Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Rain]

I have all the following crons in my public_html that work... The thing is, it says my character is, for example, 250 days old when my character is really 30 days old. Another thing is then it say my character's Last Action is -50 seconds ago, I was thinking I need a cron_second.php to fix this maybe? Not sure if anyone knows how to fix this PM me or post it here

[Danny696]

cron_second no, make sure no cron is posted twice or if theres an error or a query reppeted twice

[Rain]

I dont have any crons posted twice, also what do you mean bu the query repeated twice?

[Danny696]

Go into the cron there mabey things like this:  $db->query("UPDATE users SET blahh=blahh+2 WHERE userid=$userid");
$db->query("UPDATE users SET blah=blah+1 WHERE userid=$userid");
$db->query("UPDATE users SET blahh=blahh+2 WHERE userid=$userid");  causing blahh to be +4 not +2

[Cronus]

Never run a cron_second.
If you are running a cron that runs every second, you're wasting sooooooo much bandwidth.
Plus, your site will probably lag, permanently.

[gambino]

that would have to be a server error. crons can only support up to a minute to years. server might be buffering way too fast. you could switch to my hosting server if you get permission from my WHP to get it and I will submit the support ticket to see if your approved.

if I can if mccodes.com would let me do some paid modifying to your site.

[Rain]

Well heres the DB Query part in my crons_day.php. Tel lme if there is anything wrong with it

$db->query("UPDATE users SET fedjail=0 WHERE userid IN(".implode(",", $ids).")");
}
$db->query("DELETE FROM fedjail WHERE fed_days=0");
$db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 1");
$db->query("UPDATE users SET daysold=daysold+1, boxes_opened=0");
$db->query("TRUNCATE TABLE rating");
$db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0");
$db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0");
$db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0");
$db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0");
$db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>0");
$db->query("UPDATE users SET sbban=sbban-1 WHERE sbban > 0");
$q=$db->query("SELECT * FROM users WHERE cdays=0 AND course > 0");
while($r=$db->fetch_row($q))$db->query("UPDATE users SET fedjail=0 WHERE userid IN(".implode(",", $ids).")");
}
$db->query("DELETE FROM fedjail WHERE fed_days=0");
$db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 1");
$db->query("UPDATE users SET daysold=daysold+1, boxes_opened=0");
$db->query("TRUNCATE TABLE rating");
$db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0");
$db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0");
$db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0");
$db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0");
$db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>0");
$db->query("UPDATE users SET sbban=sbban-1 WHERE sbban > 0");
$q=$db->query("SELECT * FROM users WHERE cdays=0 AND course > 0");
while($r=$db->fetch_row($q))

[Danny696]

pm me your whole cron day file

[Jordan]

I can have a look into this with you if you're still getting this.

Pudda2008@hotmail.co.uk - IM me