mxbb-commits — Internal Mailing List for CVS Commit Messages

[mxbb-commits] core/modules/mx_rebuild_search_tables db_install.php, NONE, 1.1 db_upgrade.php, NONE, 1.1

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core/modules/mx_rebuild_search_tables
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv1524

Added Files:
	db_install.php db_upgrade.php 
Log Message:
added

--- NEW FILE: db_install.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_phpbb2admin
* @version $Id: db_install.php,v 1.1 2007/07/23 22:29:01 jonohlsson Exp $
* @copyright (c) 2002-2006 [menalto.gallery.com, Jon Ohlsson] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
* @link http://www.mxbb.net
*
*/

define( 'IN_PORTAL', true );

if ( !defined( 'IN_ADMIN' ) )
{
	$mx_root_path = './../../';
	$phpEx = substr(strrchr(__FILE__, '.'), 1);
	include( $mx_root_path . 'common.' . $phpEx );
	// Start session management
	$mx_user->init($user_ip, PAGE_INDEX);

	if ( !$userdata['session_logged_in'] )
	{
		die( "Hacking attempt(1)" );
	}

	if ( $userdata['user_level'] != ADMIN )
	{
		die( "Hacking attempt(2)" );
	}
	// End session management
}

$mx_module_version = 'mxBB Core Module';
$mx_module_copy = 'Original phpBB <i>Rebuild Search Tables</i> by the phpBB Team :: Adapted for mxBB by <a href="http://www.mxbb.net" target="_blank">Jon</a>';

$message = "<b>This is a fresh install!</b><br/><br/>";

$sql = array();

$sql[] = "UPDATE " . $mx_table_prefix . "module" . "
			    SET module_version  = '" . $mx_module_version . "',
			      module_copy  = '" . $mx_module_copy . "'
			    WHERE module_id = '" . $mx_module_id . "'";

$message .= mx_do_install_upgrade( $sql );

echo "<br /><br />";
echo "<table  width=\"90%\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">";
echo "<tr><th class=\"thHead\" align=\"center\">Module Installation/Upgrading/Uninstalling Information - module specific db tables</th></tr>";
echo "<tr><td class=\"row1\"  align=\"left\"><span class=\"gen\">" . $message . "</span></td></tr>";
echo "</table><br />";
?>

--- NEW FILE: db_upgrade.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_phpbb2admin
* @version $Id: db_upgrade.php,v 1.1 2007/07/23 22:29:01 jonohlsson Exp $
* @copyright (c) 2002-2006 [menalto.gallery.com, Jon Ohlsson] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
* @link http://www.mxbb.net
*
*/

define( 'IN_PORTAL', true );

if ( !defined( 'IN_ADMIN' ) )
{
	$mx_root_path = './../../';
	$phpEx = substr(strrchr(__FILE__, '.'), 1);
	include( $mx_root_path . 'common.' . $phpEx );
	// Start session management
	$mx_user->init($user_ip, PAGE_INDEX);

	if ( !$userdata['session_logged_in'] )
	{
		die( "Hacking attempt(1)" );
	}

	if ( $userdata['user_level'] != ADMIN )
	{
		die( "Hacking attempt(2)" );
	}
	// End session management
}

$mx_module_version = 'mxBB Core Module';
$mx_module_copy = 'Original phpBB <i>Rebuild Search Tables</i> by the phpBB Team :: Adapted for mxBB by <a href="http://www.mxbb.net" target="_blank">Jon</a>';

$message = "<b>Upgrading!</b><br/><br/>";

$sql = array();

$sql[] = "UPDATE " . $mx_table_prefix . "module" . "
			    SET module_version  = '" . $mx_module_version . "',
			      module_copy  = '" . $mx_module_copy . "'
			    WHERE module_id = '" . $mx_module_id . "'";

$message .= mx_do_install_upgrade( $sql );
$message .= "<b>...Now upgraded to v. $mx_module_version :-)</b><br/><br/>";

echo "<br /><br />";
echo "<table  width=\"90%\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">";
echo "<tr><th class=\"thHead\" align=\"center\">Module Installation/Upgrading/Uninstalling Information - module specific db tables</th></tr>";
echo "<tr><td class=\"row1\"  align=\"left\"><span class=\"gen\">" . $message . "</span></td></tr>";
echo "</table><br />";

?>

[mxbb-commits] mx_newssuite/includes newssuite_constants.php, 1.20, 1.21

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_newssuite/includes
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv1314/includes

Modified Files:
	newssuite_constants.php 
Log Message:
Fix for CORE 2.8.2

Index: newssuite_constants.php
===================================================================
RCS file: /cvsroot/mxbb/mx_newssuite/includes/newssuite_constants.php,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -d -r1.20 -r1.21
*** newssuite_constants.php	17 Jun 2006 20:12:33 -0000	1.20
--- newssuite_constants.php	23 Jul 2007 21:42:40 -0000	1.21
***************
*** 34,38 ****
  	$mx_user->extend();
  	$mx_page->add_copyright( 'mxBB Newssuite Module' );
! 	$mx_page->add_css( $module_root_path );
  }
  ?>
\ No newline at end of file
--- 34,38 ----
  	$mx_user->extend();
  	$mx_page->add_copyright( 'mxBB Newssuite Module' );
! 	//$mx_page->add_css( $module_root_path );
  }
  ?>
\ No newline at end of file

[mxbb-commits] mx_newssuite db_upgrade.php,1.13,1.14

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_newssuite
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv1314

Modified Files:
	db_upgrade.php 
Log Message:
Fix for CORE 2.8.2

Index: db_upgrade.php
===================================================================
RCS file: /cvsroot/mxbb/mx_newssuite/db_upgrade.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** db_upgrade.php	30 Jan 2007 16:26:09 -0000	1.13
--- db_upgrade.php	23 Jul 2007 21:42:40 -0000	1.14
***************
*** 43,46 ****
--- 43,47 ----
  
  $message .= mx_do_install_upgrade( $sql );
+ $message .= "<b>...Now upgraded to v. $mx_module_version :-)</b><br/><br/>";
  
  $message .= '<br /> This module does not have any module tables, it use mx paramters only! Thank you for using this module...the installation was successful :-)';

[mxbb-commits] core/install/schemas mysql_schema_upgrade_to_2.8.1.sql, 1.3, 1.4 upgrade_schemas_map.php, 1.19, 1.20

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core/install/schemas
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv30896

Modified Files:
	mysql_schema_upgrade_to_2.8.1.sql upgrade_schemas_map.php 
Log Message:
Fix

Index: upgrade_schemas_map.php
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/upgrade_schemas_map.php,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** upgrade_schemas_map.php	22 Jul 2007 21:00:21 -0000	1.19
--- upgrade_schemas_map.php	23 Jul 2007 21:36:43 -0000	1.20
***************
*** 18,22 ****
  	array('schema' => 'upgrade_to_2.8_b2'	, 'sql' => "SELECT overall_header FROM mx_table_portal"),
  	array('schema' => 'upgrade_to_2.8_b3'	, 'sql' => "SELECT main_layout FROM mx_table_portal"),
! 	array('schema' => 'upgrade_to_2.8.0'	, 'sql' => "SELECT overall_footer FROM mx_table_portal"),
  	array('schema' => 'upgrade_to_2.8.1'	, 'sql' => "SELECT portal_status FROM mx_table_portal"),
  );
--- 18,22 ----
  	array('schema' => 'upgrade_to_2.8_b2'	, 'sql' => "SELECT overall_header FROM mx_table_portal"),
  	array('schema' => 'upgrade_to_2.8_b3'	, 'sql' => "SELECT main_layout FROM mx_table_portal"),
! 	array('schema' => 'upgrade_to_2.8.0'	, 'sql' => "SELECT override_user_style FROM mx_table_portal"),
  	array('schema' => 'upgrade_to_2.8.1'	, 'sql' => "SELECT portal_status FROM mx_table_portal"),
  );

Index: mysql_schema_upgrade_to_2.8.1.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_upgrade_to_2.8.1.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** mysql_schema_upgrade_to_2.8.1.sql	22 Jul 2007 21:00:20 -0000	1.3
--- mysql_schema_upgrade_to_2.8.1.sql	23 Jul 2007 21:36:43 -0000	1.4
***************
*** 30,33 ****
--- 30,34 ----
  # New Fields in Table `mx_portal`
  #
+ ALTER TABLE mx_table_portal ADD portal_backend varchar(255) default 'phpBB2' AFTER mod_rewrite;
  ALTER TABLE mx_table_portal ADD portal_status smallint(2) NOT NULL default '1' AFTER portal_backend;
  ALTER TABLE mx_table_portal ADD disabled_message varchar(255) default 'We are currenty upgrading this site with latest mxBB software.' AFTER portal_status;

[mxbb-commits] mx_linkdb/linkdb/includes functions_linkdb.php, 1.24, 1.25

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_linkdb/linkdb/includes
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv7896/includes

Modified Files:
	functions_linkdb.php 
Log Message:
Orys fixes for comments

Index: functions_linkdb.php
===================================================================
RCS file: /cvsroot/mxbb/mx_linkdb/linkdb/includes/functions_linkdb.php,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** functions_linkdb.php	30 May 2007 21:33:00 -0000	1.24
--- functions_linkdb.php	22 Jul 2007 22:38:24 -0000	1.25
***************
*** 1348,1354 ****
  				// Update item with new topic_id
  				//
! 				$sql = "UPDATE " . PA_FILES_TABLE . "
! 					SET topic_id = '" . $return_data['topic_id'] . "'
! 				    WHERE file_id = ". $item_id;
  
  				if ( !( $result = $db->sql_query( $sql ) ) )
--- 1348,1354 ----
  				// Update item with new topic_id
  				//
! 	         	$sql = "UPDATE " . LINKS_TABLE . "
! 	               	SET topic_id = '" . $return_data['topic_id'] . "'
! 	                WHERE link_id = ". $item_id;
  
  				if ( !( $result = $db->sql_query( $sql ) ) )

[mxbb-commits] mx_linkdb/linkdb/modules link_post_comment.php, 1.2, 1.3

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_linkdb/linkdb/modules
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv7896/modules

Modified Files:
	link_post_comment.php 
Log Message:
Orys fixes for comments

