public static function GetByPath($path) { $pdo = DataSystem::GetPDO(); $query = "SELECT * 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" => $path, ":content_LanguageID" => Language::GetCurrent()->ID)); if ($statement->rowCount() < 1) { return null; } $values = $statement->fetch(PDO::FETCH_ASSOC); return Content::GetByAssoc($values); }
public static function GetByName($stringName, $language = null) { if ($language == null) { $language = Language::GetCurrent(); } if ($language == null) { return "@TRANSLATE['" . $stringName . "']@"; } global $MySQL; $query = "SELECT languagestring_StringValue FROM " . System::GetConfigurationValue("Database.TablePrefix") . "LanguageStrings WHERE languagestring_StringName = '" . $MySQL->real_escape_string($stringName) . "' AND languagestring_LanguageID = " . $language->ID; $result = $MySQL->query($query); if ($result === false) { return "@TRANSLATE['" . $stringName . "']@"; } $count = $result->num_rows; if ($count == 0) { return "@TRANSLATE['" . $stringName . "']@"; } $values = $result->fetch_array(); return $values[0]; }
/** * Sets the description of this TenantObject to the specified value for the given language. * @param Language $language The Language for which to set this description. * @param string $value The description to set. * @return boolean True if the operation completed successfully; false if the operation failed. */ public function SetDescription($language, $value) { if ($language == null) { $language = Language::GetCurrent(); } global $MySQL; $query = "SELECT COUNT(*) FROM " . System::$Configuration["Database.TablePrefix"] . "TenantObjectDescriptions WHERE entry_LanguageID = " . $language->ID . " AND entry_ObjectID = " . $this->ID; $result = $MySQL->query($query); if ($result === false) { return false; } $values = $result->fetch_array(); if (is_numeric($values[0]) && $values[0] > 0) { $query = "UPDATE " . System::$Configuration["Database.TablePrefix"] . "TenantObjectDescriptions SET entry_Value = '" . $MySQL->real_escape_string($value) . "' WHERE entry_LanguageID = " . $language->ID . " AND entry_ObjectID = " . $this->ID; $result = $MySQL->query($query); if ($result === false) { return false; } } else { $query = "INSERT INTO " . System::$Configuration["Database.TablePrefix"] . "TenantObjectDescriptions (entry_LanguageID, entry_ObjectID, entry_Value) VALUES (" . $language->ID . ", " . $this->ID . ", '" . $MySQL->real_escape_string($value) . "')"; $result = $MySQL->query($query); if ($result === false) { return false; } } return true; }