<?
////////////////////////////////////kolregisred//////////////////////
$koll_reg=@mysql_query("SELECT count(*) FROM `c_users` ;");
$itog_koll_reg = @mysql_fetch_array($koll_reg);
$koll_seg=@mysql_query("SELECT count(*) FROM `c_users` WHERE `datareg`='".$daten."';");
$itog_koll_seg = @mysql_fetch_array($koll_seg);
/////////////////////////////////////////////////////////////////////
//////////////////////////////////pravila/////////////////////////
$koll_p_pravila=@mysql_query("SELECT count(*) FROM `c_pravila` WHERE `komu`='p';");
$itog_p_pravila = @mysql_fetch_array($koll_p_pravila);
$koll_m_pravila=@mysql_query("SELECT count(*) FROM `c_pravila` WHERE `komu`='m';");
$itog_m_pravila = @mysql_fetch_array($koll_m_pravila);
////////////////////////////////////////////////////////////////////
//////////////////////////////news//////////////////////////////////////////////
$koll_c_news=@mysql_query("SELECT count(*) FROM `c_news`;");
$itog_c_news = @mysql_fetch_array($koll_c_news);
$dat_news=@mysql_query("SELECT `data` FROM `c_news` ORDER BY `id` DESC LIMIT 1;");
$new_dat_new = @mysql_fetch_array($dat_news);
/////////////////////////////////////////////////////////////////////////////////
//////////////////////////////обьявления//////////////////////////////////////////////
$koll_c_obiav=@mysql_query("SELECT count(*) FROM `c_obiav`;");
$itog_c_obiav = @mysql_fetch_array($koll_c_obiav);
$koll_pc_obiav=@mysql_query("SELECT count(*) FROM `c_obiav` WHERE `kuda`='p';");
$itog_pc_obiav = @mysql_fetch_array($koll_pc_obiav);
/////////////////////////////////////////////////////////////////////////////////
//////////////////////////////Свадьбы чата//////////////////////////////////////////////
$koll_c_svadb=@mysql_query("SELECT count(*) FROM `c_svadb`;");
$itog_c_svadb = @mysql_fetch_array($koll_c_svadb);
/////////////////////////////////////////////////////////////////////////////////
//////////////////////////////Infa//////////////////////////////////////////////
$koll_c_infaraz=@mysql_query("SELECT count(*) FROM `c_infaraz`;");
$itog_c_infaraz = @mysql_fetch_array($koll_c_infaraz);
$koll_c_infamgs=@mysql_query("SELECT count(*) FROM `c_infamgs`;");
$itog_c_infamgs = @mysql_fetch_array($koll_c_infamgs);
/////////////////////////////////////////////////////////////////////////////////
//////////////////////////////Vstrech//////////////////////////////////////////////
$koll_c_vsterch=@mysql_query("SELECT count(*) FROM `c_vsterch`;");
$itog_c_vsterch = @mysql_fetch_array($koll_c_vsterch);
/////////////////////////////////////////////////////////////////////////////////
//////////////////////////////mails//////////////////////////////////////////////
$koll_c_mailvhod=@mysql_query("SELECT count(*) FROM `c_mailvhod` WHERE `komu`='".bug($id)."' AND `dell`='1';");
$itog_c_mailvhod= @mysql_fetch_array($koll_c_mailvhod);
$koll_n_mailvhod=@mysql_query("SELECT count(*) FROM `c_mailvhod` WHERE `komu`='".bug($id)."' AND `new`='1' AND `dell`='1';");
$itog_n_mailvhod= @mysql_fetch_array($koll_n_mailvhod);
$koll_y_mailvhod=@mysql_query("SELECT count(*) FROM `c_mailvhod` WHERE `komu`='".bug($id)."' AND `dell`='2';");
$itog_y_mailvhod= @mysql_fetch_array($koll_y_mailvhod);
$koll_y_mailisvhod=@mysql_query("SELECT count(*) FROM `c_mailisvhod` WHERE `kto`='".bug($id)."' AND `dell`='2';");
$itog_y_mailisvhod= @mysql_fetch_array($koll_y_mailisvhod);
$koll_c_mailisvhod=@mysql_query("SELECT count(*) FROM `c_mailisvhod` WHERE `kto`='".bug($id)."' AND `dell`='1';");
$itog_c_mailisvhod= @mysql_fetch_array($koll_c_mailisvhod);
/////////////////////////////////////////////////////////////////////////////////
$koll_dhyh = @mysql_query("SELECT COUNT(*) FROM `c_users` WHERE `day`='".$currDen."' AND `month`='".$currDate."';");
$itog_dhyh= @mysql_fetch_array($koll_dhyh);
///////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////colorrrr//////////////////////////////////////////////////////////
$koll_c_color=@mysql_query("SELECT count(*) FROM `c_color`;");
$itog_c_color=@mysql_fetch_array($koll_c_color);
////////////////////////////////////////////////////////////////////////////////////////
////////////////////////komnot////////////////////////////
$koll_c_komnota=@mysql_query("SELECT count(*) FROM `c_komnota`;");
$itog_c_komnota=@mysql_fetch_array($koll_c_komnota);
$koll_i_komnota=@mysql_query("SELECT count(*) FROM `c_komnota` WHERE `kategor`='inti';");
$itog_i_komnota=@mysql_fetch_array($koll_i_komnota);
$koll_n_komnota=@mysql_query("SELECT count(*) FROM `c_komnota`WHERE `kategor`='inko';");
$itog_n_komnota=@mysql_fetch_array($koll_n_komnota);
$koll_s_komnota=@mysql_query("SELECT count(*) FROM `c_komnota`WHERE `kategor`='sort';");
$itog_s_komnota=@mysql_fetch_array($koll_s_komnota);
$koll_j=@mysql_query("SELECT count(*) FROM `c_users`WHERE `pol`='f';"); $j=@mysql_fetch_array($koll_j);
$koll_m=@mysql_query("SELECT count(*) FROM `c_users`WHERE `pol`='m';"); $m=@mysql_fetch_array($koll_m);
///////////////////////////////////////////
if($liven_us>8)
$pr_count = @mysql_query("SELECT count(*) FROM `c_users` WHERE ltime>'".intval(time()-$offline)."';");
else
$pr_count = @mysql_query("SELECT count(*) FROM `c_users` WHERE ltime>'".intval(time()-$offline)."' and anon ='0';");
$pdc = @mysql_fetch_array($pr_count);
if($liven_us>8)
$pixoh_count = @mysql_query("SELECT count(*) FROM `c_users` WHERE ltime>'".intval(time()-$offline)."' and room='prih';");
else
$pixoh_count = @mysql_query("SELECT count(*) FROM `c_users` WHERE ltime>'".intval(time()-$offline)."' and anon ='0' and room='prih';");
$pixoh = @mysql_fetch_array($pixoh_count);
if($liven_us>8)
$koll_onlineklub = @mysql_query("select count(*) from `c_users` WHERE ltime>'".intval(time()-$offline)."' and nev='1' order by id;");
else
$koll_onlineklub = @mysql_query("select count(*) from `c_users` WHERE ltime>'".intval(time()-$offline)."' and anon ='0' and nev='1' order by id;");
$uss_kollklub = @mysql_fetch_array($koll_onlineklub);
if($liven_us>8)
$koll_onlinepos = @mysql_query("select count(*) from `c_users` WHERE ltime>'".intval(time()-$offline)."' and nev='2' order by id;");
else
$koll_onlinepos = @mysql_query("select count(*) from `c_users` WHERE ltime>'".intval(time()-$offline)."' and anon ='0' and nev='2' order by id;");
$uss_kollpos = @mysql_fetch_array($koll_onlinepos);
$koll_post_max=@mysql_query("SELECT count(*) FROM `c_users` WHERE `post_chat`='2';");
$itog_post_max=@mysql_fetch_array($koll_post_max);
////////////////////////////////////////////////////////drug//////////////////////////////////
$koll_c_drug=@mysql_query("SELECT count(*) FROM `c_drug` WHERE `ukogo`='".bug($id)."';");
$itog_c_drug=@mysql_fetch_array($koll_c_drug);
$koll_c_ignor=@mysql_query("SELECT count(*) FROM `c_ignor` WHERE `ukogo`='".bug($id)."';");
$itog_c_ignor=@mysql_fetch_array($koll_c_ignor);
////////////////////////////////////////botttt//////////////////////
$koll_c_bots_v=@mysql_query("SELECT count(*) FROM `c_bots_v` ;");
$itog_c_bots_v=@mysql_fetch_array($koll_c_bots_v);
$koll_c_bots_h=@mysql_query("SELECT count(*) FROM `c_bots_h` ;");
$itog_c_bots_h=@mysql_fetch_array($koll_c_bots_h);
$koll_c_bots=@mysql_query("SELECT count(*) FROM `c_bots` ;");
$itog_c_bots=@mysql_fetch_array($koll_c_bots);
$koll_c_bots_r=@mysql_query("SELECT count(*) FROM `c_bots_r` ;");
$itog_c_bots_r=@mysql_fetch_array($koll_c_bots_r);
//////////////////////////////////////////foto///////////////////////////////////
$koll_c_foto_raz=@mysql_query("SELECT count(*) FROM `c_foto_raz` ;");
$itog_c_foto_raz=@mysql_fetch_array($koll_c_foto_raz);
$koll_c_foto_albom=@mysql_query("SELECT count(*) FROM `c_foto_albom` WHERE `kto`='".bug($id)."';");
$itog_c_foto_albom=@mysql_fetch_array($koll_c_foto_albom);
$koll__foto_albom=@mysql_query("SELECT count(*) FROM `c_foto_albom`;");
$itog__foto_albom=@mysql_fetch_array($koll__foto_albom);
$kollc_foto_add=@mysql_query("SELECT count(*) FROM `c_foto_add`;");
$itogc_foto_add=@mysql_fetch_array($kollc_foto_add);
$kollc_foto_komm=@mysql_query("SELECT count(*) FROM `c_foto_komm`;");
$itogc_foto_komm=@mysql_fetch_array($kollc_foto_komm);
if($liven_us>8)
$koll_onnn_f=@mysql_query("SELECT count(*) FROM `c_users` WHERE ltime>'".intval(time()-$offline)."' and room='foto';");
else
$koll_onnn_f=@mysql_query("SELECT count(*) FROM `c_users` WHERE ltime>'".intval(time()-$offline)."' and anon ='0' and room='foto';");
$itog_onnn_f = @mysql_fetch_array($koll_onnn_f);
////////////////////////////////////////////////////////forum////////////////////////////////
$koll_c_forum_razdel=@mysql_query("SELECT count(*) FROM `c_forum_razdel` ;");
$itog_c_forum_razdel=@mysql_fetch_array($koll_c_forum_razdel);
$koll_c_forum_tema=@mysql_query("SELECT count(*) FROM `c_forum_tema` ;");
$itog_c_forum_tema=@mysql_fetch_array($koll_c_forum_tema);
$koll_c_forum_msg=@mysql_query("SELECT count(*) FROM `c_forum_msg` ;");
$itog_c_forum_msg=@mysql_fetch_array($koll_c_forum_msg);
if($liven_us>8)
$koll_forr_f=@mysql_query("SELECT count(*) FROM `c_users` WHERE ltime>'".intval(time()-$offline)."' and room='forum';");
else
$koll_forr_f=@mysql_query("SELECT count(*) FROM `c_users` WHERE ltime>'".intval(time()-$offline)."' and anon ='0' and room='forum';");
$itog_forr_f = @mysql_fetch_array($koll_forr_f);
$koll_m_forum_tema=@mysql_query("SELECT count(*) FROM `c_forum_tema` WHERE `kto`='".bug($id)."' ;");
$itog_m_forum_tema=@mysql_fetch_array($koll_m_forum_tema);
//////////////////////////////////////////////////////////////////////////////////////////
?>