}
#========================================================================================
_print("<TABLE width=600><TR><TD>");
$mysql=_sqlconnect(); # -------------- Ouverture DB
$query1 = "SELECT SHRiD FROM `MZ_Share` WHERE TiD=$ZZ_TID and link='I'"; // Mes demande de partage pas encore acceptées
#echo "$query1<BR>";
$result1 = @MySQL_QUERY($query1);
$query2 = "SELECT TiD FROM `MZ_Share` WHERE SHRiD=$ZZ_TID and link='I'"; // Les demandes partage que je n'ai pas encore acceptées
#echo "$query2<BR>";
$result2 = @MySQL_QUERY($query2);
$query3 = "SELECT count(TiD) as count FROM `MZ_Share` WHERE TiD!=$ZZ_TID and SHRiD=$ZZ_TID and link='S'";
#echo "$query3<BR>";
$result3 = @MySQL_QUERY($query3);
_sqlclose(); # -------------- Fermeture DB
$nData = @MySQL_NUM_ROWS($result1);
if ($nData>0) { #========================================= On demande validation de partage
$waitValid="";
$sendMP="http://games.mountyhall.com/mountyhall/Messagerie/MH_Messagerie.php?cat=3&title=Pourrais-tu%20valider%20ma%20demande%20de%20partage%20ZZ?&dest=";
for ($i=0; $i<$nData; $i++) {
$aTiD=mysql_result($result1,$i,"SHRiD");
$sendMP.="+$aTiD,";
$waitValid.="#<FONT COLOR=BLUE><B>$aTiD</B></FONT> ";
}
_print("<IMG SRC=MH/Images/Bullet-yeux.gif WIDTH=61 HEIGHT=31 BORDER=0 ALIGN=TOP><FONT COLOR=RED><U><B>ATTENTION</B></U>: Vous attendez des validations de partages.");
_print("<br>Vous attendez la validation de: $waitValid [<A HREF=$sendMP>envoyer un MP</A>]<BR><BR>");
}
}
$mysql=_sqlconnect(); # -------------- Ouverture DB
if ((strlen($ZZ_PWD)<30) && (strlen($ZZ_PWD)>0)) $ZZ_PWD=md5("$ZZ_PWD");
$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>");
if ($user != $loser) {
send_pm(0, $loser, sqlesc('Your Highscore Is Broken!'), sqlesc("Your highscore for Auto Bahn is broken\n\n Time to visit the arcade and get it back ;)\n\n [color=red]This is a automatic system message , so DO NOT reply ![/color]"));
}
do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `trophy`='0' WHERE `id`=" . $loser . "", true);
do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `trophy`='1' WHERE `id`=" . $user . "", true);
$al = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM {$TABLE_PREFIX}chat ORDER BY id DESC LIMIT 1");
$rw = mysqli_fetch_assoc($al);
$ct = $rw["count"] + 1;
do_sqlquery("INSERT INTO {$TABLE_PREFIX}chat (uid, time, name, text,count) VALUES (0," . time() . ", 'System','[color=red]NEW HIGHSCORE FOR[/color]: [img]{$BASEURL}/flash/autobahn1.gif[/img] Score: " . $score . " By " . $arcadeuser . " Award: " . $arte . "'," . $ct . ")");
}
}
if ($_POST['gname'] == "chainreactionGS") {
$game = 20;
$level = 1;
$score = $_POST['gscore'];
$ardresult = MySQL_QUERY("SELECT * FROM {$TABLE_PREFIX}flashscores WHERE game ='20' ORDER BY score DESC LIMIT 1");
$arcad = mysqli_fetch_array($ardresult);
$loser = $arcad["user"];
if ($score > $arcad["score"]) {
if ($btit_settings["arc_aw"] == true) {
do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `uploaded`=uploaded+'" . $upbon . "' WHERE `id`=" . $user . "", true);
} else {
do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `seedbonus`=seedbonus+'" . $seedbon . "' WHERE `id`=" . $user . "", true);
}
send_pm(0, $user, sqlesc('You Beat The Highscore!'), sqlesc("You did beat the highscore for Chain Reaction\n\n Congratulations , you did recieve a " . $arte . " bonus !!\n\n [color=red]This is a automatic system message , so DO NOT reply ![/color]"));
if ($user != $loser) {
send_pm(0, $loser, sqlesc('Your Highscore Is Broken!'), sqlesc("Your highscore for Chain Reaction is broken\n\n Time to visit the arcade and get it back ;)\n\n [color=red]This is a automatic system message , so DO NOT reply ![/color]"));
}
do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `trophy`='0' WHERE `id`=" . $loser . "", true);
do_sqlquery("UPDATE `{$TABLE_PREFIX}users` SET `trophy`='1' WHERE `id`=" . $user . "", true);
$al = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM {$TABLE_PREFIX}chat ORDER BY id DESC LIMIT 1");
}
//==============================================================================
} 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
$result1 = @MySQL_QUERY($query);
$query = "SELECT count(TimeStamp) as count FROM `MZ_CdM` WHERE (TimeStamp>'$OutOfDate') and (TiD=$TiD)";
$result2 = @MySQL_QUERY($query);
$query = "SELECT count(TimeStamp) as count FROM `MZ_Insulte` WHERE (TimeStamp>'$OutOfDate') and (TiD=$TiD)";
$result3 = @MySQL_QUERY($query);
$query = "SELECT count(TimeStamp) as count FROM `MZ_Piege` WHERE (TimeStamp>'$OutOfDate') and (TiD=$TiD)";
$result4 = @MySQL_QUERY($query);
$query = "SELECT count(TimeStamp) as count FROM `MZ_Attaque` WHERE (TimeStamp>'$OutOfDate') and (TiD=$TiD)";
$result5 = @MySQL_QUERY($query);
$query = "SELECT sum(PA) as count FROM `MZ_Glandouille` WHERE (TimeStamp>'$OutOfDate') and (TiD=$TiD)";
$result6 = @MySQL_QUERY($query);
_sqlclose(); # -------------- Fermeture DB
$nData = @MySQL_NUM_ROWS($result1);
if ($nData>0) {
$fame=mysql_result($result1,0,"Troll");
_print("<BR><U><I><B>A propos de</B></I></U>: <B>$fame</B><I> (des 30 derniers jours jusqu'aujourd'hui)<TABLE>");
#=======================================================
#$query = "SELECT count(TimeStamp) as count FROM `MZ_CdM` WHERE (TimeStamp>'$OutOfDate') and (TiD=$TiD)";
$nData = @MySQL_NUM_ROWS($result2);
if ($nData>0) {
$count=mysql_result($result2,0,"count");
_print("<TR><TD></TD><TD>Nombre de CdM: </TD><TD><B>$count</B></TD></TR>");
}
function MAJBestiaire2($cdmFamille,$cdmNom,$cdmAge,$cdmNivMin,$cdmNivMax,$cdmPdVMin,$cdmPdVMax,$cdmBlessure,$cdmAttMin,$cdmAttMax,$cdmEsqMin,$cdmEsqMax,$cdmDegMin,$cdmDegMax,$cdmRegMin,$cdmRegMax,$cdmArmMin,$cdmArmMax,$cdmArmMagMin, $cdmArmMagMax, $cdmVueMin,$cdmVueMax,$cdmPouvoir,$cdmMMMin,$cdmMMMax,$cdmRMMin,$cdmRMMax,$cdmNbAtt,$cdmVitesse,$cdmVlC,$cdmAttDist, $cdmAttMag, $cdmVole, $cdmSangFroid, $cdmDLA,$cdmDLAMin,$cdmDLAMax,$cdmChargement,$cdmBonusMalus,$cdmCapaRange)
{
global $__MAX;
# BORNE SUP DU BESTIARE ------------------------------------------------------
if ($cdmNivMax==0) $cdmNivMax=$__MAX;
if ($cdmPdVMax==0) $cdmPdVMax=$__MAX;
if ($cdmAttMax==0) $cdmAttMax=$__MAX;
if ($cdmEsqMax==0) $cdmEsqMax=$__MAX;
if ($cdmDegMax==0) $cdmDegMax=$__MAX;
if ($cdmRegMax==0) $cdmRegMax=$__MAX;
if ($cdmArmMax==0) $cdmArmMax=$__MAX;
if ($cdmArmMagMax==0) $cdmArmMagMax=$__MAX;
if ($cdmVueMax==0) $cdmVueMax=$__MAX;
if ($cdmMMMax==0) $cdmMMMax=$__MAX;
if ($cdmRMMax==0) $cdmRMMax=$__MAX;
if ($cdmDLAMax==0) $cdmDLAMax=$__MAX;
# Mise à jour du BESTIAIRE ------------------------------------------------------
$query = "SELECT * FROM `MZ_Beast2` where (Nom=\"$cdmNom\") and (Age=\"$cdmAge\")";
//echo "$query<BR>";
$result = MySQL_QUERY($query);
$nData = @MySQL_NUM_ROWS($result);
if ($nData==0) {
$query = "INSERT INTO `MZ_Beast2` VALUES ('$cdmFamille','$cdmNom','$cdmAge',$cdmNivMin,$cdmNivMin,$cdmNivMax,$cdmNivMax,$cdmPdVMin,$cdmPdVMin,$cdmPdVMax,$cdmPdVMax,$cdmAttMin,$cdmAttMin,$cdmAttMax,$cdmAttMax,$cdmEsqMin,$cdmEsqMin,$cdmEsqMax,$cdmEsqMax,$cdmDegMin,$cdmDegMin,$cdmDegMax,$cdmDegMax,$cdmRegMin,$cdmRegMin,$cdmRegMax,$cdmRegMax,$cdmArmMin,$cdmArmMin,$cdmArmMax,$cdmArmMax,$cdmArmMagMin,$cdmArmMagMin,$cdmArmMagMax,$cdmArmMagMax,$cdmVueMin,$cdmVueMin,$cdmVueMax,$cdmVueMax,'$cdmPouvoir',$cdmMMMin,$cdmMMMin,$cdmMMMax,$cdmMMMax,$cdmRMMin,$cdmRMMin,$cdmRMMax,$cdmRMMax,\"$cdmnbATT\",\"$cdmVitesse\",\"$cdmVlC\",\"$cdmAttDist\",\"$cdmAttMag\",\"$cdmVole\",\"$cdmSangFroid\",\"$cdmDLA\",$cdmDLAMin,$cdmDLAMin,$cdmDLAMax,$cdmDLAMax,\"$cdmChargement\",\"$cdmBonusMalus\",\"$cdmCapaRange\" )";
//echo "$query<BR>";
$result = MySQL_QUERY($query);
return;
}
$query = "";
$NivMinInf=mysql_result($result,0,"NivMinInf");
$NivMinSup=mysql_result($result,0,"NivMinSup");
$NivMaxInf=mysql_result($result,0,"NivMaxInf");
$NivMaxSup=mysql_result($result,0,"NivMaxSup");
$query .= CheckLimite('Niv', $cdmNivMin, $cdmNivMax, $NivMinInf, $NivMinSup, $NivMaxInf, $NivMaxSup );
$PdVMinInf=mysql_result($result,0,"PdVMinInf");
$PdVMinSup=mysql_result($result,0,"PdVMinSup");
$PdVMaxInf=mysql_result($result,0,"PdVMaxInf");
$PdVMaxSup=mysql_result($result,0,"PdVMaxSup");
$query .= CheckLimite('PdV', $cdmPdVMin, $cdmPdVMax, $PdVMinInf, $PdVMinSup, $PdVMaxInf, $PdVMaxSup );
$AttMinInf=mysql_result($result,0,"AttMinInf");
$AttMinSup=mysql_result($result,0,"AttMinSup");
$AttMaxInf=mysql_result($result,0,"AttMaxInf");
$AttMaxSup=mysql_result($result,0,"AttMaxSup");
$query .= CheckLimite('Att', $cdmAttMin, $cdmAttMax, $AttMinInf, $AttMinSup, $AttMaxInf, $AttMaxSup );
$EsqMinInf=mysql_result($result,0,"EsqMinInf");
$EsqMinSup=mysql_result($result,0,"EsqMinSup");
$EsqMaxInf=mysql_result($result,0,"EsqMaxInf");
$EsqMaxSup=mysql_result($result,0,"EsqMaxSup");
$query .= CheckLimite('Esq', $cdmEsqMin, $cdmEsqMax, $EsqMinInf, $EsqMinSup, $EsqMaxInf, $EsqMaxSup );
$DegMinInf=mysql_result($result,0,"DegMinInf");
$DegMinSup=mysql_result($result,0,"DegMinSup");
$DegMaxInf=mysql_result($result,0,"DegMaxInf");
$DegMaxSup=mysql_result($result,0,"DegMaxSup");
$query .= CheckLimite('Deg', $cdmDegMin, $cdmDegMax, $DegMinInf, $DegMinSup, $DegMaxInf, $DegMaxSup );
$RegMinInf=mysql_result($result,0,"RegMinInf");
$RegMinSup=mysql_result($result,0,"RegMinSup");
$RegMaxInf=mysql_result($result,0,"RegMaxInf");
$RegMaxSup=mysql_result($result,0,"RegMaxSup");
$query .= CheckLimite('Reg', $cdmRegMin, $cdmRegMax, $RegMinInf, $RegMinSup, $RegMaxInf, $RegMaxSup );
$ArmMinInf=mysql_result($result,0,"ArmMinInf");
$ArmMinSup=mysql_result($result,0,"ArmMinSup");
$ArmMaxInf=mysql_result($result,0,"ArmMaxInf");
$ArmMaxSup=mysql_result($result,0,"ArmMaxSup");
$query .= CheckLimite('Arm', $cdmArmMin, $cdmArmMax, $ArmMinInf, $ArmMinSup, $ArmMaxInf, $ArmMaxSup );
$ArmMagMinInf=mysql_result($result,0,"ArmMagMinInf");
$ArmMagMinSup=mysql_result($result,0,"ArmMagMinSup");
$ArmMagMaxInf=mysql_result($result,0,"ArmMagMaxInf");
$ArmMagMaxSup=mysql_result($result,0,"ArmMagMaxSup");
$query .= CheckLimite('ArmMag', $cdmArmMagMin, $cdmArmMagMax, $ArmMagMinInf, $ArmMagMinSup, $ArmMagMaxInf, $ArmMagMaxSup );
$VueMinInf=mysql_result($result,0,"VueMinInf");
$VueMinSup=mysql_result($result,0,"VueMinSup");
$VueMaxInf=mysql_result($result,0,"VueMaxInf");
$VueMaxSup=mysql_result($result,0,"VueMaxSup");
$query .= CheckLimite('Vue', $cdmVueMin, $cdmVueMax, $VueMinInf, $VueMinSup, $VueMaxInf, $VueMaxSup );
$MMMinInf=mysql_result($result,0,"MMMinInf");
$MMMinSup=mysql_result($result,0,"MMMinSup");
$MMMaxInf=mysql_result($result,0,"MMMaxInf");
$MMMaxSup=mysql_result($result,0,"MMMaxSup");
$query .= CheckLimite('MM', $cdmMMMin, $cdmMMMax, $MMMinInf, $MMMinSup, $MMMaxInf, $MMMaxSup );
$RMMinInf=mysql_result($result,0,"RMMinInf");
$RMMinSup=mysql_result($result,0,"RMMinSup");
$RMMaxInf=mysql_result($result,0,"RMMaxInf");
$RMMaxSup=mysql_result($result,0,"RMMaxSup");
$query .= CheckLimite('RM', $cdmRMMin, $cdmRMMax, $RMMinInf, $RMMinSup, $RMMaxInf, $RMMaxSup );
$DLAMinInf=mysql_result($result,0,"DLAMinInf");
$DLAMinSup=mysql_result($result,0,"DLAMinSup");
$DLAMaxInf=mysql_result($result,0,"DLAMaxInf");
$DLAMaxSup=mysql_result($result,0,"DLAMaxSup");
$query .= CheckLimite('DLA', $cdmDLAMin, $cdmDLAMax, $DLAMinInf, $DLAMinSup, $DLAMaxInf, $DLAMaxSup );
$query .= CheckValue('Pouvoir',$cdmPouvoir, mysql_result($result,0,"Pouvoir"));
$query .= CheckValue('nbATT',$cdmNbAtt, mysql_result($result,0,"nbATT"));
$query .= CheckValue('Vitesse',$cdmVitesse, mysql_result($result,0,"Vitesse"));
$query .= CheckValue('VlC',$cdmVlC, mysql_result($result,0,"VlC"));
$query .= CheckValue('AttDist',$cdmAttDist, mysql_result($result,0,"AttDist"));
$query .= CheckValue('AttMag',$cdmAttMag, mysql_result($result,0,"AttMag"));
$query .= CheckValue('Vole',$cdmVole, mysql_result($result,0,"Vole"));
$query .= CheckValue('SangFroid',$cdmSangFroid, mysql_result($result,0,"SangFroid"));
$query .= CheckValue('CapaRange',$cdmCapaRange, mysql_result($result,0,"CapaRange"));
if ($query!="") {
$query = "UPDATE `MZ_Beast2` SET $query Age=\"$cdmAge\" where (Nom=\"$cdmNom\") and (Age=\"$cdmAge\")";
//echo "$query<BR>";
$result = MySQL_QUERY($query);
}
return;
} // Fin MAJ Bestiaire
$res = @MySQL_QUERY($query);
if (@mysql_num_rows($res)) {
$update = mysql_result($res, 0, 'karma_update');
$yesterday = date("Y-m-d", mktime(date("H"), date("i"), date("s"), date("m"), date("d") - 1, date("Y")));
if ($update != $yesterday) {
$ball++;
$update = "<font color=red><b>{$update}</b</font>";
} else {
$update = "<font color=green><b>{$update}</b</font>";
}
$Etat = "Dernier chargement le: {$update}";
}
break;
case "cron_cleanDB.php":
$query = "SELECT Value as cleanDB_update from MZ_Cron where Field='cleanDB_update'";
$res = @MySQL_QUERY($query);
if (@mysql_num_rows($res)) {
$update = mysql_result($res, 0, 'cleanDB_update');
$yesterday = date("Y-m-d", mktime(date("H"), date("i"), date("s"), date("m"), date("d") - 1, date("Y")));
if ($update < $yesterday) {
$ball++;
$update = "<font color=red><b>{$update}</b</font>";
} else {
$update = "<font color=green><b>{$update}</b</font>";
}
$Etat = "Dernier nettoyage le: {$update}";
}
break;
}
$con_name = substr($scriptpath, 0, -4);
if ($ball == 0) {
$query = "TRUNCATE TABLE TMP_Diplo_Inv";
// on vide l'ancienne table (tempo)
#echo "$query<BR>";
$result = @MySQL_QUERY($query);
$query = "SELECT * FROM `MH_Diplo` order by ID , Type , IdCible";
$result = @MySQL_QUERY($query);
$nData = @MySQL_NUM_ROWS($result);
for ($i = 0; $i < $nData; $i++) {
$ID = mysql_result($result, $i, "ID");
$Type = mysql_result($result, $i, "Type");
$IdCible = mysql_result($result, $i, "IdCible");
$Diplo = mysql_result($result, $i, "Diplo");
if ($Diplo == "AMI") {
$Color = "#AAFFAA";
} else {
$Color = "#FFAAAA";
}
//rose monstre=>#FFD3D3
if ($Type == "T") {
$IdCible = -$IdCible;
}
// Pour la diplo d'un troll
$query = "INSERT INTO `TMP_Diplo_Inv` VALUES ('{$IdCible}','{$ID}','{$Color}','G')";
//$query = "INSERT INTO `TMP_Diplo_Inv` VALUES ('$ID','$IdCible','#FFFFFF','$Type')";
echo "{$i} => {$query}<BR>";
$insert = @MySQL_QUERY($query);
}
_sqlclose();
# -------------- Fermeture DB
?>
function _sqllog($err, $RW, $TiD, $Action, $Coterie, $Comment) {
return; #Plus de LOG pour soulager les temps de réponses
$TimeStamp=date("Y-m-d H:i:s");
$ipaddr=mysql_real_escape_string($_SERVER["REMOTE_ADDR"]);
$host=mysql_real_escape_string($_SERVER["REMOTE_ADDR"]);
$self=mysql_real_escape_string($_SERVER["REQUEST_URI"]);
$refer=mysql_real_escape_string($_SERVER["HTTP_REFERER"]);
$TiD=intval($TiD); #TiD en chiffre entier
$Comment=mysql_real_escape_string($Comment);
$_sqlquery = "INSERT INTO `MZ_LogZZ` VALUES('$TimeStamp', $err, '$RW', '$Action', $TiD, '$Coterie', '$Comment', '$ipaddr', '$host', '$self', '$refer')";
#echo "$_sqlquery<BR>";
$_sqlresult = @MySQL_QUERY($_sqlquery);
#Nettoyage du log d'erreur de plus d'un mois et non-erreur de plus d'une semaine
$OutOfDate=date("Y-m-d H:i:s",mktime(date("H"),date("i"),date("s"),date("m"),date("d")-30,date("Y")));
$_sqlquery = "DELETE from `MZ_LogZZ` where (err!=0) and (Coterie='$Coterie') and (TimeStamp<'$OutOfDate')";
$_sqlresult = @MySQL_QUERY($_sqlquery);
$OutOfDate=date("Y-m-d H:i:s",mktime(date("H"),date("i"),date("s"),date("m"),date("d")-7,date("Y")));
$_sqlquery = "DELETE from `MZ_LogZZ` where (err=0) and (Coterie='$Coterie') and (TimeStamp<'$OutOfDate')";
$_sqlresult = @MySQL_QUERY($_sqlquery);
return;
}
