<?

header('Content-type: image/gif');

ob_start();

include('includes/functions.inc.php');
include('class/sendsms.class.php');
include('class/template.class.php');
include('class/mysqldb.class.php');

if(isset($_GET['id']) && is_numeric($_GET['id']) && $_GET['id'] > 0) {
    $s_id = $_GET['id'];
}
else {
    die(file_get_contents('images/red.gif'));
}

// Make DB connection
$db = new mysqldb();
$db->connect();
		
$query = $db->prepare('select s.* from smsboxes s, `user` u ' .
    'where s.s_id=' . $s_id . ' && s.s_usr_id = u.usr_id && ' .
    'u.usr_flag_status > 0 limit 1');
$query->exec();
if($query->num_rows() != 1) {
    die(file_get_contents('images/green.gif'));
}
$smsbox = $query->get_row();

$cfg = array();
$query = $db->prepare('select set_key, set_val from settings');
$query->exec();
while($set = $query->get_row()) {
    $cfg[$set->set_key] = $set->set_val;
}

$cnt_sms = $smsbox->s_today_sms;

if($cnt_sms >= $smsbox->s_max_freesms_per_day) die(file_get_contents('images/red.gif'));
elseif($cnt_sms / $smsbox->s_max_freesms_per_day > 0.6) die(file_get_contents('images/yellow.gif'));
else die(file_get_contents('images/green.gif'));