/** * @param string $key */ public function set($guildID, $key, $value) { $json = $this->getAll($guildID); $json->{$key} = $value; $data = json_encode($json); $this->db->execute("INSERT INTO settings (serverID, settings) VALUES (:serverID, :settings) ON DUPLICATE KEY UPDATE settings = :settings", array(":serverID" => $guildID, ":settings" => $data)); }
/** * @return Model */ public function synchronize() { $tables = $this->db->tables(); if (false === array_search($this->table, $tables)) { $properties = array(); foreach ($this->properties as $name => $instance) { if (is_subclass_of($instance, 'Property')) { $properties[] = "`{$name}` " . $instance->__toString(); } } $this->db->execute("CREATE TABLE `{$this->table}` (" . implode(', ', $properties) . ")"); } return $this; }
public static function updatePassword($password) { $userID = user::getUserID(); $password = self::genPassword($password); Db::execute("UPDATE zz_users SET password = :password WHERE id = :userID", array(":password" => $password, ":userID" => $userID)); return "Updated password"; }
public function process() { $db = new Db(); $perishable_token = $this->generateToken(); $query = "insert into user (email, password, perishable_token, last_activity_timestamp, signup_timestamp) values (" . "'" . $this->attributes['email'] . "', " . "'" . $this->attributes['password'] . "', " . "'" . $perishable_token . "', " . time() . ", " . time() . ")"; return $db->execute($query); }
public static function updatePassword($password) { $userID = user::getUserID(); $password = self::genPassword($password); Db::execute('UPDATE zz_users SET password = :password WHERE id = :userID', array(':password' => $password, ':userID' => $userID)); return 'Updated password'; }
function UpdateRouteAssignment() { $arrRouteAssignment = array('varRouteId' => $_POST['txtRouteId'], 'varRouteAssignment' => $_POST['txtRouteAssignment']); Db::execute('UPDATE routes SET assignment = :varRouteAssignment WHERE rtcode = :varRouteId', $arrRouteAssignment); $varResult = Db::getRow('SELECT * FROM routes WHERE rtcode = ?', $arrRouteAssignment['varRouteId']); echo 'Update Completed. Route assigned to ' . $varResult['assignment']; }
public static function updatePoints($killID, $tempTables = false) { $points = self::calculatePoints($killID, $tempTables); $temp = $tempTables ? "_temporary" : ""; Db::execute("update zz_participants{$temp} set points = :points where killID = :killID", array(":points" => $points, ":killID" => $killID)); return $points; }
/** * @url POST profile/{userId} * @url PUT {userId} */ protected function postProfile($userId, $firstname, $lastname, $nickname, $phone, $birthdate, $school, $province, $level, $purpose, $avatarId) { if ($userId == \TTO::getUserId()) { $statement = ' UPDATE user SET firstname = :firstname, lastname = :lastname, nickname = :nickname, phone = :phone, birthdate = :birthdate, school = :school, province = :province, level = :level, purpose = :purpose, avatarId = :avatarId WHERE userId = :userId '; $bind = array('firstname' => $firstname, 'lastname' => $lastname, 'nickname' => $nickname, 'phone' => $phone, 'birthdate' => $birthdate, 'school' => $school, 'province' => $province, 'level' => $level, 'purpose' => $purpose, 'avatarId' => $avatarId, 'userId' => $userId); $row_update = \Db::execute($statement, $bind); \TTOMail::createAndSendAdmin('A user updated profile', json_encode($bind)); $response = new \stdClass(); $response->row_update = $row_update; return $response; } else { throw new RestException(401, 'No Authorize or Invalid request !!!'); } }
function irc_log($nick, $uhost, $command, $params) { $id = Db::queryField("SELECT id FROM zz_irc_access WHERE name = :nick AND host = :uhost", "id", array(":nick" => $nick, ":uhost" => $uhost)); if ($id == null) { $id = 0; } Db::execute("INSERT INTO zz_irc_log (id, nick, command, parameters) VALUES (:id, :nick, :command, :params)", array(":nick" => $nick, ":id" => $id, ":command" => $command, ":params" => implode(" ", $params))); }
public static function cachePrimer() { Db::execute("set session wait_timeout = 120"); self::storeResult(Db::query("select c.* from zz_characters c left join zz_participants p on (c.characterID = p.characterID) where dttm > date_sub(now(), interval 5 day) group by characterID", array(), 0), "select name from zz_characters where characterID = :id", ":id", "characterID", "name"); self::storeResult(Db::query("select * from zz_corporations", array(), 0), "select name from zz_corporations where corporationID = :id", ":id", "corporationID", "name"); self::storeResult(Db::query("select * from zz_alliances", array(), 0), "select name from zz_alliances where allianceID = :id", ":id", "allianceID", "name"); self::storeResult(Db::query("select * from ccp_invTypes", array(), 0), "select typeName from invTypes where typeID = :typeID", ":typeID", "typeID", "typeName"); }
/** * @param string $sql * @param array $params * @return bool|ResultSet */ protected function runSql($sql, $params = array()) { $rez = $this->db->execute($sql, $params); if (!$rez) { $this->logError($this->db->lastError); } return $rez; }
/** * 定单处理 * @param $tid 定单编号 */ public function handle($tid) { Db::table('balance')->where('tid', $tid)->update(array('status' => 1)); //添加会员余额 $balance = Db::table('balance')->where('siteid', SITEID)->where('tid', $tid)->first(); $sql = "UPDATE " . tablename('member') . " SET credit2=credit2+{$balance['fee']} WHERE uid={$balance['uid']}"; Db::execute($sql); }
/** * 删除数据 * * @param string $table * @param string $where */ public function delete($where = null, $table = '') { if (empty($table)) { $table = $this->table; } $sql = 'DELETE FROM ' . $table . (is_null($where) ? '' : ' WHERE ' . (is_array($where) ? implode(' AND ', $where) : $where)); return $this->db->execute($sql); }
function consumeNonce($form) { $now = time(); if (!isset($form['nonce']) || $form['nonce'] != $_SESSION['hg_nonce'] || !preg_match('/^\\d\\d\\d\\d-\\d\\d-\\d\\dT\\d\\d:\\d\\d:\\d\\dZ/', $form['nonce'], $ma) || !($timestamp = strtotime($ma[0])) || $timestamp > $now || $timestamp < $now - 60 * 60 || Db::scalarQuery('SELECT stamp FROM jos_oauthp_nonces WHERE nonce = ?', array($form['nonce']))) { //throw new Exception('Bad token', 405); } Db::execute('UPDATE jos_oauthp_nonces SET stamp = 1 WHERE nonce = ?', array($form['nonce'])); unset($_SESSION['hg_nonce']); }
public function save() { $params = json_encode($this->settings); $updateQuery = 'UPDATE jos_extensions SET params = ? WHERE `type`=\'component\' AND `element` = \'com_hubgraph\''; $insertQuery = 'INSERT INTO jos_extensions(name, `type`, `element`, params) VALUES (\'HubGraph\', \'component\', \'com_hubgraph\', ?)'; if (!Db::update($updateQuery, array($params))) { Db::execute($insertQuery, array($params)); } }
function updateJEditableField($table, $field, $value, $id) { $data = array('id' => $id, 'value' => $value); try { Db::execute("UPDATE {$table} SET {$field} = :value WHERE id = :id", $data); echo nl2br($value); } catch (Exception $e) { echo 'Error occured'; } }
function addStatus() { unset($_GET['action']); try { Db::execute("INSERT INTO status_names(name, WIP, serial)\n VALUES(:name, :WIP, (select max(id) from status_names) + 1)", $_GET); response('success', Db::getLastInsertId()); } catch (Exception $e) { response('error', $e->getMessage()); } }
function createNonce() { //set_include_path(get_include_path() . PATH_SEPARATOR . JPATH_BASE.'/libraries/openid'); //require_once 'Auth/OpenID/Nonce.php'; $now = time(); $_SESSION['hg_nonce'] = sha1($now); //Auth_OpenID_mkNonce($now); Db::execute('INSERT INTO `#__oauthp_nonces` (created, nonce, stamp) VALUES (CURRENT_TIMESTAMP, ?, 0)', array($_SESSION['hg_nonce'])); return $_SESSION['hg_nonce']; }
public function __construct() { //创建migration表用于记录动作 if (!Schema::tableExists('migrations')) { $sql = "CREATE TABLE " . c('database.prefix') . 'migrations(migration varchar(255) not null,batch int)CHARSET UTF8'; Db::execute($sql); } if (empty(self::$batch)) { self::$batch = Db::table('migrations')->max('batch') ?: 0; } }
public static function beSocial($killID) { if ($killID < 0) { return; } $ircMin = 5000000000; $twitMin = 10000000000; // This is an array of characters we like to laugh at :) $laugh = array(1633218082, 924610627, 619471207, 268946627, 179004085, 428663616); $count = Db::queryField("select count(*) count from zz_social where killID = :killID", "count", array(":killID" => $killID), 0); if ($count != 0) { return; } // Get victim info $victimInfo = Db::queryRow("select * from zz_participants where killID = :killID and isVictim = 1", array(":killID" => $killID)); if ($victimInfo == null) { return; } $totalPrice = $victimInfo["total_price"]; if (!in_array($victimInfo["characterID"], $laugh)) { // If in laugh array, skip the checks // Check the minimums, min. price and happened in last 12 hours if ($totalPrice < $ircMin) { return; } } Info::addInfo($victimInfo); $url = "https://zkillboard.com/detail/{$killID}/"; if ($totalPrice >= $twitMin) { $url = Twit::shortenUrl($url); } $message = "|g|" . $victimInfo["shipName"] . "|n| worth |r|" . Util::formatIsk($totalPrice) . " ISK|n| was destroyed! {$url}"; if (!isset($victimInfo["characterName"])) { $victimInfo["characterName"] = $victimInfo["corporationName"]; } if (strlen($victimInfo["characterName"]) < 25) { $name = $victimInfo["characterName"]; if (Util::endsWith($name, "s")) { $name .= "'"; } else { $name .= "'s"; } $message = "{$name} {$message}"; } Db::execute("insert into zz_social (killID) values (:killID)", array(":killID" => $killID)); Log::irc("{$message}"); $message = Log::stripIRCColors($message); if ($totalPrice >= $twitMin) { $message .= " #tweetfleet #eveonline"; $return = Twit::sendMessage($message); $twit = "https://twitter.com/eve_kill/status/" . $return->id; Log::irc("Message was also tweeted: |g|{$twit}"); } }
/** * @param $password * @param $time */ public function updateValuesInDatabase($password, $time, $browser) { $database = new Db(); $username = $_SESSION[self::$setSessionUser]; $database->query('UPDATE users SET cookie_password = :cookie_password, coockie_date = :cookie_date, browser = :browser WHERE username = :username'); $database->bind(':username', $username); $database->bind(':cookie_password', $password); $database->bind(':cookie_date', $time); $database->bind(':browser', $browser); $database->execute(); }
function DropPagesTable() { global $db_config; $db = new Db($db_config); $sql = <<<SQL DROP TABLE IF EXISTS `pages`; SQL; if ($db->execute($sql)) { echo "Pages table dropped successfully"; } else { echo "Error: Could not drop pages table. Please try again"; } }
public function execute($nick, $uhost, $channel, $command, $parameters, $nickAccessLevel) { $keyIDs = array(); $entity = implode(" ", $parameters); if (sizeof($parameters) == 1 && (int) $parameters[0]) { $keyIDs[] = (int) $parameters[0]; } else { // Perform a search $chars = array(); $corps = array(); $charResult = Db::query("select characterID from zz_characters where name = :s", array(":s" => $entity)); foreach ($charResult as $char) { $chars[] = $char["characterID"]; } foreach ($chars as $charID) { $corpID = Db::queryField("select corporationID from zz_participants where characterID = :c order by killID desc limit 1", "corporationID", array(":c" => $charID)); if ($corpID !== null && $corpID > 0) { $corps[] = $corpID; } } if (sizeof($chars)) { $keys = Db::query("select distinct keyID from zz_api_characters where isDirector = 'F' and characterID in (" . implode(",", $chars) . ")"); foreach ($keys as $key) { $keyIDs[] = $key["keyID"]; } } else { $corpID = Db::queryField("select corporationID from zz_corporations where name = :s order by memberCount desc", "corporationID", array(":s" => $entity)); if ($corpID !== null && $corpID > 0) { $corps[] = $corpID; } } if (sizeof($corps)) { $keys = Db::query("select distinct keyID from zz_api_characters where isDirector = 'T' and corporationID in (" . implode(",", $corps) . ")"); foreach ($keys as $key) { $keyIDs[] = $key["keyID"]; } } } if (sizeof($keyIDs) == 0) { irc_out("|r|Unable to locate any keys associated with {$entity} |n|"); } else { $keyIDs = array_unique($keyIDs); sort($keyIDs); $key = sizeof($keyIDs) == 1 ? "keyID" : "keyIDs"; $keys = implode(", ", $keyIDs); Db::execute("update zz_api set errorCode = 0, errorCount = 0, lastValidation = 0 where keyID in ({$keys})"); if (sizeof($keyIDs)) { irc_out("Revalidating {$key}: {$keys}"); } } }
public static function set($key, $value) { if (!User::isLoggedIn()) { throw new Exception("User is not logged in."); } $id = User::getUserID(); self::$userConfig = null; if (is_null($value) || is_string($value) && strlen(trim($value)) == 0) { // Just remove the row and let the defaults take over return Db::execute("delete from zz_users_config where id = :id and locker = :key", array(":id" => $id, ":key" => $key)); } $value = json_encode($value); return Db::execute("insert into zz_users_config (id, locker, content) values (:id, :key, :value)\n on duplicate key update content = :value", array(":id" => $id, ":key" => $key, ":value" => $value)); }
function CreateUser() { global $db_config; $db = new Db($db_config); $sql = <<<SQL INSERT INTO `users` (`id`, `username`, `password`, `active`, `created_at`, `modified_at`) VALUES (%d, '%s', '%s', %d, '%s', '%s'); SQL; $sql = sprintf($sql, 1, $db->escString("adminone"), $db->escString(md5("password" . SALT)), 1, date('Y-m-d h:i:s'), date('Y-m-d h:i:s')); $db->execute($sql); echo "User created successfully"; }
/** * @url POST removenotification */ protected function postRemoveNotification($userId, $routeUrl, $fromUserId) { $statement = ' DELETE FROM notification WHERE userId = :userId AND routeUrl = :routeUrl AND fromUserId = :fromUserId '; $bind = array('userId' => $userId, 'routeUrl' => $routeUrl, 'fromUserId' => $fromUserId); \Db::execute($statement, $bind); $statement = ' UPDATE user SET notificationCount = notificationCount - 1 WHERE userId = :userId '; $bind = array('userId' => $userId); \Db::execute($statement, $bind); }
/** * @url POST * @url POST /user/{userId} */ protected function addSection($courseId, $name, $description, $seq, $userId = null) { if (\TTO::getRole() == 'admin') { $statement = ' INSERT INTO section (courseId, name, description, seq) VALUES (:courseId, :name, :description, :seq) '; $bind = array('courseId' => $courseId, 'name' => $name, 'description' => $description, 'seq' => $seq); \Db::execute($statement, $bind); $sectionId = \Db::getLastInsertId(); $statement = 'SELECT * FROM section WHERE sectionId = :sectionId'; $bind = array('sectionId' => $sectionId); return \Db::getRow($statement, $bind); } else { throw new RestException(401, 'No Authorize or Invalid request !!!'); } }
public function move($new) { if (!$this->found) { return false; } if ($this->posicion == $new) { return false; } if ($this->posicion > $new) { Db::execute("UPDATE `inmuebles_fotos`\n SET `posicion` = `posicion` + 1\n WHERE `posicion` < {$this->posicion}\n AND `posicion` >= {$new}\n AND `inmueble_id` = {$this->inmueble_id}"); } else { Db::execute("UPDATE `inmuebles_fotos`\n SET `posicion` = `posicion` - 1\n WHERE `posicion` > {$this->posicion}\n AND `posicion` <= {$new}\n AND `inmueble_id` = {$this->inmueble_id}"); } $this->posicion = $new; $this->update(); return true; }
function createProject() { $name = strval($_GET['project']); if (empty($name)) { return response('error', 'Empty project name'); } $exist = Db::getValue('SELECT count(id) from projects where name= ?', $name); if ($exist) { return response('error', 'Project name already exist'); } // Insert project $data = array('name' => $name, 'status' => 'active'); Db::execute('INSERT INTO projects(name, status) VALUES(:name, :status)', $data); $insertId = Db::getLastInsertId(); if ($insertId) { return response('success', $insertId); } return response('error', 'Something went wrong! please try again.'); }
/** * Register a new user if username doesn't already exist * * @param \model\RegisterUser $credential * @param \model\IregisterListener $listener * @return bool */ public function doRegister(\model\RegisterUser $credential, model\IregisterListener $listener) { $username = $credential->getUsername(); $records = new Db(); $records->query('SELECT username,password FROM users WHERE username = :username'); $records->bind(':username', $username); $records->resultset(); if ($records->rowCount() > 0) { $listener->userExist("RegisterModel::UserAlreadyExistException"); } else { $password = password_hash($credential->getPassword(), PASSWORD_BCRYPT); $records->query('INSERT INTO users (username, password) VALUES (:username, :password)'); $records->bind(':username', $username); $records->bind(':password', $password); $records->execute(); $_SESSION[self::$newUsername] = $username; return true; } }