Quote:
Originally Posted by xClock
Better if you'd like to use when user is creating account
|
your writing a lot of useless posts in the help section recently. Good job continue doing that. Give people more false hope.
@ThreadStarter.
Go to the procedure called _AddNewChar.
Find this ****:
-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID
IF (@temp >= 4)
BEGIN
-- ³Ê¹« ¸¹ÀÚ³ª
RETURN -2
END
-- finish by novice.
Then replace that **** with this ****:
-- start by novice.
SELECT @temp = count(CharID) FROM _User WITH (NOLOCK) WHERE UserJID = @UserJID
IF (@temp >= 4)
BEGIN
-- ³Ê¹« ¸¹ÀÚ³ª
RETURN -2
END
IF @temp = 0
INSERT INTO SRO_VT_ACCOUNT.dbo.SK_SILK (JID,Silk_own,Silk_point,Silk_gift)
VALUES (@UserJID, 9932, 0,0)
This **** will basically give the account 9932 silk.. PS: Only for the first character per account. if u want to add silk everytime.. remove the "IF @temp = 0" line.