Changeset 42

Timestamp:

Jan 29, 2009, 12:18:39 PM (15 years ago)

Author:

george

Message:

• Opraveno: Sledování odkazovaných adres na bannery.

Files:

• SqlTranslate.zip (modified) ( previous)
• banners/banner.php (modified) (1 diff)
• banners/conf.txt (deleted)
• branches/2/user.php (modified) (1 diff)
• readme.txt (added)

banners/banner.php

@@ -8 +8 @@
 $Database->SelectDatabase($Config['Database']['Database']);   
 
-header('Content-Type: image/png');
+//header('Content-Type: image/png');
 $Referer = addslashes($_SERVER['HTTP_REFERER']);
-$Database->SQLCommand('REPLACE INTO `banner` (`Web`, `DateLast`) VALUES ("'.$Referer.'",NOW() )');
+$DbResult = mysql_query('SELECT * FROM `banner` WHERE `Web` = "'.$Referer.'"', $Database->id_connection);
+if(mysql_num_rows($DbResult) > 0)
+  $Database->SQLCommand('UPDATE `banner` SET `DateLast` = NOW() WHERE `Web` = "'.$Referer.'"');
+  else mysql_query('INSERT INTO `banner` (`Web`, `DateFirst`, `DateLast`) VALUES ("'.$Referer.'", NOW(), NOW( ))', $Database->id_connection);
 $Image = imagecreatefromjpeg(addslashes($_GET['image']));
 imagepng($Image);

branches/2/user.php

@@ -19 +19 @@
   var $User = array();
   var $DefaultRole = 2;
-  var $AnonymousUserId = 1;
+  var $AnonymousUserId = 315;
 
   function Check()