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 == 'new')
  6. {
  7.         $res = db_query("SELECT `user_cnid` FROM `".$WBConfig->getMySQLPrefix()."folders` WHERE `id` = '".db_escape($folder)."'");
  8.         $row = db_fetch($res);
  9.         if ($row['user_cnid'] != $benutzer['id'])
  10.                 $folder = 0;
  11.  
  12.         db_query("INSERT INTO ".$WBConfig->getMySQLPrefix()."popper_konten (`name`, `folder_cnid`, `server`, `username`, `password`, `personal_name`, `replyaddr`, `user_cnid`) VALUES ('".db_escape($name)."', '".db_escape($folder)."', '".db_escape($mserver)."', '".db_escape($musername)."', '".db_escape($mpassword)."', '".db_escape($personal_name)."', '".db_escape($replyaddr)."', '".$benutzer['id']."')");
  13.         if ($danach == 'A') wb_redirect_now($_SERVER['PHP_SELF'].'?seite=main&modul='.$modul);
  14.         if ($danach == 'B') wb_redirect_now($_SERVER['PHP_SELF'].'?seite=edit&modul='.$modul.'&aktion=new&danach='.$danach);
  15.         if ($danach == 'C') wb_redirect_now($_SERVER['PHP_SELF'].'?seite=edit&modul='.$modul.'&aktion=new&folder='.$folder.'&danach='.$danach);
  16. }
  17.  
  18. if ($aktion == 'edit')
  19. {
  20.         $res = db_query("SELECT `user_cnid` FROM `".$WBConfig->getMySQLPrefix()."folders` WHERE `id` = '".db_escape($folder)."'");
  21.         $row = db_fetch($res);
  22.         if ($row['user_cnid'] != $benutzer['id'])
  23.                 $folder = 0;
  24.  
  25.         db_query("UPDATE `".$WBConfig->getMySQLPrefix()."popper_konten` SET `name` = '".db_escape($name)."', `folder_cnid` = '".db_escape($folder)."', `server` = '".db_escape($mserver)."', `username` = '".db_escape($musername)."', `password` = '".db_escape($mpassword)."', `personal_name` = '".db_escape($personal_name)."', `replyaddr` = '".db_escape($replyaddr)."' WHERE `id` = '".db_escape($id)."' AND `user_cnid` = '".$benutzer['id']."'");
  26.         if ($danach == 'A') wb_redirect_now($_SERVER['PHP_SELF'].'?seite=main&modul='.$modul);
  27.         if ($danach == 'B') wb_redirect_now($_SERVER['PHP_SELF'].'?seite=edit&modul='.$modul.'&aktion=new&danach='.$danach);
  28.         if ($danach == 'C') wb_redirect_now($_SERVER['PHP_SELF'].'?seite=edit&modul='.$modul.'&aktion=new&folder='.$folder.'&danach='.$danach);
  29. }
  30.  
  31. if ($aktion == 'delete')
  32. {
  33.         db_query("DELETE FROM `".$WBConfig->getMySQLPrefix()."popper_konten` WHERE `id` = '".db_escape($id)."' AND `user_cnid` = '".$benutzer['id']."'");
  34.         if (db_affected_rows() > 0)
  35.                 db_query("OPTIMIZE TABLE `".$WBConfig->getMySQLPrefix()."popper_konten`");
  36.  
  37.         db_query("DELETE FROM `".$WBConfig->getMySQLPrefix()."popper_messages` WHERE `accounts` = '".db_escape($id)."'");
  38.         if (db_affected_rows() > 0)
  39.                 db_query("OPTIMIZE TABLE `".$WBConfig->getMySQLPrefix()."popper_messages`");
  40.  
  41.         wb_redirect_now($_SERVER['PHP_SELF'].'?seite=main&modul='.$modul);
  42. }
  43.  
  44. ?>