http://wiki.linuxmce.org/index.php?title=Special:NewPages&feed=atom&hideredirs=1&limit=50&offset=&namespace=0&username=&tagfilter=
LinuxMCE - New pages [en]
2024-03-28T11:05:59Z
From LinuxMCE
MediaWiki 1.24.1
http://wiki.linuxmce.org/index.php/Game_Database_Schema
Game Database Schema
2017-06-04T03:55:12Z
<p>Tschak909: </p>
<hr />
<div>This is the proposed schema for the lmce_game database. As the first version was used as is between the first two Game Player versions, the new version of the schema will be called v2.<br />
<br />
As was before, this database is used to reconcile the possible metadata for game media found on a LinuxMCE system. <br />
<br />
== Goals ==<br />
<br />
The goals with this particular database schema are:<br />
<br />
* Deal with the differences between "Software List" based collections that are baked collections for a given emulator (e.g. MAME soft list), and loose ROMs.<br />
* Try to consolidate media metadata to cleaned sanitized titles utilizing hashes made from normalized strings<br />
* Consolidate and Handle multiple game systems<br />
<br />
== Tables ==<br />
<br />
The Database is comprised of the following tables:<br />
<br />
=== Attribute ===<br />
<br />
This stores the type of attributes to keep for media metadata.<br />
<br />
<pre><br />
CREATE TABLE Attribute (<br />
PK_Attribute INTEGER AUTO_INCREMENT NOT NULL,<br />
Description VARCHAR(128),<br />
Define VARCHAR(128),<br />
PRIMARY KEY(PK_Attribute)<br />
);<br />
</pre><br />
<br />
=== Emulator ===<br />
<br />
This table provides overall configuration data for a given emulator.<br />
<br />
<pre><br />
CREATE TABLE Emulator (<br />
PK_Emulator INTEGER AUTO_INCREMENT NOT NULL,<br />
Descripition VARCHAR(128),<br />
Define CHARCHAR(128),<br />
PRIMARY KEY(PK_Emulator)<br />
);<br />
</pre><br />
<br />
=== File ===<br />
<br />
This table is the entry point for a file, usually a ROM.<br />
<br />
<pre><br />
CREATE TABLE File (<br />
PK_File INTEGER AUTO_INCREMENT NOT NULL,<br />
Description VARCHAR(1024),<br />
SHA1_Hash UNIQUE CHAR(40),<br />
PRIMARY_KEY(PK_File),<br />
KEY(SHA1_Hash)<br />
);<br />
</pre><br />
<br />
=== GameSystem ===<br />
<br />
A Game System is a particular system that can play a given game. Examples, Arcade, Atari 2600, NES, Sega Master System, etc.<br />
<br />
<pre><br />
CREATE TABLE GameSystem (<br />
PK_GameSystem INTEGER AUTO_INCREMENT NOT NULL,<br />
Description VARCHAR(128),<br />
PRIMARY KEY(PK_GameSystem)<br />
);<br />
</pre></div>
Tschak909
http://wiki.linuxmce.org/index.php/MAME_Merged_or_Split_ROM_notes
MAME Merged or Split ROM notes
2017-06-04T02:25:06Z
<p>Tschak909: Created page with "Currently, MAME has the ability to store ROM information for not only the parent game, but for any child games that may derive from it; such as clones or bootlegs. == Merged..."</p>
<hr />
<div>Currently, MAME has the ability to store ROM information for not only the parent game, but for any child games that may derive from it; such as clones or bootlegs.<br />
<br />
== Merged ROM set == <br />
<br />
Given a ROM set, such as puckman.zip, which corresponds to a parent game of Burning Rubber, you have inside it:<br />
<br />
<pre><br />
Length Method Size Cmpr Date Time CRC-32 Name<br />
-------- ------ ------- ---- ---------- ----- -------- ----<br />
2048 Defl:X 1570 23% 1996-12-24 23:32 0b102302 abscam/as0.bin<br />
2048 Defl:X 1354 34% 1996-12-24 23:32 bc0281e0 abscam/as1.bin<br />
2048 Defl:X 872 57% 1996-12-24 23:32 81d50c98 abscam/as10.bin<br />
2048 Defl:X 692 66% 1996-12-24 23:32 9d802b68 abscam/as11.bin<br />
2048 Defl:X 1482 28% 1996-12-24 23:32 e05d46ad abscam/as2.bin<br />
2048 Defl:X 1387 32% 1996-12-24 23:32 b39eb940 abscam/as3.bin<br />
2048 Defl:X 1371 33% 1996-12-24 23:32 3116a8ec abscam/as4.bin<br />
256 Defl:X 72 72% 1996-12-24 23:32 1605b324 abscam/as4a.bin<br />
2048 Defl:X 1353 34% 1996-12-24 23:32 428ee2e8 abscam/as5.bin<br />
2048 Defl:X 1510 26% 1996-12-24 23:32 3ae9a8cb abscam/as6.bin<br />
2048 Defl:X 1388 32% 1996-12-24 23:32 16cf1c67 abscam/as7.bin<br />
2048 Defl:X 879 57% 1996-12-24 23:32 61daabe5 abscam/as8.bin<br />
2048 Defl:X 153 93% 1996-12-24 23:32 a3bd1613 abscam/as9.bin<br />
2048 Defl:X 1590 22% 1996-12-24 23:32 2c0fa0ab bucaner/buc1.6e<br />
2048 Defl:X 505 75% 1996-12-24 23:32 09f66dec bucaner/buc10.5f<br />
2048 Defl:X 626 69% 1996-12-24 23:32 e3861283 bucaner/buc11.5h<br />
2048 Defl:X 525 74% 1996-12-24 23:32 653314e7 bucaner/buc12.5j<br />
2048 Defl:X 1380 33% 1996-12-24 23:32 6b53ada9 bucaner/buc2.6f<br />
2048 Defl:X 1503 27% 1996-12-24 23:32 9045a44c bucaner/buc3.6h<br />
2048 Defl:X 1338 35% 1996-12-24 23:32 292de161 bucaner/buc4.6j<br />
2048 Defl:X 1266 38% 1996-12-24 23:32 afeca2f1 bucaner/buc5.6k<br />
2048 Defl:X 1352 34% 1996-12-24 23:32 35f3ca84 bucaner/buc6.6m<br />
2048 Defl:X 1458 29% 1996-12-24 23:32 888f3c3e bucaner/buc7.6n<br />
2048 Defl:X 785 62% 1996-12-24 23:32 884af858 bucaner/buc8.6p<br />
2048 Defl:X 620 70% 1996-12-24 23:32 4060c077 bucaner/buc9.5e<br />
2048 Defl:X 1314 36% 1996-12-24 23:32 bed4a077 crockman/p4.6j<br />
2048 Defl:X 1460 29% 1996-12-24 23:32 93f344c5 crockman/p7.6n<br />
2048 Defl:X 816 60% 1996-12-24 23:32 800be41e crockman/p8.6p<br />
2048 Defl:X 629 69% 1996-12-24 23:32 a10218c4 crockman/p9.5e<br />
2048 Defl:X 1591 22% 1996-12-24 23:32 9d027c4a ctrpllrp/c1.bin<br />
2048 Defl:X 839 59% 1996-12-24 23:32 ba9ec199 ctrpllrp/c10.bin<br />
2048 Defl:X 637 69% 1996-12-24 23:32 46f72fef ctrpllrp/c11.bin<br />
2048 Defl:X 818 60% 1996-12-24 23:32 41c09655 ctrpllrp/c12.bin<br />
2048 Defl:X 1380 33% 1996-12-24 23:32 afa149a8 ctrpllrp/c2.bin<br />
2048 Defl:X 1507 26% 1996-12-24 23:32 6bb282a1 ctrpllrp/c3.bin<br />
2048 Defl:X 1325 35% 1996-12-24 23:32 86c91e0e ctrpllrp/c4.bin<br />
2048 Defl:X 1398 32% 1996-12-24 23:32 f39846d3 ctrpllrp/c5.bin<br />
2048 Defl:X 1424 31% 1996-12-24 23:32 baf5461e ctrpllrp/c6.bin<br />
2048 Defl:X 1510 26% 1996-12-24 23:32 fa2140f5 ctrpllrp/c7.bin<br />
2048 Defl:X 1145 44% 1996-12-24 23:32 3d28134e ctrpllrp/c8.bin<br />
2048 Defl:X 627 69% 1996-12-24 23:32 1c4617be ctrpllrp/c9.bin<br />
2048 Defl:X 631 69% 1996-12-24 23:32 44a45b72 ghostmun/blpac10b<br />
2048 Defl:X 881 57% 1996-12-24 23:32 ab88b2c4 ghostmun/blpac11b<br />
2048 Defl:X 797 61% 1996-12-24 23:32 b2ed320b ghostmun/blpac12b<br />
2048 Defl:X 783 62% 1996-12-24 23:32 fa84659f ghostmun/blpac9b<br />
32 Defl:X 35 -9% 1996-12-24 23:32 759647e3 ghostmun/ghostmun.clr<br />
4096 Defl:X 2867 30% 1996-12-24 23:32 19338c70 ghostmun/pac1.bin<br />
4096 Defl:X 2712 34% 1996-12-24 23:32 18db074d ghostmun/pac2.bin<br />
4096 Defl:X 2880 30% 1996-12-24 23:32 abb98b1d ghostmun/pac3.bin<br />
4096 Defl:X 2246 45% 1996-12-24 23:32 2403c78e ghostmun/pac4.bin<br />
4096 Defl:X 2891 29% 1996-12-24 23:32 5fe8610a hangly/hangly.6e<br />
4096 Defl:X 2736 33% 1996-12-24 23:32 73726586 hangly/hangly.6f<br />
4096 Defl:X 2912 29% 1996-12-24 23:32 4e7ef99f hangly/hangly.6h<br />
4096 Defl:X 2317 43% 1996-12-24 23:32 7f4147e6 hangly/hangly.6j<br />
4096 Defl:X 1257 69% 1996-12-24 23:32 0c944964 hangly/pacman.5e<br />
4096 Defl:X 1149 72% 1996-12-24 23:32 958fedf9 hangly/pacman.5f<br />
2048 Defl:X 1377 33% 1996-12-24 23:32 5ba228bb hangly2/hangly2.6f<br />
2048 Defl:X 1327 35% 1996-12-24 23:32 51305374 hangly2/hangly2.6j<br />
2048 Defl:X 1123 45% 1996-12-24 23:32 427c9d4d hangly2/hangly2.6p<br />
4096 Defl:X 1205 71% 1996-12-24 23:32 299fb17a hangly2/pacmanh.5e<br />
2048 Defl:X 1504 27% 1996-12-24 23:32 08419c4a hangly3/hm3.6h<br />
2048 Defl:X 1325 35% 1996-12-24 23:32 5039b082 hangly3/hm4.6j<br />
2048 Defl:X 1400 32% 1996-12-24 23:32 194c7189 hangly3/hm5.6k<br />
2048 Defl:X 1509 26% 1996-12-24 23:32 ab74b51f hangly3/hm7.6n<br />
2048 Defl:X 1121 45% 1996-12-24 23:32 931770d7 hangly3/hm8.6p<br />
2048 Defl:X 583 72% 1996-12-24 23:32 5f4be3cc hangly3/hm9.5e<br />
2048 Defl:X 1587 23% 1996-12-24 23:32 d844b679 joyman/joy1.6e<br />
2048 Defl:X 674 67% 1996-12-24 23:32 338771a6 joyman/joy10.5f<br />
2048 Defl:X 706 66% 1996-12-24 23:32 33e0289e joyman/joy11.5h<br />
2048 Defl:X 625 70% 1996-12-24 23:32 f4f0add5 joyman/joy12.5j<br />
2048 Defl:X 1292 37% 1996-12-24 23:32 00b553f8 joyman/joy4.6j<br />
2048 Defl:X 1269 38% 1996-12-24 23:32 ab9c8f29 joyman/joy5.6k<br />
2048 Defl:X 1357 34% 1996-12-24 23:32 b3c8d32e joyman/joy6.6m<br />
2048 Defl:X 788 62% 1996-12-24 23:32 5d5ce992 joyman/joy8.6p<br />
2048 Defl:X 578 72% 1996-12-24 23:32 39b557bc joyman/joy9.5e<br />
2048 Defl:X 572 72% 1996-12-24 23:32 ca8c184c newpuc2/5f.cpu<br />
2048 Defl:X 704 66% 1996-12-24 23:32 777c70d3 newpuc2/5h.cpu<br />
2048 Defl:X 572 72% 1996-12-24 23:32 7dc75a81 newpuc2/5j.cpu<br />
2048 Defl:X 1587 23% 1996-12-24 23:32 69496a98 newpuc2/6e.cpu<br />
2048 Defl:X 1507 26% 1996-12-24 23:32 81719de8 newpuc2/6h.cpu<br />
2048 Defl:X 1328 35% 1996-12-24 23:32 e6675736 newpuc2/6j.cpu<br />
2048 Defl:X 1331 35% 1996-12-24 23:32 158fc01c newpuc2/6k.cpu<br />
2048 Defl:X 1419 31% 1996-12-24 23:32 70810ccf newpuc2/6m.cpu<br />
2048 Defl:X 1486 27% 1996-12-24 23:32 3f250c58 newpuc2/6n.cpu<br />
2048 Defl:X 1083 47% 1996-12-24 23:32 1f81e765 newpuc2/6p.cpu<br />
2048 Defl:X 1505 27% 1996-12-24 23:32 f5e4b2b1 newpuc2b/np2b3.bin<br />
2048 Defl:X 1333 35% 1996-12-24 23:32 f068e009 newpuc2b/np2b4.bin<br />
2048 Defl:X 1080 47% 1996-12-24 23:32 1fadcc2f newpuc2b/np2b8.bin<br />
4096 Defl:X 2664 35% 1996-12-24 23:32 1a6fb2d4 newpuckx/pacman.6f<br />
4096 Defl:X 2758 33% 1996-12-24 23:32 a8ae23c5 newpuckx/puckman.6e<br />
4096 Defl:X 2864 30% 1996-12-24 23:32 197443f8 newpuckx/puckman.6h<br />
4096 Defl:X 2103 49% 1996-12-24 23:32 2e64a3ba newpuckx/puckman.6j<br />
65536 Defl:X 2798 96% 1996-12-24 23:32 70941a50 pac90/char.ic85<br />
32768 Defl:X 11140 66% 1996-12-24 23:32 8af34306 pac90/rom1.ic87<br />
65536 Defl:X 677 99% 1996-12-24 23:32 bc9bfdf2 pac90/rom2.ic67<br />
65536 Defl:X 1201 98% 1996-12-24 23:32 1c4d17fd pac90/rom3.ic54<br />
65536 Defl:X 1685 97% 1996-12-24 23:32 190852ea pac90/sprite1.ic50<br />
65536 Defl:X 1696 97% 1996-12-24 23:32 33effbea pac90/sprite2.ic60<br />
65536 Defl:X 51156 22% 1996-12-24 23:32 abc61f3d pac90/voice.ic82<br />
2048 Defl:X 579 72% 1996-12-24 23:32 c62bbabf pacheart/pacheart.ch1<br />
2048 Defl:X 1285 37% 1996-12-24 23:32 b9152a38 pacheart/pacheart.pg2<br />
2048 Defl:X 1362 34% 1996-12-24 23:32 842d6574 pacheart/pacheart.pg4<br />
2048 Defl:X 1332 35% 1996-12-24 23:32 f5265c10 pacheart/pacheart.pg7<br />
2048 Defl:X 814 60% 1996-12-24 23:32 1a21a381 pacheart/pacheart.pg8<br />
4096 Defl:X 2742 33% 1996-12-24 23:32 c1e6ab10 pacman/pacman.6e<br />
4096 Defl:X 2865 30% 1996-12-24 23:32 bcdd1beb pacman/pacman.6h<br />
4096 Defl:X 2234 46% 1996-12-24 23:32 817d94e3 pacman/pacman.6j<br />
2048 Defl:X 1592 22% 1996-12-24 23:32 6718df42 pacmanbl/1<br />
2048 Defl:X 1354 34% 1996-12-24 23:32 33be3648 pacmanbl/2<br />
2048 Defl:X 1373 33% 1996-12-24 23:32 f98c0ceb pacmanbl/3<br />
2048 Defl:X 1407 31% 1996-12-24 23:32 a9cd0082 pacmanbl/4<br />
2048 Defl:X 1446 29% 1996-12-24 23:32 6d475afc pacmanbl/5<br />
2048 Defl:X 1477 28% 1996-12-24 23:32 cbe863d3 pacmanbl/6<br />
2048 Defl:X 1109 46% 1996-12-24 23:32 7daef758 pacmanbl/7<br />
32 Defl:X 35 -9% 1996-12-24 23:32 24652bc4 pacmanbl/sn74s288n.6l<br />
4096 Defl:X 2971 28% 1996-12-24 23:32 75e4f967 pacmanbla/rom1.bin<br />
4096 Defl:X 2783 32% 1996-12-24 23:32 5b2e4293 pacmanbla/rom2.bin<br />
4096 Defl:X 2477 40% 1996-12-24 23:32 c06e30a4 pacmanbla/rom3.bin<br />
4096 Defl:X 1427 65% 1996-12-24 23:32 592b4ba8 pacmanbla/rom4.bin<br />
4096 Defl:X 1350 67% 1996-12-24 23:32 f2d8c01e pacmanbla/rom5.bin<br />
4096 Defl:X 1560 62% 1996-12-24 23:32 346a1720 pacmanbla/rom6.bin<br />
32 Defl:X 33 -3% 1996-12-24 23:32 4e3caeab pacmanblb/MB7051.6L<br />
2048 Defl:X 1501 27% 1996-12-24 23:32 d1542234 pacmanblb/MOON1<br />
2048 Defl:X 1592 22% 1996-12-24 23:32 06b60bca pacmanblb/MOON2<br />
2048 Defl:X 1115 46% 1996-12-24 23:32 93d22cee pacmanblb/MOON3<br />
2048 Defl:X 1355 34% 1996-12-24 23:32 88eca6fb pacmanblb/MOON4<br />
2048 Defl:X 1373 33% 1996-12-24 23:32 cf25a673 pacmanblb/MOON5<br />
2048 Defl:X 1408 31% 1996-12-24 23:32 86230500 pacmanblb/MOON6<br />
2048 Defl:X 1446 29% 1996-12-24 23:32 287fcbe0 pacmanblb/MOON7<br />
4096 Defl:X 2665 35% 1996-12-24 23:32 720dc3ee pacmanf/pacfast.6f<br />
2048 Defl:X 1309 36% 1996-12-24 23:32 258580a2 pacmanjpm/jpm4<br />
2048 Defl:X 772 62% 1996-12-24 23:32 b4d7ee8c pacmanjpm/jpm8<br />
2048 Defl:X 1593 22% 1996-12-24 23:32 183d235a pacmanpe/come1.6e<br />
2048 Defl:X 1499 27% 1996-12-24 23:32 cc92abb1 pacmanpe/come3.6h<br />
2048 Defl:X 1304 36% 1996-12-24 23:32 a02ce07f pacmanpe/come4.6j<br />
2048 Defl:X 1412 31% 1996-12-24 23:32 2771c530 pacmanpe/come5.6k<br />
2048 Defl:X 1463 29% 1996-12-24 23:32 8810b38e pacmanpe/come7.6n<br />
2048 Defl:X 811 60% 1996-12-24 23:32 34e9566d pacmanpe/come8.6p<br />
2048 Defl:X 573 72% 1996-12-24 23:32 2229ab07 pacmanpe/come9.5e<br />
2048 Defl:X 1599 22% 1996-12-24 23:32 76dbed21 pacmanso/PM-1R.6E<br />
2048 Defl:X 1500 27% 1996-12-24 23:32 a5af382c pacmanso/PM-3R.6H<br />
2048 Defl:X 1315 36% 1996-12-24 23:32 cd03135a pacmanso/PM-4R.6J<br />
2048 Defl:X 1384 32% 1996-12-24 23:32 965bb9b2 pacmanso/PM-5R.6K<br />
2048 Defl:X 1444 30% 1996-12-24 23:32 fb397ced pacmanso/PM-8R.6P<br />
2048 Defl:X 617 70% 1996-12-24 23:32 2ee076d2 pacmanso/PM-9S.5E<br />
32768 Defl:X 14380 56% 1996-12-24 23:32 f2404b4d pacmansp/1.bin<br />
8192 Defl:X 2250 73% 1996-12-24 23:32 7a75b696 pacmansp/2.bin<br />
4096 Defl:X 2744 33% 1996-12-24 23:32 3b2ec270 pacmod/pacmanh.6e<br />
4096 Defl:X 2866 30% 1996-12-24 23:32 18811780 pacmod/pacmanh.6h<br />
4096 Defl:X 2234 46% 1996-12-24 23:32 5c96a733 pacmod/pacmanh.6j<br />
2048 Defl:X 1582 23% 1996-12-24 23:32 ec8c1ed8 pacuman/pacuman01.bin<br />
2048 Defl:X 1236 40% 1996-12-24 23:32 40edaf56 pacuman/pacuman02.bin<br />
2048 Defl:X 1377 33% 1996-12-24 23:32 db4f702b pacuman/pacuman03.bin<br />
2048 Defl:X 1351 34% 1996-12-24 23:32 28f7257d pacuman/pacuman04.bin<br />
2048 Defl:X 1504 27% 1996-12-24 23:32 212acb41 pacuman/pacuman05.bin<br />
2048 Defl:X 1474 28% 1996-12-24 23:32 e73dd1b9 pacuman/pacuman06.bin<br />
2048 Defl:X 1313 36% 1996-12-24 23:32 908a2cb2 pacuman/pacuman07.bin<br />
2048 Defl:X 803 61% 1996-12-24 23:32 cf4ba26c pacuman/pacuman08.bin<br />
2048 Defl:X 1569 23% 1996-12-24 23:32 69a3e6ea piranha/pir1.bin<br />
2048 Defl:X 292 86% 1996-12-24 23:32 d19399fb piranha/pir10.bin<br />
2048 Defl:X 854 58% 1996-12-24 23:32 5f8bdabe piranha/pir11.bin<br />
2048 Defl:X 627 69% 1996-12-24 23:32 cfb4403d piranha/pir12.bin<br />
2048 Defl:X 1376 33% 1996-12-24 23:32 62cb6954 piranha/pir2.bin<br />
2048 Defl:X 1488 27% 1996-12-24 23:32 843fbfe5 piranha/pir3.bin<br />
2048 Defl:X 1421 31% 1996-12-24 23:32 4cdf6704 piranha/pir4.bin<br />
2048 Defl:X 1379 33% 1996-12-24 23:32 245e753f piranha/pir5.bin<br />
2048 Defl:X 1352 34% 1996-12-24 23:32 cb0700bc piranha/pir6.bin<br />
2048 Defl:X 1460 29% 1996-12-24 23:32 73084d5e piranha/pir7.bin<br />
2048 Defl:X 1313 36% 1996-12-24 23:32 b86fedb3 piranha/pir8.bin<br />
2048 Defl:X 875 57% 1996-12-24 23:32 0f19eb28 piranha/pir9.bin<br />
256 Defl:X 70 73% 1996-12-24 23:32 08c9447b piranha/piranha.4a<br />
4096 Defl:X 2861 30% 1996-12-24 23:32 bc5ad024 piranhah/pr1.cpu<br />
4096 Defl:X 2869 30% 1996-12-24 23:32 473c379d piranhah/pr3.cpu<br />
4096 Defl:X 2125 48% 1996-12-24 23:32 63fbf895 piranhah/pr4.cpu<br />
2048 Defl:X 735 64% 1996-12-24 23:32 3fc4030c piranhah/pr5.cpu<br />
2048 Defl:X 252 88% 1996-12-24 23:32 f3e9c9d5 piranhah/pr6.cpu<br />
2048 Defl:X 790 61% 1996-12-24 23:32 30b9a010 piranhah/pr7.cpu<br />
2048 Defl:X 542 74% 1996-12-24 23:32 133d720d piranhah/pr8.cpu<br />
2048 Defl:X 1592 22% 1996-12-24 23:32 c6ce1bfc piranhao/p1.bin<br />
2048 Defl:X 251 88% 1996-12-24 23:32 84165a2c piranhao/p10.bin<br />
2048 Defl:X 857 58% 1996-12-24 23:32 a3606973 piranhao/p11.bin<br />
2048 Defl:X 584 72% 1996-12-24 23:32 2699ba9e piranhao/p12.bin<br />
2048 Defl:X 1419 31% 1996-12-24 23:32 9363a4d1 piranhao/p4.bin<br />
2048 Defl:X 1374 33% 1996-12-24 23:32 a2655a33 piranhao/p5.bin<br />
2048 Defl:X 1324 35% 1996-12-24 23:32 2769979c piranhao/p8.bin<br />
2048 Defl:X 814 60% 1996-12-24 23:32 94eb7563 piranhao/p9.bin<br />
32 Defl:X 21 34% 1996-12-24 23:32 2fc650bd pm1-1.7f<br />
256 Defl:X 23 91% 1996-12-24 23:32 77245b66 pm1-2.3m<br />
256 Defl:X 136 47% 1996-12-24 23:32 a9cc86bf pm1-3.1m<br />
256 Defl:X 70 73% 1996-12-24 23:32 3eb3a8e4 pm1-4.4a<br />
2048 Defl:X 616 70% 1996-12-24 23:32 2066a0b7 pm1_chg1.5e<br />
2048 Defl:X 639 69% 1996-12-24 23:32 3591b89d pm1_chg2.5h<br />
2048 Defl:X 622 70% 1996-12-24 23:32 9e39323a pm1_chg3.5f<br />
2048 Defl:X 572 72% 1996-12-24 23:32 1b1d9096 pm1_chg4.5j<br />
2048 Defl:X 1589 22% 1996-12-24 23:32 f36e88ab pm1_prg1.6e<br />
2048 Defl:X 1250 39% 1996-12-24 23:32 618bd9b3 pm1_prg2.6k<br />
2048 Defl:X 1376 33% 1996-12-24 23:32 7d177853 pm1_prg3.6f<br />
2048 Defl:X 1352 34% 1996-12-24 23:32 d3e8914c pm1_prg4.6m<br />
2048 Defl:X 1504 27% 1996-12-24 23:32 6bf4f625 pm1_prg5.6h<br />
2048 Defl:X 1460 29% 1996-12-24 23:32 a948ce83 pm1_prg6.6n<br />
2048 Defl:X 1315 36% 1996-12-24 23:32 b6289b26 pm1_prg7.6j<br />
2048 Defl:X 816 60% 1996-12-24 23:32 17a88c13 pm1_prg8.6p<br />
2048 Defl:X 713 65% 1996-12-24 23:32 014fb5a4 popeyeman/pop10.5f<br />
2048 Defl:X 665 68% 1996-12-24 23:32 21b91c64 popeyeman/pop12.5j<br />
2048 Defl:X 628 69% 1996-12-24 23:32 b569c4c1 popeyeman/pop9.5e<br />
4096 Defl:X 2759 33% 1996-12-24 23:32 fee263b3 puckmanb/namcopac.6e<br />
4096 Defl:X 2667 35% 1996-12-24 23:32 39d1fc83 puckmanb/namcopac.6f<br />
4096 Defl:X 2865 30% 1996-12-24 23:32 02083b03 puckmanb/namcopac.6h<br />
4096 Defl:X 2080 49% 1996-12-24 23:32 7a36fe55 puckmanb/namcopac.6j<br />
4096 Defl:X 2668 35% 1996-12-24 23:32 51b38db9 puckmanf/nampfast.6f<br />
4096 Defl:X 2737 33% 1996-12-24 23:32 61d38c6c puckmanh/pm02.6f<br />
4096 Defl:X 2339 43% 1996-12-24 23:32 8939ddd2 puckmanh/pm04.6j<br />
4096 Defl:X 2079 49% 1996-12-24 23:32 7d98d5f5 puckmod/npacmod.6j<br />
-------- ------- --- -------<br />
947584 359941 62% 213 files<br />
<br />
</pre><br />
<br />
Notice the different subdirectories with names like abscam, and popeyeman. These are different variations of the game, which also have different ROM labeling (MAME's policy is to always match the labeling of the ROMs on the board)...<br />
<br />
This is called the merged variation of a ROM.<br />
<br />
== Split ROM set ==<br />
<br />
Whereas, in the split form, one may have ROM ZIPs with each of the games, and their clones as seperate files, such as puckman.zip, abscam.zip, popeyeman.zip, npacmod.zip, and so on, each containing a flat set of ROMs for that specific game. This form is called a "split" ROM archive.<br />
<br />
== How to solve Ingestion ==<br />
<br />
The only clean way to solve inROMgestion here, is to literally have a relationship where one Rom entry in the game database may reference multiple individual Games. This way, we can catch on a file content hash and use appropriately.<br />
<br />
== Important other pages ==<br />
<br />
[[Game Database Schema]]</div>
Tschak909
http://wiki.linuxmce.org/index.php/Install_Test_in_VM_-_Xenial_amd64_-_2017-05-17
Install Test in VM - Xenial amd64 - 2017-05-17
2017-05-17T22:52:45Z
<p>Tschak909: /* Diskless Creation */</p>
<hr />
<div>== System setup ==<br />
* VMWare 12<br />
* Amd64<br />
* 8GB RAM<br />
* 40GB system disk<br />
* NIC 0: Public (VMNet0) bridged to main network Detected as ens33<br />
* NIC 1: Private (VMNet1) (192.168.80.0/24) set up as private network, detected as ens34 <br />
* USB 3.0 hub<br />
* OS: Xenial 16.04 Server<br />
* Installed as: Core<br />
<br />
== Installation Status ==<br />
<br />
Install was OK, no errors during package install. EDIT: (None of the database tables were created)<br />
<br />
== Web admin user creation ==<br />
<br />
Failed with HTTP Error 500, due to: <br />
<pre><br />
[Wed May 17 15:34:47.833416 2017] [:error] [pid 1948] [client 192.168.1.16:60517] PHP Warning: mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost' in /var/www/lmce-admin/include/adodb/drivers/adodb-mysqli.inc.php on line 124<br />
[Wed May 17 15:34:47.833466 2017] [:error] [pid 1948] [client 192.168.1.16:60517] PHP Fatal error: mysqli error: [1698: Access denied for user 'root'@'localhost'] in CONNECT(localhost, '****', '****', pluto_main)\n in /var/www/lmce-admin/include/adodb/adodb-errorhandler.inc.php on line 79<br />
</pre><br />
<br />
I previously was able to get around this by issuing a CREATE USER root@localhost; but this no longer works.<br />
<br />
== Diskless Creation ==<br />
<br />
Diskless_CreateTBZ still hard-creates i386 images. At the very least, amd64 images should be created on amd64 hosts, and ideally, both i386 and amd64 images should be built when Diskless_CreateTBZ.sh is called.<br />
Diskless_CreateTBZ seems to create without incident, however since I can't get into the web admin, can't do much more beyond this. EDIT: Damn it, spoke too soon: Log pasted here: http://paste.ubuntu.com/24595723/<br />
<br />
== Conclusion ==<br />
<br />
Build seems to be blocked due to database permission issues. (using -uroot as non-root user causes an access denied).<br />
<br />
== Installation Log ==<br />
<br />
Installation Log can be found here: http://paste.ubuntu.com/24595671/<br />
<br />
--[[User:Tschak909|Tschak909]] ([[User talk:Tschak909|talk]]) 22:52, 17 May 2017 (UTC)</div>
Tschak909
http://wiki.linuxmce.org/index.php/LniuxMCE_Regression_Testing
LniuxMCE Regression Testing
2017-04-19T21:44:36Z
<p>Tschak909: Initial content.</p>
<hr />
<div>== Automated Regression Testing for LinuxMCE ==<br />
<br />
* Use Vagrant for machine bring-up, down.<br />
* Implement virtual sound card to file, and use VNC perhaps to do automated snapshots.</div>
Tschak909
http://wiki.linuxmce.org/index.php/Intel_NUC
Intel NUC
2017-04-02T06:51:56Z
<p>Tschak909: Initial NUC content.</p>
<hr />
<div>== Intel NUC ==<br />
<br />
The Intel NUC are a line of mini-ITX computers intended to be used in embedded applications, such as small desktops, kiosks, media center PCs, and various other use cases. They consist of a single board, containing an embedded CPU (ranging from an N series celeron, to an Intel i7), two SO-DIMM slots for memory, mobile PCI-E slots for inserting SSD devices, and a variety of the usual suspects of I/O connectors. The NUC can either come in board form, or complete with a cube-like enclosure.<br />
<br />
LinuxMCE supports various NUC incarnations, and notes for different models are below.<br />
<br />
=== NUC 54250WYK ===<br />
<br />
This NUC is an i5 based model, and works great with LinuxMCE, with the following tweaks:<br />
<br />
==== /tftpboot/pxelinux.cfg/default ====<br />
<br />
On the core, make the following changes to the 'default' boot file, after you've generated the diskless image with /usr/pluto/bin/Diskless_CreateTBZ.sh<br />
<br />
* remove '''acpi=off''' from the kernel options line, as ACPI is required to enumerate and initialize the e1000 the network card correctly.<br />
<br />
==== Enabling the IR remote control support ====<br />
<br />
* Inside the BIOS, ensure that the nuvoton-cir IR receiver is enabled, and that RC6 remote control support is enabled if you want to use a Windows media center remote.<br />
* Inside the web admin, go to Wizard > Media Directors, and scroll to your NUC media director.<br />
** Select "default" from Infra-red receivers<br />
** Press Add Remote<br />
** Select Template #1622 (Windows XP MC Remote) or a suitable remote from the LIRC Remotes category.<br />
** Press Update<br />
** Quick reload router<br />
<br />
Your remote should now be ready for use.</div>
Tschak909
http://wiki.linuxmce.org/index.php/Slimme_Meter
Slimme Meter
2016-12-23T14:49:05Z
<p>Dap-P: New page for DT 2347</p>
<hr />
<div>== Dutch Smart Energy Meter (Slimme Meter) ==<br />
<br />
=== Contents ===<br />
1 Short Description<br />
<br />
2 Hardware<br />
<br />
3 Software<br />
<br />
=== Short Description ===<br />
In the Netherlands it is very common to have a smart energy meter. This meter measures all electricity and gas usage in the home. On this meter is an interface for the customer.<br />
This interface can be connected via a serial interface to the LMCE Core and all data can be logged.<br />
<br />
There are some differences between different manufacturers of these meters, this information can be widely found on the internet.<br />
<br />
=== Hardware ===<br />
The serial interface on the meter is mostly rs232, but the tx is inversed. I have used an arduino as a converter to interface with the meter with 9600 baud, 7 bits, with parity, to the LMCE core on 9600 baud 8 bits, and no parity. There is a lot of information on how to connect onthe internet, just use google.<br />
<br />
This is my arduino code. <br />
3 wire should be connected, RTS = pin 4, Data on pin 10, and ground.<br />
<br />
<blockquote><br />
.#include <SoftwareSerial.h><br><br />
const int requestPin = 4;<br><br />
int incomingByte = 0;<br><br />
String inputString = "";<br><br />
boolean start_p1_record;<br><br />
boolean data_ready = false;<br><br />
<br><br />
SoftwareSerial mySerial(10, 11, true); // RX, TX, inverted, buffer<br><br />
<br><br />
void setup () {<br><br />
mySerial.begin(9600);<br><br />
delay(1);<br><br />
Serial.begin(9600);<br><br />
<br><br />
Serial.println("P1 Smart meter reading - START\n");<br><br />
<br><br />
pinMode(requestPin, OUTPUT);<br><br />
digitalWrite(requestPin, HIGH);<br><br />
}<br><br />
<br><br />
void loop () {<br><br />
while (mySerial.available() > 0) {<br><br />
<br> <br />
incomingByte = mySerial.read();<br><br />
incomingByte &= ~(1 << 7);<br><br />
char inChar = (char)incomingByte;<br><br />
Serial.print(inChar);<br><br />
}<br><br />
<br><br />
}<br><br />
</blockquote><br />
<br />
=== Software ===<br />
Its probably a good idea to have the Datalogger plugin installed on your core.<br />
<br />
To install the device for the Smart Energy Meter open the webadmin, Advanced, Configuration, Devices. Select the Core and click Create Child Device, Pick Device Template, and use DT 2347.<br />
<br />
Now all is finished, and the energy usage is monitored, the data can be seen via Data Logger.</div>
Dap-P