Use countSumTotalData() instead of SQL query

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

diff --git a/inc/libs/surfbar_functions.php b/inc/libs/surfbar_functions.php
index 4e641f4cc8951c7f0200bda63e53bce5e760b6e2..801ab5a7ec071129a7ef3bac3e12fd124e987832 100644 (file)
--- a/inc/libs/surfbar_functions.php
+++ b/inc/libs/surfbar_functions.php
@@ -526,7 +526,7 @@ function doSurfbarSelfMaintenance () {
 // Handle URLs which limit has depleted
 function doHandleSurfbarDepletedViews () {
        // Get all URLs
-       $urlArray = getSurfbarUrlData(0, 'url_views_max', 'url_id', 'ASC', 'url_id', " AND `url_views_allowed` > 0 AND `url_status`='ACTIVE'");
+       $urlArray = getSurfbarUrlData('0', 'url_views_max', 'url_id', 'ASC', 'url_id', " AND `url_views_allowed` > 0 AND `url_status`='ACTIVE'");
 
        // Are there some entries?
        if (count($urlArray) > 0) {
@@ -1006,7 +1006,7 @@ function getSurfbarTotalUrls ($status = 'ACTIVE', $excludeUserId = NULL) {
        } // END - if
 
        // Is the exlude userid set?
-       if (isValidUserId($excludeUserId)) {
+       if (isValidId($excludeUserId)) {
                // Then add it
                $userids['url_userid'][$excludeUserId] = $excludeUserId;
        } // END - if
@@ -1147,7 +1147,7 @@ function addSurfbarReloadLockById ($urlId) {
 function doSurfbarPayPoints () {
        // Remove it from the URL owner
        //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'userid='.getSurfbarUserid().',costs='.getSurfbarCosts() . ' - ENTERED!');
-       if (isValidUserId(getSurfbarUserid())) {
+       if (isValidId(getSurfbarUserid())) {
                // Subtract points and ignore return status
                subtractPoints(sprintf("surfbar_%s", getSurfbarPaymentModel()), getSurfbarUserid(), getSurfbarCosts());
        } // END - if
@@ -1424,7 +1424,7 @@ function changeSurfbarUrlStatus ($urlId, $prevStatus, $newStatus, $data = array(
        } // END - if
 
        // Prepare array
-       $filterData =  array(
+       $filterData = array(
                'url_id'      => $urlId,
                'prev_status' => $prevStatus,
                'new_status'  => $newStatus,
@@ -1885,7 +1885,7 @@ function generateSurfbarPackageLink ($packageId) {
        $url  = '{%url=modules.php?module=admin&what=list_surfbar_packages';
 
        // Is package id given?
-       if ((!is_null($packageId)) && ($packageId > 0)) {
+       if (isValidId($packageId)) {
                // Then add it
                $url .= '&package_id=' . bigintval($packageId);
        } // END - if