<?php
include "include/config.php";
if (!isset($_SESSION['admin_id'])) {
header("location:login.php");
exit;
}
$err = array();
$get_banner = "SELECT lis.*, lid.firstname, lid.lastname from `cs_li_share` as lis, cs_users as csu, `cs_li_data` as lid WHERE lis.member_id=csu.id and lid.member_id=lis.member_id and csu.client_id='" . $_SESSION['admin_id'] . "' ";
if (isset($_GET['header_search']) && $_GET['header_search'] != '') {
$get_banner .= " and (lis.share_url like '%" . re_db_input($_GET['header_search']) . "%' || lid.firstname like '%" . re_db_input($_GET['header_search']) . "%' || lid.lastname like '%" . re_db_input($_GET['header_search']) . "%')";
}
if (isset($_GET['orderby']) && $_GET['orderby'] != '' && isset($_GET['order']) && $_GET['order'] == "asc") {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " " . $_GET['order'];
} else {
if (isset($_GET['orderby']) && $_GET['orderby'] != '') {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " desc";
} else {
$get_banner .= " ORDER BY id desc";
}
}
$extralink = re_get_all_get_params(array('action', 'pageno', 'msg'));
$href_url = "lishares.php";
$search_record = pagination($get_banner, $href_url, $extralink, isset($_GET['pageno']) ? $_GET['pageno'] : 0, $rec_per_page = 20, $style = '', $separator = '|', $get_var = 'pageno', $show_first_last_link = true);
$res_banner = $search_record[0];
$showingpage = $search_record[1];
include "header.php";
?>
<div class="chat-sidebar" id="chat">
<div class="chat-sidebar-content">
<header class="chat-sidebar-header">
<?php
include "include/config.php";
if (!isset($_SESSION['admin_id'])) {
header("location:login.php");
exit;
}
$err = array();
$get_banner = "SELECT fbs.*, csu.id as memb_id from `cs_fb_share` as fbs, `cs_users` as csu WHERE csu.id=fbs.member_id and csu.client_id='" . $_SESSION['admin_id'] . "' ";
if (isset($_GET['header_search']) && $_GET['header_search'] != '') {
$get_banner .= " and (fbs.url like '%" . re_db_input($_GET['header_search']) . "%' || fbs.uname like '%" . re_db_input($_GET['header_search']) . "%' )";
}
if (isset($_GET['orderby']) && $_GET['orderby'] != '' && isset($_GET['order']) && $_GET['order'] == "asc") {
$get_banner .= " ORDER BY fbs." . $_GET['orderby'] . " " . $_GET['order'];
} else {
if (isset($_GET['orderby']) && $_GET['orderby'] != '') {
$get_banner .= " ORDER BY fbs." . $_GET['orderby'] . " desc";
} else {
$get_banner .= " ORDER BY fbs.id desc";
}
}
$extralink = re_get_all_get_params(array('action', 'pageno', 'msg'));
$href_url = "fbshares.php";
$search_record = pagination($get_banner, $href_url, $extralink, isset($_GET['pageno']) ? $_GET['pageno'] : 0, $rec_per_page = 20, $style = '', $separator = '|', $get_var = 'pageno', $show_first_last_link = true);
$res_banner = $search_record[0];
$showingpage = $search_record[1];
include "header.php";
?>
<div class="chat-sidebar" id="chat">
<div class="chat-sidebar-content">
<header class="chat-sidebar-header">
<?php
include "include/config.php";
if (!isset($_SESSION['admin_id'])) {
header("location:login.php");
exit;
}
$is_from_arr = array("Facebook", "Facebook", "LinkedIn", "Google+", "Twitter");
$err = array();
$get_banner = "SELECT ot.*, csu.email 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.client_id='" . $_SESSION['admin_id'] . "' ";
if (isset($_GET['header_search']) && $_GET['header_search'] != '') {
$get_banner .= " and (order_id like '%" . re_db_input($_GET['header_search']) . "%' || order_amt like '%" . re_db_input($_GET['header_search']) . "%'|| email like '%" . re_db_input($_GET['header_search']) . "%' )";
}
if (isset($_GET['orderby']) && $_GET['orderby'] != '' && isset($_GET['order']) && $_GET['order'] == "asc") {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " " . $_GET['order'];
} else {
if (isset($_GET['orderby']) && $_GET['orderby'] != '') {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " desc";
} else {
$get_banner .= " ORDER BY id desc";
}
}
$extralink = re_get_all_get_params(array('action', 'pageno', 'msg'));
$href_url = "cs_track_orders.php";
$search_record = pagination($get_banner, $href_url, $extralink, isset($_GET['pageno']) ? $_GET['pageno'] : 0, $rec_per_page = 20, $style = '', $separator = '|', $get_var = 'pageno', $show_first_last_link = true);
$res_banner = $search_record[0];
$showingpage = $search_record[1];
include "header.php";
?>
<div class="content-wrap">
<!-- main page content. the place to put widgets in. usually consists of .row > .col-md-* > .widget. -->
<?php
include "include/config.php";
if (!isset($_SESSION['admin_id'])) {
header("location:login.php");
exit;
}
$is_from_arr = array("", "Facebook", "LinkedIn", "Twitter");
$err = array();
$get_banner = "SELECT sc.*, csu.email from `cs_share_clicked` as sc, `cs_users` as csu WHERE csu.id=sc.shared_by and csu.client_id='" . $_SESSION['admin_id'] . "' ";
if (isset($_GET['header_search']) && $_GET['header_search'] != '') {
$get_banner .= " and (url like '%" . re_db_input($_GET['header_search']) . "%' || email like '%" . re_db_input($_GET['header_search']) . "%' || clicked_by like '%" . re_db_input($_GET['header_search']) . "%' )";
}
if (isset($_GET['orderby']) && $_GET['orderby'] != '' && isset($_GET['order']) && $_GET['order'] == "asc") {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " " . $_GET['order'];
} else {
if (isset($_GET['orderby']) && $_GET['orderby'] != '') {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " desc";
} else {
$get_banner .= " ORDER BY id desc";
}
}
$extralink = re_get_all_get_params(array('action', 'pageno', 'msg'));
$href_url = "shareclicks.php";
$search_record = pagination($get_banner, $href_url, $extralink, isset($_GET['pageno']) ? $_GET['pageno'] : 0, $rec_per_page = 20, $style = '', $separator = '|', $get_var = 'pageno', $show_first_last_link = true);
$res_banner = $search_record[0];
$showingpage = $search_record[1];
include "header.php";
?>
<div class="chat-sidebar" id="chat">
<div class="chat-sidebar-content">
$email = "";
if (isset($_POST['update_account']) && $_POST['update_account'] == "Update Account") {
$id = re_db_input($_POST['id']);
$api_key = re_db_input($_POST['api_key']);
$api_secret = re_db_input($_POST['api_secret']);
$firstname = re_db_input($_POST['firstname']);
$lastname = re_db_input($_POST['lastname']);
$site_url = re_db_input($_POST['site_url']);
$site_admin = re_db_input($_POST['site_admin']);
$fb_app_id = re_db_input($_POST['fb_app_id']);
$twitter_app_id = re_db_input($_POST['twitter_app_id']);
$linkedin_app_id = re_db_input($_POST['linkedin_app_id']);
$gplus_app_id = re_db_input($_POST['gplus_app_id']);
$yahoo_app_id = re_db_input($_POST['yahoo_app_id']);
$yahoo_app_id = re_db_input($_POST['insta_app_id']);
$email = re_db_input($_POST['admin_email']);
if (isset($_POST['firstname']) && $_POST['firstname'] == "") {
$error[] = "Please enter first name.";
}
if (isset($_POST['lastname']) && $_POST['lastname'] == "") {
$error[] = "Please enter last name.";
}
if (isset($_POST['site_url']) && $_POST['site_url'] == "") {
$error[] = "Please enter site url.";
}
if (isset($_POST['site_admin']) && $_POST['site_admin'] == "") {
$error[] = "Please enter site admin.";
}
/*if(isset($_POST['fb_app_id']) && $_POST['fb_app_id']=="") {
$error[]="Please enter Facebook Application ID.";
}
} else {
/*$insert_into="insert into cs_users set is_ig='1',client_id='".re_db_input($_GET['site_id'])."',ig_id='".$_GET['ig_id']."'";
re_db_query($insert_into);*/
echo "0~" . $_GET['ig_id'] . "~" . $row_user['id'];
/*$member_id=re_db_insert_id();
$insert_into="insert into cs_ig_data ".$set_query.",member_id='".$member_id."',reg_on='".date('Y-m-d H:i:s',mktime(gmdate('H'),gmdate('i'),gmdate('s'),gmdate('m'),gmdate('d'),gmdate('Y')))."'";
re_db_query($insert_into);*/
}
exit;
}
if (isset($_GET['is_from']) && $_GET['is_from'] == '6' && $_GET['action'] != 'notifycs') {
$select_data = "update cs_users set email='" . mysql_real_escape_string($_GET['email']) . "' where ig_id='" . mysql_real_escape_string($_GET['id']) . "' and client_id='" . re_db_input($_GET['siteid']) . "'";
re_db_query($select_data);
$get_ig_data = "update cs_ig_data set email='" . mysql_real_escape_string($_GET['email']) . "' where email is null or email='' and insta_id='" . mysql_real_escape_string($_GET['id']) . "' and client_id='" . re_db_input($_GET['siteid']) . "'";
re_db_query($get_ig_data);
$sel_data = "select full_name,email,member_id from cs_ig_data where insta_id='" . mysql_real_escape_string($_GET['id']) . "' and client_id='" . re_db_input($_GET['siteid']) . "'";
$res_sel = re_db_query($sel_data);
$row_sel = re_db_fetch_array($res_sel);
$inser_logins = "insert into cs_logins (client_id,member_id,date_time,ip,is_from)\n values ('" . mysql_real_escape_string($_GET['siteid']) . "','" . $row_sel['member_id'] . "','" . date('Y-m-d H:i:s', mktime(gmdate('H'), gmdate('i'), gmdate('s'), gmdate('m'), gmdate('d'), gmdate('Y'))) . "','" . $_SERVER['REMOTE_ADDR'] . "','6')";
mysql_query($inser_logins);
$first_last = explode(" ", $row_sel['full_name']);
echo json_encode(array('email' => $row_sel['email'], 'first_name' => $first_last[0], 'last_name' => $first_last[1], 'member_id' => $row_sel['member_id']));
exit;
}
if (isset($_GET['action']) && $_GET['action'] == 'notifycs') {
$reg_on = '';
if (isset($_GET['is_new']) && $_GET['is_new'] == '1') {
$reg_on = ",reg_on='" . date('Y-m-d H:i:s', mktime(gmdate('H'), gmdate('i'), gmdate('s'), gmdate('m'), gmdate('d'), gmdate('Y'))) . "'";
}
if ($_GET['is_from'] == '1') {
$update_cs = "update cs_fb_share_users set site_uid='" . mysql_real_escape_string($_GET['siteUid']) . "' " . $reg_on . " where member_id='" . mysql_real_escape_string($_GET['member_id']) . "'";
<?php
include "include/config.php";
if (!isset($_SESSION['admin_id'])) {
header("location:login.php");
exit;
}
$is_from_arr = array("", "Facebook", "LinkedIn", "Twitter");
$err = array();
$get_banner = "SELECT csr.*, csu.email from `cs_referral` as csr, `cs_users` as csu WHERE csu.id=csr.ref_by and csu.client_id='" . $_SESSION['admin_id'] . "' ";
if (isset($_GET['header_search']) && $_GET['header_search'] != '') {
$get_banner .= " and (reg_user like '%" . re_db_input($_GET['header_search']) . "%' || email like '%" . re_db_input($_GET['header_search']) . "%' )";
}
if (isset($_GET['orderby']) && $_GET['orderby'] != '' && isset($_GET['order']) && $_GET['order'] == "asc") {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " " . $_GET['order'];
} else {
if (isset($_GET['orderby']) && $_GET['orderby'] != '') {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " desc";
} else {
$get_banner .= " ORDER BY id desc";
}
}
$extralink = re_get_all_get_params(array('action', 'pageno', 'msg'));
$href_url = "cs_referral.php";
$search_record = pagination($get_banner, $href_url, $extralink, isset($_GET['pageno']) ? $_GET['pageno'] : 0, $rec_per_page = 20, $style = '', $separator = '|', $get_var = 'pageno', $show_first_last_link = true);
$res_banner = $search_record[0];
$showingpage = $search_record[1];
include "header.php";
?>
<div class="content-wrap">
<!-- main page content. the place to put widgets in. usually consists of .row > .col-md-* > .widget. -->
<?php
include "include/config.php";
if (!isset($_SESSION['admin_id'])) {
header("location:login.php");
exit;
}
$is_from_arr = array("", "Facebook", "LinkedIn", "Twitter");
$err = array();
$get_banner = "SELECT * from `cs_like_unlike` WHERE client_id='" . $_SESSION['admin_id'] . "' ";
if (isset($_GET['header_search']) && $_GET['header_search'] != '') {
$get_banner .= " and (url like '%" . re_db_input($_GET['header_search']) . "%' )";
}
if (isset($_GET['orderby']) && $_GET['orderby'] != '' && isset($_GET['order']) && $_GET['order'] == "asc") {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " " . $_GET['order'];
} else {
if (isset($_GET['orderby']) && $_GET['orderby'] != '') {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " desc";
} else {
$get_banner .= " ORDER BY id desc";
}
}
$extralink = re_get_all_get_params(array('action', 'pageno', 'msg'));
$href_url = "cs_like_unlike.php";
$search_record = pagination($get_banner, $href_url, $extralink, isset($_GET['pageno']) ? $_GET['pageno'] : 0, $rec_per_page = 20, $style = '', $separator = '|', $get_var = 'pageno', $show_first_last_link = true);
$res_banner = $search_record[0];
$showingpage = $search_record[1];
include "header.php";
?>
<div class="content-wrap">
<!-- main page content. the place to put widgets in. usually consists of .row > .col-md-* > .widget. -->
} else {
re_db_query("update cs_sites set is_approved='1' where id='" . $_GET['id'] . "'");
}
$_SESSION['msg'] = "approve";
} else {
if ($_GET['action'] == "unapprove") {
re_db_query("update cs_sites set is_approved='0' where id='" . $_GET['id'] . "'");
$_SESSION['msg'] = "unapprove";
}
}
header("location:cs_approve_client.php");
exit;
}
$client_qry = "SELECT * FROM cs_sites ";
if (isset($_GET['header_search']) && $_GET['header_search'] != '') {
$client_qry .= " WHERE (site_url like '%" . re_db_input($_GET['header_search']) . "%' || admin_email like '%" . re_db_input($_GET['header_search']) . "%' || firstname like '%" . re_db_input($_GET['header_search']) . "%' || lastname like '%" . re_db_input($_GET['header_search']) . "%' )";
}
if (isset($_GET['orderby']) && $_GET['orderby'] != '' && isset($_GET['order']) && $_GET['order'] == "asc") {
$client_qry .= " ORDER BY " . $_GET['orderby'] . " " . $_GET['order'];
} else {
if (isset($_GET['orderby']) && $_GET['orderby'] != '') {
$client_qry .= " ORDER BY " . $_GET['orderby'] . " desc";
} else {
$client_qry .= " ORDER BY is_approved asc";
}
}
$extralink = re_get_all_get_params(array('action', 'id', 'pageno', 'msg'));
$href_url = "cs_approve_client.php";
$search_record = pagination($client_qry, $href_url, $extralink, isset($_GET['pageno']) ? $_GET['pageno'] : 0, $rec_per_page = 20, $style = '', $separator = '|', $get_var = 'pageno', $show_first_last_link = true);
$client_sql = $search_record[0];
$showingpage = $search_record[1];
<?php
include "include/config.php";
if (!isset($_SESSION['admin_id'])) {
header("location:login.php");
exit;
}
$err = array();
$get_banner = "SELECT * from `cs_users` WHERE client_id='" . $_SESSION['admin_id'] . "' ";
if (isset($_GET['header_search']) && $_GET['header_search'] != '') {
$get_banner .= " and email like '%" . re_db_input($_GET['header_search']) . "%' ";
}
if (isset($_GET['orderby']) && $_GET['orderby'] != '' && isset($_GET['order']) && $_GET['order'] == "asc") {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " " . $_GET['order'];
} else {
if (isset($_GET['orderby']) && $_GET['orderby'] != '') {
$get_banner .= " ORDER BY " . $_GET['orderby'] . " desc";
} else {
$get_banner .= " ORDER BY id desc";
}
}
$extralink = re_get_all_get_params(array('action', 'pageno', 'msg'));
$href_url = "fb_share_user.php";
$search_record = pagination($get_banner, $href_url, $extralink, isset($_GET['pageno']) ? $_GET['pageno'] : 0, $rec_per_page = 20, $style = '', $separator = '|', $get_var = 'pageno', $show_first_last_link = true);
$res_banner = $search_record[0];
$showingpage = $search_record[1];
include "header.php";
?>
<div class="chat-sidebar" id="chat">
<div class="chat-sidebar-content">
<header class="chat-sidebar-header">
function addURL($domain)
{
$urls = re_db_select("`urls`", array("`url`"), "`url` = '" . re_db_input($domain) . "'");
if (!$urls) {
re_db_insert("urls", array("url" => re_db_input($domain)));
}
}
