Login form for guests in surfbar added, some trigger_error() added, misc rewrites

[mailer.git] / inc / libs / surfbar_functions.php

diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php
index 08b2bd164518dbaae9c65e8f268e7ba0383e97cf..10a2ba6583693fc99c4f03c54ff0a6aac06abdeb 100644 (file)
--- a/inc/libs/surfbar_functions.php
+++ b/inc/libs/surfbar_functions.php
@@ -879,6 +879,12 @@ function SURFBAR_GET_TOTAL_URLS ($status = 'ACTIVE', $excludeUserId = 0) {
        // Determine depleted user account
        $UIDs = SURFBAR_DETERMINE_DEPLETED_USERIDS();
 
        // Determine depleted user account
        $UIDs = SURFBAR_DETERMINE_DEPLETED_USERIDS();
 

+       // If we dont get any user ids back, there are no URLs
+       if (count($UIDs['uid']) == 0) {
+               // No user ids found, no URLs!
+               return 0;
+       } // END - if
+

        // Is the exlude userid set?
        if ($excludeUserId > 0) {
                // Then add it
        // Is the exlude userid set?
        if ($excludeUserId > 0) {
                // Then add it


@@ -886,10 +892,10 @@ function SURFBAR_GET_TOTAL_URLS ($status = 'ACTIVE', $excludeUserId = 0) {
        } // END - if
 
        // Get amount from database
        } // END - if
 
        // Get amount from database

-       $result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt
+       $result = SQL_QUERY_ESC("SELECT COUNT(`id`) AS cnt

 FROM `{!_MYSQL_PREFIX!}_surfbar_urls`
 FROM `{!_MYSQL_PREFIX!}_surfbar_urls`

-WHERE userid NOT IN (".implode(',', $UIDs['uid']).") AND `status`='%s'",
-       array($status), __FUNCTION__, __LINE__
+WHERE `userid` NOT IN (".implode(', ', $UIDs['uid']).") AND `status`='%s'",
+               array($status), __FUNCTION__, __LINE__

        );
 
        // Fetch row
        );
 
        // Fetch row