22

✏️ Editing: landing_api.php

<?php
// Start the session
session_start();

?>
 
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-191688555-1"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

gtag('config', 'UA-191688555-1');
</script>

<script async src="https://www.googletagmanager.com/gtag/js?id=G-FK3QG5L16Z"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

gtag('config', 'G-FK3QG5L16Z');
</script>

<script type='text/javascript'>
(function(e,t,n){if(e.snaptr)return;var a=e.snaptr=function()
{a.handleRequest?a.handleRequest.apply(a,arguments):a.queue.push(arguments)};
a.queue=[];var s='script';r=t.createElement(s);r.async=!0;
r.src=n;var u=t.getElementsByTagName(s)[0];
u.parentNode.insertBefore(r,u);})(window,document,
'https://sc-static.net/scevent.min.js');

snaptr('init', '05155d10-d9ae-4f61-9b7f-3530ddd7820a', {
'user_email': '<?php if(isset($_SESSION['cst_email'])){ echo $_SESSION['cst_email']; }else{echo $email;} ?>'
});

snaptr('track', 'PAGE_VIEW');

</script>

<script>
!function(f,b,e,v,n,t,s)
{if(f.fbq)return;n=f.fbq=function(){n.callMethod?
n.callMethod.apply(n,arguments):n.queue.push(arguments)};
if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';
n.queue=[];t=b.createElement(e);t.async=!0;
t.src=v;s=b.getElementsByTagName(e)[0];
s.parentNode.insertBefore(t,s)}(window, document,'script',
'https://connect.facebook.net/en_US/fbevents.js');
fbq('init', '570689050186578');
fbq('track', 'PageView');
</script>
<noscript><img height="1" width="1" style="display:none"
src="https://www.facebook.com/tr?id=570689050186578&ev=PageView&noscript=1"
/></noscript>

// Start the session
//session_start();

date_default_timezone_set('Asia/Riyadh');

//Connection Detail
$dbhost = 'localhost';
$dbuser = 'balubaid_hijaz_ads';
$db = 'balubaid_crmdata';
$dbpass = 'crm963963';
//$id = $_GET['id'];

$link = mysqli_connect($dbhost, $dbuser, $dbpass, $db);
$GLOBALS["link"] = mysqli_connect($dbhost, $dbuser, $dbpass, $db);
$link->set_charset("utf8");
if (!$link) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}

function create_customer($data){

$name = $data['cname'];
$city = $data['city'];
$email = $data['email'];
$phone = $data['mobile'];
$source = $data['source'];

$codequery = "insert into xx_funland_lucky_wheel_customers (name, city, phone, email, source,creation_date) value ('$name','$city','$phone', '$email','$source',now())";

//echo $codequery;

if ($GLOBALS["link"]->query($codequery) === TRUE) {
return '1';    
}else{
return '0';    
}
    
}

function is_existing_customer($data){

$codequery = "select count(id) as cnt from xx_funland_lucky_wheel_customers
where phone = '$data'";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$cnt = $row['cnt'];
}

if($cnt >= 1){$is_existing = '1';}else{$is_existing = '0';}

return $is_existing;
    
}

function get_customer_id($data){

$codequery = "select id from xx_funland_lucky_wheel_customers
where phone = '$data'";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id = $row['id'];
}

return $id;
    
}

function get_customer_details($data){

$codequery = "select * from xx_funland_lucky_wheel_customers
where id = '$data'";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id = $row;
}

return $id;
    
}

function get_prize_details($data){

$codequery = "select * from xx_funland_luckywheel_prize
where prize_code = '$data'";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id = $row;
}

return $id;
    
}

function get_unredeem_prize_details($data){

$codequery = "SELECT * FROM xx_prize_vu 
WHERE win_date > NOW() - INTERVAL 15 DAY
and is_redeemed is null
and game_type = 'Lucky Wheel'
and cst_id = '$data'
limit 0,1";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id = $row;
}

return $id;
    
}

function get_prize_details2($data){

$codequery = "select * from xx_prize_vu
where prize_code = '$data'";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id = $row;
}

return $id;
    
}

function get_last_win_date($data){

$codequery = "select win_date from xx_funland_luckywheel_prize
where cst_id = '$data'";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id = $row['win_date'];
}

return $id;
    
}

function check_unredeem_win($data){

$codequery = "SELECT count(id)cnt FROM xx_funland_luckywheel_prize 
WHERE win_date > NOW() - INTERVAL 15 DAY
and is_redeemed is null
and game_type is null
and cst_id = '$data'";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id = $row['cnt'];
}

if($data == ''){
return 1;    
}else{
return $id;
}
    
}

