Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 19:34

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



can any1 help with this php/sql updateing script

Discussion on can any1 help with this php/sql updateing script within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2009
Posts: 77
Received Thanks: 20
can any1 help with this php/sql updateing script

edited to fixed the verification thanks to tylor but now it verafys the points above 3 if you have 0 points and input 2 to deduct it and it still deducts the 2 from account leaveing a negative number in point field.. any idea how ta fix that part?? BTW this script now works with the edited Red wrighting also need the corect sql quary and the index page if any are interested in them just let me know ill post them.
Code:
<?php
$UserID = trim($_POST['UserID']);
$Points = trim ($_POST['Points']);

// Connection with MSSQL server

$conn=mssql_connect('Server','ServerID','ServerPass');
$db = mssql_select_db('PS_UserData',$conn) or die("MSSQL Conection Error!");
		$res = mssql_query("SELECT Point FROM  PS_UserData.dbo.Users_Master WHERE (UserID) = ('".$UserID."')"); 
		if ("[COLOR="Red"]$res[/COLOR]" < $Points)
		{
			echo "<b>Not enufe DP to Prosead</b><br>";
			}
			else
		{	
		$res1 = mssql_query("SELECT UserID FROM  PS_UserData.dbo.Users_Master WHERE (UserID) = ('".$UserID."')"); 
	
		if (mssql_num_rows($res1)) 
	{
				// Insert Start
					$query1 = "exec PS_GMTool.dbo.usp_DeleatePoints '".$UserID."','".$Points."'";
			$rresult1 = mssql_query($query1) or die("account dose not exist");
					{
							echo "<b>Successfully deleated  $Points Donation Points From $UserID account</b><br>";
					}
	}
else
	{
	echo '<b>Account dosent exist.</b>'; 
	}
	}
?>

i am not shure what i did wrong on the verafying that points in db is not less then points deducted when quary executes i got it ta makeshure account exists but cant get the point verification part to work can any1 plzz tell me were and what to add TY in advance
ac1dtab is offline  
Reply


Similar Threads Similar Threads
any1 got PHP script for online users,top pk top pvp?
08/30/2010 - Dekaron Private Server - 7 Replies
If yes pls sent me :D
WTS/WTT some acc's *Updateing every buy/trade/sell*
03/19/2010 - Silkroad Online Trading - 5 Replies
Some chars are out for trade or sale. If il trade il prefer (Eldorado server) but offer me and we will see =) I can trade all the chars for 1 GOOD one, (server doesnt matter) Wizz/cleric lvl97 - Scammed by Lukas- [email protected] & [email protected] S/s Fire nuker - Eldorado ------------------------ lvl 97 0.30%(still lvling)
can any1 make new adresses for 12sky2 for CheatEngine script
11/16/2009 - 12Sky2 - 1 Replies
ok guys any can post here new adresses for 12sky2 cuz trainer dont work like old adresses for cheatengine. pls post here new adresses for speed atack and speed movement hack for CheatenginE gl and ty who post here :):handsdown::handsdown::handsdown::handsdown:
any1 know the web of script vessel?
07/04/2008 - Conquer Online 2 - 1 Replies
any1 can help me to dowloand script vessel? thanks.
What I have Foud still needs updateing
10/15/2007 - Archlord - 2 Replies
ok I did a little snooping around and I found that the main EXE sends a CRC AND a ADLER32 check AND a BLOWFISH :eek: ADLER32 :: 0001BEAC :: 0041BEAC The reference is above. BLOWFISH :: 00030460 :: 00430460 The reference is above. CryptCreateHash :: 00024014 :: 00424014 Referenced (Hash: MD5) at 00416B19 Referenced (Hash: MD5) at 00416BD9 CryptDecrypt :: 00024010 :: 00424010



All times are GMT +1. The time now is 19:35.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.