function NP_set_i18n($strings, $val = null, $lang = null) { if (is_string($strings)) { $tmp = NP_DDBB::decodeI18NSqlValue($strings); if (is_array($tmp)) { $strings = $tmp; } } else { if (is_null($strings)) { $strings = array(); } } if (is_array($strings)) { if ($val === null && $lang !== null) { unset($strings[$lang]); } else { if ($lang === null) { $strings[NP_LANG] = $val; } else { $strings[$lang] = $val; } } return $strings; } else { if (!is_null($strings)) { return $strings; } else { return $val; } } }
function fetchCategories($data) { global $categories, $categoryTitle, $item; if ($item->categoryId == $data['CAT_CO_CODIGO']) { $categoryTitle = NP_DDBB::decodeSQLValue($data['CAT_VA_NOMBRE'], "STRING_I18N"); } array_push($categories, array($data['CAT_CO_CODIGO'], NP_DDBB::decodeSQLValue($data['CAT_VA_NOMBRE'], "STRING_I18N"))); }
function getCountryName($countryId) { global $ddbb; if ($countryId != null && trim($countryId) != "") { $data = $ddbb->executePKSelectQuery("SELECT name FROM NPS_PAISES WHERE id=" . $countryId); return NP_get_i18n(NP_DDBB::decodeSQLValue($data["name"], "STRING_I18N")); } }
function fetchCategories($data) { global $categories, $categoryTitle; //, $sourceCategoryTitle; if ($_GET['categoryId'] == $data['CAT_CO_CODIGO']) { $categoryTitle = NP_DDBB::decodeSQLValue($data['CAT_VA_NOMBRE'], "STRING_I18N"); } // if (isset($_GET['sourceCategoryId']) && $_GET['sourceCategoryId'] == $data['CAT_CO_CODIGO']) // $sourceCategoryTitle = $data['CAT_VA_NOMBRE']; array_push($categories, array($data['CAT_CO_CODIGO'], NP_DDBB::decodeSQLValue($data['CAT_VA_NOMBRE'], "STRING_I18N"))); }
public static function loadRating($userId, $photoId) { global $photocontest_ddbb; $sql = "SELECT * FROM " . $photocontest_ddbb->getTable('Rating') . " WHERE " . $photocontest_ddbb->getMapping('Rating', 'userId') . " = " . NP_DDBB::encodeSQLValue($userId, $photocontest_ddbb->getType('Rating', 'userId')) . " AND " . $photocontest_ddbb->getMapping('Rating', 'photoId') . " = " . NP_DDBB::encodeSQLValue($photoId, $photocontest_ddbb->getType('Rating', 'photoId')); $data = $photocontest_ddbb->executePKSelectQuery($sql); if ($data != null) { return new Rating($data); } else { return null; } }
public function delete() { global $photocontest_ddbb; $sql_1 = "DELETE FROM " . $photocontest_ddbb->getTable('Photo') . " WHERE " . $photocontest_ddbb->getMapping('Photo', 'photoId') . " = " . NP_DDBB::encodeSQLValue($this->photoId, $photocontest_ddbb->getType('Photo', 'photoId')); return $photocontest_ddbb->executeDeleteQuery($sql_1) > 0; }
function storeSpecialShippingCost($orderId, $lineNumber) { global $npshop; $sql = "INSERT INTO " . $npshop["ddbb"]["PREFIX"] . "PEDIDOSCOSTES " . " VALUES (" . NP_DDBB::encodeSQLValue($orderId, "INT") . ", " . NP_DDBB::encodeSQLValue($lineNumber, "INT") . ", " . NP_DDBB::encodeSQLValue($this->id, "STRING") . ", " . NP_DDBB::encodeSQLValue($this->quantity, "INT") . ", " . NP_DDBB::encodeSQLValue($this->specialShippingCost, "FLOAT") . ", " . NP_DDBB::encodeSQLValue($this->quantity * $this->specialShippingCost, "FLOAT") . ")"; $ddbb->executeInsertUpdateQuery($sql); }
function fetchCountries($data) { global $countries; $countries[$data['id']] = NP_DDBB::decodeSQLValue($data['name'], "STRING_I18N"); }
function decodeSQLValue($strVal, $sqlType) { if (isset($strVal) && $strVal !== null) { if ($sqlType == "STRING" || $sqlType == "TEXT") { return $strVal; } else { if ($sqlType == "STRING_I18N" || $sqlType == "TEXT_I18N") { return NP_DDBB::decodeI18NSqlValue($strVal); } else { if ($sqlType == "BOOL") { if (isset($strVal) && $strVal != "") { return $strVal == "1"; } else { return false; } } else { if ($sqlType == "INT") { if (isset($strVal) && $strVal != "") { return intval($strVal); } else { return 0; } } else { if ($sqlType == "FLOAT") { if (isset($strVal) && $strVal != "") { return number_format((double) $strVal, 2, '.', ''); } else { return 0; } } else { if ($sqlType == "DATE") { if (isset($strVal) && $strVal != "") { return date($strVal); } else { return null; } } else { return $strVal; } } } } } } } else { return null; } }
$skin['path'] = "/sites/"; $langs = array(); $langs['es_ES'] = "Spanish"; $langs['en_US'] = "English"; $nps = array(); $nps['ddbb'] = $ddbb; $nps['tpv'] = $tpv; $nps['skin'] = $skin; $nps['constants'] = $constants; $nps['avaliable_languages'] = $langs; $nps['language'] = "en_US"; return $nps; } $npshop = doConfig($npshop); define('NP_DEFAULT_LANG', "en_US"); if (isset($_GET) && array_key_exists("LANG", $_GET)) { define('NP_LANG', $_GET[LANG]); setcookie('NP_LANG', $_GET[LANG]); } else { define('NP_LANG', $_COOKIE['NP_LANG'] != NULL ? $_COOKIE['NP_LANG'] : $npshop['language']); } putenv("LC_ALL=" . NP_LANG); setlocale(LC_ALL, NP_LANG); bindtextdomain("messages", APP_ROOT . "/i18n"); textdomain("messages"); if (version_compare(phpversion(), '5.0') < 0) { $ddbb = new NP_DDBB(); $ddbb->__construct($npshop['ddbb']); } else { $ddbb = new NP_DDBB($npshop['ddbb']); }
function _dbUpdate() { global $ddbb; $objectVars = get_object_vars($this); $first = true; $ddbb_mapping = $ddbb->getMapping("User", null); $ddbb_types = $ddbb->getType("User", null); $sql = "UPDATE " . $ddbb->getTable("User") . " SET "; foreach (array_keys($objectVars) as $var) { if (array_key_exists($var, $ddbb_mapping)) { if (is_array($ddbb_mapping[$var])) { foreach (array_keys($ddbb_mapping[$var]) as $subvar) { if (!$first) { $sql .= ", "; } else { $first = false; } //echo $var.$subvar.$ddbb_types["User"][$var][$subvar].$objectVars[$var][$subvar]."-->".encodeSQLValue($objectVars[$var][$subvar], $ddbb_types["User"][$var][$subvar])."<br>"; $sql .= $ddbb_mapping[$var][$subvar] . "=" . NP_DDBB::encodeSQLValue($objectVars[$var][$subvar], $ddbb_types[$var][$subvar]); } } else { if ($var != "id") { if (!$first) { $sql .= ", "; } else { $first = false; } $sql .= $ddbb_mapping[$var] . "=" . NP_DDBB::encodeSQLValue($objectVars[$var], $ddbb_types[$var]); } } } else { //TODO: ERROR } } $sql .= " WHERE " . $ddbb_mapping["id"] . "=" . NP_DDBB::encodeSQLValue($objectVars["id"], $ddbb_types["id"]); $ddbb->executeInsertUpdateQuery($sql); }
public function photoRatings($photoId, $userId = null) { global $photocontest_ddbb; $result = null; if ($userId !== null) { $rating = Rating::loadRating($userId, $photoId); if ($rating != null) { return $rating->rating; } else { return 0; } } else { $sql = "SELECT SUM(r." . $photocontest_ddbb->getMapping('Rating', 'rating') . ") as total_votes, count(*) number_people FROM " . $photocontest_ddbb->getTable("Rating") . " r JOIN " . $photocontest_ddbb->getTable("Photo") . " p ON r.photo_id=p.photo_id WHERE r.photo_id=" . NP_DDBB::encodeSQLValue($photoId, $photocontest_ddbb->getType('Rating', 'photoId')) . " AND p.contest_id=" . NP_DDBB::encodeSQLValue($this->contestId, $photocontest_ddbb->getType('Photo', 'contestId')); $result = $photocontest_ddbb->executePKSelectQuery($sql); if ($result['total_votes'] === null) { $result['total_votes'] = 0; } } return $result; }
function deleteOrder() { global $npshop, $ddbb; foreach ($this->items as $item) { $item->deleteFromOrder($this->orderId); } $sqlShippingCost = "DELETE FROM " . $npshop["ddbb"]["PREFIX"] . "PEDIDOSCOSTES WHERE PED_CO_CODIGO=" . NP_DDBB::encodeSQLValue($this->orderId, $ddbb->getType("Cart", "orderId")); $ddbb->executeDeleteQuery($sqlShippingCost); $sqlOrder = "DELETE FROM " . $ddbb->getTable("Cart") . " WHERE " . $ddbb->getMapping("Cart", "orderId") . "=" . NP_DDBB::encodeSQLValue($this->orderId, $ddbb->getType("Cart", "orderId")); $ddbb->executeDeleteQuery($sqlOrder); }