<? 
/*Improve PHP configuration to prevent issues */
ob_start(); 
@ini_set('display_errors'     , 'off');
@ini_set('upload_max_filesize', '100M');
@ini_set('default_charset'    , 'utf-8');
/* Correct Apache charset header('Content-Type: text/html; charset=utf-8');*/
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");	

define('_DB_SERVER_'  , 'localhost');
/*define('_DB_NAME_'    , 'yesicans_uk2');
define('_DB_USER_'    , 'yesicans_uk2');
define('_DB_PASSWD_'  , 'T2ATKDrL4uk2');
define('_TB_PREFIX_'  , 'tb_');*/

define('_DB_NAME_'    , 'koganei_db');
define('_DB_USER_'    , 'koganei_db');
define('_DB_PASSWD_'  , 'kqwibGsV');
define('_TB_PREFIX_'  , 'kgn_');

define('_LOGIN_TIME_' , 3600);
define('_SECURE_','25a82a1d8562f7acac44eb93845e0ae1df5d5658');

session_start();
?><?

class auto_query extends c_db{

	
	/* all unit */

	public function __construct($s_host,$s_name,$s_user,$s_pass = null){

		
		parent::__construct($s_host,$s_name,$s_user,$s_pass);

	}

	/* all unit*/

	
public function admin_login($login,$pass)

	{

		$pass = sha1(mysql_real_escape_string($pass));
		$sql  = 'SELECT admin_id,admin_user,admin_type,pre_code,admin_name FROM '._TB_PREFIX_.'administrators a,
				'._TB_PREFIX_.'permission b ';
		$sql .= 'WHERE admin_user = "'.mysql_real_escape_string($login).'" AND ';
		$sql .= 'admin_pass = "'.$pass.'" AND ' ; 
		$sql .= 'admin_type = pre_type ';
		$sql .= 'LIMIT 0,1';
		

		//echo "$sql"; exit;

		$result = $this->db_query($sql);

		
	while ($record = mysql_fetch_array($result))

		{

			$user_type = $record[admin_type];

			$admin_id = $record[admin_id];

			$admin_code = $record[pre_code];

			$name = $record[admin_name];

		}


		return array($user_type,$admin_id,$admin_code,$name);

	}	

	
	public function fetch_article($status)

	{		
	
	if($status !='')
		{
			 $cont  = ' WHERE post_status ="'.$status.'" ';
		}
		

		$sql = 'SELECT *  FROM '._TB_PREFIX_.'articles '.$cont.' ORDER by Id desc ';

		$result = $this->db_query($sql);

		$i = 0;

				
		while ($rec = mysql_fetch_array($result))

		{

			$data[$i] = $rec; $i++;

		}

		
		return $data;

	}
	
		public function fetch_article_th()

	{		
	
	
		$sql = 'SELECT *  FROM '._TB_PREFIX_.'articles WHERE post_status ="1" and topic_th !="" ORDER by content_date ';

		$result = $this->db_query($sql);

		$i = 0;

				
		while ($rec = mysql_fetch_array($result))

		{

			$data[$i] = $rec; $i++;

		}

		
		return $data;

	}
	
	
	public function view_article($id)

	{

	
 	$sql = ' SELECT * FROM '._TB_PREFIX_.'articles      

				 where 	Id  = "'.$id.'"';

		$result = $this->db_query($sql);

		$i = 0;

			while ($rec = mysql_fetch_array($result))

		{

			$data = $rec;

		}
		

		return $data;

	}
	
	
	public function fetch_article_front($page_first,$page_num)

	{		
	

	$sql = 'SELECT *  FROM '._TB_PREFIX_.'articles WHERE post_status ="1" ORDER by Id desc LIMIT '.$page_first.','.$page_num;

		$result = $this->db_query($sql);

		$i = 0;

				
		while ($rec = mysql_fetch_array($result))

		{

			$data[$i] = $rec; $i++;

		}

		
		return $data;

	}

	
public function fetch_article_front_th($page_first,$page_num)

	{		
	

	$sql = 'SELECT *  FROM '._TB_PREFIX_.'articles WHERE post_status ="1" AND topic_th !="" ORDER by content_date desc LIMIT '.$page_first.','.$page_num;

		$result = $this->db_query($sql);

		$i = 0;

				
		while ($rec = mysql_fetch_array($result))

		{

			$data[$i] = $rec; $i++;

		}

		
		return $data;

	}

	
}


?><? 
function pagenavi_start($page_count,$page_num,$page_now) /*page = $_GET[now] */
{
	if (empty($page_now))
	{
		return 1;	
	}
	else
	{	
		if (ceil($page_count/$page_num) < $page_now)
		{		
			return 1;	
		}
		else
		{
			return $page_now;	
		}
	}
}
function pagenavi_first($page_now,$page_num)
{
	return  (($page_now-1) *$page_num);
}

/* function show page navigation footer bar */
function pagenavi_font($now,$num,$prefix,$show_bypage)
{	
	 $last_page =  ceil($num/$show_bypage); 
	 
	 if ($last_page !=1 )
	 {
	
	
	if ($num == 0)
	{
		$buffer .=  '';
	}
else
{	
$buffer  = ' <nav aria-label="Page navigation example">
<ul class="pagination justify-content-center">
            ';
 
$num;
	/*if ($num < $show_bypage)
	{
		$buffer .= '';
	}*/
/*	else
	{*/
	if ($now > 1)
		{
			$buffer .= '<li class="page-item"><a class="page-link"  href="'.$prefix.($now-1).'" aria-label="Previous">
                                 <span aria-hidden="true">&laquo;</span>
                <span class="sr-only">Previous</span>
                              </a></li>';	
		} else {
			
				//$buffer .= '<li class="next box"><a href="#">前へ</a></li>';	
		}
		
		$page_buffer = '';
		
		for ($i=1;$i <= $last_page;$i++)
		{
			
			
			if ($i == $now )
			{
				
				$page_buffer[$i] = '<li class="page-item  active"><a class="page-link" href="#">'.$i.'</a></li>';
				$buffer .= $page_buffer[$i];
			}
			else
			{
				$page_buffer[$i] = '<li class="page-item"><a class="page-link" href="'.$prefix.$i.'">'.$i.'</a></li>';	
				$buffer .= $page_buffer[$i];
			}
		}	
	//}
	
	/*if (($now <= 5)||($num <= 10))
	{*/	
		
	
		/*case1*/		
		
		/*for ($i = 1;$i<=10;$i++)
		{
			*/
			
	/*		
			
		}*/	
			if ($now != $last_page)
			{
				$buffer .= '<li class="page-item"><a class="page-link" href="'.$prefix.($now+1).'" aria-label="Next">
				
                                 <span aria-hidden="true">&raquo;</span>
                <span class="sr-only">Next</span>
                              </a></li>';
			} else {
				
				//$buffer .= '<li class="next box"><a href="#">次へ</a></li>';
			}
		
		 
	//  }
		$buffer .= '   </ul>
        </nav>  
        ';

}

	 }
	return $buffer;
}


function number_format_zero($i)
{
	if ($i < 10)
	{
		return '0'.$i;
	}
	else
	{
		return $i;
	}
}


?>