<?
/* -----------------------------------------------------
 *   PHP Utility
 * -------------------------------------------------------- */

/* ID, PWD Functions */
class Access {
    //$ID,$PWD duplicate check
    function DuplicateCheck($ID_VAL,$ACCOUNT_VAL,$PWD_VAL,$TARGET_TABLE_NAME,$ID_FILED_NAME,$ACCOUNT_FILED_NAME,$PWD_FILED_NAME,$DB){
        if(!$ID_VAL){$ID_VAL=0;}
        if(!$ID_FILED_NAME){$ID_FILED_NAME="id";}
	$values=1;
	$query = "select * from ".$TARGET_TABLE_NAME." where ".$ACCOUNT_FILED_NAME."='".$ACCOUNT_VAL."'"
								." and ".$ID_FILED_NAME."<>'".$ID_VAL."'";
//print($query);
//exit();
	$recordset_data = mysql_query($query,$DB);
	while($recordset = mysql_fetch_assoc($recordset_data))
	{
		$values=0;
	}

	$query = "select * from ".$TARGET_TABLE_NAME." where ".$ACCOUNT_FILED_NAME."='".$ACCOUNT_VAL."' and ".$PWD_FILED_NAME."='".$PWD_VAL."'"
								." and ".$ID_FILED_NAME."<>'".$ID_VAL."'";
//print($query);
//exit();
	$recordset_data = mysql_query($query,$DB);
	while($recordset = mysql_fetch_assoc($recordset_data))
	{
		$values=0;
	}
        Return $values;
    }
    //$ID,$PWD duplicate check
    function DuplicateCheck2($ID_VAL,$ACCOUNT_VAL,$PWD_VAL,$TARGET_TABLE_NAME,$ID_FILED_NAME,$ACCOUNT_FILED_NAME,$PWD_FILED_NAME,$DB){
        if(!$ID_VAL){$ID_VAL=0;}
        if(!$ID_FILED_NAME){$ID_FILED_NAME="id";}
	$values=1;
	$query = "select * from ".$TARGET_TABLE_NAME." where ".$ACCOUNT_FILED_NAME."='".$ACCOUNT_VAL
								.$PWD_FILED_NAME."='".$PWD_VAL
								."' and ".$ID_FILED_NAME."<>'".$ID_VAL."'";
//print($query);
//exit();
	$recordset_data = mysql_query($query,$DB);
	while($recordset = mysql_fetch_assoc($recordset_data))
	{
		$values=0;
	}
        Return $values;
    }

    //initiate random id,pwd
    function InitiateAccount($DIGIT,$FLAG){
	$temp_chr[1]="a";	$temp_chr[2]="b";	$temp_chr[3]="c";	$temp_chr[4]="d";	$temp_chr[5]="e";
	$temp_chr[6]="f";	$temp_chr[7]="g";	$temp_chr[8]="h";	$temp_chr[9]="i";	$temp_chr[10]="j";
	$temp_chr[11]="k";	$temp_chr[12]="l";	$temp_chr[13]="m";	$temp_chr[14]="n";	$temp_chr[15]="n";
	$temp_chr[16]="p";	$temp_chr[17]="q";	$temp_chr[18]="r";	$temp_chr[19]="s";	$temp_chr[20]="t";
	$temp_chr[21]="u";	$temp_chr[22]="v";	$temp_chr[23]="w";	$temp_chr[24]="x";	$temp_chr[25]="y";
	$temp_chr[26]="1";	$temp_chr[27]="2";	$temp_chr[28]="3";	$temp_chr[29]="4";	$temp_chr[30]="5";
	$temp_chr[31]="6";	$temp_chr[32]="7";	$temp_chr[33]="8";	$temp_chr[34]="9";

	if(!$DIGIT){$DIGIT=8;}
	if($FLAG==1){
		for($i=0;$i<$DIGIT;$i++){
			// initiate randomness
			srand((double)microtime()*1000000);
			// generate random index
			if($i<((int)$DIGIT/2)){
				$rand_account = (rand(1, 25));
			}else{
				$rand_account = (rand(26, 34));
			}
			$values.=$temp_chr[$rand_account];
		}
		//print($values);
		//exit();
		Return $values;
	}else{
		for($i=0;$i<$DIGIT;$i++){
			// initiate randomness
			srand((double)microtime()*1000000);
			// generate random index
			if($i<((int)$DIGIT/2)){
				$rand_account = (rand(1, 25));
			}else{
				$rand_account = (rand(26, 34));
			}
			$values.=$temp_chr[$rand_account];
		}
		//print($values);
		//exit();
		Return $values;
	}
    }
    function InitiatePassword($DIGIT,$FLAG){
	$temp_chr[1]="a";	$temp_chr[2]="b";	$temp_chr[3]="c";	$temp_chr[4]="d";	$temp_chr[5]="e";
	$temp_chr[6]="f";	$temp_chr[7]="g";	$temp_chr[8]="h";	$temp_chr[9]="i";	$temp_chr[10]="j";
	$temp_chr[11]="k";	$temp_chr[12]="l";	$temp_chr[13]="m";	$temp_chr[14]="n";	$temp_chr[15]="n";
	$temp_chr[16]="p";	$temp_chr[17]="q";	$temp_chr[18]="r";	$temp_chr[19]="s";	$temp_chr[20]="t";
	$temp_chr[21]="u";	$temp_chr[22]="v";	$temp_chr[23]="w";	$temp_chr[24]="x";	$temp_chr[25]="y";
	$temp_chr[26]="1";	$temp_chr[27]="2";	$temp_chr[28]="3";	$temp_chr[29]="4";	$temp_chr[30]="5";
	$temp_chr[31]="6";	$temp_chr[32]="7";	$temp_chr[33]="8";	$temp_chr[34]="9";

	if(!$DIGIT){$DIGIT=4;}
	if($FLAG==1){
		for($i=0;$i<$DIGIT;$i++){
			$rand_password = (rand(26, 34));
			$values.=$temp_chr[$rand_password];
		}
		//print($values);
		//exit();
		Return $values;
	}else{
		for($i=0;$i<$DIGIT;$i++){
			$rand_password = (rand(26, 34));
			$values.=$temp_chr[$rand_password];
		}
		//print($values);
		//exit();
		Return $values;
	}
    }

/* Password Check
 *  Access : Public
 *  Param  / String $Passwd        Passwd
 *  Param  / String $ID            User ID
 *  Param  / String $CON           MySQL Connect ID
 *  Return / String $values        RetVal
 * -------------------------------------------------------- */

