How i can Add Silk for New Register users ?

How i can Add Silk for New Register users ?

in PHP for register page.

Quote:

---

Originally Posted by LogiN

in PHP for register page.

---

I Don't know
I need Any Account Create Start With 10,000 Silk

Like he said you , you make a registration script which give 10 000 silks

Quote:

---

Originally Posted by Mixizi

Like he said you , you make a registration script which give 10 000 silks

---

Can you give me
almost I don't know how to do that !:(

#Check this:
http://forum.ragezone.com/f722/relea...ration-807636/

Quote:

---

Originally Posted by LogiN

#Check this:
http://forum.ragezone.com/f722/relea...ration-807636/

---

tested before and fail

Go to Stored Procedures >> _AddNewChar like the image and add my lines in this place :-


http://img803.imageshack.us/img803/9076/48993953.png

Lines:-

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

---

500 is 500 silk (you can edit whatever you like)

good Luck ;)

Thanks arabianfox & LogiN for Help Working Now With arabianfox idea