VGOEmulator.net

[quote="John Adams":ry1na3sa]I do have to share the one scare I had today.


Was just telling Jabantiz, that it's taken me almost 6 hours straight to try and recover the EQ2Emulators Forums database.... yes, the entire thing. All their posts, were gone. The bad spot on the drive sat right under their Posts table, of course. Almost 29,000 posts on that site spanning almost 9 years. I panicked.

After trying every thing I knew, and searching the stupid ass google/blogger/armchair "experts" on stackoverflow for hours, I finally walked away for a moment... when it suddenly hit me; what if I read the Posts table in chunks, and skipped over the bad stuff?

So I started doing "insert into new_table select * from old_table limit 0,1000" until I hit the bad spots. I got about 9,000 rows into the corrupt table. Then, it started looking bleak again. 10,000, 11,000, and so on... all bad.

Of course I had a backup, duh. But it was from the last time I moved everything (bad JA, bad!) which was Aug 2014. So I loaded up the backup. Low and behold, there were over 28,000 posts in that table... so worst come to worst, EQ2 would only lose their latest posts. That was not good enough for me!

So I had another brainstorm... when there's a bad "spot" on a drive, it's just a spot right? So, I saw the highest record ID in the backup and went to the corrupted table and did a DESC sort on that ID and what do ya know? 175 posts was all that was missing. And the corrupted table let me have them.

Peace and Tranquility has been restored to [url=http://eq2emulator.net:ry1na3sa]EQ2Emulator[/url:ry1na3sa].

F*#k I need a beer.[/quote:ry1na3sa]

Hahaha nice work mate! You definitely deserve a beer at least!

[quote="John Adams":12pesrdk]

F*#k I need a beer.[/quote:12pesrdk]
You mean piss-water? How about a something harder.

No can do, my friend. Partied like a rock star way too long in my younger days

John the World Database Editor seem's to be FUBAR

Oops. Fixed.

Note: What you saw was the new editor code (tons rewritten for the new schema and security), it just wasn't supposed to go live yet So anything that touches Spawn data will be broken.

I was just chatting with Tan Fen Greatcloud! I loved it! I had to go back through and read the conversation to my hubby who said "Ha! That's flipping awesome!". Over the past few weeks (since I found out about VGOEmulator) I've been running around New Telon, reliving memories and just breathing in the beautiful scenery. Both my Husband and son played VG too and we've all sat around the computer for hours doing the whole "oh, let's go check out _________ agian!", lol. We think you guys are doing an amazing job and are very excited you've decided to take on the project. I wish there was a way that we could help.. We were considering a monetary donation but then I was reading through the forums and saw that that's not an option. So, I guess for now I'll just sit on the sidelines and be the cheerleader Go team VGOE!