Index: link_post_comment.php
===================================================================
RCS file: /cvsroot/mxbb/mx_linkdb/linkdb/modules/link_post_comment.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** link_post_comment.php	13 Aug 2006 19:43:51 -0000	1.2
--- link_post_comment.php	22 Jul 2007 22:38:25 -0000	1.3
***************
*** 174,178 ****
  				else
  				{
! 					include( $module_root_path . 'kb/includes/functions_comment.' . $phpEx );
  					$linkdb_comments = new linkdb_comments();
  					$linkdb_comments->init( $link_info, 'phpbb' );
--- 174,178 ----
  				else
  				{
! 					include( $module_root_path . 'linkdb/includes/functions_comment.' . $phpEx );
  					$linkdb_comments = new linkdb_comments();
  					$linkdb_comments->init( $link_info, 'phpbb' );

[mxbb-commits] mx_phpbb/includes forum_hack.php,1.23,1.24

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_phpbb/includes
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv30479

Modified Files:
	forum_hack.php 
Log Message:
Selven's fix for avatars

Index: forum_hack.php
===================================================================
RCS file: /cvsroot/mxbb/mx_phpbb/includes/forum_hack.php,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -d -r1.23 -r1.24
*** forum_hack.php	13 Jul 2007 21:23:59 -0000	1.23
--- forum_hack.php	22 Jul 2007 22:31:04 -0000	1.24
***************
*** 1427,1430 ****
--- 1427,1441 ----
  				$code = str_replace('$board_config[\'avatar_path\']', '\''.$phpbb_root_path.'\' . $board_config[\'avatar_path\']', $code);
  				break;
+ 
+ 	         case 'includes/usercp_viewprofile':
+ 	            //
+ 	            // Avatars and ranks
+ 	            //
+ 	            $code = str_replace('\'./\' . $board_config[\'avatar_gallery_path\']', '$board_config[\'avatar_gallery_path\']', $code);
+ 	            $code = str_replace('\'./\' . $board_config[\'avatar_path\']', '$board_config[\'avatar_path\']', $code);
+ 
+ 	            $code = str_replace('$board_config[\'avatar_gallery_path\']', '\''.$phpbb_root_path.'\' . $board_config[\'avatar_gallery_path\']', $code);
+ 	            $code = str_replace('$board_config[\'avatar_path\']', '\''.$phpbb_root_path.'\' . $board_config[\'avatar_path\']', $code);
+ 	            break;
  		}
  

[mxbb-commits] core/templates/subSilver/images/page_icons icon_icon.gif, 1.2, NONE

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core/templates/subSilver/images/page_icons
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv29120

Removed Files:
	icon_icon.gif 
Log Message:
updated mx_install.php
removed another icon

--- icon_icon.gif DELETED ---

[mxbb-commits] core/install/schemas mysql_schema_install.sql, 1.40, 1.41

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core/install/schemas
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv28446/schemas

Modified Files:
	mysql_schema_install.sql 
Log Message:
updated mx_install.php
removed another icon

Index: mysql_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v
retrieving revision 1.40
retrieving revision 1.41
diff -C2 -d -r1.40 -r1.41
*** mysql_schema_install.sql	22 Jul 2007 21:00:20 -0000	1.40
--- mysql_schema_install.sql	22 Jul 2007 22:29:01 -0000	1.41
***************
*** 439,443 ****
  INSERT INTO mx_table_page VALUES("1", "Home", "This is the startpage", "10", "", "0","icon_home.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
  INSERT INTO mx_table_page VALUES("2", "Forum", "This is the phpBB Forum startpage", "20", "", "0","icon_forum.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "1");
! INSERT INTO mx_table_page VALUES("3", "Demo Page", "Block Demos", "30", "", "0","icon_scate.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
  INSERT INTO mx_table_page VALUES("4", "Sitestats", "Sitestats page", "40", "", "0","icon_stats.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
  INSERT INTO mx_table_page VALUES("5", "Site Search", "Site Search page", "50", "", "0","icon_search.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
--- 439,443 ----
  INSERT INTO mx_table_page VALUES("1", "Home", "This is the startpage", "10", "", "0","icon_home.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
  INSERT INTO mx_table_page VALUES("2", "Forum", "This is the phpBB Forum startpage", "20", "", "0","icon_forum.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "1");
! INSERT INTO mx_table_page VALUES("3", "Demo Page", "Block Demos", "30", "", "0","icon_docs.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
  INSERT INTO mx_table_page VALUES("4", "Sitestats", "Sitestats page", "40", "", "0","icon_stats.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");
  INSERT INTO mx_table_page VALUES("5", "Site Search", "Site Search page", "50", "", "0","icon_search.gif", "", "", "", "", "1", "0", "0", "0", "-1", "-1", "", "", "", "0", "a:1:{i:0;s:0:\"\";}", "-1");

[mxbb-commits] core/install mx_install.php,1.77,1.78

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core/install
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv28446

Modified Files:
	mx_install.php 
Log Message:
updated mx_install.php
removed another icon

Index: mx_install.php
===================================================================
RCS file: /cvsroot/mxbb/core/install/mx_install.php,v
retrieving revision 1.77
retrieving revision 1.78
diff -C2 -d -r1.77 -r1.78
*** mx_install.php	9 Jul 2007 21:57:06 -0000	1.77
--- mx_install.php	22 Jul 2007 22:28:59 -0000	1.78
***************
*** 40,44 ****
  // This is shown in the top right corner of the installation panels.
  //
! define('INSTALLER_VERSION', '2.1.1');
  define('INSTALLER_NAME', 'mxBB-IWizard');
  
--- 40,44 ----
  // This is shown in the top right corner of the installation panels.
  //
! define('INSTALLER_VERSION', '2.1.2');
  define('INSTALLER_NAME', 'mxBB-IWizard');
  
***************
*** 337,341 ****
  		$s_hidden_fields = '';
  
! 		include($mx_root_path . "install/includes/template.$phpEx");
  		$template = new Template($mx_root_path . 'install/templates');
  		page_header_install($lang['Welcome_install'], $lang['Choose_lang_explain']);
--- 337,341 ----
  		$s_hidden_fields = '';
  
! 		include_once($mx_root_path . "install/includes/template.$phpEx");
  		$template = new Template($mx_root_path . 'install/templates');
  		page_header_install($lang['Welcome_install'], $lang['Choose_lang_explain']);

[mxbb-commits] core/templates/subSilver/images/page_icons icon_dl.gif, 1.3, 1.4 icon_game.gif, 1.3, 1.4 icon_home.gif, 1.4, 1.5 icon_movie.gif, 1.2, 1.3 icon_stats.gif, 1.3, 1.4

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core/templates/subSilver/images/page_icons
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10138

Added Files:
	icon_dl.gif icon_game.gif icon_home.gif icon_movie.gif 
	icon_stats.gif 
Log Message:
renamed

--- NEW FILE: icon_movie.gif ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: icon_game.gif ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: icon_home.gif ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: icon_stats.gif ---
(This appears to be a binary file; contents omitted.)

--- NEW FILE: icon_dl.gif ---
(This appears to be a binary file; contents omitted.)

[mxbb-commits] core/templates/subSilver/images/page_icons icon_about.gif, 1.2, NONE icon_angel.gif, 1.2, NONE icon_calendar2.gif, 1.2, NONE icon_cellphone.gif, 1.2, NONE icon_chat.gif, 1.2, NONE icon_circel.gif, 1.2, NONE icon_clones.gif, 1.2, NONE icon_config.gif, 1.2, NONE icon_connect.gif, 1.2, NONE icon_connect2.gif, 1.2, NONE icon_copy.gif, 1.2, NONE icon_desctop.gif, 1.2, NONE icon_dir.gif, 1.2, NONE icon_disc.gif, 1.2, NONE icon_disconnect.gif, 1.2, NONE icon_display.gif, 1.2, NONE icon_display2.gif, 1.1, NONE icon_dl.gif, 1.2, NONE icon_dl2.gif, 1.2, NONE icon_docs2.gif, 1.2, NONE icon_drink.gif, 1.2, NONE icon_find.gif, 1.2, NONE icon_forum3.gif, 1.1, NONE icon_game.gif, 1.2, NONE icon_game2.gif, 1.2, NONE icon_game3.gif, 1.2, NONE icon_home.gif, 1.3, NONE icon_home2.gif, 1.2, NONE icon_home3.gif, 1.2, NONE icon_house.gif, 1.2, NONE icon_list.gif, 1.2, NONE icon_list2.gif, 1.1, NONE icon_loudspeaker.gif, 1.2, NONE icon_mail2.gif, 1.2, NONE icon_mail4.gif, 1.1, NONE icon_mark.gif, 1.2, NONE icon_misc.gif, 1.2, NONE icon_movie2.gif, 1.2, NONE icon_movie3.gif, 1.1, NONE icon_movie4.gif, 1.1, NONE icon_paper_album.gif, 1.2, NONE icon_paper_doc.gif, 1.2, NONE icon_paper_help.gif, 1.2, NONE icon_paper_notify.gif, 1.2, NONE icon_plus.gif, 1.2, NONE icon_profile2.gif, 1.2, NONE icon_profile_boy.gif, 1.2, NONE icon_profile_headset.gif, 1.2, NONE icon_profile_music.gif, 1.2, NONE icon_protections.gif, 1.2, NONE icon_radio.gif, 1.2, NONE icon_register.gif, 1.3, NONE icon_restore.gif, 1.2, NONE icon_save.gif, 1.2, NONE icon_saveall.gif, 1.2, NONE icon_scate.gif, 1.2, NONE icon_select2.gif, 1.2, NONE icon_smilie.gif, 1.2, NONE icon_smilie2.gif, 1.2, NONE icon_smilie3.gif, 1.2, NONE icon_stats.gif, 1.2, NONE icon_stats2.gif, 1.2, NONE icon_stop.gif, 1.2, NONE icon_transfer.gif, 1.2, NONE icon_zip.gif, 1.2, NONE icon_zipdisc.gif, 1.2, NONE

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core/templates/subSilver/images/page_icons
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv3946/page_icons

Removed Files:
	icon_about.gif icon_angel.gif icon_calendar2.gif 
	icon_cellphone.gif icon_chat.gif icon_circel.gif 
	icon_clones.gif icon_config.gif icon_connect.gif 
	icon_connect2.gif icon_copy.gif icon_desctop.gif icon_dir.gif 
	icon_disc.gif icon_disconnect.gif icon_display.gif 
	icon_display2.gif icon_dl.gif icon_dl2.gif icon_docs2.gif 
	icon_drink.gif icon_find.gif icon_forum3.gif icon_game.gif 
	icon_game2.gif icon_game3.gif icon_home.gif icon_home2.gif 
	icon_home3.gif icon_house.gif icon_list.gif icon_list2.gif 
	icon_loudspeaker.gif icon_mail2.gif icon_mail4.gif 
	icon_mark.gif icon_misc.gif icon_movie2.gif icon_movie3.gif 
	icon_movie4.gif icon_paper_album.gif icon_paper_doc.gif 
	icon_paper_help.gif icon_paper_notify.gif icon_plus.gif 
	icon_profile2.gif icon_profile_boy.gif 
	icon_profile_headset.gif icon_profile_music.gif 
	icon_protections.gif icon_radio.gif icon_register.gif 
	icon_restore.gif icon_save.gif icon_saveall.gif icon_scate.gif 
	icon_select2.gif icon_smilie.gif icon_smilie2.gif 
	icon_smilie3.gif icon_stats.gif icon_stats2.gif icon_stop.gif 
	icon_transfer.gif icon_zip.gif icon_zipdisc.gif 
Log Message:
Removed a bunch

--- icon_movie2.gif DELETED ---

--- icon_stats.gif DELETED ---

--- icon_profile_boy.gif DELETED ---

--- icon_paper_album.gif DELETED ---

--- icon_paper_notify.gif DELETED ---

--- icon_zipdisc.gif DELETED ---

--- icon_clones.gif DELETED ---

--- icon_profile_music.gif DELETED ---

--- icon_profile2.gif DELETED ---

--- icon_dl.gif DELETED ---

--- icon_paper_help.gif DELETED ---

--- icon_copy.gif DELETED ---

--- icon_radio.gif DELETED ---

--- icon_saveall.gif DELETED ---

--- icon_home2.gif DELETED ---

--- icon_scate.gif DELETED ---

--- icon_save.gif DELETED ---

--- icon_angel.gif DELETED ---

--- icon_config.gif DELETED ---

--- icon_smilie.gif DELETED ---

--- icon_transfer.gif DELETED ---

--- icon_docs2.gif DELETED ---

--- icon_connect2.gif DELETED ---

--- icon_mail4.gif DELETED ---

--- icon_disc.gif DELETED ---

--- icon_game3.gif DELETED ---

--- icon_zip.gif DELETED ---

--- icon_dl2.gif DELETED ---

--- icon_display2.gif DELETED ---

--- icon_profile_headset.gif DELETED ---

--- icon_circel.gif DELETED ---

--- icon_display.gif DELETED ---

--- icon_home.gif DELETED ---

--- icon_misc.gif DELETED ---

--- icon_stats2.gif DELETED ---

--- icon_smilie3.gif DELETED ---

--- icon_plus.gif DELETED ---

--- icon_mark.gif DELETED ---

--- icon_paper_doc.gif DELETED ---

--- icon_movie3.gif DELETED ---

--- icon_calendar2.gif DELETED ---

--- icon_connect.gif DELETED ---

--- icon_loudspeaker.gif DELETED ---

--- icon_house.gif DELETED ---

--- icon_home3.gif DELETED ---

--- icon_stop.gif DELETED ---

--- icon_select2.gif DELETED ---

--- icon_smilie2.gif DELETED ---

--- icon_disconnect.gif DELETED ---

--- icon_desctop.gif DELETED ---

--- icon_protections.gif DELETED ---

--- icon_list.gif DELETED ---

--- icon_register.gif DELETED ---

--- icon_game2.gif DELETED ---

--- icon_cellphone.gif DELETED ---

--- icon_mail2.gif DELETED ---

--- icon_drink.gif DELETED ---

--- icon_find.gif DELETED ---

--- icon_about.gif DELETED ---

--- icon_list2.gif DELETED ---

--- icon_game.gif DELETED ---

--- icon_movie4.gif DELETED ---

--- icon_forum3.gif DELETED ---

--- icon_restore.gif DELETED ---

--- icon_chat.gif DELETED ---

--- icon_dir.gif DELETED ---

[mxbb-commits] core/templates/subSilver/images/menu_icons icon_cd.gif, 1.1, NONE icon_cd_hot.gif, 1.1, NONE icon_chat.gif, 1.1, NONE icon_chat_hot.gif, 1.1, NONE icon_cut.gif, 1.1, NONE icon_cut_hot.gif, 1.1, NONE icon_day.gif, 1.1, NONE icon_day_hot.gif, 1.1, NONE icon_delete.gif, 1.4, NONE icon_delete_hot.gif, 1.4, NONE icon_education.gif, 1.1, NONE icon_education_hot.gif, 1.1, NONE icon_flag.gif, 1.1, NONE icon_flag_hot.gif, 1.1, NONE icon_food.gif, 1.1, NONE icon_food_hot.gif, 1.1, NONE icon_happy.gif, 1.1, NONE icon_happy_hot.gif, 1.1, NONE icon_help.gif, 1.4, NONE icon_help_hot.gif, 1.4, NONE icon_house.gif, 1.1, NONE icon_house_hot.gif, 1.1, NONE icon_ipod.gif, 1.1, NONE icon_ipod_hot.gif, 1.1, NONE icon_left.gif, 1.1, NONE icon_left_hot.gif, 1.1, NONE icon_link.gif, 1.1, NONE icon_link_hot.gif, 1.1, NONE icon_map.gif, 1.1, NONE icon_map_hot.gif, 1.1, NONE icon_minus.gif, 1.1, NONE icon_minus_hot.gif, 1.1, NONE icon_movie.gif, 1.4, NONE icon_movie_hot.gif, 1.4, NONE icon_music.gif, 1.1, NONE icon_music_hot.gif, 1.1, NONE icon_pay.gif, 1.1, NONE icon_pay_hot.gif, 1.1, NONE icon_plus.gif, 1.1, NONE icon_plus_hot.gif, 1.1, NONE icon_right.gif, 1.1, NONE icon_right_hot.gif, 1.1, NONE icon_sad.gif, 1.1, NONE icon_sad_hot.gif, 1.1, NONE icon_select.gif, 1.1, NONE icon_select_hot.gif, 1.1, NONE icon_smilie.gif, 1.4, NONE icon_smilie_hot.gif, 1.4, NONE icon_star.gif, 1.4, NONE icon_star_hot.gif, 1.4, NONE icon_unlock.gif, 1.1, NONE icon_unlock_hot.gif, 1.1, NONE icon_upload.gif, 1.1, NONE icon_upload_hot.gif, 1.1, NONE icon_user.gif, 1.1, NONE icon_user_hot.gif, 1.1, NONE

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core/templates/subSilver/images/menu_icons
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv3946/menu_icons

Removed Files:
	icon_cd.gif icon_cd_hot.gif icon_chat.gif icon_chat_hot.gif 
	icon_cut.gif icon_cut_hot.gif icon_day.gif icon_day_hot.gif 
	icon_delete.gif icon_delete_hot.gif icon_education.gif 
	icon_education_hot.gif icon_flag.gif icon_flag_hot.gif 
	icon_food.gif icon_food_hot.gif icon_happy.gif 
	icon_happy_hot.gif icon_help.gif icon_help_hot.gif 
	icon_house.gif icon_house_hot.gif icon_ipod.gif 
	icon_ipod_hot.gif icon_left.gif icon_left_hot.gif 
	icon_link.gif icon_link_hot.gif icon_map.gif icon_map_hot.gif 
	icon_minus.gif icon_minus_hot.gif icon_movie.gif 
	icon_movie_hot.gif icon_music.gif icon_music_hot.gif 
	icon_pay.gif icon_pay_hot.gif icon_plus.gif icon_plus_hot.gif 
	icon_right.gif icon_right_hot.gif icon_sad.gif 
	icon_sad_hot.gif icon_select.gif icon_select_hot.gif 
	icon_smilie.gif icon_smilie_hot.gif icon_star.gif 
	icon_star_hot.gif icon_unlock.gif icon_unlock_hot.gif 
	icon_upload.gif icon_upload_hot.gif icon_user.gif 
	icon_user_hot.gif 
Log Message:
Removed a bunch

--- icon_cd.gif DELETED ---

--- icon_music.gif DELETED ---

--- icon_link.gif DELETED ---

--- icon_house.gif DELETED ---

--- icon_upload_hot.gif DELETED ---

--- icon_delete.gif DELETED ---

--- icon_food.gif DELETED ---

--- icon_select.gif DELETED ---

--- icon_star_hot.gif DELETED ---

--- icon_sad.gif DELETED ---

--- icon_plus_hot.gif DELETED ---

--- icon_ipod_hot.gif DELETED ---

--- icon_minus_hot.gif DELETED ---

--- icon_music_hot.gif DELETED ---

--- icon_right.gif DELETED ---

--- icon_pay_hot.gif DELETED ---

--- icon_user.gif DELETED ---

--- icon_education_hot.gif DELETED ---

--- icon_smilie.gif DELETED ---

--- icon_right_hot.gif DELETED ---

--- icon_minus.gif DELETED ---

--- icon_flag_hot.gif DELETED ---

--- icon_select_hot.gif DELETED ---

--- icon_star.gif DELETED ---

--- icon_cut_hot.gif DELETED ---

--- icon_pay.gif DELETED ---

--- icon_link_hot.gif DELETED ---

--- icon_map.gif DELETED ---

--- icon_help_hot.gif DELETED ---

--- icon_sad_hot.gif DELETED ---

--- icon_plus.gif DELETED ---

--- icon_house_hot.gif DELETED ---

--- icon_map_hot.gif DELETED ---

--- icon_happy.gif DELETED ---

--- icon_ipod.gif DELETED ---

--- icon_movie.gif DELETED ---

--- icon_cut.gif DELETED ---

--- icon_happy_hot.gif DELETED ---

--- icon_chat_hot.gif DELETED ---

--- icon_smilie_hot.gif DELETED ---

--- icon_user_hot.gif DELETED ---

--- icon_unlock.gif DELETED ---

--- icon_upload.gif DELETED ---

--- icon_delete_hot.gif DELETED ---

--- icon_left.gif DELETED ---

--- icon_flag.gif DELETED ---

--- icon_help.gif DELETED ---

--- icon_day_hot.gif DELETED ---

--- icon_day.gif DELETED ---

--- icon_food_hot.gif DELETED ---

--- icon_unlock_hot.gif DELETED ---

--- icon_movie_hot.gif DELETED ---

--- icon_left_hot.gif DELETED ---

--- icon_cd_hot.gif DELETED ---

--- icon_chat.gif DELETED ---

--- icon_education.gif DELETED ---

[mxbb-commits] mx_ggsitemaps/templates/subSilver/admin admin_mx_ggsitemap.tpl, NONE, 1.1 index.htm, NONE, 1.1

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/templates/subSilver/admin
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10940

Added Files:
	admin_mx_ggsitemap.tpl index.htm 
Log Message:
Added this module, for now, so i do not loose it

--- NEW FILE: admin_mx_ggsitemap.tpl ---
<h1>{L_CONFIGURATION_TITLE}</h1>

<p>{L_CONFIGURATION_EXPLAIN}</p>

<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_SITEMAP_SETTINGS}</th>
	</tr>
	<tr> 
		<td class="row1">{L_SQL_LIMIT}<br /><span class="gensmall">{L_SQL_LIMIT_EXPLAIN}</span></td> 
		<td class="row2"><input type="text" name="sitemap_sql_limit" value="{SQL_LIMIT}" /></td> 
	</tr>
	<tr> 
		<td class="row1">{L_DEFAULT_LIMIT}<br /><span class="gensmall">{L_DEFAULT_LIMIT_EXPLAIN}</span></td> 
		<td class="row2"><input type="text" name="sitemap_url_limit" value="{DEFAULT_LIMIT}" /></td> 
	</tr>
	<tr>
		<td class="row1">{L_SORT_ORDER}<br /><span class="gensmall">{L_SORT_ORDER_EXPLAIN}</span></td>
		<td class="row2"><input type="radio" name="sitemap_sort" value="DESC" {SITEMAP_SORT_DESC} /> {L_NEW_FIRST}&nbsp;&nbsp;<input type="radio" name="sitemap_sort" value="ASC" {SITEMAP_SORT_ASC} /> {L_OLD_FIRST}</td>
	</tr>
	<tr>
		<td class="row1">{L_S_MOD_REWRITE}<br /><span class="gensmall">{L_S_MOD_REWRITE_EXPLAIN}</span></td>
		<td class="row2"><input type="radio" name="sitemap_rewrited" value="FALSE" {REWRTIE_S_NO} /> {L_NO}&nbsp;&nbsp;<input type="radio" name="sitemap_rewrited" value="TRUE" {REWRTIE_S_YES} /> {L_YES}</td>
	</tr> 
	<tr>
		<th class="thHead" colspan="2">{L_SITEMAP_FORUM_SET}</th>
	</tr>
	<tr> 
		<td class="row1">{L_ANNOUNCE_PRIORITY}<br /><span class="gensmall">{L_ANNOUNCE_PRIORITY_EXPLAIN}</span></td> 
		<td class="row2"><input type="text" name="sitemap_announce_priority" value="{ANNOUNCE_PRIORITY}" /></td> 
	</tr>
	<tr> 
		<td class="row1">{L_STICKY_PRIORITY}<br /><span class="gensmall">{L_STICKY_PRIORITY_EXPLAIN}</span></td> 
		<td class="row2"><input type="text" name="sitemap_sticky_priority" value="{STICKY_PRIORITY}" /></td> 
	</tr>
	<tr> 
		<td class="row1">{L_DEFAULT_PRIORITY}<br /><span class="gensmall">{L_DEFAULT_PRIORITY_EXPLAIN}</span></td> 
		<td class="row2"><input type="text" name="sitemap_default_priority" value="{DEFAULT_PRIORITY}" /></td> 
	</tr>
	<tr> 
		<td class="row1">{L_PAGINATION_LIMIT1}<br /><span class="gensmall">{L_PAGINATION_LIMIT_EXPLAIN1}</span></td> 
		<td class="row2"><input type="text" name="sitemap_limitdown" value="{PAGINATION_LIMITDOWN}" /></td> 
	</tr>
	<tr> 
		<td class="row1">{L_PAGINATION_LIMIT2}<br /><span class="gensmall">{L_PAGINATION_LIMIT_EXPLAIN2}</span></td> 
		<td class="row2"><input type="text" name="sitemap_limitup" value="{PAGINATION_LIMITUP}" /></td> 
	</tr>
<!-- BEGIN kb_config -->
	<tr>
		<th class="thHead" colspan="2">{kb_config.L_SITEMAP_KB_SET}</th>
	</tr>
	<tr> 
		<td class="row1">{kb_config.L_KB_MX_PAGE}<br /><span class="gensmall">{kb_config.L_KB_MX_PAGE_EXPLAIN}</span></td> 
		<td class="row2"><input type="text" name="sitemap_kb_mx_page" value="{kb_config.KB_MX_PAGE}" /></td> 
	</tr>
<!-- END kb_config -->
<tr>
	<td class="catBottom" colspan="3" align="center">{S_HIDDEN_FIELDS}<input type="submit" name="submit" value="{L_SUBMIT}" class="mainoption" />&nbsp;&nbsp;<input type="reset" value="{L_RESET}" class="liteoption" />
</tr> 

</table></form>
<div align="center"><span class="copyright">{VER_INFO}</span></div>
<br clear="all" />

--- NEW FILE: index.htm ---
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">

</body>
</html>

[mxbb-commits] mx_ggsitemaps/language/lang_english index.htm, NONE, 1.1 lang_google_sitemap.php, NONE, 1.1

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/language/lang_english
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10474

Added Files:
	index.htm lang_google_sitemap.php 
Log Message:
Added this module, for now, so i do not loose it

--- NEW FILE: lang_google_sitemap.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: lang_google_sitemap.php,v 1.1 2007/07/22 21:17:58 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

//
// The format of this file is:
//
// ---> $lang["message"] = "text";
//
// Specify your language character encoding... [optional]
//
// setlocale(LC_ALL, "en");

// ACP
$lang['Sitemap_conf_title'] = 'Google Sitemaps';
$lang['Sitemap_conf_explain'] = "The Google sitemap system allows GoogleBot to find pages far away from the Home page easyer. This system generates a sitemapp index pointing to the different sitemaps available.<br /> You must register your sitemapIndex @ %sGoogle%s if you want to access some interesting stats.";
$lang['Sitemap_conf_explain2'] = "You can proceed %sanonymous%s though";

$lang['Sitemap_settings'] = 'Google Sitemaps Settings';

$lang['Sql_limit'] = 'SQL cycle';
$lang['Sql_limit_explain'] = 'Major queries are sparated into several cycles in order not to overload the SQL server. This is the maximum number of topics to fetch within a single query';

$lang['Default_limit'] = 'Url Limit';
$lang['Default_limit_explain'] = 'Maximum number of url outputed in each sitemap.<br /> This limit being checked in every SQL cycle, the actual outputed number of url is this limit +- 1 SQL cycle +- number of paginated topics (limited or not) in the last cycle.<br />Limited by default to 40 000, knowing Google will go up to 50 000 per sitemap file. ';

$lang['Sort_order'] = 'Sort Order';
$lang['New_first'] = 'DESC';
$lang['Old_first'] = 'ASC';
$lang['Sort_order_explain'] = 'All outputed links are sorted in the same way topics are sorted by default in phpbb (last activity DESC). <br /> You can set this to DESC for example if you whish to make it easyer for Google to find again links to archeological or locked threads (eg inactive for a looong time).';

$lang['Mod_rewrite_S'] = "Mod Rewrite Sitemaps";
$lang['Mod_rewrite_S_explain'] = "If activated, the sitemap's url will be rewrited.<br />CAUTION : you MUST run Apache server with mod rewrite activated and set up the .htaccess located in this release's contrib/ folder properly. <br /> NOTE : This will only affect the sitemaps url provided in the sitemap index. There is no problem for google to visit non url rewrited sitemaps.";

$lang['Sitemap_Forum_set'] = 'Forums Sitemaps Settings';

$lang['Announce_priority'] = 'Announcement Priority';
$lang['Announce_priority_explain'] = 'Announcement Priority (must be a number between 0.0 &amp; 1.0 inclusive)';

$lang['Sticky_priority'] = 'Sticky Priority';
$lang['Sticky_priority_explain'] = 'Sticky Priority (must be a number between 0.0 &amp; 1.0 inclusive)';

$lang['Default_priority'] = 'Default Priority';
$lang['Default_priority_explain'] = 'Priority for regular topics (must be a number between 0.0 &amp; 1.0 inclusive)';

$lang['Pagination_limit1'] = "Topic Pagination: Low Limit";
$lang['Pagination_limit_explain1'] = "Paginated topic link output is handeled. Enter here how many paginated topic pages, from the begining, are to be outputed.<br /> If set to 0, it won't output paginated links after the first topic page.";

$lang['Pagination_limit2'] = "Topic Pagination: Upper Limit";
$lang['Pagination_limit_explain2'] = "Enter here how many paginated topic pages, starting from the last one,  are to be outputed.<br /> If set to 0, it won't output paginated links before the last topic page.";

$lang['KB_mx_page'] = "Kb mx page Id";
$lang['KB_mx_page_explain'] = "This only get used if kb is installed in a %smxBB PORTAL%s . If running phpbb stand alone, just not bother about this, it's just ment to know on which mx pages kb is installed.<br />CAUTION : If you don't set this to the right ID while using KB and mxBB you could end up pointing to 404!!";


$lang['Google_Config_updated'] = "Google sitemaps Configuration Updated Successfully";
$lang['Click_return_ggsitemap_config'] = "Click %sHere%s to return to the Google sitemaps Configuration";

// INSTALL
$lang['Google_install'] = "<b>Installation mx Google Sitemaps : Default Param.</b><br/><br/>";
$lang['Google_install_ok'] = "Building required dB tables";
$lang['Google_error'] = "[Error or Already added]</font></b> line: ";
$lang['Google_sql_ok'] = "[Added/Updated]</font></b> line: ";
$lang['Google_general'] = "If you get some Errors, Already Added or Updated messages, relax, this is normal when updating modules";
$lang['Google_uninstall'] = "<b>This list is a result of the SQL queries needed for mx Google Sitemap module</b><br /><br />";
$lang['Google_uninstall_ok'] = "Sql : Ok.";

$lang['Google_unerror'] = "[Error, Already deleted or updated]</font></b> line: ";
$lang['Google_unsql_ok'] = "[Deleted/Updated]</font></b> line: ";
$lang['Google_uninstal_info'] = "Module Uninstallation Information";
$lang['Google_instal_info'] = "Module Installation Information";
//
// That's all Folks!
// -------------------------------------------------
?>
--- NEW FILE: index.htm ---
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">

</body>
</html>

[mxbb-commits] mx_ggsitemaps/templates index.htm,NONE,1.1

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/templates
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10068/templates

Added Files:
	index.htm 
Log Message:
Added this module, for now, so i do not loose it

--- NEW FILE: index.htm ---
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">

</body>
</html>

[mxbb-commits] mx_ggsitemaps/language index.htm,NONE,1.1

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/language
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10068/language

Added Files:
	index.htm 
Log Message:
Added this module, for now, so i do not loose it

--- NEW FILE: index.htm ---
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">

</body>
</html>

[mxbb-commits] mx_ggsitemaps/includes .htaccess, NONE, 1.1 common_GGsitemaps.php, NONE, 1.1 index.htm, NONE, 1.1 index_forum.php, NONE, 1.1 index_kb.php, NONE, 1.1 index_mx.php, NONE, 1.1 sitemap_forum.php, NONE, 1.1 sitemap_kb.php, NONE, 1.1 sitemap_mx.php, NONE, 1.1

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/includes
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10068/includes

Added Files:
	.htaccess common_GGsitemaps.php index.htm index_forum.php 
	index_kb.php index_mx.php sitemap_forum.php sitemap_kb.php 
	sitemap_mx.php 
Log Message:
Added this module, for now, so i do not loose it

--- NEW FILE: index_mx.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: index_mx.php,v 1.1 2007/07/22 21:17:35 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

if ( !defined('IN_PHPBB') && !defined('IN_PORTAL') )
{
	die('Hacking attempt');
	exit;
}

// Should be enough as a check
if ( defined('IN_PORTAL') )
{
	//Output start if necessary
	if (!$started)
	{
		header("Content-type: text/xml");
		$started = true;
		echo $I_header;
	}

	echo "\t" . '<sitemap>' . "\n";
	echo "\t\t" . '<loc>' .  ( ($Rewrite_sitemap) ? $root_url.'mx-sitemap.xml' : $root_url."sitemap.php?mx" ) . '</loc>' . "\n";
	echo "\t" . '</sitemap>' . "\n";
}

?>
--- NEW FILE: sitemap_mx.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: sitemap_mx.php,v 1.1 2007/07/22 21:17:36 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

//
// First basic security
//
if ( !defined('IN_PHPBB') && !defined('IN_PORTAL') )
{
	die('Hacking attempt');
	exit;
}

// Let's start with checking what to do
$mx_map = ( isset( $HTTP_GET_VARS['mx'] ) ) ? TRUE : FALSE;

if ( $mx_map )
{
	//
	// First get all visible blocks
	//
	$sql = "SELECT block_id
	   		FROM " . BLOCK_TABLE . "
			WHERE show_block = 1";

	if ( !$result = $db->sql_query( $sql ) )
	{
		mx_message_die( GENERAL_ERROR, 'Could not obtain block results', '', __LINE__, __FILE__, $sql );
	}

	$block_rowset = $db->sql_fetchrowset( $result );
	$db->sql_freeresult($result);

	//
	// Get all pages with view access
	//
	/*
	$sql = "SELECT * FROM " . PAGE_TABLE . " ORDER BY page_id";
	if ( !( $result = $db->sql_query( $sql ) ) )
	{
		mx_message_die( GENERAL_ERROR, "Couldn't get list of page", "", __LINE__, __FILE__, $sql );
	}

	$valid_page_ids_array = array();
	while ( $page_row = $db->sql_fetchrow( $result ))
	{
		//
		// Page auth
		//
		$mx_page_temp = new mx_page();
		$mx_page_temp->init($page_row['page_id']);

		if ( $mx_page_temp->auth_view )
		{
			$valid_page_ids_array[] = $page_row['page_id'];
		}
	}
	$db->sql_freeresult($result);
	*/

	$valid_page_ids_array = array();
	foreach( $mx_page->page_rowset as $temp_key => $page_row )
	{
		$_auth_ary = $mx_page->auth($page_row['auth_view'], $page_row['auth_view_group'], $page_row['auth_moderator_group']);
		if ($_auth_ary['auth_view'])
		{
			$valid_page_ids_array[] = $page_row['page_id'];
		}
	}

	//
	// Now find the associated pages
	//
	$page_ids = array();
	$block_ids = array();
	$valid_page_ids = '';
	foreach($block_rowset as $key => $block_row)
	{
		$page_id_array = get_page_id($block_row['block_id'], false, true);

		if (in_array($page_id_array['page_id'], $valid_page_ids_array))
		{
			$page_ids[$block_row['block_id']] = $page_id_array;
			$block_ids[] = $block_row['block_id'];
		}
	}

	$valid_block_ids = implode( ', ', $block_ids );

	//
	// Output start
	//
	header("Content-type: text/xml");
	$started = true;
	echo $S_header;

	// Homepage location
	echo "\t" . '<url>' . "\n";
	echo "\t\t" . '<loc>' .  $root_url . '</loc>' . "\n";
	//echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', time() ) . '</lastmod>' . "\n";
	echo "\t\t" . '<changefreq>always</changefreq>' . "\n";
	echo "\t\t" . '<priority>1.0</priority>' . "\n";
	echo "\t" . '</url>' . "\n";

	//
	// Dump out the results
	//
	$pageids = array();
	foreach($page_ids as $block_id => $page_row )
	{
		if (is_array($page_row) && !empty($page_row['block_id']))
		{
			$dynamic_block_id = $page_row['block_id'];
			$pageid = $page_row['page_id'];
			$priority = '0.8';
		}
		else if (is_array($page_row))
		{
			$dynamic_block_id = '';
			$pageid = $page_row['page_id'];
			$priority = '1.0';
		}
		else
		{
			$dynamic_block_id = '';
			$pageid = $page_row;
			$priority = '1.0';
		}

		//
		// Remove duplicate pages
		//
		if (empty($dynamic_block_id))
		{
			if (in_array($pageid,$pageids) )
			{
				continue;
			}
			else
			{
				$pageids[] = $pageid;
			}
		}

		$page_title = $page_row['page_name'];
		$page_desc = $page_row['page_desc'];

		$temp_url = !empty($dynamic_block_id) ?  mx_append_sid( PORTAL_URL . 'index.php?page=' . $pageid . '&amp;dynamic_block=' . $dynamic_block_id, false, true )  : mx_append_sid( PORTAL_URL . 'index.php?page=' . $pageid );

		//
		// Built mx urls
		//
		echo "\t" . '<url>' . "\n";
		echo "\t\t" . '<loc>' .  $temp_url . '</loc>' . "\n";
		//echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', time() ) . '</lastmod>' . "\n";
		echo "\t\t" . '<changefreq>always</changefreq>' . "\n";
		echo "\t\t" . '<priority>'.$priority.'</priority>' . "\n";
		echo "\t" . '</url>' . "\n";
	}

	$db->sql_freeresult($result);
	unset($page_ids);
	unset($block_rowset);
	unset($page_row);

	// Dump the page since there's nothing left to do
	echo $S_footer;
	exit;
}
?>
--- NEW FILE: common_GGsitemaps.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: common_GGsitemaps.php,v 1.1 2007/07/22 21:17:31 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

if ( !defined('IN_PHPBB') && !defined('IN_PORTAL') )
{
	die('Hacking attempt');
	exit;
}

//
// Define table names.
//
if (defined('IN_PORTAL'))
{
	$table_prefix =  $mx_table_prefix;
}

define('GGSITEMAP_TABLE', $table_prefix.'ggsitemap_config');

// message_die selector
function mx_sitemaps_message_die($msg_code, $msg_text = '', $msg_title = '', $err_line = '', $err_file = '', $sql = '')
{
	global $phpbb;
	if ($phpbb)
	{
		message_die($msg_code, $msg_text = '', $msg_title = '', $err_line = '', $err_file = '', $sql = '');
	}
	else
	{
		mx_message_die($msg_code, $msg_text = '', $msg_title = '', $err_line = '', $err_file = '', $sql = '');
	}
}

// Basically the mxBB Portal mx_redirect function
// Used to circumvent header already sent matters
function mx_sitemaps_redirect($url)
{
	global $db, $board_config;

	//
	// Save any possible changes made in session variables, otherwise we will loose them.
	// See comments here:
	// http://www.php.net/session
	// http://www.php.net/session_write_close
	//
	@session_write_close();
	@session_start();

	if ( !empty($db) )
	{
		$db->sql_close();
	}

	if ( strstr(urldecode($url), "\n") || strstr(urldecode($url), "\r") )
	{
		message_die(GENERAL_ERROR, 'Tried to redirect to potentially insecure url.');
	}
	// Redirect via an HTML form for PITA webservers
	if (@preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')))
	{
		header('Refresh: 0; URL=' . $url);
		echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><meta http-equiv="refresh" content="0; url=' . $url . '"><title>Redirect</title></head><body><div align="center">If your browser does not support meta redirection please click <a href="' . $url . '">HERE</a> to be redirected</div></body></html>';
		exit;
	}

	// Behave as per HTTP/1.1 spec for others
	header("Status: 302 Found", false, 302);
	header('Location: ' . $root_url . $url);
	exit;
}

if (defined('IN_ADMIN'))
{
	//
	// Load language files.
	//
	if( file_exists($module_root_path2 . 'language/lang_' . $board_config['default_lang'] . '/lang_google_sitemap.' . $phpEx) )
	{
		include_once($module_root_path2 . 'language/lang_' . $board_config['default_lang'] . '/lang_google_sitemap.' . $phpEx);
	}
	else
	{
		include_once($module_root_path2 . 'language/lang_english/lang_google_sitemap.' . $phpEx);
	}

	// One small cosmetic function for easy compatibility with phpbb
	// Basically the phpbb make clickable function
	if (!function_exists('make_link'))
	{
		function make_link($text)
		{
			$text = preg_replace('#(script|about|applet|activex|chrome):#is', "\\1&#058;", $text);

			// pad it with a space so we can match things at the start of the 1st line.
			$ret = ' ' . $text;

			// matches an "xxxx://yyyy" URL at the start of a line, or after a space.
			// xxxx can only be alpha characters.
			// yyyy is anything up to the first space, newline, comma, double quote or <
			$ret = preg_replace("#(^|[\n ])([\w]+?://[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"\\2\" target=\"_blank\">\\2</a>", $ret);

			// matches a "www|ftp.xxxx.yyyy[/zzzz]" kinda lazy URL thing
			// Must contain at least 2 dots. xxxx contains either alphanum, or "-"
			// zzzz is optional.. will contain everything up to the first space, newline,
			// comma, double quote or <.
			$ret = preg_replace("#(^|[\n ])((www|ftp)\.[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\">\\2</a>", $ret);

			// Remove our padding..
			$ret = substr($ret, 1);

			return($ret);
		}
	}
}
?>
--- NEW FILE: .htaccess ---
<Limit GET POST PUT>
Order Allow,Deny
Deny from All
</Limit>
--- NEW FILE: index_kb.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: index_kb.php,v 1.1 2007/07/22 21:17:34 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

if ( !defined('IN_PHPBB') && !defined('IN_PORTAL') )
{
	die('Hacking attempt');
	exit;
}
if ($is_index)
{
	if ( ( defined('IN_PORTAL') ) && file_exists( $module_root_path . 'mx_kb/includes/functions_kb.php' ) )
	{
		$kb_installed = TRUE;
		define( 'KB_CATEGORIES_TABLE', $mx_table_prefix . 'kb_categories' );
	}
	elseif ( file_exists( $phpbb_root_path . 'includes/functions_kb.php' ) )
	{
		$kb_installed = TRUE;
		define( 'KB_CATEGORIES_TABLE', $table_prefix . 'kb_categories' );
	}
	if ( $kb_installed )
	{
		// Grab necessary info
		// Here, some postgresql && oracle wizards are welcome to validate this switch
		// I just could not test it, and by the way am not a postgresql && oracle guru :-)
		switch(SQL_LAYER)
		{
			case 'postgresql':
				$sql = "SELECT c.*, p.post_time, p.post_username, u.username, u.user_id
					FROM " . KB_CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p
					WHERE f.forum_id = c.comments_forum_id
						AND p.post_id = f.forum_last_post_id
						UNION (
							SELECT c.*, NULL, NULL, NULL, NULL
							FROM " . KB_CATEGORIES_TABLE . " c
							WHERE NOT EXISTS (
								SELECT p.post_time
								FROM " . POSTS_TABLE . " p
								WHERE p.post_id = f.forum_last_post_id
							)
						)
						ORDER BY forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
				break;

			case 'oracle':
				$sql = "SELECT c.*, p.post_time, p.post_username, u.username, u.user_id
						FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
						WHERE f.forum_id = c.comments_forum_id(+)
						AND p.post_id = f.forum_last_post_id(+)
						ORDER BY f.forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
				break;

			default:
				$sql = "SELECT c.category_id, c.category_name, c.auth_view, f.forum_last_post_id, p.post_time
						FROM (( " . KB_CATEGORIES_TABLE . " c
						LEFT JOIN " . FORUMS_TABLE . " f ON f.forum_id = c.comments_forum_id )
						LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
						ORDER BY f.forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
				break;
		}
		if ( !($result = $db->sql_query($sql)) )
		{
			$query_ok = FALSE;
			if (!$started)
			{
				mx_sitemaps_message_die(GENERAL_ERROR, "Could not obtain category data", '', __LINE__, __FILE__, $sql);
			}
		}

		// I do this here to handle sql errors the best possible
		if ( $query_ok )
		{
			$kb_cats = $db->sql_fetchrowset( $result );
			$db->sql_freeresult($result);

			//Output start if necessary
			if (!$started)
			{
				header("Content-type: text/xml");
				$started = true;
				echo $I_header;
			}

			// KB cat loop
			$last_kb_comment = 0;
			for ($x = 0; $x < count($kb_cats); $x++)
			{
				// Only output sitemaps for public Cats with properly set non empty comment forum.
				if ( ($kb_cats[$x]['auth_view'] == '0') && ($kb_cats[$x]['forum_last_post_id']) )
				{
					$kb_forum_id = $kb_cats[$x]['comments_forum_id'];
					$kb_last_mod_time = '<lastmod>' . gmdate('Y-m-d\TH:i:s'.'+00:00',$kb_cats[$x]['post_time']) . '</lastmod>';
					// This get used for the kb cat sitemap
					$last_kb_comment = ( $kb_cats[$x]['post_time'] > $last_kb_comment ) ? $kb_cats[$x]['post_time'] : $last_kb_comment;

					// Either mod rewrite or not for sitemaps
					$kb_sitemap_url = ($Rewrite_sitemap) ? $root_url.'kb-sitemap-'.$kb_cats[$x]['category_id'].'.xml' : $root_url.'sitemap.'.$phpEx.'?kbid='.$kb_cats[$x]['category_id'];

					echo "\t" . '<sitemap>' . "\n";
					echo "\t\t" . '<loc>' .  $kb_sitemap_url . '</loc>' . "\n";
					echo "\t\t" . $kb_last_mod_time . "\n";
					echo "\t" . '</sitemap>' . "\n";
				}
			}

			// Either mod rewrite or not for sitemaps
			$sitemap_kbcat_url = ($Rewrite_sitemap) ? $root_url.'sitemap-kbcat.xml' : $root_url.'sitemap.'.$phpEx.'?kbcat';

			echo "\t" . '<sitemap>' . "\n";
			echo "\t\t" . '<loc>' .  $sitemap_kbcat_url . '</loc>' . "\n";
			echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', $last_ever ) . '</lastmod>' . "\n";
			echo "\t" . '</sitemap>' . "\n";

			unset ($kb_cats);

		}
	}
}
?>
--- NEW FILE: index_forum.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: index_forum.php,v 1.1 2007/07/22 21:17:33 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

if ( !defined('IN_PHPBB') && !defined('IN_PORTAL') )
{
	die('Hacking attempt');
	exit;
}

if ( $is_index )
{
	// Let's build the forum's sitemaps list, while grabbing info usefull for main mx sitemap too
	// Check the forum's last post date and grab all necessary infos
	// Define appropriate sql, The postgresql && oracle one are left as they are in the forum's index
	// Could get rid of user info here, like I did For default, but It works like this with not much harm so ...
	// postgresql && oracle coder welcome to opt thoses ;-)
	switch(SQL_LAYER)
	{
		case 'postgresql':
			$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
				FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
				WHERE p.post_id = f.forum_last_post_id
					AND u.user_id = p.poster_id
					UNION (
						SELECT f.*, NULL, NULL, NULL, NULL
						FROM " . FORUMS_TABLE . " f
						WHERE NOT EXISTS (
							SELECT p.post_time
							FROM " . POSTS_TABLE . " p
							WHERE p.post_id = f.forum_last_post_id
						)
					)
					ORDER BY forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
			break;

		case 'oracle':
			$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
				FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
				WHERE p.post_id = f.forum_last_post_id(+)
				AND u.user_id = p.poster_id(+)
				ORDER BY f.forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
			break;

		default:
			$sql = "SELECT f.*, p.post_time
				FROM ( " . FORUMS_TABLE . " f
				LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
				ORDER BY f.forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
			break;
	}
	if ( !($result = $db->sql_query($sql)) )
	{
			$query_ok = FALSE;
			if (!$started)
			{
				mx_sitemaps_message_die(GENERAL_ERROR, "Could not obtain Forum data", '', __LINE__, __FILE__, $sql);
			}
	}
	$forum_data = array();
	while( $row = $db->sql_fetchrow($result) )
	{
		$forum_data[] = $row;
	}
	$db->sql_freeresult($result);


	// Reset vars
	$forum_sitemap_urls = '';
	$last_mod_time = '';
	$last_mod = array();
	$last_ever = 0;

	//Output start if necessary
	if (!$started)
	{
		header("Content-type: text/xml");
		$started = true;
		echo $I_header;
	}

	if ( ($total_forums = count($forum_data)) && $query_ok)
	{
		// Forum maps loop
		for($j = 0; $j < $total_forums; $j++)
		{
			if ( ($forum_data[$j]['auth_view'] == '0') && ($forum_data[$j]['auth_read'] == '0') && ( $forum_data[$j]['forum_last_post_id'] ) )
			{
				$forum_id = $forum_data[$j]['forum_id'];

				$last_mod_time = '<lastmod>' . gmdate('Y-m-d\TH:i:s'.'+00:00', $forum_data[$j]['post_time']) . '</lastmod>';
				// This get used for sitemap forums
				$last_ever = ( $forum_data[$j]['post_time'] > $last_ever ) ? $forum_data[$j]['post_time'] : $last_ever;

				// Either mod rewrite or not for forum sitemaps
				$forum_sitemap_urls = ($Rewrite_sitemap) ? $root_url.'forum-sitemap-'.$forum_id.'.xml' : $root_url.'sitemap.'.$phpEx.'?fid='.$forum_id;

				echo "\t" . '<sitemap>' . "\n";
				echo "\t\t" . '<loc>' .  $forum_sitemap_urls . '</loc>' . "\n";
				echo "\t\t" . $last_mod_time . "\n";
				echo "\t" . '</sitemap>' . "\n";

			}
		}// End Forum map loop

		//Forum maps locations
		// Either mod rewrite or not for sitemaps
		$sitemap_forums_url = ($Rewrite_sitemap) ? $root_url.'sitemap-forum.xml' : $root_url.'sitemap.'.$phpEx.'?forum';

		echo "\t" . '<sitemap>' . "\n";
		echo "\t\t" . '<loc>' .  $sitemap_forums_url . '</loc>' . "\n";
		echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', $last_ever ) . '</lastmod>' . "\n";
		echo "\t" . '</sitemap>' . "\n";

		unset($forum_data);
	}
}
?>
--- NEW FILE: sitemap_forum.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: sitemap_forum.php,v 1.1 2007/07/22 21:17:36 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

// First basic security
if ( !defined('IN_PHPBB') && !defined('IN_PORTAL') )
{
	die('Hacking attempt');
	exit;
}

// Let's start with checking what to do
$forum_id = ( isset( $HTTP_GET_VARS['fid'] ) ) ? intval( $HTTP_GET_VARS['fid'] ) : FALSE;
$forum_map = ( isset( $HTTP_GET_VARS['forum'] ) ) ? TRUE : FALSE;

// Go for forum if that's what to do
if ($forum_id)
{
	// Check forum auth and grab necessary infos
	$sql = "SELECT f.*, p.post_time
		FROM ". FORUMS_TABLE ." AS f, " . POSTS_TABLE . " AS p
		WHERE f.forum_id = $forum_id
		AND p.post_id = f.forum_last_post_id";
	if ( !($result = $db->sql_query($sql)) )
	{
		mx_sitemaps_message_die(GENERAL_ERROR, "Could not obtain Forum data", '', __LINE__, __FILE__, $sql);
	}
	$forum_data = $db->sql_fetchrow($result);
	$db->sql_freeresult($result);
	if ( ( $forum_data['auth_view'] != '0' ) || ( $forum_data['auth_read'] != '0' ) )
	{
		mx_sitemaps_message_die(GENERAL_MESSAGE, 'Invalid Sitemap');
	}

	// This forum is allowed and has posts, so let's start
	$forum_id = $forum_data['forum_id'];

	// So let's go for max item per query
	if($ggsitemap_config['sitemap_sort'] == "ASC")
	{
		$order = "DESC";
	}
	else
	{
		$order = "ASC";
	}

	$sql = "SELECT topic_last_post_id
			FROM " . TOPICS_TABLE . "
			WHERE forum_id = $forum_id
			ORDER BY topic_last_post_id $order
			LIMIT 1";
	if ( !($result = $db->sql_query($sql)) )
	{
		mx_sitemaps_message_die(GENERAL_ERROR, 'Error getting topic information', '', __LINE__, __FILE__, $sql);
	}
	$result = $db->sql_fetchrow($result);
	$lastid = $result['topic_last_post_id'];

	$sql = "SELECT COUNT(topic_id) AS forum_topics
			FROM " . TOPICS_TABLE . "
			WHERE forum_id = $forum_id";
	if ( !($result = $db->sql_query($sql)) )
	{
		mx_sitemaps_message_die(GENERAL_ERROR, 'Could not obtain limited topics count information', '', __LINE__, __FILE__, $sql);
	}
	$row = $db->sql_fetchrow($result);

	$topics_count = ( $row['forum_topics'] ) ? $row['forum_topics'] : 1;

	$forum_url = 'viewforum.' . $phpEx . '?f=' . $forum_id;

	//Output start
	header("Content-type: text/xml");
	$started = true;
	echo $S_header;
	echo "\t" . '<url>' . "\n";
	echo "\t\t" . '<loc>' .  $server_url . $forum_url . '</loc>' . "\n";
	echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', $forum_data['post_time']) . '</lastmod>' . "\n";
	echo "\t\t" . '<changefreq>always</changefreq>' . "\n";
	echo "\t\t" . '<priority>1.0</priority>' . "\n";
	echo "\t" . '</url>' . "\n";

	// Absolute limit
	$topic_sofar = 0;
	// topic limit per query
	$last_topic = 0;
	while( ( $lasttopic != $lastid ) && ( $topic_sofar <  $topics_count ) && ($topic_sofar < $url_limit) )
	{
		$result = "";
		//Newest topics first
		if(is_numeric($lasttopic) && $ggsitemap_config['sitemap_sort'] == "ASC")
		{
			$lasttopic++;
			$wheresql = "AND t.topic_last_post_id >= $lasttopic";
		}
		//Oldest topics first
		elseif(is_numeric($lasttopic))
		{
			$lasttopic--;
			$wheresql = "AND t.topic_last_post_id <= $lasttopic";
		}
		else
		{
			$wheresql = "";
		}
		$sql = "SELECT t.topic_id, t.topic_type, t.topic_status, t.topic_replies, p.post_time
				FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p
				WHERE t.topic_last_post_id=p.post_id
				AND t.forum_id = $forum_id
				$wheresql
				ORDER BY t.topic_last_post_id " . $ggsitemap_config['sitemap_sort'] . "
				LIMIT $topic_sofar,$sql_limit";

		if ( !($result = $db->sql_query($sql)) )
		{
			$query_ok = FALSE;
			if (!$started)
			{
				mx_sitemaps_message_die(GENERAL_ERROR, "Could not obtain category data", '', __LINE__, __FILE__, $sql);
			}
		}

		// I do this here to handle sql errors the best possible
		if ( $query_ok )
		{
			$topics = $db->sql_fetchrowset($result);
			$db->sql_freeresult($result);

			// Simple result limit used to separate query here too ;-)
			$topic_sofar = $topic_sofar + $sql_limit;

			for ($x = 0; $x < count($topics); $x++)
			{
				$topic = $topics[$x];
				$topic_url = 'viewtopic.' . $phpEx . '?t=' . $topic['topic_id'];
				switch ($topic['topic_type'])
				{
					case 2:
						$topic_priority = $ggsitemap_config['sitemap_announce_priority'];
						break;
					case 1:
						$topic_priority = $ggsitemap_config['sitemap_sticky_priority'];
						break;
					default:
						$topic_priority = $ggsitemap_config['sitemap_default_priority'];
				}
				if ($topic['topic_status'] == 1)
				{
					$topic_change = "never";
				}
				else
				{
					$topic_change = "always";
				}
				$paginated = $board_config['posts_per_page'];
				if($topic['topic_replies'] > $paginated)
				{
					// Reset Pages limits for this topic
					$pag_limit1 = $ggsitemap_config['sitemap_limitdown'];
					$pag_limit2 = $ggsitemap_config['sitemap_limitup'];
					$pages = ceil($topic['topic_replies'] / $paginated);

					// If $pag_limit2 too big for this topic, lets output all pages
					$pag_limit2 = ( $pages < $pag_limit2 ) ?  ($pages - 1) :  $pag_limit2;

					$i=0;
					while ( ($i <= $pages) )
					{
						if ( ( $i <= $pag_limit1 ) || ( $i > ($pages - $pag_limit2 ) ) )
						{
							$start = ( $i == 0 ) ? '' : "&amp;start=" . $paginated * $i;
							echo "\t" . '<url>' . "\n";
							echo "\t\t" . '<loc>' .  $server_url . $topic_url . $start . '</loc>' . "\n";
							echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', $topic['post_time']) . '</lastmod>' . "\n";
							echo "\t\t" . '<changefreq>' .  $topic_change . '</changefreq>' . "\n";
							echo "\t\t" . '<priority>' .  $topic_priority . '</priority>' . "\n";
							echo "\t" . '</url>' . "\n";

							$i++;
							$topic_sofar++;
						}
						else
						{
							$i++;
							$topic_sofar++;
						}
					}
				}
				else
				{

					echo "\t" . '<url>' . "\n";
					echo "\t\t" . '<loc>' .  $server_url . $topic_url . '</loc>' . "\n";
					echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', $topic['post_time']) . '</lastmod>' . "\n";
					echo "\t\t" . '<changefreq>' .  $topic_change . '</changefreq>' . "\n";
					echo "\t\t" . '<priority>' .  $topic_priority . '</priority>' . "\n";
					echo "\t" . '</url>' . "\n";

				}
			$lasttopic = $topic['topic_last_post_id'];
			}// End topic loop
			unset($topics);
			unset($topic);
		}

	}// End Query limit loop
	// Dump the page since there's nothing left to do
	echo $S_footer;
	exit;

} // End Forum sitemaps
elseif ($forum_map)
{
	// Check the forum's last post date and grab all necessary infos
	// Define appropriate sql, The postgresql && oracle one are left as they are in the forum's index
	// Could get rid of user info here, like I did For default, but It works like this with not much arm so ...
	// postgresql && oracle coder welcome to opt thoses here too ;-)
	switch(SQL_LAYER)
	{
		case 'postgresql':
			$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
				FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
				WHERE p.post_id = f.forum_last_post_id
					AND u.user_id = p.poster_id
					UNION (
						SELECT f.*, NULL, NULL, NULL, NULL
						FROM " . FORUMS_TABLE . " f
						WHERE NOT EXISTS (
							SELECT p.post_time
							FROM " . POSTS_TABLE . " p
							WHERE p.post_id = f.forum_last_post_id
						)
					)
					ORDER BY forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
			break;

		case 'oracle':
			$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
				FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
				WHERE p.post_id = f.forum_last_post_id(+)
				AND u.user_id = p.poster_id(+)
				ORDER BY f.forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
			break;

		default:
			$sql = "SELECT f.*, p.post_time
				FROM ( " . FORUMS_TABLE . " f
				LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
				ORDER BY f.forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
			break;
	}
	if ( !($result = $db->sql_query($sql)) )
	{
		mx_sitemaps_message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
	}
	$forum_datas = array();
	while( $row = $db->sql_fetchrow($result) )
	{
		$forum_datas[] = $row;
	}
	$db->sql_freeresult($result);

	//Output start
	header("Content-type: text/xml");
	$started = true;
	echo $S_header;

	// Forums loop
	$last_ever = 0;
	if ($total_forums = count($forum_datas))
	{
		for($j = 0; $j < $total_forums; $j++)
		{
			if ( ($forum_datas[$j]['auth_view'] == '0') && ($forum_datas[$j]['auth_read'] == '0') )
			{
				$forum_id = $forum_datas[$j]['forum_id'];
				$last_mod_time = ( $forum_datas[$j]['forum_last_post_id'] ) ? '<lastmod>' . gmdate('Y-m-d\TH:i:s'.'+00:00', $forum_datas[$j]['post_time']) . '</lastmod>': '';

				// This get used for the Forum index location
				$last_ever = ( $forum_datas[$j]['post_time'] > $last_ever ) ? $forum_datas[$j]['post_time'] : $last_ever;

				$forum_urls = $server_url . 'viewforum.' . $phpEx . '?f=' . $forum_id;

				echo "\t" . '<url>' . "\n";
				echo "\t\t" . '<loc>' .  $forum_urls . '</loc>' . "\n";
				echo "\t\t" . $last_mod_time . "\n";
				echo "\t\t" . '<changefreq>always</changefreq>' . "\n";
				echo "\t\t" . '<priority>1.0</priority>' . "\n";
				echo "\t" . '</url>' . "\n";

			}
		}
	}// End Forum map loop

	// Forum index location
	echo "\t" . '<url>' . "\n";
	echo "\t\t" . '<loc>' .  $server_url . "index." . $phpEx . '</loc>' . "\n";
	echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', $last_ever ) . '</lastmod>' . "\n";
	echo "\t\t" . '<changefreq>always</changefreq>' . "\n";
	echo "\t\t" . '<priority>1.0</priority>' . "\n";
	echo "\t" . '</url>' . "\n";
	unset ($forum_datas);

	// Dump the page since there's nothing left to do
	echo $S_footer;
	exit;
} // End sitemap forums
?>
--- NEW FILE: index.htm ---
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">

</body>
</html>

--- NEW FILE: sitemap_kb.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: sitemap_kb.php,v 1.1 2007/07/22 21:17:36 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

if ( !defined('IN_PHPBB') && !defined('IN_PORTAL') )
{
	die('Hacking attempt');
	exit;
}

// Check if installed and how
if ( ( defined('IN_PORTAL') ) && file_exists( $module_root_path . 'mx_kb/includes/functions_kb.php' ) )
{
	$kb_installed = TRUE;
	define( 'KB_CATEGORIES_TABLE', $mx_table_prefix . 'kb_categories' );
	define( 'KB_ARTICLES_TABLE', $mx_table_prefix . 'kb_articles' );
	// Then set kb's page ID
	$page_id = $ggsitemap_config['sitemap_kb_mx_page'];
	// Built KB url
	$kb_page_url = 'index.'.$phpEx.'?page='.$page_id;
}
elseif ( file_exists( $phpbb_root_path . 'includes/functions_kb.php' ) )
{
	$kb_installed = TRUE;
	define( 'KB_CATEGORIES_TABLE', $table_prefix . 'kb_categories' );
	define( 'KB_ARTICLES_TABLE', $table_prefix . 'kb_articles' );
	$kb_page_url = 'kb.' . $phpEx;
}

// Let's start with checking what to do
$kb_cat_id = ( isset( $HTTP_GET_VARS['kbid'] ) ) ? intval( $HTTP_GET_VARS['kbid'] ) : FALSE;
$kb_cat_map = ( isset( $HTTP_GET_VARS['kbcat'] ) ) ? TRUE : FALSE;

// Asking for a kb cat sitemap ?
if ($kb_cat_id)
{
	if ( $kb_installed )
	{
		// check for kb cat auth and grab necessary datas
		$sql = "SELECT c.category_id, c.category_name, c.auth_view, p.post_time
       			FROM ".KB_CATEGORIES_TABLE." AS c, " . FORUMS_TABLE . " AS f, " . POSTS_TABLE . " AS p
			WHERE category_id = $kb_cat_id
			AND f.forum_id = c.comments_forum_id
			AND p.post_id = f.forum_last_post_id";
		if ( !($result = $db->sql_query($sql)) )
		{
			mx_sitemaps_message_die(GENERAL_ERROR, "Could not obtain category data", '', __LINE__, __FILE__, $sql);
		}

		$kb_cats = $db->sql_fetchrow( $result );
		$db->sql_freeresult($result);

		if ( $kb_cats['auth_view'] != '0' )
		{
			mx_sitemaps_message_die(GENERAL_MESSAGE, 'Invalid Sitemap');
		}

		// This cat is allowed, and has comment forum properly set so let's start
		$kb_cat_id = $kb_cats['category_id'];

		// So let's go for max item per query
		if($ggsitemap_config['sitemap_sort'] == "ASC")
		{
			$order = "DESC";
		}
		else
		{
			$order = "ASC";
		}

		$sql = "SELECT a.article_id, a.topic_id, t.topic_id, t.topic_last_post_id
				FROM " . KB_ARTICLES_TABLE . " AS a, " . TOPICS_TABLE . " AS t
				WHERE article_category_id = $kb_cat_id
				AND t.topic_id = a.topic_id
				ORDER BY t.topic_last_post_id $order
				LIMIT 1";
		if ( !($result = $db->sql_query($sql)) )
		{
			mx_sitemaps_message_die(GENERAL_ERROR, 'Error getting topic information', '', __LINE__, __FILE__, $sql);
		}
		$result = $db->sql_fetchrow($result);
		$last_kb_id = $result['topic_last_post_id'];

		$sql = "SELECT COUNT(article_id) AS cat_articles
			FROM " . KB_ARTICLES_TABLE . "
			WHERE article_category_id = $kb_cat_id";
		if ( !($result = $db->sql_query($sql)) )
		{
			mx_sitemaps_message_die(GENERAL_ERROR, 'Could not obtain limited topics count information', '', __LINE__, __FILE__, $sql);
		}
		$row = $db->sql_fetchrowset($result);
		$db->sql_freeresult($result);
		$article_count = ( $row['cat_articles'] ) ? $row['cat_articles'] : 1;

		//Output start
		header("Content-type: text/xml");
		$started = true;
		echo $S_header;
		echo "\t" . '<url>' . "\n";
		echo "\t\t" . '<loc>' .  $root_url . $kb_page_url . '&amp;mode=cat&amp;cat=' . $kb_cat_id . '</loc>' . "\n";
		echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', $kb_cats['post_time'] ) . '</lastmod>' . "\n";
		echo "\t\t" . '<changefreq>always</changefreq>' . "\n";
		echo "\t\t" . '<priority>1.0</priority>' . "\n";
		echo "\t" . '</url>' . "\n";

		// Absolute limit
		$article_sofar = 0;
		// topic limit per query
		$last_article = 0;
		while( ( $last_kb_art != $last_kb_id ) && ( $article_sofar <  $article_count ) && ($article_sofar < $url_limit) )
		{
			//Newest articles first
			if(is_numeric($last_kb_art) && $ggsitemap_config['sitemap_sort'] == "ASC")
			{
				$last_kb_art++;
				$wheresql = "AND t.topic_last_post_id >= $last_kb_art";
			}
			//Oldest articles first
			elseif(is_numeric($last_kb_art))
			{
				$last_kb_art--;
				$wheresql = "AND t.topic_last_post_id <= $last_kb_art";
			}
			else
			{
				$wheresql = "";
			}
			// Select only approved articles
			$sql = "SELECT a.article_id, a.article_category_id, a.article_title, a.article_date, a.approved, a.topic_id, p.post_time
					FROM " . KB_ARTICLES_TABLE . " AS a, " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p
					WHERE a.article_category_id = $kb_cat_id
					$wheresql
					AND a.approved = 1
					AND t.topic_id = a.topic_id
					AND p.post_id = t.topic_last_post_id
					ORDER BY t.topic_last_post_id " . $ggsitemap_config['sitemap_sort'] . "
					LIMIT $article_sofar,$sql_limit";
			if ( !( $article_result = $db->sql_query( $sql ) ) )
			{
				$query_ok = FALSE;
				if (!$started)
				{
					mx_sitemaps_message_die(GENERAL_ERROR, "Could not obtain category data", '', __LINE__, __FILE__, $sql);
				}
			}

			// I do this here to handle sql errors the best possible
			if ( $query_ok )
			{
				$kb_articles = $db->sql_fetchrowset($article_result);
				$db->sql_freeresult($article_result);

				// Simple result limit used to separate query here too ;-)
				$article_sofar = $topic_sofar + $sql_limit;

				for ($x = 0; $x < count($kb_articles); $x++)
				{
					$kb_article = $kb_articles[$x];

					echo "\t" . '<url>' . "\n";
					echo "\t\t" . '<loc>' .  $root_url . $kb_page_url . '&amp;mode=article&amp;k=' . $kb_article['article_id'] . '</loc>' . "\n";
					echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', $kb_article['post_time'] ) . '</lastmod>' . "\n";
					echo "\t\t" . '<changefreq>always</changefreq>' . "\n";
					echo "\t\t" . '<priority>1.0</priority>' . "\n";
					echo "\t" . '</url>' . "\n";

					$last_kb_art = $kb_article['article_id'];
				}// End article loop
				unset ($kb_cats);
				unset ($kb_articles);
			}

		}// End Query limit loop

		// Dump the page since there's nothing left to do
		echo $S_footer;
		exit;
	}
}
// Why not a kb cat sitemap if asked for
elseif ($kb_cat_map)
{
	if ( KB_INSTALLED )
	{
		// Here, some postgresql && oracle wizards are welcome to validate this switch
		// I just could not test it, and by the way am not a postgresql && oracle guru :-)
		switch(SQL_LAYER)
		{
			case 'postgresql':
				$sql = "SELECT c.*, p.post_time, p.post_username, u.username, u.user_id
					FROM " . KB_CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p
					WHERE f.forum_id = c.comments_forum_id
						AND p.post_id = f.forum_last_post_id
						UNION (
							SELECT c.*, NULL, NULL, NULL, NULL
							FROM " . KB_CATEGORIES_TABLE . " c
							WHERE NOT EXISTS (
								SELECT p.post_time
								FROM " . POSTS_TABLE . " p
								WHERE p.post_id = f.forum_last_post_id
							)
						)
						ORDER BY forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
				break;

			case 'oracle':
				$sql = "SELECT c.*, p.post_time, p.post_username, u.username, u.user_id
						FROM " . FORUMS_TABLE . " f, " . POSTS_TABLE . " p, " . USERS_TABLE . " u
						WHERE f.forum_id = c.comments_forum_id(+)
						AND p.post_id = f.forum_last_post_id(+)
						ORDER BY f.forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
				break;

			default:
				$sql = "SELECT c.category_id, c.category_name, c.auth_view, p.post_time, f.forum_last_post_id
						FROM (( " . KB_CATEGORIES_TABLE . " c
						LEFT JOIN " . FORUMS_TABLE . " f ON f.forum_id = c.comments_forum_id )
						LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
						ORDER BY f.forum_last_post_id " . $ggsitemap_config['sitemap_sort'];
				break;
		}

		if ( !($result = $db->sql_query($sql)) )
		{
			mx_sitemaps_message_die(GENERAL_ERROR, "Could not obtain category data", '', __LINE__, __FILE__, $sql);
		}

		$kb_cats = $db->sql_fetchrowset( $result );
		$db->sql_freeresult($result);

		//Output start
		header("Content-type: text/xml");
		$started = true;
		echo $S_header;

		// Cat loop
		$last_kb_comment = 0;
		for ($x = 0; $x < count($kb_cats); $x++)
		{
			if ( ($kb_cats[$x]['auth_view'] == '0') )
			{
				$kb_last_mod_time = (  $kb_cats[$x]['forum_last_post_id'] ) ? '<lastmod>' . gmdate('Y-m-d\TH:i:s'.'+00:00', $kb_cats[$x]['post_time']) . '</lastmod>': '';

				$last_kb_comment = ( $kb_cats[$x]['post_time'] > $last_ever ) ? $kb_cats[$x]['post_time'] : $last_ever;

				echo "\t" . '<url>' . "\n";
				echo "\t\t" . '<loc>' .  $root_url . $kb_page_url . '&amp;mode=cat&amp;cat=' . $kb_cats[$x]['category_id'] . '</loc>' . "\n";
				echo "\t\t" . $kb_last_mod_time . "\n";
				echo "\t\t" . '<changefreq>always</changefreq>' . "\n";
				echo "\t\t" . '<priority>1.0</priority>' . "\n";
				echo "\t" . '</url>' . "\n";

			}
		}

		// KB index location
		echo "\t" . '<url>' . "\n";
		echo "\t\t" . '<loc>' .  $root_url . $kb_page_url . '</loc>' . "\n";
		echo "\t\t" . '<lastmod>' .  gmdate('Y-m-d\TH:i:s'.'+00:00', $last_kb_comment ) . '</lastmod>' . "\n";
		echo "\t\t" . '<changefreq>always</changefreq>' . "\n";
		echo "\t\t" . '<priority>1.0</priority>' . "\n";
		echo "\t" . '</url>' . "\n";

		unset ($kb_cats);

		// Dump the page since there's nothing left to do
		echo $S_footer;
		exit;
	}
	else
	{
		mx_sitemaps_message_die(GENERAL_MESSAGE, 'Invalid sitemap kb cat');
	}
}
?>

[mxbb-commits] mx_ggsitemaps db_install.php, NONE, 1.1 db_uninstall.php, NONE, 1.1 db_upgrade.php, NONE, 1.1 mx_ggsitemap.pak, NONE, 1.1

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10068

Added Files:
	db_install.php db_uninstall.php db_upgrade.php 
	mx_ggsitemap.pak 
Log Message:
Added this module, for now, so i do not loose it

--- NEW FILE: mx_ggsitemap.pak ---
module=+:60=+:mx Google Sitemaps=+:modules/mx_ggsitemaps/=+:Google sitemaps generator=+:1
function=+:0=+:0=+:0=+:endoflist=+:0=+:0

--- NEW FILE: db_uninstall.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: db_uninstall.php,v 1.1 2007/07/22 21:17:27 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

// Edited by dcz to both fit mx and phpbb.
// Added multi language support.

if ( file_exists( 'viewtopic.php' ) )
{
	define('IN_PHPBB', true);
	$module_root_path2 = $phpbb_root_path = $mx_root_path = './';
	$module_root_path = $mx_root_path . 'mx_ggsitemaps/';
}
else
{
	define('IN_PORTAL', true);
	$mx_root_path = '../../';
	$module_root_path2 = $module_root_path = '../modules/mx_ggsitemaps/';
}

if ( !defined('IN_ADMIN') )
{

  $phpEx = substr(strrchr(__FILE__, '.'), 1);
  include($mx_root_path . 'common.'.$phpEx);

  //
  // Start session management
  //
  $userdata = session_pagestart($user_ip, PAGE_INDEX);
  if (defined('IN_PORTAL'))
  {
	  mx_init_userprefs($userdata);
  }
  if (defined('IN_PHPBB'))
  {
	 init_userprefs($userdata);
	 $mx_table_prefix = $table_prefix;
  }

  if( !$userdata['session_logged_in'] )
	{
   		die("Hacking attempt(3)");
	}

	if( $userdata['user_level'] != ADMIN )
	{
   		die("Hacking attempt(4)");
	}
  //
  // End session management
  //
}

//
// Include common module stuff...
//
require($module_root_path . 'includes/common_GGsitemaps.' . $phpEx);


$message = $lang['Google_uninstall'];
$sql = array(
	"DROP TABLE ".$mx_table_prefix."ggsitemap_config",
	);


$n = 0;
while($sql[$n])
{
	$message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br />' : '';
	if(!$result = $db->sql_query($sql[$n]))
	{
		$message .= '<b><font color=#FF0000>'. $lang['Google_unerror'] .($n+1).' , '.$sql[$n].'<br />';
	}
	else
	{
		$message .='<b><font color=#0000fF>' . $lang['Google_unsql_ok'] .($n+1).' , '.$sql[$n].'<br />';
	}
	$n++;
}

$message .= '<br />' . $lang['Google_general'];
echo "<br /><br />";
echo "<table  cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">";
echo "<tr><th class=\"thHead\" align=\"center\">".$lang['Google_uninstal_info']."</th></tr>";
echo "<tr><td class=\"row1\"  align=\"center\"><span class=\"gen\">" . $message . "</span></td></tr>";
echo "</table><br />";

?>
--- NEW FILE: db_install.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: db_install.php,v 1.1 2007/07/22 21:17:26 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

// Edited by to both fit mx and phpbb.
// Added multi language support.
if ( file_exists( 'viewtopic.php' ) )
{
	define('IN_PHPBB', true);
	$module_root_path2 = $phpbb_root_path = $mx_root_path = './';
	$module_root_path = $mx_root_path . 'mx_ggsitemaps/';
}
else
{
	define('IN_PORTAL', true);
	$mx_root_path = '../../';
	$module_root_path2 = $module_root_path = '../modules/mx_ggsitemaps/';
}

if ( !defined('IN_ADMIN') )
{

  $phpEx = substr(strrchr(__FILE__, '.'), 1);
  include($mx_root_path . 'common.'.$phpEx);

  //
  // Start session management
  //
  $userdata = session_pagestart($user_ip, PAGE_INDEX);
  if (defined('IN_PORTAL'))
  {
	  mx_init_userprefs($userdata);
  }
  if (defined('IN_PHPBB'))
  {
	 init_userprefs($userdata);
	 $mx_table_prefix = $table_prefix;
  }

  if( !$userdata['session_logged_in'] )
	{
   		die("Hacking attempt(3)");
	}

	if( $userdata['user_level'] != ADMIN )
	{
   		die("Hacking attempt(4)");
	}
  //
  // End session management
  //
}

$mx_module_version = '2.0.0';
$mx_module_copy = 'Original phpBB <i>Google Sitemaps</i> MOD by <a href="http://www.mxbb.net/" target="_blank">dcz</a> :: Adapted for mxBB by <a href="http://www.mxbb.net" target="_blank">dcz</a> & <a href="http://www.mxbb.net" target="_blank">Jon</a>';

//
// Include common module stuff...
//
require($module_root_path . 'includes/common_GGsitemaps.' . $phpEx);


$message = $lang['Google_install'];

$sql = array(
		"DROP TABLE IF EXISTS ".$mx_table_prefix."ggsitemap_config",

		"CREATE TABLE ".$mx_table_prefix."ggsitemap_config(
		config_name varchar(255) NOT NULL,
		config_value varchar(255) NOT NULL,
		PRIMARY KEY (config_name)
		)",

		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_sql_limit', '200')",
		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_url_limit', '2500')",
		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_sort', 'DESC')",
		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_rewrited', 'FALSE')",

		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_announce_priority', '0.5')",
		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_default_priority', '1.0')",
		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_sticky_priority', '0.75')",
		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_limitdown', '5')",
		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_limitup', '5')",

		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_kb_mx_page', 'FALSE')",
		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_c_info', '(C) 2006 dcz - http://www.phpbb-seo.com/')",
		"INSERT INTO ".$mx_table_prefix."ggsitemap_config VALUES ('sitemap_ver', 'v1.0.0RC2')",

);

$sql[] = "UPDATE " . $mx_table_prefix . "module" . "
			    SET module_version  = '" . $mx_module_version . "',
			      module_copy  = '" . $mx_module_copy . "'
			    WHERE module_id = '" . $mx_module_id . "'";

$n = 0;
$message .= '<b>' . $lang['Google_install_ok'] . '</b><br /><br />';
while($sql[$n])
{
	$message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br />' : '';
	if(!$result = $db->sql_query($sql[$n]))
	{
		$message .= '<b><font color=#FF0000>' . $lang['Google_error'] .($n+1).' , '.$sql[$n].'<br />';
	}
	else
	{
		$message .='<b><font color=#0000fF>' . $lang['Google_sql_ok'] .($n+1).' , '.$sql[$n].'<br />';
	}
	$n++;
}

$message .= '<br />' . $lang['Google_general'];
echo "<br /><br />";
echo "<table  cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">";
echo "<tr><th class=\"thHead\" align=\"center\">".$lang['Google_instal_info']."</th></tr>";
echo "<tr><td class=\"row1\"  align=\"center\"><span class=\"gen\">" . $message . "</span></td></tr>";
echo "</table><br />";

?>
--- NEW FILE: db_upgrade.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_phpbb2admin
* @version $Id: db_upgrade.php,v 1.1 2007/07/22 21:17:27 jonohlsson Exp $
* @copyright (c) 2002-2006 [menalto.gallery.com, Jon Ohlsson] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

define( 'IN_PORTAL', true );

if ( !defined( 'IN_ADMIN' ) )
{
	$mx_root_path = './../../';
	$phpEx = substr(strrchr(__FILE__, '.'), 1);
	include( $mx_root_path . 'common.' . $phpEx );
	// Start session management
	$mx_user->init($user_ip, PAGE_INDEX);

	if ( !$userdata['session_logged_in'] )
	{
		die( "Hacking attempt(1)" );
	}

	if ( $userdata['user_level'] != ADMIN )
	{
		die( "Hacking attempt(2)" );
	}
	// End session management
}

$mx_module_version = '2.0.0';
$mx_module_copy = 'Original phpBB <i>Google Sitemaps</i> MOD by <a href="http://www.mxbb.net/" target="_blank">dcz</a> :: Adapted for mxBB by <a href="http://www.mxbb.net" target="_blank">dcz</a> & <a href="http://www.mxbb.net" target="_blank">Jon</a>';

$message = "<b>Upgrading!</b><br/><br/>";

$sql = array();

$sql[] = "UPDATE " . $mx_table_prefix . "module" . "
			    SET module_version  = '" . $mx_module_version . "',
			      module_copy  = '" . $mx_module_copy . "'
			    WHERE module_id = '" . $mx_module_id . "'";

$message .= mx_do_install_upgrade( $sql );
$message .= "<b>...Now upgraded to v. $mx_module_version :-)</b><br/><br/>";

echo "<br /><br />";
echo "<table  width=\"90%\" align=\"center\" cellpadding=\"4\" cellspacing=\"1\" border=\"0\" class=\"forumline\">";
echo "<tr><th class=\"thHead\" align=\"center\">Module Installation/Upgrading/Uninstalling Information - module specific db tables</th></tr>";
echo "<tr><td class=\"row1\"  align=\"left\"><span class=\"gen\">" . $message . "</span></td></tr>";
echo "</table><br />";

?>

[mxbb-commits] mx_ggsitemaps/admin admin_mx_ggsitemap.php, NONE, 1.1 index.htm, NONE, 1.1

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/admin
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv10068/admin

Added Files:
	admin_mx_ggsitemap.php index.htm 
Log Message:
Added this module, for now, so i do not loose it

--- NEW FILE: admin_mx_ggsitemap.php ---
<?php
/**
*
* @package mxBB Portal Module - mx_ggsitemaps
* @version $Id: admin_mx_ggsitemap.php,v 1.1 2007/07/22 21:17:25 jonohlsson Exp $
* @copyright (c) 2002-2006 [www.phpbb-seo.com] mxBB Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU General Public License v2
*
*/

if ( file_exists( 'admin_board.php' ) )
{
	define('IN_PHPBB', 1);
	$admin_root_path1 = $admin_root_path2 = './';
	$module_root_path2 = $phpbb_root_path = $mx_root_path = '../';
	$module_root_path =  $mx_root_path . 'mx_ggsitemaps/';
	$pathkb = '';
}
else
{
	define('IN_PORTAL', 1);
	$mx_root_path = '../../../';
	$admin_root_path1 = $mx_root_path . 'admin/';
	$admin_root_path2 = $mx_root_path . 'modules/mx_ggsitemaps/admin/';
	$module_root_path2 = $module_root_path = '../';

	$pathkb = 'modules/mx_kb/';
}

if( !empty($setmodules) )
{
  $filename = basename(__FILE__);
  $module['Mx_SiteMaps']['Google_SiteMaps'] = $admin_root_path2 . $filename;

  return;
}

$phpEx = substr(strrchr(__FILE__, '.'), 1);
require($mx_root_path . 'admin/pagestart.' . $phpEx);

//
// Include common module stuff...
//
require($module_root_path . 'includes/common_GGsitemaps.' . $phpEx);

//
// Begin program proper
//

$mode = "";

if( isset($HTTP_POST_VARS['submit']) )
{
	$mode = "submit";
}

// Pull all config data

$sql = "SELECT * FROM " . GGSITEMAP_TABLE;
if ( !$result = $db->sql_query( $sql ) )
{
	message_die( CRITICAL_ERROR, "Could not query Google sitemap configuration information ", "", __LINE__, __FILE__, $sql );
}
else
{
	while( $row = $db->sql_fetchrow($result) )
	{
		$config_name = $row['config_name'];
		$config_value = $row['config_value'];
		$default_config[$config_name] = isset($HTTP_POST_VARS['submit']) ? str_replace("'", "\'", $config_value) : $config_value;

		$new[$config_name] = ( isset($HTTP_POST_VARS[$config_name]) ) ? $HTTP_POST_VARS[$config_name] : $default_config[$config_name];

		// Ok let's update config if necessary
		if( $mode == "submit" )
		{
			// The dumb guy checks ;-)
			if ( ( $config_name == 'sitemap_announce_priority' ) && ( ( $config_value < 0 ) || ( $config_value > 1 ) ) )
			{
				$new[$config_name] = '1.0';
			}
			if ( ($config_name == 'sitemap_default_priority' ) && ( ( $config_value < 0 ) || ( $config_value > 1 ) ) )
			{
				$new[$config_name] = '1.0';
			}
			if ( ($config_name == 'sitemap_sticky_priority' ) && ( ( $config_value < 0 ) || ( $config_value > 1 ) ) )
			{
				$new[$config_name] = '1.0';
			}
			if ( ($config_name == 'sitemap_url_limit' ) && ( ( $config_value < 0 ) || ( $config_value > 50000 ) ) )
			{
				$new[$config_name] = 40000;
			}
			if ( ($config_name == 'sitemap_sql_limit' ) && ( ( $config_value < 0 ) || ( $config_value > 1000 ) ) )
			{
				$new[$config_name] = 200;
			}
			if ( ($config_name == 'sitemap_limitup' ) && ( ( $config_value < 0 ) || ( $config_value > 1000 ) ) )
			{
				$new[$config_name] = 50;
			}
			if ( ($config_name == 'sitemap_limitdown' ) && ( ( $config_value < 0 ) || ( $config_value > 1000 ) ) )
			{
				$new[$config_name] = 50;
			}
			if ( ($config_name == 'sitemap_rewrited' ) && ( ( $config_value != "TRUE" ) && ( $config_value != "FALSE" ) ) )
			{
				$new[$config_name] = "FALSE";
			}
			if ( ($config_name == 'sitemap_ver' ) && ( $config_value != "v1.0.0RC2" ) )
			{
				$new[$config_name] = "v1.0.0RC2";
			}
			if ( ($config_name == 'sitemap_c_info' ) && ( $config_value != "(C) 2006 dcz - http://www.phpbb-seo.com/" ) )
			{
				$new[$config_name] = "(C) 2006 dcz - http://www.phpbb-seo.com/";
			}
			if ( ($config_name == 'sitemap_kb_mx_page' ) && ( $config_value < 0  ) )
			{
				$new[$config_name] = "FALSE";
			}

			$sql = "UPDATE " . GGSITEMAP_TABLE . " SET
				config_value = '" . str_replace("\'", "''", $new[$config_name]) . "'
				WHERE config_name = '$config_name'";
			if( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, "Failed to update Google sitemap configuration ", "", __LINE__, __FILE__, $sql);
			}
		}
	}

	// Send a nice message if config updated
	if( $mode == "submit" )
	{
		$message = $lang['Google_Config_updated'] . "<br /><br />" . sprintf($lang['Click_return_ggsitemap_config'], "<a href=\"" . append_sid($admin_root_path2 . "admin_mx_ggsitemap.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid($admin_root_path1 . "index.$phpEx?pane=right") . "\">", "</a>");

		message_die(GENERAL_MESSAGE, $message);
	}
}

// We shall build the page then
$template->set_filenames(array(
	"admin_ggsitemap" => "admin/admin_mx_ggsitemap.tpl")
);

$sitemap_sort_desc = ( $new['sitemap_sort'] == "DESC" ) ? "checked=\"checked\"" : "";
$sitemap_sort_asc = ( $new['sitemap_sort'] == "ASC" ) ? "checked=\"checked\"" : "";
$rewrite_sitemaps_no = ( $new['sitemap_rewrited'] == "FALSE" ) ? "checked=\"checked\"" : "";
$rewrite_sitemaps_yes = ( $new['sitemap_rewrited'] == "TRUE" ) ? "checked=\"checked\"" : "";

$template->assign_vars(array(
	"L_CONFIGURATION_TITLE" => $lang['Sitemap_conf_title'],
	"L_CONFIGURATION_EXPLAIN" => sprintf($lang['Sitemap_conf_explain'], "<a href=\"http://www.google.com/webmasters/sitemaps/login\" target=\"_Google\">", "</a>") . '<br />' . sprintf($lang['Sitemap_conf_explain2'], "<a href=\"http://www.google.fr/search?hl=all&q=google+sitemap+submitter&btnG=Rechercher&meta=\" target=\"_Google\">", "</a>"),

	"S_CONFIG_ACTION" => append_sid($admin_root_path2 . "admin_mx_ggsitemap.$phpEx"),

	"L_SITEMAP_SETTINGS" => $lang['Sitemap_settings'],
	"L_SQL_LIMIT" => $lang['Sql_limit'],
	"L_SQL_LIMIT_EXPLAIN" => $lang['Sql_limit_explain'],
	"L_DEFAULT_LIMIT" => $lang['Default_limit'],
	"L_DEFAULT_LIMIT_EXPLAIN" => $lang['Default_limit_explain'],
	"L_SORT_ORDER" => $lang['Sort_order'],
	"L_SORT_ORDER_EXPLAIN" => $lang['Sort_order_explain'],
	"L_NEW_FIRST" => $lang['New_first'],
	"L_OLD_FIRST" => $lang['Old_first'],
	"L_S_MOD_REWRITE" => $lang['Mod_rewrite_S'],
	"L_S_MOD_REWRITE_EXPLAIN" => $lang['Mod_rewrite_S_explain'],
	"L_YES" => $lang['Yes'],
	"L_NO" => $lang['No'],

	"L_SITEMAP_FORUM_SET" => $lang['Sitemap_Forum_set'],
	"L_ANNOUNCE_PRIORITY" => $lang['Announce_priority'],
	"L_ANNOUNCE_PRIORITY_EXPLAIN" => $lang['Announce_priority_explain'],
	"L_STICKY_PRIORITY" => $lang['Sticky_priority'],
	"L_STICKY_PRIORITY_EXPLAIN" => $lang['Sticky_priority_explain'],
	"L_DEFAULT_PRIORITY" => $lang['Default_priority'],
	"L_DEFAULT_PRIORITY_EXPLAIN" => $lang['Default_priority_explain'],
	"L_PAGINATION_LIMIT1" => $lang['Pagination_limit1'],
	"L_PAGINATION_LIMIT_EXPLAIN1" => $lang['Pagination_limit_explain1'],
	"L_PAGINATION_LIMIT2" => $lang['Pagination_limit2'],
	"L_PAGINATION_LIMIT_EXPLAIN2" => $lang['Pagination_limit_explain2'],

	"SQL_LIMIT" => $new['sitemap_sql_limit'],
	"SITEMAP_SORT_DESC" => $sitemap_sort_desc,
	"SITEMAP_SORT_ASC" => $sitemap_sort_asc,
	"REWRTIE_S_NO" => $rewrite_sitemaps_no,
	"REWRTIE_S_YES" => $rewrite_sitemaps_yes,

	"ANNOUNCE_PRIORITY" => $new['sitemap_announce_priority'],
	"STICKY_PRIORITY" => $new['sitemap_sticky_priority'],
	"DEFAULT_PRIORITY" => $new['sitemap_default_priority'],
	"DEFAULT_LIMIT" => $new['sitemap_url_limit'],
	"PAGINATION_LIMITDOWN" => $new['sitemap_limitdown'],
	"PAGINATION_LIMITUP" => $new['sitemap_limitup'],

	"VER_INFO" => 'mx_ggsitemaps ' . $new['sitemap_ver'] . '<br/>' .  make_link($new['sitemap_c_info']),

	"L_SUBMIT" => $lang['Submit'],
	"L_RESET" => $lang['Reset']
));

// If kb is installed with mx, let's show some more options
if ( file_exists( $mx_root_path . $pathkb . 'includes/functions_kb.' . $phpEx ) && defined('IN_PORTAL') )
{
	$template -> assign_block_vars('kb_config', array(
			"L_SITEMAP_KB_SET" => $lang['Sitemap_kb_set'],

			"L_KB_MX_PAGE" => $lang['KB_mx_page'],
			"L_KB_MX_PAGE_EXPLAIN" => sprintf($lang['KB_mx_page_explain'], "<a href=\"http://www.mx-system.com/\" target=\"_mxBB\">", "</a>"),
			"KB_MX_PAGE" => $new['sitemap_kb_mx_page'],
			)
		);
}

$template->pparse('admin_ggsitemap');

include_once($admin_root_path1 . 'page_footer_admin.'.$phpEx);
?>
--- NEW FILE: index.htm ---
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">

</body>
</html>

[mxbb-commits] mx_ggsitemaps/templates/subSilver/admin - New directory

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/templates/subSilver/admin
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv9482/admin

Log Message:
Directory /cvsroot/mxbb/mx_ggsitemaps/templates/subSilver/admin added to the repository

[mxbb-commits] mx_ggsitemaps/templates/subSilver - New directory

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/templates/subSilver
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv9447/subSilver

Log Message:
Directory /cvsroot/mxbb/mx_ggsitemaps/templates/subSilver added to the repository

[mxbb-commits] mx_ggsitemaps/language/lang_english - New directory

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/language/lang_english
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv9403/lang_english

Log Message:
Directory /cvsroot/mxbb/mx_ggsitemaps/language/lang_english added to the repository

[mxbb-commits] mx_ggsitemaps/admin - New directory

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/admin
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8856/admin

Log Message:
Directory /cvsroot/mxbb/mx_ggsitemaps/admin added to the repository

[mxbb-commits] mx_ggsitemaps/language - New directory

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/mx_ggsitemaps/language
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8856/language

Log Message:
Directory /cvsroot/mxbb/mx_ggsitemaps/language added to the repository