Reviews
|
|
if($_GET["sort"] == "")
{
$sort = "reviews.xmldatum DESC";
} else if($_GET["sort"] == "0") {
$sort = "Systeem.kortenaam";
} else if($_GET["sort"] == "1") {
$sort = "Titel.titel";
} else if($_GET["sort"] == "2") {
$sort = "members.username";
} else if($_GET["sort"] == "3") {
$sort = "reviews.score5 DESC";
} else if($_GET["sort"] == "4") {
$sort = "reviews.xmldatum DESC";
}
if($_GET["systeem"] == "")
{
$systeemid = "Product.systeem_id <>'17'";
} else if($_GET["systeem"] == "1") {
$systeemid = "Product.systeem_id ='1'";
} else if($_GET["systeem"] == "2") {
$systeemid = "Product.systeem_id ='2'";
} else if($_GET["systeem"] == "7") {
$systeemid = "Product.systeem_id ='7'";
} else if($_GET["systeem"] == "4") {
$systeemid = "Product.systeem_id ='4'";
} else if($_GET["systeem"] == "15") {
$systeemid = "Product.systeem_id ='15'";
} else if($_GET["systeem"] == "3") {
$systeemid = "Product.systeem_id ='3'";
} else if($_GET["systeem"] == "0") {
$systeemid = "Product.systeem_id <>'17'";
} else if($_GET["systeem"] == "9") {
$systeemid = "Product.systeem_id ='9'";
} else if($_GET["systeem"] == "10") {
$systeemid = "Product.systeem_id ='10'";
} else
{
$systeemid = "Product.systeem_id <>'17'";
}
$sql = "SELECT reviews.product_id AS prodid, reviews.id, Titel.titel, members.username, reviews.score5, reviews.xmldatum, Systeem.kortenaam AS systeem
FROM reviews,Titel,members,Product,Systeem
WHERE reviews.product_id = Product.id AND Product.titel_id = Titel.id AND reviews.auteur = members.id AND reviews.preview = '0' AND Systeem.id = Product.systeem_id AND ".$systeemid." ORDER BY ".$sort;
$producten = mysql_query($sql);
$inhoud = array();
//echo($sql);
$i=0;
while($row = mysql_fetch_array($producten))
{
$inhoud[$i]= array();
$inhoud[$i][0] = $row["prodid"];
$inhoud[$i][1] = $row["titel"];
$inhoud[$i][2] = $row["username"];
$inhoud[$i][3] = $row["score5"];
$inhoud[$i][4] = $row["xmldatum"];
$inhoud[$i][5] = $row["systeem"];
$i++;
}
//print_r($inhoud);
geefReviewLijst(array("Systeem", "Game", "Auteur", "Punt", "Datum"), $inhoud);
?>
|
geefRechterIndexBalk(); ?>
include("footer.inc");
?>
|