|
You last visited: Today at 10:38
Advertisement
[Release]GM function - neue PvP Equipment
Discussion on [Release]GM function - neue PvP Equipment within the 4Story forum part of the MMORPGs category.
05/06/2013, 18:11
|
#1
|
elite*gold: 120 
Join Date: Apr 2012
Posts: 1,982
Received Thanks: 2,463
|
[Release]GM function - neues PvP Equipment
Hey,
hier die eine neue GM function, womit man das neue PvP Equipment bekommt, statt das alte.
Code:
ALTER PROCEDURE [dbo].[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 = 27020
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 = 26620
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 = 26620
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 = 26020
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 = 26220
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 = 26420
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
Einfach in die TTESTGmItemGive function einfügen.
|
|
|
|
05/06/2013, 18:18
|
#2
|
elite*gold: 13
Join Date: Dec 2010
Posts: 482
Received Thanks: 236
|
Funktion funktioniert einwandfrei. Wäre es noch möglich, die Items den richtigen Klassen zuzuordnen? Der Priester bekommt z.B. Beschwörer Equipment. Sowas meine ich.
Grüße
|
|
|
|
|
05/06/2013, 18:34
|
#3
|
elite*gold: 0
Join Date: Aug 2011
Posts: 286
Received Thanks: 240
|
Quote:
Originally Posted by DaFabi1996
Funktion funktioniert einwandfrei. Wäre es noch möglich, die Items den richtigen Klassen zuzuordnen? Der Priester bekommt z.B. Beschwörer Equipment. Sowas meine ich.
Grüße
|
Schau mal in die Funktion, wenn du das ändern willst, änder einfach eine Zahl 
|
|
|
|
|
05/06/2013, 18:52
|
#4
|
elite*gold: 120
Join Date: Apr 2012
Posts: 1,982
Received Thanks: 2,463
|
Neuer Code ist drin, jetzt sollten Priester das richtige Equipment bekommen.
|
|
|
|
|
05/06/2013, 19:46
|
#5
|
elite*gold: 0
Join Date: Oct 2011
Posts: 170
Received Thanks: 16
|
Weom u can upload the screen of equipment?
Because i don't have server and i would like to see them <3.
And other question.
IS for 3.6?? or 4.0 +?
|
|
|
|
|
05/06/2013, 19:51
|
#6
|
elite*gold: 0
Join Date: Aug 2011
Posts: 286
Received Thanks: 240
|
There´s no diffrent whether it´s for 3.6 or 4. whatever... It´s just the gm give function guys
|
|
|
|
|
05/16/2013, 16:45
|
#7
|
elite*gold: 0
Join Date: Dec 2012
Posts: 267
Received Thanks: 23
|
kannst du mir genau erklären wie ich das machen kann bitte?^^
|
|
|
|
|
05/16/2013, 17:38
|
#8
|
elite*gold: 0
Join Date: Dec 2012
Posts: 11
Received Thanks: 2
|
Quote:
Originally Posted by LittleJ3ossy
kannst du mir genau erklären wie ich das machen kann bitte?^^
|
Geh in Navicat. Geh auf TGAME, dann auf dbo, dann auf Funktion, suchst TTESTGmItemGive. Löscht das raus was drinn steht und fügst dann andere ein.
Drück save dann drück run gibts dein Char Name ein und das wars. 
|
|
|
|
|
05/16/2013, 22:52
|
#9
|
elite*gold: 0
Join Date: Nov 2012
Posts: 9,182
Received Thanks: 485
|
Funktioniert super!
Danke für den Release!
|
|
|
|
|
05/19/2013, 10:43
|
#10
|
elite*gold: 0
Join Date: Oct 2010
Posts: 546
Received Thanks: 152
|
I have just do this under ! 
|
|
|
|
|
05/19/2013, 11:11
|
#11
|
elite*gold: 150
Join Date: Oct 2011
Posts: 373
Received Thanks: 73
|
Hello I Have A New Problem I Am Create A Hamachi Server But Other People Can't Connect When They Go To Login It Say "The Server Is Under Maintence"
Please Help!!!!!!
|
|
|
|
|
05/25/2013, 00:18
|
#12
|
elite*gold: LOCKED
Join Date: May 2013
Posts: 318
Received Thanks: 62
|
geht gut, thanks!
|
|
|
|
|
05/25/2013, 01:01
|
#13
|
elite*gold: 0
Join Date: Jan 2013
Posts: 81
Received Thanks: 46
|
Quote:
Originally Posted by Weom
Hey,
hier die eine neue GM function, womit man das neue PvP Equipment bekommt, statt das alte.
Code:
ALTER PROCEDURE [dbo].[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 = 27020
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 = 26620
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 = 26620
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 = 26020
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 = 26220
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 = 26420
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
Einfach in die TTESTGmItemGive function einfügen. |
Is not your creation is creation of julianj -_-
|
|
|
|
|
05/25/2013, 01:48
|
#14
|
elite*gold: 120
Join Date: Apr 2012
Posts: 1,982
Received Thanks: 2,463
|
Quote:
Originally Posted by Yes@i
Is not your creation is creation of julianj -_-
|
This is my creation. Go sleeping.
|
|
|
|
|
05/25/2013, 01:59
|
#15
|
elite*gold: 0
Join Date: Nov 2012
Posts: 9,182
Received Thanks: 485
|
Danke für die Funktion
Gute arbeit, hab sie auhc schon getestet
|
|
|
|
 |
Similar Threads
|
[Release]Dungeonpunkte function
12/11/2012 - Metin2 PServer Guides & Strategies - 16 Replies
Tach kurz und knapp, mir war langweilig ^^
Was ihr damit anfangen könnt muss jeder für sich wissen oder was es bringt
und wie ihr es genau einfügt ( einfügen ist nicht schwer ... ).
Hab ne verbesserte Variante, daher kriegt ihr die alte.
function give_dungeonpoints(race,value)
if race ~= nil and value ~= nil then
pc.setqf("dungeon_points", pc.getqf("dungeon_points") + value)
else
syschat("Kein Wert angegeben, Abbruch")
|
Warrock *Neue Costüme und Equipment* STORE
11/18/2012 - WarRock Trading - 17 Replies
Hallo Epvp,
Ich habe beschlossen einen Costüm und Equipment Store zu eröffnen.
Infos zu den Items:
Alle Items haben eine Dauer von 3649 Tagen. Bezahlen müsst ihr keinen Dinar.
Zudem haben viele Equipments Vorteile.z.B: Treffsicherheit,Schutz (siehe Bilder)
|
[S]Neue Equipment
08/02/2012 - Metin2 Private Server - 5 Replies
Suche diese neuen Eq sachen / Thx im vorraus :handsdown:
Wie auf dem link zu sehen http://www.elitepvpers.com/forum/metin2-pserver-gu ides-strategies/1475577-release-neue-m2-de-items.h tml
Die Query's etc ..
|
[RELEASE] Metin2Master 2.0 *New Function*
09/24/2008 - Metin2 Hacks, Bots, Cheats, Exploits & Macros - 45 Replies
Hello all again. I have now relaesed a new Metin2Master with a NEW and FUN function. Its called Click & Teleport. It is what it sounds like.. you simple will teleport to where you click.
RapidShare: 1-Click Webhosting
Dont overwrite your old MetinCoords.met
How it works : Point to where you wanna teleport with your mouse.. (NOT on map), then hold right mouse button and click with left mousebutton .. and AWAAAAAY YOOOU GOOOO!!! Now you can teleport to places you never been to =) .
...
|
All times are GMT +2. The time now is 10:38.
|
|
![[Release]GM function - neue PvP Equipment](https://www.elitepvpers.com/forum/iconimages/4story/release-gm-function-neue-pvp-equipment_ltr.gif){kind=small}
