//酒鬼 20110708
$aday = strtotime(dgmdate(TIMESTAMP,'Ymd'));//今天日期
$bday = 24*3600*30;//减去多少天,我这里设定30天前
$cday = $aday - $bday;//计算30天前的日期
$postatt = DB::query("SELECT * FROM ".DB::table('forum_post')." WHERE authorid='$discuz_uid' and attachment=1 and dateline>'$cday' and message like '%.mp3%'");
while ($value = DB::fetch($postatt)){
$pid = $value['pid'];
$listatt = DB::result_first("SELECT tableid FROM ".DB::table('forum_attachment')." where pid='$pid' order by aid LIMIT 1");
$tableid = $listatt['tableid'];
$tablename = "forum_attachment_".$tableid;
$mp3temp = "";
$mp3val = DB::query("SELECT filename,attachment FROM ".DB::table($tablename)." where pid='$pid'");
while ($mp3arr = DB::fetch($mp3val)){
$mp3temp .= "<option value='http://xxx.xxx.xxx/data/attachment/forum/".$mp3arr['attachment']."'>".$mp3arr['filename']."</option>";
}
}
//酒鬼 20110708
if($types == 3){
$query = DB::query("SELECT vsubject, id FROM hsk_vgallerys WHERE album=1 and uid='$discuz_uid' ORDER BY id");
while($datarow = DB::fetch($query)){
$dataloop2[] = $datarow;
}
}
------------------------
open gallery_release.htm 大概 line 197 处添加以下代码: