Menu
▾
▴
mxbb-commits — Internal Mailing List for CVS Commit Messages
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
|
Mar
(95) |
Apr
(270) |
May
(111) |
Jun
|
Jul
|
Aug
(64) |
Sep
(130) |
Oct
(319) |
Nov
(17) |
Dec
(191) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
(53) |
Feb
|
Mar
|
Apr
|
May
(6) |
Jun
(387) |
Jul
(102) |
Aug
(247) |
Sep
(120) |
Oct
(1) |
Nov
(8) |
Dec
(21) |
| 2007 |
Jan
(38) |
Feb
(36) |
Mar
|
Apr
(32) |
May
(135) |
Jun
(523) |
Jul
(192) |
Aug
(103) |
Sep
(533) |
Oct
(77) |
Nov
(23) |
Dec
(203) |
| 2008 |
Jan
(312) |
Feb
(1193) |
Mar
(404) |
Apr
(67) |
May
(62) |
Jun
(497) |
Jul
(297) |
Aug
(110) |
Sep
(335) |
Oct
(256) |
Nov
(50) |
Dec
(118) |
| 2009 |
Jan
(67) |
Feb
(10) |
Mar
(1) |
Apr
(1) |
May
|
Jun
(10) |
Jul
(61) |
Aug
|
Sep
(16) |
Oct
(45) |
Nov
(12) |
Dec
(14) |
| 2010 |
Jan
(30) |
Feb
|
Mar
|
Apr
(4) |
May
|
Jun
|
Jul
(7) |
Aug
(7) |
Sep
(5) |
Oct
(5) |
Nov
|
Dec
|
| 2011 |
Jan
(7) |
Feb
(3) |
Mar
(89) |
Apr
(11) |
May
(5) |
Jun
|
Jul
(8) |
Aug
(1) |
Sep
(2) |
Oct
|
Nov
(2) |
Dec
(89) |
| 2012 |
Jan
(7) |
Feb
(1) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(4) |
Sep
(3) |
Oct
(42) |
Nov
(1) |
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
(19) |
Apr
(90) |
May
(38) |
Jun
(235) |
Jul
(38) |
Aug
(10) |
Sep
|
Oct
(29) |
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
(6) |
May
(52) |
Jun
|
Jul
(7) |
Aug
|
Sep
(17) |
Oct
|
Nov
|
Dec
|
|
From: Andrew <men...@us...> - 2006-01-02 20:31:02
|
Update of /cvsroot/mxbb/mx_sitestats In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv27237 Modified Files: db_install.php Log Message: Credits... Index: db_install.php =================================================================== RCS file: /cvsroot/mxbb/mx_sitestats/db_install.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** db_install.php 24 Oct 2005 20:19:01 -0000 1.2 --- db_install.php 2 Jan 2006 20:30:53 -0000 1.3 *************** *** 3,7 **** * Subject : mxBB - a fully modular portal and CMS (for phpBB) * Author : Jon Ohlsson and the mxBB Team ! * Credits : The phpBB Group & Marc Morisette, Marc Ferran (www.phpmix.com) * Copyright : (C) 2002-2005 mxBB Portal, phpMiX (c) 2004 * Email : jo...@mx... --- 3,7 ---- * Subject : mxBB - a fully modular portal and CMS (for phpBB) * Author : Jon Ohlsson and the mxBB Team ! * Credits : The phpBB Group, mxBB Team, markus(_petrux) (www.phpmix.com) * Copyright : (C) 2002-2005 mxBB Portal, phpMiX (c) 2004 * Email : jo...@mx... *************** *** 42,46 **** $mx_module_version = 'mxBB Sitestats Module 2.0.0'; ! $mx_module_copy = 'Written by <a href="http://www.phpmix.com" target="_phpbb" >Markus</a>'; // Read module constants... --- 42,46 ---- $mx_module_version = 'mxBB Sitestats Module 2.0.0'; ! $mx_module_copy = 'Written by <a href="http://www.phpmix.com" target="_phpbb" >markus</a>'; // Read module constants... |
|
From: Jon O. <jon...@us...> - 2005-12-31 15:15:15
|
Update of /cvsroot/mxbb/core/modules/mx_coreblocks/templates/subSilver/images In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv28217/images Log Message: Directory /cvsroot/mxbb/core/modules/mx_coreblocks/templates/subSilver/images added to the repository |
|
From: Jon O. <jon...@us...> - 2005-12-31 15:05:00
|
Update of /cvsroot/mxbb/core/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25585/admin Modified Files: admin_mx_portal.php page_header_admin.php Log Message: mostly cosmetics, and minor mxBB styling fixes Index: page_header_admin.php =================================================================== RCS file: /cvsroot/mxbb/core/admin/page_header_admin.php,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** page_header_admin.php 1 Oct 2005 14:10:44 -0000 1.11 --- page_header_admin.php 31 Dec 2005 15:04:51 -0000 1.12 *************** *** 97,106 **** 'S_CONTENT_DIR_LEFT' => $lang['LEFT'], 'S_CONTENT_DIR_RIGHT' => $lang['RIGHT'], ! // MX ADDON ! 'L_MX_ADMIN' => $lang['mxBB_adminCP'], ! 'U_PHPBB_ROOT_PATH' => PHPBB_URL, ! 'U_PORTAL_ROOT_PATH' => PORTAL_URL, ! 'TEMPLATE_ROOT_PATH' => TEMPLATE_ROOT_PATH, ! // END 'T_HEAD_STYLESHEET' => $theme['head_stylesheet'], 'T_BODY_BACKGROUND' => $theme['body_background'], --- 97,105 ---- 'S_CONTENT_DIR_LEFT' => $lang['LEFT'], 'S_CONTENT_DIR_RIGHT' => $lang['RIGHT'], ! ! // ! // These theme variables are not used for mxBB, since mxBB require a theme.css file ! // ! /* 'T_HEAD_STYLESHEET' => $theme['head_stylesheet'], 'T_BODY_BACKGROUND' => $theme['body_background'], *************** *** 140,145 **** 'T_SPAN_CLASS1' => $theme['span_class1'], 'T_SPAN_CLASS2' => $theme['span_class2'], ! 'T_SPAN_CLASS3' => $theme['span_class3']) ! ); $template->pparse('header'); --- 139,156 ---- 'T_SPAN_CLASS1' => $theme['span_class1'], 'T_SPAN_CLASS2' => $theme['span_class2'], ! 'T_SPAN_CLASS3' => $theme['span_class3'], ! */ ! ! //+ mxBB ! 'L_MX_ADMIN' => $lang['mxBB_adminCP'], ! 'U_PHPBB_ROOT_PATH' => PHPBB_URL, ! 'U_PORTAL_ROOT_PATH' => PORTAL_URL, ! 'TEMPLATE_ROOT_PATH' => TEMPLATE_ROOT_PATH, ! ! 'T_PHPBB_STYLESHEET' => $theme['head_stylesheet'], ! 'T_MXBB_STYLESHEET' => $theme['head_stylesheet'], ! 'T_GECKO_STYLESHEET' => 'gecko.css' ! //- mxBB ! )); $template->pparse('header'); Index: admin_mx_portal.php =================================================================== RCS file: /cvsroot/mxbb/core/admin/admin_mx_portal.php,v retrieving revision 1.21 retrieving revision 1.22 diff -C2 -d -r1.21 -r1.22 *** admin_mx_portal.php 8 Dec 2005 21:41:27 -0000 1.21 --- admin_mx_portal.php 31 Dec 2005 15:04:51 -0000 1.22 *************** *** 33,37 **** require('./pagestart.' . $phpEx); - // // Begin program proper --- 33,36 ---- |
|
From: Andrew <men...@us...> - 2005-12-30 18:50:02
|
Update of /cvsroot/mxbb/core/templates/subSilver/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14789/templates/subSilver/admin Modified Files: index_body.tpl Log Message: Updated in compliance with phpBB 2.0.19's release. Index: index_body.tpl =================================================================== RCS file: /cvsroot/mxbb/core/templates/subSilver/admin/index_body.tpl,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** index_body.tpl 24 Oct 2005 00:55:41 -0000 1.5 --- index_body.tpl 30 Dec 2005 18:49:52 -0000 1.6 *************** *** 40,43 **** --- 40,49 ---- </tr> </table> + + <h1>{L_VERSION_INFORMATION}</h1> + + {MXBB_VERSION_INFO} + {PHPBB_VERSION_INFO} + <h1>{L_WHO_IS_ONLINE}</h1> <table width="100%" cellpadding="4" cellspacing="1" border="0" class="forumline"> *************** *** 72,79 **** </table> - <h1>{L_VERSION_INFORMATION}</h1> - - {MXBB_VERSION_INFO} - {PHPBB_VERSION_INFO} - <br clear="all" /> \ No newline at end of file --- 78,80 ---- |
|
From: Andrew <men...@us...> - 2005-12-30 18:50:02
|
Update of /cvsroot/mxbb/core/language/lang_english In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14789/language/lang_english Modified Files: lang_main.php Log Message: Updated in compliance with phpBB 2.0.19's release. Index: lang_main.php =================================================================== RCS file: /cvsroot/mxbb/core/language/lang_english/lang_main.php,v retrieving revision 1.26 retrieving revision 1.27 diff -C2 -d -r1.26 -r1.27 *** lang_main.php 18 Dec 2005 16:44:20 -0000 1.26 --- lang_main.php 30 Dec 2005 18:49:52 -0000 1.27 *************** *** 117,120 **** --- 117,122 ---- $lang['No'] = 'No'; + $lang['Please_remove_install_contrib'] = 'Please ensure both the install/ and contrib/ directories are deleted'; + // // That's all Folks! |
|
From: Andrew <men...@us...> - 2005-12-30 18:50:02
|
Update of /cvsroot/mxbb/core In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14789 Modified Files: common.php login.php Log Message: Updated in compliance with phpBB 2.0.19's release. Index: login.php =================================================================== RCS file: /cvsroot/mxbb/core/login.php,v retrieving revision 1.15 retrieving revision 1.16 diff -C2 -d -r1.15 -r1.16 *** login.php 9 Dec 2005 23:22:03 -0000 1.15 --- login.php 30 Dec 2005 18:49:52 -0000 1.16 *************** *** 56,60 **** $password = isset($HTTP_POST_VARS['password']) ? $HTTP_POST_VARS['password'] : ''; ! $sql = "SELECT user_id, username, user_password, user_active, user_level FROM " . USERS_TABLE . " WHERE username = '" . str_replace("\\'", "''", $username) . "'"; --- 56,60 ---- $password = isset($HTTP_POST_VARS['password']) ? $HTTP_POST_VARS['password'] : ''; ! $sql = "SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM " . USERS_TABLE . " WHERE username = '" . str_replace("\\'", "''", $username) . "'"; *************** *** 72,75 **** --- 72,90 ---- else { + + // If the last login is more than x minutes ago, then reset the login tries/time + if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $row['user_last_login_try'] < (time() - ($board_config['login_reset_time'] * 60))) + { + $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']); + $row['user_last_login_try'] = $row['user_login_tries'] = 0; + } + + // Check to see if user is allowed to login again... if his tries are exceeded + if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $board_config['max_login_attempts'] && + $row['user_last_login_try'] >= (time() - ($board_config['login_reset_time'] * 60)) && $row['user_login_tries'] >= $board_config['max_login_attempts']) + { + message_die(GENERAL_MESSAGE, sprintf($lang['Login_attempts_exceeded'], $board_config['max_login_attempts'], $board_config['login_reset_time'])); + } + if( md5($password) == $row['user_password'] && $row['user_active'] ) { *************** *** 78,81 **** --- 93,99 ---- $admin = (isset($HTTP_POST_VARS['admin'])) ? 1 : 0; $session_id = session_begin($row['user_id'], $user_ip, PAGE_INDEX, FALSE, $autologin, $admin); + + // Reset login tries + $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']); if( $session_id ) *************** *** 91,94 **** --- 109,122 ---- else { + + // Save login tries and last login + if ($row['user_id'] != ANONYMOUS) + { + $sql = 'UPDATE ' . USERS_TABLE . ' + SET user_login_tries = user_login_tries + 1, user_last_login_try = ' . time() . ' + WHERE user_id = ' . $row['user_id']; + $db->sql_query($sql); + } + $redirect = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : ''; $redirect = str_replace('?', '&', $redirect); Index: common.php =================================================================== RCS file: /cvsroot/mxbb/core/common.php,v retrieving revision 1.45 retrieving revision 1.46 diff -C2 -d -r1.45 -r1.46 *** common.php 9 Dec 2005 23:22:03 -0000 1.45 --- common.php 30 Dec 2005 18:49:51 -0000 1.46 *************** *** 298,302 **** if( file_exists('install') || file_exists('contrib') ) { ! mx_message_die(GENERAL_MESSAGE, 'Please ensure both the install/ and contrib/ directories are deleted'); } --- 298,302 ---- if( file_exists('install') || file_exists('contrib') ) { ! mx_message_die(GENERAL_MESSAGE, 'Please_remove_install_contrib'); } |
|
From: Andrew <men...@us...> - 2005-12-30 18:50:02
|
Update of /cvsroot/mxbb/core/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14789/admin Modified Files: index.php Log Message: Updated in compliance with phpBB 2.0.19's release. Index: index.php =================================================================== RCS file: /cvsroot/mxbb/core/admin/index.php,v retrieving revision 1.20 retrieving revision 1.21 diff -C2 -d -r1.20 -r1.21 *** index.php 18 Dec 2005 16:41:38 -0000 1.20 --- index.php 30 Dec 2005 18:49:51 -0000 1.21 *************** *** 420,426 **** $version = $row['mysql_version']; ! if( preg_match("/^(3\.23|4\.)/", $version) ) { ! $db_name = ( preg_match("/^(3\.23\.[6-9])|(3\.23\.[1-9][1-9])|(4\.)/", $version) ) ? "`$dbname`" : $dbname; $sql = "SHOW TABLE STATUS --- 420,426 ---- $version = $row['mysql_version']; ! if( preg_match("/^(3\.23|4\.|5\.)/", $version) ) { ! $db_name = ( preg_match("/^(3\.23\.[6-9])|(3\.23\.[1-9][1-9])|(4\.)|(5\.)/", $version) ) ? "`$dbname`" : $dbname; $sql = "SHOW TABLE STATUS |
|
From: Andrew <men...@us...> - 2005-12-22 18:09:08
|
Update of /cvsroot/mxbb/core/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11399/includes Modified Files: mx_functions_ch.php Log Message: Compatibility with CH fix; thanks to selven for this one. Also note that I added $phpbb_root_path in case... Index: mx_functions_ch.php =================================================================== RCS file: /cvsroot/mxbb/core/includes/mx_functions_ch.php,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** mx_functions_ch.php 18 Dec 2005 18:24:27 -0000 1.4 --- mx_functions_ch.php 22 Dec 2005 18:09:00 -0000 1.5 *************** *** 48,52 **** if ( !defined('IN_LOGIN') && !defined('IN_INSTALL') && (($config->data['mod_cat_hierarchy'] != CH_CURRENT_VERSION) || defined('RUN_CH_INSTALL')) ) { ! header('Location: ./install_cat/install.' . $phpEx . (empty($SID) ? '' : '?' . $SID)); exit; } --- 48,52 ---- if ( !defined('IN_LOGIN') && !defined('IN_INSTALL') && (($config->data['mod_cat_hierarchy'] != CH_CURRENT_VERSION) || defined('RUN_CH_INSTALL')) ) { ! header('Location: ' . $phpbb_root_path . 'install_cat/install.' . $phpEx . (empty($SID) ? '' : '?' . $SID)); exit; } *************** *** 90,92 **** --- 90,107 ---- include($phpbb_root_path . 'language/lang_' . $language . '/lang_extend_cat_hierarchy.' . $phpEx); + // include extra language key + $language = $userdata['user_lang']; + + if( !file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_extend_cat_hierarchy.'.$phpEx) ) + { + $language = $board_config['default_lang']; + } + + if( !file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_extend_cat_hierarchy.'.$phpEx) ) + { + $language = 'english'; + } + + include($phpbb_root_path . 'language/lang_' . $language . '/lang_extend_cat_hierarchy.' . $phpEx); + ?> \ No newline at end of file |
|
From: Andrew <men...@us...> - 2005-12-20 20:36:12
|
Update of /cvsroot/mxbb/core/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29900/install Modified Files: mx_install.php Log Message: May not have time to do all of this... Index: mx_install.php =================================================================== RCS file: /cvsroot/mxbb/core/install/mx_install.php,v retrieving revision 1.61 retrieving revision 1.62 diff -C2 -d -r1.61 -r1.62 *** mx_install.php 20 Dec 2005 04:31:14 -0000 1.61 --- mx_install.php 20 Dec 2005 20:36:03 -0000 1.62 *************** *** 251,260 **** 'COMMENTS' => 'mx_remove_comments' ), ! 'mssql' => array( ! 'LABEL' => 'MS SQL Server 7/2000', ! 'SCHEMA' => 'mssql', ! 'DELIM' => 'GO', ! 'DELIM_BASIC' => ';', ! 'COMMENTS' => 'mx_remove_comments' ), // 'msaccess' => array( --- 251,260 ---- 'COMMENTS' => 'mx_remove_comments' ), ! // 'mssql' => array( ! // 'LABEL' => 'MS SQL Server 7/2000', ! // 'SCHEMA' => 'mssql', ! // 'DELIM' => 'GO', ! // 'DELIM_BASIC' => ';', ! // 'COMMENTS' => 'mx_remove_comments' ), // 'msaccess' => array( |
|
From: Andrew <men...@us...> - 2005-12-20 04:31:25
|
Update of /cvsroot/mxbb/core/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24638/install Modified Files: mx_install.php Log Message: Minor... Index: mx_install.php =================================================================== RCS file: /cvsroot/mxbb/core/install/mx_install.php,v retrieving revision 1.60 retrieving revision 1.61 diff -C2 -d -r1.60 -r1.61 *** mx_install.php 17 Dec 2005 20:30:36 -0000 1.60 --- mx_install.php 20 Dec 2005 04:31:14 -0000 1.61 *************** *** 4,13 **** * begin : june, 2002 * copyright : (C) 2002-2005 mxBB-Portal ! * email : jon...@ho... * project site : www.mx-system.com * * editor settings : Please, set tabsize to 4 * - * description : * ------------------------------------------------------------------------- * --- 4,12 ---- * begin : june, 2002 * copyright : (C) 2002-2005 mxBB-Portal ! * email : jo...@mx... * project site : www.mx-system.com * * editor settings : Please, set tabsize to 4 * * ------------------------------------------------------------------------- * *************** *** 47,51 **** // $mx_portal_name = 'mxBB-Portal'; ! $mx_portal_version = '2.8.0b1'; // --- 46,50 ---- // $mx_portal_name = 'mxBB-Portal'; ! $mx_portal_version = '2.8.0B1'; // *************** *** 82,86 **** // FYI: // The following code related to PHP Global Variables is based on ! // common.php from phpBB 2.0.13 // error_reporting (E_ERROR | E_WARNING | E_PARSE); // This will NOT report uninitialized variables --- 81,85 ---- // FYI: // The following code related to PHP Global Variables is based on ! // common.php from phpBB 2.0.18 // error_reporting (E_ERROR | E_WARNING | E_PARSE); // This will NOT report uninitialized variables *************** *** 252,262 **** 'COMMENTS' => 'mx_remove_comments' ), ! // 'mssql' => array( ! // 'LABEL' => 'MS SQL Server 7/2000', ! // 'SCHEMA' => 'mssql', ! // 'DELIM' => 'GO', ! // 'DELIM_BASIC' => ';', ! // 'COMMENTS' => 'mx_remove_comments' ! // ), // 'msaccess' => array( // 'LABEL' => 'MS Access [ ODBC ]', --- 251,261 ---- 'COMMENTS' => 'mx_remove_comments' ), ! 'mssql' => array( ! 'LABEL' => 'MS SQL Server 7/2000', ! 'SCHEMA' => 'mssql', ! 'DELIM' => 'GO', ! 'DELIM_BASIC' => ';', ! 'COMMENTS' => 'mx_remove_comments' ! ), // 'msaccess' => array( // 'LABEL' => 'MS Access [ ODBC ]', |
|
From: Andrew <men...@us...> - 2005-12-20 04:24:22
|
Update of /cvsroot/mxbb/core/contrib/sync_overall_header In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23774/contrib/sync_overall_header Modified Files: how to.txt Log Message: Test Index: how to.txt =================================================================== RCS file: /cvsroot/mxbb/core/contrib/sync_overall_header/how to.txt,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** how to.txt 17 Dec 2005 20:25:34 -0000 1.4 --- how to.txt 20 Dec 2005 04:24:04 -0000 1.5 *************** *** 1,2 **** --- 1,4 ---- + # $Id$ + HOW TO: |
|
From: Andrew <men...@us...> - 2005-12-20 04:23:29
|
Update of /cvsroot/mxbb/core/contrib/replace_phpbb_admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23129/contrib/replace_phpbb_admin Modified Files: install.txt Log Message: ... Index: install.txt =================================================================== RCS file: /cvsroot/mxbb/core/contrib/replace_phpbb_admin/install.txt,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** install.txt 17 Dec 2005 20:30:16 -0000 1.3 --- install.txt 20 Dec 2005 04:22:52 -0000 1.4 *************** *** 5,7 **** Copy the index.php in the phpbb/admin directory. ! Edit index.php and replace "www.your_host.com" with your portal adress. \ No newline at end of file --- 5,7 ---- Copy the index.php in the phpbb/admin directory. ! Edit index.php and replace "www.yourdomain.com" with your portal address. \ No newline at end of file |
|
From: Andrew <men...@us...> - 2005-12-20 00:46:49
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11460/install/schemas Added Files: mssql_schema_install_2.7.3.sql Log Message: Preliminary... --- NEW FILE: mssql_schema_install_2.7.3.sql --- CREATE TABLE mx_table_block ( block_id SMALLINT NOT NULL IDENTITY(1, 1), block_title VARCHAR(150) NULL DEFAULT (NULL), block_desc TEXT NULL, function_id SMALLINT NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), auth_edit SMALLINT NULL DEFAULT (0), auth_delete SMALLINT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), auth_edit_group SMALLINT NOT NULL DEFAULT (0), auth_delete_group SMALLINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_block_pk PRIMARY KEY (block_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (function_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_block VALUES(1,'Welcome','',20,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(2,'Multiple Horizontal Blocks','',19,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(3,'Demo Textblock Multi','',22,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(4,'Demo Textblock BBcode','',20,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(5,'Demo Textblock Html','',21,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(6,'Poll','',12,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(7,'Language Select','',13,99,5,0,0,0,0); INSERT INTO mx_table_block VALUES(8,'Navigation Menu','',11,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(24,'Forum','',10,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(13,'Login',NULL,14,99,5,0,0,0,0); INSERT INTO mx_table_block VALUES(14,'Theme Select','',15,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(21,'Google','',16,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(18,'Announcements',NULL,17,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(19,'Online','',18,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(16,'Last Message Post',NULL,30,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(32,'Statistics','',40,0,0,0,0,0,0); CREATE TABLE mx_block_system_parameter ( block_id SMALLINT NOT NULL DEFAULT (0), parameter_id SMALLINT NOT NULL DEFAULT (0), parameter_value TEXT NULL, bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), CONSTRAINT mx_block_system_parameter_pk PRIMARY KEY (block_id, parameter_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (parameter_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_block_system_parameter VALUES(1,15,'Welcome to the Mx-system Portal!\r\n\r\nPlease visit www.mx-system.com for further information.\r\n\r\nThe Mx-Portal version is announced and documented [url=http://www.mx-system.com/forum/viewforum.php?f=11] here[/url].','10bec5b560'); INSERT INTO mx_block_system_parameter VALUES(2,60,'3,4,5',''); INSERT INTO mx_block_system_parameter VALUES(2,61,'33%,*,33%',''); INSERT INTO mx_block_system_parameter VALUES(2,62,'4',''); INSERT INTO mx_block_system_parameter VALUES(3,50,'This is a demo multi textblock!\r\n\r\n - featuring bbcode, html, style parameters (click the EDIT button and try them out) and permissions (view and edit permissions for users and PRIVATE groups).','10bec5b560'); INSERT INTO mx_block_system_parameter VALUES(3,51,'none',''); INSERT INTO mx_block_system_parameter VALUES(3,52,'TRUE',''); INSERT INTO mx_block_system_parameter VALUES(3,53,'TRUE',''); INSERT INTO mx_block_system_parameter VALUES(3,54,'TRUE',''); INSERT INTO mx_block_system_parameter VALUES(4,15,'This is a demo bbcode textblock!\r\n\r\n- featuring bbcode, html and permissions (view and edit permissions for users and PRIVATE groups).','10bec5b560'); INSERT INTO mx_block_system_parameter VALUES(5,16,'This is a demo html textblock!\r\n\r\n- featuring html and permissions (view and edit permissions for users and PRIVATE groups).','10bec5b560'); INSERT INTO mx_block_system_parameter VALUES(6,36,'',NULL); INSERT INTO mx_block_system_parameter VALUES(6,13,'0',NULL); INSERT INTO mx_block_system_parameter VALUES(16,17,'5',NULL); INSERT INTO mx_block_system_parameter VALUES(16,18,'TRUE',NULL); INSERT INTO mx_block_system_parameter VALUES(16,19,'30',NULL); INSERT INTO mx_block_system_parameter VALUES(16,20,'_self',NULL); INSERT INTO mx_block_system_parameter VALUES(16,21,'left',NULL); INSERT INTO mx_block_system_parameter VALUES(16,22,'TRUE',NULL); INSERT INTO mx_block_system_parameter VALUES(16,37,'',NULL); INSERT INTO mx_block_system_parameter VALUES(16,38,'FALSE',NULL); INSERT INTO mx_block_system_parameter VALUES(16,39,'FALSE',NULL); INSERT INTO mx_block_system_parameter VALUES(16,40,'TRUE',NULL); INSERT INTO mx_block_system_parameter VALUES(18,1,'1',NULL); INSERT INTO mx_block_system_parameter VALUES(18,2,'999',NULL); INSERT INTO mx_block_system_parameter VALUES(18,3,'TRUE',NULL); INSERT INTO mx_block_system_parameter VALUES(18,4,'FALSE',NULL); INSERT INTO mx_block_system_parameter VALUES(18,5,'FALSE',NULL); INSERT INTO mx_block_system_parameter VALUES(18,7,'thumb_news.gif',NULL); INSERT INTO mx_block_system_parameter VALUES(18,8,'thumb_globe.gif',NULL); INSERT INTO mx_block_system_parameter VALUES(18,9,'thumb_globe.gif',NULL); INSERT INTO mx_block_system_parameter VALUES(18,6,'TRUE',NULL); INSERT INTO mx_block_system_parameter VALUES(18,10,'thumb_globe.gif ',NULL); INSERT INTO mx_block_system_parameter VALUES(18,11,'',NULL); CREATE TABLE mx_table_column ( column_id SMALLINT NOT NULL IDENTITY(1, 1), column_title VARCHAR(100) NULL DEFAULT (NULL), column_order SMALLINT NOT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), column_size VARCHAR(5) NULL DEFAULT ('100%'), page_id SMALLINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_column_pk PRIMARY KEY (column_id) ON [PRIMARY], CHECK (column_id>=0), CHECK (column_order>=0) ) ON [PRIMARY]; CREATE INDEX mx_table_column_cat_order ON mx_table_column (column_order) ON [PRIMARY]; INSERT INTO mx_table_column VALUES(1,'Column 1',10,NULL,'220',1); INSERT INTO mx_table_column VALUES(2,'Column 2',20,NULL,'100%',1); INSERT INTO mx_table_column VALUES(20,'Menu',10,NULL,'200',2); INSERT INTO mx_table_column VALUES(21,'Forum',20,NULL,'100%',2); CREATE TABLE mx_table_column_block ( column_id SMALLINT NOT NULL DEFAULT (0), block_id SMALLINT NOT NULL DEFAULT (0), block_order SMALLINT NOT NULL DEFAULT (0) ) ON [PRIMARY]; INSERT INTO mx_table_column_block VALUES(1,8,10); INSERT INTO mx_table_column_block VALUES(1,16,20); INSERT INTO mx_table_column_block VALUES(1,6,30); INSERT INTO mx_table_column_block VALUES(1,13,40); INSERT INTO mx_table_column_block VALUES(1,7,50); INSERT INTO mx_table_column_block VALUES(1,14,60); INSERT INTO mx_table_column_block VALUES(2,1,10); INSERT INTO mx_table_column_block VALUES(2,2,10); INSERT INTO mx_table_column_block VALUES(2,18,20); INSERT INTO mx_table_column_block VALUES(2,19,30); INSERT INTO mx_table_column_block VALUES(20,8,10); INSERT INTO mx_table_column_block VALUES(20,16,20); INSERT INTO mx_table_column_block VALUES(21,24,30); INSERT INTO mx_table_column_block VALUES(21,19,40); CREATE TABLE mx_table_function ( function_id SMALLINT NOT NULL IDENTITY(1, 1), module_id SMALLINT NOT NULL DEFAULT (0), function_name VARCHAR(150) NULL DEFAULT (NULL), function_desc TEXT NULL, function_file VARCHAR(255) NULL DEFAULT (NULL), function_admin VARCHAR(255) NULL DEFAULT (NULL), CONSTRAINT mx_table_function_pk PRIMARY KEY (function_id) ON [PRIMARY], CHECK (function_id>=0), CHECK (module_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_table_function_module_id ON mx_table_function (module_id) ON [PRIMARY]; INSERT INTO mx_table_function VALUES(10,10,'Forum phpBB','Forum phpBB','mx_forum.php',NULL); INSERT INTO mx_table_function VALUES(11,10,'Navigation Menu','Menu Navigation','mx_menu_nav.php','admin/admin_mx_menu.php'); INSERT INTO mx_table_function VALUES(12,10,'Polls','Polls','mx_poll.php',NULL); INSERT INTO mx_table_function VALUES(13,10,'Language Select','Language Select','mx_language.php',NULL); INSERT INTO mx_table_function VALUES(14,10,'Login','Login','mx_login.php',NULL); INSERT INTO mx_table_function VALUES(15,10,'Theme Select','Theme Select','mx_theme.php',NULL); INSERT INTO mx_table_function VALUES(16,10,'Google','Google','mx_google.php',NULL); INSERT INTO mx_table_function VALUES(17,10,'Announcements','Announcements','mx_announce.php',NULL); INSERT INTO mx_table_function VALUES(18,10,'Who is Online','Who is Online','mx_online.php',NULL); INSERT INTO mx_table_function VALUES(19,10,'Multiple Horizontal Blocks','Block that can arrange other blocks in a horizontal line.','mx_multiple_blocks.php',''); INSERT INTO mx_table_function VALUES(20,20,'TextBlock_BBcode','TextBlock_BBcode','mx_textblock_bbcode.php','modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES(21,20,'TextBlock_Html','TextBlock_Html','mx_textblock_html.php','modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES(22,20,'TextBlock_Multi','Textblock for bbcode and html with parameters','mx_textblock_multi.php','modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES(30,30,'Post Last Message','Post Last Message','mx_last_msg.php',NULL); INSERT INTO mx_table_function VALUES(40,40,'Statistics MX','Statistics MX','mx_statistics.php',NULL); CREATE TABLE mx_table_menu_categories ( block_id SMALLINT NOT NULL DEFAULT (1), cat_id INTEGER NOT NULL IDENTITY(1, 1), cat_title VARCHAR(100) NULL DEFAULT (NULL), cat_order INTEGER NOT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), cat_desc TEXT NULL, cat_show TINYINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_menu_categories_pk PRIMARY KEY (cat_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (cat_id>=0), CHECK (cat_order>=0), CHECK (cat_show>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_tablemenucategoriescatorder ON mx_table_menu_categories (cat_order) ON [PRIMARY]; INSERT INTO mx_table_menu_categories VALUES(8,1,'Main Menu',20,NULL,NULL,1); CREATE TABLE mx_table_menu_nav ( menu_id SMALLINT NOT NULL IDENTITY(1, 1), cat_id INTEGER NOT NULL DEFAULT (0), menu_name VARCHAR(150) NULL DEFAULT (NULL), menu_desc TEXT NULL, menu_links VARCHAR(255) NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), menu_order SMALLINT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), menu_icon VARCHAR(255) NULL DEFAULT (NULL), function_id SMALLINT NULL DEFAULT (0), block_id SMALLINT NOT NULL DEFAULT (0), page_id SMALLINT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), link_target TINYINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_menu_nav_pk PRIMARY KEY (menu_id) ON [PRIMARY], CHECK (menu_id>=0), CHECK (cat_id>=0), CHECK (menu_order>=0), CHECK (function_id>=0), CHECK (page_id>=0), CHECK (link_target>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_table_menu_nav_cat_id ON mx_table_menu_nav (cat_id) ON [PRIMARY]; INSERT INTO mx_table_menu_nav VALUES(1,1,'Home','Home Page','index.php',0,10,'bc5d5e65eb','icon_home.gif',0,0,0,0,0); INSERT INTO mx_table_menu_nav VALUES(2,1,'Forum','phpBB Forum','index.php',0,20,'1a7e19f246','icon_forum.gif',0,0,2,0,0); INSERT INTO mx_table_menu_nav VALUES(3,1,'Statistics','Statistics Module','',0,30,'e16b0fbb51','icon_stat.gif',40,0,0,0,0); CREATE TABLE mx_table_module ( module_id SMALLINT NOT NULL IDENTITY(1, 1), module_name VARCHAR(150) NULL DEFAULT (NULL), module_path VARCHAR(255) NULL DEFAULT (NULL), module_desc TEXT NULL, module_include_admin CHAR(1) NULL DEFAULT ('0'), CONSTRAINT mx_table_module_pk PRIMARY KEY (module_id) ON [PRIMARY], CHECK (module_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_module VALUES(10,'Core Blocks','./','Core blocks',''); INSERT INTO mx_table_module VALUES(20,'Text Blocks','modules/mx_textblocks/','Textblocks module',''); INSERT INTO mx_table_module VALUES(30,'Post Last Message','modules/mx_last_msg/','Last Message Module','0'); INSERT INTO mx_table_module VALUES(40,'Statistics MX','modules/mx_statistics/','Statistics Modules','0'); CREATE TABLE mx_table_page ( page_id SMALLINT NOT NULL IDENTITY(1, 1), page_name VARCHAR(255) NULL DEFAULT (NULL), page_icon VARCHAR(255) NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), page_header VARCHAR(255) NULL DEFAULT ('overall_header.tpl'), CONSTRAINT mx_table_page_pk PRIMARY KEY (page_id) ON [PRIMARY] ) ON [PRIMARY]; INSERT INTO mx_table_page VALUES(1,'Home','icon_home.gif',0,0,'overall_header.tpl'); INSERT INTO mx_table_page VALUES(2,'Forum','icon_forum.gif',0,0,'overall_header.tpl'); CREATE TABLE mx_table_parameter ( parameter_id SMALLINT NOT NULL IDENTITY(1, 1), function_id SMALLINT NOT NULL DEFAULT (0), parameter_name VARCHAR(150) NULL DEFAULT (NULL), parameter_type VARCHAR(30) NULL DEFAULT (NULL), parameter_default VARCHAR(150) NULL DEFAULT (NULL), parameter_function VARCHAR(255) NULL DEFAULT (NULL), CONSTRAINT mx_table_parameter_pk PRIMARY KEY (parameter_id) ON [PRIMARY], CHECK (parameter_id>=0), CHECK (function_id>=0) ) ON [PRIMARY]; INSERT INTO mx_table_parameter VALUES(1,17,'announce_nbr_display','Number','1',NULL); INSERT INTO mx_table_parameter VALUES(2,17,'announce_nbr_days','Number','14',NULL); INSERT INTO mx_table_parameter VALUES(3,17,'announce_display','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(4,17,'announce_display_sticky','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(5,17,'announce_display_normal','Boolean','FALSE',NULL); INSERT INTO mx_table_parameter VALUES(7,17,'announce_img','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(8,17,'announce_img_sticky','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(9,17,'announce_img_normal','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(6,17,'announce_display_global','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(10,17,'announce_img_global','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(11,17,'announce_forum','Function',NULL,'get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(13,12,'Poll_Display','Function','0','poll_select( {parameter_value}, "{parameter_id}" )'); INSERT INTO mx_table_parameter VALUES(36,12,'poll_forum','Function','','get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(15,20,'Text','BBText','Insert your text here',NULL); INSERT INTO mx_table_parameter VALUES(16,21,'Html','Html','Entre your Html code here',NULL); INSERT INTO mx_table_parameter VALUES(17,30,'Last_Msg_Number_Title','Number','15',NULL); INSERT INTO mx_table_parameter VALUES(18,30,'Last_Msg_Display_Date','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(19,30,'Last_Msg_Title_Length','Number','30',NULL); INSERT INTO mx_table_parameter VALUES(20,30,'Last_Msg_Target','Values','_blank',NULL); INSERT INTO mx_table_parameter VALUES(21,30,'Last_Msg_Align','Values','left',NULL); INSERT INTO mx_table_parameter VALUES(22,30,'Last_Msg_Display_Forum','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(37,30,'Last_Msg_forum','Function','','get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(38,30,'Last_Msg_Display_Last_Author','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(39,30,'Last_Msg_Display_Author','Boolean','FALSE',''); INSERT INTO mx_table_parameter VALUES(40,30,'Last_Msg_Display_Icon_View','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(50,22,'Text','BBText','Enter your block text here',''); INSERT INTO mx_table_parameter VALUES(51,22,'text_style','Values','none',''); INSERT INTO mx_table_parameter VALUES(52,22,'block_style','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(53,22,'title_style','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(54,22,'show_title','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(60,19,'block_ids','Function','1,2,3','get_list_multiple( "{parameter_id}[]", BLOCK_TABLE, \'block_id\', \'block_title\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(61,19,'block_sizes','Text','20%,30%,*',''); INSERT INTO mx_table_parameter VALUES(62,19,'space_between','Number','4',''); CREATE TABLE mx_table_parameter_option ( option_id SMALLINT NOT NULL IDENTITY(1, 1), parameter_id SMALLINT NOT NULL DEFAULT (0), option_code VARCHAR(150) NULL DEFAULT (NULL), option_desc TEXT NULL, CONSTRAINT mx_table_parameter_option_pk PRIMARY KEY (option_id) ON [PRIMARY], CHECK (option_id>=0), CHECK (parameter_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_parameter_option VALUES(1,14,'0','Sunday'); INSERT INTO mx_table_parameter_option VALUES(2,14,'1','Monday'); INSERT INTO mx_table_parameter_option VALUES(3,21,'left','left '); INSERT INTO mx_table_parameter_option VALUES(4,21,'right','right'); INSERT INTO mx_table_parameter_option VALUES(5,21,'center','center'); INSERT INTO mx_table_parameter_option VALUES(6,20,'_blank','New Window'); INSERT INTO mx_table_parameter_option VALUES(7,20,'_self','Current Window'); CREATE TABLE mx_table_portal ( portal_id SMALLINT NOT NULL IDENTITY(1, 1), portal_name VARCHAR(150) NULL DEFAULT (NULL), portal_phpbb_url VARCHAR(255) NULL DEFAULT ('http://www.phpbb.com/phpBB/'), portal_url VARCHAR(255) NULL DEFAULT (NULL), portal_version VARCHAR(255) NULL DEFAULT (NULL), top_phpbb_links SMALLINT NOT NULL DEFAULT (1), CONSTRAINT mx_table_portal_pk PRIMARY KEY (portal_id) ON [PRIMARY], CHECK (portal_id>=0), CHECK (top_phpbb_links>=0) ) ON [PRIMARY]; |
|
From: Andrew <men...@us...> - 2005-12-20 00:39:48
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9828/install/schemas Added Files: mssql_schema_install_2.7.2.sql Log Message: Preliminary schema... --- NEW FILE: mssql_schema_install_2.7.2.sql --- CREATE TABLE mx_table_block ( block_id SMALLINT NOT NULL IDENTITY(1, 1), block_title VARCHAR(150) NULL DEFAULT (NULL), block_desc TEXT NULL, function_id SMALLINT NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), auth_edit SMALLINT NULL DEFAULT (0), auth_delete SMALLINT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), auth_edit_group SMALLINT NOT NULL DEFAULT (0), auth_delete_group SMALLINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_block_pk PRIMARY KEY (block_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (function_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_block VALUES(1,'Welcome','',20,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(2,'Multiple Horizontal Blocks','',19,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(3,'Demo Textblock Multi','',22,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(4,'Demo Textblock BBcode','',20,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(5,'Demo Textblock Html','',21,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(6,'Poll','',12,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(7,'Language Select','',13,99,5,0,0,0,0); INSERT INTO mx_table_block VALUES(8,'Navigation Menu','',11,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(24,'Forum','',10,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(13,'Login',NULL,14,99,5,0,0,0,0); INSERT INTO mx_table_block VALUES(14,'Theme Select','',15,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(21,'Google','',16,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(18,'Announcements',NULL,17,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(19,'Online','',18,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(16,'Last Message Post',NULL,30,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(32,'Statistics','',40,0,0,0,0,0,0); CREATE TABLE mx_block_system_parameter ( block_id SMALLINT NOT NULL DEFAULT (0), parameter_id SMALLINT NOT NULL DEFAULT (0), parameter_value TEXT NULL, bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), CONSTRAINT mx_block_system_parameter_pk PRIMARY KEY (block_id, parameter_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (parameter_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_block_system_parameter VALUES(1,15,'Welcome to the Mx-system Portal!\r\n\r\nPlease visit www.mx-system.com for further information.\r\n\r\nThe Mx-Portal version is announced and documented [url=http://www.mx-system.com/forum/viewforum.php?f=11] here[/url].','10bec5b560'); INSERT INTO mx_block_system_parameter VALUES(2,60,'3,4,5',''); INSERT INTO mx_block_system_parameter VALUES(2,61,'33%,*,33%',''); INSERT INTO mx_block_system_parameter VALUES(2,62,'4',''); INSERT INTO mx_block_system_parameter VALUES(3,50,'This is a demo multi textblock!\r\n\r\n - featuring bbcode, html (if allowed by phpbb config), style parameters (click the EDIT button and try them out) and permissions (view and edit permissions for users and PRIVATE groups).','10bec5b560'); INSERT INTO mx_block_system_parameter VALUES(3,51,'none',''); INSERT INTO mx_block_system_parameter VALUES(3,52,'TRUE',''); INSERT INTO mx_block_system_parameter VALUES(3,53,'TRUE',''); INSERT INTO mx_block_system_parameter VALUES(3,54,'TRUE',''); INSERT INTO mx_block_system_parameter VALUES(4,15,'This is a demo bbcode textblock!\r\n\r\n- featuring bbcode, html (if allowed by phpbb config) and permissions (view and edit permissions for users and PRIVATE groups).','10bec5b560'); INSERT INTO mx_block_system_parameter VALUES(5,16,'This is a demo html textblock!\r\n\r\n- featuring html (if allowed by phpbb config) and permissions (view and edit permissions for users and PRIVATE groups).','10bec5b560'); INSERT INTO mx_block_system_parameter VALUES(6,36,'',NULL); INSERT INTO mx_block_system_parameter VALUES(6,13,'0',NULL); INSERT INTO mx_block_system_parameter VALUES(16,17,'5',NULL); INSERT INTO mx_block_system_parameter VALUES(16,18,'TRUE',NULL); INSERT INTO mx_block_system_parameter VALUES(16,19,'30',NULL); INSERT INTO mx_block_system_parameter VALUES(16,20,'_self',NULL); INSERT INTO mx_block_system_parameter VALUES(16,21,'left',NULL); INSERT INTO mx_block_system_parameter VALUES(16,22,'TRUE',NULL); INSERT INTO mx_block_system_parameter VALUES(16,37,'',NULL); INSERT INTO mx_block_system_parameter VALUES(16,38,'FALSE',NULL); INSERT INTO mx_block_system_parameter VALUES(16,39,'FALSE',NULL); INSERT INTO mx_block_system_parameter VALUES(16,40,'TRUE',NULL); INSERT INTO mx_block_system_parameter VALUES(18,1,'1',NULL); INSERT INTO mx_block_system_parameter VALUES(18,2,'999',NULL); INSERT INTO mx_block_system_parameter VALUES(18,3,'TRUE',NULL); INSERT INTO mx_block_system_parameter VALUES(18,4,'FALSE',NULL); INSERT INTO mx_block_system_parameter VALUES(18,5,'FALSE',NULL); INSERT INTO mx_block_system_parameter VALUES(18,7,'thumb_news.gif',NULL); INSERT INTO mx_block_system_parameter VALUES(18,8,'thumb_globe.gif',NULL); INSERT INTO mx_block_system_parameter VALUES(18,9,'thumb_globe.gif',NULL); INSERT INTO mx_block_system_parameter VALUES(18,6,'TRUE',NULL); INSERT INTO mx_block_system_parameter VALUES(18,10,'thumb_globe.gif ',NULL); INSERT INTO mx_block_system_parameter VALUES(18,11,'',NULL); CREATE TABLE mx_table_column ( column_id SMALLINT NOT NULL IDENTITY(1, 1), column_title VARCHAR(100) NULL DEFAULT (NULL), column_order SMALLINT NOT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), column_size VARCHAR(5) NULL DEFAULT ('100%'), page_id SMALLINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_column_pk PRIMARY KEY (column_id) ON [PRIMARY], CHECK (column_id>=0), CHECK (column_order>=0) ) ON [PRIMARY]; CREATE INDEX mx_table_column_cat_order ON mx_table_column (column_order) ON [PRIMARY]; INSERT INTO mx_table_column VALUES(1,'Column 1',10,NULL,'220',1); INSERT INTO mx_table_column VALUES(2,'Column 2',20,NULL,'100%',1); INSERT INTO mx_table_column VALUES(20,'Menu',10,NULL,'200',2); INSERT INTO mx_table_column VALUES(21,'Forum',20,NULL,'100%',2); CREATE TABLE mx_table_column_block ( column_id SMALLINT NOT NULL DEFAULT (0), block_id SMALLINT NOT NULL DEFAULT (0), block_order SMALLINT NOT NULL DEFAULT (0) ) ON [PRIMARY]; INSERT INTO mx_table_column_block VALUES(1,8,10); INSERT INTO mx_table_column_block VALUES(1,16,20); INSERT INTO mx_table_column_block VALUES(1,6,30); INSERT INTO mx_table_column_block VALUES(1,13,40); INSERT INTO mx_table_column_block VALUES(1,7,50); INSERT INTO mx_table_column_block VALUES(1,14,60); INSERT INTO mx_table_column_block VALUES(2,1,10); INSERT INTO mx_table_column_block VALUES(2,2,10); INSERT INTO mx_table_column_block VALUES(2,18,20); INSERT INTO mx_table_column_block VALUES(2,19,30); INSERT INTO mx_table_column_block VALUES(20,8,10); INSERT INTO mx_table_column_block VALUES(20,16,20); INSERT INTO mx_table_column_block VALUES(21,24,30); INSERT INTO mx_table_column_block VALUES(21,19,40); CREATE TABLE mx_table_function ( function_id SMALLINT NOT NULL IDENTITY(1, 1), module_id SMALLINT NOT NULL DEFAULT (0), function_name VARCHAR(150) NULL DEFAULT (NULL), function_desc TEXT NULL, function_file VARCHAR(255) NULL DEFAULT (NULL), function_admin VARCHAR(255) NULL DEFAULT (NULL), CONSTRAINT mx_table_function_pk PRIMARY KEY (function_id) ON [PRIMARY], CHECK (function_id>=0), CHECK (module_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_table_function_module_id ON mx_table_function (module_id) ON [PRIMARY]; INSERT INTO mx_table_function VALUES(10,10,'Forum phpBB','Forum phpBB','mx_forum.php',NULL); INSERT INTO mx_table_function VALUES(11,10,'Navigation Menu','Menu Navigation','mx_menu_nav.php','admin/admin_mx_menu.php'); INSERT INTO mx_table_function VALUES(12,10,'Polls','Polls','mx_poll.php',NULL); INSERT INTO mx_table_function VALUES(13,10,'Language Select','Language Select','mx_language.php',NULL); INSERT INTO mx_table_function VALUES(14,10,'Login','Login','mx_login.php',NULL); INSERT INTO mx_table_function VALUES(15,10,'Theme Select','Theme Select','mx_theme.php',NULL); INSERT INTO mx_table_function VALUES(16,10,'Google','Google','mx_google.php',NULL); INSERT INTO mx_table_function VALUES(17,10,'Announcements','Announcements','mx_announce.php',NULL); INSERT INTO mx_table_function VALUES(18,10,'Who is Online','Who is Online','mx_online.php',NULL); INSERT INTO mx_table_function VALUES(19,10,'Multiple Horizontal Blocks','Block that can arrange other blocks in a horizontal line.','mx_multiple_blocks.php',''); INSERT INTO mx_table_function VALUES(20,20,'TextBlock_BBcode','TextBlock_BBcode','mx_textblock_bbcode.php','modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES(21,20,'TextBlock_Html','TextBlock_Html','mx_textblock_html.php','modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES(22,20,'TextBlock_Multi','Textblock for bbcode and html with parameters','mx_textblock_multi.php','modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES(30,30,'Post Last Message','Post Last Message','mx_last_msg.php',NULL); INSERT INTO mx_table_function VALUES(40,40,'Statistics MX','Statistics MX','mx_statistics.php',NULL); CREATE TABLE mx_table_menu_categories ( block_id SMALLINT NOT NULL DEFAULT (1), cat_id INTEGER NOT NULL IDENTITY(1, 1), cat_title VARCHAR(100) NULL DEFAULT (NULL), cat_order INTEGER NOT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), cat_desc TEXT NULL, cat_show TINYINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_menu_categories_pk PRIMARY KEY (cat_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (cat_id>=0), CHECK (cat_order>=0), CHECK (cat_show>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_tablemenucategoriescatorder ON mx_table_menu_categories (cat_order) ON [PRIMARY]; INSERT INTO mx_table_menu_categories VALUES(8,1,'Main Menu',20,NULL,NULL,1); CREATE TABLE mx_table_menu_nav ( menu_id SMALLINT NOT NULL IDENTITY(1, 1), cat_id INTEGER NOT NULL DEFAULT (0), menu_name VARCHAR(150) NULL DEFAULT (NULL), menu_desc TEXT NULL, menu_links VARCHAR(255) NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), menu_order SMALLINT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), menu_icon VARCHAR(255) NULL DEFAULT (NULL), function_id SMALLINT NULL DEFAULT (0), block_id SMALLINT NOT NULL DEFAULT (0), page_id SMALLINT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), link_target TINYINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_menu_nav_pk PRIMARY KEY (menu_id) ON [PRIMARY], CHECK (menu_id>=0), CHECK (cat_id>=0), CHECK (menu_order>=0), CHECK (function_id>=0), CHECK (page_id>=0), CHECK (link_target>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_table_menu_nav_cat_id ON mx_table_menu_nav (cat_id) ON [PRIMARY]; INSERT INTO mx_table_menu_nav VALUES(1,1,'Home','Home Page','index.php',0,10,'bc5d5e65eb','icon_home.gif',0,0,0,0,0); INSERT INTO mx_table_menu_nav VALUES(2,1,'Forum','phpBB Forum','index.php',0,20,'1a7e19f246','icon_forum.gif',0,0,2,0,0); INSERT INTO mx_table_menu_nav VALUES(3,1,'Statistics','Statistics Module','',0,30,'e16b0fbb51','icon_stat.gif',40,0,0,0,0); CREATE TABLE mx_table_module ( module_id SMALLINT NOT NULL IDENTITY(1, 1), module_name VARCHAR(150) NULL DEFAULT (NULL), module_path VARCHAR(255) NULL DEFAULT (NULL), module_desc TEXT NULL, module_include_admin CHAR(1) NULL DEFAULT ('0'), CONSTRAINT mx_table_module_pk PRIMARY KEY (module_id) ON [PRIMARY], CHECK (module_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_module VALUES(10,'Core Blocks','./','Core blocks',''); INSERT INTO mx_table_module VALUES(20,'Text Blocks','modules/mx_textblocks/','Textblocks module',''); INSERT INTO mx_table_module VALUES(30,'Post Last Message','modules/mx_last_msg/','Last Message Module','0'); INSERT INTO mx_table_module VALUES(40,'Statistics MX','modules/mx_statistics/','Statistics Modules','0'); CREATE TABLE mx_table_page ( page_id SMALLINT NOT NULL IDENTITY(1, 1), page_name VARCHAR(255) NULL DEFAULT (NULL), page_icon VARCHAR(255) NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), page_header VARCHAR(255) NULL DEFAULT ('overall_header.tpl'), CONSTRAINT mx_table_page_pk PRIMARY KEY (page_id) ON [PRIMARY] ) ON [PRIMARY]; INSERT INTO mx_table_page VALUES(1,'Home','icon_home.gif',0,0,'overall_header.tpl'); INSERT INTO mx_table_page VALUES(2,'Forum','icon_forum.gif',0,0,'overall_header.tpl'); CREATE TABLE mx_table_parameter ( parameter_id SMALLINT NOT NULL IDENTITY(1, 1), function_id SMALLINT NOT NULL DEFAULT (0), parameter_name VARCHAR(150) NULL DEFAULT (NULL), parameter_type VARCHAR(30) NULL DEFAULT (NULL), parameter_default VARCHAR(150) NULL DEFAULT (NULL), parameter_function VARCHAR(255) NULL DEFAULT (NULL), CONSTRAINT mx_table_parameter_pk PRIMARY KEY (parameter_id) ON [PRIMARY], CHECK (parameter_id>=0), CHECK (function_id>=0) ) ON [PRIMARY]; INSERT INTO mx_table_parameter VALUES(1,17,'announce_nbr_display','Number','1',NULL); INSERT INTO mx_table_parameter VALUES(2,17,'announce_nbr_days','Number','14',NULL); INSERT INTO mx_table_parameter VALUES(3,17,'announce_display','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(4,17,'announce_display_sticky','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(5,17,'announce_display_normal','Boolean','FALSE',NULL); INSERT INTO mx_table_parameter VALUES(7,17,'announce_img','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(8,17,'announce_img_sticky','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(9,17,'announce_img_normal','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(6,17,'announce_display_global','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(10,17,'announce_img_global','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(11,17,'announce_forum','Function',NULL,'get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(13,12,'Poll_Display','Function','0','poll_select( {parameter_value}, "{parameter_id}" )'); INSERT INTO mx_table_parameter VALUES(36,12,'poll_forum','Function','','get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(15,20,'Text','BBText','Insert your text here',NULL); INSERT INTO mx_table_parameter VALUES(16,21,'Html','Html','Entre your Html code here',NULL); INSERT INTO mx_table_parameter VALUES(17,30,'Last_Msg_Number_Title','Number','15',NULL); INSERT INTO mx_table_parameter VALUES(18,30,'Last_Msg_Display_Date','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(19,30,'Last_Msg_Title_Length','Number','30',NULL); INSERT INTO mx_table_parameter VALUES(20,30,'Last_Msg_Target','Values','_blank',NULL); INSERT INTO mx_table_parameter VALUES(21,30,'Last_Msg_Align','Values','left',NULL); INSERT INTO mx_table_parameter VALUES(22,30,'Last_Msg_Display_Forum','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(37,30,'Last_Msg_forum','Function','','get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(38,30,'Last_Msg_Display_Last_Author','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(39,30,'Last_Msg_Display_Author','Boolean','FALSE',''); INSERT INTO mx_table_parameter VALUES(40,30,'Last_Msg_Display_Icon_View','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(50,22,'Text','BBText','Enter your block text here',''); INSERT INTO mx_table_parameter VALUES(51,22,'text_style','Values','none',''); INSERT INTO mx_table_parameter VALUES(52,22,'block_style','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(53,22,'title_style','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(54,22,'show_title','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(60,19,'block_ids','Function','1,2,3','get_list_multiple( "{parameter_id}[]", BLOCK_TABLE, \'block_id\', \'block_title\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(61,19,'block_sizes','Text','20%,30%,*',''); INSERT INTO mx_table_parameter VALUES(62,19,'space_between','Number','4',''); CREATE TABLE mx_table_parameter_option ( option_id SMALLINT NOT NULL IDENTITY(1, 1), parameter_id SMALLINT NOT NULL DEFAULT (0), option_code VARCHAR(150) NULL DEFAULT (NULL), option_desc TEXT NULL, CONSTRAINT mx_table_parameter_option_pk PRIMARY KEY (option_id) ON [PRIMARY], CHECK (option_id>=0), CHECK (parameter_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_parameter_option VALUES(1,14,'0','Sunday'); INSERT INTO mx_table_parameter_option VALUES(2,14,'1','Monday'); INSERT INTO mx_table_parameter_option VALUES(3,21,'left','left '); INSERT INTO mx_table_parameter_option VALUES(4,21,'right','right'); INSERT INTO mx_table_parameter_option VALUES(5,21,'center','center'); INSERT INTO mx_table_parameter_option VALUES(6,20,'_blank','New Window'); INSERT INTO mx_table_parameter_option VALUES(7,20,'_self','Current Window'); CREATE TABLE mx_table_portal ( portal_id SMALLINT NOT NULL IDENTITY(1, 1), portal_name VARCHAR(150) NULL DEFAULT (NULL), portal_phpbb_url VARCHAR(255) NULL DEFAULT ('http://www.phpbb.com/phpBB/'), portal_url VARCHAR(255) NULL DEFAULT (NULL), portal_version VARCHAR(255) NULL DEFAULT (NULL), top_phpbb_links SMALLINT NOT NULL DEFAULT (1), CONSTRAINT mx_table_portal_pk PRIMARY KEY (portal_id) ON [PRIMARY], CHECK (portal_id>=0), CHECK (top_phpbb_links>=0) ) ON [PRIMARY]; |
|
From: Andrew <men...@us...> - 2005-12-20 00:33:56
|
Update of /cvsroot/mxbb/core/install/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8477/install/db Added Files: mssql.php Log Message: Err... recklessly borrowed from phpBB's own db/ folder... adapting it for us (if needed at all) will be done later. --- NEW FILE: mssql.php --- <?php /*************************************************************************** * mssql.php * ------------------- * begin : Saturday, Feb 13, 2001 * copyright : (C) 2001 The phpBB Group * email : supportphpbb.com * * $Id: mssql.php,v 1.1 2005/12/20 00:33:46 mennonitehobbit Exp $ * ***************************************************************************/ /*************************************************************************** * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * ***************************************************************************/ if(!defined("SQL_LAYER")) { define("SQL_LAYER","mssql"); class sql_db { var $db_connect_id; var $result; var $next_id; var $in_transaction = 0; var $row = array(); var $rowset = array(); var $limit_offset; var $query_limit_success; var $num_queries = 0; // // Constructor // function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true) { $this->persistency = $persistency; $this->user = $sqluser; $this->password = $sqlpassword; $this->server = $sqlserver; $this->dbname = $database; $this->db_connect_id = ( $this->persistency ) ? @mssql_pconnect($this->server, $this->user, $this->password) : @mssql_connect($this->server, $this->user, $this->password); if( $this->db_connect_id && $this->dbname != "" ) { if( !mssql_select_db($this->dbname, $this->db_connect_id) ) { mssql_close($this->db_connect_id); return false; } } return $this->db_connect_id; } // // Other base methods // function sql_close() { if($this->db_connect_id) { // // Commit any remaining transactions // if( $this->in_transaction ) { @mssql_query("COMMIT", $this->db_connect_id); } return @mssql_close($this->db_connect_id); } else { return false; } } // // Query method // function sql_query($query = '', $transaction = FALSE) { // // Remove any pre-existing queries // unset($this->result); unset($this->row); if ( $query != '' ) { $this->num_queries++; if ( $transaction == BEGIN_TRANSACTION && !$this->in_transaction ) { if ( !@mssql_query('BEGIN TRANSACTION', $this->db_connect_id) ) { return false; } $this->in_transaction = TRUE; } // // Does query contain any LIMIT code? If so pull out relevant start and num_results // This isn't terribly easy with MSSQL, whatever you do will potentially impact // performance compared to an 'in-built' limit // // Another issue is the 'lack' of a returned true value when a query is valid but has // no result set (as with all the other DB interfaces). It seems though that it's // 'fair' to say that if a query returns a false result (ie. no resource id) then the // SQL was valid but had no result set. If the query returns nothing but the rowcount // returns something then there's a problem. This may well be a false assumption though // ... needs checking under Windows itself. // if( preg_match('#^SELECT(.*?)(LIMIT ([0-9]+)[, ]*([0-9]+)*)?$#s', $query, $limits) ) { $query = $limits[1]; if( !empty($limits[2]) ) { $row_offset = ( $limits[4] ) ? $limits[3] : ""; $num_rows = ( $limits[4] ) ? $limits[4] : $limits[3]; $query = 'TOP ' . ( $row_offset + $num_rows ) . $query; } $this->result = @mssql_query("SELECT $query", $this->db_connect_id); if( $this->result ) { $this->limit_offset[$this->result] = ( !empty($row_offset) ) ? $row_offset : 0; if( $row_offset > 0 ) { @mssql_data_seek($this->result, $row_offset); } } } else if( preg_match('#^INSERT #i', $query) ) { if( @mssql_query($query, $this->db_connect_id) ) { $this->result = time() + microtime(); $result_id = @mssql_query('SELECT @@IDENTITY AS id, @@ROWCOUNT as affected', $this->db_connect_id); if( $result_id ) { if( $row = @mssql_fetch_array($result_id) ) { $this->next_id[$this->db_connect_id] = $row['id']; $this->affected_rows[$this->db_connect_id] = $row['affected']; } } } } else { if( @mssql_query($query, $this->db_connect_id) ) { $this->result = time() + microtime(); $result_id = @mssql_query('SELECT @@ROWCOUNT as affected', $this->db_connect_id); if( $result_id ) { if( $row = @mssql_fetch_array($result_id) ) { $this->affected_rows[$this->db_connect_id] = $row['affected']; } } } } if( !$this->result ) { if( $this->in_transaction ) { @mssql_query('ROLLBACK', $this->db_connect_id); $this->in_transaction = FALSE; } return false; } if( $transaction == END_TRANSACTION && $this->in_transaction ) { $this->in_transaction = FALSE; if( !@mssql_query('COMMIT', $this->db_connect_id) ) { @mssql_query("ROLLBACK", $this->db_connect_id); return false; } } return $this->result; } else { if( $transaction == END_TRANSACTION && $this->in_transaction ) { $this->in_transaction = FALSE; if( !@mssql_query('COMMIT', $this->db_connect_id) ) { @mssql_query('ROLLBACK', $this->db_connect_id); return false; } } return true; } } // // Other query methods // function sql_numrows($query_id = 0) { if( !$query_id ) { $query_id = $this->result; } if( $query_id ) { return ( !empty($this->limit_offset[$query_id]) ) ? @mssql_num_rows($query_id) - $this->limit_offset[$query_id] : @mssql_num_rows($query_id); } else { return false; } } function sql_numfields($query_id = 0) { if( !$query_id ) { $query_id = $this->result; } return ( $query_id ) ? @mssql_num_fields($query_id) : false; } function sql_fieldname($offset, $query_id = 0) { if( !$query_id ) { $query_id = $this->result; } return ( $query_id ) ? @mssql_field_name($query_id, $offset) : false; } function sql_fieldtype($offset, $query_id = 0) { if(!$query_id) { $query_id = $this->result; } return ( $query_id ) ? @mssql_field_type($query_id, $offset) : false; } function sql_fetchrow($query_id = 0) { if( !$query_id ) { $query_id = $this->result; } if( $query_id ) { empty($row); $row = @mssql_fetch_array($query_id); while( list($key, $value) = @each($row) ) { $row[$key] = stripslashes($value); } @reset($row); return $row; } else { return false; } } function sql_fetchrowset($query_id = 0) { if( !$query_id ) { $query_id = $this->result; } if( $query_id ) { $i = 0; empty($rowset); while( $row = @mssql_fetch_array($query_id)) { while( list($key, $value) = @each($row) ) { $rowset[$i][$key] = stripslashes($value); } $i++; } @reset($rowset); return $rowset; } else { return false; } } function sql_fetchfield($field, $row = -1, $query_id) { if( !$query_id ) { $query_id = $this->result; } if( $query_id ) { if( $row != -1 ) { if( $this->limit_offset[$query_id] > 0 ) { $result = ( !empty($this->limit_offset[$query_id]) ) ? @mssql_result($this->result, ($this->limit_offset[$query_id] + $row), $field) : false; } else { $result = @mssql_result($this->result, $row, $field); } } else { if( empty($this->row[$query_id]) ) { $this->row[$query_id] = @mssql_fetch_array($query_id); $result = stripslashes($this->row[$query_id][$field]); } } return $result; } else { return false; } } function sql_rowseek($rownum, $query_id = 0) { if( !$query_id ) { $query_id = $this->result; } if( $query_id ) { return ( !empty($this->limit_offset[$query_id]) ) ? @mssql_data_seek($query_id, ($this->limit_offset[$query_id] + $rownum)) : @mssql_data_seek($query_id, $rownum); } else { return false; } } function sql_nextid() { return ( $this->next_id[$this->db_connect_id] ) ? $this->next_id[$this->db_connect_id] : false; } function sql_affectedrows() { return ( $this->affected_rows[$this->db_connect_id] ) ? $this->affected_rows[$this->db_connect_id] : false; } function sql_freeresult($query_id = 0) { if( !$query_id ) { $query_id = $this->result; } return ( $query_id ) ? @mssql_free_result($query_id) : false; } function sql_error($query_id = 0) { $result['message'] = @mssql_get_last_message(); return $result; } } // class sql_db } // if ... define ?> |
|
From: Andrew <men...@us...> - 2005-12-19 22:27:56
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5593/install/schemas Modified Files: mysql_schema_install.sql Log Message: Doubt we need this line... Index: mysql_schema_install.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v retrieving revision 1.16 retrieving revision 1.17 diff -C2 -d -r1.16 -r1.17 *** mysql_schema_install.sql 19 Dec 2005 03:23:57 -0000 1.16 --- mysql_schema_install.sql 19 Dec 2005 22:27:47 -0000 1.17 *************** *** 109,113 **** INSERT INTO mx_table_block_system_parameter VALUES("8", "63", "Vertical", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("8", "64", "TRUE", "", "0"); - INSERT INTO mx_table_block_system_parameter VALUES("27", "72", "http://127.0.0.1/include_file/startsidan.htm", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("27", "70", "1", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("27", "73", "325", "", "0"); --- 109,112 ---- *************** *** 116,123 **** INSERT INTO mx_table_block_system_parameter VALUES("4", "80", "29", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("10", "16", "<table cellpadding=\"2\" width=\"100%\" border=\"0\"><tr><td class=\"row2\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Mon</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- MÅNDAG -->Busy with <em>this and that</em></span></td></tr><tr><td class=\"row1\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Tue</strong></span></td><td class=\"row1\"><span class=\"gensmall\"><!-- TISDAG-->Not so busy</span></td></tr><tr><td class=\"row2\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Wen</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- ONSDAG-->Very busy</span></td></tr><tr><td class=\"row1\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Thu</strong></span></td><td class=\"row1\"><span class=\"gensmall\"><!-- TORSDAG-->Lazy</span></td></tr><tr><td class=\"row2\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Fri</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- FREDAG-->Resting...</span></td></tr></table><p>This basic table structure is a nice demonstration in which the wysiwyg editor comes in handy!</p><p>Try it out! <br />(to edit use the top right edit button)</p>", "0", "0"); ! INSERT INTO mx_table_block_system_parameter VALUES("1", "15", "This is a [i:d4ee1ca70a]standard [/i:d4ee1ca70a]TextBlock, featuring bbcodes, html and smilies as defined by the phpBB config settings.\r\n\r\nTry it out! \r\n(to edit use the top right edit button)", "d4ee1ca70a", "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "65", "5", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("3", "91", "3 months", "", "0"); ! INSERT INTO mx_table_block_system_parameter VALUES("28", "15", "[b:5093963b57]mxBB Portal [/b:5093963b57]is a fully modular portal and CMS, for phpBB, featuring dynamic pages, blocks, themes and more by means of a powerful yet flexible adminCP and front end block editing possibilites on the fly. While it uses integrated features it works without touching phpBB. mxBB Portal requires phpBB to run, and currently supports the MySQL and PostgreSQL databases. mxBB Portal is the classical phpBB portal addon, improved and enhanced for every phpBB version since 2001.\r\n\r\n[i:5093963b57]Welcome, and thanks for using the mxBB Portal![/i:5093963b57] \r\n\r\n :lol:", "5093963b57", "0"); INSERT INTO mx_table_block_system_parameter VALUES("29", "15", "On this page we [i:a561d23b0e]demonstrate [/i:a561d23b0e]a few basic portal blocks (not already present on this or other pages) - to get you started. Please, try out the top links to different demo blocks.", "a561d23b0e", "0"); INSERT INTO mx_table_block_system_parameter VALUES("30", "15", "You may enrich your portal with addon modules - for specific functionality:\r\n\r\n- Download manager\r\n- Picture Album\r\n- Calendar Tools\r\n- Knowledge Base\r\n- Links Gallery\r\n- Games\r\n\r\nand many more. Be sure to visit www.mx-system.com for latest available modules!", "ecfe9a4569", "0"); --- 115,122 ---- INSERT INTO mx_table_block_system_parameter VALUES("4", "80", "29", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("10", "16", "<table cellpadding=\"2\" width=\"100%\" border=\"0\"><tr><td class=\"row2\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Mon</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- MÅNDAG -->Busy with <em>this and that</em></span></td></tr><tr><td class=\"row1\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Tue</strong></span></td><td class=\"row1\"><span class=\"gensmall\"><!-- TISDAG-->Not so busy</span></td></tr><tr><td class=\"row2\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Wen</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- ONSDAG-->Very busy</span></td></tr><tr><td class=\"row1\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Thu</strong></span></td><td class=\"row1\"><span class=\"gensmall\"><!-- TORSDAG-->Lazy</span></td></tr><tr><td class=\"row2\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Fri</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- FREDAG-->Resting...</span></td></tr></table><p>This basic table structure is a nice demonstration in which the wysiwyg editor comes in handy!</p><p>Try it out! <br />(to edit use the top right edit button)</p>", "0", "0"); ! INSERT INTO mx_table_block_system_parameter VALUES("1", "15", "This is a [i:d4ee1ca70a]standard [/i:d4ee1ca70a]TextBlock, featuring BBCode, HTML, and smilies, as defined by the phpBB config settings.\r\n\r\nTry it out! \r\n(to edit use the top right edit button)", "d4ee1ca70a", "0"); INSERT INTO mx_table_block_system_parameter VALUES("16", "65", "5", "", "0"); INSERT INTO mx_table_block_system_parameter VALUES("3", "91", "3 months", "", "0"); ! INSERT INTO mx_table_block_system_parameter VALUES("28", "15", "[b:5093963b57]mxBB-Portal[/b:5093963b57] is a fully modular portal and CMS for phpBB, featuring dynamic pages, blocks, themes, and more by means of a powerful yet flexible AdminCP. It works without touching phpBB by using integrated features and functions. mxBB-Portal requires phpBB to run, and currently supports the mySQL and postgreSQL databases, with planned support for MS-SQL and other DBMSs. mxBB-Portal is the classical phpBB portal add-on, improved and enhanced for every phpBB version released since 2001.\r\n\r\n[i:5093963b57]Welcome, and thanks for using the mxBB-Portal![/i:5093963b57] \r\n\r\n :lol:", "5093963b57", "0"); INSERT INTO mx_table_block_system_parameter VALUES("29", "15", "On this page we [i:a561d23b0e]demonstrate [/i:a561d23b0e]a few basic portal blocks (not already present on this or other pages) - to get you started. Please, try out the top links to different demo blocks.", "a561d23b0e", "0"); INSERT INTO mx_table_block_system_parameter VALUES("30", "15", "You may enrich your portal with addon modules - for specific functionality:\r\n\r\n- Download manager\r\n- Picture Album\r\n- Calendar Tools\r\n- Knowledge Base\r\n- Links Gallery\r\n- Games\r\n\r\nand many more. Be sure to visit www.mx-system.com for latest available modules!", "ecfe9a4569", "0"); |
|
From: Andrew <men...@us...> - 2005-12-19 03:37:25
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv891/install/schemas Added Files: mssql_schema_install_2.7.1.sql Log Message: Preliminary support for MS-SQL Do we even need this in CVS anymore? --- NEW FILE: mssql_schema_install_2.7.1.sql --- CREATE TABLE mx_table_block ( block_id SMALLINT NOT NULL IDENTITY(1, 1), block_title VARCHAR(150) NULL DEFAULT (NULL), block_desc TEXT NULL, function_id SMALLINT NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), auth_edit SMALLINT NULL DEFAULT (0), auth_delete SMALLINT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), auth_edit_group SMALLINT NOT NULL DEFAULT (0), auth_delete_group SMALLINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_block_pk PRIMARY KEY (block_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (function_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_block VALUES(1,'Welcome','',20,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(2,'Multiple Horizontal Blocks','',19,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(3,'Demo Textblock Multi','',22,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(4,'Demo Textblock BBcode','',20,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(5,'Demo Textblock Html','',21,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(6,'Poll','',12,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(7,'Language Select','',13,99,5,0,0,0,0); INSERT INTO mx_table_block VALUES(8,'Navigation Menu','',11,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(24,'Forum','',10,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(13,'Login',NULL,14,99,5,0,0,0,0); INSERT INTO mx_table_block VALUES(14,'Theme Select','',15,0,5,0,0,0,0); INSERT INTO mx_table_block VALUES(21,'Google','',16,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(18,'Announcements',NULL,17,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(19,'Online','',18,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(16,'Last Message Post',NULL,30,0,0,0,0,0,0); INSERT INTO mx_table_block VALUES(32,'Statistics','',40,0,0,0,0,0,0); CREATE TABLE mx_table_block_parameter ( block_id SMALLINT NOT NULL DEFAULT (0), parameter_id SMALLINT NOT NULL DEFAULT (0), parameter_value TEXT NULL, bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), CONSTRAINT mx_table_block_parameter_pk PRIMARY KEY (block_id, parameter_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (parameter_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_block_parameter VALUES(1,15,'Welcome to the Mx-system Portal!\r\n\r\nPlease visit www.mx-system.com for further information.\r\n\r\nThe Mx-Portal version is announced and documented [url=http://www.mx-system.com/forum/viewforum.php?f=11] here[/url].','10bec5b560'); INSERT INTO mx_table_block_parameter VALUES(2,60,'3,4,5',''); INSERT INTO mx_table_block_parameter VALUES(2,61,'33%,*,33%',''); INSERT INTO mx_table_block_parameter VALUES(2,62,'4',''); INSERT INTO mx_table_block_parameter VALUES(3,50,'This is a demo multi textblock!\r\n\r\n - featuring bbcode, html (if allowed by phpbb config), style parameters (click the EDIT button and try them out) and permissions (view and edit permissions for users and PRIVATE groups).','10bec5b560'); INSERT INTO mx_table_block_parameter VALUES(3,51,'none',''); INSERT INTO mx_table_block_parameter VALUES(3,52,'TRUE',''); INSERT INTO mx_table_block_parameter VALUES(3,53,'TRUE',''); INSERT INTO mx_table_block_parameter VALUES(3,54,'TRUE',''); INSERT INTO mx_table_block_parameter VALUES(4,15,'This is a demo bbcode textblock!\r\n\r\n- featuring bbcode, html (if allowed by phpbb config) and permissions (view and edit permissions for users and PRIVATE groups).','10bec5b560'); INSERT INTO mx_table_block_parameter VALUES(5,16,'This is a demo html textblock!\r\n\r\n- featuring html (if allowed by phpbb config) and permissions (view and edit permissions for users and PRIVATE groups).','10bec5b560'); INSERT INTO mx_table_block_parameter VALUES(6,36,'',NULL); INSERT INTO mx_table_block_parameter VALUES(6,13,'0',NULL); INSERT INTO mx_table_block_parameter VALUES(16,17,'5',NULL); INSERT INTO mx_table_block_parameter VALUES(16,18,'TRUE',NULL); INSERT INTO mx_table_block_parameter VALUES(16,19,'30',NULL); INSERT INTO mx_table_block_parameter VALUES(16,20,'_self',NULL); INSERT INTO mx_table_block_parameter VALUES(16,21,'left',NULL); INSERT INTO mx_table_block_parameter VALUES(16,22,'TRUE',NULL); INSERT INTO mx_table_block_parameter VALUES(16,37,'',NULL); INSERT INTO mx_table_block_parameter VALUES(16,38,'FALSE',NULL); INSERT INTO mx_table_block_parameter VALUES(16,39,'FALSE',NULL); INSERT INTO mx_table_block_parameter VALUES(16,40,'TRUE',NULL); INSERT INTO mx_table_block_parameter VALUES(18,1,'1',NULL); INSERT INTO mx_table_block_parameter VALUES(18,2,'999',NULL); INSERT INTO mx_table_block_parameter VALUES(18,3,'TRUE',NULL); INSERT INTO mx_table_block_parameter VALUES(18,4,'FALSE',NULL); INSERT INTO mx_table_block_parameter VALUES(18,5,'FALSE',NULL); INSERT INTO mx_table_block_parameter VALUES(18,7,'thumb_news.gif',NULL); INSERT INTO mx_table_block_parameter VALUES(18,8,'thumb_globe.gif',NULL); INSERT INTO mx_table_block_parameter VALUES(18,9,'thumb_globe.gif',NULL); INSERT INTO mx_table_block_parameter VALUES(18,6,'TRUE',NULL); INSERT INTO mx_table_block_parameter VALUES(18,10,'thumb_globe.gif ',NULL); INSERT INTO mx_table_block_parameter VALUES(18,11,'',NULL); CREATE TABLE mx_table_column ( column_id SMALLINT NOT NULL IDENTITY(1, 1), column_title VARCHAR(100) NULL DEFAULT (NULL), column_order SMALLINT NOT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), column_size VARCHAR(5) NULL DEFAULT ('100%'), page_id SMALLINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_column_pk PRIMARY KEY (column_id) ON [PRIMARY], CHECK (column_id>=0), CHECK (column_order>=0) ) ON [PRIMARY]; CREATE INDEX mx_table_column_cat_order ON mx_table_column (column_order) ON [PRIMARY]; INSERT INTO mx_table_column VALUES(1,'Column 1',10,NULL,'220',1); INSERT INTO mx_table_column VALUES(2,'Column 2',20,NULL,'100%',1); INSERT INTO mx_table_column VALUES(20,'Menu',10,NULL,'200',2); INSERT INTO mx_table_column VALUES(21,'Forum',20,NULL,'100%',2); CREATE TABLE mx_table_column_block ( column_id SMALLINT NOT NULL DEFAULT (0), block_id SMALLINT NOT NULL DEFAULT (0), block_order SMALLINT NOT NULL DEFAULT (0) ) ON [PRIMARY]; INSERT INTO mx_table_column_block VALUES(1,8,10); INSERT INTO mx_table_column_block VALUES(1,16,20); INSERT INTO mx_table_column_block VALUES(1,6,30); INSERT INTO mx_table_column_block VALUES(1,13,40); INSERT INTO mx_table_column_block VALUES(1,7,50); INSERT INTO mx_table_column_block VALUES(1,14,60); INSERT INTO mx_table_column_block VALUES(2,1,10); INSERT INTO mx_table_column_block VALUES(2,2,10); INSERT INTO mx_table_column_block VALUES(2,18,20); INSERT INTO mx_table_column_block VALUES(2,19,30); INSERT INTO mx_table_column_block VALUES(20,8,10); INSERT INTO mx_table_column_block VALUES(20,16,20); INSERT INTO mx_table_column_block VALUES(21,24,30); INSERT INTO mx_table_column_block VALUES(21,19,40); CREATE TABLE mx_table_function ( function_id SMALLINT NOT NULL IDENTITY(1, 1), module_id SMALLINT NOT NULL DEFAULT (0), function_name VARCHAR(150) NULL DEFAULT (NULL), function_desc TEXT NULL, function_file VARCHAR(255) NULL DEFAULT (NULL), function_admin VARCHAR(255) NULL DEFAULT (NULL), CONSTRAINT mx_table_function_pk PRIMARY KEY (function_id) ON [PRIMARY], CHECK (function_id>=0), CHECK (module_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_table_function_module_id ON mx_table_function (module_id) ON [PRIMARY]; INSERT INTO mx_table_function VALUES(10,10,'Forum phpBB','Forum phpBB','mx_forum.php',NULL); INSERT INTO mx_table_function VALUES(11,10,'Navigation Menu','Menu Navigation','mx_menu_nav.php','admin/admin_mx_menu.php'); INSERT INTO mx_table_function VALUES(12,10,'Polls','Polls','mx_poll.php',NULL); INSERT INTO mx_table_function VALUES(13,10,'Language Select','Language Select','mx_language.php',NULL); INSERT INTO mx_table_function VALUES(14,10,'Login','Login','mx_login.php',NULL); INSERT INTO mx_table_function VALUES(15,10,'Theme Select','Theme Select','mx_theme.php',NULL); INSERT INTO mx_table_function VALUES(16,10,'Google','Google','mx_google.php',NULL); INSERT INTO mx_table_function VALUES(17,10,'Announcements','Announcements','mx_announce.php',NULL); INSERT INTO mx_table_function VALUES(18,10,'Who is Online','Who is Online','mx_online.php',NULL); INSERT INTO mx_table_function VALUES(19,10,'Multiple Horizontal Blocks','Block that can arrange other blocks in a horizontal line.','mx_multiple_blocks.php',''); INSERT INTO mx_table_function VALUES(20,20,'TextBlock_BBcode','TextBlock_BBcode','mx_textblock_bbcode.php','modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES(21,20,'TextBlock_Html','TextBlock_Html','mx_textblock_html.php','modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES(22,20,'TextBlock_Multi','Textblock for bbcode and html with parameters','mx_textblock_multi.php','modules/mx_textblocks/admin/admin_edit.php'); INSERT INTO mx_table_function VALUES(30,30,'Post Last Message','Post Last Message','mx_last_msg.php',NULL); INSERT INTO mx_table_function VALUES(40,40,'Statistics MX','Statistics MX','mx_statistics.php',NULL); CREATE TABLE mx_table_menu_categories ( block_id SMALLINT NOT NULL DEFAULT (1), cat_id INTEGER NOT NULL IDENTITY(1, 1), cat_title VARCHAR(100) NULL DEFAULT (NULL), cat_order INTEGER NOT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), cat_desc TEXT NULL, cat_show TINYINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_menu_categories_pk PRIMARY KEY (cat_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (cat_id>=0), CHECK (cat_order>=0), CHECK (cat_show>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_tablemenucategoriescatorder ON mx_table_menu_categories (cat_order) ON [PRIMARY]; INSERT INTO mx_table_menu_categories VALUES(8,1,'Main Menu',20,NULL,NULL,1); CREATE TABLE mx_table_menu_nav ( menu_id SMALLINT NOT NULL IDENTITY(1, 1), cat_id INTEGER NOT NULL DEFAULT (0), menu_name VARCHAR(150) NULL DEFAULT (NULL), menu_desc TEXT NULL, menu_links VARCHAR(255) NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), menu_order SMALLINT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), menu_icon VARCHAR(255) NULL DEFAULT (NULL), function_id SMALLINT NULL DEFAULT (0), block_id SMALLINT NOT NULL DEFAULT (0), page_id SMALLINT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), link_target TINYINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_menu_nav_pk PRIMARY KEY (menu_id) ON [PRIMARY], CHECK (menu_id>=0), CHECK (cat_id>=0), CHECK (menu_order>=0), CHECK (function_id>=0), CHECK (page_id>=0), CHECK (link_target>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_table_menu_nav_cat_id ON mx_table_menu_nav (cat_id) ON [PRIMARY]; INSERT INTO mx_table_menu_nav VALUES(1,1,'Home','Home Page','index.php',0,10,'bc5d5e65eb','icon_home.gif',0,0,0,0,0); INSERT INTO mx_table_menu_nav VALUES(2,1,'Forum','phpBB Forum','index.php',0,20,'1a7e19f246','icon_forum.gif',0,0,2,0,0); INSERT INTO mx_table_menu_nav VALUES(3,1,'Statistics','Statistics Module','',0,30,'e16b0fbb51','icon_stat.gif',40,0,0,0,0); CREATE TABLE mx_table_module ( module_id SMALLINT NOT NULL IDENTITY(1, 1), module_name VARCHAR(150) NULL DEFAULT (NULL), module_path VARCHAR(255) NULL DEFAULT (NULL), module_desc TEXT NULL, module_include_admin CHAR(1) NULL DEFAULT ('0'), CONSTRAINT mx_table_module_pk PRIMARY KEY (module_id) ON [PRIMARY], CHECK (module_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_module VALUES(10,'Core Blocks','./','Core blocks',''); INSERT INTO mx_table_module VALUES(20,'Text Blocks','modules/mx_textblocks/','Textblocks module',''); INSERT INTO mx_table_module VALUES(30,'Post Last Message','modules/mx_last_msg/','Last Message Module','0'); INSERT INTO mx_table_module VALUES(40,'Statistics MX','modules/mx_statistics/','Statistics Modules','0'); CREATE TABLE mx_table_page ( page_id SMALLINT NOT NULL IDENTITY(1, 1), page_name VARCHAR(255) NULL DEFAULT (NULL), page_icon VARCHAR(255) NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), page_header VARCHAR(255) NULL DEFAULT ('overall_header.tpl'), CONSTRAINT mx_table_page_pk PRIMARY KEY (page_id) ON [PRIMARY] ) ON [PRIMARY]; INSERT INTO mx_table_page VALUES(1,'Home','icon_home.gif',0,0,'overall_header.tpl'); INSERT INTO mx_table_page VALUES(2,'Forum','icon_forum.gif',0,0,'overall_header.tpl'); CREATE TABLE mx_table_parameter ( parameter_id SMALLINT NOT NULL IDENTITY(1, 1), function_id SMALLINT NOT NULL DEFAULT (0), parameter_name VARCHAR(150) NULL DEFAULT (NULL), parameter_type VARCHAR(30) NULL DEFAULT (NULL), parameter_default VARCHAR(150) NULL DEFAULT (NULL), parameter_function VARCHAR(255) NULL DEFAULT (NULL), CONSTRAINT mx_table_parameter_pk PRIMARY KEY (parameter_id) ON [PRIMARY], CHECK (parameter_id>=0), CHECK (function_id>=0) ) ON [PRIMARY]; INSERT INTO mx_table_parameter VALUES(1,17,'announce_nbr_display','Number','1',NULL); INSERT INTO mx_table_parameter VALUES(2,17,'announce_nbr_days','Number','14',NULL); INSERT INTO mx_table_parameter VALUES(3,17,'announce_display','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(4,17,'announce_display_sticky','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(5,17,'announce_display_normal','Boolean','FALSE',NULL); INSERT INTO mx_table_parameter VALUES(7,17,'announce_img','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(8,17,'announce_img_sticky','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(9,17,'announce_img_normal','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(6,17,'announce_display_global','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(10,17,'announce_img_global','Text','thumb_globe.gif',NULL); INSERT INTO mx_table_parameter VALUES(11,17,'announce_forum','Function',NULL,'get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(13,12,'Poll_Display','Function','0','poll_select( {parameter_value}, "{parameter_id}" )'); INSERT INTO mx_table_parameter VALUES(36,12,'poll_forum','Function','','get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(15,20,'Text','BBText','Insert your text here',NULL); INSERT INTO mx_table_parameter VALUES(16,21,'Html','Html','Entre your Html code here',NULL); INSERT INTO mx_table_parameter VALUES(17,30,'Last_Msg_Number_Title','Number','15',NULL); INSERT INTO mx_table_parameter VALUES(18,30,'Last_Msg_Display_Date','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(19,30,'Last_Msg_Title_Length','Number','30',NULL); INSERT INTO mx_table_parameter VALUES(20,30,'Last_Msg_Target','Values','_blank',NULL); INSERT INTO mx_table_parameter VALUES(21,30,'Last_Msg_Align','Values','left',NULL); INSERT INTO mx_table_parameter VALUES(22,30,'Last_Msg_Display_Forum','Boolean','TRUE',NULL); INSERT INTO mx_table_parameter VALUES(37,30,'Last_Msg_forum','Function','','get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(38,30,'Last_Msg_Display_Last_Author','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(39,30,'Last_Msg_Display_Author','Boolean','FALSE',''); INSERT INTO mx_table_parameter VALUES(40,30,'Last_Msg_Display_Icon_View','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(50,22,'Text','BBText','Enter your block text here',''); INSERT INTO mx_table_parameter VALUES(51,22,'text_style','Values','none',''); INSERT INTO mx_table_parameter VALUES(52,22,'block_style','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(53,22,'title_style','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(54,22,'show_title','Boolean','TRUE',''); INSERT INTO mx_table_parameter VALUES(60,19,'block_ids','Function','1,2,3','get_list_multiple( "{parameter_id}[]", BLOCK_TABLE, \'block_id\', \'block_title\', "{parameter_value}", TRUE)'); INSERT INTO mx_table_parameter VALUES(61,19,'block_sizes','Text','20%,30%,*',''); INSERT INTO mx_table_parameter VALUES(62,19,'space_between','Number','4',''); CREATE TABLE mx_table_parameter_option ( option_id SMALLINT NOT NULL IDENTITY(1, 1), parameter_id SMALLINT NOT NULL DEFAULT (0), option_code VARCHAR(150) NULL DEFAULT (NULL), option_desc TEXT NULL, CONSTRAINT mx_table_parameter_option_pk PRIMARY KEY (option_id) ON [PRIMARY], CHECK (option_id>=0), CHECK (parameter_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_parameter_option VALUES(1,14,'0','Sunday'); INSERT INTO mx_table_parameter_option VALUES(2,14,'1','Monday'); INSERT INTO mx_table_parameter_option VALUES(3,21,'left','left '); INSERT INTO mx_table_parameter_option VALUES(4,21,'right','right'); INSERT INTO mx_table_parameter_option VALUES(5,21,'center','center'); INSERT INTO mx_table_parameter_option VALUES(6,20,'_blank','New Window'); INSERT INTO mx_table_parameter_option VALUES(7,20,'_self','Current Window'); CREATE TABLE mx_table_portal ( portal_id SMALLINT NOT NULL IDENTITY(1, 1), portal_name VARCHAR(150) NULL DEFAULT (NULL), portal_phpbb_url VARCHAR(255) NULL DEFAULT ('http://www.phpbb.com/phpBB/'), portal_url VARCHAR(255) NULL DEFAULT (NULL), portal_version VARCHAR(255) NULL DEFAULT (NULL), top_phpbb_links SMALLINT NOT NULL DEFAULT (1), CONSTRAINT mx_table_portal_pk PRIMARY KEY (portal_id) ON [PRIMARY], CHECK (portal_id>=0), CHECK (top_phpbb_links>=0) ) ON [PRIMARY]; |
|
From: Andrew <men...@us...> - 2005-12-19 03:31:37
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32054/install/schemas Added Files: mssql_schema_install.sql Log Message: Preliminary MS-SQL schema Note 'mx_table_block_system_parameter' was renamed... it was probably too long. --- NEW FILE: mssql_schema_install.sql --- CREATE TABLE mx_table_block ( block_id SMALLINT NOT NULL IDENTITY(1, 1), block_title VARCHAR(150) NULL DEFAULT (NULL), block_desc TEXT NULL, function_id SMALLINT NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), auth_edit SMALLINT NOT NULL DEFAULT (0), auth_delete SMALLINT NOT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), auth_edit_group SMALLINT NOT NULL DEFAULT (0), auth_delete_group SMALLINT NOT NULL DEFAULT (0), auth_moderator_group SMALLINT NOT NULL DEFAULT (0), show_title TINYINT NOT NULL DEFAULT (1), show_block TINYINT NOT NULL DEFAULT (1), show_stats TINYINT NOT NULL DEFAULT (0), block_time VARBINARY(255) NOT NULL DEFAULT (''), block_editor_id INTEGER NOT NULL DEFAULT (0), CONSTRAINT mx_table_block_pk PRIMARY KEY (block_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (function_id>=0), CHECK (show_title>=0), CHECK (show_block>=0), CHECK (show_stats>=0), CHECK (block_editor_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_block VALUES("1","phpBB TextBlock","This is a Demo Block","24","0","5","0","0","0","0","0","1","1","1","1125865999","2"); INSERT INTO mx_table_block VALUES("2","Split Block","This is a Demo Block","11","0","5","0","0","0","0","0","1","1","0","1125841933","2"); INSERT INTO mx_table_block VALUES("6","Poll","This is a Demo Block","14","0","5","0","0","0","0","0","1","1","0","1125841942","2"); INSERT INTO mx_table_block VALUES("7","Language Select","This is a Demo Block","6","0","5","0","0","0","0","0","1","1","0","1125841887","2"); INSERT INTO mx_table_block VALUES("8","Navigation Menu","This is a vertical Navigation Menu Demo Block","51","0","5","0","0","0","0","0","1","1","0","1126034018","2"); INSERT INTO mx_table_block VALUES("24","Forum","This is a Demo Block","8","0","5","0","0","0","0","0","1","1","0","1125841817","2"); INSERT INTO mx_table_block VALUES("13","Login","This is a Demo Block","7","9","5","0","0","0","0","0","1","1","0","1125867452","2"); INSERT INTO mx_table_block VALUES("14","Theme Select","This is a Demo Block","12","0","5","0","0","0","0","0","1","1","0","1125841964","2"); INSERT INTO mx_table_block VALUES("21","Google","This is a Demo Block","4","0","5","0","0","0","0","0","1","1","0","1126033253","2"); INSERT INTO mx_table_block VALUES("18","Announcements","This is a Demo Block","2","0","5","0","0","0","0","0","1","1","0","1125868467","2"); INSERT INTO mx_table_block VALUES("19","Who is Online?","This is a Demo Block","13","0","5","0","0","0","0","0","1","1","0","1125841983","2"); INSERT INTO mx_table_block VALUES("16","Last Message Post","This is a Demo Block","31","0","5","0","0","0","0","0","1","1","0","1125842159","2"); INSERT INTO mx_table_block VALUES("26","Statistics","This is a Demo Block","41","0","5","0","0","0","0","0","1","1","0","1125842177","2"); INSERT INTO mx_table_block VALUES("27","IncludeX","This is a Demo Block","5","0","5","0","0","0","0","0","1","1","0","1125841878","2"); INSERT INTO mx_table_block VALUES("25","Navigation Menu","This is a horizontal Navigation Menu Demo Block","51","0","5","0","0","0","0","0","1","1","0","1125842132","2"); INSERT INTO mx_table_block VALUES("4","Dynamic Block","This is a Demo Block","3","0","5","0","0","0","0","0","1","1","0","1125841802","2"); INSERT INTO mx_table_block VALUES("5","Blog TextBlock","This is a Demo Block","21","0","5","0","0","0","0","0","1","1","1","1125842544","2"); INSERT INTO mx_table_block VALUES("10","WYSIWYG TextBlock","This is a Demo Block","23","0","5","0","0","0","0","0","1","1","1","1125842503","2"); INSERT INTO mx_table_block VALUES("28","Welcome","This is the firstpage welcome block","24","0","5","0","0","0","0","0","1","1","1","1125852430","2"); INSERT INTO mx_table_block VALUES("29","Demo Pages","Introduction","24","0","5","0","0","0","0","0","1","1","1","1125859625","2"); INSERT INTO mx_table_block VALUES("30","Modules Info","Introduction","24","0","5","0","0","0","0","0","1","1","1","1125859742","2"); INSERT INTO mx_table_block VALUES("3","Site Log","This is a Demo Block","10","0","5","0","0","0","0","0","1","1","0","1125841954","2"); INSERT INTO mx_table_block VALUES("15","Site Search","Site Search","15","0","5","0","0","0","0","0","1","1","0","1125841954","2"); INSERT INTO mx_table_block VALUES("9","mxBB TextBlock","This is a Demo Block","22","0","5","0","0","0","0","0","1","1","1","1125865570","2"); CREATE TABLE mx_table_block_parameter ( block_id SMALLINT NOT NULL DEFAULT (0), parameter_id SMALLINT NOT NULL DEFAULT (0), parameter_value TEXT NULL, parameter_opt TEXT NULL, sub_id INTEGER NOT NULL DEFAULT (0), CONSTRAINT mx_table_block_parameter_pk PRIMARY KEY (block_id, parameter_id, sub_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (parameter_id>=0), CHECK (sub_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_block_system_parameter VALUES("8","66","","","0"); INSERT INTO mx_table_block_system_parameter VALUES("25","66","","","0"); INSERT INTO mx_table_block_system_parameter VALUES("2","60","21,7,14","","0"); INSERT INTO mx_table_block_system_parameter VALUES("2","61","33%, 33%,*","","0"); INSERT INTO mx_table_block_system_parameter VALUES("2","62","4","","0"); INSERT INTO mx_table_block_system_parameter VALUES("6","36","",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("6","13","0",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("16","17","5",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("16","18","TRUE",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("16","19","30",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("16","20","_self",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("16","21","left",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("16","22","TRUE",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("16","37","",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("16","38","FALSE",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("16","39","FALSE",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("16","40","TRUE",NULL,"0"); INSERT INTO mx_table_block_system_parameter VALUES("18","1","3","","0"); INSERT INTO mx_table_block_system_parameter VALUES("18","2","10","","0"); INSERT INTO mx_table_block_system_parameter VALUES("18","3","TRUE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("18","4","TRUE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("18","5","FALSE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("18","7","thumb_news.gif","","0"); INSERT INTO mx_table_block_system_parameter VALUES("18","8","thumb_globe.gif","","0"); INSERT INTO mx_table_block_system_parameter VALUES("18","9","thumb_globe.gif","","0"); INSERT INTO mx_table_block_system_parameter VALUES("18","6","TRUE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("18","10","thumb_globe.gif","","0"); INSERT INTO mx_table_block_system_parameter VALUES("18","11","","","0"); INSERT INTO mx_table_block_system_parameter VALUES("8","63","Vertical","","0"); INSERT INTO mx_table_block_system_parameter VALUES("8","64","TRUE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("27","72","http://127.0.0.1/include_file/startsidan.htm","","0"); INSERT INTO mx_table_block_system_parameter VALUES("27","70","1","","0"); INSERT INTO mx_table_block_system_parameter VALUES("27","73","325","","0"); INSERT INTO mx_table_block_system_parameter VALUES("25","63","Horizontal","","0"); INSERT INTO mx_table_block_system_parameter VALUES("25","64","TRUE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("4","80","29","","0"); INSERT INTO mx_table_block_system_parameter VALUES("10","16","<table cellpadding=\"2\" width=\"100%\" border=\"0\"><tr><td class=\"row2\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Mon</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- MÅNDAG -->Busy with <em>this and that</em></span></td></tr><tr><td class=\"row1\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Tue</strong></span></td><td class=\"row1\"><span class=\"gensmall\"><!-- TISDAG-->Not so busy</span></td></tr><tr><td class=\"row2\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Wen</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- ONSDAG-->Very busy</span></td></tr><tr><td class=\"row1\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Thu</strong></span></td><td class=\"row1\"><span class=\"gensmall\"><!-- TORSDAG-->Lazy</span></td></tr><tr><td class=\"row2\" valign=\"top\" align=\"left\"><span class=\"genmed\"><strong>Fri</strong></span></td><td class=\"row2\"><span class=\"gensmall\"><!-- FREDAG-->Resting...</span></td></tr></table><p>This basic table structure is a nice demonstration in which the wysiwyg editor comes in handy!</p><p>Try it out! <br />(to edit use the top right edit button)</p>","0","0"); INSERT INTO mx_table_block_system_parameter VALUES("1","15","This is a [i:d4ee1ca70a]standard [/i:d4ee1ca70a]TextBlock, featuring bbcodes, html and smilies as defined by the phpBB config settings.\r\n\r\nTry it out! \r\n(to edit use the top right edit button)","d4ee1ca70a","0"); INSERT INTO mx_table_block_system_parameter VALUES("16","65","5","","0"); INSERT INTO mx_table_block_system_parameter VALUES("3","91","3 months","","0"); INSERT INTO mx_table_block_system_parameter VALUES("28","15","[b:5093963b57]mxBB Portal [/b:5093963b57]is a fully modular portal and CMS, for phpBB, featuring dynamic pages, blocks, themes and more by means of a powerful yet flexible adminCP and front end block editing possibilites on the fly. While it uses integrated features it works without touching phpBB. mxBB Portal requires phpBB to run, and currently supports the MySQL and PostgreSQL databases. mxBB Portal is the classical phpBB portal addon, improved and enhanced for every phpBB version since 2001.\r\n\r\n[i:5093963b57]Welcome, and thanks for using the mxBB Portal![/i:5093963b57] \r\n\r\n :lol:","5093963b57","0"); INSERT INTO mx_table_block_system_parameter VALUES("29","15","On this page we [i:a561d23b0e]demonstrate [/i:a561d23b0e]a few basic portal blocks (not already present on this or other pages) - to get you started. Please, try out the top links to different demo blocks.","a561d23b0e","0"); INSERT INTO mx_table_block_system_parameter VALUES("30","15","You may enrich your portal with addon modules - for specific functionality:\r\n\r\n- Download manager\r\n- Picture Album\r\n- Calendar Tools\r\n- Knowledge Base\r\n- Links Gallery\r\n- Games\r\n\r\nand many more. Be sure to visit www.mx-system.com for latest available modules!","ecfe9a4569","0"); INSERT INTO mx_table_block_system_parameter VALUES("3","92","5","","0"); INSERT INTO mx_table_block_system_parameter VALUES("9","50","This is basically a [i:3883289f58]standard[/i:3883289f58] TextBlock, but you may configure settings for bbcodes, html and smilies for [i:3883289f58]this[/i:3883289f58] block.\r\n\r\nTry it out! \r\n(to edit use the top right edit button)","3883289f58","0"); INSERT INTO mx_table_block_system_parameter VALUES("9","51","none","","0"); INSERT INTO mx_table_block_system_parameter VALUES("9","52","TRUE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("9","53","TRUE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("9","56","TRUE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("9","54","TRUE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("9","57","TRUE","","0"); INSERT INTO mx_table_block_system_parameter VALUES("9","55","b,i,u,img","","0"); CREATE TABLE mx_table_column ( column_id SMALLINT NOT NULL IDENTITY(1, 1), column_title VARCHAR(100) NULL DEFAULT (NULL), column_order SMALLINT NOT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), column_size VARCHAR(5) NULL DEFAULT ('100%'), page_id SMALLINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_column_pk PRIMARY KEY (column_id) ON [PRIMARY], CHECK (column_id>=0), CHECK (column_order>=0) ) ON [PRIMARY]; CREATE INDEX mx_table_column_cat_order ON mx_table_column (column_order) ON [PRIMARY]; INSERT INTO mx_table_column VALUES("8","Main","50",NULL,"100%","4"); INSERT INTO mx_table_column VALUES("2","Main","35",NULL,"100%","1"); INSERT INTO mx_table_column VALUES("7","Left","40",NULL,"200","4"); INSERT INTO mx_table_column VALUES("6","Main","50",NULL,"100%","3"); INSERT INTO mx_table_column VALUES("5","Left","40",NULL,"200","3"); INSERT INTO mx_table_column VALUES("4","Main","50",NULL,"100%","2"); INSERT INTO mx_table_column VALUES("1","Left","25",NULL,"200","1"); INSERT INTO mx_table_column VALUES("3","Left","40",NULL,"200","2"); INSERT INTO mx_table_column VALUES("10","Main","50",NULL,"100%","5"); INSERT INTO mx_table_column VALUES("9","Left","40",NULL,"200","5"); CREATE TABLE mx_table_column_block ( column_id SMALLINT NOT NULL DEFAULT (0), block_id SMALLINT NOT NULL DEFAULT (0), block_order SMALLINT NOT NULL DEFAULT (0) ) ON [PRIMARY]; INSERT INTO mx_table_column_block VALUES("5","14","40"); INSERT INTO mx_table_column_block VALUES("4","19","20"); INSERT INTO mx_table_column_block VALUES("8","19","20"); INSERT INTO mx_table_column_block VALUES("4","24","10"); INSERT INTO mx_table_column_block VALUES("1","13","20"); INSERT INTO mx_table_column_block VALUES("3","16","20"); INSERT INTO mx_table_column_block VALUES("5","3","30"); INSERT INTO mx_table_column_block VALUES("2","19","20"); INSERT INTO mx_table_column_block VALUES("2","28","10"); INSERT INTO mx_table_column_block VALUES("1","8","10"); INSERT INTO mx_table_column_block VALUES("6","25","10"); INSERT INTO mx_table_column_block VALUES("8","26","10"); INSERT INTO mx_table_column_block VALUES("7","8","10"); INSERT INTO mx_table_column_block VALUES("6","4","20"); INSERT INTO mx_table_column_block VALUES("5","8","10"); INSERT INTO mx_table_column_block VALUES("6","19","30"); INSERT INTO mx_table_column_block VALUES("5","7","20"); INSERT INTO mx_table_column_block VALUES("3","13","30"); INSERT INTO mx_table_column_block VALUES("3","8","10"); INSERT INTO mx_table_column_block VALUES("10","15","10"); INSERT INTO mx_table_column_block VALUES("9","8","10"); CREATE TABLE mx_table_column_templates ( column_template_id SMALLINT NOT NULL IDENTITY(1, 1), column_title VARCHAR(100) NULL DEFAULT ('0'), column_order SMALLINT NOT NULL DEFAULT (0), column_size VARCHAR(5) NULL DEFAULT ('0'), page_template_id SMALLINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_column_templates_pk PRIMARY KEY (column_template_id) ON [PRIMARY], CHECK (column_template_id>=0), CHECK (column_order>=0) ) ON [PRIMARY]; CREATE INDEX mx_tablecolumntemplatescatorde ON mx_table_column_templates (column_order) ON [PRIMARY]; INSERT INTO mx_table_column_templates VALUES("1","Left","40","200","2"); INSERT INTO mx_table_column_templates VALUES("2","Main","50","100%","2"); INSERT INTO mx_table_column_templates VALUES("3","Main","10","100%","3"); INSERT INTO mx_table_column_templates VALUES("4","Right","20","200","3"); INSERT INTO mx_table_column_templates VALUES("5","Left","10","180","4"); INSERT INTO mx_table_column_templates VALUES("6","Middle","20","100%","4"); INSERT INTO mx_table_column_templates VALUES("7","Right","30","180","4"); CREATE TABLE mx_table_function ( function_id SMALLINT NOT NULL IDENTITY(1, 1), module_id SMALLINT NOT NULL DEFAULT (0), function_name VARCHAR(150) NULL DEFAULT (NULL), function_desc TEXT NULL, function_file VARCHAR(255) NULL DEFAULT (NULL), function_admin VARCHAR(255) NULL DEFAULT (NULL), CONSTRAINT mx_table_function_pk PRIMARY KEY (function_id) ON [PRIMARY], CHECK (function_id>=0), CHECK (module_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_table_function_module_id ON mx_table_function (module_id) ON [PRIMARY]; INSERT INTO mx_table_function VALUES("8","10","phpBB forum","phpBB Function for the phpBB Index Block","mx_forum.php",""); INSERT INTO mx_table_function VALUES("51","50","Navigation Menu","This is the function for Navigation Menu Blocks","mx_menu_nav.php",""); INSERT INTO mx_table_function VALUES("14","10","Polls","This is the function for Polls","mx_poll.php",""); INSERT INTO mx_table_function VALUES("6","10","Language Select","Language Select Function","mx_language.php",""); INSERT INTO mx_table_function VALUES("7","10","Login","Login Function","mx_login.php",""); INSERT INTO mx_table_function VALUES("12","10","Theme Select","Theme Select Function","mx_theme.php",""); INSERT INTO mx_table_function VALUES("4","10","Google","Google Block Function","mx_google.php",""); INSERT INTO mx_table_function VALUES("2","10","Announcements","Announcements Function","mx_announce.php",""); INSERT INTO mx_table_function VALUES("13","10","Who is Online","Who is Online Function","mx_online.php",""); INSERT INTO mx_table_function VALUES("11","10","Split Block","Split Block Function - a block that puts subblocks side by side","mx_multiple_blocks.php",""); INSERT INTO mx_table_function VALUES("24","20","TextBlock (phpBB)","BBcodes, html and smilies - defined by phpBB config","mx_textblock_bbcode.php",""); INSERT INTO mx_table_function VALUES("23","20","TextBlock (Html/wysiwyg)","Plain html textblock, or featuring a wysiwyg editor","mx_textblock_html.php",""); INSERT INTO mx_table_function VALUES("22","20","TextBlock (Customized)","Textblock, featuring block defined settings","mx_textblock_multi.php",""); INSERT INTO mx_table_function VALUES("31","30","Post Last Message","Post Last Message Function","mx_last_msg.php",""); INSERT INTO mx_table_function VALUES("41","40","Statistics MX","Statistics Function","mx_statistics.php",NULL); INSERT INTO mx_table_function VALUES("5","10","IncludeX","Include a iframe, site, multimedia or file","mx_includex.php",""); INSERT INTO mx_table_function VALUES("3","10","DynamicBlock","Dynamic block defined by its block_id","mx_dynamic.php",""); INSERT INTO mx_table_function VALUES("21","20","TextBlock (Blog)","UserBlog Textblock","mx_textblock_blog.php",""); INSERT INTO mx_table_function VALUES("10","10","Site Log","Site Log monitor Function","mx_site_log.php",""); INSERT INTO mx_table_function VALUES("15","10","Site Search","Site Search Block","mx_search.php",""); CREATE TABLE mx_table_menu_categories ( block_id SMALLINT NOT NULL DEFAULT (1), cat_id INTEGER NOT NULL IDENTITY(1, 1), cat_title VARCHAR(100) NULL DEFAULT (NULL), cat_order INTEGER NOT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), cat_desc TEXT NULL, cat_show TINYINT NOT NULL DEFAULT (0), cat_url SMALLINT NULL DEFAULT (0), cat_target TINYINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_menu_categories_pk PRIMARY KEY (cat_id) ON [PRIMARY], CHECK (block_id>=0), CHECK (cat_id>=0), CHECK (cat_order>=0), CHECK (cat_show>=0), CHECK (cat_url>=0), CHECK (cat_target>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_tablemenucategoriescatorder ON mx_table_menu_categories (cat_order) ON [PRIMARY]; INSERT INTO mx_table_menu_categories VALUES("8","1","Resources","20","c1affc0aaa","","0","0","0"); INSERT INTO mx_table_menu_categories VALUES("8","3","Home","10","eab7a16ce5","","1","1","0"); INSERT INTO mx_table_menu_categories VALUES("25","4","Core Blocks","40","a5abf5b8c4","Demo Core blocks","1","0","0"); INSERT INTO mx_table_menu_categories VALUES("25","5","TextBlocks","50","fa33545edc","Demo TextBlocks","0","0","0"); INSERT INTO mx_table_menu_categories VALUES("25","6","Modules","60","7dafcede48","Modules Info","0","0","0"); CREATE TABLE mx_table_menu_nav ( menu_id SMALLINT NOT NULL IDENTITY(1, 1), cat_id INTEGER NOT NULL DEFAULT (0), menu_name VARCHAR(150) NULL DEFAULT (NULL), menu_desc TEXT NULL, menu_links VARCHAR(255) NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), menu_order SMALLINT NULL DEFAULT (0), bbcode_uid VARCHAR(10) NULL DEFAULT (NULL), menu_icon VARCHAR(255) NULL DEFAULT (NULL), function_id SMALLINT NULL DEFAULT (0), block_id SMALLINT NOT NULL DEFAULT (0), page_id SMALLINT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), link_target TINYINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_menu_nav_pk PRIMARY KEY (menu_id) ON [PRIMARY], CHECK (menu_id>=0), CHECK (cat_id>=0), CHECK (menu_order>=0), CHECK (function_id>=0), CHECK (page_id>=0), CHECK (link_target>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_table_menu_nav_cat_id ON mx_table_menu_nav (cat_id) ON [PRIMARY]; INSERT INTO mx_table_menu_nav VALUES("7","4","Split Block","Split block Demo","","0","10","043673560e","icon_dot.gif","0","2","0","0","0"); INSERT INTO mx_table_menu_nav VALUES("8","4","Google Block","Google Block Demo","","0","20","795e2489d7","icon_dot.gif","0","21","0","0","0"); INSERT INTO mx_table_menu_nav VALUES("9","4","phpBB Announcements (if any)","phpBB Announcements Demo","","0","30","29add66982","icon_dot.gif","0","18","0","0","0"); INSERT INTO mx_table_menu_nav VALUES("10","4","IncludeX","IncludeX Demo","","0","40","f7adaf1201","icon_dot.gif","0","27","0","0","0"); INSERT INTO mx_table_menu_nav VALUES("11","4","phpBB Polls (if any)","phpBB Polls Demo","","0","50","a80fe73aee","icon_dot.gif","0","6","0","0","0"); INSERT INTO mx_table_menu_nav VALUES("12","5","phpBB TextBlock","phpBB TextBlock Demo","","0","10","85d178caa8","icon_dot.gif","0","1","3","0","0"); INSERT INTO mx_table_menu_nav VALUES("13","5","WYSIWYG TextBlock","WYSIWYG TextBlock Demo","","0","20","51e2ddb3a7","icon_dot.gif","0","10","3","0","0"); INSERT INTO mx_table_menu_nav VALUES("14","5","Custom TextBlock","Custom TextBlock Demo","","0","30","22cb7a4f9f","icon_dot.gif","0","9","3","0","0"); INSERT INTO mx_table_menu_nav VALUES("15","6","Modules Info","Information","","0","10","630ce0e7f0","icon_dot.gif","0","30","3","0","0"); INSERT INTO mx_table_menu_nav VALUES("5","1","phpBB Home","","http://www.phpbb.com","0","20","71fe54c6a2","icon_info.gif","0","0","0","0","0"); INSERT INTO mx_table_menu_nav VALUES("3","3","SiteStats","Some Sitestats","","0","30","62b47107b4","icon_stats.gif","0","0","4","0","0"); INSERT INTO mx_table_menu_nav VALUES("4","1","mxBB-Portal Home","","http://www.mx-system.com","0","10","c40e66a4ae","icon_info.gif","0","0","0","0","0"); INSERT INTO mx_table_menu_nav VALUES("6","1","Demo Pages","On this page are several demo blocks located","","0","30","348dc29f4a","icon_dev.gif","0","0","3","0","0"); INSERT INTO mx_table_menu_nav VALUES("1","3","Home","Back to home","","0","10","bb51181967","icon_home.gif","0","0","1","0","0"); INSERT INTO mx_table_menu_nav VALUES("2","3","Forum","phpBB Forum Index","","0","20","a33e401abc","icon_forum.gif","0","0","2","0","0"); CREATE TABLE mx_table_module ( module_id SMALLINT NOT NULL IDENTITY(1, 1), module_name VARCHAR(150) NULL DEFAULT (NULL), module_path VARCHAR(255) NULL DEFAULT (NULL), module_desc TEXT NULL, module_include_admin CHAR(1) NULL DEFAULT ('0'), module_version VARCHAR(255) NULL DEFAULT (NULL), module_copy TEXT NULL, CONSTRAINT mx_table_module_pk PRIMARY KEY (module_id) ON [PRIMARY], CHECK (module_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; INSERT INTO mx_table_module VALUES("10","Core Blocks","modules/mx_coreblocks/","mxBB Core (standard) Module","0","","mzBB Core Module"); INSERT INTO mx_table_module VALUES("20","Text Blocks","modules/mx_textblocks/","mxBB Textblocks Module","0",NULL,"mzBB Core Module"); INSERT INTO mx_table_module VALUES("30","Post Last Message","modules/mx_last_msg/","mxBB Last Message Module","0",NULL,"mzBB Core Module"); INSERT INTO mx_table_module VALUES("40","Statistics MX","modules/mx_statistics/","mxBB Statistics Module","0",NULL,"mzBB Core Module"); INSERT INTO mx_table_module VALUES("50","Navigation Menu","modules/mx_navmenu/","mxBB Navigation Module","0",NULL,"mzBB Core Module"); CREATE TABLE mx_table_page ( page_id SMALLINT NOT NULL IDENTITY(1, 1), page_name VARCHAR(255) NULL DEFAULT (NULL), page_desc VARCHAR(255) NULL DEFAULT (NULL), page_icon VARCHAR(255) NULL DEFAULT (NULL), auth_view SMALLINT NOT NULL DEFAULT (0), auth_view_group SMALLINT NOT NULL DEFAULT (0), auth_moderator_group SMALLINT NOT NULL DEFAULT (0), page_header VARCHAR(255) NULL DEFAULT ('overall_header.tpl'), page_graph_border VARCHAR(255) NOT NULL DEFAULT (''), ip_filter VARCHAR(255) NOT NULL DEFAULT (''), phpbb_stats SMALLINT NOT NULL DEFAULT (-1), CONSTRAINT mx_table_page_pk PRIMARY KEY (page_id) ON [PRIMARY] ) ON [PRIMARY]; INSERT INTO mx_table_page VALUES("5","Site Search","Site Search page","nav_search.gif","0","0","0","overall_header.tpl","","","-1"); INSERT INTO mx_table_page VALUES("4","Sitestats","Sitestats page","nav_statistics.gif","0","0","0","overall_header.tpl","","","-1"); INSERT INTO mx_table_page VALUES("1","Home","This is the startpage","nav_home.gif","0","0","0","overall_header.tpl","","","-1"); INSERT INTO mx_table_page VALUES("2","Forum","This is the phpBB Forum startpage","nav_forum.gif","0","0","0","overall_header.tpl","","","1"); INSERT INTO mx_table_page VALUES("3","Demo Page","Block Demos","nav_develope.gif","0","0","0","overall_header.tpl","","","-1"); CREATE TABLE mx_table_page_templates ( page_template_id SMALLINT NOT NULL IDENTITY(1, 1), template_name VARCHAR(255) NOT NULL DEFAULT (''), CONSTRAINT mx_table_page_templates_pk PRIMARY KEY (page_template_id) ON [PRIMARY], CHECK (page_template_id>=0) ) ON [PRIMARY]; INSERT INTO mx_table_page_templates VALUES("1","NONE"); INSERT INTO mx_table_page_templates VALUES("2","Two-Columns left"); INSERT INTO mx_table_page_templates VALUES("3","Two-Columns right"); INSERT INTO mx_table_page_templates VALUES("4","Three-Columns"); CREATE TABLE mx_table_parameter ( parameter_id SMALLINT NOT NULL IDENTITY(1, 1), function_id SMALLINT NOT NULL DEFAULT (0), parameter_name VARCHAR(150) NULL DEFAULT (NULL), parameter_type VARCHAR(30) NULL DEFAULT (NULL), parameter_default VARCHAR(150) NULL DEFAULT (NULL), parameter_function VARCHAR(255) NULL DEFAULT (NULL), parameter_auth SMALLINT NOT NULL DEFAULT (0), parameter_order SMALLINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_parameter_pk PRIMARY KEY (parameter_id) ON [PRIMARY], CHECK (parameter_id>=0), CHECK (function_id>=0), CHECK (parameter_order>=0) ) ON [PRIMARY]; INSERT INTO mx_table_parameter VALUES("1","2","announce_nbr_display","Number","1","","0","0"); INSERT INTO mx_table_parameter VALUES("2","2","announce_nbr_days","Number","14","","0","0"); INSERT INTO mx_table_parameter VALUES("3","2","announce_display","Boolean","TRUE","","0","0"); INSERT INTO mx_table_parameter VALUES("4","2","announce_display_sticky","Boolean","TRUE","","0","0"); INSERT INTO mx_table_parameter VALUES("5","2","announce_display_normal","Boolean","FALSE","","0","0"); INSERT INTO mx_table_parameter VALUES("7","2","announce_img","Text","thumb_globe.gif","","0","0"); INSERT INTO mx_table_parameter VALUES("8","2","announce_img_sticky","Text","thumb_globe.gif","","0","0"); INSERT INTO mx_table_parameter VALUES("9","2","announce_img_normal","Text","thumb_globe.gif","","0","0"); INSERT INTO mx_table_parameter VALUES("6","2","announce_display_global","Boolean","TRUE","","0","0"); INSERT INTO mx_table_parameter VALUES("10","2","announce_img_global","Text","thumb_globe.gif","","0","0"); INSERT INTO mx_table_parameter VALUES("11","2","announce_forum","Function","","get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)","0","0"); INSERT INTO mx_table_parameter VALUES("13","14","Poll_Display","Function","0","poll_select( {parameter_value}, \"{parameter_id}\" )","0","0"); INSERT INTO mx_table_parameter VALUES("36","14","poll_forum","Function","","get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)","0","0"); INSERT INTO mx_table_parameter VALUES("15","24","Text","phpBBTextBlock","Insert your text here","","0","0"); INSERT INTO mx_table_parameter VALUES("16","23","Html","WysiwygTextBlock","Entre your Html code here","","0","0"); INSERT INTO mx_table_parameter VALUES("17","31","Last_Msg_Number_Title","Number","15","","0","0"); INSERT INTO mx_table_parameter VALUES("18","31","Last_Msg_Display_Date","Boolean","TRUE","","0","0"); INSERT INTO mx_table_parameter VALUES("19","31","Last_Msg_Title_Length","Number","30","","0","0"); INSERT INTO mx_table_parameter VALUES("20","31","Last_Msg_Target","Values","_blank","","0","0"); INSERT INTO mx_table_parameter VALUES("21","31","Last_Msg_Align","Values","left","","0","0"); INSERT INTO mx_table_parameter VALUES("22","31","Last_Msg_Display_Forum","Boolean","TRUE","","0","0"); INSERT INTO mx_table_parameter VALUES("37","31","Last_Msg_forum","Function","","get_list_multiple(\"{parameter_id}[]\", FORUMS_TABLE, \'forum_id\', \'forum_name\', \"{parameter_value}\", TRUE)","0","0"); INSERT INTO mx_table_parameter VALUES("38","31","Last_Msg_Display_Last_Author","Boolean","TRUE","","0","0"); INSERT INTO mx_table_parameter VALUES("39","31","Last_Msg_Display_Author","Boolean","FALSE","","0","0"); INSERT INTO mx_table_parameter VALUES("40","31","Last_Msg_Display_Icon_View","Boolean","TRUE","","0","0"); INSERT INTO mx_table_parameter VALUES("50","22","Text","CustomizedTextBlock","Enter your block text here","","0","0"); INSERT INTO mx_table_parameter VALUES("51","22","text_style","Text","none","","0","0"); INSERT INTO mx_table_parameter VALUES("52","22","block_style","Boolean","TRUE","","0","0"); INSERT INTO mx_table_parameter VALUES("53","22","title_style","Boolean","TRUE","","0","0"); INSERT INTO mx_table_parameter VALUES("91","10","log_filter_date","Menu_single_select","1 month","a:12:{i:0;s:8:\"no limit\";i:1;s:5:\"1 day\";i:2;s:6:\"2 days\";i:3;s:6:\"3 days\";i:4;s:6:\"1 week\";i:5;s:7:\"2 weeks\";i:6;s:7:\"3 weeks\";i:7;s:7:\"1 month\";i:8;s:8:\"2 months\";i:9;s:8:\"3 months\";i:10;s:8:\"6 months\";i:11;s:6:\"1 year\";}","0","0"); INSERT INTO mx_table_parameter VALUES("60","11","block_ids","Function","1,2,3","get_list_multiple( \"{parameter_id}[]\", BLOCK_TABLE, \'block_id\', \'block_title\', \"{parameter_value}\", TRUE)","0","0"); INSERT INTO mx_table_parameter VALUES("61","11","block_sizes","Text","20%,30%,*","","0","0"); INSERT INTO mx_table_parameter VALUES("62","11","space_between","Number","4","","0","0"); INSERT INTO mx_table_parameter VALUES("70","5","x_mode","Menu_single_select","x_iframe","a:6:{i:0;s:8:\"x_listen\";i:1;s:8:\"x_iframe\";i:2;s:10:\"x_textfile\";i:3;s:12:\"x_multimedia\";i:4;s:5:\"x_pic\";i:5;s:8:\"x_format\";}","0","0"); INSERT INTO mx_table_parameter VALUES("80","3","default_block_id","Function","0","get_list_formatted(\"block_list\",\"{parameter_value}\",\"{parameter_id}[]\")","0","0"); INSERT INTO mx_table_parameter VALUES("72","5","x_1","Text","","","0","0"); INSERT INTO mx_table_parameter VALUES("73","5","x_2","Text","","","0","0"); INSERT INTO mx_table_parameter VALUES("63","51","menu_display_mode","Radio_single_select","Vertical","a:2:{i:0;s:8:\"Vertical\";i:1;s:10:\"Horizontal\";}","0","20"); INSERT INTO mx_table_parameter VALUES("64","51","menu_page_sync","Boolean","0","","0","30"); INSERT INTO mx_table_parameter VALUES("71","5","x_3","Text","http://www.mx-system.com","","0","0"); INSERT INTO mx_table_parameter VALUES("81","21","Blog","BBText","Add your text here...","","0","0"); INSERT INTO mx_table_parameter VALUES("92","10","numOfEvents","Number","5","","0","0"); INSERT INTO mx_table_parameter VALUES("65","51","msg_filter_date","Function","5","get_list_static(\"{parameter_id}[]\",array(\"no limit\", \"1 day\", \"2 days\", \"3 days\", \"1 week\", \"2 weeks\", \"3 weeks\", \"1 month\", \"2 months\", \"3 months\", \"6 months\", \"1 year\"),\"{parameter_value}\")","0","0"); INSERT INTO mx_table_parameter VALUES("57","22","allow_smilies","Boolean","TRUE","","1","0"); INSERT INTO mx_table_parameter VALUES("54","22","allow_html","Boolean","TRUE","","1","0"); INSERT INTO mx_table_parameter VALUES("56","22","allow_bbcode","Boolean","TRUE","","1","0"); INSERT INTO mx_table_parameter VALUES("55","22","html_tags","Text","b,i,u,img","","1","0"); INSERT INTO mx_table_parameter VALUES("66","51","Nav menu","nav_menu","","","0","10"); CREATE TABLE mx_table_portal ( portal_id SMALLINT NOT NULL IDENTITY(1, 1), portal_name VARCHAR(150) NULL DEFAULT (NULL), portal_phpbb_url VARCHAR(255) NULL DEFAULT ('http://www.phpbb.com/phpBB/'), portal_url VARCHAR(255) NULL DEFAULT (NULL), portal_version VARCHAR(255) NULL DEFAULT (NULL), top_phpbb_links SMALLINT NOT NULL DEFAULT (0), mx_use_cache SMALLINT NOT NULL DEFAULT (1), portal_recached VARCHAR(255) NOT NULL DEFAULT (''), mod_rewrite SMALLINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_portal_pk PRIMARY KEY (portal_id) ON [PRIMARY], CHECK (portal_id>=0), CHECK (top_phpbb_links>=0), CHECK (mx_use_cache>=0) ) ON [PRIMARY]; CREATE TABLE mx_table_search_results ( search_id INTEGER NOT NULL DEFAULT (0), session_id VARCHAR(32) NOT NULL DEFAULT (''), search_array TEXT NOT NULL, CONSTRAINT mx_table_search_results_pk PRIMARY KEY (search_id) ON [PRIMARY], CHECK (search_id>=0) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]; CREATE INDEX mx_tablesearchresultssessionid ON mx_table_search_results (session_id) ON [PRIMARY]; CREATE TABLE mx_table_wordlist ( word_text VARBINARY(50) NOT NULL DEFAULT (''), word_id INTEGER NOT NULL IDENTITY(1, 1), word_common TINYINT NOT NULL DEFAULT (0), CONSTRAINT mx_table_wordlist_pk PRIMARY KEY (word_text) ON [PRIMARY], CHECK (word_id>=0), CHECK (word_common>=0) ) ON [PRIMARY]; CREATE INDEX mx_table_wordlist_word_id ON mx_table_wordlist (word_id) ON [PRIMARY]; CREATE TABLE mx_table_wordmatch ( block_id INTEGER NOT NULL DEFAULT (0), word_id INTEGER NOT NULL DEFAULT (0), title_match SMALLINT NOT NULL DEFAULT (0), CHECK (block_id>=0), CHECK (word_id>=0) ) ON [PRIMARY]; CREATE INDEX mx_table_wordmatch_block_id ON mx_table_wordmatch (block_id) ON [PRIMARY]; CREATE INDEX mx_table_wordmatch_word_id ON mx_table_wordmatch (word_id) ON [PRIMARY]; |
|
From: Andrew <men...@us...> - 2005-12-19 03:24:11
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30110/install/schemas Modified Files: mysql_schema_install.sql Log Message: We shouldn't need those DROPs... Index: mysql_schema_install.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v retrieving revision 1.15 retrieving revision 1.16 diff -C2 -d -r1.15 -r1.16 *** mysql_schema_install.sql 17 Dec 2005 13:10:27 -0000 1.15 --- mysql_schema_install.sql 19 Dec 2005 03:23:57 -0000 1.16 *************** *** 10,14 **** # - DROP TABLE IF EXISTS mx_table_block; CREATE TABLE `mx_table_block` ( `block_id` smallint(5) unsigned NOT NULL auto_increment, --- 10,13 ---- *************** *** 66,70 **** # - DROP TABLE IF EXISTS mx_table_block_system_parameter; CREATE TABLE `mx_table_block_system_parameter` ( `block_id` smallint(5) unsigned NOT NULL default '0', --- 65,68 ---- *************** *** 139,143 **** # - DROP TABLE IF EXISTS mx_table_column; CREATE TABLE `mx_table_column` ( `column_id` smallint(5) unsigned NOT NULL auto_increment, --- 137,140 ---- *************** *** 171,175 **** # - DROP TABLE IF EXISTS mx_table_column_block; CREATE TABLE `mx_table_column_block` ( `column_id` smallint(5) NOT NULL default '0', --- 168,171 ---- *************** *** 209,213 **** # - DROP TABLE IF EXISTS mx_table_column_templates; CREATE TABLE `mx_table_column_templates` ( `column_template_id` smallint(5) unsigned NOT NULL auto_increment, --- 205,208 ---- *************** *** 238,242 **** # - DROP TABLE IF EXISTS mx_table_function; CREATE TABLE `mx_table_function` ( `function_id` smallint(5) unsigned NOT NULL auto_increment, --- 233,236 ---- *************** *** 281,285 **** # - DROP TABLE IF EXISTS mx_table_menu_categories; CREATE TABLE `mx_table_menu_categories` ( `block_id` smallint(5) unsigned NOT NULL default '1', --- 275,278 ---- *************** *** 312,316 **** # - DROP TABLE IF EXISTS mx_table_menu_nav; CREATE TABLE `mx_table_menu_nav` ( `menu_id` smallint(5) unsigned NOT NULL auto_increment, --- 305,308 ---- *************** *** 358,362 **** # - DROP TABLE IF EXISTS mx_table_module; CREATE TABLE `mx_table_module` ( `module_id` smallint(5) unsigned NOT NULL auto_increment, --- 350,353 ---- *************** *** 386,390 **** # - DROP TABLE IF EXISTS mx_table_page; CREATE TABLE `mx_table_page` ( `page_id` smallint(5) NOT NULL auto_increment, --- 377,380 ---- *************** *** 417,421 **** # - DROP TABLE IF EXISTS mx_table_page_templates; CREATE TABLE `mx_table_page_templates` ( `page_template_id` smallint(3) unsigned NOT NULL auto_increment, --- 407,410 ---- *************** *** 439,443 **** # - DROP TABLE IF EXISTS mx_table_parameter; CREATE TABLE `mx_table_parameter` ( `parameter_id` smallint(5) unsigned NOT NULL auto_increment, --- 428,431 ---- *************** *** 511,515 **** # - DROP TABLE IF EXISTS mx_table_portal; CREATE TABLE `mx_table_portal` ( `portal_id` smallint(5) unsigned NOT NULL auto_increment, --- 499,502 ---- *************** *** 530,534 **** # - DROP TABLE IF EXISTS mx_table_search_results; CREATE TABLE `mx_table_search_results` ( `search_id` int(11) unsigned NOT NULL default '0', --- 517,520 ---- *************** *** 544,548 **** # - DROP TABLE IF EXISTS mx_table_wordlist; CREATE TABLE `mx_table_wordlist` ( `word_text` varchar(50) binary NOT NULL default '', --- 530,533 ---- *************** *** 558,562 **** # - DROP TABLE IF EXISTS mx_table_wordmatch; CREATE TABLE `mx_table_wordmatch` ( `block_id` mediumint(8) unsigned NOT NULL default '0', --- 543,546 ---- |
|
From: Andrew <men...@us...> - 2005-12-18 18:24:39
|
Update of /cvsroot/mxbb/core/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13159/includes Modified Files: mx_functions_ch.php Log Message: selven's fixes. Documented here: http://www.mx-system.com/forum/viewtopic.php?t=8018 . Index: mx_functions_ch.php =================================================================== RCS file: /cvsroot/mxbb/core/includes/mx_functions_ch.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** mx_functions_ch.php 1 Oct 2005 14:10:45 -0000 1.3 --- mx_functions_ch.php 18 Dec 2005 18:24:27 -0000 1.4 *************** *** 46,52 **** // let's run the upgrade script ! if ( !defined('IN_LOGIN') && !defined('IN_INSTALL') && (($config->data['mod_cat_hierarchy'] != '2.1.0f') || defined('RUN_CH_INSTALL')) ) { ! header('Location: '.$phpbb_root_path.'install_cat/install.' . $phpEx . (empty($SID) ? '' : '?' . $SID)); exit; } --- 46,52 ---- // let's run the upgrade script ! if ( !defined('IN_LOGIN') && !defined('IN_INSTALL') && (($config->data['mod_cat_hierarchy'] != CH_CURRENT_VERSION) || defined('RUN_CH_INSTALL')) ) { ! header('Location: ./install_cat/install.' . $phpEx . (empty($SID) ? '' : '?' . $SID)); exit; } *************** *** 75,77 **** --- 75,92 ---- $message_queue = !defined('CH_message_queue') ? '' : new message_queue(); + // include extra language key + $language = $userdata['user_lang']; + + if( !file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_extend_cat_hierarchy.'.$phpEx) ) + { + $language = $board_config['default_lang']; + } + + if( !file_exists($phpbb_root_path . 'language/lang_' . $language . '/lang_extend_cat_hierarchy.'.$phpEx) ) + { + $language = 'english'; + } + + include($phpbb_root_path . 'language/lang_' . $language . '/lang_extend_cat_hierarchy.' . $phpEx); + ?> \ No newline at end of file |
|
From: Andrew <men...@us...> - 2005-12-18 16:49:16
|
Update of /cvsroot/mxbb/core/language/lang_english In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv26330/language/lang_english Modified Files: lang_admin.php Log Message: Man, am I picky. And yes, I'll go over this file more in depth later... studying for finals comes first. Index: lang_admin.php =================================================================== RCS file: /cvsroot/mxbb/core/language/lang_english/lang_admin.php,v retrieving revision 1.59 retrieving revision 1.60 diff -C2 -d -r1.59 -r1.60 *** lang_admin.php 18 Dec 2005 03:36:20 -0000 1.59 --- lang_admin.php 18 Dec 2005 16:49:05 -0000 1.60 *************** *** 125,129 **** $lang['Mx_use_cache_explain'] = "Block data is cached to individual cache/block_*.xml files. Block cache files are created when Blocks are edited."; $lang['Mx_mod_rewrite'] = "Use mod_rewrite"; ! $lang['Mx_mod_rewrite_explain'] = "If you're running on an Apache server, and have mod_rewrite activated, you may rewrite urls like 'page=x' with more intuitive alternatives. Read further documentation in the mx_mod_rewrite module."; --- 125,129 ---- $lang['Mx_use_cache_explain'] = "Block data is cached to individual cache/block_*.xml files. Block cache files are created when Blocks are edited."; $lang['Mx_mod_rewrite'] = "Use mod_rewrite"; ! $lang['Mx_mod_rewrite_explain'] = "If you're running on an Apache server and have mod_rewrite activated, you may rewrite urls like 'page=x' with more intuitive alternatives. Read further documentation in the mx_mod_rewrite module."; |
|
From: Andrew <men...@us...> - 2005-12-18 16:44:36
|
Update of /cvsroot/mxbb/core/language/lang_english In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25569/language/lang_english Modified Files: lang_main.php Log Message: Minor fixes. Also updated the copyright line. Index: lang_main.php =================================================================== RCS file: /cvsroot/mxbb/core/language/lang_english/lang_main.php,v retrieving revision 1.25 retrieving revision 1.26 diff -C2 -d -r1.25 -r1.26 *** lang_main.php 13 Dec 2005 20:57:02 -0000 1.25 --- lang_main.php 18 Dec 2005 16:44:20 -0000 1.26 *************** *** 37,41 **** $lang['Edit your Profile'] = "Edit Your Profile"; ! $lang['Portal_lang'] = "Language CP"; // Blocktitle $lang['SELECTGUILANG'] = "Select Language:"; --- 37,41 ---- $lang['Edit your Profile'] = "Edit Your Profile"; ! $lang['Portal_lang'] = "LanguageCP"; // Blocktitle $lang['SELECTGUILANG'] = "Select Language:"; *************** *** 62,67 **** $lang['Block_Config_updated'] = "Block Configuration updated successfully"; $lang['Block_Edit'] = "Edit Block"; ! $lang['Block_Edit_dyn'] = "Edit parent dynamic Block"; ! $lang['Block_Edit_sub'] = "Edit parent split Block"; // --- 62,67 ---- $lang['Block_Config_updated'] = "Block Configuration updated successfully"; $lang['Block_Edit'] = "Edit Block"; ! $lang['Block_Edit_dyn'] = "Edit parent dynamic block"; ! $lang['Block_Edit_sub'] = "Edit parent split block"; // *************** *** 88,92 **** $lang['Show_admin_options'] = "Show/Hide Page Admin Options: "; $lang['Hidden_block'] = "Hidden block..."; ! $lang['Hidden_block_explain'] = "This block is 'hidden', but visible since you're an admin/moderator."; $lang['General_updated_return_settings'] = "Configuration updated successfully...<br /><br />Click %shere%s to continue."; // %s's for URI params - DO NOT REMOVE --- 88,92 ---- $lang['Show_admin_options'] = "Show/Hide Page Admin Options: "; $lang['Hidden_block'] = "Hidden block..."; ! $lang['Hidden_block_explain'] = "This block is 'hidden', but visible since you're an administrator or moderator."; $lang['General_updated_return_settings'] = "Configuration updated successfully...<br /><br />Click %shere%s to continue."; // %s's for URI params - DO NOT REMOVE *************** *** 104,113 **** $lang['Block_updated_by'] = "Updated by "; ! $lang['No_items_found'] = "Nothing new to report... "; $lang['Powered_by'] = "Powered by "; $lang['Modules_copy'] = "and mxBB Modules "; ! $lang['mx_copy_text'] = '<b>mxBB - Modular Portal & CMS for phpBB!</b> <br /><br/> mxBB is a fully modular portal and CMS for phpBB, featuring dynamic pages/blocks/themes by means of a powerful yet flexible AdminCP. While it uses integrated features, it works without touching phpBB. mxBB-Portal is the classical phpBB portal add-on, improved and enhanced for every phpBB version since 2001. <br /><br />Authors: Jon Ohlsson, Marc Morissette, Markus, Jaime, Luke Finnigan, Snake, and the rest of the mxBB Development Team. <br />Please visit <a href="http://www.mx-system.com/">www.mx-system.com</a> for further information.'; $lang['mx_modules_text'] = '<b>mxBB Modules</b>'; --- 104,113 ---- $lang['Block_updated_by'] = "Updated by "; ! $lang['No_items_found'] = "Nothing new to report. "; $lang['Powered_by'] = "Powered by "; $lang['Modules_copy'] = "and mxBB Modules "; ! $lang['mx_copy_text'] = '<b>mxBB - Modular Portal & CMS for phpBB!</b> <br /><br/> mxBB is a fully modular portal and CMS for phpBB, featuring dynamic pages, blocks, and themes, by means of a powerful yet flexible AdminCP. It works without touching phpBB by using integrated functions and features. mxBB-Portal is the classical phpBB portal add-on, improved and enhanced for every phpBB version released since 2001. <br /><br />Authors: The mxBB Development Team. <br />Please visit <a href="http://www.mx-system.com/">www.mx-system.com</a> for further information.'; $lang['mx_modules_text'] = '<b>mxBB Modules</b>'; |
|
From: Andrew <men...@us...> - 2005-12-18 16:41:46
|
Update of /cvsroot/mxbb/core/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv25153/admin Modified Files: index.php Log Message: Minor fix(es). Index: index.php =================================================================== RCS file: /cvsroot/mxbb/core/admin/index.php,v retrieving revision 1.19 retrieving revision 1.20 diff -C2 -d -r1.19 -r1.20 *** index.php 18 Dec 2005 00:36:59 -0000 1.19 --- index.php 18 Dec 2005 16:41:38 -0000 1.20 *************** *** 20,24 **** /** ! * mxNN Notes: * This file is borrowed from phpBB, with some modifications */ --- 20,24 ---- /** ! * mxBB Notes: * This file is borrowed from phpBB, with some modifications */ |
|
From: Andrew <men...@us...> - 2005-12-18 16:26:25
|
Update of /cvsroot/mxbb/core/contrib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22919/contrib Modified Files: readme.txt Log Message: Fine fine, I give up... Index: readme.txt =================================================================== RCS file: /cvsroot/mxbb/core/contrib/readme.txt,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** readme.txt 18 Dec 2005 16:25:32 -0000 1.3 --- readme.txt 18 Dec 2005 16:26:16 -0000 1.4 *************** *** 1,4 **** - // $IDHEADER - You will find two different subfolders in this contrib/ directory: replace_phpbb_admin , and sync_overall_header . --- 1,2 ---- |
|
From: Andrew <men...@us...> - 2005-12-18 16:25:41
|
Update of /cvsroot/mxbb/core/contrib In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22840/contrib Modified Files: readme.txt Log Message: test again Index: readme.txt =================================================================== RCS file: /cvsroot/mxbb/core/contrib/readme.txt,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** readme.txt 18 Dec 2005 16:24:23 -0000 1.2 --- readme.txt 18 Dec 2005 16:25:32 -0000 1.3 *************** *** 1,3 **** ! // $Id You will find two different subfolders in this contrib/ directory: replace_phpbb_admin , and sync_overall_header . --- 1,3 ---- ! // $IDHEADER You will find two different subfolders in this contrib/ directory: replace_phpbb_admin , and sync_overall_header . |
2 messages has been excluded from this view by a project administrator.
