Problem beim einbauen eines Mod's

[Bones van Helghast]

Code: Alles auswählen

#-----[ SQL ]----------------------------------------------------
#
CREATE TABLE phpbb_reports (
   report_id mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
   user_id mediumint(8) NOT NULL,
   report_time int(11) NOT NULL,
   report_last_change mediumint(8) UNSIGNED DEFAULT NULL,
   report_module_id mediumint(8) UNSIGNED NOT NULL,
   report_status tinyint(1) NOT NULL,
   report_reason_id mediumint(8) UNSIGNED NOT NULL,
   report_subject int(11) NOT NULL,
   report_subject_data mediumtext DEFAULT NULL,
   report_title varchar(255) NOT NULL,
   report_desc text NOT NULL,
   PRIMARY KEY (report_id),
   KEY user_id (user_id),
   KEY report_time (report_time),
   KEY report_type_id (report_module_id),
   KEY report_status (report_status),
   KEY report_reason_id (report_reason_id),
   KEY report_subject (report_subject)
);

CREATE TABLE phpbb_reports_changes (
   report_change_id mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
   report_id mediumint(8) UNSIGNED NOT NULL,
   user_id mediumint(8) NOT NULL,
   report_change_time int(11) NOT NULL,
   report_status tinyint(1) NOT NULL,
   report_change_comment text NOT NULL,
   PRIMARY KEY (report_change_id),
   KEY report_id (report_id),
   KEY user_id (user_id),
   KEY report_change_time (report_change_time)
);

CREATE TABLE phpbb_reports_modules (
   report_module_id mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
   report_module_order mediumint(8) UNSIGNED NOT NULL,
   report_module_notify tinyint(1) NOT NULL,
   report_module_prune smallint(6) NOT NULL,
   report_module_last_prune int(11) DEFAULT NULL,
   report_module_name varchar(50) NOT NULL,
   auth_write tinyint(1) NOT NULL,
   auth_view tinyint(1) NOT NULL,
   auth_notify tinyint(1) NOT NULL,
   auth_delete tinyint(1) NOT NULL,
   PRIMARY KEY (report_module_id),
   KEY report_module_order (report_module_order),
   KEY auth_view (auth_view)
);

CREATE TABLE phpbb_reports_reasons (
   report_reason_id mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
   report_module_id mediumint(8) UNSIGNED NOT NULL,
   report_reason_order mediumint(8) UNSIGNED NOT NULL,
   report_reason_desc varchar(255) NOT NULL,
   PRIMARY KEY (report_reason_id),
   KEY report_type_id (report_module_id),
   KEY report_reason_order (report_reason_order)
);

ALTER TABLE phpbb_posts ADD post_reported tinyint(1) NOT NULL default '0';
ALTER TABLE phpbb_topics ADD topic_reported tinyint(1) NOT NULL default '0';
ALTER TABLE phpbb_privmsgs ADD privmsgs_reported tinyint(1) NOT NULL default '0';

INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_subject_auth', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_modules_cache', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_hack_count', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_notify', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_list_admin', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_new_window', '0');

Dieser auschnitt war in der anleitung gestanden und ich weiß ehrlich gesagt nicht wo ich das einfügen muss ?!

[gloriosa]

Hallo,
das ist in der Pos. 12 der >>> KB:18 <<< und zahlreichen Kommentaren zum Ausführen der SQL-Anweisung nachzulesen !

Alternativ kannst Du auch eine install.phpgenerieren und ausführen !

Weiterhin gibt es die, viel zu selten benutzte, boardeigene Funktion [ externes Bild ] Suchen und den Bereich Dokumentation um Informationen zu finden.