Discuz!X3 楼层错乱临时解决方案 - 无限星辰工作室-客户无限互联网动力之源

@set_time_limit(0);
//connection to db
$mysql_server_name='localhost';
$mysql_username='root'; //改成自己的用户名
$mysql_password='12345678'; //改成自己的密码
$mysql_database='dbname'; //改成自己的数据库名字
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$table_name="pre_forum_post"; //改成自己的数据表名称
//to correct the error on floors in topics
$sql = "SELECT tid FROM $table_nameWHERE first=1 AND position>1";
$result=mysql_query($sql,$conn);
while ($row=mysql_fetch_array($result))
{
$n=1;
$sql="selectpid from $table_name where tid=" . $row["tid"] . " order bydateline asc";
$rs=mysql_query($sql,$conn);
while($r=mysql_fetch_array($rs))
{
$sql="update $table_name setposition=" . $n . " where pid=" . $r["pid"];
mysql_query($sql);
$n++;
}//end while $r
mysql_free_result($rs);
} // end while $row
echo "
done with records:" . mysql_num_rows($result);
mysql_free_result($result);
mysql_close($conn);
?>

复制代码