Changeset 196 for trunk/aktuality/index.php

Timestamp:

Apr 27, 2009, 8:00:50 AM (16 years ago)

Author:

george

Message:

• Upraveno: Názvy tabulek a sloupců aktualit pozměněny na názvy se slovy začínající velkými písmeny.

File:

• trunk/aktuality/index.php (modified) (10 diffs)

trunk/aktuality/index.php

@@ -16 +16 @@
     if(array_key_exists('category', $_GET)) $Category = $_GET['category'] * 1;
     if(array_key_exists('category', $_POST)) $Category = $_POST['category'] * 1;
-    $DbResult = $this->Database->select('news_category', '*', 'id='.$Category);
+    $DbResult = $this->Database->select('NewsCategory', '*', 'Id='.$Category);
     if($DbResult->num_rows > 0) 
     {
       $Row = $DbResult->fetch_array();
-      $CategoryName = $Row['caption'];
+      $CategoryName = $Row['Caption'];
     }
 
@@ -31 +31 @@
         {
           if(array_key_exists('id', $_GET)) $Id = $_GET['id'] * 1;
-          $DbResult = $this->Database->query('SELECT `news`.*, `User`.`Name` FROM `news` LEFT JOIN `User` ON `User`.`Id`=`news`.`User` WHERE  `news`.`id`='.$Id);
+          $DbResult = $this->Database->query('SELECT `News`.*, `User`.`Name` FROM `News` LEFT JOIN `User` ON `User`.`Id`=`News`.`User` WHERE  `News`.`Id`='.$Id);
           if($DbResult->num_rows > 0)
           {
             $Row = $DbResult->fetch_array();
-            if($Row['Name'] == '') $Author = $Row['author'];
+            if($Row['Name'] == '') $Author = $Row['Author'];
               else $Author = $Row['Name'];
-            $Output .= '<div style="border: thin dotted #97ADFF;        background: #F6F7FF; margin-top: 5px; padding: 0px 5px 5px 5px;"><div style="padding-bottom: 1px; border-bottom-width: 1; border-bottom-style: solid; border-bottom-color: silver;"><strong>'.$Row['title'].' ('.HumanDate($Row['date']).', '.$Author.')</strong>';
+            $Output .= '<div style="border: thin dotted #97ADFF;        background: #F6F7FF; margin-top: 5px; padding: 0px 5px 5px 5px;"><div style="padding-bottom: 1px; border-bottom-width: 1; border-bottom-style: solid; border-bottom-color: silver;"><strong>'.$Row['Title'].' ('.HumanDate($Row['Date']).', '.$Author.')</strong>';
             if($this->System->Modules['User']->User['Id'] == $Row['User'])
             { 
-              $Output .= '&nbsp;<a href="index.php?action=del&amp;category='.$Category.'&amp;id='.$Row['id'].'">Smazat</a>';
-              $Output .= '&nbsp;<a href="index.php?action=edit&amp;category='.$Category.'&amp;id='.$Row['id'].'">Editovat</a>';
-            }
-            $Output .= '</div>'.$Row['content'].'<br />';
-            if($Row['enclosure'] != '')
+              $Output .= '&nbsp;<a href="index.php?action=del&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Smazat</a>';
+              $Output .= '&nbsp;<a href="index.php?action=edit&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Editovat</a>';
+            }
+            $Output .= '</div>'.$Row['Content'].'<br />';
+            if($Row['Enclosure'] != '')
             { 
               $Output .= '<br />Přílohy: ';
-              $Enclosures = explode(';', $Row['enclosure']);
+              $Enclosures = explode(';', $Row['Enclosure']);
               foreach($Enclosures as $Enclosure)
               {
@@ -62 +62 @@
         $Output .= '<form enctype="multipart/form-data" action="?action=add2" method="post">'.
     'Kategorie: <select name="category">';
-        $DbResult = $this->Database->select('news_category', '*');
+        $DbResult = $this->Database->select('NewsCategory', '*');
         while($DbRow = $DbResult->fetch_array()) 
         {
-          if($this->System->Modules['User']->CheckPermission('News', 'Insert', 'Group', $DbRow['id']))
-          {
-            if($DbRow['id'] == $Category) $Selected = ' selected="1"'; else $Selected = '';
-            $Output .= '<option value="'.$DbRow['id'].'"'.$Selected.'>'.$DbRow['caption'].'</option>';
+          if($this->System->Modules['User']->CheckPermission('News', 'Insert', 'Group', $DbRow['Id']))
+          {
+            if($DbRow['Id'] == $Category) $Selected = ' selected="1"'; else $Selected = '';
+            $Output .= '<option value="'.$DbRow['Id'].'"'.$Selected.'>'.$DbRow['Caption'].'</option>';
           }
         }
@@ -105 +105 @@
 
           $_POST['content'] = str_replace("\n",'<br />',$_POST['content']);
-          $this->Database->insert('news',array('category' => $Category, 'title' => $_POST['title'], 'content' => $_POST['content'], 'date' => 'NOW()', 'ip' => $RemoteAddr, 'enclosure' => $Enclosures, 'author' => $this->System->Modules['User']->User['Name'], 'User' => $this->System->Modules['User']->User['Id']));
+          $this->Database->insert('News',array('Category' => $Category, 'Title' => $_POST['title'], 'Content' => $_POST['content'], 'Date' => 'NOW()', 'IP' => $RemoteAddr, 'Enclosure' => $Enclosures, 'Author' => $this->System->Modules['User']->User['Name'], 'User' => $this->System->Modules['User']->User['Id']));
           $Output .= 'Aktualita přidána!<br />Pokud budete chtít vaši aktualitu smazat, klikněte na odkaz Smazat v seznamu všech aktualit v kategorii.<br /><br />';
           $Output .= '<a href="index.php?category='.$_POST['category'].'">Zpět na seznam aktualit</a>';
@@ -112 +112 @@
         break;
       case 'edit':
-        $DbResult = $this->Database->query('SELECT * FROM news WHERE id='.$_GET['id']);
+        $DbResult = $this->Database->query('SELECT * FROM News WHERE Id='.$_GET['id']);
         $Row = $DbResult->fetch_array();
         if($this->System->Modules['User']->User['Id'] == $Row['User'])
         {
-          $Row['content'] = str_replace('<br />', "", $Row['content']);
+          $Row['Content'] = str_replace('<br />', '', $Row['Content']);
           $Output .= '<strong>Editace aktuality v kategorii '.$CategoryName.':</strong><br />';
           $Output .= '<form action="index.php?action=update" method="post">'.
           '<input type="hidden" value="'.$_GET['id'].'" name="id">'.
-          'Nadpis:<br /><input type="text" size="54" name="title" value="'.$Row['title'].'"><br />'.
-          'Obsah:<br /><textarea name="content" rows="20" cols="40">'.$Row['content'].'</textarea><br />'.
+          'Nadpis:<br /><input type="text" size="54" name="title" value="'.$Row['Title'].'"><br />'.
+          'Obsah:<br /><textarea name="content" rows="20" cols="40">'.$Row['Content'].'</textarea><br />'.
           '<input type="hidden" name="category" value="'.$Category.'"><br />'.
           '<input type="submit" value="Uložit">'.
@@ -130 +130 @@
         $RemoteAddr = GetRemoteAddress();  
         $_POST['id'] = $_POST['id'] * 1;
-        $DbResult = $this->Database->select('news', '*', 'id='.$_POST['id']);
+        $DbResult = $this->Database->select('News', '*', 'Id='.$_POST['id']);
         if($DbResult->num_rows > 0)
         {
@@ -136 +136 @@
           if($this->System->Modules['User']->User['Id'] == $Row['User'])
           {
-            $_POST['content'] = str_replace("\n",'<br />',$_POST['content']);
-            $this->Database->update('news', 'id='.$_POST['id'], array('title' => $_POST['title'], 'content' => $_POST['content']));
+            $_POST['content'] = str_replace("\n", '<br />', $_POST['content']);
+            $this->Database->update('News', 'Id='.$_POST['id'], array('Title' => $_POST['title'], 'Content' => $_POST['content']));
             $Output .= 'Aktualita uložena!<br />';
             $Output .= '<a href="index.php?category='.$Category.'">Zpět na seznam aktualit</a>';
@@ -144 +144 @@
         break;
       case 'del':
-        $DbResult = $this->Database->query('SELECT * FROM news WHERE id='.$_GET['id']);
+        $DbResult = $this->Database->query('SELECT * FROM News WHERE Id='.$_GET['id']);
         $Row = $DbResult->fetch_array();
         if($this->System->Modules['User']->User['Id'] == $Row['User'])
         {
-          if($Row['enclosure'] != '')
+          if($Row['Enclosure'] != '')
           { 
             $Output .= '<br />Přílohy: ';
-            $Enclosures = explode(';', $Row['enclosure']);
+            $Enclosures = explode(';', $Row['Enclosure']);
                   foreach($Enclosures as $Enclosure)
                   {
@@ -157 +157 @@
                   }
           }
-          $this->Database->query('DELETE FROM news WHERE id='.$_GET['id']);
+          $this->Database->query('DELETE FROM News WHERE Id='.$_GET['id']);
           $Output .= 'Aktualita smazána!<br /><a href="index.php?category='.$Category.'">Zpět na seznam aktualit</a>';
         } else $Output .= 'Nemáte oprávnění.';
@@ -165 +165 @@
         {
           $PerPage = 20;
-          $DbResult = $this->Database->select('news', 'COUNT(*)', ' category='.$Category);
+          $DbResult = $this->Database->select('News', 'COUNT(*)', ' Category='.$Category);
           $RowTotal = $DbResult->fetch_array();
           $PageMax = $RowTotal[0];
-          if(array_key_exists('page', $_GET)) $Page = $_GET['page']; else $Page = 0; //round($PageMax/$PerPage);
+          if(array_key_exists('page', $_GET)) $Page = $_GET['page']; 
+            else $Page = 0; //round($PageMax/$PerPage);
           $Output .= '<strong>Seznam aktualit kategorie '.$CategoryName.':</strong><div style="font-size: small;">';
-          $Output .= PagesList('?category='.$Category.'&amp;page=',$Page,$PageMax,$PerPage);
+          $Output .= PagesList('?category='.$Category.'&amp;page=', $Page, $PageMax, $PerPage);
 
           //echo(GetRemoteAddress().','.$_SERVER['HTTP_X_FORWARDED_FOR'].'<br />');
-          $DbResult = $this->Database->query('SELECT `news`.*, `User`.`Name` FROM `news` LEFT JOIN `User` ON `User`.`Id`=`news`.`User` WHERE `category`='.$Category.' ORDER BY `news`.`id` DESC LIMIT '.($Page * $PerPage).','.$PerPage);
+          $DbResult = $this->Database->query('SELECT `News`.*, `User`.`Name` FROM `News` LEFT JOIN `User` ON `User`.`Id`=`News`.`User` WHERE `Category`='.$Category.' ORDER BY `News`.`Id` DESC LIMIT '.($Page * $PerPage).','.$PerPage);
           while($Row = $DbResult->fetch_array())
           {
-            if($Row['Name'] == '') $Author = $Row['author'];
+            if($Row['Name'] == '') $Author = $Row['Author'];
               else $Author = $Row['Name'];
-            $Output .= '<div style="border: thin dotted #97ADFF; background: #F6F7FF; margin-top: 5px; padding: 0px 5px 5px 5px;"><div style="padding-bottom: 1px; border-bottom-width: 1; border-bottom-style: solid; border-bottom-color: silver;"><strong><a href="?action=view&id='.$Row['id'].'">'.$Row['title'].'</a> ('.HumanDate($Row['date']).', '.$Author.')</strong>';
+            $Output .= '<div style="border: thin dotted #97ADFF; background: #F6F7FF; margin-top: 5px; padding: 0px 5px 5px 5px;"><div style="padding-bottom: 1px; border-bottom-width: 1; border-bottom-style: solid; border-bottom-color: silver;"><strong><a href="?action=view&id='.$Row['Id'].'">'.$Row['Title'].'</a> ('.HumanDate($Row['Date']).', '.$Author.')</strong>';
             if($this->System->Modules['User']->User['Id'] == $Row['User'])
             {
-              $Output .= '&nbsp;<a href="index.php?action=del&amp;category='.$Category.'&amp;id='.$Row['id'].'">Smazat</a>';
-              $Output .= '&nbsp;<a href="index.php?action=edit&amp;category='.$Category.'&amp;id='.$Row['id'].'">Editovat</a>';
-            }
-            $Output .= '</div>'.$Row['content'].'<br />';
-            if($Row['enclosure'] != '')
+              $Output .= '&nbsp;<a href="index.php?action=del&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Smazat</a>';
+              $Output .= '&nbsp;<a href="index.php?action=edit&amp;category='.$Category.'&amp;id='.$Row['Id'].'">Editovat</a>';
+            }
+            $Output .= '</div>'.$Row['Content'].'<br />';
+            if($Row['Enclosure'] != '')
             {
               $Output .= '<br />Přílohy: ';
-              $Enclosures = explode(';', $Row['enclosure']);
+              $Enclosures = explode(';', $Row['Enclosure']);
                     foreach($Enclosures as $Enclosure)
               {