public function del($archive = 0)
{
$q = "DELETE FROM " . $this->dbdata_table . " WHERE id=? ";
$st = $this->dbconn->Prepare($q);
$r = $this->dbconn->Execute($st, array($this->id));
if (!$r) {
$_SESSION['hidden_error'] = "Could not fetch the " . get_class($this) . " record! " . $this->dbconn->ErrorMsg();
return false;
}
//generate log
if ($this->dbdata_table == 'profiles' || $this->dbdata_table == 'contents' and $archive == 1) {
$cols_update = array();
$vars_update = array();
$cols_update[] = 'event';
$vars_update[] = 'delete';
$cols_update[] = 'event_id';
$vars_update[] = $this->id;
$cols_update[] = 'event_profile_id';
$vars_update[] = $_SESSION['profile_id'];
$cols_update[] = 'event_date';
$vars_update[] = date("Y-m-d H:i:s");
$dbconn_archive = DBConn::connectArchive();
$q_archive = "INSERT INTO " . $this->dbdata_table . "(" . implode(",", $cols_update) . ") VALUES (" . str_repeat("?,", count($vars_update) - 1) . "?)";
$st_archive = $dbconn_archive->Prepare($q_archive);
$r_archive = $dbconn_archive->Execute($st_archive, $vars_update);
}
$dbconn = DBConn::getInstance()->conn;
$this->dbconn = $dbconn;
return true;
}
