Script pentru deblocare caracter(daca ramane blocat prin map 1,sau prin alta parte va fi teleportat automat)
Creati o pagina noua ex: deblocare.php si introducetio in site
if($_POST['sbug']) {
mysql_select_db($db['database']['account']) or die('Could not select database: '.mysql_error());
echo '$_POST['sbug'] trovato e connesso al database account'."
\n";
$pg = mysql_real_escape_string($_POST['pg']);
$pwd['user'] = mysql_real_escape_string($_POST['pw']);
$query['pwd'] = "SELECT password FROM account WHERE login = '$pg'";
$pwd['fromdb'] = mysql_query($query['pwd']);
// $menge = mysql_num_rows($pwd['fromdb']);
$results['pwd'] = mysql_result($pwd['fromdb'], 0);
echo '$pwd['fromdb'] : '.$pwd['fromdb']."
\n";
echo '$results['pwd']'.$results['pwd']."
\n";
if($pwd['user'] == $results['pwd']) {
echo 'Le due password coincidono';
$query['id'] = "SELECT id FROM account WHERE login = '$pg' AND password = '".$pwd['user']."'";
$id = mysql_query($query['id']);
if ($id != "") {
mysql_select_db($db['database']['player']) or die('Could not select database: '.mysql_error());
echo '$id diverso da "" e connesso al database player';
$query['sbug'] = "UPDATE `player`.`player` SET `x`=436377, `y`=215769, `map_index`=61, `exit_x`=436378, `exit_y`=215769, `exit_map_index`=61 WHERE (`name`='$pg') AND (`account_id`='$id')";
$success = mysql_query($query['sbug']);
if($success != "") {
echo "PG Sbuggato ^^ torna a giocare!!";
} else {
echo "PG non Sbuggato riprova più tardi";
}
}
}
}
?>
host:ip-ul serverului
user:root
password: parola bazei de date
Creati o pagina noua ex: deblocare.php si introducetio in site
- $pwd = Array();
$query = Array();
$db = Array();
$results = Array();
$db['host'] = "***";
$db['user'] = "***";
$db['password'] = "***";
$db['database'] = Array();
$db['database']['player'] = "player";
$db['database']['account'] = "account";
$db['conn'] = mysql_connect($db['host'], $db['user'], $db['password']) or die('Could not connect: '.mysql_error());
?>
if($_POST['sbug']) {
mysql_select_db($db['database']['account']) or die('Could not select database: '.mysql_error());
echo '$_POST['sbug'] trovato e connesso al database account'."
\n";
$pg = mysql_real_escape_string($_POST['pg']);
$pwd['user'] = mysql_real_escape_string($_POST['pw']);
$query['pwd'] = "SELECT password FROM account WHERE login = '$pg'";
$pwd['fromdb'] = mysql_query($query['pwd']);
// $menge = mysql_num_rows($pwd['fromdb']);
$results['pwd'] = mysql_result($pwd['fromdb'], 0);
echo '$pwd['fromdb'] : '.$pwd['fromdb']."
\n";
echo '$results['pwd']'.$results['pwd']."
\n";
if($pwd['user'] == $results['pwd']) {
echo 'Le due password coincidono';
$query['id'] = "SELECT id FROM account WHERE login = '$pg' AND password = '".$pwd['user']."'";
$id = mysql_query($query['id']);
if ($id != "") {
mysql_select_db($db['database']['player']) or die('Could not select database: '.mysql_error());
echo '$id diverso da "" e connesso al database player';
$query['sbug'] = "UPDATE `player`.`player` SET `x`=436377, `y`=215769, `map_index`=61, `exit_x`=436378, `exit_y`=215769, `exit_map_index`=61 WHERE (`name`='$pg') AND (`account_id`='$id')";
$success = mysql_query($query['sbug']);
if($success != "") {
echo "PG Sbuggato ^^ torna a giocare!!";
} else {
echo "PG non Sbuggato riprova più tardi";
}
}
}
}
?>
host:ip-ul serverului
user:root
password: parola bazei de date
