startheaders();
include "mysql.php";
global $c;
$is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error());
$ir=mysql_fetch_array($is);
check_level();
$fm=money_formatter($ir['money']);
$cm=money_formatter($ir['credits'],'');
$lv=date('F j, Y, g:i a',$ir['laston']);
$h->userdata($ir,$lv,$fm,$cm);
$h->menuarea();
print "Schooling
";
if($ir['course'] > 0)
{
$cd=mysql_query("SELECT * FROM courses WHERE crID={$ir['course']}",$c);
$coud=mysql_fetch_array($cd);
print "You are currently doing the {$coud['crNAME']}, you have {$ir['cdays']} days remaining.";
}
else
{
if($_GET['cstart'])
{
$_GET['cstart'] = abs((int) $_GET['cstart']);
//Verify.
$cd=mysql_query("SELECT * FROM courses WHERE crID={$_GET['cstart']}",$c);
if(mysql_num_rows($cd) == 0)
{
print "You are trying to start a non-existant course!";
}
else
{
$coud=mysql_fetch_array($cd);
$cdo=mysql_query("SELECT * FROM coursesdone WHERE userid=$userid AND courseid={$_GET['cstart']}",$c);
if($ir['money'] < $coud['crCOST'])
{
print "You don't have enough money to start this course.";
$h->endpage();
exit;
}
if(mysql_num_rows($cd0) > 0)
{
print "You have already done this course.";
$h->endpage();
exit;
}
mysql_query("UPDATE users SET course={$_GET['cstart']},cdays={$coud['crDAYS']},money=money-{$coud['crCOST']} WHERE userid=$userid",$c);
print "You have started the {$coud['crNAME']}, it will take {$coud['crDAYS']} days to complete.";
}
}
else
{
//list courses
print "Here is a list of available courses.";
$q=mysql_query("SELECT * FROM courses",$c);
print "
| Course | Description | Cost | Take |
|---|
";
while($r=mysql_fetch_array($q))
{
$cd0=mysql_query("SELECT * FROM coursesdone WHERE userid=$userid AND courseid={$r['crID']}",$c);
if(mysql_num_rows($cd0)) { $cd0="Done"; } else { $cd0="Take"; }
print "| {$r['crNAME']} | {$r['crDESC']} | \${$r['crCOST']} | $cd0 |
";
}
print "
";
}
}
$h->endpage();
?>