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('۰', '۱', '۲', '۳', '۴', '۵', '۶', '۷', '۸', '۹');
// 2. Arabic HTML decimal
$arabicDecimal = array('٠', '١', '٢', '٣', '٤', '٥', '٦', '٧', '٨', '٩');
// 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);
}
?>