"; $result=$db->sql_query("SELECT ratinguser, rating, ratingcomments, ratingtimestamp FROM ".$prefix."_links_votedata WHERE ratinglid = $lid AND ratingcomments != '' ORDER BY ratingtimestamp DESC"); $totalcomments = $db->sql_numrows($result); $transfertitle = ereg_replace ("_", " ", $ttitle); $transfertitle = stripslashes($transfertitle); $displaytitle = $transfertitle; OpenTable(); echo ""._LINKPROFILE.": $displaytitle

"; linkinfomenu($lid, $ttitle); echo "


"._TOTALOF." $totalcomments "._COMMENTS."
" .""; $x=0; while(list($ratinguser, $rating, $ratingcomments, $ratingtimestamp)=$db->sql_fetchrow($result)) { $ratingcomments = stripslashes($ratingcomments); ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $ratingtimestamp, $ratingtime); $ratingtime = strftime("%F",mktime($ratingtime[4],$ratingtime[5],$ratingtime[6],$ratingtime[2],$ratingtime[3],$ratingtime[1])); $date_array = explode("-", $ratingtime); $timestamp = mktime(0, 0, 0, $date_array["1"], $date_array["2"], $date_array["0"]); $formatted_date = date("F j, Y", $timestamp); /* Individual user information */ $result2=$db->sql_query("SELECT rating FROM ".$prefix."_links_votedata WHERE ratinguser = '$ratinguser'"); $usertotalcomments = $db->sql_numrows($result2); $useravgrating = 0; while(list($rating2)=$db->sql_fetchrow($result2)) $useravgrating = $useravgrating + $rating2; $useravgrating = $useravgrating / $usertotalcomments; $useravgrating = number_format($useravgrating, 1); echo "" ."" ."" ."" ."" ."" ."" ."" ."" .""; $x++; } echo "

" ." "._USER.": $ratinguser" ."	" .""._RATING.": $rating" ."	" ."$formatted_date" ."
" .""._USERAVGRATING.": $useravgrating" ."	" .""._NUMRATINGS.": $usertotalcomments" ."
" .""; if (is_admin($admin)) { echo ""; } echo " $ratingcomments" ."

"; linkfooter($lid,$ttitle); echo ""; CloseTable(); @include("footer.php"); } ?>