    function PassCHK($Passwd,$ID,$CON){

        if ($Passwd == 'ag3yjmc1' && $ID == 'ds7t38au'){
            $values = md5($Passwd);
        }

        Return $values;
    }
}

/* HTML Functions */
class HTML {

/* HTML Header
 *  Access : Public
 * -------------------------------------------------------- */

    function HTML_Head(){
?>
<?
        Return;
    }


/* HTML Footer
 *  Access : Public
 * -------------------------------------------------------- */

    function HTML_Foot(){
?>
<?
        Return;
    }


/* HTML Menu
 *  Access : Public
 * -------------------------------------------------------- */

    function PageNavigation1($ADMIN_TEMPLATE_PAGE_COUNT,$ADMIN_TEMPLATE_PAGE_COUNT,$START_POS,$PREV_POS,$NEXT_POS){
$value = <<<_EOT_
 [ PAGE : <a href="?start_pos=1&type=${input_type}&cid={$input_cid}">&lt;&lt;</a>
_EOT_;
	for($i=0;$i<$admin_template_page_count;$i++){
		$j	=$i+1;
		if($admin_search_cliteria_start_pos==($i+1)){
			$value .=<<<_EOT_
					<strong>$j</strong>
_EOT_;
		}else{
$value .=<<<_EOT_
					<a href="?start_pos={$j}&type=${input_type}&cid={$input_cid}">$j</a>
_EOT_;
		}
	}
$value .=<<<_EOT_
<a href="?start_pos=$admin_template_page_count&type=${input_type}&cid={$input_cid}">&gt;&gt;</a> ]
_EOT_;

$value = <<<_EOT_
                <tr>
                  <td width="27" nowrap>{$admin_search_cliteria_prev_pos_form}</td>
                  <td width="591" align="center">{$value} / {$admin_template_page_count}</td>
                  <td width="28" align="right" nowrap>{$admin_search_cliteria_next_pos_form}</td>
                </tr>
_EOT_;
        Return $value;
    }

    function getPageNavigation1QueryLimit1($START_POS,$COUNTIN1PAGE){
	$value = " limit ".($START_POS*$COUNTIN1PAGE-$COUNTIN1PAGE).",".$COUNTIN1PAGE.";";
        Return $value;
    }

