public static function save($table, $id, $name, $value) { // Insert new meta dataset into database $sql = new SqlManager(); $insert = array("object_table" => $table, "object_id" => $id, "name" => $name, "value" => $value); $sql->insert("meta", $insert); }
public static function save($code, $value, $lang = null) { // Save specific locale value by given key if (!$lang) { $lang = self::getLanguage(); } // Check if locale already exists $sql = new SqlManager(); $sql->setQuery("\n\t\t\tSELECT code FROM locale \n\t\t\tWHERE code = '{{code}}' \n\t\t\tAND language = {{lang}}\n\t\t\tLIMIT 1"); $sql->bindParam('{{code}}', $code); $sql->bindParam('{{lang}}', $lang, "int"); $check = $sql->result(); $loc = array('code' => $sql->escape($code), 'language' => $sql->escape($lang, "int"), 'text' => $sql->escape($value), 'lastchanged' => DateManager::now()); // Either update database or insert new entry for given locale if (!$check['code']) { $loc['created'] = DateManager::now(); $sql->insert("locale", $loc); } else { $sql->update("locale", $loc); } // Refresh cache to make sure new locale entry will be used $cachekey = "locale:" . $lang; Cache::clear($cachekey); self::load($lang); }
public static function save($type, $id, $data) { $data['object_type'] = $type; $data['object_id'] = $id; $sql = new SqlManager(); if (!isset($data['id'])) { $sql->insert("version", $data); } else { $sql->setQuery("\n\t\t\t\tSELECT id FROM version\n\t\t\t\tWHERE id = {{id}}\n\t\t\t\tLIMIT 1\n\t\t\t\t"); $sql->bindParam("{{id}}", $data['id']); $check = $sql->result(); if (isset($check['id'])) { $sql->update("version", $data); } else { $sql->insert("version", $data); } } }
public function set($name, $value) { // Set config and update database $sql = new SqlManager(); $set = array("name" => $name, "user_id" => $this->user, "value" => $value); if (isset($this->config[$name])) { $sql->update("config", $set); } else { $sql->insert("config", $set); } $this->config[$name] = $value; }
public function create(array $data, array $meta = array()) { // Create new user from given data array $sql = new SqlManager(); if (isset($data['password'])) { // Save password as bcrypt hash`` $data['password'] = Crypt::createHash($data['password']); } $sql->insert("user", $data); $id = $sql->getLastInsertID(); // Save meta data foreach ($meta as $key => $value) { Meta::save("user", $id, $key, $value); } // Return database ID of added user return $id; }
private function create() { // Create a new session $this->id = session_id(); // And write session into database $insert = array("phpkey" => $this->id, "created" => DateManager::now()); $sql = new SqlManager(); $sql->insert("session", $insert); // Save data in instance $this->data = $insert; $this->data['id'] = $sql->getLastInsertID(); // Write meta data into database foreach ($_SERVER as $key => $value) { Meta::save("session", $this->data['id'], $key, $value); } // Set login status $this->loggedin = false; // Create user and config object for session $this->user = new User(); $this->config = new Config(); }