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: Markus P. <mar...@us...> - 2005-03-22 00:25:07
|
Update of /cvsroot/mxbb/core/install/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv16024/includes Log Message: Directory /cvsroot/mxbb/core/install/includes added to the repository |
|
From: Markus P. <mar...@us...> - 2005-03-21 22:10:35
|
Update of /cvsroot/mxbb/core/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10752 Modified Files: template.php Log Message: Including phpBB version of the Template class. Index: template.php =================================================================== RCS file: /cvsroot/mxbb/core/includes/template.php,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** template.php 21 Mar 2005 20:52:01 -0000 1.10 --- template.php 21 Mar 2005 22:10:25 -0000 1.11 *************** *** 22,25 **** --- 22,32 ---- */ + + // + // Including phpBB version of the Template class + // + include_once($phpbb_root_path . "includes/template.$phpEx"); + + class mx_Template extends Template { |
|
From: Jon O. <jon...@us...> - 2005-03-21 21:53:12
|
Update of /cvsroot/mxbb/core/modules/mx_textblocks/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1521/modules/mx_textblocks/admin Modified Files: mx_textblock_edit.php Log Message: merging, resolving conflict Index: mx_textblock_edit.php =================================================================== RCS file: /cvsroot/mxbb/core/modules/mx_textblocks/admin/mx_textblock_edit.php,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** mx_textblock_edit.php 21 Mar 2005 21:24:43 -0000 1.14 --- mx_textblock_edit.php 21 Mar 2005 21:52:40 -0000 1.15 *************** *** 24,27 **** --- 24,28 ---- require( $mx_root_path . 'admin/pagestart.php' ); + include_once($phpbb_root_path . 'includes/functions_search.'.$phpEx); // required for search tables include_once($phpbb_root_path . "includes/functions_post.$phpEx"); // required by mx_generate_smilies *************** *** 38,42 **** } ! $block_id = isset( $HTTP_GET_VARS['block_id'] ) ? intval( $HTTP_GET_VARS['block_id'] ) : intval( $HTTP_POST_VARS['block_id'] ); $portalpage = isset( $HTTP_GET_VARS['portalpage'] ) ? intval( $HTTP_GET_VARS['portalpage'] ) : intval( $HTTP_POST_VARS['portalpage'] ); --- 39,43 ---- } ! // Initial vars $block_id = isset( $HTTP_GET_VARS['block_id'] ) ? intval( $HTTP_GET_VARS['block_id'] ) : intval( $HTTP_POST_VARS['block_id'] ); $portalpage = isset( $HTTP_GET_VARS['portalpage'] ) ? intval( $HTTP_GET_VARS['portalpage'] ) : intval( $HTTP_POST_VARS['portalpage'] ); *************** *** 57,61 **** ! // OBS OBS OBS // $blog_validate = ( $blog_mode == 'group' ) ? mx_auth_group( $sub_id, $userdata['user_id'], true ) : $sub_id == $userdata['user_id']; $blog_validate = ( $blog_mode == 'group' ) ? mx_auth_group_cache( $sub_id, true ) : $sub_id == $userdata['user_id']; --- 58,62 ---- ! // Blog mode: // $blog_validate = ( $blog_mode == 'group' ) ? mx_auth_group( $sub_id, $userdata['user_id'], true ) : $sub_id == $userdata['user_id']; $blog_validate = ( $blog_mode == 'group' ) ? mx_auth_group_cache( $sub_id, true ) : $sub_id == $userdata['user_id']; *************** *** 82,93 **** } - $html_entities_match = array( '#&#', '#<#', '#>#' ); - $html_entities_replace = array( '&', '<', '>' ); - // Parameters ! $submit = ( isset( $HTTP_POST_VARS['post'] ) ) ? true : 0; ! $cancel = ( isset( $HTTP_POST_VARS['cancel'] ) ) ? true : 0; ! $preview = ( isset( $HTTP_POST_VARS['preview'] ) ) ? true : 0; $refresh = $preview || $submit_search; --- 83,91 ---- } // Parameters ! $submit = ( isset( $HTTP_POST_VARS['post'] ) ) ? true : false; ! $cancel = ( isset( $HTTP_POST_VARS['cancel'] ) ) ? true : false; ! $preview = ( isset( $HTTP_POST_VARS['preview'] ) ) ? true : false; $refresh = $preview || $submit_search; *************** *** 103,106 **** --- 101,105 ---- $error = false; + /* // Toggles *************** *** 124,127 **** --- 123,127 ---- $bbcode_on = true; } + */ if ( !$board_config['allow_smilies'] ) *************** *** 139,143 **** // Define all config data - // echo('aa '.$sub_id); // Main parameters --- 139,142 ---- *************** *** 148,169 **** $show_stats_par = "show_stats"; ! if ( isset( $block_config[$block_id]['Html'] ) ) { ! $block_info_par = "Html"; $mode = "edithtml"; } ! else if ( isset( $block_config[$block_id]['Text'] ) ) { ! $block_info_par = "Text"; $mode = "edit"; } ! else if ( isset( $block_config[$block_id]['Blog'] ) ) { ! $block_info_par = "Blog"; $mode = "editblog"; } else { ! $block_info_par = ""; $mode = "edit"; } --- 147,183 ---- $show_stats_par = "show_stats"; ! if ( isset( $block_config[$block_id]['Html'] ) ) // Html Textblock { ! $block_text_par = "Html"; $mode = "edithtml"; + $bbcode_on = false; + $html_on = true; + + $html_entities_match = array( ); + $html_entities_replace = array( ); } ! else if ( isset( $block_config[$block_id]['Text'] ) ) // Multi or BBcode Textblock { ! $block_text_par = "Text"; $mode = "edit"; + $bbcode_on = true; + $html_on = true; + + $html_entities_match = array( '#&#', '#<#', '#>#' ); + $html_entities_replace = array( '&', '<', '>' ); } ! else if ( isset( $block_config[$block_id]['Blog'] ) ) // Blog Textblock { ! $block_text_par = "Blog"; $mode = "editblog"; + $bbcode_on = true; + $html_on = true; + + $html_entities_match = array( '#&#', '#<#', '#>#' ); + $html_entities_replace = array( '&', '<', '>' ); } else { ! $block_text_par = ""; $mode = "edit"; } *************** *** 179,183 **** $new_vars = array(); ! $new_vars = array( $block_info_par, $block_style_par, $text_style_par, $title_style_par, $blog_id_par ); $new = array(); --- 193,197 ---- $new_vars = array(); ! $new_vars = array( $block_text_par, $block_style_par, $text_style_par, $title_style_par, $blog_id_par ); $new = array(); *************** *** 197,207 **** else { ! if ( $new_vars[$j] == 'Text' || $new_vars[$j] == 'Blog' ) { ! if ( $bbcode_on && $mode != 'edithtml' ) { $bbcode_uid = make_bbcode_uid(); } ! $new[$new_vars[$j]] = prepare_message( $new[$new_vars[$j]], $html_on, $bbcode_on, $smilies_on, $bbcode_uid ); } --- 211,223 ---- else { ! if ( $new_vars[$j] == $block_text_par ) { ! if ( $bbcode_on ) { $bbcode_uid = make_bbcode_uid(); } ! ! //Format the input: ! $new[$new_vars[$j]] = prepare_message( trim($new[$new_vars[$j]]), $html_on, $bbcode_on, $smilies_on, $bbcode_uid ); } *************** *** 243,248 **** if ( $sub_id == "0" ) { ! $block_title = ( isset( $HTTP_POST_VARS['block_title'] ) ) ? trim( strip_tags( $HTTP_POST_VARS['block_title'] ) ) : $block_config[$block_id]['block_title']; ! $block_desc = trim( strip_tags( $HTTP_POST_VARS['block_desc'] ) ); $show_block = intval( $HTTP_POST_VARS['show_block'] ); $show_title = intval( $HTTP_POST_VARS['show_title'] ); --- 259,264 ---- if ( $sub_id == "0" ) { ! $block_title = ( isset( $HTTP_POST_VARS['block_title'] ) ) ? htmlspecialchars(trim( $HTTP_POST_VARS['block_title'] ) ) : $block_config[$block_id]['block_title']; ! $block_desc = htmlspecialchars(trim( $HTTP_POST_VARS['block_desc'] ) ); $show_block = intval( $HTTP_POST_VARS['show_block'] ); $show_title = intval( $HTTP_POST_VARS['show_title'] ); *************** *** 267,271 **** } ! mx_add_search_words( 'single', $block_id, stripslashes( str_replace( "\'", "''", $new[$block_info_par] ) ), stripslashes( str_replace( "\'", "''", $block_title ) ) ); } --- 283,287 ---- } ! mx_add_search_words( 'single', $block_id, stripslashes( str_replace( "\'", "''", $new[$block_text_par] ) ), stripslashes( str_replace( "\'", "''", $block_title ) ) ); } *************** *** 289,317 **** } ! $block_info = $new[$block_info_par]; ! $bbcode_uid = $block_config[$block_id][$block_info_par]['bbcode_uid']; $blog_id = trim( stripslashes( $new[$blog_id_par] )); ! if ( $preview ) ! { ! $preview_title = trim( strip_tags( stripslashes( $block_title ) ) ); ! $preview_info = trim( $block_info ) ; ! $preview_info = preg_replace( '#<textarea>#si', '<textarea>', $preview_info ); ! } if ( $mode != 'edithtml' ) { ! $block_info = preg_replace( "/\:(([a-z0-9]:)?)$bbcode_uid/si", '', $block_info ); ! $block_info = str_replace( '<br />', "\n", $block_info ); ! $block_info = preg_replace( '#</textarea>#si', '</textarea>', $block_info ); ! $block_info = trim( stripslashes( $block_info ) ); } else { $block_title = trim( strip_tags( stripslashes( $block_title ) ) ); ! $block_info = str_replace( '<br />', "\n", $block_info ); ! $block_info = preg_replace( '#</textarea>#si', '</textarea>', $block_info ); ! $block_info = trim( stripslashes( $block_info ) ); } // Style parameters --- 305,329 ---- } ! $block_text = $new[$block_text_par]; ! $bbcode_uid = $block_config[$block_id][$block_text_par]['bbcode_uid']; $blog_id = trim( stripslashes( $new[$blog_id_par] )); ! $block_text = htmlspecialchars( trim( stripslashes( $block_text ) ) ) ; ! $block_title = htmlspecialchars( trim( stripslashes( $block_title ) ) ) ; if ( $mode != 'edithtml' ) { ! $block_text = preg_replace( "/\:(([a-z0-9]:)?)$bbcode_uid/si", '', $block_text ); ! $block_text = str_replace( '<br />', "\n", $block_text ); ! $block_text = preg_replace( '#</textarea>#si', '</textarea>', $block_text ); ! $block_text = trim( stripslashes( $block_text ) ); } else { $block_title = trim( strip_tags( stripslashes( $block_title ) ) ); ! $block_text = str_replace( '<br />', "\n", $block_text ); ! $block_text = preg_replace( '#</textarea>#si', '</textarea>', $block_text ); ! $block_text = trim( stripslashes( $block_text ) ); } // Style parameters *************** *** 355,358 **** --- 367,371 ---- $show_stats_yes = ( $show_stats == 1 ) ? "checked=\"checked\"" : ""; $show_stats_no = ( $show_stats == 0 ) ? "checked=\"checked\"" : ""; + // Start output, first preview, then errors then post form *************** *** 376,379 **** --- 389,397 ---- if ( $preview && !$error ) { + $preview_title = $block_title; + $preview_text = $block_text; + + // $preview_text = preg_replace( '#<textarea>#si', '<textarea>', $preview_text ); + $orig_word = array(); $replacement_word = array(); *************** *** 384,408 **** $bbcode_uid = make_bbcode_uid(); } ! // $preview_info = stripslashes(preg_replace($html_entities_match, $html_entities_replace, $preview_info)); ! $preview_info = stripslashes( prepare_message( $preview_info, $html_on, $bbcode_on, $smilies_on, $bbcode_uid ) ); // Finalise processing as per viewtopic - if ( !$html_on ) - { - if ( $user_sig != '' || !$userdata['user_allowhtml'] ) - { - $user_sig = preg_replace( '#(<)([\/]?.*?)(>)#is', "<\\2>", $user_sig ); - } - } - - if ( $attach_sig && $user_sig != '' && $userdata['user_sig_bbcode_uid'] ) - { - $user_sig = bbencode_second_pass( $user_sig, $userdata['user_sig_bbcode_uid'] ); - } - if ( $bbcode_on && $mode != 'edithtml' ) { ! $preview_info = bbencode_second_pass( $preview_info, $bbcode_uid ); } --- 402,416 ---- $bbcode_uid = make_bbcode_uid(); } ! ! //$mxbb_tmp = $board_config['allow_html_tags']; //Should we have specfic allowed tags spec for mx textblocks? ! //$board_config['allow_html_tags'] = ''; ! $preview_text = stripslashes(prepare_message(addslashes(unprepare_message($preview_text)), $html_on, $bbcode_on, $smilies_on, $bbcode_uid)); ! //$board_config['allow_html_tags'] = $mxbb_tmp; // Finalise processing as per viewtopic if ( $bbcode_on && $mode != 'edithtml' ) { ! $preview_text = bbencode_second_pass( $preview_text, $bbcode_uid ); } *************** *** 410,423 **** { $preview_title = preg_replace( $orig_word, $replacement_word, $preview_title ); ! $preview_info = preg_replace( $orig_word, $replacement_word, $preview_info ); } if ( $smilies_on && $mode != 'edithtml' ) { ! $preview_info = mx_smilies_pass( $preview_info ); } ! $preview_info = make_clickable( $preview_info ); ! $preview_info = str_replace( "\n", '<br />', $preview_info ); $s_hidden_fields .= '<input type="hidden" name="mode" value="' . $mode . '" />'; --- 418,435 ---- { $preview_title = preg_replace( $orig_word, $replacement_word, $preview_title ); ! $preview_text = preg_replace( $orig_word, $replacement_word, $preview_text ); } if ( $smilies_on && $mode != 'edithtml' ) { ! $preview_text = mx_smilies_pass( $preview_text ); } ! $preview_text = make_clickable( $preview_text ); ! ! if ( $mode != 'edithtml' ) ! { ! $preview_text = str_replace( "\n", '<br />', $preview_text ); ! } $s_hidden_fields .= '<input type="hidden" name="mode" value="' . $mode . '" />'; *************** *** 429,433 **** $template->assign_vars( array( 'BLOCK_TITLE' => $preview_title, ! 'BLOCK_INFO' => $preview_info, 'S_HIDDEN_FIELDS' => $s_hidden_fields, --- 441,445 ---- $template->assign_vars( array( 'BLOCK_TITLE' => $preview_title, ! 'BLOCK_INFO' => $preview_text, 'S_HIDDEN_FIELDS' => $s_hidden_fields, *************** *** 463,470 **** { $POST_ACTION = $module_root_path . "admin/mx_textblock_edit.$phpEx?mode=edit"; ! }elseif ( $mode == 'edithtml' ) { $POST_ACTION = $module_root_path . "admin/mx_textblock_edit.$phpEx?mode=edithtml"; ! }elseif ( $mode == 'editblog' ) { $POST_ACTION = $module_root_path . "admin/mx_textblock_edit.$phpEx?mode=editblog"; --- 475,484 ---- { $POST_ACTION = $module_root_path . "admin/mx_textblock_edit.$phpEx?mode=edit"; ! } ! elseif ( $mode == 'edithtml' ) { $POST_ACTION = $module_root_path . "admin/mx_textblock_edit.$phpEx?mode=edithtml"; ! } ! elseif ( $mode == 'editblog' ) { $POST_ACTION = $module_root_path . "admin/mx_textblock_edit.$phpEx?mode=editblog"; *************** *** 506,514 **** 'L_EXPLAIN' => $lang['Block_admin_explain'], 'BLOCK_TITLE' => $block_title, ! 'BLOCK_INFO' => $block_info, 'HTML_STATUS' => $html_status, 'SMILIES_STATUS' => $smilies_status, ! 'BLOCK_TEXT_NAME' => $block_info_par, 'L_BLOCK_STYLE' => $lang['Block_Style'], --- 520,528 ---- 'L_EXPLAIN' => $lang['Block_admin_explain'], 'BLOCK_TITLE' => $block_title, ! 'BLOCK_INFO' => $block_text, 'HTML_STATUS' => $html_status, 'SMILIES_STATUS' => $smilies_status, ! 'BLOCK_TEXT_NAME' => $block_text_par, 'L_BLOCK_STYLE' => $lang['Block_Style'], |
|
From: Markus P. <mar...@us...> - 2005-03-21 21:31:59
|
Update of /cvsroot/mxbb/mx_kb/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23835 Modified Files: kb_add.php kb_edit.php Log Message: Rolled back previous action (include_once phpbb/includes/functions_post.php, required by mx_generate_smilies). Not required since functions_post is already included_once by kb.php =:-o Index: kb_edit.php =================================================================== RCS file: /cvsroot/mxbb/mx_kb/includes/kb_edit.php,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** kb_edit.php 21 Mar 2005 21:27:22 -0000 1.14 --- kb_edit.php 21 Mar 2005 21:31:47 -0000 1.15 *************** *** 25,30 **** } - include_once($phpbb_root_path . "includes/functions_post.$phpEx"); // required by mx_generate_smilies - $article_id = ( isset( $HTTP_GET_VARS['k'] ) ) ? intval ( $HTTP_GET_VARS['k'] ) : intval ( $HTTP_POST_VARS['k'] ); --- 25,28 ---- Index: kb_add.php =================================================================== RCS file: /cvsroot/mxbb/mx_kb/includes/kb_add.php,v retrieving revision 1.14 retrieving revision 1.15 diff -C2 -d -r1.14 -r1.15 *** kb_add.php 21 Mar 2005 21:27:21 -0000 1.14 --- kb_add.php 21 Mar 2005 21:31:47 -0000 1.15 *************** *** 25,30 **** } - include_once($phpbb_root_path . "includes/functions_post.$phpEx"); // required by mx_generate_smilies - $category_id = ( isset( $HTTP_GET_VARS['cat'] ) ) ? intval ( $HTTP_GET_VARS['cat'] ) : intval ( $HTTP_POST_VARS['cat'] ); --- 25,28 ---- |
|
From: Markus P. <mar...@us...> - 2005-03-21 21:27:33
|
Update of /cvsroot/mxbb/mx_kb/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21760/includes Modified Files: kb_add.php kb_edit.php Log Message: include_once phpbb/includes/functions_post.php, required by mx_generate_smilies. Index: kb_edit.php =================================================================== RCS file: /cvsroot/mxbb/mx_kb/includes/kb_edit.php,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** kb_edit.php 17 Mar 2005 12:37:24 -0000 1.13 --- kb_edit.php 21 Mar 2005 21:27:22 -0000 1.14 *************** *** 25,28 **** --- 25,30 ---- } + include_once($phpbb_root_path . "includes/functions_post.$phpEx"); // required by mx_generate_smilies + $article_id = ( isset( $HTTP_GET_VARS['k'] ) ) ? intval ( $HTTP_GET_VARS['k'] ) : intval ( $HTTP_POST_VARS['k'] ); Index: kb_add.php =================================================================== RCS file: /cvsroot/mxbb/mx_kb/includes/kb_add.php,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** kb_add.php 17 Mar 2005 12:37:24 -0000 1.13 --- kb_add.php 21 Mar 2005 21:27:21 -0000 1.14 *************** *** 25,28 **** --- 25,30 ---- } + include_once($phpbb_root_path . "includes/functions_post.$phpEx"); // required by mx_generate_smilies + $category_id = ( isset( $HTTP_GET_VARS['cat'] ) ) ? intval ( $HTTP_GET_VARS['cat'] ) : intval ( $HTTP_POST_VARS['cat'] ); |
|
From: Markus P. <mar...@us...> - 2005-03-21 21:24:54
|
Update of /cvsroot/mxbb/core/modules/mx_textblocks/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20443/modules/mx_textblocks/admin Modified Files: mx_textblock_edit.php Log Message: include_once phpbb/includes/functions_post.php, required by mx_generate_smilies. Index: mx_textblock_edit.php =================================================================== RCS file: /cvsroot/mxbb/core/modules/mx_textblocks/admin/mx_textblock_edit.php,v retrieving revision 1.13 retrieving revision 1.14 diff -C2 -d -r1.13 -r1.14 *** mx_textblock_edit.php 18 Feb 2005 10:10:46 -0000 1.13 --- mx_textblock_edit.php 21 Mar 2005 21:24:43 -0000 1.14 *************** *** 23,27 **** $module_root_path = "../"; ! require( $mx_root_path . 'admin/pagestart.php' ); // Mode setting --- 23,28 ---- $module_root_path = "../"; ! require( $mx_root_path . 'admin/pagestart.php' ); ! include_once($phpbb_root_path . "includes/functions_post.$phpEx"); // required by mx_generate_smilies // Mode setting |
|
From: Markus P. <mar...@us...> - 2005-03-21 21:24:53
|
Update of /cvsroot/mxbb/core/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20443/admin Modified Files: admin_mx_block_edit.php Log Message: include_once phpbb/includes/functions_post.php, required by mx_generate_smilies. Index: admin_mx_block_edit.php =================================================================== RCS file: /cvsroot/mxbb/core/admin/admin_mx_block_edit.php,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** admin_mx_block_edit.php 6 Mar 2005 01:10:12 -0000 1.7 --- admin_mx_block_edit.php 21 Mar 2005 21:24:31 -0000 1.8 *************** *** 32,35 **** --- 32,36 ---- require( './pagestart.php' ); + include_once($phpbb_root_path . "includes/functions_post.$phpEx"); // required by mx_generate_smilies $block_id = ( ! empty( $HTTP_GET_VARS['block_id'] ) ) ? intval( $HTTP_GET_VARS['block_id'] ) : intval( $HTTP_POST_VARS['id'] ); |
|
From: Markus P. <mar...@us...> - 2005-03-21 20:59:44
|
Update of /cvsroot/mxbb/core/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8715/install Modified Files: mx_install.php Log Message: Rewritten templates.php script. Now our template class is named mx_Template, it simply extends the phpBB Template class which could be based on the standard one or those in their contrib folder (file or db cache).This is the first step to try to make our template engine also compatible with eXtreme Styles MOD, etc. Index: mx_install.php =================================================================== RCS file: /cvsroot/mxbb/core/install/mx_install.php,v retrieving revision 1.35 retrieving revision 1.36 diff -C2 -d -r1.35 -r1.36 *** mx_install.php 9 Mar 2005 19:32:05 -0000 1.35 --- mx_install.php 21 Mar 2005 20:59:33 -0000 1.36 *************** *** 54,58 **** // This is shown in the top right corner of the installation panels. // ! define('INSTALLER_VERSION', '1.0.4'); define('INSTALLER_NAME', 'mxBB-Installer'); --- 54,58 ---- // This is shown in the top right corner of the installation panels. // ! define('INSTALLER_VERSION', '1.0.5'); define('INSTALLER_NAME', 'mxBB-Installer'); *************** *** 354,358 **** include($mx_root_path . "includes/template.$phpEx"); ! $template = new Template($mx_root_path . 'install/templates'); page_header_install($lang['Welcome_install'], $lang['Choose_lang_explain']); $template->set_filenames(array('language' => 'mx_install_language.tpl')); --- 354,358 ---- include($mx_root_path . "includes/template.$phpEx"); ! $template = new mx_Template($mx_root_path . 'install/templates'); page_header_install($lang['Welcome_install'], $lang['Choose_lang_explain']); $template->set_filenames(array('language' => 'mx_install_language.tpl')); *************** *** 470,474 **** include($mx_root_path . "includes/template.$phpEx"); ! $template = new Template($mx_root_path . 'install/templates'); page_header_install($lang['Welcome_install'], $instruction_text); $template->set_filenames(array('button' => 'mx_install_button.tpl')); --- 470,474 ---- include($mx_root_path . "includes/template.$phpEx"); ! $template = new mx_Template($mx_root_path . 'install/templates'); page_header_install($lang['Welcome_install'], $instruction_text); $template->set_filenames(array('button' => 'mx_install_button.tpl')); *************** *** 576,580 **** include($mx_root_path . "includes/template.$phpEx"); ! $template = new Template($mx_root_path . 'install/templates'); page_header_install($install_title, $message); $template->set_filenames(array('button' => 'mx_install_button.tpl')); --- 576,580 ---- include($mx_root_path . "includes/template.$phpEx"); ! $template = new mx_Template($mx_root_path . 'install/templates'); page_header_install($install_title, $message); $template->set_filenames(array('button' => 'mx_install_button.tpl')); *************** *** 599,603 **** // include($mx_root_path . "includes/template.$phpEx"); ! $template = new Template($mx_root_path . 'install/templates'); --- 599,603 ---- // include($mx_root_path . "includes/template.$phpEx"); ! $template = new mx_Template($mx_root_path . 'install/templates'); *************** *** 1009,1013 **** { include($mx_root_path . "includes/template.$phpEx"); ! $template = new Template($mx_root_path . 'install/templates'); page_header_install($lang['Installation_error'], $message); } --- 1009,1013 ---- { include($mx_root_path . "includes/template.$phpEx"); ! $template = new mx_Template($mx_root_path . 'install/templates'); page_header_install($lang['Installation_error'], $message); } *************** *** 1352,1356 **** // include($mx_root_path . "includes/template.$phpEx"); ! $template = new Template($mx_root_path . 'install/templates'); page_header_install('phpInfo()'); $template->set_filenames(array('phpinfo' => 'mx_install_phpinfo.tpl')); --- 1352,1356 ---- // include($mx_root_path . "includes/template.$phpEx"); ! $template = new mx_Template($mx_root_path . 'install/templates'); page_header_install('phpInfo()'); $template->set_filenames(array('phpinfo' => 'mx_install_phpinfo.tpl')); |
|
From: Markus P. <mar...@us...> - 2005-03-21 20:59:43
|
Update of /cvsroot/mxbb/core/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8715/includes Modified Files: mx_functions_phpbb.php Log Message: Rewritten templates.php script. Now our template class is named mx_Template, it simply extends the phpBB Template class which could be based on the standard one or those in their contrib folder (file or db cache).This is the first step to try to make our template engine also compatible with eXtreme Styles MOD, etc. Index: mx_functions_phpbb.php =================================================================== RCS file: /cvsroot/mxbb/core/includes/mx_functions_phpbb.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** mx_functions_phpbb.php 21 Mar 2005 19:33:44 -0000 1.2 --- mx_functions_phpbb.php 21 Mar 2005 20:59:33 -0000 1.3 *************** *** 219,227 **** } ! $template = new Template( $mx_root_path . $template_path . $template_name, $board_config, $db ); } else { ! $template = new Template( $mx_root_path . $template_path . $template_name, $board_config, $db ); } --- 219,227 ---- } ! $template = new mx_Template( $mx_root_path . $template_path . $template_name, $board_config, $db ); } else { ! $template = new mx_Template( $mx_root_path . $template_path . $template_name, $board_config, $db ); } *************** *** 327,331 **** if ( empty( $template ) ) { ! $template = new Template( $mx_root_path . 'templates/' . $board_config['board_template'] ); } if ( empty( $theme ) ) --- 327,331 ---- if ( empty( $template ) ) { ! $template = new mx_Template( $mx_root_path . 'templates/' . $board_config['board_template'] ); } if ( empty( $theme ) ) *************** *** 491,495 **** if ( empty( $template ) ) { ! $template = new Template( $mx_root_path . 'templates/' . $board_config['board_template'] ); } if ( empty( $theme ) ) --- 491,495 ---- if ( empty( $template ) ) { ! $template = new mx_Template( $mx_root_path . 'templates/' . $board_config['board_template'] ); } if ( empty( $theme ) ) |
|
From: Markus P. <mar...@us...> - 2005-03-21 20:59:43
|
Update of /cvsroot/mxbb/core In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8715 Modified Files: index.php mx_multiple_blocks.php Log Message: Rewritten templates.php script. Now our template class is named mx_Template, it simply extends the phpBB Template class which could be based on the standard one or those in their contrib folder (file or db cache).This is the first step to try to make our template engine also compatible with eXtreme Styles MOD, etc. Index: mx_multiple_blocks.php =================================================================== RCS file: /cvsroot/mxbb/core/mx_multiple_blocks.php,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** mx_multiple_blocks.php 6 Mar 2005 01:10:13 -0000 1.6 --- mx_multiple_blocks.php 21 Mar 2005 20:59:33 -0000 1.7 *************** *** 203,207 **** // echo $module_root_path.$block_file; ! $template = new Template( $template->root, $board_config, $db ); include( $module_root_path . $block_x_file ); --- 203,207 ---- // echo $module_root_path.$block_file; ! $template = new mx_Template( $template->root, $board_config, $db ); include( $module_root_path . $block_x_file ); Index: index.php =================================================================== RCS file: /cvsroot/mxbb/core/index.php,v retrieving revision 1.25 retrieving revision 1.26 diff -C2 -d -r1.25 -r1.26 *** index.php 17 Mar 2005 11:30:36 -0000 1.25 --- index.php 21 Mar 2005 20:59:32 -0000 1.26 *************** *** 88,92 **** // Initialize template ! $layouttemplate = new Template( $template->root, $board_config, $db ); $layouttemplate->set_filenames( array( --- 88,92 ---- // Initialize template ! $layouttemplate = new mx_Template( $template->root, $board_config, $db ); $layouttemplate->set_filenames( array( *************** *** 168,172 **** { //$layouttemplate->assign_block_vars( 'layoutcol', array() ); ! $template = new Template( $template->root, $board_config, $db ); $module_root_path = $block_rows[$block]['module_path']; --- 168,172 ---- { //$layouttemplate->assign_block_vars( 'layoutcol', array() ); ! $template = new mx_Template( $template->root, $board_config, $db ); $module_root_path = $block_rows[$block]['module_path']; |
|
From: Markus P. <mar...@us...> - 2005-03-21 20:52:11
|
Update of /cvsroot/mxbb/core/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4828 Modified Files: template.php Log Message: Rewritten templates.php script. Now our template class is named mx_Template, it simply extends the phpBB Template class which could be based on the standard one or those in their contrib folder (file or db cache).This is the first step to try to make our template engine also compatible with eXtreme Styles MOD, etc. Index: template.php =================================================================== RCS file: /cvsroot/mxbb/core/includes/template.php,v retrieving revision 1.9 retrieving revision 1.10 diff -C2 -d -r1.9 -r1.10 *** template.php 20 Mar 2005 05:23:47 -0000 1.9 --- template.php 21 Mar 2005 20:52:01 -0000 1.10 *************** *** 22,213 **** */ ! /** ! * Template class. By Nathan Codding of the phpBB group. ! * The interface was originally inspired by PHPLib templates, ! * and the template file formats are quite similar. ! */ ! ! class Template { - var $classname = "Template"; - // variable that holds all the data we'll be substituting into - // the compiled templates. - // ... - // This will end up being a multi-dimensional array like this: - // $this->_tpldata[block.][iteration#][child.][iteration#][child2.][iteration#][variablename] == value - // if it's a root-level variable, it'll be like this: - // $this->_tpldata[.][0][varname] == value - var $_tpldata = array(); - // Hash of filenames for each template handle. - var $files = array(); - // Root template directory. - var $root = ""; - // this will hash handle names to the compiled code for that handle. - var $compiled_code = array(); - // This will hold the uncompiled code for that handle. - var $uncompiled_code = array(); - /** ! * Constructor. Simply sets the root dir. ! */ ! function Template( $root = "." ) ! { ! $this->set_rootdir( $root ); ! } ! ! /** ! * Destroys this template object. Should be called when you're done with it, in order ! * to clear out the template data so you can load/parse a new template set. ! */ ! function destroy() ! { ! $this->_tpldata = array(); ! } ! ! /** ! * Sets the template root directory for this Template object. ! */ ! function set_rootdir( $dir ) ! { ! if ( !is_dir( $dir ) ) ! { ! return false; ! } ! ! $this->root = $dir; ! return true; ! } ! ! /** ! * Sets the template filenames for handles. $filename_array ! * should be a hash of handle => filename pairs. ! */ ! function set_filenames( $filename_array ) ! { ! if ( !is_array( $filename_array ) ) ! { ! return false; ! } ! ! reset( $filename_array ); ! while ( list( $handle, $filename ) = each( $filename_array ) ) ! { ! $this->files[$handle] = $this->make_filename( $filename ); ! } ! ! return true; ! } ! ! /** ! * Load the file for the handle, compile the file, ! * and run the compiled code. This will print out ! * the results of executing the template. ! */ ! function pparse( $handle ) ! { ! if ( !$this->loadfile( $handle ) ) ! { ! die( "Template->pparse(): Couldn't load template file for handle $handle" ); ! } ! // actually compile the template now. ! if ( !isset( $this->compiled_code[$handle] ) || empty( $this->compiled_code[$handle] ) ) ! { ! // Actually compile the code now. ! $this->compiled_code[$handle] = $this->compile( $this->uncompiled_code[$handle] ); ! } ! // Run the compiled code. ! eval( $this->compiled_code[$handle] ); ! return true; ! } ! ! /** ! * Inserts the uncompiled code for $handle as the ! * value of $varname in the root-level. This can be used ! * to effectively include a template in the middle of another ! * template. ! * Note that all desired assignments to the variables in $handle should be done ! * BEFORE calling this function. ! */ ! function assign_var_from_handle( $varname, $handle ) ! { ! if ( !$this->loadfile( $handle ) ) ! { ! die( "Template->assign_var_from_handle(): Couldn't load template file for handle $handle" ); ! } ! // Compile it, with the "no echo statements" option on. ! $_str = ""; ! $code = $this->compile( $this->uncompiled_code[$handle], true, '_str' ); ! // evaluate the variable assignment. ! eval( $code ); ! // assign the value of the generated variable to the given varname. ! $this->assign_var( $varname, $_str ); ! ! return true; ! } ! ! /** ! * Block-level variable assignment. Adds a new block iteration with the given ! * variable assignments. Note that this should only be called once per block ! * iteration. ! */ ! function assign_block_vars( $blockname, $vararray ) ! { ! if ( strstr( $blockname, '.' ) ) ! { ! // Nested block. ! $blocks = explode( '.', $blockname ); ! $blockcount = sizeof( $blocks ) - 1; ! $str = '$this->_tpldata'; ! for ( $i = 0; $i < $blockcount; $i++ ) ! { ! $str .= '[\'' . $blocks[$i] . '.\']'; ! eval( '$lastiteration = sizeof(' . $str . ') - 1;' ); ! $str .= '[' . $lastiteration . ']'; ! } ! // Now we add the block that we're actually assigning to. ! // We're adding a new iteration to this block with the given ! // variable assignments. ! $str .= '[\'' . $blocks[$blockcount] . '.\'][] = $vararray;'; ! // Now we evaluate this assignment we've built up. ! eval( $str ); ! } ! else ! { ! // Top-level block. ! // Add a new iteration to this block with the variable assignments ! // we were given. ! $this->_tpldata[$blockname . '.'][] = $vararray; ! } ! ! return true; ! } ! ! /** ! * Root-level variable assignment. Adds to current assignments, overriding ! * any existing variable assignment with the same name. ! */ ! function assign_vars( $vararray ) ! { ! reset ( $vararray ); ! while ( list( $key, $val ) = each( $vararray ) ) ! { ! $this->_tpldata['.'][0][$key] = $val; ! } ! ! return true; ! } ! ! /** ! * Root-level variable assignment. Adds to current assignments, overriding ! * any existing variable assignment with the same name. */ ! function assign_var( $varname, $varval ) { ! $this->_tpldata['.'][0][$varname] = $varval; ! ! return true; } /** * Generates a full path+filename for the given filename, which can either * be an absolute name, or a name relative to the rootdir for this Template --- 22,39 ---- */ ! class mx_Template extends Template { /** ! * Constructor. Simply calling parent construtor. ! * This is required. Reason is constructors have different method names. */ ! function mx_Template( $root = "." ) { ! parent::Template($root); } /** + * This make_filename implementation overrides parent method. + * * Generates a full path+filename for the given filename, which can either * be an absolute name, or a name relative to the rootdir for this Template *************** *** 285,500 **** } ! /** ! * If not already done, load the file for the given handle and populate ! * the uncompiled_code[] hash with its code. Do not compile. ! */ ! function loadfile( $handle ) ! { ! // If the file for this handle is already loaded and compiled, do nothing. ! if ( isset( $this->uncompiled_code[$handle] ) && !empty( $this->uncompiled_code[$handle] ) ) ! { ! return true; ! } ! // If we don't have a file assigned to this handle, die. ! if ( !isset( $this->files[$handle] ) ) ! { ! die( "Template->loadfile(): No file specified for handle $handle" ); ! } ! ! $filename = $this->files[$handle]; ! ! $str = implode( "", @file( $filename ) ); ! if ( empty( $str ) ) ! { ! die( "Template->loadfile(): File $filename for handle $handle is empty" ); ! } ! ! $this->uncompiled_code[$handle] = $str; ! ! return true; ! } ! ! /** ! * Compiles the given string of code, and returns ! * the result in a string. ! * If "do_not_echo" is true, the returned code will not be directly ! * executable, but can be used as part of a variable assignment ! * for use in assign_code_from_handle(). ! */ ! function compile( $code, $do_not_echo = false, $retvar = '' ) ! { ! // replace \ with \\ and then ' with \'. ! $code = str_replace( '\\', '\\\\', $code ); ! $code = str_replace( '\'', '\\\'', $code ); ! // change template varrefs into PHP varrefs ! // This one will handle varrefs WITH namespaces ! $varrefs = array(); ! preg_match_all( '#\{(([a-z0-9\-_]+?\.)+?)([a-z0-9\-_]+?)\}#is', $code, $varrefs ); ! $varcount = sizeof( $varrefs[1] ); ! for ( $i = 0; $i < $varcount; $i++ ) ! { ! $namespace = $varrefs[1][$i]; ! $varname = $varrefs[3][$i]; ! $new = $this->generate_block_varref( $namespace, $varname ); ! ! $code = str_replace( $varrefs[0][$i], $new, $code ); ! } ! // This will handle the remaining root-level varrefs ! $code = preg_replace( '#\{([a-z0-9\-_]*?)\}#is', '\' . ( ( isset($this->_tpldata[\'.\'][0][\'\1\']) ) ? $this->_tpldata[\'.\'][0][\'\1\'] : \'\' ) . \'', $code ); ! // Break it up into lines. ! $code_lines = explode( "\n", $code ); ! ! $block_nesting_level = 0; ! $block_names = array(); ! $block_names[0] = "."; ! // Second: prepend echo ', append ' . "\n"; to each line. ! $line_count = sizeof( $code_lines ); ! for ( $i = 0; $i < $line_count; $i++ ) ! { ! $code_lines[$i] = chop( $code_lines[$i] ); ! if ( preg_match( '#<!-- BEGIN (.*?) -->#', $code_lines[$i], $m ) ) ! { ! $n[0] = $m[0]; ! $n[1] = $m[1]; ! // Added: dougk_ff7-Keeps templates from bombing if begin is on the same line as end.. I think. :) ! if ( preg_match( '#<!-- END (.*?) -->#', $code_lines[$i], $n ) ) ! { ! $block_nesting_level++; ! $block_names[$block_nesting_level] = $m[1]; ! if ( $block_nesting_level < 2 ) ! { ! // Block is not nested. ! $code_lines[$i] = '$_' . $n[1] . '_count = ( isset($this->_tpldata[\'' . $n[1] . '.\']) ) ? sizeof($this->_tpldata[\'' . $n[1] . '.\']) : 0;'; ! $code_lines[$i] .= "\n" . 'for ($_' . $n[1] . '_i = 0; $_' . $n[1] . '_i < $_' . $n[1] . '_count; $_' . $n[1] . '_i++)'; ! $code_lines[$i] .= "\n" . '{'; ! } ! else ! { ! // This block is nested. ! // Generate a namespace string for this block. ! $namespace = implode( '.', $block_names ); ! // strip leading period from root level.. ! $namespace = substr( $namespace, 2 ); ! // Get a reference to the data array for this block that depends on the ! // current indices of all parent blocks. ! $varref = $this->generate_block_data_ref( $namespace, false ); ! // Create the for loop code to iterate over this block. ! $code_lines[$i] = '$_' . $n[1] . '_count = ( isset(' . $varref . ') ) ? sizeof(' . $varref . ') : 0;'; ! $code_lines[$i] .= "\n" . 'for ($_' . $n[1] . '_i = 0; $_' . $n[1] . '_i < $_' . $n[1] . '_count; $_' . $n[1] . '_i++)'; ! $code_lines[$i] .= "\n" . '{'; ! } ! // We have the end of a block. ! unset( $block_names[$block_nesting_level] ); ! $block_nesting_level--; ! $code_lines[$i] .= '} // END ' . $n[1]; ! $m[0] = $n[0]; ! $m[1] = $n[1]; ! } ! else ! { ! // We have the start of a block. ! $block_nesting_level++; ! $block_names[$block_nesting_level] = $m[1]; ! if ( $block_nesting_level < 2 ) ! { ! // Block is not nested. ! $code_lines[$i] = '$_' . $m[1] . '_count = ( isset($this->_tpldata[\'' . $m[1] . '.\']) ) ? sizeof($this->_tpldata[\'' . $m[1] . '.\']) : 0;'; ! $code_lines[$i] .= "\n" . 'for ($_' . $m[1] . '_i = 0; $_' . $m[1] . '_i < $_' . $m[1] . '_count; $_' . $m[1] . '_i++)'; ! $code_lines[$i] .= "\n" . '{'; ! } ! else ! { ! // This block is nested. ! // Generate a namespace string for this block. ! $namespace = implode( '.', $block_names ); ! // strip leading period from root level.. ! $namespace = substr( $namespace, 2 ); ! // Get a reference to the data array for this block that depends on the ! // current indices of all parent blocks. ! $varref = $this->generate_block_data_ref( $namespace, false ); ! // Create the for loop code to iterate over this block. ! $code_lines[$i] = '$_' . $m[1] . '_count = ( isset(' . $varref . ') ) ? sizeof(' . $varref . ') : 0;'; ! $code_lines[$i] .= "\n" . 'for ($_' . $m[1] . '_i = 0; $_' . $m[1] . '_i < $_' . $m[1] . '_count; $_' . $m[1] . '_i++)'; ! $code_lines[$i] .= "\n" . '{'; ! } ! } ! } ! else if ( preg_match( '#<!-- END (.*?) -->#', $code_lines[$i], $m ) ) ! { ! // We have the end of a block. ! unset( $block_names[$block_nesting_level] ); ! $block_nesting_level--; ! $code_lines[$i] = '} // END ' . $m[1]; ! } ! else ! { ! // We have an ordinary line of code. ! if ( !$do_not_echo ) ! { ! $code_lines[$i] = 'echo \'' . $code_lines[$i] . '\' . "\\n";'; ! } ! else ! { ! $code_lines[$i] = '$' . $retvar . '.= \'' . $code_lines[$i] . '\' . "\\n";'; ! } ! } ! } ! // Bring it back into a single string of lines of code. ! $code = implode( "\n", $code_lines ); ! return $code ; ! } ! ! /** ! * Generates a reference to the given variable inside the given (possibly nested) ! * block namespace. This is a string of the form: ! * ' . $this->_tpldata['parent'][$_parent_i]['$child1'][$_child1_i]['$child2'][$_child2_i]...['varname'] . ' ! * It's ready to be inserted into an "echo" line in one of the templates. ! * NOTE: expects a trailing "." on the namespace. ! */ ! function generate_block_varref( $namespace, $varname ) ! { ! // Strip the trailing period. ! $namespace = substr( $namespace, 0, strlen( $namespace ) - 1 ); ! // Get a reference to the data block for this namespace. ! $varref = $this->generate_block_data_ref( $namespace, true ); ! // Prepend the necessary code to stick this in an echo line. ! // Append the variable reference. ! $varref .= '[\'' . $varname . '\']'; ! ! $varref = '\' . ( ( isset(' . $varref . ') ) ? ' . $varref . ' : \'\' ) . \''; ! ! return $varref; ! } ! ! /** ! * Generates a reference to the array of data values for the given ! * (possibly nested) block namespace. This is a string of the form: ! * $this->_tpldata['parent'][$_parent_i]['$child1'][$_child1_i]['$child2'][$_child2_i]...['$childN'] ! * ! * If $include_last_iterator is true, then [$_childN_i] will be appended to the form shown above. ! * NOTE: does not expect a trailing "." on the blockname. ! */ ! function generate_block_data_ref( $blockname, $include_last_iterator ) ! { ! // Get an array of the blocks involved. ! $blocks = explode( ".", $blockname ); ! $blockcount = sizeof( $blocks ) - 1; ! $varref = '$this->_tpldata'; ! // Build up the string with everything but the last child. ! for ( $i = 0; $i < $blockcount; $i++ ) ! { ! $varref .= '[\'' . $blocks[$i] . '.\'][$_' . $blocks[$i] . '_i]'; ! } ! // Add the block reference for the last child. ! $varref .= '[\'' . $blocks[$blockcount] . '.\']'; ! // Add the iterator for the last child if requried. ! if ( $include_last_iterator ) ! { ! $varref .= '[$_' . $blocks[$blockcount] . '_i]'; ! } ! ! return $varref; ! } ! } ?> \ No newline at end of file --- 111,115 ---- } ! } // class mx_Template ?> \ No newline at end of file |
|
From: Markus P. <mar...@us...> - 2005-03-21 19:42:03
|
Update of /cvsroot/mxbb/core In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5121 Removed Files: more_smilies.php Log Message: Removed more_smilies.php from mx/root. Since we have a new version of mx_generate_smilies we don't need that one any more. Also checked no other modules use it. --- more_smilies.php DELETED --- |
|
From: Markus P. <mar...@us...> - 2005-03-21 19:33:56
|
Update of /cvsroot/mxbb/core/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1512 Modified Files: mx_functions_phpbb.php Log Message: Hacking smilies_pass from phpbb/includes/bbcode.php Hacking generate_smilies from phpbb/includes/functions_post.php Index: mx_functions_phpbb.php =================================================================== RCS file: /cvsroot/mxbb/core/includes/mx_functions_phpbb.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** mx_functions_phpbb.php 16 Mar 2005 00:17:26 -0000 1.1 --- mx_functions_phpbb.php 21 Mar 2005 19:33:44 -0000 1.2 *************** *** 23,26 **** --- 23,27 ---- * Included functions in this file: (validated for phpbb 2.0.10) * - mx_smilies_pass (from bbcode.php) + * - mx_generate_smilies (from functions_post.php) * - mx_decode * - mx_init_userprefs (from functions.php) *************** *** 28,71 **** * - mx_message_die (from functions.php) * - mx_block_info (another message_die clone, from functions.php) - * - mx_generate_smilies (from functions_post.php) * - mx_redirect (from functions_post.php) */ ! function mx_smilies_pass( $message ) { ! static $orig, $repl; ! ! if ( !isset( $orig ) ) ! { ! global $db, $board_config; ! $orig = $repl = array(); ! ! $sql = 'SELECT * FROM ' . SMILIES_TABLE; ! if ( !$result = $db->sql_query( $sql ) ) ! { ! mx_message_die( GENERAL_ERROR, "Couldn't obtain smilies data", "", __LINE__, __FILE__, $sql ); ! } ! $smilies = $db->sql_fetchrowset( $result ); ! ! if ( count( $smilies ) ) ! { ! usort( $smilies, 'smiley_sort' ); ! } ! ! for( $i = 0; $i < count( $smilies ); $i++ ) ! { ! $orig[] = "/(?<=.\W|\W.|^\W)" . phpbb_preg_quote( $smilies[$i]['code'], "/" ) . "(?=.\W|\W.|\W$)/"; ! $repl[] = '<img src="' . PHPBB_URL . $board_config['smilies_path'] . '/' . $smilies[$i]['smile_url'] . '" alt="' . $smilies[$i]['emoticon'] . '" border="0" />'; ! } ! } ! ! if ( count( $orig ) ) ! { ! $message = preg_replace( $orig, $repl, ' ' . $message . ' ' ); ! $message = substr( $message, 1, -1 ); ! } return $message; } // Convert the bbcode to html function mx_decode( $bbtext, $bbcode_uid ) { --- 29,66 ---- * - mx_message_die (from functions.php) * - mx_block_info (another message_die clone, from functions.php) * - mx_redirect (from functions_post.php) */ ! // ! // Hacking smilies_pass from phpbb/includes/bbcode.php ! // ! function mx_smilies_pass($message) { ! global $board_config; ! $smilies_path = $board_config['smilies_path']; ! $board_config['smilies_path'] = PHPBB_URL . $board_config['smilies_path']; ! $message = smilies_pass($message); ! $board_config['smilies_path'] = $smilies_path; return $message; } + + // + // Hacking generate_smilies from phpbb/includes/functions_post.php + // + function mx_generate_smilies($mode, $page_id) + { + global $board_config, $template, $phpEx; + $smilies_path = $board_config['smilies_path']; + $board_config['smilies_path'] = PHPBB_URL . $board_config['smilies_path']; + generate_smilies($mode, $page_id); + $board_config['smilies_path'] = $smilies_path; + $template->assign_vars(array( + 'U_MORE_SMILIES' => append_sid(PHPBB_URL . "posting.$phpEx?mode=smilies")) + ); + } + + // // Convert the bbcode to html + // function mx_decode( $bbtext, $bbcode_uid ) { *************** *** 597,706 **** } - // Fill smiley templates (or just the variables) with smileys - // Either in a window or inline - function mx_generate_smilies( $mode, $page_id ) - { - global $db, $board_config, $template, $lang, $images, $theme, $phpEx, $mx_root_path, $phpbb_root_path; - global $user_ip, $session_length, $starttime; - global $userdata; - - $inline_columns = 4; - $inline_rows = 5; - $window_columns = 8; - - if ( $mode == 'window' ) - { - $userdata = session_pagestart( $user_ip, $page_id ); - mx_init_userprefs( $userdata ); - - $gen_simple_header = true; - // $page_title = $lang['Review_topic'] . " - $topic_title"; - $page_title = $lang['Emoticons'] . " - $topic_title"; - include( $mx_root_path . 'includes/page_header.' . $phpEx ); - - $template->set_filenames( array( 'smiliesbody' => 'mx_posting_smilies.tpl' ) - ); - } - - $sql = "SELECT emoticon, code, smile_url - FROM " . SMILIES_TABLE . " - ORDER BY smilies_id"; - if ( $result = $db->sql_query( $sql ) ) - { - $num_smilies = 0; - $rowset = array(); - while ( $row = $db->sql_fetchrow( $result ) ) - { - if ( empty( $rowset[$row['smile_url']] ) ) - { - $rowset[$row['smile_url']]['code'] = str_replace( '\\', '\\\\', str_replace( "'", "\\'", $row['code'] ) ); - $rowset[$row['smile_url']]['emoticon'] = $row['emoticon']; - $num_smilies++; - } - } - - if ( $num_smilies ) - { - $smilies_count = ( $mode == 'inline' ) ? min( 19, $num_smilies ) : $num_smilies; - $smilies_split_row = ( $mode == 'inline' ) ? $inline_columns - 1 : $window_columns - 1; - - $s_colspan = 0; - $row = 0; - $col = 0; - - while ( list( $smile_url, $data ) = @each( $rowset ) ) - { - if ( !$col ) - { - $template->assign_block_vars( 'smilies_row', array() ); - } - - $template->assign_block_vars( 'smilies_row.smilies_col', array( 'SMILEY_CODE' => $data['code'], - 'SMILEY_IMG' => PHPBB_URL . $board_config['smilies_path'] . '/' . $smile_url, - 'SMILEY_DESC' => $data['emoticon'] ) - ); - - $s_colspan = max( $s_colspan, $col + 1 ); - - if ( $col == $smilies_split_row ) - { - if ( $mode == 'inline' && $row == $inline_rows - 1 ) - { - break; - } - $col = 0; - $row++; - } - else - { - $col++; - } - } - - if ( $mode == 'inline' && $num_smilies > $inline_rows * $inline_columns ) - { - $template->assign_block_vars( 'switch_smilies_extra', array() ); - - $template->assign_vars( array( 'L_MORE_SMILIES' => $lang['More_emoticons'], - 'U_MORE_SMILIES' => append_sid( PORTAL_URL . "more_smilies.$phpEx?mode=smilies" ) ) - ); - } - - $template->assign_vars( array( 'FIELD' => 'block_info', - 'L_EMOTICONS' => $lang['Emoticons'], - 'L_CLOSE_WINDOW' => $lang['Close_window'], - 'S_SMILIES_COLSPAN' => $s_colspan ) - ); - } - } - - if ( $mode == 'window' ) - { - $template->pparse( 'smiliesbody' ); - - include( $mx_root_path . 'includes/page_tail.' . $phpEx ); - } - } - // MX - Redeclarations of functions from function.php function mx_redirect( $url, $redirect_msg = '', $redirect_link = '' ) --- 592,595 ---- |
|
From: Markus P. <mar...@us...> - 2005-03-21 00:11:14
|
Update of /cvsroot/mxbb/core In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv11081 Removed Files: mx_meta.inc.distrib Log Message: Removed mx_meta.inc.distrib, it was absolutely useless. --- mx_meta.inc.distrib DELETED --- |
|
From: Markus P. <mar...@us...> - 2005-03-20 23:19:31
|
Update of /cvsroot/mxbb/core/templates/subSilver/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9892 Modified Files: admin_mx_portal.tpl Log Message: Modified template layout for the Portal Management ACP. This is the first step to upcomming modifications to add more useful information. Index: admin_mx_portal.tpl =================================================================== RCS file: /cvsroot/mxbb/core/templates/subSilver/admin/admin_mx_portal.tpl,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** admin_mx_portal.tpl 6 Mar 2005 01:10:15 -0000 1.4 --- admin_mx_portal.tpl 20 Mar 2005 23:19:18 -0000 1.5 *************** *** 4,22 **** <form action="{S_CONFIG_ACTION}" method="post"> ! <table width="100%" cellpadding="4" cellspacing="1" border="0" align="center" class="forumline"> <tr> ! <th class="thHead" colspan="3">{L_GENERAL_SETTINGS}</th> </tr> <tr> ! <td class="row1">{L_PORTAL_NAME}</td> ! <td class="row2"><input type="text" maxlength="150" size="30" name="portal_name" value="{PORTAL_NAME}" /></td> </tr> <tr> <td class="row1">{L_PORTAL_URL}</td> ! <td class="row2"><input type="text" maxlength="150" size="30" name="portal_url" value="{PORTAL_URL}" /></td> </tr> <tr> <td class="row1">{L_PORTAL_PHPBB_URL}</td> ! <td class="row2"><input type="text" maxlength="150" size="30" name="portal_phpbb_url" value="{PORTAL_PHPBB_URL}" /></td> </tr> <tr> --- 4,22 ---- <form action="{S_CONFIG_ACTION}" method="post"> ! <table width="100%" cellpadding="4" cellspacing="1" border="0" align="center" class="forumline"> <tr> ! <th class="thHead" colspan="2">{L_GENERAL_SETTINGS}</th> </tr> <tr> ! <td class="row1" width="50%">{L_PORTAL_NAME}</td> ! <td class="row2" width="50%"><input type="text" maxlength="150" size="50" name="portal_name" value="{PORTAL_NAME}" /></td> </tr> <tr> <td class="row1">{L_PORTAL_URL}</td> ! <td class="row2"><input type="text" maxlength="150" size="50" name="portal_url" value="{PORTAL_URL}" /></td> </tr> <tr> <td class="row1">{L_PORTAL_PHPBB_URL}</td> ! <td class="row2"><input type="text" maxlength="150" size="50" name="portal_phpbb_url" value="{PORTAL_PHPBB_URL}" /></td> </tr> <tr> *************** *** 28,40 **** <td class="row2"><input type="radio" name="mx_use_cache" value="1" {S_MX_USE_CACHE_YES} /> {L_YES} <input type="radio" name="mx_use_cache" value="0" {S_MX_USE_CACHE_NO} /> {L_NO}</td> </tr> - <tr> - <td class="catBottom" colspan="3" align="center">{S_HIDDEN_FIELDS}<input type="submit" name="submit" value="{L_SUBMIT}" class="mainoption" /> <input type="reset" value="{L_RESET}" class="liteoption" /> - </tr> - <tr> ! <th class="thHead" colspan="3">{L_GENERAL_CONFIG_INFO}</th> </tr> <tr> ! <td class="row1">{L_PHPBB_RELATIVE_PATH}<br />{L_PHPBB_RELATIVE_PATH_EXPLAIN}</td> <td class="row2">{PHPBB_RELATIVE_PATH}</td> </tr> --- 28,39 ---- <td class="row2"><input type="radio" name="mx_use_cache" value="1" {S_MX_USE_CACHE_YES} /> {L_YES} <input type="radio" name="mx_use_cache" value="0" {S_MX_USE_CACHE_NO} /> {L_NO}</td> </tr> <tr> ! <td class="catBottom" colspan="2" align="center">{S_HIDDEN_FIELDS}<input type="submit" name="submit" value="{L_SUBMIT}" class="mainoption" /> <input type="reset" value="{L_RESET}" class="liteoption" /> </tr> <tr> ! <th class="thHead" colspan="2">{L_GENERAL_CONFIG_INFO}</th> ! </tr> ! <tr> ! <td class="row1">{L_PHPBB_RELATIVE_PATH}</td> <td class="row2">{PHPBB_RELATIVE_PATH}</td> </tr> *************** *** 43,49 **** <td class="row2">{PORTAL_VERSION}</td> </tr> - <tr> ! <th class="thHead" colspan="3">{L_PHPBB_INFO}</th> </tr> <tr> --- 42,47 ---- <td class="row2">{PORTAL_VERSION}</td> </tr> <tr> ! <th class="thHead" colspan="2">{L_PHPBB_INFO}</th> </tr> <tr> *************** *** 59,65 **** <td class="row2">{PHPBB_SCRIPT_PATH}</td> </tr> ! ! ! </table></form> ! ! <br clear="all" /> --- 57,61 ---- <td class="row2">{PHPBB_SCRIPT_PATH}</td> </tr> ! </table> ! </form> ! <br clear="all" /> \ No newline at end of file |
|
From: Markus P. <mar...@us...> - 2005-03-20 23:00:05
|
Update of /cvsroot/mxbb/core/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32178 Modified Files: admin_mx_phpinfo.php Log Message: Formatting output for phpInfo in ACP. Index: admin_mx_phpinfo.php =================================================================== RCS file: /cvsroot/mxbb/core/admin/admin_mx_phpinfo.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** admin_mx_phpinfo.php 9 Jan 2005 21:55:44 -0000 1.3 --- admin_mx_phpinfo.php 20 Mar 2005 22:59:55 -0000 1.4 *************** *** 1,7 **** <?php /** ------------------------------------------------------------------------ ! * subject : mx-portal, CMS & portal * begin : june, 2002 ! * copyright : (C) 2002-2005 MX-System * email : jon...@ho... * project site : www.mx-system.com --- 1,7 ---- <?php /** ------------------------------------------------------------------------ ! * subject : mxBB-Portal * begin : june, 2002 ! * copyright : (C) 2002-2005 mxBB-Portal * email : jon...@ho... * project site : www.mx-system.com *************** *** 19,39 **** */ ! $no_page_header = true; ! ! if ( !empty( $setmodules ) ) { ! $file = basename( __FILE__ ); $module['Portal - System']['phpInfo'] = 'admin/' . $file; return; } ! define( 'IN_PORTAL', 1 ); $mx_root_path = '../'; // Security and page header ! require( './pagestart.php' ); ! phpinfo(); ?> \ No newline at end of file --- 19,83 ---- */ ! if ( !empty($setmodules) ) { ! $file = basename(__FILE__); $module['Portal - System']['phpInfo'] = 'admin/' . $file; return; } ! define('IN_PORTAL', 1); $mx_root_path = '../'; + // // Security and page header + // + require('./pagestart.php'); ! // ! // Capture the phpInfo output ! // ! ob_start(); phpinfo(); + $output = ob_get_contents(); + ob_end_clean(); + + // + // Extract the BODY part. + // + preg_match_all('#<body[^>]*>(.*)</body>#siU', $output, $body_part); + $body_part = $body_part[1][0]; + + // + // Remove all, but some HTML Tags. + // + $allowedTags = '<h1><h2><h3><hr><ul><ol><li><b><i><u>'. + '<a><pre><blockquote><img><div><span><p><br>'. + '<table><tr><td><th><thead><tbody><tfoot>'; + $body_part = strip_tags($body_part, $allowedTags); + + // + // Alter some CSS related attributes. + // + $body_part = preg_replace('# (style|class)=["\'](.*?)["\']#si', '', $body_part); + $body_part = preg_replace('#<hr(.*?)>#si', '<hr size="1" width="600" />', $body_part); + $body_part = preg_replace('#<img(.*?)>#si', '<img style="float:right; border:0px;"\1>', $body_part); + $body_part = preg_replace('#<td(.*?)>(.*?)</td>#si', '<td\1><span class="genmed">\2</span></td>', $body_part); + $body_part = preg_replace('#cellpadding="(.*?)"#si', 'cellpadding="2"', $body_part); + $body_part = preg_replace('#cellspacing="(.*?)"#si', '', $body_part); + $body_part = preg_replace('#<table(.*?)>#si', '<table\1 cellspacing="1" class="forumline" style="margin-left:auto;margin-right:auto;">', $body_part); + $body_part = preg_replace('#<td(.*?)>#si', '<td\1 class="row1">', $body_part); + $body_part = preg_replace('#<td(.*?)class="row1">#si', '<td\1class="row2">', $body_part); + + // + // Send the formatted result to the browser. + // + $template->set_filenames(array('phpinfo' => 'admin/admin_mx_phpinfo.tpl')); + $template->assign_vars(array('PHPINFO' => $body_part)); + $template->pparse('phpinfo'); + + // + // Send page footer. + // + include_once('page_footer_admin.' . $phpEx); ?> \ No newline at end of file |
|
From: Markus P. <mar...@us...> - 2005-03-20 22:59:35
|
Update of /cvsroot/mxbb/core/templates/subSilver/admin In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31853 Added Files: admin_mx_phpinfo.tpl Log Message: Formatting output for phpInfo in ACP. --- NEW FILE: admin_mx_phpinfo.tpl --- <div style="text-align:center;">{PHPINFO}</div> |
|
From: Markus P. <mar...@us...> - 2005-03-20 05:23:55
|
Update of /cvsroot/mxbb/core/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29673 Modified Files: template.php Log Message: Fixed filename reporting when template not found in template.php. Index: template.php =================================================================== RCS file: /cvsroot/mxbb/core/includes/template.php,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** template.php 9 Jan 2005 21:55:44 -0000 1.8 --- template.php 20 Mar 2005 05:23:47 -0000 1.9 *************** *** 273,277 **** if ( substr( $filename, 0, 1 ) != '/' ) { ! $filename = phpbb_realpath( $this->root . '/' . $filename ); } } --- 273,277 ---- if ( substr( $filename, 0, 1 ) != '/' ) { ! $filename = ($rp_filename = phpbb_realpath($this->root . '/' . $filename)) ? $rp_filename : $filename; } } |
|
From: Markus P. <mar...@us...> - 2005-03-20 04:20:27
|
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv24362/schemas Modified Files: mysql_schema_install.sql mysql_schema_install_2.7.3.sql Added Files: mysql_schema_install_2.7.5.sql Log Message: Removed Sunday/Monday entries (orphans!) from parameter_option table. --- NEW FILE: mysql_schema_install_2.7.5.sql --- # # mxBB-Portal - MySQL Schema - version 2.7.5 # # $Id: mysql_schema_install_2.7.5.sql,v 1.1 2005/03/20 04:20:17 markus_petrux Exp $ # # -------------------------------------------------------- # # Table structure for table `mx_block` # CREATE TABLE mx_table_block ( block_id smallint(5) unsigned NOT NULL auto_increment, block_title varchar(150) default NULL, block_desc text, function_id smallint(5) unsigned default NULL, auth_view tinyint(2) NOT NULL default '0', auth_edit tinyint(2) default '0', auth_delete tinyint(2) default '0', auth_view_group smallint(5) NOT NULL default '0', auth_edit_group smallint(5) NOT NULL default '0', auth_delete_group smallint(5) NOT NULL default '0', PRIMARY KEY (block_id) ); # # Dumping data for table `mx_block` # 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); # -------------------------------------------------------- # # Table structure for table `mx_block_system_parameter` # CREATE TABLE mx_table_block_system_parameter ( block_id smallint(5) unsigned NOT NULL default '0', parameter_id smallint(5) unsigned NOT NULL default '0', parameter_value text, bbcode_uid varchar(10) default NULL, PRIMARY KEY (block_id, parameter_id) ); # # Dumping data for table `mx_block_system_parameter` # INSERT INTO mx_table_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_table_block_system_parameter VALUES (2, 60, '3,4,5', ''); INSERT INTO mx_table_block_system_parameter VALUES (2, 61, '33%,*,33%', ''); INSERT INTO mx_table_block_system_parameter VALUES (2, 62, '4', ''); INSERT INTO mx_table_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_table_block_system_parameter VALUES (3, 51, 'none', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 52, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 53, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 54, 'TRUE', ''); INSERT INTO mx_table_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_table_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_table_block_system_parameter VALUES (6, 36, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (6, 13, '0', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 17, '5', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 18, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 19, '30', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 20, '_self', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 21, 'left', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 22, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 37, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 38, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 39, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 40, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 1, '1', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 2, '999', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 3, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 4, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 5, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 7, 'thumb_news.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 8, 'thumb_globe.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 9, 'thumb_globe.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 6, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 10, 'thumb_globe.gif ', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 11, '', NULL); # -------------------------------------------------------- # # Table structure for table `mx_column` # CREATE TABLE mx_table_column ( column_id smallint(5) unsigned NOT NULL auto_increment, column_title varchar(100) default NULL, column_order smallint(5) unsigned NOT NULL default '0', bbcode_uid varchar(10) default NULL, column_size varchar(5) default '100%', page_id smallint(5) NOT NULL default '0', PRIMARY KEY (column_id), KEY cat_order (column_order) ); # # Dumping data for table `mx_column` # 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); # -------------------------------------------------------- # # Table structure for table `mx_column_block` # CREATE TABLE mx_table_column_block ( column_id smallint(5) NOT NULL default '0', block_id smallint(5) NOT NULL default '0', block_order smallint(5) NOT NULL default '0' ); # # Dumping data for table `mx_column_block` # 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); # -------------------------------------------------------- # # Table structure for table `mx_function` # CREATE TABLE mx_table_function ( function_id smallint(5) unsigned NOT NULL auto_increment, module_id smallint(5) unsigned NOT NULL default '0', function_name varchar(150) default NULL, function_desc text, function_file varchar(255) default NULL, function_admin varchar(255) default NULL, PRIMARY KEY (function_id), KEY module_id (module_id) ); # # Dumping data for table `mx_function` # 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); # -------------------------------------------------------- # # Table structure for table `mx_menu_categories` # CREATE TABLE mx_table_menu_categories ( block_id smallint(5) unsigned NOT NULL default '1', cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100) default NULL, cat_order mediumint(8) unsigned NOT NULL default '0', bbcode_uid varchar(10) default NULL, cat_desc text, cat_show tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (cat_id), KEY cat_order (cat_order) ); # # Dumping data for table `mx_menu_categories` # INSERT INTO mx_table_menu_categories VALUES (8, 1, 'Main Menu', 20, NULL, NULL, 1); # -------------------------------------------------------- # # Table structure for table `mx_menu_nav` # CREATE TABLE mx_table_menu_nav ( menu_id smallint(5) unsigned NOT NULL auto_increment, cat_id mediumint(8) unsigned NOT NULL default '0', menu_name varchar(150) default NULL, menu_desc text, menu_links varchar(255) default NULL, auth_view tinyint(2) NOT NULL default '0', menu_order smallint(5) unsigned default '0', bbcode_uid varchar(10) default NULL, menu_icon varchar(255) default NULL, function_id smallint(5) unsigned default '0', block_id smallint(8) NOT NULL default '0', page_id smallint(5) unsigned default '0', auth_view_group smallint(5) NOT NULL default '0', link_target tinyint(2) unsigned NOT NULL default '0', PRIMARY KEY (menu_id), KEY cat_id (cat_id) ); # # Dumping data for table `mx_menu_nav` # 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); # -------------------------------------------------------- # # Table structure for table `mx_module` # CREATE TABLE mx_table_module ( module_id smallint(5) unsigned NOT NULL auto_increment, module_name varchar(150) default NULL, module_path varchar(255) default NULL, module_desc text, module_include_admin char(1) default '0', PRIMARY KEY (module_id) ); # # Dumping data for table `mx_module` # 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'); # -------------------------------------------------------- # # Table structure for table `mx_page` # CREATE TABLE mx_table_page ( page_id smallint(5) NOT NULL auto_increment, page_name varchar(255) default NULL, page_icon varchar(255) default NULL, auth_view tinyint(2) NOT NULL default '0', auth_view_group smallint(5) NOT NULL default '0', page_header varchar(255) default 'overall_header.tpl', PRIMARY KEY (page_id) ); # # Dumping data for table `mx_page` # 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'); # -------------------------------------------------------- # # Table structure for table `mx_parameter` # CREATE TABLE mx_table_parameter ( parameter_id smallint(5) unsigned NOT NULL auto_increment, function_id smallint(5) unsigned NOT NULL default '0', parameter_name varchar(150) default NULL, parameter_type varchar(30) default NULL, parameter_default varchar(150) default NULL, parameter_function varchar(255) default NULL, PRIMARY KEY (parameter_id) ); # # Dumping data for table `mx_parameter` # 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', ''); # -------------------------------------------------------- # # Table structure for table `mx_parameter_option` # CREATE TABLE mx_table_parameter_option ( option_id smallint(5) unsigned NOT NULL auto_increment, parameter_id smallint(5) unsigned NOT NULL default '0', option_code varchar(150) default NULL, option_desc text, PRIMARY KEY (option_id) ); # # Dumping data for table `mx_parameter_option` # 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'); # -------------------------------------------------------- # # Table structure for table `mx_portal` # CREATE TABLE mx_table_portal ( portal_id smallint(5) unsigned NOT NULL auto_increment, portal_name varchar(150) default NULL, portal_phpbb_url varchar(255) default 'http://www.phpbb.com/phpBB/', portal_url varchar(255) default NULL, portal_version varchar(255) default NULL, top_phpbb_links smallint(5) unsigned NOT NULL default '1', PRIMARY KEY (portal_id) ); Index: mysql_schema_install_2.7.3.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install_2.7.3.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** mysql_schema_install_2.7.3.sql 20 Mar 2005 03:37:05 -0000 1.1 --- mysql_schema_install_2.7.3.sql 20 Mar 2005 04:20:17 -0000 1.2 *************** *** 1,4 **** # ! # mxBB-Portal - MySQL Schema - version 2.7.3 & 2.7.5 # # $Id$ --- 1,4 ---- # ! # mxBB-Portal - MySQL Schema - version 2.7.3 # # $Id$ Index: mysql_schema_install.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** mysql_schema_install.sql 9 Mar 2005 22:46:36 -0000 1.2 --- mysql_schema_install.sql 20 Mar 2005 04:20:17 -0000 1.3 *************** *** 213,218 **** # Dumping data for table `mx_parameter_option` # - 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'); --- 213,216 ---- |
Update of /cvsroot/mxbb/core/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29792 Modified Files: mysql_schema_upgrade_to_2.7.1.sql mysql_schema_upgrade_to_2.706.sql upgrade_schemas_map.php Added Files: mysql_schema_install_2.7.1.sql mysql_schema_install_2.7.2.sql mysql_schema_install_2.7.3.sql mysql_schema_install_2.701.sql mysql_schema_install_2.702.sql mysql_schema_install_2.703.sql mysql_schema_install_2.704.sql mysql_schema_install_2.705.sql mysql_schema_install_2.706.sql mysql_schema_upgrade_to_2.705.sql Removed Files: mysql_schema_upgrade_to_2.704.sql Log Message: Fixed MySQL upgrade schema for 2.705 (it was 2.704). Uploaded previous installation schemas (MySQL). Index: mysql_schema_upgrade_to_2.706.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.706.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** mysql_schema_upgrade_to_2.706.sql 6 Mar 2005 01:18:56 -0000 1.1 --- mysql_schema_upgrade_to_2.706.sql 20 Mar 2005 03:37:05 -0000 1.2 *************** *** 9,13 **** # New Fields in Table `mx_portal` # ! ALTER TABLE mx_table_portal ADD portal_version VARCHAR(255) DEFAULT ''; ALTER TABLE mx_table_portal ADD top_phpbb_links SMALLINT(5) UNSIGNED DEFAULT '1' NOT NULL; --- 9,13 ---- # New Fields in Table `mx_portal` # ! ALTER TABLE mx_table_portal ADD portal_version VARCHAR(255) DEFAULT NULL; ALTER TABLE mx_table_portal ADD top_phpbb_links SMALLINT(5) UNSIGNED DEFAULT '1' NOT NULL; Index: mysql_schema_upgrade_to_2.7.1.sql =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.7.1.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** mysql_schema_upgrade_to_2.7.1.sql 6 Mar 2005 01:18:56 -0000 1.1 --- mysql_schema_upgrade_to_2.7.1.sql 20 Mar 2005 03:37:05 -0000 1.2 *************** *** 15,19 **** # New Fields in Table `mx_page` # ! ALTER TABLE mx_table_page ADD page_header VARCHAR(255) DEFAULT 'overall_header.tpl' NULL; # ------------------------------------------------------------ --- 15,19 ---- # New Fields in Table `mx_page` # ! ALTER TABLE mx_table_page ADD page_header VARCHAR(255) DEFAULT 'overall_header.tpl'; # ------------------------------------------------------------ --- NEW FILE: mysql_schema_install_2.7.3.sql --- # # mxBB-Portal - MySQL Schema - version 2.7.3 & 2.7.5 # # $Id: mysql_schema_install_2.7.3.sql,v 1.1 2005/03/20 03:37:05 markus_petrux Exp $ # # -------------------------------------------------------- # # Table structure for table `mx_block` # CREATE TABLE mx_table_block ( block_id smallint(5) unsigned NOT NULL auto_increment, block_title varchar(150) default NULL, block_desc text, function_id smallint(5) unsigned default NULL, auth_view tinyint(2) NOT NULL default '0', auth_edit tinyint(2) default '0', auth_delete tinyint(2) default '0', auth_view_group smallint(5) NOT NULL default '0', auth_edit_group smallint(5) NOT NULL default '0', auth_delete_group smallint(5) NOT NULL default '0', PRIMARY KEY (block_id) ); # # Dumping data for table `mx_block` # 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); # -------------------------------------------------------- # # Table structure for table `mx_block_system_parameter` # CREATE TABLE mx_table_block_system_parameter ( block_id smallint(5) unsigned NOT NULL default '0', parameter_id smallint(5) unsigned NOT NULL default '0', parameter_value text, bbcode_uid varchar(10) default NULL, PRIMARY KEY (block_id, parameter_id) ); # # Dumping data for table `mx_block_system_parameter` # INSERT INTO mx_table_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_table_block_system_parameter VALUES (2, 60, '3,4,5', ''); INSERT INTO mx_table_block_system_parameter VALUES (2, 61, '33%,*,33%', ''); INSERT INTO mx_table_block_system_parameter VALUES (2, 62, '4', ''); INSERT INTO mx_table_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_table_block_system_parameter VALUES (3, 51, 'none', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 52, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 53, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 54, 'TRUE', ''); INSERT INTO mx_table_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_table_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_table_block_system_parameter VALUES (6, 36, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (6, 13, '0', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 17, '5', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 18, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 19, '30', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 20, '_self', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 21, 'left', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 22, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 37, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 38, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 39, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 40, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 1, '1', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 2, '999', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 3, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 4, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 5, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 7, 'thumb_news.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 8, 'thumb_globe.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 9, 'thumb_globe.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 6, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 10, 'thumb_globe.gif ', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 11, '', NULL); # -------------------------------------------------------- # # Table structure for table `mx_column` # CREATE TABLE mx_table_column ( column_id smallint(5) unsigned NOT NULL auto_increment, column_title varchar(100) default NULL, column_order smallint(5) unsigned NOT NULL default '0', bbcode_uid varchar(10) default NULL, column_size varchar(5) default '100%', page_id smallint(5) NOT NULL default '0', PRIMARY KEY (column_id), KEY cat_order (column_order) ); # # Dumping data for table `mx_column` # 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); # -------------------------------------------------------- # # Table structure for table `mx_column_block` # CREATE TABLE mx_table_column_block ( column_id smallint(5) NOT NULL default '0', block_id smallint(5) NOT NULL default '0', block_order smallint(5) NOT NULL default '0' ); # # Dumping data for table `mx_column_block` # 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); # -------------------------------------------------------- # # Table structure for table `mx_function` # CREATE TABLE mx_table_function ( function_id smallint(5) unsigned NOT NULL auto_increment, module_id smallint(5) unsigned NOT NULL default '0', function_name varchar(150) default NULL, function_desc text, function_file varchar(255) default NULL, function_admin varchar(255) default NULL, PRIMARY KEY (function_id), KEY module_id (module_id) ); # # Dumping data for table `mx_function` # 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); # -------------------------------------------------------- # # Table structure for table `mx_menu_categories` # CREATE TABLE mx_table_menu_categories ( block_id smallint(5) unsigned NOT NULL default '1', cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100) default NULL, cat_order mediumint(8) unsigned NOT NULL default '0', bbcode_uid varchar(10) default NULL, cat_desc text, cat_show tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (cat_id), KEY cat_order (cat_order) ); # # Dumping data for table `mx_menu_categories` # INSERT INTO mx_table_menu_categories VALUES (8, 1, 'Main Menu', 20, NULL, NULL, 1); # -------------------------------------------------------- # # Table structure for table `mx_menu_nav` # CREATE TABLE mx_table_menu_nav ( menu_id smallint(5) unsigned NOT NULL auto_increment, cat_id mediumint(8) unsigned NOT NULL default '0', menu_name varchar(150) default NULL, menu_desc text, menu_links varchar(255) default NULL, auth_view tinyint(2) NOT NULL default '0', menu_order smallint(5) unsigned default '0', bbcode_uid varchar(10) default NULL, menu_icon varchar(255) default NULL, function_id smallint(5) unsigned default '0', block_id smallint(8) NOT NULL default '0', page_id smallint(5) unsigned default '0', auth_view_group smallint(5) NOT NULL default '0', link_target tinyint(2) unsigned NOT NULL default '0', PRIMARY KEY (menu_id), KEY cat_id (cat_id) ); # # Dumping data for table `mx_menu_nav` # 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); # -------------------------------------------------------- # # Table structure for table `mx_module` # CREATE TABLE mx_table_module ( module_id smallint(5) unsigned NOT NULL auto_increment, module_name varchar(150) default NULL, module_path varchar(255) default NULL, module_desc text, module_include_admin char(1) default '0', PRIMARY KEY (module_id) ); # # Dumping data for table `mx_module` # 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'); # -------------------------------------------------------- # # Table structure for table `mx_page` # CREATE TABLE mx_table_page ( page_id smallint(5) NOT NULL auto_increment, page_name varchar(255) default NULL, page_icon varchar(255) default NULL, auth_view tinyint(2) NOT NULL default '0', auth_view_group smallint(5) NOT NULL default '0', page_header varchar(255) default 'overall_header.tpl', PRIMARY KEY (page_id) ); # # Dumping data for table `mx_page` # 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'); # -------------------------------------------------------- # # Table structure for table `mx_parameter` # CREATE TABLE mx_table_parameter ( parameter_id smallint(5) unsigned NOT NULL auto_increment, function_id smallint(5) unsigned NOT NULL default '0', parameter_name varchar(150) default NULL, parameter_type varchar(30) default NULL, parameter_default varchar(150) default NULL, parameter_function varchar(255) default NULL, PRIMARY KEY (parameter_id) ); # # Dumping data for table `mx_parameter` # 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', ''); # -------------------------------------------------------- # # Table structure for table `mx_parameter_option` # CREATE TABLE mx_table_parameter_option ( option_id smallint(5) unsigned NOT NULL auto_increment, parameter_id smallint(5) unsigned NOT NULL default '0', option_code varchar(150) default NULL, option_desc text, PRIMARY KEY (option_id) ); # # Dumping data for table `mx_parameter_option` # 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'); # -------------------------------------------------------- # # Table structure for table `mx_portal` # CREATE TABLE mx_table_portal ( portal_id smallint(5) unsigned NOT NULL auto_increment, portal_name varchar(150) default NULL, portal_phpbb_url varchar(255) default 'http://www.phpbb.com/phpBB/', portal_url varchar(255) default NULL, portal_version varchar(255) default NULL, top_phpbb_links smallint(5) unsigned NOT NULL default '1', PRIMARY KEY (portal_id) ); --- NEW FILE: mysql_schema_install_2.7.1.sql --- # # mxBB-Portal - MySQL Schema - version 2.7.1 # # $Id: mysql_schema_install_2.7.1.sql,v 1.1 2005/03/20 03:37:05 markus_petrux Exp $ # # -------------------------------------------------------- # # Table structure for table `mx_block` # CREATE TABLE mx_table_block ( block_id smallint(5) unsigned NOT NULL auto_increment, block_title varchar(150) default NULL, block_desc text, function_id smallint(5) unsigned default NULL, auth_view tinyint(2) NOT NULL default '0', auth_edit tinyint(2) default '0', auth_delete tinyint(2) default '0', auth_view_group smallint(5) NOT NULL default '0', auth_edit_group smallint(5) NOT NULL default '0', auth_delete_group smallint(5) NOT NULL default '0', PRIMARY KEY (block_id) ); # # Dumping data for table `mx_block` # 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); # -------------------------------------------------------- # # Table structure for table `mx_block_system_parameter` # CREATE TABLE mx_table_block_system_parameter ( block_id smallint(5) unsigned NOT NULL default '0', parameter_id smallint(5) unsigned NOT NULL default '0', parameter_value text, bbcode_uid varchar(10) default NULL, PRIMARY KEY (block_id, parameter_id) ); # # Dumping data for table `mx_block_system_parameter` # INSERT INTO mx_table_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_table_block_system_parameter VALUES (2, 60, '3,4,5', ''); INSERT INTO mx_table_block_system_parameter VALUES (2, 61, '33%,*,33%', ''); INSERT INTO mx_table_block_system_parameter VALUES (2, 62, '4', ''); INSERT INTO mx_table_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_table_block_system_parameter VALUES (3, 51, 'none', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 52, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 53, 'TRUE', ''); INSERT INTO mx_table_block_system_parameter VALUES (3, 54, 'TRUE', ''); INSERT INTO mx_table_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_table_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_table_block_system_parameter VALUES (6, 36, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (6, 13, '0', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 17, '5', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 18, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 19, '30', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 20, '_self', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 21, 'left', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 22, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 37, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 38, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 39, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 40, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 1, '1', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 2, '999', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 3, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 4, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 5, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 7, 'thumb_news.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 8, 'thumb_globe.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 9, 'thumb_globe.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 6, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 10, 'thumb_globe.gif ', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 11, '', NULL); # -------------------------------------------------------- # # Table structure for table `mx_column` # CREATE TABLE mx_table_column ( column_id smallint(5) unsigned NOT NULL auto_increment, column_title varchar(100) default NULL, column_order smallint(5) unsigned NOT NULL default '0', bbcode_uid varchar(10) default NULL, column_size varchar(5) default '100%', page_id smallint(5) NOT NULL default '0', PRIMARY KEY (column_id), KEY cat_order (column_order) ); # # Dumping data for table `mx_column` # 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); # -------------------------------------------------------- # # Table structure for table `mx_column_block` # CREATE TABLE mx_table_column_block ( column_id smallint(5) NOT NULL default '0', block_id smallint(5) NOT NULL default '0', block_order smallint(5) NOT NULL default '0' ); # # Dumping data for table `mx_column_block` # 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); # -------------------------------------------------------- # # Table structure for table `mx_function` # CREATE TABLE mx_table_function ( function_id smallint(5) unsigned NOT NULL auto_increment, module_id smallint(5) unsigned NOT NULL default '0', function_name varchar(150) default NULL, function_desc text, function_file varchar(255) default NULL, function_admin varchar(255) default NULL, PRIMARY KEY (function_id), KEY module_id (module_id) ); # # Dumping data for table `mx_function` # 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); # -------------------------------------------------------- # # Table structure for table `mx_menu_categories` # CREATE TABLE mx_table_menu_categories ( block_id smallint(5) unsigned NOT NULL default '1', cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100) default NULL, cat_order mediumint(8) unsigned NOT NULL default '0', bbcode_uid varchar(10) default NULL, cat_desc text, cat_show tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (cat_id), KEY cat_order (cat_order) ); # # Dumping data for table `mx_menu_categories` # INSERT INTO mx_table_menu_categories VALUES (8, 1, 'Main Menu', 20, NULL, NULL, 1); # -------------------------------------------------------- # # Table structure for table `mx_menu_nav` # CREATE TABLE mx_table_menu_nav ( menu_id smallint(5) unsigned NOT NULL auto_increment, cat_id mediumint(8) unsigned NOT NULL default '0', menu_name varchar(150) default NULL, menu_desc text, menu_links varchar(255) default NULL, auth_view tinyint(2) NOT NULL default '0', menu_order smallint(5) unsigned default '0', bbcode_uid varchar(10) default NULL, menu_icon varchar(255) default NULL, function_id smallint(5) unsigned default '0', block_id smallint(8) NOT NULL default '0', page_id smallint(5) unsigned default '0', auth_view_group smallint(5) NOT NULL default '0', link_target tinyint(2) unsigned NOT NULL default '0', PRIMARY KEY (menu_id), KEY cat_id (cat_id) ); # # Dumping data for table `mx_menu_nav` # 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); # -------------------------------------------------------- # # Table structure for table `mx_module` # CREATE TABLE mx_table_module ( module_id smallint(5) unsigned NOT NULL auto_increment, module_name varchar(150) default NULL, module_path varchar(255) default NULL, module_desc text, module_include_admin char(1) default '0', PRIMARY KEY (module_id) ); # # Dumping data for table `mx_module` # 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'); # -------------------------------------------------------- # # Table structure for table `mx_page` # CREATE TABLE mx_table_page ( page_id smallint(5) NOT NULL auto_increment, page_name varchar(255) default NULL, page_icon varchar(255) default NULL, auth_view tinyint(2) NOT NULL default '0', auth_view_group smallint(5) NOT NULL default '0', page_header varchar(255) default 'overall_header.tpl', PRIMARY KEY (page_id) ); # # Dumping data for table `mx_page` # 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'); # -------------------------------------------------------- # # Table structure for table `mx_parameter` # CREATE TABLE mx_table_parameter ( parameter_id smallint(5) unsigned NOT NULL auto_increment, function_id smallint(5) unsigned NOT NULL default '0', parameter_name varchar(150) default NULL, parameter_type varchar(30) default NULL, parameter_default varchar(150) default NULL, parameter_function varchar(255) default NULL, PRIMARY KEY (parameter_id) ); # # Dumping data for table `mx_parameter` # 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', ''); # -------------------------------------------------------- # # Table structure for table `mx_parameter_option` # CREATE TABLE mx_table_parameter_option ( option_id smallint(5) unsigned NOT NULL auto_increment, parameter_id smallint(5) unsigned NOT NULL default '0', option_code varchar(150) default NULL, option_desc text, PRIMARY KEY (option_id) ); # # Dumping data for table `mx_parameter_option` # 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'); # -------------------------------------------------------- # # Table structure for table `mx_portal` # CREATE TABLE mx_table_portal ( portal_id smallint(5) unsigned NOT NULL auto_increment, portal_name varchar(150) default NULL, portal_phpbb_url varchar(255) default 'http://www.phpbb.com/phpBB/', portal_url varchar(255) default NULL, portal_version varchar(255) default NULL, top_phpbb_links smallint(5) unsigned NOT NULL default '1', PRIMARY KEY (portal_id) ); --- mysql_schema_upgrade_to_2.704.sql DELETED --- Index: upgrade_schemas_map.php =================================================================== RCS file: /cvsroot/mxbb/core/install/schemas/upgrade_schemas_map.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** upgrade_schemas_map.php 9 Mar 2005 23:39:04 -0000 1.3 --- upgrade_schemas_map.php 20 Mar 2005 03:37:05 -0000 1.4 *************** *** 37,41 **** $upgrade_schemas_map = array( ! array('schema' => 'upgrade_to_2.704' , 'sql' => "SELECT auth_view FROM mx_table_page"), array('schema' => 'upgrade_to_2.706' , 'sql' => "SELECT portal_version FROM mx_table_portal"), array('schema' => 'upgrade_to_2.7.1' , 'sql' => "SELECT link_target FROM mx_table_menu_nav"), --- 37,41 ---- $upgrade_schemas_map = array( ! array('schema' => 'upgrade_to_2.705' , 'sql' => "SELECT auth_view FROM mx_table_page"), array('schema' => 'upgrade_to_2.706' , 'sql' => "SELECT portal_version FROM mx_table_portal"), array('schema' => 'upgrade_to_2.7.1' , 'sql' => "SELECT link_target FROM mx_table_menu_nav"), *************** *** 49,53 **** // -------------------- // DEBUG ONLY ;-) ! //echo(var_export($upgrade_schemas_map)); // -------------------- --- 49,54 ---- // -------------------- // DEBUG ONLY ;-) ! // ! //echo('upgrade_schemas_map: '.var_export($upgrade_schemas_map, true)."<br />\n"); // -------------------- --- NEW FILE: mysql_schema_install_2.703.sql --- # # mxBB-Portal - MySQL Schema - version 2.703 # # $Id: mysql_schema_install_2.703.sql,v 1.1 2005/03/20 03:37:05 markus_petrux Exp $ # # -------------------------------------------------------- # # Table structure for table `mx_block` # CREATE TABLE mx_table_block ( block_id smallint(5) unsigned NOT NULL auto_increment, block_title varchar(150) default NULL, block_desc text, function_id smallint(5) unsigned default NULL, auth_view tinyint(2) NOT NULL default '0', auth_edit tinyint(2) default '0', auth_delete tinyint(2) default '0', PRIMARY KEY (block_id) ); # # Dumping data for table `mx_block` # INSERT INTO mx_table_block VALUES (1, 'Welcome', '', 10, 0, 5, 0); INSERT INTO mx_table_block VALUES (4, 'Navigation Menu', '', 30, 0, 5, 0); INSERT INTO mx_table_block VALUES (5, 'Poll', '', 40, 0, 5, 0); INSERT INTO mx_table_block VALUES (7, 'Language', '', 50, 99, 5, 0); INSERT INTO mx_table_block VALUES (13, 'Login', NULL, 80, 99, 5, 0); INSERT INTO mx_table_block VALUES (14, 'Theme', '', 90, 0, 5, 0); INSERT INTO mx_table_block VALUES (16, 'Last Message', NULL, 170, 0, 0, 0); INSERT INTO mx_table_block VALUES (21, 'Google', '', 100, 0, 0, 0); INSERT INTO mx_table_block VALUES (18, 'Announcement', NULL, 110, 0, 0, 0); INSERT INTO mx_table_block VALUES (19, 'Online', '', 120, 0, 0, 0); INSERT INTO mx_table_block VALUES (24, 'Forum', '', 20, 0, 0, 0); INSERT INTO mx_table_block VALUES (32, 'Statistics', '', 190, 0, 0, 0); # -------------------------------------------------------- # # Table structure for table `mx_block_system_parameter` # CREATE TABLE mx_table_block_system_parameter ( block_id smallint(5) unsigned NOT NULL default '0', parameter_id smallint(5) unsigned NOT NULL auto_increment, parameter_value text, bbcode_uid varchar(10) default NULL, PRIMARY KEY (block_id, parameter_id) ); # # Dumping data for table `mx_block_system_parameter` # INSERT INTO mx_table_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\nThis 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_system_parameter VALUES (5, 36, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (5, 13, '0', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 17, '5', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 18, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 19, '30', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 20, '_self', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 21, 'left', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 22, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 37, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 38, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 39, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 40, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 1, '1', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 2, '999', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 3, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 4, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 5, 'FALSE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 7, './images/news_02.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 8, './images/globe7.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 9, './images/globe7.gif', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 6, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 10, './images/globe7.gif ', NULL); INSERT INTO mx_table_block_system_parameter VALUES (18, 11, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (35, 15, 'Insert your text here', NULL); # -------------------------------------------------------- # # Table structure for table `mx_block_user_parameter` # CREATE TABLE mx_table_block_user_parameter ( block_id smallint(5) unsigned NOT NULL default '0', parameter_id smallint(5) unsigned NOT NULL auto_increment, parameter_value text, PRIMARY KEY (block_id, parameter_id) ); # # Dumping data for table `mx_block_user_parameter` # # -------------------------------------------------------- # # Table structure for table `mx_column` # CREATE TABLE mx_table_column ( column_id smallint(5) unsigned NOT NULL auto_increment, column_title varchar(100) default NULL, column_order smallint(5) unsigned NOT NULL default '0', bbcode_uid varchar(10) default NULL, column_size varchar(5) default '100%', page_id smallint(5) NOT NULL default '0', PRIMARY KEY (column_id), KEY cat_order (column_order) ); # # Dumping data for table `mx_column` # 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); # -------------------------------------------------------- # # Table structure for table `mx_column_block` # CREATE TABLE mx_table_column_block ( column_id smallint(5) NOT NULL default '0', block_id smallint(5) NOT NULL default '0', block_order smallint(5) NOT NULL default '0' ); # # Dumping data for table `mx_column_block` # INSERT INTO mx_table_column_block VALUES (1, 4, 10); INSERT INTO mx_table_column_block VALUES (1, 16, 20); INSERT INTO mx_table_column_block VALUES (1, 5, 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, 18, 20); INSERT INTO mx_table_column_block VALUES (2, 19, 30); INSERT INTO mx_table_column_block VALUES (20, 4, 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); # -------------------------------------------------------- # # Table structure for table `mx_function` # CREATE TABLE mx_table_function ( function_id smallint(5) unsigned NOT NULL auto_increment, module_id smallint(5) unsigned NOT NULL default '0', function_name varchar(150) default NULL, function_desc text, function_file varchar(255) default NULL, function_admin varchar(255) default NULL, PRIMARY KEY (function_id), KEY module_id (module_id) ); # # Dumping data for table `mx_function` # INSERT INTO mx_table_function VALUES (10, 10, 'Block', 'Block', 'mx_block.php', 'admin/admin_mx_block_edit.php'); INSERT INTO mx_table_function VALUES (20, 10, 'Forum', 'Forum', 'mx_forum.php', NULL); INSERT INTO mx_table_function VALUES (30, 10, 'Menu Navigation', 'Menu Navigation', 'mx_menu_nav.php', 'admin/admin_mx_menu.php'); INSERT INTO mx_table_function VALUES (40, 10, 'Poll', 'Poll', 'mx_poll.php', NULL); INSERT INTO mx_table_function VALUES (50, 10, 'Language', 'Language', 'mx_language.php', NULL); INSERT INTO mx_table_function VALUES (70, 10, 'Block Html', 'Block Html', 'mx_block_html.php', NULL); INSERT INTO mx_table_function VALUES (80, 10, 'Login', 'Login', 'mx_login.php', NULL); INSERT INTO mx_table_function VALUES (90, 10, 'Theme', 'Theme', 'mx_theme.php', NULL); INSERT INTO mx_table_function VALUES (100, 10, 'Google', 'Google', 'mx_google.php', NULL); INSERT INTO mx_table_function VALUES (110, 10, 'Announcement', 'Announcement', 'mx_announce.php', NULL); INSERT INTO mx_table_function VALUES (120, 10, 'Who is Online', 'Who is Online', 'mx_online.php', NULL); INSERT INTO mx_table_function VALUES (170, 50, 'Last Message', 'Last Message', 'mx_last_msg.php', NULL); INSERT INTO mx_table_function VALUES (190, 70, 'Statistics', 'Statistics Module', 'mx_statistics.php', NULL); # -------------------------------------------------------- # # Table structure for table `mx_menu_categories` # CREATE TABLE mx_table_menu_categories ( block_id smallint(5) unsigned NOT NULL default '1', cat_id mediumint(8) unsigned NOT NULL auto_increment, cat_title varchar(100) default NULL, cat_order mediumint(8) unsigned NOT NULL default '0', bbcode_uid varchar(10) default NULL, cat_desc text, PRIMARY KEY (cat_id), KEY cat_order (cat_order) ); # # Dumping data for table `mx_menu_categories` # INSERT INTO mx_table_menu_categories VALUES (4, 1, 'Main Menu', 20, NULL, NULL); # -------------------------------------------------------- # # Table structure for table `mx_menu_nav` # CREATE TABLE mx_table_menu_nav ( menu_id smallint(5) unsigned NOT NULL auto_increment, cat_id mediumint(8) unsigned NOT NULL default '0', menu_name varchar(150) default NULL, menu_desc text, menu_links varchar(255) default NULL, auth_view tinyint(2) NOT NULL default '0', menu_order smallint(5) unsigned default '0', bbcode_uid varchar(10) default NULL, menu_icon varchar(255) default NULL, function_id smallint(5) unsigned default '0', block_id smallint(8) NOT NULL default '0', PRIMARY KEY (menu_id), KEY cat_id (cat_id) ); # # Dumping data for table `mx_menu_nav` # INSERT INTO mx_table_menu_nav VALUES (1, 1, 'Home Page', 'Home Page', 'index.php', 0, 10, 'bc5d5e65eb', 'icon_home.gif', 0, 0); INSERT INTO mx_table_menu_nav VALUES (2, 1, 'Forum', 'Forum', 'index.php?page=2', 0, 20, '1a7e19f246', 'icon_help.gif', 0, 0); INSERT INTO mx_table_menu_nav VALUES (6, 1, 'Statistics', 'Module Statistics', '', 0, 60, 'e16b0fbb51', 'icon_poll.gif', 190, 0); # -------------------------------------------------------- # # Table structure for table `mx_module` # CREATE TABLE mx_table_module ( module_id smallint(5) unsigned NOT NULL auto_increment, module_name varchar(150) default NULL, module_path varchar(255) default NULL, module_desc text, module_include_admin char(1) default '0', PRIMARY KEY (module_id) ); # # Dumping data for table `mx_module` # INSERT INTO mx_table_module VALUES (10, 'Standard', './', 'Module standard', ''); INSERT INTO mx_table_module VALUES (50, 'Last Message', 'modules/mx_last_msg/', 'Last Message Module', '0'); INSERT INTO mx_table_module VALUES (70, 'Statistics', 'modules/mx_statistics/', 'Statistics Modules', '0'); # -------------------------------------------------------- # # Table structure for table `mx_page` # CREATE TABLE mx_table_page ( page_id smallint(5) NOT NULL auto_increment, page_name varchar(255) default NULL, page_icon varchar(255) default NULL, PRIMARY KEY (page_id) ); # # Dumping data for table `mx_page` # INSERT INTO mx_table_page VALUES (1, 'Portal', 'home.jpg'); INSERT INTO mx_table_page VALUES (2, 'Forum', 'forum.jpg'); # -------------------------------------------------------- # # Table structure for table `mx_parameter` # CREATE TABLE mx_table_parameter ( parameter_id smallint(5) unsigned NOT NULL auto_increment, function_id smallint(5) unsigned NOT NULL default '0', parameter_name varchar(150) default NULL, parameter_type varchar(30) default NULL, parameter_default varchar(150) default NULL, parameter_function varchar(255) default NULL, PRIMARY KEY (parameter_id) ); # # Dumping data for table `mx_parameter` # INSERT INTO mx_table_parameter VALUES (1, 110, 'announce_nbr_display', 'Number', '1', NULL); INSERT INTO mx_table_parameter VALUES (2, 110, 'announce_nbr_days', 'Number', '14', NULL); INSERT INTO mx_table_parameter VALUES (3, 110, 'announce_display', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (4, 110, 'announce_display_sticky', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (5, 110, 'announce_display_normal', 'Boolean', 'FALSE', NULL); INSERT INTO mx_table_parameter VALUES (7, 110, 'announce_img', 'Text', './images/globe7.gif', NULL); INSERT INTO mx_table_parameter VALUES (8, 110, 'announce_img_sticky', 'Text', './images/globe7.gif', NULL); INSERT INTO mx_table_parameter VALUES (9, 110, 'announce_img_normal', 'Text', './images/globe7.gif', NULL); INSERT INTO mx_table_parameter VALUES (6, 110, 'announce_display_global', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (10, 110, 'announce_img_global', 'Text', './images/globe7.gif', NULL); INSERT INTO mx_table_parameter VALUES (11, 110, '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, 40, 'Poll_Display', 'Function', '0', 'poll_select( {parameter_value}, "{parameter_id}" )'); INSERT INTO mx_table_parameter VALUES (15, 10, 'Text', 'BBText', 'Insert your text here', NULL); INSERT INTO mx_table_parameter VALUES (16, 70, 'Html', 'Html', 'Entre your Html code here', NULL); INSERT INTO mx_table_parameter VALUES (17, 170, 'Last_Msg_Number_Title', 'Number', '15', NULL); INSERT INTO mx_table_parameter VALUES (18, 170, 'Last_Msg_Display_Date', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (19, 170, 'Last_Msg_Title_Length', 'Number', '30', NULL); INSERT INTO mx_table_parameter VALUES (20, 170, 'Last_Msg_Target', 'Values', '_blank', NULL); INSERT INTO mx_table_parameter VALUES (21, 170, 'Last_Msg_Align', 'Values', 'left', NULL); INSERT INTO mx_table_parameter VALUES (22, 170, 'Last_Msg_Display_Forum', 'Boolean', 'TRUE', NULL); INSERT INTO mx_table_parameter VALUES (37, 170, '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, 170, 'Last_Msg_Display_Last_Author', 'Boolean', 'FALSE', ''); INSERT INTO mx_table_parameter VALUES (39, 170, 'Last_Msg_Display_Author', 'Boolean', 'FALSE', ''); INSERT INTO mx_table_parameter VALUES (40, 170, 'Last_Msg_Display_Icon_View', 'Boolean', 'FALSE', ''); INSERT INTO mx_table_parameter VALUES (36, 40, 'poll_forum', 'Function', '', 'get_list_multiple("{parameter_id}[]", FORUMS_TABLE, \'forum_id\', \'forum_name\', "{parameter_value}", TRUE)'); # -------------------------------------------------------- # # Table structure for table `mx_parameter_option` # CREATE TABLE mx_table_parameter_option ( option_id smallint(5) unsigned NOT NULL auto_increment, parameter_id smallint(5) unsigned NOT NULL default '0', option_code varchar(150) default NULL, option_desc text, PRIMARY KEY (option_id) ); # # Dumping data for table `mx_parameter_option` # 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'); # -------------------------------------------------------- # # Table structure for table `mx_portal` # CREATE TABLE mx_table_portal ( portal_id smallint(5) unsigned NOT NULL auto_increment, portal_name varchar(150) default NULL, portal_phpbb_url varchar(255) default 'http://www.phpbb.com/phpBB/', portal_url varchar(255) default NULL, PRIMARY KEY (portal_id) ); --- NEW FILE: mysql_schema_install_2.705.sql --- # # mxBB-Portal - MySQL Schema - version 2.705 # # $Id: mysql_schema_install_2.705.sql,v 1.1 2005/03/20 03:37:05 markus_petrux Exp $ # # -------------------------------------------------------- # # Table structure for table `mx_block` # CREATE TABLE mx_table_block ( block_id smallint(5) unsigned NOT NULL auto_increment, block_title varchar(150) default NULL, block_desc text, function_id smallint(5) unsigned default NULL, auth_view tinyint(2) NOT NULL default '0', auth_edit tinyint(2) default '0', auth_delete tinyint(2) default '0', PRIMARY KEY (block_id) ); # # Dumping data for table `mx_block` # INSERT INTO mx_table_block VALUES (1, 'Welcome', '', 10, 0, 5, 0); INSERT INTO mx_table_block VALUES (4, 'Navigation Menu', '', 30, 0, 5, 0); INSERT INTO mx_table_block VALUES (5, 'Poll', '', 40, 0, 5, 0); INSERT INTO mx_table_block VALUES (7, 'Language', '', 50, 99, 5, 0); INSERT INTO mx_table_block VALUES (13, 'Login', NULL, 80, 99, 5, 0); INSERT INTO mx_table_block VALUES (14, 'Theme', '', 90, 0, 5, 0); INSERT INTO mx_table_block VALUES (16, 'Last Message', NULL, 170, 0, 0, 0); INSERT INTO mx_table_block VALUES (21, 'Google', '', 100, 0, 0, 0); INSERT INTO mx_table_block VALUES (18, 'Announcement', NULL, 110, 0, 0, 0); INSERT INTO mx_table_block VALUES (19, 'Online', '', 120, 0, 0, 0); INSERT INTO mx_table_block VALUES (24, 'Forum', '', 20, 0, 0, 0); INSERT INTO mx_table_block VALUES (32, 'Statistics', '', 190, 0, 0, 0); # -------------------------------------------------------- # # Table structure for table `mx_block_system_parameter` # CREATE TABLE mx_table_block_system_parameter ( block_id smallint(5) unsigned NOT NULL default '0', parameter_id smallint(5) unsigned NOT NULL default '0', parameter_value text, bbcode_uid varchar(10) default NULL, PRIMARY KEY (block_id, parameter_id) ); # # Dumping data for table `mx_block_system_parameter` # INSERT INTO mx_table_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\nThis 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_system_parameter VALUES (5, 36, '', NULL); INSERT INTO mx_table_block_system_parameter VALUES (5, 13, '0', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 17, '5', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 18, 'TRUE', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 19, '30', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 20, '_self', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 21, 'left', NULL); INSERT INTO mx_table_block_system_parameter VALUES (16, 22, 'TRUE', NULL); INSERT INTO mx_table_block_system_paramet... [truncated message content] |
|
From: Markus P. <mar...@us...> - 2005-03-18 22:11:21
|
Update of /cvsroot/mxbb/core/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22136 Modified Files: index.php Log Message: Testing the mailing list. ;-) Index: index.php =================================================================== RCS file: /cvsroot/mxbb/core/install/index.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** index.php 2 Jul 2003 19:50:18 -0000 1.1 --- index.php 18 Mar 2005 22:11:06 -0000 1.2 *************** *** 1,8 **** ! <HEAD> ! <SCRIPT language="JavaScript"> ! <!-- window.location="mx_install.php"; ! //--> ! </SCRIPT> ! </HEAD> ! --- 1,7 ---- ! <html> ! <head> ! <script language="javascript" type="text/javascript"><!-- window.location="mx_install.php"; ! //--></script> ! </head> ! </html> \ No newline at end of file |
|
From: Markus P. <mar...@us...> - 2005-03-18 21:59:16
|
Update of /cvsroot/mxbb/core/install In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15295 Modified Files: mx_install_readme.htm Log Message: Testing the mailing list. ;-) Index: mx_install_readme.htm =================================================================== RCS file: /cvsroot/mxbb/core/install/mx_install_readme.htm,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** mx_install_readme.htm 22 May 2004 22:23:09 -0000 1.6 --- mx_install_readme.htm 18 Mar 2005 21:59:07 -0000 1.7 *************** *** 207,218 **** --> </style> - <script language="Javascript" type="text/javascript"> - <!-- - if ( 0 ) - { - window.open('privmsg.php?mode=newpm', '_phpbbprivmsg', 'HEIGHT=225,resizable=yes,WIDTH=400');; - } - //--> - </script> </head> --- 207,210 ---- |
|
From: Jon O. <jon...@us...> - 2005-03-18 21:32:43
|
Update of /cvsroot/mxbb/mx_act In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1878/modules/mx_act Modified Files: db_install.php Log Message: testing the maillist ;) Index: db_install.php =================================================================== RCS file: /cvsroot/mxbb/mx_act/db_install.php,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** db_install.php 6 Mar 2005 01:11:40 -0000 1.6 --- db_install.php 18 Mar 2005 21:32:23 -0000 1.7 *************** *** 60,63 **** --- 60,64 ---- define( "iNA_SCORES", $mx_table_prefix . 'ina_scores' ); define( "iNA_GAMES", $mx_table_prefix . 'ina_games' ); + // If fresh install if ( !$result = $db->sql_query( "SELECT config_name from " . $mx_table_prefix . "ina_data" ) ) |
|
From: Jon O. <jon...@us...> - 2005-03-18 21:04:45
|
Update of /cvsroot/mxbb/mx_linkdb In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19559/modules/mx_linkdb Modified Files: db_upgrade.php Log Message: testing the maillist ;) removing REPLACE INTO and adding missing ?> Index: db_upgrade.php =================================================================== RCS file: /cvsroot/mxbb/mx_linkdb/db_upgrade.php,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** db_upgrade.php 6 Mar 2005 01:12:41 -0000 1.3 --- db_upgrade.php 18 Mar 2005 21:04:05 -0000 1.4 *************** *** 129,132 **** --- 129,134 ---- $sql[] = "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('news_sort', 'Alphabetic')"; $sql[] = "INSERT INTO " . $mx_table_prefix . "kb_config VALUES ('news_sort_par', 'ASC')"; + + /* // Now add some new parameters // First get function_id *************** *** 164,167 **** --- 166,170 ---- $sql[] = "UPDATE " . $mx_table_prefix . "function SET function_admin = 'modules/mx_kb/admin/kb_config.php' WHERE function_id = '" . $function_id . "' OR function_file = 'kb.php'"; + */ } else |
|
From: Jon O. <jon...@us...> - 2005-03-18 21:04:30
|
Update of /cvsroot/mxbb/mx_linkdb/linkdb/includes In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19559/modules/mx_linkdb/linkdb/includes Modified Files: functions.php Log Message: testing the maillist ;) removing REPLACE INTO and adding missing ?> Index: functions.php =================================================================== RCS file: /cvsroot/mxbb/mx_linkdb/linkdb/includes/functions.php,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** functions.php 9 Jan 2005 21:42:01 -0000 1.1 --- functions.php 18 Mar 2005 21:04:06 -0000 1.2 *************** *** 160,161 **** --- 160,162 ---- } } + ?> \ No newline at end of file |
2 messages has been excluded from this view by a project administrator.
