怡红院落

<form method="POST" action="action.php?act=post">
<?php if (!$_SESSION['login']) { ?>
昵称:<input name="username" id="username" class="username" type="text" value="<?php echo $_COOKIE['gbook_name']; ?>">
邮箱:<input name="email" id="email" class="email" type="text"value="<?php echo $_COOKIE['gbook_email']; ?>">
网站:<input name="website" id="website" class="website" type="text" value="<?php echo $_COOKIE['gbook_website']; ?>"></p>
<p><textarea name="content" id="content" class="content" rows="5"></textarea>
<input type="submit" value="确认">
<span style="font-size:12px;display:block;color:#CCC;float:right;">你可以使用的标签有：&lt;a&gt;,&lt;img&gt;,&lt;p&gt;,&lt;br&gt;,&lt;b&gt;</span>
</form>

if (!$<em>SESSION['login']) {//判断用户是否登录，如果没登陆执行以下操作
     $username = $</em>POST['username'];//赋值
     setcookie('gbook<em>name',$username,time()+ 604800);//设置COOKIE
     $email = $</em>POST['email'];
     setcookie('gbook<em>email',$email,time()+ 604800);
     $website = $</em>POST['website'];
     setcookie('gbook<em>website',$website,time()+ 604800);
  } else {//登录的话执行以下操作
    $user = sql</em>query ('SELECT * FROM user WHERE username = "admin"');//读取用户数据
    $user = mysql<em>fetch</em>object($user);//对取得的数据进行格式化
    $username = $user -> nickname;//赋值管理员昵称
    $email = $user -> email;
    $website = $user -> url;
  }
     $content =  $<em>POST['content'];
     $ip = getip();//通过getip函数获取用户IP
     $geo = user</em>ip($ip);//通过user<em>ip函数对IP地址进行解析，得到详细地质
     if ($geo = "") {
       $geo = "火星";//如果没IP或解析不到则显示为火星
     }
     $agent = $</em>SERVER[HTTP<em>USER</em>AGENT];//记录使用者的操作系统信息
     if ($username !=="" &amp;&amp; $content !== "" ) {//如果昵称和留言内容都不为空则执行以下内容
       $post<em>time = time();//获取时间
     $content = strip</em>tags($content,'<br><p></p><img><a></a><b></b>');//对留言内容进行格式化
       $insert<em>sql = "INSERT INTO entry (id, username, content, time, email, website, agent, ip, geo) VALUES ('','$username','$content','$post</em>time','$email','$website','$agent','$ip','$geo')";
       sql<em>query($insert</em>sql);//将留言内容写入数据库
       header('Location:index.php');//跳转回首页
     } else {//如果昵称和留言内容二者有一个为空则执行以下语句
         echo "<script>alert('昵称和留言内容是必须要填写的！');</script>";
     }

<ul class="entry">
<?php
$entrys = get_entry_by_page($perpage);//通过自定义了函数来根据页面来显示内容，达到分页效果（这个函数在后面会讲）
while ($entry = mysql_fetch_object($entrys)) {//while循环执行读取格式化后的日志工作
?>
  <li id="entry">
    <span class="avatar">
        <img src="<?php echo getavatar($entry -> email);/*根据留言者的邮箱获取他的Gravatar头像*/ ?>" alt="<?php echo $entry -> username; ?>">
    </span>
   <span class="top">
    <span class="username">
        <a href="<?php echo $entry -> website; ?>" target="_blank" alt="<?php echo $entry -> username; ?>"><?php echo $entry -> username;?></a>
    </span>
    <span class="information">
      <span class="geo">来自<?php echo $entry -> geo; ?></span>
      <span class="agent"><?php echo user_agent($entry -> agent); ?></span>
    </span>
   </span>
    <span class="content"><?php echo nl2br($entry -> content);/*nl2br是将换行变成<br>的函数,不需要太多了解*/ ?></span>
    <span class="time">发表于<?php echo time_past($entry -> time);/*通过自定义函数对Unix时间戳进行格式化并得到距离现在的时间*/ ?></span>
    <span class="rep"><a href="#" onclick="inser('@<?php echo $entry -> username; ?>&nbsp;');return false;">[回]</a>
    <?php if ($_SESSION['login']) { /*如果登录则执行以下代码*/?>
    <span class="del"><a href="action.php?act=del&id=<?php echo $entry -> id; ?>">[删]</a></span>
  <?php } ?>
  </li>
<?php } ?>
</ul>

function get_entry_by_page($perpage) {
  if ($_GET['page'] == "") {//设置当前页的默认值为1
    $_GET['page'] = 1;<br />
  } 
  $page = $_GET['page'];
  $start_entry = ($page - 1) * $perpage;//$prepage为你设置的每页显示的条数
  $entrys = sql_query('SELECT * FROM entry ORDER BY time DESC LIMIT ' . $start_entry . ', ' . $perpage);
  return $entrys;<br />
}

function pages($perpage) {
  $count = sql_query("SELECT COUNT(id) AS total FROM entry"); 
  $count = mysql_fetch_object($count);
  $count = $count -> total;//获取总条数
  if ($count%$perpage == 0) {
    $page_total = intval($count/$perpage);<br />
  } else {
    $page_total = intval($count/$perpage) + 1;<br />
  }//获取总页数
  if ($_GET['page'] == "") {
    $_GET['page'] = 1;<br />
  }
  $page_class = 'page';
  echo '<span class="pages">';
  if ($_GET['page'] != 1) {
    $pre_page = $_GET['page'] - 1;
    echo '<span class="' . $page_class . '"><a href="index.php?page=' . $pre_page . '">&laquo;上一页</a></span>';<br />
  }
  if ($page_total &lt;= 5 ) {
    for ($i=1;$i &lt;= $page_total;$i++) {
      echo '<span class="' . $page_class . '"><a href="index.php?page=' . $i . '">' . $i . '</a></span>';<br />
    }<br />
  } else {
    for ($i=1;$i &lt;= 5;$i++) {
      echo '<span class="' . $page_class . '"><a href="index.php?page=' . $i . '">' . $i . '</a></span>';<br />
    }<br />
    echo "...";
    echo '<span class="' . $page_class . '"><a href="index.php?page=' . $page_total . '">' . $page_total . '</a></span>';<br />
  }
  if ($_GET['page'] != $page_total ) {
    $next_page = $_GET['page'] + 1;
    echo '<span class="' . $page_class . '"><a href="index.php?page=' . $next_page . '">下一页&raquo;</a></span>'; 
  }
  echo '</span>';
}

<html>
<head>
<title>Emlog碎语转PageCookery程序 </title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
    textarea {width:100%;height:200px;}
    form {width:400px;}
    button {float:right;}
    #footer {width:100%;text-align:center;position:fixed;bottom:0px;}
</style>
</head>
<body>
&lt;?php 
    require<em>once 'config.php'; //连接数据库<br />
    function mysql</em>run($sqlcon){<br />
      $con=mysql<em>connect(DB</em>HOST, DB<em>USER,DB</em>PASSWD);
      mysql<em>select</em>db(DB<em>NAME);
      mysql</em>query("SET NAMES 'utf8'");
      $result = mysql<em>query($sqlcon);
      mysql</em>close($con);
      return $result;
    }</p>
<p>?></p>
<p>复制下列代码并在phpMyadmin中执行即可<a href="http://img1.dnschina.net/files/68/insert_into_sql.png" target="_blank" style="font-size:12px;">不懂请看图</a></p>
<p><textarea></p>
<p>&lt;?php</p>
<p>$content = mysql<em>run('SELECT * FROM ' . DB</em>PREFIX . 'twitter');</p>
<p>while($entry=mysql<em>fetch</em>object($content)){
    echo "INSERT INTO <code>entry</code> VALUES ";
    echo "('',1,'" . htmlspecialchars( str<em>replace('&#92;','',$entry -> content) , ENT</em>QUOTES ) . "'," . $entry -> date . ",'Emlog'," . $entry -> author . ");";
}
?></p>
<p><?php
$re = mysql_run('SELECT * FROM ' . DB_PREFIX . 'reply');
while($reply =mysql_fetch_object($re)){
    echo "INSERT INTO `reply` VALUES";
    echo "(''," . $reply -> tid .",'Great Fire Wall', '" . $reply -> ip . "','" . $reply -> content . "'," . $reply -> date . ",'0','" . $reply -> name . "');";
}
?>
</textarea>
<p style="margin-top:15px;color:#AAA;">
    友情提示：<br>
    1.请确定你是在PageCookery的表中执行代码，并确保PageCookery已经安装，即存在entry和reply两个表。<br>
    2.部分对数据库架构进行过变动的用户可能会导入失败，请修改相关代码后再进行导入。<br>
    3.导入前请将原数据库进行备份，以免发生意外损失。
</p>
<div id="footer">Powered By <a href="http://imnerd.org">怡红公子</a> | 欢迎报告 <a href="mailto:i@imnerd.org">BUG</a></div>
<body>
</html>