<?php
// error_reporting(E_ALL);

$db_host = "xxxx";
$db_user = "root";
$db_pass = "xxxx";
$db_name = "lvps";

mysql_connect($db_host, $db_user, $db_pass)or die("cannot connect");
mysql_select_db($db_name)or die("cannot select DB");


$mmp = mysql_query("SELECT * FROM vps_vps_status");

while ($rows = mysql_fetch_array($mmp))
{
    getvpsinfo($rows['vps_id'], "ram");
    getvpsinfo($rows['vps_id'], "hdd");
    getvpsinfo($rows['vps_id'], "cpu");

}



function getvpsinfo($vpsID, $select)
{
    if ($select == 'ram') {
        $output = shell_exec("vzctl exec2 ".$vpsID." free -m | awk {'print $3'}");
        $output = explode("\n", $output);
        $output = $output[1];

        mysql_query("UPDATE vps_vps_status SET ram='$output' WHERE vps_id='$vpsID'");
      //  echo $output;
    }
    else if ($select == 'hdd') {
        $output = shell_exec("vzctl exec2 ".$vpsID." df -h |awk {'print $3'}");
        $output = explode("\n", $output);
        $output = $output[1];

        mysql_query("UPDATE vps_vps_status SET disk='$output' WHERE vps_id='$vpsID'");
      //  echo $output;
    }
    else if ($select == 'cpu') {
        $output = shell_exec("vzctl exec2 ".$vpsID."  vmstat 1 5 |awk '{print $15}' > file");

        mysql_query("UPDATE vps_vps_status SET cpu='$output' WHERE vps_id='$vpsID'");
       // echo $output;
    }
}



?>