ok i created a few db quarys that work perfect from deleating dp to adding db by userid and help from tyler got me a good item gift quary that gose by charname and item numbers now to my problem.. i execute this php with a index page that fills in item id account id and charname and count it all activates perfect here is the script
and here is outcome
now problem even tho it al looks good is when you check the db the points were not actyaly deducted any idea what i can do to creat the php script
actyaly take the value in the count table and turn it into the $Points value or am i doing it corect and its just not inputing the corect info in corect spots to deduct the points or anything else i may have messed up or missed.
Code:
<?php
$CharName = trim($_POST['CharName']);
$ItemID = trim ($_POST['ItemID']);
$Count = trim ($_POST['Count']);
$UserID = trim($_POST['UserID']);
// Connection with MSSQL server
$conn=mssql_connect('xxx','xxx','xxx');
$db = mssql_select_db('PS_UserData',$conn) or die("MSSQL Conection Error!");
$res = mssql_query("SELECT UserID FROM PS_UserData.dbo.Users_Master WHERE (UserID) = ('".$UserID."')");
if (mssql_num_rows($res))
// Insert Start
{
if($ItemID = "1001" and $count = "1")
$Points="200";}
$query1 = "exec PS_GMTool.dbo.usp_DeleatePoints' ".$UserID."','".$Points."'";
$rresult1 = mssql_query($query1) or die("Create GameAccountTBL Error!");
{echo "points deducted $UserID $Points";}
$query2 = "exec PS_GMTool.dbo.usp_GiftBox '".$CharName."','".$ItemID."','".$Count."'";
$rresult1 = mssql_query($query2) or die("Create GameAccountTBL Error!");
{echo "The item was Baught successfully.<br /><br /><b>User:</b> $CharName<br><b>Item:</b> $ItemID<br><b>Count:</b> $Count <br><b>Account:</b> $UserID<br> <b>Points deducted:</b> $Points<br>";}
?>
Code:
points deducted admin 200 The item was Baught successfully. User: DASH Item: 1001 Count: 1 Account: admin Points deducted: 200
actyaly take the value in the count table and turn it into the $Points value or am i doing it corect and its just not inputing the corect info in corect spots to deduct the points or anything else i may have messed up or missed.