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>
$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";