<span style="color: #009933; font-style: italic;">/**
* 批量更改旧文章的别名为ID
* 使用方法:将代码添加到网站根目录的 wp-config.php 的最底部,访问一次网站首页,等页面打开后,再删除这些代码
* https://www.wpdaxue.com/wordpress-using-post-id-as-slug.html
*/</span>
<span style="color: #666666; font-style: italic;">// 添加一个变量来包容文章标题数组,防止重复操作</span>
<span style="color: #000088;">$slug_done</span> <span style="color: #339933;">=</span> <span style="color: #990000;">array</span><span style="color: #009900;">(</span><span style="color: #009900;">)</span><span style="color: #339933;">;</span>
<span style="color: #666666; font-style: italic;">// 查询所有文章</span>
<span style="color: #000088;">$posts</span> <span style="color: #339933;">=</span> <span style="color: #000088;">$wpdb</span><span style="color: #339933;">-></span><span style="color: #004000;">get_results</span><span style="color: #009900;">(</span> <span style="color: #0000ff;">"
SELECT
`ID`,
`post_title`
FROM
`"</span> <span style="color: #339933;">.</span> <span style="color: #000088;">$wpdb</span><span style="color: #339933;">-></span><span style="color: #004000;">posts</span> <span style="color: #339933;">.</span> <span style="color: #0000ff;">"`
WHERE
`post_type` = 'post'
"</span> <span style="color: #009900;">)</span><span style="color: #339933;">;</span>
<span style="color: #666666; font-style: italic;">// 输出文章</span>
<span style="color: #b1b100;">foreach</span><span style="color: #009900;">(</span> <span style="color: #000088;">$posts</span> <span style="color: #b1b100;">AS</span> <span style="color: #000088;">$single</span> <span style="color: #009900;">)</span> <span style="color: #009900;">{</span>
<span style="color: #000088;">$this_slug</span> <span style="color: #339933;">=</span> <span style="color: #000088;">$single</span><span style="color: #339933;">-></span><span style="color: #004000;">ID</span><span style="color: #339933;">;</span>
<span style="color: #000088;">$slug_done</span><span style="color: #009900;">[</span><span style="color: #009900;">]</span> <span style="color: #339933;">=</span> <span style="color: #000088;">$this_slug</span><span style="color: #339933;">;</span>
<span style="color: #666666; font-style: italic;">// 使用文章ID替换文章原来的别名</span>
<span style="color: #000088;">$wpdb</span><span style="color: #339933;">-></span><span style="color: #004000;">query</span><span style="color: #009900;">(</span> <span style="color: #0000ff;">"
UPDATE
`"</span> <span style="color: #339933;">.</span> <span style="color: #000088;">$wpdb</span><span style="color: #339933;">-></span><span style="color: #004000;">posts</span> <span style="color: #339933;">.</span> <span style="color: #0000ff;">"`
SET
`post_name` = '"</span> <span style="color: #339933;">.</span> <span style="color: #000088;">$this_slug</span> <span style="color: #339933;">.</span> <span style="color: #0000ff;">"'
WHERE
`ID` = '"</span> <span style="color: #339933;">.</span> <span style="color: #000088;">$single</span><span style="color: #339933;">-></span><span style="color: #004000;">ID</span> <span style="color: #339933;">.</span> <span style="color: #0000ff;">"'
LIMIT 1
"</span> <span style="color: #009900;">)</span><span style="color: #339933;">;</span>
<span style="color: #009900;">}</span>
请先
!