Файл: settings/info/count.php
Строк: 46
<?
/******************************************************************************/
$q=mysql_fetch_array(mysql_query("SELECT * FROM `city` WHERE `city_id`='$ank[mycity]' LIMIT 1"));
$stra=$q['country_id'];
$regi=$q['region_id'];
$qregi=mysql_fetch_array(mysql_query("SELECT * FROM `region` WHERE `region_id`='$regi' LIMIT 1"));
$qcoun=mysql_fetch_array(mysql_query("SELECT * FROM `country` WHERE `country_id`='$stra' LIMIT 1"));
/******************************************************************************/
$d1sql = mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE (`user` = '$user[id]' AND `to` = '$ank[id]') OR (`user` = '$ank[id]' AND `to` = '$user[id]') LIMIT 1");
$d2sql = mysql_query("SELECT COUNT(*) FROM `frends` WHERE (`user` = '$ank[id]' AND `frend` = '$user[id]') OR (`user` = '$user[id]' AND `frend` = '$ank[id]') LIMIT 1");
/******************************************************************************/
$sum = mysql_result(mysql_query("SELECT COUNT(*) FROM `garem` WHERE `id_garem`='".$ank['id']."'"),0);
/******************************************************************************/
$avkom=mysql_result(mysql_query("SELECT COUNT(*) FROM `avkom` WHERE `id_user_adm` = $ank[id] ",$db), 0);
/******************************************************************************/
$k_p_g=mysql_result(mysql_query("SELECT COUNT(*) FROM `us_guest` WHERE `id_user_adm` = $ank[id] ",$db), 0);
/******************************************************************************/
$mod_dei=mysql_result(mysql_query("SELECT COUNT(*) FROM `mod_dei_go` WHERE `uid` = '$ank[id]'"),0);
/******************************************************************************/
$blog=mysql_result(mysql_query("SELECT COUNT(*) FROM `blog_list` WHERE `id_user` = '$ank[id]'"),0);
/******************************************************************************/
$foto=mysql_num_rows( mysql_query( "SELECT `id` FROM `gallery` WHERE `id_user` = '$ank[id]'" ) );
/******************************************************************************/
$prezent=mysql_result(mysql_query("SELECT COUNT(*) FROM `present_give` WHERE `id_give` = $ank[id] ",$db), 0);
/******************************************************************************/
$audio=mysql_result(mysql_query("SELECT count(*) FROM `audio_file` WHERE `id_user`='$ank[id]'"),0);
/******************************************************************************/
$filse=mysql_result(mysql_query("SELECT COUNT(*) FROM `obmennik_files` WHERE `id_user` = '$ank[id]'"),0);
/******************************************************************************/
$chit=mysql_result(mysql_query("SELECT COUNT(*) FROM `my_guests` WHERE `id_ank` = '$ank[id]'"),0);
/******************************************************************************/
$comm=mysql_num_rows(mysql_query("SELECT `id` FROM `community_user_incomm` WHERE `uid` = '$ank[id]'"));
/******************************************************************************/
$avlike=mysql_result(mysql_query("SELECT COUNT(*) FROM `ava_laik` WHERE `id_kont` = '$ank[id]'"),0);
/******************************************************************************/
$pol=($ank['pol']==1) ? '' : '(а)';
/******************************************************************************/
$perehodu=mysql_result(mysql_query("SELECT `perehodu` FROM `user` WHERE `id` = '$ank[id]' LIMIT 1",$db), 0);
/******************************************************************************/
if (isset($user) && $user['id']!=$ank['id'])
{mysql_query("UPDATE `user` SET `prosm` = '".($ank['prosm']+1)."' WHERE `id` = '$ank[id]' LIMIT 1");}
/******************************************************************************/
?>