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";
