Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > 4Story
You last visited: Today at 14:53

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Have a GM equipment

Discussion on Have a GM equipment within the 4Story forum part of the MMORPGs category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2009
Posts: 53
Received Thanks: 2
Arrow 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 ?
LILIOni is offline  
Old 04/06/2013, 14:27   #2
 
pipitt05000's Avatar
 
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 !
pipitt05000 is offline  
Old 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 ?
LILIOni is offline  
Old 04/06/2013, 14:36   #4
 
pipitt05000's Avatar
 
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 )
pipitt05000 is offline  
Old 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
LILIOni is offline  
Old 04/06/2013, 14:44   #6
 
pipitt05000's Avatar
 
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
pipitt05000 is offline  
Thanks
1 User
Old 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
LILIOni is offline  
Old 04/06/2013, 15:29   #8
 
pipitt05000's Avatar
 
elite*gold: 0
Join Date: Mar 2010
Posts: 187
Received Thanks: 93
Your welcome but my help is bad... :/
pipitt05000 is offline  
Old 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 ^^
LILIOni is offline  
Old 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.
jibi1996 is offline  
Reply


Similar Threads Similar Threads
**Metin2 [B] Imba Equipment auf Server 18 Erfoo [S]Equipment auf S1 Mosha oder Psc**
08/21/2012 - Metin2 Trading - 4 Replies
huhu liebe com, da ich inaktiv auf s18 erfoo bin, biete ich hier mein restequip zum tausch/Verkauf an dgp+9 2k tp 5tp absorb 3crap 3+4er standard
[B] FinalMT2 IMBA Equipment-Accounts [S]Amkira Equipment-Account/ PSC / Paypal
03/19/2012 - Metin2 Trading - 1 Replies
.



All times are GMT +1. The time now is 14:53.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.