Random

[Grovir]

Is there a way to pull random links to show in a specified location on the front page, or any page for that matter?

[Vladimir T.]

I have delete common question.
ok. Please do following steps:
1. Edit ./includes/classes/DirListing.php file

find code

PHP Code:

function getLatest($aStart = 0, $aLimit = 0, $aAccount = '')
{
    $sql = "SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path` ";
    $sql .= $aAccount ? ', IF((`t1`.`id_account` IS NULL)
        OR (`t1`.`id_account` = \'0\'), \'0\', \'1\') `id_account_edit` ' : ', \'0\' `id_account_edit` ';
    $sql .= "FROM `".$this->mTable."` t1 ";
    $sql .= "LEFT JOIN `".$this->mPrefix."categories` t9 ";
    $sql .= "ON t1.`id_category` = t9.`id` ";
    $sql .= "WHERE t1.`status` = 'active' ";
    $sql .= "AND t9.`status` = 'active' ";
    //$sql .= "GROUP BY t1.`id` ";
    $sql .= "ORDER BY t1.`date` DESC ";    
    $sql .= $aLimit ? "LIMIT {$aStart}, {$aLimit}" : '';
    
    return $this->getAll($sql);
} 


add after

PHP Code:

/**
* Returns random listings
*
* @param int $aStart starting position
* @param int $aLimit number of listings to be returned
* @param int $aAccount account id
*
* @return arr
*/
function getRandom($aStart = 0, $aLimit = 0, $aAccount = '')
{
    $sql = "SELECT t1.*, `t1`.`comments_active` `comments`, t9.`path` ";
    $sql .= $aAccount ? ', IF((`t1`.`id_account` IS NULL)
        OR (`t1`.`id_account` = \'0\'), \'0\', \'1\') `id_account_edit` ' : ', \'0\' `id_account_edit` ';
    $sql .= "FROM `".$this->mTable."` t1 ";
    $sql .= "LEFT JOIN `".$this->mPrefix."categories` t9 ";
    $sql .= "ON t1.`id_category` = t9.`id` ";
    $sql .= "WHERE t1.`status` = 'active' ";
    $sql .= "AND t9.`status` = 'active' ";
    $sql .= "ORDER BY RAND() ";    
    $sql .= $aLimit ? "LIMIT {$aStart}, {$aLimit}" : '';
    return $this->getAll($sql);
} 


2. Edit ./includes/view.inc.php file
find code

PHP Code:

/** get partner listings **/
if ($config->get('partner_listings'))
{
    $partner_listings = $Listing->getPartner($id, 0, $config->get('num_partner_display'));
    $gDirSmarty->assign_by_ref('partner_listings', $partner_listings);
} 


add after

/**Get Random Listing **/
$random_listings = $Listing->getRandom(0, 10, $gDirAccount['id']);
$gDirSmarty->assign_by_ref('random_listings', $random_listings);

where 10 - is number of random links

3) code for template

   
{if $random_listings}
<table cellspacing="0" cellpadding="0">
	{foreach from=$random_listings item=listing}
		{include file="listing-display.tpl"}						
	{/foreach}
</table>
{/if}

You can use it code anywhere in template.

[Grovir]

You, sir, are a genius! Thank you!

One minor change to your instructions. I do not have a file named esynListing.php in my includes/classes directory, the file I edited is named DirListing.php.

Other then that it worked great! Thanks again!

[Vladimir T.]

Oh, Yes you are right. I have inserted name of file from Pro version. I have edit...