Initiate Mage
- Joined
- Feb 17, 2015
- Messages
- 5
- Reaction score
- 1
Hello, I have the files from https://forum.ragezone.com/f853/simple-php-register-script-1049880/
And I'd like to know how to also add cash for the item shop when I register on my website please ?
The SQL query for adding cash is this :
USE [DNMembership]
GO
DECLARE return_value int
EXEC return_value = [dbo].[P_ModCashBalance]
@nvcAccountName = N'USERNAME', IntCashBalance = 999999999
SELECT 'Return Value' = return_value
GO
How to execute it via php in the same files when registering please ?
Thank you
Thanks to @OuTDooR
sqlsrv_query($conn, "INSERT INTO dnmembership.dbo.Accounts (AccountName, AccountLevelCode, GameOption, CharacterCreateLimit, LastCharacterCreateDate, CharacterMaxCount, LastLoginDate, LastLogoutDate, LastLoginIP, LastSessionID, JoinIP, RegisterDate, PublisherCode, GenderCode, BirthDate, Passphrase, NationalityCode, ChannelPartnerCode, NewbieRewardFlag,SecondAuthLockFlag)VALUES ('$Username','99', NULL,'4', NULL,
'4', null, NULL, null,
null, null, GETDATE(), '4', null,
null, (SELECT HashBytes('MD5','$Password')), null, NULL,'true', CAST(0 AS bit)) DECLARE return_value int
EXEC return_value = [dbo].[P_ModCashBalance]
@nvcAccountName = N'$Username', IntCashBalance = 999999999
SELECT 'Return Value' = return_value") or die("That account already exists, try a different username.");
And I'd like to know how to also add cash for the item shop when I register on my website please ?
The SQL query for adding cash is this :
USE [DNMembership]
GO
DECLARE return_value int
EXEC return_value = [dbo].[P_ModCashBalance]
@nvcAccountName = N'USERNAME', IntCashBalance = 999999999
SELECT 'Return Value' = return_value
GO
How to execute it via php in the same files when registering please ?
Thank you
Thanks to @OuTDooR
sqlsrv_query($conn, "INSERT INTO dnmembership.dbo.Accounts (AccountName, AccountLevelCode, GameOption, CharacterCreateLimit, LastCharacterCreateDate, CharacterMaxCount, LastLoginDate, LastLogoutDate, LastLoginIP, LastSessionID, JoinIP, RegisterDate, PublisherCode, GenderCode, BirthDate, Passphrase, NationalityCode, ChannelPartnerCode, NewbieRewardFlag,SecondAuthLockFlag)VALUES ('$Username','99', NULL,'4', NULL,
'4', null, NULL, null,
null, null, GETDATE(), '4', null,
null, (SELECT HashBytes('MD5','$Password')), null, NULL,'true', CAST(0 AS bit)) DECLARE return_value int
EXEC return_value = [dbo].[P_ModCashBalance]
@nvcAccountName = N'$Username', IntCashBalance = 999999999
SELECT 'Return Value' = return_value") or die("That account already exists, try a different username.");