<?
//********************************************************
//訪問者ブログパーツ（バナー版）
//********************************************************

//********************************************************
//INCLUDEセクション（基本関数等のインクルード）
//********************************************************

//require_once ("/var/www/html/com/rss_fetch.inc");
//include("/com/com_func.inc");
header("Content-type: application/x-javascript");
header("P3P: CP='UNI CUR OUR'");

//トラフィックエクスチェンジで超高負荷対応
if( $_REQUEST["m"] == '4bd3bd4c56f7e' ){ 
	echo "document.write('');\n";
	exit();
}

//コミュニティのサブドメイン
$g_com_domain ="community.edita.jp";
$g_usr_dir = "/var/www/html";	//本番

$g_site_url = "http://community.edita.jp";		//テスト
$g_usr_dir = "/var/www/html";	//テスト

//アカウントのサブドメイン
$g_acc_domain ="account.edita.jp";


include($g_usr_dir."/com/const.inc");
include($g_usr_dir."/com/db_func.inc");


define('MAGPIE_OUTPUT_ENCODING', 'UTF-8');


$p_member_id = $_REQUEST["m"];
$p_blog = $_REQUEST["b"];
$gm_member_id = $_COOKIE['member_id'];

switch($p_blog){
	case 1:		$p_blog_no = "m1";	break;
	case 2:		$p_blog_no = "m2";	break;
	default:	$p_blog_no = "m";	break;
}


if( trim($gm_member_id) != "" ){

	$db_community = db_connect("community");

	$sql = "SELECT member_id FROM member m ";
	$sql .= "WHERE m.member_id='".$gm_member_id."' AND m.del_flg='0' ";
	if( $row = db_fetch(db_execute($sql,$db_community)) ){
		$com_user_flg = 1;
	}else{
		$com_user_flg = "";
	}

	//■コミュニティＤＢから
	if( $com_user_flg == 1 ){
		//■訪問者がコミュニティを利用しているかチェック

		
		//拒否されていないかチェック
		$ng_flg = false;
		$sql = "SELECT member_id FROM member_ng ";
		$sql .= "WHERE member_id='".$p_member_id."' AND ng_member_id='".$gm_member_id."' AND del_flg='0'";

		if( $row = db_fetch(db_execute($sql,$db_community)) ){
			$ng_flg = true;
		}


		//足あとの更新
		if($p_member_id != $gm_member_id and !$ng_flg){

			$sql = "SELECT * FROM member WHERE member_id='".$p_member_id."' ";
			$row = db_fetch(db_execute($sql,$db_community));
	
			switch($p_blog_no){
				case "m":
					$blogurl = $row["blog_url"];
					break;
				case "m1":
					$blogurl = $row["sub_blog1_url"];
					break;
				case "m2":
					$blogurl = $row["sub_blog2_url"];
					break;
			}


			$sql = "SELECT member_id,date_updated FROM blog_footstamp WHERE member_id='".$p_member_id."' AND blog_url='".$blogurl."' AND footstamp_member_id='".$gm_member_id."'";
			if( $row = db_fetch(db_execute($sql,$db_community)) ){
				if( date("Y/m/d H:i:s",strtotime($row["date_updated"])) < date("Y/m/d H:i:s",strtotime("-10 Minute")) ){
					$sql = "UPDATE blog_footstamp SET date_updated=now() WHERE member_id='".$p_member_id."' AND blog_url='".$blogurl."' AND footstamp_member_id='".$gm_member_id."'";
					$ret = db_execute($sql,$db_community);
				}
			}else{

				$column = "";						$value = "";
				$column .= "member_id,";			$value .= "'".$p_member_id."',";
				$column .= "blog_url,";				$value .= "'".$blogurl."',";
				$column .= "footstamp_member_id,";	$value .= "'".$gm_member_id."',";
				$column .= "new_date,";				$value .= "now(),";
				$column .= "del_flg,";				$value .= "'0',";
				$column .= "date_created,";			$value .= "now(),";
				$column .= "date_updated";			$value .= "now()";
				
				$sql = "INSERT INTO blog_footstamp(".$column.") VALUE(".$value.")";
				$ret = db_execute($sql,$db_community);
			}

			//ブログまで来た足あと
			$sql = "SELECT * FROM blog_come_footstamp WHERE member_id='".$p_member_id."' AND blog_url='".$blogurl."' AND footstamp_member_id='".$gm_member_id."' AND footstamp_date='".date("Y/m/d")."'";
			if( $row = db_fetch(db_execute($sql,$db_community)) ){
				if( date("Y/m/d H:i:s",strtotime($row["date_updated"])) < date("Y/m/d H:i:s",strtotime("-10 Minute")) ){
					$sql = "UPDATE blog_come_footstamp SET date_updated=now() WHERE member_id='".$p_member_id."' AND blog_url='".$blogurl."' AND footstamp_member_id='".$gm_member_id."' AND footstamp_date='".date("Y/m/d")."'";
					$ret = db_execute($sql,$db_community);
				}
			}else{

				$column = "";						$value = "";
				$column .= "member_id,";			$value .= "'".$p_member_id."',";
				$column .= "blog_url,";				$value .= "'".$blogurl."',";
				$column .= "footstamp_member_id,";	$value .= "'".$gm_member_id."',";
				$column .= "footstamp_date,";		$value .= "'".date("Y/m/d")."',";
				$column .= "del_flg,";				$value .= "'0',";
				$column .= "date_created,";			$value .= "now(),";
				$column .= "date_updated";			$value .= "now()";
				
				$sql = "INSERT INTO blog_come_footstamp(".$column.") VALUE(".$value.")";
				$ret = db_execute($sql,$db_community);
			}

		}

	}
	db_close($db_community);

}


echo "document.write('<a href=\"".$g_site_url."/member_show/m-".$p_member_id."\" target=\"_blank\"><img src=\"http://image.edita.jp/img/bp/edita_member_banner.gif\" alt=\"エディタコミュニティに参加しています(edita ブログでつながるコミュニティサイト)\" border=\"0\" /></a>');\n";


//■ログの書き込み
if( trim($_SERVER['HTTP_REFERER']) != "" && ( !is_numeric(strpos($_SERVER['HTTP_REFERER'], 'community.edita.jp'))) ){

	$db_log = db_connect("log");
	$sql = "INSERT INTO bp_log (bp_flg,remote_address, remote_host, id, blog_no, referrer, date_created) ";
	$sql .= "VALUES ('1002','".$remote_address."','".$remote_host."','".$p_member_id."','".$p_blog_no."','".$_SERVER['HTTP_REFERER']."',now());";
	$ret = db_execute($sql,$db_log);
}

?>