Main Restorations Software Audio/Jukebox/MP3 Everything Else Buy/Sell/Trade
Project Announcements Monitor/Video GroovyMAME Merit/JVL Touchscreen Meet Up Retail Vendors
Driving & Racing Woodworking Software Support Forums Consoles Project Arcade Reviews
Automated Projects Artwork Frontend Support Forums Pinball Forum Discussion Old Boards
Raspberry Pi & Dev Board controls.dat Linux Miscellaneous Arcade Wiki Discussion Old Archives
Lightguns Arcade1Up Try the site in https mode Site News

Unread posts | New Replies | Recent posts | Rules | Chatroom | Wiki | File Repository | RSS | Submit news

  

Author Topic: Here is a spreadsheet with games and their control types  (Read 6732 times)

0 Members and 1 Guest are viewing this topic.

soslo

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 437
  • Last login:March 10, 2012, 03:23:36 pm
  • The Governator
    • My website does not have a name yet
Here is a spreadsheet with games and their control types
« on: August 13, 2003, 06:17:26 pm »
Thanks to a few ppl on here, I put the data from the online list of controls [
http://www.cosmicbreaks.com/images/arcade_stick/Controls_0.60 ] into a database and have pulled it into an Excel spreadsheet.

Now it is much easier to sort...I know the list is outdated somewhat, so I would appreciate any modifications/updates. Please post them or email them to me - DO NOT CHANGE THE SPREADSHEET AND SEND IT BACK TO ME.

I am storing the data in a database, and updating the spreadsheet will not help me because the data is normailized and uses keys for the different tables. Just write down what changes need to be made and I'll change them in the DB, then create a new spreadsheet from the updated data.

The data is easy to sort...just highlight everything, click data > sort, then select the columns you wish to sort by.

Please post changes, or email them to me and I will update the DB, and put the new spreadsheet here. I will not make changes from an updated spreadsheet.

I am using this sheet to help me pick games for my cab that will definately work with the controls I have...perhaps there are other uses.

If there is a better source for this info, please let me know and I won't waste any more time working on a problem someone else has solved.

If someone can host my SQL Server DB and some ASP pages, I'll write up a few pages for entering/updating/displaying the data in real-time. I do this all day at work, but I don't have a way to host anything.

NOTE: This is an excel spreadsheet - so rename it from .txt to .xls
« Last Edit: August 13, 2003, 06:18:20 pm by soslo »
5 MAME cabs and counting...

Ever wonder what full side art looks like?
http://www.aaronmurray.com

u_rebelscum

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 3633
  • Last login:April 21, 2010, 03:06:26 pm
  • You rebel scum
    • Mame:Analog+
Re:Here is a spreadsheet with games and their control types
« Reply #1 on: August 13, 2003, 10:02:28 pm »
I have some info at my site's download page.  

"Mame .70u1 inputs; tab delimited text file with evey game and it's inputs"

It's more database oriented (vs spreadsheet), and lists the minimum data per input.  But it does list every input in every game, as of mame ver. 0.70u1.


My freeware spreadsheet doesn't read your excel file (reads up to excel 4.0) so I'm not sure what is included in it.  I'll have to borrow a friend's comp to check it out.  Any suggestions on free spreadsheets that read currect excel files?
Robin
Knowledge is Power

CitznFish

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 831
  • Last login:November 13, 2024, 01:18:45 am
  • www.subvertcity.com - Prof. Strength Slackwear
Re:Here is a spreadsheet with games and their control types
« Reply #2 on: August 13, 2003, 10:07:55 pm »
doesn't MS offer a free excel viewer?

edit: here is the URL for their free viewer;

http://office.microsoft.com/downloads/default.aspx?Product=Excel&Version=95|97|98|2000|2002&Type=Converter|Viewer
« Last Edit: August 13, 2003, 10:08:56 pm by CitznFish »

u_rebelscum

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 3633
  • Last login:April 21, 2010, 03:06:26 pm
  • You rebel scum
    • Mame:Analog+
Re:Here is a spreadsheet with games and their control types
« Reply #3 on: August 13, 2003, 10:16:45 pm »
"viewer", damn I was looking the wrong words. :-\  I tried "reader", "file", and "xls" under download--excel search, and no luck.

Thanks!  Downloading now. :)
Robin
Knowledge is Power

Sasquatch!

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 1138
  • Last login:March 01, 2010, 04:11:47 pm
  • Toot-Toot!
    • Arcade Paradise
