Project Parasy @r23HTTP下載(BIG5 + GBK)版

ALTER TABLE `cdb_forums` DROP `board_name`
ALTER TABLE `cdb_forums` DROP `idx_push`
ALTER TABLE `cdb_favorites` DROP `dateline`
ALTER TABLE `cdb_members` DROP `now_img`
ALTER TABLE `cdb_members` DROP `idx_cloud`
ALTER TABLE `cdb_members` DROP `usr_geo`


DROP TABLE `cdb_savepoint`
DROP TABLE `cdb_geo_usage_simple`
DROP TABLE `cdb_geo_going`
DROP TABLE `cdb_geo_been`
DROP TABLE `cdb_plugin_now`
DROP TABLE `cdb_plugin_now_stats`
DROP TABLE `cdb_expense`
DROP TABLE `cdb_plugin_tod_project`
DROP TABLE `cdb_plugin_tod_task`

<script type="text/javascript">var IMGDIR = '{IMGDIR}';var SMDIR = '{SMDIR}';</script>

<script type="text/javascript">var IMGDIR = '$bbsdir/images/smilies';var SMDIR = '{SMDIR}';</script>

<!--{loop $_DCACHE['newthread'] $toploop}-->
<!--{eval $toploopt[dateline] = make_descriptive_time($toploop[lastpost]);}-->
<!--{eval $toploopt[author] = rawurlencode($toploop[author]);}-->
<!--{eval $name_color = rand_color();}-->
<tr><td align="left"><span class="tip_i"> <img src="$toploop[avatar]" alt="$toploop[author]" align="absmiddle" height="16" width="16" class="portrait" /> <a href="profile-username-$toploopt[author].html" style="color: $name_color;" class="var">$toploop[author]</a> ... <a href="go/$toploop[board_name]">$toploop[name]</a> ... [ <a href="viewthread.php?tid=$toploop[tid]" style="color: $toploop[csscolor];" class="var">$toploop[subjectc]</a> ] ... $toploopt[dateline],$toploop[replies]回復</span></td></tr><!--{/loop}-->

$conditions = "LEFT JOIN {$tablepre}forums f ON f.fid=t.fid LEFT JOIN {$tablepre}memberfields mf ON mf.uid=t.authorid WHERE t.displayorder!='-1' ORDER BY t.lastpost DESC LIMIT 0, 20";