Convertire sql in xlm

Totalitatea subiectelor care nu respectă regulamentul impus in sectiunea "Probleme şi Întrebări" vor fi stocate aici.
Închis
Avatar utilizator
RID8Rgaming
Nivel 3

Nivel 3
Mesaje: 316
Membru din: 01 Feb 2016, 05:08
Regat: Jinno
Aprecieri: 128  
Mulţumiri: 2  
 Contact:
Vezi detalii
Medalii

Nu pot sa convertesc item_proto.sql in item_proto.xlm
Site-ul http://www.stevecraft.cz/hracky/ip_sql_to_xml.php nu este bun.
Versiunea game, clinet: 40k
Imagine
Afișează semnătura
Sus
Avatar utilizator
Titan
Metin Master

Metin Master
Mesaje: 2783
Membru din: 01 Iun 2015, 15:09
Server: In curand.
Regat: Chunjo
Aprecieri: 42  
Mulţumiri: 377  
  Rezolvări prob.: 3
Discord: Copiază ID
 Contact:
Vezi detalii
Medalii

RID8Rgaming scrie:Nu pot sa convertesc item_proto.sql in item_proto.xlm
Site-ul http://www.stevecraft.cz/hracky/ip_sql_to_xml.php nu este bun.
Versiunea game, clinet: 40k
Ba este foarte bun dar bănuiesc că ești tu paralel ;))
lasă liniile aici în code și te ajut eu
Imagine
Afișează semnătura
Sus
Avatar utilizator
RID8Rgaming
Nivel 3

Nivel 3
Mesaje: 316
Membru din: 01 Feb 2016, 05:08
Regat: Jinno
Aprecieri: 128  
Mulţumiri: 2  
 Contact:
Vezi detalii
Medalii

fumigena65 scrie:
RID8Rgaming scrie:Nu pot sa convertesc item_proto.sql in item_proto.xlm
Site-ul http://www.stevecraft.cz/hracky/ip_sql_to_xml.php nu este bun.
Versiunea game, clinet: 40k
Ba este foarte bun dar bănuiesc că ești tu paralel ;))
lasă liniile aici în code și te ajut eu
Iti las primele 3 linii din sql si din xlm. Zimi daca reusesti sa faci din sql in xlm.
Sql:
INSERT INTO `item_proto` VALUES (1, 'µ·²Ù·¯¹Ì', 'Yang', 9, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0);
INSERT INTO `item_proto` VALUES (2, 'Çѱ¹¹«½Ö¹öÁ¯', 'Versiune in limba Romana', 0, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, -1, -1, -1, -1, -1, 0, 0, 0, 0);
INSERT INTO `item_proto` VALUES (10, 'µµ+0', 'Sabie+0', 1, 0, 0, 2, 262176, 1, 16, '', 0, 0, 11, 1, 0, 15, 1, 0, 0, 0, 7, 22, 0, 0, 0, 0, 0, 15, 19, 13, 15, 0, -1, -1, -1, -1, -1, -1, 0, 1, 0, 0);
Xml:
<ItemDef Vnum="1" Name="µ·˛Ů·ŻąĚ" LocalizedName="Yang" Type="9" SubType="0" Weight="0" Size="1" AntiFlags="0" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="0" ApplyValue0="0" ApplyType1="0" ApplyValue1="0" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="0" Value2="0" Value3="0" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0" />
<ItemDef Vnum="2" Name="Çѱąą«˝ÖąöÁŻ" LocalizedName="Versiune în limba Româna" Type="0" SubType="0" Weight="0" Size="1" AntiFlags="0" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="0" ApplyValue0="0" ApplyType1="0" ApplyValue1="0" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="0" Value2="0" Value3="0" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0" />
<ItemDef Vnum="10" Name="µµ+0" LocalizedName="Sabie+0" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="262176" Flags="1" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="22" ApplyType1="0" ApplyValue1="0" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="15" Value2="19" Value3="13" Value4="15" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="11" RefineSet="1" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="1" AddonType="0" />
Imagine
Afișează semnătura
Sus
Avatar utilizator
Moț
Ţepar / Untrusted User

Ţepar / Untrusted User
Mesaje: 2825
Membru din: 03 Apr 2017, 15:00
Aprecieri: 216  
Mulţumiri: 3040  
Discord: Copiază ID
Medalii