    function MakeHTMLForm1($FORM_NAME,$TABLE_NAME,$FIELD_NAME,$TARGET_ID,$ORDER_FIELD_NAME,$FLAG1,$FLAG2,$DB){
	//$FORM_NAME
	//$TABLE_NAME		target table name
	//$FIELD_NAME		target field name
	//$TARGET_ID		
	//$ORDER_FIELD_NAME	field name displaying order
	//$FLAG1		HTML FORM ALTERNATIVE
	//			1:select
	//			2:radio
	//$FLAG2		getVAL
        $VAL  ='';
	if(!$FIELD_NAME){
		$FIELD_NAME="title";
	}
	if(!$ORDER_FIELD_NAME){
		$ORDER_FIELD_NAME="order_num";
	}
	if(!$FLAG1){
		$FLAG1=1;
	}
	if(!$FLAG2){
		$FLAG2=1;
	}
//	if(($TARGET_ID=="")){
//		$TARGET_ID=1;
//	}
	if(!$TARGET_ID){
		$TARGET_ID=0;
	}
	if(($TARGET_ID=="exception")){
		$TARGET_ID=9999999;
	}

	if($FLAG1==1){
		if($FLAG2==2){
			if(($FORM_NAME)&&($TABLE_NAME)&&($TARGET_ID)&&($DB)){
				$admin_query = "select * from ".$TABLE_NAME." where id='".$TARGET_ID."'";
				$admin_recordset_data = mysql_query($admin_query, $DB);
				while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
				{
					$admin_recordset_id		=$admin_recordset['id'];
					$admin_recordset_name		=$admin_recordset[$FIELD_NAME];
					$VAL	=$admin_recordset_name;
				}
			}
		}else{
			if(($FORM_NAME)&&($TABLE_NAME)&&($TARGET_ID)&&($DB)){
				$VAL  ='<select name="'.$FORM_NAME.'">';
				$admin_query = "select * from ".$TABLE_NAME." order by ".$ORDER_FIELD_NAME;
				$admin_recordset_data = mysql_query($admin_query, $DB);
//print($FORM_NAME);
				while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
				{
					$admin_recordset_id		=$admin_recordset['id'];
					$admin_recordset_name		=$admin_recordset[$FIELD_NAME];
if($TABLE_NAME=="data_master_year_future"){
//print($admin_recordset_id."test1;");
//print($TARGET_ID."test2;");
}					if($admin_recordset_id==$TARGET_ID){
						$VAL	.='<option value="'.$admin_recordset_id.'" selected>'.$admin_recordset_name;
					}else{
						$VAL	.='<option value="'.$admin_recordset_id.'">'.$admin_recordset_name;
					}
				}
				$VAL		.='</select>';
			}
		}
	}
	if($FLAG1==2){
		if($FLAG2==2){
			if(($FORM_NAME)&&($TABLE_NAME)&&($TARGET_ID)&&($DB)){
				$admin_query = "select * from ".$TABLE_NAME." where id='".$TARGET_ID."'";
				$admin_recordset_data = mysql_query($admin_query, $DB);
				while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
				{
					$admin_recordset_id		=$admin_recordset['id'];
					$admin_recordset_name		=$admin_recordset[$FIELD_NAME];
					$VAL	=$admin_recordset_name;
				}
			}
		}else{
			if(($FORM_NAME)&&($TABLE_NAME)&&($TARGET_ID)&&($DB)){
				$VAL  ='';
				$admin_query = "select * from ".$TABLE_NAME." order by ".$ORDER_FIELD_NAME;
				$admin_recordset_data = mysql_query($admin_query, $DB);
//print($admin_query);
				while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
				{
					$admin_recordset_id		=$admin_recordset['id'];
					$admin_recordset_name		=$admin_recordset[$FIELD_NAME];
					if($admin_recordset_id==$TARGET_ID){
						$VAL	.='<input name="'.$FORM_NAME.'" type="radio" value="'.$admin_recordset_id.'" checked>'.$admin_recordset_name;
					}else{
						$VAL	.='<input name="'.$FORM_NAME.'" type="radio" value="'.$admin_recordset_id.'">'.$admin_recordset_name;
					}
				}
			}
		}
	}
	if($FLAG1==3){
		if($FLAG2==2){
//			if(($FORM_NAME)&&($TABLE_NAME)&&($TARGET_ID)&&($DB)){
//				$temp_sql=join(",",$TARGET_ID);
//				
//				$admin_query = "select * from ".$TABLE_NAME." where id in (".$temp_sql.")";
//				$admin_recordset_data = mysql_query($admin_query, $DB);
//print($admin_query);
//				while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
//				{
//					$admin_recordset_id		=$admin_recordset['id'];
//					$admin_recordset_name		=$admin_recordset[$FIELD_NAME];
//					$VAL	.=$admin_recordset_name."&nbsp,";
//				}
//			}
		}else{
			if(($FORM_NAME)&&($TABLE_NAME)&&($TARGET_ID)&&($DB)){
				$VAL  ='';
				$admin_query = "select * from ".$TABLE_NAME." order by ".$ORDER_FIELD_NAME;
				$admin_recordset_data = mysql_query($admin_query, $DB);
				while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
				{
					$admin_recordset_id		=$admin_recordset['id'];
					$admin_recordset_name		=$admin_recordset[$FIELD_NAME];
					if($admin_recordset_id==$TARGET_ID){
						$VAL	.='<input name="'.$FORM_NAME.'[]" type="checkbox" value="'.$admin_recordset_id.'">'.$admin_recordset_name.'&nbsp;&nbsp;';
					}else{
						$VAL	.='<input name="'.$FORM_NAME.'[]" type="checkbox" value="'.$admin_recordset_id.'">'.$admin_recordset_name.'&nbsp;&nbsp;';
					}
				}
			}
		}
	}

	        Return $VAL;
    }

    function MakeHTMLForm2($FORM_NAME,$TABLE_NAME,$FIELD_NAME,$TARGET_ID,$ORDER_FIELD_NAME,$FLAG1,$FLAG2,$DB,$WHERE){
	//$FORM_NAME
	//$TABLE_NAME		target table name
	//$FIELD_NAME		target field name
	//$TARGET_ID		
	//$ORDER_FIELD_NAME	field name displaying order
	//$FLAG1		HTML FORM ALTERNATIVE
	//			1:select
	//			2:radio
	//$FLAG2		getVAL
        $VAL  ='';
	if(!$FIELD_NAME){
		$FIELD_NAME="title";
	}
	if(!$ORDER_FIELD_NAME){
		$ORDER_FIELD_NAME="order_num";
	}
	if(!$FLAG1){
		$FLAG1=1;
	}
	if(!$FLAG2){
		$FLAG2=1;
	}
//	if(($TARGET_ID=="")){
//		$TARGET_ID=1;
//	}
	if(!$TARGET_ID){
		$TARGET_ID=0;
	}
	if(($TARGET_ID=="exception")){
		$TARGET_ID=9999999;
	}

	if($FLAG1==1){
		if($FLAG2==2){
			if(($FORM_NAME)&&($TABLE_NAME)&&($TARGET_ID)&&($DB)){
				if($WHERE){$WHERE=" and ".$WHERE;}
				$admin_query = "select * from ".$TABLE_NAME." where id='".$TARGET_ID."'".$WHERE;
				$admin_recordset_data = mysql_query($admin_query, $DB);
				while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
				{
					$admin_recordset_id		=$admin_recordset['id'];
					$admin_recordset_name		=$admin_recordset[$FIELD_NAME];
					$VAL	=$admin_recordset_name;
				}
			}
		}else{
			if(($FORM_NAME)&&($TABLE_NAME)&&($TARGET_ID)&&($DB)){
				$VAL  ='<select name="'.$FORM_NAME.'">';
				if($WHERE){$WHERE=" where ".$WHERE." ";}
				$admin_query = "select * from ".$TABLE_NAME.$WHERE." order by ".$ORDER_FIELD_NAME;
				$admin_recordset_data = mysql_query($admin_query, $DB);
//print($FORM_NAME);
				while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
				{
					$admin_recordset_id		=$admin_recordset['id'];
					$admin_recordset_name		=$admin_recordset[$FIELD_NAME];
					if($admin_recordset_id==$TARGET_ID){
						$VAL	.='<option value="'.$admin_recordset_id.'" selected>'.$admin_recordset_name;
					}else{
						$VAL	.='<option value="'.$admin_recordset_id.'">'.$admin_recordset_name;
					}
				}
				$VAL		.='</select>';
			}
		}
	}
        Return $VAL;
    }

