Changeset 297 for quests

Timestamp:

Feb 8, 2008, 11:08:10 PM (17 years ago)

Author:

maron

Message:

Zobrazení serverů odkazující na nás, filtr

Location:

quests

Files:

• banners.php (added)
• banners/baner_468_60.php (modified) (2 diffs)
• banners/baner_88_31.php (modified) (2 diffs)
• includes/global.php (modified) (1 diff)
• structure/banner.sql (modified) (1 diff)

quests/banners/baner_468_60.php

@@ -4 +4 @@
   include('../includes/databaseconection.php');
 
-
   $Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
   $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
   $Database->SelectDatabase($Config['Database']['Database']);    
 
+  function HaveInArray($Array,$String)
+  { // BEGIN function HaveInArray
+    for ( $i = 0; $i < count($Array); ++$i) {
+      if ($String == $Array[$i]) {
+        return true;
+      } 
+    }   
+  } // END function HaveInArray
+  
+  function GetIP($Web)
+  { // BEGIN function GetIP
+    $result_string = substr($Web,0,strpos($Web,'/'));   
+    $Web = substr($Web,strlen($result_string)+1,strlen($Web)-strlen($result_string));  
+    $result_string1 = substr($Web,0,strpos($Web,'/'));   
+    $Web = substr($Web,strlen($result_string1)+1,strlen($Web)-strlen($result_string1));  
+    $result_string2 = substr($Web,0,strpos($Web,'/'));   
+    $Web = substr($Web,strlen($result_string2)+1,strlen($Web)-strlen($result_string2));  
+    return $result_string2;     
+  } // END function GetIP
+  
+  function GetArrayWebs()
+  { // BEGIN function GetArrayWebs
+    global $Database;
+    $ID = $Database->SQLCommand("SELECT * FROM `banner`");
+    $i = 0;
+    while($Line = mysql_fetch_array($ID)) {
+      $result[$i] = GetIP($Line['Web']);
+      ++$i;
+        }
+        return $result;
+  } // END function GetArrayWebs
+
   $img = imagecreatefromjpeg('baner_468_60.jpg');
   $address = @$_SERVER["HTTP_REFERER"];
+  $ArrayWebIP = GetArrayWebs();
+
+    if (HaveInArray($ArrayWebIP,GetIP($address)) == false) {
+      $CanWrite = true;
+    } else {
+      $CanWrite = false;
+    }
 
   $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM banner WHERE Web = '$address'"));
-  if (!$Line) {
+  if ((!$Line) and $CanWrite) {
     $Database->SQLCommand("INSERT INTO `banner` ( `Date` , `Web` ) VALUES ( NOW() , '$address');");
   }
@@ -21 +59 @@
  // imagestring($img, 10, 10, 30, 'Pøispupujete z: '.$address, $Color3);
 
+//  Header('Content-Disposition: attachment; filename="img_468_60.jpg"');
   header('Content-Type: image/png');
-//  Header('Content-Disposition: attachment; filename="img_468_60.jpg"');
   imagepng($img);
 

quests/banners/baner_88_31.php

@@ -4 +4 @@
   include('../includes/databaseconection.php');
 
-
   $Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
   $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
   $Database->SelectDatabase($Config['Database']['Database']);    
 
+  function HaveInArray($Array,$String)
+  { // BEGIN function HaveInArray
+    for ( $i = 0; $i < count($Array); ++$i) {
+      if ($String == $Array[$i]) {
+        return true;
+      } 
+    }   
+  } // END function HaveInArray
+  
+  function GetIP($Web)
+  { // BEGIN function GetIP
+    $result_string = substr($Web,0,strpos($Web,'/'));   
+    $Web = substr($Web,strlen($result_string)+1,strlen($Web)-strlen($result_string));  
+    $result_string1 = substr($Web,0,strpos($Web,'/'));   
+    $Web = substr($Web,strlen($result_string1)+1,strlen($Web)-strlen($result_string1));  
+    $result_string2 = substr($Web,0,strpos($Web,'/'));   
+    $Web = substr($Web,strlen($result_string2)+1,strlen($Web)-strlen($result_string2));  
+    return $result_string2;     
+  } // END function GetIP
+  
+  function GetArrayWebs()
+  { // BEGIN function GetArrayWebs
+    global $Database;
+    $ID = $Database->SQLCommand("SELECT * FROM `banner`");
+    $i = 0;
+    while($Line = mysql_fetch_array($ID)) {
+      $result[$i] = GetIP($Line['Web']);
+      ++$i;
+        }
+        return $result;
+  } // END function GetArrayWebs
+
   $img = imagecreatefromjpeg('baner_88_31.jpg');
   $address = @$_SERVER["HTTP_REFERER"];
+  $ArrayWebIP = GetArrayWebs();
+
+    if (HaveInArray($ArrayWebIP,GetIP($address)) == false) {
+      $CanWrite = true;
+    } else {
+      $CanWrite = false;
+    }
 
   $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM banner WHERE Web = '$address'"));
-  if (!$Line) {
+  if ((!$Line) and $CanWrite) {
     $Database->SQLCommand("INSERT INTO `banner` ( `Date` , `Web` ) VALUES ( NOW() , '$address');");
   }
@@ -21 +59 @@
  // imagestring($img, 10, 10, 30, 'Pøispupujete z: '.$address, $Color3);
 
+//  Header('Content-Disposition: attachment; filename="img_468_60.jpg"');
   header('Content-Type: image/png');
-//  Header('Content-Disposition: attachment; filename="img_468_60.jpg"');
   imagepng($img);
 

quests/includes/global.php

@@ -72 +72 @@
       <a Title="Hlavní stránka" href="index.php">Domù</a><br />
       <a Title="Diskuze na téma pøeklárání" href="http://wow.zdechov.net/forum/viewforum.php?f=22">Forum projektu</a><br />
-      <a Title="Domácí server" href="http://wow.zdechov.net/">Web serveru</a><br />
+      <a Title="Weby odkazující na tento projekt bennerem" href="banners.php">Odkazuje na nás</a><br />
       <a Title="Slovník wow výrazù" onclick="javascript:window.open(\'dictionary.php\',\'Slovník\',\'width=400,height=412\'); return false;" href="dictionary.php">Slovníèek</a><br />
       <a Title="Statistika pøekládání" href="statistic.php">Statistika</a><br />

quests/structure/banner.sql

@@ +1 @@
+- phpMyAdmin SQL Dump
+-- version 2.9.1.1
+-- http://www.phpmyadmin.net
+-- 
+-- Host: localhost
+-- Generation Time: Feb 08, 2008 at 11:09 PM
+-- Server version: 5.0.27
+-- PHP Version: 5.2.0
+-- 
+-- Database: `quests`
+-- 
 
+-- --------------------------------------------------------
 
+-- 
+-- Table structure for table `banner`
+-- 
 
 CREATE TABLE `banner` (
-`ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-`Date` DATETIME NOT NULL ,
-`Web` TEXT NOT NULL
-) ENGINE = MYISAM ;
+  `ID` int(11) NOT NULL auto_increment,
+  `Date` datetime NOT NULL,
+  `Web` text NOT NULL,
+  `Show` int(11) NOT NULL default '1',
+  `Description` text NOT NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `Show` (`Show`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;
+
+/*
+ALTER TABLE `banner` ADD `Show` INT NOT NULL DEFAULT '1',
+ADD `Description` TEXT NOT NULL ;
+
+ALTER TABLE `banner` ADD INDEX ( `Show` ) ;
+*/