function generateRandomString($length, $api_key) { $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'; $randomString = ''; for ($i = 0; $i < $length; $i++) { $randomString .= $characters[rand(0, strlen($characters) - 1)]; } $client_sql = re_db_query("SELECT * FROM cs_sites WHERE api_key='" . $randomString . "' OR api_secret='" . $randomString . "'"); if (re_db_num_rows($client_sql) > 0) { generateRandomString('10'); } else { if ($api_key == $randomString) { generateRandomString('10'); } else { return $randomString; } } }
exit; } } if (!isset($_POST['save_btn']) && isset($_SESSION['admin_id'])) { $social_key_qry = "select * from cs_client_social_key where client_id='" . $_SESSION['admin_id'] . "'"; $social_key_sql = re_db_query($social_key_qry); if (re_db_num_rows($social_key_sql) > 0) { $tot_rec = re_db_num_rows($social_key_sql); while ($social_key_rec = re_db_fetch_array($social_key_sql)) { $auto_id[$social_key_rec['social_id']] = $social_key_rec['id']; $api_key[$social_key_rec['social_id']] = $social_key_rec['api_key']; $secret_key[$social_key_rec['social_id']] = $social_key_rec['secret_key']; } } } $social_sql = re_db_query("select * from cs_social_network_master where is_display='1'"); if (isset($_SESSION['msg']) && $_SESSION['msg'] == "insert") { $msg = "Change Saved Successfully."; unset($_SESSION['msg']); } include "header.php"; ?> <div class="content-wrap"> <!-- main page content. the place to put widgets in. usually consists of .row > .col-md-* > .widget. --> <main id="content" class="content" role="main"> <ol class="breadcrumb"> <li>YOU ARE HERE</li> <li class="active">Authorization Settings</li> </ol> <!--h1 class="page-title">Site - <span class="fw-semi-bold">Settings</span></h1--> <div class="row">
<?php include "include/config.php"; $sel = "select id,likes,client_id from cs_users cs join (select member_id,likes from cs_fb_share_users where likes!='' ) as cu on cu.member_id=cs.id where cs.is_fb='1'"; $res_sel = re_db_query($sel); while ($row_sel = re_db_fetch_array($res_sel)) { $likes = explode(",", $row_sel['likes']); foreach ($likes as $key => $val) { if ($val != '') { re_db_query("insert into cs_member_pages_like (member_id,page_id,client_id) values ('" . mysql_real_escape_string($row_sel['id']) . "',(select id from cs_like_pages where page_title='" . mysql_real_escape_string($val) . "'),'" . $row_sel['client_id'] . "')"); } } } exit("Dilip it is all over");
$csuser_id = 0; if (mysql_num_rows($res_user) > 0) { $row_user = mysql_fetch_array($res_user); $csuser_id = $row_user['id']; $update_query = "update cs_li_data"; $where = " where member_id='" . mysql_real_escape_string($member_id) . "'"; } else { $update_query = "insert into cs_li_data"; $where = ""; } if (intval($udata->byear) == '0') { $byear = "0000"; } else { $byear = intval($udata->byear); } $set_query = $update_query . " set \n member_id='" . mysql_real_escape_string($member_id) . "',\n profile_id='" . mysql_real_escape_string($udata->id) . "', \n firstname='" . mysql_real_escape_string($udata->firstName) . "',\n lastname='" . mysql_real_escape_string($udata->lastName) . "',\n bday='" . mysql_real_escape_string(intval($udata->bday)) . "',\n bmonth='" . mysql_real_escape_string(intval($udata->bmonth)) . "',\n byear='" . mysql_real_escape_string($byear) . "',\n headline='" . mysql_real_escape_string($udata->headline) . "',\n industry='" . mysql_real_escape_string($udata->industry) . "',\n location='" . mysql_real_escape_string($udata->location) . "',\n numConnections='" . mysql_real_escape_string($udata->numConnections) . "',\n pictureUrl='" . mysql_real_escape_string($udata->pictureUrl) . "',\n publicProfileUrl='" . mysql_real_escape_string($udata->publicProfileUrl) . "' \n " . $where . "\n "; re_db_query($set_query); if (!isset($_GET['clickurl']) && $_GET['to_share'] == '1') { echo $member_id; exit; } if (!isset($_GET['clickurl']) && $_GET['to_share'] == '0') { echo "no_share~" . $udata->emailAddress; exit; } } /*LINKED DATA END*/ } ?>
function manage_fb_page($fb_page_title, $fb_page_id, $member_id, $client_id, $total_likes) { $select_all = "select * from `cs_like_pages` where page_title='" . mysql_real_escape_string($fb_page_title) . "'"; $res_like = re_db_query($select_all); if (re_db_num_rows($res_like) > 0) { $row_page = re_db_fetch_array($res_like); re_db_query("update cs_like_pages set fb_page_id='" . $fb_page_id . "',total_likes='" . $total_likes . "' where id='" . $row_page['id'] . "'"); $user_entry = re_db_query("select id from `cs_member_pages_like` where page_id='" . $row_page['id'] . "' and client_id='" . $client_id . "' and member_id='" . $member_id . "'"); if (re_db_num_rows($user_entry) <= 0) { $insert_user = "******" . $row_page['id'] . "',member_id='" . $member_id . "',client_id='" . $client_id . "'"; re_db_query($insert_user); } } else { $insert_cs = re_db_query("insert into cs_like_pages set page_title='" . mysql_real_escape_string($fb_page_title) . "',fb_page_id='" . $fb_page_id . "',total_likes='" . $total_likes . "'"); $last_page_id = mysql_insert_id(); $insert_user = "******" . $last_page_id . "',member_id='" . $member_id . "',client_id='" . $client_id . "'"; re_db_query($insert_user); } }
$fb_sub_age_qry = "SELECT COUNT(*) as total, CASE WHEN age = 0 THEN 'NP' WHEN age > 0 AND age < 13 THEN '13' WHEN age >=13 AND age <=17 THEN '13-17' WHEN age >=18 AND age <=34 THEN '18-34' WHEN age >=35 AND age <= 49 THEN '35-49' WHEN age >=50 THEN '50+' END AS ageband FROM ( " . $select_fb_main . " ) as tbl GROUP BY ageband"; $fb_sub_age_sql = re_db_query($fb_sub_age_qry); if (re_db_num_rows($fb_sub_age_sql) > 0) { while ($fb_sub_age_rec = re_db_fetch_array($fb_sub_age_sql)) { $fb_age_arr[$fb_sub_age_rec['ageband']] = $fb_sub_age_rec['total']; } } $gp_sub_age_qry = "SELECT COUNT(*) as total, CASE WHEN age = 0 THEN 'NP' WHEN age > 0 AND age < 13 THEN '13' WHEN age >=13 AND age <=17 THEN '13-17' WHEN age >=18 AND age <=34 THEN '18-34' WHEN age >=35 AND age <= 49 THEN '35-49' WHEN age >=50 THEN '50+' END AS ageband FROM ( " . $select_gp_main . " ) as tbl GROUP BY ageband"; $gp_sub_age_sql = re_db_query($gp_sub_age_qry); if (re_db_num_rows($gp_sub_age_sql) > 0) { while ($gp_sub_age_rec = re_db_fetch_array($gp_sub_age_sql)) { $gp_age_arr[$gp_sub_age_rec['ageband']] = $gp_sub_age_rec['total']; } } $li_sub_age_qry = "SELECT COUNT(*) as total, CASE WHEN age = 0 THEN 'NP' WHEN age > 0 AND age < 13 THEN '13' WHEN age >=13 AND age <=17 THEN '13-17' WHEN age >=18 AND age <=34 THEN '18-34' WHEN age >=35 AND age <= 49 THEN '35-49' WHEN age >=50 THEN '50+' END AS ageband FROM ( " . $select_li_main . " ) as tbl GROUP BY ageband"; $li_sub_age_sql = re_db_query($li_sub_age_qry); if (re_db_num_rows($li_sub_age_sql) > 0) { while ($li_sub_age_rec = re_db_fetch_array($li_sub_age_sql)) { $li_age_arr[$li_sub_age_rec['ageband']] = $li_sub_age_rec['total']; } } ?> <script type="text/javascript"> var chartAge; var typesAge = [ <?php $i = 0; $total = count($main_age_arr); foreach ($main_age_arr as $key => $val) { $i++; if ($key == "NP") {
fwrite($myfile, $txt) or die("Unable to file write!"); fclose($myfile); $_SESSION['msg'] = "update"; } //$_SESSION['msg']="update"; header("location:follow_bar_setting.php"); exit; } } if (!isset($_POST['save'])) { $site_data_qry = "select * from cs_sites where id='" . $_SESSION['admin_id'] . "'"; $site_data_sql = re_db_query($site_data_qry); if (re_db_num_rows($site_data_sql) > 0) { $site_data_rec = re_db_fetch_array($site_data_sql); $follow_btn_size = $site_data_rec['follow_btn_size']; $detail_sql = re_db_query("select * from cs_follow_bar_setting where client_id='" . $_SESSION['admin_id'] . "'"); if (re_db_num_rows($detail_sql) > 0) { $i = 0; while ($detail_rec = re_db_fetch_array($detail_sql)) { $i++; $provider[$i] = $detail_rec['provider']; $provider_url[$i] = $detail_rec['provider_url']; $provider_title[$i] = $detail_rec['provider_title']; $provider_id[$i] = $detail_rec['provider_id']; } } } } if ($provider[1] == "") { $file_url = ""; }
<div class="widget-body"> <?php $dateRange = ""; $ageRange = ""; $select_rev_main = "select sum(if(ot.is_from=1,ot.order_amt,0)) as fb_total, sum(if(ot.is_from=2,ot.order_amt,0)) as li_total, sum(if(ot.is_from=3,ot.order_amt,0)) as gp_total, sum(if(ot.is_from=5,ot.order_amt,0)) as yh_total, sum(if(ot.is_from=6,ot.order_amt,0)) as ig_total, date_format(ot.date_time,'%m-%d-%Y') as order_date from cs_track_orders as ot, `cs_users` as csu where csu.id=ot.ref_by and ot.client_id=csu.client_id and ot.date_time is not null and ot.client_id='" . $_SESSION['admin_id'] . "' "; if (isset($_POST['day_range']) && ($_POST['day_range'] == '0' || $_POST['day_range'] == '1')) { $select_rev_main .= " and datediff(current_date,ot.date_time) ='" . $_POST['day_range'] . "'"; } else { if (isset($_POST['day_range']) && $_POST['day_range'] > 1) { $select_rev_main .= " and datediff(current_date,ot.date_time) <='" . $_POST['day_range'] . "'"; } else { $select_rev_main .= " and datediff(current_date,ot.date_time) <='30'"; } } $select_rev_main .= " group by date_format(ot.date_time,'%m-%d-%Y')"; $rev_main_sql = re_db_query($select_rev_main); $total = re_db_num_rows($rev_main_sql); ?> <script type="text/javascript"> var chart = AmCharts.makeChart("rbpBarChartDiv", { "type": "serial", "theme": "none", "startDuration": 2, "depth3D":20, "angle":30, "legend": { "menuTop": '0px', "horizontalGap": 1, "maxColumns": 1, "position": "right", "useGraphSettings": true,
} if (isset($_POST['pass']) && $_POST['pass'] == "") { $error[] = "Please enter password."; } if (count($error) <= 0) { $sel_cs = "INSERT INTO `cs_sites` SET \r\n firstname='" . $_POST['firstname'] . "',\r\n lastname='" . $_POST['lastname'] . "',\r\n site_url='" . $_POST['site_url'] . "', \r\n site_admin='" . $_POST['site_admin'] . "',\r\n fb_app_id='" . $_POST['fb_app_id'] . "',\r\n twitter_app_id='" . $_POST['twitter_app_id'] . "',\r\n linkedin_app_id='" . $_POST['linkedin_app_id'] . "',\r\n gplus_app_id='" . $_POST['gplus_app_id'] . "',\r\n yahoo_app_id='" . $_POST['yahoo_app_id'] . "',\r\n admin_email='" . $_POST['email'] . "',\r\n admin_password='******'pass']) . "'"; re_db_query($sel_cs); $last_id = re_db_insert_id(); if ($_FILES['admin_img']['name'] != "") { $filename = basename($_FILES['admin_img']['name']); $ext = strtolower(getEXT($filename)); $orgfilename = "cs_admin_" . $last_id . "." . $ext; $uploaddir = DIR_FS . "img/cs_admin/" . $orgfilename; move_uploaded_file($_FILES['admin_img']['tmp_name'], $uploaddir); $u_update = "update cs_sites set admin_img='" . $orgfilename . "' where id='" . $last_id . "'"; re_db_query($u_update); } header("location:login.php?msg=reg"); exit; } } ?> <!DOCTYPE html> <html> <head> <title>Sing Up</title> <link href="css/application.min.css" rel="stylesheet"> <!-- as of IE9 cannot parse css files with more that 4K classes separating in two files --> <!--[if IE 9]> <link href="css/application-ie9-part2.css" rel="stylesheet"> <![endif]-->
if (isset($_POST['user']) && ($_POST['user'] == "" || $_POST['pass'] == "")) { $error[] = "Please enter username and password."; } if (count($error) <= 0) { if ($_POST['user'] == "csadmin" && md5($_POST['pass']) == "29ad0e3fd3db681fb9f8091c756313f7") { $_SESSION['admin_type'] = "master"; $_SESSION['admin_id'] = "1"; $_SESSION['firstname'] = "Master"; $_SESSION['lastname'] = "Admin"; $_SESSION['admin_email'] = "*****@*****.**"; $_SESSION['admin_img'] = "admin_1.jpg"; header("location:index.php"); exit; } else { $sel_cs = "select * from `cs_sites` where admin_email='" . $_POST['user'] . "' and admin_password='******'pass']) . "' and is_approved='1'"; $rec_cs = re_db_query($sel_cs); if (re_db_num_rows($rec_cs) > 0) { $row_cs = re_db_fetch_array($rec_cs); $_SESSION['admin_type'] = "client"; $_SESSION['admin_id'] = $row_cs['id']; $_SESSION['site_admin'] = $row_cs['site_admin']; $_SESSION['firstname'] = $row_cs['firstname']; $_SESSION['lastname'] = $row_cs['lastname']; $_SESSION['admin_email'] = $row_cs['admin_email']; $_SESSION['admin_img'] = $row_cs['admin_img']; $_SESSION['fb_app_id'] = $row_cs['fb_app_id']; $_SESSION['twitter_app_id'] = $row_cs['twitter_app_id']; $_SESSION['linkedin_app_id'] = $row_cs['linkedin_app_id']; header("location:index.php"); exit; } else {
} else { if (trim($_POST['password']) != trim($_POST['password-r'])) { $err[] = "Please enter the same password"; } else { $select_login_query = "select count(*) as admin_cnt from cs_sites where admin_password='******'old_password']) . "' and id='" . $_SESSION['admin_id'] . "'"; $select_login = re_db_query($select_login_query); $fetch_login = re_db_fetch_array($select_login); if ($fetch_login['admin_cnt'] == '0') { $err[] = "Your old password doesn't match."; } } } } if (count($err) == 0) { $update_login_query = "UPDATE `cs_sites` SET `admin_password` = '" . md5($_POST['password']) . "' WHERE id='" . $_SESSION['admin_id'] . "'"; re_db_query($update_login_query); $_SESSION['msg'] = "2"; header("Location:change_password.php"); exit; } } if (isset($_SESSION['msg']) && $_SESSION['msg'] == "2") { $msg = "Password changed successfully."; unset($_SESSION['msg']); } include "header.php"; ?> <div class="chat-sidebar" id="chat"> <div class="chat-sidebar-content"> <header class="chat-sidebar-header"> <h4 class="chat-sidebar-title">Contacts</h4>
<?php include "include/config.php"; if (!isset($_SESSION['admin_id'])) { header("location:login.php"); exit; } $fb_data_qry = "select * from cs_fb_share_users where member_id='" . mysql_real_escape_string($_GET['mid']) . "' and client_id='" . $_SESSION['admin_id'] . "' "; $fb_data_sql = re_db_query($fb_data_qry); $li_data_qry = "select lid.*, csu.email from cs_li_data as lid, cs_users as csu where csu.id=lid.member_id and csu.client_id='" . $_SESSION['admin_id'] . "' and member_id='" . mysql_real_escape_string($_GET['mid']) . "' "; $li_data_sql = re_db_query($li_data_qry); $gp_data_qry = "select * from cs_gp_users where member_id='" . mysql_real_escape_string($_GET['mid']) . "' and client_id='" . $_SESSION['admin_id'] . "' "; $gp_data_sql = re_db_query($gp_data_qry); include "header.php"; ?> <div class="content-wrap"> <!-- main page content. the place to put widgets in. usually consists of .row > .col-md-* > .widget. --> <main id="content" class="content" role="main"> <ol class="breadcrumb"> <li>YOU ARE HERE</li> <li class="active">User Profile</li> </ol> <h1 class="page-title">User - <span class="fw-semi-bold">Profile</span></h1> <div class="row"> <div class="col-md-12"> <section class="widget"> <header> <h4>User's FB <small>Profile</small></h4> <div class="widget-controls"> <a data-widgster="expand" title="Expand" href="#"><i class="glyphicon glyphicon-chevron-up"></i></a> <a data-widgster="collapse" title="Collapse" href="#"><i class="glyphicon glyphicon-chevron-down"></i></a>
<?php if (isset($_SESSION['admin_type']) && $_SESSION['admin_type'] == "master") { $chl_app_sql = re_db_query("select * from cs_sites where is_approved='0'"); $tot_app = re_db_num_rows($chl_app_sql); } ?> <!DOCTYPE html> <html> <head> <title>Coupay Social - Dashboard</title> <link href="css/application.min.css" rel="stylesheet"> <!-- as of IE9 cannot parse css files with more that 4K classes separating in two files --> <!--[if IE 9]> <link href="css/application-ie9-part2.css" rel="stylesheet"> <![endif]--> <link rel="shortcut icon" href="img/favicon.png"> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no"> <meta name="description" content=""> <meta name="author" content=""> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <script> /* yeah we need this empty stylesheet here. It's cool chrome & chromium fix chrome fix https://code.google.com/p/chromium/issues/detail?id=167083 https://code.google.com/p/chromium/issues/detail?id=332189 */ </script> <script type="text/javascript" language="javascript"> var sitepath='http://www.coupay.com.sg/';
header("location:login.php"); exit; } $select_cu = "select email from cs_users where id='" . mysql_real_escape_string($_GET['mid']) . "'"; $res_cu = re_db_query($select_cu); $row_cu = re_db_fetch_array($res_cu); $fb_data_qry = "select * from cs_fb_share_users where member_id='" . mysql_real_escape_string($_GET['mid']) . "' and client_id='" . $_SESSION['admin_id'] . "' "; $fb_data_sql = re_db_query($fb_data_qry); $li_data_qry = "select lid.*, csu.email from cs_li_data as lid, cs_users as csu where csu.id=lid.member_id and csu.client_id='" . $_SESSION['admin_id'] . "' and member_id='" . mysql_real_escape_string($_GET['mid']) . "' "; $li_data_sql = re_db_query($li_data_qry); $gp_data_qry = "select * from cs_gp_users where member_id='" . mysql_real_escape_string($_GET['mid']) . "' and client_id='" . $_SESSION['admin_id'] . "' "; $gp_data_sql = re_db_query($gp_data_qry); $yh_data_qry = "select * from cs_yahoo_data where member_id='" . mysql_real_escape_string($_GET['mid']) . "' and client_id='" . $_SESSION['admin_id'] . "' "; $yh_data_sql = re_db_query($yh_data_qry); $ig_data_qry = "select * from cs_ig_data where member_id='" . mysql_real_escape_string($_GET['mid']) . "' and client_id='" . $_SESSION['admin_id'] . "' "; $ig_data_sql = re_db_query($ig_data_qry); $is_profile = 0; if (re_db_num_rows($fb_data_sql) > 0 || re_db_num_rows($gp_data_sql) > 0 || re_db_num_rows($li_data_sql) > 0 || re_db_num_rows($yh_data_sql) > 0 || re_db_num_rows($ig_data_sql) > 0) { $is_profile = 1; $fb_data_rec = re_db_fetch_array($fb_data_sql); $li_data_rec = re_db_fetch_array($li_data_sql); $gp_data_rec = re_db_fetch_array($gp_data_sql); $yh_data_rec = re_db_fetch_array($yh_data_sql); $ig_data_rec = re_db_fetch_array($ig_data_sql); if ($fb_data_rec['profile_pic']) { $profle_pic = $fb_data_rec['profile_pic']; } else { if ($li_data_rec['pictureUrl']) { $profle_pic = $li_data_rec['pictureUrl']; } else { if ($gp_data_rec['profile_pic']) {
$error[] = "Please enter proper icon height."; } } $disabled = ""; } if (count($error) <= 0) { $u_update = "update cs_sites set \n icon_size='" . $icon_size . "', \n req_custom='" . $req_custom . "', \n custom_icon_size='" . $custom_icon_size . "' \n where id='" . $_SESSION['admin_id'] . "'"; re_db_query($u_update); $_SESSION['msg'] = "update"; header("location:social_icon_setting.php"); exit; } } if (!isset($_POST['update'])) { $site_data_qry = "select * from cs_sites where id='" . $_SESSION['admin_id'] . "'"; $site_data_sql = re_db_query($site_data_qry); if (re_db_num_rows($site_data_sql) > 0) { $site_data_rec = re_db_fetch_array($site_data_sql); $icon_size = $site_data_rec['icon_size']; $req_custom = $site_data_rec['req_custom']; $custom_icon_size = $site_data_rec['custom_icon_size']; $is_size_approved = $site_data_rec['is_size_approved']; if ($req_custom == "1") { $custom_icon_size_arr = explode('x', $custom_icon_size); $icon_w = $custom_icon_size_arr[0]; $icon_h = $custom_icon_size_arr[1]; $disabled = ""; } } } if (isset($_SESSION['msg']) && $_SESSION['msg'] == "update") {
} } } } } } if ($_POST['gender'] != '') { if ($_POST['gender'] == '1' || $_POST['gender'] == '2') { $select_fb_main .= $_POST['gender'] == '1' ? " and gender='male' " : " and gender='female'"; } if ($_POST['gender'] == '3') { $select_fb_main .= " and gender not in ('male','female')"; } } $sel_tlp = "select page_title,id,fb_page_id,cp.total from cs_like_pages cl join (select count(*) as total,page_id from cs_member_pages_like cpl join (select member_id,birthday,gender from cs_fb_share_users where client_id='" . $_SESSION['admin_id'] . "' " . $select_fb_main . ") as cup on cup.member_id=cpl.member_id where cpl.client_id='" . $_SESSION['admin_id'] . "' group by page_id) as cp on cp.page_id=cl.id order by total desc,page_title asc limit 10"; $res_tlp = re_db_query($sel_tlp); $total = re_db_num_rows($res_tlp); ?> <section class="widget"> <header> <h4><?php echo $title_1; ?> <small><?php echo $title_2; ?> </small> <span id="total_shares"></span></h4> <div class="widget-controls"> <a data-widgster="close" title="Close" href="#"><i class="glyphicon glyphicon-remove"></i></a> </div> </header>
$social_rec = re_db_fetch_array($social_sql); if (($btn_style == "1" || $btn_style == "2") && $social_rec['short_name'] == "li") { $img_div .= '<img style="float: left; margin-right: 5px; " src="' . SITE_URL . 'img/social_icon/' . $social_rec['short_name'] . '_share_icon_' . $counter_type . '.jpg" alt="" title="" />'; } else { $img_div .= '<img style="float: left; margin-right: 5px; " src="' . SITE_URL . 'img/social_icon/' . $social_rec['short_name'] . '_share_btn_' . $counter_type . '.jpg" alt="" title="" />'; } $social_div .= '<div style="margin-bottom: 5px;"> <input type="checkbox" name="share_button[' . $i . ']" id="share_button_' . $i . '" value="' . $val . '" checked="checked" onclick="call_manage_display()" /> ' . $social_rec['social_name'] . ' <span style="float: right;"> <a href="javascript:void(0);" onclick="call_ordering(\'' . $i . '\',\'up\')">up</a> <a href="javascript:void(0);" onclick="call_ordering(\'' . $i . '\',\'down\')">down</a> </span> <input type="hidden" name="short_order[' . $i . ']" id="short_order_' . $i . '" value="' . $i . '" /> </div>'; } } $social_sql = re_db_query("select * from cs_social_network_master where social_id not in ('" . implode("','", $new_social_arr) . "') and is_display='1'"); if (re_db_num_rows($social_sql) > 0) { while ($social_rec = re_db_fetch_array($social_sql)) { $i++; $social_div .= '<div style="margin-bottom: 5px;"> <input type="checkbox" name="share_button[' . $i . ']" id="share_button_' . $i . '" value="' . $social_rec['social_id'] . '" onclick="call_manage_display()" /> ' . $social_rec['social_name'] . ' <span style="float: right;"> <a href="javascript:void(0);" onclick="call_ordering(\'' . $i . '\',\'up\')">up</a> <a href="javascript:void(0);" onclick="call_ordering(\'' . $i . '\',\'down\')">down</a> </span> <input type="hidden" name="short_order[' . $i . ']" id="short_order_' . $i . '" value="' . $i . '" /> </div>'; } } $social_div .= '<input type="hidden" name="odr_id" id="odr_id" value="" /> <input type="hidden" name="odr_type" id="odr_type" value="" /> <input type="hidden" name="total_social" id="total_social" value="4" />';
<?php include "include/config.php"; if (!isset($_SESSION['admin_id'])) { header("location:login.php"); exit; } $select_all = "select * from cs_fb_share_users where uid='" . mysql_real_escape_string($_GET['uid']) . "' and client_id='" . $_SESSION['admin_id'] . "' "; $res_data = re_db_query($select_all); $row_data = re_db_fetch_array($res_data); //echo"<pre>"; print_r($row_data); echo"</pre>"; include "header.php"; ?> <div class="content-wrap"> <!-- main page content. the place to put widgets in. usually consists of .row > .col-md-* > .widget. --> <main id="content" class="content" role="main"> <ol class="breadcrumb"> <li>YOU ARE HERE</li> <li class="active">User Profile</li> </ol> <h1 class="page-title">User - <span class="fw-semi-bold">Profile</span></h1> <div class="row"> <div class="col-md-12"> <section class="widget"> <header> <h4>User <small>Details</small></h4> <div class="widget-controls"> <a data-widgster="expand" title="Expand" href="#"><i class="glyphicon glyphicon-chevron-up"></i></a> <a data-widgster="collapse" title="Collapse" href="#"><i class="glyphicon glyphicon-chevron-down"></i></a> <a data-widgster="close" title="Close" href="#"><i class="glyphicon glyphicon-remove"></i></a> </div>
, color: "<?php echo $color_arr[$i]; ?> ", subs: [ <?php $j = 0; $sub_fb_main = "select count(*) as total, 'Facebook' as Provider, relationship_status from cs_fb_share_users where reg_on is not null and reg_on!='0000-00-00 00:00:00' and relationship_status='" . $main_rec['relation'] . "' and client_id='" . $_SESSION['admin_id'] . "' " . $select_main . " group by relationship_status"; $sub_gp_main = "select count(*) as total, 'Google+' as Provider, relationship_status from cs_gp_users where reg_on is not null and reg_on!='0000-00-00 00:00:00' and relationship_status='" . $main_rec['relation'] . "' and client_id='" . $_SESSION['admin_id'] . "' " . $select_main . " group by relationship_status"; $sub_li_main = "select count(*) as total, 'LinkedIn' as Provider, '' as relationship_status from cs_li_data where reg_on is not null and reg_on!='0000-00-00 00:00:00' and client_id='" . $_SESSION['admin_id'] . "' " . $select_main . " group by relationship_status HAVING relationship_status='" . $main_rec['relation'] . "'"; $sub_yh_main = "select count(*) as total, 'Yahoo' as Provider, '' as relationship_status from cs_yahoo_data where reg_on is not null and reg_on!='0000-00-00 00:00:00' and client_id='" . $_SESSION['admin_id'] . "' " . $select_main . " group by relationship_status HAVING relationship_status='" . $main_rec['relation'] . "'"; $sub_ig_main = "select count(*) as total, 'Instagram' as Provider, '' as relationship_status from cs_ig_data where reg_on is not null and reg_on!='0000-00-00 00:00:00' and client_id='" . $_SESSION['admin_id'] . "' " . $select_main . " group by relationship_status HAVING relationship_status='" . $main_rec['relation'] . "'"; $sub_main_qry = $sub_fb_main . " union all " . $sub_gp_main . " union all " . $sub_li_main . " union all " . $sub_yh_main . " union all " . $sub_ig_main; //$sub_main_qry=$sub_fb_main." union all ".$sub_gp_main; $sub_main_sql = re_db_query($sub_main_qry); $sub_total = re_db_num_rows($sub_main_sql); while ($sub_main_rec = re_db_fetch_array($sub_main_sql)) { $j++; ?> { type: "<?php echo $sub_main_rec['Provider']; ?> ", percent: <?php echo $sub_main_rec['total']; ?> }<?php if ($j < $tot_rec) { ?> ,<?php }
function re_db_delete($tb, $where = "") { $query .= "DELETE FROM " . $tb . " "; if (isset($where) && $where != "") { $query .= "WHERE " . $where; } $rec = re_db_query($query); }