Shoutbox Subsilver

Hulp nodig bij een modificaties of op zoek naar een MOD? Bekijk ons archief. Support wordt helaas niet meer verleend.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.phpBB2.0.x
Gesloten
Vikash
Berichten: 172
Lid geworden op: 01 mar 2005, 20:41
Locatie: Rotterdam

Shoutbox Subsilver

Bericht door Vikash » 05 mar 2005, 14:30

Hallo,

ik wil een shoutbx op mijn forum zetten.
ik heb al een shoutbox gedownload en geopent, ik volg de instructies, om die mod te instaleren, maar nu zie ik dat er in die map een shoutbox is voor subsilver, maar ik heb geen subsilver, ik heb bbtech.

Als ik de shoutbox instaleer, heeft het dan invloed op mijn forum, dus ziet het er dan wel dezelfde uit (de layout) zo niet hoe kan ik er dan voor zorgen dat het er wel zo uitziet ?
Omhoog
Gebruikersavatar
Stef
Berichten: 9080
Lid geworden op: 04 jun 2003, 20:47

Bericht door Stef » 05 mar 2005, 14:34

Meestal gebruiken template auteur's dezelfde classes als subSilver, dus hij zal waarschijnlijk er toch wel goed uit zien.

Zet hem eerst eens neer en als hij dan lelijk is, kijk je even of je zelfde de goede classes kan pakken en desnoods helpen wij je ermee. :)
Omhoog
Vikash
Berichten: 172
Lid geworden op: 01 mar 2005, 20:41
Locatie: Rotterdam

Bericht door Vikash » 05 mar 2005, 14:41

Stef schreef:Meestal gebruiken template auteur's dezelfde classes als subSilver, dus hij zal waarschijnlijk er toch wel goed uit zien.

Zet hem eerst eens neer en als hij dan lelijk is, kijk je even of je zelfde de goede classes kan pakken en desnoods helpen wij je ermee. :)
ok, iedergeval bedankt :wink: 8)
Omhoog
Vikash
Berichten: 172
Lid geworden op: 01 mar 2005, 20:41
Locatie: Rotterdam

Bericht door Vikash » 08 mar 2005, 17:11

Ik heb ff een vraagje, dit moet ik doen om mijn shoutbox te installeren

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)
);
Dus mijn vraag is dan :

hoef ik alleen dit te doen ?

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:
en verder niks, dus wat daaronder allemaal staat hoef ik dan niet te doen ( dus die SQL enzo) ?
of moet ik dat ook doen ?
Omhoog
Gebruikersavatar
Luuk
Berichten: 7311
Lid geworden op: 22 okt 2003, 10:07
Locatie: Delft

Bericht door Luuk » 08 mar 2005, 17:14

Je moet al die bestanden uploaden, je kan voor de databaseveranderingen of db_install.php uploaden en uitvoeren of die sql querrie uitvoeren via phpmyadmin.
Afbeelding
Omhoog
Vikash
Berichten: 172
Lid geworden op: 01 mar 2005, 20:41
Locatie: Rotterdam

Bericht door Vikash » 08 mar 2005, 17:21

Luuk schreef:Je moet al die bestanden uploaden, je kan voor de databaseveranderingen of db_install.php uploaden en uitvoeren of die sql querrie uitvoeren via phpmyadmin.
okw ok, dat wou ik weten, want ik dacht dat ik alles gewoon moest doen.

maar bedankt :wink: 8)
Omhoog
Vikash
Berichten: 172
Lid geworden op: 01 mar 2005, 20:41
Locatie: Rotterdam

Bericht door Vikash » 09 mar 2005, 17:16

ik heb mijn shoutbox geupload naar mijn server(ftp) daarna ben ik naar admin pannel gegaan en toen naar algemeen beheer en daar stond shoutbox, dus ik klik daarop en zie het volgende :

Code: Selecteer alles

phpBB : Critical Error 

Could not query shoutbox config information

DEBUG MODE

SQL Error : 1146 Table 'vikashjhingoer_nl_db.SHOUTBOX_CONFIG_TABLE' doesn't exist

SELECT * FROM SHOUTBOX_CONFIG_TABLE

Line : 36
File : admin_shoutbox.php
wat bedoelen ze hiermee, en wat moet ik doen om het goed te krijgen ?
Omhoog
Gebruikersavatar
Leipo
Berichten: 4693
Lid geworden op: 22 feb 2003, 12:29
Contacteer:
Contacteer Leipo

Bericht door Leipo » 09 mar 2005, 17:19

