Buy WCoins on IGCN S6EP3 Databases (SQL 2012)

[KarLi]

Hi, well i use that module by jacubb called "super rewards"
and it works fine on s6ep3 SCFMT databases on buying wcoins because
the database contains WCoinC column in MEMB_INFO

but the premium s6ep3 files have the WCoin in different table which is T_InGameShop_Point .

so in the superreward .php files its configured to connect to memb_info still i have tried few things but it
hasn't work, here are the configs:

superrewards.php

<?php
  $getid = mssql_query("SELECT memb_guid from MEMB_INFO where memb___id = '".$user_auth_id."'");
  $getid = mssql_fetch_row($getid);  
?>

<iframe src="https://www.superrewards-offers.com/super/offers?h=mlprkypopuoXXXXXXXXXXX&uid=<?=$getid[0]?>" frameborder="0" width="700" height="250" scrolling="no"></iframe>

donate_proceed.php

<?php

$dbhost     = "(local)"; //Your database domain
$dbuser     = "sa"; //Database username
$dbpassword = "tutorials"; //Database password
$db         = "MuOnline"; //Database name

$conn = mssql_connect($dbhost, $dbuser, $dbpassword);
mssql_select_db($db);

if ($core["debug"] == "1")
{
	ini_set("display_errors", "On");
	error_reporting(E_ERROR | E_WARNING | E_PARSE);
}
 else 
{
	ini_set("display_errors", "Off");
	error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED & ~E_WARNING);
}
 
$SECRET = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";   ///this is you apps secret key get this from app info
$snuid = $_REQUEST['uid'];      // this grabs the snuid from the url
$currency = $_REQUEST['new'];   // this grabs amount of points to award user
$total = $_REQUEST['total'];     // this grabs total points super rewards has ever sent user
$offerwallID = $_REQUEST['oid'];// this grabs the offer walls offer ID
$transactionID = $_REQUEST['id'];//this grabs the taransaction id from super rewards
$sidverify = $_REQUEST['sig'];  // this grabs the hashed info for you to authenticate with

// Sanity check.
if(!(is_numeric($transactionID) && is_numeric($snuid) && is_numeric($offerwallID) && is_numeric($currency) && is_numeric($total)))
	exit('0'); // Fail.
  
$return_value = 1;

// make  a hash of our own to verify authenicc transaction
$sig = md5($_REQUEST['id'] . ':' . $_REQUEST['new'] . ':' . $_REQUEST['uid'] . ':' . $SECRET);
 
//here we are gonna count the total points loged each time user has recived points
$sql = "SELECT SUM(wcoin) FROM MUCore_SuperRewards WHERE memb_guid='".$snuid."'";

if( !($result = mssql_query($sql)) ) 
{
    die('Failed to run query.');
    $return_value = 0;
}
else
{
  $return_value = 1;
}

$row = mssql_fetch_row($result);
$DeadWeight = $row[0]; 

// You may want to add other checks to ensure that the user exists in your system

//Check if hashed info is same as hashed info from superrewards if not do nothing.
if  ($sidverify == $sig)
{
  $getid = mssql_query("SELECT memb___id from MEMB_INFO where memb_guid = '".$snuid."'");
  $userid = mssql_fetch_array($getid);
 //Insert Super Rewards transaction info into your database
  mssql_query("INSERT INTO MUCore_SuperRewards(memb_guid, memb___id, transID, wcoin, wcoin_total, offerwallID, date) VALUES($snuid,'$userid[0]',$transactionID,$currency,$total,$offerwallID,".CURRENT_TIMESTAMP.")");
  //Check if the total amount of points awarded to users is less then or the same as total from super rewards
  //This will make sure you dont give more then you should.
  if  ($DeadWeight <= $total)
  {
    //If all is good Update the user with there points from the url request.
    mssql_query("UPDATE MEMB_INFO SET WCoin = WCoin + ".$currency." WHERE memb___id = '".$userid[0]."'");
    //Send event to the player [Silent Mafia Edit]
    //Send_Event($snuid, "You have been credited ".$currency." points for completing a offer");
  }
}
else
{
  $return_value = 0;
}

mssql_close($conn);
echo $return_value;
   
?>

If anyone has any idea what has to be changed exactly that'd be helpful
or any other module for buying wcoins with IGCN s6ep3 premium files.

PS: There is same issue with DMN Vote Reward it rewards on memb_info i guess, but nto sure i changed tables it might be different there.


Thanks.

[MentaL]

[thanhdia]

try change

mssql_query("UPDATE MEMB_INFO SET WCoin = WCoin + ".$currency." WHERE memb___id = '".$userid[0]."'");

to:

mssql_query("UPDATE T_InGameShop_Point SET WCoinC = WCoinC + ".$currency." WHERE AccountID = '".$userid[0]."'");