[php-blog-cvs] jBlog db.sql,1.10,1.11 jBlog_functions.inc.php,1.26,1.27

[<gsc...@us...>]

Update of /cvsroot/php-blog/jBlog
In directory sc8-pr-cvs1:/tmp/cvs-serv11701

Modified Files:
	db.sql jBlog_functions.inc.php 
Log Message:
lazy sql != good sql, even with garbage collection



Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/jBlog/db.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- db.sql	6 Mar 2003 20:08:09 -0000	1.10
+++ db.sql	6 Mar 2003 20:16:30 -0000	1.11
@@ -91,7 +91,8 @@
 CREATE TABLE {PREFIX}suppress (
   url varchar(128) default NULL,
   ip varchar(15) default NULL,
-  last timestamp(14) NOT NULL
+  last timestamp(14) NOT NULL,
+  unique key (url, ip)
 ) TYPE=MyISAM;
 
 

Index: jBlog_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/jBlog/jBlog_functions.inc.php,v
retrieving revision 1.26
retrieving revision 1.27
diff -u -d -r1.26 -r1.27
--- jBlog_functions.inc.php	6 Mar 2003 20:08:08 -0000	1.26
+++ jBlog_functions.inc.php	6 Mar 2003 20:16:31 -0000	1.27
@@ -1089,7 +1089,7 @@
                   WHERE ip = '$_SERVER[REMOTE_ADDR]'
                   AND url = '$_SERVER[HTTP_REFERER]'
                   AND last > now() - 900";
-    $suppressu = "INSERT INTO $jBlog[dbPrefix]suppress
+    $suppressu = "REPLACE INTO $jBlog[dbPrefix]suppress
                   (url, ip, last) 
                   VALUES ('$_SERVER[HTTP_REFERER]', '$_SERVER[REMOTE_ADDR]', now())";
     $update = "UPDATE $jBlog[dbPrefix]referrers