[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 />";

?>