| <html> |
| <head> |
| <title>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> |
| <?php |
| error_reporting(E_ALL ^ E_NOTICE); |
| require_once 'config.php'; |
| function sql_query($sqlcon){ |
| $con=mysql_connect(DATABASE_HOST, DATABASE_USER, DATABASE_PSSWORD); |
| mysql_select_DB(DATABASE_DB_NAME); |
| mysql_query("SET NAMES 'utf8'"); |
| $result = mysql_query($sqlcon); |
| mysql_close($con); |
| return $result; |
| } |
| $entry_pc = sql_query('SELECT * FROM entry'); |
| $reply_pc = sql_query('SELECT * FROM reply'); |
| $prefix = $_GET['prefix']; |
| if ($prefix == "") $prefix = "mf_"; |
| ?> |
| <form action="convertpc2mf.php" method="GET"> |
| 请输入你的微饭数据库的自定义前缀:<input name="prefix" type="text" value="mf_">(不要忘了最后还有一个'_'哦!) |
| <input type="submit" value="确认"> |
| </form> |
| <p>复制下列代码并在phpMyadmin中执行即可<a href="http://img1.dnschina.net/files/68/insert_into_sql.png" target="_blank" style="font-size:12px;">不懂请看图</a></p> |
| <textarea> |
| <?php |
| while ($entry = mysql_fetch_object($entry_pc)) { |
| $content = $entry -> content; |
| echo "INSERT INTO `" . $prefix . "entry` VALUES "; |
| echo "('','" . $entry -> userid . "','','','','" . addslashes($content) . "','" . $entry -> time . "','" . $entry -> from . "','0','','','');"; |
| echo "\n"; |
| } |
| while($reply =mysql_fetch_object($reply_pc)){ |
| $nickname = $reply -> nickname; |
| $geo = $reply -> geo; |
| if ($nickname == "" && $geo != "owner") { |
| $nickname = $geo . '网友'; |
| $userid = 0; |
| } elseif ($nickaname == "" && $geo == "owner" ) { |
| $userid = 1; |
| $nickname = ""; |
| } |
| echo "INSERT INTO `" . $prefix . "entry` VALUES"; |
| echo "('','" . $userid . "','" . $nickname . "','" . $reply -> email . "','" . $reply -> url . "','" . $reply -> message . "','" . $reply -> time . "','网页','" . $reply -> entryid . "','','','');"; |
| echo "\n"; |
| } |
| ?> |
| </textarea> |
| <p style="margin-top:15px;color:#AAA;"> |
| 友情提示:<br> |
| 1.请确定你是在'微饭'的表中执行代码,并确保微饭已经安装,即存在entry和reply两个表。<br> |
| 2.请输入你的'微饭'表前缀并确定后再复制代码,否则可能导致失败。<br> |
| 3.部分对数据库架构进行过变动的用户可能会导入失败,请修改相关代码后再进行导入。<br> |
| 4.导入前请将原数据库进行备份,以免发生意外损失。 |
| </p> |
| <div id="footer">Powered By <a href="http://imnerd.org">怡红公子</a> | 欢迎报告 <a href="mailto:i@imnerd.org">BUG</a></div> |
| <body> |
| </html></p> |
|
| <p> |