Old f4g posts for UO guilds on europa

MMoudry · 5th July 2009, 07:51 AM

Hello All,

Few years ago the f4g site crashed and all data was lost. There was plethora of stories and reports written there. I've tried to recover the data from google cache and recovered about 1.5GB of data. However I have never gotten around to sorting it and doing anything meaningful with it.

The archive still sitting on my hard drive. It's around 1.5 GB and while doing cleaning I would like to get rid of it. If you know someone who might be interested in recovering it I would gladly burn a DVD and send it to them by regular mail in any format they would prefer (ie. XML). I will make a similar offer to several people I know from the community. If I don't hear from anyone 3 weeks from now I shall delete it.

The recovery algorithm was preicise, doing heuristic search of various threads and thread pages over google based on member names. I am confident that 95% of content was recovered. So far it is inside a MySQL database, I can convert it to any format for your convinience.

Thanks,

Murad

**Corvak** · 5th July 2009, 08:01 AM

did you try archive.org? Sometimes they have old web pages stored.

Tabbitha · 5th July 2009, 08:07 AM

I answered you on Skype Murad.I just need Adams advice on what will be the best format to get it in.

I know the player of Seriya de Lacey was desperate to get it way back when I asked you if you could retrieve any of it.She kept asking me if you had passed it on, so she will be very happy.

I am sure Adam will reply here and once he has I will send you an adress for the disc to go to .

Many thanks

**Adam** · 5th July 2009, 08:10 AM

Heh wow, that's awesome.
Wonder if it'd be possible to import it into a forum.

Tabbitha · 5th July 2009, 08:13 AM

That would be the ultimate ending for it all to be put on,as there are SO Many rp stories and the history of Erpa and Core.

What would be the best format to have it burned to a disc ?

*drags Murad off Skype to speak to Adam *

**Adam** · 5th July 2009, 08:15 AM

SQL would be fine, I'd certainly try me best to import it, but if it's a manual process, I'd need help lol

Tabbitha · 5th July 2009, 08:17 AM

Quote:

Originally Posted by Adam

SQL would be fine, I'd certainly try me best to import it, but if it's a manual process, I'd need help lol

Well of course and I would help as it would be just awesome to have it all back up again

MMoudry · 5th July 2009, 08:18 AM

Adam,
I would say that importing it into a forum is possible and that was my ultimate goal when I set upon this endeavour. However, it is quite tedious work even for a programmer familiar with the vBulletin DB schema. I have personally no time to put into this due to my other engagements

. I have estimated that this job would need around 40-50 man hours. If somebody else would like to pick up the beacon I'd be glad to consult on the current data format and the way I have devised to import it to a vBulletin schema.

Murad

Tabbitha · 5th July 2009, 08:20 AM

*watches as it all starts to go over her head now *.......:p

MMoudry · 5th July 2009, 08:22 AM

well SQL is possible, however the data aren't normalized or even parsed. There is one line in the table per vBulletin 'page view' and inside the line one column that contains all the HTML code generated by the said page. One needs to write a script to match the page with the thread and parse out the various posts while matching them to various member names (if you decide to maintain the referential integrity with the names). The data are in brute state and not importable into any schema as is. Although I have made sure that all the necessary info for later parsing and matching is present.

5th July 2009, 07:51 AM	#1
MMoudry Join Date: Jul 2009 Posts: 21 Gold: 12 Thanks: 0 Thanked 4 Times in 1 Post	Old f4g posts for UO guilds on europa Hello All, Few years ago the f4g site crashed and all data was lost. There was plethora of stories and reports written there. I've tried to recover the data from google cache and recovered about 1.5GB of data. However I have never gotten around to sorting it and doing anything meaningful with it. The archive still sitting on my hard drive. It's around 1.5 GB and while doing cleaning I would like to get rid of it. If you know someone who might be interested in recovering it I would gladly burn a DVD and send it to them by regular mail in any format they would prefer (ie. XML). I will make a similar offer to several people I know from the community. If I don't hear from anyone 3 weeks from now I shall delete it. The recovery algorithm was preicise, doing heuristic search of various threads and thread pages over google based on member names. I am confident that 95% of content was recovered. So far it is inside a MySQL database, I can convert it to any format for your convinience. Thanks, Murad

5th July 2009, 08:01 AM	#2
Corvak UOForums Lead Moderator Join Date: Feb 2009 Shard/Server: Catskills Posts: 2,952 Gold: 7,885,011 My Mood: Thanks: 89 Thanked 241 Times in 191 Posts Member's Picture Albums	Re: Old f4g posts for UO guilds on europa did you try archive.org? Sometimes they have old web pages stored. __________________ UO - Corvak - Find me on Catskills. WoW - Kriggs - Feathermoon (Alliance) Star Trek Online - @Corvak Steam: Tarkhan Bioware: TarkNWN

