I use $mond for the code below to show all classes on monday. and $tue to shows all classes on tuesday... and so on, since the code is too long, i removed tuesday to sunday.
They can get all the classes in schedule just fine. I can also remove and approve classes, but I can't edit them. when I tried to click on edit, they show 2 forms (1 display above header with all $var
PHP Code:
$templater->register('mond', $mond);
PHP Code:
if ($ese_schedule['do'] == "main"){
// Get Monday
$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "schedule WHERE day = 'Monday' AND live = '1' ORDER BY display");
while($mon = $vbulletin->db->fetch_array($result)){
$mond .= "<b><font color='#FF0000'>$mon[display]</font></b> -
<b>$mon[day]</b> -
<b>$mon[time] $mon[ampm]</b> -
<b>$mon[instructor]</b> -
<b>$mon[class]</b> -
<b>$mon[level]</b> -
<b><span><a href='schedulecp.php?do=edit&id=$mon[id]'>Edit</a></span></b> -
<b><span><a href='schedulecp.php?do=approve&id=$mon[id]'>Approve</a></span></b> -
<b><span><a href='schedulecp.php?do=delete&id=$mon[id]'>Delete</a></span></b><br />";
}
// Get tuesday
//code for getting tuesday's classes here using $tue
// Get wednesday
//code for getting tuesday's classes here using $wed
// Get thur
//code for getting tuesday's classes here using $thu
// Get fri
//code for getting tuesday's classes here using $fri
// Get sat
//code for getting tuesday's classes here using $sat
// Get sun
//code for getting tuesday's classes here using $sun
}
here is how the main page looks:
and here is the editing page currently look.
11-25-2009, 03:55 AM
Hybrid Mode
