$orderByUp = ', `eventUpInCatAll` DESC';
$eventFreezeTime = '`eventUpInCatAll`';
$and = '';
if (isset($_GET['cityId'])) {
$filters[] = '`spotCityId` = ' . (int) $_GET['cityId'] . ' ';
}
if (isset($_GET['catId'])) {
$filters[] = '`eventCatId` = ' . (int) $_GET['catId'] . ' ';
$orderByUp = ', `eventUpInCat` DESC';
$eventFreezeTime = '`eventUpInCat`';
}
if (isset($_GET['SubCatId'])) {
$filters[] = ' `eventSubCatId` = ' . (int) $_GET['SubCatId'] . ' ';
}
if (isset($_GET['textSearchRequest'])) {
$filters[] = ' MATCH (`eventName`,`eventInfo`) AGAINST (\'' . $dbConnection->ms($_GET['textSearchRequest']) . '\' IN BOOLEAN MODE) ';
}
$_GET['from'] = isset($_GET['from']) ? (int) $_GET['from'] : 0;
$_GET['amount'] = isset($_GET['amount']) ? (int) $_GET['amount'] : 10;
$and = count($filters) > 0 ? ' AND ' : '';
$query = $dbConnection->mq('
SELECT
*,
IF(`eventFreezeTime`>=NOW(),1,0) as VIP
FROM
`event`
INNER JOIN
`eventSpots`
ON
`eventSpotsEventId` = `eventId`
INNER JOIN
function authorize(Mysql $mysql)
{
if (!isset($_POST['email'], $_POST['pass'])) {
exit;
}
$query = $mysql->mq('
SELECT
`companyId`
FROM
`company`
WHERE
`companyMail` = "' . $mysql->ms($_POST['email']) . '"
AND
`companyPassword` = "' . Security::generatePassword($_POST['email'], $_POST['pass']) . '"
LIMIT 1
');
if ($query->num_rows) {
$_SESSION['userId'] = $mysql->assoc($query)['companyId'];
}
echo $query->num_rows;
}
