}
//==============================================================================
} else {
$query = "SELECT Value as troll_step from MZ_Cron where Field='troll_step'";
$result = @MySQL_QUERY($query);
$troll_step = 1 * mysql_result($result, 0, "troll_step");
if ($troll_step == 0) {
// calculer la table diplo inversé
$query = "REPLACE INTO MZ_Trolls SELECT * from MH_Trolls";
// récupérer les datas
$result = @MySQL_QUERY($query);
$query = "UPDATE MZ_User U, MH_Trolls T SET U.GiD=T.GiD WHERE U.TiD=T.TiD";
// Mise a jour des comptes User si la guilde a changé!
$result = @MySQL_QUERY($query);
$query = "UPDATE MZ_Cron set Value='1' WHERE Field='troll_step'";
// terminer le script!
$result = @MySQL_QUERY($query);
} else {
// le travail quotidien est terminé
//-----------------------------------------------------------------------------------------------------------------
if (!$_FOPEN_EXTERNAL) {
@unlink("ftp/Public_Trolls.txt");
}
$next_fire = date("Y-m-d H:i:s", mktime(0, 0, 0, date("m"), date("d") + 1, date("Y")));
// Plus de mise à jour avant demain
$query = "UPDATE MZ_Crontab SET next_fire='{$next_fire}' WHERE id='{$_cron_id}'";
@MySQL_QUERY($query);
}
}
_sqlclose();
# -------------- Fermeture DB
$query = "SELECT TiD FROM `MZ_User` where (TiD=$TiD) and (Pwd='$ZZ_PWD')";
#echo "$query<BR>";
$result = MySQL_QUERY($query);
$nData = @MySQL_NUM_ROWS($result);
if ($nData>0) { #autologon ZZ interface
$_SESSION['login']=$TiD;
} else $TiD=0;
$query = "SELECT Troll FROM `MZ_Trolls` where (TiD=$TiD)";
#echo "$query<BR>";
$result = MySQL_QUERY($query);
$nData = @MySQL_NUM_ROWS($result);
if ($nData>0) { #autologon ZZ interface
$Troll=mysql_result($result,0,"Troll");
} else $Troll="";
_sqlclose(); # -------------- Fermeture DB
If ($TiD<=0) Die("Erreur accès à ZoryaZilla: Mauvais identifiant Troll!");
print("Le password du Troll <b>$Troll</b> (Id=#<i><b>$TiD</b></i>) a été sauvegardé dans Firefox!!");
print("<FORM name=FormDlgBox><INPUT TYPE=hidden Name=ZZSession Value=\"$ZZ_PWD\"><INPUT TYPE=hidden Name=TiD Value=\"$TiD\">");
if ($Troll!="") print("<INPUT TYPE=hidden Name=Troll Value=\"$Troll\">");
print("</FORM>");
if ($Source!="") print("Retour au jeu: <A HREF='$Source'>$Source</A>");
#========================================================================================
print("</TD></TR></TABLE>");
?>
function _sqllogTiD($TiD, $Comment) {
global $SQL_SI_TiDViewList;
$mysql=_sqlconnect(); # -------------- Ouverture DB
$TimeStamp=date("Y-m-d H:i:s");
$DateStamp=date("Y-m-d");
if (array_key_exists ("HTTP_CLIENT_IP", $_SERVER) && $_SERVER["HTTP_CLIENT_IP"]!="")
$ipaddr=mysql_real_escape_string($_SERVER["HTTP_CLIENT_IP"]); // en cas de proxy.
else if ($_SERVER["HTTP_X_FORWARDED_FOR"]!="")
$ipaddr=mysql_real_escape_string($_SERVER["HTTP_X_FORWARDED_FOR"]); // en cas de proxy.
else
$ipaddr=mysql_real_escape_string($_SERVER["REMOTE_ADDR"]);
$arr_tid=explode(",", $SQL_SI_TiDViewList);
for ($i=1; $i<sizeof($arr_tid); $i++) {
$query = "REPLACE INTO `MZ_Log` values(".$arr_tid[$i].", '$DateStamp', '$TimeStamp', $TiD, '$ipaddr', '$Comment')";
//echo "$query<br>";
$result = @MySQL_QUERY($query);
}
_sqlclose(); # -------------- Fermeture DB
}
