帝国cms会员空间模板显示最近来访访客信息

CREATE TABLE `{$dbtbpre}_userkjf` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `lfuserid` varchar(20) CHARACTER SET gbk DEFAULT NULL,   `bfuserid` varchar(100) CHARACTER SET gbk NOT NULL,   `ip` char(50) CHARACTER SET gbk DEFAULT NULL,   `ipdl` char(50) CHARACTER SET gbk DEFAULT NULL,   `lftime` char(20) CHARACTER SET gbk NOT NULL,   PRIMARY KEY (`id`),   UNIQUE KEY `id` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1 AUTO_INCREMENT=65;

<?php // 取得登陆者信息 $userid = getcvar('mluserid');    // 会员ID $uid = $_GET['userid']; // 当前空间的主人ID  if ($uid != $userid) {     // 如果访客已登陆，则记录访客信息     if ($userid) {         $lfUname = $_COOKIE["lfUname"]; // 获取访客信息          $fkdd = $empire->fetch1("SELECT * FROM {$dbtbpre}userkjf WHERE bfuserid='{$uid}' AND lfuserid='{$userid}'");          if (!$fkdd) {             $empire->query("INSERT INTO {$dbtbpre}userkjf (lfuserid, bfuserid, lftime) VALUES ('{$userid}', '{$uid}', '".date('Y-m-d H:i:s')."')");         }     } else { // 如果访客未登陆，则记录IP和地区信息         // 取得IP 和地区         $gifo = new get_gust_info();         $ip = $gifo->Getip();         $ipadds = $gifo->Getaddress();         $ipdl = '';         foreach ($ipadds[0] as $value) {             $ipdl .= iconv("utf-8", "gbk", $value);         }          // 获取访客信息         $lfUname = $_COOKIE["lfUname"];          if ($lfUname == '') {             $empire->query("INSERT INTO {$dbtbpre}userkjf (bfuserid, ip, ipdl, lftime) VALUES ('{$uid}', '{$ip}', '{$ipdl}', '".date('Y-m-d H:i:s')."')");             setcookie("lfUname", "游客", time() + 1200); // 创建来访客信息，20分钟过期         }     } } ?>  <?php // 作用取得客户端的ip、地理信息、浏览器、本地真实IP class get_gust_info {     // 获得访客真实ip     function Getip() {         if (!empty($_SERVER["HTTP_CLIENT_IP"])) {             $ip = $_SERVER["HTTP_CLIENT_IP"];         }         if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { // 获取代理ip             $ips = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']);         }         if ($ip) {             array_unshift($ips, $ip);         }          $count = count($ips);         for ($i = 0; $i < $count; $i++) {             if (!preg_match("/^(10|172.16|192.168)./i", $ips[$i])) { // 排除局域网ip                 $ip = $ips[$i];                 break;             }         }         $tip = empty($_SERVER['REMOTE_ADDR']) ? $ip : $_SERVER['REMOTE_ADDR'];         if ($tip == "127.0.0.1") { // 获得本地真实IP             return $this->get_onlineip();         } else {             return $tip;         }     }      // 获得本地真实IP     function get_onlineip() {         $mip = file_get_contents("http://city.ip138.com/city0.asp");         if ($mip) {             preg_match("/[.*]/", $mip, $sip);             $p = array("/[/", "/]/");             return preg_replace($p, "", $sip[0]);         } else {             return "获取本地IP失败！";         }     }      // 根据ip获得访客所在地地名     function Getaddress($ip = '') {         if (empty($ip)) {             $ip = $this->Getip();         }         $ipadd = file_get_contents("http://int.dpool.sina.com.cn/iplookup/iplookup.php?ip=" . $ip); // 根据新浪api接口获取         if ($ipadd) {             $charset = iconv("gbk", "utf-8", $ipadd);             preg_match_all("/[\x{4e00}-\x{9fa5}]+/u", $charset, $ipadds);              return $ipadds; // 返回一个二维数组         } else {             return "地址未知";         }     } } ?>  <?php // 会员空间访客显示开始 $fkSQL = "SELECT * FROM {$dbtbpre}userkjf WHERE bfuserid='{$uid}' ORDER BY id DESC LIMIT 5"; $fkSQL = $empire->query($fkSQL);  while ($rs = $empire->fetch($fkSQL)) {     if ($rs['lfuserid']) {         $fkxxrs = $empire->fetch1("SELECT userid, truename, userpic FROM {$dbtbpre}enewsmemberadd WHERE userid='{$rs['lfuserid']}' LIMIT 1");         ?>         <li>             <a href="/e/space/index.php?userid=<?=$fkxxrs['userid']?>"><img src="<?=$fkxxrs['userpic'] ? $fkxxrs['userpic'] : '/templets/member/common/images/dfboy.png'?>" alt="<?=$fkxxrs['truename']?>" /></a>             <a href="/e/space/index.php?userid=<?=$fkxxrs['userid']?>"><?=$fkxxrs['truename']?></a>         </li>         <?php     } else {         ?>         <li>             <a href="#"><img src="../data/images/nouserpic.gif" /></a>             <span>                 <div><?= $rs['ipdl'] ? "来自: " . $rs['ipdl'] : "未知地区" ?></div>                 <br>                 <div><?= $rs['lftime'] ?></div>             </span>         </li>         <?php     } } // 会员空间访客显示结束 ?>