Messing up the servers

[Gen. Volkov]

Yeah, I'd like a reset, reg is dead, and it would clear out all the old gunk, which would help with the usage. I just don get why the usage spike would happen now, we've had all those dead wralords for awhile.

[Disdain]

Mine seems to be gone, as well.

I'd prefer one, since my account got deleted for some reason.

[Wolf Snare]

I'm in favour of a reset.

[Shogun]

On the suspect of lunarpages: Servers got DOS'd today, at least Krittika did. My site is down now, which sucks. :S

[Peace Alliance]

I think everyone would like one now, since there was a lot of inactive accounts

[Aqualis]

Yes, reset.

[Germania]

How are turns proccesed? Does it go through all the accounts? Dead and alive? Someone check turns.php....

[Peace Alliance]

G... germania? where've you been? i thought you were in jail again or something, lol

[bjornredtail]

*digs out copy of BAXX sourcecode*
Ok...
Here is the relivant code in turns.php

Code Select Expand

print "Updating ranks...";
$users = mysql_query("SELECT num FROM $playerdb ORDER BY disabled ASC, networth DESC;");
$urank = 0;
while ($user = mysql_fetch_array($users))
{
$urank++;
mysql_query("UPDATE $playerdb SET rank=$urank WHERE num=$user[num];");
}
/*$users = mysql_query("SELECT num FROM $playerdb WHERE disabled != 2 AND land = 0 ORDER BY networth DESC;");
while ($user = mysql_fetch_array($users))
{
$urank++;
mysql_query("UPDATE $playerdb SET rank=$urank WHERE num=$user[num];");
}*/

Odd, the old code that was commented noted if there did not update ranks for dead people, at least I think.

[Gen. Volkov]

So its possible someone was messing with it and Retto didn't realize they were?

[bjornredtail]

Not likely... Everything in turns.php is fired via cron. If you attempt to launch it thourgh the web server, you would fail.

To prove that: http://www.redwallwarlords.com/turns.php

Access forbidden!

Fatal error: Call to undefined function: htmlend() in /home/redwallw/public_html/turns.php on line 18

Which is just what is supposed to happen. However, if you were to call it through PHP indapendently of Apache, it would run... And I do not have the access to do that, else I would have messed up the turns.

However, the real time scores could be exploited like that, at least I belive. Perhaps something could be added to exclude dead empires from real time rankings.

[Germania]

G... germania? where've you been? i thought you were in jail again or something, lol

Around.

What I meant by processing turns for dead accounts was eventually when you hit a certain point, you had say 900 dead accounts which would still get time devoted to by cron when it processed turns.php. I guess you would have to; to a point so the ranks would update and they could settle at the bottom but maybe a bypass line if:dead then:skip logic after initial rankings are updated.

[Retto]

Well, bravo, to everyone who has been mucking about, and the idiots who put up with their lies and schemes:

Hello,

I have had to disable your cron jobs as the processes weren't dying off, and
the server had load of 44. Usual load is up to around 10.

As this has caused an issue before, I must ask that you do not put them back
again, as they are not suitable for our shared hosting plan.

You need to upgrade to dedicated if you want to host these. Alternatively,
it might be ok if you run them every hour, but definately not as they have been
running, as they have caused problems twice now.

[Gen. Volkov]

Oh great, thanks guys. No turns again.

[cloud]

maybe if beatles wasn't hacking the code and using programs...