phpBB.de

Verfasst: **13.11.2005 09:35**

Also ich hab da ein Problem und zwar mit der SQL Datenbank und zwar

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;

wie ich das machen soll wenn es jemand weiß könnte er es mir sagen?
Danke im Voraus

Verfasst: **13.11.2005 20:44**

[kb=modsfaq#sql_phpmyadmin]SQL & phpMyAdmin[/kb]

Verfasst: **20.11.2005 03:33**

fanrpg hat geschrieben:
Code: Alles auswählen
$sql = 'SELECT `user` FROM `DEINETABELLE` WHERE status=0'; 
$result = mysql_query($sql) or die(mysql_error());
$user_num = mysql_num_rows($result);
Und die gesamanzahl der User kannst du dann so ausgeben:
Code: Alles auswählen
echo $user_num;
Und DEINETABELLE musst du in das ändern wie die Tabelle heisst wo die user drin stehen.

[/code]

sorry, aber hab da wirklich null ahung...füge ich den ersten code in die func.users.php ein? und der zweite kommt auf die ausgabeseite?