Menu
▾
▴
[osbb-commits Mailing List] osbb sql_backup.sql,1.4,1.5
|
From: Sven <bra...@us...> - 2005-01-06 14:14:48
|
Update of /cvsroot/osbb/osbb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11871 Modified Files: sql_backup.sql Log Message: Sorry, forgot to remember the queries i ran -.- Index: sql_backup.sql =================================================================== RCS file: /cvsroot/osbb/osbb/sql_backup.sql,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** sql_backup.sql 5 Jan 2005 16:26:18 -0000 1.4 --- sql_backup.sql 6 Jan 2005 14:14:37 -0000 1.5 *************** *** 4,8 **** # # Host: localhost ! # Generation Time: Jan 05, 2005 at 05:25 PM # Server version: 4.1.8 # PHP Version: 5.0.3 --- 4,8 ---- # # Host: localhost ! # Generation Time: Jan 06, 2005 at 03:13 PM # Server version: 4.1.8 # PHP Version: 5.0.3 *************** *** 154,158 **** `configtype` int(1) NOT NULL default '0', PRIMARY KEY (`configid`) ! ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=26 ; # --- 154,158 ---- `configtype` int(1) NOT NULL default '0', PRIMARY KEY (`configid`) ! ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=27 ; # *************** *** 185,188 **** --- 185,189 ---- INSERT INTO `osbb_config` VALUES (24, 'tpp', 0); INSERT INTO `osbb_config` VALUES (25, 'ppp', 0); + INSERT INTO `osbb_config` VALUES (26, 'timezone', 0); # -------------------------------------------------------- *************** *** 226,229 **** --- 227,231 ---- INSERT INTO `osbb_config_values` VALUES (24, '30'); INSERT INTO `osbb_config_values` VALUES (25, '20'); + INSERT INTO `osbb_config_values` VALUES (26, '1'); # -------------------------------------------------------- *************** *** 945,948 **** --- 947,951 ---- INSERT INTO `osbb_langvars` VALUES (1, 'mod_delete_desc', 'Bitte geben Sie einen Grund ein, warum Sie dieses Thema löschen wollen:'); INSERT INTO `osbb_langvars` VALUES (1, 'editthread_comment', 'Kommentar zum editieren'); + INSERT INTO `osbb_langvars` VALUES (1, 'timezone', 'Alle Zeiten in diesem Forum sind GMT+<var>$userdata[\'usertimezone\']</var> Stunde(n)'); # -------------------------------------------------------- *************** *** 1279,1283 **** # ! INSERT INTO `osbb_sessions` VALUES ('390b7e025ab05027b254878a7215513ab4c6c998', '127.0.0.1', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041111 Firefox/1.0', 1, 1104943647, 'index.php', '6645dy31ou'); # -------------------------------------------------------- --- 1282,1286 ---- # ! INSERT INTO `osbb_sessions` VALUES ('0f465ff6935b73b857415e89bac7602fd17cbc90', '127.0.0.1', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20041111 Firefox/1.0', 1, 1105022440, 'index.php', '75qqj3sp54'); # -------------------------------------------------------- *************** *** 1429,1433 **** # ! INSERT INTO `osbb_templates` VALUES (1, 0, 'html', '<?xml version="1.0" encoding="windows-1252"?>\r\n<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="<{langname}>" xml:lang="<{langname}>">\r\n<head>\r\n <title><{title}></title>\r\n <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />\r\n <style type="text/css">\r\n body{\r\n background-color: <{style.bgcolor}>;\r\n }\r\n \r\n body a:link, body a:visited, body a:active { \r\n color: <{style.body_linkn_color}>;\r\n text-decoration: <{style.body_linkn_dec}>;\r\n }\r\n\r\n body a:hover { \r\n color: <{style.body_linkh_color}>;\r\n text-decoration: <{style.body_linkh_dec}>;\r\n }\r\n\r\n .table_out{\r\n background-color: <{style.tbl_out_bordercolor}>;\r\n width: <{style.tbl_out_width}>;\r\n border: <{style.tbl_out_border}>px;\r\n }\r\n\r\n .mainpage{\r\n background-color: <{style.mainpage_bgcolor}>;\r\n color: <{style.mainpage_fontcolor}>;\r\n text-align: center;\r\n }\r\n\r\n .mainpage a:link, .mainpage a:visited, .mainpage a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .mainpage a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n\r\n .header_welcome{\r\n background-color: <{style.mainpage_bgcolor}>;\r\n color: <{style.mainpage_fontcolor}>;\r\n text-align: right;\r\n }\r\n\r\n .header_welcome a:link, .header_welcome a:visited, .header_welcome a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .header_welcome a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n\r\n .logo{\r\n background-color: <{style.logo_bgcolor}>;\r\n color: <{style.logo_fontcolor}>;\r\n text-align: <{style.logo_textalign}>;\r\n }\r\n\r\n .logo_text{\r\n font-size: <{style.logotext_size}>;\r\n font-family: <{style.logotext_font}>;\r\n }\r\n\r\n .footer{\r\n background-color: <{style.footer_bgcolor}>;\r\n text-align: right;\r\n }\r\n\r\n .footer a:link, .footer a:visited, .footer a:active { \r\n color: <{style.footer_linkn_color}>;\r\n text-decoration: <{style.footer_linkn_dec}>;\r\n }\r\n\r\n .footer a:hover { \r\n color: <{style.footer_linkh_color}>;\r\n text-decoration: <{style.footer_linkh_dec}>;\r\n }\r\n\r\n\r\n .normaltext{\r\n font-size: <{style.normaltext_size}>;\r\n font-family: <{style.normaltext_font}>;\r\n }\r\n\r\n .bigtext{\r\n font-size: <{style.bigtext_size}>;\r\n font-family: <{style.bigtext_font}>;\r\n }\r\n\r\n .errortext{\r\n color: red;\r\n font-size: <{style.normaltext_size}>;\r\n font-family: <{style.normaltext_font}>;\r\n }\r\n\r\n .buttons{\r\n background-color: <{style.buttons_bgcolor}>;\r\n <if condition={$vars[\'style\'][\'buttons_bgimage\'] != \'\'}>\r\n background-image: url(\'<{style.buttons_bgimage}>\');\r\n <endif>\r\n text-align: <{style.buttons_align}>;\r\n }\r\n \r\n .buttons a:link, .buttons a:visited, .buttons a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .buttons a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n \r\n .center{\r\n text-align: center;\r\n }\r\n \r\n .table_in{\r\n background-color: <{style.tbl_in_bordercolor}>;\r\n border: <{style.tbl_in_border}>;\r\n text-align: center;\r\n width: 98%;\r\n }\r\n \r\n .table_in2{\r\n background-color: <{style.tbl_in_bordercolor}>;\r\n border: <{style.tbl_in_border}>;\r\n text-align: center;\r\n }\r\n \r\n .table_in_cat{\r\n background-color: <{style.tbl_in_cat_bgcolor}>;\r\n background-image: url(\'<{style.imagefolder}>/<{style.tbl_in_cat_bgimage}>\');\r\n }\r\n \r\n .table_in_cat a:link, .table_in_cat a:visited, .table_in_cat a:active { \r\n color: <{style.tbl_in_cat_linkn_color}>;\r\n text-decoration: <{style.tbl_in_cat_linkn_dec}>;\r\n }\r\n\r\n .table_in_cat a:hover { \r\n color: <{style.tbl_in_cat_linkh_color}>;\r\n text-decoration: <{style.tbl_in_cat_linkh_dec}>;\r\n }\r\n\r\n .table_in_a{\r\n background-color: <{style.tbl_in_a_bgcolor}>;\r\n }\r\n \r\n .table_in_a a:link, .table_in_a a:visited, .table_in_a a:active { \r\n color: <{style.tbl_in_a_linkn_color}>;\r\n text-decoration: <{style.tbl_in_a_linkn_dec}>;\r\n }\r\n\r\n .table_in_a a:hover { \r\n color: <{style.tbl_in_a_linkh_color}>;\r\n text-decoration: <{style.tbl_in_a_linkh_dec}>;\r\n }\r\n\r\n .table_in_b{\r\n background-color: <{style.tbl_in_b_bgcolor}>;\r\n }\r\n \r\n .table_in_b a:link, .table_in_b a:visited, .table_in_b a:active { \r\n color: <{style.tbl_in_b_linkn_color}>;\r\n text-decoration: <{style.tbl_in_b_linkn_dec}>;\r\n }\r\n\r\n .table_in_b a:hover { \r\n color: <{style.tbl_in_b_linkh_color}>;\r\n text-decoration: <{style.tbl_in_b_linkh_dec}>;\r\n }\r\n </style>\r\n <{head}>\r\n</head>\r\n<body>\r\n<{body}>\r\n</body>\r\n</html>', '<?xml version="1.0" encoding="windows-1252"?>\r\n<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="<{langname}>" xml:lang="<{langname}>">\r\n<head>\r\n <title><{title}></title>\r\n <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />\r\n <style type="text/css">\r\n body{\r\n background-color: <{style.bgcolor}>;\r\n }\r\n \r\n body a:link, body a:visited, body a:active { \r\n color: <{style.body_linkn_color}>;\r\n text-decoration: <{style.body_linkn_dec}>;\r\n }\r\n\r\n body a:hover { \r\n color: <{style.body_linkh_color}>;\r\n text-decoration: <{style.body_linkh_dec}>;\r\n }\r\n\r\n .table_out{\r\n background-color: <{style.tbl_out_bordercolor}>;\r\n width: <{style.tbl_out_width}>;\r\n border: <{style.tbl_out_border}>px;\r\n }\r\n\r\n .mainpage{\r\n background-color: <{style.mainpage_bgcolor}>;\r\n color: <{style.mainpage_fontcolor}>;\r\n text-align: center;\r\n }\r\n\r\n .mainpage a:link, .mainpage a:visited, .mainpage a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .mainpage a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n\r\n .header_welcome{\r\n background-color: <{style.mainpage_bgcolor}>;\r\n color: <{style.mainpage_fontcolor}>;\r\n text-align: right;\r\n }\r\n\r\n .header_welcome a:link, .header_welcome a:visited, .header_welcome a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .header_welcome a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n\r\n .logo{\r\n background-color: <{style.logo_bgcolor}>;\r\n color: <{style.logo_fontcolor}>;\r\n text-align: <{style.logo_textalign}>;\r\n }\r\n\r\n .logo_text{\r\n font-size: <{style.logotext_size}>;\r\n font-family: <{style.logotext_font}>;\r\n }\r\n\r\n .footer{\r\n background-color: <{style.footer_bgcolor}>;\r\n text-align: right;\r\n }\r\n\r\n .footer a:link, .footer a:visited, .footer a:active { \r\n color: <{style.footer_linkn_color}>;\r\n text-decoration: <{style.footer_linkn_dec}>;\r\n }\r\n\r\n .footer a:hover { \r\n color: <{style.footer_linkh_color}>;\r\n text-decoration: <{style.footer_linkh_dec}>;\r\n }\r\n\r\n\r\n .normaltext{\r\n font-size: <{style.normaltext_size}>;\r\n font-family: <{style.normaltext_font}>;\r\n }\r\n\r\n .bigtext{\r\n font-size: <{style.bigtext_size}>;\r\n font-family: <{style.bigtext_font}>;\r\n }\r\n\r\n .errortext{\r\n color: red;\r\n font-size: <{style.normaltext_size}>;\r\n font-family: <{style.normaltext_font}>;\r\n }\r\n\r\n .buttons{\r\n background-color: <{style.buttons_bgcolor}>;\r\n <if condition={$vars[\'style\'][\'buttons_bgimage\'] != \'\'}>\r\n background-image: url(\'<{style.buttons_bgimage}>\');\r\n <endif>\r\n text-align: <{style.buttons_align}>;\r\n }\r\n \r\n .buttons a:link, .buttons a:visited, .buttons a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .buttons a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n \r\n .center{\r\n text-align: center;\r\n }\r\n \r\n .table_in{\r\n background-color: <{style.tbl_in_bordercolor}>;\r\n border: <{style.tbl_in_border}>;\r\n text-align: center;\r\n width: 98%;\r\n }\r\n \r\n .table_in2{\r\n background-color: <{style.tbl_in_bordercolor}>;\r\n border: <{style.tbl_in_border}>;\r\n text-align: center;\r\n }\r\n \r\n .table_in_cat{\r\n background-color: <{style.tbl_in_cat_bgcolor}>;\r\n background-image: url(\'<{style.imagefolder}>/<{style.tbl_in_cat_bgimage}>\');\r\n }\r\n \r\n .table_in_cat a:link, .table_in_cat a:visited, .table_in_cat a:active { \r\n color: <{style.tbl_in_cat_linkn_color}>;\r\n text-decoration: <{style.tbl_in_cat_linkn_dec}>;\r\n }\r\n\r\n .table_in_cat a:hover { \r\n color: <{style.tbl_in_cat_linkh_color}>;\r\n text-decoration: <{style.tbl_in_cat_linkh_dec}>;\r\n }\r\n\r\n .table_in_a{\r\n background-color: <{style.tbl_in_a_bgcolor}>;\r\n }\r\n \r\n .table_in_a a:link, .table_in_a a:visited, .table_in_a a:active { \r\n color: <{style.tbl_in_a_linkn_color}>;\r\n text-decoration: <{style.tbl_in_a_linkn_dec}>;\r\n }\r\n\r\n .table_in_a a:hover { \r\n color: <{style.tbl_in_a_linkh_color}>;\r\n text-decoration: <{style.tbl_in_a_linkh_dec}>;\r\n }\r\n\r\n .table_in_b{\r\n background-color: <{style.tbl_in_b_bgcolor}>;\r\n }\r\n \r\n .table_in_b a:link, .table_in_b a:visited, .table_in_b a:active { \r\n color: <{style.tbl_in_b_linkn_color}>;\r\n text-decoration: <{style.tbl_in_b_linkn_dec}>;\r\n }\r\n\r\n .table_in_b a:hover { \r\n color: <{style.tbl_in_b_linkh_color}>;\r\n text-decoration: <{style.tbl_in_b_linkh_dec}>;\r\n }\r\n </style>\r\n <{head}>\r\n</head>\r\n<body>\r\n<div align="center">\r\n<table class="table_out" cellspacing="<{style.tbl_out_cellspacing}>" cellpadding="<{style.tbl_out_cellspacing}>">\r\n<tr><td class="logo">\r\n <if condition={$vars[\'style\'][\'logo\'] != \'\'}>\r\n <img src="<{style.logo}>" alt="<{boardname}>" />\r\n <else>\r\n <span class="logo_text"><{boardname}></span>\r\n <endif>\r\n</td></tr>\r\n<tr><td class="buttons" align="center">\r\n <table cellspacing="0" cellpadding="0" style="border: 0px; width: 100%;">\r\n <tr><td align="left" style="width:150px;"><span class="bigtext">\r\n<if condition={$vars[\'userid\'] == 0}>\r\n <a href="register.php?s=<{s}>"><[button_register]></a> |\r\n <a href="login.php?s=<{s}>"><[title_login]></a>\r\n<else>\r\n <a href="ucp.php?s=<{s}>"><[button_usercp]></a> |\r\n <a href="logout.php?s=<{s}>"><[title_logout]></a>\r\n<endif>\r\n </span>\r\n </td>\r\n <td align="right" width="*">\r\n <span class="bigtext">\r\n<if condition={checkAdminPermission(\'can_use_acp\',0)}>\r\n <a href="admin/" target="_blank"><[button_acp]></a> |\r\n<endif>\r\n <a href="index.php?s=<{s}>"><[button_index]></a>\r\n </span>\r\n </td></tr>\r\n </table>\r\n</td></tr>\r\n<tr><td class="mainpage" style="text-align:right;"><{locator}></td></tr>\r\n<tr><td class="mainpage">\r\n <div align="center"><br />\r\n <span class="normaltext">\r\n This is an unstable version of osBB. We <b>highly</b> recommend to use this version <b>only for testing issues</b>.<br />\r\n We wont help you with any problems. It is <b>completely unsupported</b>!<br />\r\n </span>\r\n </div><br />\r\n <div align="center">\r\n <{body}>\r\n <br />\r\n </div>\r\n</td></tr></table>\r\n<span class="normaltext">\r\n This board runs with osBB <{version}> which is developed and © by the <a href="http://osbb.sourceforge.net" target="_blank">osBB Development Group</a><br />\r\n This program is <b>free software</b> released under the <a href="http://www.gnu.org/licenses/gpl.html" target="_blank">GNU/GPL</a>!<br />\r\n</span>\r\n</div>\r\n</body>\r\n</html>', 'langname,button_acp,button_register,title_login,button_usercp,title_logout,button_index,guest', 1); 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<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); INSERT INTO `osbb_templates` VALUES (3, 0, 'index_useronline', '', '<a href="etc.php?do=userinfo&id=<{id}>&s=<{s}>"><{name}></a>', '', 0); --- 1432,1436 ---- # ! INSERT INTO `osbb_templates` VALUES (1, 0, 'html', '<?xml version="1.0" encoding="windows-1252"?>\r\n<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="<{langname}>" xml:lang="<{langname}>">\r\n<head>\r\n <title><{title}></title>\r\n <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />\r\n <style type="text/css">\r\n body{\r\n background-color: <{style.bgcolor}>;\r\n }\r\n \r\n body a:link, body a:visited, body a:active { \r\n color: <{style.body_linkn_color}>;\r\n text-decoration: <{style.body_linkn_dec}>;\r\n }\r\n\r\n body a:hover { \r\n color: <{style.body_linkh_color}>;\r\n text-decoration: <{style.body_linkh_dec}>;\r\n }\r\n\r\n .table_out{\r\n background-color: <{style.tbl_out_bordercolor}>;\r\n width: <{style.tbl_out_width}>;\r\n border: <{style.tbl_out_border}>px;\r\n }\r\n\r\n .mainpage{\r\n background-color: <{style.mainpage_bgcolor}>;\r\n color: <{style.mainpage_fontcolor}>;\r\n text-align: center;\r\n }\r\n\r\n .mainpage a:link, .mainpage a:visited, .mainpage a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .mainpage a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n\r\n .header_welcome{\r\n background-color: <{style.mainpage_bgcolor}>;\r\n color: <{style.mainpage_fontcolor}>;\r\n text-align: right;\r\n }\r\n\r\n .header_welcome a:link, .header_welcome a:visited, .header_welcome a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .header_welcome a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n\r\n .logo{\r\n background-color: <{style.logo_bgcolor}>;\r\n color: <{style.logo_fontcolor}>;\r\n text-align: <{style.logo_textalign}>;\r\n }\r\n\r\n .logo_text{\r\n font-size: <{style.logotext_size}>;\r\n font-family: <{style.logotext_font}>;\r\n }\r\n\r\n .footer{\r\n background-color: <{style.footer_bgcolor}>;\r\n text-align: right;\r\n }\r\n\r\n .footer a:link, .footer a:visited, .footer a:active { \r\n color: <{style.footer_linkn_color}>;\r\n text-decoration: <{style.footer_linkn_dec}>;\r\n }\r\n\r\n .footer a:hover { \r\n color: <{style.footer_linkh_color}>;\r\n text-decoration: <{style.footer_linkh_dec}>;\r\n }\r\n\r\n\r\n .normaltext{\r\n font-size: <{style.normaltext_size}>;\r\n font-family: <{style.normaltext_font}>;\r\n }\r\n\r\n .bigtext{\r\n font-size: <{style.bigtext_size}>;\r\n font-family: <{style.bigtext_font}>;\r\n }\r\n\r\n .errortext{\r\n color: red;\r\n font-size: <{style.normaltext_size}>;\r\n font-family: <{style.normaltext_font}>;\r\n }\r\n\r\n .buttons{\r\n background-color: <{style.buttons_bgcolor}>;\r\n <if condition={$vars[\'style\'][\'buttons_bgimage\'] != \'\'}>\r\n background-image: url(\'<{style.buttons_bgimage}>\');\r\n <endif>\r\n text-align: <{style.buttons_align}>;\r\n }\r\n \r\n .buttons a:link, .buttons a:visited, .buttons a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .buttons a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n \r\n .center{\r\n text-align: center;\r\n }\r\n \r\n .table_in{\r\n background-color: <{style.tbl_in_bordercolor}>;\r\n border: <{style.tbl_in_border}>;\r\n text-align: center;\r\n width: 98%;\r\n }\r\n \r\n .table_in2{\r\n background-color: <{style.tbl_in_bordercolor}>;\r\n border: <{style.tbl_in_border}>;\r\n text-align: center;\r\n }\r\n \r\n .table_in_cat{\r\n background-color: <{style.tbl_in_cat_bgcolor}>;\r\n background-image: url(\'<{style.imagefolder}>/<{style.tbl_in_cat_bgimage}>\');\r\n }\r\n \r\n .table_in_cat a:link, .table_in_cat a:visited, .table_in_cat a:active { \r\n color: <{style.tbl_in_cat_linkn_color}>;\r\n text-decoration: <{style.tbl_in_cat_linkn_dec}>;\r\n }\r\n\r\n .table_in_cat a:hover { \r\n color: <{style.tbl_in_cat_linkh_color}>;\r\n text-decoration: <{style.tbl_in_cat_linkh_dec}>;\r\n }\r\n\r\n .table_in_a{\r\n background-color: <{style.tbl_in_a_bgcolor}>;\r\n }\r\n \r\n .table_in_a a:link, .table_in_a a:visited, .table_in_a a:active { \r\n color: <{style.tbl_in_a_linkn_color}>;\r\n text-decoration: <{style.tbl_in_a_linkn_dec}>;\r\n }\r\n\r\n .table_in_a a:hover { \r\n color: <{style.tbl_in_a_linkh_color}>;\r\n text-decoration: <{style.tbl_in_a_linkh_dec}>;\r\n }\r\n\r\n .table_in_b{\r\n background-color: <{style.tbl_in_b_bgcolor}>;\r\n }\r\n \r\n .table_in_b a:link, .table_in_b a:visited, .table_in_b a:active { \r\n color: <{style.tbl_in_b_linkn_color}>;\r\n text-decoration: <{style.tbl_in_b_linkn_dec}>;\r\n }\r\n\r\n .table_in_b a:hover { \r\n color: <{style.tbl_in_b_linkh_color}>;\r\n text-decoration: <{style.tbl_in_b_linkh_dec}>;\r\n }\r\n </style>\r\n <{head}>\r\n</head>\r\n<body>\r\n<{body}>\r\n</body>\r\n</html>', '<?xml version="1.0" encoding="windows-1252"?>\r\n<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="<{langname}>" xml:lang="<{langname}>">\r\n<head>\r\n <title><{title}></title>\r\n <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />\r\n <style type="text/css">\r\n body{\r\n background-color: <{style.bgcolor}>;\r\n }\r\n \r\n body a:link, body a:visited, body a:active { \r\n color: <{style.body_linkn_color}>;\r\n text-decoration: <{style.body_linkn_dec}>;\r\n }\r\n\r\n body a:hover { \r\n color: <{style.body_linkh_color}>;\r\n text-decoration: <{style.body_linkh_dec}>;\r\n }\r\n\r\n .table_out{\r\n background-color: <{style.tbl_out_bordercolor}>;\r\n width: <{style.tbl_out_width}>;\r\n border: <{style.tbl_out_border}>px;\r\n }\r\n\r\n .mainpage{\r\n background-color: <{style.mainpage_bgcolor}>;\r\n color: <{style.mainpage_fontcolor}>;\r\n text-align: center;\r\n }\r\n\r\n .mainpage a:link, .mainpage a:visited, .mainpage a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .mainpage a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n\r\n .header_welcome{\r\n background-color: <{style.mainpage_bgcolor}>;\r\n color: <{style.mainpage_fontcolor}>;\r\n text-align: right;\r\n }\r\n\r\n .header_welcome a:link, .header_welcome a:visited, .header_welcome a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .header_welcome a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n\r\n .logo{\r\n background-color: <{style.logo_bgcolor}>;\r\n color: <{style.logo_fontcolor}>;\r\n text-align: <{style.logo_textalign}>;\r\n }\r\n\r\n .logo_text{\r\n font-size: <{style.logotext_size}>;\r\n font-family: <{style.logotext_font}>;\r\n }\r\n\r\n .footer{\r\n background-color: <{style.footer_bgcolor}>;\r\n text-align: right;\r\n }\r\n\r\n .footer a:link, .footer a:visited, .footer a:active { \r\n color: <{style.footer_linkn_color}>;\r\n text-decoration: <{style.footer_linkn_dec}>;\r\n }\r\n\r\n .footer a:hover { \r\n color: <{style.footer_linkh_color}>;\r\n text-decoration: <{style.footer_linkh_dec}>;\r\n }\r\n\r\n\r\n .normaltext{\r\n font-size: <{style.normaltext_size}>;\r\n font-family: <{style.normaltext_font}>;\r\n }\r\n\r\n .bigtext{\r\n font-size: <{style.bigtext_size}>;\r\n font-family: <{style.bigtext_font}>;\r\n }\r\n\r\n .errortext{\r\n color: red;\r\n font-size: <{style.normaltext_size}>;\r\n font-family: <{style.normaltext_font}>;\r\n }\r\n\r\n .buttons{\r\n background-color: <{style.buttons_bgcolor}>;\r\n <if condition={$vars[\'style\'][\'buttons_bgimage\'] != \'\'}>\r\n background-image: url(\'<{style.buttons_bgimage}>\');\r\n <endif>\r\n text-align: <{style.buttons_align}>;\r\n }\r\n \r\n .buttons a:link, .buttons a:visited, .buttons a:active { \r\n color: <{style.mainpage_linkn_color}>;\r\n text-decoration: <{style.mainpage_linkn_dec}>;\r\n }\r\n\r\n .buttons a:hover { \r\n color: <{style.mainpage_linkh_color}>;\r\n text-decoration: <{style.mainpage_linkh_dec}>;\r\n }\r\n \r\n .center{\r\n text-align: center;\r\n }\r\n \r\n .table_in{\r\n background-color: <{style.tbl_in_bordercolor}>;\r\n border: <{style.tbl_in_border}>;\r\n text-align: center;\r\n width: 98%;\r\n }\r\n \r\n .table_in2{\r\n background-color: <{style.tbl_in_bordercolor}>;\r\n border: <{style.tbl_in_border}>;\r\n text-align: center;\r\n }\r\n \r\n .table_in_cat{\r\n background-color: <{style.tbl_in_cat_bgcolor}>;\r\n background-image: url(\'<{style.imagefolder}>/<{style.tbl_in_cat_bgimage}>\');\r\n }\r\n \r\n .table_in_cat a:link, .table_in_cat a:visited, .table_in_cat a:active { \r\n color: <{style.tbl_in_cat_linkn_color}>;\r\n text-decoration: <{style.tbl_in_cat_linkn_dec}>;\r\n }\r\n\r\n .table_in_cat a:hover { \r\n color: <{style.tbl_in_cat_linkh_color}>;\r\n text-decoration: <{style.tbl_in_cat_linkh_dec}>;\r\n }\r\n\r\n .table_in_a{\r\n background-color: <{style.tbl_in_a_bgcolor}>;\r\n }\r\n \r\n .table_in_a a:link, .table_in_a a:visited, .table_in_a a:active { \r\n color: <{style.tbl_in_a_linkn_color}>;\r\n text-decoration: <{style.tbl_in_a_linkn_dec}>;\r\n }\r\n\r\n .table_in_a a:hover { \r\n color: <{style.tbl_in_a_linkh_color}>;\r\n text-decoration: <{style.tbl_in_a_linkh_dec}>;\r\n }\r\n\r\n .table_in_b{\r\n background-color: <{style.tbl_in_b_bgcolor}>;\r\n }\r\n \r\n .table_in_b a:link, .table_in_b a:visited, .table_in_b a:active { \r\n color: <{style.tbl_in_b_linkn_color}>;\r\n text-decoration: <{style.tbl_in_b_linkn_dec}>;\r\n }\r\n\r\n .table_in_b a:hover { \r\n color: <{style.tbl_in_b_linkh_color}>;\r\n text-decoration: <{style.tbl_in_b_linkh_dec}>;\r\n }\r\n </style>\r\n <{head}>\r\n</head>\r\n<body>\r\n<div align="center">\r\n<table class="table_out" cellspacing="<{style.tbl_out_cellspacing}>" cellpadding="<{style.tbl_out_cellspacing}>">\r\n<tr><td class="logo">\r\n <if condition={$vars[\'style\'][\'logo\'] != \'\'}>\r\n <img src="<{style.logo}>" alt="<{boardname}>" />\r\n <else>\r\n <span class="logo_text"><{boardname}></span>\r\n <endif>\r\n</td></tr>\r\n<tr><td class="buttons" align="center">\r\n <table cellspacing="0" cellpadding="0" style="border: 0px; width: 100%;">\r\n <tr><td align="left" style="width:150px;"><span class="bigtext">\r\n<if condition={$vars[\'userid\'] == 0}>\r\n <a href="register.php?s=<{s}>"><[button_register]></a> |\r\n <a href="login.php?s=<{s}>"><[title_login]></a>\r\n<else>\r\n <a href="ucp.php?s=<{s}>"><[button_usercp]></a> |\r\n <a href="logout.php?s=<{s}>"><[title_logout]></a>\r\n<endif>\r\n </span>\r\n </td>\r\n <td align="right" width="*">\r\n <span class="bigtext">\r\n<if condition={checkAdminPermission(\'can_use_acp\',0)}>\r\n <a href="admin/" target="_blank"><[button_acp]></a> |\r\n<endif>\r\n <a href="index.php?s=<{s}>"><[button_index]></a>\r\n </span>\r\n </td></tr>\r\n </table>\r\n</td></tr>\r\n<tr><td class="mainpage" style="text-align:right;"><{locator}></td></tr>\r\n<tr><td class="mainpage">\r\n <div align="center"><br />\r\n <span class="normaltext">\r\n This is an unstable version of osBB. We <b>highly</b> recommend to use this version <b>only for testing issues</b>.<br />\r\n We wont help you with any problems. It is <b>completely unsupported</b>!<br />\r\n </span>\r\n </div><br />\r\n <div align="center">\r\n <{body}>\r\n <br />\r\n </div>\r\n</td></tr></table>\r\n<span class="normaltext">\r\n<{timezone}>\r\n</span>\r\n</table>\r\n<span class="normaltext">\r\n This board runs with osBB <{version}> which is developed and © by the <a href="http://osbb.sourceforge.net" target="_blank">osBB Development Group</a><br />\r\n This program is <b>free software</b> released under the <a href="http://www.gnu.org/licenses/gpl.html" target="_blank">GNU/GPL</a>!<br />\r\n</span>\r\n</div>\r\n</body>\r\n</html>', 'langname,button_acp,button_register,title_login,button_usercp,title_logout,button_index,guest,timezone', 1); 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<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); INSERT INTO `osbb_templates` VALUES (3, 0, 'index_useronline', '', '<a href="etc.php?do=userinfo&id=<{id}>&s=<{s}>"><{name}></a>', '', 0); *************** *** 1551,1554 **** --- 1554,1558 ---- `useronlinerankgid` int(100) NOT NULL default '0', `userghostmode` tinyint(1) NOT NULL default '0', + `usertimezone` tinyint(2) NOT NULL default '0', `useravatarid` int(20) NOT NULL default '0', `userextrarank` varchar(255) NOT NULL default '', *************** *** 1595,1600 **** # ! INSERT INTO `osbb_users` VALUES (1, 'brainstorm', '6bbcd00b37878eb6d5e5e9858c7c6453be9ac3ec', 45, 2, 1, 1, 1, 0, 0, 'Admin', 1, 1, '', '', '', 1, 1, 0, 1, 1, 162877844, 'test', 'te...@te...', 'test', '', 'http://www.test.de', '', 0, 0, 1, 1099734367, '16-4-2004', 'a:5:{i:1;s:8:"test;;;;";i:2;s:1:"2";i:3;s:5:"0,1,2";i:4;s:1:"0";i:5;s:1:"1";}', 1104941847, 1104764589, 86, 0, 1, 1, 'cfcd208495d565ef66e7dff9f98764da', '0', 1, 1, 0, 1); ! INSERT INTO `osbb_users` VALUES (2, 'brainstorm|test', 'a688a47ac73fb58ce3828bcb184cb157', 2, 3, 5, 4, 0, 0, 0, '', 0, 0, '', '', '', 1, 1, 0, 0, 0, 0, '', '', '', '', '', 'te...@we...', 0, 0, 0, 1099734467, 'nn-nn-nnnn', '', 1104941847, 1099933377, 70, 0, 0, 0, '38583984fb294dde77df9fed596cb271', '5edc00cb0083d94b22073d1c786a515f', 1, 1, 0, 0); # -------------------------------------------------------- --- 1599,1604 ---- # ! INSERT INTO `osbb_users` VALUES (1, 'brainstorm', '6bbcd00b37878eb6d5e5e9858c7c6453be9ac3ec', 45, 2, 1, 1, 1, 0, 0, 0, 'Admin', 1, 1, '', '', '', 1, 1, 0, 1, 1, 162877844, 'test', 'te...@te...', 'test', '', 'http://www.test.de', '', 0, 0, 1, 1099734367, '16-4-2004', 'a:5:{i:1;s:8:"test;;;;";i:2;s:1:"2";i:3;s:5:"0,1,2";i:4;s:1:"0";i:5;s:1:"1";}', 1105020640, 1105015006, 86, 0, 1, 1, 'cfcd208495d565ef66e7dff9f98764da', '0', 1, 1, 0, 1); ! INSERT INTO `osbb_users` VALUES (2, 'brainstorm|test', 'a688a47ac73fb58ce3828bcb184cb157', 2, 3, 5, 4, 0, 0, 0, 0, '', 0, 0, '', '', '', 1, 1, 0, 0, 0, 0, '', '', '', '', '', 'te...@we...', 0, 0, 0, 1099734467, 'nn-nn-nnnn', '', 1105020640, 1099933377, 70, 0, 0, 0, '38583984fb294dde77df9fed596cb271', '5edc00cb0083d94b22073d1c786a515f', 1, 1, 0, 0); # -------------------------------------------------------- |
