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