TScammingPost - Funtion

[jibi1996]

I would set this function, so everybody gets some golds (30golds) when they sucessfully creates a character.

ALTER PROCEDURE TScammingPost
@dwCharID INT
AS

DECLARE @szName VARCHAR(50)
DECLARE @bCountry TINYINT

SELECT @szName = szName, @bCountry=bCountry FROM TCHARTABLE WHERE dwCharID = @dwCharID
IF(@@ROWCOUNT = 0 OR @szName IS NULL)
	RETURN

IF NOT EXISTS(SELECT dwSeq FROM TRESERVEDPOST WHERE dwRecverID=@dwCharID AND wItemID = 9400)
BEGIN

	EXEC TEventItemGive 
		@szName,
		7625,
		5,
		'Start Package',
		'Welcome, to the Server
Admin.-
'

END

Someone could give me a hand? ^^

[manikas131]

help were i put this?

[xXxXHansXxXx]

You do not need the scamming post. I disabled it on my server. Just use my welcomebackbonus and you will get all what you need to.

Cheeers

[manikas131]

so i will delete the scamming post?