Page 1 of 2
SQL Script To Delvl 80+ Mobs In Low Lvl Zones
Posted: Sun Jun 02, 2013 7:31 pm
by lautan
A patch long ago removed low level mobs in Crawlers' Nest and replaced them with lvl 80+ monsters. This ruined some camps and made some missions stupidly difficult. This script will delvl all mobs back to the original low lvl. Full list here:
http://parchmentpaper.blogspot.ca/2011/ ... -they.html
Run this script after you ran mob_groups.sql.
If any mobs are missing let me know.
EDIT: updated with bug fixes.
EDIT 2: update reverts puks, vampires, toads and proggos to original mobs.
EDIT 3: forgot kabooms in garage cidatel
Edit 4: added Skinnymajinx
EDIT 5: Added Skinnymalink
Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones
Posted: Sat Jul 20, 2013 3:22 pm
by lautan
Typo. Olid funguars in crawlers will now be normal level.
Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones
Posted: Sat Jul 20, 2013 7:02 pm
by lautan
Found some more typos and added more mobs for dangff wadi
Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones
Posted: Sat Jul 20, 2013 9:04 pm
by whasf
just edit your original message, no need to confuse people with replies that have attachments! Plus do you think drive space is unlimited on the server??
Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones
Posted: Thu Nov 07, 2013 11:09 pm
by xipies
There's a lv80+ Skinnymajinx left in Inner Horutoto Ruins on the way to the portal charm door.
Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones
Posted: Tue Jan 14, 2014 2:48 pm
by nasomi
Thank you very much for this.
Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones
Posted: Thu Jan 30, 2014 4:07 pm
by miketran2009
does this sql still works with latest dspffxi rev. and what about the hilvl mob drops does it effect drops ??? just curious thx
Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones
Posted: Fri Jun 13, 2014 7:46 pm
by lautan
Yes this still works. It finds by mobs names which never change.
Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones
Posted: Thu Oct 16, 2014 3:33 am
by uwill99
Awesome. I've got the .txt and I can open up mob_groups.sql but where do I put the text in the file? Thanks beforehand.
Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones
Posted: Thu Oct 16, 2014 10:00 am
by whitevamp
uwill99 wrote:Awesome. I've got the .txt and I can open up mob_groups.sql but where do I put the text in the file? Thanks beforehand.
rename mob_fix.txt to mob_fix.sql and run it as a sql file in navicat or what ever prog you use.