phpBB.nl

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

Im portal fout

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

Pagina 1 van 1

Im portal fout

Geplaatst: 12 jun 2004, 13:08
door ajcied

Code: Selecteer alles

phpBB : Fatale Fout 

Could not query portal config table

DEBUG MODE

SQL Error : 1146 Table 'ajcied5_nl_db.phpbb_portal_config' doesn't exist

SELECT * FROM phpbb_portal_config

Line : 47
File : /data/members/free/tripod/nl/a/j/c/ajcied5/htdocs/phpBB2/includes/functions_portal.php
Ik heb geen sql fouten gehad!!!!
Wat is het probleem?

Geplaatst: 12 jun 2004, 13:15
door cartoontje
Je bent een regeltje SQL vergeten door te voeren! ;)

Zoniet: Heb je een andere prefix en phpbb_ met de juiste gewijzigd?

Geplaatst: 12 jun 2004, 13:24
door ajcied
kan iemand meschien van het sql bestandje een setup bestandje maken misschien dat ie het dan goed doet! phpmyadmin doet het namelijk niet goed bij mij!

Geplaatst: 12 jun 2004, 13:35
door ajcied
moet ezportal ook geinstald zijn?

Geplaatst: 12 jun 2004, 13:39
door WebSiteNet
1. Wat is de query? Dan kan je hiermee een bestand maken:

http://www.phpbbhacks.com/forums/db_generator.php

2. Ja.

Geplaatst: 12 jun 2004, 13:47
door ajcied
Er zit een fout in!

Code: Selecteer alles

Parse error: parse error in /data/members/free/tripod/nl/a/j/c/ajcied5/htdocs/phpBB2/install.php on line 123
Dit is de quary bestand dat ik aanmaakte

Code: Selecteer alles

