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

[Kleber Henrique 8]

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?

Edited August 16, 2014 by noobsmok

[Kleber Henrique 8]

 

Resolvido

descreva como

 

O host me oriento da seguinte forma:

 

onde tiver group_id e muda pra level ou vise versa.

[JulioCF 105]

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

[Kleber Henrique 8]

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 105]

veja as querys

[Kleber Henrique 8]

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="cursor:pointer" 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 8]

Resolvido

[JulioCF 105]

Resolvido

descreva como

[JulioCF 105]

._.

 

ok..