.Khan scrie:Ia încearcă astea nenea.
Item_proto :

Cod: Selectaţi tot

	<ItemDef Vnum="186000" Name="Platosa de safir+0" LocalizedName="Platosa de safir+0" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7100000" ShopBuyPrice="110000" LimitType0="1" LimitValue0="71" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="21" ApplyType1="7" ApplyValue1="5" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="200" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196001" RefineSet="1000" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186001" Name="Platosa de safir+1" LocalizedName="Platosa de safir+1" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7200000" ShopBuyPrice="120000" LimitType0="1" LimitValue0="72" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="22" ApplyType1="7" ApplyValue1="10" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="210" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196002" RefineSet="1001" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186002" Name="Platosa de safir+2" LocalizedName="Platosa de safir+2" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7300000" ShopBuyPrice="130000" LimitType0="1" LimitValue0="73" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="23" ApplyType1="7" ApplyValue1="15" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="220" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196003" RefineSet="1002" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186003" Name="Platosa de safir+3" LocalizedName="Platosa de safir+3" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7400000" ShopBuyPrice="140000" LimitType0="1" LimitValue0="74" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="24" ApplyType1="7" ApplyValue1="20" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="230" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196004" RefineSet="1003" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186004" Name="Platosa de safir+4" LocalizedName="Platosa de safir+4" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7500000" ShopBuyPrice="150000" LimitType0="1" LimitValue0="75" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="25" ApplyType1="7" ApplyValue1="25" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="240" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196005" RefineSet="1004" AlterToMagicItemPercent="15" Specular="30" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186005" Name="Platosa de safir+5" LocalizedName="Platosa de safir+5" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7600000" ShopBuyPrice="160000" LimitType0="1" LimitValue0="76" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="26" ApplyType1="7" ApplyValue1="30" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="250" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196006" RefineSet="1005" AlterToMagicItemPercent="15" Specular="40" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186006" Name="Platosa de safir+6" LocalizedName="Platosa de safir+6" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7700000" ShopBuyPrice="170000" LimitType0="1" LimitValue0="77" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="27" ApplyType1="7" ApplyValue1="35" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="260" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196007" RefineSet="1006" AlterToMagicItemPercent="15" Specular="50" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186007" Name="Platosa de safir+7" LocalizedName="Platosa de safir+7" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7800000" ShopBuyPrice="180000" LimitType0="1" LimitValue0="78" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="28" ApplyType1="7" ApplyValue1="40" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="270" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196008" RefineSet="1007" AlterToMagicItemPercent="15" Specular="65" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186008" Name="Platosa de safir+8" LocalizedName="Platosa de safir+8" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7900000" ShopBuyPrice="190000" LimitType0="1" LimitValue0="79" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="29" ApplyType1="7" ApplyValue1="45" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="280" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196009" RefineSet="1008" AlterToMagicItemPercent="15" Specular="80" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186009" Name="Platosa de safir+9" LocalizedName="Platosa de safir+9" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="8000000" ShopBuyPrice="200000" LimitType0="1" LimitValue0="80" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="30" ApplyType1="7" ApplyValue1="50" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="290" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196010" RefineSet="1009" AlterToMagicItemPercent="15" Specular="100" GainSocketPercent="3" AddonType="0"  />

Pastebin : link

