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

SensualxD

Rekomendowane odpowiedzi

SensualxD Uczeń

SensualxD

Opublikowano
Uczeń

SensualxD

Opublikowano

Witam

 

Chcę wgrać te query na pliki terenzo
 

INSERT INTO `mob_proto` VALUES ('3301', '¸Á·®?´', 0x4C656D757265732057617272696F72, '0', '0', '0', '97', 'SMALL', null, '0', '', '', '0', 'lemures_soldier', '0', '70', '22', '66', '22', '500', '1232', '10000', '3', '1', '10000', '10000', '23122', '222', '100', '100', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3302', '¸Á·®?´?Ä?´', 0x4C656D757265732057617272696F72, '1', '0', '0', '98', 'SMALL', null, '0', '', '', '0', 'lemures_soldier2', '0', '300', '250', '232', '230', '200', '2500', '10000', '3', '1', '1000', '10000', '230000', '130', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3303', '¸?·®ą??»?§', 0x4C656D757265732057617272696F72, '1', '0', '1', '99', 'SMALL', null, '0', '', '', '0', 'lemures_magic', '0', '300', '250', '232', '230', '400', '3000', '11111', '3', '1', '1000', '10000', '250000', '150', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3304', '¸?·®?”Ä?±??', 0x4C656D757265732057617272696F72, '2', '0', '0', '100', 'SMALL', null, '0', '', '', '0', 'lemures_officer', '0', '300', '250', '232', '230', '500', '3100', '12000', '3', '1', '1000', '10000', '280000', '180', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3305', '¸?·®»??±???”Ä?±??', 0x4C656D757265732057617272696F72, '3', '0', '0', '101', 'SMALL', null, '0', '', '', '0', 'lemures_general', '0', '300', '250', '232', '230', '600', '3300', '13000', '3', '1', '1000', '10000', '320000', '220', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3390', '¸?·®?· ???Ž?·?”Ä', 0x4C656D757265732057617272696F72, '4', '0', '0', '103', 'SMALL', null, '0', '', '', '0', 'lemures_boss', '0', '300', '250', '232', '230', '800', '5000', '100000', '3', '1', '1000', '100000', '550000', '270', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3391', '¸?·®?·?”Ä?', 0x4C656D757265732057617272696F72, '5', '0', '0', '103', 'SMALL', null, '0', '', '', '0', 'lemures_boss2', '0', '300', '250', '232', '230', '1000', '7000', '250000', '3', '1', '1000', '300000', '1000000', '300', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3401', '?î?Î?´', 0x4C656D757265732057617272696F72, '1', '0', '0', '98', 'SMALL', null, '0', '', '', '0', 'triton_soldier2', '0', '300', '250', '232', '230', '200', '2500', '10000', '3', '1', '1000', '10000', '230000', '130', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3402', 'Ä??®?”?ŽÄ‚´Ä??„??´', 0x4C656D757265732057617272696F72, '1', '0', '0', '98', 'SMALL', null, '0', '', '', '0', 'triton_soldier2', '0', '300', '250', '232', '230', '200', '2500', '10000', '3', '1', '1000', '10000', '230000', '130', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3403', 'Ä??®?”?ŽÄ…??»?§', 0x4C656D757265732057617272696F72, '1', '0', '1', '99', 'SMALL', null, '0', '', '', '0', 'triton_magic', '0', '300', '250', '232', '230', '400', '3000', '11111', '3', '1', '1000', '10000', '250000', '150', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3404', 'Ä??®?”?Ž?”Ä?±??', 0x4C656D757265732057617272696F72, '2', '0', '0', '100', 'SMALL', null, '0', '', '', '0', 'triton_officer', '0', '300', '250', '232', '230', '500', '3100', '12000', '3', '1', '1000', '10000', '280000', '180', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3405', 'Ä??®?”?ŽÂ»??±???”Ä?±??', 0x4C656D757265732057617272696F72, '3', '0', '0', '101', 'SMALL', null, '0', '', '', '0', 'triton_general', '0', '300', '250', '232', '230', '600', '3300', '13000', '3', '1', '1000', '10000', '320000', '220', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3490', 'Ä??®?”?Ž?· ???Ž?·?”Ä', 0x4C656D757265732057617272696F72, '4', '0', '0', '103', 'SMALL', null, '0', '', '', '0', 'triton_boss', '0', '300', '250', '232', '230', '800', '5000', '100000', '3', '1', '1000', '100000', '550000', '270', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3491', 'Ä??®?”?Ž?·?”Ä?', 0x4C656D757265732057617272696F72, '5', '0', '0', '103', 'SMALL', null, '0', '', '', '0', 'triton_boss2', '0', '300', '250', '232', '230', '1000', '7000', '250000', '3', '1', '1000', '300000', '1000000', '300', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3201', '?ü?Í?´', 0x4C656D757265732057617272696F72, '0', '0', '0', '98', 'SMALL', null, '0', '', '', '0', 'manticore_soldier2', '0', '53', '58', '87', '30', '200', '900', '10000', '3', '1', '1000', '10000', '230000', '130', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3202', 'Ä…???”??Ă´Ä??„??´', 0x4C656D757265732057617272696F72, '1', '0', '0', '98', 'SMALL', null, '0', '', '', '0', 'manticore_soldier2', '0', '53', '58', '87', '30', '200', '900', '10000', '3', '1', '1000', '10000', '230000', '130', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3203', 'Ä…???”??Ä…??»?§', 0x4C656D757265732057617272696F72, '1', '0', '1', '99', 'SMALL', null, '0', '', '', '0', 'manticore_magic', '0', '35', '65', '76', '87', '400', '900', '11111', '3', '1', '1000', '10000', '250000', '150', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3204', 'Ä…???”???”Ä?±??', 0x4C656D757265732057617272696F72, '2', '0', '0', '100', 'SMALL', null, '0', '', '', '0', 'manticore_officer', '0', '65', '45', '87', '32', '500', '900', '12000', '3', '1', '1000', '10000', '280000', '180', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3205', 'Ä…???”??»??±???”Ä?±??', 0x4C656D757265732057617272696F72, '3', '0', '0', '101', 'SMALL', null, '0', '', '', '0', 'manticore_general', '0', '76', '55', '87', '42', '600', '900', '13000', '3', '1', '1000', '10000', '320000', '220', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3290', 'Ä…???”???· ???Ž?·?”Ä', 0x4C656D757265732057617272696F72, '4', '0', '0', '103', 'SMALL', null, '0', '', '', '0', 'manticore_boss', '0', '85', '66', '87', '55', '800', '900', '100000', '3', '1', '1000', '100000', '550000', '270', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');
INSERT INTO `mob_proto` VALUES ('3291', 'Ä…???”???·?”Ä?', 0x4C656D757265732057617272696F72, '5', '0', '0', '103', 'SMALL', null, '0', '', '', '0', 'manticore_boss2', '0', '100', '80', '95', '67', '1000', '900', '250000', '3', '1', '1000', '300000', '1000000', '300', '170', '150', '0', '2000', '150', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, null, null, null, '0', null, null, null, null, null, null, null, null, null, null, '0', '0', '0', '0', '0');

I wywala takie błędy:

1048 - Column 'ai_flag' cannot be null
1048 - Column 'ai_flag' cannot be null
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1048 - Column 'ai_flag' cannot be null
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1048 - Column 'ai_flag' cannot be null
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1
1406 - Data too long for column 'name' at row 1

 

Czy wie ktoś jak przekonvertować te query żeby działały na plikach terenzo lub co kolwiek zrobić żeby działało ?

 

query pochodzą z tąd : http://www.mpcforum.pl/topic/778555-dl-mapa-nowa-nie-potrafie-wymyslac-tych-nazw-;/

 

Za pomoc like :)

SensualxD Uczeń

SensualxD

Opublikowano
Uczeń

SensualxD

  • Autor
Opublikowano

popatrz na id ;) Idzie spokojnie wywnioskować o co chodzi, pomyśl i pokombinuj.

Jeśli chodzi o to że mob o takim id istnieje już to sprawdzałem i nie ma w mob_proto żadnego moba o takim id :(

 

Jak umiesz to pomóż :)

Zarchiwizowany

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

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