function getSlotInfoForSlots($slotNameArray)
{
global $dbhost, $dbuser, $dbpass, $dbdb;
$ar = array();
if (!count($slotNameArray)) {
return $ar;
}
$query = "\n\t\t\tSELECT\n\t\t\t\tslot_name,\n\t\t\t\tslot_type,\n\t\t\t\tslot_owner.user_uname AS owner_uname,\n\t\t\t\t(site_id IS NOT NULL) AS site_exists,\n\t\t\t\tsite_title,\n\t\t\t\t(classgroup_id IS NOT NULL) AS is_classgroup,\n\t\t\t\tcreatedby.user_uname AS site_addedby,\n\t\t\t\tsite_created_tstamp,\n\t\t\t\teditedby.user_uname AS site_editedby,\n\t\t\t\tsite_updated_tstamp,\n\t\t\t\tsite_activate_tstamp,\n\t\t\t\tsite_deactivate_tstamp,\n\t\t\t\t(\tsite_active = '1'\n\t\t\t\t\tAND (site_activate_tstamp = '00000000000000'\n\t\t\t\t\t\tOR site_activate_tstamp < CURRENT_TIMESTAMP())\n\t\t\t\t\tAND (site_deactivate_tstamp = '00000000000000'\n\t\t\t\t\t\tOR site_deactivate_tstamp > CURRENT_TIMESTAMP())\n\t\t\t\t) AS is_active\n\t\t\tFROM\n\t\t\t\tslot\n\t\t\t\t\tINNER JOIN\n\t\t\t\t\t\tuser AS slot_owner ON (\n\t\t\t\t\t\t\t\t\t\t\t\tslot.FK_owner = slot_owner.user_id\n\t\t\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\t\t\t\t(";
$i = 0;
foreach ($slotNameArray as $slot) {
$query .= "\t\t\t\t\t\t\t\t\t\t";
if ($i > 0) {
$query .= "OR ";
}
$query .= "slot.slot_name = '" . addslashes($slot) . "'";
$i++;
}
$query .= "\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\tLEFT JOIN\n\t\t\t\tsite ON slot.FK_site = site_id\n\t\t\t\t\tLEFT JOIN\n\t\t\t\t\t\tuser AS createdby ON site.FK_createdby = createdby.user_id\n\t\t\t\t\tLEFT JOIN\n\t\t\t\t\t\tuser AS editedby ON site.FK_updatedby = editedby.user_id\n\t\t\t\t\tLEFT JOIN\n\t\t\t\t\t\tclassgroup ON slot_name = classgroup_name\n\t\t\tGROUP BY\n\t\t\t\tslot_name\n\t\t\t\t\t";
$r = db_query($query);
if (db_num_rows($r)) {
while ($a = db_fetch_assoc($r)) {
segue::addRowToSiteInfoArray($ar, $a);
}
}
return $ar;
}
function getSiteInfoWhereUserOwner($user = '')
{
global $dbhost, $dbuser, $dbpass, $dbdb;
if ($user == '') {
$user = $_SESSION[auser];
}
$query = "\n\t\t\tSELECT\n\t\t\t\tslot_name,\n\t\t\t\tslot_type,\n\t\t\t\tslot_owner.user_uname AS owner_uname,\n\t\t\t\t(site_id IS NOT NULL) AS site_exists,\n\t\t\t\tsite_title,\n\t\t\t\t(classgroup_id IS NOT NULL) AS is_classgroup,\n\t\t\t\tcreatedby.user_uname AS site_addedby,\n\t\t\t\tsite_created_tstamp,\n\t\t\t\teditedby.user_uname AS site_editedby,\n\t\t\t\tsite_updated_tstamp,\n\t\t\t\tsite_activate_tstamp,\n\t\t\t\tsite_deactivate_tstamp,\n\t\t\t\t(\tsite_active = '1'\n\t\t\t\t\tAND (site_activate_tstamp = '00000000000000'\n\t\t\t\t\t\tOR site_activate_tstamp < CURRENT_TIMESTAMP())\n\t\t\t\t\tAND (site_deactivate_tstamp = '00000000000000'\n\t\t\t\t\t\tOR site_deactivate_tstamp > CURRENT_TIMESTAMP())\n\t\t\t\t) AS is_active\n\t\t\tFROM\n\t\t\t\tslot\n\t\t\t\t\tINNER JOIN\n\t\t\t\t\t\tuser AS slot_owner ON (\n\t\t\t\t\t\t\t\t\t\t\t\tslot.FK_owner = slot_owner.user_id\n\t\t\t\t\t\t\t\t\t\t\tAND\n\t\t\t\t\t\t\t\t\t\t\t\tslot_owner.user_uname = '" . addslashes($user) . "'\n\t\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\tINNER JOIN\n\t\t\t\tsite ON slot.FK_site = site_id\n\t\t\t\t\tINNER JOIN\n\t\t\t\t\t\tuser AS createdby ON site.FK_createdby = createdby.user_id\n\t\t\t\t\tINNER JOIN\n\t\t\t\t\t\tuser AS editedby ON site.FK_updatedby = editedby.user_id\n\t\t\t\t\tLEFT JOIN\n\t\t\t\t\t\tclassgroup ON slot_name = classgroup_name\n\t\t\tGROUP BY\n\t\t\t\tslot_name\n\t\t";
$r = db_query($query);
if (db_num_rows($r)) {
while ($a = db_fetch_assoc($r)) {
segue::addRowToSiteInfoArray($ar, $a);
}
}
return $ar;
}
