public function getAllRules($where = '', $wlimit = '')
{
$count_str = "SELECT R.RecordID,R.RuleID,R.ParrentRuleID,R.Information,\n R.Rule,R.DefaultValue,R.Deleted,\n RF.RuleFileName,RDF.DataFileName,R.RuleFileID from rules R\n LEFT JOIN rule_files RF ON (RF.RuleFileID=R.RuleFileID)\n LEFT JOIN rule_data_files RDF ON (RDF.DataFileID=RF.RuleFileID)\n WHERE 1 {$where} ORDER BY R.RecordID DESC {$wlimit}";
$result = $this->dbh->query($count_str);
if (PEAR::isError($result)) {
echo $result->getMessage() . ' - ' . $result->getUserinfo();
exit;
}
$array = $result->fetchAll();
$result->free();
$rules_a = array();
foreach ($array as $r) {
$rule = new Rule();
$rule->setRuleRecordID($r[0]);
$rule->setRuleID($r[1]);
$rule->setRuleParrentRuleID($r[2]);
$rule->setRuleInformation($r[3]);
$rule->setRule($r[4]);
$rule->setRuleShort(substr($r[4], 0, 55));
$rule->setRuleDefaultValue($r[5]);
$rule->setRuleFileName($r[7]);
$rule->setRuleFileID($r[9]);
$rule->setDataFileName($r[8]);
$rule->setRuleActive($r[6]);
$rules_a[] = $rule;
}
return $rules_a;
}
