Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1:/tmp/cvs-serv6981
Modified Files:
serendipity_functions.inc.php
Log Message:
Refactor URL storage.
Index: serendipity_functions.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/serendipity_functions.inc.php,v
retrieving revision 1.21
retrieving revision 1.22
diff -u -d -r1.21 -r1.22
--- serendipity_functions.inc.php 2 Apr 2003 21:14:40 -0000 1.21
+++ serendipity_functions.inc.php 3 Apr 2003 05:34:31 -0000 1.22
@@ -1445,6 +1445,9 @@
function serendipity_track_url($list, $url) {
global $serendipity;
+ $u = parse_url($url);
+ $url = $u['scheme'] . '://' . $u['host'];
+
serendipity_db_query(
sprintf(
"UPDATE %s%s
@@ -1483,22 +1486,26 @@
function serendipity_displayTopUrlList($list, $limit) {
global $serendipity;
+
$query = "SELECT url, SUM(count) AS total
FROM $serendipity[dbPrefix]$list
GROUP BY url
ORDER BY total DESC, url
LIMIT $limit";
+
+ $rows = serendipity_db_query($query);
- $rows = serendipity_db_query($query);
- if (is_array($rows)) {
- foreach ($rows as $row) {
- $u = parse_url($row['url']);
- $ref[$u['scheme']."://".$u['host']] += $row['total'];
- }
- foreach ($ref as $k=>$v) {
- echo "<a href='$k'>$k</a> ($v)<br>";
- }
- }
+ if (is_array($rows)) {
+ foreach ($rows as $row) {
+ printf(
+ '<a href="%s">%s</a> (%s)<br />',
+
+ $row['url'],
+ $row['url'],
+ $row['total']
+ );
+ }
+ }
}
function serendipity_set_config_var($name, $val) {
|
