Jump to content
  • 0

buffer problem


paulos13

Question

13 answers to this question

Recommended Posts

  • 0

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

Link to comment
Share on other sites

  • 0

[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

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

 

Link to comment
Share on other sites

  • 0

[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
Link to comment
Share on other sites

  • 0

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

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

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

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.


×
×
  • Create New...