Je hebt de MySQL opdrachten niet uitgevoerd.
Met 10 worden Engels kom je een heel eind.

Code: Selecteer alles

"SQL..  ..SHOUTBOX_CONGIF_TABLE' doesn't exist"
SQL slaat terug op je Database, Table op een Tabel en doesn't exist betekent dat hij niet bestaat.
[+] Isento at DeviantArt
Omhoog
Vikash
Berichten: 172
Lid geworden op: 01 mar 2005, 20:41
Locatie: Rotterdam

Bericht door Vikash » 09 mar 2005, 17:23

Leipo schreef:Je hebt de MySQL opdrachten niet uitgevoerd.
Met 10 worden Engels kom je een heel eind.

Code: Selecteer alles

"SQL..  ..SHOUTBOX_CONGIF_TABLE' doesn't exist"
SQL slaat terug op je Database, Table op een Tabel en doesn't exist betekent dat hij niet bestaat.
MySQL ?
hoe moet ik dat instaleren ?

dit staat in die install bestand :

Code: Selecteer alles

##############################################################
## MOD Title:          Small ShoutBox
## MOD Version:        1.4
## MOD Author:         Przemo
## Author email:       przemo@przemo.org
## Author Website      http://www.przemo.org
## MOD Description:    
## Full configurable Shoutbox on main index or another page.
## It allow you to change options via Admin Panel like:
## - Allow users or moderators to edit/delete messages
## - Allow you to decide who can shout
## - Allow you to decide who can view ShoutBox
## - Enable bbcode (only: b, i, u)
## - Enable smilies
## - Enable make links
## - Disable Shoutbox
## - Enable username link profile
## - Shoutbox avaliable for guests
## - Shoutbox only visible for guests
## - Type number of viewed messages
## - Max messages letters 
## - Max word letters to protect against horizontal scrolling
## - Enable date before messages
## - Customize date format
## - Customize Shoutbox size
##
## - Protect against flooding (board config flood control)
## - User can hide/show self Shoutbox (cookies)
##
## Tested on phpBB2.0.3 and 2.0.4
##
## Installation Level: easy
## Installation Time:  ~5 Minutes
## 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
## 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
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/
##############################################################
## Note: If you use ShoutBox for not subSilver style change the line:
## <link rel="stylesheet" href="templates/subSilver/subSilver.css" type="text/css" />
## for your css file it is located in the shoutbox_send_body.tpl and shoutbox_view_body.tpl
##############################################################
## MOD History:
##   1.0 (07-07-03)
##     - Initial Release.
##
##   1.1 (16-07-03)
##	 - Fix encoding problem.
##	 - Add messages delete days
##
##   1.2 (22-07-03)
##	 - Add set message time delete
##	 - Fix important installation instruction (bug in the information
##	   about inserts lines into lang_main.php)
##
##   1.3, 1.4 (23-10-03)
##       - Fix few bugs
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ 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','');

#
#-----[ OPEN ]------------------------------------------
#
admin/admin_db_utilities.php

#
#-----[ FIND ]------------------------------------------
#
			$tables = array('auth_access', 'banlist', 'categories', 'config', 'disallow', 'forums', 'forum_prune', 'groups', 'posts', 'posts_text', 'privmsgs', 'privmsgs_text', 'ranks', 'search_results', 'search_wordlist', 'search_wordmatch', 'sessions', 'smilies', 'themes', 'themes_name', 'topics', 'topics_watch', 'user_group', 'users', 'vote_desc', 'vote_results', 'vote_voters', 'words');
	
#
#-----[ REPLACE WITH ]------------------------------------------
#
			$tables = array('auth_access', 'banlist', 'categories', 'config', 'disallow', 'forums', 'forum_prune', 'groups', 'posts', 'posts_text', 'privmsgs', 'privmsgs_text', 'ranks', 'search_results', 'search_wordlist', 'search_wordmatch', 'sessions', 'smilies', 'themes', 'themes_name', 'topics', 'topics_watch', 'user_group', 'users', 'vote_desc', 'vote_results', 'vote_voters', 'words', 'shoutbox', 'shoutbox_config');
			
#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]------------------------------------------
#
define('CONFIG_TABLE', $table_prefix.'config');

#
#-----[ AFTER, ADD ]------------------------------------------
#
// Shoutbox mod
define('SHOUTBOX_CONFIG_TABLE', $table_prefix.'shoutbox_config');
define('SHOUTBOX_TABLE', $table_prefix.'shoutbox');

#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_admin.php

