07-10-2003, 01:07 PM
|
#1
|
|
A Shissar Defiler
Join Date: Sep 2002
Posts: 173
|
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 "
Last edited by FennyX : 03-15-2015 at 06:01 PM.
|
|
|
|
07-11-2003, 05:19 AM
|
#2
|
|
A Shissar Disciple
Join Date: Jul 2002
Server: Sébilis
Posts: 122
|
that's a good idea ! 
since i play on a localised server, would you allow me to change it a little bit to put in the french names and description ? (if i ever have time to do it :/)
otherwise, one little question : how do you install it ?
__________________
|
|
|
|
|
07-11-2003, 05:39 AM
|
#3
|
|
A Shissar Defiler
Join Date: Sep 2002
Posts: 173
|
You would need to get a french version of lucy's database. The script I use only pulls values out of their file, it doesnt care english, french whatever. Well ok maybe a little bit like the titles and field labels.
See the download page for how to install, all you do is extract the zip to the right folder.
|
|
|
|
|
07-19-2003, 11:43 AM
|
#4
|
|
A Tundra Mammoth
Join Date: Aug 2002
Posts: 67
|
Excellent work!
One thing you could consider is offering this mod separately for each class. That way, every spell only appears once in each file, and the back 'n forth buttons would be a lot easier to implement.
Also, this would actually make the filesize -smaller- as people would be able to decide for themselves what they want.. Like say.. Their own class, and NPC spells (didn't check if you included those, just an example).. This would decrease the download time for most people.
And the spell nuts who want all the spells for all classes (like me, sigh :/) probably won't mind downloading an additional megabyte or two.
__________________
[size=1] Inspect me || Level: 60 (at last count)
|
|
|
|
|
07-19-2003, 02:21 PM
|
#5
|
|
A Shissar Defiler
Join Date: Sep 2002
Posts: 173
|
thats a direction ill keep in mind as i make mods to the script. its some flexibility i dont have right now so it would have to come gradually. though i will say i dont exactly look forward to uploading 14 or 15 different mods after every patch  |
|
|
|
|
08-03-2003, 06:06 PM
|
#6
|
|
A Gray Wolf
Join Date: Aug 2002
Posts: 5
|
This is a really awesome mod!!! Now I don't have to do a web search while in game to see what a spell does if I'm not sure.
I actually do like having the spells for all classes since I have a druid, shaman, and necro, and my husband has an enchanter and beastlord. Especially on our low level chars, we always have to keep checking to see what we get at the next spell level.
I can live without the back and forth navigation - small price to pay to have this information directly in game. Keep up the good work!
|
|
|
|
|
08-03-2003, 07:10 PM
|
#7
|
|
A Treant
Join Date: Sep 2002
Server: Fennin Ro
Posts: 27
|
I love this. Someone asks about a Focus Effect or some spell, and I am all like "Let me consult with Foofy!!"  Seriously, it is very very useful, thanks! |
|
|
|
|
08-03-2003, 09:08 PM
|
#8
|
|
A Shissar Defiler
Join Date: Sep 2002
Posts: 173
|
great! im glad you like it ill be updating after the patch on the 6th i think it is, i have a few new indexes as well. |
|
|
|
|
08-09-2003, 10:14 AM
|
#9
|
|
A Shissar Disciple
Join Date: Aug 2002
Posts: 103
|
Quick question on the installation process of this.......
Your instructions say to "Remember to check the "Use Folder Names" box or you will have a bigger mess than you know how to deal with."
Forgive the stupidity if this is an obvious thing, as my brain is having problems with flatulence at the moment, but what check box are you referring to?
__________________
I am Pasquinel, and I come to you unafraid!
|
|
|
|
|
08-09-2003, 12:32 PM
|
#10
|
|
A Shissar Defiler
Join Date: Sep 2002
Posts: 173
|
i was talking about in WinZip. If you are using some other way to extract files then you'll have to find some method of preserving the file structure stored in the zip.
For example, if you are using the built-in zip extractor in WinXP there are no options to choose, so don't worry about it.
Last edited by FennyX : 08-09-2003 at 12:40 PM.
|
|
|
|
|
08-28-2003, 01:53 AM
|
#11
|
|
A Fire Beetle
Join Date: Jan 2003
Posts: 2
|
This UI mod kinda got some recent airtime on Graffe's (wiz forum), thanks to one of the moderators there. I installed it yesterday, and have to say, I'm very impressed.
I have a suggestion, which will help with the issue of navigating back and forth, and which I believe should be pretty simple to add.
Basically, in the spell description where it lists the class/level of that spell, you could make that link back to the Spells by Level list for that Class/Level.
So for example, Minor Healing would have:
Classes: CLR/1 PAL/9 RNG/9 DRU/1 SHM/1 BST/9
And each one of those would be a link, eg
LEVEL-CLR.txt#level1
LEVEL-PAL.txt#level9
And so on.
Obiviously, to do this, you'd need to add <a name=level1> tags into the level lists, but this can be done at the same time you already output the spell level.
Alternatively, if you want to be more ambitious, the number above links to the spell list by level, and the class name links to the alphabetical spell list.
While neither of these changes is absolutely required, I feel they would make this information much more accessible for users to browse - particularly for class-related spells.
(Edit: add forum link. Oops, did I say Arcanist; I meant Graffe's)
Last edited by Inusan : 10-13-2003 at 09:57 AM.
|
|
|
|
|
08-28-2003, 11:50 AM
|
#12
|
|
A Shissar Defiler
Join Date: Sep 2002
Posts: 173
|
thanks could you post a link to those forums?
thats not a bad idea, my main concern with putting links into the spell pages is the download size. links are the big thing everyone wants =\ thats the best idea yet and you're right its very doable. i wish there was a way to handle the indexes that aren't class-based though.
Last edited by FennyX : 08-28-2003 at 12:01 PM.
|
|
|
|
|
08-28-2003, 03:11 PM
|
#13
|
|
A Bat
Join Date: Sep 2002
Posts: 1
|
I installed it right, but for some reasonw hen i click on the areas it doesnt do anything at all. Little help please
|
|
|
|
|
08-28-2003, 08:40 PM
|
#14
|
|
A Shissar Defiler
Join Date: Sep 2002
Posts: 173
|
Make sure all the files are there. It sounds like you only extracted one file; storyFooyfSpells.txt .. make sure you have the following in your Everquest folder:
a file: Everquest\Storyline\storyFoofySpells.txt
a folder: Everqeust\Storyline\foofy
in the foofy folder there should be a ton of files.
|
|
|
|
|
09-13-2003, 03:59 PM
|
#15
|
|
A Lost Soul
Join Date: Oct 2002
Server: the rathe
Posts: 428
|
i like your spell list. I would take out the message you get. Give some idea as to where the spell can be located.
__________________
Kill them All Let God,if there is one. Sort them out.
|
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear 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
HTML code is Off
|
|
|
|
