Changeset 900 for trunk/Modules/Referrer/Referrer.php

Timestamp:

Apr 10, 2024, 11:49:39 PM (5 weeks ago)

Author:

chronos

Message:

• Fixed: More form input fields validation.
• Modified: Code cleanup.

File:

• trunk/Modules/Referrer/Referrer.php (modified) (3 diffs)

trunk/Modules/Referrer/Referrer.php

@@ -93 +93 @@
     $Output .= $BannerSmall.' &nbsp;&nbsp;<textarea rows="2" cols="30">'.htmlspecialchars($BannerSmall).'</textarea><br />';
 
-    if ($User->Licence(LICENCE_ADMIN)) {
-
-    $MonthAge = 3;
-    $YesNo = array('Ne', 'Ano');
-    $Output .= '<br/><strong>'.T('Servers referring to us').':</strong> <br />
-    <div style="font-size: 10px;">Seznam je automaticky aktualizován a zobrazeny jsou servery, ze kterých přišli uživatelé během posledních třech měsíců řazený sestupně dle nejnovějších.</div><br />';
-
-    if (!$User->Licence(LICENCE_ADMIN)) $Where = ' WHERE (`Visible`=1) AND (`Parent` IS NULL)';
-    else $Where = '';
-    $Query = 'SELECT *, (SELECT Web FROM `Referrer` AS T4 WHERE T4.Id = T3.Parent) AS ParentName '.
+    if ($User->Licence(LICENCE_ADMIN)) 
+    {
+      $MonthAge = 3;
+      $YesNo = array('Ne', 'Ano');
+      $Output .= '<br/><strong>'.T('Servers referring to us').':</strong> <br />'.
+        '<div style="font-size: 10px;">Seznam je automaticky aktualizován a zobrazeny jsou servery, ze kterých přišli uživatelé během posledních třech měsíců řazený sestupně dle nejnovějších.</div><br />';
+
+      if (!$User->Licence(LICENCE_ADMIN)) $Where = ' WHERE (`Visible`=1) AND (`Parent` IS NULL)';
+        else $Where = '';
+      $Query = 'SELECT *, (SELECT Web FROM `Referrer` AS T4 WHERE T4.Id = T3.Parent) AS ParentName '.
         'FROM (SELECT *, '.
         '(`Hits` + COALESCE((SELECT SUM(`Hits`) FROM '.
@@ -111 +111 @@
         'WHERE (`T3`.`MaxDateLast` > (NOW() - INTERVAL '.$MonthAge.' MONTH))';
 
-
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS T');
-    $DbRow = $DbResult->fetch_row();
-    $PageList = GetPageList($DbRow[0]);
-
-    $Output .= $PageList['Output'].
-    '<table class="BaseTable">';
-
-    $TableColumns = array(
+      $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS T');
+      $DbRow = $DbResult->fetch_row();
+      $PageList = GetPageList($DbRow[0]);
+
+      $Output .= $PageList['Output'].
+        '<table class="BaseTable">';
+
+      $TableColumns = array(
         array('Name' => 'Web', 'Title' => T('Address')),
         array('Name' => 'MaxDateLast', 'Title' => T('Last visit')),
         array('Name' => 'TotalHits', 'Title' => T('Hits')),
-    );
-    if ($User->Licence(LICENCE_ADMIN))
-    {
-      $TableColumns[] = array('Name' => 'Visible', 'Title' => T('Visible'));
-      $TableColumns[] = array('Name' => 'Parent', 'Title' => T('Parent'));
-      $TableColumns[] = array('Name' => 'Description', 'Title' => T('Comment'));
-      $TableColumns[] = array('Name' => 'LastIP', 'Title' => T('Last IP address'));
-      $TableColumns[] = array('Name' => 'Action', 'Title' => T('Actions'));
-    }
-    $Order = GetOrderTableHeader($TableColumns, 'MaxDateLast', 1);
-    $Output .= $Order['Output'];
-
-    $Query .= $Order['SQL'].$PageList['SQLLimit'];
-
-    $DbResult = $this->Database->query($Query);
-    while ($Line = $DbResult->fetch_assoc())
-    {
-      $Output .= '<tr><td><a href="'.$Line['LastURL'].'">'.$Line['Web'].'</a></td>'.
+      );
+      if ($User->Licence(LICENCE_ADMIN))
+      {
+        $TableColumns[] = array('Name' => 'Visible', 'Title' => T('Visible'));
+        $TableColumns[] = array('Name' => 'Parent', 'Title' => T('Parent'));
+        $TableColumns[] = array('Name' => 'Description', 'Title' => T('Comment'));
+        $TableColumns[] = array('Name' => 'LastIP', 'Title' => T('Last IP address'));
+        $TableColumns[] = array('Name' => 'Action', 'Title' => T('Actions'));
+      }
+      $Order = GetOrderTableHeader($TableColumns, 'MaxDateLast', 1);
+      $Output .= $Order['Output'];
+
+      $Query .= $Order['SQL'].$PageList['SQLLimit'];
+
+      $DbResult = $this->Database->query($Query);
+      while ($Line = $DbResult->fetch_assoc())
+      {
+        $Output .= '<tr><td><a href="'.$Line['LastURL'].'">'.$Line['Web'].'</a></td>'.
           '<td>'.HumanDate($Line['MaxDateLast']).'</td>'.
           '<td>'.$Line['TotalHits'].'</td>';
-      if ($User->Licence(LICENCE_ADMIN))
-      {
-        $Output .=
-        '<td>'.$YesNo[$Line['Visible']].'</td>'.
-        '<td>'.$Line['ParentName'].'</td>'.
-        '<td>'.$Line['Description'].'</td>'.
-        '<td>'.$Line['LastIP'].'</td>'.
-        '<td><a href="?action=edit&amp;id='.$Line['Id'].'">'.T('Modify').'</a> '.
-        '<a href="?action=spam&amp;id='.$Line['Id'].'">'.T('Spam').'</a></td>';
+        if ($User->Licence(LICENCE_ADMIN))
+        {
+          $Output .=
+          '<td>'.$YesNo[$Line['Visible']].'</td>'.
+          '<td>'.$Line['ParentName'].'</td>'.
+          '<td>'.$Line['Description'].'</td>'.
+          '<td>'.$Line['LastIP'].'</td>'.
+          '<td><a href="?action=edit&amp;id='.$Line['Id'].'">'.T('Modify').'</a> '.
+          '<a href="?action=spam&amp;id='.$Line['Id'].'">'.T('Spam').'</a></td>';
+        }
+        $Output .= '</tr>';
       }
-      $Output .= '</tr>';
-    }
-    $Output .= '</table>';
-    $Output .= $PageList['Output'];
-
+      $Output .= '</table>';
+      $Output .= $PageList['Output'];
     }
     return $Output;
@@ -263 +261 @@
   }
 }
-