<?
######################################################################################
##
##    Program     : 
##    Description :
##    Programmer  : äªÂÃÑµ¹ì  ÊØ¹·ÃÇÔÀÒµ
##    Email       : webmaster@sixhead.com
##                : webmaster@todaysoftware.com
##    Website     : http://www.sixhead.com
##                : http://www.todaysoftware.com
##    Date        : 
##    Modify log  : 
##     
######################################################################################

#####################################################################
#### start setup ####

$tp_serial_generater_special_info		=	"_tp_serial_generater_special_info_v4.html";
$tp_serial_generater_special			=	"_tp_serial_generater_special_v4.html";

#### end of setup ####
#####################################################################

#####################################################################
#### start program ####

require "../../module/_config.php";
require "../../module/_module.php";


# check session
if (!$_SESSION['s_user_username'] && !$_SESSION['s_admin_username']) {
	#header("Location: $cfg_main_url/user/?go=/engfanatic/user/WebService/serial_generater.php&error=Please Sign in - ¡ÃØ³Òà¢éÒÃÐºº¡èÍ¹ à©¾ÒÐÊÁÒªÔ¡à·èÒ¹Ñé¹!!");
	$error	=	$cfg_text_error_session;
	$go		=	urlencode($_SERVER["REQUEST_URI"]);
	header("Location: $cfg_main_url/user/index.php?error=$error&go=$go");
	exit;
}
ob_start();
	
	@$db = mysql_connect($db_host,$db_user,$db_pass); 
	mysql_select_db($db_name);
	if (!$db) { echo "Error connect to Database: " . mysql_error(); ob_end_flush(); exit; }

	$active_sql = "Y";
	if ($_SESSION['s_admin_username']) { 
		$active_sql = "%";
	}
	$sql = "SELECT * FROM $db_table_serial_generater_special WHERE ID = '$id' AND ACTIVE LIKE '$active_sql'";
	$result = mysql_query($sql);
	while($row = mysql_fetch_array($result)) {
		$program_id		=	$row[ID];
		$program_name 	=	$row[NAME];
		$max_len	 	=	$row[MAX_LEN];
		$detail		 	=	$row[DETAIL];
		$strCal			=	$row[CAL];
	}
	mysql_free_result($result);  

	if (!$program_id) { 
		header("Location: /engfanatic/");
		exit;
	}
	
	if ( ! $_SESSION['s_admin_username']) { 
		$auth_id = 0;
		$sql = "SELECT auth_id FROM $db_table_auth_generater_special WHERE program_id = '$program_id' AND user_id = '$s_user_id' AND active = 'Y' LIMIT 1";
		$result = mysql_query($sql);
		if (!$result) { if ($is_debug) { echo "$sql\n"; echo mysql_error(); echo "\n"; } die("invalid query"); }
		while($row = mysql_fetch_assoc($result)) {
			$auth_id	=	$row["auth_id"];
		}
		mysql_free_result($result);
		if ($auth_id == 0) { 
			header("Location: /engfanatic/");
			exit;
		}
	}

	mysql_close($db);


	if ($max_len == 0) { 
		$max_len = "";
	}
	else { 
$js_check_length = <<<SiXhEaD
		if ((theForm['key'].value.length) != $max_len){
			theForm['key'].value = "";
			errMsg = "¤ÇÒÁÂÒÇ¢Í§ Key äÁè¶Ù¡µéÍ§";
			setfocus = "['key']";
		}	
SiXhEaD;
	}
	

	if ($key) {
		if ($max_len != "") { 
			if (strlen($key) != $max_len) { 
				$tp = new SiXTemplate($tp_serial_generater_special_info);
				$tp->Display();
				exit;				
			}
		}
		$m = $key;
		$strCal = preg_replace("/\((.*?)\^(.*?)\)/", "pow($1,$2)", $strCal);
		#eval("\$strCal = $strCal;");
		eval("\$strCal = $strCal;");
		#echo $strCal;
		#echo "\n";
		$serial = (int) $strCal;
		$serial = abs($serial);

		@$db = mysql_connect($db_host,$db_user,$db_pass); 
		mysql_select_db($db_name);
		if (!$db) { echo "Error connect to Database: " . mysql_error(); ob_end_flush(); exit; }
	
		$dl_count = 0;
		$sql = "SELECT * FROM $db_table_serial_generater_special_log WHERE USER_ID = '$s_user_id' AND PROGRAM_ID = '$program_id'";
		$result = mysql_query($sql);
		while($row = mysql_fetch_array($result)) {
			$dl_count++;
		}		
		mysql_free_result($result);

		
		if ($dl_count <= 100) { # ï¿½ï¿½Ç¹ï¿½ï¿½ï¿½Å´ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ ï¿½ï¿½ï¿½Â¡ï¿½ï¿½ï¿½ 100 ï¿½ï¿½ï¿½ï¿½
			$sql = "
				INSERT INTO $db_table_serial_generater_special_log
				(PROGRAM_ID,USER_ID,KEY_INPUT,SERIAL_RETURN,DATEADD) VALUES 
				('$program_id','$s_user_id','$key','$serial',NOW())
			";
			mysql_query($sql);
			mysql_close($db);

			$tp = new SiXTemplate($tp_serial_generater_special);
			$tp->Display();
			exit;
		}
		else { 
			mysql_close($db);

			$error = "ï¿½Ø³ï¿½ï¿½ï¿½ Serial ï¿½Í§ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½Ô¹ 100 ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½";
			$tp = new SiXTemplate($tp_serial_generater_special_info);
			$tp->Display();
			exit;				
		}

		
	}
	else { 
		$tp = new SiXTemplate($tp_serial_generater_special_info);
		$tp->Display();
		exit;		
	}	

ob_end_flush();

#### end of program ####
#####################################################################


#### Start sub program. Don't touch anything below ####


?>