Desufire wrote:I must be missing something. I'm trying to add items that were replaced by their Rare/Ex counterparts like the Kraken Club.
So I did what you said, but I don't see a mobid list in the mob_droplist. I actually don't see any mobids. So I'm guessing I've misunderstood what you meant by "query in mob_droplist". Did you mean use the query function like in Navicat when you do the zoneip?
Open your database management system, go to mob_droplist, find value 18852, and replace with value 17440.
Value 18852 is the Octave club, value 17440 is the kraken club. But, this will replace, not add to the drop pool, so you will no longer get the rare/ex version (Please see the edit again)
Of course, this is just one of the rare/ex replacements. You will need to find all of them to totally replace. You can always generate a script so future updates can be patched.
Code: Select all
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
Edit: For reference, I just tested replacement of the OC with the KC. It worked fine. Here is the code:
Code: Select all
update `mob_droplist` set `itemId` = replace(`itemId`,'18852','17440');
Edit again: Here is an SQL file I created if you or someone is interested in adding the non ex versions or over-writing the ex versions with the rare versions (Or rare with non-rare, ex. Archer's Ring -> Shikaree Ring).
If you want to over-write, then uncomment the "update " lines. If you just want to add the drops (Like if you want LL to drop both Leaping and Bounding), then just uncomment the "INSERT INTO " lines.
I have added Kraken Club, Leaping Boots, Emperor Hairpin, Peacock Charm, Shikaree Ring, Speed Belt, Dryad Staff, Strider Boots, and Ochiudo's Kote. Please note, if you chose to over-write, then the rare/ex versions will not be able to drop from anywhere, since there are no other mobs/bcnms that can drop. So, if you over-write Archer's Ring with Shikaree Ring, you will not be able to get Archer's Ring without using a GM account and @additem. Or by manually adding it back in. So, think carefully before you decide if you want to over-write, instead of just add.
Anyways, worst case, you can just drop the table and re-add it using the git master table, so you can always undo.
Here is the file:
Feel free to let me know what I missed, and I can add to it.