EQInterface Forums

EQInterface Forums (http://www.eqinterface.com/forums/index.php)
-   Released (http://www.eqinterface.com/forums/forumdisplay.php?f=5)
-   -   foofyspells (storyline mod) (http://www.eqinterface.com/forums/showthread.php?t=9312)

FennyX 07-10-2003 01:07 PM

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 "

Kunis Marfury 07-11-2003 05:19 AM

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 ?

FennyX 07-11-2003 05:39 AM

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.

Jahari Durden 07-19-2003 11:43 AM

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. :)

FennyX 07-19-2003 02:21 PM

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 :eek:

Borreny 08-03-2003 06:06 PM

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!

Kalysto 08-03-2003 07:10 PM

I love this. Someone asks about a Focus Effect or some spell, and I am all like "Let me consult with Foofy!!" :D Seriously, it is very very useful, thanks!

FennyX 08-03-2003 09:08 PM

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.

Lazaru5 08-09-2003 10:14 AM

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?

FennyX 08-09-2003 12:32 PM

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.

Inusan 08-28-2003 01:53 AM

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)

FennyX 08-28-2003 11:50 AM

thanks :D 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.

kezzerdrix 08-28-2003 03:11 PM

I installed it right, but for some reasonw hen i click on the areas it doesnt do anything at all. Little help please

FennyX 08-28-2003 08:40 PM

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.

kasca 09-13-2003 03:59 PM

i like your spell list. I would take out the message you get. Give some idea as to where the spell can be located.

Wign 09-14-2003 01:00 PM

Update??
 
Is this auto updated or do we need to download a new batch of .txt's when there's a patch?

FennyX 09-14-2003 01:19 PM

need to download every time theres a patch.

download91 10-10-2003 10:44 PM

Problems?...
 
I have a problem with the spell list.

I installed it like you said but when I go to check the list I only get so far...

I open the journal window, load foofy spells, click on the class but then I cant click on the spell names to get data on them.. Is that supposed to happen or did i do something wrong?

FennyX 10-13-2003 02:35 PM

it sounds like not everything got extracted from the zip file. using explorer, check to make sure you have the following (pretend everquest is installed in c:\program files\everquest):

a file: c:\program files\everquest\storyline\storyFoofySpells.txt
a folder: c:\program files\everquest\storyline\foofy
a folder: c:\program files\everquest\storyline\foofy\data

in the foofy folder there should be a bunch of files named things like ALL06-01.TXT, ONOTHER-071.TXT etc.

in the data folder there should be a ton of files named like 0001.TXT, 3586.TXT etc.

it sounds to me like only some files were extracted, maybe even just the main index (storyFoofySpells.txt). or maybe you ran out of disk space while extracting, or maybe the extract process was interrupted in the middle. just try to extract the zipfile again, and make sure you extract everything; because there is a lot :)

download91 10-21-2003 03:44 PM

Ok, I get it now. I'll try this right away. What I did last time was put them in e:\everquest\storyline\---here I put the main file--
the the rest were in e:\everquest\storyline\foofy :p
Thanks. :D

FennyX 11-16-2003 07:28 PM

the lucy download server has been fixed so foofyspells is current once again :)

Vulcon 11-17-2003 03:40 AM

Great work, love it.

FennyX 11-25-2003 02:09 PM

allakhazam has taken over the lucy site, but they are still providing downloads so as long as they keep it up, I can update foofyspells :D

Kerilar Oakenfe 12-02-2003 05:05 AM

Question
 
I love this UI mod, its extreemly useful. I had an idea that I was thinking about trying for myself, but maybe you know an easier way to do it than I do.... what about a Illia's Bestiary conversion? Like mobs by zone, and the basic stats that Illia has listed? Do you run a script to compile the data from Lucy or do you do it by hand? If you did it by script itd be easy ( i assume, I dont know how to write something like that though) but if it had to be done by hand it would be unfeasable.

Lothay 12-02-2003 11:00 AM

He can do this because LUCY provides the data from their database in a downloadable format. Alla's and Illia's do not.

FennyX 12-03-2003 12:17 AM

yeah exactly. i just run a script on the db that lucy lets us download. if allakhazam & illia did the same sure, i'd do it tomorrow :p but being a pay-site thats prolly wishful thinking; in fact, i sort of expect allakhazam to stop allowing downloads soon now that they own lucy.

FennyX 12-07-2003 07:58 AM

The 11-15 version of the db from allakhazam had some old data in there, while the 11-05 version from lucy was correct. Two problems with the 11-15 allakhazam version were a missing Soul Clasp entry and Vampire Kiss having fire resist.

This new 12-06 db from allakhazam seems to fix these problems. Please let me know if you find further errors.

Thanks for the PM, I did try to reply but your box was full. As for the range listing on Nova Inferno, there's two ranges associated with targetted ae spells: caster to target, and radius about target. In foofyspells, Nova Inferno shows a range of 200 and an AE-range of 300. Lucy isnt showing the range field for targetted AE spells, only the AE-range field. I could change this in foofyspells if it's confusing, but I sort of like to see both.

Epix 12-25-2003 01:59 AM

When I try to extract this, it all goes in the same folder (storyline). If it's supposed to extract into various and sundry folders, it's not happening. Maybe I'm WinZip impaired. Please type slower for my rented brain, and try again to explain just how to extract this so that it works.

Thank you so much.

EDITED: NM! I actually had a moment of sense and figured it out. It might help people like me to indicate that you extract everything into the whatever/whatever/whatever/storyline -- just tell them what to enter into the extract line. Otherwise, most of us idiots will put it all in the storyline folder via drag & drop.

Speaking for idiots everywhere, thank you for your consideration!

FennyX 02-11-2004 03:45 PM

for the gates of discord patch i added a bunch of backlinks. inusan up above had a great idea and i've put that in along with links to other places.

for the ppl having trouble with install i modded the FAQ at the beginning of this thread to try helping out; its not much of a FAQ i guess, only two questions :p

FennyX 02-26-2004 06:15 PM

well it looks like what i feared when allakhazam took over lucy has happened. they are no longer providing downloads of the database.

i've started work on my own spdat parser, but i dont know how long it will take. i have the calc formulas already, but not the duration ones, if someone knows of a source i'd appreciate hearing about it.


All times are GMT -5. The time now is 02:59 PM.

vBulletin Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.