User tag to get random news item

[kmoon]

Hello,

I have been trying to wrote a usertag that will gram a random news item, but no matter what I try nothing shows up.
I'm not much of a programmer so I need some help here.

Here's my code:

Code: Select all

      global $gCms;
      $db = & $gCms->db;

      $dbresult = array();

      $query = "SELECT * FROM ".cms_db_prefix()."module_new 
 where news_cat = 'Udtalelser' ORDER BY RAND limit 1";
      $dbresult = $db->Execute($query);

      if ($dbresult && $dbresult->RowCount() > 0)
      {
         while ($row = $dbresult->FetchRow())
         {
            $name = $row[news_title];
            $data = $row[news_data];
            echo $data."<br>".$name;
        }
      }

[Ted]

The table name is module_news instead of module_new.

It should be "ORDER BY rand()" as rand is a function.

[kmoon]

Thanks...
After fighting with this for an hour I took a break and a cup of coffee.. when I came back I found those same mistakes.
Feeling stooopid...

[olaf_noehring]

Hi

probably a better solution is to reuse the existing news module and simply add a new sortorder  . Here the code - you need to add the new sortby-variable (random -> e.g. sortby="random") to the help yourself.

1. open /modules/news/action.default.php (from 1.0 beta 6)
2. searchif (isset($params['sortby']))
{
if ($params['sortby'] == 'news_category')
{
    $query .= "ORDER BY 'long_name', 'news_date'";
} else {
        $query .= "ORDER BY '" . str_replace("'", '', str_replace(';', '', $params['sortby'])) . "' ";
}
}
else
{
$query .= "ORDER BY news_date ";
} 

3. replace withif (isset($params['sortby']))
{
//noehring - added random sort order for news
if ($params['sortby'] == 'random'){
$query .= "ORDER BY rand()";
} else {
if ($params['sortby'] == 'news_category')
{
    $query .= "ORDER BY 'long_name', 'news_date'";
} else {
        $query .= "ORDER BY '" . str_replace("'", '', str_replace(';', '', $params['sortby'])) . "' ";
}
}
// end noehring
}
else
{
$query .= "ORDER BY news_date ";
}

That's all!
Code posted in developers section under: http://dev.cmsmadesimple.org/tracker/in ... 8&atid=111
Olaf