public function __construct()
{
$this->headerFooter = HeaderFooterFactory::createHeaderFooter();
$this->pageHome = PageFactory::createHome();
$this->database = DatabaseFactory::createDatabase();
$this->file = FileFactory::setFile();
}
public static function GetInstance()
{
static $instance = null;
if (is_null($instance)) {
$factory = new DatabaseFactory();
$instance = $factory->createObject(G_DB_TYPE);
if (is_null($instance)) {
die("Can not create database object\n");
}
}
return $instance;
}
public function getOutData()
{
$id = $this->data;
$query = "SELECT * FROM Users WHERE id = {$id}";
$db = DatabaseFactory::create("AAADatabase")->connect();
return $db->SQLFetchArray($query);
}
public static function getDatabase()
{
if (!self::$database) {
self::$database = new Database(DB_HOST, DB_NAME, DB_USERNAME, DB_PASSWORD);
}
return self::$database;
}
public function getOutData()
{
$date = $this->data['date'];
$db = DatabaseFactory::create("SquidDatabase")->connect();
$rowsTotalNumberInArray = $db->SQLFetchArray("SELECT COUNT(*)\n FROM SquidData\n WHERE date = '{$date}' ");
return (int) $rowsTotalNumberInArray['COUNT(*)'];
}
public static function selectgen($name, $label, $table, $required = null, $selected = null)
{
if ($required != null) {
$required = 'required';
}
$s = '';
$s .= '<div class="form-group">
<label>' . $label . '</label>
<select class="form-control" name="' . $name . '" required >';
$s .= '<option value="" > Select </option>';
$pdo = DatabaseFactory::getFactory()->getConnection();
$sql = "SELECT id, name FROM " . $table;
$query = $pdo->prepare($sql);
$query->execute();
$options = $query->fetchAll();
foreach ($options as $k => $v) {
$s .= '<option value="' . $v->id . '" ';
if ($v->id == $selected) {
$s .= ' selected ';
}
$s .= ' >' . $v->name . '</option>';
}
$s .= '</select>
</div>';
return $s;
}
private function register_on_db($cinema)
{
//o nome da classe é o id do banco, recupera dinamico
$classname = get_class($this);
$cinema->_id = $classname;
$db = DatabaseFactory::get_provider();
$cinema_db = $db->find($classname);
if ($cinema_db) {
if ($cinema_db->hash != $cinema->hash) {
$cinema->_rev = $cinema_db->_rev;
//utilizado mais para ter uma nocao olhando direto no banco...
$cinema->last_update = date('d/m/y H:i:s');
$db->save($cinema);
//atributo utilizado para filtrar cinemas que foram atualizados para notificar clientes de atualizacao uma unica vez.
//seta o valor temporariamente, não guarda no db, so para validacao
$cinema->updated = 'YES';
//Log::write($cinema->name . ' tem novidades');
}
} else {
$cinema->last_update = date('d/m/y H:i:s');
$db->save($cinema);
$cinema->updated = 'YES';
}
if (!isset($cinema->updated)) {
//controle so de validacao
$cinema->updated = 'NO';
}
return $cinema;
}
public static function lookup_member($id = null, $email = null)
{
$id = (int) $id;
$email = trim($email);
$sql = "SELECT `AutoID` , `useremail`, `userFirstname`, `userLastname` FROM `user_signup`";
if ($id || $email || $author) {
$sql .= " WHERE";
} else {
return null;
}
if ($id) {
$sql .= " `AutoID` = '{$id}'";
if ($email || $author) {
$sql .= " &&";
}
}
if ($email) {
$sql .= " `useremail` = '{$email}'";
}
if ($res = DatabaseFactory::passinggreen_master_db()->query($sql)) {
if ($res->num_rows == 1) {
$member = $res->fetch_object();
return new Member($member->AutoID);
} else {
return null;
}
}
return null;
}
public static function getFactory()
{
if (!self::$factory) {
self::$factory = new DatabaseFactory();
}
return self::$factory;
}
public function getOutData()
{
$date = $this->data['date'];
$query = "SELECT client_ip, COUNT(client_ip) as frequency \n FROM SquidData \n \t\t\tWHERE date = '{$date}'\n GROUP BY client_ip \n \t\t\tORDER BY frequency DESC";
$db = DatabaseFactory::create("SquidDatabase")->connect();
return $db->SQLFetchAllArray($query);
}
public function getOutData()
{
$name = $this->data;
$query = "SELECT * FROM Users WHERE name LIKE '%{$name}%'";
$db = DatabaseFactory::create("AAADatabase")->connect();
return $db->SQLFetchAllArray($query);
}
public function getOutData()
{
$id = $this->data;
$query = "SELECT roles.*, 1 as status\n FROM roles \n LEFT JOIN users_roles\n ON users_roles.role_id = roles.id\n WHERE users_roles.user_id = {$id}\n\n\t\t\t\t UNION\n\n\t\t\t\t SELECT roles.*, 0 as status\n FROM roles \n WHERE roles.id NOT IN \n (\n \tSELECT roles.id\n\t\t\t \tFROM roles\n\t\t \t \tLEFT JOIN users_roles\n\t\t \tON users_roles.role_id = roles.id\n\t\t \tWHERE users_roles.user_id = {$id}\n\t\t )";
$db = DatabaseFactory::create("AAADatabase")->connect();
return $db->SQLFetchAllArray($query);
}
public function getOutData()
{
$id = $this->data;
$query = "SELECT actions.*, 1 as status\n FROM actions \n LEFT JOIN roles_actions\n ON roles_actions.action_name = actions.name\n WHERE roles_actions.role_id = {$id}\n\n\t\t\t\t UNION\n\n\t\t\t\t SELECT actions.*, 0 as status\n FROM actions \n WHERE actions.name NOT IN \n (\n \tSELECT actions.name\n\t\t\t \tFROM actions\n\t\t \t \tLEFT JOIN roles_actions\n\t\t \tON roles_actions.action_name = actions.name\n\t\t \tWHERE roles_actions.role_id = {$id}\n\t\t ) ORDER BY actions.name DESC";
$db = DatabaseFactory::create("AAADatabase")->connect();
return $db->SQLFetchAllArray($query);
}
public function setInData($data)
{
$id = $data;
$query = "DELETE FROM Users WHERE id={$id}";
$db = DatabaseFactory::create("AAADatabase")->connect();
$db->SQLQuery($query);
}
function sendEmail($recipient, $content, $subject = 'Notification', $includeStandardFooter = true)
{
$subject = 'lanlist.org - ' . $subject;
if (empty($content)) {
throw new Exception('Cannot send a blank email');
}
$content = wordwrap($content);
if ($includeStandardFooter) {
$content .= "\n\n- lanlist.org";
}
ErrorHandler::getInstance()->beLazy();
require_once 'Mail.php';
require_once 'Mail/smtp.php';
$host = 'ssl://smtp.gmail.com';
$username = '******';
$password = '******';
$smtp = new Mail_smtp(array('host' => $host, 'port' => 465, 'auth' => true, 'username' => $username, 'password' => $password));
$headers = array('From' => '"lanlist.org" <*****@*****.**>', 'To' => '<' . $recipient . '>', 'Subject' => $subject, 'Content-Type' => 'text/html');
$smtp->send('<' . $recipient . '>', $headers, $content);
ErrorHandler::getInstance()->beGreedy();
Logger::messageDebug('Sending email to ' . $recipient . ', subject: ' . $subject);
$sql = 'INSERT INTO email_log (subject, emailAddress, sent) VALUES (:subject, :emailAddress, now())';
$stmt = DatabaseFactory::getInstance()->prepare($sql);
$stmt->bindValue(':emailAddress', $recipient);
$stmt->bindValue(':subject', $subject);
$stmt->execute();
}
public function getOutData()
{
$id = $this->data;
$query = "SELECT users.*, 1 as status\n FROM users \n LEFT JOIN users_roles\n ON users_roles.user_id = users.id\n WHERE users_roles.role_id = {$id}";
$db = DatabaseFactory::create("AAADatabase")->connect();
return $db->SQLFetchAllArray($query);
}
public function getInitialEventsList()
{
$sql = 'SELECT e.*, o.id AS organizerId, o.title AS organizerTitle FROM events e LEFT JOIN organizers o ON e.organizer = o.id WHERE e.dateStart > now()';
$stmt = DatabaseFactory::getInstance()->prepare($sql);
$stmt->execute();
return $stmt->fetchAll();
}
public function getOutData()
{
$actionName = $this->data;
$query = "SELECT roles.*\n FROM roles\n LEFT JOIN roles_actions\n ON roles_actions.role_id = roles.id\n WHERE roles_actions.action_name = '{$actionName}'";
$db = DatabaseFactory::create("AAADatabase")->connect();
return $db->SQLFetchAllArray($query);
}
function __construct()
{
$this->db = DatabaseFactory::getDatabase();
$this->de = new WarOfNationsDataExtractor($this->db);
// We always need authentication, so just initialize it now
$this->auth = new WarOfNationsAuthentication($this->db, $this->de, $this->data_load_id);
}
private function __construct($gitHubFacade)
{
if (!$gitHubFacade) {
throw ErrorFactory::makeError(ERROR_MISC_SYSTEM);
}
$this->gitHub = $gitHubFacade;
$this->db = DatabaseFactory::makeCouchDBDriver();
}
public function getOutData()
{
$clientIp = $this->data['client-ip'];
$date = $this->data['date'];
$query = "SELECT client_data, time, url\n FROM SquidData \n WHERE client_ip = '{$clientIp}' AND date = '{$date}'\n ORDER BY time";
$db = DatabaseFactory::create("SquidDatabase")->connect();
return $db->SQLFetchAllArray($query);
}
/**
* @return Database
*/
public static function GetDatabase()
{
require_once ROOT_DIR . 'lib/Database/namespace.php';
if (self::$_database == null) {
self::$_database = DatabaseFactory::GetDatabase();
}
return self::$_database;
}
public static function get($key)
{
$database = DatabaseFactory::getFactory()->getConnection();
$query = $database->prepare("SELECT `value` FROM `settings` WHERE `setting` = :key LIMIT 1");
$query->execute(array(':key' => $key));
$fetched = json_decode(json_encode($query->fetch(PDO::FETCH_ASSOC)), true);
return $fetched['value'];
}
public function getOutData()
{
$clientIp = $this->data['client-ip'];
$date = $this->data['date'];
$query = "SELECT url, date, time, COUNT(url) as frequency \n FROM SquidData \n WHERE client_ip = '{$clientIp}' AND date = '{$date}'\n GROUP BY url\n ORDER BY frequency DESC";
$db = DatabaseFactory::create("SquidDatabase")->connect();
return $db->SQLFetchAllArray($query);
}
public function getOutData()
{
$clientIp = $this->data['client-ip'];
$date = $this->data['date'];
$db = DatabaseFactory::create("SquidDatabase")->connect();
$rowsTotalNumberInArray = $db->SQLFetchArray("SELECT COUNT(client_data)\n FROM SquidData\n WHERE client_ip = '{$clientIp}' \n AND date = '{$date}'\n ORDER BY time");
return (int) $rowsTotalNumberInArray['COUNT(client_data)'];
}
/**
* create a new log entry
* @param $user_id , add user_id to log
* @param string $action , create-comment-close-undo
* @param string $param , addtional parameters that can be stored. (JSON)
* @return bool feedback
*/
public static function log($user_id, $action, $param)
{
$db = DatabaseFactory::getFactory()->fluentPDO();
$values = array('ENTRY_ID' => time(), 'action' => $action, 'user_id' => $user_id, 'param' => json_encode($param));
$query = $db->insertInto('log', $values);
$query->execute();
return true;
}
public function setInData($data)
{
$name = $data['name'];
$description = $data['description'];
$query = "INSERT INTO Roles (name, description) VALUES ('{$name}', '{$description}')";
$db = DatabaseFactory::create("AAADatabase")->connect();
$db->SQLQuery($query);
}
public function setInData($data)
{
$name = $data['name'];
$password = $data['password'];
$query = "INSERT INTO Users (name, password) VALUES ('{$name}', '{$password}')";
$db = DatabaseFactory::create("AAADatabase")->connect();
$db->SQLQuery($query);
}
public static function getCardsInSet($setcode)
{
$database = DatabaseFactory::getFactory()->getConnection();
$sql = "SELECT name, setcode, multiverseid, id FROM cards WHERE setcode = '{$setcode}' LIMIT 20";
$query = $database->prepare($sql);
$query->execute();
return $query->fetchAll();
}
public function getOutData()
{
$paginator = PaginatorFactory::create();
$beginning = $paginator->beginning;
$rowsPerPage = $paginator->rowsPerPage;
$query = "SELECT client_ip, url, COUNT(client_ip) as frequency FROM SquidData \n \t\t\tGROUP BY client_ip \n \t\t\t\tORDER BY frequency DESC \n \t\t\t\t\tLIMIT {$beginning}, {$rowsPerPage}";
$db = DatabaseFactory::create("SquidDatabase")->connect();
return $db->SQLFetchAllArray($query);
}
