SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Applications/Tools written to make running DarkStar easier for the rest of us.
lautan
Developer
Posts: 164
Joined: Mon Jul 30, 2012 6:17 pm

SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Post by lautan » Sun Jun 02, 2013 7:31 pm

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
Attachments
mob_fix.txt
(13.17 KiB) Downloaded 338 times
Last edited by lautan on Thu Sep 10, 2015 8:20 pm, edited 5 times in total.

lautan
Developer
Posts: 164
Joined: Mon Jul 30, 2012 6:17 pm

Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Post by lautan » Sat Jul 20, 2013 3:22 pm

Typo. Olid funguars in crawlers will now be normal level.
Last edited by lautan on Sat Jul 20, 2013 10:20 pm, edited 1 time in total.

lautan
Developer
Posts: 164
Joined: Mon Jul 30, 2012 6:17 pm

Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Post by lautan » Sat Jul 20, 2013 7:02 pm

Found some more typos and added more mobs for dangff wadi
Last edited by lautan on Sat Jul 20, 2013 10:19 pm, edited 1 time in total.

User avatar
whasf
Site Admin
Posts: 1291
Joined: Thu Jul 19, 2012 9:11 pm

Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Post by whasf » Sat Jul 20, 2013 9:04 pm

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??
-- Whasf

xipies
Posts: 119
Joined: Thu Aug 02, 2012 11:29 pm

Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Post by xipies » Thu Nov 07, 2013 11:09 pm

There's a lv80+ Skinnymajinx left in Inner Horutoto Ruins on the way to the portal charm door.

nasomi
Posts: 141
Joined: Wed Feb 13, 2013 8:51 am

Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Post by nasomi » Tue Jan 14, 2014 2:48 pm

Thank you very much for this.

miketran2009
Posts: 17
Joined: Mon Aug 06, 2012 1:15 am

Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Post by miketran2009 » Thu Jan 30, 2014 4:07 pm

does this sql still works with latest dspffxi rev. and what about the hilvl mob drops does it effect drops ??? just curious thx

lautan
Developer
Posts: 164
Joined: Mon Jul 30, 2012 6:17 pm

Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Post by lautan » Fri Jun 13, 2014 7:46 pm

Yes this still works. It finds by mobs names which never change.

uwill99
Posts: 61
Joined: Tue Aug 12, 2014 11:28 pm

Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Post by uwill99 » Thu Oct 16, 2014 3:33 am

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.

whitevamp
Posts: 52
Joined: Sun Dec 09, 2012 12:19 pm

Re: SQL Script To Delvl 80+ Mobs In Low Lvl Zones

Post by whitevamp » Thu Oct 16, 2014 10:00 am

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.

Post Reply