PHP parse_db_error函数代码示例

 /**
  * Добавить новые теги
  * 
  * 
  * @param array $tags Теги [тег1,тег2,...]
  * @return array Записанные результаты
  */
 function Add($tags)
 {
     global $DB;
     foreach ($tags as $ikey => $value) {
         if (!$value) {
             continue;
         }
         $sql = "SELECT inserttag('" . change_q_new(substr(trim($value), 0, 20)) . "');";
         $tag[] = $DB->val($sql);
         $error[1] = parse_db_error($DB->error);
     }
     return $tag;
 }

 /**
  * Выборка тем сообщений
  *
  * @param integer $item_id  ИД треда
  * @param string  $error    Возвращает сообщения об ошибке
  */
 function GetThread($item_id, &$error)
 {
     global $DB;
     $curname = get_class($this);
     $sql = "SELECT id, fromuser_id, reply_to, post_time, msgtext, attach, title, uname, usurname, users.is_banned, login, photo, is_pro_test, role, modified, modified_id, deluser_id, deleted, small, payed, sign\n\t\tFROM \n\t\t(SELECT {$curname}.item_id, {$curname}.fromuser_id, {$curname}.id, {$curname}.reply_to, {$curname}.post_time, {$curname}.msgtext, {$curname}.attach, {$curname}.title, {$curname}.modified, \n\t\t{$curname}.small, 1 as t, modified_id, deluser_id, deleted, NULL as sign FROM {$curname} WHERE item_id = ?i\n\t\tUNION ALL \n\t\tSELECT id, 0, 0, NULL, NULL, short, NULL, title, NULL, NULL, 0, NULL, NULL, NULL, sign\n\t\tFROM articles WHERE id = ?i) as blg\n\t\tLEFT JOIN users ON fromuser_id=uid \n\t\tLEFT JOIN (SELECT DISTINCT from_id, payed FROM orders \n             WHERE payed=true AND from_date<=now() AND from_date+to_date+COALESCE(freeze_to, '0')::interval >= now() AND orders.active='true'\n             AND NOT (freeze_from_time IS NOT NULL AND NOW() >= freeze_from_time::date AND NOW() < freeze_to_time)) as pay\n\t\t ON pay.from_id=uid\n\t\tORDER BY blg.t, reply_to, post_time";
     $this->thread = $DB->rows($sql, $item_id, $item_id);
     $error .= $DB->error;
     if ($error) {
         $error = parse_db_error($error);
     } else {
         $this->msg_num = count($this->thread);
         if ($this->msg_num > 0) {
             $this->SetVars(0);
         }
     }
 }

 /**
  * Выборка тем сообщений.
  *
  * @todo Возвращает несуществующие переменные, проверить и удалить
  * 
  * @param integer $nrsk_id ИД треда
  * @param mixed   $error   Возвращает сообщение об ошибке
  *
  * @return array
  */
 public function GetThread($nrsk_id, &$error)
 {
     global $DB;
     $curname = get_class($this);
     $sql = "SELECT id, fromuser_id, reply_to, post_time, msgtext, attach, title, uname, usurname, login, photo, role, modified, modified_id, deluser_id, deleted, small, is_pro as payed\n\t\tFROM  {$curname}\n\t\tLEFT JOIN users ON fromuser_id=uid \n\t\tWHERE item_id=?i ORDER BY reply_to, post_time";
     $this->thread = $DB->rows($sql, $nrsk_id);
     $error .= $DB->error;
     if ($error) {
         $error = parse_db_error($error);
     } else {
         $this->msg_num = count($this->thread);
         if ($this->msg_num > 0) {
             $this->SetVars($this->msg_num - 1);
         }
     }
     return array($name, $id_gr, 101);
 }

 /**
  * Выборка треда сообщения
  *
  * @param string $error  Возвращает сообщение об ошибке
  * @return integer 0;
  */
 function GetThread(&$error)
 {
     $curname = get_class($this);
     global $DB;
     $sql = "SELECT id, fromuser_id, reply_to, post_time, msgtext, attach, title, uname, usurname, login, photo, role, modified, modified_id, deluser_id, deleted, small, is_pro as payed\n\t\tFROM  {$curname}\n\t\tLEFT JOIN users ON fromuser_id=uid \n\t\tORDER BY reply_to, post_time";
     $res = $DB->squery($sql);
     $error .= pg_errormessage();
     if ($error) {
         $error = parse_db_error($error);
     } else {
         $this->thread = pg_fetch_all($res);
         $this->msg_num = pg_num_rows($res);
         if ($this->msg_num > 0) {
             $this->SetVars($this->msg_num - 1);
         }
     }
     return 0;
 }

 /**
  * Популярные авторы.
  *
  * @param integer $limit
  *
  * @return <type>
  */
 public function getTopAuthors($limit = 12)
 {
     global $DB;
     $sql = 'SELECT u.login, u.photo, SUM(a.view_cnt) as viewcnt FROM
             articles_new a
             INNER JOIN users as u ON u.uid = a.user_id
             WHERE a.approved = TRUE
             GROUP BY a.user_id, u.login, u.photo ORDER BY viewcnt DESC LIMIT ?i';
     $ret = $DB->rows($sql, $limit);
     $error = $DB->error;
     if ($error) {
         $error = parse_db_error($error);
     }
     return $ret;
 }

 /**
  * Удалить новость
  *
  * @param integer $id Ид новости
  * @return string Сообщение об ошибке
  */
 function Delete($id)
 {
     global $DB;
     $DB->query('DELETE FROM news WHERE id = ?', $id);
     if ($DB->error) {
         $error = parse_db_error($DB->error);
     }
     return $error;
 }

 /**
  * Информация о рейтинге работадателя и кол-ве хитов на его страницу.
  *
  * @param    string   $login   login работадателя
  * @param    string   $err     возвращает возможную ошибку
  *
  * @return   array             массив с данными
  */
 public function GetAdditInfo($login, &$err)
 {
     global $DB;
     $ret = $DB->row('
         SELECT 
             hits, 
             rating_get(rating, is_pro, is_verify) as rating, 
             hitstoday 
         FROM employer 
         WHERE login = ?', $login);
     $err .= $DB->error;
     if ($err) {
         $err = parse_db_error($err);
     }
     return $ret;
 }

 /**
  * Установка статуса "Отказано" для автора данного предложения.
  *
  * @param integer $po_id     id предложения
  * @param integer $prj_id    id проекта
  * @param integer $user_id   id пользователя
  * @param integer $po_reason причина отказа (0 - некорректен, 1 - не подходят работы, 2 - не подходит цена, 3 - другая причина)
  * @param boolean $selected  отказано (true) / не отказано (false)
  *
  * @return string сообщение об ошибке
  */
 public function SetRefused($po_id, $prj_id, $user_id, $po_reason = 0, $refused = true)
 {
     global $DB;
     $po_id = intval($po_id);
     $prj_id = intval($prj_id);
     $user_id = intval($user_id);
     $po_reason = intval($po_reason);
     $sql = "UPDATE projects_offers SET refused='" . ($refused ? 't' : 'f') . "', refuse_reason=?i WHERE id=?i AND project_id=?i AND user_id=?i RETURNING user_id";
     $frl_id = $DB->val($sql, $po_reason, $po_id, $prj_id, $user_id);
     $error = parse_db_error($DB->error);
     $mem = new memBuff();
     $mem->delete('prjEventsCnt' . $frl_id);
     $mem->delete('prjEventsCntWst' . $frl_id);
     return $error;
 }

 /**
  * Инициализировать переменные класса данными из таблицы с помощью произвольного запроса.
  *
  * @param string $where строка после WHERE
  *
  * @return string сообщение об ошибке
  */
 public function InitFromSQL($where_prms, $any_base = true)
 {
     global $DB;
     $fields = array();
     $current = get_class($this);
     $class_vars = get_class_vars(get_class($this));
     $inner_counters = 'LEFT JOIN users_counters uc ON uc.user_id = uid';
     foreach ($class_vars as $name => $value) {
         if ($name == 'rating') {
             $fields[] = "rating_get({$current}.rating, {$current}.is_pro, {$current}.is_verify, {$current}.is_profi) as rating";
             continue;
         }
         if ($name != 'passwd') {
             $fields[] = $current . '.' . $name;
         }
     }
     $fld = implode(', ', $fields);
     $where = array_shift($where_prms);
     $sql = "SELECT {$fld}, uc.ops_frl_null as ops_null, uc.ops_frl_plus as ops_plus, uc.ops_frl_minus as ops_minus\n                FROM {$current} {$inner_counters} WHERE {$where}";
     array_unshift($where_prms, $sql);
     $result = call_user_func_array(array($DB, 'row'), $where_prms);
     if ($DB->error) {
         $error = parse_db_error($DB->error);
     } else {
         if ($result) {
             foreach ($result as $name => $value) {
                 $this->{$name} = $value;
             }
         }
     }
     return $error;
 }

 /**
  * Инициализирует дерево сообщений в данной теме
  *
  * @param integer $thread_id		идентификатор темы
  * @param string $error				сообщение об ошибке
  * @param integer $mod				имеет ли текущий юзер права на просмотр данного раздела [1 - да, 0 - нет]
  * @param integer $fid				UID текущего юзера
  * @return array					[название раздела блогов, идентификатор раздела, идентификатор "базы"]
  */
 function GetThread($thread_id, &$error, $mod = 1, $fid = 0)
 {
     global $DB;
     $sql = "SELECT id_gr, base, is_private::int, close_comments::int, fav_cnt FROM blogs_themes WHERE thread_id='{$thread_id}'\n                UNION ALL\n                SELECT id_gr, base, null::int as is_private, null::int as close_comments, null as fav_cnt FROM blogs_themes_old WHERE thread_id='{$thread_id}'";
     $res = $DB->row($sql);
     if (!$res) {
         $error = "Группа не найдена или недоступна.";
         return 0;
     }
     $error = $DB->error;
     if ($fid) {
         $r = $DB->row("SELECT last_view, status FROM blogs_themes_watch WHERE user_id = ? AND theme_id = ?", $fid, $thread_id);
         if ($r['last_view']) {
             $new = $DB->parse(", (? < post_time) AS new, ?i AS read_comments", $r['last_view'], (int) $r['status']);
         }
     }
     $this->id_gr = $res['id_gr'];
     $this->base = $res['base'];
     $this->is_private = $res['is_private'];
     $this->close_comments = $res['close_comments'];
     $this->fav_cnt = $res['fav_cnt'];
     $name = $this->GetGroupName($this->id_gr, $this->base, $mod);
     if (!$name) {
         $error = "Группа не найдена или недоступна.";
         return 0;
     }
     $sql = "\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tblogs_msgs.id, deleted_reason, fromuser_id, reply_to, post_time, msgtext, yt_link, blogs_msgs.title, modified, modified_id, deluser_id, deleted,\n\t\t\t\t\t\tusers.uname, users.usurname, users.login, users.photo, users.is_pro_test, users.role, users.is_chuck, users.is_team,\n\t\t\t\t\t\tusers.warn, users.is_banned, users.ban_where, users.is_pro as payed, users.is_pro_test as payed_test, users.reg_date, freelancer.spec, -- p.name as prof_name,\n\t\t\t\t\t\tadmins.uname AS modername, admins.usurname AS modersurname, admins.login AS moderlogin,\n\t\t\t\t\t\tblogs_poll.question as poll_question, blogs_poll.closed as poll_closed, blogs_poll.multiple as poll_multiple, sbr_meta.completed_cnt, moderator_status {$new}\n\t\t\t\t\tFROM blogs_msgs\n\t\t\t\t\tINNER JOIN users ON fromuser_id=users.uid\n\t\t\t\t\tLEFT JOIN freelancer ON fromuser_id=freelancer.uid\n\t\t\t\t\tLEFT JOIN users AS admins ON moderator_status = admins.uid\n                    LEFT JOIN sbr_meta ON sbr_meta.user_id=fromuser_id\n\t\t\t\t\t-- LEFT JOIN professions p ON p.id = freelancer.spec_orig\n\t\t\t\t\tLEFT JOIN blogs_poll ON blogs_poll.thread_id = blogs_msgs.thread_id\n\t\t\t\t\t{$join}\n\t\t\t\t\tWHERE blogs_msgs.thread_id= ?i ORDER BY reply_to, post_time\n\t\t\t\t";
     $this->thread = $DB->rows($sql, $thread_id);
     $error .= $DB->error;
     if ($error) {
         $error = parse_db_error($error);
     } else {
         $this->msg_num = count($this->thread);
         if ($this->msg_num > 0) {
             // аттач файлов
             $this->AddAttach($this->thread);
             // заблокирован ли топик
             if ($fid && $fid == $_SESSION['uid']) {
                 $role = $_SESSION['role'];
             } else {
                 if ($fid) {
                     $users = new users();
                     $role = $users->GetField($fid, $error, 'role');
                 } else {
                     $role = 0;
                 }
             }
             $is_moder = hasPermissions('blogs');
             if ($is_moder) {
                 $row = $DB->row("SELECT blogs_blocked.admin, blogs_blocked.reason, blogs_blocked.blocked_time, users.login as admin_login, users.uname as admin_name, users.usurname as admin_uname FROM blogs_blocked JOIN users ON blogs_blocked.admin = users.uid WHERE thread_id = ?i", $thread_id);
             } else {
                 $row = $DB->row("SELECT admin, reason, blocked_time FROM blogs_blocked WHERE thread_id = ?i", $thread_id);
             }
             if ($row) {
                 $this->is_blocked = 1;
                 $this->thread[$this->msg_num - 1] = array_merge($this->thread[$this->msg_num - 1], $row);
             } else {
                 $this->is_blocked = 0;
             }
             if ($this->thread[$this->msg_num - 1]['poll_question']) {
                 $r = $DB->rows("SELECT * FROM blogs_poll_answers WHERE thread_id = '{$thread_id}' ORDER BY id", $thread_id);
                 $this->thread[$this->msg_num - 1]['poll'] = $r;
             }
             // читаем тред
             $this->SetVars($this->msg_num - 1);
             if ($mod) {
                 require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/stdf.php";
                 $user = new users();
                 $user->GetUser($this->login);
                 if ($user->is_banned && $user->ban_where <= 1) {
                     $error = "Тред не найден или недоступен.";
                     return 0;
                 }
             }
             // доступ
             if ($this->is_blocked && !($fid && $fid == $this->fromuser_id || $is_moder)) {
                 $error = "Тред заблокирован администрацией";
                 return 0;
             }
         }
     }
     return array($name, $this->id_gr, $this->base);
 }

 /**
  * Получает комментрий к отзыву по его id
  *
  * @param integer $id              id комментария
  *
  * @return mixed                   массив с данными комментария или текст ошибки в случае неуспеха
  */
 function GetMsgComInfo($msg_id)
 {
     global $DB;
     $sql = "SELECT id, user_id, comment, opinion_id FROM opinion_comments WHERE id = ?";
     $res = $DB->query($sql, $msg_id);
     $error = pg_errormessage();
     if ($error) {
         $error = parse_db_error($error);
     } else {
         $ret = pg_fetch_assoc($res);
     }
     return $ret;
 }

 /**
  * Выборка тем сообщений
  *
  * @param integer $item_id  ИД треда
  * @param string  $error    Возвращает сообщения об ошибке
  */
 function GetThreads($item_id, &$error)
 {
     global $DB;
     $curname = get_class($this);
     $sql = "SELECT id, blg.from_id, parent_id, created_time, msgtext,\n                    modified_id, deleted_id,\n                    modified_time,\n                    u.uname, u.usurname, u.is_banned, u.login, u.photo, u.is_pro, u.is_pro_test, u.role,\n                    mod.uname as mod_name, mod.usurname as mod_usurname, mod.login as mod_login, mod.role as mod_role,\n                    youtube_link\n                FROM articles_comments as blg\n                INNER JOIN users as u ON u.uid=blg.from_id\n                LEFT JOIN users as mod ON mod.uid=blg.modified_id\n                WHERE blg.article_id=?i\n                ORDER BY created_time";
     $this->thread = $DB->rows($sql, $item_id);
     $error .= $DB->error;
     if ($error) {
         $error = parse_db_error($error);
     } else {
         $this->msg_num = count($this->thread);
         if ($this->msg_num > 0) {
             $this->SetVars(0);
         }
     }
     //return array($name, $id_gr, 99);
 }

 /**
  * Добавление ответа менеджера, по заявке.
  *
  * @param string $msg    Сообщение
  * @param int    $id     ИД заявки
  * @param int    $status Статус (принять(1)/отказать(0))
  *
  * @return bool
  */
 public function addAnswerManager($msg, $id, $status = 1)
 {
     global $DB;
     $type = $status == 1 ? 'msg_green' : 'msg_red';
     $DB->update('my_manager', array($type => $msg, 'status' => $status), 'id = ?i', $id);
     $error = $DB->error;
     $sql = 'SELECT uid FROM my_manager as m WHERE m.id = ?i LIMIT 1 OFFSET 0';
     $uid = $DB->val($sql, $id);
     if ($DB->error) {
         $error = parse_db_error($DB->error);
     }
     require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/smail.php';
     $smail = new smail();
     $smail->sendManagerAnswer($uid, $msg);
     return true;
 }

 /**
  * Берем определенной поле из портфолио по его ИД.
  *
  * @param integer $id         ИД портфолио
  * @param string  $fieldname  Имя поля
  *
  * @return string Значение поля
  */
 public function GetField($id, $fieldname)
 {
     global $DB;
     $sql = "SELECT {$fieldname} FROM portfolio WHERE (id= ?i )";
     $ret = $DB->val($sql, $id);
     $error = $DB->error;
     if ($error) {
         $error = parse_db_error($error);
     }
     return $ret;
 }