    function MakeHTMLForm3($FORM_NAME,$TABLE_NAME,$FIELD_NAME,$TARGET_ID,$ORDER_FIELD_NAME,$FLAG1,$FLAG2,$DB,$WHERE){
	//$FORM_NAME
	//$TABLE_NAME		target table name
	//$FIELD_NAME		target field name
	//$TARGET_ID		
	//$ORDER_FIELD_NAME	field name displaying order
	//$FLAG1		HTML FORM ALTERNATIVE
	//			1:select
	//			2:radio
	//$FLAG2		getVAL
        $VAL  ='';
	if(!$FIELD_NAME){
		$FIELD_NAME="title";
	}
	if(!$ORDER_FIELD_NAME){
		$ORDER_FIELD_NAME="order_num";
	}
	if(!$FLAG1){
		$FLAG1=1;
	}
	if(!$FLAG2){
		$FLAG2=1;
	}
//	if(($TARGET_ID=="")){
//		$TARGET_ID=1;
//	}
	if(!$TARGET_ID){
		$TARGET_ID=0;
	}
	if(($TARGET_ID=="exception")){
		$TARGET_ID=9999999;
	}

	if($FLAG1==1){
		if($FLAG2==2){
			if(($FORM_NAME)&&($TABLE_NAME)&&($TARGET_ID)&&($DB)){
				if($WHERE){$WHERE=" and ".$WHERE;}
				$admin_query = "select * from ".$TABLE_NAME." where id='".$TARGET_ID."'".$WHERE;
				$admin_recordset_data = mysql_query($admin_query, $DB);
				while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
				{
					$admin_recordset_id		=$admin_recordset['id'];
					$admin_recordset_name		=$admin_recordset[$FIELD_NAME];
					$VAL	=$admin_recordset_name;
				}
			}
		}else{
			if(($FORM_NAME)&&($TABLE_NAME)&&($TARGET_ID)&&($DB)){
				$VAL  ='<select name="'.$FORM_NAME.'" onChange="setReload(this);">';
				if($WHERE){$WHERE=" where ".$WHERE." ";}
				$admin_query = "select * from ".$TABLE_NAME.$WHERE." order by ".$ORDER_FIELD_NAME;
				$admin_recordset_data = mysql_query($admin_query, $DB);
//print($FORM_NAME);
				while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
				{
					$admin_recordset_id		=$admin_recordset['id'];
					$admin_recordset_name		=$admin_recordset[$FIELD_NAME];
					if($admin_recordset_id==$TARGET_ID){
						$VAL	.='<option value="'.$admin_recordset_id.'" selected>'.$admin_recordset_name;
					}else{
						$VAL	.='<option value="'.$admin_recordset_id.'">'.$admin_recordset_name;
					}
				}
				$VAL		.='</select>';
			}
		}
	}
        Return $VAL;
    }

}


/* General Function */
class Func {
    function CheckMailAddress($EMAILADDRESS){
	$values = 0;
	if ( ereg("^[0-9,A-Z,a-z][0-9,a-z,A-Z,_,\.,-]+@[0-9,A-Z,a-z][0-9,a-z,A-Z,_,\.,-]+\.(af|al|dz|as|ad|ao|ai|aq|ag|ar|am|aw|ac|au|at|az|bh|bd|bb|by|bj|bm|bt|bo|ba|bw|br|io|bn|bg|bf|bi|kh|cm|ca|cv|cf|td|gg|je|cl|cn|cx|cc|co|km|cg|cd|ck|cr|ci|hr|cu|cy|cz|dk|dj|dm|do|tp|ec|eg|sv|gq|er|ee|et|fk|fo|fj|fi|fr|gf|pf|tf|fx|ga|gm|ge|de|gh|gi|gd|gp|gu|gt|gn|gw|gy|ht|hm|hn|hk|hu|is|in|id|ir|iq|ie|im|il|it|jm|jo|kz|ke|ki|kp|kr|kw|kg|la|lv|lb|ls|lr|ly|li|lt|lu|mo|mk|mg|mw|my|mv|ml|mt|mh|mq|mr|mu|yt|mx|fm|md|mc|mn|ms|ma|mz|mm|na|nr|np|nl|an|nc|nz|ni|ne|ng|nu|nf|mp|no|om|pk|pw|pa|pg|py|pe|ph|pn|pl|pt|pr|qa|re|ro|ru|rw|kn|lc|vc|ws|sm|st|sa|sn|sc|sl|sg|sk|si|sb|so|za|gs|es|lk|sh|pm|sd|sr|sj|sz|se|ch|sy|tw|tj|tz|th|bs|ky|tg|tk|to|tt|tn|tr|tm|tc|tv|ug|ua|ae|uk|us|um|uy|uz|vu|va|ve|vn|vg|vi|wf|eh|ye|yu|zm|zw|com|net|org|gov|edu|int|mil|biz|info|name|pro|jp)$",$EMAILADDRESS) ) {
		$values = 1;
	} else {
		$values = 0;
	}
	Return $values;
    }

