// USER reputation funk
function userreputation($user_id, $post_id="", $type="") {
global $db_prefix;
 
$result = dbquery("SELECT
SUM(IF(type=1,1,-1)) as total
FROM
".$db_prefix."reputation
WHERE
to_id = '$user_id'
GROUP BY
to_id");
 
if (dbrows($result) != 0) {
$data = dbarray($result);
$total = $data['total'];
$info = "<sup>[ <a href='reputation.php?uid=$user_id&pid=$post_id'><font color='".($total<0?"red":($total>0?"green":"black"))."'><b>".($total<=0?"":"+")."$total</b></font></a> ]</sup>";
} else {
$info = "<sup>[ <a href='reputation.php?uid=$user_id&pid=$post_id'><font color='black'><b>0</b></font></a> ]</sup>";
}
return $info;
}
Parsed in 0.024 seconds, using GeSHi 1.0.8.10

<a href='../profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a>
Parsed in 0.025 seconds, using GeSHi 1.0.8.10

<a href='../profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a> ".userreputation($data['user_id'], $data['post_id'])."
Parsed in 0.024 seconds, using GeSHi 1.0.8.10