Solusi Buat GM untuk Register ID di web yang Error

[it's On!]

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

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

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

ALTER TABLE account ADD COLUMN `gmlevel` TINYINT (3) UNSIGNED NOT NULL AFTER sha_pass_hash;

semoga salah satu solusi diatas bisa membantu GM.Terimakasih.

[mago_otz]

+1 BUMP !

oi GM benerin donk. gw mau maen lagi gak bisa bikin ID neh! grrrrrr.

[Lovelylips]

trima kasi info nya..
sbnr nya dr kmrn2 udah mau di ganti minimanager nya, karna udah ga support buat trinity.
tp karna Admin yg ngurus web nya lagi sibuk jadi masi tertunda sampe sekarang.
buat smntara kita uda apply perbaikan diatas, dan udah bisa create account baru melalui web.
mudah2an dalam waktu cepat, kita akan melakukan pembaharuan buat website.