EQ2 Forum Archive @ EQ2Wire

 

Go Back   EQ2 Forum Archive @ EQ2Wire > EverQuest II > The Norrathian Herald > Community News
Members List Search Mark Forums Read

Notices

Reply
 
Thread Tools
Old 11-16-2006, 12:36 AM   #1
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Sign up for a free account!
The functionality is in beta, the administrative tools and websites still need more work.
 
 
EQ2-Compendium is now in open BETA!
 
1. What is it?
 
EQ2-Compendium is a compilation of data contained in all users log files. Namely Loot/Kill/Vendor/Broker/Harvest Data.
 
2. Why is that useful?
 
All Mobs have a specific loot table assigned to it that upon that monsters death, a random roll is performed and depending on the result an item from that table is dropped for the player to pick up. We record that information and compile it over all servers to reassemble the monsters loot table.
 
3. Again why is reassembling the mobs loot table important?
 
Because instead of killing random mobs in hopes of finding an item that is useful for your character, you can target the SPECIFIC mob that has a chance to drop the items you want!
 
4. What kind of items does this apply to?
 
All kinds! Vendor trash, Legendary, Fabled, Mythical, Spells (including Master Spell Drops!). Anything that the mob has a chance to drop will eventually be a part of our database!
 
5. I am still not seeing how this would be useful, could you please elaborate?
 
It takes the guesswork out of hunting for new equipment. Sure you can spend a fortune of plat to buy that superuber ring off the broker, or using EQ2-Compendium you can see what mob or mobs drop that ring, and go killem yourself! Outfitting a character used to take weeks, months or a fortune of platinum but with EQ2-Compendium it will help you trim that time/cost significantly.
 
6. Is this even legal?
 
Yes! We collect absolutely nothing that is either personally identifiable or breaks the EULA (End User License Agreement) in any way shape or form. In fact if you had the time to go through your own log files, and the logs of countless other users you could find the information you need. We just offer an automated way compile and access this data.
 
7. How often is the information updated, Every night? Every week?
 
Better! Within 30 seconds of an EQ2-Compendium user killing any mob on any server the information is recorded into the database, becoming instantly available to ALL users worldwide! If that mob drops something off its corpse or in a chest, that information is available as well!
 
8. How Exact is the data?
 
Sadly our data can never be 100% accurate, the way the information is logged makes it nearly impossible to maintain 100% accuracy so you will see some data anomalies. But we at EQ2-Compendium search out those anomalies and fix them to keep our data is as accurate as possible.
 
9. Okay so I've signed up, now what?
 
You download and install the software, Login using the user name and password you created. After which it will automagically seek out your log files for Everquest 2 and begin parsing them. A second window will pop and allow you to search by mob or item, and you are on your way!
 
10. Do I need to check for updates?
 
No! Every time you start the application it will call home and check for updates and prompt you to install them, you will always be on the latest and greatest version of the software.
 
11. I've used other software that needs me to download the update database for new data, will I have to do that with EQ2-Compendium?
 
Not even once! Every search you perform hits our production data so if user JoeSchmo on Nagafen finally downed the superhardraidmob 60 seconds ago, you will be able to see what he dropped!
 
12. That sounds pretty neat, do you have anything planned for the future?
 
Absolutely, through our automatic updates we will push out updates on a regular basis, if there's something you would like to see drop it in the comment box and we will defiantly look into it! After all this is software for YOU! Currently we have slated more improvements in statistical calculations and a more exact MobZone Discovery technique.
 
13. There's an expansion coming out soon / recently released will you have Item/Mob data from that?
 
Yes! Within a minute of an EQ2-Compendium user killing/harvesting/picking up anything, we will have the info!
 
14. How many mobs/items/kills are in your database?
 
The real time stats are posted on the bottom of the page at www.eq2-compendium.com, go ahead and take a peek!
  
www.eq2-compendium.com : The Smart way to play!
 

Message Edited by RoMaJoHo on 11-17-2006 08:53 AM

__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-16-2006, 01:11 AM   #2
Cyanbane

Guildm8s.com
Cyanbane's Avatar
 
Join Date: Nov 2004
Location: Atlanta, Ga.
Posts: 260
Default

This sounds like a cool idea.  Not sure if I am keen on paying $2.50 a month for it though.    Couldnt you just allow everyone who lets you parse their logs see the data for free?  It sounds like there is a direct inverse relationship between the requirement  of  the number of paying users and the amount of useful information you will recieve from their logs.  Why not drop one variable to push up the other?Regardless, Good luck with it.edit spelling

Message Edited by Cyanbane on 11-15-2006 12:12 PM

__________________
Come discuss EQ2 at GuildM8s (formerly EQ2-Daily)!
Cyanbane is offline   Reply With Quote
Old 11-16-2006, 01:13 AM   #3
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

as i'm more of a technical person rather than a business one...i'm opening beta to all for free...then we'll see what happens from there. (beta is expected to run till january)
 
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-16-2006, 01:16 AM   #4
Cyanbane

