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