Jump to content
  • 0
Sign in to follow this  
Kleber Henrique

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

Question

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 by noobsmok

Share this post


Link to post
Share on other sites

7 answers to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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..

Share this post


Link to post
Share on other sites
  • 0

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`");?>

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.