主题设置1.01[关键字: 附件，关闭，置顶，天](新加入批量和更新BUG)

tks999 · 发表于 2005-9-25 11:51:21

最后修改日期： ---
适用版本：2.5SP1
插件名称：主题设置
作　　者：tks999(tks000)
数据升级：有
修改文件：topicadmin.php,include/forum.php
修改模板：viewthread.htm
安装难度：简单
最后发表日期：---
插件功能简介：该功能能够实现设置主题关闭时间，置顶时间，删除附件时间,该插件部分代码参考liuqiang的显示置顶
演示或技术支持网站:http://bbs3.15mm.info:100
http://dev.freediscuz.net/dev

1.升级数据

ALTER TABLE cdb_threads ADD closeday int(10) DEFAULT 0 NOT NULL;
ALTER TABLE cdb_attachments ADD deleteday int(10) DEFAULT 0 NOT NULL;
ALTER TABLE cdb_threads ADD deleteday int(10) DEFAULT 0 NOT NULL;
ALTER TABLE cdb_threads ADD topday int(10) DEFAULT 0 NOT NULL;

复制代码

2.上传附件到templates/default

3.打开topicadmin.php
查找

} elseif($action == 'digest' && $allowdigest) {

复制代码

上面加入

} elseif($action == 'settings') {
if(!submitcheck('settingssubmit')) {
include template('topicadmin_settings');
} else {
if($settingstype == 0) {
if($closeday > 0) {
$closeday = $timestamp+86400*$closeday;
}
else {
$closeday = 0;
}
$db->query("UPDATE $table_threads SET closeday='$closeday' WHERE tid='$tid' AND fid='$fid'");
}
if($settingstype == 1) {
if($deleteday > 0) {
$deleteday = $timestamp+86400*$deleteday;
}
else {
$deleteday = 0;
}
$db->query("UPDATE $table_attachments SET deleteday='$deleteday' WHERE tid='$tid'");
$db->query("UPDATE $table_threads SET deleteday='$deleteday' WHERE tid='$tid'");
}
if($settingstype == 2) {
if($topday > 0) {
$topday = $timestamp+86400*$topday;
}
else {
$topday = 0;
}
$db->query("UPDATE $table_threads SET topday='$topday' WHERE tid='$tid' AND fid='$fid'");
}
modlog();
showmessage('admin_succeed', "viewthread.php?tid=$tid&page=$fpage");
}

复制代码

打开include/forum.php
查找

if(!defined('IN_DISCUZ')) {
exit('Access Denied');
}

复制代码

下面加入

$query = $db->query("UPDATE $table_threads SET closed='1' where closeday<>'0' AND closeday<'$timestamp'");
$query = $db->query("UPDATE $table_threads SET displayorder='1' where topday<>'0' AND topday<'$timestamp'");
$query = $db->query("SELECT attachment FROM $table_attachments WHERE deleteday<>'0' AND deleteday<'$timestamp'");
while($attach = $db->fetch_array($query)) {
@unlink(DISCUZ_ROOT.'./'.$attachdir.'/'.$attach['attachment']);
}
$db->query("DELETE FROM $table_attachments where deleteday<>'0' AND deleteday<'$timestamp'");
$query = $db->query("UPDATE $table_threads SET attachment='0' where deleteday<>'0' AND deleteday<'$timestamp'");

复制代码

打开viewthread.htm
查找

<option value="recount">{lang admin_recount}</option>

复制代码

下面加入

<option value="settings">主题设置</option>

复制代码

[ 本帖最后由 tks999 于 2005-9-26 21:58 编辑 ]

lu5266 · 发表于 2005-9-25 11:52:09

好东西

tks999 · 发表于 2005-9-25 11:54:20

修正附件不会在attachments文件夹删除(请在26-9-05年之前安装的用户更新)
打开include/forum.php
查找

$query = $db->query("UPDATE $table_threads SET closed='1' where closeday<>'0' AND closeday<'$timestamp'");
$query = $db->query("UPDATE $table_threads SET displayorder='1' where topday<>'0' AND topday<'$timestamp'");
$db->query("DELETE FROM $table_attachments where deleteday<>'0' AND deleteday<'$timestamp'");
$query = $db->query("UPDATE $table_threads SET attachment='0' where deleteday<>'0' AND deleteday<'$timestamp'");

复制代码

替换为

$query = $db->query("UPDATE $table_threads SET closed='1' where closeday<>'0' AND closeday<'$timestamp'");
$query = $db->query("UPDATE $table_threads SET displayorder='1' where topday<>'0' AND topday<'$timestamp'");
$query = $db->query("SELECT attachment FROM $table_attachments WHERE deleteday<>'0' AND deleteday<'$timestamp'");
while($attach = $db->fetch_array($query)) {
@unlink(DISCUZ_ROOT.'./'.$attachdir.'/'.$attach['attachment']);
}
$db->query("DELETE FROM $table_attachments where deleteday<>'0' AND deleteday<'$timestamp'");
$query = $db->query("UPDATE $table_threads SET attachment='0' where deleteday<>'0' AND deleteday<'$timestamp'");

复制代码

[ 本帖最后由 tks999 于 2005-9-27 06:16 编辑 ]

tks999 · 发表于 2005-9-25 11:55:22

打开topicadmin.php
查找

}elseif($operation == 'digest' && $allowdigest){

复制代码

上面加入

}elseif($operation == 'settings'){
if($settingstype == 0) {
if($closeday > 0) {
$closeday = $timestamp+86400*$closeday;
}
else {
$closeday = 0;
}
$db->query("UPDATE $table_threads SET closeday='$closeday' WHERE tid in($tids) AND fid='$fid'");
}
if($settingstype == 1) {
if($deleteday > 0) {
$deleteday = $timestamp+86400*$deleteday;
}
else {
$deleteday = 0;
}
$db->query("UPDATE $table_attachments SET deleteday='$deleteday' WHERE tid in($tids)");
$db->query("UPDATE $table_threads SET deleteday='$deleteday' WHERE tid in($tids)");
}
if($settingstype == 2) {
if($topday > 0) {
$topday = $timestamp+86400*$topday;
}
else {
$topday = 0;
}
$db->query("UPDATE $table_threads SET topday='$topday' WHERE tid in($tids) AND fid='$fid'");
}
modlog();
showmessage('admin_succeed', "forumdisplay.php?fid=$fid&page=$page");

复制代码

打开topicadmin_moderate
查找

{lang moderate_delete}

复制代码

上面加入

主题设置

复制代码

查找(注意是第2个)

复制代码

上面加入

<tr>
<td bgcolor="{ALTBG1}">设置使用的选项:</td>
<td bgcolor="{ALTBG2}">
<input type="radio" name="settingstype" value="0">关闭主题  <input type="radio" name="settingstype" value="1">删除附件<input type="radio" name="settingstype" value="2" >主题置顶  </td>
<tr>
<td bgcolor="{ALTBG1}" width="21%">几天后关闭(如果有选择使用关闭主题):</td>
<td bgcolor="{ALTBG2}">
<input type="text" name="closeday" value="0">单位:(天)
</tr>
<tr>
<td bgcolor="{ALTBG1}" width="21%">几天后删除附件(如果有选择使用删除附件):</td>
<td bgcolor="{ALTBG2}">
<input type="text" name="deleteday" value="0">单位:(天)
</tr>
<tr>
<td bgcolor="{ALTBG1}" width="21%">几天后置顶(如果有选择使用删除主题):</td>
<td bgcolor="{ALTBG2}">
<input type="text" name="topday" value="0">单位:(天)
</tr>

复制代码

打开forumdisplay.htm
查找

<input type="radio" name="operation" value="digest">
{lang moderate_digest}

复制代码

下面加入

<input type="radio" name="operation" value="settings">
主题设置

复制代码

[ 本帖最后由 tks999 于 2005-10-1 11:45 编辑 ]

winter0706 · 发表于 2005-9-25 11:57:29

支持啊~

Pteranodon · 发表于 2005-9-25 12:01:48

先支持, 期待有新版本我再裝, 嘿 (還好, 我在第1頁時回覆到=0=')

tks999 · 发表于 2005-9-25 12:02:04

原帖由 winter0706 于 2005-9-25 11:57 发表
支持啊~

感谢下。本来我是打算分开发布那个删除附件时间的，后来呢，想了下就干脆合在一起了

xjbl · 发表于 2005-9-25 12:04:45

支持....继续关注.

tks999 · 发表于 2005-9-25 12:10:24

批量应该会在不久后发布，现在在测试期间

winter0706 · 发表于 2005-9-25 12:17:27

代碼有待優化吧~
大概用$s=x?y:z會比較好吧

		自动登录	找回密码
密码			立即注册

主题设置1.01[关键字: 附件，关闭，置顶，天](新加入批量和更新BUG)

本帖子中包含更多资源

批量功能

删除附件时间是新的