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: ListGen updated Feb 21, 2006  (Read 1940 times)

0 Members and 1 Guest are viewing this topic.

Buddabing

  • Wiki Master
  • Trade Count: (0)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 1845
  • Last login:February 12, 2015, 02:51:45 pm
  • I'm a llama!
ListGen updated Feb 21, 2006
« on: February 21, 2006, 02:37:33 pm »
Hello,

I've updated my ListGen utility. There were two changes.

1) ListGen would not parse newer -listxml files created by the most recent versions of MAME. This is fixed.

2) I've added two fields to my database which might help some people. They are called is_in_controls_dat and parent_in_controls_dat. You'll need to make sure controls.xml is in the same directory with your ListGen executable, or these options will always fail.

For example, if you want to only generate a list of games that have controls.dat entries you could put the following in your filter.sql:

Code: [Select]
select * from gamedata where is_in_controls_dat='1' or parent_in_controls_dat='1';

This SQL statement generates 996 list entries when the parent_in_controls_dat is not set, and 2475 list entries when it is. (Using BuddaMAME v0.104)

You may see a warning that "unknown option -gamelist", depending on what MAME version you are using. This is because MAMEdev took this option out recently.

Please inform me of any bugs or requested features.

Regards,
Buddabing

EDIT: Link
« Last Edit: February 22, 2006, 08:13:02 am by Buddabing »
I have changed my nickname to "Cakemeister". Please do not PM the Buddabing account because I do not check it anymore.

Please read the wiki!

SirPoonga

  • Puck'em Up
  • Global Moderator
  • Trade Count: (+1)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 8190
  • Last login:August 14, 2025, 10:34:47 pm
  • The Bears Still Suck!
Re: ListGen updated Feb 21, 2006
« Reply #1 on: February 21, 2006, 02:47:24 pm »
This SQL statement generates 996 list entries when the parent_in_controls_dat is not set, and 2475 list entries when it is. (Using BuddaMAME v0.104)
That does not compute.

Buddabing

  • Wiki Master
  • Trade Count: (0)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 1845
  • Last login:February 12, 2015, 02:51:45 pm
  • I'm a llama!
Re: ListGen updated Feb 21, 2006
« Reply #2 on: February 21, 2006, 03:44:27 pm »
That does not compute.


It computes quite well for the older version of controls.xml that I was using.  ;D

For the latest version (v0.101.3), is_in_controls_dat generates 1054 list entries and is_in_controls_dat or parent_in_controls_dat generates 2598 list entries.

There are 1059 entries in the controls.xml, less the five entries that aren't games (hng64, nss, neogeo, playch10, and trvwhiz), that leaves 1054.



I have changed my nickname to "Cakemeister". Please do not PM the Buddabing account because I do not check it anymore.

Please read the wiki!

SirPoonga

  • Puck'em Up
  • Global Moderator
  • Trade Count: (+1)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 8190
  • Last login:August 14, 2025, 10:34:47 pm
  • The Bears Still Suck!
Re: ListGen updated Feb 21, 2006
« Reply #3 on: February 21, 2006, 04:23:46 pm »
ahhh, better :)

cdbrown

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 1241
  • Last login:October 16, 2017, 09:52:03 pm
  • Bowowow
Re: ListGen updated Feb 21, 2006
« Reply #4 on: February 22, 2006, 11:10:22 am »
I just downloaded the listgen although I don't think it's been updated.  I checked listgen.exe and it still has a date 10/07/05.  I thought something was strange when I copied over the original files and they came up with the same date and timestamp.

Buddabing

  • Wiki Master
  • Trade Count: (0)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 1845
  • Last login:February 12, 2015, 02:51:45 pm
  • I'm a llama!
Re: ListGen updated Feb 21, 2006
« Reply #5 on: February 22, 2006, 12:04:47 pm »
I just downloaded the listgen although I don't think it's been updated.  I checked listgen.exe and it still has a date 10/07/05.  I thought something was strange when I copied over the original files and they came up with the same date and timestamp.

When did you upload it? I made a mistake with the filename on the first upload so I corrected it this morning (2-22, approx 14:00 GMT)
I have changed my nickname to "Cakemeister". Please do not PM the Buddabing account because I do not check it anymore.

Please read the wiki!

cdbrown

  • Trade Count: (0)
  • Full Member
  • ***
  • Offline Offline
  • Posts: 1241
  • Last login:October 16, 2017, 09:52:03 pm
  • Bowowow
Re: ListGen updated Feb 21, 2006
« Reply #6 on: February 22, 2006, 12:22:42 pm »
I think it was a cache problem.  Cleared all data and redownloaded it now.  Can see there is a definite difference.  Sorry about that.

It works.  Now I need a way to get a list of unplayable games.  It seems MAWS relies on catver.ini to determine all the categories on the site, problem is catver hasn't been updated since 099u2.  You may say but I just downloaded version 101 - open up catver and see what's in the first line of text.

Do you know if any of this info could be taken from listxml.txt?  Also need mature and mahjong lists.

SirPoonga

  • Puck'em Up
  • Global Moderator
  • Trade Count: (+1)
  • Full Member
  • *****
  • Offline Offline
  • Posts: 8190
  • Last login:August 14, 2025, 10:34:47 pm
  • The Bears Still Suck!
Re: ListGen updated Feb 21, 2006
« Reply #7 on: February 22, 2006, 01:02:46 pm »
cd, that info is mainly in catver.  You can't determine that from mame.  Well, possibly unplayable.

Unofficial catver that started since the real one hasn;t been updated.
http://www.mameitalia.net/index.php?showtopic=6526