phpBB.de

Code: Alles auswählen

#-----[ SQL ]------------------------------------------ 
#
# Notes: Execute these commands via phpmyadmin OR run the install.php file from your browser.
#	If the install file is used, delete the install.php file from your server afterwards.
#	If using the text SQLs, you may need to change the "phpbb_" if your phpbb's table prefix 
#	is something other than the default used here! THIS STEP MUST BE DONE FIRST!!!
#
# 

CREATE TABLE `phpbb_pjirc` (
                             pjirc_name varchar(255),
                             pjirc_value varchar(255)
                             );

INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_mod_version', '3.1.2a');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_status', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_server', 'irc.blitzed.org');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_port', '6667');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_channel', '#pjirc4phpbb');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_language', 'english');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_template', 'subSilver');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_popup_onoff', '0');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_allow_guests', '0');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_guestname', 'guest');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_auth_joinlist', '');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_show_connect', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_show_chanlist', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_show_about', '0');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_show_help', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_show_close', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_show_status', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_show_dock', '0');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_show_nickfield', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_time_stamp', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_topicscroller', '10');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_quit', 'PJIRC Chat MOD User');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_smilies', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_smilies_enter', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_smilies_count', '20');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_smilies_lines', '20');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_beep', 'boing.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_enter_timer', '45500');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_profile', 'boingggg.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_im', 'cork.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_query', 'knocking.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_ignore', 'clunk.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_unignore', 'chirp.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_away', 'tone.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_back', 'cashregister.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_clear', 'wipe.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_whois', 'drip.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound_help', 'lasertrill.au');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound1', 'cashregister.au'); 
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_soundwords1', 'word1 word2 word3 word4 word5'); 
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_sound2', 'tone.au'); 
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_soundwords2', 'word1 word2 word3 word4 word5'); 
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_bot_overall', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_bot_switch1', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_bot_timer', '46000'); 
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_bot_switch2', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_channel2_on', '0');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_channel3_on', '0');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_channel2', '');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_channel3', '');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_multiserver', '0');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_multiserver_server', 'irc.freenode.net'); 
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_multiserver_port', '6667'); 
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_multiserver_delay', '60000'); 
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_use_info', '0');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_style_selector', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_style_selector_definition', '');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_font_style', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_font_style_definition', '');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_style_nick_left', '');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_style_nick_right', '');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_show_highlight', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_highlightcolor', '4');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_highlightwords', 'word1 word2 word3');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_background_which', '1');
INSERT INTO phpbb_pjirc ( pjirc_name , pjirc_value ) VALUES ('irc_background_file', '');

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