function ClearForEvent($event_id) { if ($event_id) { $query = "DELETE FROM recurrence WHERE event_id = {$event_id}"; MyActiveRecord::Query($query); } }
function delete() { foreach ($this->get_photos() as $photo) { $photo->delete(true); } return MyActiveRecord::Query("DELETE FROM galleries WHERE id = {$this->id}"); }
function delete() { $target_path = SERVER_DOCUMENTS_ROOT . $this->filename; if (file_exists($target_path)) { unlink($target_path); } return MyActiveRecord::Query("DELETE FROM documents WHERE id ={$this->id}"); }
function delete() { $target_path = $this->get_local_image_path($this->filename); if (file_exists($target_path)) { unlink($target_path); } return MyActiveRecord::Query("DELETE FROM photos WHERE id ={$this->id}"); }
/** * Deletes the object from the database * eg: * <code> * $car = MyActiveRecord::FindById('Car', 1); * $car->destroy(); * </code> * * @return boolean True on success, False on failure */ public function destroy() { $table = MyActiveRecord::Class2Table($this); return MyActiveRecord::Query("DELETE FROM `{$table}` WHERE `{$table}`.`id`={$this->id}"); }
/** * Count number of items of type strClass which are linked to the current object. * * @param string $strClass Class of objects to count. * @param string $mxdCondition Additional WHERE clause * @return int */ function count_linked($strClass, $mxdCondition = null) { if (isset($this->id) && $this->id > 0) { $this->id = intval($this->id); // only attempt to find links if this object has an id $table = MyActiveRecord::Class2Table($strClass); $thistable = MyActiveRecord::Class2Table($this); $linktable = MyActiveRecord::GetLinkTable($table, $thistable); $sql = "SELECT COUNT(1) AS _count FROM {$table} INNER JOIN {$linktable} ON {$table}_id = {$table}.id WHERE {$linktable}.{$thistable}_id = {$this->id} "; if (is_array($mxdCondition)) { foreach ($mxdCondition as $key => $val) { $val = addslashes($val); $sql .= " AND {$key} = '{$val}' "; } } else { if ($mxdCondition) { $sql .= " AND {$mxdCondition}"; } } $result = MyActiveRecord::Query($sql); if ($row = mysql_fetch_object($result)) { return $row->_count; } } return 0; }
/** * Deletes the object from the database * eg: * <code> * $car = MyActiveRecord::FindById('Car', 1); * $car->destroy(); * </code> * * @return boolean True on success, False on failure */ function destroy() { $table = MyActiveRecord::Class2Table($this); return MyActiveRecord::Query("DELETE FROM {$table} WHERE id ={$this->id}"); }