PhpBB3：修订间差异

2024年10月13日 (日) 12:22的最新版本

About phpBB^®

Millions of people use phpBB on a daily basis, making it the most widely used open source bulletin board system in the world. Whether you want to stay in touch with a small group of friends or are looking to set up a large multi-category board for a corporate website, phpBB has the features you need built-in.

SEO

phpbb3(3.3.5)

页面的标头部分缺少说明

<head>
  <meta name='description' content='在此处输入有关页面内容的描述性、富含关键字的文本。'>
</head>

Bing

<meta name="description" content="必应可帮助你将理论付诸实践，使得搜索更加方便快捷，从而达到事半功倍的效果。"/>

mwbbs

<meta name='description' content='牛奶河BBS - Milky Way BBS - 牛奶河论坛'>

title

<title>牛奶河BBS - Milky Way BBS</title>

phpbb3 安装

php install

apt install libapache2-mod-php7.4 openssl php-imagick php7.4-common php7.4-curl php7.4-gd php7.4-imap php7.4-intl php7.4-json php7.4-ldap php7.4-mbstring php7.4-mysql php7.4-pgsql php-ssh2 php7.4-sqlite3 php7.4-xml php7.4-zip php-net-ftp unzip

Email

SMTP 服务器地址和协议：smtp-mail.outlook.com
SMTP 服务器端口：587
SMTP 验证方式：PLAIN
SMTP 用户名：[email protected]
SMTP 密码：MWw.123
验证 SSL 证书：是
验证 SMTP 端名字：是

LOGO

/var/www/html/phpbb/styles/prosilver/theme/images/site_logo.svg

Head

\styles\prosilver\template\
  overall_header.html
  simple_header.html

<meta name="description" content="牛奶河BBS - {PAGE_TITLE} - Milky Way BBS - www.mwbbs.tk" />
<link rel="shortcut icon" href="/images/pangolin.png" type="image/x-icon">

配置等级

否则只有一个管理员等级，很令人迷惑

用户等级_1.ranks下有相应图标（支持子目录）

用户等级_2.用户和组 -> 管理等级

用户等级_3.等级表单

用户等级_4.等级表单_指派特殊等级

维护 -> 错误日志

connect db config

config.php

phpbb3 恢复

mysql phpbb << ${FILENAME}.sql
可能需要清除缓存：ACP -> 综合 -> 清除缓存

phpbb3 升级

*OLD: current
*NEW: phpBB3

path

#上传的附件
cp -par files ../phpBB3/
# 等级、表情
cp -par images ../phpBB3/
# 自定义
cp -par mwbbs ../phpBB3/
# 聊天窗口
cp -par ext/dmzx ../phpBB3/ext/

file

cp ${FN} ../phpBB3/.

config.php
sitemap.xml
robots.txt
各搜索引擎的证书/验证文件
styles/prosilver/theme/images/site_logo.svg

文件修改

styles/prosilver/template/overall_header.html
styles/prosilver/template/simple_header.html

<title>牛奶河BBS - Milky Way BBS</title>
<meta name="description" content="{SITENAME} - Milky Way BBS - www.mwbbs.tk" />

chown -R www-data:www-data ../phpBB3

phpbb_upgrade.sh

#!/bin/bash

# 当前目录
CURRENT=html
NEW=phpBB3

cd $CURRENT

#上传的附件
cp -par files ../${NEW}/
# 等级、表情
cp -par images ../${NEW}/
# 自定义
cp -par mwbbs ../${NEW}/

FL_I=(
   config.php
   sitemap.xml
   googleba45e31fd4a15ff5.html
   sitemap.xml
   robots.txt
   styles/prosilver/theme/images/site_logo.svg
   styles/prosilver/template/overall_header.html
   styles/prosilver/template/simple_header.html
)

for FN in ${FL_I[*]};do
   cp -pa ${FN} ../${NEW}/${FN}
done

chown -R www-data:www-data ../phpBB3

phpbb3 常用表

版主列表

select * from phpbb_moderator_cache;

修改查看次数

original backup

create table phpbb_topics_20221030 select * from phpbb_topics;

topic_id unique

select   topic_id,
         count(*) cs
from     phpbb_topics
group by topic_id
order by 2 desc;

topic

select   *
from     phpbb_topics
where    topic_id = 14;

update

update   phpbb_topics
set      topic_views = 1
where    topic_id = 14;

BOT

Google Bot

# Googlebot
66.249.64.18 - - [21/Feb/2022:21:44:59 +0800] "GET /styles/prosilver/theme/zh_cmn_hans/stylesheet.css?assets_version=2 HTTP/1.1" 200 444 "http://www.ldscf.cf/" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.80 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"

Bing

# bingbot/
192.168.32.3 - - [21/Feb/2022:02:57:04 +0800] "GET /phpbb/index.php HTTP/1.1" 200 4045 "-" "Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)"

petalsearch

# 据说是华为的
114.119.160.84 - - [04/Jan/2023:15:09:01 +0800] "GET /viewtopic.php?t=455&view=print HTTP/1.1" 200 1774 "http://132.145.63.24/viewtopic.php?t=455" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"

DuckDuckGo

69.64.55.90 - - [10/Apr/2023:19:05:36 +0800] "GET / HTTP/1.1" 200 3886 "http://www.mwbbs.tk" "DuckDuckBot/1.0; (+http://duckduckgo.com/duckduckbot.html)"