I have been working on a game and I cant seem to get it to reset when its a new day. It will reset when someone is logged on but not when no one is on. my code looks like this:
$hour_s = date("h");
$minute_s = date("i");
$second_s = date("s");
$timecheck = date("A");
if($timecheck == "PM")
{
if($hour_s == "12")
{
$resetin_h = 23 - $hour_s;
$resetin_m = 60 - $minute_s;
}
else
{
$resetin_h = 11 - $hour_s;
$resetin_m = 60 - $minute_s;
}
}
elseif($timecheck == "AM")
{
$resetin_h = 23 - $hour_s;
$resetin_m = 60 - $minute_s;
}
if($resetin_h == "0")
{
if($resetin_m < "5")
{
$sql = 'OPTIMIZE TABLE admin_logs , ano , arm , cchat , chat , clan_app , clan_mem , clans , cmarket , enemies , game_config , game_updates , ipban , mb , mb_boards , mb_posts , mb_topics , msg , newsandupdates , noobchat , pequipment , polls , tran_log , userdb , usernews , usersinchat , usersonline , verify_email , weps ';
$updatenews = mysql_query("UPDATE usernews SET id='', user='Game', text='New Day', date=NOW{}");
$updaterest = mysql_query("UPDATE game_config SET lastreset=NOW()");
$reseto = mysql_query("update userdb set age=age+1");
$resetb = mysql_query("update userdb set fightstoday='0'");
$resetc = mysql_query("update userdb set energy='10'");
$resett = mysql_query("update userdb set trains='15'");
$resethp = mysql_query("update userdb set hp_left=hp");
$resetstamina = mysql_query("update userdb set stamina='10'");
$resetj = mysql_query("update userdb set jaildays=jaildays-1 WHERE jail='Y'");
$resetj2 = mysql_query("UPDATE userdb SET jail='N', jaildays='0', jailby='', jailbyid='', jailreason=''WHERE jaildays='0'");
$resetc = mysql_query("update userdb set cbandays=cbandays-1 WHERE cban='Y'");
$resetmbtp = mysql_query("UPDATE userdb SET totalpost = '0'");
$resetgameconfig = mysql_query("UPDATE game_config SET lastreset=NOW()");
include("style.css");
$minutes_until_done = 5 - $minute_s;
$seconds_until_done = 60 - $second_s;
echo "<center>Game is currently down for the reset. It will be done in $minutes_until_done minutes and $seconds_until_done seconds.</center>";
exit;
}
}
thanks for the help.
Machiezmo
