cerere Sql

Închis
Avatar utilizator
klaudyu14
Nivel 3

Nivel 3
Mesaje: 301
Membru din: 23 Iul 2014, 23:01
Server: www.metin2hyperx.com
Regat: Jinno
Aprecieri: 34  
Mulţumiri: 179  
 Contact:
Vezi detalii
Medalii

Salut! De cateva minute tot incerc sa convertesc itemproto.xml in sql. adica niste iteme pentru navicat. dar nu reusesc am varianta de 20/28/34k si 40k

Cod: Selectaţi tot

 	<Item vnum="85011" hashName="sash_03_1" name="Esarfã Suveran (normalã)" type="28" subtype="2" weight="0" size="1" antiflag="33152" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="1" applyvalue0="200" applytype1="17" applyvalue1="1" applytype2="63" applyvalue2="1" value0="1" value1="85012" value2="0" value3="9" value4="0" value5="0" socket0="0" socket1="0" socket2="0" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
	<Item vnum="85012" hashName="sash_03_2" name="Esarfã Suveran (finã)" type="28" subtype="2" weight="0" size="1" antiflag="33152" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="1" applyvalue0="300" applytype1="17" applyvalue1="2" applytype2="63" applyvalue2="2" value0="2" value1="85013" value2="0" value3="10" value4="0" value5="0" socket0="0" socket1="0" socket2="0" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
	<Item vnum="85013" hashName="sash_03_3" name="Esarfã Suveran (nobilã)" type="28" subtype="2" weight="0" size="1" antiflag="33152" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="1" applyvalue0="400" applytype1="17" applyvalue1="3" applytype2="63" applyvalue2="3" value0="3" value1="85014" value2="0" value3="11" value4="0" value5="0" socket0="0" socket1="0" socket2="0" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
	<Item vnum="85014" hashName="sash_03_4" name="Esarfã Suveran (avansat)" type="28" subtype="2" weight="0" size="1" antiflag="33152" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="1" applyvalue0="500" applytype1="17" applyvalue1="5" applytype2="63" applyvalue2="5" value0="4" value1="0" value2="0" value3="12" value4="0" value5="0" socket0="0" socket1="0" socket2="0" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
	<Item vnum="85015" hashName="sash_04_1" name="Esarfã Roialã (normalã)" type="28" subtype="2" weight="0" size="1" antiflag="33152" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="1" applyvalue0="200" applytype1="17" applyvalue1="1" applytype2="63" applyvalue2="1" value0="1" value1="85016" value2="0" value3="13" value4="0" value5="0" socket0="0" socket1="0" socket2="0" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
	<Item vnum="85016" hashName="sash_04_2" name="Esarfã Roialã (finã)" type="28" subtype="2" weight="0" size="1" antiflag="33152" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="1" applyvalue0="300" applytype1="17" applyvalue1="2" applytype2="63" applyvalue2="2" value0="2" value1="85017" value2="0" value3="14" value4="0" value5="0" socket0="0" socket1="0" socket2="0" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
	<Item vnum="85017" hashName="sash_04_3" name="Esarfã Roialã (nobilã)" type="28" subtype="2" weight="0" size="1" antiflag="33152" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="1" applyvalue0="400" applytype1="17" applyvalue1="3" applytype2="63" applyvalue2="3" value0="3" value1="85018" value2="0" value3="15" value4="0" value5="0" socket0="0" socket1="0" socket2="0" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
	<Item vnum="85018" hashName="sash_04_4" name="Esarfã Roialã (avansatã)" type="28" subtype="2" weight="0" size="1" antiflag="33152" flag="0" wearflag="0" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="1" applyvalue0="500" applytype1="17" applyvalue1="5" applytype2="63" applyvalue2="5" value0="4" value1="0" value2="0" value3="16" value4="0" value5="0" socket0="0" socket1="0" socket2="0" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
40k

