View file football/count.php

<?
//echo mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `date_last` > '".(time()-600)."' AND `url` like '/plugins/games/football/%'"), 0).' Peoples';


 $row_cnt_udar_male = mysql_result(mysql_query("SELECT COUNT(`udar`) FROM `_football_blow` WHERE `udar` = '1' AND `sex` = 'male' AND `id_football` = (SELECT max(`id_football`) FROM `_football_blow`) "), 0);

                // Количество голов у девушек
               $row_cnt_udar_female = mysql_result(mysql_query("SELECT COUNT(`udar`) FROM `_football_blow` WHERE `udar` = '1' AND `sex` = 'female' AND `id_football` = '(SELECT max(`id_football`) FROM `_football_blow`)'"), 0);
			   
				echo " Boys:[red] ".$row_cnt_udar_male." [/red]goals";
			   echo " <BR> Girls: ".$row_cnt_udar_female." goals";
			   
			   
			   ?>