function courseExists($c)
{
if (!$c) {
return false;
}
$query = "\n\t\t\tSELECT\n\t\t\t\tCOUNT(*) as count\n\t\t\tFROM\n\t\t\t\tclass\n\t\t\tWHERE\n\t\t\t\t'" . addslashes(generateTermsFromCode($c)) . "'\n\t\t";
$r = db_query($query);
$a = db_fetch_assoc($r);
if ($a['count'] != 0) {
return true;
}
return false;
}
function getClassgroupListsForGroupsContainingClasses($classesArray)
{
global $dbhost, $dbuser, $dbpass, $dbdb;
$classgroupLists = array();
if (!count($classesArray)) {
return $classgroupLists;
}
$query = "\nSELECT\n\tclassgroup_name,\n\tclass_department,\n\tclass_number,\n\tclass_section,\n\tclass_semester,\n\tclass_year\nFROM\n\tclass\n\t\tINNER JOIN\n\t\t\tclassgroup ON FK_classgroup = classgroup_id\nWHERE\n";
$i = 0;
foreach ($classesArray as $className) {
$query .= "\n\t";
if ($i > 0) {
$query .= "OR ";
}
$query .= "(";
$query .= generateTermsFromCode($className);
$query .= ")";
$i++;
}
$query .= "\nORDER BY\n\tclassgroup_name\n";
$r = db_query($query);
if (db_num_rows($r)) {
while ($a = db_fetch_assoc($r)) {
if (!isset($classgroupLists[$a['classgroup_name']])) {
$classgroupLists[$a['classgroup_name']] = array();
}
$code = generateCodeFromData($a['class_department'], $a['class_number'], $a['class_section'], $a['class_semester'], $a['class_year']);
$classgroupLists[$a['classgroup_name']][$code] = array('code' => $a['class_department'] . $a['class_number'], 'sect' => $a['class_section'], 'sem' => $a['class_semester'], 'year' => $a['class_year']);
}
}
return $classgroupLists;
}
$w[] = "user2.user_uname like '%" . addslashes($user) . "%'";
}
if ($_REQUEST[site]) {
$isgroup = ($classlist = group::getClassesFromName($_REQUEST[site])) ? 1 : 0;
if ($isgroup) {
$class_terms = array();
foreach ($classlist as $code) {
$terms[] = "(" . generateTermsFromCode($code) . ")";
}
$arg = "(";
$arg .= implode(" OR ", $classlist);
$arg .= ")";
$w[] = $arg;
} else {
// $w[]="class_code like '%$site%'";
$w[] = generateTermsFromCode($site);
}
}
//if ($title) $w[]="title like '%$title%'";
if (count($w)) {
$where = " where " . implode(" and ", $w);
}
$query = "\n\tSELECT \n\t\tCOUNT(*) AS log_count\n\tFROM \n\t\tclass\n\t\t\tINNER JOIN\n\t\tuser AS user1\n\t\t\tON\n\t\tclass.FK_owner = user1.user_id\n\t\t\tINNER JOIN\n\t\tugroup\n\t\t\tON\n\t\tclass.FK_ugroup = ugroup_id\n\t\t\tINNER JOIN\n\t\tugroup_user\n\t\t\tON\n\t\tugroup_id = ugroup_user.FK_ugroup\n\t\t\tINNER JOIN\n\t\tuser AS user2\n\t\t\tON\n\t\tugroup_user.FK_user = user2.user_id\n\t{$where}";
$r = db_query($query);
$a = db_fetch_assoc($r);
$numlogs = $a[log_count];
if (!isset($lowerlimit)) {
$lowerlimit = 0;
}
if ($lowerlimit < 0) {
$lowerlimit = 0;
function inclassgroup($class)
{
$query = "\n\t\tSELECT\n\t\t\tclassgroup_name\n\t\tFROM\n\t\t\tclassgroup\n\t\t\t\tINNER JOIN\n\t\t\tclass ON classgroup_id = FK_classgroup AND " . addslashes(generateTermsFromCode($class)) . "\n\t";
$r = db_query($query);
if (db_num_rows($r)) {
$a = db_fetch_assoc($r);
return $a[classgroup_name];
}
return 0;
}
function getNameFromClass($class)
{
$query = "SELECT classgroup_name FROM class INNER JOIN classgroup ON FK_classgroup = classgroup_id AND " . generateTermsFromCode($class);
// echo $query."<br />";
$r = db_query($query);
if (db_num_rows($r)) {
$a = db_fetch_assoc($r);
return $a[classgroup_name];
}
return false;
}
