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 10-01-2012, 02:40 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Quote:
Originally Posted by blackdragonsdg View Post
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.
Try it again, I changed some max upload size settings on the webserver end.

How large was the file that you were trying to upload?
Reply With Quote
  #2  
Old 10-02-2012, 10:29 PM
pfyon's Avatar
pfyon
Discordant
 
Join Date: Mar 2009
Location: Ottawa
Posts: 495
Default

Haha I was just thinking about this a couple of weeks ago. Glad someone got around to writing a parser before me

I found 80 from a variety of characters + another 26 that I renamed as part of archiving back from 2002.
Reply With Quote
  #3  
Old 10-02-2012, 10:45 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Quote:
Originally Posted by pfyon View Post
Haha I was just thinking about this a couple of weeks ago. Glad someone got around to writing a parser before me

I found 80 from a variety of characters + another 26 that I renamed as part of archiving back from 2002.
Oh wow, logs from 03/04. Now we're talking progress.

Once again if I can encourage anyone and everyone to try and get them to upload historic character log files this helps the project quite a bit.

If anyone has questions please let me know.

Thanks,
Akkadius
Reply With Quote
  #4  
Old 10-02-2012, 10:50 PM
demonstar55
Demi-God
 
Join Date: Apr 2008
Location: MA
Posts: 1,164
Default

Have you thought about posting this on like the EQ sub-reddit? I'm sure there would be people at least interested in submitting some and there is a larger chance they have logs.
Reply With Quote
  #5  
Old 10-02-2012, 11:35 PM
pfyon's Avatar
pfyon
Discordant
 
Join Date: Mar 2009
Location: Ottawa
Posts: 495
Default

Any chance you can release some aggregated data once you're done with this project? I'd like to see how older mobs compare (hp/damage wise) to what we have in the peq DB.
Reply With Quote
  #6  
Old 10-03-2012, 12:15 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Quote:
Originally Posted by pfyon View Post
Any chance you can release some aggregated data once you're done with this project? I'd like to see how older mobs compare (hp/damage wise) to what we have in the peq DB.
Yeah I definitely will, I just need to collect a decent amount of logs before I start putting together the parser.

In the middle of working on some other rather large PEQ parsing projects to get loot, merchantlist, tradeskills from all expansions.

In the meantime I just need to start building the private repository so I have something to work with when the script is being created to parse through all of the text files.

After that I plan on having a web page that people can go to and see a hitlist of what has been collected and what hasn't
Reply With Quote
  #7  
Old 10-03-2012, 12:18 PM
Maze_EQ
Demi-God
 
Join Date: Mar 2012
Posts: 1,103
Default

Question....Is test server data useful? I've got access to a multitude of accounts that can basically box everything up to VoA stuff.
__________________
"No, thanks, man. I don't want you fucking up my life, too."

Skype:
Comerian1
Reply With Quote
  #8  
Old 10-03-2012, 09:37 PM
pfyon's Avatar
pfyon
Discordant
 
Join Date: Mar 2009
Location: Ottawa
Posts: 495
Default

Finished my first 80 using the web interface, found another 46 (in addition to the archived ones).

After sitting in front of my computer for an hour doing those, I decided I'd script it. If you have a linux box and lots of logs, try the following script:
Code:
 for x in eqlog*.txt; do echo "Starting $x"; curl -F FileName=@$x -F EQEmuForumName=CHANGEME http://eoc.akkadius.com/eoc/EQEmuDataCollect/LogCollector.php &> /dev/null; done
Change or remove the '-F EQEmuForumName=CHANGEME' to your forum name if you want it to be included.
Reply With Quote
  #9  
Old 10-03-2012, 10:08 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

That's quite the collection you have there and that definitely will help.

I've updated the form to include how many logs we've collected so far and the size:

http://eoc.akkadius.com/eoc/EQEmuDat...gCollector.php
Reply With Quote
  #10  
Old 10-03-2012, 11:39 PM
pfyon's Avatar
pfyon
Discordant
 
Join Date: Mar 2009
Location: Ottawa
Posts: 495
Default

How are you storing the logs? Are you using the original filename? I have multiple logs which share the same filename (I would copy them elsewhere and/or rename them to make parsing of more recent stuff easier) which, if you keep them as the same filename, could get overwritten.
Reply With Quote
  #11  
Old 10-03-2012, 11:55 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Quote:
Originally Posted by pfyon View Post
How are you storing the logs? Are you using the original filename? I have multiple logs which share the same filename (I would copy them elsewhere and/or rename them to make parsing of more recent stuff easier) which, if you keep them as the same filename, could get overwritten.
No, I thought that through beforehand. They never get saved as the original filename.
Reply With Quote
  #12  
Old 10-06-2012, 05:47 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Update:

We have tons of 2002-2005 logs now, we need a high density of 2004-2012 logs now.

Need your help!

UPLOAD HERE:

http://eoc.akkadius.com/eoc/EQEmuDat...gCollector.php
Reply With Quote
  #13  
Old 10-07-2012, 11:20 PM
Warking
Hill Giant
 
Join Date: Mar 2012
Location: Norrath
Posts: 132
Default

I have all my EQ files since I started in 99. I'll start looking through them
Reply With Quote
  #14  
Old 10-19-2012, 05:07 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

I've not seen anything uploaded recently, the community needs more help with this than we are getting. People have no idea how much this is going to help the community.
Reply With Quote
  #15  
Old 10-19-2012, 06:17 PM
Caryatis
Dragon
 
Join Date: May 2009
Location: Milky Way
Posts: 539
Default

Quote:
this is going to help the community.
You need to re-frame this to what the individual is going to get out of it. Give out some worthless points or some shit and work out a deal with some of the big servers to redeem them for trinkets, then you will be overwhelmed with logs.
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 12:42 PM.


 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3