Subversion Repositories personal-webbase

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
1 daniel-mar 1 
<?php
2 
 
3 
if (!defined('WBLEGAL')) die('Kann nicht ohne Personal WebBase ausgef&uuml;hrt werden.');
4 
 
5 
if ($aktion == 'lock')
6 
{
7 
        $res = db_query("SELECT `banned` FROM `".$WBConfig->getMySQLPrefix()."users` WHERE `id` = '".db_escape($id)."'");
8 
        $row = db_fetch($res);
9 
 
10 
        if ($row['banned'] == '1')
11 
                db_query("UPDATE `".$WBConfig->getMySQLPrefix()."users` SET `banned` = '0' WHERE `id` = '".db_escape($id)."'");
12 
        else
13 
                db_query("UPDATE `".$WBConfig->getMySQLPrefix()."users` SET `banned` = '1' WHERE `id` = '".db_escape($id)."'");
14 
 
15 
        wb_redirect_now($_SERVER['PHP_SELF'].'?modul='.$modul.'&seite=main');
16 
}
17 
 
18 
if ($aktion == 'edit')
19 
{
20 
        if ($f_banned)
21 
                $f_gesp = '1';
22 
        else
23 
                $f_gesp = '0';
24 
        db_query("UPDATE `".$WBConfig->getMySQLPrefix()."users` SET `username` = '".db_escape($f_username)."', `personal_name` = '".db_escape($f_personal_name)."', `banned` = '".db_escape($f_gesp)."', `email` = '".db_escape($f_email)."' WHERE `id` = '".db_escape($id)."'");
25 
        if ($f_neupwd) db_query("UPDATE `".$WBConfig->getMySQLPrefix()."users` SET `password` = '".md5($f_password)."' WHERE `id` = '".db_escape($id)."'");
26 
 
27 
        wb_redirect_now($_SERVER['PHP_SELF'].'?modul='.$modul.'&seite=main');
28 
}
29 
 
30 
if ($aktion == 'del')
31 
{
32 
        db_query("DELETE FROM `".$WBConfig->getMySQLPrefix()."users` WHERE `id` = '".db_escape($id)."'");
33 
        if (db_affected_rows() > 0)
34 
                db_query("OPTIMIZE TABLE `".$WBConfig->getMySQLPrefix()."users`");
35 
 
36 
        wb_redirect_now($_SERVER['PHP_SELF'].'?modul='.$modul.'&seite=main');
37 
}
38 
 
39 
?>