Пакет | Пользователи |
---|---|
{$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} |