Pagina 1 van 3

Shoutbox

Geplaatst: 15 mei 2004, 12:43
door gunstn
Ik heb juis een shoutbox mod gedownload van php hacs, maar nu snap ik niet van de instaltia manuel, kan iemand mij helpen, dit is het instal 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

Geplaatst: 15 mei 2004, 12:46
door RobinTown

Geplaatst: 15 mei 2004, 14:28
door gunstn
Ik kan

Code: Selecteer alles

  $template->assign_vars(array( 
      'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts), 
niet vinden in de index.php
zou ik het ook gewoon ergens anders in de index.php mogen zetten ?

Geplaatst: 15 mei 2004, 14:47
door mosymuis
Je moet een beetje creatief zijn als je bepaalde delen in een mod niet kunt vinden, blijkbaar heb je al andere mods geïnstaleerd die hetzelfde hebben aangepast. In plaats daarvan kan je ook gewoon zoeken naar TOTAL_POSTS.

Geplaatst: 15 mei 2004, 14:50
door gunstn
Ok, zal ik proberen, maar ik heb nog geen andere mod op mijn forum gebruikt, dus kan het dat niet zijn, maar ik zal creatief zijn
thx :thumb:

Geplaatst: 15 mei 2004, 15:05
door gunstn
Staat er nergens in :roll:
maar zou ik het speciaal op die plaats moeten zetten, of zou ik het ook gewoon ergens mogen zetten in de index.php helemaal vanonder of zo, zou dat ook gaaan ?

Geplaatst: 15 mei 2004, 15:09
door mosymuis
Je kan het plaatsen in een redelijk groot gebied, maar je kan het niet zomaar op een willekeurige plek in de pagina plaatsen, nee. Zoek anders eens naar $template->assign_vars(array(.

Geplaatst: 15 mei 2004, 15:14
door gunstn
Nee, ook niet, zou het kunnen komen omdat ik Aeolus als tamplate heb?

Geplaatst: 15 mei 2004, 15:21
door mosymuis
Je hebt gewoon de verkeerde file voor je, je zit waarschijnlijk te zoeken in index_body.tpl en je moet zijn in index.php. Voortaan beter opletten dus.

Geplaatst: 15 mei 2004, 15:30
door gunstn
Woops :roll:

Maar hoe kan jij weten dat ik mis zat te zoeken ?

Geplaatst: 15 mei 2004, 15:32
door RobinTown
miss wel omdat dat stukje text 100% zeker in index.php zit, en 100% zeker niet in index_body.tpl ;)

Geplaatst: 15 mei 2004, 15:33
door mosymuis
gunstn schreef:Maar hoe kan jij weten dat ik mis zat te zoeken ?
Je begon over de template, die doet er in de PHP source totaal niet toe. Bovendien is het onmogelijk om een werkend forum te hebben, als er geen $template->assign_vars(array( zou staan in je index.php. Dit object stuurt namelijk alle template variabelen door.

Geplaatst: 15 mei 2004, 15:37
door gunstn
Ok, alles geupload, kijk ik op mijn forum

eror, deze eror http://pb.exocrew.com/gunstn/ (niet om reclame te maken, maar om de eror te tonen)

Geplaatst: 15 mei 2004, 15:41
door mosymuis
SQL Error : 1146 Table 'pbexo_14.gunstn_shoutbox_config' doesn't exist
Lees nu eens wat er staat? Je database tabel "gunstn_shoutbox_config" bestaat niet (meer), of je hebt het prefix verkeerd staan.

Geplaatst: 15 mei 2004, 15:44
door gunstn
Dat bestand staat er inderdaad niet op, maar in de map dat ik van phphacs heb gedownload staat dat bestand niet :cry:

Geplaatst: 15 mei 2004, 15:46
door mosymuis
mosymuis schreef:Je database tabel "gunstn_shoutbox_config" bestaat niet (meer), of je hebt het prefix verkeerd staan.
, geen bestand dus. Wat heb je gedaan sinds het niet meer werkt?

Geplaatst: 15 mei 2004, 15:46
door RobinTown
dit is die db_install van de small shoutbox van przmo of zo

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: 15 mei 2004, 15:50
door gunstn

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 

[b]or insert it manually: [/b]

# 
#-----[ 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',''); 
ik heb aleen dat copy gedeelte gedaan, maar daarchter staat or onsirt it manual betekent dat dat je ook nog eens die sql moet doen, of dat dat die manual wijze is ?

Geplaatst: 15 mei 2004, 15:53
door mosymuis
Upload and run as forum admin: db_install.php

or insert it manually:
Betekent "draai db_install.php, of voeg deze query handmatig in". Als je geen van beide doet is het natuurlijk logisch dat je mod niet werkt. Als je de query handmatig draait moet je de phpbb_ prefix wel aanpassen naar wat jij gebruikt.

Geplaatst: 15 mei 2004, 15:56
door gunstn
Hoe draai je db_install.php :oops: