include ( "./defaults.php" );
$titlestat="Статистика каталога";
$incomingline = "
$def_catalogue
|
$titlestat
";
$incomingline_firm=$titlerating;
$help_section = "$statistica_help";
include ( "./template/$def_template/header.php" );
main_table_top ($titlestat);
// Counting listings, and gathering statistics
$rstat1=$db->query ("select COUNT(*) from $db_users") or die ("mySQL error!");
$rstat2=$db->query ("select COUNT(*) from $db_users where firmstate='on'") or die ("mySQL error!");
$rstat3=$db->query ("select COUNT(*) from $db_users where firmstate='off'") or die ("mySQL error!");
$rstat4=$db->query ("select COUNT(*) from $db_users where flag='A'") or die ("mySQL error!");
$rstat5=$db->query ("select COUNT(*) from $db_users where flag='B'") or die ("mySQL error!");
$rstat6=$db->query ("select COUNT(*) from $db_users where flag='C'") or die ("mySQL error!");
$rstat7=$db->query ("select COUNT(*) from $db_users where flag='D'") or die ("mySQL error!");
$rstat8=$db->query ("select COUNT(*) from $db_offers") or die ("mySQL error!");
$rstat9=$db->query ("select COUNT(*) from $db_offers where type='1'") or die ("mySQL error!");
$rstat10=$db->query ("select COUNT(*) from $db_offers where type='2'") or die ("mySQL error!");
$rstat11=$db->query ("select COUNT(*) from $db_offers where type='3'") or die ("mySQL error!");
$rstat12=$db->query ("select COUNT(*) from $db_category") or die ("mySQL error!");
$rstat13=$db->query ("select COUNT(*) from $db_subcategory") or die ("mySQL error!");
$rstat14=$db->query ("select COUNT(*) from $db_subsubcategory") or die ("mySQL error!");
$rstat15=$db->query ("select COUNT(*) from $db_location") or die ("mySQL error!");
$rstat16=$db->query ("select COUNT(*) from $db_states") or die ("mySQL error!");
$rstat17=$db->query ("select COUNT(*) from $db_reviews where status='on'") or die ("mySQL error!");
$rstat18=$db->query ("select COUNT(*) from $db_reviews where status='off'") or die ("mySQL error!");
$result = $db->query ('SELECT VERSION() AS version');
if ($result != FALSE && @mysql_num_rows($result) > 0) {
$row = $db->fetcharray ($result);
$match = explode('.', $row['version']);
$banhandle = opendir('./banner');
$bancount=0;
while (false != ($banfile = readdir($banhandle))) {
if ($banfile != "." && $banfile != ".." && $banfile != "_vti_cnf" && $banfile != "index.html") {
$bancount++;
}
}
closedir($banhandle);
$banhandle2 = opendir('./banner2');
$bancount2=0;
while (false != ($banfile2 = readdir($banhandle2))) {
if ($banfile2 != "." && $banfile2 != ".." && $banfile2 != "_vti_cnf" && $banfile2 != "index.html") {
$bancount2++;
}
}
closedir($banhandle2);
$logohandle = opendir('./logo');
$logocount=0;
while (false != ($logofile = readdir($logohandle))) {
if ($logofile != "." && $logofile != ".." && $logofile != "_vti_cnf" && $logofile != "index.html") {
$logocount++;
}
}
closedir($logohandle);
$logohandle2 = opendir('./gallery');
$logocount2=0;
while (false != ($logofile2 = readdir($logohandle2))) {
if ($logofile2 != "." && $logofile2 != ".." && $logofile2 != "_vti_cnf" && $logofile2 != "index.html") {
$logocount2++;
}
}
closedir($logohandle2);
?>
| echo "Сгенерирована: ".date("H:i:s"); ?> | |
|
} ?> Всего компаний: echo mysql_result($rstat1, 0 ,0); ?> Одобрено: echo mysql_result($rstat2, 0 ,0); ?> Ожидающих проверки: echo mysql_result($rstat3, 0 ,0); ?> Всего комментариев: echo mysql_result($rstat17, 0 ,0); ?> Комментарии ожидающие проверки: echo mysql_result($rstat18, 0 ,0); ?> if ($def_allow_products == "YES") { echo "Продукции и услуг: "; ?> echo mysql_result($rstat8, 0 ,0); ?> echo "$def_offer_1"; ?>: echo mysql_result($rstat9, 0 ,0); ?> echo "$def_offer_2"; ?>: echo mysql_result($rstat10, 0 ,0); ?> echo "$def_offer_3"; ?>: echo mysql_result($rstat11, 0 ,0); ?> Размещено в тарифных планах: } if ($def_A_enable == "YES" ) { echo "$def_A"; ?>: echo mysql_result($rstat4, 0 ,0); ?> } ?> if ($def_B_enable == "YES" ) { echo "$def_B"; ?>: echo mysql_result($rstat5, 0 ,0); ?> } ?> if ($def_C_enable == "YES" ) { echo "$def_C"; ?>: echo mysql_result($rstat6, 0 ,0); ?> } ?> echo "$def_D"; ?>: echo mysql_result($rstat7, 0 ,0); ?> |
echo "Категорий"; ?>: echo mysql_result($rstat12, 0 ,0); ?> echo "Подкатегорий"; ?>: echo mysql_result($rstat13, 0 ,0); ?> echo "Разделов подкатегорий"; ?>: echo mysql_result($rstat14, 0 ,0); ?> echo "Стран"; ?>: echo mysql_result($rstat15, 0 ,0); ?> if ($def_states_allow == "YES") { echo "Областей"; ?>: echo mysql_result($rstat16, 0 ,0); ?> } ?> echo "Логотипов"; ?>: echo "$logocount"; ?> echo "Баннеров TOP"; ?>: echo "$bancount"; ?> echo "Баннеров SIDE"; ?>: echo "$bancount2"; ?> echo "Изображений"; ?>: echo $logocount2/2; ?> |