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