phpBB.de

Verfasst: **27.10.2003 10:13**

Die oben genannten Fehlerquellen hast du überprüft ?

oder du fügst folgendes am Anfang der *.php ein (nach dem Includen von common.php):
Code: Alles auswählen
define('JR_ADMIN_USERS_TABLE', $table_prefix.'jr_admin_users');

..mach mal testweise das für sämtliche neuen Tabellen.

Verfasst: **27.10.2003 10:17**

hab ich doch schon längst:

Code: Alles auswählen

define('ATTACHMENTS_CONFIG_TABLE', $table_prefix.'attachments_config');
define('FORBIDDEN_EXTENSIONS_TABLE', $table_prefix.'forbidden_extensions');
define('EXTENSION_GROUPS_TABLE', $table_prefix.'extension_groups');
define('EXTENSIONS_TABLE', $table_prefix.'phpbb_extensions');
define('ATTACHMENTS_DESC_TABLE', $table_prefix.'phpbb_attachments_desc');
define('ATTACHMENTS_TABLE', $table_prefix.'phpbb_attachments');
define('QUOTA_LIMITS_TABLE', $table_prefix.'phpbb_quota_limits');
define('ATTACH_QUOTA_TABLE', $table_prefix.'phpbb_attach_quota');
define('MODULES_TABLE', $table_prefix . 'stats_modules');
define('STATS_CONFIG_TABLE', $table_prefix . 'stats_config');
define('AUTH_ACCESS_TABLE', $table_prefix.'auth_access');
define('BANLIST_TABLE', $table_prefix.'banlist');
define('CATEGORIES_TABLE', $table_prefix.'categories');
define('COLOR_GROUPS_TABLE', $table_prefix.'color_groups');
define('CONFIG_TABLE', $table_prefix.'config');
define('DISALLOW_TABLE', $table_prefix.'disallow');
define('FORUMS_TABLE', $table_prefix.'forums');
define('GROUPS_TABLE', $table_prefix.'groups');
define('JR_ADMIN_TABLE', $table_prefix.'jr_admin_users');
define('POSTS_TABLE', $table_prefix.'posts');
define('POSTS_TEXT_TABLE', $table_prefix.'posts_text');
define('PRIVMSGS_TABLE', $table_prefix.'privmsgs');
define('PRIVMSGS_TEXT_TABLE', $table_prefix.'privmsgs_text');
define('PRIVMSGS_IGNORE_TABLE', $table_prefix.'privmsgs_ignore');
define('PRIVMSGS_ARCHIVE_TABLE', $table_prefix.'privmsgs_archive');
define('PRUNE_TABLE', $table_prefix.'forum_prune');
define('RANKS_TABLE', $table_prefix.'ranks');
define('SEARCH_TABLE', $table_prefix.'search_results');
define('SEARCH_WORD_TABLE', $table_prefix.'search_wordlist');
define('SEARCH_MATCH_TABLE', $table_prefix.'search_wordmatch');
define('SESSIONS_TABLE', $table_prefix.'sessions');
define('SMILIES_TABLE', $table_prefix.'smilies');
define('THEMES_TABLE', $table_prefix.'themes');
define('THEMES_NAME_TABLE', $table_prefix.'themes_name');
define('TOPICS_TABLE', $table_prefix.'topics');
define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');
define('USER_GROUP_TABLE', $table_prefix.'user_group');
define('USERS_TABLE', $table_prefix.'users');
define('WORDS_TABLE', $table_prefix.'words');
define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

also ich hab einfach einträge für tables die mods erzeugen so in die constants.php zu den schon vorhandenen geaddet!! ich weiss ja nicht ob das zuviel verlangt ist, aber wenn das alles fertig is (soll ja wie gesagt ne distribution sein) kann ja sein, dass es leute gibt, die noch schlechter sind als ich

würdest du dir das dann mal angucken??

Verfasst: **27.10.2003 10:22**

Füge es mal testweise in das Installationsscript ein.. diese Fehlermeldung besagt, das "mehrere" Fehler aufgetreten sind.

Verfasst: **27.10.2003 10:35**

kann es nicht einfach so sein: so stell ich mir das nämlich vor: wenn ich ein original (ungemoddetes) phpbb nehme und das auf den server hochlade und dann noch die constants.php update und das installationssript hochlade, dann funktioniert es bestens!! alle tabellen werden geaddet und so weiter!! kann es nicht einfach daran liegen, dass der attachment mod schon installiert ist, aber dafür noch die tables fehlen?? denn in der installationsanleitung zum attachment mod wird erst das datenbankupdate (step 2) vorgenommen, und dann erst werden die dateien gemoddet und hochgeladen! wiegesagt, kann der fehler nicht einfach vom attachment mod kommen, dem ein paar tables fehlen???