Re:Here is a spreadsheet with games and their control types
« Reply #4 on: August 13, 2003, 10:27:34 pm »
Cool info to have.  A buddy of mine is trying to figure out what controls he'll need to have for his future CP, so this'll come in handy.  Thanks, soslo!

jerryjanis

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 821
  • Last login:February 02, 2023, 01:56:44 am
  • Skate or Die!!!
    • Jake's Joystick
Re:Here is a spreadsheet with games and their control types
« Reply #5 on: August 13, 2003, 11:31:47 pm »
You're missing all of the really crazy control types (some of my favorites!).  Here are some of the crazier ones, that might be really important when planning a control panel:

SDI Strategic Defense Initiative
« Last Edit: August 13, 2003, 11:34:39 pm by jerryjanis »

soslo

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 437
  • Last login:March 10, 2012, 03:23:36 pm
  • The Governator
    • My website does not have a name yet
Re:Here is a spreadsheet with games and their control types
« Reply #6 on: August 14, 2003, 11:58:57 am »
Cool, thanks guys! Here is the new version (rename from .txt to .xls). This also has a list of known (to me)control types - please feel free to chime in with others (and the games that use them).
5 MAME cabs and counting...

Ever wonder what full side art looks like?
http://www.aaronmurray.com

soslo

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 437
  • Last login:March 10, 2012, 03:23:36 pm
  • The Governator
    • My website does not have a name yet
Re:Here is a spreadsheet with games and their control types
« Reply #7 on: August 14, 2003, 11:59:48 am »
And here is just the first page in tab delimeted format for the guys without Excel
5 MAME cabs and counting...

Ever wonder what full side art looks like?
http://www.aaronmurray.com

Inaba

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 117
  • Last login:December 14, 2004, 01:58:48 pm
  • Secret Squirrel
    • Cazic Thule Forums
Re:Here is a spreadsheet with games and their control types
« Reply #8 on: August 14, 2003, 12:32:11 pm »
Soslo,

I was going to write something similar... however, I work with Apache/PHP.  I can provide you some space and we can work on an Open Source app + open database for Mame roms.

I've been doing some checking around, and it doesn't seem that anything from Mame.dk is readily available (understandable) -- and there's not anything really updated on ROM sets that can be easily manipulated.  As you've found, Mame.dk doesn't have all the information you'd like on controls (among other things as well) - so it may be time to have a comprehensive database.

I can provide you with some webspace and a MySQL server... but no ASP or MSSQL.  If you're willing and able to work with PHP :)

Either way, I'll probably work something up based on this data and see how it goes from there.

soslo

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 437
  • Last login:March 10, 2012, 03:23:36 pm
  • The Governator
    • My website does not have a name yet
Re:Here is a spreadsheet with games and their control types
« Reply #9 on: August 14, 2003, 12:49:35 pm »
Inaba, check your PM
5 MAME cabs and counting...

Ever wonder what full side art looks like?
http://www.aaronmurray.com

SirPoonga

  • Puck'em Up
  • Global Moderator
  • Trade Count: (+1)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 8188
  • Last login:July 20, 2025, 03:37:24 pm
  • The Bears Still Suck!
Re:Here is a spreadsheet with games and their control types
« Reply #10 on: August 14, 2003, 02:31:28 pm »
Soslo,

I was going to write something similar... however, I work with Apache/PHP.  I can provide you some space and we can work on an Open Source app + open database for Mame roms.

I've been doing some checking around, and it doesn't seem that anything from Mame.dk is readily available (understandable) -- and there's not anything really updated on ROM sets that can be easily manipulated.  As you've found, Mame.dk doesn't have all the information you'd like on controls (among other things as well) - so it may be time to have a comprehensive database.

I can provide you with some webspace and a MySQL server... but no ASP or MSSQL.  If you're willing and able to work with PHP :)

Either way, I'll probably work something up based on this data and see how it goes from there.


The control part is already being done by me and HC.  Though I could use some help.  I'm learning PHP.

http://fe.donkeyfly.com   Go there, register, and PM me.  I'll show you what I have done so far.    In fact I am working on the submission wizard right now, just taking a break.
« Last Edit: August 14, 2003, 02:32:07 pm by SirPoonga »

Inaba

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 117
  • Last login:December 14, 2004, 01:58:48 pm
  • Secret Squirrel
    • Cazic Thule Forums
