如何使用SQL快速設定每個板面的權限
不然幾十個板一個一個設眼睛很酸，而且怕一個不小心就設錯了！
所以我才想到要用SQL直接快速設定每一個板面！
所有會員因該是０
註冊會員則是１
板面管理員因該是３吧？\r
檢視 閱讀 發表 回覆 編輯 刪除\r
０ ０ １ １ １ ３
置頂 公告 投票 票選活動
３ ３ １ ３
[閒聊]如何使用SQL快速設定？內詳
版主: 版主管理群
版面規則
本區是討論關於 phpBB 2.0.X 架設安裝上的問題，只要有安裝任何外掛，請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表，違者砍文)
本區是討論關於 phpBB 2.0.X 架設安裝上的問題，只要有安裝任何外掛，請到外掛討論相關版面按照公告格式發表。
(發表文章請按照公告格式發表，違者砍文)
代碼: 選擇全部
UPDATE phpbb_forums SET
auth_view = '?',
auth_read = '?',
auth_post = '?',
auth_reply = '?',
auth_edit = '?',
auth_delete = '?',
auth_sticky = '?',
auth_announce = '?',
auth_vote = '?',
auth_pollcreate = '?'
WHERE forum_id in ( forum_id1 , forum_id2 ,forum_id3... )
所有會員=0
註冊會員=1
群組成員=2
版面管理員=3
系統管理員=5
auth_view=閱讀
auth_read=發表
auth_post=發表
auth_reply=回覆
auth_edit=編輯
auth_delete=刪除\r
auth_sticky=置頂
auth_announce=公告
auth_vote=投票\r
auth_pollcreate=票選活動
try this.
UPDATE phpbb_forums SET
auth_view = 'NULL',
auth_read = 'NULL',
auth_post = 'NULL',
auth_reply = 'NULL',
auth_edit = 'NULL',
auth_delete = 'NULL',
auth_sticky = 'NULL',
auth_announce = 'NULL',
auth_vote = 'NULL',
auth_pollcreate = 'NULL'
WHERE forum_id = '---' AND '---' AND '---' AND '---' ;
UPDATE phpbb_forums SET
auth_view = 'NULL',
auth_read = 'NULL',
auth_post = 'NULL',
auth_reply = 'NULL',
auth_edit = 'NULL',
auth_delete = 'NULL',
auth_sticky = 'NULL',
auth_announce = 'NULL',
auth_vote = 'NULL',
auth_pollcreate = 'NULL'
WHERE forum_id = '---' AND '---' AND '---' AND '---' ;
文 寫:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '. . )' at line 12
UPDATE phpbb_forums SET
auth_view = '?',
auth_read = '?',
auth_post = '?',
auth_reply = '?',
auth_edit = '?',
auth_delete = '?',
auth_sticky = '?',
auth_announce = '?',
auth_vote = '?',
auth_pollcreate = '?'
WHERE forum_id in ( forum_id1 , forum_id2 ,forum_id3... )
最後一行的 in (forum_id1,fourm_id2,forum_id3..)
fourm_id1是填你要改的版面id啊
..是若有其他id則繼續下去啊
例如你要改版面 3,4,5
那最後一行就是\r
WHERE forum_id in ( 3,4,5 )
ID要自己輸入？那有幾十個板就要把所有的ID都輸入？GaryFu 寫:文 寫:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '. . )' at line 12
UPDATE phpbb_forums SET
auth_view = '?',
auth_read = '?',
auth_post = '?',
auth_reply = '?',
auth_edit = '?',
auth_delete = '?',
auth_sticky = '?',
auth_announce = '?',
auth_vote = '?',
auth_pollcreate = '?'
WHERE forum_id in ( forum_id1 , forum_id2 ,forum_id3... )
最後一行的 in (forum_id1,fourm_id2,forum_id3..)
fourm_id1是填你要改的版面id啊
..是若有其他id則繼續下去啊
例如你要改版面 3,4,5
那最後一行就是\r
WHERE forum_id in ( 3,4,5 )
我先認分一點用手動的好了XD
-
GeniusKiKi
- 竹貓忠實會員
- 文章: 1086
- 註冊時間: 2003-10-28 14:50
