} // Tracking if (empty($sid) || $mode == "login" || $mode == "dlogin") { $first_sign = "t"; } else { $first_sign = "f"; } $sql = "DELETE FROM tracking WHERE calltime+'" . 24 * $logday . ":00'<now();"; $sql .= "INSERT INTO tracking (serial,id,ip,url,uri,ref,agent,firstsign,calltime) values ("; $sql .= "'" . $sid . "',"; $sql .= "'" . $login_id . "',"; $sql .= "'" . $remote_addr . "',"; $sql .= "'" . db_textsafe(textsafe(mb_convert_encoding($script_name, "EUC-JP"))) . "',"; $sql .= "'" . db_textsafe(textsafe(mb_convert_encoding($request_uri, "EUC-JP"))) . "',"; $sql .= "'" . db_textsafe(textsafe(mb_convert_encoding($referer, "EUC-JP"))) . "',"; $sql .= "'" . db_textsafe(textsafe(mb_convert_encoding($user_agent, "EUC-JP"))) . "',"; $sql .= "'" . $first_sign . "',"; $sql .= "'now()')"; print "<!--"; pg_query($conn, "BEGIN;" . $sql . ";COMMIT;"); print "-->"; ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML lang="ja-JP"> <HEAD> <!--・--> <TITLE>PENGUIN OFFICE</TITLE> <META http-equiv="Content-Type" content="text/html; charset=EUC-JP"> <META http-equiv="page-exit" content="BlendTrans(Duration=0.2)"> <?php # if ($refresh and sizeof($headerr)==0) {
// 60日間以前のログを削除 $lastseqno = get_last("users_location", "seqno", "user_id='" . $login_id . "'", 0); $seqno = $lastseqno + 1; $code = $_GET["location"]; $text = get_first("locations", "name", "id=" . $code, ""); if ($lastseqno > 0) { $lastcode = get_first("users_location", "code", "user_id='" . $login_id . "' AND seqno=" . $lastseqno, 0); } else { $lastcode = ""; } if ($lastcode != $code) { $sql = "INSERT INTO users_location (seqno,user_id,code,text,updatestamp) VALUES ("; $sql .= $seqno . ","; $sql .= "'" . $login_id . "',"; $sql .= "'" . $code . "',"; $sql .= "'" . db_textsafe($text) . "',"; $sql .= "'now'"; $sql .= ")"; $res = pg_query($conn, $sql); } } // ユーザー情報の取得 $sql_user = "******" . $login_id . "'"; $res_user = pg_query($conn, $sql_user); $cnt_user = pg_num_rows($res_user); if ($cnt_user > 0) { $row_user = pg_fetch_array($res_user, 0); // 自身の情報獲得 $users[$login_id] = $row_user["name_ryaku"]; $mygroup = $row_user["mygroup"]; // 秘書(受け)の情報獲得