View Full Version : quest info via the storywindow
Nerconom
07-19-2005, 06:26 PM
As I'm sure some of you know, I've been involved in the Demi-lich skullcap quest for a few weeks and I'm nearly done now (waiting on help to go into HS). I got sort of annoyed switching between eq and other apps to pull up the quest info I needed.
Basically, I pulled text from webpages and such and compiled them into a form that can be brought up in the story window within EQ. I've been doing it by hand using windows Notepad. First, I was wondering if I should post my project for others to download. If people are interested, I will do such, if not then I won't bother. Second, I was wondering if there is an easier program that I can do that sort of html in, since I've had to teach myself the coding by looking at others examples, and it's become quite time consuming that way. Any suggestions?
If enough people were willing to pitch in, we could have quite a selection for people to download and make their lives a little easier when we have long quests like this one.
Sarnath Creed
07-19-2005, 07:21 PM
I think that sounds like a pretty good idea.
I have that checklist of items needed for all the quests next to my comp, and every now and then i go camp for a few items and check em off as i get them. have been having trouble geting the sarnak hatchlings to spawn. :blink:
I would definatly use that tho :)
A++
banewolf7
07-19-2005, 08:17 PM
Does it just have like only text in the Story Window? It's not like tasks when it shows that you've completed it tho right? It would still be helpful, being as I get a lot of papers on my desk, and my checklists always get lost, lol But then again, I got two comps on my desk, so I always have Alla's up on my other comp.
Nirruden
07-19-2005, 08:24 PM
Originally posted by Sarnath Creed@Jul 19 2005, 07:21 PM
have been having trouble geting the sarnak hatchlings to spawn.
1. Go to lake of ill omen. Move north, to the cabilis area. Move east/south out into the area where the newbie mobs spawn.
2. Kill everything. Don't bother to loot, just keep killing. Jaboner is a ewbie mob blender, so queue him up on several mobs in succession, and just let him pretend to be a mage pet for a while.
3. Goblins and Sarnak kill each other. If you want sarnak, kill the goblins on sight.
4. When the area looks like genocide, you will be rewarded. Patience is key. You will have your brains in short order - the tapestry takes a bit longer.
Nerconom
07-19-2005, 08:45 PM
Yes, loio is the place for sarnak hatchling brains and tapestry, kill the goblins constantly and you will get the pieces fairly quickly. Took me about 15 min tops for the brains and the tapestry.
It does show up as text in the story window, and I have it seperated by what step of the quest you are on (ie. first skullcap, second, third...) and I have included all the text and faction hits. I also have a section dedicated to getting the faction needed for those of us that are not Iksar. When you bring up the "story" in the story window, you can click on the part of the quest that you are on. I am going through and adding color to highlight things like zones or certain mobs, also included will be color coding of what items are no-drop, no-rent, or droppable.
Alot of the text is copied from websites, but I give credit and list that in the main page of it. I don't have it here (I'm at work), but when I get home I will upload it and you can check it out, it won't interfere with any function of everquest at all.
banewolf7
07-19-2005, 11:56 PM
Kewl, Thnx for all the helpful work you're doing!
/hats off
Nerconom
07-20-2005, 08:33 PM
Ok, sorry it took me a little longer, I went back and added the proper colors and a key to it, as well as a few notes to help with certain mobs. The link to download is here:
http://rapidshare.de/files/3216075/demilichskullcap.zip.html
If you haven't used rapidshare in the past, click the link and scroll down on the page. You will see a button that says "free". Click that and scroll down again. You will be given a "download ticket" where basically you wait anywhere between a few seconds and 40 seconds (it will count down on screen for you) before a link will pop up allowing you to download the zip file.
To install it, simply unzip the file into your storyline folder in the EQ directory, which should be something like "C:\Program Files\Sony\Everquest\storyline".
Log into the game and bring up the story window with ALT + N and you should see the Demi Lich Skullcap quest show up as one of the stories in the top half of the window, click on it and go from there.
If you have any problems or suggestions, post them here and I will check back and perhaps modify these files some as I go along (not quite finished with the quest myself).
Veratu
07-21-2005, 12:56 AM
That is a really good Idea Necronom!
Veratu
Nerconom
07-21-2005, 03:42 AM
Anyone else use mods like this? I've heard of a huge tradeskill one, but I can't find a place to download a recent one, the latest one I've seen was from 2003.
GnekroeGnomicon
07-21-2005, 03:15 PM
I know eqtraders has a foraging story add on... haven't really seen any others out there, though it would be a good thing to build a collection of "common" data that needs to be kept...
ie.
Epic 1 walkthrough/checklist
Epic 1.5 Prequest walkthrough/checklist
Epic 1.5 walkthrough/checklist
Demi-lich skull cap
Epic 2 walkthrough/checklist
DoN progression walkthrough/checklist
PoP progression walkthrough/checklist
Major quest guides:
Coldain Shawl Quests
Coldain Ring Quests
Break in Communications
Tier 1 oow quest items
etc.
Maybe even zone-guides like a PoM guide or something like that...
Nerconom
07-21-2005, 09:18 PM
Problem is that it is best if people who have actually done the quests can put input or even write the guides themselves, most of those quests I've never even attempted, thats why I chose the Demi-Lick skullcap.
I would be willing to put together any check-list or basic guides, but they would be completely ripped from alla's (not as though the Demi-lich wasn't ripped, but I did add my own info to it as well.)
I'll see if I can put together a few checklists and upload them when I get the chance. Do we host files on this website ever? Or should I stick with rapidshare?
Xislaben
07-22-2005, 05:08 AM
Originally posted by GnekroeGnomicon@Jul 21 2005, 03:15 PM
I know eqtraders has a foraging story add on... haven't really seen any others out there, though it would be a good thing to build a collection of "common" data that needs to be kept...
ie.
Epic 1 walkthrough/checklist
Epic 1.5 Prequest walkthrough/checklist
Epic 1.5 walkthrough/checklist
Demi-lich skull cap
Epic 2 walkthrough/checklist
DoN progression walkthrough/checklist
PoP progression walkthrough/checklist
Major quest guides:
Coldain Shawl Quests
Coldain Ring Quests
Break in Communications
Tier 1 oow quest items
etc.
Maybe even zone-guides like a PoM guide or something like that...
Oh yeah I'm all over this, such a good idea.
Once loaded you don't need to rezone to see changes either, this means testing won't take for fricking ever.
How much html is supported in the storyline format? Iframes maybe? Can I have my own web browser in there looking stuff up on lucy while playing?
More later, must sleep now.
Nerconom
07-23-2005, 03:18 PM
As far as I know, there is very limited html supported. I have been looking for a way to create a checklist that you would be able to actually check off as you do things, but I don't think the game will let you write to the files dynamically. You would have to edit the actual html text file for that to take hold.
Xislaben
07-25-2005, 01:59 PM
Originally posted by Necronom@Jul 23 2005, 03:18 PM
As far as I know, there is very limited html supported. I have been looking for a way to create a checklist that you would be able to actually check off as you do things, but I don't think the game will let you write to the files dynamically. You would have to edit the actual html text file for that to take hold.
Yeah so far I've only found that breaks
and colors <c> work, and hyperlinks too.
At the very leaste I could use static information that can't remembers, like which mobs in zone X drop which items, maybe with further links to those items individually, or enumerated in the same file.
Nerconom
07-25-2005, 06:52 PM
That's basically what I've been told the eqtraders one DID (not sure if it still exists). Apparently there was a huge amount of information pulled from that website with linking to the files via the name.
Is there any program that will help do some of the coding a bit faster than manually doing it with notepad? Maybe something that would dummy proof it a bit (ya know, highlight something, select a color, and when finished the program will insert the proper tags?). This can be quite tedieous(sp??).
I am hoping to make a PoP progression guide next, but that will be quite a bit of text to deal with.
Xislaben
07-25-2005, 07:10 PM
Originally posted by Necronom@Jul 25 2005, 06:52 PM
That's basically what I've been told the eqtraders one DID (not sure if it still exists). Apparently there was a huge amount of information pulled from that website with linking to the files via the name.
Is there any program that will help do some of the coding a bit faster than manually doing it with notepad? Maybe something that would dummy proof it a bit (ya know, highlight something, select a color, and when finished the program will insert the proper tags?). This can be quite tedieous(sp??).
I am hoping to make a PoP progression guide next, but that will be quite a bit of text to deal with.
Well there's a downloadable lucy db, you could write an application that parses certain information out of the database and insert it into specific text files in some directory, and then creat a master list of names, but you'd have to manually sacroll down that list in game to find the item to click on, and with so many items that may be kind of hard. Plus there's got to be some limit to the amount of text that window can store. The e-mail system which is realtively new has a very small amount of text that can be stored in it. In fact it's been rather designed rather poorly. Just reply to an all-guild e-mail and see how the reply truncates out the original e-mail text due to the huge munber of characters needed to represent every guild member's full e-mail address in game.
GnekroeGnomicon
07-25-2005, 10:12 PM
Well there's a downloadable lucy db, you could write an application that parses certain information out of the database and insert it into specific text files in some directory, and then creat a master list of names, but you'd have to manually sacroll down that list in game to find the item to click on, and with so many items that may be kind of hard. Plus there's got to be some limit to the amount of text that window can store. The e-mail system which is realtively new has a very small amount of text that can be stored in it. In fact it's been rather designed rather poorly. Just reply to an all-guild e-mail and see how the reply truncates out the original e-mail text due to the huge munber of characters needed to represent every guild member's full e-mail address in game.
Holy crap I am all over this... where is the downloadable lucy located
// Runs off to find LUCY@HOME
Didn't find a "real" dump of lucy, but there is this - which has item and their associated db number, which of course can then be parsed further.
http://lucy.allakhazam.com/itemlist.txt.gz
Things to play wiht in the coming days.
Zeller TP
07-25-2005, 10:41 PM
There's also:
http://eqitems.13th-floor.org
Xislaben
07-26-2005, 01:36 PM
Originally posted by Zeller TP@Jul 25 2005, 10:41 PM
There's also:
http://eqitems.13th-floor.org
Yeah that's the db I was thinking about.
I'm afraid it only give ya stats, and not proc names, only the id# for the proc. So the item wouldn't be like a lucy item unless you could get a more details db with other tbales (with procs etc) from one of the emulator sites:
http://www.projecteq.net/
http://www.eqemulator.net/
The classic db on http://www.projecteq.net/ should have a 100meg sql statement that creates db's and adds in tons of items and procs and stuff.
http://www.projecteq.net/download.php?file=5.8-classic.zip
It only has about 34228 items in it though :(
Nerconom
07-26-2005, 02:48 PM
And unfortunately, it doesn't give an idea on where the mobs are found that drop the items or sell the items. That would be very useful for quests and such.
A few years ago, there was a program that was called EQwatcher or EQEvolution or something like that. I remember one of the nice things about it was that you could leave it running in the background, turn on logging in-game, and type commands to it and it would return results via the storyline window.
The use for it at the time was that you loaded the latest spell file from lucy and you could run a search on any spell in the game. The storyline window txt files can be modified while the game is running, because that's how I tested the mod that I made. Anyone ever programed a parcer to figure out what their DPS is and all that? It would have to be much the same thing, only with an output file saved to the storyline txt file and put into basic html.
I think I'm going to look into some of those programs and see if they can be modified, or if I get really bored I may try to make a simple one in visual basic or C++.
Xislaben
07-26-2005, 03:57 PM
Originally posted by Necronom@Jul 26 2005, 02:48 PM
And unfortunately, it doesn't give an idea on where the mobs are found that drop the items or sell the items. That would be very useful for quests and such.
A few years ago, there was a program that was called EQwatcher or EQEvolution or something like that. I remember one of the nice things about it was that you could leave it running in the background, turn on logging in-game, and type commands to it and it would return results via the storyline window.
The use for it at the time was that you loaded the latest spell file from lucy and you could run a search on any spell in the game. The storyline window txt files can be modified while the game is running, because that's how I tested the mod that I made. Anyone ever programed a parcer to figure out what their DPS is and all that? It would have to be much the same thing, only with an output file saved to the storyline txt file and put into basic html.
I think I'm going to look into some of those programs and see if they can be modified, or if I get really bored I may try to make a simple one in visual basic or C++.
Mmm I suspect that could be seen as as eula violation, passing data to and from eq dynamically and all :(
You could pretty easily send a command to the chat window and have a sniffer read it, and look up some item on lucy and return the data from that query in text for to either the notes or to the story line, but I doubt soe would like it.
I'd like to contribute to building something that'd pass under the radar if you know what I mean.
GnekroeGnomicon
07-26-2005, 03:58 PM
me thinks it is time to slurp lucy... set up a chron to grab new/updated items each night and then we are cookin' with fossil fuel :)
Xislaben
07-26-2005, 04:07 PM
I'm creating a master file that'll sit in the story dir, and it'll link to quests, checklists, items, mobs, and whatever other categories i'd like to toss in there. Those linkes will be in subdirectories of the same name, that way I only have 1 item in the stories dir to worry about updating and I can toss the rest of the files in as I fill them in.
I'll post a link after I test it a bit to make sure it works as intended.
GnekroeGnomicon
07-26-2005, 06:39 PM
Lucy is about to be slurped in a way that would make the most faithful of Bertox's children blush.
LINK REMOVED
It will take some time, though my script will slurp all of lucy: from 0 (lowest id I found was 1001 though) to 100,000 (highest id somewhere in the 90k's). Any objections to a tab delimited file? I don't think tabs are existant in the item db, but I have no idea if commas are there... and I figured an excessively unique delimiter would make the file too large :)
Xislaben
07-26-2005, 06:48 PM
Originally posted by GnekroeGnomicon@Jul 26 2005, 06:39 PM
Lucy is about to be slurped in a way that would make the most faithful of Bertox's children blush.
Here is a sample (lucy id's 1001-1102):
Sample of Slurping (http://gemini.oscs.montana.edu/~jake/webimages/lucy.nec)
It will take some time, though my script will slurp all of lucy: from 0 (lowest id I found was 1001 though) to 100,000 (highest id somewhere in the 90k's). Any objections to a tab delimited file? I don't think tabs are existant in the item db, but I have no idea if commas are there... and I figured an excessively unique delimiter would make the file too large :)
Interesting, how you manage that? Oh you just grabbed the raw tab.
I'd rather go with coma delimited than tab delimited (less whitespace) but it parses the same.
Which field contains the data conecting it to the focus effects?
Looks liek the item's "spellid0" field through "spellid5" corresponds to the spell/proc's "id" field. Personally I keep the key names the same so you don't have to hunt and peck to figure out what is and is not a foreign key.
Now, since you can download the spell data, you have that already from lucy in a nice zip file.
GnekroeGnomicon
07-26-2005, 07:00 PM
I can do comma delimited, just wasn't sure if there were any items with commas in their names (which just causes headaches :)
Lucy is a pain to get info from but I got a script working a month or so ago to grab spell data which will eventually turn into a up-to-date spell info guide.
Will take some time for the script to run, have no idea how large the file might be, might separate them into blocks of 1,000 or 10,000.
GnekroeGnomicon
07-26-2005, 07:03 PM
Looks liek the item's "spellid0" field through "spellid5" corresponds to the spell/proc's "id" field. Personally I keep the key names the same so you don't have to hunt and peck to figure out what is and is not a foreign key.
Now, since you can download the spell data, you have that already from lucy in a nice zip file. Yup, and I will tie it all together with that.
Also, as a task in the near future, I will go through and slurp from allakhazam / zone and mob data for each item... but that will come next - and unfortunately that will take the script forever.
Nerconom
07-26-2005, 07:07 PM
Originally posted by Xislaben@Jul 26 2005, 03:57 PM
I think I'm going to look into some of those programs and see if they can be modified, or if I get really bored I may try to make a simple one in visual basic or C++.
Mmm I suspect that could be seen as as eula violation, passing data to and from eq dynamically and all :(
You could pretty easily send a command to the chat window and have a sniffer read it, and look up some item on lucy and return the data from that query in text for to either the notes or to the story line, but I doubt soe would like it.
I'd like to contribute to building something that'd pass under the radar if you know what I mean. [/quote]
The way I view the eula is that it was put into place to stop people from cheating, plain and simple. There were once programs that would exploit some things in EQ that were much more obviously a violation to the eula.
The programs that people would make that used tradeskill defects that allowed people to make money for basically free, for example, would be something that I know Sony wouldn't allow. Things like this, however, simply let people skip putting the game into window mode and look up the information on the internet. I don't view this as a cheat at all, and certainly not one that Sony would make a big fuss about or even look for.
Plus, if they did not want people to use the story window in such a way, then I would imagine they would have found a more complicated way of programming it rather than an extrememly simple HTML. I consider using these techniques no more a violation than using a different UI. I could make an arguement that certain UI's give an unfair advantage to people by allowing fast access to inventory or clickie items or combat skills when people using the default would have to go through an extra keystroke or two to access the same content.
To me, this is the same thing. All this is doing is giving me access to something that I have access to anyway, just a little faster and more convienent.
Xislaben
07-26-2005, 07:07 PM
Originally posted by GnekroeGnomicon@Jul 26 2005, 07:00 PM
I can do comma delimited, just wasn't sure if there were any items with commas in their names (which just causes headaches
Good point, I believe there are items with commas in the names, like some of the tank 2.0's.
Nightbane, Sword of the Valiant
Rijak
07-26-2005, 07:08 PM
put two gnomes together and anything is possible
http://i12.photobucket.com/albums/a222/frostburn/smil/matrix.gif
Xislaben
07-26-2005, 07:18 PM
Originally posted by Necronom+Jul 26 2005, 07:07 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>QUOTE (Necronom @ Jul 26 2005, 07:07 PM)</td></tr><tr><td id='QUOTE'> The way I view the eula is that it was put into place to stop people from cheating, plain and simple. There were once programs that would exploit some things in EQ that were much more obviously a violation to the eula.
The programs that people would make that used tradeskill defects that allowed people to make money for basically free, for example, would be something that I know Sony wouldn't allow. Things like this, however, simply let people skip putting the game into window mode and look up the information on the internet. I don't view this as a cheat at all, and certainly not one that Sony would make a big fuss about or even look for.
Plus, if they did not want people to use the story window in such a way, then I would imagine they would have found a more complicated way of programming it rather than an extrememly simple HTML. I consider using these techniques no more a violation than using a different UI. I could make an arguement that certain UI's give an unfair advantage to people by allowing fast access to inventory or clickie items or combat skills when people using the default would have to go through an extra keystroke or two to access the same content.
To me, this is the same thing. All this is doing is giving me access to something that I have access to anyway, just a little faster and more convienent. [/b]
Mmmmm your point is well taken. Though I disagree on the reasons for the simplicity of the format. I believe it's rather because the devs are likely pressed for time and thus chose to use a realtively simple and easily player manipulatable storyline (don't wanna say lazy, they may, though it's unlikely, actually read this) rather than opt for some other form of storage. Like say a single dll that contains the story data.
Here's the question, while yes you can lookup info on an encounter or the price of an item from the ave alla value (like that's near accurate anyway) or a quest or mob drops tables by tabbing over to another pc, most people won't be able to have the answer instantly appear on their screen in a storyline, so it adds something of an imbalance. Er, ok that wasn't a question.
We may not feel that's an eula violation, but it's soe's opinion that worries this gnome :)
<!--QuoteBegin-Rejak@Jul 26 2005, 07:08 PM
put two gnomes together and anything is possible
http://i12.photobucket.com/albums/a222/frostburn/smil/matrix.gif
[/quote]
:)
GnekroeGnomicon
07-26-2005, 07:44 PM
Hmm, going to take a while :)
first ~1,000 entries took a bit of time to complete (10 mins?) and it looks good - the real issue actually occurs that my script hits some server side limit of 8.8 megs of downloaded dynamic data. So it looks like items will be thrown initially into groups of 1000 which comes out to be about a little over 300kb per file...
Might have to refine how I grab the files (if possible? I can't access the db directly so I am just requesting pages and parsing out the data that is needed) from lucy though, at ~9 megs a group would mean that I will use ~850 ish megs of bandwidth - not really acceptable if you ask me so for the moment I will halt and play around with the script a bit more.
Nerconom
07-26-2005, 07:46 PM
Originally posted by Xislaben@Jul 26 2005, 07:18 PM
We may not feel that's an eula violation, but it's soe's opinion that worries this gnome :)
Good point, but soe knows that people use parcers to get exact info on DPS and such, yet they don't actively pursue people who use them, mostly for the fact that because logging is something they themselves put into the game, so there is no rule for looking over what comes out of the log and they have no way of knowing if the user has a program looking at the logs because that happens locally on the machine.
Soe also doesn't seem to be opposed to the idea of people modifying the story window to include other information, because with all the websites that have things like that easily downloadable, one would think they would make the websites take that down if it violated any part of the EULA (I say this because I do recall soe going after a few websites that had programs for download that were geared toward EQ exploits and such a few years ago).
So is it now different if I were to manually edit the storyline files?
Basically, I don't think it's even possible to get "caught" using this theoretical program because the only game files being modified are the storyline files, which doesn't seem to be a problem to soe so far.
So if I were to make an incredibly long series of txt files and make a master link file that shows up in the storyline window (which is basically how the EQtraders mod worked), I highly doubt that would be breaking any rules, and very well might be the route I go.
I just think that it would be one of those things that Sony wouldn't bother going after just to ban people from playing. The people with two computers set up side-by-side are doing to same basic thing, just from two computers. The only advantage to me from using this theoretical program would be a little bit of time saved, around the same amount of time saved that others with a better computer set up already save. So do people like that already have a significant advantage? Not really, just a few less headaches :lol:
I also wouldn't use a packet sniffer on anything, that would definately raise questions. Packets contain quite a bit more information than simple text commands, and if you are trying to figure out what is in those packets then soe may get the impression that you are trying to change those packets, which would be VERY MUCH against the eula, because that is cheating. Not worth getting banned from the game.
Nerconom
07-26-2005, 07:49 PM
Originally posted by GnekroeGnomicon@Jul 26 2005, 07:44 PM
Might have to refine how I grab the files (if possible? I can't access the db directly so I am just requesting pages and parsing out the data that is needed) from lucy though, at ~9 megs a group would mean that I will use ~850 ish megs of bandwidth - not really acceptable if you ask me so for the moment I will halt and play around with the script a bit more.
Doesn't lucy have a downloadable item database? I just downloaded a fairly long txt file from a link earlier in this thread, is that one just not complete?
Xislaben
07-26-2005, 07:53 PM
Originally posted by Necronom+Jul 26 2005, 07:49 PM--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>QUOTE (Necronom @ Jul 26 2005, 07:49 PM)</td></tr><tr><td id='QUOTE'> <!--QuoteBegin-GnekroeGnomicon@Jul 26 2005, 07:44 PM
Might have to refine how I grab the files (if possible? I can't access the db directly so I am just requesting pages and parsing out the data that is needed) from lucy though, at ~9 megs a group would mean that I will use ~850 ish megs of bandwidth - not really acceptable if you ask me so for the moment I will halt and play around with the script a bit more.
Doesn't lucy have a downloadable item database? I just downloaded a fairly long txt file from a link earlier in this thread, is that one just not complete? [/b][/quote]
It's a db with just item names and lucy links to them.
For an item DB you can look at the eqemulator sql downloads. The first one is 100 megs (8mb compressed) and then again the second is 200+ megs (9mb compressed) in a previous post. Now sure how many items are actually in it though, looks like only about 30k for the initial one.
GnekroeGnomicon
07-26-2005, 07:55 PM
Doesn't lucy have a downloadable item database? I just downloaded a fairly long txt file from a link earlier in this thread, is that one just not complete? The link from Lucy above looks to be complete, but it doesn't have any information beyond teh id, name and lucy link. Which is actually pretty odd (redundant data), since the lucy link is the same url with the item id as a parameter.
The other db's that were listed appear to be semi-collections, though the largest that I saw only compiles ~46,000 items, which is only about half of the actual items in game.
GnekroeGnomicon
07-26-2005, 09:07 PM
Update:
LINK REMOVED
* I already realize there will need to be a change to this database, as it doesn't include the lucy id. But items that haven't been assigned an allakhazam link have a shared id of '0'. This complicates things in updating the items in the future. I will revise the items starting tomorrow. *
After playing around with the lucy database some more I don't believe I can reduce the bandwidth required to download each page. So I will be building upon the database daily over the next week or so - so I don't put unnecessary stress on their resources.
After completing the db, I will put combine it with spell effects so that we will have all of the procs/focus effects combined with the item db, and then I will start mining allakhazam for mob/zone drop info.
This will take some time, so I hope everyone is patient and I think we can come up with a pretty cool tool.
I will keep daily (mostly) logs of new and updated items as well so the final db mine will combine all the new/updated items and then a chron will take over to continue the work from then on. I will see who is interested in the db and I will make it available to them on a regular basis.
Fayed
07-26-2005, 10:56 PM
Just thought I'd let you in on a little bit of information, you can directly query the Lucy DB. I don't know how its done, just that it can be done. Foofys Spell Lists (http://eqinterface.com/downloads/fileinfo.php?id=2171) does this. It also lists every spell in the game, or at those on lucy.
And story windows DO NOT break EULA. they are not a 3rd party program. and im not 100% sure but i believe SOE ahs stated that they do not consder SW to violate EULA
**EDIT**
Was reading up on it, Foofy gets the DL version of Lucy DB. dunno if that help.
Xislaben
07-27-2005, 05:34 AM
Here's an example storyline mod with 1 main file, and lots of sub files.
Checklists, Quests, Items, Mobs, Spells, Focii...
Xis' Storyline (http://rapidshare.de/files/3391026/XisStoryline.zip.html)
The demilich skullcap quest is not orriginal of course.
Dump the contents of the zip file into:
C:\Program Files\Sony\EverQuest\storyline\
Then reboot. It's all text files.
Hit Alt-N and it shows up as "Master List -----------"
GnekroeGnomicon
07-27-2005, 02:10 PM
Was reading up on it, Foofy gets the DL version of Lucy DB. dunno if that help. That will definitely be used in the long run and maybe for different story window mods. The DL version of the item database only includes the lucy id and item name so for anything but linking directly back to Lucy it doesn't help much.
If there is a way to directly query Lucy I am all ears as I haven't seen anything like it. I have the feeling that there would be others who would directly use Lucy for queries by item properties (rather than go through Alla's clunky slow interface (maybe premium is faster?)) if public accecss to the db was given.
Xis' Storyline Sweet! I will give this a try tonight!
Nerconom
07-27-2005, 02:31 PM
Nice! My mod made it into that collection... that's quite a compliment actually :D
And I'm eagerally anticipating that db, thank you for all the hard work guys, we may have something quite exceptional out of all this... glad I can be part of it B)
Xislaben
07-27-2005, 03:33 PM
Originally posted by GnekroeGnomicon@Jul 27 2005, 02:10 PM
Was reading up on it, Foofy gets the DL version of Lucy DB. dunno if that help. That will definitely be used in the long run and maybe for different story window mods. The DL version of the item database only includes the lucy id and item name so for anything but linking directly back to Lucy it doesn't help much.
I tried foofy. It's more than just spell name and lucy id, it's got all the spell data in it. Very cool. Huge ass file and tons of little files in it.
They must have the db either from lucy (which I would prefer) or from slurping (whish will work as well but takes longer) and just generate the subfiles from it programatically.
GnekroeGnomicon
07-27-2005, 04:50 PM
I tried foofy. It's more than just spell name and lucy id, it's got all the spell data in it. Very cool. Huge ass file and tons of little files in it.You are right I was more referring to the downloads that Lucy offers on thier site.
They must have the db either from lucy (which I would prefer) or from slurping (whish will work as well but takes longer) and just generate the subfiles from it programatically. There is a quote that says they are querying Lucy directly, I will look more into it.
The only information that foofy looks like it has (admittedly not using it) is in game descriptions - those could be done by hand or slurping - otherwise it looks like it is using every from the Downloaded Spell db.
GnekroeGnomicon
07-28-2005, 02:19 PM
Update:
LINK REMOVED
Items 0-6000 were redone to grab their lucy id. There appears to be some issue with id's in the 3600-3900 range but haven't had a chance to see where the data issue is coming from (ie. they all of a sudden jump to 2600-2900 and then return back to what they should be).
Nerconom
07-28-2005, 02:28 PM
coming along quite nicely, anyone have any idea roughly how many items are there total?
GnekroeGnomicon
07-28-2005, 02:45 PM
coming along quite nicely, anyone have any idea roughly how many items are there total? There are roughly 90k+ id's and it is averaging ~800 item's per 1000 ids so if that trend continues, ~72-75k items.
GnekroeGnomicon
07-29-2005, 10:59 PM
Update:
Current Db (http://gemini.oscs.montana.edu/~jake/webimages/lucydb.txt)
~16000 items (ids 0-20000) - 4.7 mb
Items 3001-3976 were redone to fix the (dunno what was the cause) corrupt data in those fields previously.
Nerconom
08-01-2005, 04:32 PM
Thanks GnekroeGnomicon for all the hard work, can't wait to make use of it:)
Xislaben
08-01-2005, 07:43 PM
More stuff, including some mpg raid trials and vp keys:
Mostly alla text, with a few posts that looked like they had good content. More mob locaitons need to be added.
http://rapidshare.de/files/3551239/Storyline.zip.html
GnekroeGnomicon
08-04-2005, 02:47 PM
Just an update for you all, I am transferring my domain (finally getting my site back up instead of using my work share) so my data skimming efforts are at a stand still for a day or two... will be back up probably by the weekend.
Nerconom
08-11-2005, 09:25 PM
Not to lean on you gnekroe, but has there been any more progress with this database? Just curious to see how this pans out. :D
GnekroeGnomicon
08-11-2005, 09:26 PM
Sorry been beusy this week, tomorrow I should have another update though as things slow down again.
Sorry for the wait!
GnekroeGnomicon
08-12-2005, 06:54 PM
Big Update:
items 0-50000, ~28,000 actual items
Item DB (http://necro.scrypts.com/lucydb.txt) - 9 MB
I am removing links to the older db.
Nerconom
08-12-2005, 07:19 PM
oh don't be sorry, you have been doing an excellent job so far. Just looking foward to putting it to good use:)
daephyx
08-13-2005, 12:04 AM
EQ Interface has a collection of dowloadable Storyline Mods, including a pretty nice one for BiC quest.
Xislaben
08-16-2005, 03:18 PM
Hey I found a bunch more storyline mods to include:
http://www.meryddian.net/storywindow.html
vBulletin® v3.8.3, Copyright ©2000-2012, Jelsoft Enterprises Ltd.