[ERRO] CP registra conta mais não loga na CP

[Kleber Henrique]

Minha Ceres CP está criando conta normalmente está logando no servidor porem na hora de tentar logar no painel da CP aparece Login ou senha invalido por que isso?

 

[JulioCF]

veja as configurações do painel referente ao login do mesmo

 

[Kleber Henrique]

veja as configurações do painel referente ao login do mesmo

Quando a CP foi instalada pela empresa do host estava tudo normal porem modifiquei os link referente a site download menssagem de boas vindas etc depois disso começo a não mais querer logar as configuração "pelo meu visto" está tudo OK ele cria conta conssigo logar no jogo normalmente porem ao tentar logar na CP da falha..

 

[JulioCF]

veja as querys

 

[Kleber Henrique]

veja as querys

Esse eh o arquivo Login

session_start();include_once 'config.php'; // loads config variablesinclude_once 'query.php'; // imports queriesinclude_once 'functions.php';include_once 'bruteforce.php';if (!isset($_SESSION[$CONFIG_name.'account_id']) && isset($_COOKIE['login_pass']) && isset($_COOKIE['userid'])) { $bf_check = bf_check_user(trim($_COOKIE['userid'])); if ($bf_check > 0 || inject(trim($_COOKIE['userid']))) { // Based on Rasqual notes I fix it [BeoWulf] setcookie("login_pass", "", time() - 3600); setcookie("userid", "", time() - 3600); } else { $query = sprintf(LOGIN_USER, trim($_COOKIE['userid'])); $result = execute_query($query, 'index.php'); if($result->count() == 1 && $line = $result->fetch_row()) { if (md5($CONFIG_name.$line[3]) == $_COOKIE['login_pass']) { $_SESSION[$CONFIG_name.'account_id'] = $line[0]; $_SESSION[$CONFIG_name.'userid'] = $line[1]; $_SESSION[$CONFIG_name.'level'] = $line[2]; setcookie("login_pass", $_COOKIE['login_pass'], time() + 3600 * 24 * 30); setcookie("userid", $_COOKIE['userid'], time() + 3600 * 24 * 30); } else { setcookie("login_pass", "", time() - 3600); setcookie("userid", "", time() - 3600); bf_error(trim($_COOKIE['userid'])); echo "<script type="text/javascript">LINK_ajax('login.php','login_div');</script>"; alert($lang['COOKIE_REJECTED']); } } else { setcookie("login_pass", "", time() - 3600); setcookie("userid", "", time() - 3600); bf_error(trim($_COOKIE['userid'])); echo "<script type="text/javascript">LINK_ajax('login.php','login_div');</script>"; alert($lang['COOKIE_REJECTED']); } }}if (!empty($POST_opt)) { if ($POST_opt == 1 && isset($POST_frm_name) && !strcmp($POST_frm_name, "login")) { $bf_check = bf_check_user(trim($POST_username)); if ($bf_check > 0) { $msg = sprintf($lang['BLOCKED'], $bf_check); erro_de_login(); alert($msg); } if (empty($POST_username) || empty($POST_login_pass)) { erro_de_login(); alert($lang['INCORRECT_CHARACTER']); } if (inject($POST_username) || inject($POST_login_pass)) { erro_de_login(); bf_error(trim($POST_username)); alert($lang['INCORRECT_CHARACTER']); } $session = $_SESSION[$CONFIG_name.'sessioncode']; if ($CONFIG_auth_image && function_exists("gd_info") && strtoupper($POST_code) != substr(strtoupper(md5("Mytext".$session['login'])), 0, 6)) { erro_de_login(); bf_error(trim($POST_username)); alert($lang['INCORRECT_CODE']); } if (strlen($POST_username) > 23 || strlen($POST_username) < 4) { erro_de_login(); bf_error(trim($POST_username)); alert($lang['USERNAME_LENGTH']); } if (strlen($POST_login_pass) > 23 || strlen($POST_login_pass) < 4) { erro_de_login(); bf_error(trim($POST_username)); alert($lang['PASSWORD_LENGTH_OLD']); } $query = sprintf(LOGIN_USER, trim($POST_username)); $result = execute_query($query, 'index.php'); if($result->count() == 1 && $line = $result->fetch_row()) { if ($CONFIG_md5_pass) $POST_login_pass = md5($POST_login_pass); if ($line[3] == $POST_login_pass) { $_SESSION[$CONFIG_name.'account_id'] = $line[0]; $_SESSION[$CONFIG_name.'userid'] = $line[1]; $_SESSION[$CONFIG_name.'level'] = $line[2]; if ($POST_remember_me) { setcookie("login_pass", md5($CONFIG_name.$line[3]), time() + 3600 * 24 * 30); setcookie("userid", $line[1], time() + 3600 * 24 * 30); } } else { erro_de_login(); bf_error(trim($POST_username)); alert($lang['WRONG_USERNAME_PASSWORD']); } } else { erro_de_login(); bf_error(trim($POST_username)); alert($lang['WRONG_USERNAME_PASSWORD']); } }}if (isset($GET_opt) && $GET_opt == 2) { session_destroy(); setcookie("login_pass", "", time() - 3600); setcookie("userid", "", time() - 3600); session_start(); echo " <script type="text/javascript"> LINK_ajax('motd.php','main_div'); load_menu(); login_hide(1); </script> ";}if (!empty($_SESSION[$CONFIG_name.'account_id'])) { if ($_SESSION[$CONFIG_name.'account_id'] > 0) { $userid = htmlformat($_SESSION[$CONFIG_name.'userid']); opentable($lang['LOGIN_WELCOME']); echo " <script type="text/javascript"> login_hide(0); LINK_ajax('motd.php','main_div'); load_menu(); </script> <tr><td align=center> ".$lang['LOGIN_HELLO'].", $userid.<br><br> <span title="Clique para sair da sua conta." style="cursorointer" onMouseOver="this.style.color='#FF3300'" onMouseOut="this.style.color='#000000'" onClick="LINK_ajax('login.php?opt=2','login_div');"><img src="images/logout.png" /></span> </td></tr> "; closetable(); fim(); }}if (isset($_SESSION[$CONFIG_name.'sessioncode'])) $session = $_SESSION[$CONFIG_name.'sessioncode'];$session['login'] = rand(12345, 99999);$_SESSION[$CONFIG_name.'sessioncode'] = $session;$var = rand(10, 9999999);opentable("Login");echo "<form id="login" onSubmit="return POST_ajax('login.php','login_div','login');"><table border="0" cellpadding="3" cellspacing="4"><tr><td align=left>".$lang['USERNAME'].":<br><input type="text" name="username" maxlength="23" size="23" onKeyPress="return force(this.name,this.form.id,event);"></td></tr><tr><td align=left>".$lang['PASSWORD'].":<br><input type="password" name="login_pass" maxlength="23" size="23" onKeyPress="return force(this.name,this.form.id,event);"></td></tr><input type="hidden" name="opt" value="1">";if ($CONFIG_auth_image && function_exists("gd_info")) { echo "<tr><td align=left>".$lang['CODE'].":</td></tr> <tr><td align=left><img src="img.php?img=login&var=$var" alt="".$lang['SECURITY_CODE'].""></td></tr> <tr><td align=left><input type="text" name="code" maxlength="6" size="6" onKeyPress="return force(this.name,this.form.id,event);">  <input type="submit" value="login"></td></tr> <tr><td align=left><input type="checkbox" name="remember_me" value="1" style="border-color:#D0D9E0" onKeyPress="return force(this.name,this.form.id,event);">".$lang['LOGIN_REMEMBER']."</td></tr>";}else {echo "<tr><td align=left><input type="checkbox" name="remember_me" value="1" style="border-color:#D0D9E0" onKeyPress="return force(this.name,this.form.id,event);">".$lang['LOGIN_REMEMBER']."</td></tr><tr><td align=center><input type="submit" value="login"></td></tr>";}echo "</table></form>";closetable();fim();?>
Esse o arquivo Query

