Code: Alles auswählen
<?
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
if($userdata['user_level'] == ADMIN)
{
unset($sql);
#
# Tabellenstruktur für Tabelle `nickpagebuddies`
#
//$table_name[] = $table_prefix."nickpagebuddies";
$sql[] = "CREATE TABLE IF NOT EXISTS ".$table_prefix."nickpagebuddies (
uid mediumint(8) NOT NULL default '0',
buddie mediumint(8) NOT NULL default '0'
)";
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `nickpageconf`
#
//$table_name[] = $table_prefix."nickpageconf";
$sql[] = "CREATE TABLE IF NOT EXISTS ".$table_prefix."nickpageconf (
registered_only tinyint(1) NOT NULL default '0',
anzahl_posts int(8) NOT NULL default '0',
buddielist int(8) NOT NULL default '0',
favlinks int(8) NOT NULL default '0',
allow_guestbook tinyint(1) NOT NULL default '0',
guestbook_writer tinyint(1) NOT NULL default '0',
entry_per_page mediumint(5) NOT NULL default '0',
allow_galerie tinyint(1) NOT NULL default '0',
galery_maxpics int(8) NOT NULL default '0',
allow_kreatives tinyint(1) NOT NULL default '0',
gd tinyint(1) NOT NULL default '0'
)";
//Datensatz einfügen
$sql[] = "INSERT INTO ".$table_prefix."nickpageconf VALUES (0, 0, 10, 10, 1, 0, 10, 1, 25, 1, 2 )";
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `nickpagefavs`
#
//$table_name[] = $table_prefix."nickpagefavs";
$sql[] = "CREATE TABLE IF NOT EXISTS ".$table_prefix."nickpagefavs (
uid mediumint(8) NOT NULL default '0',
url varchar(100) NOT NULL default '',
urlname varchar(100) NOT NULL default ''
)";
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `nickpagegalerie`
#
//$table_name[] = $table_prefix."nickpagegalerie";
$sql[] = "CREATE TABLE IF NOT EXISTS ".$table_prefix."nickpagegalerie (
gal_id int(5) NOT NULL auto_increment,
uid int(5) NOT NULL default '0',
pic varchar(100) NOT NULL default '',
comment varchar(100) NOT NULL default '',
PRIMARY KEY (gal_id)
)";
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `nickpagegb`
#
//$table_name[] = $table_prefix."nickpagegb";
$sql[] = "CREATE TABLE IF NOT EXISTS ".$table_prefix."nickpagegb (
aid int(10) NOT NULL auto_increment,
von mediumint(8) NOT NULL default '0',
autor varchar(100) NOT NULL default '',
an mediumint(8) NOT NULL default '0',
zeit varchar(40) NOT NULL default '',
message varchar(255) NOT NULL default '',
PRIMARY KEY (aid)
)";
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `nickpagemod`
#
//$table_name[] = $table_prefix."nickpagemod";
$sql[] = "CREATE TABLE IF NOT EXISTS ".$table_prefix."nickpagemod (
uid mediumint(8) NOT NULL default '0',
name varchar(25) NOT NULL default '',
born varchar(40) NOT NULL default '',
pic varchar(255) NOT NULL default '',
specialnick varchar(255) NOT NULL default '',
info varchar(255) NOT NULL default '',
visits mediumint(8) NOT NULL default '0',
vote int(8) NOT NULL default '0',
votes int(5) NOT NULL default '0',
kreatives text NOT NULL,
safe tinyint(1) NOT NULL default '0',
safe_gb tinyint(1) NOT NULL default '0',
gb_email tinyint(1) NOT NULL default '0',
status tinyint(4) NOT NULL default '0',
PRIMARY KEY (uid)
)";
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `nickpagevotes`
#
//$table_name[] = $table_prefix."nickpagevotes";
$sql[] = "CREATE TABLE IF NOT EXISTS ".$table_prefix."nickpagevotes (
uid int(6) NOT NULL default '0',
von int(6) NOT NULL default '0',
vote tinyint(1) NOT NULL default '0'
)";
for($x=0;$x<count($sql);$x++)
{
$db->sql_query($sql[$x]);
}
message_die(GENERAL_MESSAGE,'Installation abgeschlossen.<br>
<br>
Unter Umständen ist es erforderlich die Nickpage über das ACP zu konfigurieren.<br>
<br>
Viel Spass...');
}
else
{
message_die(GENERAL_MESSAGE,'Sie sind nicht befugt, den Mod zu installieren!<br>
<br>
Bitte wenden Sie sich an Ihren Boardadministrator.');
}
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>