phpBB.nl

Nederlandstalige phpBB Support
https://www.phpbb.nl/forums/

Shoutbox

https://www.phpbb.nl/forums/viewtopic.php?f=45&t=20254

Pagina 1 van 2

Shoutbox

Geplaatst: 03 jun 2005, 19:06
door Quoctrung
Hoi, ik wil een shoutbox uploaden maar snap deze stap niet. Kan iemand mij ermee helpen?

Code: Selecteer alles

#
#-----[ COPY ]------------------------------------------
#
admin/admin_shoutbox.php to /admin/admin_shoutbox.php
templates/subSilver/admin/shoutbox_config_body.tpl to /templates/subSilver/admin/shoutbox_config_body.tpl
templates/subSilver/shoutbox_send_body.tpl to /templates/style/shoutbox_send_body.tpl
templates/subSilver/shoutbox_view_body.tpl to /templates/style/shoutbox_view_body.tpl
shoutbox.php to /shoutbox.php	
shoutbox_body.php to /shoutbox_body.php
shoutbox_send.php to /shoutbox_send.php
shoutbox_view.php to /shoutbox_view.php

Upload and run as forum admin: db_install.php

or insert it manually:

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_shoutbox (
  id int(11) NOT NULL auto_increment,
  sb_user_id int(11) NOT NULL,
  msg varchar(255) NOT NULL,
  timestamp int(10) unsigned NOT NULL,
  sb_username varchar(255) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE phpbb_shoutbox_config ( 
    config_name varchar(255) NOT NULL, 
    config_value varchar(255) NOT NULL, 
    PRIMARY KEY (config_name)
);

INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_guest_view','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_guest','0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete_all','0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete','0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit_all','0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit','0');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_bbcode','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_smilies','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('links_names','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('make_links','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('count_msg','100');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('delete_days','30');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('text_lenght','500');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('word_lenght','90');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('date_format','D G:i');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('date_on','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shoutbox_on','1');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shout_width','630');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shout_height','130');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('banned_user_id','');
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('banned_user_id_view','');

Geplaatst: 03 jun 2005, 19:10
door Paul
http://www.phpbb.nl/kb.php?mode=article&k=24 :thumb:

Geplaatst: 03 jun 2005, 19:16
door Quoctrung
De bestanden die je erbij hebt gedownload uploaden naar die map verwijzing? als ze dat bedoelen, heb ik dat al gedaan. Verder heb ik alle stappen gevold maar zie ik geen verandering in mijn forum

Geplaatst: 03 jun 2005, 19:19
door Paul
Alle templates wel veranderd? Alle bestanden aangepast? SQL uitgevoerd?

Geplaatst: 03 jun 2005, 19:19
door Quoctrung
paulus schreef:Alle templates wel veranderd? Alle bestanden aangepast? SQL uitgevoerd?
SQL?

Geplaatst: 03 jun 2005, 19:20
door Paul
Ja, das hetgeen onder het kopje sql. En in de link die ik gaf staat hoe je dat moet doen

Geplaatst: 03 jun 2005, 19:32
door Quoctrung
paulus schreef:Ja, das hetgeen onder het kopje sql. En in de link die ik gaf staat hoe je dat moet doen
Ik krijg als ik naar http://quoctrung.qu.funpic.org/phpBB2/db_install.php ga het volgende:

Code: Selecteer alles

Install results:

[failed] line: 1 , CREATE TABLE phpbb_shoutbox ( id int(11) NOT NULL auto_increment, sb_user_id int(11) NOT NULL, msg varchar(255) NOT NULL, timestamp int(10) unsigned NOT NULL, sb_username varchar(255) NOT NULL, PRIMARY KEY (id) )
[failed] line: 2 , CREATE TABLE phpbb_shoutbox_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name) )
[failed] line: 3 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_guest_view','1')
[failed] line: 4 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_guest','0')
[failed] line: 5 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete_all','0')
[failed] line: 6 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete','0')
[failed] line: 7 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit_all','0')
[failed] line: 8 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit','0')
[failed] line: 9 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_bbcode','1')
[failed] line: 10 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_smilies','1')
[failed] line: 11 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('links_names','1')
[failed] line: 12 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('make_links','1')
[failed] line: 13 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('count_msg','100')
[failed] line: 14 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('delete_days','30')
[failed] line: 15 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('text_lenght','500')
[failed] line: 16 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('word_lenght','90')
[failed] line: 17 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('date_format','D G:i')
[failed] line: 18 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('date_on','1')
[failed] line: 19 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shoutbox_on','1')
[failed] line: 20 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shout_width','630')
[failed] line: 21 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shout_height','130')
[failed] line: 22 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('banned_user_id','')
[failed] line: 23 , INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('banned_user_id_view','')
Weet niet waar ik moet bewerken in db_install.php

Geplaatst: 03 jun 2005, 19:34
door Paul
Had je die al gedraaid? Dis wel vreemd, de querys zijn niet fout :?

Geplaatst: 03 jun 2005, 19:39
door Quoctrung
dit is mijn db_install.php

Code: Selecteer alles

<?php
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');

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);

if ( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_ERROR, "You are not authorised");
}
else
{
	$sql=array(
"CREATE TABLE ".$table_prefix."shoutbox (
  id int(11) NOT NULL auto_increment,
  sb_user_id int(11) NOT NULL,
  msg varchar(255) NOT NULL,
  timestamp int(10) unsigned NOT NULL,
  sb_username varchar(255) NOT NULL,
  PRIMARY KEY (id)
)",

"CREATE TABLE ".$table_prefix."shoutbox_config (
    config_name varchar(255) NOT NULL,
    config_value varchar(255) NOT NULL,
    PRIMARY KEY (config_name)
)",

