boas pessoal retirei esta arma de um cliente e queria adecionar ao meu server ja adecionei na parte do cliente mas nao consigo a query para a meter pelo navicat uso as files metin2limit v3.5
mas ao adecionar essa query no navicat dame o seguinte erro: [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Mortal +1, 0)' at line 1
se alguem poder ajudar agradecia
ja consegui adecionar mas a nao aparece o icon da arma no inventario meti os tga e gr2 que tinha da arma e nao aparece la no inventario quando a uso a arma simplesmente fica toda branca
boas pessoal retirei esta arma de um cliente e queria adecionar ao meu server ja adecionei na parte do cliente mas nao consigo a query para a meter pelo navicat uso as files metin2limit v3.5
o item proto em questao é este:
<ItemDef Vnum="6300" Name="Espada Mortal +0" LocalizedName="Espada Mortal +0" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="0" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="100" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="10" ApplyType1="17" ApplyValue1="15" ApplyType2="12" ApplyValue2="15" Value0="0" Value1="780" Value2="800" Value3="820" Value4="840" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="6301" RefineSet="0" AlterToMagicItemPercent="5" Specular="0" GainSocketPercent="3" AddonType="0" />
<ItemDef Vnum="6301" Name="Espada Mortal +1" LocalizedName="Espada Mortal +1" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="0" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="100" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="10" ApplyType1="17" ApplyValue1="15" ApplyType2="12" ApplyValue2="15" Value0="0" Value1="780" Value2="800" Value3="820" Value4="840" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="6302" RefineSet="0" AlterToMagicItemPercent="5" Specular="0" GainSocketPercent="3" AddonType="0" />
<ItemDef Vnum="6302" Name="Espada Mortal +2" LocalizedName="Espada Mortal +2" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="0" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="100" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="10" ApplyType1="17" ApplyValue1="15" ApplyType2="12" ApplyValue2="15" Value0="0" Value1="780" Value2="800" Value3="820" Value4="840" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="6303" RefineSet="0" AlterToMagicItemPercent="5" Specular="0" GainSocketPercent="3" AddonType="0" />
<ItemDef Vnum="6303" Name="Espada Mortal +3" LocalizedName="Espada Mortal +3" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="0" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="100" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="10" ApplyType1="17" ApplyValue1="15" ApplyType2="12" ApplyValue2="15" Value0="0" Value1="780" Value2="800" Value3="820" Value4="840" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="6304" RefineSet="0" AlterToMagicItemPercent="5" Specular="0" GainSocketPercent="3" AddonType="0" />
<ItemDef Vnum="6304" Name="Espada Mortal +4" LocalizedName="Espada Mortal +4" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="0" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="100" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="10" ApplyType1="17" ApplyValue1="15" ApplyType2="12" ApplyValue2="15" Value0="0" Value1="780" Value2="800" Value3="820" Value4="840" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="6305" RefineSet="0" AlterToMagicItemPercent="5" Specular="30" GainSocketPercent="3" AddonType="0" />
<ItemDef Vnum="6305" Name="Espada Mortal +5" LocalizedName="Espada Mortal +5" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="0" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="100" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="10" ApplyType1="17" ApplyValue1="15" ApplyType2="12" ApplyValue2="15" Value0="0" Value1="780" Value2="800" Value3="820" Value4="840" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="6306" RefineSet="0" AlterToMagicItemPercent="5" Specular="40" GainSocketPercent="3" AddonType="0" />
<ItemDef Vnum="6306" Name="Espada Mortal +6" LocalizedName="Espada Mortal +6" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="0" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="100" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="10" ApplyType1="17" ApplyValue1="15" ApplyType2="12" ApplyValue2="15" Value0="0" Value1="780" Value2="800" Value3="820" Value4="840" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="6307" RefineSet="0" AlterToMagicItemPercent="5" Specular="50" GainSocketPercent="3" AddonType="0" />
<ItemDef Vnum="6307" Name="Espada Mortal +7" LocalizedName="Espada Mortal +7" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="0" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="100" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="10" ApplyType1="17" ApplyValue1="15" ApplyType2="12" ApplyValue2="15" Value0="0" Value1="780" Value2="800" Value3="820" Value4="840" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="6308" RefineSet="0" AlterToMagicItemPercent="5" Specular="65" GainSocketPercent="3" AddonType="0" />
<ItemDef Vnum="6308" Name="Espada Mortal +8" LocalizedName="Espada Mortal +8" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="0" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="100" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="10" ApplyType1="17" ApplyValue1="15" ApplyType2="12" ApplyValue2="15" Value0="0" Value1="780" Value2="800" Value3="820" Value4="840" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="6309" RefineSet="0" AlterToMagicItemPercent="5" Specular="80" GainSocketPercent="3" AddonType="0" />
<ItemDef Vnum="6309" Name="Espada Mortal +9" LocalizedName="Espada Mortal +9" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="0" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="100" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="10" ApplyType1="17" ApplyValue1="15" ApplyType2="12" ApplyValue2="15" Value0="0" Value1="780" Value2="800" Value3="820" Value4="840" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="6309" RefineSet="0" AlterToMagicItemPercent="5" Specular="100" GainSocketPercent="3" AddonType="0" />
e ao converter para query por um pograma o que me da é isto:
INSERT INTO item_proto VALUES (6300, 'Espada Mortal +0', 'Espada Mortal +0', 1, 0, 0, 2, 56, 0, 16, 0, 0, 0, 0, 3, 0, 0, 1, 100, 0, 0, 7, 10, 17, 15, 12, 15, 0, 780, 800, 820, 840, 0, -1, -1, -1, -1, -1, -1, 6301, Espada Mortal +1, 0);
mas ao adecionar essa query no navicat dame o seguinte erro: [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Mortal +1, 0)' at line 1
se alguem poder ajudar agradecia
ja consegui adecionar mas a nao aparece o icon da arma no inventario meti os tga e gr2 que tinha da arma e nao aparece la no inventario quando a uso a arma simplesmente fica toda branca
Share this post
Link to post
Share on other sites