<?php

/**
 * MySQL host
 */
$db_host = "localhost";

/**
 * MySQL username
 */
$db_user = "coradmin_Escaped";

/**
 * MySQL password
 */
$db_password = "noob123456";

/**
 * MySQL database name
 */
$db_name = "coradmin_CoradminVb";

$db = new Database($db_host, $db_user, $db_password, $db_name);
if(!$db->connect()) {
    die("Unable to connect too MySQL Server. Please contact an administrator.");
}

$sql = $db->query("SELECT * FROM `votes`");
if (mysql_num_rows($sql) > 0) {
    while ($row = mysql_fetch_array($sql)) {
        if (strtotime("1 day", $row['time']) - time() <= 0) {
            $db->query("DELETE * FROM `votes` WHERE `authcode` = '".$row['authcode']."'");
        }
    }
}

class Database
{
    private $server;
    private $username;
    private $password;
    private $database;
    private $connected;

    public function __construct($s, $u, $p, $d)
    {
        $this->server = $s;
        $this->username = $u;
        $this->password = $p;
        $this->database = $d;
        $this->connected = false;
    }

    public function connect()
    {
        if (!mysql_connect($this->server, $this->username, $this->password))
            return false;

        if (!@mysql_select_db($this->database))
            return false;

        $this->connected = true;
        return true;
    }

    public function query($s)
    {
        if (!$this->connected)
            $this->connect();
        $query = mysql_query($s);

        return $query;
    }

    public function anti_inject($sql)
    {
        $sql = preg_replace(sql_regcase(" / (from | select | insert | delete |
                where | drop table | show tables | #|\*|--|\\\\)/"), "", $sql);
        $sql = trim($sql);
        $sql = strip_tags($sql);
        $sql = addslashes($sql);
        return $sql;
    }
}

?>