{section name="td" loop="$table"} {/section}
Пакет Пользователи
{$table[td].name} {$table[td].users}

Общая статистика

Всего подписок:{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
Активировано пакетов за сутки:{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE time_from > UNIX_TIMESTAMP( )-86400 AND time_from < UNIX_TIMESTAMP( )")); echo $mysql; {/php}
Активировано пакетов за неделю:{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE time_from > UNIX_TIMESTAMP( )-86400*7 AND time_from < UNIX_TIMESTAMP( )")); echo $mysql; {/php}
Общая сумма непотраченных средств юзерами:{php} $res = mysql_query("SELECT SUM(balance) FROM users"); while($row=mysql_fetch_row($res)) { echo $row[0]."\n"; } {/php} $
        Статистика по пакетам

Super-VIP:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = '1' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
VIP-36:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'VIP-36' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
VIP-75:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'VIP-75' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
VIP-0.8:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'VIP-0.8' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
VIP-36+9:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'VIP-36+9' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
VIP-36+XXX:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'VIP-36+XXX' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
VIP-36+75:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'VIP-36+75' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
VIP-36+5:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'VIP-36+5' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
VIP-36+0.8:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'VIP-36+0.8' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
Trikolor-36:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'Trikolor-36' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
Plat+Pent-9:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'Plat+Pent-9' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}
Нтв+56:___{php} $mysql = mysql_num_rows(mysql_query("SELECT id FROM user_packet_groups WHERE packet_group = 'НТВ+56' AND time_till > UNIX_TIMESTAMP( )")); echo $mysql; {/php}