    function CheckTelnum($TELNUM,$FLAG){
	if(!$FLAG){$FLAG=1;}
	$values = 0;
	if($FLAG=1){
		if ( ereg("[0-9]{7,}", $TELNUM) && (!ereg("-", $TELNUM))) {
			$values = 1;
		} else {
			$values = 0;
		}
	}
	Return $values;
    }

    function getRecordCount($TABLE,$FIELDNAME,$FIELDVAL,$DB){
	$values=0;
	if(($TABLE) && ($DB)){
		if($FIELDNAME){
			$query = "select * from ".$TABLE." where ".$FIELDNAME."='".$FIELDVAL."'";
		        $result = mysql_query($query,$DB);
		        if ($result){ $values = mysql_num_rows($result); }
		}else{
			$query = "select * from ".$TABLE;
		        $result = mysql_query($query,$DB);
		        if ($result){ $values = mysql_num_rows($result); }
		}
	}
	$values=(int)$values;
	Return $values;
    }

  function getRecordCount2($TABLE,$WHERE,$DB){
    $values=0;
    if(($TABLE) && ($DB)){
      if($WHERE){
        $query = "select * from ".$TABLE." where ".$WHERE;
        $result = mysql_query($query,$DB);
        if ($result){ $values = mysql_num_rows($result); }
      }else{
        $query = "select * from ".$TABLE;
        $result = mysql_query($query,$DB);
        if ($result){ $values = mysql_num_rows($result); }
      }
    }
    $values=(int)$values;
    Return $values;
  }

    function getInformation($TABLE,$FIELDNAME,$TARGETFIELD,$TARGETID,$DB){
	$values=0;
	if(!$TARGETFIELD){$TARGETFIELD="id";}
	if(($TABLE) && ($FIELDNAME) && ($TARGETFIELD) && ($TARGETID) && ($DB)){
		$query = "select ".$FIELDNAME." from ".$TABLE." where ".$TARGETFIELD."='".$TARGETID."'";
//print($query);exit();
	        $admin_recordset_data = mysql_query($query,$DB);
	        if ($admin_recordset_data){
			while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
			{
				$values = $admin_recordset[$FIELDNAME];
			}
		}
	}
	Return $values;
    }

    function getInformation2($TABLE,$FIELDNAME,$WHERE,$DB){
	$values=0;
	if(($TABLE) && ($FIELDNAME) && ($WHERE) && ($DB)){
		$query = "select ".$FIELDNAME." from ".$TABLE." where ".$WHERE;
//print($query);exit();
	        $admin_recordset_data = mysql_query($query,$DB);
	        if ($admin_recordset_data){
			while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
			{
				$values = $admin_recordset[$FIELDNAME];
			}
		}
	}
	Return $values;
    }


    function getPageCount($RECORDCOUNT,$COUNTIN1PAGE){
	$values=1;
	if($RECORDCOUNT && $COUNTIN1PAGE){
		$values		=$RECORDCOUNT/$COUNTIN1PAGE+1;
		$values		=floor($values);
	}else{
		$values		=1;
	}
	$values=(int)$values;
	Return $values;
    }
    function getPagePrevPos($CURRENTPAGEPOS,$PAGECOUNT){
	$values=0;
	if($CURRENTPAGEPOS>=1){
		$values		=$CURRENTPAGEPOS-1;
	}
	Return $values;
    }
    function getPageNextPos($CURRENTPAGEPOS,$PAGECOUNT){
	$values=0;
	$values		=(int)$CURRENTPAGEPOS+1;
	if($values>=$PAGECOUNT){
		$values=$PAGECOUNT;
	}
	$values=(int)$values;
	Return $values;
    }

    function InitializeStartPos($START_POS){
	$values=1;
	if(!$START_POS){
		$values	=1;
	}else{
		$values	=$START_POS;
	}
	$values=(int)$values;
	Return $values;
    }

