Bitte führen Sie die Installationsroutine aus und löschen anschließend die Datei aus dem Verzeichnis!
"; echo ""; exit(); } $shop = $templates_arry["shop"]; $shopzeit = $templates_arry["shopzeit"]; $shopmeldung = $templates_arry["shopmeldung"]; $shopmeldung1 = $shopmeldung; $shopmeldung = nl2br($shopmeldung); $TITLE1 = $templates_arry["title1"]; $TITLE2 = $templates_arry["title2"]; $BGCOLOR = $templates_arry["bgcolor"]; $FONTSIZE_TITLE2 = $templates_arry["fontsize_title2"]; $FONTCOLOR_TITLE2 = $templates_arry["fontcolor_title2"]; $FONTSIZE_TITLE3 = $templates_arry["fontsize_title3"]; $FONTCOLOR_TITLE3 = $templates_arry["fontcolor_title3"]; $FOOTER = $templates_arry["footer"]; $HOMEPAGE = $templates_arry["homepage"]; $EMAIL = $templates_arry["mailadresse"]; $FOOTER_SIZE = $templates_arry["footer_size"]; $FOOTER_COLOR = $templates_arry["footer_color"]; $STYLE1 = $templates_arry["style1"]; $STYLE2 = $templates_arry["style2"]; $TEXT = $templates_arry["text"]; $LINK = $templates_arry["link"]; $ALINK = $templates_arry["alink"]; $VLINK = $templates_arry["vlink"]; $FONTSIZE_NORMAL = $templates_arry["fontsize_normal"]; $TABLE_COLOR1 = $templates_arry["table_color1"]; $TABLE_COLOR2 = $templates_arry["table_color2"]; $ERROR_COLOR = $templates_arry["error_color"]; $ERFOLG_COLOR = $templates_arry["erfolg_color"]; $unternehmen = $templates_arry["unternehmen"]; $header = $templates_arry["header"]; $header_img = $templates_arry["header_img"]; $header_text = $templates_arry["header_text"]; $FONTSIZE_HEADER = $templates_arry["fontsize_header"]; $FONTCOLOR_HEADER = $templates_arry["fontcolor_header"]; $waehrung = $templates_arry["waehrung"]; $variante_name1 = $templates_arry["variante_name1"]; $variante_name2 = $templates_arry["variante_name2"]; $table_align = $templates_arry["table_align"]; $table_width = $templates_arry["table_width"]; $AGBS = $templates_arry["agbs"]; $status_green = $templates_arry["status_green"]; $status_yellow = $templates_arry["status_yellow"]; $status_red = $templates_arry["status_red"]; $ds_anzahl = $templates_arry["ds_anzahl"]; $mindermengenaufschlag = $templates_arry["mindermengenaufschlag"]; $mindestbestellpreis = $templates_arry["mindestbestellpreis"]; $mailheader = html_entity_decode($templates_arry["mailheader"]); $mailfooter = html_entity_decode($templates_arry["mailfooter"]); $mehrwertsteuer = $templates_arry["mehrwertsteuer"]; $mailadresse_mail = $templates_arry["mailadresse_mail"]; $widerrufsrecht = $templates_arry["widerrufsrecht"]; // Variablen Deklaration if (!isset($_GET['nr'])) $_GET['nr'] = ""; if (!isset($_GET['main_kat'])) $_GET['main_kat'] = ""; if (!isset($_GET['kategorie'])) $_GET['kategorie'] = ""; if (!isset($_GET['action'])) $_GET['action'] = ""; if (!isset($_GET['start'])) $_GET['start'] = 0; if (!isset($_GET['next_start'])) $_GET['next_start'] = 0; $post_vars= array(); $get_vars = array(); $_GET['nr'] = htmlentities($_GET['nr']); $_GET['main_kat'] = htmlentities($_GET['main_kat']); $_GET['kategorie'] = htmlentities($_GET['kategorie']); $_GET['action'] = htmlentities($_GET['action']); $_GET['start'] = htmlentities($_GET['start']); $_GET['next_start'] = htmlentities($_GET['next_start']); $get_vars['nr'] = htmlentities($_GET['nr']); $get_vars['main_kat'] = htmlentities($_GET['main_kat']); $get_vars['kategorie'] = htmlentities($_GET['kategorie']); $get_vars['action'] = htmlentities($_GET['action']); $get_vars['start'] = htmlentities($_GET['start']); $get_vars['next_start'] = htmlentities($_GET['next_start']); // Nummer check $_GET['nr'] = filter_input(INPUT_GET, 'nr', FILTER_SANITIZE_STRING); $_GET['nr'] = substr($_GET['nr'], 0, 50); //Schutz SQL-Injection - nur die ersten Stellen $i = 0; $sql = "select * from SHOP_Session where id=:nr"; $stmt = $db->prepare($sql); $stmt->bindValue(':nr',$_GET['nr']); $stmt->execute(); while($row = $stmt->fetch()) { $sSearchIn = $row["searchin"]; $sSearchTxt = $row["txt_search"]; $sSortOrder = $row["sortorder"]; $i++; } if ($i == 0) $_GET['nr'] = ""; } ?> class taggenerator { public $db; public $arrTags; public function __construct($db) { $this->db = $db; } protected function select_spart($page,$object_id) { if ($page=='subcat') { $sql = "SELECT * FROM SHOP_Hauptgruppen WHERE id='".$object_id."'"; foreach($this->db->query($sql) as $row) { if (empty($row['title'])) $this->arrTags['title'] = $row['name']; else $this->arrTags['title'] = $row['title']; if (empty($row['meta_keywords'])) $this->arrTags['meta_keywords'] = $row['name']; else $this->arrTags['meta_keywords'] = $row['meta_keywords']; if (empty($row['meta_description'])) $this->arrTags['meta_description'] = $row['name']; else $this->arrTags['meta_description'] = $row['meta_description']; if (empty($row['copytext'])) $this->arrTags['copytext'] = '© Versandhaus Neumeyer-Abzeichen: '.$row['name']; else $this->arrTags['copytext'] = $row['copytext']; } } elseif ($page=='details') { $sql = "SELECT * FROM SHOP_Artikel WHERE id='".$object_id."'"; foreach($this->db->query($sql) as $row) { if (empty($row['title'])) $this->arrTags['title'] = $row['name']; else $this->arrTags['title'] = $row['title']; if (empty($row['meta_keywords'])) $this->arrTags['meta_keywords'] = $row['name']; else $this->arrTags['meta_keywords'] = $row['meta_keywords']; if (empty($row['meta_description'])) $this->arrTags['meta_description'] = $row['name']; else $this->arrTags['meta_description'] = $row['meta_description']; if (empty($row['copytext'])) $this->arrTags['copytext'] = '© Versandhaus Neumeyer-Abzeichen: '.$row['name']; else $this->arrTags['copytext'] = $row['copytext']; } } elseif (substr($page, 0,8)=='standard') { $page = substr($page, 9); $sql = "SELECT * FROM SHOP_Bereiche WHERE name='".$page."'"; foreach($this->db->query($sql) as $row) { if (empty($row['title'])) $this->arrTags['title'] = $row['name']; else $this->arrTags['title'] = $row['title']; if (empty($row['meta_keywords'])) $this->arrTags['meta_keywords'] = $row['name']; else $this->arrTags['meta_keywords'] = $row['meta_keywords']; if (empty($row['meta_description'])) $this->arrTags['meta_description'] = $row['name']; else $this->arrTags['meta_description'] = $row['meta_description']; if (empty($row['copytext'])) $this->arrTags['copytext'] = '© Versandhaus Neumeyer-Abzeichen: '.$row['name']; else $this->arrTags['copytext'] = $row['copytext']; } } elseif ($page!='subcat' OR $page!='details') { $sql = "SELECT * FROM SHOP_Taggenerator WHERE page = '".$page."'"; foreach($this->db->query($sql) as $row) { $this->arrTags['title'] = $row['title']; $this->arrTags['meta_keywords'] = $row['meta_keywords']; $this->arrTags['meta_description'] = $row['meta_description']; $this->arrTags['abschlusstext'] = $row['abschlusstext']; $this->arrTags['copytext'] = $row['copytext']; } } } public function title($page,$object_id) { $this->select_spart($page,$object_id); echo $this->arrTags['title']; } public function meta_keywords($page,$object_id) { $this->select_spart($page,$object_id); echo $this->arrTags['meta_keywords']; } public function meta_description($page,$object_id) { $this->select_spart($page,$object_id); echo $this->arrTags['meta_description']; } public function abschlusstext($page,$object_id) { $this->select_spart($page,$object_id); $this->arrTags['abschlusstext'] = html_entity_decode($this->arrTags['abschlusstext']); echo $this->arrTags['abschlusstext']; } public function copytext($page,$object_id) { $this->select_spart($page,$object_id); echo $this->arrTags['copytext']; } } ?>