Muitos perguntam, oque é sLang é para que serve? Simples, quando voce vai colocar uma palavra inadequada, aparece somente ingles! Mais os problemas acabaram, voce pode colocar sLang para não mostrar palavrões, como: puta, fdm, fdp, cdf, noiado, vesgo. Mais nem tudo pode ser não mostrado.
Então vou passar o código SQL para vocês.
-- -- Table structure for table `etl_servers` -- DROP TABLE IF EXISTS etl_servers; CREATE TABLE IF NOT EXISTS `etl_servers` ( `id` mediumint(6) NOT NULL AUTO_INCREMENT, `bOnline` tinyint(1) NOT NULL DEFAULT '0', `bUpg` tinyint(1) NOT NULL DEFAULT '0', `sName` varchar(60) NOT NULL DEFAULT 'Server', `sIP` varchar(40) NOT NULL DEFAULT '0.0.0.0', `iChat` tinyint(1) NOT NULL DEFAULT '2', `iCount` mediumint(4) NOT NULL DEFAULT '0', `iMax` mediumint(4) NOT NULL DEFAULT '500', `sLang` varchar(2) NOT NULL DEFAULT 'pt', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;Adicione o Código em locahost/phpmyadmin, após adicionar, vai até Xampp > Htdocs > Game e vá até Cf-userlogin e coloque este código:
<?php
error_reporting(0);
$msg['prot'] = '<login><bSuccess>0</bSuccess><sMsg><![CDATA[Your account has been disabled because of a violation of the Terms and Condition. If you believe this is an error, please contact Staff as soon as possible.</a></u>]]></sMsg></login>'; $msg['bann'] = '<login><bSuccess>0</bSuccess><sMsg><![CDATA[Your account has been disabled because of a violation of the Terms and Condition. If you believe this is an error, please contact Staff as soon as possible.</a></u>]]></sMsg></login>'; $msg['erro'] = '<login><bSuccess>0</bSuccess><sMsg><![CDATA[Please try again later. If you are seeing this messaage it means theres an problem that need to be fixed. Be patient]]></sMsg></login>';
/** Content Type is XML **/ header("Content-Type: text/xml");
$sql['host'] = 'localhost';
$sql['user'] = 'root';
$sql['pass'] = '';
$sql['name'] = 'SUA DATABASE AQUI';
$con = mysqli_connect($sql['host'], $sql['user'], $sql['pass'], $sql['name']) or die($msg['erro']);
if(isset($_POST['strUsername'])) {
$username = $con->real_escape_string(stripslashes($_POST['strUsername']));
$password = md5($_POST['strPassword']);
$ip = $_SERVER['REMOTE_ADDR'];
$user_quer = $con->query('SELECT id,dUpgExp,iSendEmail,iAge,iUpg,iAccess,strEmail,iUpgDays FROM etl_users WHERE strUsername="'.$username.'" AND strPassword="'.$password.'" LIMIT 1');
$user_info = $user_quer->fetch_assoc();
$user_id = $user_info['id'];
if ($user_quer->num_rows === 0) {
print '<login bSuccess="0" sMsg="If you are seeing this, most likely you typed in your username or password wrong. If you see this screen after receiving a name change, most likely one of the Staff misspelled your new username. Please contact Staff as soon as possible."/>';
} else {
$chck_bann = $con->query('SELECT id,protection FROM etl_users_banned WHERE user_id='.$user_id.' AND active=1');
if ($chck_bann->num_rows > 0) {
$user_prot = $chck_bann->fetch_assoc();
if($user_prot['protection'] === 1) {
print $msg['prot'];
} else {
print $msg['bann'];
}
} else {
$con->query('UPDATE etl_users SET login_ip='.$ip.' WHERE id='.$user_id);
$upg_date = preg_replace('/\s+/', 'T', $user_info['dUpgExp']);
/** Login Data **/
print '<login bSuccess="1" userid="'.$user_id.'" iAccess="'.$user_info['iAccess'].'" iUpg="'.$user_info['iUpg'].'" iAge="'.$user_info['iAge'].'" sToken="'.$password.'" dUpgExp="'.$upg_date.'" iUpgDays="'.$user_info['iUpgDays'].'" iSendEmail="'.$user_info['iSendEmail'].'" strEmail="'.$user_info['strEmail'].'" bCCOnly="0">';
/** List Servers **/
$server_info_list = $con->query("SELECT * FROM etl_servers LIMIT 10");
while ($server_info = $server_info_list->fetch_assoc()) {
print '<servers sName="'. $server_info['sName'] .'" sIP="'. $server_info['sIP'] .'" iCount="'. $server_info['iCount'] .'" iMax="'. $server_info['iMax'] .'" bOnline="'. $server_info['bOnline'] .'" iChat="'. $server_info['iChat'] .'" bUpg="'. $server_info['bUpg'] .'" sLang="'. $server_info['sLang'] .'" />';
}
print '</login>';
}
}
} else {
print '<login bSuccess="0" sMsg="Invalid Input"/>';
} #0.0274
#0.0273
#0.0272 ?>
O código SQL é esse! E após colocar, deverá ficar assim:
Só isso! Até mais!
0 comentários:
Postar um comentário