|
You last visited: Today at 00:08
Advertisement
[Release]Alternative for TITEMTABLE
Discussion on [Release]Alternative for TITEMTABLE within the 4Story forum part of the MMORPGs category.
06/27/2013, 21:34
|
#1
|
elite*gold: 0 
Join Date: Nov 2010
Posts: 216
Received Thanks: 171
|
[Release]Alternative for TITEMTABLE
Edit: i dont realease more nothing
|
|
|
|
06/27/2013, 21:51
|
#2
|
elite*gold: 0
Join Date: Aug 2011
Posts: 286
Received Thanks: 241
|
Very usefull, good idea, great work.
|
|
|
|
|
06/27/2013, 22:21
|
#3
|
elite*gold: 0
Join Date: Nov 2011
Posts: 391
Received Thanks: 471
|
This is very good as usual
|
|
|
|
|
06/27/2013, 22:23
|
#4
|
elite*gold: 0
Join Date: Oct 2011
Posts: 170
Received Thanks: 16
|
What problem have titamble??
|
|
|
|
|
06/27/2013, 22:24
|
#5
|
elite*gold: 0
Join Date: Nov 2011
Posts: 391
Received Thanks: 471
|
Quote:
Originally Posted by OnePippa
What problem have titamble??
|
Let's say he simplify TITEMTABLE If you want to make a web tools such as its going to be much easier
|
|
|
|
|
06/27/2013, 22:28
|
#6
|
elite*gold: 0
Join Date: May 2013
Posts: 35
Received Thanks: 12
|
RA-Developer they are really impressive so much to make our lives easier it is true that the channel is beugged I'm working on the fix.
|
|
|
|
|
06/27/2013, 22:32
|
#7
|
elite*gold: 0
Join Date: May 2013
Posts: 2
Received Thanks: 0
|
I see that it has encoded the air but also very hard so I put a complex thanks.
|
|
|
|
|
06/27/2013, 22:33
|
#8
|
elite*gold: 120
Join Date: Apr 2012
Posts: 1,982
Received Thanks: 2,464
|
Quote:
Originally Posted by BESTAMO
RA-Developer they are really impressive so much to make our lives easier it is true that the channel is beugged I'm working on the fix.
|
Channel is not bugged, you have only no idea how to activate
@nice release.
|
|
|
|
|
06/27/2013, 23:22
|
#9
|
elite*gold: 0
Join Date: Nov 2010
Posts: 216
Received Thanks: 171
|
thanks 
|
|
|
|
|
06/28/2013, 10:44
|
#10
|
elite*gold: 0
Join Date: Oct 2011
Posts: 170
Received Thanks: 16
|
Quote:
Originally Posted by EliteTuerie
Let's say he simplify TITEMTABLE If you want to make a web tools such as its going to be much easier
|
Thx
|
|
|
|
|
06/28/2013, 17:06
|
#11
|
elite*gold: 0
Join Date: Apr 2011
Posts: 219
Received Thanks: 69
|
Great :thumbup:
|
|
|
|
|
06/28/2013, 21:17
|
#12
|
elite*gold: 0
Join Date: May 2013
Posts: 2
Received Thanks: 0
|
Quote:
Originally Posted by Sicarium
I make new script for new alternative TITEMTABLE, but only for see the values, dont for insert values
Exemple:
Download the table in the Attach Files and upload it in TGAME_GSP,
Next you Make a new Procedure in TGAME_GSP Functions and call it "TEquipInfo".
PHP Code:
ALTER PROCEDURE [dbo].[TEquipInfo]
@dwCharID INT,
@dwUserID INT
AS
BEGIN
DECLARE @nomepersonaggio VARCHAR(50)
DECLARE @itemid INT
DECLARE @nomeitem VARCHAR(50)
DECLARE @posizioneitem TINYINT
DECLARE @nomeposizione VARCHAR(50)
DECLARE @livelloupgrade INT
DECLARE @colore INT
DECLARE @nomecolore VARCHAR(50)
DECLARE @raffinamenti TINYINT
DECLARE @durabilitacorrente INT
DECLARE @durabilitamax INT
DECLARE @scadenzaitem smalldatetime
DECLARE @regnoitem TINYINT
DECLARE @primobonus INT
DECLARE @nomeprimobonus VARCHAR(50)
DECLARE @primovalore INT
DECLARE @secondobonus INT
DECLARE @nomesecondobonus VARCHAR(50)
DECLARE @secondovalore INT
DECLARE @terzobonus INT
DECLARE @nometerzobonus VARCHAR(50)
DECLARE @terzovalore INT
DECLARE @quartobonus INT
DECLARE @nomequartobonus VARCHAR(50)
DECLARE @quartovalore INT
DECLARE @nomeregnoitem VARCHAR(50)
DECLARE @bClass TINYINT
/* Nome personaggio */
SELECT @nomepersonaggio = szNAME FROM TCHARTABLE WHERE dwCharID = @dwCharID AND dwUserID = @dwUserID
SELECT @bClass = bClass FROM TCHARTABLE WHERE dwCharID = @dwCharID
/* Riempio tutte le variaibile da TITEMTABLE */
SELECT @itemid=wItemID,@livelloupgrade = bLevel,@raffinamenti = bRefineCur, @durabilitacorrente = dwDuraCur, @durabilitamax = dwDuraMax, @colore = bGradeEffect, @primobonus = bMagic1, @primovalore = wValue1, @secondobonus = bMagic2, @secondovalore = wValue2, @terzobonus = bMagic3, @terzovalore = wValue3, @quartobonus = bMagic4, @quartovalore = wValue4 FROM TITEMTABLE WHERE dwOwnerID = @dwCharID AND bItemID = 0 AND dwStorageID = 254
SELECT @nomeitem = szNAME, @regnoitem = bItemCountry FROM TITEMCHART WHERE wItemID = @itemid
SET @nomeposizione = 'Main Hand'
SET @posizioneitem = 0
IF(@regnoitem = 0)
BEGIN
SET @nomeregnoitem = 'Defugel'
END
IF(@regnoitem = 1)
BEGIN
SET @nomeregnoitem = 'Craxion'
END
IF(@regnoitem = 3 or @regnoitem = 4)
BEGIN
SET @nomeregnoitem = 'Gor'
END
/* Assegno nomi ai colori */
IF(@colore = 0)
BEGIN
SET @nomecolore = 'Nothing'
END
IF(@colore = 0 AND @livelloupgrade = 16 )
BEGIN
SET @nomecolore = 'Gold'
END
IF(@colore = 1)
BEGIN
SET @nomecolore = 'Blue'
END
IF(@colore = 2)
BEGIN
SET @nomecolore = 'Red'
END
IF(@colore = 3)
BEGIN
SET @nomecolore = 'Electric'
END
IF(@colore = 4)
BEGIN
SET @nomecolore = 'Sky-Blue'
END
IF(@colore = 5)
BEGIN
SET @nomecolore = 'Black-Green'
END
IF(@colore = 6)
BEGIN
SET @nomecolore = 'Purple'
END
IF(@colore = 7)
BEGIN
SET @nomecolore = 'Blue Storm'
END
IF(@colore = 8)
BEGIN
SET @nomecolore = 'Light Green'
END
IF(@colore = 9)
BEGIN
SET @nomecolore = 'Red Lava'
END
/* Assegno nomi ai bonus */
IF(@primobonus = 11)
BEGIN
SET @nomeprimobonus = 'Attack Rating'
END
IF(@secondobonus = 11)
BEGIN
SET @nomesecondobonus = 'Attack Rating'
END
IF(@terzobonus = 11)
BEGIN
SET @nometerzobonus = 'Attack Rating'
END
IF(@quartobonus = 11)
BEGIN
SET @nomequartobonus = 'Attack Rating'
END
IF(@primobonus = 12)
BEGIN
SET @nomeprimobonus = 'Defense rating'
END
IF(@secondobonus = 12)
BEGIN
SET @nomesecondobonus = 'Defense rating'
END
IF(@terzobonus = 12)
BEGIN
SET @nometerzobonus = 'Defense rating'
END
IF(@quartobonus = 12)
BEGIN
SET @nomequartobonus = 'Defense rating'
END
IF(@primobonus = 13)
BEGIN
SET @nomeprimobonus = 'Phsycal critical hit rate'
END
IF(@secondobonus = 13)
BEGIN
SET @nomesecondobonus = 'Phsycal critical hit rate'
END
IF(@terzobonus = 13)
BEGIN
SET @nometerzobonus = 'Phsycal critical hit rate'
END
IF(@quartobonus = 13)
BEGIN
SET @nomequartobonus = 'Phsycal critical hit rate'
END
IF(@primobonus = 20)
BEGIN
SET @nomeprimobonus = 'Cast rate'
END
IF(@secondobonus = 20)
BEGIN
SET @nomesecondobonus = 'Cast rate'
END
IF(@terzobonus = 20)
BEGIN
SET @nometerzobonus = 'Cast rate'
END
IF(@quartobonus = 20)
BEGIN
SET @nomequartobonus = 'Cast rate'
END
IF(@primobonus = 21)
BEGIN
SET @nomeprimobonus = 'Critical magic rate'
END
IF(@secondobonus = 21)
BEGIN
SET @nomesecondobonus = 'Critical magic rate'
END
IF(@terzobonus = 21)
BEGIN
SET @nometerzobonus = 'Critical magic rate'
END
IF(@quartobonus = 21)
BEGIN
SET @nomequartobonus = 'Critical magic rate'
END
IF(@primobonus = 34)
BEGIN
SET @nomeprimobonus = 'Block rate'
END
IF(@secondobonus = 34)
BEGIN
SET @nomesecondobonus = 'Block rate'
END
IF(@terzobonus = 34)
BEGIN
SET @nometerzobonus = 'Block rate'
END
IF(@quartobonus = 34)
BEGIN
SET @nomequartobonus = 'Block rate'
END
IF(@primobonus = 54)
BEGIN
SET @nomeprimobonus = 'Phsycal attack speed'
END
IF(@secondobonus = 54)
BEGIN
SET @nomesecondobonus = 'Phsycal attack speed'
END
IF(@terzobonus = 54)
BEGIN
SET @nometerzobonus = 'Phsycal attack speed'
END
IF(@quartobonus = 54)
BEGIN
SET @nomequartobonus = 'Phsycal attack speed'
END
IF(@primobonus = 55)
BEGIN
SET @nomeprimobonus = 'Longe range attack speed'
END
IF(@secondobonus = 55)
BEGIN
SET @nomesecondobonus = 'Longe range attack speed'
END
IF(@terzobonus = 55)
BEGIN
SET @nometerzobonus = 'Longe range attack speed'
END
IF(@quartobonus = 55)
BEGIN
SET @nomequartobonus = 'Longe range attack speed'
END
IF(@primobonus = 56)
BEGIN
SET @nomeprimobonus = 'Magic attack speed'
END
IF(@secondobonus = 56)
BEGIN
SET @nomesecondobonus = 'Magic attack speed'
END
IF(@terzobonus = 56)
BEGIN
SET @nometerzobonus = 'Magic attack speed'
END
IF(@quartobonus = 56)
BEGIN
SET @nomequartobonus = 'Magic attack speed'
END
IF(@primobonus = 86)
BEGIN
SET @nomeprimobonus = 'Magic attack'
END
IF(@secondobonus = 86)
BEGIN
SET @nomesecondobonus = 'Magic attack'
END
IF(@terzobonus = 86)
BEGIN
SET @nometerzobonus = 'Magic attack'
END
IF(@quartobonus = 86)
BEGIN
SET @nomequartobonus = 'Magic attack'
END
IF(@primobonus = 87)
BEGIN
SET @nomeprimobonus = 'Magic defense level'
END
IF(@secondobonus = 87)
BEGIN
SET @nomesecondobonus = 'Magic defense level'
END
IF(@terzobonus = 87)
BEGIN
SET @nometerzobonus = 'Magic defense level'
END
IF(@quartobonus = 87)
BEGIN
SET @nomequartobonus = 'Magic defense level'
END
INSERT INTO EquipInformations(Name,Item,Type,Upgrade,Color,Refinament,DurabilityCurrent,DurabilityMax,CountryItem,FirstBonus,FirstValue,SecondBonus,SecondValue,ThirdBonus,ThirdValue,FourthBonus,FourthValue)
VALUES(@nomepersonaggio,@nomeitem,@nomeposizione,@livelloupgrade,@nomecolore,@raffinamenti,@durabilitacorrente,@durabilitamax,@nomeregnoitem,@nomeprimobonus,@primovalore,@nomesecondobonus,@secondovalore,@nometerzobonus,@terzovalore,@nomequartobonus,@quartovalore)
SET @nomeprimobonus =''
SET @nomesecondobonus=''
SET @nometerzobonus =''
SET @nomequartobonus=''
SELECT @itemid=wItemID,@livelloupgrade = bLevel,@raffinamenti = bRefineCur, @durabilitacorrente = dwDuraCur, @durabilitamax = dwDuraMax, @colore = bGradeEffect, @primobonus = bMagic1, @primovalore = wValue1, @secondobonus = bMagic2, @secondovalore = wValue2, @terzobonus = bMagic3, @terzovalore = wValue3, @quartobonus = bMagic4, @quartovalore = wValue4 FROM TITEMTABLE WHERE dwOwnerID = @dwCharID AND bItemID = 1 AND dwStorageID = 254
SELECT @nomeitem = szNAME, @regnoitem = bItemCountry FROM TITEMCHART WHERE wItemID = @itemid
SET @nomeposizione = 'Off Hand'
SET @posizioneitem = 1
IF(@regnoitem = 0)
BEGIN
SET @nomeregnoitem = 'Defugel'
END
IF(@regnoitem = 1)
BEGIN
SET @nomeregnoitem = 'Craxion'
END
IF(@regnoitem = 3 or @regnoitem = 4)
BEGIN
SET @nomeregnoitem = 'Gor'
END
/* Assegno nomi ai colori */
IF(@colore = 0)
BEGIN
SET @nomecolore = 'Nothing'
END
IF(@colore = 0 AND @livelloupgrade = 16 )
BEGIN
SET @nomecolore = 'Gold'
END
IF(@colore = 1)
BEGIN
SET @nomecolore = 'Blue'
END
IF(@colore = 2)
BEGIN
SET @nomecolore = 'Red'
END
IF(@colore = 3)
BEGIN
SET @nomecolore = 'Electric'
END
IF(@colore = 4)
BEGIN
SET @nomecolore = 'Sky-Blue'
END
IF(@colore = 5)
BEGIN
SET @nomecolore = 'Black-Green'
END
IF(@colore = 6)
BEGIN
SET @nomecolore = 'Purple'
END
IF(@colore = 7)
BEGIN
SET @nomecolore = 'Blue Storm'
END
IF(@colore = 8)
BEGIN
SET @nomecolore = 'Light Green'
END
IF(@colore = 9)
BEGIN
SET @nomecolore = 'Red Lava'
END
/* Assegno nomi ai bonus */
IF(@primobonus = 11)
BEGIN
SET @nomeprimobonus = 'Attack Rating'
END
IF(@secondobonus = 11)
BEGIN
SET @nomesecondobonus = 'Attack Rating'
END
IF(@terzobonus = 11)
BEGIN
SET @nometerzobonus = 'Attack Rating'
END
IF(@quartobonus = 11)
BEGIN
SET @nomequartobonus = 'Attack Rating'
END
IF(@primobonus = 12)
BEGIN
SET @nomeprimobonus = 'Defense rating'
END
IF(@secondobonus = 12)
BEGIN
SET @nomesecondobonus = 'Defense rating'
END
IF(@terzobonus = 12)
BEGIN
SET @nometerzobonus = 'Defense rating'
END
IF(@quartobonus = 12)
BEGIN
SET @nomequartobonus = 'Defense rating'
END
IF(@primobonus = 13)
BEGIN
SET @nomeprimobonus = 'Phsycal critical hit rate'
END
IF(@secondobonus = 13)
BEGIN
SET @nomesecondobonus = 'Phsycal critical hit rate'
END
IF(@terzobonus = 13)
BEGIN
SET @nometerzobonus = 'Phsycal critical hit rate'
END
IF(@quartobonus = 13)
BEGIN
SET @nomequartobonus = 'Phsycal critical hit rate'
END
IF(@primobonus = 20)
BEGIN
SET @nomeprimobonus = 'Cast rate'
END
IF(@secondobonus = 20)
BEGIN
SET @nomesecondobonus = 'Cast rate'
END
IF(@terzobonus = 20)
BEGIN
SET @nometerzobonus = 'Cast rate'
END
IF(@quartobonus = 20)
BEGIN
SET @nomequartobonus = 'Cast rate'
END
IF(@primobonus = 21)
BEGIN
SET @nomeprimobonus = 'Critical magic rate'
END
IF(@secondobonus = 21)
BEGIN
SET @nomesecondobonus = 'Critical magic rate'
END
IF(@terzobonus = 21)
BEGIN
SET @nometerzobonus = 'Critical magic rate'
END
IF(@quartobonus = 21)
BEGIN
SET @nomequartobonus = 'Critical magic rate'
END
IF(@primobonus = 34)
BEGIN
SET @nomeprimobonus = 'Block rate'
END
IF(@secondobonus = 34)
BEGIN
SET @nomesecondobonus = 'Block rate'
END
IF(@terzobonus = 34)
BEGIN
SET @nometerzobonus = 'Block rate'
END
IF(@quartobonus = 34)
BEGIN
SET @nomequartobonus = 'Block rate'
END
IF(@primobonus = 54)
BEGIN
SET @nomeprimobonus = 'Phsycal attack speed'
END
IF(@secondobonus = 54)
BEGIN
SET @nomesecondobonus = 'Phsycal attack speed'
END
IF(@terzobonus = 54)
BEGIN
SET @nometerzobonus = 'Phsycal attack speed'
END
IF(@quartobonus = 54)
BEGIN
SET @nomequartobonus = 'Phsycal attack speed'
END
IF(@primobonus = 55)
BEGIN
SET @nomeprimobonus = 'Longe range attack speed'
END
IF(@secondobonus = 55)
BEGIN
SET @nomesecondobonus = 'Longe range attack speed'
END
IF(@terzobonus = 55)
BEGIN
SET @nometerzobonus = 'Longe range attack speed'
END
IF(@quartobonus = 55)
BEGIN
SET @nomequartobonus = 'Longe range attack speed'
END
IF(@primobonus = 56)
BEGIN
SET @nomeprimobonus = 'Magic attack speed'
END
IF(@secondobonus = 56)
BEGIN
SET @nomesecondobonus = 'Magic attack speed'
END
IF(@terzobonus = 56)
BEGIN
SET @nometerzobonus = 'Magic attack speed'
END
IF(@quartobonus = 56)
BEGIN
SET @nomequartobonus = 'Magic attack speed'
END
IF(@primobonus = 86)
BEGIN
SET @nomeprimobonus = 'Magic attack'
END
IF(@secondobonus = 86)
BEGIN
SET @nomesecondobonus = 'Magic attack'
END
IF(@terzobonus = 86)
BEGIN
SET @nometerzobonus = 'Magic attack'
END
IF(@quartobonus = 86)
BEGIN
SET @nomequartobonus = 'Magic attack'
END
IF(@primobonus = 87)
BEGIN
SET @nomeprimobonus = 'Magic defense level'
END
IF(@secondobonus = 87)
BEGIN
SET @nomesecondobonus = 'Magic defense level'
END
IF(@terzobonus = 87)
BEGIN
SET @nometerzobonus = 'Magic defense level'
END
IF(@quartobonus = 87)
BEGIN
SET @nomequartobonus = 'Magic defense level'
END
INSERT INTO EquipInformations(Name,Item,Type,Upgrade,Color,Refinament,DurabilityCurrent,DurabilityMax,CountryItem,FirstBonus,FirstValue,SecondBonus,SecondValue,ThirdBonus,ThirdValue,FourthBonus,FourthValue)
VALUES(@nomepersonaggio,@nomeitem,@nomeposizione,@livelloupgrade,@nomecolore,@raffinamenti,@durabilitacorrente,@durabilitamax,@nomeregnoitem,@nomeprimobonus,@primovalore,@nomesecondobonus,@secondovalore,@nometerzobonus,@terzovalore,@nomequartobonus,@quartovalore)
IF(@bClass <= 2)
BEGIN
SET @nomeprimobonus =''
SET @nomesecondobonus=''
SET @nometerzobonus =''
SET @nomequartobonus=''
SELECT @itemid=wItemID,@livelloupgrade = bLevel,@raffinamenti = bRefineCur, @durabilitacorrente = dwDuraCur, @durabilitamax = dwDuraMax, @colore = bGradeEffect, @primobonus = bMagic1, @primovalore = wValue1, @secondobonus = bMagic2, @secondovalore = wValue2, @terzobonus = bMagic3, @terzovalore = wValue3, @quartobonus = bMagic4, @quartovalore = wValue4 FROM TITEMTABLE WHERE dwOwnerID = @dwCharID AND bItemID = 2 AND dwStorageID = 254
SELECT @nomeitem = szNAME, @regnoitem = bItemCountry FROM TITEMCHART WHERE wItemID = @itemid
SET @nomeposizione = 'Crossbow/Bow'
SET @posizioneitem = 2
IF(@regnoitem = 0)
BEGIN
SET @nomeregnoitem = 'Defugel'
END
IF(@regnoitem = 1)
BEGIN
SET @nomeregnoitem = 'Craxion'
END
IF(@regnoitem = 3 or @regnoitem = 4)
BEGIN
SET @nomeregnoitem = 'Gor'
END
/* Assegno nomi ai colori */
IF(@colore = 0)
BEGIN
SET @nomecolore = 'Nothing'
END
IF(@colore = 0 AND @livelloupgrade = 16 )
BEGIN
SET @nomecolore = 'Gold'
END
IF(@colore = 1)
BEGIN
SET @nomecolore = 'Blue'
END
IF(@colore = 2)
BEGIN
SET @nomecolore = 'Red'
END
IF(@colore = 3)
BEGIN
SET @nomecolore = 'Electric'
END
IF(@colore = 4)
BEGIN
SET @nomecolore = 'Sky-Blue'
END
IF(@colore = 5)
BEGIN
SET @nomecolore = 'Black-Green'
END
IF(@colore = 6)
BEGIN
SET @nomecolore = 'Purple'
END
IF(@colore = 7)
BEGIN
SET @nomecolore = 'Blue Storm'
END
IF(@colore = 8)
BEGIN
SET @nomecolore = 'Light Green'
END
IF(@colore = 9)
BEGIN
SET @nomecolore = 'Red Lava'
END
/* Assegno nomi ai bonus */
IF(@primobonus = 11)
BEGIN
SET @nomeprimobonus = 'Attack Rating'
END
IF(@secondobonus = 11)
BEGIN
SET @nomesecondobonus = 'Attack Rating'
END
IF(@terzobonus = 11)
BEGIN
SET @nometerzobonus = 'Attack Rating'
END
IF(@quartobonus = 11)
BEGIN
SET @nomequartobonus = 'Attack Rating'
END
IF(@primobonus = 12)
BEGIN
SET @nomeprimobonus = 'Defense rating'
END
IF(@secondobonus = 12)
BEGIN
SET @nomesecondobonus = 'Defense rating'
END
IF(@terzobonus = 12)
BEGIN
SET @nometerzobonus = 'Defense rating'
END
IF(@quartobonus = 12)
BEGIN
SET @nomequartobonus = 'Defense rating'
END
IF(@primobonus = 13)
BEGIN
SET @nomeprimobonus = 'Phsycal critical hit rate'
END
IF(@secondobonus = 13)
BEGIN
SET @nomesecondobonus = 'Phsycal critical hit rate'
END
IF(@terzobonus = 13)
BEGIN
SET @nometerzobonus = 'Phsycal critical hit rate'
END
IF(@quartobonus = 13)
BEGIN
SET @nomequartobonus = 'Phsycal critical hit rate'
END
IF(@primobonus = 20)
BEGIN
SET @nomeprimobonus = 'Cast rate'
END
IF(@secondobonus = 20)
BEGIN
SET @nomesecondobonus = 'Cast rate'
END
IF(@terzobonus = 20)
BEGIN
SET @nometerzobonus = 'Cast rate'
END
IF(@quartobonus = 20)
BEGIN
SET @nomequartobonus = 'Cast rate'
END
IF(@primobonus = 21)
BEGIN
SET @nomeprimobonus = 'Critical magic rate'
END
IF(@secondobonus = 21)
BEGIN
SET @nomesecondobonus = 'Critical magic rate'
END
IF(@terzobonus = 21)
BEGIN
SET @nometerzobonus = 'Critical magic rate'
END
IF(@quartobonus = 21)
BEGIN
SET @nomequartobonus = 'Critical magic rate'
END
IF(@primobonus = 34)
BEGIN
SET @nomeprimobonus = 'Block rate'
END
IF(@secondobonus = 34)
BEGIN
SET @nomesecondobonus = 'Block rate'
END
IF(@terzobonus = 34)
BEGIN
SET @nometerzobonus = 'Block rate'
END
IF(@quartobonus = 34)
BEGIN
SET @nomequartobonus = 'Block rate'
END
IF(@primobonus = 54)
BEGIN
SET @nomeprimobonus = 'Phsycal attack speed'
END
IF(@secondobonus = 54)
BEGIN
SET @nomesecondobonus = 'Phsycal attack speed'
END
IF(@terzobonus = 54)
BEGIN
SET @nometerzobonus = 'Phsycal attack speed'
END
IF(@quartobonus = 54)
BEGIN
SET @nomequartobonus = 'Phsycal attack speed'
END
IF(@primobonus = 55)
BEGIN
SET @nomeprimobonus = 'Longe range attack speed'
END
IF(@secondobonus = 55)
BEGIN
SET @nomesecondobonus = 'Longe range attack speed'
END
IF(@terzobonus = 55)
BEGIN
SET @nometerzobonus = 'Longe range attack speed'
END
IF(@quartobonus = 55)
BEGIN
SET @nomequartobonus = 'Longe range attack speed'
END
IF(@primobonus = 56)
BEGIN
SET @nomeprimobonus = 'Magic attack speed'
END
IF(@secondobonus = 56)
BEGIN
SET @nomesecondobonus = 'Magic attack speed'
END
IF(@terzobonus = 56)
BEGIN
SET @nometerzobonus = 'Magic attack speed'
END
IF(@quartobonus = 56)
BEGIN
SET @nomequartobonus = 'Magic attack speed'
END
IF(@primobonus = 86)
BEGIN
SET @nomeprimobonus = 'Magic attack'
END
IF(@secondobonus = 86)
BEGIN
SET @nomesecondobonus = 'Magic attack'
END
IF(@terzobonus = 86)
BEGIN
SET @nometerzobonus = 'Magic attack'
END
IF(@quartobonus = 86)
BEGIN
SET @nomequartobonus = 'Magic attack'
END
IF(@primobonus = 87)
BEGIN
SET @nomeprimobonus = 'Magic defense level'
END
IF(@secondobonus = 87)
BEGIN
SET @nomesecondobonus = 'Magic defense level'
END
IF(@terzobonus = 87)
BEGIN
SET @nometerzobonus = 'Magic defense level'
END
IF(@quartobonus = 87)
BEGIN
SET @nomequartobonus = 'Magic defense level'
END
INSERT INTO EquipInformations(Name,Item,Type,Upgrade,Color,Refinament,DurabilityCurrent,DurabilityMax,CountryItem,FirstBonus,FirstValue,SecondBonus,SecondValue,ThirdBonus,ThirdValue,FourthBonus,FourthValue)
VALUES(@nomepersonaggio,@nomeitem,@nomeposizione,@livelloupgrade,@nomecolore,@raffinamenti,@durabilitacorrente,@durabilitamax,@nomeregnoitem,@nomeprimobonus,@primovalore,@nomesecondobonus,@secondovalore,@nometerzobonus,@terzovalore,@nomequartobonus,@quartovalore)
END
SET @nomeprimobonus =''
SET @nomesecondobonus=''
SET @nometerzobonus =''
SET @nomequartobonus=''
SELECT @itemid=wItemID,@livelloupgrade = bLevel,@raffinamenti = bRefineCur, @durabilitacorrente = dwDuraCur, @durabilitamax = dwDuraMax, @colore = bGradeEffect, @primobonus = bMagic1, @primovalore = wValue1, @secondobonus = bMagic2, @secondovalore = wValue2, @terzobonus = bMagic3, @terzovalore = wValue3, @quartobonus = bMagic4, @quartovalore = wValue4 FROM TITEMTABLE WHERE dwOwnerID = @dwCharID AND bItemID = 3 AND dwStorageID = 254
SELECT @nomeitem = szNAME, @regnoitem = bItemCountry FROM TITEMCHART WHERE wItemID = @itemid
SET @nomeposizione = 'Helmet'
SET @posizioneitem = 3
IF(@regnoitem = 0)
BEGIN
SET @nomeregnoitem = 'Defugel'
END
IF(@regnoitem = 1)
BEGIN
SET @nomeregnoitem = 'Craxion'
END
IF(@regnoitem = 3 or @regnoitem = 4)
BEGIN
SET @nomeregnoitem = 'Gor'
END
/* Assegno nomi ai colori */
IF(@colore = 0)
BEGIN
SET @nomecolore = 'Nothing'
END
IF(@colore = 0 AND @livelloupgrade = 16 )
BEGIN
SET @nomecolore = 'Gold'
END
IF(@colore = 1)
BEGIN
SET @nomecolore = 'Blue'
END
IF(@colore = 2)
BEGIN
SET @nomecolore = 'Red'
END
IF(@colore = 3)
BEGIN
SET @nomecolore = 'Electric'
END
IF(@colore = 4)
BEGIN
SET @nomecolore = 'Sky-Blue'
END
IF(@colore = 5)
BEGIN
SET @nomecolore = 'Black-Green'
END
IF(@colore = 6)
BEGIN
SET @nomecolore = 'Purple'
END
IF(@colore = 7)
BEGIN
SET @nomecolore = 'Blue Storm'
END
IF(@colore = 8)
BEGIN
SET @nomecolore = 'Light Green'
END
IF(@colore = 9)
BEGIN
SET @nomecolore = 'Red Lava'
END
/* Assegno nomi ai bonus */
IF(@primobonus = 11)
BEGIN
SET @nomeprimobonus = 'Attack Rating'
END
IF(@secondobonus = 11)
BEGIN
SET @nomesecondobonus = 'Attack Rating'
END
IF(@terzobonus = 11)
BEGIN
SET @nometerzobonus = 'Attack Rating'
END
IF(@quartobonus = 11)
BEGIN
SET @nomequartobonus = 'Attack Rating'
END
IF(@primobonus = 12)
BEGIN
SET @nomeprimobonus = 'Defense rating'
END
IF(@secondobonus = 12)
BEGIN
SET @nomesecondobonus = 'Defense rating'
END
IF(@terzobonus = 12)
BEGIN
SET @nometerzobonus = 'Defense rating'
END
IF(@quartobonus = 12)
BEGIN
SET @nomequartobonus = 'Defense rating'
END
IF(@primobonus = 13)
BEGIN
SET @nomeprimobonus = 'Phsycal critical hit rate'
END
IF(@secondobonus = 13)
BEGIN
SET @nomesecondobonus = 'Phsycal critical hit rate'
END
IF(@terzobonus = 13)
BEGIN
SET @nometerzobonus = 'Phsycal critical hit rate'
END
IF(@quartobonus = 13)
BEGIN
SET @nomequartobonus = 'Phsycal critical hit rate'
END
IF(@primobonus = 20)
BEGIN
SET @nomeprimobonus = 'Cast rate'
END
IF(@secondobonus = 20)
BEGIN
SET @nomesecondobonus = 'Cast rate'
END
IF(@terzobonus = 20)
BEGIN
SET @nometerzobonus = 'Cast rate'
END
IF(@quartobonus = 20)
BEGIN
SET @nomequartobonus = 'Cast rate'
END
IF(@primobonus = 21)
BEGIN
SET @nomeprimobonus = 'Critical magic rate'
END
IF(@secondobonus = 21)
BEGIN
SET @nomesecondobonus = 'Critical magic rate'
END
IF(@terzobonus = 21)
BEGIN
SET @nometerzobonus = 'Critical magic rate'
END
IF(@quartobonus = 21)
BEGIN
SET @nomequartobonus = 'Critical magic rate'
END
IF(@primobonus = 34)
BEGIN
SET @nomeprimobonus = 'Block rate'
END
IF(@secondobonus = 34)
BEGIN
SET @nomesecondobonus = 'Block rate'
END
IF(@terzobonus = 34)
BEGIN
SET @nometerzobonus = 'Block rate'
END
IF(@quartobonus = 34)
BEGIN
SET @nomequartobonus = 'Block rate'
END
IF(@primobonus = 54)
BEGIN
SET @nomeprimobonus = 'Phsycal attack speed'
END
IF(@secondobonus = 54)
BEGIN
SET @nomesecondobonus = 'Phsycal attack speed'
END
IF(@terzobonus = 54)
BEGIN
SET @nometerzobonus = 'Phsycal attack speed'
END
IF(@quartobonus = 54)
BEGIN
SET @nomequartobonus = 'Phsycal attack speed'
END
IF(@primobonus = 55)
BEGIN
SET @nomeprimobonus = 'Longe range attack speed'
END
IF(@secondobonus = 55)
BEGIN
SET @nomesecondobonus = 'Longe range attack speed'
END
IF(@terzobonus = 55)
BEGIN
SET @nometerzobonus = 'Longe range attack speed'
END
IF(@quartobonus = 55)
BEGIN
SET @nomequartobonus = 'Longe range attack speed'
END
IF(@primobonus = 56)
BEGIN
SET @nomeprimobonus = 'Magic attack speed'
END
IF(@secondobonus = 56)
BEGIN
SET @nomesecondobonus = 'Magic attack speed'
END
IF(@terzobonus = 56)
BEGIN
SET @nometerzobonus = 'Magic attack speed'
END
IF(@quartobonus = 56)
BEGIN
SET @nomequartobonus = 'Magic attack speed'
END
IF(@primobonus = 86)
BEGIN
SET @nomeprimobonus = 'Magic attack'
END
IF(@secondobonus = 86)
BEGIN
SET @nomesecondobonus = 'Magic attack'
END
IF(@terzobonus = 86)
BEGIN
SET @nometerzobonus = 'Magic attack'
END
IF(@quartobonus = 86)
BEGIN
SET @nomequartobonus = 'Magic attack'
END
IF(@primobonus = 87)
BEGIN
SET @nomeprimobonus = 'Magic defense level'
END
IF(@secondobonus = 87)
BEGIN
SET @nomesecondobonus = 'Magic defense level'
END
IF(@terzobonus = 87)
BEGIN
SET @nometerzobonus = 'Magic defense level'
END
IF(@quartobonus = 87)
BEGIN
SET @nomequartobonus = 'Magic defense level'
END
INSERT INTO EquipInformations(Name,Item,Type,Upgrade,Color,Refinament,DurabilityCurrent,DurabilityMax,CountryItem,FirstBonus,FirstValue,SecondBonus,SecondValue,ThirdBonus,ThirdValue,FourthBonus,FourthValue)
VALUES(@nomepersonaggio,@nomeitem,@nomeposizione,@livelloupgrade,@nomecolore,@raffinamenti,@durabilitacorrente,@durabilitamax,@nomeregnoitem,@nomeprimobonus,@primovalore,@nomesecondobonus,@secondovalore,@nometerzobonus,@terzovalore,@nomequartobonus,@quartovalore)
SET @nomeprimobonus =''
SET @nomesecondobonus=''
SET @nometerzobonus =''
SET @nomequartobonus=''
SELECT @itemid=wItemID,@livelloupgrade = bLevel,@raffinamenti = bRefineCur, @durabilitacorrente = dwDuraCur, @durabilitamax = dwDuraMax, @colore = bGradeEffect, @primobonus = bMagic1, @primovalore = wValue1, @secondobonus = bMagic2, @secondovalore = wValue2, @terzobonus = bMagic3, @terzovalore = wValue3, @quartobonus = bMagic4, @quartovalore = wValue4 FROM TITEMTABLE WHERE dwOwnerID = @dwCharID AND bItemID = 5 AND dwStorageID = 254
SELECT @nomeitem = szNAME, @regnoitem = bItemCountry FROM TITEMCHART WHERE wItemID = @itemid
SET @nomeposizione = 'Shirt'
SET @posizioneitem = 5
IF(@regnoitem = 0)
BEGIN
SET @nomeregnoitem = 'Defugel'
END
IF(@regnoitem = 1)
BEGIN
SET @nomeregnoitem = 'Craxion'
END
IF(@regnoitem = 3 or @regnoitem = 4)
BEGIN
SET @nomeregnoitem = 'Gor'
END
/* Assegno nomi ai colori */
IF(@colore = 0)
BEGIN
SET @nomecolore = 'Nothing'
END
IF(@colore = 0 AND @livelloupgrade = 16 )
BEGIN
SET @nomecolore = 'Gold'
END
IF(@colore = 1)
BEGIN
SET @nomecolore = 'Blue'
END
IF(@colore = 2)
BEGIN
SET @nomecolore = 'Red'
END
IF(@colore = 3)
BEGIN
SET @nomecolore = 'Electric'
END
IF(@colore = 4)
BEGIN
SET @nomecolore = 'Sky-Blue'
END
IF(@colore = 5)
BEGIN
SET @nomecolore = 'Black-Green'
END
IF(@colore = 6)
BEGIN
SET @nomecolore = 'Purple'
END
IF(@colore = 7)
BEGIN
SET @nomecolore = 'Blue Storm'
END
IF(@colore = 8)
BEGIN
SET @nomecolore = 'Light Green'
END
IF(@colore = 9)
BEGIN
SET @nomecolore = 'Red Lava'
END
/* Assegno nomi ai bonus */
IF(@primobonus = 11)
BEGIN
SET @nomeprimobonus = 'Attack Rating'
END
IF(@secondobonus = 11)
BEGIN
SET @nomesecondobonus = 'Attack Rating'
END
IF(@terzobonus = 11)
BEGIN
SET @nometerzobonus = 'Attack Rating'
END
IF(@quartobonus = 11)
BEGIN
SET @nomequartobonus = 'Attack Rating'
END
IF(@primobonus = 12)
BEGIN
SET @nomeprimobonus = 'Defense rating'
END
IF(@secondobonus = 12)
BEGIN
SET @nomesecondobonus = 'Defense rating'
END
IF(@terzobonus = 12)
BEGIN
SET @nometerzobonus = 'Defense rating'
END
IF(@quartobonus = 12)
BEGIN
SET @nomequartobonus = 'Defense rating'
END
IF(@primobonus = 13)
BEGIN
SET @nomeprimobonus = 'Phsycal critical hit rate'
END
IF(@secondobonus = 13)
BEGIN
SET @nomesecondobonus = 'Phsycal critical hit rate'
END
IF(@terzobonus = 13)
BEGIN
SET @nometerzobonus = 'Phsycal critical hit rate'
END
IF(@quartobonus = 13)
BEGIN
SET @nomequartobonus = 'Phsycal critical hit rate'
END
IF(@primobonus = 20)
BEGIN
SET @nomeprimobonus = 'Cast rate'
END
IF(@secondobonus = 20)
BEGIN
SET @nomesecondobonus = 'Cast rate'
END
IF(@terzobonus = 20)
BEGIN
SET @nometerzobonus = 'Cast rate'
END
IF(@quartobonus = 20)
BEGIN
SET @nomequartobonus = 'Cast rate'
END
IF(@primobonus = 21)
BEGIN
SET @nomeprimobonus = 'Critical magic rate'
END
IF(@secondobonus = 21)
BEGIN
SET @nomesecondobonus = 'Critical magic rate'
END
IF(@terzobonus = 21)
BEGIN
SET @nometerzobonus = 'Critical magic rate'
END
IF(@quartobonus = 21)
BEGIN
SET @nomequartobonus = 'Critical magic rate'
END
IF(@primobonus = 34)
BEGIN
SET @nomeprimobonus = 'Block rate'
END
IF(@secondobonus = 34)
BEGIN
SET @nomesecondobonus = 'Block rate'
END
IF(@terzobonus = 34)
BEGIN
SET @nometerzobonus = 'Block rate'
END
IF(@quartobonus = 34)
BEGIN
SET @nomequartobonus = 'Block rate'
END
IF(@primobonus = 54)
BEGIN
SET @nomeprimobonus = 'Phsycal attack speed'
END
IF(@secondobonus = 54)
BEGIN
SET @nomesecondobonus = 'Phsycal attack speed'
END
IF(@terzobonus = 54)
BEGIN
SET @nometerzobonus = 'Phsycal attack speed'
END
IF(@quartobonus = 54)
BEGIN
SET @nomequartobonus = 'Phsycal attack speed'
END
IF(@primobonus = 55)
BEGIN
SET @nomeprimobonus = 'Longe range attack speed'
END
IF(@secondobonus = 55)
BEGIN
SET @nomesecondobonus = 'Longe range attack speed'
END
IF(@terzobonus = 55)
BEGIN
SET @nometerzobonus = 'Longe range attack speed'
END
IF(@quartobonus = 55)
BEGIN
SET @nomequartobonus = 'Longe range attack speed'
END
IF(@primobonus = 56)
BEGIN
SET @nomeprimobonus = 'Magic attack speed'
END
IF(@secondobonus = 56)
BEGIN
SET @nomesecondobonus = 'Magic attack speed'
END
IF(@terzobonus = 56)
BEGIN
SET @nometerzobonus = 'Magic attack speed'
END
IF(@quartobonus = 56)
BEGIN
SET @nomequartobonus = 'Magic attack speed'
END
IF(@primobonus = 86)
BEGIN
SET @nomeprimobonus = 'Magic attack'
END
IF(@secondobonus = 86)
BEGIN
SET @nomesecondobonus = 'Magic attack'
END
IF(@terzobonus = 86)
BEGIN
SET @nometerzobonus = 'Magic attack'
END
IF(@quartobonus = 86)
BEGIN
SET @nomequartobonus = 'Magic attack'
END
IF(@primobonus = 87)
BEGIN
SET @nomeprimobonus = 'Magic defense level'
END
IF(@secondobonus = 87)
BEGIN
SET @nomesecondobonus = 'Magic defense level'
END
IF(@terzobonus = 87)
BEGIN
SET @nometerzobonus = 'Magic defense level'
END
IF(@quartobonus = 87)
BEGIN
SET @nomequartobonus = 'Magic defense level'
END
INSERT INTO EquipInformations(Name,Item,Type,Upgrade,Color,Refinament,DurabilityCurrent,DurabilityMax,CountryItem,FirstBonus,FirstValue,SecondBonus,SecondValue,ThirdBonus,ThirdValue,FourthBonus,FourthValue)
VALUES(@nomepersonaggio,@nomeitem,@nomeposizione,@livelloupgrade,@nomecolore,@raffinamenti,@durabilitacorrente,@durabilitamax,@nomeregnoitem,@nomeprimobonus,@primovalore,@nomesecondobonus,@secondovalore,@nometerzobonus,@terzovalore,@nomequartobonus,@quartovalore)
SET @nomeprimobonus =''
SET @nomesecondobonus=''
SET @nometerzobonus =''
SET @nomequartobonus=''
SELECT @itemid=wItemID,@livelloupgrade = bLevel,@raffinamenti = bRefineCur, @durabilitacorrente = dwDuraCur, @durabilitamax = dwDuraMax, @colore = bGradeEffect, @primobonus = bMagic1, @primovalore = wValue1, @secondobonus = bMagic2, @secondovalore = wValue2, @terzobonus = bMagic3, @terzovalore = wValue3, @quartobonus = bMagic4, @quartovalore = wValue4 FROM TITEMTABLE WHERE dwOwnerID = @dwCharID AND bItemID = 6 AND dwStorageID = 254
SELECT @nomeitem = szNAME, @regnoitem = bItemCountry FROM TITEMCHART WHERE wItemID = @itemid
SET @nomeposizione = 'Trousers'
SET @posizioneitem = 6
IF(@regnoitem = 0)
BEGIN
SET @nomeregnoitem = 'Defugel'
END
IF(@regnoitem = 1)
BEGIN
SET @nomeregnoitem = 'Craxion'
END
IF(@regnoitem = 3 or @regnoitem = 4)
BEGIN
SET @nomeregnoitem = 'Gor'
END
/* Assegno nomi ai colori */
IF(@colore = 0)
BEGIN
SET @nomecolore = 'Nothing'
END
IF(@colore = 0 AND @livelloupgrade = 16 )
BEGIN
SET @nomecolore = 'Gold'
END
IF(@colore = 1)
BEGIN
SET @nomecolore = 'Blue'
END
IF(@colore = 2)
BEGIN
SET @nomecolore = 'Red'
END
IF(@colore = 3)
BEGIN
SET @nomecolore = 'Electric'
END
IF(@colore = 4)
BEGIN
SET @nomecolore = 'Sky-Blue'
END
IF(@colore = 5)
BEGIN
SET @nomecolore = 'Black-Green'
END
IF(@colore = 6)
BEGIN
SET @nomecolore = 'Purple'
END
IF(@colore = 7)
BEGIN
SET @nomecolore = 'Blue Storm'
END
IF(@colore = 8)
BEGIN
SET @nomecolore = 'Light Green'
END
IF(@colore = 9)
BEGIN
SET @nomecolore = 'Red Lava'
END
/* Assegno nomi ai bonus */
IF(@primobonus = 11)
BEGIN
SET @nomeprimobonus = 'Attack Rating'
END
IF(@secondobonus = 11)
BEGIN
SET @nomesecondobonus = 'Attack Rating'
END
IF(@terzobonus = 11)
BEGIN
SET @nometerzobonus = 'Attack Rating'
END
IF(@quartobonus = 11)
BEGIN
SET @nomequartobonus = 'Attack Rating'
END
IF(@primobonus = 12)
BEGIN
SET @nomeprimobonus = 'Defense rating'
END
IF(@secondobonus = 12)
BEGIN
SET @nomesecondobonus = 'Defense rating'
END
IF(@terzobonus = 12)
BEGIN
SET @nometerzobonus = 'Defense rating'
END
IF(@quartobonus = 12)
BEGIN
SET @nomequartobonus = 'Defense rating'
END
IF(@primobonus = 13)
BEGIN
SET @nomeprimobonus = 'Phsycal critical hit rate'
END
IF(@secondobonus = 13)
BEGIN
SET @nomesecondobonus = 'Phsycal critical hit rate'
END
IF(@terzobonus = 13)
BEGIN
SET @nometerzobonus = 'Phsycal critical hit rate'
END
IF(@quartobonus = 13)
BEGIN
SET @nomequartobonus = 'Phsycal critical hit rate'
END
IF(@primobonus = 20)
BEGIN
SET @nomeprimobonus = 'Cast rate'
END
IF(@secondobonus = 20)
BEGIN
SET @nomesecondobonus = 'Cast rate'
END
IF(@terzobonus = 20)
BEGIN
SET @nometerzobonus = 'Cast rate'
END
IF(@quartobonus = 20)
BEGIN
SET @nomequartobonus = 'Cast rate'
END
IF(@primobonus = 21)
BEGIN
SET @nomeprimobonus = 'Critical magic rate'
END
IF(@secondobonus = 21)
BEGIN
SET @nomesecondobonus = 'Critical magic rate'
END
IF(@terzobonus = 21)
BEGIN
SET @nometerzobonus = 'Critical magic rate'
END
IF(@quartobonus = 21)
BEGIN
SET @nomequartobonus = 'Critical magic rate'
END
IF(@primobonus = 34)
BEGIN
SET @nomeprimobonus = 'Block rate'
END
IF(@secondobonus = 34)
BEGIN
SET @nomesecondobonus = 'Block rate'
END
IF(@terzobonus = 34)
BEGIN
SET @nometerzobonus = 'Block rate'
END
IF(@quartobonus = 34)
BEGIN
SET @nomequartobonus = 'Block rate'
END
IF(@primobonus = 54)
BEGIN
SET @nomeprimobonus = 'Phsycal attack speed'
END
IF(@secondobonus = 54)
BEGIN
SET @nomesecondobonus = 'Phsycal attack speed'
END
IF(@terzobonus = 54)
BEGIN
SET @nometerzobonus = 'Phsycal attack speed'
END
IF(@quartobonus = 54)
BEGIN
SET @nomequartobonus = 'Phsycal attack speed'
END
IF(@primobonus = 55)
BEGIN
SET @nomeprimobonus = 'Longe range attack speed'
END
IF(@secondobonus = 55)
BEGIN
SET @nomesecondobonus = 'Longe range attack speed'
END
IF(@terzobonus = 55)
BEGIN
SET @nometerzobonus = 'Longe range attack speed'
END
IF(@quartobonus = 55)
BEGIN
SET @nomequartobonus = 'Longe range attack speed'
END
IF(@primobonus = 56)
BEGIN
SET @nomeprimobonus = 'Magic attack speed'
END
IF(@secondobonus = 56)
BEGIN
SET @nomesecondobonus = 'Magic attack speed'
END
IF(@terzobonus = 56)
BEGIN
SET @nometerzobonus = 'Magic attack speed'
END
IF(@quartobonus = 56)
BEGIN
SET @nomequartobonus = 'Magic attack speed'
END
IF(@primobonus = 86)
BEGIN
SET @nomeprimobonus = 'Magic attack'
END
IF(@secondobonus = 86)
BEGIN
SET @nomesecondobonus = 'Magic attack'
END
IF(@terzobonus = 86)
BEGIN
SET @nometerzobonus = 'Magic attack'
END
IF(@quartobonus = 86)
BEGIN
SET @nomequartobonus = 'Magic attack'
END
IF(@primobonus = 87)
BEGIN
SET @nomeprimobonus = 'Magic defense level'
END
IF(@secondobonus = 87)
BEGIN
SET @nomesecondobonus = 'Magic defense level'
END
IF(@terzobonus = 87)
BEGIN
SET @nometerzobonus = 'Magic defense level'
END
IF(@quartobonus = 87)
BEGIN
SET @nomequartobonus = 'Magic defense level'
END
INSERT INTO EquipInformations(Name,Item,Type,Upgrade,Color,Refinament,DurabilityCurrent,DurabilityMax,CountryItem,FirstBonus,FirstValue,SecondBonus,SecondValue,ThirdBonus,ThirdValue,FourthBonus,FourthValue)
VALUES(@nomepersonaggio,@nomeitem,@nomeposizione,@livelloupgrade,@nomecolore,@raffinamenti,@durabilitacorrente,@durabilitamax,@nomeregnoitem,@nomeprimobonus,@primovalore,@nomesecondobonus,@secondovalore,@nometerzobonus,@terzovalore,@nomequartobonus,@quartovalore)
SET @nomeprimobonus =''
SET @nomesecondobonus=''
SET @nometerzobonus =''
SET @nomequartobonus=''
SELECT @itemid=wItemID,@livelloupgrade = bLevel,@raffinamenti = bRefineCur, @durabilitacorrente = dwDuraCur, @durabilitamax = dwDuraMax, @colore = bGradeEffect, @primobonus = bMagic1, @primovalore = wValue1, @secondobonus = bMagic2, @secondovalore = wValue2, @terzobonus = bMagic3, @terzovalore = wValue3, @quartobonus = bMagic4, @quartovalore = wValue4 FROM TITEMTABLE WHERE dwOwnerID = @dwCharID AND bItemID = 7 AND dwStorageID = 254
SELECT @nomeitem = szNAME, @regnoitem = bItemCountry FROM TITEMCHART WHERE wItemID = @itemid
SET @nomeposizione = 'Boots'
SET @posizioneitem = 7
IF(@regnoitem = 0)
BEGIN
SET @nomeregnoitem = 'Defugel'
END
IF(@regnoitem = 1)
BEGIN
SET @nomeregnoitem = 'Craxion'
END
IF(@regnoitem = 3 or @regnoitem = 4)
BEGIN
SET @nomeregnoitem = 'Gor'
END
/* Assegno nomi ai colori */
IF(@colore = 0)
BEGIN
SET @nomecolore = 'Nothing'
END
IF(@colore = 0 AND @livelloupgrade = 16 )
BEGIN
SET @nomecolore = 'Gold'
END
IF(@colore = 1)
BEGIN
SET @nomecolore = 'Blue'
END
IF(@colore = 2)
BEGIN
SET @nomecolore = 'Red'
END
IF(@colore = 3)
BEGIN
SET @nomecolore = 'Electric'
END
IF(@colore = 4)
BEGIN
SET @nomecolore = 'Sky-Blue'
END
IF(@colore = 5)
BEGIN
SET @nomecolore = 'Black-Green'
END
IF(@colore = 6)
BEGIN
SET @nomecolore = 'Purple'
END
IF(@colore = 7)
BEGIN
SET @nomecolore = 'Blue Storm'
END
IF(@colore = 8)
BEGIN
SET @nomecolore = 'Light Green'
END
IF(@colore = 9)
BEGIN
SET @nomecolore = 'Red Lava'
END
/* Assegno nomi ai bonus */
IF(@primobonus = 11)
BEGIN
SET @nomeprimobonus = 'Attack Rating'
END
IF(@secondobonus = 11)
BEGIN
SET @nomesecondobonus = 'Attack Rating'
END
IF(@terzobonus = 11)
BEGIN
SET @nometerzobonus = 'Attack Rating'
END
IF(@quartobonus = 11)
BEGIN
SET @nomequartobonus = 'Attack Rating'
END
IF(@primobonus = 12)
BEGIN
SET @nomeprimobonus = 'Defense rating'
END
IF(@secondobonus = 12)
BEGIN
SET @nomesecondobonus = 'Defense rating'
END
IF(@terzobonus = 12)
BEGIN
SET @nometerzobonus = 'Defense rating'
END
IF(@quartobonus = 12)
BEGIN
SET @nomequartobonus = 'Defense rating'
END
IF(@primobonus = 13)
BEGIN
SET @nomeprimobonus = 'Phsycal critical hit rate'
END
IF(@secondobonus = 13)
BEGIN
SET @nomesecondobonus = 'Phsycal critical hit rate'
END
IF(@terzobonus = 13)
BEGIN
SET @nometerzobonus = 'Phsycal critical hit rate'
END
IF(@quartobonus = 13)
BEGIN
SET @nomequartobonus = 'Phsycal critical hit rate'
END
IF(@primobonus = 20)
BEGIN
SET @nomeprimobonus = 'Cast rate'
END
IF(@secondobonus = 20)
BEGIN
SET @nomesecondobonus = 'Cast rate'
END
IF(@terzobonus = 20)
BEGIN
SET @nometerzobonus = 'Cast rate'
END
IF(@quartobonus = 20)
BEGIN
SET @nomequartobonus = 'Cast rate'
END
IF(@primobonus = 21)
BEGIN
SET @nomeprimobonus = 'Critical magic rate'
END
IF(@secondobonus = 21)
BEGIN
SET @nomesecondobonus = 'Critical magic rate'
END
IF(@terzobonus = 21)
BEGIN
SET @nometerzobonus = 'Critical magic rate'
END
IF(@quartobonus = 21)
BEGIN
SET @nomequartobonus = 'Critical magic rate'
END
IF(@primobonus = 34)
BEGIN
SET @nomeprimobonus = 'Block rate'
END
IF(@secondobonus = 34)
BEGIN
SET @nomesecondobonus = 'Block rate'
END
IF(@terzobonus = 34)
BEGIN
SET @nometerzobonus = 'Block rate'
END
IF(@quartobonus = 34)
BEGIN
SET @nomequartobonus = 'Block rate'
END
IF(@primobonus = 54)
BEGIN
SET @nomeprimobonus = 'Phsycal attack speed'
END
IF(@secondobonus = 54)
BEGIN
SET @nomesecondobonus = 'Phsycal attack speed'
END
IF(@terzobonus = 54)
BEGIN
SET @nometerzobonus = 'Phsycal attack speed'
END
IF(@quartobonus = 54)
BEGIN
SET @nomequartobonus = 'Phsycal attack speed'
END
IF(@primobonus = 55)
BEGIN
SET @nomeprimobonus = 'Longe range attack speed'
END
IF(@secondobonus = 55)
BEGIN
SET @nomesecondobonus = 'Longe range attack speed'
END
IF(@terzobonus = 55)
BEGIN
SET @nometerzobonus = 'Longe range attack speed'
END
IF(@quartobonus = 55)
BEGIN
SET @nomequartobonus = 'Longe range attack speed'
END
IF(@primobonus = 56)
BEGIN
SET @nomeprimobonus = 'Magic attack speed'
END
IF(@secondobonus = 56)
BEGIN
SET @nomesecondobonus = 'Magic attack speed'
END
IF(@terzobonus = 56)
BEGIN
SET @nometerzobonus = 'Magic attack speed'
END
IF(@quartobonus = 56)
BEGIN
SET @nomequartobonus = 'Magic attack speed'
END
IF(@primobonus = 86)
BEGIN
SET @nomeprimobonus = 'Magic attack'
END
IF(@secondobonus = 86)
BEGIN
SET @nomesecondobonus = 'Magic attack'
END
IF(@terzobonus = 86)
BEGIN
SET @nometerzobonus = 'Magic attack'
END
IF(@quartobonus = 86)
BEGIN
SET @nomequartobonus = 'Magic attack'
END
IF(@primobonus = 87)
BEGIN
SET @nomeprimobonus = 'Magic defense level'
END
IF(@secondobonus = 87)
BEGIN
SET @nomesecondobonus = 'Magic defense level'
END
IF(@terzobonus = 87)
BEGIN
SET @nometerzobonus = 'Magic defense level'
END
IF(@quartobonus = 87)
BEGIN
SET @nomequartobonus = 'Magic defense level'
END
INSERT INTO EquipInformations(Name,Item,Type,Upgrade,Color,Refinament,DurabilityCurrent,DurabilityMax,CountryItem,FirstBonus,FirstValue,SecondBonus,SecondValue,ThirdBonus,ThirdValue,FourthBonus,FourthValue)
VALUES(@nomepersonaggio,@nomeitem,@nomeposizione,@livelloupgrade,@nomecolore,@raffinamenti,@durabilitacorrente,@durabilitamax,@nomeregnoitem,@nomeprimobonus,@primovalore,@nomesecondobonus,@secondovalore,@nometerzobonus,@terzovalore,@nomequartobonus,@quartovalore)
SET @nomeprimobonus =''
SET @nomesecondobonus=''
SET @nometerzobonus =''
SET @nomequartobonus=''
SELECT @itemid=wItemID,@livelloupgrade = bLevel,@raffinamenti = bRefineCur, @durabilitacorrente = dwDuraCur, @durabilitamax = dwDuraMax, @colore = bGradeEffect, @primobonus = bMagic1, @primovalore = wValue1, @secondobonus = bMagic2, @secondovalore = wValue2, @terzobonus = bMagic3, @terzovalore = wValue3, @quartobonus = bMagic4, @quartovalore = wValue4 FROM TITEMTABLE WHERE dwOwnerID = @dwCharID AND bItemID = 8 AND dwStorageID = 254
SELECT @nomeitem = szNAME, @regnoitem = bItemCountry FROM TITEMCHART WHERE wItemID = @itemid
SET @nomeposizione = 'Gloves'
SET @posizioneitem = 8
IF(@regnoitem = 0)
BEGIN
SET @nomeregnoitem = 'Defugel'
END
IF(@regnoitem = 1)
BEGIN
SET @nomeregnoitem = 'Craxion'
END
IF(@regnoitem = 3 or @regnoitem = 4)
BEGIN
SET @nomeregnoitem = 'Gor'
END
/* Assegno nomi ai colori */
IF(@colore = 0)
BEGIN
SET @nomecolore = 'Nothing'
END
IF(@colore = 0 AND @livelloupgrade = 16 )
BEGIN
SET @nomecolore = 'Gold'
END
IF(@colore = 1)
BEGIN
SET @nomecolore = 'Blue'
END
IF(@colore = 2)
BEGIN
SET @nomecolore = 'Red'
END
IF(@colore = 3)
BEGIN
SET @nomecolore = 'Electric'
END
IF(@colore = 4)
BEGIN
SET @nomecolore = 'Sky-Blue'
END
IF(@colore = 5)
BEGIN
SET @nomecolore = 'Black-Green'
END
IF(@colore = 6)
BEGIN
SET @nomecolore = 'Purple'
END
IF(@colore = 7)
BEGIN
SET @nomecolore = 'Blue Storm'
END
IF(@colore = 8)
BEGIN
SET @nomecolore = 'Light Green'
END
IF(@colore = 9)
BEGIN
SET @nomecolore = 'Red Lava'
END
/* Assegno nomi ai bonus */
IF(@primobonus = 11)
BEGIN
SET @nomeprimobonus = 'Attack Rating'
END
IF(@secondobonus = 11)
BEGIN
SET @nomesecondobonus = 'Attack Rating'
END
IF(@terzobonus = 11)
BEGIN
SET @nometerzobonus = 'Attack Rating'
END
IF(@quartobonus = 11)
BEGIN
SET @nomequartobonus = 'Attack Rating'
END
IF(@primobonus = 12)
BEGIN
SET @nomeprimobonus = 'Defense rating'
END
IF(@secondobonus = 12)
BEGIN
SET @nomesecondobonus = 'Defense rating'
END
IF(@terzobonus = 12)
BEGIN
SET @nometerzobonus = 'Defense rating'
END
IF(@quartobonus = 12)
BEGIN
SET @nomequartobonus = 'Defense rating'
END
IF(@primobonus = 13)
BEGIN
SET @nomeprimobonus = 'Phsycal critical hit rate'
END
IF(@secondobonus = 13)
BEGIN
SET @nomesecondobonus = 'Phsycal critical hit rate'
END
IF(@terzobonus = 13)
BEGIN
SET @nometerzobonus = 'Phsycal critical hit rate'
END
IF(@quartobonus = 13)
BEGIN
SET @nomequartobonus = 'Phsycal critical hit rate'
END
IF(@primobonus = 20)
BEGIN
SET @nomeprimobonus = 'Cast rate'
END
IF(@secondobonus = 20)
BEGIN
SET @nomesecondobonus = 'Cast rate'
END
IF(@terzobonus = 20)
BEGIN
SET @nometerzobonus = 'Cast rate'
END
IF(@quartobonus = 20)
BEGIN
SET @nomequartobonus = 'Cast rate'
END
IF(@primobonus = 21)
BEGIN
SET @nomeprimobonus = 'Critical magic rate'
END
IF(@secondobonus = 21)
BEGIN
SET @nomesecondobonus = 'Critical magic rate'
END
IF(@terzobonus = 21)
BEGIN
SET @nometerzobonus = 'Critical magic rate'
END
IF(@quartobonus = 21)
BEGIN
SET @nomequartobonus = 'Critical magic rate'
END
IF(@primobonus = 34)
BEGIN
SET @nomeprimobonus = 'Block rate'
END
IF(@secondobonus = 34)
BEGIN
SET @nomesecondobonus = 'Block rate'
END
IF(@terzobonus = 34)
BEGIN
SET @nometerzobonus = 'Block rate'
END
IF(@quartobonus = 34)
BEGIN
SET @nomequartobonus = 'Block rate'
END
IF(@primobonus = 54)
BEGIN
SET @nomeprimobonus = 'Phsycal attack speed'
END
IF(@secondobonus = 54)
BEGIN
SET @nomesecondobonus = 'Phsycal attack speed'
END
IF(@terzobonus = 54)
BEGIN
SET @nometerzobonus = 'Phsycal attack speed'
END
IF(@quartobonus = 54)
BEGIN
SET @nomequartobonus = 'Phsycal attack speed'
END
IF(@primobonus = 55)
BEGIN
SET @nomeprimobonus = 'Longe range attack speed'
END
IF(@secondobonus = 55)
BEGIN
SET @nomesecondobonus = 'Longe range attack speed'
END
IF(@terzobonus = 55)
BEGIN
SET @nometerzobonus = 'Longe range attack speed'
END
IF(@quartobonus = 55)
BEGIN
SET @nomequartobonus = 'Longe range attack speed'
END
IF(@primobonus = 56)
BEGIN
SET @nomeprimobonus = 'Magic attack speed'
END
IF(@secondobonus = 56)
BEGIN
SET @nomesecondobonus = 'Magic attack speed'
END
IF(@terzobonus = 56)
BEGIN
SET @nometerzobonus = 'Magic attack speed'
END
IF(@quartobonus = 56)
BEGIN
SET @nomequartobonus = 'Magic attack speed'
END
IF(@primobonus = 86)
BEGIN
SET @nomeprimobonus = 'Magic attack'
END
IF(@secondobonus = 86)
BEGIN
SET @nomesecondobonus = 'Magic attack'
END
IF(@terzobonus = 86)
BEGIN
SET @nometerzobonus = 'Magic attack'
END
IF(@quartobonus = 86)
BEGIN
SET @nomequartobonus = 'Magic attack'
END
IF(@primobonus = 87)
BEGIN
SET @nomeprimobonus = 'Magic defense level'
END
IF(@secondobonus = 87)
BEGIN
SET @nomesecondobonus = 'Magic defense level'
END
IF(@terzobonus = 87)
BEGIN
SET @nometerzobonus = 'Magic defense level'
END
IF(@quartobonus = 87)
BEGIN
SET @nomequartobonus = 'Magic defense level'
END
INSERT INTO EquipInformations(Name,Item,Type,Upgrade,Color,Refinament,DurabilityCurrent,DurabilityMax,CountryItem,FirstBonus,FirstValue,SecondBonus,SecondValue,ThirdBonus,ThirdValue,FourthBonus,FourthValue)
VALUES(@nomepersonaggio,@nomeitem,@nomeposizione,@livelloupgrade,@nomecolore,@raffinamenti,@durabilitacorrente,@durabilitamax,@nomeregnoitem,@nomeprimobonus,@primovalore,@nomesecondobonus,@secondovalore,@nometerzobonus,@terzovalore,@nomequartobonus,@quartovalore)
END
Add this linee in the TCreateChar always in TGAME_GSP, frist of
RETURN @@ERROR
PHP Code:
EXEC TEquipInfo @dwCharID, @dwUserID
Add this linee in the TLogout always in TGAME_GSP, frist of
COMMIT TRAN SAVECHAREND
PHP Code:
DECLARE @name VARCHAR(50)
SELECT @name = szNAME FROM TCHARTABLE WHERE dwCharID=@dwCharID
DELETE EquipInformations WHERE Name = @name
EXEC TEquipInfo @dwCharID, @dwUserID
if you have the bug called "Objectname not found"
follow this path
 |
