function writeLog($log, $errorMessage = null) { $conn = sqlConnectDefault(); if (is_null($conn)) { 1; // make error somewhere return; } if ($log['type'] == "0") { $insQ = new insertSQL($conn); $insQ->tableName = "visit_logs"; $insQ->cols = array("date", "url", "catid", "prodid", "ip", "userid"); $insQ->insertData = array(time(), $log['page'], $log['catid'], $log['prodid'], ip2long($_SERVER['REMOTE_ADDR']), $log['user']); if ($errorMessage) { $insQ->cols[] = "error"; $insQ->cols[] = "message"; $insQ->insertData[] = "1"; $insQ->insertData[] = $errorMessage; } if (!$insQ->executeQuery()) { 1; } // make error somewhere return; } }
<?php $conn = sqlConnectDefault(); if (is_null($conn)) { $statusMessage = makeStatusMessage(1, "error"); return; } $user = getUser($conn); if (empty($user)) { $log = createLog("", "", "", $id); } else { $log = createLog("", "", "", $id, ""); } $selQ = new selectSQL($conn); $selQ->select = array("catid"); $selQ->tableNames = array("products"); $selQ->where = "promo != '0'"; if (!$selQ->executeQuery()) { $statusMessage = $selQ->status; mysqli_close($conn); return; } if ($selQ->getNumberOfResults() == 0) { $statusMessage = makeStatusMessage(52, "error"); mysqli_close($conn); return; } $tmp = $selQ->result->fetch_assoc(); $catid = $tmp['catid']; unset($selQ); $selQ = new selectSQL($conn);
function getPropsForCat($conn, $catid, $langArr = null, $insertQueryLangArr = null) { $language = $GLOBALS['language']; include_once 'variables/productVariables.php'; if (isset($langArr)) { $propNamesDefld = array(); foreach ($propNamesDefldtemp as $tmp) { foreach ($langArr as $lan) { $propNamesDefld[] = $tmp . $lan; } } } else { $propNamesDefld = $propNamesDefldtemp; } $propNames = array(); $propNamesld = array(); if (isset($insertQueryLangArr)) { $langArr = $insertQueryLangArr; } $conn = sqlConnectDefault(); if (is_null($conn)) { $statusMessage = makeStatusMessage(1, "error"); return; } $selQ = new selectSQL($conn); $selQ->tableNames = array("props_to_prods as ptp", "properties as p"); $selQ->joins = array("p.id = ptp.propid"); $selQ->joinTypes = array("INNER JOIN"); $selQ->select = array("p.name as propName", "p.langDependant as ld", "p.name" . $language . " as `langName`"); $selQ->where = "ptp.catid = '" . $catid . "'"; if (!$selQ->executeQuery()) { $GLOBALS['statusMessage'] = $selQ->status; return null; } elseif ($selQ->getNumberOfResults() == 0) { $GLOBALS['statusMessage'] = makeStatusMessage(53, "error"); return null; } elseif (isset($langArr)) { while ($r = $selQ->result->fetch_assoc()) { if ($r['ld']) { if (isset($insertQueryLangArr)) { $propNamesld[] = $r['propName'] . " as `" . $r['langName'] . "`"; } else { foreach ($langArr as $lan) { $propNamesld[] = $r['propName'] . $lan . " as `" . $r['langName'] . "`"; } } } else { $propNames[] = $r['propName'] . " as `" . $r['langName'] . "`"; } } } else { while ($r = $selQ->result->fetch_assoc()) { if ($r['ld']) { $propNamesld[] = $r['propName']; } else { $propNames[] = $r['propName']; } } } return array("propNamesDefld" => $propNamesDefld, "propNamesDef" => $propNamesDef, "propNamesld" => $propNamesld, "propNames" => $propNames); }