$count = $row[0];
if (!$count && isset($cleansearchstr)) {
$wherea = $wherebase;
$searcha = explode(" ", $cleansearchstr);
$sc = 0;
foreach ($searcha as $searchss) {
if (strlen($searchss) <= 1) {
continue;
}
$sc++;
if ($sc > 5) {
break;
}
$ssa = array();
foreach (array("torrents.name") as $sss) {
$ssa[] = "{$sss} LIKE '%" . sqlwildcardesc($searchss) . "%'";
}
$wherea[] = "(" . implode(" OR ", $ssa) . ")";
}
if ($sc) {
$where = implode(" AND ", $wherea);
if ($where != "") {
$where = "WHERE {$where}";
}
$res = SQL_Query_exec("SELECT COUNT(*) FROM torrents {$where} {$parent_check}");
$row = mysql_fetch_array($res);
$count = $row[0];
}
}
//Sort by
if ($addparam != "") {
// | along with TBDevYSE; if not, write to the Free Software Foundation, |
// | Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
// +--------------------------------------------------------------------------+
// | Do not remove above lines! |
// +--------------------------------------------------------------------------+
*/
require "include/bittorrent.php";
dbconn();
loggedinorreturn();
$search = trim($_GET['search']);
$class = $_GET['class'];
if ($class == '-' || !is_valid_user_class($class)) {
$class = '';
}
if ($search != '' || $class) {
$query = "username LIKE '%" . sqlwildcardesc("{$search}") . "%' AND status='confirmed'";
if ($search) {
$q = "search=" . htmlspecialchars_uni($search);
}
} else {
$letter = trim($_GET["letter"]);
if (strlen($letter) > 1) {
die;
}
/* if ($letter != "" && strpos("abcdefghijklmnopqrstuvwxyz", $letter) === false)
$letter = "a";
$query = ( $letter != "" ? "username LIKE '$letter%' AND " : "") . "status='confirmed'";
if ($letter == "")
$letter = "a";
$q = "letter=$letter";*/
if ($letter != "" && strpos("abcdefghijklmnopqrstuvwxyz" . "абвгдеёжзийклмнопрстуфхцчшщъыьэюя", $letter) === false) {
$num_torrents = $count;
if (!$count && isset($cleansearchstr)) {
$wherea = $wherebase;
//$orderby = "ORDER BY id DESC";
$searcha = explode(" ", $cleansearchstr);
$sc = 0;
foreach ($searcha as $searchss) {
if (strlen($searchss) <= 1) {
continue;
}
$sc++;
if ($sc > 5) {
break;
}
$ssa = array();
$ssa[] = "t.name LIKE '%" . sqlwildcardesc($searchss) . "%'";
}
if ($sc) {
$where = implode(" AND ", $wherea);
if ($where != "") {
$where = "WHERE {$where}";
}
$res = sql_query("SELECT COUNT(*) FROM torrents AS t {$where}");
$row = mysql_fetch_array($res);
$count = $row[0];
}
}
$torrentsperpage = $CURUSER["torrentsperpage"];
if (!$torrentsperpage) {
$torrentsperpage = 25;
}
function search($_GET, $CURUSER)
{
$cats = genrelist();
if (isset($_GET["search"])) {
$searchstr = unesc($_GET["search"]);
$cleansearchstr = searchfield($searchstr);
if (empty($cleansearchstr)) {
unset($cleansearchstr);
}
}
$orderby = "ORDER BY torrents.id DESC";
$addparam = "";
$wherea = array();
$wherecatina = array();
if (isset($_GET["incldead"]) && $_GET["incldead"] == 1) {
$addparam .= "incldead=1&";
if (!isset($CURUSER) || get_user_class() < UC_ADMINISTRATOR) {
$wherea[] = "banned != 'yes'";
}
} else {
if (isset($_GET["incldead"]) && $_GET["incldead"] == 2) {
$addparam .= "incldead=2&";
$wherea[] = "visible = 'no'";
} else {
$wherea[] = "visible = 'yes'";
}
}
$category = isset($_GET["cat"]) ? (int) $_GET["cat"] : false;
$license = isset($_GET["lic"]) ? (int) $_GET["lic"] : false;
$version = isset($_GET["ver"]) ? (int) $_GET["ver"] : false;
$user = isset($_GET["user"]) ? (int) $_GET["user"] : false;
$all = isset($_GET["all"]) ? $_GET["all"] : false;
$page_limit = isset($_GET["page_limit"]) ? $_GET["page_limit"] : false;
if (!$all) {
if (!$_GET && $CURUSER["notifs"]) {
$all = True;
foreach ($cats as $cat) {
$all &= $cat['id'];
if (strpos($CURUSER["notifs"], "[cat" . $cat['id'] . "]") !== False) {
$wherecatina[] = $cat['id'];
$addparam .= "c{$cat['id']}=1&";
}
}
} elseif ($category) {
if (!is_valid_id($category)) {
stderr("Error", "Invalid category ID.");
}
$wherecatina[] = $category;
$addparam .= "cat={$category}&";
} else {
$all = True;
foreach ($cats as $cat) {
$all &= isset($_GET["c{$cat['id']}"]);
if (isset($_GET["c{$cat['id']}"])) {
$wherecatina[] = $cat['id'];
$addparam .= "c{$cat['id']}=1&";
}
}
}
}
if ($all) {
$wherecatina = array();
$addparam = "";
}
if (count($wherecatina) > 1) {
$wherecatin = implode(",", $wherecatina);
} elseif (count($wherecatina) == 1) {
$wherea[] = "category = {$wherecatina['0']}";
}
if ($license > 0) {
$wherea[] = "license = {$license}";
}
if ($user > 0) {
$wherea[] = "owner = {$user}";
}
if ($version > 0) {
$wherea[] = "version = {$version}";
}
$wherebase = $wherea;
if (isset($cleansearchstr)) {
$wherea[] = "MATCH (search_text, ori_descr) AGAINST (" . sqlesc($searchstr) . ")";
//$wherea[] = "0";
$addparam .= "search=" . urlencode($searchstr) . "&";
$orderby = "";
/////////////// SEARCH CLOUD MALARKY //////////////////////
$searchcloud = sqlesc($cleansearchstr);
// $r = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM searchcloud WHERE searchedfor = $searchcloud"), MYSQL_NUM);
//$a = $r[0];
//if ($a)
// mysql_query("UPDATE searchcloud SET howmuch = howmuch + 1 WHERE searchedfor = $searchcloud");
//else
// mysql_query("INSERT INTO searchcloud (searchedfor, howmuch) VALUES ($searchcloud, 1)");
mysql_query("INSERT INTO searchcloud (searchedfor, howmuch) VALUES ({$searchcloud}, 1)\n ON DUPLICATE KEY UPDATE howmuch=howmuch+1");
/////////////// SEARCH CLOUD MALARKY END ///////////////////
}
$where = implode(" AND ", $wherea);
if (isset($wherecatin)) {
$where .= ($where ? " AND " : "") . "category IN(" . $wherecatin . ")";
}
if ($where != "") {
$where = "WHERE {$where}";
}
$res = mysql_query("SELECT COUNT(*) FROM torrents {$where}") or die(mysql_error());
$row = mysql_fetch_array($res, MYSQL_NUM);
$count = $row[0];
if (!$count && isset($cleansearchstr)) {
$wherea = $wherebase;
$orderby = "ORDER BY id DESC";
$searcha = explode(" ", $cleansearchstr);
$sc = 0;
foreach ($searcha as $searchss) {
if (strlen($searchss) <= 1) {
continue;
}
$sc++;
if ($sc > 5) {
break;
}
$ssa = array();
foreach (array("search_text", "ori_descr") as $sss) {
$ssa[] = "{$sss} LIKE '%" . sqlwildcardesc($searchss) . "%'";
}
$wherea[] = "(" . implode(" OR ", $ssa) . ")";
}
if ($sc) {
$where = implode(" AND ", $wherea);
if ($where != "") {
$where = "WHERE {$where}";
}
$res = mysql_query("SELECT COUNT(*) FROM torrents {$where}");
$row = mysql_fetch_array($res, MYSQL_NUM);
$count = $row[0];
}
}
$torrentsperpage = $CURUSER["torrentsperpage"];
if ($page_limit) {
$torrentsperpage = $page_limit;
}
if (!$torrentsperpage) {
$torrentsperpage = 15;
}
if ($count) {
//list($pagertop, $pagerbottom, $limit) = pager($torrentsperpage, $count, "browse.php?" . $addparam);
$pager = pager($torrentsperpage, $count, "browse.php?" . $addparam);
$query = "SELECT torrents.id, torrents.category, torrents.leechers, torrents.seeders, torrents.name, torrents.times_completed, torrents.size, torrents.added, torrents.type, torrents.comments,torrents.numfiles,torrents.filename,torrents.owner,IF(torrents.nfo <> '', 1, 0) as nfoav," . "categories.name AS cat_name, categories.image AS cat_pic, users.username, torrents.version, torrents.descr,licenses.name AS lic_name,licenses.url AS lic_url,licenses.description AS lic_desc FROM torrents LEFT JOIN categories ON category = categories.id LEFT JOIN users ON torrents.owner = users.id LEFT JOIN licenses ON torrents.license = licenses.id {$where} {$orderby} {$pager['limit']}";
$res = mysql_query($query) or die(mysql_error());
} else {
unset($res);
}
if ($count) {
return array($res, $wherecatina, $pager);
} else {
return array("", $wherecatina, "");
}
}
}
$HTMLOUT .= "</td>";
$HTMLOUT .= "<td style='white-space: nowrap;'>" . get_date($getdaily['added'], 'LONG', 1, 0) . "</td></tr>";
}
mysql_free_result($res);
$HTMLOUT .= end_table();
$HTMLOUT .= $pager['pagerbottom'];
$HTMLOUT .= end_main_frame();
print stdhead('Today Posts (Last 24 Hours)') . $HTMLOUT . stdfoot();
} else {
if ($action == "search") {
$error = false;
$found = '';
$keywords = isset($_GET['keywords']) ? trim($_GET['keywords']) : '';
if (!empty($keywords)) {
$res = mysql_query("SELECT COUNT(id) AS c FROM posts WHERE body LIKE " . sqlesc("%" . sqlwildcardesc($keywords) . "%")) or sqlerr(__FILE__, __LINE__);
$arr = mysql_fetch_assoc($res);
$count = (int) $arr['c'];
$keywords = htmlspecialchars($keywords);
if ($count == 0) {
$error = true;
} else {
$perpage = 10;
$pager = pager($perpage, $count, $_SERVER['PHP_SELF'] . '?action=' . $action . '&keywords=' . $keywords . '&');
$res = mysql_query("SELECT p.id, p.topicid, p.userid, p.added, t.forumid, t.subject, f.name, f.minclassread, u.username " . "FROM posts AS p " . "LEFT JOIN topics AS t ON t.id=p.topicid " . "LEFT JOIN forums AS f ON f.id=t.forumid " . "LEFT JOIN users AS u ON u.id=p.userid " . "WHERE p.body LIKE " . sqlesc("%" . $keywords . "%") . " " . $pager['limit'] . "");
$num = mysql_num_rows($res);
$HTMLOUT .= $pager['pagertop'];
$HTMLOUT .= begin_main_frame();
$HTMLOUT .= "<table border='0' cellspacing='0' cellpadding='5' width='100%'>\r\n\t\t\t <tr align='left'>\r\n \t<td class='colhead'>Post</td>\r\n <td class='colhead'>Topic</td>\r\n <td class='colhead'>Forum</td>\r\n <td class='colhead'>Posted by</td>\r\n\t\t\t </tr>";
for ($i = 0; $i < $num; ++$i) {
$post = mysql_fetch_assoc($res);
