<?php


$servername = "localhost";
$username = "root";
$password = "";
$databaseName = "KGB";

// Create connection
$conn = new mysqli($servername, $username, $password, $databaseName);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


$name = $_POST['name'];
$DummyURL = $_POST['DummyURL'];
$url_lpu = $_POST['url_lpu'];
$url_image =  $_POST['url_image'];
$Creative = $_POST['Creative'];
$w = $_POST['w'];
$h = $_POST['h'];
$autoredirect = $_POST['autoredirect'];
$device = $_POST['Device'];


$coolFunctions = new CoolFunctionsModel();
$key = $coolFunctions->create_guid();

#$sql = "INSERT INTO KGB (Campaign,DummyURL,ActionURL,Creative) VALUES('$Campaign','$DummyURL','$ActionURL','$Creative')";
$sql = "INSERT INTO campaigns (name,DummyURL,url_image,url_lpu,w,h,campaign_key,autoredirect,device) VALUES ('$name','$DummyURL', '$url_image', '$url_lpu', '$w', '$h','$key','$autoredirect','$device');";

if ($conn->query($sql) === TRUE) {
    echo "$name";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

#$conn->query($sql);



class CoolFunctionsModel {


	public function formatPrice($p) {

		return number_format($p, 2, ',', '.');

	}

	public function formatNumber($n) {

		return number_format($n, 0, ',', '.');

	}

	public function getCTR($views, $clicks) {

		if($views == 0) {
			$ctr = 0;
		} else {
			$ctr = ($clicks/$views)*100;
		}
		return $ctr;

	}

	public function getECPM($views, $cost) {

		return ($cost/$views)*1000;

	}

	public function formatDate($date, $type) {

		return date($type, strtotime($date));

	}

	public function parseDateToTimestamp($date) {

		$datum = explode(".",$date);
		return $datum[2]."-".$datum[1]."-".$datum[0];

	}

	function generatePW($length=8)
	{

		$dummy	= array_merge(range('0', '9'), range('a', 'z'), range('A', 'Z'), array('#','&','@','$','_','%','?','+'));

		// shuffle array

		mt_srand((double)microtime()*1000000);

		for ($i = 1; $i <= (count($dummy)*2); $i++)
		{
		$swap		= mt_rand(0,count($dummy)-1);
		$tmp		= $dummy[$swap];
		$dummy[$swap]	= $dummy[0];
		$dummy[0]	= $tmp;
		}

		// get password

		return substr(implode('',$dummy),0,$length);

	}

	function startsWith($haystack, $needle)
	{
		return $needle === "" || strpos($haystack, $needle) === 0;
	}

	public function create_guid($namespace = '') {
		static $guid = '';
		$uid = uniqid("", true);
		$data = $namespace;
		$data .= $_SERVER['REQUEST_TIME'];
		$data .= $_SERVER['HTTP_USER_AGENT'];
		//$data .= $_SERVER['LOCAL_ADDR'];
		//$data .= $_SERVER['LOCAL_PORT'];
		$data .= $_SERVER['REMOTE_ADDR'];
		$data .= $_SERVER['REMOTE_PORT'];
		$hash = strtolower(hash('ripemd128', $uid . $guid . md5($data)));
		$guid = '' .
				substr($hash,  0,  8) .
				'-' .
				substr($hash,  8,  4) .
				'-' .
				substr($hash, 12,  4) .
				'-' .
				substr($hash, 16,  4) .
				'-' .
				substr($hash, 20, 12) .
				'';
				return $guid;
	}

}