Jump to content
  • 0

Question

13 answers to this question

Recommended Posts

  • 0
Posted

lpn exi 2 sql files to 1 einai auto -->INSERT INTO `npc` VALUES ('51', '30767', 'Buffer', '1', 'By Apithanos™', '1', 'NPC.a_maidB_FHuman', '8.00', '22.00', '70', 'female', 'L2NpcBuffer', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '55', '132', '', '0', '1', '0', 'LAST_HIT'); kai sto alo-->INSERT INTO `npc_buffer` VALUES ('51', '264', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '265', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '266', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '267', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '268', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '269', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '270', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '271', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '272', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '273', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '274', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '275', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '276', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '277', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '304', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '305', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '306', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '307', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '308', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '309', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '310', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '311', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '349', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '363', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '364', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '365', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '366', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1087', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1303', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1304', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1355', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1356', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1357', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1363', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1413', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4342', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4343', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4344', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4345', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4346', '4', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4347', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4348', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4349', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4350', '4', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4351', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4352', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4353', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4354', '4', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4355', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4356', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4357', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4358', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4359', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4360', '3', '57', '100');

kai dn mpeni kanena

  • 0
Posted

[Err] 1062 - Duplicate entry '51' for key 'PRIMARY'

[Err] INSERT INTO `npc` VALUES ('51', '30767', 'Buffer', '1', 'By Apithanos™', '1', 'NPC.a_maidB_FHuman', '8.00', '22.00', '70', 'female', 'L2NpcBuffer', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '55', '132', '', '0', '1', '0', 'LAST_HIT');

[Msg] Finished - Unsuccessfully

--------------------------------------------------

auto kai ..... auto --->>>[Err] 1146 - Table 'l2jdb.npc_buffer' doesn't exist

[Err] INSERT INTO `npc_buffer` VALUES ('51', '264', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '265', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '266', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '267', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '268', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '269', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '270', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '271', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '272', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '273', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '274', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '275', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '276', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '277', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '304', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '305', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '306', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '307', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '308', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '309', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '310', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '311', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '349', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '363', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '364', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '365', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '366', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1087', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1303', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1304', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1355', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1356', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1357', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1363', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1413', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4342', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4343', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4344', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4345', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4346', '4', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4347', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4348', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4349', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4350', '4', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4351', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4352', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4353', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4354', '4', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4355', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4356', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4357', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4358', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4359', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4360', '3', '57', '100');

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

  • 0
Posted

[Err] 1062 - Duplicate entry '51' for key 'PRIMARY'

[Err] INSERT INTO `npc` VALUES ('51', '30767', 'Buffer', '1', 'By Apithanos™', '1', 'NPC.a_maidB_FHuman', '8.00', '22.00', '70', 'female', 'L2NpcBuffer', '40', '3862', '1493', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '55', '132', '', '0', '1', '0', 'LAST_HIT');

[Msg] Finished - Unsuccessfully

--------------------------------------------------

auto kai ..... auto --->>>[Err] 1146 - Table 'l2jdb.npc_buffer' doesn't exist

[Err] INSERT INTO `npc_buffer` VALUES ('51', '264', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '265', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '266', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '267', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '268', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '269', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '270', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '271', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '272', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '273', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '274', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '275', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '276', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '277', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '304', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '305', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '306', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '307', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '308', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '309', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '310', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '311', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '349', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '363', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '364', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '365', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '366', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1087', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1303', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1304', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1355', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1356', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1357', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1363', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '1413', '1', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4342', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4343', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4344', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4345', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4346', '4', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4347', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4348', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4349', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4350', '4', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4351', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4352', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4353', '6', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4354', '4', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4355', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4356', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4357', '2', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4358', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4359', '3', '57', '100');

INSERT INTO `npc_buffer` VALUES ('51', '4360', '3', '57', '100');

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

Αυτό σημαίνει ότι έχεις περάσει ήδη τη buffer στο npc.sql και ότι δεν υπάρχει το αρχείο npc_buffer.sql
  • 0
Posted

Άλλαξε το ID από 51 σε κάτι δικό σου, το ίδιο και στα υπόλοιπα αρχεία. ( επειδή το 51 είναι ήδη περασμένο ) ή απλά άλλαξε να πάει στο table από npc σε custom_npc

Μετά, άνοιξε το npc_buffer.sql και πες μου κάτι, λέει " Table 'l2jdb.npc_buffer' " εάν ναι, σβήσε το l2jdb και κράτα το npc_buffer μόνο.

Γιατί σε frozen είναι gameserver_beta

Guest
This topic is now closed to further replies.


×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..