<?php
/*-----------------------------------------------------
-- Mono Country v1.0 BETA
-- A product of DBS-entertainment
-- Copyright held 2005 by Dabomstew
-- INDEX.php
-----------------------------------------------------*/
session_start();
require "global_func.php";
if($_SESSION['loggedin']==0) { header("Location: login.php");exit; }
$userid=$_SESSION['userid'];
require "header.php";
$h = new headers;
$h->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 "<h3>Schooling</h3>";
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 "<br /><table width=75%><tr style='background:gray;'><th>Course</th><th>Description</th><th>Cost</th><th>Take</th></tr>";
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="<i>Done</i>"; } else { $cd0="<a href='education.php?cstart={$r['crID']}'>Take</a>"; }
print "<tr><td>{$r['crNAME']}</td><td>{$r['crDESC']}</td><td>\${$r['crCOST']}</td><td>$cd0</td></tr>";
}
print "</table>";
}
}
$h->endpage();
?>