Re:Here is a spreadsheet with games and their control types
« Reply #11 on: August 14, 2003, 03:33:05 pm »
Soslo,

I was going to write something similar... however, I work with Apache/PHP.  I can provide you some space and we can work on an Open Source app + open database for Mame roms.

I've been doing some checking around, and it doesn't seem that anything from Mame.dk is readily available (understandable) -- and there's not anything really updated on ROM sets that can be easily manipulated.  As you've found, Mame.dk doesn't have all the information you'd like on controls (among other things as well) - so it may be time to have a comprehensive database.

I can provide you with some webspace and a MySQL server... but no ASP or MSSQL.  If you're willing and able to work with PHP :)

Either way, I'll probably work something up based on this data and see how it goes from there.


The control part is already being done by me and HC.  Though I could use some help.  I'm learning PHP.

http://fe.donkeyfly.com   Go there, register, and PM me.  I'll show you what I have done so far.    In fact I am working on the submission wizard right now, just taking a break.

Are you planning on making the database and software open to the public?  I plan on making the raw database available for download for use on other sites, as well as the software itself.  Too many closed DBs already, no sense in hoarding this sort of information, unless you're intending to make a profit somehow, then it's understandable.  But I have no plans to try and make a profit off this.

SirPoonga

  • Puck'em Up
  • Global Moderator
  • Trade Count: (+1)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 8188
  • Last login:July 20, 2025, 03:37:24 pm
  • The Bears Still Suck!
Re:Here is a spreadsheet with games and their control types
« Reply #12 on: August 14, 2003, 03:51:21 pm »
You didn't goto fe.donkeyfly.com and read:)  It's the controls.dat project.  The project is to list and label the controls a game uses.  (like labelling a button Jump).  It's mainly for FE devs.  There will be two version, an ini file and an xml file that will be generated from the MySQL database (which I finished designing two weeks ago).  Do a search on here for controls.dat, you will see about a year ago we started talking about it.  

Inaba

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 117
  • Last login:December 14, 2004, 01:58:48 pm
  • Secret Squirrel
    • Cazic Thule Forums
Re:Here is a spreadsheet with games and their control types
« Reply #13 on: August 14, 2003, 04:24:41 pm »
You didn't goto fe.donkeyfly.com and read:)  It's the controls.dat project.  The project is to list and label the controls a game uses.  (like labelling a button Jump).  It's mainly for FE devs.  There will be two version, an ini file and an xml file that will be generated from the MySQL database (which I finished designing two weeks ago).  Do a search on here for controls.dat, you will see about a year ago we started talking about it.  

Ok... just read throuhg the site a bit.  I'm a little confused on what you're trying to accomplish?  It appears you plan on using this for FE development, yes?  What is the end result envisioned to be?  I can't quite put my finger on exactly what's going to be available as far as information goes, can you elaborate on it a bit?

I've been developing apps for PHP/MySQL for several years now, if you need any help or anything, let me know.

SirPoonga

  • Puck'em Up
  • Global Moderator
  • Trade Count: (+1)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 8188
  • Last login:July 20, 2025, 03:37:24 pm
  • The Bears Still Suck!
Re:Here is a spreadsheet with games and their control types
« Reply #14 on: August 14, 2003, 04:39:33 pm »
I haven;t gotten around to moving all the threads on controls.dat to the controls.dat area.  Alot of it is in the users area.  Sorry about that.  Check this thread out

http://www.fe.donkeyfly.com/yabbse/index.php?board=1;action=display;threadid=45

Yarb

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 113
  • Last login:December 26, 2019, 01:18:30 pm
Re:Here is a spreadsheet with games and their control types
« Reply #15 on: August 15, 2003, 05:20:12 pm »
Isn't R-Type 8-way Joystick + 2 Buttons (It's listed as 4 buttons)

Yarb

JoyMonkey

  • Voodoo Wiki Master . . .
  • Wiki Master
  • Trade Count: (+5)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 2899
  • Last login:June 16, 2025, 09:16:27 pm
  • Candy is Dandy but Liquor is Quicker
    • JoyMonkey.com
