Subversion Repositories personal-webbase

Rev

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

  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. ?>