Dzisiaj uploadowano torrenty

[HERKULES]

Mod pokazuje jakie torrenty w dzisiejszym dniu uploadowano.

Utwórz plik dzis.php i wklej ten kod:

<?
require_once&#40;"include/bittorrent.php"&#41;;
dbconn&#40;false&#41;;
loggedinorreturn&#40;&#41;;
stdhead&#40;&#41;;


$orderby = "ORDER BY torrents.id DESC";

$date_time=get_date_time&#40;time&#40;&#41;-&#40;3600*48&#41;&#41;; // the 72 is the hours you want listed
$result= mysql_query&#40;"SELECT id FROM categories"&#41;;
$catcount=1;
$noofcats=mysql_num_rows&#40;$result&#41;;
while&#40;$catcount <> $noofcats and $_GET&#91;"cat"&#93; == 0&#41; &#123;
$result= mysql_query&#40;"SELECT * FROM torrents where category ='$catcount' AND visible = 'yes' AND added>='$date_time'"&#41;;
$nooftor=mysql_num_rows&#40;$result&#41;;
$result= mysql_query&#40;"SELECT name FROM categories where id=$catcount"&#41;;
$temp=mysql_fetch_assoc&#40;$result&#41;;
$catname=$temp&#91;"name"&#93;;
if &#40;$nooftor <> 0&#41; &#123;
begin_frame&#40;"$catname", center&#41;;
$dead=1;
if &#40;$_GET&#91;"incldead"&#93; == 1&#41; &#123;
$addparam .= "incldead=1&";
if &#40;!isset&#40;$CURUSER&#41; || get_user_class < UC_ADMINISTRATOR&#41;
$wherea&#91;&#93; = "banned != 'yes'";
&#125;
else
if &#40;$_GET&#91;"incldead"&#93; == 2&#41;
$wherea&#91;&#93; = "seeders = '0'";
else
$wherea&#91;&#93; = "seeders >= '1'";
$where = "WHERE seeders >= '1' AND category = '$catcount'";
$query = "SELECT torrents.id, torrents.category, torrents.leechers, torrents.seeders, torrents.name, torrents.times_completed, torrents.size, torrents.added, torrents.comments,torrents.numfiles,torrents.filename,torrents.nfo,torrents.owner,IF&#40;torrents.nfo <> '', 1, 0&#41; as nfoav," .
"IF&#40;torrents.numratings < $minvotes, NULL, ROUND&#40;torrents.ratingsum / torrents.numratings, 1&#41;&#41; AS rating, categories.name AS cat_name, categories.image AS cat_pic, users.username FROM torrents LEFT JOIN categories ON category = categories.id LEFT JOIN users ON torrents.owner = users.id $where AND torrents.added>='$date_time' $orderby $limit";
$res = mysql_query&#40;$query&#41;
or die&#40;mysql_error&#40;&#41;&#41;;

if &#40;$CURUSER != ""&#41;&#123;
if &#40;$nooftor&#41; &#123;
list&#40;$pagertop, $pagerbottom, $limit&#41; = pager&#40;1000, $count, "index.php?" . $addparam&#41;;
echo '
';
torrenttable&#40;$res&#41;;
echo '
';
&#125;
if &#40;!$nooftor&#41;&#123;
begin_frame&#40;"Nie znaleziono!"&#41;;
echo"

Nie uploadowano dzisiaj torrentów!

";
end_frame&#40;&#41;;
&#125;
&#125;
else
bark2&#40;"Musisz być zalogowany, aby oglądać najnowsze torrenty!", "Zarejetruj sie, i zaloguj się, aby je obejrzeć!"&#41;;

end_frame&#40;&#41;;
&#125;
$catcount=$catcount+1;
&#125;
stdfoot&#40;&#41;;
?>

[hammond1]

Działa to ale nie do końca nie pokazuje wszystkich kategori np. filmy/xvid jakieś pomysły czemu tak jest.

[P2PST]

masz tutaj ten kod bo cos krzaczki były w powyższym poscie jka dałem:

<?
require_once("include/bittorrent.php");
dbconn(false);
loggedinorreturn();
stdhead("Dzisiaj wstawione torrenty");


$orderby = "ORDER BY torrents.id DESC";

$date_time=get_date_time(time()-(3600*24)); // the 72 is the hours you want listed
$id_result= mysql_query("SELECT id FROM categories");
$noofcats=mysql_num_rows($id_result);
while ( $cat_array = mysql_fetch_array($id_result, MYSQL_ASSOC) and $_GET["cat"] == 0) {
$id_array = $cat_array["id"];
$result= mysql_query("SELECT * FROM torrents where category ='$id_array' AND visible = 'yes' AND added>='$date_time'");
$nooftor=mysql_num_rows($result);
$result= mysql_query("SELECT name FROM categories where id='$id_array'");
$temp=mysql_fetch_assoc($result);
$catname=$temp["name"];
if ($nooftor <> 0) {
begin_frame("$catname", center);
$dead=1;
if ($_GET["incldead"] == 1) {
$addparam .= "incldead=1&";
if (!isset($CURUSER) || get_user_class < UC_ADMINISTRATOR)
$wherea[] = "banned != 'yes'";
**
else
if ($_GET["incldead"] == 2)
$wherea[] = "seeders = '0'";
else
$wherea[] = "seeders >= '1'";
$where = "WHERE seeders >= '0' AND category = '$id_array'";
$query = "SELECT torrents.id, torrents.category, torrents.leechers, torrents.seeders, torrents.name, torrents.times_completed, torrents.size, torrents.added, torrents.comments,torrents.numfiles,torrents.filename,torrents.nfo,torrents.owner,IF(torrents.nfo <> '', 1, 0) as nfoav," .
"IF(torrents.numratings < $minvotes, NULL, ROUND(torrents.ratingsum / torrents.numratings, 1)) AS rating, categories.name AS cat_name, categories.image AS cat_pic, users.username, users.anonymous FROM torrents LEFT JOIN categories ON category = categories.id LEFT JOIN users ON torrents.owner = users.id $where AND torrents.added>='$date_time' $orderby $limit";
$res = mysql_query($query)
or die(mysql_error());

if ($CURUSER != ""){
if ($nooftor) {
list($pagertop, $pagerbottom, $limit) = pager(1000, $count, "index.php?" . $addparam);
echo '<br>';
torrenttable($res);
echo '<br>';
**
if (!$nooftor){
begin_frame("Nie znaleziono!");
echo"<BR><BR>Nie uploadowano dzisiaj torrentów!<BR><BR>";
end_frame();
**
**
else
bark2("Musisz być zalogowany, aby ogl&#177;dać najnowsze torrenty!", "Zarejetruj sie, i zaloguj się, aby je obejrzeć!");

end_frame();
**
$catcount=$catcount+1;
**
stdfoot();
?>

zamist tego ** wstaw klamerke czyli zamkniecie i otwarcie