Aber dan als ich die Installations Datei ausführen wolte kam diese Meldung:
Code: Alles auswählen
There was an error creating one of the tables. Please report the following error to the message boards Admin.
Duplicate column name 'user_sound_pm'Hier ist die Installations Datei:
Code: Alles auswählen
<?php
define('IN_PHPBB', 1);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'config.'.$phpEx);
include($phpbb_root_path . 'includes/constants.'.$phpEx);
include($phpbb_root_path . 'includes/db.'.$phpEx);
echo '<html>
<head>
<title>PM Sound/Animation SQL installer</title>
</head>
<body>
<h1>Welcome to the PM Sound/Animation SQL installer</h1>
<hr />';
if (!isset($HTTP_GET_VARS['install'])) {
echo '<a href="?install=1">Click here to begin</a>';
}
else {
$queries = array(
'ALTER TABLE ' . USERS_TABLE . ' ADD user_sound_pm TINYINT(1) DEFAULT \'1\' NOT NULL AFTER user_popup_pm',
);
$success = true;
foreach($queries as $query) {
if (!$db->sql_query($query)) {
echo 'There was an error creating one of the tables. Please report the following error to the message boards Admin.<br />';
echo mysql_error();
$success = false;
break;
}
}
if ($success) {
echo 'All queries were executed successfully. You may delete this file from your root folder then go to your profile to activate or deactivate Sound and Animation upon receipt of a new PM.';
}
}
?>
