Limit the number of "New Listing" displays (re-visited)

[brw9532]

I'm having a problem that I have seen discussed here before, but the solution is not working for me. I would like to limit the number of displays when people click on �New Listijngs�. It currently shows ALL Listings. Can someone help me limit this?



V3.1.7 Designer
Default template


Below is the code I am using. The [$number=4] should limit my displays to 4. However, all �new� listings are being displayed. (Note: I have even changed the 4 to �4� but that didn�t solve my problem. Any help would be much appreciated!


<?php
/**
* smarty_function_new_listings
*
* This function is useful for generating a vertical table of new listings.
*
* All source code & content (c) Copyright 2006, 68 Classifieds
* unless specifically noted otherwise.
*
* @package 68classifieds
* @author Eric Barnes
* @copyright 68 Classifieds
* @link http://www.68classifieds.com
* @$Revision: 1.3 $
* @Updated: $Date: 2006/05/26 13:14:08 $
*/
function smarty_function_new_listings($params, &$smarty)
{
global $db;

$table_attr = 'border="1"';
$tr_attr = '';
$td_attr = '';
$number=4;
$trailpad = ' ';
$img_break = '<br />';
$date_format = '%B %e, %Y %I:%M %p';

foreach ($params as $_key=>$_value)
{
switch ($_key)
{
case 'number':
$$_key = (int)$_value;
break;

case 'table_attr':
case 'img_break':
case 'date_format':
$$_key = (string)$_value;
break;

case 'tr_attr':
case 'td_attr':
$$_key = $_value;
break;
}
}

$sSQL="SELECT p.id, p.owner, p.title, p.featured, p.section, p.description, p.price, p.dateadded, p.expiration, p.pHighlighted, p.pBold, u.state, u.city, u.country FROM ".PREFIX."products AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id WHERE p.expiration > NOW() AND p.display = 'Y' ORDER BY p.dateadded DESC LIMIT ".$number;
$result=$db->query($sSQL);
$i=0;
while($row=$result->fetch())

[Eric Barnes]

When you are calling this function can you make sure you do not have a number associated with it or it is also number=4?

[Lhotch]

You may also want to try and delete the contents of /templates_c

[gregbatch]

NOW:

ORDER BY p.dateadded DESC LIMIT ".$number;

TRY:

ORDER BY p.dateadded DESC LIMIT ".$number."";

Technically, it should work as is, but I have had some servers refuse to accept a concatenated variable at the tail of a query. Either it gave an error, or ignored that variable completely. Closed it up with quotes and it worked fine. Don't know the reason.

[brw9532]

Thanks for all of your help, but none of these changes worked for me. In fact, I'm really confused. Being an old "tester of programming code" I deleted the "function.new_listings" file just to see what would happen. We'll the program still displayed ALL of the New Listings EVEN without the "function.new_listings" file being there. Why wouldn't I get an error when I attempt to produce the New Listings if the file was gone? Could the program be pulling information from a different file besides the "function.new_listings"? That would explain why none of my changes seem to be working. I'm using the Developer version of the program so I can't access the "toplistings.php" page to see what is going on. Guess I'll be up late tonight trying to figure this out. Any ideas?

[Eric Barnes]

From that last response I think you are looking in the wrong place. The smarty function is only used by placing code in the template file. For example:

{new_listings number=4}

The toplistings.php file pulls out all the data in that file. If you open you should be able to see a global variable: MAX_ROWS_SEARCH

Here is the actual limit clause:

PHP Code:

$offset = ($pageNum - 1) * MAX_ROWS_SEARCH;
    $searchSQL = sprintf("%s LIMIT %d, %d", $sSQL, $offset, MAX_ROWS_SEARCH); 


[brw9532]

Sounds like we're heading in the right direction! But, when I open "toplistings.php" in the root directory" I see what looks like scrambled data:


(example of what I see, 4+oV5CfIvrml3ToJ8f5oV/0Dzu//XX
ZhDyAlqOQiGIAA8SJmvvAqGH68eZh6180XcWEeiKOHncQH
6ZZlF+x9PlwF7CPINyOaXaaqcaZ/IniQ/qZqQh13bywZGSU
P4NTojtuEHLVXdAe9UN+xed4zDPbEnudB4xVzv6fDYvvjQno
EuSlcwwBss4zZSo0p5lGIMG/+U4ZU/UFTEF/HLC55QGyVbu
wJRuV+e6+CBIikTxj69j+8y/FlQH+qFtC8/X2VJf0S7yXgg
EfsIaraXVmhJCPZyyvmVB6O1Fz9FRzhFweVa/huc
sK2Ry4D+IlgW08o7)



I naturally assumed this is because I have the Designer version of the program and many of the PHP files have been protected. Or, am I looking in the wrong place or have a done something else wrong?

[Eric Barnes]

Yes with the Designer edition that file is encoded. The only work arounds that I can think of are to either purchase the Developer edition or some how use the external.php file with an rss parser to display x amount of new listings.

[brw9532]

Thanks for your help. I was thinking about getting the Developers version at some point anyway.