|
From: Sven <bra...@us...> - 2005-01-09 14:00:38
|
Update of /cvsroot/osbb/osbb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11699 Modified Files: SQLChangeLog Log Message: Added threaddesc again Index: SQLChangeLog =================================================================== RCS file: /cvsroot/osbb/osbb/SQLChangeLog,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** SQLChangeLog 9 Jan 2005 13:48:01 -0000 1.4 --- SQLChangeLog 9 Jan 2005 14:00:15 -0000 1.5 *************** *** 45,46 **** --- 45,50 ---- UPDATE osbb_config SET configvalue='1' WHERE configid = '26'; DROP TABLE `osbb_config_values`; + + #09/01/2005 (DD/MM/YYYY) - added threaddesc to the boardview + DELETE FROM `osbb_templates` WHERE templatename = 'board'; + INSERT INTO `osbb_templates` VALUES (6, 0, 'board', '', '<br />\r\n<if condition={checkBoardPermission(\'can_start_threads\',$vars[\'boardid\'],0) && $vars[\'board\'][\'boardtype\'] == BOARD_BOARD}>\r\n<table cellspacing="<{style.tbl_in_cellspacing}>" cellpadding="<{style.table_in_cellpadding}>" style="width: 98%;">\r\n<tr><td>\r\n <div align="right">\r\n <{button_newthread}>\r\n </div>\r\n</td></tr>\r\n</table>\r\n<endif>\r\n\r\n<if condition={$vars[\'subboardcount\'] != 0}>\r\n<table class="table_in" cellspacing="<{style.tbl_in_cellspacing}>" cellpadding="<{style.tbl_in_cellpadding}>">\r\n<tr>\r\n <td class="table_in_cat" width="50"> </td>\r\n <td class="table_in_cat" width="*"><span class="bigtext"><[index_boardname]></span></td>\r\n <td class="table_in_cat" width="50"><span class="bigtext"><[index_threads]></span></td>\r\n <td class="table_in_cat" width="50"><span class="bigtext"><[index_posts]></span></td>\r\n <td class="table_in_cat" width="300"><span class="bigtext"><[index_lastpost]></span></td>\r\n</tr>\r\n<foreach variable="boards" bit="boardbit">\r\n<if condition={$vars[\'boardbit\'][\'depth\'] == 0}>\r\n<if condition={$vars[\'boardbit\'][\'boardtype\'] == BOARD_CAT}>\r\n<tr>\r\n<td class="table_in_cat" colspan="5" style="text-align: left;">\r\n <span class="bigtext">\r\n <a href="board.php?id=<{boardbit.boardid}>&s=<{s}>"><{boardbit.boardname}></a></span>\r\n <if condition={$vars[\'boardbit\'][\'boarddesc\'] != \'\'}>\r\n <span class="normaltext"><{boardbit.boarddesc}></span> \r\n <endif>\r\n</td>\r\n</tr>\r\n<else>\r\n<tr>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="*" colspan="2">\r\n <table width="100%" cellspacing="0" cellpadding="1" border="0">\r\n <tr>\r\n <td width=50">\r\n <if condition={!checkPermission(\'can_view_board\',$vars[\'boardbit\'][\'boardid\'],0)}>\r\n <img src="<{style.imagefolder}>/b_closed.png" alt="" />\r\n <elseif condition={$vars[\'boardbit\'][\'old\'] == 1}>\r\n <img src="<{style.imagefolder}>/b_old.png" alt="" />\r\n <else>\r\n <img src="<{style.imagefolder}>/b_new.png" alt="" />\r\n <endif>\r\n </td>\r\n <td width="*" style="text-align: left;">\r\n <span class="bigtext">\r\n <a href="board.php?id=<{boardbit.boardid}>&s=<{s}>"><{boardbit.boardname}></a>\r\n </span>\r\n <if condition={$vars[\'boardbit\'][\'boarddesc\'] != \'\'}>\r\n <span class="normaltext">\r\n <br /><{boardbit.boarddesc}>\r\n <if condition={$vars[\'boardbit\'][\'subboards\'] != \'\'}>\r\n <{boardbit.subboards}>\r\n <endif>\r\n </span>\r\n <endif>\r\n </td></tr></table>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="50">\r\n <span class="normaltext">\r\n <{boardbit.boardthreads}>\r\n </span>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="50">\r\n <span class="normaltext">\r\n <{boardbit.boardposts}>\r\n </span>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],1,$vars[\'ab\'])</exp>" width="300">\r\n <span class="normaltext">\r\n <if condition={checkPermission(\'can_view_board\',$vars[\'boardbit\'][\'boardid\'],0)}>\r\n <if condition={$vars[\'boardbit\'][\'boardlastpostid\'] == 0}>\r\n <[board_nolastpost]>\r\n <else>\r\n <a href="thread.php?id=<{boardbit.threadid}>&s=<{s}>&lastpost=1#post_<{boardbit.postid}>">\r\n <b><{boardbit.threadtopic}></b>\r\n </a><br />\r\n <exp>formatDate($vars[\'boardbit\'][\'posttime\'])</exp> <[board_thread_from]>\r\n <a href="etc.php?action=userinfo&id=<{boardbit.boardlastposterid}>&s=<{s}>">\r\n <b><{boardbit.boardlastpostername}></b>\r\n </a>\r\n <endif>\r\n <else>\r\n <b><[index_board_lastpost_noaccess]></b> \r\n <endif>\r\n </span>\r\n</td>\r\n</tr>\r\n<endif>\r\n<elseif condition={$vars[\'boardbit\'][\'depth\'] == 1}>\r\n<if condition={$vars[\'boardbit\'][\'boardtype\'] == BOARD_CAT}>\r\n<tr>\r\n<td class="table_in_cat" width="50"> </td>\r\n<td class="table_in_cat" colspan="4" style="text-align: left;">\r\n <span class="bigtext">\r\n <a href="board.php?id=<{boardbit.boardid}>&s=<{s}>"><{boardbit.boardname}></a></span>\r\n <if condition={$vars[\'boardbit\'][\'boarddesc\'] != \'\'}>\r\n <span class="normaltext"><{boardbit.boarddesc}></span> \r\n <endif>\r\n</td>\r\n</tr>\r\n<else>\r\n<tr>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="50">\r\n <if condition={!checkPermission(\'can_view_board\',$vars[\'boardbit\'][\'boardid\'],0)}>\r\n <img src="<{style.imagefolder}>/b_closed.png" alt="" />\r\n <elseif condition={$vars[\'boardbit\'][\'old\'] == 1}>\r\n <img src="<{style.imagefolder}>/b_old.png" alt="" />\r\n <else>\r\n <img src="<{style.imagefolder}>/b_new.png" alt="" />\r\n <endif>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="*" style="text-align: left;">\r\n <span class="bigtext">\r\n <a href="board.php?id=<{boardbit.boardid}>&s=<{s}>"><{boardbit.boardname}></a>\r\n </span>\r\n <if condition={$vars[\'boardbit\'][\'boarddesc\'] != \'\'}>\r\n <span class="normaltext">\r\n <br /><{boardbit.boarddesc}>\r\n <if condition={$vars[\'boardbit\'][\'subboards\'] != \'\'}>\r\n <{boardbit.subboards}>\r\n <endif>\r\n </span>\r\n <endif>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="50">\r\n <span class="normaltext">\r\n <{boardbit.boardthreads}>\r\n </span>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="50">\r\n <span class="normaltext">\r\n <{boardbit.boardposts}>\r\n </span>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],1,$vars[\'ab\'])</exp>" width="300">\r\n <span class="normaltext">\r\n <if condition={checkPermission(\'can_view_board\',$vars[\'boardbit\'][\'boardid\'],0)}>\r\n <if condition={$vars[\'boardbit\'][\'boardlastpostid\'] == 0}>\r\n <[board_nolastpost]>\r\n <else>\r\n <a href="thread.php?id=<{boardbit.threadid}>&s=<{s}>&lastpost=1#post_<{boardbit.postid}>">\r\n <b><{boardbit.threadtopic}></b>\r\n </a><br />\r\n <exp>formatDate($vars[\'boardbit\'][\'posttime\'])</exp> <[board_thread_from]>\r\n <a href="etc.php?action=userinfo&id=<{boardbit.boardlastposterid}>&s=<{s}>">\r\n <b><{boardbit.boardlastpostername}></b>\r\n </a>\r\n <endif>\r\n <else>\r\n <b><[index_board_lastpost_noaccess]></b> \r\n <endif>\r\n </span>\r\n</td>\r\n</tr>\r\n<endif>\r\n<endif>\r\n<endforeach>\r\n</table><br />\r\n<elseif condition={$vars[\'board\'][\'boardtype\'] == BOARD_CAT}>\r\n<table class="table_in" cellspacing="<{style.tbl_in_cellspacing}>" cellpadding="<{style.tbl_in_cellpadding}>">\r\n<tr>\r\n <td class="table_in_a">\r\n <span class="bigtext">\r\n <b><[board_nosubboards]></b>\r\n </span>\r\n </td>\r\n</tr>\r\n</table><br />\r\n<endif>\r\n\r\n<if condition={$vars[\'threadcount\'] != 0}>\r\n<table class="table_in" cellspacing="<{style.tbl_in_cellspacing}>" cellpadding="<{style.tbl_in_cellpadding}>">\r\n<tr>\r\n <td class ="table_in_cat" width="30"> </td>\r\n <td class ="table_in_cat" width="16"> </td>\r\n <td class ="table_in_cat" width="*">\r\n <span class="bigtext">\r\n <[board_threads]>\r\n </span>\r\n </td>\r\n <td class ="table_in_cat" width="150">\r\n <span class="bigtext">\r\n <[thread_author]>\r\n </span>\r\n </td>\r\n <td class ="table_in_cat" width="50">\r\n <span class="bigtext">\r\n <[board_replies]>\r\n </span>\r\n </td>\r\n <td class ="table_in_cat" width="50">\r\n <span class="bigtext">\r\n <[board_hits]>\r\n </span>\r\n </td>\r\n <td class ="table_in_cat" width="250">\r\n <span class="bigtext">\r\n <[board_lastpost]>\r\n </span>\r\n </td>\r\n</tr>\r\n\r\n<foreach variable="threads" bit="threadbit">\r\n<if condition={$vars[\'threadbit\'][\'threaddeleted\'] == 1 && !checkBoardPermission(\'can_view_deleted_threads\',$vars[\'boardid\'],0)}>\r\n<tr>\r\n <td class="table_in_<exp>getVar($vars[\'count\'],1,$vars[\'ab\'])</exp>" colspan="7">\r\n <span class="bigtext">\r\n <{threadbit.threadtopic}>\r\n </span><br />\r\n <span class="normaltext">\r\n <{threadbit.deleted_info}> <{threadbit.threaddeletedreason}>\r\n </span>\r\n </td>\r\n</tr>\r\n<else>\r\n<tr>\r\n <td class ="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="30">\r\n <img src="<{style.imagefolder}>/<exp>makeThreadImage($vars[\'threadbit\'][\'old\'],$vars[\'threadbit\'])</exp>" alt=" " />\r\n </td>\r\n <td class ="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="16">\r\n <exp>makeIcon($vars[\'threadbit\'][\'threadiconid\'],$vars[\'threadbit\'])</exp>\r\n </td>\r\n <td class ="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="*" style="text-align: left;">\r\n <span class="bigtext">\r\n <if condition={$vars[\'threadbit\'][\'threadimportant\'] == THREAD_IMPORTANT}>\r\n <[thread_important]>\r\n <elseif condition={$vars[\'threadbit\'][\'threadimportant\'] == THREAD_ANNOUNCEMENT}>\r\n <[thread_annoucnement]>\r\n <endif>\r\n <a href="thread.php?id=<{threadbit.threadid}>&s=<{s}>"><{threadbit.threadtopic}></a>\r\n </span>\r\n <if condition={$vars[\'threadbit\'][\'threaddesc\'] != \'\'}>\r\n <span class="normaltext"><br />\r\n <exp>killHTML($vars[\'threadbit\'][\'threaddesc\'])</exp>\r\n </span>\r\n <endif>\r\n </td>\r\n <td class ="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="150">\r\n <span class="bigtext">\r\n <a href="etc.php?do=userinfo&id=<{threadbit.threadauthorid}>&s=<{s}>"><{threadbit.threadauthorname}></a>\r\n </span>\r\n </td>\r\n <td class ="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="50">\r\n <span class="bigtext">\r\n <{threadbit.threadreplies}>\r\n </span>\r\n </td>\r\n <td class ="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="50">\r\n <span class="bigtext">\r\n <{threadbit.threadhits}>\r\n </span>\r\n </td>\r\n <td class ="table_in_<exp>getVar($vars[\'count\'],1,$vars[\'ab\'])</exp>" width="250">\r\n <span class="normaltext">\r\n <[board_thread_at]> <b><exp>formatDate($vars[\'threadbit\'][\'posttime\'])</exp></b><br />\r\n <[board_thread_from]> <a href="etc.php?do=userinfo&id=<{threadbit.postauthorid}>&s=<{s}>"><b><{threadbit.postauthorname}></b></a>\r\n </span>\r\n </td>\r\n</tr>\r\n<endif>\r\n<endforeach>\r\n</table><br />\r\n<elseif condition={$vars[\'board\'][\'boardtype\'] == BOARD_BOARD && $vars[\'threadcount\'] == 0}>\r\n<table class="table_in" cellspacing="<{style.tbl_in_cellspacing}>" cellpadding="<{style.tbl_in_cellpadding}>">\r\n<tr>\r\n <td class="table_in_a">\r\n <span class="bigtext">\r\n <b><[board_nothreads]></b>\r\n </span>\r\n </td>\r\n</tr>\r\n</table><br />\r\n<endif>\r\n<table class="table_in" cellspacing="<{style.tbl_in_cellspacing}>" cellpadding="<{style.tbl_in_cellpadding}>">\r\n<tr>\r\n <td class="table_in_a">\r\n <{pagelink}>\r\n </td>\r\n</tr>\r\n</table>', 'board_wrongid,button_addthread,board_nolastpost,index_boardname,index_threads,index_posts,index_lastpost,index_subboards_closed,index_board_lastpost_noaccess,board_nolastpost,board_thread_from,board_nosubboards,board_threads,board_posts,board_threads,board_lastpost,thread_closed_noreason,thread_deleted_info,thread_important,thread_announcement,thread_author,board_hits,board_replies,board_nothreads,board_thread_at,board_thread_from,button_addthread', 0); |