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