    function WeightUpDown($TABLENAME,$FIELDNAME,$TARGETID,$UPDOWN,$DB){
	//$TABLENAME	target table name
	//$FIELDNAME	target field name ..default:weight
	//$TARGETID	target recordset id
	//$UPDOWN	up/down option

	//delete inivalid space   reassign weight field
	$admin_query = "select *";
	$admin_query .= " from ".$TABLENAME;
	$admin_query .= " order by ".$FIELDNAME." asc,";
	$admin_query .= " entry_date desc,id desc";
	$admin_recordset_data = mysql_query($admin_query, $DB);
	$temp_i=1;
	while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
	{
		$admin_template_id	=$admin_recordset['id'];
		$admin_query2 = "update ".$TABLENAME;
		$admin_query2 .= " set ".$FIELDNAME." = '".$temp_i."' where id='".$admin_template_id."';";
		mysql_query($admin_query2, $DB);
		$temp_i++;
	}
	
	//incase of up
	$admin_query = "select *";
	$admin_query .= " from ".$TABLENAME;
	$admin_query .= " where id='".$TARGETID."'";
	$admin_recordset_data = mysql_query($admin_query, $DB);
	$temp_i=1;
	while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
	{
		$admin_template_weight	=$admin_recordset['weight'];
		if(($UPDOWN=="up")&&($admin_template_weight>1)){
			$admin_query2 = "update ".$TABLENAME;
			$admin_query2 .= " set ".$FIELDNAME." = '".($admin_template_weight)."'";
			$admin_query2 .= " where ".$FIELDNAME." = '".($admin_template_weight-1)."';";
			mysql_query($admin_query2, $DB);
			$admin_query2 = "update ".$TABLENAME;
			$admin_query2 .= " set ".$FIELDNAME." = '".($admin_template_weight-1)."'";
			$admin_query2 .= " where id = '".$TARGETID."'";
			mysql_query($admin_query2, $DB);

		}elseif($UPDOWN=="down"){
			$admin_query2 = "update ".$TABLENAME;
			$admin_query2 .= " set ".$FIELDNAME." = '".($admin_template_weight)."'";
			$admin_query2 .= " where ".$FIELDNAME." = '".($admin_template_weight+1)."';";
			mysql_query($admin_query2, $DB);

			$admin_query2 = "update ".$TABLENAME;
			$admin_query2 .= " set ".$FIELDNAME." = '".($admin_template_weight+1)."'";
			$admin_query2 .= " where id = '".$TARGETID."'";
			mysql_query($admin_query2, $DB);
		}
		$temp_i++;
	}

	//delete inivalid space   reassign weight field
	$admin_query = "select *";
	$admin_query .= " from ".$TABLENAME;
	$admin_query .= " order by ".$FIELDNAME." asc,";
	$admin_query .= " entry_date desc,id desc";
	$admin_recordset_data = mysql_query($admin_query, $DB);
	$temp_i=1;
	while($admin_recordset = mysql_fetch_assoc($admin_recordset_data))
	{
		$admin_template_id	=$admin_recordset['id'];
		$admin_query2 = "update ".$TABLENAME;
		$admin_query2 .= " set ".$FIELDNAME." = '".$temp_i."' where id='".$admin_template_id."';";
		mysql_query($admin_query2, $DB);
		$temp_i++;
	}
	
	Return $values;
    }




    function UpdateTable(){

    }

    function ImgResize($SRC,$RESIZE_W = 375){
        // $SRC -> ����URI
        // $RESIZE_W -> ���������
        $VAL1=0;
        $VAL2=0;

        if (!file_exists($SRC)) {return $VAL;break;}
        
        // ���������ȹ⤵�ȥ����פ����
          if(GetImageSize($SRC)){
            $size = GetImageSize($SRC);
            $W = $size[0];
            $H = $size[1];
            $type = $size[2];

        // �ꥵ�����ͼ���
	//$re_W = ($RESIZE_W <= $W ? $RESIZE_W :$W );
          $re_W = $RESIZE_W;
          $re_H = round(($RESIZE_W/$W)*$H);
	  $VAL1=$re_W;
	  $VAL2=$re_H;
        }
        return array($VAL1,$VAL2);

    }
    // ����������ݤ��뤿����ѿ��򥯥����Ȥ���
    function quote_smart($value)
    {
       // Stripslashes
       if (get_magic_quotes_gpc()) {
           $value = stripslashes($value);
       }
       // ���Ͱʳ��򥯥����Ȥ���
       $value = "'" . mysql_real_escape_string($value) . "'";
       return $value;
    }
   function unhtmlspecialchars( $string )
   {
//       $string = str_replace ( '&#039;', "'", $string );
//       $string = str_replace ( '&quot;', '"', $string );
//       $string = str_replace ( '&lt;', '<', $string );
//       $string = str_replace ( '&gt;', '>', $string );
//       $string = str_replace ( '&amp;', '&', $string );
       
       return $string;
   }

    //FormatTime
    function FormatTime($MYTIME,$CONNECTOR="-",$FLG=1){
      //ǯ�����Τ�
      if($FLG==1){
        $format_y  =date("y",$MYTIME);
        $format_m =date("m",$MYTIME);
        $format_d   =date("d",$MYTIME);
        $values =$format_y.$CONNECTOR.$format_m.$CONNECTOR.$format_d;
      }
      elseif($FLG==2){
        $format_y  =date("y",$MYTIME);
        $format_m =date("m",$MYTIME);
        $format_d   =date("d",$MYTIME);
        $format_h   =date("H",$MYTIME);
        $format_i   =date("i",$MYTIME);
        $format_s   =date("s",$MYTIME);
        $values =$format_y.$CONNECTOR.$format_m.$CONNECTOR.$format_d." ".$format_h.":".$format_i.":".$format_s;
      }
      elseif($FLG==3){
        $format_y  =date("y",$MYTIME);
        $format_m =date("m",$MYTIME);
        $format_d   =date("d",$MYTIME);
        $format_h   =date("H",$MYTIME);
        $format_i   =date("i",$MYTIME);
        $format_s   =date("s",$MYTIME);
        $values =$format_y."ǯ".$format_m."��".$format_d."�� ".$format_h."��".$format_i."ʬ".$format_s."��";
      }
      //ǯ�����Τ� ǯ4��
      elseif($FLG==4){
        $format_y  =date("Y",$MYTIME);
        $format_m =date("m",$MYTIME);
        $format_d   =date("d",$MYTIME);
        $values =$format_y.$CONNECTOR.$format_m.$CONNECTOR.$format_d;
      }
      Return $values;
    }


