WebSVN – lars-tiefland.ci – Diff – /frontend/helpers/weban_helper.php

 <?php
-// $Id: weban_helper.php 2011 2017-02-04 23:30:38Z lars $
+// $Id: weban_helper.php 2117 2017-11-11 20:56:38Z lars $
-if (!defined("CONTINUE_ON_ERROR"))
 if (!defined("CONTINUE_ON_ERROR")) {
-	define("CONTINUE_ON_ERROR", false);
+    define("CONTINUE_ON_ERROR", false);
-}
-if (!defined("CRON"))
+}
-{
-	if (php_sapi_name() == "cli")
+if (!defined("CRON")) {
-	{
-		define("CRON", true);
+    if (php_sapi_name() == "cli") {
-	}
-	else
+        define("CRON", true);
-	{
+    } else {
-		define("CRON", false);
+        define("CRON", false);
-	}
+    }
 }
-if (!defined("EOL"))
-{
-	if (php_sapi_name() == "cli")
+if (!defined("EOL")) {
-	{
-		define("EOL", "\n");
+    if (php_sapi_name() == "cli") {
-	}
-	else
+        define("EOL", "\n");
-	{
+    } else {
-		define("EOL", "<br>");
+        define("EOL", "<br>");
+    }
 }
 $GLOBALS['ci'] = &get_instance();
-$GLOBALS['order_db'] = $GLOBALS['ci']->load->database('order_db', TRUE);
+$GLOBALS['order_db'] = $GLOBALS['ci']->load->database('order_db', true);
-$GLOBALS['db_red'] = $GLOBALS['ci']->load->database('db_red', TRUE);
+$GLOBALS['db_red'] = $GLOBALS['ci']->load->database('db_red', true);
 $GLOBALS['ci']->load->model('artikel_model', 'artikel');
 $domain = "faltradxxs.de";
 $GLOBALS["Eigenschaften"] = getVersandEigenschaften($domain);
 $GLOBALS["web_rechte"] = getWebRechte($domain);
 isWeban();
 $GLOBALS["zahlsysteme"] = array(
-	"kreditkarte",
+    "kreditkarte",
-	"paypal",
+    "paypal",
-	"sofortueberweisung",
+    "sofortueberweisung",
-	"frei",
+    "frei",
-	"finanzierung",
+    "finanzierung",
-	"billsafe",
+    "billsafe",
-	"billsafe_hire",
+    "billsafe_hire",
-	"amazon",
+    "amazon",
-	"PayPalExpress",
+    "PayPalExpress",
-	"Ratenzahlung",
+    "Ratenzahlung",
-	"PayPalPlus",
+    "PayPalPlus",
-	"paymill",
+    "paymill",
-	);
+    );
 //Excellence Käuferschutz
 $GLOBALS["tsItems"] = array(
-	"TS080501_500_30_EUR" => array(
+    "TS080501_500_30_EUR" => array(
-		"max" => 500,
+        "max" => 500,
-		"preis" => 0.82353,
+        "preis" => 0.82353,
-		),
+        ),
-	"TS080501_1500_30_EUR" => array(
+    "TS080501_1500_30_EUR" => array(
-		"max" => 1500,
+        "max" => 1500,
-		"preis" => 2.47059,
+        "preis" => 2.47059,
-		),
+        ),
-	"TS080501_2500_30_EUR" => array(
+    "TS080501_2500_30_EUR" => array(
-		"max" => 2500,
+        "max" => 2500,
-		"preis" => 4.11765,
+        "preis" => 4.11765,
-		),
+        ),
-	"TS080501_5000_30_EUR" => array(
+    "TS080501_5000_30_EUR" => array(
-		"max" => 5000,
+        "max" => 5000,
-		"preis" => 8.23530,
+        "preis" => 8.23530,
-		),
+        ),
-	"TS080501_1000_30_EUR" => array(
+    "TS080501_1000_30_EUR" => array(
-		"max" => 1000,
+        "max" => 1000,
-		"preis" => 16.47060,
+        "preis" => 16.47060,
-		),
+        ),
-	"TS080501_20000_30_EUR" => array(
+    "TS080501_20000_30_EUR" => array(
-		"max" => 20000,
+        "max" => 20000,
-		"preis" => 31.94120,
+        "preis" => 31.94120,
-		),
+        ),
-	);
+    );
 $GLOBALS["tsMethods"] = array(
-	"paypal" => "PAYPAL",
+    "paypal" => "PAYPAL",
-	"PayPalPlus" => "PAYPAL",
+    "PayPalPlus" => "PAYPAL",
-	"billsafe" => "INVOICE",
+    "billsafe" => "INVOICE",
-	"nachnahme" => "CASH_ON_DELIVERY",
+    "nachnahme" => "CASH_ON_DELIVERY",
-	"kreditkarte" => "CREDIT_CARD",
+    "kreditkarte" => "CREDIT_CARD",
-	"selbstabholung" => "CASH_ON_PICKUP",
+    "selbstabholung" => "CASH_ON_PICKUP",
-	"sofortueberweisung" => "DIECT_E_BANKING",
+    "sofortueberweisung" => "DIECT_E_BANKING",
-	"vorkasse" => "PREPAYMENT",
+    "vorkasse" => "PREPAYMENT",
-	);
+    );
 //Excellence Käuferschutz - ENDE
 /**
  * @author Lars Tiefland
  * @copyright 2016
  */
