Skocz do zawartości

  • 👋 Witaj na MPCForum!

    Przeglądasz forum jako gość, co oznacza, że wiele świetnych funkcji jest jeszcze przed Tobą! 😎

    • ✅ Pełny dostęp do działów i ukrytych treści
    • ✅ Możliwość pisania i odpowiadania w tematach
    • ✅ System prywatnych wiadomości
    • ✅ Zbieranie reputacji i rozwijanie swojego profilu
    • ✅ Członkostwo w jednej z największych społeczności graczy

    👉 Dołączenie zajmie Ci mniej niż minutę – a zyskasz znacznie więcej!

    Zarejestruj się teraz

[Problem] query MySQL

ZeleZar

Rekomendowane odpowiedzi

ZeleZar Uczeń

ZeleZar

Opublikowano
Uczeń

ZeleZar

Opublikowano

Witam.

Próbując przekonwertować item_proto z clienta do serwera występuje u mnie błąd i nie mogę dadać zapytań.

Postępuje wg. tego tematu

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

przykładowe zapytania jakie kreuje mi program:

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('71144','Ĺ?¸?˝ş¸?˝ş Ľ?ą°?óŔÚ','Świąteczna Skrzynia','18','0','0','1','106880','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','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`,`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 ('75015','Ŕü¸đ','Kapelusz Wojowniczki','18','0','0','1','106938','8192','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','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`,`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 ('75014','ľĆÇÁ?Î Çěľî','Afro Wojowniczki','18','0','0','1','106938','8192','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','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`,`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 ('5014','Ŕş?É+4','Srebrny Dzwon+4','1','4','0','1','28','1','16','0','800','1500','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','28','0','64960','127','65008','21631','4855','5015','113','15','30','1');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('5013','Ŕş?É+3','Srebrny Dzwon+3','1','4','0','1','28','1','16','0','800','1000','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','21','0','64960','127','65008','21631','4855','5014','112','15','0','1');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('5012','Ŕş?É+2','Srebrny Dzwon+2','1','4','0','1','28','1','16','0','800','1000','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','14','0','64960','127','65008','21631','4855','5013','111','15','0','1');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('5011','Ŕş?É+1','Srebrny Dzwon+1','1','4','0','1','28','1','16','0','800','1000','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','7','0','64960','127','65008','21631','4855','5012','110','15','0','1');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('5009','?ż?É+9','Miedziany Dzwon+9','1','4','0','1','28','1','16','0','600','4500','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','63','0','64960','127','65008','21631','4855','0','0','15','100','1');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('5008','?ż?É+8','Miedziany Dzwon+8','1','4','0','1','28','1','16','0','600','3000','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','56','0','64960','127','65008','21631','4855','5009','117','15','80','1');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('5007','?ż?É+7','Miedziany Dzwon+7','1','4','0','1','28','1','16','0','600','2000','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','49','0','64960','127','65008','21631','4855','5008','116','15','65','1');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('5006','?ż?É+6','Miedziany Dzwon+6','1','4','0','1','28','1','16','0','600','1500','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','42','0','64960','127','65008','21631','4855','5007','115','15','50','1');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('5005','?ż?É+5','Miedziany Dzwon+5','1','4','0','1','28','1','16','0','600','1500','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','35','0','64960','127','65008','21631','4855','5006','114','15','40','1');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('5004','?ż?É+4','Miedziany Dzwon+4','1','4','0','1','28','1','16','0','600','1000','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','28','0','64960','127','65008','21631','4855','5005','113','15','30','1');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('3211','ŔűĂ?°Ë+1','Ostrze Z Czerw. Stali+1','1','3','0','3','56','1','16','0','20000','33000','1','30','0','0','7','25','0','0','0','0','0','0','0','72','109','6','0','64960','127','65008','21631','4855','3212','353','15','0','2');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('3188','Ă??ćľđżů??+8','Pogromca Nieb. Smoka+8','1','3','0','3','56','1','16','0','10000','10000','0','0','0','0','7','25','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','3189','54','5','80','0');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('3174','Ȳ?ć°ł?ęşÎ+4','Zabójca Żółt. Smoka+4','1','3','0','3','56','1','16','0','10000','10000','0','0','0','0','7','25','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','3175','50','5','30','0');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('3123','?çŔÚŔ?+3','Zabójca Lwów+3','1','3','0','3','56','1','16','0','180000','250000','1','60','0','0','7','25','0','0','0','0','0','0','0','102','156','15','0','64960','127','65008','21631','4855','3124','49','15','0','3');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('3122','?çŔÚŔ?+2','Zabójca Lwów+2','1','3','0','3','56','1','16','0','180000','220000','1','60','0','0','7','25','0','0','0','0','0','0','0','102','156','10','0','64960','127','65008','21631','4855','3123','48','15','0','3');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('3121','?çŔÚŔ?+1','Zabójca Lwów+1','1','3','0','3','56','1','16','0','180000','200000','1','60','0','0','7','25','0','0','0','0','0','0','0','102','156','5','0','64960','127','65008','21631','4855','3122','47','15','0','3');

 

INSERT INTO `item_proto` (`vnum`,`name`,`locale_name`,`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 ('157','?;ưË+7','Miecz Szponu Ducha+7','1','0','0','2','44','1','16','0','360000','1320000','1','65','0','0','7','15','0','0','0','0','0','90','110','46','87','77','0','64960','127','65008','21631','4855','158','26','15','65','3');

 

 

Może query są złe mógłby ktoś sprawdzić??

JBC za robienie serwów wziołęm się niedawno więc niezbyt obcykany jestem.

Z góry thx.

`SkaCzuS. Budowniczy

`SkaCzuS.

Opublikowano
Budowniczy

`SkaCzuS.

Opublikowano

 

 

INSERT INTO item_proto VALUES ('71144','Ĺ?¸?˝ş¸?˝ş Ľ?ą°?óŔÚ','Świąteczna Skrzynia','18','0','0','1','106880','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','0','0','0','0','0');

INSERT INTO item_proto VALUES ('75015','Ŕü¸đ','Kapelusz Wojowniczki','18','0','0','1','106938','8192','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','0','0','0','0','0');

INSERT INTO item_proto VALUES ('75014','ľĆÇÁ?Î Çěľî','Afro Wojowniczki','18','0','0','1','106938','8192','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','0','0','0','0','0');

INSERT INTO item_proto VALUES ('5014','Ŕş?É+4','Srebrny Dzwon+4','1','4','0','1','28','1','16','0','800','1500','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','28','0','64960','127','65008','21631','4855','5015','113','15','30','1');

INSERT INTO item_proto VALUES ('5013','Ŕş?É+3','Srebrny Dzwon+3','1','4','0','1','28','1','16','0','800','1000','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','21','0','64960','127','65008','21631','4855','5014','112','15','0','1');

INSERT INTO item_proto VALUES ('5012','Ŕş?É+2','Srebrny Dzwon+2','1','4','0','1','28','1','16','0','800','1000','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','14','0','64960','127','65008','21631','4855','5013','111','15','0','1');

INSERT INTO item_proto VALUES ('5011','Ŕş?É+1','Srebrny Dzwon+1','1','4','0','1','28','1','16','0','800','1000','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','7','0','64960','127','65008','21631','4855','5012','110','15','0','1');

INSERT INTO item_proto VALUES ('5009','?ż?É+9','Miedziany Dzwon+9','1','4','0','1','28','1','16','0','600','4500','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','63','0','64960','127','65008','21631','4855','0','0','15','100','1');

INSERT INTO item_proto VALUES ('5008','?ż?É+8','Miedziany Dzwon+8','1','4','0','1','28','1','16','0','600','3000','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','56','0','64960','127','65008','21631','4855','5009','117','15','80','1');

INSERT INTO item_proto VALUES ('5007','?ż?É+7','Miedziany Dzwon+7','1','4','0','1','28','1','16','0','600','2000','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','49','0','64960','127','65008','21631','4855','5008','116','15','65','1');

INSERT INTO item_proto VALUES ('5006','?ż?É+6','Miedziany Dzwon+6','1','4','0','1','28','1','16','0','600','1500','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','42','0','64960','127','65008','21631','4855','5007','115','15','50','1');

INSERT INTO item_proto VALUES ('5005','?ż?É+5','Miedziany Dzwon+5','1','4','0','1','28','1','16','0','600','1500','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','35','0','64960','127','65008','21631','4855','5006','114','15','40','1');

INSERT INTO item_proto VALUES ('5004','?ż?É+4','Miedziany Dzwon+4','1','4','0','1','28','1','16','0','600','1000','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','28','0','64960','127','65008','21631','4855','5005','113','15','30','1');

INSERT INTO item_proto VALUES ('3211','ŔűĂ?°Ë+1','Ostrze Z Czerw. Stali+1','1','3','0','3','56','1','16','0','20000','33000','1','30','0','0','7','25','0','0','0','0','0','0','0','72','109','6','0','64960','127','65008','21631','4855','3212','353','15','0','2');

INSERT INTO item_proto VALUES ('3188','Ă??ćľđżů??+8','Pogromca Nieb. Smoka+8','1','3','0','3','56','1','16','0','10000','10000','0','0','0','0','7','25','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','3189','54','5','80','0');

INSERT INTO item_proto VALUES ('3174','Ȳ?ć°ł?ęşÎ+4','Zabójca Żółt. Smoka+4','1','3','0','3','56','1','16','0','10000','10000','0','0','0','0','7','25','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','3175','50','5','30','0');

INSERT INTO item_proto VALUES ('3123','?çŔÚŔ?+3','Zabójca Lwów+3','1','3','0','3','56','1','16','0','180000','250000','1','60','0','0','7','25','0','0','0','0','0','0','0','102','156','15','0','64960','127','65008','21631','4855','3124','49','15','0','3');

INSERT INTO item_proto VALUES ('3122','?çŔÚŔ?+2','Zabójca Lwów+2','1','3','0','3','56','1','16','0','180000','220000','1','60','0','0','7','25','0','0','0','0','0','0','0','102','156','10','0','64960','127','65008','21631','4855','3123','48','15','0','3');

INSERT INTO item_proto VALUES ('3121','?çŔÚŔ?+1','Zabójca Lwów+1','1','3','0','3','56','1','16','0','180000','200000','1','60','0','0','7','25','0','0','0','0','0','0','0','102','156','5','0','64960','127','65008','21631','4855','3122','47','15','0','3');

INSERT INTO item_proto VALUES ('157','?;ưË+7','Miecz Szponu Ducha+7','1','0','0','2','44','1','16','0','360000','1320000','1','65','0','0','7','15','0','0','0','0','0','90','110','46','87','77','0','64960','127','65008','21631','4855','158','26','15','65','3');

 

 

Moze to ?

ZeleZar Uczeń

ZeleZar

Opublikowano
Uczeń

ZeleZar

  • Autor
Opublikowano

Poradziłem sobie z tym źle apostrofy były rozmieszczone.

Ale teraz znów gdy wgrywam zapytania po restarcie maszynki nie można wbić do gry.

Zauważyłem że między innymi jest różnica w tych chińskich znaczkach w kolumnie name czy to może mieć coś w tym wspólnego??

 

@ Czy może być to wina navicata??

  • 1 miesiąc temu...
kamil2321 Bywalec

kamil2321

Opublikowano
Bywalec

kamil2321

Opublikowano

Jaki to błąd Ci się pokazuje ? co do query są dobrze przekonwertowane i wgrywa je na serwer na plikach oczywiście 2010/2011/2012, osobiście sprawdziłem :P

Tabelkę mam z locale_name, być może masz gb2312name więc nie wgra je na serwer

Tutaj masz query z tabelką gb2312name:

 

 

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 ('71144','Ĺ?¸?˝ş¸?˝ş Ľ?ą°?óŔÚ','Świąteczna Skrzynia','18','0','0','1','106880','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','0','0','0','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 ('75015','Ŕü¸đ','Kapelusz Wojowniczki','18','0','0','1','106938','8192','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','0','0','0','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 ('75014','ľĆÇÁ?Î Çěľî','Afro Wojowniczki','18','0','0','1','106938','8192','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','0','0','0','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 ('5014','Ŕş?É+4','Srebrny Dzwon+4','1','4','0','1','28','1','16','0','800','1500','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','28','0','64960','127','65008','21631','4855','5015','113','15','30','1');

 

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 ('5013','Ŕş?É+3','Srebrny Dzwon+3','1','4','0','1','28','1','16','0','800','1000','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','21','0','64960','127','65008','21631','4855','5014','112','15','0','1');

 

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 ('5012','Ŕş?É+2','Srebrny Dzwon+2','1','4','0','1','28','1','16','0','800','1000','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','14','0','64960','127','65008','21631','4855','5013','111','15','0','1');

 

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 ('5011','Ŕş?É+1','Srebrny Dzwon+1','1','4','0','1','28','1','16','0','800','1000','1','15','0','0','7','23','0','0','0','0','0','4','30','20','26','7','0','64960','127','65008','21631','4855','5012','110','15','0','1');

 

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 ('5009','?ż?É+9','Miedziany Dzwon+9','1','4','0','1','28','1','16','0','600','4500','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','63','0','64960','127','65008','21631','4855','0','0','15','100','1');

 

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 ('5008','?ż?É+8','Miedziany Dzwon+8','1','4','0','1','28','1','16','0','600','3000','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','56','0','64960','127','65008','21631','4855','5009','117','15','80','1');

 

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 ('5007','?ż?É+7','Miedziany Dzwon+7','1','4','0','1','28','1','16','0','600','2000','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','49','0','64960','127','65008','21631','4855','5008','116','15','65','1');

 

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 ('5006','?ż?É+6','Miedziany Dzwon+6','1','4','0','1','28','1','16','0','600','1500','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','42','0','64960','127','65008','21631','4855','5007','115','15','50','1');

 

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 ('5005','?ż?É+5','Miedziany Dzwon+5','1','4','0','1','28','1','16','0','600','1500','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','35','0','64960','127','65008','21631','4855','5006','114','15','40','1');

 

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 ('5004','?ż?É+4','Miedziany Dzwon+4','1','4','0','1','28','1','16','0','600','1000','1','10','0','0','7','32','0','0','0','0','0','10','18','13','15','28','0','64960','127','65008','21631','4855','5005','113','15','30','1');

 

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 ('3211','ŔűĂ?°Ë+1','Ostrze Z Czerw. Stali+1','1','3','0','3','56','1','16','0','20000','33000','1','30','0','0','7','25','0','0','0','0','0','0','0','72','109','6','0','64960','127','65008','21631','4855','3212','353','15','0','2');

 

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 ('3188','Ă??ćľđżů??+8','Pogromca Nieb. Smoka+8','1','3','0','3','56','1','16','0','10000','10000','0','0','0','0','7','25','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','3189','54','5','80','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 ('3174','Ȳ?ć°ł?ęşÎ+4','Zabójca Żółt. Smoka+4','1','3','0','3','56','1','16','0','10000','10000','0','0','0','0','7','25','0','0','0','0','0','0','0','0','0','0','0','64960','127','65008','21631','4855','3175','50','5','30','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 ('3123','?çŔÚŔ?+3','Zabójca Lwów+3','1','3','0','3','56','1','16','0','180000','250000','1','60','0','0','7','25','0','0','0','0','0','0','0','102','156','15','0','64960','127','65008','21631','4855','3124','49','15','0','3');

 

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 ('3122','?çŔÚŔ?+2','Zabójca Lwów+2','1','3','0','3','56','1','16','0','180000','220000','1','60','0','0','7','25','0','0','0','0','0','0','0','102','156','10','0','64960','127','65008','21631','4855','3123','48','15','0','3');

 

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 ('3121','?çŔÚŔ?+1','Zabójca Lwów+1','1','3','0','3','56','1','16','0','180000','200000','1','60','0','0','7','25','0','0','0','0','0','0','0','102','156','5','0','64960','127','65008','21631','4855','3122','47','15','0','3');

 

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 ('157','?;ưË+7','Miecz Szponu Ducha+7','1','0','0','2','44','1','16','0','360000','1320000','1','65','0','0','7','15','0','0','0','0','0','90','110','46','87','77','0','64960','127','65008','21631','4855','158','26','15','65','3');

 

Pomogłem ? klik up to Like ;D ( Lubię to ! ) xD

300 postów-> 10.10.2013 godz. 9:00
400 postów-> 19.10.2013 godz. 9:00

 

Zarchiwizowany

Ten temat przebywa obecnie w archiwum. Dodawanie nowych odpowiedzi zostało zablokowane.

Tematy
×
×
  • Dodaj nową pozycję...