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