View Single Post
Old 07-10-2003, 01:07 PM   #1
FennyX
A Shissar Defiler
 
Join Date: Sep 2002
Posts: 173
Interface Author - Click to view interfaces
Default foofyspells (storyline mod)

Foofy's Spell Lists

Current version is: Live 2015-02-24 18:35:49
md5: EE9B97B3AE1D35C33A81727E55434CD4 foofyspells.zip


This is a conversion of the Lucy spell database created/provided by Allakhazam.

Here's some answers to a few questions I've been asked.

Q: I extracted this but it's not working. What did I do wrong?
A: When extracting the files, you need to type in the name of your storyline folder; for me, that would be "c:\program files\everquest\storyline".

When you have extracted things correctly, you should see the following items in your Everquest/Storyline folder:
  • a file named storyFoofySpells.txt
  • a folder named foofy
  • a TON of files in the foofy folder named things like abc fxq bbq etc

Q: Why don't your New & Changed indexes match up with the things Lucy says are "new" and "changed"?
A: Lucy calls a spell changed if even one field in the spell data changes. Things like "spell icon" or "unknown180" changing is enough to flag it changed. FoofySpells only reports a change for a field that is displayed by FoofySpells. Since it doesn't show things like "spellicon" or "unknown176", changes to those fields in the spell data aren't counted as changes in FoofySpells.

Q: This unzips slow.
A: FoofySpells has around 40,000 tiny little files. If you have anti-virus running, they tend to scan every file as it gets created so you'll definitely run into some slowing down. Could disable virus scanners while you unzip, but that's entirely your choice.

There is also the possibility you are low on disk space, but most people have giant h/d so probably not. Regardless, even though the zip is about 20MB, it expands to enormous proportion because of something called "cluster size". if you have the default formatting for your h/d, your cluster size is 4k. with 40,000 files, this means it expands to around 200MB. it's up to you to decide if this is a problem or not.

enjoy!