Guildm8s.com
Cyanbane's Avatar
 
Join Date: Nov 2004
Location: Atlanta, Ga.
Posts: 260
Default

Cool I just saw the pricing on the site and was wondering.  Hopefully you  can keep it free post beta.
__________________
Come discuss EQ2 at GuildM8s (formerly EQ2-Daily)!
Cyanbane is offline   Reply With Quote
Old 11-16-2006, 03:31 PM   #5
Kemendur

Loremaster
 
Join Date: Nov 2005
Posts: 6
Default

Hi i want to try your program but whe i install EQFA occur a problem it says" the application missin required files"..before i've launched the exe

Message Edited by Kemendur on 11-16-2006 02:32 AM

Kemendur is offline   Reply With Quote
Old 11-16-2006, 06:02 PM   #6
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Interesting, I will work with you on the issue.
 
Anyone can email [email protected] with any issues while i get the website issue reporting up and running.
 
Thank ya'll for the help!
 
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-16-2006, 07:32 PM   #7
Iyemana

Loremaster
Iyemana's Avatar
 
Join Date: Mar 2006
Posts: 39
Default


Kemendur wrote:
Hi i want to try your program but whe i install EQFA occur a problem it says" the application missin required files"..before i've launched the exe

Message Edited by Kemendur on 11-16-2006 02:32 AM


Same for me and i have all the prerequirements.
Iyemana is offline   Reply With Quote
Old 11-16-2006, 08:19 PM   #8
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

SMILEY Gotta love throwing something out there and having it blow up SMILEY

 

Everyone having issues, either post here or email [email protected] with what OS your using and browser? i'm hearing reports that the publishing method of .net 2.0 isn't functional in firefox/mozilla.

Thank ya'll for the help/feedback

__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-16-2006, 08:34 PM   #9
Iyemana

Loremaster
Iyemana's Avatar
 
Join Date: Mar 2006
Posts: 39
Default

I use FIrefox by default and upon inspection saw you wre using a Microsoft one click thingy so i went back to try it in IE and now it appears the site is down SMILEY

Server Error in '/' Application.
Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.Source Error:An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
[InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.] System.Data.ProviderBase.DbConnectionFactory.GetCo  nnection(DbConnection owningConnection) +1184377 System.Data.ProviderBase.DbConnectionClosed.OpenCo  nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 EQ2Comp.Page_Load(Object sender, EventArgs e) +45 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Iyemana is offline   Reply With Quote
Old 11-16-2006, 08:44 PM   #10
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Site is Back-up, For firefox users i'm planning another method to download & install. I'm assuming you can use an MSI installer.

 

Thank you for your help.

Message Edited by RoMaJoHo on 11-16-2006 07:44 AM

__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-16-2006, 08:46 PM   #11
Iyemana

Loremaster
Iyemana's Avatar
 
Join Date: Mar 2006
Posts: 39
Default

Yes currently it needs IE to download SMILEYCant wait to try this out at home tonight.
Iyemana is offline   Reply With Quote
Old 11-16-2006, 08:50 PM   #12
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Hehe, honestly after how many tiers, encryption, scrubbing and misc transformation the data goes thru...i was shocked it worked at all...when i came up with this 2 weeks ago i thought there was no way it'd work. I can't describe how excited when i picked up my first tester, had them kill something and see it reflected in the DB within 20 seconds. I hope you enjoy.
 
Bear in mind the way Zones are logged is very hit or miss...so the zone info on mobs is quite often off...i'm thinking thru a fix for that now.
 
Any suggestions or what you'd like to see...or bug reports...would help immensely.
 
 
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-16-2006, 08:54 PM   #13
Iyemana

Loremaster
Iyemana's Avatar
 
Join Date: Mar 2006
Posts: 39
Default

is there a way to manually set the eq2 directory?  I dont see where i can browse through my network to my gaming rig.I run all my parsers and voice programs on another PC to reduce the lag on my processor SMILEY  and would like to do the same with this.
Iyemana is offline   Reply With Quote
Old 11-16-2006, 08:58 PM   #14
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