Re:Here is a spreadsheet with games and their control types
« Reply #16 on: August 15, 2003, 06:12:46 pm »
Myself and IIOIOOIOO have been working on a similar project, right now we're working on a way for people to submit control descriptions based on the game's info in our database. The database uses info from Mame's listinfo and KLOV's control descriptions (thanks to PacManFan's Gameplay.ini file) and is pretty much complete.

Here's a sample csv text file of the info I've collected, I've been working it through Excel and into XML for the submission system which should be ready (hopefully) in a week or two.


SirPoonga

  • Puck'em Up
  • Global Moderator
  • Trade Count: (+1)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 8188
  • Last login:July 20, 2025, 03:37:24 pm
  • The Bears Still Suck!
Re:Here is a spreadsheet with games and their control types
« Reply #17 on: August 15, 2003, 06:17:47 pm »
Hey, that's the same thing that HC and I have been doing.

The submission system, at least for adding games, should be done very soon.

JoyMonkey

  • Voodoo Wiki Master . . .
  • Wiki Master
  • Trade Count: (+5)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 2899
  • Last login:June 16, 2025, 09:16:27 pm
  • Candy is Dandy but Liquor is Quicker
    • JoyMonkey.com
Re:Here is a spreadsheet with games and their control types
« Reply #18 on: August 15, 2003, 06:25:06 pm »
Hey, that's the same thing that HC and I have been doing.

The submission system, at least for adding games, should be done very soon.

Whohoo! Looks like we might have a 'my ones bigger than yours' type schoolyard fight-out with these things!

SirPoonga

  • Puck'em Up
  • Global Moderator
  • Trade Count: (+1)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 8188
  • Last login:July 20, 2025, 03:37:24 pm
  • The Bears Still Suck!
Re:Here is a spreadsheet with games and their control types
« Reply #19 on: August 15, 2003, 06:34:47 pm »
no, we don't need another catver.ini issue.  

Anyway, the format HC and I are creating has been discussed here by the FE devs.  It's what the FE devs want.

If you want to help look above.
« Last Edit: August 15, 2003, 06:59:25 pm by SirPoonga »

Howard_Casto

  • Idiot Police
  • Trade Count: (+1)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 19428
  • Last login:Yesterday at 11:52:51 pm
  • Your Post's Soul is MINE!!! .......Again??
    • The Dragon King
Re:Here is a spreadsheet with games and their control types
« Reply #20 on: August 15, 2003, 07:28:03 pm »
Yeah, that isn't to say that your efforts aren't appreciated, but so far 99% of the data you have in your format can be parsed directly from listinfo.  The only new data you have is alternating and some odd ball type description?  While these two bits of data are nice, they in no way reflect gameplay unless combined with more complicated data, which you guys aren't gathering (we are).  So my quesiton is why are you doing your file manually when it could be parsed directly from listinfo?  

As sirp said, the format we have created is based upon a lengthy discussion with the major fe developers out there.  So if you are doing this file for them then don't bother and come help us.  If your making it for another purpose then good luck to you.  

SirPoonga

  • Puck'em Up
  • Global Moderator
  • Trade Count: (+1)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 8188
  • Last login:July 20, 2025, 03:37:24 pm
  • The Bears Still Suck!
Re:Here is a spreadsheet with games and their control types
« Reply #21 on: August 16, 2003, 06:13:03 pm »
Actually, if anyone wants to beta test PM me.  I have the wizards that users will use almost complete.

IIOIOOIOO

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 295
  • Last login:August 04, 2003, 02:18:12 pm
Re:Here is a spreadsheet with games and their control types
« Reply #22 on: August 16, 2003, 11:54:52 pm »
Just because I've been overly quiet, I am uploading the major interface to the stub format JoyMonkey displayed tonight. He also made a gorgeous website for it btw. And yes HC, the info displayed in JoyMonkey's file IS mostly parsed from listinfo, with one other (I believe?) source combined with it. However, it is not "The File." Rather, it served as the baseline for a skeletal pre-filled file to save some time for users entering a game. I.E. if we know from easily parsed sources that SFII has 2 players simul, and 1 stick + 6 buttons for each player, we can assume the base controlset for the game. Note that this is just for prefill of the form. Users can easily add/remove controls to the controlset for a player, and clone either explicitly or implicitly between players. By building things up from a control/actiontype framework, it is very easy to translate the resulting format across to a graphical display of the information. I.E. a program can either display the controlset for a game textually, or another program can create customized CP snaps for the individual users machine, by... well, it's a longer process than I care to describe whilst so tired. But yes, I read the discussion on the FEDev forums re controls.dat or whatever it was called, and I devised this system as a direct response to that one :) But wait till monday, and assuming that JoyMonkey's host has the proper libraries installed on it you will see what I'm talkin bout.