TvT NPC Missing
Posted: Sat Feb 27, 2010 4:09 am
Hi, i've notice that in all npc.sql table that was published in all the Epilogue distributions the NPC (70010 - TvT Event NPC) is missing, so i added from the Gracia Final table and correct the values for compatibility in the colums that doesn't allows nulls.
This missing NPC makes that if you enable TvT when the TvT Event start it makes a loop and make the server practically crush, generating lag and freeze.
Here is the code that have to be added into the NPC table, i've already tested in my DB, but feel free to test it before patching your production DB
It will be great if this could be added to the official npc.sql file witch is in the SVN.
Regards!
This missing NPC makes that if you enable TvT when the TvT Event start it makes a loop and make the server practically crush, generating lag and freeze.
Here is the code that have to be added into the NPC table, i've already tested in my DB, but feel free to test it before patching your production DB
Code: Select all
INSERT INTO `npc` VALUES ('70010', '31606', 'Catrina', '1', 'L2J TvT Event Manager', '1', 'Monster2.queen_of_cat', '8.00', '15.00', '70', 'female', 'L2TvTEventNpc', '40', '2444', '2444', '0.00', '0.00', '10', '10', '10', '10', '10', '10', '0', '0', '500', '500', '500', '500', '278', '0', '333', '0', '0', '0', '0', '28', '120', '0', '0', 'LAST_HIT', 'false'); Regards!