beta db's

**Nologic** · June 24, 2007

First off a big tip of the hat goes off to PimpDaddyStu & bkenobi for their work done thus far...thanks guys.

Okay figured I'd start a new thread, since we are doing something different.

At this point we are looking to get the correct number of players supported because in my prior script it simply allowed a default value to be applied. This generally speaking wasn't a bad thing since the default would likely apply the bulk of the games gathered.

First off it would be nice if everyone thats going to pitch in on this round would grab the current collection located: [here]

This is so mainly we are all playing with the same set of names...hehe these are not etched in stone by any means so if some one has better suggestions for tagging and naming by all means speak up, so that it can be discussed or acted upon.

Also you'll need AutoIt installed as you'll be working with a raw script, that you will need to edit...AutoIt can be found: [here]

Lastly you'll need the script attached to this post "Moby_Players.zip"

Alright the run down on what needs to be done:

1. Open up a db and make sure the data sheet is in full sized to where the Title bar of Access reads "Microsoft Access - [GameData : Table]"

2. Start a browser session and goto MobyGames.com

3. Find the platform that corresponds with your open db and click on its link

4. Under "Tech-Info" click the link labeled "Number of Players Supported"

5. Under "Number of Players Supported" pick any link thats NOT "1-2 Players" as that corresponds with our default value

6. Open up the "Moby_Players.au3" file and edit line 4's value to match that of what section you are in. If you are doing "1-4 Players" set $players = "4"

7. Copy the url location of where you are at in the site and past that into line 5...make sure "/list-games/" is attached to the url

8. Save the file, then double click it and don't touch your system till a message box appears stating its complete...or that an error has occurred.

9. Continue to go through all the different player counts until done, then zip the file and upload it here, to be included in the next step to getting these done.

10. Start a new one.

<<Important>>

Please post what db you are currently working on...some of these are really big...and it could be a let down for you or some one else if the same db is done twice.

Thanks ahead of time for those looking to pitch in.

**Nologic** · June 24, 2007

All PC's are done and can be found here.

[PC] Amiga

[PC] Amstrad CPC

[PC] Apple II

[PC] Apple Macintosh

[PC] Atari 8-bit

[PC] Atari ST

[PC] Commodore 64

[PC] Commodore 128

[PC] Commodore PET_CBM

[PC] Commodore VIC-20

[PC] Dragon 32_64

[PC] Linux

[PC] Microsoft DOS

[PC] Microsoft MSX

[PC] Microsoft Windows

[PC] Microsoft Windows 3.x

[PC] PC Booter

[PC] Sinclair ZX Spectrum

[PC] Tandy TRS-80

[PC] Tandy TRS-80 CoCo

[PC] TI-99_4A

**Stu1983** · June 24, 2007

All the work is in your script Nologic so all the thanks goes to you for it

In progress [Console] Nintendo SNES

Stu

**Stu1983** · June 24, 2007

Seeing as we're going into each mdb again should we search and replace ";" with " -" so they are more compatible with current naming conventions?

The other thing I'm wondering is, is there any way we could have the script set that at the top you telling the address for all the different players for a system and then the script could cycle through and repeat itself so we didn't have to keep starting it?

I dont know much about AutoIt so maybe it's not as easy as I'm imagining but I'm thinking you would add the addresses to an array and then you could just cycle through them

Stu

**bkenobi** · June 24, 2007

Just a quick note: All of the DB's are done except for PS3, Wii, and XBox360. The database here should probably be updated to include the last couple files.

**Nologic** · June 24, 2007

All Consoles are done and can be found here.

[Console] Amiga CD32

[Console] Atari 2600

[Console] Atari 5200

[Console] Atari 7800

[Console] Atari Jaguar

[Console] Coleco Vision

[Console] Fairchild Channel F

[Console] GCE Vectrex

[Console] Mattel Intellivision

[Console] Microsoft Xbox

[Console] NEC PC-FX

[Console] NEC TurboGrafx-16

[Console] NEC TurboGrafx CD

[Console] Nintendo GameCube