<?php
/***************************************************************************
 *                               db_update.php
 *                            -------------------
 *
 *   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey
 *   project              : http://sourceforge.net/projects/dbgenerator
 *   Website              : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//


if( !$userdata['session_logged_in'] )
{
	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
	header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));
	exit;
}

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}


$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = array();
$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "block_position";
$sql[] = "CREATE TABLE " . $table_prefix . "block_position (
  bpid int(10) NOT NULL auto_increment,
  pkey varchar(30) NOT NULL default '',
  bposition char(1) NOT NULL default '',
  layout int(10) NOT NULL default '1',
  PRIMARY KEY  (bpid)
) TYPE=MyISAM";
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (1, 'header', '@', 0)";
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (2, 'footer', '*', 0)";
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (3, 'right', 'r', 1)";
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (4, 'center', 'c', 1)";
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (5, 'center', 'c', 2)";
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (6, 'center', 'c', 3)";
$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "block_variable";
$sql[] = "CREATE TABLE " . $table_prefix . "block_variable (
  bvid int(10) NOT NULL auto_increment,
  label varchar(30) NOT NULL default '',
  sub_label varchar(255) default NULL,
  config_name varchar(30) NOT NULL default '',
  field_options varchar(255) default NULL,
  field_values varchar(255) default NULL,
  type tinyint(1) NOT NULL default '0',
  block varchar(255) default NULL,
  PRIMARY KEY  (config_name),
  KEY bvid (bvid)
) TYPE=MyISAM";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (1, 'Number of news on portal', '', 'md_num_news', '', '', 1, 'forum')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (2, 'Length of news', 'Number of characters displayed', 'md_news_length', '', '', 1, 'forum')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (3, 'Poll Bar Length', 'decrease/increase the value for 1 vote bar length', 'md_poll_bar_length', '', '', 1, 'poll')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (4, 'News Forum ID(s)', 'comma delimited', 'md_news_forum_id', '', '', 1, 'forum')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (5, 'Poll Forum ID(s)', 'comma delimited', 'md_poll_forum_id', '', '', 1, 'poll')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (6, 'Number of recent topics', 'number of topics displayed', 'md_num_recent_topics', '', '', 1, 'recent_topics')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (7, 'Approve MOD installed?', 'tick if Approve MOD is installed', 'md_approve_mod_installed', '', '', 4, 'recent_topics')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (8, 'Recent Topics Style', 'choose static display or scrolling display', 'md_recent_topics_style', 'Scroll,Static', '1,0', 3, 'recent_topics')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (9, 'Search option text', 'Text displayed as the default option', 'md_search_option_text', '', '', 1, 'search')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (10, 'Header width', 'Width of forum-wide left column in pixels', 'header_width', '', '', 1, '@Portal Config')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (11, 'Footer width', 'Width of forum-wide right column in pixels', 'footer_width', '', '', 1, '@Portal Config')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (12, 'Cache File Locking', 'can avoid cache corruption under bad circumstances', 'md_cache_file_locking', '', '', 4, '@Portal Config')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (13, 'Cache Write Control', 'detect some corrupt cache files', 'md_cache_write_control', '', '', 4, '@Portal Config')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (14, 'Cache Read Control', 'a control key is embeded in cache file', 'md_cache_read_control', '', '', 4, '@Portal Config')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (15, 'Cache Read Control Type', 'Type of read control (only if read control is enabled)', 'md_cache_read_type', 'md5 hash control, crc32 hash control, length only test', 'md5,crc32,strlen', 2, '@Portal Config')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (16, 'Cache File Name Protection', '', 'md_cache_filename_protect', '', '', 4, '@Portal Config')";
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (17, 'Cache Automatic Serialization', 'Enable / disable automatic serialization', 'md_cache_serialize', '', '', 4, '@Portal Config')";
$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "blocks";
$sql[] = "CREATE TABLE " . $table_prefix . "blocks (
  bid int(10) NOT NULL auto_increment,
  title varchar(60) NOT NULL default '',
  content text NOT NULL,
  bposition char(1) NOT NULL default '',
  weight int(10) NOT NULL default '1',
  active tinyint(1) NOT NULL default '1',
  blockfile varchar(255) NOT NULL default '',
  view tinyint(1) NOT NULL default '0',
  layout int(10) NOT NULL default '1',
  cache tinyint(1) NOT NULL default '0',
  cache_time int(10) NOT NULL default '0',
  block_bbcode_uid varchar(10) default NULL,
  type tinyint(1) NOT NULL default '1',
  border tinyint(1) NOT NULL default '1',
  titlebar tinyint(1) NOT NULL default '1',
  background tinyint(1) NOT NULL default '1',
  local tinyint(1) NOT NULL default '0',
  groups tinytext NOT NULL,
  PRIMARY KEY  (bid)
) TYPE=MyISAM";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (1, 'Board Navigation', '<table width="100%" cellpadding="0" cellspacing="1" border="0">\r\n<tr>\r\n<td align="left"><span class="genmed" style="line-height: 150%">\r\n<a href="portal.php">Home</a><br />\r\n<a href="index.php">Forum</a><br />\r\n<a href="memberlist.php">Memberlist</a><br />\r\n<a href="faq.php">FAQ</a><br />\r\n<a href="search.php">Search</a><br />\r\n</span></td>\r\n</tr>\r\n</table>', '@', 2, 1, '', 0, 0, 0, 0, '', 0, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (2, 'Statistics', '', 'r', 3, 1, 'blocks_imp_statistics', 0, 1, 1, 43200, '', 1, 1, 1, 1, 0, '5')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (3, 'Links', '<table width="100%" cellpadding="0" cellspacing="1" border="0">\r\n<tr>\r\n<td class="row1" align="center"><a href="http://phpbbintegramod.sourceforge.net" target="_blank" class="gen">IntegraMOD</a></td>\r\n</tr>\r\n</table>', 'r', 2, 1, '', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (4, 'Welcome to IM Portal', '<table cellspacing="0" cellpadding="0" border="0" width="100%">\r\n<tr>\r\n<td align="center"><span class="gen">\r\nWelcome to IM Portal<br /><br />For questions, comments and suggestions, please visit <a href="http://www.integramod.com">IntegraMOD</a>\r\n</span>\r\n</td>\r\n</tr>\r\n</table>', 'c', 2, 1, '', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (5, 'News', '', 'c', 3, 1, 'blocks_imp_forum', 0, 1, 0, 0, '', 1, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (6, 'User Block', '', '@', 3, 1, 'blocks_imp_user_block', 0, 0, 0, 0, '', 1, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (7, 'Who is Online', '', '@', 4, 1, 'blocks_imp_online_users', 0, 0, 1, 300, '', 1, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (8, 'Poll', 'hkghk', 'r', 4, 1, 'blocks_imp_poll', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (9, 'Recent Topics', '', 'r', 1, 1, 'blocks_imp_recent_topics', 0, 1, 1, 300, '', 1, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (10, 'Search', '', '@', 5, 1, 'blocks_imp_search', 0, 0, 1, 1000000000, '', 1, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (11, 'sample block', '[size=12:81ef439b94][b:81ef439b94][color=red:81ef439b94]This is just a sample block[/color:81ef439b94][/b:81ef439b94] showing the capabilities of [b:81ef439b94][color=green:81ef439b94]IM Portal[/color:81ef439b94][/b:81ef439b94] with the use of BBCodes.[/size:81ef439b94] \r\n\r\n :lol:  8)  :o  :( \r\n[quote:81ef439b94]This version of IM Portal uses a multi-page feature to create more than one page for your portal.  Try visiting this address: [b:81ef439b94]http://www.myforum.com/portal.php?page=2[/b:81ef439b94]. Replace www.myforum.com with the correct location[/quote:81ef439b94]The block below (Welcome to IM Portal) is an example of a block using HTML.', 'c', 1, 1, '', 0, 1, 0, 0, '81ef439b94', 1, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (12, 'Sample 1', 'This page shows an example of the multi-page feature of IM Portal.  This page also displays the forum-wide blocks.\r\n\r\n[code:1:82bdfbd9b5]Try to visit: http://www.myforum.com/portal.php?page=3[/code:1:82bdfbd9b5]', 'c', 1, 1, '', 0, 2, 0, 0, '82bdfbd9b5', 1, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (13, 'Sample 6', 'This block also shows the [b:0c6a883c90][color=orange:0c6a883c90]multi-page feature of IM Portal[/color:0c6a883c90][/b:0c6a883c90].  But this time, it does not display the forum-wide blocks.\r\n\r\nYou can now proceed to the [b:0c6a883c90][color=blue:0c6a883c90]ACP[/color:0c6a883c90][/b:0c6a883c90] and delete the sample layouts/pages in the layout management page.', 'c', 1, 1, '', 0, 3, 0, 0, '0c6a883c90', 1, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (14, 'News', '', 'c', 4, 1, 'blocks_imp_forum', 0, 3, 0, 0, '', 0, 1, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (15, 'Sample 2', 'This is the new feature of IM Portal which enables a block with the following options:[list:8466b58e05][*:8466b58e05]with or without titlebar\r\n[*:8466b58e05]with or without border\r\n[*:8466b58e05]with or without background[/list:u:8466b58e05]\r\nThis block is without a titlebar, border and background', 'c', 2, 1, '', 0, 2, 0, 0, '8466b58e05', 1, 0, 0, 0, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (16, 'Sample 3', 'Without titlebar only  :o', 'c', 3, 1, '', 0, 2, 0, 0, '7e13fbbacc', 1, 1, 0, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (17, 'Sample 4', 'Without background only  :wink:', 'c', 4, 1, '', 0, 2, 0, 0, '5b8176554c', 1, 1, 1, 0, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (18, 'Sample 5', 'Without border  :arrow:  :idea:  :arrow:', 'c', 5, 1, '', 0, 2, 0, 0, 'ed31156971', 1, 0, 1, 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (19, 'Sample 7', 'Take note that pages and blocks can have different permissions.  There are 2 kinds of permissions to set, per user level and per usergroups.  It is allowed to mix permissions but it is wise to set the user level to registered when usergroups are used (e.g. making a page only accessible for a specific usergroup)  :wink:', 'c', 2, 1, '', 0, 3, 0, 0, '16703bc74c', 1, 1, 0, 0, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (20, 'Sample 8', 'To support localization for IM Portal, titlebars can also be localized so titles being displayed, instead of being retrieved from the database will be retrieved from the language files.  This only applies for those blocks which has a language file.  :shock:  8)', 'c', 3, 1, '', 0, 3, 0, 0, '48d2dd24ac', 1, 0, 1, 0, 0, '')";
$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "layout";
$sql[] = "CREATE TABLE " . $table_prefix . "layout (
  lid int(10) unsigned NOT NULL auto_increment,
  name varchar(100) NOT NULL default '',
  template varchar(100) NOT NULL default '',
  forum_wide tinyint(1) NOT NULL default '1',
  view tinyint(1) NOT NULL default '0',
  groups tinytext NOT NULL,
  PRIMARY KEY  (lid)
) TYPE=MyISAM";
$sql[] = "INSERT INTO " . $table_prefix . "layout VALUES (1, 'IM Portal Default', 'portal_body.tpl', 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "layout VALUES (2, 'Sample 1', 'layout1.tpl', 1, 0, '')";
$sql[] = "INSERT INTO " . $table_prefix . "layout VALUES (3, 'Sample 2', 'layout1.tpl', 0, 0, '')";
$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "portal_config";
$sql[] = "CREATE TABLE " . $table_prefix . "portal_config (
  id int(10) unsigned NOT NULL auto_increment,
  config_name varchar(255) NOT NULL default '',
  config_value varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (1, 'default_portal', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (2, 'portal_header', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (3, 'portal_tail', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (4, 'cache_enabled', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (5, 'md_news_length', '250')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (6, 'md_news_forum_id', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (7, 'md_num_news', '5')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (8, 'md_search_option_text', 'IM Portal')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (9, 'md_num_recent_topics', '10')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (10, 'md_approve_mod_installed', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (11, 'md_recent_topics_style', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (12, 'md_poll_bar_length', '40')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (13, 'md_poll_forum_id', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (14, 'header_width', '150')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (15, 'footer_width', '')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (16, 'md_cache_file_locking', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (17, 'md_cache_write_control', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (18, 'md_cache_read_control', '1')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (19, 'md_cache_read_type', 'md5')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (20, 'md_cache_filename_protect', '0')";
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (21, 'md_cache_serialize', '1')";

for( $i = 0; $i < count($sql); $i++ )
{
	if( !$result = $db->sql_query ($sql[$i]) )
	{
		$error = $db->sql_error();

		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
	}
	else
	{
		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successful</b></font></li><br />';
	}
}


echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>';

echo '<tr><th>Installation Complete</th></tr><tr><td><span class="genmed">Please be sure to delete this file now.<br />If you require any further assistance, please visit the <a href="http://www.phpbbhacks.com/forums">phpBBHacks.com Support Forums</a>.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Go back to your index page</a>.</span></td></table>';

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>
[/quote]

Geplaatst: 12 jun 2004, 14:26
door WebSiteNet
Zo moet hij geod zijn:

Code: Selecteer alles

<?php 
/*************************************************************************** 
*                               db_update.php 
*                            ------------------- 
* 
*   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey 
*   project              : http://sourceforge.net/projects/dbgenerator 
*   Website              : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net 
* 
***************************************************************************/ 

