Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers
Reload this Page Efficient Way to Clean Up Database (Items Mainly) by Zone?

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 04-20-2018, 09:00 PM
Nydosa's Avatar
Nydosa
Sarnak
  
Join Date: Jan 2013
Posts: 61
Default
I would recommend getting GeorgeS' tool working for viewing total zone loot drops.

Another heavy-handed fix I did for items was remove all items from lootdrop and merchants that had an ID right around when the "newbie" quest show up in the database. I would HIGHLY recommend making a back-up, but around id 19550 they show up in my database, so removing that got rid of 99% of the trash in old-world zones.
Reply With Quote
  #2  
Old 04-21-2018, 08:02 AM
Gnowm
Fire Beetle
  
Join Date: Aug 2009
Location: Australia
Posts: 21
Default
Would searching the lore column for the value 'for the
use of anyone willing to take up arms' (or something close)
find all defiant gear.

Thats just memory, n im not even good at sql but that sounds logical.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 01:34 PM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3