Solusi Buat GM untuk Register ID di web yang Error
kk GM saya lihat bnyk thread yang bilang ga bisa create id sekarang gr2 ada mysql error di column gmlevel, saya coba bantu kasih solusi.tolong kalau bisa segera dicoba patch ini.Soalnya bnyk yang png daftar tapi ga bisa lagi.Saya disini hanya sekedar membantu biar komunitas WOW AMPM bisa semakin ramai.semoga solusinya bisa bekerja dan sesuai dengan kondisi konfigurasi server WOW AMPM.Terimakasih GM
Solusi 1
Code:
Index: login.php
===================================================================
--- login.php (revision 29)
+++ login.php (working copy)
@@ -11,7 +11,7 @@
if (empty($_POST['user']) || empty($_POST['pass']))
redirect('login.php?error=2');
- $user_name = $sqlr->quote_smart($_POST['user']);
+ $user_name = strtoupper($sqlr->quote_smart($_POST['user']));
$user_pass = $sqlr->quote_smart($_POST['pass']);
if (255 < strlen($user_name) || 255 < strlen($user_pass))
Index: register.php
===================================================================
--- register.php (revision 29)
+++ register.php (working copy)
@@ -43,7 +43,7 @@
// DO REGISTER
//#####################################################################################################
function doregister(){
- global $lang_global, $characters_db, $realm_db, $realm_id, $mmfpm_db, $disable_acc_creation, $limit_acc_per_ip, $valid_ip_mask,
+ global $lang_global, $characters_db, $realm_db, $realm_id, $mmfpm_db, $disable_acc_creation, $limit_acc_per_ip, $valid_ip_mask, $expansion_select,
$send_mail_on_creation, $create_acc_locked, $from_mail, $mailer_type, $smtp_cfg, $title, $defaultoption, $server_type, $require_account_verify;
if (($_POST['security_code']) != ($_SESSION['security_code'])) {
@@ -165,8 +165,8 @@
else {
$result = $sql->query("INSERT INTO account (username,sha_pass_hash,email, joindate,last_ip,failed_logins,locked,last_login,expansion)
VALUES (UPPER('$user_name'),'$pass','$mail',now(),'$last_ip',0,$create_acc_locked,NULL,$expansion)");
- $query_result = mysql_fetch_assoc($sql->query("SELECT id FROM account WHERE username = '$user_name'"));
- $result = $sql->query("INSERT INTO account_access (`id`,`gmlevel`) VALUES ('".$query_result['id']."','0')");
+ $query_result = mysql_fetch_assoc($sql->query("SELECT id FROM account WHERE username = '".strtoupper($user_name)."'"));
+ $result = $sql->query("INSERT INTO account_access (`id`,`gmlevel`, `RealmID`) VALUES ('".$query_result['id']."','0', 1)");
}
}
else
ada tambahan lagi solusi lagi untuk dicoba
Solusi 2
saya menggunakan referensi dari sini http://code.google.com/p/minimanager...ce/detail?r=47
Code:
32 732 $new_mail = (isset($_GET['new_mail'])) ? $sqlc->quote_smart(trim($_GET['new_mail'])) : NULL;
733 733 $locked = (isset($_GET['new_locked'])) ? $sqlc->quote_smart($_GET['new_locked']) : 0;
734 734 $expansion = (isset($_GET['new_expansion'])) ? $sqlc->quote_smart($_GET['new_expansion']) : 0;
735 - $result = $sqlc->query("INSERT INTO account (username,sha_pass_hash,gmlevel,email, joindate,last_ip,failed_logins,locked,last_login,expansion)
736 - VALUES ('$new_user','$pass',0 ,'$new_mail',now() ,'$last_ip',0, $locked ,NULL, $expansion)");
735 + $result = $sqlc->query("INSERT INTO account (username,sha_pass_hash,email, joindate,last_ip,failed_logins,locked,last_login,expansion)
736 + VALUES ('$new_user','$pass','$new_mail',now() ,'$last_ip',0, $locked ,NULL, $expansion)");
737 737 if ($result)
738 738 redirect("user.php?error=5");
739 739
perhatikan perubahan di line 735 sampai 736+
Solusi 3
masukan perintah SQL ini melalui HediSQL atau Navicat terserah GM
Code:
ALTER TABLE account ADD COLUMN `gmlevel` TINYINT (3) UNSIGNED NOT NULL AFTER sha_pass_hash;
semoga salah satu solusi diatas bisa membantu GM.Terimakasih.
