static function add($table, $kfield, $tfield, $kvalue, $tvalue)
{
if (wra_multiselect::isexist($table, $kfield, $tfield, $kvalue, $tvalue)) {
return;
}
$wd = new wra_db();
$wd->query = 'INSERT INTO `' . WRA_CONF::$db_prefix . "{$table}` (`id`,`{$kfield}`,`{$tfield}`)\n values(null,'{$kvalue}' ,'{$tvalue}')";
$wd->execute();
$wd->close();
unset($wd);
}
function add()
{
//добавление нового объекта
$wd = new wra_db();
$this->id = WRA::getnewkey("" . WRA_CONF::$db_prefix . 'adminnotices');
$wd->query = "INSERT INTO `" . WRA_CONF::$db_prefix . "adminnotices` (\n `id`,\n `dateadd`,\n `ip`,\n `message`,\n `status`,`header`\n )VALUES(\n '{$this->id}',\n '{$this->dateadd}',\n '{$this->ip}',\n '{$this->message}',\n '{$this->status}', '{$this->header}'\n )";
$wd->execute();
if (!WRA_CONF::$usegetkey) {
$this->id = $wd->getlastkey();
}
$wd->close();
unset($wd);
}
function query($request)
{
$wd = new wra_db();
$ip = WRA::getip();
$time = time();
$wd->query = 'INSERT INTO `' . WRA_CONF::$db_prefix . "requests` (\n `request`,\n `ip`,\n `time`\n )VALUES(\n '{$request}',\n '{$ip}',\n '{$time}'\n )";
$wd->execute();
$id = $wd->getlastkey();
$wd->close();
// $this->currentobjid = wra_objects::addnewobject('wra_fbu', $this->id, $this->objectadres);
unset($wd);
return $id;
}
function delete()
{
$wd = new wra_db();
$wd->query = 'DELETE FROM `' . WRA_CONF::$db_prefix . "foursqvenues` where `id`='{$this->id}'";
$wd->execute();
$wd->close();
unset($wd);
return true;
}
function delete()
{
//удаление объекта
$wd = new wra_db();
$wd->query = 'DELETE FROM `' . WRA_CONF::$db_prefix . "usersrights` where `id`='{$this->id}'";
$wd->execute();
$wd->close();
unset($wd);
}
function update()
{
$wd = new wra_db($wf);
$wd->query = 'UPDATE `' . WRA_CONF::$db_prefix . "users`\n\t\t\t\tSET `login`='{$this->login}' , `email`='{$this->email}' , \n\t\t\t\t`password`='{$this->password}' , `active`= '{$this->active}' , \n\t\t\t\t`displayname` ='{$this->displayname}', `namei`= '{$this->namei}' , `namef`='{$this->namef}' ,\n\t\t\t\t`nameo`='{$this->nameo}' , `cellphone`= '{$this->cellphone}' , `cityid`='{$this->cityid}' ,\n\t\t\t\t`lasttime`='{$this->lasttime}' , `dolg`='{$this->dolg}' , `icq`='{$this->icq}' , `twitter`='{$this->twitter}' , `web`='{$this->web}' ,\n\t\t\t\t`adresid`='{$this->adresid}', `groupid`='{$this->groupid}', `avatar`='{$this->avatar}',`adres`='{$this->adres}', `tmbavatar`='{$this->tmbavatar}',\n\t\t\t\t`issotr`='{$this->issotr}',`company`='{$this->company}',\n\t\t\t\t`bday`='{$this->bday}',`description`='{$this->description}',`gender`='{$this->gender}',\n\t\t\t\t`interests`='{$this->interests}',`infor`='{$this->infor}',\n\t\t\t\t`fromwhere`='{$this->fromwhere}',`signin`='{$this->signin}',`discount`='{$this->discount}'\n\t\tWHERE `id`='{$this->id}' \n\t\t\t\t";
$wd->execute();
$wd->close();
unset($wd);
return true;
}
function delete()
{
$wd = new wra_db();
$wd->query = "DELETE FROM `" . WRA_CONF::$db_prefix . "langed` where `id`='{$this->id}'";
$wd->execute();
$wd->close();
unset($wd);
return true;
}
function delete()
{
//удаление объекта
$wd = new wra_db();
$wd->query = "DELETE FROM `" . WRA_CONF::$db_prefix . "virtualpage` where `id`='{$this->id}'";
$wd->execute();
$wd->close();
unset($wd);
wra_objects::deleteobj($this->currentobjid);
return true;
}
static function getnewkey($table)
{
//получаем новый ключ для таблицы table
if (!WRA_CONF::$usegetkey) {
return '';
}
$result = 1;
$wd = new wra_db();
$wd->query = 'select value from ' . WRA_CONF::$db_prefix . "keys where tablename='{$table}'";
$wd->executereader();
if ($wd->error == '' && $wd->rows_count != 0) {
if ($u0 = $wd->read()) {
$result = $u0[0] + 1;
}
$wd->query = 'update ' . WRA_CONF::$db_prefix . "keys set value='{$result}' where tablename='{$table}'";
$wd->execute();
$wd->close();
} else {
WRA::insertkey($table);
}
unset($wd);
return $result;
}
function deletefirst($lang)
{
$wd = new wra_db();
$wd->query = 'DELETE FROM `' . WRA_CONF::$db_prefix . $this->table . $lang . "` where `id`='{$this->curid}'";
$wd->execute();
$wd->close();
unset($wd);
return true;
}
