Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-27-2012, 11:14 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default Live Data Collection (Need Community Help)

I'm going to make this short and sweet.

We have made huge ground parsing Magelo's site for large amounts of data to catch up PEQ all the way through the current expansion. I spent time to write a web crawler that has gathered all of the following data types from all expansions to now:
  • Merchantlists
  • Loot
  • Tradeskills
  • Spawnpoints

I will be working on getting these in one by one, my life has been super busy and it has been hard to make time for things but I'm still trying to get these things knocked out because they are rather large. I also am not rushing because Cavedude is in the middle of moving, I am probably going to end up moving here shortly myself.

Asking the Community for Help:
Anyways, I need help from the community to collect logs from live. These are the logs that are generated from /log in-game from any and all time frames that have ever been played.

What will this enable us to do?
We will be able to collect quite a wide variety of data that just simply can't be automated through web sources. This will allow us to collect:
  • NPC Relative Health
  • NPC Spell Casts
  • NPC Faction hits
  • NPC Damage Data
  • NPC Aggro Emotes
  • NPC Death Emotes
  • Other things I'm not thinking of right now

If we can get log data from PEQ's more recent expansions (GoD, LDON) all the way through the current expansion the more we will be able to fill in the gaps of all of the data that gets manually processed through the development procedures and standards that PEQ has put in place today.

My effort is going to be to take logs from players anonymously through a form and have a script go through and tear through the data existing through those logs. These logs will be kept privately and will only be used for the benefit of this community and will only be seen by trusted developers.

The UPLOAD form can be found here: http://eoc.akkadius.com/eoc/EQEmuDat...gCollector.php

Simply upload a eqlog file of your EverQuest live characters and once the data parsing process begins, I will try to make a way to have people see what NPC's have been collected in what zones and what hasn't collected so we can take an accurate hitlist against what we need to collect as a community.

This will take a while as we get people to dump their historic logs from the past, I encourage everyone to reach out to anyone they might know to help this process move along so we can get more data.

How/What:
  • Typing /log in game in eqemu will create a logfile under EverQuest/Logs/eqlog_charname_servername.txt
  • We will need preferably HUGE logs that contain data spanning several zones, old and big logs are completely fine
  • The more combat spam the better, I don't care about /gu or /t messages, I won't be caring about any of that


If anyone has any questions about this please feel free to post.

Last edited by Akkadius; 09-30-2012 at 12:07 PM..
Reply With Quote
  #2  
Old 09-28-2012, 02:43 AM
namini
Fire Beetle
 
Join Date: Jul 2012
Posts: 15
Default

Oh boy. Logs, if I can find the old hard drives that I used to play and guide on, shoot. We're talking a crazy amount. But, yeah.

Short and sweet answer, you need logs, from what expansion to which expansion?
Reply With Quote
  #3  
Old 09-28-2012, 04:31 AM
Noport
Opcode Ninja
 
Join Date: Mar 2009
Location: San francisco
Posts: 426
Default

what format would you like to receive them in ? what is the max size allowed ? are you talking about the log files an or are you asking for pcap files ? i have several live logs i started in 2003-present
Reply With Quote
  #4  
Old 09-28-2012, 09:38 AM
sorvani
Dragon
 
Join Date: May 2010
Posts: 965
Default

we are talking about standard log files created by the /log on command.

any and all logs are helpful, but mostly from GoD+ as everything else is already "completed" more or less. Akka will have to respond to file size restrictions if any.
Reply With Quote
  #5  
Old 09-28-2012, 09:49 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

The default format in which they are generated in is required:

eqlog_charname_server.txt

I don't have any size restrictions, just load em up!

And yes all expansions GoD to now log data should be uploaded. Can use any and all, this needs to be a big community effort.

Last edited by Akkadius; 09-28-2012 at 10:28 AM..
Reply With Quote
  #6  
Old 09-28-2012, 03:43 PM
jdoran
Hill Giant
 
Join Date: Jul 2012
Posts: 212
Default

Would you like us to trim the logs to just those expansions, or can your parser sort it out. I have logs going back years.
Reply With Quote
  #7  
Old 09-28-2012, 03:51 PM
demonstar55
Demi-God
 
Join Date: Apr 2008
Location: MA
Posts: 1,164
Default

Quote:
Originally Posted by jdoran View Post
Would you like us to trim the logs to just those expansions, or can your parser sort it out. I have logs going back years.
Well, they did mention wanting to parse NPC Aggro/Death emotes and I know we are missing a lot of them from pretty much every expansion ... But stuff that isn't on PEQ yet would probably still be more useful.
Reply With Quote
  #8  
Old 09-28-2012, 04:18 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by jdoran View Post
Would you like us to trim the logs to just those expansions, or can your parser sort it out. I have logs going back years.
Anything and everything, my parser will be able to differentiate the data.
Reply With Quote
  #9  
Old 09-29-2012, 04:56 PM
boweq
Hill Giant
 
Join Date: Oct 2011
Posts: 130
Default

where would i send them to akka?
, also anything on live that you need really bad?

still got active acounts ( 95sk/95ranger/95sham/95bard/90 rougue)
Reply With Quote
  #10  
Old 09-30-2012, 09:38 AM
Noport
Opcode Ninja
 
Join Date: Mar 2009
Location: San francisco
Posts: 426
Default

Quote:
Originally Posted by sorvani View Post
we are talking about standard log files created by the /log on command.
ok i'll send you a log of our guild chat i did type /log on in guild chat
Reply With Quote
  #11  
Old 10-01-2012, 11:43 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Thanks for those who have uploaded logs, but so far this is looking pretty pathetic.

We really need to get a real density of logs before any parsing systems can really be developed around this.

If you know someone with a mother load of logs spanning lots of content please contact them and see if they are willing to contribute to this.
Reply With Quote
  #12  
Old 09-30-2012, 12:18 AM
Burningsoul
Banned
 
Join Date: Oct 2009
Posts: 312
Default

Bowmaster's a pretty simple being... He's like an orc - point him in the direction you want him to smash, and let him have at it. With your team are you capable of HoT & VoA content Bow? That'd be the place to hit if you're capable. Hell I'd LOVE to see crystallos fully working, just to finally play through it rather than read about it.
Reply With Quote
  #13  
Old 09-30-2012, 03:39 AM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 654
Default

Hey Akkadius your website rejected the log I attempted to upload tonight. It said it was not a log file but it is a legit log file. I tried to upload the file a second time thinking maybe it was just a fluke but it rejected it again. Any ideas?
Reply With Quote
  #14  
Old 09-30-2012, 11:24 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by blackdragonsdg View Post
Hey Akkadius your website rejected the log I attempted to upload tonight. It said it was not a log file but it is a legit log file. I tried to upload the file a second time thinking maybe it was just a fluke but it rejected it again. Any ideas?
It's going to look for the eqlog in the name as well as .txt
Reply With Quote
  #15  
Old 10-01-2012, 02:53 AM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 654
Default

Quote:
Originally Posted by Akkadius View Post
It's going to look for the eqlog in the name as well as .txt
Well it wasn't the name that caused the problem. Just a guess but I think 100% packet loss around hop 22 may have had something to do with my upload not working.
Reply With Quote
Reply


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

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

Forum Jump

   

All times are GMT -4. The time now is 08:05 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3