Oke, nu heb ik forum+site zover klaar, en ben db_update.php klaar.
Code: Selecteer alles
# CREATE TABLE `phpbb_site_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) ) TYPE=MyISAM
+++ Error: Table 'phpbb_site_config' already exists
# INSERT INTO `phpbb_site_config` VALUES ('copyright_owner', '')
+++ Error: Duplicate entry 'copyright_owner' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('copyright_text', '')
+++ Error: Duplicate entry 'copyright_text' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('site_founded', '')
+++ Error: Duplicate entry 'site_founded' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('contact_email', '')
+++ Error: Duplicate entry 'contact_email' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('contact_aim', '')
+++ Error: Duplicate entry 'contact_aim' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('contact_msn', '')
+++ Error: Duplicate entry 'contact_msn' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('contact_yim', '')
+++ Error: Duplicate entry 'contact_yim' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('contact_icq', '')
+++ Error: Duplicate entry 'contact_icq' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('contact_tel', '')
+++ Error: Duplicate entry 'contact_tel' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('contact_fax', '')
+++ Error: Duplicate entry 'contact_fax' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('contact_mobil', '')
+++ Error: Duplicate entry 'contact_mobil' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('contact_postal', '')
+++ Error: Duplicate entry 'contact_postal' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('contact_map', '')
+++ Error: Duplicate entry 'contact_map' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('site_css', 'site.css')
+++ Error: Duplicate entry 'site_css' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('site_intro', 'Welcome!')
+++ Error: Duplicate entry 'site_intro' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('linktome_intro', '')
+++ Error: Duplicate entry 'linktome_intro' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('site_last_update', '')
+++ Error: Duplicate entry 'site_last_update' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('site_hosted_by', '')
+++ Error: Duplicate entry 'site_hosted_by' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('banner_icon_path', 'images/banners')
+++ Error: Duplicate entry 'banner_icon_path' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('news_icon_path', 'images/news')
+++ Error: Duplicate entry 'news_icon_path' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('news_per_page', '5')
+++ Error: Duplicate entry 'news_per_page' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('news_order', '1')
+++ Error: Duplicate entry 'news_order' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('site_whoisonline_max', '')
+++ Error: Duplicate entry 'site_whoisonline_max' for key 1
# INSERT INTO `phpbb_site_config` VALUES ('easysite_version', '1.3.0')
+++ Error: Duplicate entry 'easysite_version' for key 1
# CREATE TABLE `phpbb_site_banner` ( `banner_id` mediumint(8) unsigned NOT NULL auto_increment, `banner_name` varchar(255) NOT NULL default '', `banner_url` varchar(255) NOT NULL default '', `banner_image` varchar(255) NOT NULL default '', `banner_type` tinyint(1) NOT NULL default '', PRIMARY KEY (`banner_id`) ) TYPE=MyISAM
+++ Error: Table 'phpbb_site_banner' already exists
# INSERT INTO `phpbb_site_banner` VALUES (1, 'EasySite @ MacphpBBMod', 'http://macphpbbmod.sourceforge.net/', 'easysite_logo.gif', 1)
+++ Error: Duplicate entry '1' for key 1
# INSERT INTO `phpbb_site_banner` VALUES (2, 'phpBB', 'http://www.phpbb.com/', 'phpBB.gif', 1)
+++ Error: Duplicate entry '2' for key 1
# INSERT INTO `phpbb_site_banner` VALUES (3, 'ForumImages', 'http://www.forumimages.com/', 'forumimages.gif', 2)
+++ Error: Duplicate entry '3' for key 1
# INSERT INTO `phpbb_site_banner` VALUES (4, 'phpBBHacks', 'http://www.phpbbhacks.com/', 'phpbbhacks.gif', 2)
+++ Error: Duplicate entry '4' for key 1
# INSERT INTO `phpbb_site_banner` VALUES (5, 'phpBB-TW', 'http://phpbb-tw.net/', 'phpbbtw.gif', 1)
+++ Error: Duplicate entry '5' for key 1
# CREATE TABLE `phpbb_site_news` ( `news_id` mediumint(8) unsigned NOT NULL auto_increment, `news_subject` varchar(60) default NULL, `news_icon` varchar(60) default NULL, `news_bbcode_uid` varchar(10) NOT NULL, `news_text` text, `logged` int(11) NOT NULL default '', PRIMARY KEY (`news_id`) ) TYPE=MyISAM
+++ Error: Table 'phpbb_site_news' already exists
# CREATE TABLE `phpbb_site_linktome` ( `linktome_id` mediumint(8) unsigned NOT NULL auto_increment, `linktome_name` varchar(255) NOT NULL default '', `linktome_source` text, PRIMARY KEY (`linktome_id`) ) TYPE=MyISAM
+++ Error: Table 'phpbb_site_linktome' already exists
# CREATE TABLE `phpbb_site_addpage` ( `addpage_id` mediumint(8) unsigned NOT NULL auto_increment, `addpage_name` varchar(10) NOT NULL default '', `addpage_url` varchar(255) NOT NULL default '', PRIMARY KEY (`addpage_id`) ) TYPE=MyISAM
+++ Error: Table 'phpbb_site_addpage' already exists
# INSERT INTO `phpbb_site_addpage` VALUES (1, 'phpBB', 'http://www.phpbb.com/')
+++ Error: Duplicate entry '1' for key 1
# CREATE TABLE `phpbb_site_search` ( `search_id` mediumint(8) unsigned NOT NULL auto_increment, `search_name` varchar(10) NOT NULL default '', `search_url1` varchar(255) NOT NULL default '', `search_url2` varchar(255) NOT NULL default '', PRIMARY KEY (`search_id`) ) TYPE=MyISAM
+++ Error: Table 'phpbb_site_search' already exists
# INSERT INTO `phpbb_site_search` VALUES (1, 'Yahoo', 'http://search.yahoo.com/search?p=', '&ei=UTF-8&fr=fp-tab-web-t&cop=mss&tab=')
+++ Error: Duplicate entry '1' for key 1
# INSERT INTO `phpbb_site_search` VALUES (2, 'Google', 'http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=', '')
+++ Error: Duplicate entry '2' for key 1