Verfasst: **27.10.2003 10:38**

Eigentlich nicht.. denn beim Ausführen des Installationsscript, wird ja der Attach.Hack nich verlangt, benutzt oder sonstwas.
Am besten du reduzierst das Script mal auf einige wenige Queries, machst´n Test, fügst ´n weiteren Query hinzu ...usw.

Verfasst: **27.10.2003 10:41**

Hallo,
also ich habe das mal so getätigt, dass ich die nötigen DB Ändeurngen einfach mit in die install/schemas/ Ordner vorhandenen "mysql_basic.sql" und "mysql_schema.sql" rein kopiert habe und dann konnte man das Forum wie ein normales ungemoddetes phpBB2 installieren und es lief danach mit allen MODs...

Probier aber auch mal das zuvor gepostete Script. Es kommt ohne Header und Footer aus...

Verfasst: **27.10.2003 10:47**

hmm ich würde das script ja gerne testen, nur das problem ist, in meinem script sind sozusagen " und ' vertauscht!! überall bei den sql eintragungen wo bei dir ' steht, steht bei mir " und andersrum!! kann man das script von dir irgendwie so modifizieren, dass ich da einfach meinen code einfügen kann??

mein script is das hier:

Code: Alles auswählen

<?php
#########################################################
## SQL commands to phpBB2
## Author: Niels Chr. Rød
## Nickname: Niels Chr. Denmark
## Email: ncr@db9.dk
##
## Ver 1.0.7
##
## phpBB2 database update script for mods
## this file is intended to use with phpBB2, when installing mods
## after so you may delete this file, but only admin can use so it really doesen't matter
## The script will look what prefix you are using, and use the existing DB defined by config.php
## The execution of this script's included SQL is harmless, so you can run it as meny times you like
## note, though that the users last visit, will be set back to his/her last login, 
## but that is a minor cosmetic isue, that will correct it self next time the use logs in
##
## the following example are from my mods, and you can add some self, for other mods if you like
## you will after execution get a list over those commands that are run with succes and those with warnings !
## delete the sample lines if you are using it only for other mods
##
#########################################################

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('SITE_HISTORY_TABLE', $table_prefix.'site_history');

###################################################################################################
##
## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################
$sql=array(
'ALTER TABLE '.FORUMS_TABLE.' ADD auth_globalannounce TINYINT (2) DEFAULT "3" NOT NULL AFTER auth_announce',
'ALTER TABLE '.AUTH_ACCESS_TABLE.' ADD auth_globalannounce TINYINT (1) NOT NULL AFTER auth_announce',

'ALTER TABLE '.USERS_TABLE.' ADD user_birthday INT DEFAULT "999999" NOT NULL ',
'ALTER TABLE '.USERS_TABLE.' ADD user_next_birthday_greeting INT DEFAULT "0" NOT NULL ',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("birthday_required", "0")',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("birthday_greeting", "1")',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("max_user_age", "100")',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("min_user_age", "5")',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("birthday_check_day", "7")',

'ALTER TABLE '.USERS_TABLE.' ADD user_gender TINYINT DEFAULT "0" NOT NULL ',

'CREATE TABLE '.COLOR_GROUPS_TABLE.' (
  group_id mediumint(8) unsigned NOT NULL auto_increment,
  group_name varchar(255) NOT NULL default "",
  group_color varchar(50) NOT NULL default "",
  hidden tinyint(1) NOT NULL default "0",
  order_num mediumint NOT NULL,
  PRIMARY KEY (group_id),
  UNIQUE KEY group_name (group_name)
) TYPE=MyISAM ',

'ALTER TABLE '.USERS_TABLE.' ADD user_color_group MEDIUMINT UNSIGNED NOT NULL ',
'ALTER TABLE '.GROUPS_TABLE.' ADD group_color_group MEDIUMINT UNSIGNED NOT NULL ',

