Example #1
0
 function delete_category()
 {
     $cat_id = $_POST['remove_cat'];
     $query = "update categories set status='delete' where id={$cat_id}";
     $result = $db->query($query);
     dberror($result);
 }
Example #2
0
        $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>
Example #3
0
 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());
 }
Example #4
0
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;
    }
}
Example #6
0
 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;
     }
 }