"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_guest_view','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_guest','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_delete_all','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_delete','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_edit_all','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_edit','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_bbcode','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_smilies','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('links_names','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('make_links','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('count_msg','100')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('delete_days','30')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('text_lenght','500')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('word_lenght','90')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('date_format','D G:i')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('date_on','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('shoutbox_on','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('shout_width','630')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('shout_height','130')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('banned_user_id','')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('banned_user_id_view','')",
	);
	

	$n=0;
	$message='</span></td><td align="left"><span class="gen"><b>Install results:</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>[failed]</font></b><font size="1"> line: '.($n+1).' , '.$sql[$n].'</font><br />';
		else $message .='<b><font color=#0000fF>[done]</font></b><font size="1"> line: '.($n+1).' , '.$sql[$n].'</font><br />';
		$n++;
	}

	message_die(GENERAL_MESSAGE, $message);
}
?>

Geplaatst: 03 jun 2005, 19:45
door Paul
Heb je verder alle bestanden, plus ook alle templates aangepast?

Geplaatst: 03 jun 2005, 19:47
door Quoctrung
paulus schreef:Heb je verder alle bestanden, plus ook alle templates aangepast?
Yep

Geplaatst: 03 jun 2005, 19:48
door Paul
Voor echt alle templates, en niet alleen subsilver? En geef is een link?

Geplaatst: 03 jun 2005, 19:51
door Quoctrung
paulus schreef:Voor echt alle templates, en niet alleen subsilver? En geef is een link?
http://quoctrung.qu.funpic.org/phpBB2/portal.php

Geplaatst: 03 jun 2005, 19:54
door Paul
http://quoctrung.qu.funpic.org/phpBB2/t ... d_body.tpl
niet de tpl bestanden naar solaris geupload dus. Heb je die bestanden wel aangepast(Denk het niet namelijk :roll: )

Geplaatst: 03 jun 2005, 19:57
door Quoctrung
paulus schreef:http://quoctrung.qu.funpic.org/phpBB2/t ... d_body.tpl
niet de tpl bestanden naar solaris geupload dus. Heb je die bestanden wel aangepast(Denk het niet namelijk :roll: )
\

Wat moet ik daar aanpassen dan? Er staat nergens dat ik die .tpl bestanden moet aanpassen?

Geplaatst: 03 jun 2005, 20:04
door Paul

Code: Selecteer alles

#
#-----[ COPY ]------------------------------------------
#
admin/admin_shoutbox.php to /admin/admin_shoutbox.php
templates/subSilver/admin/shoutbox_config_body.tpl to /templates/subSilver/admin/shoutbox_config_body.tpl
templates/subSilver/shoutbox_send_body.tpl to /templates/style/shoutbox_send_body.tpl
templates/subSilver/shoutbox_view_body.tpl to /templates/style/shoutbox_view_body.tpl
shoutbox.php to /shoutbox.php   
shoutbox_body.php to /shoutbox_body.php
shoutbox_send.php to /shoutbox_send.php
shoutbox_view.php to /shoutbox_view.php
die moet je uploaden :roll:
En je zal ook nog wel een bestand moeten aanpassen ;)
En dat moet je dus doen voor IEDERE template.

Geplaatst: 03 jun 2005, 20:10
door Quoctrung
paulus schreef:

Code: Selecteer alles

#
#-----[ COPY ]------------------------------------------
#
admin/admin_shoutbox.php to /admin/admin_shoutbox.php
templates/subSilver/admin/shoutbox_config_body.tpl to /templates/subSilver/admin/shoutbox_config_body.tpl
templates/subSilver/shoutbox_send_body.tpl to /templates/style/shoutbox_send_body.tpl
templates/subSilver/shoutbox_view_body.tpl to /templates/style/shoutbox_view_body.tpl
shoutbox.php to /shoutbox.php   
shoutbox_body.php to /shoutbox_body.php
shoutbox_send.php to /shoutbox_send.php
shoutbox_view.php to /shoutbox_view.php
die moet je uploaden :roll:
En je zal ook nog wel een bestand moeten aanpassen ;)
En dat moet je dus doen voor IEDERE template.

Dat is toch hetzelfde als dit uploaden:

Code: Selecteer alles

## Files To Edit:       admin/admin_db_utilities.php
##				includes/constants.php
##				language/lang_english/lang_admin.php
##				language/lang_english/lang_main.php
##				templates/index_body.tpl
##				common.php
##				index.php

Geplaatst: 03 jun 2005, 20:12
door Paul
Nee, die jij noemt moet je aanpassen, dat staat er ook voor :roll:

Geplaatst: 03 jun 2005, 20:14
door Quoctrung
Sorry, deze bedoel ik..

Code: Selecteer alles

## Included Files:      admin/admin_shoutbox.php
##				templates/style/admin/shoutbox_config_body.tpl
##				templates/style/shoutbox_send_body.tpl
##				templates/style/shoutbox_view_body.tpl
##				shoutbox.php
##				shoutbox_body.php
##				shoutbox_send.php
##				shoutbox_view.php

Geplaatst: 03 jun 2005, 20:24
door Paul
Die ja, en die moet je niet alleen naar templates/subSilver, maar naar alle templates uploaden, die je hebt ;)
Alle tijden zijn UTC+01:00
Pagina 1 van 2
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/