$vps_stopped = $db->fetch_array($db->query("SELECT COUNT(*) AS cnt FROM vps v INNER JOIN vps_status s ON v.vps_id = s.vps_id INNER JOIN members m ON m.m_id = v.m_id WHERE vps_up = 0 AND vps_deleted IS NULL AND m_state = 'active'"));
$vps_suspended = $db->fetch_array($db->query("SELECT COUNT(*) AS cnt FROM vps v INNER JOIN members m ON v.m_id = m.m_id WHERE m_state = 'suspended'"));
$vps_deleted = $db->fetch_array($db->query("SELECT COUNT(*) AS cnt FROM vps WHERE vps_deleted IS NOT NULL AND vps_deleted > 0"));
$vps_all = $db->fetch_array($db->query("SELECT COUNT(*) AS cnt FROM vps"));
$xtpl->table_td(_("VPS") . ':');
$xtpl->table_td($vps_on["cnt"] . ' ' . _("running") . ' / ' . $vps_stopped["cnt"] . ' ' . _("stopped") . ' / ' . $vps_suspended["cnt"] . ' ' . _("suspended") . ' / ' . $vps_deleted["cnt"] . ' ' . _("deleted") . ' / ' . $vps_all["cnt"] . ' ' . _("total"));
$xtpl->table_tr();
$m_active = $db->fetch_array($db->query("SELECT COUNT(*) AS cnt FROM members WHERE m_state = 'active'"));
$m_suspended = $db->fetch_array($db->query("SELECT COUNT(*) AS cnt FROM members WHERE m_state = 'suspended'"));
$m_total = $db->fetch_array($db->query("SELECT COUNT(*) AS cnt FROM members"));
$m_deleted = $db->fetch_array($db->query("SELECT COUNT(*) AS cnt FROM members WHERE m_state = 'deleted'"));
$xtpl->table_td(_("Members") . ':');
$xtpl->table_td($m_active["cnt"] . ' ' . _("active") . ' / ' . $m_suspended["cnt"] . ' ' . _("suspended") . ' / ' . $m_deleted["cnt"] . ' ' . _("deleted") . ' / ' . $m_total["cnt"] . ' ' . _("total"));
$xtpl->table_tr();
$free = count((array) get_free_ip_list(4));
$all = count((array) get_all_ip_list(4));
$xtpl->table_td(_("IPv4 addresses") . ':');
$xtpl->table_td($all - $free . ' ' . _("used") . ' / ' . $all . ' ' . _("total"));
$xtpl->table_tr();
$xtpl->table_out();
$xtpl->table_title(_("Node list"));
$xtpl->table_add_category('');
$xtpl->table_add_category('#');
$xtpl->table_add_category(_("Name"));
$xtpl->table_add_category(_("IP"));
$xtpl->table_add_category(_("Load"));
$xtpl->table_add_category(_("Up"));
$xtpl->table_add_category(_("Down"));
$xtpl->table_add_category(_("Del"));
$xtpl->table_add_category(_("Sum"));
$xtpl->table_add_category(_("Free"));
define('CRON_MODE', true);
define('DEMO_MODE', false);
// Include libraries
include WWW_ROOT . 'lib/cli.lib.php';
include WWW_ROOT . 'lib/xtemplate.lib.php';
include WWW_ROOT . 'lib/db.lib.php';
include WWW_ROOT . 'lib/functions.lib.php';
include WWW_ROOT . 'lib/transact.lib.php';
include WWW_ROOT . 'lib/vps.lib.php';
include WWW_ROOT . 'lib/members.lib.php';
include WWW_ROOT . 'lib/vps_status.lib.php';
include WWW_ROOT . 'lib/networking.lib.php';
include WWW_ROOT . 'lib/firewall.lib.php';
include WWW_ROOT . 'lib/version.lib.php';
include WWW_ROOT . 'lib/cluster.lib.php';
include WWW_ROOT . 'lib/cluster_status.lib.php';
$db = new sql_db(DB_HOST, DB_USER, DB_PASS, DB_NAME);
do_all_transactions_by_server(SERVER_ID);
update_all_vps_status();
$all_ips = get_all_ip_list(6);
foreach ($all_ips as $id => $ip) {
exec('ip -6 neigh add proxy ' . $ip . ' dev ' . NETDEV);
}
$accounting->load_accounting();
$accounting->all_ip4_add();
$accounting->all_ip6_add();
$accounting->update_traffic_table();
$all_vps = get_vps_array();
// cluster_status.lib.php
update_server_status();
$cluster_cfg->set("lock_cron_" . SERVER_ID, 0);
function all_ip6_add()
{
global $firewall;
$all_ips = get_all_ip_list(6);
if ($all_ips) {
foreach ($all_ips as $ip) {
$firewall->commit_rule6("-A aztotal -s {$ip}");
$firewall->commit_rule6("-A aztotal -d {$ip}");
}
}
}
