= '1') ? "AND `team_id`='".strip_tags($_GET['team'])."'" : ""; $plusteam1 = ($_GET['team'] >= '1') ? "&team=".$_GET['team'] : ""; $plusteam2 = ($_GET['team'] >= '1') ? "?team=".$_GET['team'] : ""; if(!isset($search)) $s = "SELECT * FROM `torrents` WHERE `timestamp`>'".$lastweek."' ".$and." ORDER BY `timestamp` DESC"; else $s = "SELECT * FROM `torrents` WHERE `name` REGEXP '.*".str_replace("-", ".*", $search).".*' AND `timestamp`>'".$lastweek."' ".$and." ORDER BY `timestamp` DESC"; $q = mysql_query($s); $n = mysql_num_rows($q); $numb = 1; $numt = 0; if($n == '0') echo "<1>\00304,00Aucun résultat.\n"; while($d = mysql_fetch_array($q)) { if($numt == 5) { if(!empty($search)) echo "<".$numb.">\00304,00Pour plus de résultats : \00312,00\037http://animesbt.org/lastrlz.php?search=".str_replace("-", " ", $search).$plusteam1."\n"; else echo "<".$numb.">\00304,00Pour plus de résultats : \00312,00\037http://animesbt.org/lastrlz.php".$plusteam2."\n"; $numb++; echo "<".$numb.">-----"; exit(); } $s2 = "SELECT * FROM `teams` WHERE `id`='".$d['team_id']."'"; $q2 = mysql_query($s2); $d2 = mysql_fetch_array($q2); if($date != date("j", $d['timestamp'])) { $date = date("j", $d['timestamp']); echo "<".$numb.">\00314,00".datefr(date("l j F", $d['timestamp']))."\n"; } $bgcolor = $i == 0 ? "#c9def5" : "#accbe8"; echo "<".$numb.">\00303,00".html_entity_decode(torrentName($d['id']))." \00310,00par \00313,00".$d2['name']." - \00312,00\037http://animesbt.org/dl.php?id=".$d['id']."\n"; $i = $i == 0 ? 1 : 0; $numt++; $numb++; } echo "<".$numb.">-----"; exit(); } include('header.php'); ?>
= '1') ? "AND `team_id`='".strip_tags($_GET['team'])."'" : ""; $lastweek = mktime(0, 0, 0, date("m") , date("d") - 6, date("Y")); if(!isset($search)) $s = "SELECT * FROM `torrents` WHERE `timestamp`>'".$lastweek."' ".$and." ORDER BY `timestamp` DESC"; else $s = "SELECT * FROM `torrents` WHERE `name` REGEXP '.*".str_replace("-", ".*", $search).".*' AND `timestamp`>'".$lastweek."' ".$and." ORDER BY `timestamp` DESC"; $q = mysql_query($s) or die('Erreur : '.mysql_error()); while($d = mysql_fetch_array($q)) { $s2 = "SELECT * FROM `teams` WHERE `id`='".$d['team_id']."'"; $q2 = mysql_query($s2); $d2 = mysql_fetch_array($q2); if($date != date("j", $d['timestamp'])) { $date = date("j", $d['timestamp']); echo ""; } $bgcolor = $i == 0 ? "#c9def5" : "#accbe8"; echo ""; $i = $i == 0 ? 1 : 0; } ?>
Dernière sorties
".datefr(date("l j F", $d['timestamp']))."
".torrentName($d['id'])."".$d2['name']."