function white_list_insert($post, $db)
{
$new_white_list = new Rule();
$new_white_list->setWhiteListType($post['wl_filter'] + 1);
$new_white_list->setWhiteListData($post['wl_data']);
$new_white_list->setWhiteListActive($post['validity']);
$new_white_list->setFilled(true);
$db->addWhiteLists($new_white_list);
}
public function getAllWhiteLists($where = '', $wlimit = '')
{
$count_str = "SELECT WL.RecordID,WL.WhiteListType,\n WL.WhiteListData,WL.Deleted\n FROM white_list WL\n WHERE 1 {$where} ORDER BY WL.RecordID DESC {$wlimit}";
$result = $this->dbh->query($count_str);
if (PEAR::isError($result)) {
echo $result->getMessage() . ' - ' . $result->getUserinfo();
exit;
}
$array = $result->fetchAll();
$result->free();
$white_lists = array();
foreach ($array as $wl) {
$white_list = new Rule();
$white_list->setWhiteListRecordID($wl[0]);
$white_list->setWhiteListType($wl[1]);
$white_list->setWhiteListData($wl[2]);
$white_list->setWhiteListActive($wl[3]);
$white_lists[] = $white_list;
}
return $white_lists;
}
