## SET LABELS WITH DATABASE DATA (example 3 fields)

### ADD TO GUI > 3 rows and 2 columns with items:

Items:

- Static labels (left side)

infotablblperspective

infotablblvisual

infotablblgameplay

- Data labels (right side)

medianbinfoperspective_

medianbinfovisual_

medianbinfogameplay_

### TRANSLATE GUI STATIC LABELS

- Add labels to translation file

Edit file: ecc-system\translations[LANGUAGE]\i18n_meta.php, around line 8440, in the META array, add:

    /* 1.2.0 */
    'lbl_perspective' =>
        "Perspectief",
    'lbl_visual' =>
        "Visueel",
    'lbl_gameplay' =>
        "Gameplay",

- Load Labels from translation file(s)

Edit file: ecc-system\ecc.php, around line 8440, add:

$this->setSpanMarkup($this->infotablblperspective, I18N::get('meta', 'lblperspective'), false, 'b', false); $this->setSpanMarkup($this->infotablblvisual, I18N::get('meta', 'lblvisual'), false, 'b', false); $this->setSpanMarkup($this->infotablblgameplay, I18N::get('meta', 'lbl_gameplay'), false, 'b', false);

### FILL GUI LABELS WITH DATA

Edit file: ecc-system\ecc.php, around line 3085, add:

$this->setSpanMarkup($this->medianbinfoperspective, $romMeta->getPerspective()); $this->setSpanMarkup($this->medianbinfovisual, $romMeta->getVisual()); $this->setSpanMarkup($this->medianbinfo_gameplay, $romMeta->getGameplay());

### ADD COLUMN TO ROM METADATA CHECKSUM

Edit file: ecc-system\manager\model\RomMeta.php, around line 130 ($checksumInclude array), add:

    'perspective',
    'visual',
    'gameplay',

### GET METADATA FROM DATABASE

around line 386 (function fillFromDatabase), add:

    $this->setPerspective($dbEntry['md_perspective']);
    $this->setVisual($dbEntry['md_visual']);
    $this->setGameplay($dbEntry['md_gameplay']);

### ADD NEW DATA TO SQL FIELDS

Edit file: ecc-system\manager\cTreeviewData.php, around line 60 ($sqlFields), add:

    md.perspective as md_perspective,
    md.visual as md_visual,
    md.gameplay as md_gameplay,