How i can Add Silk for New Register users ?
Printable View
How i can Add Silk for New Register users ?
in PHP for register page.
Like he said you , you make a registration script which give 10 000 silks
Go to Stored Procedures >> _AddNewChar like the image and add my lines in this place :-
http://img803.imageshack.us/img803/9076/48993953.png
Lines:-
500 is 500 silk (you can edit whatever you like)Code:IF not exists (SELECT JID FROM SRO_VT_ACCOUNT.dbo.SK_Silk WHERE JID = (SELECT UserJID FROM _User WHERE CharID = @NewCharID))
BEGIN
Declare @JID INT;
SELECT @JID = UserJID FROM _User WHERE CharID = @NewCharID
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk SELECT @JID,500,0,0
END
good Luck ;)
Thanks arabianfox & LogiN for Help Working Now With arabianfox idea