the output from listgen is empty.
listgen.tmp contains thousands of lines like this:
005|005|005|1981|Sega|raster|vertical|good|preliminary|preliminary|joy4way|224|256|0|3|4|2|1|2|segar.c||||||||0|0|60.000000|1|yes|no|Yes|Yes|No|Yes|1|0|0|0|
11beat|Eleven Beat|Eleven Beat|1998|Hudson|raster|horizontal|good|preliminary|preliminary||512|512|0|4|3|0|1|1|aleck64.c||||||||0|0|60.000000|0|no|no|No|Yes|No|Yes|1|0|0|0|
1941|1941 - Counter Attack (World)|1941 - Counter Attack|1990|Capcom|raster|vertical|good|good|good|joy8way|224|384|0|3|4|2|2|2|cps1.c||||||||0|0|60.000000|1|no|no|Yes|Yes|Yes|Yes|1|0|0|0|
1941j|1941 - Counter Attack (Japan)|1941 - Counter Attack|1990|Capcom|raster|vertical|good|good|good|joy8way|224|384|1|3|4|2|2|2|cps1.c|1941|1941||||||0|0|60.000000|1|no|no|Yes|Yes|Yes|Yes|1|0|0|0|
1942|1942 (set 1)|1942|1984|Capcom|raster|vertical|good|good|good|joy8way|224|256|0|3|4|2|2|2|1942.c||||||||0|0|60.000000|1|no|no|Yes|Yes|Yes|Yes|1|0|0|0|
1942a|1942 (set 2)|1942|1984|Capcom|raster|vertical|good|good|good|joy8way|224|256|1|3|4|2|2|2|1942.c|1942|1942||||||0|0|60.000000|1|no|no|Yes|Yes|Yes|Yes|1|0|0|0|
1942b|1942 (set 3)|1942|1984|Capcom|raster|vertical|good|good|good|joy8way|224|256|1|3|4|2|2|2|
so I think it finds the games OK
If I set the output to verbose, this is what the end of the log looks like:
Processing listfull.txt
gamelist line: < turn. Some games also have a "Flip Screen" DIP switch setting
to turn the>
rom name turn. not found in rom tree
Failed to find ssf.txt, no -movieloops 2 allowed!
Writing intermediate file listgen.tmp
Reading intermediate file into filter database
create temporary table gamedata ( romname varchar[12] unique primary key, full
_desc varchar[64], stripped_desc varchar[64] key, year varchar[4], manufactur
er varchar[80], screen varchar[24], orientation varchar[24], color varchar[24
], status varchar[24], sound varchar[24], control varchar[36], width integ
er, height integer, isclone integer, aspectx integer, aspecty integer, pla
yers integer, buttons integer, coins integer, sourcefile varchar[24], clone
of varchar[12], romof varchar[12], catver_category varchar[48], catver_veradd
ed varchar[48], nplayers_category varchar[32], gameplay_category varchar[32],
gameplay_layout varchar[32], gameplay_mnop integer, gameplay_nosp integer, r
efresh varchar[32], channels varchar[8], service varchar[8], tilt varchar[8],
gamelist_working varchar[8], gamelist_correct_colors varchar[8], gamelist_so
und varchar[8], gamelist_screen_flip varchar[8], movieloops integer, moviesta
rtframe integer, movieendframe integer, filler integer );
copy gamedata from 'listgen.tmp' using delimiters '|';
Filtering database into result.tmp
Writing game list to output.txt
What's the filtering step? I see a filter.sql do I need to modify it?
I think I'm missing something.
Thanks