'CREATE TABLE '.PRIVMSGS_ARCHIVE_TABLE.' (
  privmsgs_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  privmsgs_type tinyint(4) NOT NULL default "0",
  privmsgs_subject varchar(255) NOT NULL default "0",
  privmsgs_from_userid mediumint(8) NOT NULL default "0",
  privmsgs_to_userid mediumint(8) NOT NULL default "0",
  privmsgs_date int(11) NOT NULL default "0",
  privmsgs_ip varchar(8) NOT NULL default "",
  privmsgs_enable_bbcode tinyint(1) NOT NULL default "1",
  privmsgs_enable_html tinyint(1) NOT NULL default "0",
  privmsgs_enable_smilies tinyint(1) NOT NULL default "1",
  privmsgs_attach_sig tinyint(1) NOT NULL default "1",
  PRIMARY KEY (privmsgs_id),
  KEY privmsgs_from_userid (privmsgs_from_userid),
  KEY privmsgs_to_userid (privmsgs_to_userid) 
) TYPE = MyISAM AUTO_INCREMENT = "1" ',

'CREATE TABLE '.JR_ADMIN_TABLE.' (
  user_id mediumint(9) NOT NULL default "0",
  user_jr_admin longtext NOT NULL,
  start_date int(10) unsigned NOT NULL default "0",
  update_date int(10) unsigned NOT NULL default "0",
  admin_notes text NOT NULL,
  notes_view tinyint(1) NOT NULL default "0",
  PRIMARY KEY (user_id)
) TYPE=MyISAM ',

'CREATE TABLE '.ATTACHMENTS_CONFIG_TABLE.' (
  config_name varchar(255) NOT NULL,
  config_value varchar(255) NOT NULL,
  PRIMARY KEY (config_name)
) ',

'CREATE TABLE '.FORBIDDEN_EXTENSIONS_TABLE.' (
  ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, 
  extension varchar(100) NOT NULL, 
  PRIMARY KEY (ext_id)
) ',

'CREATE TABLE '.EXTENSION_GROUPS_TABLE.' (
  group_id mediumint(8) NOT NULL auto_increment,
  group_name char(20) NOT NULL,
  cat_id tinyint(2) DEFAULT "0" NOT NULL, 
  allow_group tinyint(1) DEFAULT "0" NOT NULL,
  download_mode tinyint(1) UNSIGNED DEFAULT "1" NOT NULL,
  upload_icon varchar(100) DEFAULT "",
  max_filesize int(20) DEFAULT "0" NOT NULL,
  forum_permissions varchar(255) default "" NOT NULL,
  PRIMARY KEY group_id (group_id)
) ',

'CREATE TABLE '.EXTENSIONS_TABLE.' (
  ext_id mediumint(8) UNSIGNED NOT NULL auto_increment,
  group_id mediumint(8) UNSIGNED DEFAULT "0" NOT NULL,
  extension varchar(100) NOT NULL,
  comment varchar(100),
  PRIMARY KEY ext_id (ext_id)
) ',

'CREATE TABLE '.ATTACHMENTS_DESC_TABLE.' (
  attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
  physical_filename varchar(255) NOT NULL,
  real_filename varchar(255) NOT NULL,
  download_count mediumint(8) UNSIGNED DEFAULT "0" NOT NULL,
  comment varchar(255),
  extension varchar(100),
  mimetype varchar(100),
  filesize int(20) NOT NULL,
  filetime int(11) DEFAULT "0" NOT NULL,
  thumbnail tinyint(1) DEFAULT "0" NOT NULL,
  PRIMARY KEY (attach_id),
  KEY filetime (filetime),
  KEY physical_filename (physical_filename(10)),
  KEY filesize (filesize)
) ',

'CREATE TABLE '.ATTACHMENTS_TABLE.' (
  attach_id mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, 
  post_id mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, 
  privmsgs_id mediumint(8) UNSIGNED DEFAULT "0" NOT NULL,
  user_id_1 mediumint(8) NOT NULL,
  user_id_2 mediumint(8) NOT NULL,
  KEY attach_id_post_id (attach_id, post_id),
  KEY attach_id_privmsgs_id (attach_id, privmsgs_id)
) ',

'CREATE TABLE '.QUOTA_LIMITS_TABLE.' (
  quota_limit_id mediumint(8) unsigned NOT NULL auto_increment,
  quota_desc varchar(20) NOT NULL default "",
  quota_limit bigint(20) unsigned NOT NULL default "0",
  PRIMARY KEY  (quota_limit_id)
) ',

'CREATE TABLE '.ATTACH_QUOTA_TABLE.' (
  user_id mediumint(8) unsigned NOT NULL default "0",
  group_id mediumint(8) unsigned NOT NULL default "0",
  quota_type smallint(2) NOT NULL default "0",
  quota_limit_id mediumint(8) unsigned NOT NULL default "0",
  KEY quota_type (quota_type)
) ',

