Changeset 575 for trunk/Modules/Wiki/Wiki.php

Timestamp:

Aug 28, 2013, 11:31:10 PM (11 years ago)

Author:

chronos

Message:

• Added: Moderator can show history of wiki pages.
• Fixed: Wiki page content was saved with appended quote slashes.

File:

• trunk/Modules/Wiki/Wiki.php (modified) (6 diffs)

trunk/Modules/Wiki/Wiki.php

@@ -60 +60 @@
                         if($_GET['Action'] == 'Edit') $Output = $this->EditContent();
                         else if($_GET['Action'] == 'EditSave') $Output = $this->SaveContent();
+                        else if($_GET['Action'] == 'History') $Output = $this->ShowHistory();
                         else $Output = $this->ShowContent();
                 } else $Output = $this->ShowContent();
@@ -72 +73 @@
                 {
                         $DbRow = $DbResult->fetch_assoc();
-                        $Output = '<h3>'.$DbRow['Name'].'</h3>';
-                        $DbResult2 = $this->Database->select('WikiPageContent', '*', 'Page='.$DbRow['Id'].' ORDER BY Time DESC LIMIT 1');
-                        if($DbResult2->num_rows > 0)
-                        {
-                                $DbRow2 = $DbResult2->fetch_assoc();
-                    $Output .= $DbRow2['Content'];
-                    if($this->System->User->Licence(LICENCE_MODERATOR))
-                      $Output .= '<div><a href="?Action=Edit">Upravit</a></div>';
-                        } else $Output = ShowMessage('Wiki stránka nenalezena', MESSAGE_CRITICAL);
+                        if(array_key_exists('ver', $_GET))
+                        {
+                                $DbResult2 = $this->Database->select('WikiPageContent', '*', 'Page='.$DbRow['Id'].' AND Id='.$_GET['ver']*1);
+                          if($DbResult2->num_rows > 0)
+                          {
+                                  $DbRow2 = $DbResult2->fetch_assoc();
+                                $Output = '<h3>Archív stránky '.$DbRow['Name'].' ('.HumanDateTime($DbRow2['Time']).')</h3>';
+                                  $Output .= $DbRow2['Content'];
+                      if($this->System->User->Licence(LICENCE_MODERATOR))
+                        $Output .= '<div><a href="?Action=Edit">Upravit nejnovější</a> <a href="?Action=History">Historie</a></div>';
+                          } else $Output = ShowMessage('Wiki stránka nenalezena', MESSAGE_CRITICAL);
+                        } else 
+                        {
+                          $DbResult2 = $this->Database->select('WikiPageContent', '*', 'Page='.$DbRow['Id'].' ORDER BY Time DESC LIMIT 1');
+                          if($DbResult2->num_rows > 0)
+                          {
+                                  $DbRow2 = $DbResult2->fetch_assoc();
+                            $Output = '<h3>'.$DbRow['Name'].'</h3>';
+                                  $Output .= $DbRow2['Content'];
+                      if($this->System->User->Licence(LICENCE_MODERATOR))
+                        $Output .= '<div><a href="?Action=Edit">Upravit</a> <a href="?Action=History">Historie</a></div>';
+                          } else $Output = ShowMessage('Wiki stránka nenalezena', MESSAGE_CRITICAL);
+                        }
                 } else $Output = ShowMessage('Wiki stránka nenalezena', MESSAGE_CRITICAL);
                 return($Output);
@@ -87 +102 @@
         function EditContent()
         {
+                if($this->System->User->Licence(LICENCE_MODERATOR))
+                {
                 $PageName = $this->System->PathItems[count($this->System->PathItems) - 1];
                 $DbResult = $this->Database->select('WikiPage', 'Name, Id', 'NormalizedName="'.$PageName.'"');
@@ -98 +115 @@
                                 $DbRow2 = $DbResult2->fetch_assoc();
                     $Output .= '<form action="?Action=EditSave" method="post">'.
-                    '<textarea name="content" rows="8" cols="80" onkeydown="ResizeTextArea(this)" class="textedit">'.$DbRow2['Content'].'</textarea>'.
-                    '<input type="submit" value="Uložit"/>'.
+                    '<textarea name="content" rows="8" cols="80" onkeydown="ResizeTextArea(this)" class="textedit">'.$DbRow2['Content'].'</textarea><br/>'.
+                    '<input type="submit" name="save" value="Uložit"/> '.
+                    '<input type="button" name="cancel" value="Zrušit" onclick="location.href=\'?\'"/>'.
                     '</form>';
                         } else $Output = ShowMessage('Wiki stránka nenalezena', MESSAGE_CRITICAL);
                 } else $Output = ShowMessage('Wiki stránka nenalezena', MESSAGE_CRITICAL);
