public function __construct($BikeId = null, $BranchId = null, $Number = null) { $this->bikes_id = $BikeId; $this->branch_identifier = $BranchId; $this->number_of_bikes = $Number; $this->db = database::getInstance(); }
private function __construct() { require_once './database.class.php'; require_once './movie.class.php'; $this->db = database::getInstance(); $this->db->connect(); }
public function init() { if (database::getInstance()->isDown() || !property::getInstance()->get('collect_statistic')) { return; } $realip = system::getInstance()->getRealIp(); $visittime = time(); $browser = self::user_browser($_SERVER['HTTP_USER_AGENT']); $os = self::user_os($_SERVER['HTTP_USER_AGENT']); $cookie = $_COOKIE['source'] ?: ''; $userid = user::getInstance()->get('id'); if ($userid == null) { $userid = 0; } if ($cookie == null) { $settime = $visittime + 365 * 24 * 60 * 60; setcookie('source', system::getInstance()->md5random(), $settime, '/'); $cookie = ''; } $referer = $_SERVER['HTTP_REFERER'] ?: ''; $path = $_SERVER['REQUEST_URI'] ?: ''; $query = "INSERT INTO " . property::getInstance()->get('db_prefix') . "_statistic (ip, cookie, browser, os, time, referer, path, reg_id) VALUES(?, ?, ?, ?, ?, ?, ?, ?)"; $stmt = database::getInstance()->con()->prepare($query); $stmt->bindParam(1, $realip, \PDO::PARAM_STR); $stmt->bindParam(2, $cookie, \PDO::PARAM_STR, 32); $stmt->bindParam(3, $browser, \PDO::PARAM_STR); $stmt->bindParam(4, $os, \PDO::PARAM_STR); $stmt->bindParam(5, $visittime, \PDO::PARAM_INT); $stmt->bindParam(6, $referer, \PDO::PARAM_STR); $stmt->bindParam(7, $path, \PDO::PARAM_STR); $stmt->bindParam(8, $userid, \PDO::PARAM_INT); $stmt->execute(); }
/** * Check if user is permament banned in database and display ban.tpl theme */ public function init() { $ip = system::getInstance()->getRealIp(); $time = time(); $userid = user::getInstance()->get('id'); if ($userid > 0) { $stmt = database::getInstance()->con()->prepare("SELECT COUNT(*) FROM " . property::getInstance()->get('db_prefix') . "_user_block WHERE (user_id = ? or ip = ?) AND (express > ? OR express = 0)"); $stmt->bindParam(1, $userid, \PDO::PARAM_INT); $stmt->bindParam(2, $ip, \PDO::PARAM_STR); $stmt->bindParam(3, $time, \PDO::PARAM_INT); $stmt->execute(); } else { $stmt = database::getInstance()->con()->prepare("SELECT COUNT(*) FROM " . property::getInstance()->get('db_prefix') . "_user_block WHERE ip = ? AND (express > ? OR express = 0)"); $stmt->bindParam(1, $ip, \PDO::PARAM_STR); $stmt->bindParam(2, $time, \PDO::PARAM_INT); $stmt->execute(); } $rowFetch = $stmt->fetch(); $count = $rowFetch[0]; if ($count > 0) { // block founded in db $content = template::getInstance()->twigRender('ban.tpl', array('local' => array('admin_email' => property::getInstance()->get('mail_from')))); template::getInstance()->justPrint($content); } }
function __construct($un = null, $pwd = null, $branch_n = null, $branch_location = null) { $this->username = $un; $this->password = $pwd; $this->branch_name = $branch_n; $this->branch_location = $branch_location; $this->db = database::getInstance(); }
public function __construct($number = null, $brand_id = null, $branch_identifier = null, $limit_set = null) { $this->db = database::getInstance(); $this->bike_id = $brand_id; $this->number_of_items = $number; $this->branch_id = $branch_identifier; $this->limit = $limit_set; }
public function __construct($id = 0) { $this->pdo = database::getInstance(); if ($id != 0) { $this->id = $id; $this->getFromDatabase(); } }
function get_title() { $db_once = database::getInstance(); $sql = "SELECT * FROM common_entry where ID = 1"; $row = $db_once->getDataSingle($sql); $Name = $row['Name']; echo $Name; //$db_once->closeConn(); }
public function __construct($id = 0) { $this->pdo = database::getInstance(); $this->tf = new textFinder(); $this->products = array(); if ($id != 0) { $this->id = $id; $this->getFromDatabase(); } }
public function __construct($id = 0) { $this->pdo = database::getInstance(); $this->tf = new textFinder(); $this->id_address = -1; if ($id != 0) { $this->id = $id; $this->getFromDatabase(); } }
private function __construct() { require_once './database.class.php'; require_once './event.class.php'; /* echo 'Creating database instance. <br/>'; */ $this->db = database::getInstance(); /* echo 'Database instance created. <br/>'; echo 'Creating connection. <br/>'; */ $this->db->connect(); /* echo 'Database connected. <br/>'; */ }
public static function getUserByEmail($email) { $db = database::getInstance(); $stmt = $db->prepare("SELECT uid FROM users WHERE email=? LIMIT 1"); $stmt->bind_param("s", $email); $db->select($stmt); $stmt->bind_result($id); if ($stmt->fetch()) { $stmt->close(); return new User($id); } return NULL; }
public function __construct($id = 0) { $this->pdo = database::getInstance(); $this->tf = new textFinder(); $this->id = $id; $this->name = ''; $this->description = ''; $this->cost = 0; $this->price = 0; $this->unit = ''; $this->id_group = 0; if ($id != 0) { $this->getFromDatabase(); } }
public static function getUser($username, $input) { $db = database::getInstance(); $stmt = $db->prepare("SELECT uid,password FROM users WHERE username=? LIMIT 1"); $stmt->bind_param("s", $username); $db->select($stmt); $stmt->bind_result($id, $password); if ($stmt->fetch()) { if (self::ValidatePassword($input, $password)) { $stmt->close(); return new User($id); } } return NULL; }
public function __construct($id = 0) { $this->pdo = database::getInstance(); $this->id_contact = ""; $this->id_billing_address = ""; $this->id_receiving_address = ""; $this->normal_billing_period = ""; $this->receiving_address = new address(); $this->billing_address = new address(); $this->tf = new textFinder(); $this->orders = array(); $this->ordersMonth = array(); $this->alreadyPaid = 0; $this->ca = 0; if ($id != 0) { $this->id = $id; $this->getFromDatabase(); } }
public function __construct($UserID = null) { $this->_database = database::getInstance(); $this->_sessionName = config::get('session/session_name'); $this->_cookieName = config::get('remember/cookie_name'); if (!$UserID) { if (session::exists($this->_sessionName)) { $UserID = session::get($this->_sessionName); if ($this->find($UserID)) { $this->_isLoggedIn = true; } else { // proceed to logout $this->logout(); } } } else { $this->find($UserID); } }
public function __construct($id = 0) { $this->pdo = database::getInstance(); $this->tf = new textFinder(); $this->id_company = -1; $this->id_address = -1; if ($id != 0) { $this->id = $id; $this->getFromDatabase(); $this->address = new address($this->id_address); $stmt = $this->pdo->PDOInstance->prepare("SELECT name FROM company WHERE id = :id"); $stmt->bindParam(':id', $this->id_company); try { $stmt->execute(); } catch (Exception $e) { echo "Problem at " . $e->getLine() . " from model customer :" . $e->getMessage(); } $stmt = $stmt->fetch(PDO::FETCH_ASSOC); $this->company_name = $stmt["name"]; } }
public function __construct($id = 0) { $this->pdo = database::getInstance(); if ($id != 0) { $this->id = $id; $this->getFromDatabase(); $this->company = new company($this->id_company); $this->employee = new employee($this->id_employee); $this->delivery_address = new address($this->id_delivery_address); $this->line_product = array(); $this->price = 0; $this->getLineProduct(); // $tva = 0; if ($this->company->getUst_id() != "" && $this->company->getNationality() != "GER") { // } else { $tva = round(19 * $this->getPrice() / 100, 2); } $this->final_price = $this->price + $tva; } }
public function &database() { static $db; if ($db == null) { $db =& database::getInstance(); } return $db; }
public static function siteOnline() { $live = self::readCache('site_live'); if (!empty($live)) { return $live; } else { $live = database::getInstance()->select('fetch', 'settings', 'value', array('name' => 'site_live')); $auction = self::writeCache('site_live', $live['value']); return $live['value']; } }
public function __construct() { $this->_database = database::getInstance(); }
$result['Histories'] = $bid_histories_result; } } $result['Auction'] = $auction; // writing data to the application cache if (!empty($_GET['histories'])) { $auction = tools::writeCache('auction_view_' . $value, $result); } else { $auction = tools::writeCache('auction_' . $value, $result); } } $result['User_id'] = $user_id; if (!empty($user_id)) { $balance = tools::readCache('bids_balance_' . $user_id); if (empty($balance)) { $balance = database::getInstance()->getRow("SELECT SUM(credit) - SUM(debit) AS balance FROM " . DB_PREFIX . "bids WHERE user_id = {$user_id}"); tools::writeCache('bids_balance_' . $user_id, $balance); } $result['Balance'] = $balance['balance']; } $result['Auction']['price'] = $result['Auction']['price']; $result['Auction']['serverTimestamp'] = time(); $result['Auction']['serverTimeString'] = date('d-m-Y, H:i:s'); $result['Auction']['time_left'] = strtotime($result['Auction']['end_time']) - time(); if ($result['Auction']['time_left'] <= 0 && $result['Auction']['closed'] == 0) { $result['Auction']['time_left'] = 1; } if ($site_online == 'no') { $result['Auction']['isPeakNow'] = 0; $result['Auction']['peak_only'] = 1; } else {
/** * Erstellt die Grundlegenden Tabellen in der Datenbank */ public function createDatabase() { $oDb = database::getInstance()->getConnection(); $oDb->query(' CREATE TABLE IF NOT EXISTS `reportUsers` ( `reportUserIdFk` INT NOT NULL UNIQUE AUTO_INCREMENT, `reportUsers` VARCHAR(255) NULL , PRIMARY KEY (`reportUsers`) ) ENGINE = InnoDB; '); if ($oDb->errno != 0) { return false; } $oDb->query(' CREATE TABLE IF NOT EXISTS `reportMacs` ( `reportMacIdFk` INT NOT NULL UNIQUE AUTO_INCREMENT, `reportMac` VARCHAR(255) NULL , PRIMARY KEY (`reportMac`) ) ENGINE = InnoDB; '); if ($oDb->errno != 0) { return false; } $oDb->query(' CREATE TABLE IF NOT EXISTS `reportAppNames` ( `reportAppNameIdFk` INT NOT NULL UNIQUE AUTO_INCREMENT, `reportAppName` VARCHAR(255) NULL , PRIMARY KEY (`reportAppName`) ) ENGINE = InnoDB; '); if ($oDb->errno != 0) { return false; } $oDb->query(' CREATE TABLE IF NOT EXISTS `reports` ( `reportId` INT NOT NULL AUTO_INCREMENT , `reportAppPath` VARCHAR(255) NULL , `reportType` VARCHAR(255) NULL , `reportAppNameId` INT NULL , `reportMacId` INT NULL , `reportUserId` INT NULL , `reportDate` VARCHAR(255) NULL , PRIMARY KEY (`reportId`) , INDEX `FkReportUser_idx` (`reportUserId` ASC) , INDEX `FKMacs_idx` (`reportMacId` ASC) , INDEX `FKReportAppNames_idx` (`reportAppNameId` ASC) , FOREIGN KEY (`reportUserId`) REFERENCES `reportUsers`(`reportUserIdFk`), FOREIGN KEY (`reportMacId`) REFERENCES `reportMacs`(`reportMacIdFk`), FOREIGN KEY (`reportAppNameId`) REFERENCES `reportAppNames`(`reportAppNameIdFk`) ) ENGINE = InnoDB; '); if ($oDb->errno != 0) { return false; } $oDb->query(' CREATE TABLE IF NOT EXISTS `config` ( `name` VARCHAR(255) NULL , `value` VARCHAR(255) NULL , PRIMARY KEY (`name`) ) ENGINE = InnoDB; '); if ($oDb->errno != 0) { return false; } return true; }
public function cancelTransaction() { try { return $this->db->rollBack(); } catch (Exception $e) { exit('<strong>ROLLBACK TRANSACTION ERROR:</strong> ' . $e->getMessage()); } } public function error() { echo '<pre>'; var_dump($this->stmt->debugDumpParams()); echo '</pre>'; } // Helper function(s) public function truncate(array $tables = null) { if (!count($tables)) { return false; } $this->startTrans(); foreach ($tables as $table) { $this->query('TRUNCATE TABLE ?'); $this->execute([$table]); } $this->endTrans(); } } $db = database::getInstance(); $_SERVER['PHP_SELF'] = str_replace('/mtg-engine', '', $_SERVER['PHP_SELF']); // Temporary, for dev purposes
/** * Gibt alle User der Wer Reports zurück * * @return array|bool */ public static function getUser() { $rows = []; $oDb = database::getInstance()->getConnection(); $aResult = $oDb->query(' SELECT DISTINCT `ru`.`reportUsers` FROM `reports` `r` JOIN `reportusers` `ru` ON ( `ru`.`reportUserIdFk` = `r`.`reportUserId` ) '); if ($oDb->errno != 0) { return false; } while ($row = $aResult->fetch_assoc()) { $rows[] = $row; } return $rows; }
function signup() { if (isset($_SESSION['user_id'])) { tools::redirect('/account'); } if (!empty($_POST)) { $data = tools::filter($_POST); $toCheck = array('username' => $data['username'], 'password' => $data['password'], 'email' => $data['email'], 'req' => $data['terms'], 'account' => $_SERVER['REMOTE_ADDR']); // check captcha if activated if ($this->settings['app']['captcha']) { $toCheck['captcha'] = $data['captcha']; } // validate the sent data $errors = tools::validate($toCheck); if (empty($errors)) { $key = mt_rand(); $toInsert = array('username' => $data['username'], 'ppasswd' => tools::generateHash($data['password']), 'email' => $data['email'], 'validation_key' => $key, 'ip' => $_SERVER['REMOTE_ADDR'], 'created' => date("Y-m-d H:i:s")); if ($this->user->add($toInsert)) { // get user id $userID = database::getInstance()->lastInsertId(); // add referrer if isset if (isset($_SESSION['referrer'])) { $this->user->addReferral(array('user_id' => $userID, 'referrer_id' => $_SESSION['referrer'])); unset($_SESSION['referrer']); } // add free signup credits $this->bid->add(array('user_id' => $userID, 'description' => 'free#signup', 'credit' => $this->settings['app']['free_signup_credits'])); // send signing email to user tools::sendMail($data['email'], 'registration', array('username' => $data['username'], 'key' => $key)); tools::setFlash($this->l('Thanks for signing up! Please check your email and click Activate Account in the message we just sent to you'), 'success'); tools::redirect('/'); } else { tools::setFlash($this->l('An error has occurred'), 'error'); tools::redirect('/user/signup'); } } else { $message = ''; foreach ($errors as $error) { $message .= $this->l($error) . '<br>'; } tools::setFlash($message, 'error'); $this->smarty->assign('data', $data); } } $this->smarty->assign('active', 7); $this->smarty->display('user/signup.tpl'); }
private function viewUpdate() { $params = array(); if (!file_exists(root . "/install/.update-" . version)) { $params['notify']['unlock_update'] = true; } $install_log = @file_get_contents(root . "/install/.update-" . version); if ($install_log == "locked") { $params['notify']['locked_update'] = true; } if (!$this->isInstalled()) { $params['notify']['not_installed'] = true; } else { $stmt = database::getInstance()->con()->query("SELECT `version` FROM `" . property::getInstance()->get('db_prefix') . "_version` LIMIT 1"); $res = $stmt->fetch(\PDO::FETCH_ASSOC); $usedVersion = $res['version']; if ($usedVersion == version) { $params['notify']['actual_version'] = true; } $updateQuery = null; if (sizeof($params['notify']) == 0) { if (system::getInstance()->post('startupdate')) { $update_sql_array_files = $this->foundVersionUpdates($usedVersion, version); if (is_array($update_sql_array_files)) { foreach ($update_sql_array_files as $update_file) { $updateQuery .= @file_get_contents(root . '/install/sql/' . $update_file) . '\\n'; } } if ($updateQuery != null) { $updateQuery = str_replace('{$db_prefix}', property::getInstance()->get('db_prefix'), $updateQuery); database::getInstance()->con()->exec($updateQuery); @file_put_contents(root . "/install/.update-" . version, 'locked'); // only 1 run $params['notify']['success'] = true; } else { $params['notify']['nosql_data'] = true; } } } } return template::getInstance()->twigRender('update.tpl', $params); }
<?php require_once '../model/link_company_delivery_address.php'; require_once '../model/address.php'; require_once '../model/database.php'; $id_DA = $_GET["idDA"]; $id_c = $_GET["idC"]; $pdo = database::getInstance(); $pdo = $pdo->PDOInstance; $stmt = $pdo->prepare('SELECT id FROM link_company_delivery_address WHERE id_company = :idc and id_address = :ida'); $stmt->bindParam(':idc', $id_c); $stmt->bindParam(':ida', $id_DA); $stmt->execute(); $result = $stmt->fetch(); $idLDA = $result['id']; $lda = new link_company_delivery_address($idLDA); $address = new address($lda->getId_address()); ?> <h2>Set this Address to Database</h2> <form method="get" action="../controller/setLinkDA.php"> <input type="hidden" name="idA" value="<?php echo $address->getId(); ?> "> <input type="hidden" name="idC" value="<?php echo $id_c; ?> "> <div class="form-group"> <label for="line">Line</label>
/** * Injects the database to the container * * @return database the database */ public function setDatabase() { $array = 'mysql' == $this['Config']['database']['type'] ? array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") : array(); return database::getInstance($this['Config']['database']['host'], $this['Config']['database']['database'], $this['Config']['database']['user'], $this['Config']['database']['password'], $this['Config']['database']['type'], $array); }
private function loadAllData() { if (sizeof($this->full_access_data) < 1) { $query = database::getInstance()->con()->query("SELECT * FROM " . property::getInstance()->get('db_prefix') . "_user_access_level"); $this->full_access_data = $query->fetchAll(\PDO::FETCH_ASSOC); } }