function get_media($pg_media) { $pg_media_csv = ''; if (@(!empty($pg_media)) && @is_array($pg_media)) { $pg_media_csv = "'" . implode("','", $pg_media) . "'"; } if (empty($pg_media_csv)) { return false; } $sql_1 = "SELECT * FROM site_media WHERE placement_tag IN ({$pg_media_csv})"; $media = @mysql_exec($sql_1); //var_dump("<pre>", $sql_1, $media); die(); if (is_array($media) && count($media) > 0) { $media = cb89($media, 'placement_tag'); //var_dump("<pre>", $media); die(); return $media; } return false; }
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); }
<tr> <th>ADMIN PERMISSIONS</th> </tr> <tr> <td valign="middle" style="padding:6px 4px;"> <div style="width:130px; float:left;">Allowed Sections:</div> <div style="float:left;"> <?php $admin_sections = get_admin_sections(); $admin_user_perms = array(); if ($au_id > 0) { $admin_user_perms = cb89(get_admin_user_perms($au_id), 'admin_section_id'); //var_dump("<pre>", $admin_user_perms); } foreach ($admin_sections as $admin_sec) { #/ Prevent self-lockout, and Prevent Super-Admin locout $disabled = ''; if (($au_id == $my_user_id || @$empt['is_super_admin'] == '1') && $admin_sec['id'] == 1) { $disabled = "disabled=''"; echo "<input type='hidden' name='permissions[]' value='{$admin_sec['id']}' />"; } echo '<input type="checkbox" name="permissions[]" ' . $disabled . ' value="' . $admin_sec['id'] . '"'; if (isset($admin_user_perms[$admin_sec['id']])) { echo "checked=\"checked\""; } echo '>'; echo $admin_sec['label'] . '</br>';
<script> $(document).ready(function(){ var body_ht = parseInt($('.section-main').outerHeight())+parseInt($('.mar-page').outerHeight()); $('#mask_1').css('height', (body_ht+90)+'px'); }); </script> <?php #/ get needed site_media $sm_array = array('main_logo'); $site_media_main = get_site_media($sm_array); //var_dump("<pre>", $site_media_main); die(); #/ get other needed info $site_contact_info = @cb89(@mysql_exec("SELECT * FROM site_contact_info"), 'c_key'); //var_dump("<pre>", $site_contact_info); die(); ?> <div class="header"> <div class="container"> <?php $site_top_logo = @$site_media_main['main_logo']; ?> <div class="logo"><a href="<?php echo DOC_ROOT; ?> "><img src="<?php echo DOC_ROOT; ?> assets/images_2/media/<?php
$orderby = '4'; break; case 'account_activated': $orderby = '5'; break; case 'is_blocked': $orderby = '6'; break; case 'joined_on': $orderby = '7'; break; } #/ Fill select-options $package_opts = ''; $packages = @format_str(@mysql_exec("SELECT * FROM membership_packages ORDER BY title")); $packages_lst = cb89($packages, 'id'); if (is_array($packages) && count($packages) > 0) { foreach ($packages as $cat_v) { $cat_v['cost'] = (double) $cat_v['cost']; $cost_dv = number_format($cat_v['cost'], 2); $package_opts .= "<option value='{$cat_v['id']}'>{$cat_v['title']}" . ($cat_v['cost'] > 0 ? " (\${$cost_dv})" : '') . "</option>"; } } ?> <tr> <th width="2%" nowrap> </th> <th valign="top" width="20%" nowrap><a href="<?php echo rebuildurl(array("orderby" => 1, "orderdi" => $orderby == 1 && $orderdi == "ASC" ? "DESC" : "ASC")); ?>
break; case 'question_text': $orderby = '3'; break; case 'votes_count': $orderby = '4'; break; case 'added_on': $orderby = '5'; break; } #/ Get Categories ##/ Fill select-options $cat_opts = ''; $cats = @format_str(@mysql_exec("SELECT DISTINCT category, id FROM voice_categories GROUP BY category ORDER BY category")); $cats_x = cb89($cats, 'id'); if (is_array($cats) && count($cats) > 0) { foreach ($cats as $cat_v) { $cat_opts .= "<option value='{$cat_v['id']}'>{$cat_v['category']}</option>"; } } ?> <tr> <th width="2%" nowrap> </th> <th valign="top" width="36%" nowrap><a href="<?php echo rebuildurl(array("orderby" => 3, "orderdi" => $orderby == 3 && $orderdi == "ASC" ? "DESC" : "ASC")); ?> "> Voice Question
function get_notification_msg($notif_data, $send_email = false, $get_user_info = true) { $user_id = $notif_data['user_id']; $from_user_id = $notif_data['from_user_id']; $template_id = $notif_data['template_id']; $objects = $notif_data['objects']; #/ Get user's info $users_info_sql = "SELECT id as user_id, email_add, profile_pic, (CASE\n WHEN identify_by='screen_name' THEN screen_name\n WHEN identify_by='full_name' THEN CONCAT(first_name, ' ', middle_name, ' ', last_name)\n WHEN identify_by='company_name' THEN company_name\n ELSE 'Member'\n END) AS user_ident\n FROM users WHERE id IN ('{$user_id}', '{$from_user_id}')"; $users_info = @format_str(@mysql_exec($users_info_sql)); $users_info = @cb89($users_info, 'user_id'); //var_dump("<pre>", $users_info); die(); if (empty($users_info) || !is_array($users_info)) { return false; } if ($from_user_id <= 0 && count($users_info) < 1 || $from_user_id > 0 && count($users_info) < 2) { return false; } #/ get Notification from Templates $notif_template = get_notif_template($template_id); if (empty($notif_template) || count($notif_template) <= 0) { return false; } ##/ generate notification string $objects_ar = array(); if (stristr($objects, ':') != false) { $objects_ar = @explode(':', $objects); } else { $objects_ar[0] = $objects; $objects_ar[1] = $objects; } @($users_info[$from_user_id]['user_ident'] = str_replace(' ', ' ', @$users_info[$from_user_id]['user_ident'])); @($users_info[$user_id]['user_ident'] = str_replace(' ', ' ', @$users_info[$user_id]['user_ident'])); $from_user_intend = empty($users_info[$from_user_id]['user_ident']) ? "" : "<b>" . @$users_info[$from_user_id]['user_ident'] . "</b>"; $to_user_intend = empty($users_info[$user_id]['user_ident']) ? "" : "<b>" . @$users_info[$user_id]['user_ident'] . "</b>"; $notification = str_ireplace(array('{USER}', '{USER2}', '{OBJECT}', '{OBJECT2}'), array($from_user_intend, $to_user_intend, "<b>{$objects_ar[0]}</b>", "<b>{$objects_ar[1]}</b>"), $notif_template['notification']); #- #/ Set Notification Details for email /*$notif_details = ''; if(!empty($notif_template['notif_details']) && ($send_email!=false) && ($notif_data['object_id']>0) && ($notif_data['object_location']!='')) { $object_info_sql = "SELECT * FROM `{$notif_data['object_location']}` WHERE id='{$notif_data['object_id']}'"; $object_info = @format_str(@mysql_exec($object_info_sql, 'single')); if(is_array($object_info) && count($object_info)>0) { $notif_details = str_ireplace( array('{OBJECT_INFO}', '{USER2}', '{OBJECT}', '{OBJECT2}'), array(@$object_info['user_ident'], @$users_info[$user_id]['user_ident'], "<b>{$objects_ar[0]}</b>", "<b>{$objects_ar[1]}</b>"), $notif_template['notif_details']); } }*/ #/ Return data if ($get_user_info) { return array('users_info' => $users_info, 'notification' => $notification); } else { return $notification; } }
/** Get basic dynamic Page Info from the table site_pages * $pg_id = CSV of pages */ function get_page_info($pg_id) { if (empty($pg_id)) { return false; } $sql_1 = "SELECT CONCAT('pg_', sp.id) AS id, sp.cat_id AS parent_id, title, st.seo_tag, popup_only\n FROM site_pages sp\n LEFT JOIN seo_tags st ON st.id=sp.seo_tag_id\n WHERE sp.is_active='1'\n AND sp.id in ({$pg_id})\n "; $menu = @format_str(@mysql_exec($sql_1)); $menu = @cb89($menu, 'id'); return $menu; }
update_attempt_counts(); redirect_me("{$consts['DOC_ROOT_ADMIN']}login", true); } else { if ($chk_email_add["is_active"] != '1') { $_SESSION["CUSA_ADMIN_MSG_GLOBAL"] = array(false, '<strong>Your Account is BLOCKED.</strong> Please contact Administrator.'); update_attempt_counts(); redirect_me("{$consts['DOC_ROOT_ADMIN']}login", true); } else { #/ Process Login $user_prof = format_str($chk_email_add); $_SESSION["cusa_admin_usr_id"] = $chk_email_add["id"]; $_SESSION["adm_usr_info"] = $user_prof; $_SESSION['LAST_CUSA_Admin_ACTIVITY'] = time(); #/ Set Permissions include_once "../../includes/admin/permission_manager.php"; $adm_perm = array_keys(@cb89(@get_admin_user_perms($chk_email_add["id"], 'admin_section_id'), 'admin_section_id')); $_SESSION['cusa_adm_perm'] = $adm_perm; //var_dump("<pre>", $_SESSION); die(); $_SESSION["CUSA_ADMIN_MSG_GLOBAL"] = array(true, 'Welcome to the CUSA Administration Section.'); reset_attempt_counts(); redirect_me("{$consts['DOC_ROOT_ADMIN']}home", true); exit; } //end else...... } //end if email add exists.... } //end if post...... //////////////////////////////////////////////////////////////////////// $pg_title = "Admin Login"; include_once "includes/header.php";