/*************************************************************************** 
* 
*   This program is free software; you can redistribute it and/or modify 
*   it under the terms of the GNU General Public License as published by 
*   the Free Software Foundation; either version 2 of the License, or 
*   (at your option) any later version. 
* 
***************************************************************************/ 

define('IN_PHPBB', true); 
$phpbb_root_path = './'; 
include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'common.'.$phpEx); 

// 
// Start session management 
// 
$userdata = session_pagestart($user_ip, PAGE_INDEX); 
init_userprefs($userdata); 
// 
// End session management 
// 


if( !$userdata['session_logged_in'] ) 
{ 
   $header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: '; 
   header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true)); 
   exit; 
} 

if( $userdata['user_level'] != ADMIN ) 
{ 
   message_die(GENERAL_MESSAGE, 'You are not authorised to access this page'); 
} 


$page_title = 'Updating the database'; 
include($phpbb_root_path . 'includes/page_header.'.$phpEx); 

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">'; 
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">'; 


$sql = array(); 
$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "block_position"; 
$sql[] = "CREATE TABLE " . $table_prefix . "block_position ( 
  bpid int(10) NOT NULL auto_increment, 
  pkey varchar(30) NOT NULL default '', 
  bposition char(1) NOT NULL default '', 
  layout int(10) NOT NULL default '1', 
  PRIMARY KEY  (bpid) 
) TYPE=MyISAM"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (1, 'header', '@', 0)"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (2, 'footer', '*', 0)"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (3, 'right', 'r', 1)"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (4, 'center', 'c', 1)"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (5, 'center', 'c', 2)"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_position VALUES (6, 'center', 'c', 3)"; 
$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "block_variable"; 
$sql[] = "CREATE TABLE " . $table_prefix . "block_variable ( 
  bvid int(10) NOT NULL auto_increment, 
  label varchar(30) NOT NULL default '', 
  sub_label varchar(255) default NULL, 
  config_name varchar(30) NOT NULL default '', 
  field_options varchar(255) default NULL, 
  field_values varchar(255) default NULL, 
  type tinyint(1) NOT NULL default '0', 
  block varchar(255) default NULL, 
  PRIMARY KEY  (config_name), 
  KEY bvid (bvid) 
) TYPE=MyISAM"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (1, 'Number of news on portal', '', 'md_num_news', '', '', 1, 'forum')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (2, 'Length of news', 'Number of characters displayed', 'md_news_length', '', '', 1, 'forum')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (3, 'Poll Bar Length', 'decrease/increase the value for 1 vote bar length', 'md_poll_bar_length', '', '', 1, 'poll')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (4, 'News Forum ID(s)', 'comma delimited', 'md_news_forum_id', '', '', 1, 'forum')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (5, 'Poll Forum ID(s)', 'comma delimited', 'md_poll_forum_id', '', '', 1, 'poll')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (6, 'Number of recent topics', 'number of topics displayed', 'md_num_recent_topics', '', '', 1, 'recent_topics')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (7, 'Approve MOD installed?', 'tick if Approve MOD is installed', 'md_approve_mod_installed', '', '', 4, 'recent_topics')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (8, 'Recent Topics Style', 'choose static display or scrolling display', 'md_recent_topics_style', 'Scroll,Static', '1,0', 3, 'recent_topics')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (9, 'Search option text', 'Text displayed as the default option', 'md_search_option_text', '', '', 1, 'search')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (10, 'Header width', 'Width of forum-wide left column in pixels', 'header_width', '', '', 1, '@Portal Config')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (11, 'Footer width', 'Width of forum-wide right column in pixels', 'footer_width', '', '', 1, '@Portal Config')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (12, 'Cache File Locking', 'can avoid cache corruption under bad circumstances', 'md_cache_file_locking', '', '', 4, '@Portal Config')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (13, 'Cache Write Control', 'detect some corrupt cache files', 'md_cache_write_control', '', '', 4, '@Portal Config')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (14, 'Cache Read Control', 'a control key is embeded in cache file', 'md_cache_read_control', '', '', 4, '@Portal Config')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (15, 'Cache Read Control Type', 'Type of read control (only if read control is enabled)', 'md_cache_read_type', 'md5 hash control, crc32 hash control, length only test', 'md5,crc32,strlen', 2, '@Portal Config')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (16, 'Cache File Name Protection', '', 'md_cache_filename_protect', '', '', 4, '@Portal Config')"; 
$sql[] = "INSERT INTO " . $table_prefix . "block_variable VALUES (17, 'Cache Automatic Serialization', 'Enable / disable automatic serialization', 'md_cache_serialize', '', '', 4, '@Portal Config')"; 
$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "blocks"; 
$sql[] = "CREATE TABLE " . $table_prefix . "blocks ( 
  bid int(10) NOT NULL auto_increment, 
  title varchar(60) NOT NULL default '', 
  content text NOT NULL, 
  bposition char(1) NOT NULL default '', 
  weight int(10) NOT NULL default '1', 
  active tinyint(1) NOT NULL default '1', 
  blockfile varchar(255) NOT NULL default '', 
  view tinyint(1) NOT NULL default '0', 
  layout int(10) NOT NULL default '1', 
  cache tinyint(1) NOT NULL default '0', 
  cache_time int(10) NOT NULL default '0', 
  block_bbcode_uid varchar(10) default NULL, 
  type tinyint(1) NOT NULL default '1', 
  border tinyint(1) NOT NULL default '1', 
  titlebar tinyint(1) NOT NULL default '1', 
  background tinyint(1) NOT NULL default '1', 
  local tinyint(1) NOT NULL default '0', 
  groups tinytext NOT NULL, 
  PRIMARY KEY  (bid) 
) TYPE=MyISAM"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (1, 'Board Navigation', '<table width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" border=\"0\">\r\n<tr>\r\n<td align=\"left\"><span class=\"genmed\" style=\"line-height: 150%\">\r\n<a href=\"portal.php\">Home</a><br />\r\n<a href=\"index.php\">Forum</a><br />\r\n<a href=\"memberlist.php\">Memberlist</a><br />\r\n<a href=\"faq.php\">FAQ</a><br />\r\n<a href=\"search.php\">Search</a><br />\r\n</span></td>\r\n</tr>\r\n</table>', '@', 2, 1, '', 0, 0, 0, 0, '', 0, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (2, 'Statistics', '', 'r', 3, 1, 'blocks_imp_statistics', 0, 1, 1, 43200, '', 1, 1, 1, 1, 0, '5')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (3, 'Links', '<table width=\"100%\" cellpadding=\"0\" cellspacing=\"1\" border=\"0\">\r\n<tr>\r\n<td class=\"row1\" align=\"center\"><a href=\"http://phpbbintegramod.sourceforge.net\" target=\"_blank\" class=\"gen\">IntegraMOD</a></td>\r\n</tr>\r\n</table>', 'r', 2, 1, '', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (4, 'Welcome to IM Portal', '<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"100%\">\r\n<tr>\r\n<td align=\"center\"><span class=\"gen\">\r\nWelcome to IM Portal<br /><br />For questions, comments and suggestions, please visit <a href=\"http://www.integramod.com\">IntegraMOD</a>\r\n</span>\r\n</td>\r\n</tr>\r\n</table>', 'c', 2, 1, '', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (5, 'News', '', 'c', 3, 1, 'blocks_imp_forum', 0, 1, 0, 0, '', 1, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (6, 'User Block', '', '@', 3, 1, 'blocks_imp_user_block', 0, 0, 0, 0, '', 1, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (7, 'Who is Online', '', '@', 4, 1, 'blocks_imp_online_users', 0, 0, 1, 300, '', 1, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (8, 'Poll', 'hkghk', 'r', 4, 1, 'blocks_imp_poll', 0, 1, 0, 0, '', 0, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (9, 'Recent Topics', '', 'r', 1, 1, 'blocks_imp_recent_topics', 0, 1, 1, 300, '', 1, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (10, 'Search', '', '@', 5, 1, 'blocks_imp_search', 0, 0, 1, 1000000000, '', 1, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (11, 'sample block', '[size=12:81ef439b94][b:81ef439b94][color=red:81ef439b94]This is just a sample block[/color:81ef439b94][/b:81ef439b94] showing the capabilities of [b:81ef439b94][color=green:81ef439b94]IM Portal[/color:81ef439b94][/b:81ef439b94] with the use of BBCodes.[/size:81ef439b94] \r\n\r\n :lol:  8)  :o  :( \r\n[quote:81ef439b94]This version of IM Portal uses a multi-page feature to create more than one page for your portal.  Try visiting this address: [b:81ef439b94]http://www.myforum.com/portal.php?page=2[/b:81ef439b94]. Replace www.myforum.com with the correct location[/quote:81ef439b94]The block below (Welcome to IM Portal) is an example of a block using HTML.', 'c', 1, 1, '', 0, 1, 0, 0, '81ef439b94', 1, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (12, 'Sample 1', 'This page shows an example of the multi-page feature of IM Portal.  This page also displays the forum-wide blocks.\r\n\r\n[code:1:82bdfbd9b5]Try to visit: http://www.myforum.com/portal.php?page=3[/code:1:82bdfbd9b5]', 'c', 1, 1, '', 0, 2, 0, 0, '82bdfbd9b5', 1, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (13, 'Sample 6', 'This block also shows the [b:0c6a883c90][color=orange:0c6a883c90]multi-page feature of IM Portal[/color:0c6a883c90][/b:0c6a883c90].  But this time, it does not display the forum-wide blocks.\r\n\r\nYou can now proceed to the [b:0c6a883c90][color=blue:0c6a883c90]ACP[/color:0c6a883c90][/b:0c6a883c90] and delete the sample layouts/pages in the layout management page.', 'c', 1, 1, '', 0, 3, 0, 0, '0c6a883c90', 1, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (14, 'News', '', 'c', 4, 1, 'blocks_imp_forum', 0, 3, 0, 0, '', 0, 1, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (15, 'Sample 2', 'This is the new feature of IM Portal which enables a block with the following options:[list:8466b58e05][*:8466b58e05]with or without titlebar\r\n[*:8466b58e05]with or without border\r\n[*:8466b58e05]with or without background[/list:u:8466b58e05]\r\nThis block is without a titlebar, border and background', 'c', 2, 1, '', 0, 2, 0, 0, '8466b58e05', 1, 0, 0, 0, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (16, 'Sample 3', 'Without titlebar only  :o', 'c', 3, 1, '', 0, 2, 0, 0, '7e13fbbacc', 1, 1, 0, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (17, 'Sample 4', 'Without background only  :wink:', 'c', 4, 1, '', 0, 2, 0, 0, '5b8176554c', 1, 1, 1, 0, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (18, 'Sample 5', 'Without border  :arrow:  :idea:  :arrow:', 'c', 5, 1, '', 0, 2, 0, 0, 'ed31156971', 1, 0, 1, 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (19, 'Sample 7', 'Take note that pages and blocks can have different permissions.  There are 2 kinds of permissions to set, per user level and per usergroups.  It is allowed to mix permissions but it is wise to set the user level to registered when usergroups are used (e.g. making a page only accessible for a specific usergroup)  :wink:', 'c', 2, 1, '', 0, 3, 0, 0, '16703bc74c', 1, 1, 0, 0, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "blocks VALUES (20, 'Sample 8', 'To support localization for IM Portal, titlebars can also be localized so titles being displayed, instead of being retrieved from the database will be retrieved from the language files.  This only applies for those blocks which has a language file.  :shock:  8)', 'c', 3, 1, '', 0, 3, 0, 0, '48d2dd24ac', 1, 0, 1, 0, 0, '')"; 
$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "layout"; 
$sql[] = "CREATE TABLE " . $table_prefix . "layout ( 
  lid int(10) unsigned NOT NULL auto_increment, 
  name varchar(100) NOT NULL default '', 
  template varchar(100) NOT NULL default '', 
  forum_wide tinyint(1) NOT NULL default '1', 
  view tinyint(1) NOT NULL default '0', 
  groups tinytext NOT NULL, 
  PRIMARY KEY  (lid) 
) TYPE=MyISAM"; 
$sql[] = "INSERT INTO " . $table_prefix . "layout VALUES (1, 'IM Portal Default', 'portal_body.tpl', 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "layout VALUES (2, 'Sample 1', 'layout1.tpl', 1, 0, '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "layout VALUES (3, 'Sample 2', 'layout1.tpl', 0, 0, '')"; 
$sql[] = "DROP TABLE IF EXISTS " . $table_prefix . "portal_config"; 
$sql[] = "CREATE TABLE " . $table_prefix . "portal_config ( 
  id int(10) unsigned NOT NULL auto_increment, 
  config_name varchar(255) NOT NULL default '', 
  config_value varchar(255) NOT NULL default '', 
  PRIMARY KEY  (id) 
) TYPE=MyISAM"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (1, 'default_portal', '1')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (2, 'portal_header', '1')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (3, 'portal_tail', '0')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (4, 'cache_enabled', '1')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (5, 'md_news_length', '250')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (6, 'md_news_forum_id', '1')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (7, 'md_num_news', '5')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (8, 'md_search_option_text', 'IM Portal')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (9, 'md_num_recent_topics', '10')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (10, 'md_approve_mod_installed', '0')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (11, 'md_recent_topics_style', '0')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (12, 'md_poll_bar_length', '40')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (13, 'md_poll_forum_id', '1')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (14, 'header_width', '150')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (15, 'footer_width', '')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (16, 'md_cache_file_locking', '1')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (17, 'md_cache_write_control', '1')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (18, 'md_cache_read_control', '1')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (19, 'md_cache_read_type', 'md5')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (20, 'md_cache_filename_protect', '0')"; 
$sql[] = "INSERT INTO " . $table_prefix . "portal_config VALUES (21, 'md_cache_serialize', '1')"; 

