Changeset 48 for trunk

Timestamp:

Dec 22, 2019, 11:43:06 PM (4 years ago)

Author:

chronos

Message:

• Added: Allow to login as administrator.
• Added: Allow to hide meet items.

Location:

trunk

Files:

• Config/Config.sample.php (modified) (1 diff)
• Modules/Meet/MeetPage.php (modified) (5 diffs)
• SQL/Update.php (modified) (1 diff)
• index.php (modified) (6 diffs)

trunk/Config/Config.sample.php

@@ -14 +14 @@
 $Config['Web']['AdminEmail'] = 'robie@centrum.cz';
 $Config['Web']['Title'] = 'Tanec';
+$Config['Web']['AdminPassword'] = rand(1, 10000000);

trunk/Modules/Meet/MeetPage.php

@@ -59 +59 @@
 
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM (SELECT *, '.
-      '(SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName FROM `MeetItem`) AS T WHERE '.$Where);
+      '(SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName FROM `MeetItem`) AS T WHERE (T.Hidden=0) AND '.$Where);
     $DbRow = $DbResult->fetch_row();
     $PageList = GetPageList($DbRow[0]);
@@ -82 +82 @@
     $Output .= $Order['Output'];
     $DbResult = $this->Database->query('SELECT * FROM (SELECT *, (SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName, '.
-      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL FROM MeetItem) AS T WHERE '.
+      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL FROM MeetItem) AS T WHERE (T.Hidden=0) AND '.
       $Where.$Order['SQL'].$PageList['SQLLimit']);
     while($MeetItem = $DbResult->fetch_assoc())
@@ -149 +149 @@
       $id = $this->System->PathItems[2] * 1;
     } else return 'Položka nenalezena';
+    if ($this->System->IsAdmin())
+    {
+      if (array_key_exists('hide', $_GET)) $this->Database->update('MeetItem', 'Id='.$id, array('Hidden' => 1));
+      if (array_key_exists('unhide', $_GET)) $this->Database->update('MeetItem', 'Id='.$id, array('Hidden' => 0));
+    }
+
     $Output .= '<div class="title">Inzerát</div>';
     $Gender = array('', 'Muž', 'Žena');
@@ -172 +178 @@
         '<tr><th>Zdroj importu</th><td><a href="'.$MeetItem['SourceURL'].'">'.$MeetItem['SourceName'].'</a></td></tr>';
       $Output .= '</table>';
+      if ($this->System->IsAdmin()) {
+        if ($MeetItem['Hidden'] == '1')
+          $Output .= '<div>Skrytá položka <a href="?unhide">Zviditelnit</a></div>';
+          else $Output .= '<div>Viditelná položka <a href="?hide">Skrýt</a></div>';
+      }
     } else $Output .= 'Položka nenalezena';
     return $Output;
@@ -197 +208 @@
 
     $DbResult = $this->Database->select('MeetItem', '*, (SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName, '.
-      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL', '1 ORDER BY `Time` DESC LIMIT 30');
+      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL', '`Hidden`=0 ORDER BY `Time` DESC LIMIT 30');
     while($MeetItem = $DbResult->fetch_assoc())
     {

trunk/SQL/Update.php

@@ -52 +52 @@
 ALTER TABLE `MeetItem`
   ADD COLUMN `RemoteId` VARCHAR(255) NULL DEFAULT NULL AFTER `TimeImport`;
+
+-- rev 48
+ALTER TABLE `MeetItem`
+  ADD COLUMN `Hidden` INT NULL DEFAULT '0' AFTER `RemoteId`;

trunk/index.php

@@ -34 +34 @@
     $this->PageHeaders = array();
     $this->Bars = array();
+  }
+
+  function IsAdmin()
+  {
+    return ($_SESSION['IsAdmin'] == 1);
   }
 
@@ -70 +75 @@
     return($PathItems);
   }
-  
+
   function RegisterPage($Path, $Handler)
   {
@@ -149 +154 @@
     }
   }
-  
+
   function RunCommon()
   {
@@ -226 +231 @@
     }
     // MeetItems
-    $DbResult = $this->Database->query('SELECT `Id`,`Time` FROM `MeetItem`');
+    $DbResult = $this->Database->query('SELECT `Id`,`Time` FROM `MeetItem` WHERE (`Hidden`=0)');
     while ($DbRow = $DbResult->fetch_array())
     {
@@ -242 +247 @@
 }
 
-
-$Revision = 36; // Subversion revision
-$DatabaseRevision = 36; // SQL structure revision
-$ReleaseTime = strtotime('2019-05-05');
+class PageLogin extends Page
+{
+  function Show()
+  {
+    global $Config;
+
+    $Output = '';
+    if (array_key_exists('login', $_GET))
+    {
+      if (array_key_exists('password', $_POST))
+      {
+        if ($_POST['password'] == $Config['Web']['AdminPassword'])
+        {
+          $_SESSION['IsAdmin'] = 1;
+          $Output .= 'Úspěšně přihlášen jako správce.';
+        } else {
+          $_SESSION['IsAdmin'] = 0;
+          $Output .= 'Heslo není správné.';
+          $Output .= $this->ShowLoginForm();
+        }
+      } else {
+        $Output .= 'Chybí heslo.';
+        $Output .= $this->ShowLoginForm();
+      }
+    } else
+    if (array_key_exists('logoff', $_GET))
+    {
+      $_SESSION['IsAdmin'] = 0;
+      $Output .= 'Odhlášení úspěšné';
+      $Output .= $this->ShowLoginForm();
+    } else {
+      $Output .= $this->ShowLoginForm();
+    }
+    if ($this->System->IsAdmin()) $Output .= '<div>Jsi přihlášen jako správce. <a href="?logoff">Odhlásit</a></div>';
+    return $Output;
+  }
+
+  function ShowLoginForm()
+  {
+    return '<form method="post" action="?login">'.
+        'Heslo: <input type="password" name="password" value=""/><br/>'.
+        '<input type="submit" value="Přihlásit"/>'.
+        '</form>';
+  }
+}
+
+$Revision = 48; // Subversion revision
+$DatabaseRevision = 48; // SQL structure revision
+$ReleaseTime = strtotime('2019-12-22');
 
 $Application = new ApplicationTanec();
@@ -255 +305 @@
 $Application->RegisterPage('robots.txt', 'PageRobots');
 $Application->RegisterPage('sitemap.xml', 'PageSiteMap');
+$Application->RegisterPage('admin', 'PageLogin');
 $Application->Run();