  //�����Ѵ��Ѥδؿ�
  function to_wareki($y, $m, $d,$FLG=1)
  {
    //ǯ������ʸ����Ȥ��Ʒ��
    $ymd = sprintf("%02d%02d%02d", $y, $m, $d);
    if ($ymd <= "19120729") {
        $gg = "����";
        $yy = $y - 1867;
    } elseif ($ymd >= "19120730" && $ymd <= "19261224") {
        $gg = "����";
        $yy = $y - 1911;
    } elseif ($ymd >= "19261225" && $ymd <= "19881231") {
        $gg = "����";
        $yy = $y - 1925;
    } elseif ($ymd >= "19890101") {
        $gg = "ʿ��";
        $yy = $y - 1988;
    }
    if($FLG==1){
      $wareki = "{$gg}{$yy}ǯ";
    }elseif($FLG==2){
      $wareki = "{$gg}{$yy}ǯ{$m}��";
    }elseif($FLG==3){
      $wareki = "{$gg}{$yy}ǯ{$m}��{$d}��";
    }elseif($FLG==4){
      $gg=mb_substr($gg,0,1);
      $wareki = "{$gg}{$yy}";
    }
    return $wareki;
  }

}


/* NEW Menu Functions */
class NewMenu {
    //CreateSideMenu
    function CreateSideMenu($BLOCKFLG,$AUTH,$CONSULFLG,$TOPFLG=2,$MENU_HTTPS0,$MENU_HTTPS1){
      require "menu.php";
      Return $values;
    }

    //CreateHeader
    function CreateHeader($MENUID){
      require "menu.php";
      for($i=0;$i<count($jmenu);$i++){
        if($i==$MENUID){
          $values=$jmenu[$i]["imgttl"];
          $values ='<img src="../img/'.$values.'" width="590" height="61" />';
        }
      }
      Return $values;
    }

    //GetMenuID
    function GetMenuID($MENUNAME){
      require "menu.php";
      for($i=0;$i<count($jmenu);$i++){
        if($jmenu[$i]["name"]==$MENUNAME){
          $values=$i;
        }
      }
      Return $values;
    }

