function insertDB()
{
global $error;
if (segue::siteExists($this->name) || slot::exists($this->name, 0)) {
error("That site name, " . $this->name . ", is already in use.");
}
if (!ereg("^([0-9a-zA-Z_.-]{0,})\$", $this->name)) {
error("Your slot name is invalid. It may only contain alphanumeric characters, '-', '_' and '.'");
}
if (!$error) {
// get id for owner of slot
$query = "SELECT user_id FROM user WHERE user_uname = '" . addslashes($this->owner) . "'";
/* echo $query."<br />"; */
$r = db_query($query);
if (!db_num_rows($r)) {
return false;
}
$a = db_fetch_assoc($r);
$owner_id = $a[user_id];
if ($this->site) {
$site = "'" . addslashes($this->site) . "'";
} else {
$site = "NULL";
}
if ($this->assocSite) {
// get id for assoc_site of slot
$query = "SELECT slot_id FROM slot WHERE slot_name = '" . addslashes($this->assocSite) . "'";
/* echo $query."<br />"; */
$r = db_query($query);
$a = db_fetch_assoc($r);
$assocSite = "'" . addslashes($a[slot_id]) . "'";
} else {
$assocSite = "NULL";
}
if (preg_match('/^[0-9]*$/', $this->uploadlimit)) {
$uploadLimit = $this->uploadlimit;
} else {
$uploadLimit = "NULL";
}
if (!$this->name) {
error("Slot name not specified. Please notify the administrator of the steps that took you to this point.");
print "Slot name not specified. Please notify the administrator of the steps that took you to this point.";
exit;
}
$query = "\n\t\t\t\tINSERT INTO \n\t\t\t\t\tslot \n\t\t\t\tSET \n\t\t\t\t\tFK_owner= '" . addslashes($owner_id) . "',\n\t\t\t\t\tslot_name='" . addslashes($this->name) . "',\n\t\t\t\t\tslot_type='" . addslashes($this->type) . "',\n\t\t\t\t\tFK_site=" . $site . ",\n\t\t\t\t\tFK_assocsite=" . $assocSite . ",\n\t\t\t\t\tslot_uploadlimit=" . $this->uploadlimit . "\n\t\t\t";
/* print $query; */
db_query($query);
echo mysql_error();
}
}
function addClasses($classes)
{
if (is_array($classes)) {
$classes2 = array();
foreach ($classes as $n => $class) {
if (segue::siteExists($class)) {
if (!segue::siteExists($this->name)) {
$siteObj =& new site($class);
$siteObj->fetchDown(1);
$siteObj->copySite($this->name, FALSE, TRUE);
$siteObj =& new site($class);
$siteObj->fetchDown(1);
$siteObj->delete();
$classes2[] = $class;
} else {
error("You can not add an existing site to a group that already has a site created");
}
} else {
$classes2[] = $class;
}
}
$this->classes = array_unique(array_merge($this->classes, $classes2));
}
}