-function getVersandLaender()
-{
+function getVersandLaender()
-	// ME: Länder raus, und die bit-Schiebeoperation ungestört durchzählen lasssen
+{
-	// LT: für Smarty umgebaut
-	$forbiddenLands = array();
+    // ME: Länder raus, und die bit-Schiebeoperation ungestört durchzählen lasssen
-	if (table_exists("bestelladresse", $GLOBALS["INI"]["dbConnect"]["order_db"]) &&
+    // LT: für Smarty umgebaut
-		$GLOBALS["INI"]["modules"]["adresssystem"] == "neu")
+    $forbiddenLands = array();
-	{
+    if (table_exists("bestelladresse", $GLOBALS["INI"]["dbConnect"]["order_db"]) &&
-		$old = false;
+        $GLOBALS["INI"]["modules"]["adresssystem"] == "neu") {
-		if (table_exists("shippinggroups"))
-		{
+        $old = false;
-			$cTable = "countries";
+        if (table_exists("shippinggroups")) {
-			$cField = "`name-ger";
+            $cTable = "countries";
-			$coTable = "cotinents";
+            $cField = "`name-ger";
-			$coField = "name_de";
+            $coTable = "cotinents";
-			if (table_exists("countries"))
+            $coField = "name_de";
             if (table_exists("countries")) {
-				$cField = "country";
+                $cField = "country";
-				$cTable = $GLOBALS["INI"]["dbConnect"]["database"].".".$cTable;
+                $cTable = $GLOBALS["INI"]["dbConnect"]["database"] . "." . $cTable;
-				$coTable = "";
+                $coTable = "";
-				$coField = "continent";
+                $coField = "continent";
-			}
+            }
-			$sql = "SELECT
+            $sql = "SELECT
                         c.id,
                         c.shipping,
-                        ".$coField." AS continent,
+                        " . $coField . " AS continent,
-                        c.".$cField." AS country
+                        c." . $cField . " AS country
                     FROM
-                        ".$cTable." c
+                        " . $cTable . " c
-                    JOIN
-                        ".$GLOBALS["INI"]["dbConnect"]["database"].
+                    JOIN
-				".shippinggroups sg
+                        " . $GLOBALS["INI"]["dbConnect"]["database"] .
-                    ON
+                ".shippinggroups sg
-                        sg.id = c.shipping
+                    ON
-                ";
+                        sg.id = c.shipping
-			if ($coTable)
+                ";
-			{
+            if ($coTable) {
-				$sql .= "
-                        JOIN
+                $sql .= "
-                            ".$coTable."
-                        ON
+                        JOIN
-                            co.id=c.continent
+                            " . $coTable . "
-                    ";
+                        ON
                             co.id=c.continent
                     ";
 		else
         } else {
-			$old = true;
+            $old = true;
-			$sql = "SELECT
+            $sql = "SELECT
 					id,
 					weban_lcode,
 					`name-ger` AS country
 				FROM
-					content_management.countries
-				WHERE
+					content_management.countries
-					weban_lcode!=''
+				WHERE
-			";
-		}
+					weban_lcode!=''
-		$res = $GLOBALS["db_red"]->query($sql);
-		while ($row = $res->unbuffered_row('array'))
+			";
-		{
+        }
-			$land_name = $row["country"];
+        $res = $GLOBALS["db_red"]->query($sql);
-			if (!in_array($land_name, $forbiddenLands))
+        while ($row = $res->unbuffered_row('array')) {
-			{
-				if ($old === true)
+            $land_name = $row["country"];
-				{
+            if (!in_array($land_name, $forbiddenLands)) {
-					$land = $row["weban_lcode"];
+                if ($old === true) {
-					$gewicht = 0;
+                    $land = $row["weban_lcode"];
-					$preis = 0;
+                    $gewicht = 0;
-					if (isset($_SESSION['SHOP']['SUMME']) && $_SESSION['SHOP']['SUMME'])
+                    $preis = 0;
                     if (isset($_SESSION['SHOP']['SUMME']) && $_SESSION['SHOP']['SUMME']) {
-						$preis = $_SESSION['SHOP']['SUMME'];
+                        $preis = $_SESSION['SHOP']['SUMME'];
-					}
+                    }
-					// gibt es für dieses Land Versandoptionen?
+                    // gibt es für dieses Land Versandoptionen?
-					$sql = "SELECT
+                    $sql = "SELECT
                                 ID
                             FROM
                                 artikel
                             WHERE
-                                Lieferstatus & ".$land." = ".$land."
-                            AND
+                                Lieferstatus & " . $land . " = " . $land . "
-                                Father=-3
+                            AND
-                            AND
+                                Father=-3
-                                status = ".$GLOBALS['INI']['shops_ID']."
+                            AND
-                        ";
+                                status = " . $GLOBALS['INI']['shops_ID'] . "
                         ";
 					if (isset($_SESSION['SHOP']['BASKET']) && count($_SESSION["SHOP"]["BASKET"]))
                     if (isset($_SESSION['SHOP']['BASKET']) && count($_SESSION["SHOP"]["BASKET"])) {
-						$sql .= "
+                        $sql .= "
                                 AND
+                                (
-                                    (".$gewicht.
+                                    (" . $gewicht .
-							" between preis_neu1 and preis_neu2)
+                            " between preis_neu1 and preis_neu2)
+                                )
                                 AND
                                 (
-                                    (".$preis.
-							" BETWEEN preis_neu3 AND preis_neu4)
+                                    (" . $preis .
-                                    OR
-                                    (preis_neu3=preis_neu4)
+                            " BETWEEN preis_neu3 AND preis_neu4)
-                                )
-                            ";
+                                    OR
-					}
-					if (isset($_SESSION['SHOP']['BASKET']) && count($_SESSION["SHOP"]["BASKET"]))
+                                    (preis_neu3=preis_neu4)
-					{
-						foreach ($GLOBALS["Eigenschaften"] as $nr)
+                                )
                             ";
 							if (Eigenschaft($nr) == true)
                     if (isset($_SESSION['SHOP']['BASKET']) && count($_SESSION["SHOP"]["BASKET"])) {
-								$sql .= " AND Eigenschaft_$nr = 1 ";
+                        foreach ($GLOBALS["Eigenschaften"] as $nr) {
                             if (Eigenschaft($nr) == true) {
-							else
+                                $sql .= " AND Eigenschaft_$nr = 1 ";
                             } else {
-								$sql .= "
+                                $sql .= "
                                         AND
                                         (
                                             (Eigenschaft_$nr = 0)
                                             OR
                                             (Eigenschaft_$nr IS NULL)
                                         )
-                                    ";
-							}
+                                    ";
-						}
+                            }
-					}
+                        }
+                    }
-					$q = $GLOBALS['ci']->db->query($sql);
-					if ($q)
-					{
-						$n = $q->row_array();
+                    $q = $GLOBALS['ci']->db->query($sql);
-						if ($n)
+                    if ($q) {
-						{
+                        $n = $q->row_array();
-							if ($GLOBALS["INI"]["charset"] == "utf-8" && $GLOBALS["INI"]["dbConnect"]["db_is_utf8"] !=
-)
+                        if ($n) {
-							{
-								$land_name = utf8_encode($land_name);
+                            if ($GLOBALS["INI"]["charset"] == "utf-8" && $GLOBALS["INI"]["dbConnect"]["db_is_utf8"] !=
-							}
+) {
-							$laender[$row["id"]] = $land_name;
+                                $land_name = utf8_encode($land_name);
+                            }
                             $laender[$row["id"]] = $land_name;
+                        }
-				else
+                    }
                 } else {
-					$continent = $row["continent"];
+                    $continent = $row["continent"];
-					$sql = "SELECT
+                    $sql = "SELECT
                                 ID
                             FROM
                                 artikel
-                            WHERE
-                                kennung =  ".$row["shipping"]."
+                            WHERE
-                            AND
+                                kennung =  " . $row["shipping"] . "
-                                Father=-3
+                            AND
-                            AND
+                                Father=-3
-                                status = ".$GLOBALS['INI']['shops_ID']."
+                            AND
-                        ";
+                                status = " . $GLOBALS['INI']['shops_ID'] . "
                         ";
 					if (count($_SESSION["SHOP"]["BASKET"]))
-					{
+                    if (count($_SESSION["SHOP"]["BASKET"])) {
-						$sql .= "
+                        $sql .= "
                                 AND
+                                (
-                                    (".$gewicht.
+                                    (" . $gewicht .
-							" between preis_neu1 and preis_neu2)
+                            " between preis_neu1 and preis_neu2)
                                 )
                                 AND
-                                (
-                                    (".$preis.
+                                (
-							" BETWEEN preis_neu3 AND preis_neu4)
-                                    OR
+                                    (" . $preis .
-                                    (preis_neu3=preis_neu4)
-                                )
+                            " BETWEEN preis_neu3 AND preis_neu4)
-                            ";
-					}
+                                    OR
-					if (count($_SESSION["SHOP"]["BASKET"]))
-					{
+                                    (preis_neu3=preis_neu4)
 						foreach ($GLOBALS["Eigenschaften"] as $nr)
                             ";
 							if (Eigenschaft($nr) == true)
                     if (count($_SESSION["SHOP"]["BASKET"])) {
-								$sql .= " AND Eigenschaft_$nr = 1 ";
+                        foreach ($GLOBALS["Eigenschaften"] as $nr) {
                             if (Eigenschaft($nr) == true) {
-							else
+                                $sql .= " AND Eigenschaft_$nr = 1 ";
-							{
+                            } else {
-								$sql .= "
+                                $sql .= "
                                         AND
                                         (
                                             (Eigenschaft_$nr = 0)
                                             OR
                                             (Eigenschaft_$nr IS NULL)
-                                        )
-                                    ";
+                                        )
-							}
+                                    ";
-						}
-					}
+                            }
+                        }
-					$q = mysql_query($sql);
+                    }
-					if ($q)
-					{
-						$n = mysql_num_rows($q);
+                    $q = mysql_query($sql);
-						if ($n)
+                    if ($q) {
-						{
+                        $n = mysql_num_rows($q);
-							if ($GLOBALS["INI"]["charset"] == "utf-8" && $GLOBALS["INI"]["dbConnect"]["order_db_is_utf8"] !=
+                        if ($n) {
-)
+                            if ($GLOBALS["INI"]["charset"] == "utf-8" && $GLOBALS["INI"]["dbConnect"]["order_db_is_utf8"] !=
-							{
+) {
-								$land_name = utf8_encode($land_name);
-								$continent = utf8_encode($continent);
+                                $land_name = utf8_encode($land_name);
-							}
-							$laender[$continent][$row["id"]] = $land_name;
+                                $continent = utf8_encode($continent);
-						}
-					}
+                            }
-				}
+                            $laender[$continent][$row["id"]] = $land_name;
-			}
+                        }
-		}
+                    }
-	}
+                }
-	else
+            }
-	{
-		for ($i = 0; $i < 64; $i++)
+        }
-		{
+    } else {
-			$land = 1 << $i;
+        for ($i = 0; $i < 64; $i++) {
-			$land_name = getCountryById($land);
+            $land = 1 << $i;
-			if ($land_name)
+            $land_name = getCountryById($land);
             if ($land_name) {
 				if (!in_array($land_name, $forbiddenLands))
-				{
+                if (!in_array($land_name, $forbiddenLands)) {
-					$gewicht = getBasketGewicht();
+                    $gewicht = getBasketGewicht();
-					$preis = getBasketSumme();
+                    $preis = getBasketSumme();
-					// gibt es für dieses Land Versandoptionen?
+                    // gibt es für dieses Land Versandoptionen?
-					$sql = "SELECT
+                    $sql = "SELECT
                                 ID
-                            FROM
-                                artikel
+                            FROM
-                            WHERE
+                                artikel
-                                Lieferstatus & ".$land." = ".$land."
+                            WHERE
-                            AND
+                                Lieferstatus & " . $land . " = " . $land . "
-                                Father=-3
+                            AND
-                            AND
+                                Father=-3
-                                status = ".$GLOBALS['INI']['shops_ID']."
+                            AND
-                        ";
+                                status = " . $GLOBALS['INI']['shops_ID'] . "
+                        ";
-					if (count($_SESSION["SHOP"]["BASKET"]))
                     if (count($_SESSION["SHOP"]["BASKET"])) {
-						$sql .= "
+                        $sql .= "
                                 AND
+                                (
-                                    (".$gewicht.
+                                    (" . $gewicht .
-							" between preis_neu1 and preis_neu2)
+                            " between preis_neu1 and preis_neu2)
-                                )
-                                AND
+                                )
-                                (
-                                    (".$preis.
+                                AND
-							" BETWEEN preis_neu3 AND preis_neu4)
-                                    OR
+                                (
-                                    (preis_neu3=preis_neu4)
-                                )
+                                    (" . $preis .
-                            ";
-					}
+                            " BETWEEN preis_neu3 AND preis_neu4)
-					if (count($_SESSION["SHOP"]["BASKET"]))
+                                    OR
                                     (preis_neu3=preis_neu4)
 						foreach ($GLOBALS["Eigenschaften"] as $nr)
                             ";
 							if (Eigenschaft($nr) == true)
                     if (count($_SESSION["SHOP"]["BASKET"])) {
-								$sql .= " AND Eigenschaft_$nr = 1 ";
+                        foreach ($GLOBALS["Eigenschaften"] as $nr) {
-							}
+                            if (Eigenschaft($nr) == true) {
-							else
+                                $sql .= " AND Eigenschaft_$nr = 1 ";
-							{
+                            } else {
-								$sql .= "
+                                $sql .= "
                                         AND
                                         (
                                             (Eigenschaft_$nr = 0)
-                                            OR
-                                            (Eigenschaft_$nr IS NULL)
+                                            OR
-                                        )
+                                            (Eigenschaft_$nr IS NULL)
-                                    ";
-							}
+                                        )
-						}
+                                    ";
-					}
+                            }
+                        }
+                    }
-					$q = mysql_query($sql);
-					if ($q)
-					{
-						$n = mysql_num_rows($q);
+                    $q = mysql_query($sql);
-						if ($n)
+                    if ($q) {
-						{
+                        $n = mysql_num_rows($q);
-							$shopsNoEncode = array(
+                        if ($n) {
-								"ababum.de",
+                            $shopsNoEncode = array(
-								"etoh24.de",
+                                "ababum.de",
-								);
+                                "etoh24.de",
-							if ($GLOBALS["INI"]["charset"] == "utf-8" && !in_array(__SHOP__, $shopsNoEncode))
+                                );
-							{
-								$land_name = utf8_encode($land_name);
+                            if ($GLOBALS["INI"]["charset"] == "utf-8" && !in_array(__SHOP__, $shopsNoEncode)) {
-							}
-							$laender[$land] = ($land_name);
+                                $land_name = utf8_encode($land_name);
-						}
-					}
+                            }
-				}
+                            $laender[$land] = ($land_name);
-			}
+                        }
+                    }
+                }
 	if (is_array($laender))
-	{
+        }
-		$laender = array_unique($laender);
+    }
-	}
-	else
+    if (is_array($laender)) {
-	{
+        $laender = array_unique($laender);
-		$laender = array();
+    } else {
-	}
+        $laender = array();
-	return $laender;
-}
+    }
-function table_exists($table, $db = null, $c = null)
+    return $laender;
-{
+}
-	$ini = $GLOBALS['INI'];
-	if ($db)
-	{
-		$db = trim($db, '.');
-	}
+function table_exists($table, $db = null, $c = null)
-	if (!$c)
-	{
+{
-		$conn = $GLOBALS['order_db'];
-	}
+    $ini = $GLOBALS['INI'];
-	else
+    if ($db) {
-	{
+        $db = trim($db, '.');
-		$conn = $c;
+    }
     if (!$c) {
-	if (!$db || $db == $ini["dbConnect"]["database"])
+        $conn = $GLOBALS['order_db'];
     } else {
-		$db = $ini["dbConnect"]["database"];
+        $conn = $c;
-		if (!$c)
+    }
     if (!$db || $db == $ini["dbConnect"]["database"]) {
-			$conn = $GLOBALS['ci']->db;
+        $db = $ini["dbConnect"]["database"];
         if (!$c) {
-		else
+            $conn = $GLOBALS['ci']->db;
-		{
+        } else {
-			$conn = $c;
-		}
+            $conn = $c;
-	}
+        }
-	$sql = "SELECT
+    }
-            engine
+    $sql = "SELECT
-        FROM
+            engine
-            information_schema.TABLES
+        FROM
-        WHERE
+            information_schema.TABLES
-            table_name='".$table."'
+        WHERE
-        AND
-            table_schema='".$db."'
+            table_name='" . $table . "'
-    ";
+        AND
-	$res = $conn->query($sql);
+            table_schema='" . $db . "'
-	if ($res->num_rows())
-	{
+    ";
-		return true;
-	}
+    $res = $conn->query($sql);
-	return false;
-}
+    if ($res->num_rows()) {
+        return true;
-function column_exists($table, $column, $db = null, $c = null)
+    }
-{
-	$ini = $GLOBALS['INI'];
+    return false;
-	if ($db)
+}
-	{
-		$db = trim($db, '.');
-	}
-	if (!$c)
+function column_exists($table, $column, $db = null, $c = null)
-	{
-		$conn = $GLOBALS['order_db'];
+{
-	}
+    $ini = $GLOBALS['INI'];
-	else
+    if ($db) {
-	{
+        $db = trim($db, '.');
-		$conn = $c;
+    }
-	}
+    if (!$c) {
-	if (!$db || $db == $ini["dbConnect"]["database"])
-	{
+        $conn = $GLOBALS['order_db'];
-		$db = $ini["dbConnect"]["database"];
+    } else {
-		if (!$c)
+        $conn = $c;
+    }
-			$conn = $GLOBALS['ci']->db;
+    if (!$db || $db == $ini["dbConnect"]["database"]) {
-		}
+        $db = $ini["dbConnect"]["database"];
-		else
+        if (!$c) {
-		{
+            $conn = $GLOBALS['ci']->db;
-			$conn = $c;
+        } else {
-		}
+            $conn = $c;
+        }
+    }
-	$t_exists = table_exists($table, $db, $conn);
-	if ($t_exists)
-	{
+    $t_exists = table_exists($table, $db, $conn);
-		$sql = "SELECT
+    if ($t_exists) {
-                    data_type
+        $sql = "SELECT
-                FROM
+                    data_type
-                    information_schema.COLUMNS
+                FROM
-                WHERE
+                    information_schema.COLUMNS
-                    column_name='".$column."'
+                WHERE
-                AND
+                    column_name='" . $column . "'
-                    table_name='".$table."'
+                AND
  * @param mixed $c
  * @return
  */
 function getColumnInfo($table, $column, $db = null, $c = null)
+{
-	global $remoteServer_dbh, $localhost_dbh;
+    global $remoteServer_dbh, $localhost_dbh;
-	if (!is_array($_SESSION["INI"]))
+    if (!is_array($_SESSION["INI"])) {
-	{
-		$ini = $GLOBALS["INI"];
+        $ini = $GLOBALS["INI"];
-	}
-	else
+    } else {
-	{
-		$ini = $_SESSION["INI"];
+        $ini = $_SESSION["INI"];
-	}
+    }
-	if ($db)
+    if ($db) {
-	{
-		$db = trim($db, '.');
+        $db = trim($db, '.');
-	}
+    }
-	if (!$c)
+    if (!$c) {
-	{
-		if (__USE_MDB2__ === true)
+        if (__USE_MDB2__ === true) {
-		{
-			$conn = $GLOBALS["order_db"];
+            $conn = $GLOBALS["order_db"];
-		}
-		elseif (is_resource($GLOBALS["order_dbh"]))
+        } elseif (is_resource($GLOBALS["order_dbh"])) {
-		{
-			$conn = $GLOBALS["order_dbh"];
+            $conn = $GLOBALS["order_dbh"];
-		}
-		elseif (is_resource($remoteServer_dbh))
+        } elseif (is_resource($remoteServer_dbh)) {
-		{
-			$conn = $remoteServer_dbh;
+            $conn = $remoteServer_dbh;
-		}
+        }
-	}
-	else
+    } else {
-	{
-		$conn = $c;
+        $conn = $c;
-	}
+    }
-	if (!$db || $db == $ini["dbConnect"]["database"])
+    if (!$db || $db == $ini["dbConnect"]["database"]) {
-	{
-		$db = $ini["dbConnect"]["database"];
+        $db = $ini["dbConnect"]["database"];
-		if (!$c)
+        if (!$c) {
-		{
-			if (__USE_MDB2__ === true)
+            if (__USE_MDB2__ === true) {
-			{
-				$conn = $GLOBALS["db"];
+                $conn = $GLOBALS["db"];
-			}
-			elseif (is_resource($GLOBALS["dbh"]))
+            } elseif (is_resource($GLOBALS["dbh"])) {
-			{
-				$conn = $GLOBALS["dbh"];
+                $conn = $GLOBALS["dbh"];
-			}
-			elseif (is_resource($localhost_dbh))
+            } elseif (is_resource($localhost_dbh)) {
-			{
-				$conn = $localhost_dbh;
+                $conn = $localhost_dbh;
-			}
+            }
-		}
-		else
+        } else {
-		{
-			$conn = $c;
+            $conn = $c;
-		}
+        }
-	}
+    }
-	if (column_exists($table, $column, $db, $conn))
+    if (column_exists($table, $column, $db, $conn)) {
-	{
-		//Hole Informationen zur Spalte
+        //Hole Informationen zur Spalte
-		$sql = "SELECT
+        $sql = "SELECT
+                    *
                 FROM
                     information_schema.COLUMNS
                 WHERE
-                    column_name='".$column."'
+                    column_name='" . $column . "'
                 AND
-                    table_name='".$table."'
+                    table_name='" . $table . "'
                 AND
-                    table_schema='".$db."'
+                    table_schema='" . $db . "'
             ";
-		if (__USE_MDB2__ === true)
-		{
+        if (__USE_MDB2__ === true) {
-			$res = $conn->query($sql);
+            $res = $conn->query($sql);
-			if ($res->numRows())
-			{
+            if ($res->numRows()) {
-				$row = $res->fetchRow();
+                $row = $res->fetchRow();
-			}
-		}
+            }
-		else
-		{
+        } else {
-			$res = mysql_query($sql, $conn);
+            $res = mysql_query($sql, $conn);
-			if (mysql_num_rows($res))
-			{
+            if (mysql_num_rows($res)) {
-				$row = mysql_fetch_assoc($res);
+                $row = mysql_fetch_assoc($res);
-			}
+            }
-		}
+        }
-		$t = getTableInfo($table, $db, $conn);
+        $t = getTableInfo($table, $db, $conn);
-		$row["engine"] = $t["ENGINE"];
+        $row["engine"] = $t["ENGINE"];
-		if ($row["engine"] == "InnoDB")
-		{
+        if ($row["engine"] == "InnoDB") {
-			//Hole Informationen zu einem definierten Fremdschl?ssel
+            //Hole Informationen zu einem definierten Fremdschl?ssel
-			$sql = "SELECT
+            $sql = "SELECT
                         REFERENCED_TABLE_SCHEMA,
                         REFERENCED_TABLE_NAME,
                         REFERENCED_COLUMN_NAME,
                         CONSTRAINT_NAME
                     FROM
                         information_schema.KEY_COLUMN_USAGE
                     WHERE
-                        column_name='".$column."'
+                        column_name='" . $column . "'
                     AND
-                        table_name='".$table."'
+                        table_name='" . $table . "'
                     AND
-                        table_schema='".$db."'
+                        table_schema='" . $db . "'
                 ";
-			if (__USE_MDB2__ === true)
-			{
+            if (__USE_MDB2__ === true) {
-				$res = $conn->query($sql);
+                $res = $conn->query($sql);
-				if ($res->numRows())
-				{
+                if ($res->numRows()) {
-					$row_k = $res->fetchRow();
+                    $row_k = $res->fetchRow();
-				}
-			}
+                }
-			else
-			{
+            } else {
-				$res = mysql_query($sql, $conn);
+                $res = mysql_query($sql, $conn);
-				if (mysql_num_rows($res))
-				{
+                if (mysql_num_rows($res)) {
-					$row_k = mysql_fetch_assoc($res);
+                    $row_k = mysql_fetch_assoc($res);
-				}
+                }
-			}
+            }
-			if (is_array($row_k))
-			{
+            if (is_array($row_k)) {
-				$row = array_merge($row, $row_k);
+                $row = array_merge($row, $row_k);
-			}
+            }
-		}
+        }
-	}
+    }
-	return $row;
+    return $row;
+}
  * @param mixed $c
  * @return
  */
 function getTableInfo($table, $db = null, $c = null)
+{
-	global $remoteServer_dbh, $localhost_dbh;
+    global $remoteServer_dbh, $localhost_dbh;
-	if (!is_array($_SESSION["INI"]))
+    if (!is_array($_SESSION["INI"])) {
-	{
-		$ini = $GLOBALS["INI"];
+        $ini = $GLOBALS["INI"];
-	}
-	else
+    } else {
-	{
-		$ini = $_SESSION["INI"];
+        $ini = $_SESSION["INI"];
-	}
+    }
-	if ($db)
+    if ($db) {
-	{
-		$db = trim($db, '.');
+        $db = trim($db, '.');
-	}
+    }
-	if (!$c)
+    if (!$c) {
-	{
-		if (__USE_MDB2__ === true)
+        if (__USE_MDB2__ === true) {
-		{
-			$conn = $GLOBALS["order_db"];
+            $conn = $GLOBALS["order_db"];
-		}
-		elseif (is_resource($GLOBALS["order_dbh"]))
+        } elseif (is_resource($GLOBALS["order_dbh"])) {
-		{
-			$conn = $GLOBALS["order_dbh"];
+            $conn = $GLOBALS["order_dbh"];
-		}
-		elseif (is_resource($remoteServer_dbh))
+        } elseif (is_resource($remoteServer_dbh)) {
-		{
-			$conn = $remoteServer_dbh;
+            $conn = $remoteServer_dbh;
-		}
+        }
-	}
-	else
+    } else {
-	{
-		$conn = $c;
+        $conn = $c;
-	}
+    }
-	if (!$db || $db == $ini["dbConnect"]["database"])
+    if (!$db || $db == $ini["dbConnect"]["database"]) {
-	{
-		$db = $ini["dbConnect"]["database"];
+        $db = $ini["dbConnect"]["database"];
-		if (!$c)
+        if (!$c) {
-		{
-			if (__USE_MDB2__ === true)
+            if (__USE_MDB2__ === true) {
-			{
-				$conn = $GLOBALS["db"];
+                $conn = $GLOBALS["db"];
-			}
-			elseif (is_resource($GLOBALS["dbh"]))
+            } elseif (is_resource($GLOBALS["dbh"])) {
-			{
-				$conn = $GLOBALS["dbh"];
+                $conn = $GLOBALS["dbh"];
-			}
-			elseif (is_resource($localhost_dbh))
+            } elseif (is_resource($localhost_dbh)) {
-			{
-				$conn = $localhost_dbh;
+                $conn = $localhost_dbh;
-			}
+            }
-		}
-		else
+        } else {
-		{
-			$conn = $c;
+            $conn = $c;
-		}
+        }
-	}
+    }
-	if (table_exists($table, $db, $conn))
+    if (table_exists($table, $db, $conn)) {
-	{
-		//Hole Informationen zur Tabelle
+        //Hole Informationen zur Tabelle
-		$sql = "SELECT
+        $sql = "SELECT
+                    *
                 FROM
                     information_schema.TABLES
                 WHERE
-                    table_name='".$table."'
+                    table_name='" . $table . "'
                 AND
-                    table_schema='".$db."'
+                    table_schema='" . $db . "'
             ";
-		if (__USE_MDB2__ === true)
-		{
+        if (__USE_MDB2__ === true) {
-			$res = $conn->query($sql);
+            $res = $conn->query($sql);
-			if ($res->numRows())
-			{
+            if ($res->numRows()) {
-				$row = $res->fetchRow();
+                $row = $res->fetchRow();
-			}
-		}
+            }
-		else
-		{
+        } else {
-			$res = mysql_query($sql, $conn);
+            $res = mysql_query($sql, $conn);
-			if (mysql_num_rows($res))
-			{
+            if (mysql_num_rows($res)) {
-				$row = mysql_fetch_assoc($res);
+                $row = mysql_fetch_assoc($res);
-			}
+            }
-		}
+        }
-	}
+    }
-	return $row;
+    return $row;
+}
 /**
  * @param array $config
  * @return void
  */
 function createDBField($name, $table, $conn, $config)
+{
-	$typ = $config["type"];
+    $typ = $config["type"];
-	if ($config["length"])
+    if ($config["length"]) {
-	{
-		$typ .= "(".$config["length"].")";
+        $typ .= "(" . $config["length"] . ")";
-	}
+    }
-	if ($config["extra"])
+    if ($config["extra"]) {
-	{
-		$typ .= " ".$config["extra"];
+        $typ .= " " . $config["extra"];
-	}
+    }
-	if ($config["nullable"] == 1)
+    if ($config["nullable"] == 1) {
-	{
-		$typ .= " NULL DEFAULT NULL";
+        $typ .= " NULL DEFAULT NULL";
-	}
-	else
+    } else {
-	{
-		$default = '';
+        $default = '';
-		if ($config["default"])
+        if ($config["default"]) {
-		{
-			$default = $config["default"];
+            $default = $config["default"];
-		}
+        }
-		$typ .= " NOT NULL DEFAULT '".$default."'";
+        $typ .= " NOT NULL DEFAULT '" . $default . "'";
-	}
+    }
-	if ($config["after"])
+    if ($config["after"]) {
-	{
-		$typ .= " AFTER ".$config["after"];
+        $typ .= " AFTER " . $config["after"];
-	}
+    }
-	if ($config["index"])
+    if ($config["index"]) {
-	{
-		$typ .= ", ADD ".$config["index"]."(".$name.")";
+        $typ .= ", ADD " . $config["index"] . "(" . $name . ")";
-	}
+    }
-	$sql = "
+    $sql = "
             ALTER TABLE
-                ".$table."
+                " . $table . "
             ADD
-                ".$name." ".$typ."
+                " . $name . " " . $typ . "
         ";
-	$conn->exec($sql);
+    $conn->exec($sql);
+}
 function Eigenschaft($NR)
+{
-	if (is_array($_SESSION['SHOP']['BASKET']) && count($_SESSION['SHOP']['BASKET']) >
+    if (is_array($_SESSION['SHOP']['BASKET']) && count($_SESSION['SHOP']['BASKET']) >
-)
+) {
-	{
-		foreach ($_SESSION['SHOP']['BASKET'] as $v)
+        foreach ($_SESSION['SHOP']['BASKET'] as $v) {
-		{
-			$test = explode("_", $v["ID"]);
+            $test = explode("_", $v["ID"]);
-			if (count($test) == 1)
+            if (count($test) == 1) {
-			{
-				$idArray[] = $v["ID"];
+                $idArray[] = $v["ID"];
-			}
+            }
-		}
+        }
-		$query = "
+        $query = "
                 SELECT distinct
                     Eigenschaft_$NR
                 FROM
                     artikel
                 WHERE
-                    (ID =".implode(" or ID =", $idArray).")
+                    (ID =" . implode(" or ID =", $idArray) . ")
                 AND
-                    Language = '".$GLOBALS["INI"]['language']."'
+                    Language = '" . $GLOBALS["INI"]['language'] . "'
                 AND
                     Eigenschaft_$NR=1
             ";
-		$result = $GLOBALS['ci']->db->query($query);
+        $result = $GLOBALS['ci']->db->query($query);
-		if ($result->num_rows() > 0)
-		{
+        if ($result->num_rows() > 0) {
-			return true;
-		}
+            return true;
-		else
-		{
+        } else {
-			return false;
+            return false;
-		}
-	}
+        }
-	else
-	{
+    } else {
-		return false;
+        return false;
+    }
+}
 /**
  * @return array
  */
 function getVersandEigenschaften($domain = __SITE__)
+{
-	$sql = "SELECT
+    $sql = "SELECT
                 id
             FROM
                 properties
             WHERE
                 interner_Name LIKE 'Eigenschaft%'
             AND
                 tools=1
         ";
-	$res = $GLOBALS["db_red"]->query($sql);
+    $res = $GLOBALS["db_red"]->query($sql);
-	$rows = $res->result_array();
-	foreach ($rows as $row)
+    $rows = $res->result_array();
     foreach ($rows as $row) {
-		$sql2 = "SELECT
+        $sql2 = "SELECT
                     wp.*,
                     p.interner_name
                 FROM
                 JOIN
                     properties AS p
                 ON
                     p.id=wp.properties
                 WHERE
-                    domain='".$domain."'
+                    domain='" . $domain . "'
                 AND
-                    properties=".$row["id"]."
+                    properties=" . $row["id"] . "
                 AND
                     wp.Bezeichnung LIKE '%;logistik';
             ";
-		$res2 = $GLOBALS["db_red"]->query($sql2);
+        $res2 = $GLOBALS["db_red"]->query($sql2);
-		$row2 = $res2->row_array();
+        $row2 = $res2->row_array();
-		if (is_array($row2))
+        if (is_array($row2)) {
-		{
-			list($name, $nr) = explode("_", $row2["interner_name"]);
+            list($name, $nr) = explode("_", $row2["interner_name"]);
-			$eigenschaften[] = $nr;
+            $eigenschaften[] = $nr;
-		}
+        }
-	}
+    }
-	return $eigenschaften;
+    return $eigenschaften;
+}
 function getWebRechte($site = __SITE__)
 {
-	$web_rechte = array();
+    $web_rechte = array();
-	$query = "SELECT
+    $query = "SELECT
                 m.interner_name m_name,
                 t.button_name t_name,
                 p.interner_name p_name,
                 wp.Bezeichnung wp_name
             AND
                 t.modules = m.ID
             ORDER BY
                 p.Rang
         ";
-	$res = $GLOBALS["db_red"]->query($query);
+    $res = $GLOBALS["db_red"]->query($query);
-	while ($zeile = $res->unbuffered_row('array'))
+    while ($zeile = $res->unbuffered_row('array')) {
-	{
-		if (!$zeile["wp_name"])
+        if (!$zeile["wp_name"]) {
-		{
-			$zeile["wp_name"] = "";
+            $zeile["wp_name"] = "";
-		}
+        }
-		$zeile["wp_name"] = explode("|", $zeile["wp_name"]);
+        $zeile["wp_name"] = explode("|", $zeile["wp_name"]);
-		if (count($zeile["wp_name"]) == 1)
+        if (count($zeile["wp_name"]) == 1) {
-		{
-			$zeile["wp_name"] = $zeile["wp_name"][0];
+            $zeile["wp_name"] = $zeile["wp_name"][0];
-		}
+        }
-		$web_rechte[$zeile["m_name"]][$zeile["t_name"]][$zeile["p_name"]] = $zeile["wp_name"];
+        $web_rechte[$zeile["m_name"]][$zeile["t_name"]][$zeile["p_name"]] = $zeile["wp_name"];
-	}
+    }
-	foreach (array_keys($web_rechte) as $a)
+    foreach (array_keys($web_rechte) as $a) {
-	{
-		foreach (array_keys($web_rechte[$a]) as $b)
+        foreach (array_keys($web_rechte[$a]) as $b) {
-		{
-			foreach (array_keys($web_rechte[$a][$b]) as $c)
+            foreach (array_keys($web_rechte[$a][$b]) as $c) {
-			{
-				if (is_array($web_rechte[$a][$b][$c]))
+                if (is_array($web_rechte[$a][$b][$c])) {
-				{
-					$web_rechte[$a][$b][$c] = $web_rechte[$a][$b][$c][array_search($GLOBALS["INI"]["language"],
+                    $web_rechte[$a][$b][$c] = $web_rechte[$a][$b][$c][array_search($GLOBALS["INI"]["language"],
-						array_keys($web_rechte["online_shop"]["language"]))];
+                        array_keys($web_rechte["online_shop"]["language"]))];
-					if ($web_rechte[$a][$b][$c] == "./.")
+                    if ($web_rechte[$a][$b][$c] == "./.") {
-					{
-						unset($web_rechte[$a][$b][$c]);
+                        unset($web_rechte[$a][$b][$c]);
-					}
+                    }
-				}
+                }
-			}
+            }
-		}
+        }
-	}
+    }
-	unset($query);
+    unset($query);
-	unset($result);
+    unset($result);
-	unset($zeile);
+    unset($zeile);
-	return $web_rechte;
+    return $web_rechte;
+}
 function getZahlarten()
 {
-	$zahlarten[] = "- Bezahlarten -";
+    $zahlarten[] = "- Bezahlarten -";
-	$sql = "
+    $sql = "
 		SELECT
 			z.*
 		FROM
 			zahlungsarten z
 		ON
 			a.short_line_1=z.interner_name
 		ORDER BY
 			name
 	";
-	$res = $GLOBALS['ci']->db->query($sql);
+    $res = $GLOBALS['ci']->db->query($sql);
-	while ($row = $res->unbuffered_row('array'))
+    while ($row = $res->unbuffered_row('array')) {
-	{
-		$ini_name = $row["interner_name"];
+        $ini_name = $row["interner_name"];
-		if ($row["interner_name"] == "sofortueberweisung")
+        if ($row["interner_name"] == "sofortueberweisung") {
-		{
-			$ini_name = "ueberweisung";
+            $ini_name = "ueberweisung";
-		}
+        }
-		if (isset($GLOBALS['INI'][$ini_name]) && $GLOBALS["INI"][$ini_name]["aktiv"] ==
+        if (isset($GLOBALS['INI'][$ini_name]) && $GLOBALS["INI"][$ini_name]["aktiv"] ==
 && ((isset($_SESSION['zahlarten'][$ini_name]) && $_SESSION["zahlarten"][$ini_name]
-			!== false) || !isset($_SESSION['zahlarten'][$ini_name])) || !in_array($row["interner_name"],
+            !== false) || !isset($_SESSION['zahlarten'][$ini_name])) || !in_array($row["interner_name"],
-			$GLOBALS["zahlsysteme"]))
+            $GLOBALS["zahlsysteme"])) {
-		{
-			$zahlarten[$row['interner_name']] = $row['name'];
+            $zahlarten[$row['interner_name']] = $row['name'];
-		}
+        }
-	}
+    }
-	return $zahlarten;
+    return $zahlarten;
+}
 function getWebanLCode($land)
 {
-	$sql = "SELECT
+    $sql = "SELECT
                 weban_lcode
             FROM
                 countries
             WHERE
-                `name-ger` = '".$land."'
+                `name-ger` = '" . $land . "'
             OR
-                `name-en` = '".$land."'
+                `name-en` = '" . $land . "'
             OR
-                `iso-2` = '".$land."'
+                `iso-2` = '" . $land . "'
             OR
-                `iso-3` = '".$land."'
+                `iso-3` = '" . $land . "'
             OR
-                `id` = '".$land."'
+                `id` = '" . $land . "'
         ";
-	$res = $GLOBALS["db_red"]->query($sql);
+    $res = $GLOBALS["db_red"]->query($sql);
-	$row = $res->row_array();
+    $row = $res->row_array();
-	$id = $row['weban_lcode'];
+    $id = $row['weban_lcode'];
-	return $id;
+    return $id;
+}
 function get_versandkosten($land = null, $mode = '')
-{
-	if (is_null($land))
+{
-	{
+    if (is_null($land)) {
-		$land = 47;
+        $land = 47;
-	}
+    }
-	$lCode = getWebanLCode($land);
+    $lCode = getWebanLCode($land);
-	$gewicht = get_gewicht();
+    $gewicht = get_gewicht();
-	$preis = $_SESSION['SHOP']['SUMME'];
+    $preis = $_SESSION['SHOP']['SUMME'];
-	$shopID = $GLOBALS["INI"]['shops_ID'];
+    $shopID = $GLOBALS["INI"]['shops_ID'];
-	if (isset($_SESSION["KundengruppeShopID"]) && $_SESSION["KundengruppeShopID"] !=
-		"")
+    if (isset($_SESSION["KundengruppeShopID"]) && $_SESSION["KundengruppeShopID"] !=
-	{
+        "") {
-		$shopID = $_SESSION["KundengruppeShopID"];
+        $shopID = $_SESSION["KundengruppeShopID"];
-	}
+    }
-	$sql_Z_extra = "";
+    $sql_Z_extra = "";
-	if (column_exists("zahlungsarten", "express", $GLOBALS["INI"]["dbConnect"]["database"],
-		$GLOBALS['ci']->db))
+    if (column_exists("zahlungsarten", "express", $GLOBALS["INI"]["dbConnect"]["database"],
-	{
+        $GLOBALS['ci']->db)) {
-		$sql_Z_extra = "express,";
+        $sql_Z_extra = "express,";
+    }
-	$sql = "
+    $sql = "
 		SELECT
 			a.ID,
 			Eigenschaft_1,
 			Eigenschaft_2,
 			Eigenschaft_3,
 			Eigenschaft_4,
 			Eigenschaft_5,
-			".$sql_Z_extra."
+			" . $sql_Z_extra . "
 			z.name AS z_name
 		FROM
 			artikel a
 		JOIN
 			zahlungsarten z
 		ON
 			z.interner_name=a.short_line_1
 		WHERE
 			father=-3
 		AND
-			language='".$GLOBALS['INI']['language']."'
+			language='" . $GLOBALS['INI']['language'] . "'
 		AND
-			lieferstatus & ".$lCode."=".$lCode."
+			lieferstatus & " . $lCode . "=" . $lCode . "
 		AND
+		(
-			(".$gewicht." between preis_neu1 and preis_neu2)
+			(" . $gewicht . " between preis_neu1 and preis_neu2)
+		)
 		AND
+		(
-			(".$preis." BETWEEN preis_neu3 AND preis_neu4)
+			(" . $preis . " BETWEEN preis_neu3 AND preis_neu4)
 			OR
 			(preis_neu3=preis_neu4)
+		)
 	";
-	if ($mode != 'Versanduebersicht')
+    if ($mode != 'Versanduebersicht') {
-	{
-		foreach ($GLOBALS["Eigenschaften"] as $nr)
+        foreach ($GLOBALS["Eigenschaften"] as $nr) {
-		{
-			if (Eigenschaft($nr) == true)
+            if (Eigenschaft($nr) == true) {
-			{
-				$sql .= "
+                $sql .= "
 					AND
 						Eigenschaft_$nr = 1
 				";
-			}
-			else
+            } else {
-			{
-				$sql .= "
+                $sql .= "
 					AND
+					(
 						(Eigenschaft_$nr = 0)
 						OR
 						(Eigenschaft_$nr IS NULL)
+					)
 				";
-			}
+            }
-		}
+        }
-	}
+    }
-	$sql .= "
+    $sql .= "
 		ORDER BY
 			short_line_1,
 			rang
 	";
-	$res = $GLOBALS['ci']->db->query($sql);
+    $res = $GLOBALS['ci']->db->query($sql);
-	$items = $res->result_array();
+    $items = $res->result_array();
-	return $items;
+    return $items;
+}
 /**
  * getIsoCode()
+ *
  * @return string
  */
 function getIsoCode($Land = 'Deutschland', $len = 2)
+{
-	$iso = "DE";
+    $iso = "DE";
-	$sql = "SELECT
+    $sql = "SELECT
-                `iso-".$len."` as iso_code
+                `iso-" . $len . "` as iso_code
             FROM
                 countries
             WHERE
-                `name-ger` ='".$Land."'
+                `name-ger` ='" . $Land . "'
             OR
-                `name-en` = '".$Land."'
+                `name-en` = '" . $Land . "'
             OR
-                `id` = '".$Land."'
+                `id` = '" . $Land . "'
         ";
-	$res = $GLOBALS["db_red"]->query($sql);
+    $res = $GLOBALS["db_red"]->query($sql);
-	$row = $res->row_array();
+    $row = $res->row_array();
-	$iso = $row["iso_code"];
+    $iso = $row["iso_code"];
-	return $iso;
+    return $iso;
+}
-if (isset($GLOBALS['INI']['steuern']['use_countries_tax']))
-{
+if (isset($GLOBALS['INI']['steuern']['use_countries_tax'])) {
-	$GLOBALS['steuern'] = getSteuerinfo();
+    $GLOBALS['steuern'] = getSteuerinfo();
+}
 /**
  * Liefert zu den angegebenen LänderIds aus der Ini-Variable steuern->use_countries-tax die verfügbaren Steuersätze
  *      *
  * @return array $steuern mit den Steuerinfos ermittelt
+ *
  */
 function getSteuerinfo()
 {
-	$steuern = array();
+    $steuern = array();
-	//default LandID für Deutschland
+    //default LandID für Deutschland
-	$landID = 47;
+    $landID = 47;
-	//Wenn das Flag gesetzt ist, dann nimm diesen wert, damit auch "ausländische Shops" den richtigen MwSt angezeigt bekommen
-	if (isset($GLOBALS["INI"]["steuern"]["default_countryID"]))
+    //Wenn das Flag gesetzt ist, dann nimm diesen wert, damit auch "ausländische Shops" den richtigen MwSt angezeigt bekommen
-	{
+    if (isset($GLOBALS["INI"]["steuern"]["default_countryID"])) {
-		$landID = $GLOBALS["INI"]["steuern"]["default_countryID"];
+        $landID = $GLOBALS["INI"]["steuern"]["default_countryID"];
-	}
+    }
-	$countryIDs = (isset($GLOBALS['INI']['steuern']['use_countries_tax'])) ? $GLOBALS['INI']['steuern']['use_countries_tax'] :
+    $countryIDs = (isset($GLOBALS['INI']['steuern']['use_countries_tax'])) ? $GLOBALS['INI']['steuern']['use_countries_tax'] :
-		$landID;
+        $landID;
-	$sql = "SELECT
+    $sql = "SELECT
 			*
 		FROM
 			countries_tax
 		WHERE
-			countries_id IN (".$countryIDs.")
-	";
+			countries_id IN (" . $countryIDs . ")
-	$res = $GLOBALS["db_red"]->query($sql);
+	";
-	while ($r = $res->unbuffered_row('array'))
+    $res = $GLOBALS["db_red"]->query($sql);
     while ($r = $res->unbuffered_row('array')) {
-		$steuern[$r['countries_id']][$r['taxes_id']] = $r['tax_percent'];
+        $steuern[$r['countries_id']][$r['taxes_id']] = $r['tax_percent'];
+    }
-	return $steuern;
+    return $steuern;
 }
-function get_gewicht()
-{
+function get_gewicht()
-	$gewicht = 0;
+{
-	foreach ($_SESSION['SHOP']['BASKET'] AS $bItem)
+    $gewicht = 0;
     foreach ($_SESSION['SHOP']['BASKET'] as $bItem) {
-		$artikel = $GLOBALS['ci']->artikel->get_artikel($bItem['ID'], true);
+        $artikel = $GLOBALS['ci']->artikel->get_artikel($bItem['ID'], true);
-		$gewicht += $artikel['gewicht'];
+        $gewicht += $artikel['gewicht'];
+    }
+ *
  */
 function isWeban()
 {
-	$webanIP = "89.245.130.99";
+    $webanIP = "89.245.130.99";
-	if (!defined("IS_WEBAN"))
-	{
+    if (!defined("IS_WEBAN")) {
-		if ((isset($_SERVER["REMOTE_ADDR"]) && $_SERVER["REMOTE_ADDR"] == $webanIP) || (isset
+        if ((isset($_SERVER["REMOTE_ADDR"]) && $_SERVER["REMOTE_ADDR"] == $webanIP) || (isset
-			($_SERVER["PHP_AUTH_USER"]) && $_SERVER["PHP_AUTH_USER"] == "admin") || (isset($_SERVER["REMOTE_ADDR"]) &&
+            ($_SERVER["PHP_AUTH_USER"]) && $_SERVER["PHP_AUTH_USER"] == "admin") || (isset($_SERVER["REMOTE_ADDR"]) &&
-			preg_match("/192\.168\.0/", $_SERVER["REMOTE_ADDR"])) || CRON === true)
-		{
+            preg_match("/192\.168\.0/", $_SERVER["REMOTE_ADDR"])) || CRON === true) {
-			define("IS_WEBAN", true);
-		}
+            define("IS_WEBAN", true);
-		else
-		{
+        } else {
-			define("IS_WEBAN", false);
+            define("IS_WEBAN", false);
-		}
+        }
+    }
+}
 function admin_debug($var, $die = false)
 {
-	if (IS_WEBAN === true)
-	{
+    if (IS_WEBAN === true) {
-		echo EOL."Admin-Debug:".EOL;
+        echo EOL . "Admin-Debug:" . EOL;
-		var_dump($var);
+        var_dump($var);
-		if ($die === true)
-		{
+        if ($die === true) {
-			die();
+            die();
-		}
-	}
+        }
-	else
-	{
+    } else {
-		//mail( "ltiefland@gmail.com", "Fehler auf " . __SHOP__, var_export( $var, true ) );
+        //mail( "ltiefland@gmail.com", "Fehler auf " . __SHOP__, var_export( $var, true ) );
+    }
+}
 function getBasketGewicht()
 {
+    $gewicht = 0;
+    foreach ($_SESSION["SHOP"]["BASKET"] as $bItem) {
+        $gewicht += $bItem["gewicht"];
+    }
+    return $gewicht;
+}
-	$gewicht = 0;
-	foreach ($_SESSION["SHOP"]["BASKET"] as $bItem)
+function getDokDomain()
+{
+    global $webs, $site_full, $site;
+    $prot = "http";
+    if ( $webs["use_ssl"] == 1 )
+    {
+        $prot = "https";
+    }
+    $dokDomain = $prot . "://www." . $site_full;
+    if ( $site == $site_full && $webs["dok_domain"] )
-	{
+    {
-		$gewicht += $bItem["gewicht"];
+        $dokDomain = $prot . "://" . $webs["dok_domain"];
+    }
-	return $gewicht;
     return $dokDomain;

Subversion-Projekte lars-tiefland.ci

(root)/frontend/helpers/weban_helper.php – Revision 2011 → 2117