Brain.exe is utily for creat fonction i need helppp
|
|
|
|
|
06/28/2013, 22:55
|
#13
|
elite*gold: 0
Join Date: Apr 2011
Posts: 219
Received Thanks: 69
|
Quote:
Originally Posted by NekFeu
Brain.exe is utily for creat fonction i need helppp
|
yes, you really need help if you think that "brain.exe" is a utility to create a function.
|
|
|
|
 |
Similar Threads
|
Bedeutung der Spalten in TITEMTABLE
03/09/2013 - 4Story - 0 Replies
Wem die Bedeutung der Spalten in der TITEMTABLE unklar ist und was dort
hineinkommt, hier ist eine Liste.
Ich kenne allerdings nicht alle Bedeutungen, aber die Wichtigsten.
dlID
Dies ist die ID des Itemstapels/des Items.
bStorageType
Standardmäßig auf 0.
Es gibt wohl auch noch 2, ich weiß aber nicht, wofür das steht.
|
[HELP]4Story P-Server 'TITEMTABLE' is not up to date
01/28/2013 - 4Story - 5 Replies
Hi,
I have a problem again, I don't what's the issue's name, but let me explain it:
I have about 25-35 chars on my server and 21 accounts. Yes we use the server (it's the first hungarian pirvate server :D).
In the TITEMTABLE and in the TTEMPITEMTABLE (TGAME_GSP) I can't found the charachter's equipments but they have items I'm sure.
Do you know why the data in these tables doesn't exists, or do you know how to solve that?
Thanks.
|
[Release]Alternative Inventory
10/20/2012 - Flyff PServer Guides & Releases - 10 Replies
Hey, hatte gerade wieder etwas hier rum geguckt und dann das TradeWindow von Apfelsuchtii gesehen, also wollte ich auch mal irgendein Window releasen.
Im Theme Ordner habe ich ein Inventar gefunden, diese beinhaltete allerdings Tabs, also habe ich die rausgenommen und die ItemPositionen geändert.
Das ganze sieht (wie ich finde) aus wie der Vorgänger des v15 Inventars:
http://www8.pic-upload.de/17.09.11/evn3s7wc2mwo.p ng
Was ihr machen müsst ?
Sucht in eurer ResData.inc nach...
|
[RELEASE]Alternative zu Grannyviewer 3D
04/29/2012 - Metin2 PServer Guides & Strategies - 87 Replies
Hallu Community,
habt schon lange nichts mehr von mir gehört ich weiß :o
Möchte euch heute eine alternative zu Grannyviewer anbieten. Es handelt sich hierbei um das offizielle Tool von Ymir, das mittlerweile schon ohne großen Funktionsumfang im Forum gepostet wurde, weswegen ich mich jetzt dazu entschlossen habe das Programm zu releasen.
Kleine Information am Rande: Das Tool wurde von mir teilweiße auf Deutsch übersetzt, wer möchte kann sich an den Rest machen - wusste an einigen Stellen...
|
[Release]The alternative Wallhack
11/18/2008 - Dekaron Exploits, Hacks, Bots, Tools & Macros - 15 Replies
DO NOT RUN THIS SCRIPT OVER YOUR DATA.PAK!!!
I figured pre-bmr out, that you can manually wallhack, if you change the content of mapname.mac.
Of course you need to play with unpacked files to be able to use this, but I think the content of the .mac files should be somewhere in the data.pak too.
Open the .mac files of the maps you want to modify in Winhex and let the script in the attachment run over it.
You could do it yourselfe by changing all hex values to "00".
The value "02" are...
|
All times are GMT +2. The time now is 00:09.
|
|
![[Release]Alternative for TITEMTABLE](https://www.elitepvpers.com/forum/iconimages/4story/release-alternative-titemtable_ltr.gif){kind=small}
