[php-blog-cvs] serendipity db.sql,1.4,1.5 serendipity_functions.inc.php,1.11,1.12

[<ste...@us...>]

Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1:/tmp/cvs-serv4645

Modified Files:
	db.sql serendipity_functions.inc.php 
Log Message:
add weblog id to comments
some assorted cleanups


Index: db.sql
===================================================================
RCS file: /cvsroot/php-blog/serendipity/db.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- db.sql	31 Mar 2003 21:49:26 -0000	1.4
+++ db.sql	31 Mar 2003 22:17:11 -0000	1.5
@@ -28,6 +28,7 @@
 create table {PREFIX}comments (
   id {AUTOINCREMENT},
   entry_id int(10) {UNSIGNED} not null default '0',
+  weblogid int(11) not null,
   timestamp int(10) {UNSIGNED} default null,
   title varchar(150) default null,
   author varchar(80) default null,

Index: serendipity_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/serendipity_functions.inc.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- serendipity_functions.inc.php	31 Mar 2003 22:12:26 -0000	1.11
+++ serendipity_functions.inc.php	31 Mar 2003 22:17:11 -0000	1.12
@@ -215,7 +215,7 @@
 
 	if ($full === true) $body = ", body, extended";
     $querystring = "SELECT * FROM ".$serendipity["dbPrefix"]."entries e, $serendipity[dbPrefix]authors a
-                    WHERE  a.authorid = e.authorid AND $key LIKE $val and e.weblogid='$serendipity[weblogId] LIMIT 1";
+                    WHERE  a.authorid = e.authorid AND $key LIKE $val and e.weblogid='$serendipity[weblogId]' LIMIT 1";
 
 	return serendipity_db_query($querystring, true);
 }