function cc_check_banlist($transInfo, $banInfo = "")
{
//(SELECT group_concat(`bl_type`,'=',`bl_data` SEPARATOR '&') as ban FROM `cs_banlist` where `bl_group` is not null group by bl_group) union (SELECT concat(`bl_type`,'=',`bl_data`) as ban FROM `cs_banlist` where `bl_group` is null)
$bl_type = func_get_enum_data('cs_banlist', 'bl_type');
$ban_sql = " 0 ";
foreach ($bl_type as $key) {
$ban_sql .= " OR (bl_type='{$key}' AND '" . $transInfo[$key] . "' LIKE bl_data) \n";
}
// select sum(ban) as bansfound from (SELECT count(bl_ID) = sum((bl_type='name' AND bl_data = 'sebastian') OR (bl_type='address' AND bl_data = 'mancini')) as ban FROM `cs_banlist` group by `bl_group`) as bans
$sql = "select sum(ban) as bansfound , group_concat(if(ban,banInfo,NULL)) as banInfo from (\n\t\t\t\tSELECT count(bl_ID) = sum({$ban_sql}) as ban, concat('bl_group=',`bl_group`,'&',group_concat(`bl_type`,'=',`bl_data` SEPARATOR '&')) as banInfo\n\t\t\t\tFROM `cs_banlist` group by `bl_group`\n\t\t\t\t) as bans";
$result = mysql_query($sql) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>~{$sql}");
$bans = mysql_fetch_assoc($result);
$banInfo = $bans['bansfound'] . " Ban(s) Found: \n";
$banarray = explode(",", $bans['banInfo']);
foreach ($banarray as $data) {
if (!$data) {
break;
}
parse_str($data, $data);
$banInfo .= " Group " . $data['bl_group'] . " found ";
unset($data['bl_group']);
foreach ($data as $bl_type => $bl_data) {
$banInfo .= $bl_type . "='" . $bl_data . "' and ";
}
$banInfo = substr($banInfo, 0, -5);
$banInfo .= "\n";
}
return $bans['bansfound'] > 0;
}
function smart_getChargeTypes($params)
{
$types = func_get_enum_data('cs_transactiondetails', 'cardtype');
$pairs = array();
//$pairs[] = array("value"=>"","display"=>"Any Type");
foreach ($types as $key => $type) {
$pairs[] = array("value" => $type, "display" => $type);
}
return $pairs;
}
function func_get_enum_radio($table, $field, $name = '', $selectedVal = false)
{
$enum_list = func_get_enum_data($table, $field);
if (!$name) {
$name = $field;
}
foreach ($enum_list as $enum) {
$options .= ucfirst($enum) . ": <input type='radio' value='{$enum}' name='{$name}' " . ($selectedVal == $enum ? "checked" : "") . " >\n ";
}
return $options;
}