for( $i = 0; $i < count($sql); $i++ ) 
{ 
   if( !$result = $db->sql_query ($sql[$i]) ) 
   { 
      $error = $db->sql_error(); 

      echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />'; 
   } 
   else 
   { 
      echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successful</b></font></li><br />'; 
   } 
} 


echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>'; 

echo '<tr><th>Installation Complete</th></tr><tr><td><span class="genmed">Please be sure to delete this file now.<br />If you require any further assistance, please visit the <a href="http://www.phpbbhacks.com/forums">phpBBHacks.com Support Forums</a>.</span></td></tr>'; 
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Go back to your index page</a>.</span></td></table>'; 

include($phpbb_root_path . 'includes/page_tail.'.$phpEx); 

?>

Geplaatst: 12 jun 2004, 14:33
door ajcied
Fatal error: Call to undefined function: session_pagestart() in /data/members/free/tripod/nl/a/j/c/ajcied5/htdocs/phpBB2/Spellen/update.php on line 29

Geplaatst: 12 jun 2004, 15:10
door WebSiteNet
Je hebt hem niet in de root gezet. Hij moet in de zelfde map als waar index.php, viewforum.php etc staat.

Geplaatst: 12 jun 2004, 15:21
door ajcied
Had dat express gedaan omdat ie het op de phpbb2 het niet deed maar nu weer wel!

Code: Selecteer alles

#-----[ CHMOD ]------------------------------------------ 
#

create directory var_cache under your phpbb root directory and CHMOD it to 777.


#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM
Ik snap niet echt veel van dit stuk!"

Geplaatst: 12 jun 2004, 15:23
door ajcied
Doet het al!
Alle tijden zijn UTC+01:00
Pagina 1 van 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/