The RBI Baseball Database

[Gantry]

Every little bit helps, I'm going to work on it more this evening - do the weird, poorly linked stuff like templates - not to mention all of the players for California.  I'll probably just spend an hour and do as many pages as I can.  There's certainly no rush on this thing since it has been dead for ages. 

[Gantry]

Good call - then you get only legit edits by user.

Can you give a link to  a page without an original history?  The site was moved to different servers, but I haven't seen something that had no dee-nee members at the bottom of the history. 

[Gantry]

http://oldwiki.dee-nee.com/index.php?title=Boston_(NES)&action=history


Pretty much every team site, as far as I can see.  But I think I'm missing something.  I didn't think you could delete history like that.

Well that's just fucked up, no idea what's happening there.  I'll look into it later tonight, wonder if I have to go all the way back to the original wiki on the old server. 

[Turd]

I saw the same thing when I tried to do Boston.

Where is the team template again?

[broiler]

I didn't think you could delete history like that.

Be careful shitpaw, you could unravel the fabric of the space time continuum

[Gantry]

A Call To Arms

I'm ready to get the RBI Database back online and it this point it's probably best to start from scratch.  There was so much spam that it's pretty much worthless to migrate the data over from the old server to ward.  The size of the RBI Database (despite having maybe a couple hundred pages) is actually 20% larger than the forums and its 500,000+ posts!  That's because spammers were changing the pages hundreds of times a day and the history went out of whack. 

I moved my work wiki and my punkdatabase.com wiki to ward, so I have the steps down.  Here is what I'm envisioning:

1)  Done! Setup a new wiki on ward for the RBI Database, with the newest version of MediaWiki - http://wiki.dee-nee.com
2)  Done! Keep the old wiki  in it's current spot - http://dee-nee.com/wiki
3)  Manually copy every page over by hand
4)  Manually copy over every Image over by hand (this is the big PITA)

So what I'm looking for is some folks that are willing to join me in this project.  It's simply a lot of gruntwork, steps would go like this:

1)  Open up a page on the old wiki
2)  Click "Edit" to get the raw wiki source, or find the newest non-spam version in the history
3)  Select All -> Copy
4)  Create the same page on the new DB
5)  Paste

Rinse and repeat for every page on the wiki.  If we got enough people we'd probably divvy up the pages by letter or something. 

What we'd lose by doing it this way - all accounts and version history.  That's a bummer but it's better than no site at all or migrating over thousands of spam edits. 

I'd get into more detail about how to pull this off, but all I want to know now is who'd be in to help.  The more people we have, the less work there is to do.  If we get enough people to chip in 15-45 minutes of time, this can be done in no time. 

Who is with me? 

So this would explain things, starts on page 16 - the oldwiki was our first attempt to start a new db from scratch because of spam.  Looks like we didn't get very far with it.  It appears we need to revive the original db and work from there as oldwiki doesn't have most of the content (which is why there is no history for Boston, a spammer originally made the page) - the plot thickens. 

Let me see if I can get the original wiki up.  Fuck spammers

[Gantry]

Said wiki isn't on ward, which was already retired.  It was on the OLD server, guess I'll have to hook that bad boy up and work from it.  Three hour tour...

[Gantry]

So definitely incomplete, following the discussion from pages 16-19.  Looks like I started to do all the Images and made it to the letter F.  I guess we should start here:

http://oldwiki.dee-nee.com/index.php?title=Special:PrefixIndex&from=&namespace=6

But before we do that I should make sure the old wiki is even accessible on the old server before we waste any more time on this.  If we can't get the old wiki back, this project may be dead in the water.  I'll check when at the office tomorrow, sorry for the delay.

[broiler]

You're doing a great job, keep it up!

[Gantry]

thx

[Gantry]

link to the images for later:

http://oldwiki.dee-nee.com/index.php?title=Special:PrefixIndex&from=&namespace=6

[Gantry]

OK the OG wiki is up and it looks like it has all the data:

http://firstwiki.dee-nee.com/wiki/

I know the URL is a little confusing, but work with me.  Don't have any more time, but I think that all the data we are looking for.  It also has less spam than oldwiki, so I don't think we should use that anymore.  Pretty sure it's the exact same data.

Just tried the example from before, and the Boston page is there.  Transferred to the new wiki.  Have at it people!

[Gantry]

I'm going to start on the images, as it's the most tedious.   Here's a page of all wiki pages from the old one:

http://firstwiki.dee-nee.com/wiki/index.php/Special:Allpages

If we get a bunch of people take a letter or two and copy them over we'll have it done in no time. 

[Gantry]

A's are done - the new mediawiki lets you drag an image right to the upload page - saves time.  Going to take a ton of time regardless. 

[Gantry]

the new mediawiki lets you drag an image right to the upload page - saves time. 

This might be a firefox thing because it also works on Dee-Nee.  Approved...

[Gantry]

Looks like the wiki syntax has changed, look at the picture orientation of new & old Marty Barrett pages:

Old:

http://firstwiki.dee-nee.com/wiki/index.php/Marty_Barrett

New:

http://wiki.dee-nee.com/wiki/Marty_Barrett

We'll have to figure that out sooner rather than later, as we may have to edit a bunch of pages that use that format.  But I'm taking a break for now...

[Gantry]

DEE-NEE!!!

Thanks to some fucking around and Mediwiki's importImages.php script all 1500+ images are now on the new wiki.  Saves A FUCKTON of time.

[Gantry]

Shitpaw has been adding more stuff to the new wiki, a hearty thanks.  I'm going to start with the years and kind of work my way alphabetically, up to 1951 now.  Also filling in categories and random links as I go along.  Should have all the years in by the end of the day. 

[Gantry]

Re-created all the pages starting with a number again.   Also filled in some auxillary pages and most of the categories along the way.   Come across this page, which I completely forgot about:

http://wiki.dee-nee.com/wiki/Santee,_California

[Gantry]

Finished all the articles that start with "A" in addition to random other pages and categories along the way.  Question, look at the Hall of Shame:

http://wiki.dee-nee.com/wiki/Hall_of_Shame

Right now it barely says anything and links to the dee-nee proper page.  You should I should take the original page, wikify it and put it in the database?  The benefits would be that anyone can add entries and it can be a living page.  Downside is that it would take away from the main site, though it's pretty much dead anyway.  Thoughts?