[Console] Nintendo N64

[Console] Nintendo NES

[Console] Nintendo SNES

[Console] Panasonic 3DO

[Console] Philips CD-i

[Console] Philips Odyssey

[Console] Philips Odyssey 2

[Console] Sega 32X

[Console] Sega CD

[Console] Sega Dreamcast

[Console] Sega Genesis

[Console] Sega Master System

[Console] Sega Saturn

[Console] SNK Neo-Geo

[Console] SNK Neo-Geo CD

[Console] Sony Playstation

[Console] Sony PlayStation 2

**Nologic** · June 24, 2007

Done "[PC] Microsoft DOS"

**Stu1983** · June 24, 2007

Okay DB's linked to above have been updated.
Script has been updated in accordance to Stu's suggestions...more or less.
Since I felt trying to do it with arrays would be messy and overly complex (read lazy), I simply turned the bulk of the script into a function.
Under line 5 you'll see "_Player ( , )" function calls...add or delete them as needed, first value is number of players, and second is the url to start from.
Now I've made the assumption that the games where ether marked one type or the other...so games listed as Online...are not also marked 2 player. To that end I'm suggesting we use the value of 0 to indicate online enabled, and assumed 1 player only.
Now if you guys feel differently about this...we can add a new column that explicitly declares if a game is online or not.
Like always every thing is open for discussion.
Now I did write the current build to correct the GoodName values as Stu suggested, as it would make the DB's more usefull in their current state.

Nice work Nologic, I'm running Tom's latest MAME tool that OKs all roms for you at the moment

I'll hopefully get stuck into a few databases tomorrow after work... I had one other suggestion for the script which I forgot to mention earlier

Is anything like a TRY and CATCH statement in AutoIt, I use it in VB to catch errors so I was thinking you could have it before line 34 so it would try to read the data using ($oIE, 3) but if it failed it would then retry using ($oIE, 2) automatically for you rather than erroring

in VB it would be

TRY
$oTable	= _IETableGetCollection ($oIE, 3)
CATCH EX as Exception
$oTable	= _IETableGetCollection ($oIE, 2)
END TRY

I'd tried TRY in the AutoIt script but it didn't like it but maybe you know of something similar

Just a little something to keep you busy lol

Stu

**Nologic** · June 24, 2007

Done "[PC] Apple II"

**bkenobi** · June 25, 2007

When you guys come up with a stable method for Step 2, I'll step in and help. I don't want to update databases in mass until the procedure is finished. That would just be a waste of energy!

**Stu1983** · June 25, 2007

Blah the more I'm looking into players...the more I'm seeing the need for some change.
Mainly looking at changing that column to a text field rather than a numeric....I mean how does one go about defining "8+ Players" in a numeric field?

Well a text field would also take care of online games too

Stu

**Nologic** · June 25, 2007

Done "[PC] Apple Macintosh"

**Stu1983** · June 25, 2007

hmmm having some odd issues here...all the sudden...keep an eye out for errors.

Just tried the SNES there and it's replacing the game name with

{TAB 13}1 Player{SHIFTDOWN}{TAB 13}{SHIFTUP}

Stu

**Nologic** · June 25, 2007

Ok give the latest players script a try...I think I got it solved.

**Stu1983** · June 25, 2007

Ok give the latest players script a try...I think I got it solved.

It would appear to be working again now

[Console] Nintendo SNES - In progress Done

Stu

_Console__Nintendo_SNES.zip

**Stu1983** · June 25, 2007

There's still issue's with line 34

I had to have it set to 3 for 1 Player but then the script crashed as it tried to start players 1-3 so I had to change it to 2 and then run it again and it done 1-3 then 1-5 then 1-8 without any trouble

Stu

**Nologic** · June 25, 2007

Okay try the latest players script...it tested fine with "[Console] GCE Vectrex" which was a two table platform.

*Update*

hmm script seems to fail from time to time...not sure why...if reran it works fine.

Anyways I'm back filling prior posts...the script is just going to have to do as is I'm afraid.

