"; echo "document.write (\"".$out_parts."\");"; exit(); } $out_parts = ""; $out_parts .= ""; echo "document.write (\"".$out_parts."\");"; 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_date = $_REQUEST["d"]; $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; } //■フラッシュタグの出力 $qry = ""; $qry .= "m=" . $p_member_id; $qry .= "&d=" . $p_date; $qry .= "&b=" . $p_blog; $qry .= "&gurl="; $qry .= "&gname=".urlencode("YOU"); $qry .= "&gsrc=".urlencode("http://bp.edita.jp/phone_img/photo_00000001.gif"); if( trim($gm_member_id) != "" ){ $db_community = db_connect("community"); $sql = "SELECT m.*, tn.img_url AS thumbnail_img_url FROM member m "; $sql .= "LEFT JOIN thumbnail tn ON tn.thumbnail_flg='m' AND m.member_id=tn.id "; $sql .= "WHERE m.member_id='".$gm_member_id."' AND m.del_flg='0' "; if( $row = db_fetch(db_execute($sql,$db_community)) ){ $qry = ""; $qry .= "m=" . $p_member_id; $qry .= "&d=" . $p_date; $qry .= "&b=" . $p_blog; $qry .= "&gurl=".urlencode("http://community.edita.jp/member_show/m-".$gm_member_id); $qry .= "&gname=".urlencode($row["member_nickname"]); if( $row["img_url"] != "" ) $qry .= "&gsrc=".urlencode($row["img_url"]); else $qry .= "&gsrc=".urlencode($row["thumbnail_img_url"]); $com_user_flg = 1; }else{ $com_user_flg = ""; } //■コミュニティＤＢから //訪問者の情報を取得 //$sql = "SELECT m.*, tn.img_url AS thumbnail_img_url FROM member m "; //$sql .= "LEFT JOIN thumbnail tn ON tn.thumbnail_flg='m' AND m.member_id=tn.id "; //$sql .= "WHERE m.member_id='".$gm_member_id."'"; //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); } //■キャッシュ対策 $swf = "http://bp.edita.jp/swf/prof_big.swf?".date("Ymdhns"); $w = "160"; $h = "396"; echo "document.write('');\n"; echo "var Tags='"; echo ""; echo "';\n\n"; echo "document.write(Tags);\n"; //クッキー取得 //------------------// //　パラメータ取得　// //------------------// //------------// //　環境変数　// //------------// //■訪問者がコミュニティメンバーのとき if( $gm_member_id != "" ){ } //■ログの書き込み 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 ('1001','".$remote_address."','".$remote_host."','".$p_member_id."','".$p_blog_no."','".$_SERVER['HTTP_REFERER']."',now());"; $ret = db_execute($sql,$db_log); } ?>