Home Forum Downloads My Favorites Register FAQ Mark Forums Read

Go Back   EQInterface Forums > Interface Gallery Discussion > Released
User Name
Password

Reply
 
Thread Tools Display Modes
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 "

Last edited by FennyX : 03-15-2015 at 06:01 PM.
FennyX is offline   Reply With Quote
Old 07-11-2003, 05:19 AM   #2
Kunis Marfury
A Shissar Disciple
 
Join Date: Jul 2002
Server: Sébilis
Posts: 122
Interface Author - Click to view interfaces
Default

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 ?
__________________
Kunis Marfury is offline   Reply With Quote
Old 07-11-2003, 05:39 AM   #3
FennyX
A Shissar Defiler
 
Join Date: Sep 2002
Posts: 173
Interface Author - Click to view interfaces
Default

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.
FennyX is offline   Reply With Quote
Old 07-19-2003, 11:43 AM   #4
Jahari Durden
A Tundra Mammoth
 
Join Date: Aug 2002
Posts: 67
Thumbs up

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)
Jahari Durden is offline   Reply With Quote
Old 07-19-2003, 02:21 PM   #5
FennyX
A Shissar Defiler
 
Join Date: Sep 2002
Posts: 173
Interface Author - Click to view interfaces
Default

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
FennyX is offline   Reply With Quote
Old 08-03-2003, 06:06 PM   #6
Borreny
A Gray Wolf
 
Join Date: Aug 2002
Posts: 5
Default

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!
Borreny is offline   Reply With Quote
Old 08-03-2003, 07:10 PM   #7
Kalysto
A Treant
 
Kalysto's Avatar
 
Join Date: Sep 2002
Server: Fennin Ro
Posts: 27
Lightbulb

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!
Kalysto is offline   Reply With Quote
Old 08-03-2003, 09:08 PM   #8
FennyX
A Shissar Defiler
 
Join Date: Sep 2002
Posts: 173
Interface Author - Click to view interfaces
Default

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.
FennyX is offline   Reply With Quote
Old 08-09-2003, 10:14 AM   #9
Lazaru5
A Shissar Disciple
 
Join Date: Aug 2002
Posts: 103
Default

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!
Lazaru5 is offline   Reply With Quote
Old 08-09-2003, 12:32 PM   #10
FennyX
A Shissar Defiler
 
Join Date: Sep 2002
Posts: 173
Interface Author - Click to view interfaces
Default

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.
FennyX is offline   Reply With Quote
Old 08-28-2003, 01:53 AM   #11
Inusan
A Fire Beetle
 
Join Date: Jan 2003
Posts: 2
Default

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.
Inusan is offline   Reply With Quote
Old 08-28-2003, 11:50 AM   #12
FennyX
A Shissar Defiler
 
Join Date: Sep 2002
Posts: 173
Interface Author - Click to view interfaces
Default

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.
FennyX is offline   Reply With Quote
Old 08-28-2003, 03:11 PM   #13
kezzerdrix
A Bat
 
Join Date: Sep 2002
Posts: 1
Send a message via AIM to kezzerdrix
Default

I installed it right, but for some reasonw hen i click on the areas it doesnt do anything at all. Little help please
kezzerdrix is offline   Reply With Quote
Old 08-28-2003, 08:40 PM   #14
FennyX
A Shissar Defiler
 
Join Date: Sep 2002
Posts: 173
Interface Author - Click to view interfaces
Default

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.
FennyX is offline   Reply With Quote
Old 09-13-2003, 03:59 PM   #15
kasca
A Lost Soul
 
Join Date: Oct 2002
Server: the rathe
Posts: 428
Send a message via ICQ to kasca
Default

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.
kasca is offline   Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -5. The time now is 08:52 AM.


vBulletin Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
© MMOUI