EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=593)
-   -   EQ Cleanup - Cleans up/Tweaks DB and Quest files (https://www.eqemulator.org/forums/showthread.php?t=40357)

Shin Noir 01-24-2016 05:28 PM

EQ Cleanup - Cleans up/Tweaks DB and Quest files
 
The idea is simple. You grab a fresh copy of PEQ's DB/Quest files. It gives you so much great stuff to start your server from! But, you don't like X feature that EQ introduced. How do you remove it?

What is EQ Cleanup?: It's a tool that removes DB and quest entries by giving a simple menu of tweaks.

http://i.imgur.com/NDcPS6g.png

Note: This tool is still an experiment and it *DOES* delete records in your DB and quests. Use at your own risk. And BACKUP!


How does it delete things? I always keep the original items and npc_type entries around in case you plan to repurpose it, so instead, I go for every possible way that NPC or item may exist in the game, so that only #summonitem or #npctypespawn can bring them back.

What are some features to it?
Currently, it allows:
Remove Soulbinders
Remove Rodents and Exterminators
Remove Trick or Treat NPCs
Remove Tribute Masters
Remove Defiant Armor
Remove Spells, Tomes
Remove Nexus Portal NPCs
Disable Rain and Snow

How do I use it? On your server, copy the executable for your OS to the root directory of your eqemu install (the same directory eqemu_config.xml is located). If all goes well, it will read the eqemu_config.xml file and connect to the DB, and once an option is selected, will apply the needed changes. Ensure your server is SHUT DOWN during the operation, or adverse effects may occur.

How complete is this? It is still on an EARLY alpha state, however I have had no side effects thus far by using it.

Where do I download it? You can download it on the main website.

I don't trust your EXE! Understandable. You're free to recompile and review the source here. I release EXE's for convienence, however if you are familiar with GoLang it is not difficult to compile it yourself.

I want to run it on OSX, 32bit windows, etc Click this link for other OS releases.

I want to request a feature, or found a bug! I'm happy to hear from people using this tool. You can reply to this post, or even better, create an issue on github.

Splose 01-24-2016 07:09 PM

100/10


/10char

Shin Noir 01-25-2016 03:25 AM

I'm not sure what 100/10 means, but.. thanks!? :)

Xanathol 02-12-2016 05:51 PM

Looks awesome! Would love a 'remove PoK books' option (or at least the zone points to disable them) as well.

N0ctrnl 02-12-2016 05:58 PM

Oh man. Just the defiant armor option... If you could do something like that for each TS item, by era this'd be about the most powerful tool around for paring a DB.

Shin Noir 02-13-2016 07:07 AM

It's not complete, but the idea is that I can write an initial process, like the defiant armor flush, and if anyone finds items the process missed, you report it, i'll add it in, you re-run the same operation after updating, and eventually the feedback causes all entries vanish, and nobody ever has to do it manually again!

Shin Noir 02-25-2016 03:56 PM

To update those who use this, I've added a few new menu options and improves past ones:

peqtweaks -> This fixes minor glitches like skeletons being permarooted and other misc peq latest issues.
fabled -> Removes Fabled mobs from any spwn group entries
shadowrest -> Removes shadowrest npc in ecommons and other shadowrest related emissaries.
namedreduce -> lowers spawn rate of certain nameds, since PEQ classic spawns named too often.
aug -> removes augs from dropping in game.

I didn't make a build, but if anyone is interested in these lemme know.

The Zone migration tool and era-based TS remover has progress done but nothing worth committing yet.

Krran 02-26-2016 06:24 AM

This looks like something I would be a fan of. Once the semester is done I am going to revisit this. Thanks man!

Shin Noir 03-16-2016 08:05 PM

Added character wipe option and general updates across the board, version 0.13 now.

http://i.imgur.com/LCVupHt.png

Riklin 07-30-2016 07:27 PM

There are 2 other sets of items" to consider deleting in addition to the Defiant gear. There is also the "Combatant's" gear for melee classes, and the "Adept's" gear for caster classes. If someone is going to delete the drops for Defiant, they'll want to get rid of these drops too...

Riklin (Hall's Havoc)

Vandax 10-08-2016 09:19 PM

I'd love to use this as the tool would be super useful! However, I am experiencing an error: <Status: Bad <Error decoding config: XML syntax error on line 121: unexpected EOF>>

It is reading the DB just fine, everything is good there. But decoding the eqemu_config file is no good.

I am running Windows 7 64-bit.

Shin Noir 10-08-2016 10:11 PM

Try going to http://xackery.github.io/eqcleanup/ again and click the download link. That page had an older version on there.

Vandax 10-08-2016 11:13 PM

Worked like a charm! Thank you!

braindisconnect 01-03-2017 02:17 PM

Shin Noir would you happen to have a current Linux build for what you have on git? I was trying to compile it myself, but there are a lot of static directories in your code. I am interested in the zone reversion to old paw and old cazic. Figured it would be easier to ask you if you have a current linux build :D

Shin Noir 01-09-2017 01:13 PM

Just saw this, sadly, my zone migrators are work in progress and do not currently work. :(

As to your current linux build, if you go to releases.. https://github.com/Xackery/eqcleanup/releases the x86 and x64 should run on their respective architectures of all linux binaries.


they may not include the migration tools, but again, they are not feature complete. :(

Brilhasti 11-19-2017 09:36 AM

I was searching for defiant and fabled removal and found this thread. Your tool has worked perfectly, thank you so much :)

mrhodes78 01-12-2018 04:46 PM

WOW. I just ran across this tool. Worked like a charm. What a major, major time saver and help, I can't thank you enough.

Dharrk 01-24-2018 05:11 PM

Thank you for this wonderful tool Shin. I wanted to write here to let you and others now that the current version points to the old eqemu_config.XML and needs to be re-pointed to the new .json. So those that compile your files can make a simply adjustment but those that rely on your exe will need to have it recompiled. Thank you again for the great program that has saved dozens of hours!

Shin Noir 01-25-2018 05:16 PM

I can just update it to support json.. :P probably easier.

Nydosa 04-11-2018 10:31 AM

Would also love to try this... does v0.14 have the json update?

GRUMPY 04-11-2018 12:44 PM

I have never tried this tool, looks like it's a great tool, but if
it had something to disable spawns, instead of deleting them,
it would be kewl. Like the choice of "remove fabled".
Is that removal from spawn tables or does that delete them ?
I like to keep in the DB, just for anticipation of a special event.

ryandward 09-16-2018 02:29 AM

Thanks for all your work, but it's not working without the JSON update. Any news on that front?

ryandward 09-16-2018 03:14 AM

Quote:

Originally Posted by ryandward (Post 260179)
Thanks for all your work, but it's not working without the JSON update. Any news on that front?

For anybody who's stuck, you can download the old eqemu_config.xml file from Akkas github, and it'll still work for this purpose.

Shin Noir 01-19-2019 06:18 PM

This tool seems to be getting quite a bit of traction/attention/interest, so I'm going to resume work on it.

Today I started working on a 1.0 version.

Brilhasti 01-20-2019 05:12 AM

Quote:

Originally Posted by Shin Noir (Post 261361)
This tool seems to be getting quite a bit of traction/attention/interest, so I'm going to resume work on it.

Today I started working on a 1.0 version.

Excellent. Very handy tool, personally hate defiant and fabled so it's been useful for me.

Shin Noir 01-22-2019 07:53 AM

Good news for new server makers.. I've been chatting with eqemu/peq dev staff and we'll be working on #project-peq-expansions.

This project is hoping to make the process of turning PEQ into a specific expansion as simple as possible, most of which by changing a rule and restarting your server. (Some exceptions, for example legacy zones and spells will require clients to be given new files and some alternative edits)

Due to this effort, and depending on how well this goes, the need for eqcleanup will potentially be eliminated and instead streamlined into the PEQ database we all tend to baseline with! Woohoo.

Thalix 01-22-2019 04:08 PM

Well. I've been working on a classic server for months. The database is about 10% of the work. You'll need to redo all the quests, research how they worked on your target expansion, correct all encounters, factions, combat mechanics, spells, tradeskill recipes, zones, spawns, add countless missing NPC interactions, and much, more. Doing all this with a simple Database rule would be work for years.

Shin Noir 01-22-2019 06:37 PM

Indeed. There are many projects who have had the same efforts you described done, many of which have contributed their efforts in one way or another, hopefully they can help bootstrap the time needed, and if you feel inclined, you can contribute too! The sooner we establish a baseline, the less effort people will have to repeat every time they want a legacy server is the hope.

trustandfall 04-18-2019 12:55 AM

Quote:

Originally Posted by Shin Noir (Post 261414)
Indeed. There are many projects who have had the same efforts you described done, many of which have contributed their efforts in one way or another, hopefully they can help bootstrap the time needed, and if you feel inclined, you can contribute too! The sooner we establish a baseline, the less effort people will have to repeat every time they want a legacy server is the hope.

I just wanted to say that reading through this had me HYPED. I really, really hope to see the day come where you can simply toggle on and off expansions. That is literally my dream. I run a private server, and I "gate" myself out of expansions until I defeat them using a box army.

Your hard work would make this so, so simple for so many people to enjoy for years to come. Thank you so much.

Xanathol 05-20-2019 02:01 AM

I just stumbled upon this thread and saw the comments on project-peq-expansions and the github page or old zone data - I am STOKED! Any updates you can share? This is a HUGE feature imo; let me know if there is any way to help!

strugglegenerator 06-01-2019 09:57 AM

Does this tool work with the JSON version yet? =)

Titus Pullo 06-01-2019 11:57 AM

Quote:

Originally Posted by ryandward (Post 260180)
For anybody who's stuck, you can download the old eqemu_config.xml file from Akkas github, and it'll still work for this purpose.

It did not as of a week ago, but I followed the advice above and it worked great.

Nilzark 07-06-2019 08:49 AM

Looking forward to the expansion toggle options! Seems a difficult task. I wish you luck.

cdolick24 11-04-2019 04:26 PM

Trying to get a better understanding of what some of the options do, i.e. deleting spells, does that delete all spells in the DB for manually added spells?

Riklin 11-07-2019 11:26 PM

I recently used this script and had some issues with it I want to comment on. Version I used was the latest linux version, used on Debian 10. Ran via SUDO.



1. On the option to remove Fabled npcs. I found out it ALSO REMOVES SOME OF THE NON FABLED VERSIONS! So if you use this, you have to go reinsert all the non-fabled versions!

2. Regarding the option to remove spells and tomes, it is very loosely described. It literally removes ALL spells and tomes! I mean ALL of them! Not just ones higher than a specific expansion! When I realized this happened, I reloaded the database. Reinserting all the appropriate spells and tomes would be a HUGE effort!

It has some interesting and useful selections, but some of them need refined, in my opinion...

cdolick24 04-27-2020 06:41 PM

Error
 
I keep trying to utilize the tool, and when i go to remove trick or treat quest, option 5 i get this error;

Removing 7 item ids
0,Error removing 84084 from merc inventory : Error 1146: Table 'peq.merc_inventory' doesn't exist
Error removing trick or treat: Error 1146: Table 'peq.merc_inventory' doesn't exist

Shin Noir 07-24-2020 06:06 PM

I'm surprised how often folks use this tool!!

Once peq-expansions is released, i may take another look at this (or incorporating the features eqcleanup was built to support). Thanks for commenting here if you do attempt it so I know it has a use


All times are GMT -4. The time now is 02:24 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.