'ALTER TABLE '.FORUMS_TABLE.' ADD auth_download TINYINT(2) DEFAULT "0" NOT NULL ', 
'ALTER TABLE '.AUTH_ACCESS_TABLE.' ADD auth_download TINYINT(1) DEFAULT "0" NOT NULL ',  
'ALTER TABLE '.POSTS_TABLE.' ADD post_attachment TINYINT(1) DEFAULT "0" NOT NULL ',
'ALTER TABLE '.TOPICS_TABLE.' ADD topic_attachment TINYINT(1) DEFAULT "0" NOT NULL ',
'ALTER TABLE '.PRIVMSGS_TABLE.' ADD privmsgs_attachment TINYINT(1) DEFAULT "0" NOT NULL ',

'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("upload_dir","files")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("upload_img","images/icon_clip.gif")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("topic_icon","images/icon_clip.gif")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("display_order","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("max_filesize","262144")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("attachment_quota","52428800")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("max_filesize_pm","262144")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("max_attachments","3")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("max_attachments_pm","1")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("disable_mod","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_pm_attach","1")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("attachment_topic_review","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_ftp_upload","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("show_apcp","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("attach_version","2.3.9")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("default_upload_quota", "0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("default_pm_quota", "0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("ftp_server","")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("ftp_path","")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("download_path","")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("ftp_user","")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("ftp_pass","")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("ftp_pasv_mode","1")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("img_display_inlined","1")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("img_max_width","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("img_max_height","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("img_link_width","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("img_link_height","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("img_create_thumbnail","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("img_min_thumb_filesize","12000")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("img_imagick", "")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("use_gd2","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("wma_autoplay","0")',
'INSERT INTO '.ATTACHMENTS_CONFIG_TABLE.' (config_name, config_value) VALUES ("flash_autoplay","0")',

'INSERT INTO '.FORBIDDEN_EXTENSIONS_TABLE.' (ext_id, extension) VALUES ("1","php")',
'INSERT INTO '.FORBIDDEN_EXTENSIONS_TABLE.' (ext_id, extension) VALUES ("2","php3")',
'INSERT INTO '.FORBIDDEN_EXTENSIONS_TABLE.' (ext_id, extension) VALUES ("3","php4")',
'INSERT INTO '.FORBIDDEN_EXTENSIONS_TABLE.' (ext_id, extension) VALUES ("4","phtml")',
'INSERT INTO '.FORBIDDEN_EXTENSIONS_TABLE.' (ext_id, extension) VALUES ("5","pl")',
'INSERT INTO '.FORBIDDEN_EXTENSIONS_TABLE.' (ext_id, extension) VALUES ("6","asp")',
'INSERT INTO '.FORBIDDEN_EXTENSIONS_TABLE.' (ext_id, extension) VALUES ("7","cgi")',

'INSERT INTO '.EXTENSION_GROUPS_TABLE.' (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES ("1","Images","1","1","1","","0","")',
'INSERT INTO '.EXTENSION_GROUPS_TABLE.' (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES ("2","Archives","0","1","1","","0","")',
'INSERT INTO '.EXTENSION_GROUPS_TABLE.' (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES ("3","Plain Text","0","0","1","","0","")',
'INSERT INTO '.EXTENSION_GROUPS_TABLE.' (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES ("4","Documents","0","0","1","","0","")',
'INSERT INTO '.EXTENSION_GROUPS_TABLE.' (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES ("5","Real Media","0","0","2","","0","")',
'INSERT INTO '.EXTENSION_GROUPS_TABLE.' (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES ("6","Streams","2","0","1","","0","")',
'INSERT INTO '.EXTENSION_GROUPS_TABLE.' (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES ("7","Flash Files","3","0","1","","0","")',

'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("1","1","gif","")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("2","1","png", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("3","1","jpeg", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("4","1","jpg", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("5","1","tif", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("6","1","tga", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("7","2","gtar", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("8","2","gz", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("9","2","tar", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("10","2","zip", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("11","2","rar", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("12","2","ace", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("13","3","txt", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("14","3","c", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("15","3","h", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("16","3","cpp", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("17","3","hpp", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("18","3","diz", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("19","4","xls", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("20","4","doc", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("21","4","dot", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("22","4","pdf", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("23","4","ai", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("24","4","ps", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("25","4","ppt", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("26","5","rm", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("27","6","wma", "")',
'INSERT INTO '.EXTENSIONS_TABLE.' (ext_id, group_id, extension, comment) VALUES ("28","7","swf", "")',