+                } else $Output = ShowMessage('Nemáte oprávnění', MESSAGE_CRITICAL);
                 return($Output);
         }
@@ -108 +127 @@
         function SaveContent()
         {
+                if($this->System->User->Licence(LICENCE_MODERATOR))
+                {
                 $PageName = $this->System->PathItems[count($this->System->PathItems) - 1];
                 $DbResult = $this->Database->select('WikiPage', 'Name, Id', 'NormalizedName="'.$PageName.'"');
@@ -113 +134 @@
                 {
                         $DbRow = $DbResult->fetch_assoc();
-                        $DbResult2 = $this->Database->insert('WikiPageContent', array('Content' => $_POST['content'],
-                                'User' => $this->System->User->Id, 'Time' => 'NOW()', 'Page' => $DbRow['Id']));
-                        $Output = ShowMessage('Wiki stránka uložena', MESSAGE_INFORMATION);
+                        if(array_key_exists('content', $_POST) and array_key_exists('save', $_POST))
+                        {
+                          $DbResult2 = $this->Database->insert('WikiPageContent', array('Content' => stripslashes($_POST['content']),
+                                'User' => $this->System->User->Id, 'Time' => 'NOW()', 'Page' => $DbRow['Id']));
+                          $Output = ShowMessage('Wiki stránka uložena', MESSAGE_INFORMATION);                     
+                        } else $Output = ShowMessage('Nezadána platná data', MESSAGE_CRITICAL);
                         $Output .= $this->ShowContent();
                 } else $Output = ShowMessage('Wiki stránka nenalezena', MESSAGE_CRITICAL);
+                } else $Output = ShowMessage('Nemáte oprávnění', MESSAGE_CRITICAL);
+                return($Output);
+        }
+        
+        function ShowHistory()
+        {               
+                if($this->System->User->Licence(LICENCE_MODERATOR))
+                {
+                  $PageName = $this->System->PathItems[count($this->System->PathItems) - 1];
+                  $DbResult = $this->Database->select('WikiPage', 'Name, Id', 'NormalizedName="'.$PageName.'"');
+                  if($DbResult->num_rows > 0)
+                  {
+                          $DbRow = $DbResult->fetch_assoc();
+                        
+                          $Output = '<h3>Historie stránky '.$DbRow['Name'].'</h3>';
+                          $DbResult2 = $this->Database->query('SELECT COUNT(*) FROM `WikiPageContent` WHERE Page='.$DbRow['Id']);
+                        $DbRow2 = $DbResult2->fetch_row();
+                        $PageList = GetPageList($DbRow2[0]);
+                        
+                        $Output .= $PageList['Output'];
+                        $Output .= '<table class="BaseTable">';
+                        
+                          $TableColumns = array(
+                                        array('Name' => 'Time', 'Title' => 'Čas'),
+                                        array('Name' => 'User', 'Title' => 'Uživatel'),
+                                        array('Name' => 'Action', 'Title' => 'Akce'),
+                          );
+                          
+                          $Order = GetOrderTableHeader($TableColumns, 'Time', 1);
+                          $Output .= $Order['Output'];
+                          
+                          $DbResult2 = $this->Database->query('SELECT *, (SELECT `Name` FROM `User` WHERE `User`.`ID`=`WikiPageContent`.`User`) AS `UserName` '.
+                                ' FROM `WikiPageContent` WHERE Page='.
+                        $DbRow['Id'].' '.$Order['SQL'].$PageList['SQLLimit']);
+                          while($PageContent = $DbResult2->fetch_assoc())
+                          {
+                                $Output .= '<tr>'.
+                                        '<td>'.HumanDateTime($PageContent['Time']).'</td>'.
+                                '<td><a href="'.$this->System->Link('/user.php?user='.$PageContent['User']).'">'.$PageContent['UserName'].'</a></td>'.                                                                                          
+                                        '<td><a href="?id='.$PageContent['Id'].'&amp;ver='.$PageContent['Id'].'">Zobrazit</a></td>';
+                                $Output .= '</tr>';
+                          }                     
+                      
+                          $Output .= '</table>'.
+                                  $PageList['Output'];
+                  } else $Output = ShowMessage('Wiki stránka nenalezena', MESSAGE_CRITICAL);
+                } else $Output = ShowMessage('Nemáte oprávnění', MESSAGE_CRITICAL);
                 return($Output);
         }