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);
}
