Skip to content
L2PICK.com — Lineage 2 Private Server List

Can someone fix this SQL please???

-Mr.CuTe-
in Request Server Development Help [L2J]

Featured Replies

PLease can someone fix this AQl so it can be compatible with L2J Archid????

 

 

INSERT INTO `custom_npc` VALUES ('67221', '30837', '*GM~Shop*', '1', 'L][Destiny', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', 'L2Merchant', '40', '3862', '1493', '13.43', '3.09', '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '0', '0');

Try changing 'custom_npc' to 'npc'.

If this doesnt work, put here the error.

  • Author

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `npc` VALUES ('67221', '30837', '*GM~Shop*', '1', 'L][Destiny', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', 'L2Merchant', '40', '3862', '1493', '13.43', '3.09', '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '0', '0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Here its the error br0

INSERT INTO `custom_npc` VALUES ('67221', '30837', '*GM~Shop*', '1', 'L][Destiny', '1', 'NPC.a_traderA_FHuman', '20.00', '25.00', '70', 'male', 'L2Merchant', '40', '3862', '1493', '13.43', '3.09', '40', '43', '30', '21', '35', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', null, '0', '0', '0', 'LAST_HIT');

 

rdy

Guest
This topic is now closed to further replies.
Go to topic listing

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.