[Szukam] Programu do przerobienia query.

[Heon]

Witam.

 

Poszukuję programu, który po wklejeniu tego:

 

 

<Item vnum="91000" hashName="'Smoczy Hełm+0'" name="Smoczy Hełm+0" type="2" subtype="1" weight="0" size="1" antiflag="0" flag="0" wearflag="2" immuneflag="0" gold="20000" buy_price="2000" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="12" applyvalue0="1" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="13" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="65008" socket2="127" socket3="64992" socket4="21631" socket5="4855" refine_vnum="91001" refine_set="343" magic_pct="15" specular="0" socket_pct="0" />
<Item vnum="91001" hashName="'Smoczy Hełm+1'" name="Smoczy Hełm+1" type="2" subtype="1" weight="0" size="1" antiflag="0" flag="0" wearflag="2" immuneflag="0" gold="30000" buy_price="3000" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="12" applyvalue0="2" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="13" value2="0" value3="0" value4="0" value5="51" socket0="0" socket1="65008" socket2="127" socket3="64992" socket4="21631" socket5="4855" refine_vnum="91002" refine_set="344" magic_pct="15" specular="0" socket_pct="0" />
<Item vnum="91002" hashName="'Smoczy Hełm+2'" name="Smoczy Hełm+2" type="2" subtype="1" weight="0" size="1" antiflag="0" flag="0" wearflag="2" immuneflag="0" gold="45000" buy_price="4500" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="12" applyvalue0="3" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="13" value2="0" value3="0" value4="0" value5="57" socket0="0" socket1="65008" socket2="127" socket3="64992" socket4="21631" socket5="4855" refine_vnum="91003" refine_set="345" magic_pct="15" specular="0" socket_pct="0" />
<Item vnum="91003" hashName="'Smoczy Hełm+3'" name="Smoczy Hełm+3" type="2" subtype="1" weight="0" size="1" antiflag="0" flag="0" wearflag="2" immuneflag="0" gold="70000" buy_price="7000" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="12" applyvalue0="4" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="13" value2="0" value3="0" value4="0" value5="63" socket0="0" socket1="65008" socket2="127" socket3="64992" socket4="21631" socket5="4855" refine_vnum="91004" refine_set="346" magic_pct="15" specular="0" socket_pct="0" />
<Item vnum="91004" hashName="'Smoczy Hełm+4'" name="Smoczy Hełm+4" type="2" subtype="1" weight="0" size="1" antiflag="0" flag="0" wearflag="2" immuneflag="0" gold="110000" buy_price="11000" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="12" applyvalue0="5" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="13" value2="0" value3="0" value4="0" value5="67" socket0="0" socket1="65008" socket2="127" socket3="64992" socket4="21631" socket5="4855" refine_vnum="91005" refine_set="347" magic_pct="15" specular="0" socket_pct="0" />
<Item vnum="91005" hashName="'Smoczy Hełm+5'" name="Smoczy Hełm+5" type="2" subtype="1" weight="0" size="1" antiflag="0" flag="0" wearflag="2" immuneflag="0" gold="170000" buy_price="17000" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="12" applyvalue0="7" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="13" value2="0" value3="0" value4="0" value5="72" socket0="0" socket1="65008" socket2="127" socket3="64992" socket4="21631" socket5="4855" refine_vnum="91006" refine_set="348" magic_pct="15" specular="0" socket_pct="0" />
<Item vnum="91006" hashName="'Smoczy Hełm+6'" name="Smoczy Hełm+6" type="2" subtype="1" weight="0" size="1" antiflag="0" flag="0" wearflag="2" immuneflag="0" gold="260000" buy_price="26000" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="12" applyvalue0="8" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="13" value2="0" value3="0" value4="0" value5="79" socket0="0" socket1="65008" socket2="127" socket3="64992" socket4="21631" socket5="4855" refine_vnum="91007" refine_set="349" magic_pct="15" specular="0" socket_pct="0" />
<Item vnum="91007" hashName="'Smoczy Hełm+7'" name="Smoczy Hełm+7" type="2" subtype="1" weight="0" size="1" antiflag="0" flag="0" wearflag="2" immuneflag="0" gold="390000" buy_price="39000" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="12" applyvalue0="9" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="13" value2="0" value3="0" value4="0" value5="85" socket0="0" socket1="65008" socket2="127" socket3="64992" socket4="21631" socket5="4855" refine_vnum="91008" refine_set="350" magic_pct="15" specular="0" socket_pct="0" />
<Item vnum="91008" hashName="'Smoczy Hełm+8'" name="Smoczy Hełm+8" type="2" subtype="1" weight="0" size="1" antiflag="0" flag="0" wearflag="2" immuneflag="0" gold="590000" buy_price="59000" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="12" applyvalue0="12" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="13" value2="0" value3="0" value4="0" value5="91" socket0="0" socket1="65008" socket2="127" socket3="64992" socket4="21631" socket5="4855" refine_vnum="91009" refine_set="351" magic_pct="15" specular="0" socket_pct="0" />
<Item vnum="91009" hashName="'Smoczy Hełm+9'" name="Smoczy Hełm+9" type="2" subtype="1" weight="0" size="1" antiflag="0" flag="0" wearflag="2" immuneflag="0" gold="890000" buy_price="89000" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="12" applyvalue0="14" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="13" value2="0" value3="0" value4="0" value5="100" socket0="0" socket1="65008" socket2="127" socket3="64992" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="15" specular="0" socket_pct="0" />

 