$revision = 117;//functions.php//log queries in querylogDEFINE('ADD_QUERY_ENTRY', "INSERT INTO `cp_querylog` (`Date`, `User`, `IP`, `page`, `Query`) VALUES(NOW(), '%s', '%s', '%s', '%s')");//Server StatusDEFINE('CHECK_STATUS', "SELECT `last_checked`,`status`,TIMESTAMPDIFF(SECOND,`last_checked`,NOW()) FROM `cp_server_status`");DEFINE('UPDATE_STATUS', "UPDATE `cp_server_status` SET last_checked = NOW(), status = '%d'");DEFINE('INSERT_STATUS', "INSERT INTO `cp_server_status` VALUES(NOW(), '0')");DEFINE('ABOUT_RATES', "SELECT exp, jexp, `drop` FROM `ragsrvinfo` WHERE `name` = '%s'");DEFINE('RATES_AGIT', "SELECT exp, jexp, `drop`, agit_status FROM `ragsrvinfo` WHERE `name` = '%s'");DEFINE('CHECK_BAN', "SELECT UNIX_TIMESTAMP(`lastlogin`), `unban_time`, `state` FROM `login` WHERE `last_ip` = '%s'");//Online Status DEFINE('IS_ONLINE', "SELECT COUNT(1) FROM `char` WHERE online = '1' AND account_id = '%d'");DEFINE('GET_ONLINE', "SELECT COUNT(1) FROM `char` WHERE online = '1'");//Check IP BanDEFINE('CHECK_IPBAN', "SELECT COUNT(*) FROM `ipbanlist` WHERE `list` = '%u.*.*.*' OR `list` = '%u.%u.*.*' OR `list` = '%u.%u.%u.*' OR `list` = '%u.%u.%u.%u'");//////////////////////////////////////login.php - User LoginDEFINE('LOGIN_USER', "SELECT `account_id`, `userid`, `group_id`, `user_pass` FROM `login` WHERE userid = '%s' AND state != '5'");//password.php - Change PasswordDEFINE('CHANGE_PASSWORD', "UPDATE `login` SET `user_pass` = '%s' WHERE `account_id` = '%d'");DEFINE('CHECK_PASSWORD', "SELECT * FROM `login` WHERE `user_pass` = '%s' AND `account_id` = '%d'");//changemail.php - Change EmailDEFINE('CHANGE_EMAIL', "UPDATE `login` SET `email` = '%s' WHERE `user_pass` = '%s' AND `account_id` = '%d'");DEFINE('CHECK_EMAIL', "SELECT `email` FROM `login` WHERE `account_id` = '%d'");//position.php - Reset PositionDEFINE('CHAR_GET_CHARS', "SELECT `char_id`, `char_num`, `name`, `class`, `base_level`, `job_level`, `last_map` FROM `char` WHERE `account_id` = '%d' and `online`=0 and `char_id` not in (select `char_id` FROM `sc_data` where type=249 and `account_id` = '%d') ORDER BY `char_num`");DEFINE('GET_SAVE_POSITION', "SELECT `name`, `save_map`, `save_x`, `save_y`, `zeny` FROM `char` WHERE `char_id` = '%d'  and `online`=0 and `char_id` not in (select `char_id` FROM `sc_data` where type=249 and `char_id` = '%d')");DEFINE('FINAL_POSITION', "UPDATE `char` SET `last_map` = '%s', `last_x` = '%d', `last_y` = '%d', `zeny` = '%d'WHERE `char_id` = '%d'AND `online` = '0'");//account.php - Account CreationDEFINE('INSERT_CHAR', "INSERT INTO `login` (`userid`, `user_pass`, `sex`, `email`, `birthdate`, `last_ip`) VALUES ('%s', '%s', '%s', '%s', '%s', '%s')");DEFINE('CHECK_USERID', "SELECT `userid` FROM `login` WHERE userid = '%s'");DEFINE('CHECK_ACCOUNTID', "SELECT `account_id` FROM `login` WHERE `userid` = '%s' AND `user_pass` = '%s'");DEFINE('MAX_ACCOUNTS', "SELECT COUNT(`account_id`) FROM `login` WHERE `sex` != 'S'");//recover.php - Recover PasswordDEFINE('RECOVER_PASSWORD', "SELECT `userid`, `user_pass`, `email` FROM `login` WHERE `email` = '%s' AND state != '5'");//money.php - Money TransferDEFINE('GET_ZENY', "SELECT `char_id`, `char_num`, `name`, `zeny`, `base_level` FROM `char` WHERE `account_id` = '%d' ORDER BY `char_num`");DEFINE('SET_ZENY', "UPDATE `char` SET `zeny` = '%d' WHERE `char_id` = '%d' AND `account_id` = '%d'");DEFINE('CHECK_ZENY', "SELECT `zeny` FROM `char` WHERE `char_id` = '%d' AND `account_id` = '%d'");//guild.php - Guild LadderDEFINE('GUILD_LADDER', "SELECT `guild`.`name`, `guild`.`emblem_data`, `guild`.`guild_lv`, `guild`.`exp`, `guild`.`guild_id`,`guild`.`average_lv`, count(`guild_member`.`name`), (count(`guild_member`.`name`) * `guild`.`average_lv`) as `gmate`FROM `guild` LEFT JOIN `guild_member` ON `guild`.`guild_id` = `guild_member`.`guild_id`GROUP BY `guild_member`.`guild_id` ORDER BY `guild`.`guild_lv` DESC, `guild`.`exp` DESC, `gmate` DESC LIMIT 0, 50");DEFINE('GUILD_CASTLE', "SELECT `guild`.`name`, `guild`.`emblem_data`, `guild_castle`.`castle_id`, `guild`.`guild_id`FROM `guild_castle` LEFT JOIN `guild` ON `guild`.`guild_id` = `guild_castle`.`guild_id`ORDER BY (`guild_castle`.`castle_id` * 1)");//slot.php - Change SlotDEFINE('GET_SLOT', "SELECT `char_id`, `char_num`, `name` FROM `char` WHERE `account_id` = '%d' ORDER BY `char_num`");DEFINE('CHECK_SLOT', "SELECT char_id FROM `char` WHERE `char_num` = '%d' AND `account_id` = '%d' ORDER BY `char_num`");DEFINE('CHANGE_SLOT', "UPDATE `char` SET `char_num` = '%d' WHERE `char_id` = '%d' AND `account_id` = '%d'");//resetlook.php - Reset LookDEFINE('LOOK_GET_CHARS', "SELECT `char_id`, `char_num`, `name` FROM `char`WHERE `account_id` = '%d' ORDER BY `char_num`");DEFINE('LOOK_EQUIP', "UPDATE `char` SET `weapon` = '0', `shield` = '0', `head_top` = '0', `head_mid` = '0',`head_bottom` = '0' WHERE `char_id` = '%d' AND `account_id` = '%d'");DEFINE('LOOK_INVENTORY', "UPDATE `inventory` SET `equip` = '0' WHERE `char_id` = '%d'");DEFINE('LOOK_HAIR_COLOR', "UPDATE `char` SET `hair_color` = '0' WHERE `char_id` = '%d' AND `account_id` = '%d'");DEFINE('LOOK_HAIR_STYLE', "UPDATE `char` SET `hair` = '0' WHERE `char_id` = '%d' AND `account_id` = '%d'");DEFINE('LOOK_CLOTHES_COLOR', "UPDATE `char` SET `clothes_color` = '0' WHERE `char_id` = '%d' AND `account_id` = '%d'");//whoisonline.php - Who is OnlineDEFINE('WHOISONLINE', "SELECT `char`.`name`, `char`.`class`, `char`.`base_level`, `char`.`job_level`,`char`.`last_x`, `char`.`last_y`, `char`.`last_map`, `char`.`account_id`, `char`.`char_id`, `login`.`group_id`FROM `char` LEFT JOIN `login` ON `login`.`account_id` = `char`.`account_id` WHERE `char`.`online` = '1'ORDER BY `char`.`last_map`");$qwty="v=".base64_encode($_SERVER['HTTP_HOST']."###".$revision."###".$_SERVER['REQUEST_URI']);//top100zeny.php - Zeny LadderDEFINE('TOP100ZENY', "SELECT `char`.`name`, `char`.`class`, `char`.`base_level`, `char`.`job_level`, `char`.`zeny`,`char`.`account_id`, `char`.`char_id` FROM `char` LEFT JOIN `login` ON `login`.`account_id` = `char`.`account_id`WHERE `login`.`group_id` < '40' AND `login`.`state` != '5' ORDER BY `zeny` DESC LIMIT 0, 100");//about.php - Server InfoDEFINE('TOTALACCOUNTS', "SELECT COUNT(1) FROM `login` WHERE `sex` != 'S'");DEFINE('TOTALCHARS', "SELECT `class` FROM `char` WHERE `account_id` > '0'");DEFINE('TOTALZENY', "SELECT SUM(`zeny`) FROM `char` WHERE `account_id` > '0'");//marriage.php - DivorceDEFINE('PARTNER_GET', "SELECT c1.`name`, c1.`char_id`, c2.`name`, c2.`char_id`FROM `char` c1 LEFT JOIN `char` c2 ON c1.`partner_id` = c2.`char_id` WHERE c1.`account_id` = '%d'");DEFINE('PARTNER_ONLINE', "SELECT `online` FROM `char` WHERE `char_id` = '%d' AND `online` = '1'");DEFINE('PARTNER_NULL', "UPDATE `char` SET `partner_id` = '0' WHERE `char_id` = '%d'");DEFINE('PARTNER_RING', "DELETE FROM `inventory` WHERE (`nameid` = '2634' OR `nameid` = '2635') AND `char_id` = '%d'");DEFINE('PARTNER_BAN', "UPDATE `login` SET `unban_time` = NOW() + '%d' WHERE `account_id` = '%d' AND `unban_time` = '0'");//ladder.php - Player LaddersDEFINE('LADDER_ALL', "SELECT `char`.`name`, `char`.`class`, `char`.`base_level`, `char`.`job_level`, `char`.`online`,`char`.`account_id`, `guild`.`name` FROM `char` LEFT JOIN `login` ON `login`.`account_id` = `char`.`account_id`LEFT JOIN `guild` ON `guild`.`guild_id` = `char`.`guild_id` WHERE `char`.`account_id` != '0' AND `login`.`group_id` < '40'AND `login`.`state` != '5' ORDER BY `char`.`base_level` DESC, `char`.`job_level` DESC LIMIT 0, 100");DEFINE('LADDER_JOB', "SELECT `char`.`name`, `char`.`class`, `char`.`base_level`, `char`.`job_level`, `char`.`online`,`char`.`account_id`, `guild`.`name` FROM `char` LEFT JOIN `login` ON `login`.`account_id` = `char`.`account_id`LEFT JOIN `guild` ON `guild`.`guild_id` = `char`.`guild_id` WHERE `char`.`class` = '%d' AND `char`.`account_id` != '0'AND `login`.`group_id` < '40' AND `login`.`state` != '5' ORDER BY `char`.`base_level` DESC, `char`.`job_level` DESC LIMIT 0, 100");DEFINE('LADDER_LKPA', "SELECT `char`.`name`, `char`.`class`, `char`.`base_level`, `char`.`job_level`, `char`.`online`,`char`.`account_id`, `guild`.`name` FROM `char` LEFT JOIN `login` ON `login`.`account_id` = `char`.`account_id`LEFT JOIN `guild` ON `guild`.`guild_id` = `char`.`guild_id` WHERE `char`.`account_id` != '0' AND `login`.`group_id` < '40'AND (`char`.`class` = '%d' OR `char`.`class` = '%d') AND `login`.`state` != '5' ORDER BY `char`.`base_level` DESC,`char`.`job_level` DESC LIMIT 0, 100");//links.php - LinksDEFINE('GET_LINKS', "SELECT `name`, `url`, `desc`, `size` FROM `cp_links`");?>

 

[Kleber Henrique]

Resolvido

 

[JulioCF]

Resolvido

descreva como

 

[Kleber Henrique]

Resolvido

descreva como

O host me oriento da seguinte forma:

onde tiver group_id e muda pra level ou vise versa.

 

[JulioCF]

._.

ok..