hilfe bei PJIRC_Chat-120

[Forty]

hallo
ich bau grad nen chat in mein forum...

Code: Alles auswählen

#-----[ SQL ]------------------------------------------ 
# 

INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_server', 'irc.mircx.com');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_port', '6667');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_channel', '#eric.best-1.biz');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_quit', 'Good Bye');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_time_stamp', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_connect', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_chanlist', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_about', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_help', '0');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_style_selector', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_font_style', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_close', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_status', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_dock', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_use_info', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_sound_beep', 'snd/ding.au');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_sound_query', 'snd/bell2.au');

ALTER TABLE phpbb_users ADD irc_commands VARCHAR( 255 ) NOT NULL;

das soll ich ausfüllen damit hab ich keine probleme aber wo soll ich denn des text dann einfügen??
bitte um hilfe
gruss Forty

[tomtom]

Das sind keine Änderungen, die du am Code ändern musst. Es geht hier um die Datenbank!

Die Anweisung hier rauskopieren:

Code: Alles auswählen

INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_server', 'irc.mircx.com');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_port', '6667');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_channel', '#eric.best-1.biz');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_quit', 'Good Bye');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_time_stamp', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_connect', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_chanlist', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_about', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_help', '0');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_style_selector', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_font_style', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_close', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_status', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_show_dock', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_use_info', '1');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_sound_beep', 'snd/ding.au');
INSERT INTO phpbb_config ( config_name , config_value ) VALUES ('irc_sound_query', 'snd/bell2.au');

ALTER TABLE phpbb_users ADD irc_commands VARCHAR( 255 ) NOT NULL;

dann im phpMyAdmin oder anderem DB-Tool im SQL-Abfrage-Fenster wieder einfügen und ausführen. Ggf. musst du den Prefix phpbb_ an deinen anpassen.

[Forty]

huhu
danke
gruss Forty
[edit]ich verste aber immernoch nicht genau wo des hin soll (

[saerdnaer]

KB:pma_faq

[Forty]

hallo
soll ich dann hier: http://213.239.198.164/zw/forum/phpBB2/sql.bmp den ganzen text kram einfügen?
Gruss Forty

[Mehrpack]

hi,
yop dort reinkopieren und dann ok drücken.

Mehrpack

[Forty]

hallo
danke funktioniert nun
Gruss Forty