Changeset 114

Timestamp:

03/17/08 17:25:56 (8 months ago)

Author:

root

Message:

1.4.9 release

Location:

trunk

Files:

• lib/action.php (modified) (1 diff)
• wassup.php (modified) (2 diffs)

trunk/lib/action.php

@@ -70 +70 @@
                 $ch_search = $wpdb->get_results("SELECT count(search) as top_search, search, referrer FROM $table_name WHERE search!='' AND spam=0 AND timestamp BETWEEN $from_date AND $to_date GROUP BY search ORDER BY top_search DESC LIMIT 10");
                 //#get top 10 requests...
-                $ch_urlreq = $wpdb->get_results("SELECT count(urlrequested) as top_urlrequested, urlrequested FROM $table_name WHERE urlrequested!='' AND spam=0 AND timestamp BETWEEN $from_date AND $to_date GROUP BY urlrequested ORDER BY top_urlrequested DESC LIMIT 10");
+                $ch_urlreq = $wpdb->get_results("SELECT count(urlrequested) as top_urlrequested, urlrequested FROM $table_name WHERE urlrequested!='' AND spam=0 AND timestamp BETWEEN $from_date AND $to_date GROUP BY REPLACE(urlrequested, '/', '') ORDER BY top_urlrequested DESC LIMIT 10");
                 //#get top 50 referrers...will be narrowed down to 10 
                 //#  with exclusion of wpurl referrals...

trunk/wassup.php

@@ -1127 +1127 @@
         */
 
-        if (isset($_SERVER['REQUEST_URI']) && !ereg("^/$", $_SERVER['REQUEST_URI'])) { 
-                $urlRequested = eregi_replace("/$", "", clean_url($_SERVER['REQUEST_URI']));
-        } else {
-                $urlRequested = clean_url($_SERVER['REQUEST_URI']);
-        }
+        $urlRequested = clean_url($_SERVER['REQUEST_URI']);
         $referrer = (isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '');
         $userAgent = (isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '');
@@ -1903 +1899 @@
                 print "<ul class='$ulclass'>";
                 foreach ($query_det as $sref) {
-                        print "<li>- <a href='".attribute_escape($sref->referrer)."' target='_BLANK'>".stringShortener($sref->search, $chars)."</a></li>";
+                        print "<li>- <a href='".attribute_escape($sref->referrer)."' target='_BLANK'>".stringShortener(attribute_escape($sref->search), $chars)."</a></li>";
                 }
                 print "</ul>";