<?php

/**
 * 
 * @parma: game  游戏
 * @param: ch 渠道
 * @key 广告ID
 * @platform 类型
 * @p 绝对文件
 * 
 * 文件下载中转页
 * 统计下载记录
 */



header("Content-type:text/html;charset=utf-8");

$ch = isset($_GET['channel']) ? $_GET['channel'] : 'kuniu';
$game = isset($_GET['game_id']) ? $_GET['game_id'] : '';
$key = isset($_GET['ad_channel']) ? trim($_GET['ad_channel']) : 1000;
$platform = isset($_GET['platform']) ? $_GET['platform'] : 'android';
$p = isset($_GET['p']) ? $_GET['p'] : '';

if (empty($game)) die('参数错误...');

$url = "http://cdn.szkuniu.com/";
// files/ghz/100002/ghz_kuniu_100002_v4.5.4.apk
$path = "files/{$game}/{$key}/";
if ( $platform == 'ios' ) $path = "files/{$game}/{$platform}/{$key}/";

// 绝对路径
if (!empty($p)){
	$path .= $p;
	if (!file_exists( $path )) die('没有最新的包');
}
else {
	$in = glob( $path . "*" ); //检测有没有文件
	if (empty($in)) die('没有最新的包');
	
	$dir = opendir( $path );

	$arr = array();
	foreach ($in as $m_p){
		$id = filemtime( $m_p );
		$arr[ $id ] = $m_p;
	}
	
	rsort($arr);
	
	$path = isset($arr[0]) ? $arr[0] : 0;
}

$url .= $path;

$data = array(
	'url' => $url,
);

die(json_encode($data));


$time = time();

// 记录数据
$data = array(
	'game_id' => $game,
	'channel' => $ch,
	'platform' => $platform,
	'ad_channel' => $key,
	'time' => $time,
	'ip' => get_ip(),
);

$db_name = 'oms_download_log';
$table = 'download_' . $time % 100;

header("Location:{$url}");

$db = libDb( $db_name );
$sql = create_insert_sql_str($table, $data);
$db->query($sql);

function create_insert_sql_str($table, $insert_data_arr) {
	$sql_fileds = $sql_value = '';
	foreach ( $insert_data_arr as $filed => $value ) {
		$sql_fileds .= '`' . $filed . '`,';
		$sql_value .= "'" . $value . "',";
	}
	$sql_fileds = substr ( $sql_fileds, 0, - 1 );
	$sql_value = substr ( $sql_value, 0, - 1 );
	$sql = " INSERT INTO {$table} ({$sql_fileds}) VALUES ($sql_value) ";
	return $sql;
}

function libDb( $database = NULL ){
		
	$db_conn = array(
        'hostname' => '10.66.103.209',
		'username' => 'root',
		'password' => 'kuniuwill123',
		'database' => $database 
	);
	
	$db = new mysqli($db_conn['hostname'],$db_conn['username'],$db_conn['password'] , $db_conn['database'] , 3306 );
	$db->query('SET NAMES UTF8');
	
	return $db;
}

/**
 * ip
 * @return string
 */
function get_ip(){
	if ($_SERVER['REMOTE_ADDR']) {
		$cip = $_SERVER['REMOTE_ADDR'];
	} elseif (getenv("REMOTE_ADDR")) {
		$cip = getenv("REMOTE_ADDR");
	} elseif (getenv("HTTP_CLIENT_IP")) {
		$cip = getenv("HTTP_CLIENT_IP");
	} else {
		$cip = "unknown";
	}
	return $cip;
	
}