antiblock
diamwall

  • Chatbox

    Did you check out our Discord? https://discord.gg/FFdvMjk9xA
    You don't have permission to chat.
    Load More
  • 0
Sign in to follow this  
Followers 0
Low&SlowPT

ajuda a criar query deste item proto

Asked by Low&SlowPT,

Question

Low&SlowPT    58

Low&SlowPT
Posted (edited)

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: 

Spoiler

    <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:

Spoiler

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

 

Edited by Low&SlowPT (see edit history)

Share this post

Link to post
Share on other sites

3 answers to this question

  • 0

hardzone    85

hardzone
Posted

agarras numa query que de mudas o ID e o valor de dano e tudo o que esteja diferente e prontos Done, Facil

Share this post

Link to post
Share on other sites
antiblock
https://arwen2.global/
  • 0

Low&SlowPT    58

Low&SlowPT
Posted
18 minutos atrás, hardzone disse:

agarras numa query que de mudas o ID e o valor de dano e tudo o que esteja diferente e prontos Done, Facil

ja resolvi so nao consegui resolver a arma ficar branca...   Sem_t_tulo.png

 

gamegamegameee reacted to this

Share this post

Link to post
Share on other sites
  • 0

hardzone    85

hardzone
Posted

tens de copiar as linhas do item_item (se nao me engano) um ficheiro TXT no cliente

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0
Go To Question Listing Dúvidas & Pedidos