<?php
$kanshiconfig=array(
'schools'=>array(
'abroad'=>array(
),
'misuzu'=>array(
),
'macc'=>array(
),
'sho-shin'=>array(
),
'heart-c'=>array(
),
'hiyoshi'=>array(
),
'jujiya'=>array(
),
'akamon'=>array(
),
'sms_basic'=>array(
),
'freedb'=>array(
),
'gojuku'=>array(
),
'hamax'=>array(
),
'hils'=>array(
),
'horizon'=>array(
),
'iidabashi'=>array(
),
'kanebo'=>array(
),
'iidabashi'=>array(
),
//			'kaplan'=>array(
//				'kanshiurl'=>'http://kaplan.e-school.jp/',
//			),
),
// akamon basic free gojuku hamax heart_c hills hiyoshi horizon iidabashi jujiya kanebo macc misuzu shoshin 
'checks'=>array(

),
);

class technopian_kanshi_server {

	var $host      = "localhost";
	var $sock      = "";
	var $port      = "";
	var $user      = "db3tcpmaster";
	var $passwd    = "94pwVh5CGD";
	var $db        = "";
	var $connected = false;
	var $link      = null;

	function process() {
		global $kanshiconfig;

		$this->connect();

		$sms_user_name="admin";
		$sms_user_hash="a76813a988bea0231d1f63e291181dc4";

		$schools=$kanshiconfig['schools'];
		$is_err=false;
		$res_str="";
		foreach($schools as $school_name=>$school_arr) {

			$this->db=$school_name;
			$is_selected_db=$this->select_db();
			if ($is_selected_db) {
				$this->db_res( "SET NAMES 'utf8'" );
			}

			unset($res);
			if ($is_selected_db) {
				$res=$this->db_res("select user_name from users where user_name='$sms_user_name' AND user_hash='$sms_user_hash' AND deleted=0 ");
			}
			$row=array();
			if (isset($res) && $res) {$row=mysql_fetch_assoc($res);}
			if (!empty($row) && $row['user_name']==$sms_user_name) {
				$res_str .= "\n{$school_name}\tyes<br>";
			} else {
				$is_err=true;
				$res_str .= "\n<span style='color:#ff0000;'>{$school_name}\tno</span><br>";
			}
		}
		
		if ($is_err) {
			$res_str ="E-school: error\n<br>".$res_str;
		} else {
			$res_str ="E-school: noproblem\n<br>".$res_str;
		}
		echo $res_str;

	}


	function connect()
	{
		if ( $this->connected )
		return;

		if( strlen($this->port) )
		$this->port = ":".$this->port;

		if ( strlen($this->sock) )
		$this->sock = ":".$this->sock;

		$this->link = @mysql_connect( $this->host . $this->port . $this->sock, $this->user, $this->passwd );

		if ( $this->link )
		$this->connected = true;

		return $this->connected;
	}

	function select_db()
	{
		return mysql_select_db( $this->db,$this->link );  // yahya
	}


	function db_res( $query, $error_checking = true )
	{

		$res = mysql_query( $query, $this->link );
		if ( $error_checking && !$res ){
			//$this->genMySQLErr($query );
		}

		return $res;
	}

	function genMySQLErr($query) {
		echo  $query ."<br>";
		echo mysql_error() ."<br>";
	}

}




$kanshi=new technopian_kanshi_server();
$kanshi->process();

?>