PhpBB3：修订间差异

来自牛奶河Wiki
跳到导航 跳到搜索
（→‎BOT）
（→‎BOT）
 
（未显示同一用户的5个中间版本）
第7行： 第7行：
phpbb3(3.3.5)
phpbb3(3.3.5)
====页面的标头部分缺少说明====
====页面的标头部分缺少说明====
<head>
<head>
  <meta name='description' content='在此处输入有关页面内容的描述性、富含关键字的文本。'>
</head>
* Bing
<meta name="description" content="必应可帮助你将理论付诸实践，使得搜索更加方便快捷，从而达到事半功倍的效果。"/>
* mwbbs
<meta name='description' content='牛奶河BBS - Milky Way BBS - 牛奶河论坛'>


<meta name='description' content='在此处输入有关页面内容的描述性、富含关键字的文本。'>
</head>
*Bing
<meta name="description" content="必应可帮助你将理论付诸实践，使得搜索更加方便快捷，从而达到事半功倍的效果。"/>
*mwbbs
<meta name='description' content='牛奶河BBS - Milky Way BBS - 牛奶河论坛'>
====title====
====title====
<title>牛奶河BBS - Milky Way BBS</title>
<title>牛奶河BBS - Milky Way BBS</title>
 
=== phpbb3 安装 ===
=== phpbb3 安装 ===
==== php install ====
==== 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
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
[[文件:Phpbb3 email.png|右|无框]]
[[文件:Phpbb3 email.png|右|无框]]


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


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


==== Head ====
==== Head ====
\styles\prosilver\template\
\styles\prosilver\template\
 
  overall_header.html
* overall_header.html
  simple_header.html
* simple_header.html
 
  <meta name="description" content="牛奶河BBS - {PAGE_TITLE} - Milky Way BBS - www.mwbbs.tk" />
  <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">
  <link rel="shortcut icon" href="/images/pangolin.png" type="image/x-icon">
第66行： 第56行：


==== connect db config ====
==== connect db config ====
config.php
config.php


=== phpbb3 恢复 ===
=== phpbb3 恢复 ===
第73行： 第63行：


===phpbb3 升级===
===phpbb3 升级===
*OLD: current
*OLD: current
*NEW: phpBB3
*NEW: phpBB3
====path====
====path====
  #上传的附件
  #上传的附件
  cp -r files ../phpBB3/
  cp -par files ../phpBB3/
  # 等级、表情
  # 等级、表情
  cp -r images ../phpBB3/
  cp -par images ../phpBB3/
# 自定义
cp -par mwbbs ../phpBB3/
  # 聊天窗口
  # 聊天窗口
  cp -r ext/dmzx ../phpBB3/ext/
  cp -par ext/dmzx ../phpBB3/ext/
cp -r mwbbs ../phpBB3/
====file====
====file====
  cp ${FN} ../phpBB3/.
  cp ${FN} ../phpBB3/.
第96行： 第87行：
  <meta name="description" content="{SITENAME} - Milky Way BBS - www.mwbbs.tk" />
  <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
  chown -R www-data:www-data ../phpBB3


=== phpbb3 常用表 ===
=== phpbb3 常用表 ===
==== 版主列表 ====
==== 版主列表 ====
select * from phpbb_moderator_cache;
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 ===
=== BOT ===


==== Google Bot ====
==== Google Bot ====
<nowiki>#</nowiki> Googlebot
# 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 "<nowiki>http://www.ldscf.cf/</nowiki>" "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; +<nowiki>http://www.google.com/bot.html</nowiki>)"
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 "<nowiki>http://www.ldscf.cf/</nowiki>" "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; +<nowiki>http://www.google.com/bot.html</nowiki>)"


==== Bing ====
==== Bing ====
<nowiki>#</nowiki> bingbot/
# 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; +<nowiki>http://www.bing.com/bingbot.htm</nowiki>)"
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; +<nowiki>http://www.bing.com/bingbot.htm</nowiki>)"


==== Archive ====
==== Archive ====
<nowiki>#</nowiki> archive.org_bot
# archive.org_bot
 
207.241.233.139 - - [17/Sep/2022:16:55:47 +0800] "GET /viewtopic.php?t=426&sid=120e04ab709103432a26b7f66986d239 HTTP/1.0" 200 5574 "-" "Mozilla/5.0 (compatible; archive.org_bot +<nowiki>http://archive.org/details/archive.org_bot</nowiki>)"
207.241.233.139 - - [17/Sep/2022:16:55:47 +0800] "GET /viewtopic.php?t=426&sid=120e04ab709103432a26b7f66986d239 HTTP/1.0" 200 5574 "-" "Mozilla/5.0 (compatible; archive.org_bot +<nowiki>http://archive.org/details/archive.org_bot</nowiki>)"


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


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




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

Phpbb.png

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
Phpbb3 email.png

Email

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

/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)"

Archive

# archive.org_bot
207.241.233.139 - - [17/Sep/2022:16:55:47 +0800] "GET /viewtopic.php?t=426&sid=120e04ab709103432a26b7f66986d239 HTTP/1.0" 200 5574 "-" "Mozilla/5.0 (compatible; archive.org_bot +http://archive.org/details/archive.org_bot)"

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)"
取自“https://mwbbs.eu.org/wiki/index.php?title=PhpBB3&oldid=2812”