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; }