0000r0000e0000s0000e0000t.php

<?php

include('db.php');



$gettemple = mysql_query("SELECT * FROM temple");

$temple = mysql_fetch_assoc($gettemple);

$update1 = mysql_query("UPDATE characters SET temple='0'");



$getUsers = mysql_query("SELECT * FROM characters");

while($userMana = mysql_fetch_array($getUsers)){

    $getchar = mysql_query("SELECT * FROM characters WHERE id='".$userMana['id']."'");

    $char = mysql_fetch_assoc($getchar);

    $getequip = mysql_query("SELECT * FROM inventory WHERE username='".$char['username']."' AND equipped='Yes'");

    if(mysql_num_rows($getequip) > "0")

    {

    	$eqintbon = 0;

        while($equip = mysql_fetch_array($getequip))

        {

            $eqintbon += $equip['intelligence'];

        }

    }



    $charint = $char['intelligence'] + $eqintbon;

    

    $updateMana = mysql_query("UPDATE characters SET mana='".$charint."' WHERE username='".$char['username']."'");

}



$addAttempt = mysql_query("UPDATE characters SET vodooattempt='0'");

$addlogin = mysql_query("UPDATE characters SET dailylogin='0'");





$updatedBlessings1 = "None, Buy, Buy, Buy, Buy, Buy, Buy, Buy, Buy"; 

$runblessingReset1 = mysql_query("UPDATE characters SET blessing='".$updatedBlessings1."' WHERE affinitys='1'");

$updatedBlessings2 = "None, None, Buy, Buy, Buy, Buy, Buy, Buy, Buy"; 

$runblessingReset2 = mysql_query("UPDATE characters SET blessing='".$updatedBlessings2."' WHERE affinitys='2'");

$updatedBlessings3 = "None, None, None, Buy, Buy, Buy, Buy, Buy, Buy"; 

$runblessingReset3 = mysql_query("UPDATE characters SET blessing='".$updatedBlessings3."' WHERE affinitys='3'");

$updatedBlessings4 = "None, None, None, None, Buy, Buy, Buy, Buy, Buy"; 

$runblessingReset4 = mysql_query("UPDATE characters SET blessing='".$updatedBlessings4."' WHERE affinitys='4'");

$updatedBlessings5 = "None, None, None, None, None, Buy, Buy, Buy, Buy"; 

$runblessingReset5 = mysql_query("UPDATE characters SET blessing='".$updatedBlessings5."' WHERE affinitys='5'");

$updatedBlessings6 = "None, None, None, None, None, None, Buy, Buy, Buy"; 

$runblessingReset6 = mysql_query("UPDATE characters SET blessing='".$updatedBlessings6."' WHERE affinitys='6'");

$updatedBlessings7 = "None, None, None, None, None, None, None, Buy, Buy"; 

$runblessingReset7 = mysql_query("UPDATE characters SET blessing='".$updatedBlessings7."' WHERE affinitys='7'");

$updatedBlessings8 = "None, None, None, None, None, None, None, None, Buy"; 

$runblessingReset8 = mysql_query("UPDATE characters SET blessing='".$updatedBlessings8."' WHERE affinitys='8'");

$updatedBlessings9 = "None, None, None, None, None, None, None, None, None"; 

$runblessingReset9 = mysql_query("UPDATE characters SET blessing='".$updatedBlessings9."' WHERE affinitys='9'");





$messagechat = "<strong><font color=\'#00FF00\'>(System): Daily reset occured. Blessings reset, Temple reset, Mana rejuvinated.</font></strong><br />";

$query = mysql_query("INSERT INTO chatroom (`date`, `userlevel`, `message`, `to`) VALUES ('".$date."', '3', '".$messagechat."', 'Chatroom')");

?>