<?php
/*
Local: C:\Dropbox\htdocs\RND\AnonymousChatApp\apiServer\Apiserver\stats
Remote: /var/www/mingle.eft.xyz/html/stats
*/

require_once("../includes/dbparameters.php");
require_once("../includes/common-variables.php");
require_once("../includes/common-functions.php");

$db = mysqli_connect($db_host, $db_username ,$db_password, $db_name);
mysqli_set_charset($db,"utf8");

$statsquery = mysqli_query($db,"SELECT * FROM $mingle_stats_table WHERE id = 1");
if($statsqueryarray = mysqli_fetch_assoc($statsquery))
{
  $operator_stats = $statsqueryarray['operator_stats'];
  $operator_stats_array = json_decode($operator_stats, true);
  $source_stats = $statsqueryarray['source_stats'];

  $statusquery = mysqli_query($db,"SELECT status, COUNT(*) as count FROM $mypal_users GROUP BY status ORDER BY count DESC");
  while($statusqueryarray = mysqli_fetch_assoc($statusquery))
  {
      if($statusqueryarray['status'] <> '')
      {
        $operator_stats_array['common'][$statusqueryarray['status']] = $statusqueryarray['count'];
      }else{
        $operator_stats_array['common']['NULL_status'] = $statusqueryarray['count'];
      }
  }

  $operator_stats = json_encode($operator_stats_array);

	mysqli_query($db,"INSERT INTO $mingle_stats_table (timestamp,operator_stats,source_stats) VALUES ('$time','$operator_stats','$source_stats')");
}

//reset data
mysqli_query($db,"UPDATE $mingle_stats_table SET operator_stats = '', source_stats = '' WHERE id = 1");

?>