' : ''; ++$i; } echo ''; if ($total > $kmess){ echo '' . pagenav('statistik.php?act=siteadr&', $start, $total, $kmess) . ''; echo '

';} echo''; echo'
'; break; /////////// Популярные разделы //////// case 'pop': echo''; $hosts = @mysql_query("select * from `counter` GROUP BY `pop`;"); $total = mysql_num_rows($hosts); $hosts = @mysql_query("select * from `counter` GROUP BY `pop` ORDER BY `counter`.`date` DESC LIMIT " . $start . "," . $kmess); while ($hos = mysql_fetch_array($hosts)) { $number = @mysql_query("select * from `counter` where `pop` = '" . $hos['pop'] . "';"); $perehod = mysql_num_rows($number); echo ceil(ceil($i / 2) - ($i / 2)) == 0 ? ''; } ++$i; } echo ''; if ($total > $kmess){ echo '' . pagenav('statistik.php?act=pop&', $start, $total, $kmess) . ''; echo '

';} echo'
'; break; ////// Телефоны /////// case 'phones': echo''; $nokia = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%nokia%' GROUP BY `ip`, `browser`;"); $sie = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE 'SIE%' OR `browser` LIKE '%benq%' GROUP BY `ip`, `browser`;"); $sonieric = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%sony%' OR `browser` LIKE '%sonyeric%' GROUP BY `ip`, `browser`;"); $sec = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%sec%' OR `browser` LIKE '%samsung%' GROUP BY `ip`, `browser`;"); $lg = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%lg%' GROUP BY `browser`;"); $mot = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%mot%' OR `browser` LIKE '%motorol%' GROUP BY `ip`, `browser`;"); $nec = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%nec%' GROUP BY `ip`, `browser`;"); $philips = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%philips%' GROUP BY `ip`, `browser`;"); $pantech = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%pantech%' GROUP BY `ip`, `browser`;"); $sagem = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%sagem%' GROUP BY `ip`, `browser`;"); $fly = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%fly%' GROUP BY `browser`;"); $panasonic = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%panasonic%' GROUP BY `ip`, `browser`;"); $om = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%opera mini%' GROUP BY `ip`, `browser`;"); $komp = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%windows%' OR `browser` LIKE '%linux%' GROUP BY `ip`, `browser`;"); $nokia = mysql_num_rows($nokia); $sie = mysql_num_rows($sie); $sonieric = mysql_num_rows($sonieric); $sec = mysql_num_rows($sec); $lg = mysql_num_rows($lg); $mot = mysql_num_rows($mot); $nec = mysql_num_rows($nec); $philips = mysql_num_rows($philips); $sagem = mysql_num_rows($sagem); $fly = mysql_num_rows($fly); $panasonic = mysql_num_rows($panasonic); $om = mysql_num_rows($om); $komp = mysql_num_rows($komp); if($nokia !== 0){ echo''; } if($sie !== 0){ echo''; } if($sonieric !== 0){ echo''; } if($sec !== 0){ echo''; } if($lg !== 0){ echo''; } if($mot !== 0){ echo''; } if($nec !== 0){ echo''; } if($philips !== 0){ echo''; } if($sagem !== 0){ echo''; } if($fly !== 0){ echo''; } if($panasonic !== 0){ echo''; } if($om !== 0){ echo''; } if($komp !== 0){ echo''; } echo ''; echo'
'; break; ////// Nokia /////// case 'nokia': echo''; $host111 = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%nokia%' GROUP BY `ip`, `browser`;"); $total = mysql_num_rows($host111); $host111 = mysql_query("SELECT * FROM `counter` WHERE `browser` LIKE '%nokia%' GROUP BY `ip`, `browser` ORDER BY `counter`.`date` DESC LIMIT " . $start . "," . $kmess); while ($arr = mysql_fetch_array($host111)){ $number = @mysql_query("select * from `counter` where `browser` = '" . $arr['browser'] . "';"); $perehod = mysql_num_rows($number); $vrp = $arr['date'] + $sdvig * 3600; $vr = date("H:i", $vrp); echo ceil(ceil($i / 2) - ($i / 2)) == 0 ? '