[suzkaw]

Here is a smarty function to display the total number of listings.

1. Copy and paste this code in a new file and save it as: function.total_listings.php
2. Next upload it to includes/templates/plugins/ directory
3. Finally to display the total add {total_listings} to your template file.

Here is the code:

PHP Code:

<?php
/**************************************************  *********************
| 68 Classifieds developed by 68 Designs, LLC.
|-----------------------------------------------------------------------
| All source code & content (c) Copyright 2005, 68 Designs LLC
|   unless specifically noted otherwise.
|
|The contents of this file are protect under law as the intellectual property
| of 68 Designs, LLC. Any use, reproduction, disclosure or copying
| of any kind without the express and written permission of 68 Designs, LLC is forbidden.
|
| __________________________________________________  ____________________
|    http://www.68classifieds.com      http://www.68designs.com/
**************************************************  *********************/
function smarty_function_total_listings($params, &$smarty)
{
    global $db;
    
    //get total active listings
    $sSQL="SELECT COUNT(*) AS total FROM ".PREFIX."products WHERE expiration > NOW() AND display = 'Y'";
    $result=$db->query($sSQL);
    $rs=$result->fetch();
    $total_listings=$rs['total'];

    return $total_listings;
}
?>

[free2take]

Similar type function I wrote is count_user_field.

May be of use to someone else out there also, I needed a custom function to display how many listings had an admin defined extra field set to a certain value in my case the field was 'Status' and the value was 'Reused' you can pass any extra field and value to the function though.

PHP Code:

<?php
function smarty_function_count_user_field($params, $smarty)
{
    global $db;
    
        foreach ($params as $_key=>$_value)
    {
        switch ($_key)
        {
            case 'fldname':
                $$_key = (string)$_value;
                break;
            case 'fldvalue':
                $$_key = (string)$_value;
                break;
        }
    }

    //Get field ID from class_fields
    $sSQL = "SELECT fID FROM ".PREFIX."fields WHERE fNAME = '$fldname'";
    $result=$db->query($sSQL);
    $fID=$result->fetch();
    //Count number of ads with field set to desired status
    $sSQL="SELECT COUNT(*) AS total FROM ".PREFIX."products,".PREFIX."products_fields WHERE id=pID AND expiration > NOW() AND display = 'Y' AND sValue = '$fldvalue'";
    $result=$db->query($sSQL);
    $rs=$result->fetch();
    return $rs['total'];
}
?>

Copy and paste this code in a new file and save it as: function.count_user_field.php
Upload it to includes/templates/plugins/ directory
Finally to display the total add {count_user_field fldname=YourExtraFieldName fldvalue=YourFieldsValue} to your template file.

In my case call was;
{count_user_field fldname=Status fldvalue=Reused}

Hope it helps all the best,
Mully

[suzkaw]

Very nice!