'INSERT INTO '.QUOTA_LIMITS_TABLE.' (quota_limit_id, quota_desc, quota_limit) VALUES ("1", "Low","262144")',
'INSERT INTO '.QUOTA_LIMITS_TABLE.' (quota_limit_id, quota_desc, quota_limit) VALUES ("2", "Medium","2097152")',
'INSERT INTO '.QUOTA_LIMITS_TABLE.' (quota_limit_id, quota_desc, quota_limit) VALUES ("3", "High","5242880")',

'CREATE TABLE '.STATS_CONFIG_TABLE.' (
  config_name varchar(50) NOT NULL default "",
  config_value varchar(255) NOT NULL default "",
  PRIMARY KEY (config_name)
)',

'CREATE TABLE '.MODULES_TABLE.' (
  module_id tinyint(8) NOT NULL default "0",
  name varchar(150) NOT NULL default "",
  active tinyint(1) NOT NULL default "0",
  installed tinyint(1) NOT NULL default "0",
  display_order mediumint(8) unsigned NOT NULL default "0",
  update_time mediumint(8) unsigned NOT NULL default "0",
  auth_value tinyint(2) NOT NULL default "0",
  module_info_cache blob,
  module_db_cache blob,
  module_result_cache blob,
  module_info_time int(10) unsigned NOT NULL default "0",
  module_cache_time int(10) unsigned NOT NULL default "0",
  PRIMARY KEY (module_id)
)',

'INSERT INTO '.STATS_CONFIG_TABLE.' (config_name, config_value) VALUES ("install_date","'.time().'")',
'INSERT INTO '.STATS_CONFIG_TABLE.' (config_name, config_value) VALUES ("return_limit","10")',
'INSERT INTO '.STATS_CONFIG_TABLE.' (config_name, config_value) VALUES ("version","2.1.5")',
'INSERT INTO '.STATS_CONFIG_TABLE.' (config_name, config_value) VALUES ("modules_dir","stat_modules")',
'INSERT INTO '.STATS_CONFIG_TABLE.' (config_name, config_value) VALUES ("page_views","0")',

);

$mods = array ( 
'Global Announcement Mod','Global Announcement Mod',
'Birthday PART 1 Mod','Birthday PART 1 Mod','Birthday PART 2 Mod','Birthday PART 2 Mod','Birthday PART 2 Mod','Birthday PART 2 Mod','Birthday PART 2 Mod',
'Gender Mod',
'Color Groups Mod','Color Groups Mod','Color Groups Mod',
'Admin Private Message Manager',
'Junior Admin Mod',
'Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod','Attachment Mod',
'Statistics Mod','Statistics Mod','Statistics Mod','Statistics Mod','Statistics Mod','Statistics Mod','Statistics Mod'
);

############################################### 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, "You are not Authorised to do this"); 
$n=0;
$message="<b>This list is a result of the SQL queries needed for the additional mods in orangePHPbb</b><br/><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); 
?>

Verfasst: **27.10.2003 11:26**

Hallo,
versuche es mal wie oben beschrieben über die SQL Dateien:

AWSW hat geschrieben:...also ich habe das mal so getätigt, dass ich die nötigen DB Ändeurngen einfach mit in die install/schemas/ Ordner vorhandenen "mysql_basic.sql" und "mysql_schema.sql" rein kopiert habe und dann konnte man das Forum wie ein normales ungemoddetes phpBB2 installieren und es lief danach mit allen MODs...

Ich habe eben in ein neues phpBB 2.0.6 die voreditierten Dateien des Attachmentmod kopiert und dann den Inhalt der attach_mysql_basic.sql in die mysql_basic.sql und den Inhalt der attach_mysql_schema.sql mit in die mysql_schema.sql kopiert und dann das Forum ganz normal installiert. Danach war der MOD sofort mit installiert... So habe ich das damals auch bei dem fertig gemoddeten Forum erledigt und da waren auch der Global Announce, Birthday, Statistik usw mit drin. Insgesamt glaube ich um die 90 MODs...

HTH AWSW!

Verfasst: **27.10.2003 11:40**

so hab ich es jetzt auch gemacht!! nur ein allerletztes problem bleibt:

im statistik mod lautet eine zeile:

Code: Alles auswählen

INSERT INTO phpbb_stats_config (config_name, config_value) VALUES ('install_date', ' '. time() .' ');

wie kann ich das denn machen???

Verfasst: **27.10.2003 11:50**

Hmmm muss auf jeden Fall dann in die install.php... Schau mal wie das beim Feld "board_startdate" gemacht worden ist in der install.php...

phpBB.de

Brauche hilfe bei Installationsscript!