INSERT INTO `item_proto` (`vnum`, `name`, `locale_name`, `type`, `subtype`, `weight`, `size`, `antiflag`, `flag`, `wearflag`, `immuneflag`, `gold`, `shop_buy_price`, `refined_vnum`, `refine_set`, `refine_set2`, `magic_pct`, `limittype0`, `limitvalue0`, `limittype1`, `limitvalue1`, `applytype0`, `applyvalue0`, `applytype1`, `applyvalue1`, `applytype2`, `applyvalue2`, `value0`, `value1`, `value2`, `value3`, `value4`, `value5`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`, `specular`, `socket_pct`, `addon_type`) VALUES (1, 'µ·˛Ů·ŻąĚ', 'Yang', 9, 0, 0, 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `item_proto` (`vnum`, `name`, `locale_name`, `type`, `subtype`, `weight`, `size`, `antiflag`, `flag`, `wearflag`, `immuneflag`, `gold`, `shop_buy_price`, `refined_vnum`, `refine_set`, `refine_set2`, `magic_pct`, `limittype0`, `limitvalue0`, `limittype1`, `limitvalue1`, `applytype0`, `applyvalue0`, `applytype1`, `applyvalue1`, `applytype2`, `applyvalue2`, `value0`, `value1`, `value2`, `value3`, `value4`, `value5`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`, `specular`, `socket_pct`, `addon_type`) VALUES (2, 'Çѱąą«˝ÖąöÁŻ', 'Versiune în limba Româna', 0, 0, 0, 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `item_proto` (`vnum`, `name`, `locale_name`, `type`, `subtype`, `weight`, `size`, `antiflag`, `flag`, `wearflag`, `immuneflag`, `gold`, `shop_buy_price`, `refined_vnum`, `refine_set`, `refine_set2`, `magic_pct`, `limittype0`, `limitvalue0`, `limittype1`, `limitvalue1`, `applytype0`, `applyvalue0`, `applytype1`, `applyvalue1`, `applytype2`, `applyvalue2`, `value0`, `value1`, `value2`, `value3`, `value4`, `value5`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`, `specular`, `socket_pct`, `addon_type`) VALUES (10, 'µµ+0', 'Sabie+0', 1, 0, 0, 2, 262176, 1, 16, '0', 0, 0, 11, 1, 0, 0, 1, 0, 0, 0, 7, 22, 0, 0, 0, 0, 0, 15, 19, 13, 15, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);
Imagine
Afișează semnătura
Sus
Avatar utilizator
Moț
Ţepar / Untrusted User

Ţepar / Untrusted User
Mesaje: 2825
Membru din: 03 Apr 2017, 15:00
Aprecieri: 216  
Mulţumiri: 3040  
Discord: Copiază ID
Medalii

<ItemProto Version="1">
<ItemDef Vnum="1" Name="µ·˛Ů·ŻąĚ" LocalizedName="Yang" Type="9" SubType="0" Weight="0" Size="1" AntiFlags="0" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="0" ApplyValue0="0" ApplyType1="0" ApplyValue1="0" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="0" Value2="0" Value3="0" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0" />
<ItemDef Vnum="2" Name="Çѱąą«˝ÖąöÁŻ" LocalizedName="Versiune în limba Româna" Type="0" SubType="0" Weight="0" Size="1" AntiFlags="0" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="0" ApplyValue0="0" ApplyType1="0" ApplyValue1="0" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="0" Value2="0" Value3="0" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0" />
<ItemDef Vnum="10" Name="µµ+0" LocalizedName="Sabie+0" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="262176" Flags="1" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="22" ApplyType1="0" ApplyValue1="0" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="15" Value2="19" Value3="13" Value4="15" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="11" RefineSet="1" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="1" AddonType="0" />
</ItemProto>
Imagine
Afișează semnătura
Sus
Avatar utilizator
Titan
Metin Master

Metin Master
Mesaje: 2783
Membru din: 01 Iun 2015, 15:09
Server: In curand.
Regat: Chunjo
Aprecieri: 42  
Mulţumiri: 377  
  Rezolvări prob.: 3
Discord: Copiază ID
 Contact:
Vezi detalii
Medalii

SQL corect querry:

Cod: Selectaţi tot

INSERT INTO `item_proto` (`vnum`, `name`, `locale_name`, `type`, `subtype`, `weight`, `size`, `antiflag`, `flag`, `wearflag`, `immuneflag`, `gold`, `shop_buy_price`, `refined_vnum`, `refine_set`, `refine_set2`, `magic_pct`, `limittype0`, `limitvalue0`, `limittype1`, `limitvalue1`, `applytype0`, `applyvalue0`, `applytype1`, `applyvalue1`, `applytype2`, `applyvalue2`, `value0`, `value1`, `value2`, `value3`, `value4`, `value5`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`, `specular`, `socket_pct`, `addon_type`) VALUES (1, 'µ·˛Ů·ŻąĚ', 'Yang', 9, 0, 0, 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `item_proto` (`vnum`, `name`, `locale_name`, `type`, `subtype`, `weight`, `size`, `antiflag`, `flag`, `wearflag`, `immuneflag`, `gold`, `shop_buy_price`, `refined_vnum`, `refine_set`, `refine_set2`, `magic_pct`, `limittype0`, `limitvalue0`, `limittype1`, `limitvalue1`, `applytype0`, `applyvalue0`, `applytype1`, `applyvalue1`, `applytype2`, `applyvalue2`, `value0`, `value1`, `value2`, `value3`, `value4`, `value5`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`, `specular`, `socket_pct`, `addon_type`) VALUES (2, 'Çѱąą«˝ÖąöÁŻ', 'Versiune în limba Româna', 0, 0, 0, 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `item_proto` (`vnum`, `name`, `locale_name`, `type`, `subtype`, `weight`, `size`, `antiflag`, `flag`, `wearflag`, `immuneflag`, `gold`, `shop_buy_price`, `refined_vnum`, `refine_set`, `refine_set2`, `magic_pct`, `limittype0`, `limitvalue0`, `limittype1`, `limitvalue1`, `applytype0`, `applyvalue0`, `applytype1`, `applyvalue1`, `applytype2`, `applyvalue2`, `value0`, `value1`, `value2`, `value3`, `value4`, `value5`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`, `specular`, `socket_pct`, `addon_type`) VALUES (10, 'µµ+0', 'Sabie+0', 1, 0, 0, 2, 262176, 1, 16, '0', 0, 0, 11, 1, 0, 0, 1, 0, 0, 0, 7, 22, 0, 0, 0, 0, 0, 15, 19, 13, 15, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0);

XML corect querry:

Cod: Selectaţi tot

	<ItemDef Vnum="1" Name="µ·˛Ů·ŻąĚ" LocalizedName="Yang" Type="9" SubType="0" Weight="0" Size="1" AntiFlags="0" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="0" ApplyValue0="0" ApplyType1="0" ApplyValue1="0" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="0" Value2="0" Value3="0" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0"  />
	<ItemDef Vnum="2" Name="Çѱąą«˝ÖąöÁŻ" LocalizedName="Versiune în limba Româna" Type="0" SubType="0" Weight="0" Size="1" AntiFlags="0" Flags="0" WearFlags="0" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="0" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="0" ApplyValue0="0" ApplyType1="0" ApplyValue1="0" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="0" Value2="0" Value3="0" Value4="0" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="0" RefineSet="0" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="0" AddonType="0"  />
	<ItemDef Vnum="10" Name="µµ+0" LocalizedName="Sabie+0" Type="1" SubType="0" Weight="0" Size="2" AntiFlags="262176" Flags="1" WearFlags="16" ImmuneFlags="0" Gold="0" ShopBuyPrice="0" LimitType0="1" LimitValue0="0" LimitType1="0" LimitValue1="0" ApplyType0="7" ApplyValue0="22" ApplyType1="0" ApplyValue1="0" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="15" Value2="19" Value3="13" Value4="15" Value5="0" Socket0="0" Socket1="0" Socket2="0" RefinedVnum="11" RefineSet="1" AlterToMagicItemPercent="0" Specular="0" GainSocketPercent="1" AddonType="0"  />
Imagine
Afișează semnătura
Sus
Avatar utilizator
Moț
Ţepar / Untrusted User

Ţepar / Untrusted User
Mesaje: 2825
Membru din: 03 Apr 2017, 15:00
Aprecieri: 216  
Mulţumiri: 3040  
Discord: Copiază ID
Medalii

Inactiv,arhivat!
Imagine
Afișează semnătura
Sus
Închis
Convertire Gr2
Răspunsuri
3 Vizualizări
370
Citește mai mult
Problema Convertire
Răspunsuri
2 Vizualizări
288
Citește mai mult
Problema convertire item proto
Răspunsuri
1 Vizualizări
132
Citește mai mult
Interogare unix timestamp si convertire
Răspunsuri
3 Vizualizări
247
Citește mai mult

Înapoi la “Arhivă Probleme şi Întrebări”

  • Informaţie
+ Anunțul tău aici + Anunțul tău aici + Anunțul tău aici + Anunțul tău aici