<?php

	require_once 'config.php';

    class default_system {

        function __construct( $pdo ) {

            $this->pdo = $pdo;

        }

        function getData() {

			$ID 	= $_GET[ 'id' ];

			$Niche 	= "clash-clans";

			$query = $this->pdo->prepare( "SELECT * FROM `affiliates` WHERE `Network_Code` = ':id' AND `Niche` = ':niche'" );
			$query->bindValue( ':id', $ID, PDO::PARAM_INT );
			$query->bindValue( ':niche', $Niche, PDO::PARAM_STR );
			$query->execute();

			return $query->fetchAll(); // Return an Array of objects

        }

    }

	/*  Default System Settings
		column->ID 					=> A/I ID
		column->Niche 				=> Niche Name
		column->Language 			=> Language of Landing Page ( en/fr )
		column->lockerURL 			=> Title of Generator
		column->Google_ID			=> Google Analytics
	*/
	$db_system = new default_system( $pdo );
	$system_default = $db_system->getData();

	echo $system_default->lockerURL;

?>