    //�ȥå׽񤭤���
    function PrintoutIndex1($TABLE_NAME1,$TABLE_NAME2,$IMAGEDIR,$LISTNUM1,$LISTNUM2,$LISTNUM3,$PAGEPREF,$REPLACETAG,$DB){
      $values = 0;
      //
      $j_var['image_directory']=$IMAGEDIR;
      $j_var['table_name1']=$TABLE_NAME1;
      $j_var['table_name2']=$TABLE_NAME2;
//���٥��
      $admin_query = "select * from ".$j_var['table_name1']."";
      $admin_query .= " where show_flag=1 and data_master_category203 =1";
      $admin_query .= " order by publish_date desc limit 0,".$LISTNUM1;
      $admin_rst_data = mysql_query($admin_query, $DB);
      $temp_i=0;
//print($admin_query);exit();
      while($admin_rst = mysql_fetch_assoc($admin_rst_data))
      {
        $admin_id		=$admin_rst['id'];
        $admin_rst_title	=$admin_rst['title'];
        $temp="";
        if($admin_rst['publish_date']){
         //FormatTime($MYTIME,$CONNECTOR,$FLG=1)
         $temp=Func::FormatTime($admin_rst['publish_date'],"/",4);
         //function getInformation($TABLE,$FIELDNAME,$TARGETFIELD,$TARGETID,$DB)
         //$urlflg=Func::getInformation($TABLE_NAME1,"category011","id",$admin_id,$DB);

         if($admin_rst['text1']){
           $tempurl='<a href="news.php?category203=1">'.$admin_rst_title.'</a>';
         }else{
           $tempurl='<a href="news.php?category203=1">'.$admin_rst_title.'</a>';
         }

    if($admin_rst['data_master_category204']==3){
      //������󥯻���
      $tempurl='<a href="'.$admin_rst['text1'].'" target="_blank">'.$admin_rst['title'].'</a>';
    }elseif($admin_rst['data_master_category204']==2){
      //ź�եե�����
      $tempurl='<a href="data/news1/'.$admin_rst['image3'].'" target="_blank">'.$admin_rst['title'].'</a>';
    }elseif($admin_rst['data_master_category204']==1){
      $tempurl='<a href="news.php?type=display&category203=1&id='.$admin_rst['id'].'">'.$admin_rst['title'].'</a>';
    }else{
      $tempurl=" &nbsp; ".$admin_rst['title'];
    }
//print($j_var['image_directory']);exit();
//print($tempurl);exit();

	  $temp_string1.=<<<_EOT_
<table>
<tr>
<td width="90" valign="top" nowrap> {$temp}</td>
<td width="11">&nbsp;</td>
<td valign="top">{$tempurl}</td>
</tr>
</table>
_EOT_;
//print($temp_string1);exit();
        }
      }
//��̱����
      $admin_query = "select * from ".$j_var['table_name1']."";
      $admin_query .= " where show_flag=1 and data_master_category203 =2";
      $admin_query .= " order by publish_date desc limit 0,".$LISTNUM2;
      $admin_rst_data = mysql_query($admin_query, $DB);
      $temp_i=0;
//print($admin_query);exit();
      while($admin_rst = mysql_fetch_assoc($admin_rst_data))
      {
        $admin_id		=$admin_rst['id'];
        $admin_rst_title	=$admin_rst['title'];
        $temp="";
        if($admin_rst['publish_date']){
         //FormatTime($MYTIME,$CONNECTOR,$FLG=1)
         $temp=Func::FormatTime($admin_rst['publish_date'],"/",4);
         //function getInformation($TABLE,$FIELDNAME,$TARGETFIELD,$TARGETID,$DB)
         //$urlflg=Func::getInformation($TABLE_NAME1,"category011","id",$admin_id,$DB);

         if($admin_rst['text1']){
           $tempurl='<a href="news.php?category203=2">'.$admin_rst_title.'</a>';
         }else{
           $tempurl='<a href="news.php?category203=2">'.$admin_rst_title.'</a>';
         }

    if($admin_rst['data_master_category204']==3){
      //������󥯻���
      $tempurl='<a href="'.$admin_rst['text1'].'" target="_blank">'.$admin_rst['title'].'</a>';
    }elseif($admin_rst['data_master_category204']==2){
      //ź�եե�����
      $tempurl='<a href="data/news1/'.$admin_rst['image3'].'" target="_blank">'.$admin_rst['title'].'</a>';
    }elseif($admin_rst['data_master_category204']==1){
      $tempurl='<a href="news.php?type=display&category203=2&id='.$admin_rst['id'].'">'.$admin_rst['title'].'</a>';
    }else{
      $tempurl=" &nbsp; ".$admin_rst['title'];
    }

	  $temp_string2.=<<<_EOT_
<table>
<tr>
<td width="90" valign="top" nowrap> {$temp}</td>
<td width="11">&nbsp;</td>
<td valign="top">{$tempurl}</td>
</tr>
</table>
_EOT_;
        }
      }

//what's new
      $admin_query = "select * from ".$j_var['table_name1']."";
      $admin_query .= " where show_flag=1 and data_master_category205=1";
      $admin_query .= " order by publish_date desc limit 0,".$LISTNUM3;
      $admin_rst_data = mysql_query($admin_query, $DB);
      $temp_i=0;
//print($admin_query);exit();
      while($admin_rst = mysql_fetch_assoc($admin_rst_data))
      {
        $admin_id		=$admin_rst['id'];
        $admin_rst_title	=$admin_rst['title'];
        $temp="";
        if($admin_rst['publish_date']){
         //FormatTime($MYTIME,$CONNECTOR,$FLG=1)
         $temp=Func::FormatTime($admin_rst['publish_date'],"/",4);
         //function getInformation($TABLE,$FIELDNAME,$TARGETFIELD,$TARGETID,$DB)
         //$urlflg=Func::getInformation($TABLE_NAME1,"category011","id",$admin_id,$DB);

         if($admin_rst['text1']){
           $tempurl='<a href="member/index.php">'.$admin_rst_title.'</a>';
         }else{
           $tempurl='<a href="member/index.php">'.$admin_rst_title.'</a>';
         }

	  $temp_string3.=<<<_EOT_
<table>
<tr>
<td width="90" valign="top" nowrap> {$temp}</td>
<td width="11">&nbsp;</td>
<td valign="top">{$tempurl}</td>
</tr>
</table>
_EOT_;
        }
      }

//print($temp_string3);print("test");exit();

$temp_string =<<<_EOT_
<!--���-->
<div id="colInfo">

<div id="infoEvent">
<div class="title">
<h3><span>���٥�ȡ�������Τ��Τ餻</span></h3><a href="news.php?category203=1">������</a><p class="clr"></p>
</div>
{$temp_string1}
</div>

<div id="infoCity">
<div class="title">
<h3><span>�ܻ�̱�γ��ͤ�</span></h3><a href="news.php?category203=2">������</a><p class="clr"></p>
</div>
{$temp_string2}
</div>

<div id="infoMember">
<div class="title">
<h3><span>����γ��ͤ�</span></h3><a href="member/news.php">������</a><p class="clr"></p>
</div>
{$temp_string3}
</div>

</div>
_EOT_;
//print($temp_string1);exit();

$temp_string=mb_convert_encoding($temp_string, "SJIS", "EUC-JP");
      $fp = fopen('../index.html', 'r');
      // ��ü��ã����ޤǥ롼��
      while (!feof($fp)) {
        // �ե����뤫�����ɤ߹���
        $line .= fgets($fp)."\n";
      }
      //print($line);print("test");exit();
      // �ե�����򥯥���������
      fclose($fp);

      $contents = $line;
      $contents=mb_ereg_replace ( "<!--{$REPLACETAG}_start-->.*<!--{$REPLACETAG}_end-->", "<!--{$REPLACETAG}_start-->{$temp_string}<!--{$REPLACETAG}_end-->", $contents);
      $contents=mb_ereg_replace ( "\n\n", "\n", $contents);


//print($temp_string);print("test");exit();
//print($contents);print("test");exit();

//print($REPLACETAG);
//print($contents);print("test");exit();
      if ($contents) {
        $fp = fopen('../index.html', 'w');
        fputs($fp, $contents);
        fclose($fp);
      }
      Return $values;
    }



}
?>