dat moet je in je phpmyadmin voegen
phpmyadmin is een script waarmee je je database kan bekijken en sql kan invoegen zo als he bovenstaande
ik weet alleen niet waar je het moet downloaden
je kan het ook in een install bestantje propen dat je dan moet runnen(dat doe ik wel even voor je)
ps zit er een install.php of zoiets bestantje in
//edit gebruik dit script
Code: Selecteer alles
<?php
/***************************************************************************
* db_update.php
* -------------------
*
* copyright : ©2003 Freakin' Booty ;-P & Antony Bailey
* project : http://sourceforge.net/projects/dbgenerator
* Website : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net
*
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
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
//
if( !$userdata['session_logged_in'] )
{
$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));
exit;
}
if( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}
$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">';
$sql = array();
$sql[] = "CREATE TABLE `tweede." . $table_prefix . "profile_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM";
$sql[] = "INSERT INTO `tweede." . $table_prefix . "profile_config` VALUES ('user_email', '1')";
$sql[] = "INSERT INTO `tweede." . $table_prefix . "profile_config` VALUES ('user_icq', '0')";
$sql[] = "INSERT INTO `tweede." . $table_prefix . "profile_config` VALUES ('user_website', '0')";
$sql[] = "INSERT INTO `tweede." . $table_prefix . "profile_config` VALUES ('user_from', '0')";
$sql[] = "INSERT INTO `tweede." . $table_prefix . "profile_config` VALUES ('user_sig', '0')";
$sql[] = "INSERT INTO `tweede." . $table_prefix . "profile_config` VALUES ('user_aim', '0')";
$sql[] = "INSERT INTO `tweede." . $table_prefix . "profile_config` VALUES ('user_yim', '0')";
$sql[] = "INSERT INTO `tweede." . $table_prefix . "profile_config` VALUES ('user_msnm', '0')";
$sql[] = "INSERT INTO `tweede." . $table_prefix . "profile_config` VALUES ('user_occ', '0')";
$sql[] = "INSERT INTO `tweede." . $table_prefix . "profile_config` VALUES ('user_interests', '0')";
for( $i = 0; $i < count($sql); $i++ )
{
if( !$result = $db->sql_query ($sql[$i]) )
{
$error = $db->sql_error();
echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
}
else
{
echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successfull</b></font></li><br />';
}
}
echo '</ul></span></td></tr><tr><td class="catBottom" height="28"> </td></tr>';
echo '<tr><th>End</th></tr><tr><td><span class="genmed">Installation is now finished. Please be sure to delete this file now.<br />If you have run into any errors, please visit the <a href="http://www.phpbbsupport.co.uk" target="_phpbbsupport">phpBBSupport.co.uk</a> and ask someone for help.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Have a nice day</a></span></td></table>';
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>