[osbb-commits Mailing List] osbb SQLChangeLog,1.4,1.5

[Sven <bra...@us...>]

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">&nbsp;</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}>&amp;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}>&amp;s=<{s}>&amp;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&amp;id=<{boardbit.boardlastposterid}>&amp;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">&nbsp;</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}>&amp;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}>&amp;s=<{s}>&amp;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&amp;id=<{boardbit.boardlastposterid}>&amp;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">&nbsp;</td>\r\n <td class ="table_in_cat" width="16">&nbsp;</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}>&nbsp;<{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}>&amp;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&amp;id=<{threadbit.threadauthorid}>&amp;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]>&nbsp;<b><exp>formatDate($vars[\'threadbit\'][\'posttime\'])</exp></b><br />\r\n   <[board_thread_from]>&nbsp;<a href="etc.php?do=userinfo&amp;id=<{threadbit.postauthorid}>&amp;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);