Factorio Forums

Code: Select all

class Main extends CI_Controller
{
    public function __construct()
    {
        parent::__construct();
        $this->load->library("template_manager");
        $this->load->model("server_model");
        $this->tm = $this->template_manager;
    }
    
    public function index()
    {
        $this->server_model->remove_old_servers();
        $data = new stdClass();
        
        $data->servers = $this->load->view("servers_list", array("servers" => $this->server_model->get_list()), true);
        
        $this->tm->load_content("main_view", $data);
        $this->tm->show();
    }
    
    public function update_list()
    {
        $this->server_model->remove_old_servers();
        exit($this->load->view("servers_list", array("servers" => $this->server_model->get_list()), true));
    }
    
    public function add_server()
    {
        if(!IS_AJAX)
            exit("No direct access allowed!");
        
        $name = post("name", true);
        $host = post("host", true);
        $port = post("port", true);
        $description = post("description", true);
        $ip = $this->input->ip_address();
        
        if(strlen($name) < 5)
            exit(json_encode(array("error" => "The name of the server has to be atleast 5 characters long")));
        
        if(!$this->input->valid_ip($host))
            exit(json_encode(array("error" => "The host you provided is not an valid IP address")));
            
        if($port === false || !is_numeric($port))
            exit(json_encode(array("error" => "The port you provided is not an valid number")));
        
        $server = $this->server_model->get_from_host($host, $port);
        if($server != null)
            exit(json_encode(array("error" => "There is already a server with that host/ip: {$server->name}")));
        
        if(count($this->server_model->get_servers_from_ip($ip)) > 10)
            exit(json_encode(array("error" => "You have already added 10 servers to the list. Contact Zinal if you want to add more")));
        
        $id = $this->server_model->add_server($name, $host, $port, $description, $ip);
        $server = $this->server_model->get($id);
        exit(json_encode(array("result" => "The server {$server->name} has been added to the list")));
    }

    public function update_last_played()
    {
        if(!IS_AJAX)
            exit("No direct access allowed!");
        
        $id = post("id", true);
        
        $this->server_model->update_last_played($id);
        $this->update_list();
    }
    
}
 

Code: Select all

class Server_Model extends CI_Model
{
    private $server_table = "servers";
    
    public function __construct()
    {
        parent::__construct();
    }
    
    public function get($id)
    {
        return $this->db->where("id", $id)->get($this->server_table)->row();
    }
    
    public function get_list()
    {
        return $this->db->where("removed", null)->get($this->server_table)->result();
    }
    
    public function get_from_host($host, $port)
    {
        return $this->db->where("host", $host)->where("port", $port)->get($this->server_table)->row();
    }
    
    public function add_server($name, $host, $port, $description, $ip)
    {
        $this->db->insert($this->server_table, array(
            "name" => $name,
            "host" => $host,
            "port" => $port,
            "description" => $description,
            "from_ip" => $ip,
            "inserted" => date("Y-m-d H:i:s"),
            "last_played" => date("Y-m-d H:i:s")
        ));
        
        return $this->db->insert_id();
    }
    
    public function remove_old_servers()
    {
        $remove = array();
        $servers = $this->get_list();
        $today = new DateTime();
        
        foreach($servers as $server)
        {
            $last_played = new DateTime($server->last_played);
            $diff = $today->diff($last_played, true);
            
            if($diff->days > 5)
                $remove[] = $server->id;
        }
        
        if(count($remove) > 0)
        {
            $this->db->where_in("id", $remove)->update($this->server_table, array("removed" => date("Y-m-d H:i:s")));
            return $this->db->affected_rows();
        }
        
        return 0;
    }
    
    public function get_servers_from_ip($ip)
    {
        return $this->db->where("from_ip", $ip)->get($this->server_table)->result();
    }
    
    public function update_last_played($id)
    {
        $this->db->where("id", $id)->update($this->server_table, array("last_played" => date("Y-m-d H:i:s")));
        return $this->db->affected_rows();
    }
    
}

Code: Select all

Wow, people are even more suspicious of a web-application than a standalone program? :O

Code: Select all

A Database Error Occurred

Error Number: 1054

Unknown column 'deleted' in 'where clause'

SELECT * FROM (`servers`) WHERE `deleted` IS NULL AND `host` = '108.115.33.109' AND `port` = '34197'

Filename: G:\Programs\Apache\htdocs\FactorioServerList\system\database\DB_driver.php

Line Number: 330