function delete_category() { $cat_id = $_POST['remove_cat']; $query = "update categories set status='delete' where id={$cat_id}"; $result = $db->query($query); dberror($result); }
$i = $_SESSION['current'] - 3; $j = 3; $_SESSION['current'] = $i; } } else { $i = 0; $j = 3; $_SESSION['current'] = $i; } if ($_GET['default']) { $query = "select title, description, posted_on, articles.last_modified from articles join categories on categories.id=category_id where articles.status='active' and categories.status='active' limit {$i},{$j}"; } else { $query = "select title, description, posted_on, articles.last_modified from articles join categories on categories.id=category_id join users on posted_by=users.id where articles.status='active' and categories.status='active' and posted_by={$id} limit {$i},{$j}"; } $result = $db->query($query); dberror($result); while ($row = $result->fetchRow()) { $str .= '<div class=wrap><div class="title"><div><center>' . $row[0] . '</center></div></div>'; $str .= '<div class="description">' . $row[1] . '</div><br>'; $str .= '<div class="post">Posted On: ' . $row[2] . '</div>'; if ($_SESSION['flag'] == 'mine') { $str .= '<div class="modify">Last Modified: ' . $row[3] . '</div>'; $str .= '<div class="modify">Posted By: ' . $user . '</div></div><hr><br>'; } else { $str .= '<div class="modify">Last Modified: ' . $row[3] . '</div></div><hr><br>'; } } $str1 = <<<str1 <div class="articles"> <div class="articles_header"> <center>Articles</center>
public function delete() { db()->query("DELECT FROM `bot_user` WHERE `bot_id` = " . db()->quote($this->id)); db()->query("DELETE FROM bots WHERE id=" . db()->quote($this->id)) or die(dberror()); }
function dbtest() { if ($dbc = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)) { if (!mysql_select_db(DB_NAME)) { $error_str = "Error: Could not select database: " . dberror(); } else { dbclose($dbc); return true; } } else { $error_str = "Error: Could not connect to database: " . dberror(); } return false; }
function action_get_delete_user($params) { if (user()->right() == 'ADMIN') { try { $user = USER::byID($params['values'][0]); if ($user->delete()) { messages()->success(sprintf(_('User %s deleted'), $user->name())); } else { messages()->error(sprintf(_('Deletion error: %s'), dberror())); } } catch (Exception $e) { messages()->error(sprintf(_('Deletion error: %s'), $e)); } header('Location: ' . view('users')); die; } }
public function update($name = false, $email = false, $password = false, $right = false) { $succs = array(); $erros = array(); $SET = ''; if ($right) { $SET .= ', `right`=' . db()->quote($right); } if ($name) { $SET .= ', name=' . db()->quote($name); } if ($email) { $SET .= ', email=' . db()->quote($email); } if ($password) { $SET .= ', password='******'UPDATE users SET id=id' . $SET . ' WHERE id=' . db()->quote($this->id))) { return true; } else { messages()->error(sprintf(_('Update error: %s'), dberror() . ' ' . 'UPDATE users SET id=id' . $SET . ' WHERE id=' . db()->quote($this->id))); return false; } }