Cod: Selectaţi tot

 	<ItemDef Vnum="85011" Name="sash_03_1" LocalizedName="Esarfã Suveran (normalã)" Type="28" SubType="2" Weight="0" Size="1" AntiFlags="33152" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="1" ApplyValue0="200" ApplyType1="17" ApplyValue1="1" ApplyType2="63" ApplyValue2="1" Value0="1" Value1="85012" Value2="0" Value3="9" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0"  />
	<ItemDef Vnum="85012" Name="sash_03_2" LocalizedName="Esarfã Suveran (finã)" Type="28" SubType="2" Weight="0" Size="1" AntiFlags="33152" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="1" ApplyValue0="300" ApplyType1="17" ApplyValue1="2" ApplyType2="63" ApplyValue2="2" Value0="2" Value1="85013" Value2="0" Value3="10" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0"  />
	<ItemDef Vnum="85013" Name="sash_03_3" LocalizedName="Esarfã Suveran (nobilã)" Type="28" SubType="2" Weight="0" Size="1" AntiFlags="33152" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="1" ApplyValue0="400" ApplyType1="17" ApplyValue1="3" ApplyType2="63" ApplyValue2="3" Value0="3" Value1="85014" Value2="0" Value3="11" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0"  />
	<ItemDef Vnum="85014" Name="sash_03_4" LocalizedName="Esarfã Suveran (avansat)" Type="28" SubType="2" Weight="0" Size="1" AntiFlags="33152" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="1" ApplyValue0="500" ApplyType1="17" ApplyValue1="5" ApplyType2="63" ApplyValue2="5" Value0="4" Value1="0" Value2="0" Value3="12" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0"  />
	<ItemDef Vnum="85015" Name="sash_04_1" LocalizedName="Esarfã Roialã (normalã)" Type="28" SubType="2" Weight="0" Size="1" AntiFlags="33152" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="1" ApplyValue0="200" ApplyType1="17" ApplyValue1="1" ApplyType2="63" ApplyValue2="1" Value0="1" Value1="85016" Value2="0" Value3="13" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0"  />
	<ItemDef Vnum="85016" Name="sash_04_2" LocalizedName="Esarfã Roialã (finã)" Type="28" SubType="2" Weight="0" Size="1" AntiFlags="33152" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="1" ApplyValue0="300" ApplyType1="17" ApplyValue1="2" ApplyType2="63" ApplyValue2="2" Value0="2" Value1="85017" Value2="0" Value3="14" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0"  />
	<ItemDef Vnum="85017" Name="sash_04_3" LocalizedName="Esarfã Roialã (nobilã)" Type="28" SubType="2" Weight="0" Size="1" AntiFlags="33152" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="1" ApplyValue0="400" ApplyType1="17" ApplyValue1="3" ApplyType2="63" ApplyValue2="3" Value0="3" Value1="85018" Value2="0" Value3="15" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0"  />
	<ItemDef Vnum="85018" Name="sash_04_4" LocalizedName="Esarfã Roialã (avansatã)" Type="28" SubType="2" Weight="0" Size="1" AntiFlags="33152" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="1" ApplyValue0="500" ApplyType1="17" ApplyValue1="5" ApplyType2="63" ApplyValue2="5" Value0="4" Value1="0" Value2="0" Value3="16" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0"  />
AM NEVOIE PENTRU SQL ADICA PENTRU NAVICAT. Multumesc
Afișează semnătura
Sus
Avatar utilizator
klaudyu14
Nivel 3

Nivel 3
Mesaje: 301
Membru din: 23 Iul 2014, 23:01
Server: www.metin2hyperx.com
Regat: Jinno
Aprecieri: 34  
Mulţumiri: 179  
 Contact:
Vezi detalii
Medalii

up
Afișează semnătura
Sus
Avatar utilizator
Ionuț Daniel
Nivel 8

Nivel 8
Mesaje: 1724
Membru din: 19 Noi 2016, 14:52
Aprecieri: 156  
Mulţumiri: 135  
 Contact:
Vezi detalii
Medalii

Subiect marcat ca fiind rezolvat. închis.
Mutat în cereri rezolvate.
Sus
Închis

Înapoi la “Cereri Rezolvate”

  • Informaţie

  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 4 vizitatori

+ Anunțul tău aici + Anunțul tău aici + Anunțul tău aici + Anunțul tău aici