$sort_user = $_USER['uid'];
}
$sort_datetime = time();
$referer = DB_escapeString($referer);
$keywords = DB_escapeString($keywords);
$sql = "INSERT INTO {$_TABLES['mg_sort']} (sort_id,sort_user,sort_query,sort_results,sort_datetime,referer,keywords)\n VALUES ('{$sort_id}',{$sort_user},'{$sqltmp}',{$numresults},{$sort_datetime},'{$referer}','{$keywords}')";
$result = DB_query($sql);
if (DB_error()) {
COM_errorLog("Media Gallery: Error placing sort query into database");
}
$sort_purge = time() - 3660;
// 43200;
DB_query("DELETE FROM {$_TABLES['mg_sort']} WHERE sort_datetime < " . $sort_purge);
$pageBody .= MG_search($sort_id, 1);
} elseif ($mode == $LANG_MG01['cancel']) {
echo COM_refresh($_MG_CONF['site_url'] . '/index.php');
exit;
} elseif (isset($_GET['id'])) {
$id = COM_applyFilter($_GET['id']);
$page = COM_applyFilter($_GET['page'], true);
if ($page < 1) {
$page = 1;
}
$pageBody .= MG_search($id, $page);
} else {
$pageBody .= MG_displaySearchBox('');
}
$display = MG_siteHeader($LANG_MG00['results']);
$display .= $pageBody;
$display .= MG_siteFooter();
echo $display;
$sort_user = $_USER['uid'];
}
$sort_datetime = time();
$referer = addslashes($referer);
$keywords = addslashes($keywords);
if ($f_all == true || !empty($keywords)) {
$sql = "INSERT INTO {$_TABLES['mg_sort']} (sort_id,sort_user,sort_query,sort_results,sort_datetime,referer,keywords)\n VALUES ('{$sort_id}',{$sort_user},'{$sqltmp}',{$numresults},{$sort_datetime},'{$referer}','{$keywords}')";
$result = DB_query($sql);
if (DB_error()) {
COM_errorLog("Media Gallery: Error placing sort query into database");
}
$display .= MG_search($sort_id, 1, $searchinfo);
} else {
$display .= MG_showSearchForm($searchinfo);
}
$sort_purge = time() - 3660;
// 43200;
DB_query("DELETE FROM {$_TABLES['mg_sort']} WHERE sort_datetime < " . $sort_purge);
} elseif ($mode == $LANG_MG01['cancel']) {
echo COM_refresh($_MG_CONF['site_url'] . '/index.php');
exit;
} elseif (isset($_GET['id'])) {
$id = COM_applyFilter($_GET['id']);
$page = intval(COM_applyFilter($_GET['page'], true));
if ($page < 1 || empty($page)) {
$page = 1;
}
$display .= MG_search($id, $page, $searchinfo);
}
$display = MG_createHTMLDocument($display, $LANG_MG00['results']);
COM_output($display);
