Changeset 41

Timestamp:

Jan 24, 2009, 7:49:23 PM (16 years ago)

Author:

george

Message:

• Upraveno: Zjednodušení skriptu pro zobrazení bannerů a záznam odkazujících webu na bannery.

Files:

• banners.php (modified) (1 diff)
• banners/.htaccess (modified) (1 diff)
• banners/baner_468_60.php (deleted)
• banners/baner_88_31.php (deleted)
• banners/banner.php (added)
• client_files/Generate/define.php_zaloha (deleted)
• includes/databaseconection.php (modified) (1 diff)
• includes/global.php (modified) (3 diffs)
• sql (added)
• sql/updates (added)
• sql/updates/41_banner.sql (added)

banners.php

@@ -1 +1 @@
 <?php
 
-  include('includes/global.php');
+include('includes/global.php');
   
-  function HaveInArray($Array,$String)
-  { // BEGIN function HaveInArray
-    for ( $i = 0; $i < count($Array); ++$i) {
-      if ($String == $Array[$i]) {
-        return true;
-      } 
-    }
-        
-  } // END function HaveInArray
+$ID = $Database->SQLCommand("SELECT * FROM `banner` WHERE `Show`=1 AND `DateLast` > (NOW() - INTERVAL 3 MONTH)");
+  
+echo('<strong>Servery odkazující na nás:</strong> <br /><br />');
+while($Line = mysql_fetch_array($ID)) 
+{
+  echo('<a href="'.$Line['Web'].'">'.$Line['Web'].'</a> '.$Line['Description'].' <br />');      
+}
+  
+ShowFooter();      
 
-  $ID = $Database->SQLCommand("SELECT * FROM `banner` WHERE `Show` =1");
-  
-  echo '<b>Servery odkazující na nás:</b> <br><br>';
-  while($Line = mysql_fetch_array($ID)) {
-    echo '<a href="'.$Line['Web'].'">'.$Line['Web'].'</a> '.$Line['Description'].' <br>';       
-  }
-  
-  /*  echo '<table>';
-  echo '<tr><th>Adresa</th><th>Popis</th><th>Datum umístění</th>';
-  while($Line = mysql_fetch_array($ID)) {
-    echo '<tr><td><a href="'.$Line['Web'].'">'.$Line['Web'].'</a></td>
-    <td>'.$Line['Description'].'</td>
-    <td>'.$Line['Date'].'</td><tr>';    
-  }
-  echo '</table';
-*/
-  
-  ShowFooter();      
 ?>
 

banners/.htaccess

@@ -1 +1 @@
 RewriteEngine on
-RewriteRule    (baner_468_60.jpg)    /quests/banners/baner_468_60.php  
-RewriteRule    (baner_88_31.jpg)     /quests/banners/baner_88_31.php  
+RewriteRule    (baner_468_60.jpg)    banner.php?image=baner_468_60.jpg
+RewriteRule    (baner_88_31.jpg)     banner.php?image=baner_88_31.jpg

includes/databaseconection.php

@@ -1 +1 @@
 <?php
-  class Database
-  { // BEGIN class Database
-        // variables
-        var $id_connection = 0;
-  //    var $LastResult;
-
   
-        // constructor
-        function Database($addres,$user,$pass)  //default: $Database = new Database('localhost','root','');
-        { // BEGIN constructor
-         $this->id_connection = mysql_connect($addres,$user,$pass);
-     if (!$this->id_connection) 
-       die('Spojení s MySQL databází se nezdařilo.');
-        } // END constructor
+class Database
+{
+  var $id_connection = 0;
+  
+  function Database($address = 'localhost', $user = 'root', $pass = '')
+  {
+        $this->id_connection = mysql_connect($address, $user, $pass);
+    if(!$this->id_connection) 
+      die('Spojení s MySQL databází se nezdařilo.');
+  }
         
-        function SelectDatabase($NameDatabase)
-   { // BEGIN function SelectDatabase
-        $return_selection = mysql_select_db($NameDatabase,$this->id_connection);
-    if (!$return_selection)
-      die('Databázi pokus se nám nepodařilo vybrat.');
-   } // END function SelectDatabase
+  function SelectDatabase($NameDatabase)
+  {
+        $return_selection = mysql_select_db($NameDatabase, $this->id_connection);
+    if(!$return_selection)
+      die('Databázi '.$NameDatabase.' se nám nepodařilo vybrat.');
+  }
    
-   function SQLCommand($Command)
-   { // BEGIN function SQLCommand
-    $ReturnCommand = mysql_query($Command,$this->id_connection);
-    if (!$ReturnCommand) {
+  function SQLCommand($Command)
+  {
+    $ReturnCommand = mysql_query($Command, $this->id_connection);
+    if(!$ReturnCommand) 
+        {
       die('Nepodařilo se aplikovat příkaz.');
-    } else {
+    } else 
+        {
       return $ReturnCommand;
     }
-   } // END function SQLCommand
+  }
    
-   function ReadFromDatabase($SQL)    // "SELECT * FROM User"
-   { // BEGIN function ReadFromDatabase
-    $return_result = mysql_query($sql,$id_spojeni);
-    if (!$return_result) {
+  function ReadFromDatabase($SQL)
+  {
+    $return_result = mysql_query($sql, $id_spojeni);
+    if (!$return_result) 
+        {
       die('Nepodařilo se nám načíst řádky z databáze.');
-    } else {
+    } else 
+        {
       return $return_result;
     }
-   } // END function ReadFromDatabase
+  }
    
-   function Disconnect()
-   { // BEGIN function Disconnect
+  function Disconnect()
+  {
         mysql_close($this->id_connection);
-   } // END function Disconnect
-  } // END class Database
+  }
+}
 
 ?>

includes/global.php

@@ -5 +5 @@
 include('databaseconection.php');
 
-//připojení do databáze
+// připojení do databáze
 $Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
 $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
 $Database->SelectDatabase($Config['Database']['Database']);    
 
-//globální funkce
+// globální funkce
 include('global_function.php');
 
 
-echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+  echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 <HTML>
 <HEAD>
@@ -37 +37 @@
   
   ';
-
-  
-//přihlášení
-  if (array_key_exists('LoginUser',$_POST)) {
+  
+// přihlášení
+  if (array_key_exists('LoginUser',$_POST)) 
+  {
     $_SESSION['User'] = $_POST['LoginUser'];
     $_SESSION['Pass'] = $_POST['LoginPass'];
     
     $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE LOWER(user) = LOWER('".$_SESSION['User']."') AND pass = '".$_SESSION['Pass']."'"));
-    if (!$Line ) {
+    if (!$Line ) 
+        {
        echo '<script> alert("Jméno nebo heslo bylo zadáno špatně!"); </script>';
        $_SESSION['UserID'] = ''; 
        $_SESSION['User'] = '';
        $_SESSION['Pass'] = '';
-    } else {
+    } else 
+        {
       $_SESSION['UserID'] = $Line['ID']; 
       $_SESSION['User'] = $Line['user'];
@@ -57 +59 @@
   }
 //odhlášení
-  if (array_key_exists('Logout',$_GET)) {
+  if (array_key_exists('Logout',$_GET)) 
+  {
     WriteLog('Odhlášení', 3);
     $_SESSION['User'] = '';