Add a coloum in the coursec table, open the day cron, find where it give the stats when the course is completed, and use the item add function. Hope that helps
Its a paid mod, and
[mysql]ALTER TABLE `users` ADD `maxfatigue` VARCHAR( 255 ) NOT NULL DEFAULT '100'[/mysql]
why is it a VARCHAR??, use INT(11) so its a number
Your the one making assumptions show me where i said that sprintf will secure your site. -.- didnt think ya could. the TP said;
$query=("blah blah blah");$db->$query; i was correcting them, get your facts rite, then come back.
I re-did it for ya, didnt know 100% what you needed, heres the easy fix,
$q=$db->query("SELECT u.userid, u.username, u.level, u.hospital, u.hospreason, u.display_pic, u.gang, c.* FROM users u LEFT JOIN gangs c ON u.gang=c.gangID WHERE u.hospital > 0 ORDER BY u.hospital DESC",$c);
You didnt select the display pic, where in jail, and my scipt, it was selected. Hope that helps more.