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