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