#
#-----[ FIND ]------------------------------------------
#
//
// That's all Folks!

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Shoutbox mod
$lang['shoutbox_on'] = "ShoutBox on";
$lang['date_on'] = "Show date";
$lang['sb_make_links'] = "Make links";
$lang['sb_links_names'] = "Username link to profile";
$lang['sb_allow_edit'] = "Allow administrators and moderators to edit messages";
$lang['sb_allow_edit_all'] = "Allow to edit own messages";
$lang['sb_allow_delete'] = "Allow administrators and moderators to delete messages";
$lang['sb_allow_delete_all'] = "Allow to delete own messages";
$lang['sb_allow_guest'] = "Shoutbox avaliable for guests";
$lang['sb_allow_guest_view'] = "Shoutbox only visible for guests";
$lang['sb_count_msg'] = "Number of viewed messages";
$lang['delete_days'] = "Amount of days after messages will be deleted";
$lang['sb_text_lenght'] = "Max messages letters";
$lang['sb_word_lenght'] = "Max word letters";
$lang['setup_shoutbox'] = "Shoutbox Configuration";
$lang['shout_size'] = "ShoutBox size";
$lang['sb_banned_send'] = "Disallow send messages for user";
$lang['sb_banned_send_e'] = "User IDs of users who can't send messages to ShoutBox. Separate multiple user IDs with commas, for example: <b>18, 124</b>";
$lang['sb_banned_view'] = "Disallow ShoutBox for user";
$lang['sb_banned_view_e'] = "User IDs of users who can't view and use ShoutBox. Separate multiple user IDs with commas, for example: <b>18, 124</b>";

#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
//
// That's all, Folks!

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Shoutbox mod
$lang['gg_mes'] = 'Message';
$lang['login_to_shoutcast'] = "You must be logged in to use shoutbox";
$lang['sb_show'] = "show";
$lang['sb_hide'] = "SB hide";
$lang['sb_hide_done'] = "Done";
$lang['too_long_word'] = "Too long word";
$lang['sb_banned_send'] = "You can't send messages";

#
#-----[ OPEN ]------------------------------------------
#
templates/style/index_body.tpl

#
#-----[ FIND ]------------------------------------------
#
	<td><span class="gensmall">{L_FORUM_LOCKED}</span></td>
  </tr>
</table>

# Or last </table> or you can choose another place for put shoutbox

#
#-----[ AFTER, ADD ]------------------------------------------
#
{SHOUTBOX_BODY}

#
#-----[ OPEN ]------------------------------------------
#
common.php

#
#-----[ FIND ]------------------------------------------
#
$board_config = array();

#
#-----[ AFTER, ADD ]------------------------------------------
#
// Shoutbox mod
$shoutbox_config = array();

#
#-----[ FIND ]------------------------------------------
#
	$board_config[$row['config_name']] = $row['config_value'];
}

#
#-----[ AFTER, ADD ]------------------------------------------
#
// Shoutbox mod
$sql = "SELECT *
	FROM " . SHOUTBOX_CONFIG_TABLE;
if( !($result = $db->sql_query($sql)) )
{
	  message_die(CRITICAL_ERROR, "Could not query shoutbox config information", "", __LINE__, __FILE__, $sql);
}

while ( $row = $db->sql_fetchrow($result) )
{
	$shoutbox_config[$row['config_name']] = $row['config_value'];
}

#
#-----[ OPEN ]------------------------------------------
#
index.php

#
#-----[ FIND ]------------------------------------------
#

	$template->assign_vars(array(
		'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts),

#
#-----[ BEFORE, ADD ]------------------------------------------
#
	// Shoutbox mod
	$shoutbox_config['banned_user_id_view'] = $GLOBALS['shoutbox_config']['banned_user_id_view'];
	if( strstr($shoutbox_config['banned_user_id_view'], ',') )
	{
		$fids = explode(',', $shoutbox_config['banned_user_id_view']);
	while( list($foo, $id) = each($fids) )
		{
			$fid[] = intval( trim($id) );
		}
	}
	else
	{
		$fid[] = intval( trim($shoutbox_config['banned_user_id_view']) );
	}
	reset($fid);

	if ( $shoutbox_config['shoutbox_on'] && in_array($userdata['user_id'], $fid) == false )
	{
		include($phpbb_root_path . 'shoutbox_body.'.$phpEx);
	}


#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
maar ik heb dus alleen dit gedaan :

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:
die SQL heb ik niet gedaan, maar weet niet hoe je dat moet doen.

kan iemand me verder helpen ?
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20316
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 09 mar 2005, 17:54

in phpmyadmin kopje sql ;)
Omhoog
Vikash
Berichten: 172
Lid geworden op: 01 mar 2005, 20:41
Locatie: Rotterdam

Bericht door Vikash » 09 mar 2005, 18:06

paulus schreef:in phpmyadmin kopje sql ;)
Kopje sql ?

