HolidayQuery additional arguments

Talk about writing modules and plugins for CMS Made Simple, or about specific core functionality. This board is for PHP programmers that are contributing to CMSMS not for site developers
Post Reply
User avatar
magallo
Forum Members
Forum Members
Posts: 105
Joined: Thu Mar 24, 2011 12:37 am

HolidayQuery additional arguments

Post by magallo »

Hi this is a continuation of the post here:
http://forum.cmsmadesimple.org/viewtopi ... =6&t=74043
It's locked.

Do you happen to know how I could pass arguments to the

Code: Select all

public function execute()
{
if( !is_null($this->_rs) ) return;
$sql = 'SELECT SQL_CALC_FOUND_ROWS H.*
FROM '.CMS_DB_PREFIX.'mod_holidays H ORDER BY the_date DESC';
$db = \cms_utils::get_db();
$this->_rs = $db->SelectLimit($sql,$this->_limit,$this->_offset);
IF( $db->ErrorMsg() ) throw new \CmsSQLErrorException($db->sql.' -- '.$db->ErrorMsg());
$this->_totalmatchingrows = $db->GetOne('SELECT FOUND_ROWS()');
}
I'd like to add some WHERE conditions to the query.
Thanks
User avatar
magallo
Forum Members
Forum Members
Posts: 105
Joined: Thu Mar 24, 2011 12:37 am

[SOLVED] HolidayQuery additional arguments

Post by magallo »

fount it:

$query = new HolidayQuery(array('published'=>1));
Post Reply

Return to “Developers Discussion”