<?php

if (!defined("IN_FUSION")) { die("Access Denied"); }



include LOCALE.LOCALESET."ratings_useralbum.php";



openside("".$locale['r111']."");

$restar = dbquery("SELECT tp.*, SUM(tr.rating_vote)/COUNT(tr.rating_item_id) as score, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes FROM ".DB_USERS." tp LEFT JOIN ".DB_RATINGS." tr ON tr.rating_item_id = tp.user_id AND tr.rating_type='M' GROUP BY user_id ORDER BY score DESC, count_votes DESC, user_name DESC LIMIT 0,3");



while ($data = dbarray($restar)) {

if ($data['score'] > 0)

if ($data['user_avatar'] != "") {

$avatar = "<a href='".BASEDIR."profile_galerie.php?lookup=".$data['user_id']."' alt=''><img style='margin:2px' align='left'  border='0'  height='25' width='25' src='".BASEDIR."images/avatars/".$data['user_avatar']."' title='".$data['user_name']."'></a>";

}else{

$avatar = "<a href='".BASEDIR."profile_galerie.php?lookup=".$data['user_id']."' alt=''><img style='margin:2px' align='left'  border='0' height='25' width='25' src='".IMAGES."avatars/noav.gif' title='".$data['user_name']."'></a>";

}



echo "<table width='100%' align='center' cellpadding='0' cellspacing='0'>\n<tr>

"; //<td align='left' valign='top'>".$avatar." <a href='".BASEDIR."profile_galerie.php?lookup=".$data['user_id']."' alt=''> <b>".$data['user_name']."*s ".$locale['r113']."</b></a><br />".$locale['r112']." ".$data['score']." l ".$locale['r110']." ".$data['count_votes']."<br /><br /></td></tr>

echo"

<td align='left' valign='top'><a href='".BASEDIR."profile_galerie.php?lookup=".$data['user_id']."' alt=''> <b>".$data['user_name']."*s ".$locale['r113']."</b></a><br />".$locale['r112']." ".$data['score']." l ".$locale['r110']." ".$data['count_votes']."<br /><br /></td></tr>



</table>";

}

closeside();

?>

echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>\n</tr>";

      }

      echo "</table>\n";

   } else {

      redirect("index.php");

   }

}

closetable();

if (file_exists(INFUSIONS."fsc_userguestbook/fsc_userguestbook.php")) {

include INFUSIONS."fsc_userguestbook/fsc_userguestbook.php";

}

//start useralbum



opentable("".$user_data['user_name']."*s Fotoalbum");



echo "<br><table align='center' cellpadding='0' cellspacing='1' width='400' class='tbl-border'><td align='left' class='tbl2'>";

if (!iMEMBER || iMEMBER && $user_data['user_id'] != $userdata['user_id']) {



echo "<center><b>Klicken Sie auf Fotos um es in Originalgröße zu sehen.</b></center>";



}else{



echo "<center><a title='Foto-Album Bearbeiten' href='".BASEDIR."edit_userprofilepics.php'><b>Foto-Album Bearbeiten</b></a></center>";



}

echo "</td></table><br>";





include('userprofilepics.php');





closetable();



//end useralbum

require_once THEMES."templates/footer.php";

?>