Просмотр поста

Максим (29.01.2011/15:43)
функцию в студию.

function aktiv($user) {

    ////////////////////////////////////////////////////////////

    // Рейтинг активности                                //

    ////////////////////////////////////////////////////////////

///файлы///
    $down = mysql_result(mysql_query("SELECT COUNT(*) FROM `down_files` WHERE `type` = 2 AND `user_id` = '".$user."'"), 0);
	
///библа///
	$nik = mysql_query("select `name` from `users` where id='$user';");
    $nikus = mysql_fetch_array($nik);
    $bibla = mysql_result(mysql_query("SELECT COUNT(*) FROM `lib` WHERE `avtor` = '" . $nikus['name'] . "' AND `type` = 'bk' AND `moder` = '1'"), 0);

  ///опросы///
  $vote = mysql_result(mysql_query("SELECT COUNT(*) FROM `u_vote` where `user_id` = '".$user."'"), 0);

  ///аудиотека///
  $music = mysql_result(mysql_query("SELECT COUNT(*) FROM `music` WHERE `user` = '" . $user . "' "), 0);
  
     ///видеотека///
  $video = mysql_result(mysql_query("SELECT COUNT(*) FROM `video` WHERE `user` = '" . $user . "' "), 0);
	
	///блог///
	$bloge = mysql_result(mysql_query("SELECT COUNT(*) FROM `blog` WHERE `user` = '" . $user . "' and `news` = '0' "), 0);

	///новости музыки///
	$news = mysql_result(mysql_query("SELECT COUNT(*) FROM `blog` WHERE `user` = '" . $user . "' and `news` = '1' "), 0);
	
	///бан///
	$ban = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_ban_users` WHERE `user_id` = '" . $user . "'"), 0);
	
	///фото в анкете///
	if (file_exists(('../files/photo/' . $user. '_small.jpg'))) {
	$photo = 3;}else{$photo = 0;}
	
	///фото в альбоме///
	$gal = mysql_result(mysql_query("SELECT COUNT(*)  from `cms_album_files` where `user_id`='" . $user . "'"), 0);
	
	////Созданные фанклубы////
	$club = mysql_result(mysql_query("SELECT COUNT(*)  from `cat` where `from`='" . $user . "'"), 0);
	
	////биографии////
	$bio = mysql_result(mysql_query("SELECT COUNT(*)  from `cat_info` where `user`='" . $user . "'"), 0);
	
	////теги////
	$tag = mysql_result(mysql_query("SELECT COUNT(*)  from `cat_tag` where `user`='" . $user . "'"), 0);
	
	
	
	
	
	
        $total = $down*5+$bibla*5+$vote+$music+$video*4+$bloge*2+$news*4-$ban*5+$photo+$gal+$club*5+$bio*2+$tag ;

    return $total;

}