<?php
	$ini = parse_ini_file("conf.ini", true);
	mysql_connect($ini['db']['host'],$ini['db']['user'],$ini['db']['pass']);
	mysql_select_db($ini['db']['db']);

	$sql=mysql_query('SET CHARACTER SET utf8');

	$postfix=$_REQUEST['postfix'];
	$nick=$_REQUEST['nick'];
	$password=$_REQUEST['password'];

	if ($nick<>''){
		if ($ini['db']['log']=="1"){
			$arrival_time=microtime(true);
			$filename=basename(__FILE__);
			$filename="log_".$filename.".txt";
			$chunck=strval($arrival_time)." ".$_SERVER['REQUEST_URI'].$nick."\r\n";
			file_put_contents($filename,$chunck,FILE_APPEND);
		}

		if (!empty($_REQUEST['u_code']))
		{
			$user_code=$_REQUEST['u_code'];
		}
		else
		{
			$user_code=0;
		}

		if (strcmp($postfix,'_ita_gen')==0){
			$online_table='online_chat_ita';
		}
		if (strcmp($postfix,'_es_gen')==0){
			$online_table='online_chat_es';
		} 
		if (strcmp($postfix,'_eng_gen')==0){
			$online_table='online_chat_eng';
		}	 
		if (strcmp($postfix,'_pt_gen')==0){
			$online_table='online_chat_pt';
		}	
		if (strcmp($postfix,'_jp_gen')==0){
			$online_table='online_chat_jp';
		}	
		if (strcmp($postfix,'_zh_gen')==0){
			$online_table='online_chat_zh';
		}
		if (strcmp($postfix,'_tag_gen')==0){
			$online_table='online_chat_tag';
		}

		if ($user_code!=0){
			$sql=mysql_query("select user_code,last_known_user_id,canbemoderator from contest_nick where user_code=$user_code limit 1");
		}
		else{
			$sql=mysql_query("select user_code,last_known_user_id,canbemoderator from contest_nick where nick='$nick' and pwd='$password' limit 1");
		}
		if (mysql_num_rows($sql)){ 
			$match=1;
			$user_code=mysql_result($sql,0,"user_code");
			$canbemoderator=mysql_result($sql,0,"canbemoderator");
			$user_id=mysql_result($sql,0,"last_known_user_id");
			if ($canbemoderator==1){
				$sql=mysql_query("select count(*) as c from $online_table where moderator=1 and status=0");
				$c=mysql_result($sql,0,"c");
				if ($c<=2){
					$moderator=1;
				}
				else{
					$moderator=0;
				}
				$sql=mysql_query("update contest_nick set moderator=$moderator where user_code=$user_code limit 1");
			}
			else{
				$moderator=0;
			}
			$sql=mysql_query("replace into $online_table (user_code,user_id,nick,moderator,date) values ($user_code,$user_id,'$nick',$moderator,NOW())");
		}
	}
	 
	mysql_close();
?>