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

Timestamp:

Feb 22, 2015, 11:20:50 PM (9 years ago)

Author:

chronos

Message:

• Modified: Tabs converted to spaces.
• Modified: Remove spaces from end of lines.
• Added: Code format script.

File:

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

trunk/Modules/Referrer/Referrer.php

@@ -3 +3 @@
 class ModuleReferrer extends AppModule
 {
-        var $Excludes;
+  var $Excludes;
 
   function __construct($System)
@@ -20 +20 @@
   function Start()
   {
-        $this->Log();
-        $this->System->RegisterPage('referrer', 'PageReferrer');
-        $this->System->RegisterMenuItem(array(
-        'Title' => T('Promotion'),
-        'Hint' => 'Informace k propagaci tohoto projektu',
-        'Link' => $this->System->Link('/referrer/'),
-        'Permission' => LICENCE_ANONYMOUS,
-        'Icon' => '',
+    $this->Log();
+    $this->System->RegisterPage('referrer', 'PageReferrer');
+    $this->System->RegisterMenuItem(array(
+      'Title' => T('Promotion'),
+      'Hint' => 'Informace k propagaci tohoto projektu',
+      'Link' => $this->System->Link('/referrer/'),
+      'Permission' => LICENCE_ANONYMOUS,
+      'Icon' => '',
     ));
   }
@@ -40 +40 @@
       if(!in_array($HostName, $this->Excludes))
       {
-        $IP = GetRemoteAddress();
+        $IP = GetRemoteAddress();
 
         // Check if client IP is not blaclisted as spam source. If yes then add new referrer as invisible
@@ -65 +65 @@
         {
           $this->System->Database->query('INSERT INTO `Referrer` (`Web`, `DateFirst`, `DateLast`, `LastURL`, `Hits`, `LastIP`, `Visible`, `Description`) '.
-                  'VALUES ("'.$HostName.'", NOW(), NOW( ), "'.addslashes($Referrer).'", 1, "'.$IP.'", '.$Visible.', "'.$Description.'")');
+          'VALUES ("'.$HostName.'", NOW(), NOW( ), "'.addslashes($Referrer).'", 1, "'.$IP.'", '.$Visible.', "'.$Description.'")');
         }
       }
@@ -93 +93 @@
     $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(!$this->System->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 '.
-                        '`Referrer` AS `T1` WHERE `T1`.`Parent` = `T2`.`Id`), 0)) AS `TotalHits`, '.
-                        'GREATEST(`DateLast`, COALESCE((SELECT MAX(`DateLast`) FROM '.
-                        '`Referrer` AS `T1` WHERE `T1`.`Parent` = `T2`.`Id`), 0)) AS `MaxDateLast` FROM '.
-                        '`Referrer` AS `T2` '.$Where.') AS `T3` '.
-                        '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(
-                        array('Name' => 'Web', 'Title' => T('Address')),
-                        array('Name' => 'MaxDateLast', 'Title' => T('Last visit')),
-                        array('Name' => 'TotalHits', 'Title' => T('Hits')),
-        );
-        if($this->System->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'));
+    $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(!$this->System->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 '.
+        '`Referrer` AS `T1` WHERE `T1`.`Parent` = `T2`.`Id`), 0)) AS `TotalHits`, '.
+        'GREATEST(`DateLast`, COALESCE((SELECT MAX(`DateLast`) FROM '.
+        '`Referrer` AS `T1` WHERE `T1`.`Parent` = `T2`.`Id`), 0)) AS `MaxDateLast` FROM '.
+        '`Referrer` AS `T2` '.$Where.') AS `T3` '.
+        '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(
+        array('Name' => 'Web', 'Title' => T('Address')),
+        array('Name' => 'MaxDateLast', 'Title' => T('Last visit')),
+        array('Name' => 'TotalHits', 'Title' => T('Hits')),
+    );
+    if($this->System->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($this->System->User->Licence(LICENCE_ADMIN))
-                {
-                        $Output .=
-                        '<td>'.$YesNo[$Line['Visible']].'</td>'.
-                        '<td>'.$Line['ParentName'].'</td>'.
-                        '<td>'.$Line['Description'].'</td>'.
+      $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($this->System->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> '.
+        '<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 .= '</table>';
-        $Output .= $PageList['Output'];
-        return($Output);
+      }
+      $Output .= '</tr>';
+    }
+    $Output .= '</table>';
+    $Output .= $PageList['Output'];
+    return($Output);
   }
 
@@ -203 +203 @@
   {
     if($this->System->User->Licence(LICENCE_ADMIN))
-          {
-                if(array_key_exists('id', $_GET))
-                {
+    {
+      if(array_key_exists('id', $_GET))
+      {
         $DbResult = $this->Database->select('Referrer', '*', 'Id='.$_GET['id']);
-              if($DbResult->num_rows > 0)
-              {
-                      $Item = $DbResult->fetch_assoc();
-                      if($Item['Visible'] == 1) $Visible = ' checked ';
-                      else $Visible = '';
-                $Output = '<form action="?action=editsave&amp;id='.$_GET['id'].'" method="post"><table>'.
-                  '<tr><td>'.T('Web').'</td><td>'.$Item['Web'].'</td></tr>'.
-                        '<tr><td>'.T('Visible').'</td><td><input type="checkbox" name="Visible" '.$Visible.'/></td></tr>'.
-                        '<tr><td>'.T('Description').'</td><td><input type="text" name="Description" value="'.$Item['Description'].'"/></td></tr>'.
-                  '<tr><td>'.T('Parent item').'</td><td>'.$this->SelectParentItem($Item['Parent'], $Item['Id']).'</td></tr>'.
+        if($DbResult->num_rows > 0)
+        {
+          $Item = $DbResult->fetch_assoc();
+          if($Item['Visible'] == 1) $Visible = ' checked ';
+            else $Visible = '';
+          $Output = '<form action="?action=editsave&amp;id='.$_GET['id'].'" method="post"><table>'.
+            '<tr><td>'.T('Web').'</td><td>'.$Item['Web'].'</td></tr>'.
+            '<tr><td>'.T('Visible').'</td><td><input type="checkbox" name="Visible" '.$Visible.'/></td></tr>'.
+            '<tr><td>'.T('Description').'</td><td><input type="text" name="Description" value="'.$Item['Description'].'"/></td></tr>'.
+            '<tr><td>'.T('Parent item').'</td><td>'.$this->SelectParentItem($Item['Parent'], $Item['Id']).'</td></tr>'.
             '<tr><td>'.T('Last IP address').'</td><td><input type="text" name="LastIP" value="'.$Item['LastIP'].'"/></td></tr>'.
-                  '<tr><td colspan="2"><input type="submit" value="Uložit"/></td></tr></table></form>';
-              } else $Output = ShowMessage(T('Item not found'), MESSAGE_CRITICAL);
-            } else $Output = ShowMessage(T('Item not specified'), MESSAGE_CRITICAL);
-          } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
-          return($Output);
+            '<tr><td colspan="2"><input type="submit" value="Uložit"/></td></tr></table></form>';
+        } else $Output = ShowMessage(T('Item not found'), MESSAGE_CRITICAL);
+      } else $Output = ShowMessage(T('Item not specified'), MESSAGE_CRITICAL);
+    } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
+    return($Output);
   }
 
   function EditSave()
   {
-          if($this->System->User->Licence(LICENCE_ADMIN))
-          {
-                  if($_POST['Parent'] == '') $_POST['Parent'] = null;
-                  $_POST['Visible'] = array_key_exists('Visible', $_POST);
-            $DbResult = $this->Database->update('Referrer', 'Id='.$_GET['id'], array(
-                  'Visible' => $_POST['Visible'], 'LastIP' => $_POST['LastIP'],
-                  'Parent' => $_POST['Parent'], 'Description' => $_POST['Description']));
-            $_SERVER['QUERY_STRING'] = '';
-            $Output = ShowMessage(T('Settings saved'));
+    if($this->System->User->Licence(LICENCE_ADMIN))
+    {
+      if($_POST['Parent'] == '') $_POST['Parent'] = null;
+      $_POST['Visible'] = array_key_exists('Visible', $_POST);
+      $DbResult = $this->Database->update('Referrer', 'Id='.$_GET['id'], array(
+        'Visible' => $_POST['Visible'], 'LastIP' => $_POST['LastIP'],
+        'Parent' => $_POST['Parent'], 'Description' => $_POST['Description']));
+      $_SERVER['QUERY_STRING'] = '';
+      $Output = ShowMessage(T('Settings saved'));
       $Output .= $this->ShowList();
-          } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
-          return($Output);
+    } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
+    return($Output);
   }
 
   function Show()
   {
-        $this->Title = T('Promotion');
+    $this->Title = T('Promotion');
     if(array_key_exists('action', $_GET))
     {