View file book_db.php

<?php

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('BOOK_TABLE','book');

###################################################################################################
##
## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################
$sql=array(

"CREATE TABLE ".BOOK_TABLE." (
shout_id MEDIUMINT(8) UNSIGNED NOT NULL auto_increment, 
shout_username VARCHAR(25) NOT NULL, 
shout_user_id MEDIUMINT(8) NOT NULL, 
shout_group_id MEDIUMINT(8) NOT NULL,
shout_session_time INT(11) NOT NULL, 
shout_ip CHAR(8) NOT NULL, 
shout_text TEXT NOT NULL, 
shout_active MEDIUMINT(8) NOT NULL, 
enable_bbcode TINYINT (1) NOT NULL,
enable_html TINYINT (1) NOT NULL,
enable_smilies TINYINT (1) NOT NULL,
enable_sig TINYINT (1) NOT NULL,
shout_bbcode_uid VARCHAR(10) NOT NULL,
INDEX (shout_id)
)",
"INSERT INTO ".CONFIG_TABLE." (config_name, config_value) VALUES ('prune_shouts', '0')",
); 

$mods = array ( 
'fully integrated shoutbox','fully integrated shoutbox','fully integrated shoutbox'
);


############################################### 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 this Mod</b><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>[Already added]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />';
	else $message .='<b><font color=#0000fF>[Added/Updated]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />';
	$n++;
}
 message_die(GENERAL_MESSAGE, $message); 
?>