wat is dat ?
kan het alsjeblieft iets duidelijker ?
Omhoog
Gebruikersavatar
Luuk
Berichten: 7311
Lid geworden op: 22 okt 2003, 10:07
Locatie: Delft

Bericht door Luuk » 09 mar 2005, 18:11

Dit dus

Code: Selecteer alles

#
#-----[ 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','');
Afbeelding
Omhoog
Vikash
Berichten: 172
Lid geworden op: 01 mar 2005, 20:41
Locatie: Rotterdam

Bericht door Vikash » 09 mar 2005, 18:15

Luuk schreef:Dit dus

Code: Selecteer alles

#
#-----[ 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','');
hoe en waar kan ik dat maken ?
ik heb een account bij lycos, moet ik het daar ergens zetten ?
Omhoog
Gebruikersavatar
Luuk
Berichten: 7311
Lid geworden op: 22 okt 2003, 10:07
Locatie: Delft

Bericht door Luuk » 09 mar 2005, 18:17

:arrow: http://www.phpbb.nl/kb.php?mode=article&k=24 Stap 10

Je gaat naar je database bij lycos via het tripod paneel, php4u en daar ergens op database :?
Afbeelding
Omhoog
Gebruikersavatar
Bas
Berichten: 2741
Lid geworden op: 02 dec 2003, 17:38
Locatie: Omgeving Goslar (Duitsland)
Contacteer:
Contacteer Bas

Bericht door Bas » 09 mar 2005, 18:41

Fout! :lol:

Includes/constants.php is niet gewijzigd/geupload... Anders zou er toch wel wat anders staan bij doesn't exist...
Omhoog
XP-Rene
Berichten: 2168
Lid geworden op: 01 dec 2004, 19:33
Locatie: Vlissingen
Contacteer:
Contacteer XP-Rene

Bericht door XP-Rene » 10 mar 2005, 09:39

Upload het bestand "db_install.php" naar de root van je forum, dus naar bijvoorbeeld http://www.jouforum.nl/phpBB2 of http://www.jouforum.nl/forum en ga vervolgens met je browser naar http://www.jouforum.nl/phpBB2/db_install.php of naar http://www.jouforum.nl/forum/db_install.php en druk op enter.

Nu worden de juiste wijzigingen in je database gemaakt. Als dit gedaan is, verwijder je "db_install.php" weer.

MySQL hoef je niet te installeren, wat dat is er al, anders zou je ook geen forum hebben...
KNAVIVO DIERENHULP
Stimuleer verdraagzaamheid. Wees eens wat vaker irritant.
Omhoog
Vikash
Berichten: 172
Lid geworden op: 01 mar 2005, 20:41
Locatie: Rotterdam

Bericht door Vikash » 10 mar 2005, 19:08

ik heb dat gedaan, er staat alles done, maar wat moet ik nu doen ?
Omhoog
Gebruikersavatar
Leipo
Berichten: 4693
Lid geworden op: 22 feb 2003, 12:29
Contacteer:
Contacteer Leipo

Bericht door Leipo » 10 mar 2005, 20:39

"db_install.php" verwijderen, zoals aangeven.
[+] Isento at DeviantArt
Omhoog
Vikash
Berichten: 172
Lid geworden op: 01 mar 2005, 20:41
Locatie: Rotterdam

Bericht door Vikash » 11 mar 2005, 14:52

ik heb het gedaan zoals gezegt, ik heb het geinstalleerd, toen stond er done, bij alles, toen ben ik naar forum index gegaan, en toen heb ik van mijn ftp : db_install verwijdert, toen ben ik naar de administrator panel gegaan > algemeen beheer > op shoutbox geklikt en toen zag ik dit :

Code: Selecteer alles

phpBB : Critical Error 

Could not query shoutbox config information

DEBUG MODE

SQL Error : 1146 Table 'vikashjhingoer_nl_db.SHOUTBOX_CONFIG_TABLE' doesn't exist

SELECT * FROM SHOUTBOX_CONFIG_TABLE

Line : 36
File : admin_shoutbox.php
wat moet ik doen ??
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20316
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 11 mar 2005, 14:54

er mist een stuk in constants.php ;). Even nakijken of je die goed hebt aangepast :)
Omhoog
Gesloten

Terug naar “2.0 Modificaties”