Have a GM equipment

How to have a GM ekipment ?

I had find a tuto but I don't found it now :(

and How to be GM in the account table ?

Go into the fonction of TGAME_GSP -> DBO -> Function and search TTESTGmItemGive :D Execute the function and put the name of your char ;)

Good luck !

Where exactly I put my name char ?

Use your brain ! :D

So, go into TGAME_GSP -> DBO -> Function and search TTESTGmItemGive. Right click on it and select "Execute function" ! After, use your brain ! (Do it and see it ;) )

Thank a lot :D

But I haven't all ekipment just Wand and Book... Help please :)

Oh shit... So, you go on the function and select "Design Function" and no "Execute function" and delete all and put this:

Quote:

ALTER PROCEDURE TTESTGmItemGive @szName VARCHAR(50) AS declare @dwCharid INT declare @dwUserId INT declare @bClass TINYINT declare @wArmor SMALLINT declare @bMaxLevel TINYINT declare @dwExp INT declare @GenID BIGINT select @dwCharid = dwcharid, @dwUserId = dwUserID, @bClass = bclass from tchartable where szname = @szName IF(@@ROWCOUNT <> 1) RETURN 'Not Find Character' SELECT @bMaxLevel = bMaxLevel FROM TGLOBAL_GSP.DBO.TLIMITEDLEVELCHART SELECT @dwExp = dwExp FROM TLEVELCHART WHERE bLevel = @bMaxLevel-1 UPDATE tchartable set wskillpoint = 0, blevel = @bMaxLevel, dwgold = 200, dwExp = @dwExp where dwcharid = @dwCharid DELETE tskilltable where dwcharid = @dwCharid INSERT TSKILLTABLE (dwCharID, wSkillID, bLevel, dwRemainTick) SELECT @dwCharid, wID, bmaxlevel, 0 FROM TSKILLCHART WHERE (dwClassid & power(2,@bClass) <> 0) and bCanLearn =1 DELETE TITEMTABLE where dwOwnerID = @dwCharid DELETE TGLOBAL_GSP.DBO.TCASHITEMCABINETTABLE WHERE dwUserID = @dwUserID DELETE TPOSTTABLE where dwCharID = @dwCharid delete TINVENTABLE where dwCharID = @dwCharid and bInvenID in(0,1,2,3,4) insert TINVENTABLE (dwCharID, bInvenID, wItemID, dEndTime, bELD) values(@dwCharid, 0, 12, 0, 0) insert TINVENTABLE (dwCharID, bInvenID, wItemID, dEndTime, bELD) values(@dwCharid, 1, 12, 0, 0) insert TINVENTABLE (dwCharID, bInvenID, wItemID, dEndTime, bELD) values(@dwCharid, 2, 12, 0, 0) insert TINVENTABLE (dwCharID, bInvenID, wItemID, dEndTime, bELD) values(@dwCharid, 3, 12, 0, 0) insert TINVENTABLE (dwCharID, bInvenID, wItemID, dEndTime, bELD) values(@dwCharid, 4, 12, 0, 0) EXEC TEventItemGive @szName, 51, 200,'GM HIDE','Thank For Test!' EXEC TEventItemGive @szName, 53, 200,'GM SPEED','Thank For Test!' EXEC TEventItemGive @szName, 55, 200,'GM FLY','Thank For Test!' EXEC TEventItemGive @szName, 56, 200,'GM SOUL','Thank For Test!' EXEC TTESTGivePowerItem @dwCharid, 50, 10, 0 EXEC TTESTGivePowerItem @dwCharid, 50, 11, 0 EXEC TTESTGivePowerItem @dwCharid, 7310, 12, 0 EXEC TTESTGivePowerItem @dwCharid, 7310, 13, 0 IF(@bClass = 0) BEGIN EXEC TTESTGivePowerItem @dwCharid, 27130, 0, 0 --검 EXEC TTESTGivePowerItem @dwCharid, 27138, 1, 0 --방 EXEC TTESTGivePowerItem @dwCharid, 27136, 2, 0 --석 EXEC TTESTGivePowerItem @dwCharid, 27131, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 27132, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 1592, 9, 0 SET @wArmor = 27167 END ELSE IF(@bClass = 1) BEGIN EXEC TTESTGivePowerItem @dwCharid, 27133, 0, 0 --차 EXEC TTESTGivePowerItem @dwCharid, 27136, 2, 0--석 EXEC TTESTGivePowerItem @dwCharid, 27134, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 27130, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 27137, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 27135, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 1592, 9, 0 SET @wArmor = 27157 END ELSE IF(@bClass = 2) BEGIN EXEC TTESTGivePowerItem @dwCharid, 27130, 0, 0--검 EXEC TTESTGivePowerItem @dwCharid, 27137, 1, 0--단 EXEC TTESTGivePowerItem @dwCharid, 27136, 2, 0--석 EXEC TTESTGivePowerItem @dwCharid, 27135, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 1592, 9, 0 SET @wArmor = 27162 END ELSE IF(@bClass = 3) BEGIN EXEC TTESTGivePowerItem @dwCharid, 27140, 0, 0--스 EXEC TTESTGivePowerItem @dwCharid, 27139, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 27141, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 1594, 9, 0 SET @wArmor = 27147 END ELSE IF(@bClass = 4) BEGIN EXEC TTESTGivePowerItem @dwCharid, 27140, 0, 0--스 EXEC TTESTGivePowerItem @dwCharid, 27139, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 27141, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 1594, 9, 0 SET @wArmor = 27152 END ELSE IF(@bClass = 5) BEGIN EXEC TTESTGivePowerItem @dwCharid, 27140, 0, 0--스 EXEC TTESTGivePowerItem @dwCharid, 27139, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 27141, 255, 0 EXEC TTESTGivePowerItem @dwCharid, 1594, 9, 0 SET @wArmor = 27142 END -- 이펙트 타입 0:없음, 1:물, 2:불, 3:전기, 4:ICE, 5:암흑 EXEC TTESTGivePowerItem @dwCharid, @wArmor, 3, 0 SET @wArmor = @wArmor +1 EXEC TTESTGivePowerItem @dwCharid, @wArmor, 5, 0 SET @wArmor = @wArmor +1 EXEC TTESTGivePowerItem @dwCharid, @wArmor, 6, 0 SET @wArmor = @wArmor +1 EXEC TTESTGivePowerItem @dwCharid, @wArmor, 7, 0 SET @wArmor = @wArmor +1 EXEC TTESTGivePowerItem @dwCharid, @wArmor, 8, 0 EXEC TTESTGivePowerItem @dwCharid, 7001, 4, 0 EXEC TItemInsert @dwUserID, 7549, 1 EXEC TItemInsert @dwUserID, 7550, 1 EXEC TItemInsert @dwUserID, 7551, 1 EXEC TItemInsert @dwUserID, 7556, 1 EXEC TItemInsert @dwUserID, 7602, 200 EXEC TItemInsert @dwUserID, 7656, 200 EXEC TItemInsert @dwUserID, 7658, 200 EXEC TItemInsert @dwUserID, 7659, 200 EXEC TItemInsert @dwUserID, 7663, 200 EXEC TItemInsert @dwUserID, 8505, 200 EXEC TItemInsert @dwUserID, 18053, 200 EXEC TItemInsert @dwUserID, 6804, 200 EXEC TItemInsert @dwUserID, 6807, 200 EXEC TItemInsert @dwUserID, 6808, 200 EXEC TItemInsert @dwUserID, 7601, 200 EXEC TItemInsert @dwUserID, 7603, 200 EXEC TItemInsert @dwUserID, 7604, 200 EXEC TItemInsert @dwUserID, 7605, 200 EXEC TItemInsert @dwUserID, 7611, 200 EXEC TItemInsert @dwUserID, 7612, 200 EXEC TItemInsert @dwUserID, 7613, 200 EXEC TItemInsert @dwUserID, 7618, 200 EXEC TItemInsert @dwUserID, 7619, 200 EXEC TItemInsert @dwUserID, 7620, 200 EXEC TItemInsert @dwUserID, 7621, 200 EXEC TItemInsert @dwUserID, 7622, 200 EXEC TItemInsert @dwUserID, 7623, 200 EXEC TItemInsert @dwUserID, 7609, 200 EXEC TItemInsert @dwUserID, 7678, 200 EXEC TItemInsert @dwUserID, 7679, 200 EXEC TItemInsert @dwUserID, 18142, 200

same results. I wanna all stuff GM when I execute that function :O
now i have juste wand and book ^^'
ps : Thank you kindly help me

Your welcome but my help is bad... :/

So, if i execute the funtion on my Wizzard it's OK but on my priest no ^^

dude... get the item you want and refine with the gm eq...

TOPERATORTABLE (TAGME_GSP) - Insert your character ID. This unlock the GM Permissions (chatban, etc) and you are able to write in the Notice chat.