After it tried to automagically discover the eq2 directory, and it will fail if your setting it up on a second computer (if you don't have eq installed there), Which  I did for the normal people that have no idea where/what they need to do to set up, it will prompt you for your eq2 location. Select a file in that directory and it should (i hope) run without a hitch, admittadly this is a use case i have not considered.
 
The architecture of the application should allow it however.
 
let me know, i have a long night of work on this ahead of me....all you darn firefox users SMILEY
 
 
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-16-2006, 09:13 PM   #15
Iyemana

Loremaster
Iyemana's Avatar
 
Join Date: Mar 2006
Posts: 39
Default

yeah it did popup....is it normal for it to take around 5 minutes to time out and prompt?
Iyemana is offline   Reply With Quote
Old 11-16-2006, 09:19 PM   #16
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Good point, it defaults to searching the puter for your eq2.exe...i should offer the ability for either automatic or manual upfront.

 

Good call.

__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-16-2006, 10:47 PM   #17
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Firefox Fix should be coming tonight, i will notify users here and by email.
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-16-2006, 11:07 PM   #18
DeathRider69

Loremaster
DeathRider69's Avatar
 
Join Date: Nov 2005
Posts: 105
Default

Got this with IE after install.Server Error in '/' Application.
Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.Source Error:An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
[InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.] System.Data.ProviderBase.DbConnectionFactory.GetCo  nnection(DbConnection owningConnection) +1184377 System.Data.ProviderBase.DbConnectionClosed.OpenCo  nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 EQ2Comp.Page_Load(Object sender, EventArgs e) +45 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Control.LoadRecursive() +131 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
__________________
DeathRider69 is offline   Reply With Quote
Old 11-16-2006, 11:10 PM   #19
DeathRider69

Loremaster
DeathRider69's Avatar
 
Join Date: Nov 2005
Posts: 105
Default

Looks like you slashdotted yourself SMILEY  Doesn't look like your server can handle the thousands of connections you will be getting.
__________________
DeathRider69 is offline   Reply With Quote
Old 11-16-2006, 11:12 PM   #20
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Aparently i forgot to close a DB connection on the website, with 10x's more people hitting it now...it's running out of pooled connections. This is also on my list for tonight.

 

 

Man i suck SMILEY

__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-16-2006, 11:14 PM   #21
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

haha you scared me about the slashdot thing, i was like "oh God i didn't put anything there, and this is in no way ready to handle that load!"
 
Aparently there is alot of interest here, so that's good...and thank you all for trying this out and helping me improve it.
 
ya'll rock!
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-17-2006, 02:11 AM   #22
FlamFlam

Loremaster
 
Join Date: Jul 2005
Posts: 6
Default

Awesome prog you have here! Definitely gonna use this alot :smileyhappy:
FlamFlam is offline   Reply With Quote
Old 11-17-2006, 10:56 AM   #23
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Firefox download is up as a full MSI download, i will think through a better way to version and auto update it.i tested this with the only machine i could, so i hope it works for general consumption.all the users having trouble downloading and installing it should now be able to. the installer is very rough (they sure didn't make it easy). a better version will be out tommorrow.Keep bumping this thread and tell all your friends!
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-17-2006, 08:45 PM   #24
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Anyone still having issues
 
signing up for the free account,
 
Downloading the program (IE or firefox)
 
Logging in and running it
 
Please post here.
 
 
 
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-17-2006, 08:46 PM   #25
Feldan

 
Join Date: Feb 2006
Posts: 1
Default

Not a bad idea, however for the firefox peoples, as far as both my machines go, it cannot find the loggon pageThis is as of 10:45 EST, 17NOV06if I find out it has been fixed i'll edit as fast as I can.Thank you for all your hard work
Feldan is offline   Reply With Quote
Old 11-17-2006, 08:49 PM   #26
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

the login is in the application, download the installer using the download link, and after execution (EQFA.exe) the logon will pop.
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-17-2006, 09:14 PM   #27
Danelin

Loremaster
Danelin's Avatar
 
Join Date: Mar 2005
Posts: 114
Default

likewise unable to install the IE version (running IE7) tried the firefox version but login page won't load properly.
__________________
Kairn Pixiebane
69 Druid 400+ AA Bristlebane - Pre Sundering
80/200/80 Necro/Sage Antonia Bayle - Post Sundering

Stormblossom Petalflurry 80/200/80 Inquisitor/Alchemist

Reorjak Blot 80/200/80

Berserker/Armorer
Danelin is offline   Reply With Quote
Old 11-17-2006, 09:21 PM   #28
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Direct Link to installer, I will have to make this less confusing SMILEY sorry everyone!
 
This should work for any browser...as it's just a file link.
 
Download
Install it
Find where you installed it...create shortcuts if you want (a more automated process coming tonight)
execute it...logon form will appear.
 
 
thank ya'll for the help.
 
you are wonderful!
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Old 11-18-2006, 01:36 AM   #29
RoMaJo

 
Join Date: Nov 2004
Posts: 35
Default

Version 1.0.68       Firefox installer available http://www.eq2-compendium.com/wid/EQ2FASetup.msi       Added Choice for auto or manual log file set       Firefox users will be informed of updates at login       Automatic versioning       Forgot password available through the application       Improvements to the installer       Minor UI improvements
__________________
Free open Beta Accounts
Mob Loot Tables.
Item Drop Rates.
www.eq2-compendium.com
RoMaJo is offline   Reply With Quote
Reply

Thread Tools

Forum Jump


All times are GMT. The time now is 12:51 AM.

vBulletin skin by: CompleteGFX.com
Powered by vBulletin® Version 3.7.5
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
All threads and posts originally from the EQ2 and Station forums operated by Sony Online Entertainment. Their use is by express written permission.