Modules and a parameter

Xirtam · 15.02.2005, 22:34

I have two different modules.
One containing

PHP Code:

  $sql = "SELECT title_alias, id, sectionid, created, state";

$sql .= " FROM #__content ";

$sql .= "WHERE sectionid = 2 AND state = 1 ";

$sql .= "ORDER BY created ASC";

$database->setQuery($sql);

$database->query();

$events = $database->loadObjectList();

And one with

PHP Code:

  d    $sql = "SELECT * FROM #__content "

        . "WHERE (created >= '$selected_date 00:00:00' AND created <= '$selected_date 23:59:59') "

        . "AND (sectionid = 2) "

        . "AND state='1'";

When I want them to look to another sectionid I have the edit them manualy by changing 'sectionid=2' into another value.
I prefer the way an administrator can do : changing the parameter in the modules section as an administrator.

What do I have to change?
I looked into a view tut's but couldn't find anything that helped me.

_X_

zorkhh · 16.02.2005, 03:11

Hi,

just look into the Developer-Doc at mamboserver.com. There you find all you need.

In your Module's XML-File insert a parameter tag like this:

<param name="sectionid" type="mos_section" default="0" label="Section:" description="" />

and in your module's PHP-File you have to read the parameter(s):

global $database, $mainframe;

// Init parameters or set defaults
$MOSSECTIONID=$params->get('sectionid','2');

Greetings, ZorkHH