|
You last visited: Today at 14:53
Advertisement
Have a GM equipment
Discussion on Have a GM equipment within the 4Story forum part of the MMORPGs category.
04/06/2013, 12:53
|
#1
|
elite*gold: 0
Join Date: Nov 2009
Posts: 53
Received Thanks: 2
|
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 ?
|
|
|
04/06/2013, 14:27
|
#2
|
elite*gold: 0
Join Date: Mar 2010
Posts: 187
Received Thanks: 93
|
Go into the fonction of TGAME_GSP -> DBO -> Function and search TTESTGmItemGive Execute the function and put the name of your char
Good luck !
|
|
|
04/06/2013, 14:31
|
#3
|
elite*gold: 0
Join Date: Nov 2009
Posts: 53
Received Thanks: 2
|
Where exactly I put my name char ?
|
|
|
04/06/2013, 14:36
|
#4
|
elite*gold: 0
Join Date: Mar 2010
Posts: 187
Received Thanks: 93
|
Use your brain !
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 )
|
|
|
04/06/2013, 14:42
|
#5
|
elite*gold: 0
Join Date: Nov 2009
Posts: 53
Received Thanks: 2
|
Thank a lot
But I haven't all ekipment just Wand and Book... Help please
|
|
|
04/06/2013, 14:44
|
#6
|
elite*gold: 0
Join Date: Mar 2010
Posts: 187
Received Thanks: 93
|
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
|
|
|
|
04/06/2013, 15:00
|
#7
|
elite*gold: 0
Join Date: Nov 2009
Posts: 53
Received Thanks: 2
|
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
|
|
|
04/06/2013, 15:29
|
#8
|
elite*gold: 0
Join Date: Mar 2010
Posts: 187
Received Thanks: 93
|
Your welcome but my help is bad... :/
|
|
|
04/06/2013, 16:23
|
#9
|
elite*gold: 0
Join Date: Nov 2009
Posts: 53
Received Thanks: 2
|
So, if i execute the funtion on my Wizzard it's OK but on my priest no ^^
|
|
|
04/06/2013, 19:03
|
#10
|
elite*gold: 0
Join Date: Mar 2011
Posts: 306
Received Thanks: 156
|
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.
|
|
|
All times are GMT +1. The time now is 14:53.
|
|