Update History
Code:
03/15/15 - Live 2015-02-24 18:35:49 01/30/15 - Live 2015-01-22 18:33:35 12/15/14 - Live 2014-12-05 16:17:54 11/23/14 - Live 2014-11-17 18:31:17 11/16/14 - Live 2014-10-23 20:48:06 09/09/14 - Live 2014-08-19 18:49:44 06/29/14 - Live 2014-06-19 18:57:24 05/25/14 - Live 2014-05-20 17:29:26 04/29/14 - Live 2014-04-24 22:23:20 04/23/14 - Live 2014-03-31 22:16:44 03/23/14 - Live 2014-03-11 00:25:16 02/24/14 - Live 2014-02-18 14:54:32 02/05/14 - Live 2014-01-24 14:22:42 12/14/13 - Live 2013-12-06 21:10:50 11/10/13 - Live 2013-11-04 16:22:55 10/11/13 - Live 2013-10-04 00:41:20 08/23/13 - Live 2013-08-20 17:01:56 07/20/13 - Live 2013-07-15 18:48:22 06/21/13 - Live 2013-06-18 01:06:56 06/04/13 - Live 2013-05-23 17:29:22 05/28/13 - Live 2013-05-10 19:51:40 05/02/13 - Live 2013-04-22 15:03:36 04/21/13 - Live 2013-04-15 23:23:50 03/17/13 - Live 2013-03-12 17:29:58 02/18/13 - Live 2013-02-11 21:03:46 previous update was corrupt file 02/16/13 - Live 2013-02-11 21:03:46 01/19/13 - Live 2013-01-14 20:55:42 12/22/12 - Live 2012-12-06 20:59:26 11/30/12 - Live 2012-11-23 22:18:38 10/17/12 - Live 2012-10-12 19:28:02 09/23/12 - Live 2012-09-14 21:44:22 08/30/12 - Live 2012-08-17 01:56:46 08/21/12 - Live 2012-08-13 14:18:31 07/25/12 - Live 2012-07-13 18:59:36 06/28/12 - Live 2012-06-25 17:02:39 05/15/12 - Live 2012-05-10 12:55:03 04/16/12 - Live 2012-04-10 18:55:29 03/23/12 - Live 2012-03-22 06:42:59 02/09/12 - Live 2012-02-07 21:51:24 01/27/12 - Live 2012-01-24 09:52:45 01/07/12 - Live 2012-01-10 21:55:22 12/15/11 - Live 2011-12-14 01:47:43 12/05/11 - Live 2011-11-22 01:43:46 11/15/11 - Live 2011-11-14 21:32:07 lol sixth wind 10/15/11 - Live 2011-10-12 00:47:32 09/19/11 - Live 2011-09-14 23:51:00 09/05/11 - Live 2011-08-09 21:49:25 06/21/11 - Live 2011-06-15 00:14:19 04/23/11 - Live 2011-04-14 15:48:58 03/21/11 - Live 2011-03-16 03:56:59 03/17/11 - Live 2011-03-08 02:50:40 02/19/11 - Live 2011-02-10 18:55:13 01/29/11 - Live 2011-01-11 23:04:09 12/14/10 - Live 2010-12-04 01:54:38 11/11/10 - Live 2010-11-08 16:47:17 10/26/10 - Live 2010-10-19 01:46:23 09/16/10 - Live 2010-09-07 16:28:33 08/26/10 - Live 2010-08-16 16:56:21 07/26/10 - Live 2010-07-12 12:07:17 06/12/10 - Live 2010-06-07 15:43:47 05/19/10 - Live 2010-05-11 21:34:57 03/12/10 - Live 2010-03-05 22:11:52 02/11/10 - Live 2010-02-09 19:50:16 02/03/10 - Live 2010-01-11 16:44:50 01/03/10 - Live 2009-12-12 00:14:51 10/10/09 - Live 2009-10-06 15:43:25 09/17/09 - Live 2009-09-09 16:12:13 09/13/09 - Live 2009-08-17 16:03:10 hadn't noticed this update, so its late 08/13/09 - Live 2009-08-11 15:36:04 07/23/09 - Live 2009-07-13 17:39:27 07/03/09 - Live 2009-06-23 21:51:52 06/13/09 - Live 2009-06-08 20:01:03 05/27/09 - Live 2009-05-20 00:49:02 05/15/09 - Live 2009-05-07 23:50:33 04/11/09 - Live 2009-04-06 18:58:43 03/20/09 - Live 2009-03-10 19:49:35 02/12/09 - Live 2009-02-07 00:26:38 stabilized spell detail filenames, increased length of filenames to four 02/04/09 - Live 2009-01-15 17:54:50 12/10/08 - Live 2008-12-06 03:59:48 11/13/08 - Live 2008-10-29 02:25:45 Fixed up missing spell details, replaced tradeskill, focus, and cure type indices with class timer indices. 10/22/08 - Live 2008-10-20 22:51:12 SoD 09/01/08 - Live 2008-07-09 02:52:34 updated! delayed sry~ 05/09/08 - Live 2008-05-06 17:20:52 added cure corruption index 04/18/08 - Live 2008-04-17 00:59:11 04/05/08 - Live 2008-03-11 18:48:51 03/09/08 - Live 2008-02-27 22:58:44 02/07/08 - Live 2008-02-05 16:45:13 01/18/08 - Live 2008-01-16 00:57:19 12/07/07 - Live 2007-12-05 00:28:22 11/27/07 - Live 2007-11-20 20:25:15 11/14/07 - Live 2007-11-12 21:58:06 SoF 10/31/07 - Live 2007-10-29 18:30:49 10/08/07 - Live 2007-10-01 23:10:56 08/21/07 - Live 2007-08-14 07:25:10 07/30/07 - Live 2007-07-25 10:46:39 07/10/07 - Live 2007-07-05 13:28:29 06/16/07 - Live 2007-06-06 14:08:05 added hate amount field 04/26/07 - Live 2007-04-18 12:12:33 04/09/07 - Live 2007-03-29 11:30:51 03/16/07 - Live 2007-03-14 08:09:58 02/27/07 - Live 2007-02-21 08:37:38 01/18/07 - Live 2007-01-17 12:06:59 01/05/07 - Live 2006-12-14 13:05:41 12/13/06 - Live 2006-12-05 10:26:38 11/22/06 - updated to Live 2006-10-30 20:24:28, hadn't noticed spdat was updated so this is like a month delayed 09/21/06 - updated to Live 2006-09-19 21:28:11, TSS 07/29/06 - updated to Live 2006-06-28 11:55:37 06/20/06 - updated to Live 2006-06-13 12:34:46, managed to just barely squeeze in under the 6MB limit at 5.98MB 03/20/06 - updated to Live 2006-03-15 23:51:53, has info on fabled ae's 02/22/06 - updated to Live 2006-02-22 10:06:37, changed query conditions on class specific lists to exclude spells with level 127 and 255. lucy seems screwed up a bit and uses 127, -1, and 255 depending on class. spdat uses 255. also now lucy is passing the level 254 spells through (AA's) as well as a new level 225 spell for healers. melees will see the old opening system aa's listed in some cases, notably ranger and rogue. 11/17/05 - updated to Live 2005-11-16 12:59:26, removed the 'Game Description' field from the spell details page for the time being, sony has moved the data into a new file called dbstr_us.txt. 10/12/05 - updated to Live 2005-10-12 13:57:39 09/13/05 - updated to Live 2005-09-13 11:33:41, DoD 07/14/05 - updated to Live 2005-07-13 13:31:27 07/02/05 - updated to Live 2005-06-29 16:23:52 06/03/05 - update was just a change to the description text, no actual data changes. 05/19/05 - updated to Live 2005-05-18 12:36:25 05/12/05 - updated to Live 2005-05-11 14:37:27 05/04/05 - updated to Live 2005-04-20 13:21:22 04/13/05 - updated to Live 2005-04-12 13:05:05 03/11/05 - updated to Live 2005-03-17 10:31:08, has DoN info, haven't been playing eq and saw people wanted an update, my accounts are inactive so i can only verify it as working with my html version. if you see errors like text not displaying correctly please post in this thread. 01/09/05 - updated to Live 2004-12-15 10:29:01, sorry for the delay 10/26/04 - updated to Live 2004-10-25 11:59:14, trying another version of class level index, maybe this one satisfies everyone 10/13/04 - updated to Live 2004-10-13 12:03:27 09/23/04 - updated to Live 2004-09-23 11:30:28 09/16/04 - updated to Test 2004-09-14 22:03:35, lucy hasn't given a db for the live servers so this is based on the latest test server info. attribute indices are bugged past attribute #255 because of how lucy is dumping the csv file. put the class-level based index back to how it was, i just liked it better. 08/11/04 - updated to Live 2004-08-11 10:25:30, hearts at the bottom of the page take you to the main index, some cleaning up of appearances, converted some other indices to the fastindex style, let me know what you think of the new index style, i may put them back to the old way for eqinterfaces. 07/17/04 - fixed a problem with where certain spells linked back into the new AllSpellsByName index. changed ClassbyName/byLevel indexes to use the new fastindex. 07/15/04 - updated to Live 2004-07-14 09:45:55, some changes to reduce file size a bit, definitely delete your old copy before installing, file layout and names are all changed. replaced the old ABC all-spells index with a much faster index, we'll see how ppl like it :) also added some info to donate! plz get me another game card, i would love for eq to pay for itself :p removed the detrimental only versions of the messages index, and the "cooked attributes" index, they were sort of not so useful. reorganized the allspells & other lists sections a bit. 06/16/04 - updated to Live 2004-06-16 10:05:51, lucy skipped a patch so there will be new/changed spells that are "old", updated for level 70, the db lucy provides is sort of bugged atm because they are setting any attributes greater than 254 to 255 which is messing up the "Unknown #255" raw attribute list; probably a field width definition error in the CSV dumping code so bug them not me :) 05/26/04 - updated to Live 2004-05-26 10:49:51 05/13/04 - updated to Live 2004-05-12 10:26:49, removed the AE Detrimental index because it wasn't accurate; some AE target types are unknown. slightly rearraged "Other Lists" on the main page. 05/05/04 - i missed a whole update on 04-28, this adjusts the new/changed indexes to compare between 05-05 and 04-28 instead of 04-21. Balance of the Nihil was a big change between 04-21 and 04-28 (just fyi). sorry about that! :) 05/05/04 - updated to Live 2004-05-05 11:15:35 04/25/04 - updated to Live 2004-04-21 12:24:19 04/20/04 - its not really new, just changed the description since backslashes mysteriously disappeared from the file path info 04/14/04 - updated to Live 2004-04-14 12:00:37 03/30/04 - updated to Live 2004-03-30 09:48:53, added some 'uknown' AE types to the AE Detrimental index 03/24/04 - updated to Live 2004-03-23 10:00:50 03/16/04 - updated to Live 2004-03-16 10:52:06 03/10/04 - updated to Live 2004-03-10 09:47:24 02/10/04 - updated to Live 2004-02-10 11:16:59, lots of new indexes, finally some *limited* backlinks, and uh.. well a bunch of other stuff :) enjoy gates of discord! 01/14/04 - just changed the install instructions a bit, its not really new :p 12/19/03 - updated to "Live 2003-12-19 10:32:13" 12/18/03 - had left out hybrid disciplines from class indexes, sorry moderators! :) 12/18/03 - updated to "Live 2003-12-18 10:39:31", rearranged front page to make room for new melee sections, added endurance upkeep field for melee abilities 12/07/03 - updated to "Live 2003-12-06 00:56:40", this fixes the old data from the 11-15 version 11/25/03 - updated to "Live 2003-11-15 14:28:39", this is based on new downloads coming from db.allakhazam.com 11/16/03 - updated to "Live 2003-11-05 11:11:20" .. lucy downloads are working again! :D 10/10/03 - updated to "Live 2003-10-10 11:15:27" 10/09/03 - updated to "Live 2003-10-09 15:43:27" 09/12/03 - updated to "Live 2003-09-09 14:34:19", this is just an update to stay current with lucy's data. they put up a new db, but the data hasnt changed so if you have the previous version of foofyspells you dont really need this one. still no descriptions for ldon spells. 09/09/03 - updated to "Live 2003-09-09 10:47:32", added Attack buff index, LDoN! 08/26/03 - updated to "Live 2003-08-26 10:31:10" 08/06/03 - updated to "Live 2003-08-06 15:00:12", added class alphabetical, tradeskill, cures, and detrimental only versions of CastOnXxx indexes. removed "Updated" field from details, added "Deletable" field to details. 07/11/03 - really updated to "Live 2003-07-11 11:22:38 " this time :) 07/11/03 - updated to "Live 2003-07-11 11:22:38 ", added more info to CastOnYou/CastOnOther indexes, better sorting of class indexes, cleaned up alpha-bar in main index 07/10/03 - updated to "Live 2003-07-10 11:12:44 ", paged long indexes, added CastOnYou/CastOnOther indexes, alpha-bar AllSpells listing on main index, eof markers 06/18/03 - Fixed Bard and Ranger indexes, Level xx subheadings weren't being generated 06/11/03 - updated to "Live 2003-06-11 12:42:29 " 06/09/03 - based on "Live 2003-06-05 02:15:18 "
FennyX is offline   Reply With Quote