eckeO5 |
6th January 2015 21:37 |
ajaxtorrent1.php
Hello DAKz , lafouine022 and all others,
happy new 2015.
may be you or some1 can help.
question is about ajaxtorrent1.php an all its included phps.
f.e. in top_last.php i got working to see 22 torrents, each row 11 showing up.
looks like this
http://puu.sh/e9UQr/b0f6c5e5b6.jpg
Does ne1 know how to show f.e. 4 rows with exactly 44 torrents in all ???
top_last.php actual looks like this:
PHP Code:
<?php require('global.php'); dbconn();
header("Content-Type: text/html; charset=iso-8859-1");
//Letzen XX torrents mit bild
define('ANZAHL_NEUESTE_TORRENTS', 22);
//begin_frame("..:: Die ".ANZAHL_NEUESTE_TORRENTS." neusten Torrents ::..","true","100%"); $query="SELECT id, name, t_image, seeders, leechers, category, size, free, doubleupload, silver, offensive, times_completed FROM torrents WHERE t_image <> '' ORDER BY added DESC LIMIT 22"; $result=mysql_query($query); $num = mysql_num_rows($result); // count rows print'<scrollAmount=2 onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=2" scrolldelay="0"
direction="left">'; print '<center><table border=0 cellspacing=0 cellpadding=5><tr>'; $i=20; $count = 11; while ($row = mysql_fetch_assoc($result)) {
if ($row['offensive'] == 'yes' && preg_match('#E0#is', $CURUSER['options']))
{ continue; }
$id = $row['id']; if(($count == 22)) //Wieviel in einer Reihe? print'</tr><tr><td>'; else print'<td>'; $res = mysql_query("SELECT name FROM categories WHERE id=$row[category]"); $arr = mysql_fetch_assoc($res); $cat = $arr["name"];
$free = mysql_query("SELECT * FROM torrents WHERE free = 'yes'") or sqlerr(); if ($row[free]=="yes") { $free="<b><font color=green> [OnlyUpload] </font></b>"; } else { $free=""; }
$doubleupload = mysql_query("SELECT * FROM torrents WHERE doubleupload = 'yes'") or sqlerr(); if ($row[doubleupload]=="yes") { $doubleupload="<b><font color=yellow> [DoubleUpload] </font></b>"; } else { $doubleupload=""; }
$silver = mysql_query("SELECT * FROM torrents WHERE silver = 'yes'") or sqlerr(); if ($row[silver]=="yes") { $silver="<b><font color=yellow> [fifty-fifty] </font></b>"; } else { $silver=""; }
$size = mksize($row["size"]); $res=mysql_query("SELECT * FROM peers WHERE torrent=$id AND seeder = 'yes'") or sqlerr(); $seeder=mysql_num_rows($res); $res=mysql_query("SELECT * FROM peers WHERE torrent=$id AND seeder != 'yes'") or sqlerr(); $leecher=mysql_num_rows($res); $t_image = $row['t_image']; $name = $row['name']; $name = str_replace('_', ' ' , $name); $name = str_replace('.', ' ' , $name); $name = substr($name, 0, 100); print("<a href=\"/details.php?id=$id&hit=1\" onMouseover=\"overlib('<table cellpadding=4 cellspacing=1 width=100% height=80><tr><td class=tablea align=center ><b><font color=white>$name</font></b><font color=yellow><b>Typ: $cat</font><font color=lime><b>$seeder Seeder</font><font color=red>$leecher Leecher</font><font color=white>Größe: $size</font><font color=white>$row[times_completed] x Runtergeladen</font><font color=red>$free<font color=red>$doubleupload<font color=red>$silver</font></td></tr></table>','darkorange')\" onMouseout=\"nd()\"><img src=$t_image width=\"82\" height=\"100\" border=1></a><b>$seeder : <font color=green>Seeder</font>$leecher : <font color=red>Leecher</font></b>"); $i++; $count++; } print'</td>'; echo "</center></table></marquee>";
?>
Would be so glad if some1 can help.
Ahny to all of you.
eckeo5
|