Menu
▾
▴
[osbb-commits Mailing List] osbb SQLChangeLog,1.3,1.4 include.php,1.11,1.12
|
From: Sven <bra...@us...> - 2005-01-09 13:48:10
|
Update of /cvsroot/osbb/osbb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8918 Modified Files: SQLChangeLog include.php Log Message: Merged the tables config and config_values. (Dont know when i had the stupid idea of splitting them -.-) Index: include.php =================================================================== RCS file: /cvsroot/osbb/osbb/include.php,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** include.php 7 Jan 2005 12:48:25 -0000 1.11 --- include.php 9 Jan 2005 13:48:01 -0000 1.12 *************** *** 23,30 **** */ ! define('OSBB','1'); //this is needed to avoid opening a file in the lib directory manually ! error_reporting(E_ALL); //show ALL errors (not E_STRICT in PHP 5) //get config --- 23,48 ---- */ + error_reporting(E_ALL); //show ALL errors (not E_STRICT in PHP 5) ! //if register_global is switched to 'on' remove ALL ${name} variables which are in the arrays _GET/_POST/_COOKIE/_SERVER AND _ENV ! if(@ini_get('register_globals')){ ! if(is_array($_GET)){ ! foreach($_GET as $var=>$val) unset(${$var}); ! } ! if(is_array($_POST)){ ! foreach($_POST as $var=>$val) unset(${$var}); ! } ! if(is_array($_COOKIE)){ ! foreach($_COOKIE as $var=>$val) unset(${$var}); ! } ! if(is_array($_SERVER)){ ! foreach($_SERVER as $var=>$val) unset(${$var}); ! } ! if(is_array($_ENV)){ ! foreach($_ENV as $var=>$val) unset(${$var}); ! } ! } ! define('OSBB','1'); //this is needed to avoid opening a file in the lib directory manually //get config *************** *** 34,38 **** if(!defined('osbb_installed')){ //redirect the user to the install routine ! Header("Location: ./install/index.php"); exit; } --- 52,56 ---- if(!defined('osbb_installed')){ //redirect the user to the install routine ! Header("Location: ./tools/install.php"); exit; } *************** *** 52,74 **** } - //if register_global is switched to 'on' remove ALL ${name} variables which are in the arrays _GET/_POST/_COOKIE/_SERVER AND _ENV - if(@ini_get('register_globals')){ - if(is_array($_GET)){ - foreach($_GET as $var=>$val) unset(${$var}); - } - if(is_array($_POST)){ - foreach($_POST as $var=>$val) unset(${$var}); - } - if(is_array($_COOKIE)){ - foreach($_COOKIE as $var=>$val) unset(${$var}); - } - if(is_array($_SERVER)){ - foreach($_SERVER as $var=>$val) unset(${$var}); - } - if(is_array($_ENV)){ - foreach($_ENV as $var=>$val) unset(${$var}); - } - } - //prepare constans require('./lib/constants.php'); --- 70,73 ---- *************** *** 117,122 **** //read configuration $config = array(); ! $res = $sql->query("SELECT * FROM ".TABLE_CONFIG." AS c ! LEFT JOIN ".TABLE_CONFIG_VALUES." AS v ON (v.configid = c.configid)"); while ($row = $sql->fetch_array($res)) $config[$row['configname']] = $row['configvalue']; --- 116,120 ---- //read configuration $config = array(); ! $res = $sql->query("SELECT * FROM ".TABLE_CONFIG); while ($row = $sql->fetch_array($res)) $config[$row['configname']] = $row['configvalue']; Index: SQLChangeLog =================================================================== RCS file: /cvsroot/osbb/osbb/SQLChangeLog,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** SQLChangeLog 8 Jan 2005 16:19:09 -0000 1.3 --- SQLChangeLog 9 Jan 2005 13:48:01 -0000 1.4 *************** *** 10,15 **** INSERT INTO `osbb_templates` VALUES (2, 0, 'index', '<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="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="*">\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 <{boardbit.boardthreads}>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="50">\r\n <{boardbit.boardposts}>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],1,$vars[\'ab\'])</exp>" width="300">\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.lastposterid}>&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</td>\r\n</tr>\r\n<endif>\r\n<elseif condition={$vars[\'boardbit\'][\'depth\'] == 1}>\r\n<endif>\r\n<endforeach>\r\n</table>', '<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>\r\n<br />\r\n\r\n<if condition={$vars[\'config\'][\'index_userstats\'] == 1 || $vars[\'config\'][\'index_useronline\'] == 1}>\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" style="text-align: left;">\r\n <span class="bigtext">\r\n <[index_stats]>\r\n </span>\r\n </td>\r\n</tr>\r\n<if condition={$vars[\'config\'][\'index_useronline\'] == 1}>\r\n<tr>\r\n <td class="table_in_a" style="text-align: left;">\r\n <span class="normaltext">\r\n <{stats}>\r\n </span>\r\n </td>\r\n</tr>\r\n<tr>\r\n <td class="table_in_b" style="text-align: left;">\r\n <span class="normaltext">\r\n <{stats1}>\r\n </span>\r\n </td>\r\n</tr>\r\n<endif>\r\n<if condition={$vars[\'config\'][\'index_userstats\'] == 1}>\r\n<tr>\r\n <td class="table_in_a" style="text-align: left;">\r\n <span class="normaltext">\r\n <{stats2}><br />\r\n <{stats3}>\r\n </span>\r\n </td>\r\n</tr>\r\n<endif>\r\n</table>\r\n<endif>', 'title_index,index_useronline,index_userstats2,index_userstats3,board_nolastpost,index_boardname,index_threads,index_posts,index_lastpost,index_subboards_closed,index_board_lastpost_noaccess,board_nolastpost,board_thread_from,index_stats', 0); ! #08/01/2005 (DD/MM/YY) - fixed board pagelink 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 </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); INSERT INTO `osbb_templates` VALUES (8, 0, 'pagelink', '', '<span class="normaltext">\r\n<[pages]>(<{pages}>)\r\n<if condition={$vars[\'page\']-2 > 0}>\r\n<a href="<{link}>1">«</a>\r\n<endif>\r\n<if condition={$vars[\'page\']-2 > 0}>\r\n[<a href="<{link}><exp>$vars[\'page\']-2</exp>"><exp>$vars[\'page\']-2</exp></a>]\r\n<endif>\r\n<if condition={$vars[\'page\']-1 > 0}>\r\n[<a href="<{link}><exp>$vars[\'page\']-1</exp>"><exp>$vars[\'page\']-1</exp></a>]\r\n<endif>\r\n[<b><{page}></b>]\r\n<if condition={$vars[\'page\']+2 <= $vars[\'pages\']}>\r\n[<a href="<{link}><exp>$vars[\'page\']+2</exp>"><exp>$vars[\'page\']+2</exp></a>]\r\n<endif>\r\n<if condition={$vars[\'page\']+1 <= $vars[\'pages\']}>\r\n[<a href="<{link}><exp>$vars[\'page\']+1</exp>"><exp>$vars[\'page\']+1</exp></a>]\r\n<endif>\r\n<if condition={$vars[\'page\']+2 < $vars[\'pages\']}>\r\n<a href="<{link}><{pages}>">»</a>\r\n<endif>\r\n</span>', 'pages', 0); --- 10,46 ---- INSERT INTO `osbb_templates` VALUES (2, 0, 'index', '<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="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="*">\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 <{boardbit.boardthreads}>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],0,$vars[\'ab\'])</exp>" width="50">\r\n <{boardbit.boardposts}>\r\n</td>\r\n<td class="table_in_<exp>getVar($vars[\'count\'],1,$vars[\'ab\'])</exp>" width="300">\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.lastposterid}>&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</td>\r\n</tr>\r\n<endif>\r\n<elseif condition={$vars[\'boardbit\'][\'depth\'] == 1}>\r\n<endif>\r\n<endforeach>\r\n</table>', '<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>\r\n<br />\r\n\r\n<if condition={$vars[\'config\'][\'index_userstats\'] == 1 || $vars[\'config\'][\'index_useronline\'] == 1}>\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" style="text-align: left;">\r\n <span class="bigtext">\r\n <[index_stats]>\r\n </span>\r\n </td>\r\n</tr>\r\n<if condition={$vars[\'config\'][\'index_useronline\'] == 1}>\r\n<tr>\r\n <td class="table_in_a" style="text-align: left;">\r\n <span class="normaltext">\r\n <{stats}>\r\n </span>\r\n </td>\r\n</tr>\r\n<tr>\r\n <td class="table_in_b" style="text-align: left;">\r\n <span class="normaltext">\r\n <{stats1}>\r\n </span>\r\n </td>\r\n</tr>\r\n<endif>\r\n<if condition={$vars[\'config\'][\'index_userstats\'] == 1}>\r\n<tr>\r\n <td class="table_in_a" style="text-align: left;">\r\n <span class="normaltext">\r\n <{stats2}><br />\r\n <{stats3}>\r\n </span>\r\n </td>\r\n</tr>\r\n<endif>\r\n</table>\r\n<endif>', 'title_index,index_useronline,index_userstats2,index_userstats3,board_nolastpost,index_boardname,index_threads,index_posts,index_lastpost,index_subboards_closed,index_board_lastpost_noaccess,board_nolastpost,board_thread_from,index_stats', 0); ! #08/01/2005 (DD/MM/YYYY) - fixed board pagelink 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 </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); INSERT INTO `osbb_templates` VALUES (8, 0, 'pagelink', '', '<span class="normaltext">\r\n<[pages]>(<{pages}>)\r\n<if condition={$vars[\'page\']-2 > 0}>\r\n<a href="<{link}>1">«</a>\r\n<endif>\r\n<if condition={$vars[\'page\']-2 > 0}>\r\n[<a href="<{link}><exp>$vars[\'page\']-2</exp>"><exp>$vars[\'page\']-2</exp></a>]\r\n<endif>\r\n<if condition={$vars[\'page\']-1 > 0}>\r\n[<a href="<{link}><exp>$vars[\'page\']-1</exp>"><exp>$vars[\'page\']-1</exp></a>]\r\n<endif>\r\n[<b><{page}></b>]\r\n<if condition={$vars[\'page\']+2 <= $vars[\'pages\']}>\r\n[<a href="<{link}><exp>$vars[\'page\']+2</exp>"><exp>$vars[\'page\']+2</exp></a>]\r\n<endif>\r\n<if condition={$vars[\'page\']+1 <= $vars[\'pages\']}>\r\n[<a href="<{link}><exp>$vars[\'page\']+1</exp>"><exp>$vars[\'page\']+1</exp></a>]\r\n<endif>\r\n<if condition={$vars[\'page\']+2 < $vars[\'pages\']}>\r\n<a href="<{link}><{pages}>">»</a>\r\n<endif>\r\n</span>', 'pages', 0); + + + #09/01/2005 (DD/MM/YYYY) - merged config and config_values + ALTER TABLE `osbb_config` ADD `configvalue` MEDIUMTEXT NOT NULL ; + UPDATE osbb_config SET configvalue='1' WHERE configid = '1'; + UPDATE osbb_config SET configvalue='osBB 0.1 alpha 1' WHERE configid = '2'; + UPDATE osbb_config SET configvalue='::' WHERE configid = '3'; + UPDATE osbb_config SET configvalue='1' WHERE configid = '4'; + UPDATE osbb_config SET configvalue='no...@we...' WHERE configid = '5'; + UPDATE osbb_config SET configvalue='127.0.0.1/osbb' WHERE configid = '6'; + UPDATE osbb_config SET configvalue='3' WHERE configid = '7'; + UPDATE osbb_config SET configvalue='d.m.Y' WHERE configid = '8'; + UPDATE osbb_config SET configvalue='25' WHERE configid = '9'; + UPDATE osbb_config SET configvalue='100' WHERE configid = '10'; + UPDATE osbb_config SET configvalue='1' WHERE configid = '11'; + UPDATE osbb_config SET configvalue='1' WHERE configid = '12'; + UPDATE osbb_config SET configvalue='1' WHERE configid = '13'; + UPDATE osbb_config SET configvalue='4' WHERE configid = '14'; + UPDATE osbb_config SET configvalue='8' WHERE configid = '15'; + UPDATE osbb_config SET configvalue='15000' WHERE configid = '16'; + UPDATE osbb_config SET configvalue='3' WHERE configid = '17'; + UPDATE osbb_config SET configvalue='5' WHERE configid = '18'; + UPDATE osbb_config SET configvalue='30' WHERE configid = '19'; + UPDATE osbb_config SET configvalue='1' WHERE configid = '20'; + UPDATE osbb_config SET configvalue='a:2:{s:10:\"totalcount\";i:2;s:4:\"time\";i:1101741249;}' WHERE configid = '21'; + UPDATE osbb_config SET configvalue='H:i' WHERE configid = '22'; + UPDATE osbb_config SET configvalue='Admin;Team' WHERE configid = '23'; + UPDATE osbb_config SET configvalue='30' WHERE configid = '24'; + UPDATE osbb_config SET configvalue='20' WHERE configid = '25'; + UPDATE osbb_config SET configvalue='1' WHERE configid = '26'; + DROP TABLE `osbb_config_values`; |
