parseSceneIdData("getUserInfo", array("userID" => $who)); if(is_array($returnvalue["user"])&&is_array($user)) { $r = $returnvalue["user"]; $sceneIDData = $r; } mysql_query("update users set sceneIDLastRefresh = now(), sceneIDData='".mysql_real_escape_string(serialize($returnvalue["user"]))."' where id=".$who); } else { $sceneIDData = unserialize( $user["sceneIDData"] ); } unset( $sceneIDData["nickname"] ); $user = array_merge($user, $sceneIDData); $query="SELECT prods.id,prods.name,prods.group1,prods.group2,prods.group3,prods.type,comments.who,comments.comment,comments.rating,comments.quand,users.nickname,users.avatar,UNIX_TIMESTAMP()-UNIX_TIMESTAMP(comments.quand) as difftime FROM prods JOIN comments JOIN users WHERE comments.which=prods.id AND comments.who=users.id AND comments.who=".$who; if ($nothumbsdown) $query.=" AND comments.rating!=-1"; if ($nopiggies) $query.=" AND comments.rating!=0"; if ($nothumbsup) $query.=" AND comments.rating!=1"; $query.=" ORDER BY comments.quand DESC"; $query.=" LIMIT ".(($page-1)*$linebypage).",".$linebypage; //if ($com) $query.=" LIMIT ".$com; else $query.=" LIMIT 12"; $result = mysql_query($query); while($tmp = mysql_fetch_assoc($result)) { $comments[] = $tmp; } for ($i=0; $i27): if (strlen($comments[$i]["groupn1"])>10 && $comments[$i]["groupacron1"]) $comments[$i]["groupn1"]=$comments[$i]["groupacron1"]; if (strlen($comments[$i]["groupn2"])>10 && $comments[$i]["groupacron1"]) $comments[$i]["groupn2"]=$comments[$i]["groupacron2"]; if (strlen($comments[$i]["groupn3"])>10 && $comments[$i]["groupacron1"]) $comments[$i]["groupn3"]=$comments[$i]["groupacron3"]; endif; $query="select platforms.name from prods_platforms, platforms where prods_platforms.prod='".$comments[$i]["id"]."' and platforms.id=prods_platforms.platform"; $result=mysql_query($query); $check=0; $comments[$i]["platform"]=""; while($tmp = mysql_fetch_array($result)) { if ($check>0) $comments[$i]["platform"].=","; $check++; $comments[$i]["platform"].=$tmp["name"]; } endfor; //print("
->".count($comments)."<-"); for($i=0;$i27): if (strlen($cdc[$i]["groupname1"])>10) $cdc[$i]["groupname1"]=$cdc[$i]["groupacron1"]; if (strlen($cdc[$i]["groupname2"])>10) $cdc[$i]["groupname2"]=$cdc[$i]["groupacron2"]; if (strlen($cdc[$i]["groupname3"])>10) $cdc[$i]["groupname3"]=$cdc[$i]["groupacron3"]; endif; /*$query="select platforms.name from prods_platforms, platforms where prods_platforms.prod='".$cdc[$i]["id"]."' and platforms.id=prods_platforms.platform"; $result=mysql_query($query); $check=0; $cdc[$i]["platform"]=""; while($tmp = mysql_fetch_array($result)) { if ($check>0) $cdc[$i]["platform"].=", "; $check++; $cdc[$i]["platform"].=$tmp["name"]; }*/ endfor; // average rating $query="SELECT SUM(rating)/count(0) FROM comments WHERE who=".$user["id"]; $result=mysql_query($query); $avg_rating=mysql_result($result,0); ?>

" width="16" height="16">   information information glöps 0)&&($user["url"]!="http://")): ?> level: nickname: country: email: hidden '; else: echo recaptcha_mailhide_html(RECAPTCHA_MAILHIDE_PUB_KEY, RECAPTCHA_MAILHIDE_PRIV_KEY, $user["email"]); endif; ?> website: "> : "); ?> uin:  ".$user["uin"]." "); ?> ojuice: profile "); ?> slengpung: " target=_blank>pictures csdb: " target=_blank>profile zxdemo: " target=_blank>profile coup de coeur: ".stripslashes($cdc[$i]["name"])); ?> ".stripslashes($cdc[$i]["groupname1"]).""); if ($cdc[$i]["groupname2"]) print(" and ".stripslashes($cdc[$i]["groupname2"]).""); if ($cdc[$i]["groupname3"]) print(" and ".stripslashes($cdc[$i]["groupname3"]).""); ?> average rating: 0) $thumbgfx="gfx/rulez.gif"; elseif($avg_rating==0) $thumbgfx="gfx/isok.gif"; else $thumbgfx="gfx/sucks.gif"; ?>   [glopper view] [recommendations only] [kaka taste] [all comments] " width="160" height="160" class='largeavatar'>

0): ?>

"> ".stripslashes($comments[$i]["groupn1"]).""); if ($comments[$i]["groupn2"]) print(" :: ".stripslashes($comments[$i]["groupn2"]).""); if ($comments[$i]["groupn3"]) print(" :: ".stripslashes($comments[$i]["groupn3"]).""); ?> "); break; case -1: print(""); break; default: print(""); } ?> ".$comments[$i]["id"]."<->".$cdc[$ii]."|"); if ($cdc[$ii]["id"]==$comments[$i]["id"]) print(""); } ?>   =2): ?>   previous page   next page

*clicki clicki clacki* (\/) - - (\/) *clacki clacki clicki*
ciega ciega ciega frikki!!"); ?>