public function __construct()
{
if (defined('BACKEND') || defined('CRON') || defined('SITEMAP')) {
$this->parseUrl();
$this->languages = \Frontend\Db::getLanguages(true);
if (sizeof($this->languages) > 0) {
$this->currentLanguage = reset($this->languages);
}
} else {
$this->parseUrl();
$this->languages = \Frontend\Db::getLanguages(true);
if (sizeof($this->languages) == 0) {
trigger_error('All website languages are hidden.');
exit;
}
if ($this->languageUrl != null) {
foreach ($this->languages as $key => $language) {
if ($language['url'] == $this->languageUrl) {
$this->currentLanguage = $language;
}
}
if ($this->currentLanguage == null) {
$this->currentLanguage = reset($this->languages);
$this->error404();
}
} else {
$this->currentLanguage = reset($this->languages);
}
setlocale(LC_ALL, $this->currentLanguage['code']);
}
}
public function getSitemapInList()
{
global $site;
$answer = '';
$answer .= '<ul id="ipSitemap">' . "\n";
$answer .= '<li><a href="' . BASE_URL . '">Home</a></li>' . "\n";
$languages = \Frontend\Db::getLanguages(true);
//get all languages including hidden
foreach ($languages as $language) {
$link = $site->generateUrl($language['id']);
$answer .= '<li><a href="' . $link . '">' . htmlspecialchars($language['d_long']) . ' (' . htmlspecialchars($language['d_short']) . ')</a>' . "\n";
$zones = $site->getZones();
if (sizeof($zones) > 0) {
$answer .= '<ul>';
foreach ($zones as $key => $zone) {
$answer .= '<li><a href="' . $site->generateUrl($language['id'], $zone->getName()) . '">' . $zone->getTitle() . '</a>' . "\n";
$answer .= $this->getPagesList($language, $zone);
$answer .= '</li>' . "\n";
}
$answer .= '</ul>';
}
$answer .= '</li>' . "\n";
}
$answer .= '<ul>' . "\n";
$answer = str_replace('?cms_action=manage', '', $answer);
$answer = str_replace('&cms_action=manage', '', $answer);
return $answer;
}
public static function insertParameter($groupId, $parameter)
{
$sql = "insert into `" . DB_PREF . "parameter` \n set name = '" . mysql_real_escape_string($parameter['name']) . "',\n admin = '" . mysql_real_escape_string($parameter['admin']) . "',\n group_id = " . (int) $groupId . ",\n translation = '" . mysql_real_escape_string($parameter['translation']) . "',\n type = '" . mysql_real_escape_string($parameter['type']) . "'";
$rs = mysql_query($sql);
if ($rs) {
$last_insert_id = mysql_insert_id();
switch ($parameter['type']) {
case "string_wysiwyg":
$sql = "insert into `" . DB_PREF . "par_string` set `value` = '" . mysql_real_escape_string($parameter['value']) . "', `parameter_id` = " . $last_insert_id . "";
$rs = mysql_query($sql);
if (!$rs) {
trigger_error("Can't insert parameter " . $sql . " " . mysql_error());
}
break;
case "string":
$sql = "insert into `" . DB_PREF . "par_string` set `value` = '" . mysql_real_escape_string($parameter['value']) . "', `parameter_id` = " . $last_insert_id . "";
$rs = mysql_query($sql);
if (!$rs) {
trigger_error("Can't insert parameter " . $sql . " " . mysql_error());
}
break;
case "integer":
$sql = "insert into `" . DB_PREF . "par_integer` set `value` = " . mysql_real_escape_string($parameter['value']) . ", `parameter_id` = " . $last_insert_id . "";
$rs = mysql_query($sql);
if (!$rs) {
trigger_error("Can't insert parameter " . $sql . " " . mysql_error());
}
break;
case "bool":
$sql = "insert into `" . DB_PREF . "par_bool` set `value` = " . mysql_real_escape_string($parameter['value']) . ", `parameter_id` = " . $last_insert_id . "";
$rs = mysql_query($sql);
if (!$rs) {
trigger_error("Can't insert parameter " . $sql . " " . mysql_error());
}
break;
case "textarea":
$sql = "insert into `" . DB_PREF . "par_string` set `value` = '" . mysql_real_escape_string($parameter['value']) . "', `parameter_id` = " . $last_insert_id . "";
$rs = mysql_query($sql);
if (!$rs) {
trigger_error("Can't insert parameter " . $sql . " " . mysql_error());
}
break;
case "lang":
$languages = \Frontend\Db::getLanguages();
foreach ($languages as $key => $language) {
$sql3 = "insert into `" . DB_PREF . "par_lang` set `translation` = '" . mysql_real_escape_string($parameter['value']) . "', `language_id` = '" . $language['id'] . "', `parameter_id` = " . $last_insert_id . " ";
$rs3 = mysql_query($sql3);
if (!$rs3) {
trigger_error("Can't update parameter " . $sql3 . " " . mysql_error());
}
}
break;
case "lang_textarea":
$languages = \Frontend\Db::getLanguages();
foreach ($languages as $key => $language) {
$sql3 = "insert into `" . DB_PREF . "par_lang` set `translation` = '" . mysql_real_escape_string($parameter['value']) . "', `language_id` = '" . $language['id'] . "', `parameter_id` = " . $last_insert_id . " ";
$rs3 = mysql_query($sql3);
if (!$rs3) {
trigger_error("Can't update parameter " . $sql3 . " " . mysql_error());
}
}
break;
case "lang_wysiwyg":
$languages = \Frontend\Db::getLanguages();
foreach ($languages as $key => $language) {
$sql3 = "insert into `" . DB_PREF . "par_lang` set `translation` = '" . mysql_real_escape_string($parameter['value']) . "', `language_id` = '" . $language['id'] . "', `parameter_id` = " . $last_insert_id . " ";
$rs3 = mysql_query($sql3);
if (!$rs3) {
trigger_error("Can't update parameter " . $sql3 . " " . mysql_error());
}
}
break;
}
} else {
trigger_error($sql . " " . mysql_error());
}
}
