public function Update() { $pdo = DataSystem::GetPDO(); $query = "UPDATE " . System::GetConfigurationValue("Database.TablePrefix") . $this->GetCommentTableName() . " SET comment_Title = :comment_Title, comment_Content = :comment_Content WHERE comment_ID = :comment_ID"; $statement = $pdo->prepare($query); $result = $statement->execute(array(":comment_Title" => $this->Title, ":comment_Content" => $this->Content, ":comment_ID" => $this->ID)); return $result; }
public function Delete() { $pdo = DataSystem::GetPDO(); $query = "DELETE FROM " . System::GetConfigurationValue("Database.TablePrefix") . "Contents WHERE content_Path = :content_Path AND content_LanguageID = :content_LanguageID"; $statement = $pdo->prepare($query); $result = $statement->execute(array(":content_Path" => $this->Path, ":content_LanguageID" => $this->Language->ID)); return $result !== false; }
public static function GetByName($name) { $pdo = DataSystem::GetPDO(); $query = "SELECT * FROM " . System::GetConfigurationValue("Database.TablePrefix") . "Themes WHERE theme_Name = :theme_Name"; $statement = $pdo->prepare($query); $result = $statement->execute(array(":theme_Name" => $name)); if ($statement->rowCount() > 0) { $values = $statement->fetch(PDO::FETCH_ASSOC); return Theme::GetByAssoc($values); } return null; }
public function GetSlices($max = null) { $pdo = DataSystem::GetPDO(); $query = "SELECT * FROM " . System::GetConfigurationValue("Database.TablePrefix") . "AvatarBaseSlices"; $query .= " WHERE slice_BaseID = :slice_BaseID AND slice_ParentSliceID = :slice_ParentSliceID"; if (is_numeric($max)) { $query .= " LIMIT " . $max; } $statement = $pdo->prepare($query); $result = $pdo->execute(array(":slice_BaseID" => $this->Base->ID, ":slice_ParentSliceID" => $this->ID)); $count = $statement->rowCount(); $retval = array(); for ($i = 0; $i < $count; $i++) { $values = $result->fetch(PDO::FETCH_ASSOC); $retval[] = AvatarBaseSlice::GetByAssoc($values); } return $retval; }
public static function Get($max = null) { $pdo = DataSystem::GetPDO(); $query = "SELECT * FROM " . System::GetConfigurationValue("Database.TablePrefix") . "DashboardPostImpressions"; if (is_numeric($max)) { $query .= " LIMIT " . $max; } $retval = array(); $statement = $pdo->prepare($query); $result = $statement->execute(); if ($result === false) { return $retval; } $count = $statement->rowCount(); for ($i = 0; $i < $count; $i++) { $values = $statement->fetch(PDO::FETCH_ASSOC); $retval[] = DashboardPostImpression::GetByAssoc($values); } return $retval; }