Wygeneruje mi query do bazy item_proto.

 

Pozdrawiam.

[Rower1310]

INSERT INTO `item_proto` (`vnum`,`name`,`gb2312name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('91009','Smoczy Hełm+9','Smoczy Hełm+9','2','1','0','1','0','0','2','0','890000','89000','1','90','0','0','12','14','0','0','0','0','0','13','0','0','0','100','0','65008','127','64992','21631','4855','0','0','15','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`gb2312name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('91008','Smoczy Hełm+8','Smoczy Hełm+8','2','1','0','1','0','0','2','0','590000','59000','1','90','0','0','12','12','0','0','0','0','0','13','0','0','0','91','0','65008','127','64992','21631','4855','91009','351','15','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`gb2312name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('91007','Smoczy Hełm+7','Smoczy Hełm+7','2','1','0','1','0','0','2','0','390000','39000','1','90','0','0','12','9','0','0','0','0','0','13','0','0','0','85','0','65008','127','64992','21631','4855','91008','350','15','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`gb2312name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('91006','Smoczy Hełm+6','Smoczy Hełm+6','2','1','0','1','0','0','2','0','260000','26000','1','90','0','0','12','8','0','0','0','0','0','13','0','0','0','79','0','65008','127','64992','21631','4855','91007','349','15','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`gb2312name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('91005','Smoczy Hełm+5','Smoczy Hełm+5','2','1','0','1','0','0','2','0','170000','17000','1','90','0','0','12','7','0','0','0','0','0','13','0','0','0','72','0','65008','127','64992','21631','4855','91006','348','15','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`gb2312name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('91004','Smoczy Hełm+4','Smoczy Hełm+4','2','1','0','1','0','0','2','0','110000','11000','1','90','0','0','12','5','0','0','0','0','0','13','0','0','0','67','0','65008','127','64992','21631','4855','91005','347','15','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`gb2312name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('91003','Smoczy Hełm+3','Smoczy Hełm+3','2','1','0','1','0','0','2','0','70000','7000','1','90','0','0','12','4','0','0','0','0','0','13','0','0','0','63','0','65008','127','64992','21631','4855','91004','346','15','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`gb2312name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('91002','Smoczy Hełm+2','Smoczy Hełm+2','2','1','0','1','0','0','2','0','45000','4500','1','90','0','0','12','3','0','0','0','0','0','13','0','0','0','57','0','65008','127','64992','21631','4855','91003','345','15','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`gb2312name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('91001','Smoczy Hełm+1','Smoczy Hełm+1','2','1','0','1','0','0','2','0','30000','3000','1','90','0','0','12','2','0','0','0','0','0','13','0','0','0','51','0','65008','127','64992','21631','4855','91002','344','15','0','0');
INSERT INTO `item_proto` (`vnum`,`name`,`gb2312name`,`type`,`subtype`,`weight`,`size`,`antiflag`,`flag`,`wearflag`,`immuneflag`,`gold`,`shop_buy_price`,`limittype0`,`limitvalue0`,`limittype1`,`limitvalue1`,`applytype0`,`applyvalue0`,`applytype1`,`applyvalue1`,`applytype2`,`applyvalue2`,`value0`,`value1`,`value2`,`value3`,`value4`,`value5`,`socket0`,`socket1`,`socket2`,`socket3`,`socket4`,`socket5`,`refined_vnum`,`refine_set`,`magic_pct`,`specular`,`socket_pct`) VALUES ('91000','Smoczy Hełm+0','Smoczy Hełm+0','2','1','0','1','0','0','2','0','20000','2000','1','90','0','0','12','1','0','0','0','0','0','13','0','0','0','0','0','65008','127','64992','21631','4855','91001','343','15','0','0');

[Heon]

To nie działa. Nie ma np. takiego pola w bazie jak "gb2312name". Poza tym, chodzi tu o bazę 2010.

[SϒS™]

http://www.mpcforum.pl/topic/255285-tutorial-konwertowanie-item-proto-clientowego-do-serwera/

http://www.mpcforum.pl/topic/256873-tutorial-konwertowanie-item-proto-serwerowego-do-clientowego/

[Heon]

http://www.mpcforum.pl/topic/255285-tutorial-konwertowanie-item-proto-clientowego-do-serwera/

http://www.mpcforum.pl/topic/256873-tutorial-konwertowanie-item-proto-serwerowego-do-clientowego/

 

Dzięki, ale to jest do plików 2006 bodajże, ponieważ gdy importuję do mojej bazy i tworzę np. tarcze na której pokazuje 300~ pare def. to po założeniu mam ponad 100k defa :/

[Monkey D. Luffy]

Na pliki 2010 łatwo zrobić

gb2312name

zamieniasz na

locale_name

 

I wszystko będzie poprawne.

[SϒS™]

Między plikami 2006 a 2010 nie ma zbytniej różnicy .. Item_proto nie różni się niczym tylko mob_proto tym iż trzeba tylko 6 zer na koncu dodać .

Pokaż te query to Ci je poprawię bo domyslam sie gdzie jest błąd