Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32124
Modified Files:
serendipity_functions.inc.php
Log Message:
Make code for exit/referer tracking more sane.
Index: serendipity_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/serendipity_functions.inc.php,v
retrieving revision 1.228
retrieving revision 1.229
diff -u -d -r1.228 -r1.229
--- serendipity_functions.inc.php 18 Mar 2004 20:50:52 -0000 1.228
+++ serendipity_functions.inc.php 19 Mar 2004 11:05:13 -0000 1.229
@@ -2196,7 +2196,7 @@
serendipity_db_query(
@sprintf(
- "UPDATE %s
+ "UPDATE %s%s
SET count = count + 1
WHERE scheme = '%s'
AND host = '%s'
@@ -2204,9 +2204,10 @@
AND path = '%s'
AND query = '%s'
AND day = CURRENT_DATE
- %s",
+ %s",
- $serendipity['dbPrefix'] . $list,
+ $serendipity['dbPrefix'],
+ $list,
$url_parts['scheme'],
$url_parts['host'],
$url_parts['port'],
@@ -2219,17 +2220,18 @@
if (serendipity_db_affected_rows() == 0) {
serendipity_db_query(
sprintf(
- "INSERT INTO %s
- (day, count, scheme, host, port, path, query%s)
- VALUES ( CURRENT_DATE, 1, '%s', '%s', '%s', '%s', '%s'%s)",
- $serendipity['dbPrefix'] . $list,
- ($entry_id != 0) ? ', entry_id' : '',
+ "INSERT INTO %s%s
+ (entry_id, day, count, scheme, host, port, path, query)
+ VALUES (%d, CURRENT_DATE, 1, '%s', '%s', '%s', '%s', '%s')",
+
+ $serendipity['dbPrefix'],
+ $list,
+ $entry_id,
$url_parts['scheme'],
$url_parts['host'],
$url_parts['port'],
$url_parts['path'],
- $url_parts['query'],
- ($entry_id != 0) ? ", '$entry_id'" : ''
+ $url_parts['query']
)
);
}
|