<?php 
//A login is required
include ('function.php');
$this->loginRequired();
 
//This will list the sites
$vp = Flux::config('FluxTables.Sites'); 
$vp_voter = Flux::config('FluxTables.Voters'); 
$serverLogDB = $server->loginDatabase;
 
$vp_voter = Flux::config('FluxTables.Voters'); 
$vp_logs = Flux::config('FluxTables.Logs');         
$serverObj = $server->connection;
 
 
$sql = "SELECT site_id,site_name,address,points,blocking_time,banner,banner_url FROM {$server->loginDatabase}.{$vp}";
$sth = $server->connection->getStatement($sql);
$sth->execute();
 
$vp = $sth->fetchAll();
 
$account_id = $session->account->account_id;
$current_time= date("Y-m-d G:i:s",time());
$ip_address = 0;
if(Flux::config('IP_BLOCKING'))
    $ip_address = $_SERVER['REMOTE_ADDR'];
    
    
$sql = "SELECT points FROM {$server->loginDatabase}.{$vp_voter} WHERE account_id=?";
$sth = $server->connection->getStatement($sql);
$sth->execute(array($session->account->account_id));
$vp_voter = $sth->fetch();
$curr_points = $vp_voter->points;
 
function isBlock($account_id,$site_id,$current_time,$ip_address,$serverLogDB,$vp_logs,$serverObj)
{
    if($ip_address!=0)
    {
        $sql = "SELECT `rtid`,`unblock_time`,`ip_address` FROM {$serverLogDB}.{$vp_logs} WHERE f_site_id=? AND unblock_time>? AND ip_address=? ORDER BY unblock_time ASC LIMIT 1";
        $sth = $serverObj->getStatement($sql);
        $sth->execute(array($site_id,$current_time,$ip_address));
        $ip_check = $sth->fetchAll();
        
        $diff_time = strtotime($ip_check[0]->unblock_time)-strtotime(date("Y-m-d G:i:s",time()));
        if(!empty($ip_check))
            return strtotime($ip_check[0]->unblock_time);
    }
        $sql = "SELECT `unblock_time` FROM {$serverLogDB}.{$vp_logs} WHERE account_id=? AND f_site_id=?";
        $sth = $serverObj->getStatement($sql);
        $sth->execute(array($account_id,$site_id));
        $account_check = $sth->fetch();
        
        if(!empty($account_check))
            $diff_time = strtotime($account_check->unblock_time)-strtotime(date("Y-m-d G:i:s",time()));
        else
            $diff_time = 0;
            
        if($diff_time>0)
            return strtotime($account_check->unblock_time);
        else
            return 0;
 
    return strtotime($account_check->unblock_time);
}
?>