Query :

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 (186000, 'Platosa de safir+0', 'Platosa de safir+0', 2, 0, 0, 2, 56, 1, 1, '0', 7100000, 110000, 196001, 1000, 0, 15, 1, 71, 0, 0, 37, 21, 7, 5, 0, 0, 0, 200, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186001, 'Platosa de safir+1', 'Platosa de safir+1', 2, 0, 0, 2, 56, 1, 1, '0', 7200000, 120000, 196002, 1001, 0, 15, 1, 72, 0, 0, 37, 22, 7, 10, 0, 0, 0, 210, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186002, 'Platosa de safir+2', 'Platosa de safir+2', 2, 0, 0, 2, 56, 1, 1, '0', 7300000, 130000, 196003, 1002, 0, 15, 1, 73, 0, 0, 37, 23, 7, 15, 0, 0, 0, 220, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186003, 'Platosa de safir+3', 'Platosa de safir+3', 2, 0, 0, 2, 56, 1, 1, '0', 7400000, 140000, 196004, 1003, 0, 15, 1, 74, 0, 0, 37, 24, 7, 20, 0, 0, 0, 230, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186004, 'Platosa de safir+4', 'Platosa de safir+4', 2, 0, 0, 2, 56, 1, 1, '0', 7500000, 150000, 196005, 1004, 0, 15, 1, 75, 0, 0, 37, 25, 7, 25, 0, 0, 0, 240, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 30, 3, 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 (186005, 'Platosa de safir+5', 'Platosa de safir+5', 2, 0, 0, 2, 56, 1, 1, '0', 7600000, 160000, 196006, 1005, 0, 15, 1, 76, 0, 0, 37, 26, 7, 30, 0, 0, 0, 250, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 40, 3, 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 (186006, 'Platosa de safir+6', 'Platosa de safir+6', 2, 0, 0, 2, 56, 1, 1, '0', 7700000, 170000, 196007, 1006, 0, 15, 1, 77, 0, 0, 37, 27, 7, 35, 0, 0, 0, 260, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 50, 3, 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 (186007, 'Platosa de safir+7', 'Platosa de safir+7', 2, 0, 0, 2, 56, 1, 1, '0', 7800000, 180000, 196008, 1007, 0, 15, 1, 78, 0, 0, 37, 28, 7, 40, 0, 0, 0, 270, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 65, 3, 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 (186008, 'Platosa de safir+8', 'Platosa de safir+8', 2, 0, 0, 2, 56, 1, 1, '0', 7900000, 190000, 196009, 1008, 0, 15, 1, 79, 0, 0, 37, 29, 7, 45, 0, 0, 0, 280, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 80, 3, 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 (186009, 'Platosa de safir+9', 'Platosa de safir+9', 2, 0, 0, 2, 56, 1, 1, '0', 8000000, 200000, 196010, 1009, 0, 15, 1, 80, 0, 0, 37, 30, 7, 50, 0, 0, 0, 290, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 100, 3, 0);

Sunt doar pentru warrior.
Succes.

[SQL]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 (186000, 'Platosa de safir+0', 'Platosa de safir+0', 2, 0, 0, 2, 56, 1, 1, '0', 7100000, 110000, 196001, 1000, 0, 15, 1, 71, 0, 0, 37, 21, 7, 5, 0, 0, 0, 200, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 0);
[Err] 1054 - Unknown column 'refine_set2' in 'field list'

t4zu scrie:

.Khan scrie:Ia încearcă astea nenea.
Item_proto :

Cod: Selectaţi tot

	<ItemDef Vnum="186000" Name="Platosa de safir+0" LocalizedName="Platosa de safir+0" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7100000" ShopBuyPrice="110000" LimitType0="1" LimitValue0="71" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="21" ApplyType1="7" ApplyValue1="5" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="200" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196001" RefineSet="1000" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186001" Name="Platosa de safir+1" LocalizedName="Platosa de safir+1" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7200000" ShopBuyPrice="120000" LimitType0="1" LimitValue0="72" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="22" ApplyType1="7" ApplyValue1="10" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="210" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196002" RefineSet="1001" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186002" Name="Platosa de safir+2" LocalizedName="Platosa de safir+2" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7300000" ShopBuyPrice="130000" LimitType0="1" LimitValue0="73" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="23" ApplyType1="7" ApplyValue1="15" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="220" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196003" RefineSet="1002" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186003" Name="Platosa de safir+3" LocalizedName="Platosa de safir+3" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7400000" ShopBuyPrice="140000" LimitType0="1" LimitValue0="74" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="24" ApplyType1="7" ApplyValue1="20" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="230" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196004" RefineSet="1003" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186004" Name="Platosa de safir+4" LocalizedName="Platosa de safir+4" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7500000" ShopBuyPrice="150000" LimitType0="1" LimitValue0="75" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="25" ApplyType1="7" ApplyValue1="25" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="240" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196005" RefineSet="1004" AlterToMagicItemPercent="15" Specular="30" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186005" Name="Platosa de safir+5" LocalizedName="Platosa de safir+5" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7600000" ShopBuyPrice="160000" LimitType0="1" LimitValue0="76" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="26" ApplyType1="7" ApplyValue1="30" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="250" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196006" RefineSet="1005" AlterToMagicItemPercent="15" Specular="40" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186006" Name="Platosa de safir+6" LocalizedName="Platosa de safir+6" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7700000" ShopBuyPrice="170000" LimitType0="1" LimitValue0="77" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="27" ApplyType1="7" ApplyValue1="35" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="260" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196007" RefineSet="1006" AlterToMagicItemPercent="15" Specular="50" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186007" Name="Platosa de safir+7" LocalizedName="Platosa de safir+7" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7800000" ShopBuyPrice="180000" LimitType0="1" LimitValue0="78" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="28" ApplyType1="7" ApplyValue1="40" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="270" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196008" RefineSet="1007" AlterToMagicItemPercent="15" Specular="65" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186008" Name="Platosa de safir+8" LocalizedName="Platosa de safir+8" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7900000" ShopBuyPrice="190000" LimitType0="1" LimitValue0="79" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="29" ApplyType1="7" ApplyValue1="45" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="280" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196009" RefineSet="1008" AlterToMagicItemPercent="15" Specular="80" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186009" Name="Platosa de safir+9" LocalizedName="Platosa de safir+9" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="8000000" ShopBuyPrice="200000" LimitType0="1" LimitValue0="80" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="30" ApplyType1="7" ApplyValue1="50" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="290" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196010" RefineSet="1009" AlterToMagicItemPercent="15" Specular="100" GainSocketPercent="3" AddonType="0"  />

Pastebin : link

Query :

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 (186000, 'Platosa de safir+0', 'Platosa de safir+0', 2, 0, 0, 2, 56, 1, 1, '0', 7100000, 110000, 196001, 1000, 0, 15, 1, 71, 0, 0, 37, 21, 7, 5, 0, 0, 0, 200, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186001, 'Platosa de safir+1', 'Platosa de safir+1', 2, 0, 0, 2, 56, 1, 1, '0', 7200000, 120000, 196002, 1001, 0, 15, 1, 72, 0, 0, 37, 22, 7, 10, 0, 0, 0, 210, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186002, 'Platosa de safir+2', 'Platosa de safir+2', 2, 0, 0, 2, 56, 1, 1, '0', 7300000, 130000, 196003, 1002, 0, 15, 1, 73, 0, 0, 37, 23, 7, 15, 0, 0, 0, 220, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186003, 'Platosa de safir+3', 'Platosa de safir+3', 2, 0, 0, 2, 56, 1, 1, '0', 7400000, 140000, 196004, 1003, 0, 15, 1, 74, 0, 0, 37, 24, 7, 20, 0, 0, 0, 230, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186004, 'Platosa de safir+4', 'Platosa de safir+4', 2, 0, 0, 2, 56, 1, 1, '0', 7500000, 150000, 196005, 1004, 0, 15, 1, 75, 0, 0, 37, 25, 7, 25, 0, 0, 0, 240, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 30, 3, 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 (186005, 'Platosa de safir+5', 'Platosa de safir+5', 2, 0, 0, 2, 56, 1, 1, '0', 7600000, 160000, 196006, 1005, 0, 15, 1, 76, 0, 0, 37, 26, 7, 30, 0, 0, 0, 250, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 40, 3, 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 (186006, 'Platosa de safir+6', 'Platosa de safir+6', 2, 0, 0, 2, 56, 1, 1, '0', 7700000, 170000, 196007, 1006, 0, 15, 1, 77, 0, 0, 37, 27, 7, 35, 0, 0, 0, 260, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 50, 3, 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 (186007, 'Platosa de safir+7', 'Platosa de safir+7', 2, 0, 0, 2, 56, 1, 1, '0', 7800000, 180000, 196008, 1007, 0, 15, 1, 78, 0, 0, 37, 28, 7, 40, 0, 0, 0, 270, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 65, 3, 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 (186008, 'Platosa de safir+8', 'Platosa de safir+8', 2, 0, 0, 2, 56, 1, 1, '0', 7900000, 190000, 196009, 1008, 0, 15, 1, 79, 0, 0, 37, 29, 7, 45, 0, 0, 0, 280, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 80, 3, 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 (186009, 'Platosa de safir+9', 'Platosa de safir+9', 2, 0, 0, 2, 56, 1, 1, '0', 8000000, 200000, 196010, 1009, 0, 15, 1, 80, 0, 0, 37, 30, 7, 50, 0, 0, 0, 290, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 100, 3, 0);

Sunt doar pentru warrior.
Succes.

Salut. Cand execut querry, imi da urmatoarea eroare:

Cod: Selectaţi tot

[SQL]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 (186000, 'Platosa de safir+0', 'Platosa de safir+0', 2, 0, 0, 2, 56, 1, 1, '0', 7100000, 110000, 196001, 1000, 0, 15, 1, 71, 0, 0, 37, 21, 7, 5, 0, 0, 0, 200, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 0);
[Err] 1054 - Unknown column 'refine_set2' in 'field list'

P.S (Am modificat recent item_proto si e corect postat, acum, pentru fiecare rasa) ... ceva idei?

[RaffaeL] scrie:

t4zu scrie:

.Khan scrie:Ia încearcă astea nenea.
Item_proto :

Cod: Selectaţi tot

	<ItemDef Vnum="186000" Name="Platosa de safir+0" LocalizedName="Platosa de safir+0" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7100000" ShopBuyPrice="110000" LimitType0="1" LimitValue0="71" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="21" ApplyType1="7" ApplyValue1="5" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="200" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196001" RefineSet="1000" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186001" Name="Platosa de safir+1" LocalizedName="Platosa de safir+1" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7200000" ShopBuyPrice="120000" LimitType0="1" LimitValue0="72" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="22" ApplyType1="7" ApplyValue1="10" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="210" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196002" RefineSet="1001" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186002" Name="Platosa de safir+2" LocalizedName="Platosa de safir+2" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7300000" ShopBuyPrice="130000" LimitType0="1" LimitValue0="73" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="23" ApplyType1="7" ApplyValue1="15" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="220" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196003" RefineSet="1002" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186003" Name="Platosa de safir+3" LocalizedName="Platosa de safir+3" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7400000" ShopBuyPrice="140000" LimitType0="1" LimitValue0="74" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="24" ApplyType1="7" ApplyValue1="20" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="230" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196004" RefineSet="1003" AlterToMagicItemPercent="15" Specular="0" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186004" Name="Platosa de safir+4" LocalizedName="Platosa de safir+4" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7500000" ShopBuyPrice="150000" LimitType0="1" LimitValue0="75" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="25" ApplyType1="7" ApplyValue1="25" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="240" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196005" RefineSet="1004" AlterToMagicItemPercent="15" Specular="30" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186005" Name="Platosa de safir+5" LocalizedName="Platosa de safir+5" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7600000" ShopBuyPrice="160000" LimitType0="1" LimitValue0="76" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="26" ApplyType1="7" ApplyValue1="30" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="250" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196006" RefineSet="1005" AlterToMagicItemPercent="15" Specular="40" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186006" Name="Platosa de safir+6" LocalizedName="Platosa de safir+6" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7700000" ShopBuyPrice="170000" LimitType0="1" LimitValue0="77" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="27" ApplyType1="7" ApplyValue1="35" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="260" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196007" RefineSet="1006" AlterToMagicItemPercent="15" Specular="50" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186007" Name="Platosa de safir+7" LocalizedName="Platosa de safir+7" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7800000" ShopBuyPrice="180000" LimitType0="1" LimitValue0="78" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="28" ApplyType1="7" ApplyValue1="40" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="270" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196008" RefineSet="1007" AlterToMagicItemPercent="15" Specular="65" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186008" Name="Platosa de safir+8" LocalizedName="Platosa de safir+8" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="7900000" ShopBuyPrice="190000" LimitType0="1" LimitValue0="79" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="29" ApplyType1="7" ApplyValue1="45" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="280" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196009" RefineSet="1008" AlterToMagicItemPercent="15" Specular="80" GainSocketPercent="3" AddonType="0"  />
	<ItemDef Vnum="186009" Name="Platosa de safir+9" LocalizedName="Platosa de safir+9" Type="2" SubType="0" Weight="0" Size="2" AntiFlags="56" Flags="1" WearFlags="1" ImmuneFlags="0" Gold="8000000" ShopBuyPrice="200000" LimitType0="1" LimitValue0="80" LimitType1="0" LimitValue1="0" ApplyType0="37" ApplyValue0="30" ApplyType1="7" ApplyValue1="50" ApplyType2="0" ApplyValue2="0" Value0="0" Value1="290" Value2="0" Value3="196000" Value4="0" Value5="0" Socket0="0" Socket1="64992" Socket2="127" RefinedVnum="196010" RefineSet="1009" AlterToMagicItemPercent="15" Specular="100" GainSocketPercent="3" AddonType="0"  />

Pastebin : link

Query :

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 (186000, 'Platosa de safir+0', 'Platosa de safir+0', 2, 0, 0, 2, 56, 1, 1, '0', 7100000, 110000, 196001, 1000, 0, 15, 1, 71, 0, 0, 37, 21, 7, 5, 0, 0, 0, 200, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186001, 'Platosa de safir+1', 'Platosa de safir+1', 2, 0, 0, 2, 56, 1, 1, '0', 7200000, 120000, 196002, 1001, 0, 15, 1, 72, 0, 0, 37, 22, 7, 10, 0, 0, 0, 210, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186002, 'Platosa de safir+2', 'Platosa de safir+2', 2, 0, 0, 2, 56, 1, 1, '0', 7300000, 130000, 196003, 1002, 0, 15, 1, 73, 0, 0, 37, 23, 7, 15, 0, 0, 0, 220, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186003, 'Platosa de safir+3', 'Platosa de safir+3', 2, 0, 0, 2, 56, 1, 1, '0', 7400000, 140000, 196004, 1003, 0, 15, 1, 74, 0, 0, 37, 24, 7, 20, 0, 0, 0, 230, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 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 (186004, 'Platosa de safir+4', 'Platosa de safir+4', 2, 0, 0, 2, 56, 1, 1, '0', 7500000, 150000, 196005, 1004, 0, 15, 1, 75, 0, 0, 37, 25, 7, 25, 0, 0, 0, 240, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 30, 3, 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 (186005, 'Platosa de safir+5', 'Platosa de safir+5', 2, 0, 0, 2, 56, 1, 1, '0', 7600000, 160000, 196006, 1005, 0, 15, 1, 76, 0, 0, 37, 26, 7, 30, 0, 0, 0, 250, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 40, 3, 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 (186006, 'Platosa de safir+6', 'Platosa de safir+6', 2, 0, 0, 2, 56, 1, 1, '0', 7700000, 170000, 196007, 1006, 0, 15, 1, 77, 0, 0, 37, 27, 7, 35, 0, 0, 0, 260, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 50, 3, 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 (186007, 'Platosa de safir+7', 'Platosa de safir+7', 2, 0, 0, 2, 56, 1, 1, '0', 7800000, 180000, 196008, 1007, 0, 15, 1, 78, 0, 0, 37, 28, 7, 40, 0, 0, 0, 270, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 65, 3, 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 (186008, 'Platosa de safir+8', 'Platosa de safir+8', 2, 0, 0, 2, 56, 1, 1, '0', 7900000, 190000, 196009, 1008, 0, 15, 1, 79, 0, 0, 37, 29, 7, 45, 0, 0, 0, 280, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 80, 3, 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 (186009, 'Platosa de safir+9', 'Platosa de safir+9', 2, 0, 0, 2, 56, 1, 1, '0', 8000000, 200000, 196010, 1009, 0, 15, 1, 80, 0, 0, 37, 30, 7, 50, 0, 0, 0, 290, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 100, 3, 0);

Sunt doar pentru warrior.
Succes.

Salut. Cand execut querry, imi da urmatoarea eroare:

Cod: Selectaţi tot

[SQL]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 (186000, 'Platosa de safir+0', 'Platosa de safir+0', 2, 0, 0, 2, 56, 1, 1, '0', 7100000, 110000, 196001, 1000, 0, 15, 1, 71, 0, 0, 37, 21, 7, 5, 0, 0, 0, 200, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 0);
[Err] 1054 - Unknown column 'refine_set2' in 'field list'

P.S (Am modificat recent item_proto si e corect postat, acum, pentru fiecare rasa) ... ceva idei?

Incearca asa:
Intra in navicat->player, click dreapta pe item_proto->maintain->repair->extended;
dupa care ruleaza query din nou.

t4zu scrie:

[RaffaeL] scrie:

t4zu scrie: Salut. Cand execut querry, imi da urmatoarea eroare:

Cod: Selectaţi tot

[SQL]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 (186000, 'Platosa de safir+0', 'Platosa de safir+0', 2, 0, 0, 2, 56, 1, 1, '0', 7100000, 110000, 196001, 1000, 0, 15, 1, 71, 0, 0, 37, 21, 7, 5, 0, 0, 0, 200, 0, 196000, 0, 0, 0, 64992, 127, 0, 0, 0, 0, 3, 0);
[Err] 1054 - Unknown column 'refine_set2' in 'field list'

P.S (Am modificat recent item_proto si e corect postat, acum, pentru fiecare rasa) ... ceva idei?

Incearca asa:
Intra in navicat->player, click dreapta pe item_proto->maintain->repair->extended;
dupa care ruleaza query din nou.

Tot aceeasi eroare ... ceva idei?