**Nologic** · June 26, 2007

Done "[PC] Atari 8-bit"

Done "[PC] Atari ST"

Done "[PC] Commodore 64"

Done "[PC] Commodore 128"

Done "[PC] Commodore PET_CBM"

Done "[PC] Commodore VIC-20"

Done "[PC] Dragon 32/64"

Done "[PC] Linux"

Done "[PC] Microsoft MSX"

Done "[PC] Microsoft Windows 3.x"

Done "[PC] PC Booter"

Done "[PC] Sinclair ZX Spectrum"

Done "[PC] Tandy TRS-80"

Done "[PC] Tandy TRS-80 CoCo"

**bkenobi** · June 26, 2007

So then the script works? What is required now as far as user intervention for running the update?

**Nologic** · June 26, 2007

Yeah it works...not perfectly...but most the time things go smoothly.

Basically you just edit the following section to your needs:

; Duplicate or Delete "_Players( , )" as needed, alter values as required
_Players ( "1 Player"		, "http://www.mobygames.com/browse/games/win3x/tic,19/ti,140/list-games/" )
;_Players ( "1-3 Players"	, "http://www.mobygames.com/browse/games/win3x/tic,19/ti,181/list-games/" )
_Players ( "1-4 Players"	, "http://www.mobygames.com/browse/games/win3x/tic,19/ti,142/list-games/" )
_Players ( "1-5 Players"	, "http://www.mobygames.com/browse/games/win3x/tic,19/ti,182/list-games/" )
;_Players ( "1-6 Players"	, "http://www.mobygames.com/browse/games/win3x/tic,19/ti,253/list-games/" )
_Players ( "1-8 Players"	, "http://www.mobygames.com/browse/games/win3x/tic,19/ti,143/list-games/" )
;_Players ( "2 Players"		, "http://www.mobygames.com/browse/games/win3x/tic,19/ti,501/list-games/" )
;_Players ( "2-4 Players"	, "http://www.mobygames.com/browse/games/win3x/tic,19/ti,509/list-games/" )
;_Players ( "2-5 Players"	, "http://www.mobygames.com/browse/games/win3x/tic,19/ti,541/list-games/" )
;_Players ( "Online"		, "http://www.mobygames.com/browse/games/win3x/tic,19/ti,154/list-games/" )

heh tho the ones commented out with a ";" don't run.

Thats a near complete generic list of sections covered by Moby. In the above code you'll notice "win3x" which is for Windows 3.x...but for the Nintendo 64 its "n64"...so if you have a text editor that supports column editing like UltraEdit32 you can replace that section with ease...through out all the possible urls...then it just comes down to commenting and uncommenting lines and then making a quick check to make sure every thing appears right...then just let it fly.

**Stu1983** · June 26, 2007

My internet/router has died at home so I'm outta action for a while till I work out whats wrong, once I get up and going again I'll get tucked in to some more of these if there's still some left

Stu

**Nologic** · June 26, 2007

Well best of luck on getting things going.

Be sure to swing back in once things have come together.

**bkenobi** · June 26, 2007

I think I understand how to do this now, so I was going to give it a go tonight. Is there a todo list yet? I don't want to duplicate work if possible. Yeah, I could just compile one myself based on what's been listed, but perhaps you already have one you could post. Either way...

**Nologic** · June 27, 2007

Well if you want to tackle the Handheld and Mobile db's that would be great as I nearly have all the Consoles done.

**bkenobi** · June 27, 2007

Well if you want to tackle the Handheld and Mobile db's that would be great as I nearly have all the Consoles done.

I'll try to find time in a bit then...

beta db's

Recommended Posts

Nologic

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Nologic

Stu1983

Stu1983

bkenobi

Nologic

Nologic

Stu1983

Nologic

bkenobi

Stu1983

Nologic

Stu1983

Nologic

Stu1983

Stu1983

Nologic

Nologic

bkenobi

Nologic

Stu1983

Nologic

bkenobi

Nologic

bkenobi

Donate

Browse

Products

Downloads

Activity

More