function get_site_misc_data($cats = array(), $grouped = true)
{
$site_misc_data = array();
#/ Set Category
if (empty($cats) || @count($cats) < 0) {
return false;
}
$cat_in = "'" . implode("', '", format_str($cats)) . "'";
$sql_1 = "SELECT * FROM site_misc_data\n WHERE\n m_cat in ({$cat_in})\n ORDER BY m_cat, id";
//var_dump("<pre>", $sql_1); die();
$site_misc_data = @mysql_exec($sql_1);
#/ Sanitize & Format Str
function cb_risky($smd_v)
{
if ($smd_v['content_type'] == 'html') {
$m_value = rem_risky_tags($smd_v['m_value']);
unset($smd_v['m_value']);
$smd_v = @format_str($smd_v);
$smd_v['m_value'] = $m_value;
} else {
$smd_v = @format_str($smd_v);
}
return $smd_v;
}
$site_misc_data = array_map('cb_risky', $site_misc_data);
//var_dump("<pre>", $site_misc_data); die();
if (is_array($site_misc_data) && $grouped != false) {
$site_misc_data = @cb79($site_misc_data, 'm_cat', false);
}
#-
return $site_misc_data;
}
function get_home_packages()
{
mysql_exec("SET @num := 0;", 'save');
mysql_exec("SET @tpe := '';", 'save');
$sql_1 = "\n SELECT * FROM\n (\n\n SELECT *,\n @num := IF(@tpe=t_val, @num+1, 1) AS row_number,\n @tpe := t_val AS dummy_2\n\n FROM\n (\n SELECT mp.*, mp.id AS mp_id, is_basic AS t_val\n FROM membership_packages mp\n WHERE is_active='1'\n ORDER BY is_basic DESC, display_order\n ) AS TX\n GROUP BY id\n HAVING row_number<2\n\n ) AS TY\n\n ORDER BY is_basic DESC, display_order\n ";
$home_packages = @format_str(@mysql_exec($sql_1));
$services = array();
if (is_array($home_packages) && count($home_packages) > 0) {
#/ ADD Benefits
$home_packages_t1 = @array_keys(@cb89($home_packages, 'mp_id'));
if (is_array($home_packages_t1) && count($home_packages_t1) > 0) {
$hp_keys = "'" . implode("', '", $home_packages_t1) . "'";
$sql_2 = "SELECT package_id, title\n FROM package_benefits pb\n WHERE package_id in ({$hp_keys})\n ORDER BY id\n ";
$services = @cb79(format_str(@mysql_exec($sql_2)), 'package_id');
//var_dump("<pre>", $services, $hp_keys); die();
}
//$home_packages = @cb79($home_packages, 'buss_type_id', false);
}
//var_dump("<pre>", $home_packages); die();
return array($home_packages, $services);
}
function get_all_packages($get_benefits = true)
{
#/ get Packages
$packs_sql = "SELECT mp.*, mp.id AS mp_id\n FROM membership_packages mp\n WHERE is_active='1'\n ORDER BY is_basic DESC, display_order\n ";
$packages = @format_str(@mysql_exec($packs_sql));
//var_dump("<pre>", $packages); die();
if ($get_benefits == false) {
return $packages;
}
$services = array();
if (is_array($packages) && count($packages) > 0) {
#/ ADD Benefits
$packages_t1 = @array_keys(@cb89($packages, 'mp_id'));
if (is_array($packages_t1) && count($packages_t1) > 0) {
$p_keys = "'" . implode("', '", $packages_t1) . "'";
$sql_2 = "SELECT package_id, title\n FROM package_benefits pb\n WHERE package_id in ({$p_keys})\n ORDER BY id\n ";
$services = @cb79(format_str(@mysql_exec($sql_2)), 'package_id');
//var_dump("<pre>", $p_keys, $services); die();
}
//$packages = @cb79($packages, 'buss_type_id', false);
}
//var_dump("<pre>", $packages); die();
return array($packages, $services);
}
