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); }