function add_winning($cst_id,$prize,$source,$prizeCode){
    
    $wdate = date("Y-m-d h:i:sa");

$codequery = "insert into xx_funland_luckywheel_prize (cst_id, prize, win_date,source,prize_code) value ('$cst_id','$prize','$wdate','$source','$prizeCode')";

//echo $codequery;

if ($GLOBALS["link"]->query($codequery) === TRUE) {
return '1';    
}else{
return '0';    
}
    
}

function is_active_session(){

if($_SESSION['active'] == 'Y'){

//ok    
    
}

else{
    
    $newURL = 'https://funlandksa.com/luckywheel/login/';

header('Location: '.$newURL);
}
    
}

function send_sms($data,$message){

$message = urlencode($message);

//echo $message;

$url = "https://www.oursms.net/api/sendsms.php?username=hijazmall&password=123456&message=$message&numbers=$data&sender=FUN%20LAND&unicode=e&Rmduplicated=1&return=json";

//echo $url;

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL,$url);
curl_setopt($ch, CURLOPT_POST, 0);

// In real life you should use something like:
// curl_setopt($ch, CURLOPT_POSTFIELDS, 
//          http_build_query(array('postvar1' => 'value1')));

// Receive server response ...
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

$server_output = curl_exec($ch);

curl_close ($ch);

return $server_output;

}

function send_sms2($data,$message){

$message = urlencode($message);

//echo $message;

$url = "https://www.oursms.net/api/sendsms.php?username=hijazmall&password=123456&message=$message&numbers=$data&sender=FUN%20LAND-AD&unicode=e&Rmduplicated=1&return=json";

//echo $url;

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL,$url);
curl_setopt($ch, CURLOPT_POST, 0);

// In real life you should use something like:
// curl_setopt($ch, CURLOPT_POSTFIELDS, 
//          http_build_query(array('postvar1' => 'value1')));

// Receive server response ...
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

$server_output = curl_exec($ch);

curl_close ($ch);

return $server_output;

}

function get_shorturl($a){

$desturl = $a;

$desturl = urlencode($desturl);    
    
$api_url = "http://1bg.me/api/?api=856d6cdb89543c36c89f998e7dfb8bdcf961adf7&type=1&url=".$desturl;
$result = @json_decode(file_get_contents($api_url),TRUE);
if($result["status"] === 'error') {
return "0";
} else {
return $result["shortenedUrl"];
}
}

function authuser($usr,$pwd){

$codequery = "select * from xx_funland_luckywheel_admin_user where username = '$usr'";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id = $row;
}

if($id['password'] == $pwd){

$_SESSION['UID'] = $id['id'];
$_SESSION['USN'] = $id['username'];
$_SESSION['AUTH'] = 'Y';
$_SESSION['ROLE'] = $id['role'];
 
return 1;    
    
}else{

return 0;    
    
}
    
}

function get_rand_gift(){

$codequery = "SELECT * FROM xx_gifts_rand
where consume = 'N'
ORDER BY RAND()
LIMIT 1";

//echo $codequery;

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id1 = $row;
}

$last_gift_id = $id1['id'];

$codequery = "update xx_gifts_rand set consume = 'Y' where id = '$last_gift_id'";

//echo $codequery;

if ($GLOBALS["link"]->query($codequery) === TRUE) {
//return '1';    
}else{
//return '0';    
}

$codequery = "select count(id)cnt from xx_gifts_rand where consume = 'Y'";

$result = $GLOBALS["link"]->query($codequery);
while($row = $result->fetch_assoc()) {
$id2 = $row;
}

if(($id2['cnt']) == '20'){
    
    
$codequery = "update xx_gifts_rand set consume = 'N'";

//echo $codequery;

if ($GLOBALS["link"]->query($codequery) === TRUE) {
//return '1';    
}else{
//return '0';    
}
    
}

return $id1['degree'];   
    
}

function convert_ar_num($string) {
$newNumbers = range(0, 9);
    // 1. Persian HTML decimal
    $persianDecimal = array('&#1776;', '&#1777;', '&#1778;', '&#1779;', '&#1780;', '&#1781;', '&#1782;', '&#1783;', '&#1784;', '&#1785;');
    // 2. Arabic HTML decimal
    $arabicDecimal = array('&#1632;', '&#1633;', '&#1634;', '&#1635;', '&#1636;', '&#1637;', '&#1638;', '&#1639;', '&#1640;', '&#1641;');
    // 3. Arabic Numeric
    $arabic = array('٠', '١', '٢', '٣', '٤', '٥', '٦', '٧', '٨', '٩');
    // 4. Persian Numeric
    $persian = array('۰', '۱', '۲', '۳', '۴', '۵', '۶', '۷', '۸', '۹');

$string =  str_replace($persianDecimal, $newNumbers, $string);
    $string =  str_replace($arabicDecimal, $newNumbers, $string);
    $string =  str_replace($arabic, $newNumbers, $string);
    return str_replace($persian, $newNumbers, $string);
}

MR SKB