phpBB España Oficial

Código: Seleccionar todo

<?php
#########################################################
## SQL commands to phpBB2
## Author: Niels Chr. Rød
## Nickname: Niels Chr. Denmark
## Email: ncr@db9.dk
##
## Ver 0.9.0
##
##
#########################################################

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);
define('SITE_HISTORY_TABLE', $table_prefix.'site_history');
define('TOPIC_VIEW_TABLE', $table_prefix.'topic_view');
define('PAGE_INDEX_PERMISSION', -99);

###################################################################################################
##
## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################
$sql=array(
'ALTER TABLE ' . AUTH_ACCESS_TABLE . ' CHANGE `forum_id` `forum_id` SMALLINT(5) DEFAULT "0" NOT NULL',
'ALTER TABLE ' . FORUMS_TABLE . ' CHANGE `forum_id` `forum_id` SMALLINT(5) DEFAULT "0" NOT NULL',
'ALTER TABLE ' . FORUMS_TABLE . ' CHANGE `cat_id` `cat_id` MEDIUMINT(8) DEFAULT "0"'
);

$mods = array ( 
'Extra Permissions','Extra Permissions','Extra Permissions'
);

############################################### Do not change anything below this line #######################################

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//

if ($userdata['user_level']!=ADMIN)
      message_die(GENERAL_ERROR, $lang['Not_Authorised']); 
$n=0;
$message="<b>This list is a result of the SQL queries needed for the additional mods in the pre-moded pack</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=#FF4444>[Posible error]</b> line: '.($n+1).' , '.$sql[$n].'</font><br />';
	} else
	{
		if ( $db->sql_affectedrows() )
		{
			$message .='<b><font color=#0000FF>[Added/Updated]</b> line: '.($n+1).' , '.$sql[$n].'</font><br />';
		} else
		{
			$message .='<b><font color=#BBBBFF>[Already added]</b> line: '.($n+1).' , '.$sql[$n].'</font><br />';
		}
	}
	$n++;
}
 message_die(GENERAL_MESSAGE, $message); 
?>

Código: Seleccionar todo

ALTER TABLE phpbb_forums CHANGE `forum_id` `forum_id` smallint(5) UNSIGNED DEFAULT '0' NOT NULL;

ALTER TABLE phpbb_forums CHANGE `forum_id` `forum_id` smallint(5) UNSIGNED NOT NULL;

ALTER TABLE phpbb_forums CHANGE `cat_id` `cat_id` mediumint(8) UNSIGNED NOT NULL;