<?php
if(isset($_GET['error'])){
    ini_set('display_errors', 1);
    ini_set('display_startup_errors', 1);
    error_reporting(E_ALL);
}

date_default_timezone_set('America/Montreal');

$servername = "10.0.0.15";
$username = "occash_trans";
$password = "k7rA63F4R@;*66h3u3((7@^#gnz*v2/rU";
$dbname = "occash_transerotica";

$conn = new mysqli($servername, $username, $password, $dbname);

//Latest Scenes
$query = "SELECT * FROM plg_gb_galleries";

$galleries = $conn->query($query);
$gallery_array = array();

while($gallery = $galleries->fetch_assoc())
{

    $query2 = "SELECT * FROM plg_gb_galleries_extrafields WHERE  GalleryId =" . $gallery['Id'];
    $result = $conn->query($query2);
    while($gall = $result->fetch_assoc()) {
        if($gall['ExtrafieldsId'] === 3){
            $type = 'url';
        } elseif ($gall['ExtrafieldsId'] === 4) {
            $type = 'thumbnail';
        } elseif ($gall['ExtrafieldsId'] === 10) {
            $type = 'tags';
        } elseif ($gall['ExtrafieldsId'] === 13) {
            $type = 'title';=
        } elseif ($gall['ExtrafieldsId'] === 6) {
            $type = 'description';
        }
        elseif ($gall['ExtrafieldsId'] === 6){

        }
        else {
            continue;
        }

        $gallery_array[$gallery['Id']][$type] = $gall['Value'];
    }
     $gallery_array[$gallery['Id']]['ReleaseDate'] = $gallery['ReleaseDate'];
     $gallery_array[$gallery['Id']]['SiteId'] = $gallery['SiteId'];
     $gallery_array[$gallery['Id']]['site'] = getNatsSite($gallery['SiteId']);
}

echo json_encode($gallery_array);


function getNatsSite($siteId){
    switch ($siteId) {
        case '2':
            $site = "nataliemars.xxx";
            break;

        default:
            $site = "transerotica.com";
            break;
    }
    return $site;
}