5th July 2009, 08:07 AM	#3
Tabbitha "Can Set Custom Title" Join Date: Mar 2006 Shard/Server: Europa/Snowbourn Posts: 6,977 Gold: 4,843 Blog Entries: 6 Thanks: 400 Thanked 643 Times in 381 Posts Member's Picture Albums	Re: Old f4g posts for UO guilds on europa I answered you on Skype Murad.I just need Adams advice on what will be the best format to get it in. I know the player of Seriya de Lacey was desperate to get it way back when I asked you if you could retrieve any of it.She kept asking me if you had passed it on, so she will be very happy. I am sure Adam will reply here and once he has I will send you an adress for the disc to go to . Many thanks __________________

5th July 2009, 08:10 AM	#4
Adam Founder Join Date: Sep 2002 Posts: 9,083 Gold: 23,379 My Mood: Thanks: 86 Thanked 2,019 Times in 735 Posts Member's Picture Albums	Re: Old f4g posts for UO guilds on europa Heh wow, that's awesome. Wonder if it'd be possible to import it into a forum. __________________

5th July 2009, 08:13 AM	#5
Tabbitha "Can Set Custom Title" Join Date: Mar 2006 Shard/Server: Europa/Snowbourn Posts: 6,977 Gold: 4,843 Blog Entries: 6 Thanks: 400 Thanked 643 Times in 381 Posts Member's Picture Albums	Re: Old f4g posts for UO guilds on europa That would be the ultimate ending for it all to be put on,as there are SO Many rp stories and the history of Erpa and Core. What would be the best format to have it burned to a disc ? drags Murad off Skype to speak to Adam __________________ Last edited by Tabbitha; 5th July 2009 at 08:14 AM.

5th July 2009, 08:15 AM	#6
Adam Founder Join Date: Sep 2002 Posts: 9,083 Gold: 23,379 My Mood: Thanks: 86 Thanked 2,019 Times in 735 Posts Member's Picture Albums	Re: Old f4g posts for UO guilds on europa SQL would be fine, I'd certainly try me best to import it, but if it's a manual process, I'd need help lol __________________

5th July 2009, 08:18 AM	#8
MMoudry Join Date: Jul 2009 Posts: 21 Gold: 12 Thanks: 0 Thanked 4 Times in 1 Post	Re: Old f4g posts for UO guilds on europa Adam, I would say that importing it into a forum is possible and that was my ultimate goal when I set upon this endeavour. However, it is quite tedious work even for a programmer familiar with the vBulletin DB schema. I have personally no time to put into this due to my other engagements . I have estimated that this job would need around 40-50 man hours. If somebody else would like to pick up the beacon I'd be glad to consult on the current data format and the way I have devised to import it to a vBulletin schema. Murad

5th July 2009, 08:20 AM	#9
Tabbitha "Can Set Custom Title" Join Date: Mar 2006 Shard/Server: Europa/Snowbourn Posts: 6,977 Gold: 4,843 Blog Entries: 6 Thanks: 400 Thanked 643 Times in 381 Posts Member's Picture Albums	Re: Old f4g posts for UO guilds on europa watches as it all starts to go over her head now .......:p __________________

5th July 2009, 08:22 AM	#10
MMoudry Join Date: Jul 2009 Posts: 21 Gold: 12 Thanks: 0 Thanked 4 Times in 1 Post	Re: Old f4g posts for UO guilds on europa well SQL is possible, however the data aren't normalized or even parsed. There is one line in the table per vBulletin 'page view' and inside the line one column that contains all the HTML code generated by the said page. One needs to write a script to match the page with the thread and parse out the various posts while matching them to various member names (if you decide to maintain the referential integrity with the names). The data are in brute state and not importable into any schema as is. Although I have made sure that all the necessary info for later parsing and matching is present.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Europa Guilds	Oyst	UO General Discussion	1	15th November 2008 05:13 AM
List of RP Guilds on Europa.....anywhere?	Moz	Europa RP General	7	30th June 2008 07:47 AM
Europa Guilds	Full Circle	UO General Discussion	16	12th July 2007 10:34 AM
Guilds?	merth	UO General Discussion	8	28th November 2006 09:59 AM
Faction Guilds Can't Alliance with Non-Faction Guilds	Thradia	UO News	0	12th April 2006 10:24 AM