=UC_MODERATOR); if ($_POST["action"] == "add") { $cat=0+$_POST["cat"]; $titel=trim($_POST["titel"]); $info=trim($_POST["info"]); if($titel!=""&&$info!="") { mysql_query(sprintf("insert into requests (user,kategorie,titel,info,added) values (%d,%d,%s,%s,NOW())",$CURUSER["id"],$cat,sqlesc($titel),sqlesc($info))); mysql_query("insert into votes (what,user,voteid) values ('requests',$CURUSER[id],".mysql_insert_id().")"); } else stderr("FEHLER", "Alle Felder müssen ausgefüllt werden"); } if ($_POST["action"] == "closed") { $tid=0+$_POST["tid"]; $id=0+$_POST["id"]; if($tid>0) { $res=mysql_query("select id from torrents where id=".sqlesc($tid)); if(mysql_num_rows($res)===1) { mysql_query("update requests set closed=".sqlesc($tid)." where id=$id"); } else stderr("FEHLER","Ein Torrent mit der ID $tid gibt es nicht"); } else stderr("FEHLER","Du musst die ID des Torrents angeben (steht bei den Torrent-Details in der Browser-Zeile!)"); } if ($_GET["action"] == "vote") { $voteid=0+$_GET["id"]; $res=mysql_query("select id from votes where what='requests' and voteid=$voteid and user=$CURUSER[id]"); if(mysql_num_rows($res)===0) mysql_query("insert into votes (what,user,voteid) values ('requests',$CURUSER[id],$voteid)"); } if ($_GET["action"]=="del") { if($mod) { $voteid=0+$_GET["id"]; mysql_query("delete from votes where what='requests' and voteid=$voteid"); mysql_query("delete from requests where id=$voteid"); } else stderr("Fehler","Du hast hier nix zu suchen. Verschwinde!"); } if ($_GET["action"]=="info") { $infoid=0+$_GET["id"]; } $res=mysql_query("select * from categories order by name"); $cats="\n"; mysql_free_result($res); $res=mysql_query("select requests.*,count(votes.id) as votes,categories.name,categories.image,users.username from requests,votes,categories,users where votes.what='requests' and votes.voteid=requests.id and categories.id=requests.kategorie and users.id=requests.user group by requests.id order by requests.added desc limit 50"); $_a=0; stdhead("Torrent-Requests"); ?>

Torrent-Requests

".($mod?"":"").""; if(mysql_num_rows($res)<1) echo "\n"; else while($r=mysql_fetch_assoc($res)) { echo ""; echo ""; echo ""; if($r["closed"]<1) { echo ""; } else { echo ""; } echo ($mod?"":"")."\n"; } ?>

class=tabletitle>Vorhandene Requests
Kategorie	Titel	Von	Vom	Votes	Erfüllt	Löschen
Es sind keine Requests vorhanden
	".($infoid!=$r["id"]?"$r[titel]":"$r[titel] ".format_comment($r["info"]))."	$r[username]	$r[added]	$r[votes]	"; echo " ID: "; echo "	Ja

= UC_USER) { ?>