kb mod
Scris: 24-Aug-2006, 17:32:51
am instalat modul kb si cand dau sa ruleze install_kb_tables.php imi da urmatoarea eroare
am incercat sa rulez manual comenzile sql dar..nu stiu care sunt:Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in c:\program files\easyphp1-8\www\db\mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in c:\program files\easyphp1-8\www\db\mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in c:\program files\easyphp1-8\www\db\mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database
va rog spuneti-mi ce sa fac ?/***************************************************************************
* install_kb_tables.php
* -------------------
* begin : Wednesday, May 16, 2002
* copyright : Eric
* email : eric@egcnetwork.com
*
* $Id: install_kb_tables.php
*
***************************************************************************/
/***************************************************************************
*
* 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', 1);
$phpbb_root_path = './';
define( 'MXBB_MODULE', false ); // Switch for making this run as a phpBB mod or mxBB module
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'config.'.$phpEx);
include($phpbb_root_path . 'includes/constants.'.$phpEx);
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/db.'.$phpEx);
include($phpbb_root_path . 'includes/kb_constants.'.$phpEx);
// A few additional checks to avoid blunders during install/upgrade
define( 'phpBBroot_ok', file_exists( $phpbb_root_path . 'viewtopic.php' ) );
define( 'kbconstants_ok', defined( 'KB_CUSTOM_TABLE' ) );
if ( !phpBBroot_ok )
{
message_die(GENERAL_ERROR, "This install/upgrade script should be uploaded to the phpBB root.");
}
if ( !kbconstants_ok )
{
message_die(GENERAL_ERROR, "You haven't uploaded latest kb_constants.php.");
}
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
if ( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_ERROR, "You must be an Administrator to use this page.");
}
define('KB_VERSION','KB MOD 2.0.2');
?>
<DOCTYPE>
<html>
<title>Install File for MOD's</title>
<head>
<meta>
<meta>
<style>
</style>
</head>
<body>
<table>
<tr>
<td><table>
<tr>
<td><a href="./index.php"><img></a></td>
<td><span>Installing Knowledge Base</span></td>
</tr>
</table></td>
</tr>
</table>
<br>
<h2>Information</h2>
<php>sql_query($sql)) )
{
die("Couldn't obtain version info");
}
$row = $db->sql_fetchrow($result);
$phpBB_version = $row['config_value'] ;
$sql = array();
// output some info
echo '<p>Database type :: <b>' . SQL_LAYER . '</b><br>';
echo 'phpBB version :: <b>2' . $phpBB_version . '</b><br>';
echo 'Knowledge Base MOD version :: <b>' . KB_VERSION . '</b></p>' ."\n";
?>
<br>
<h3>What are you going to do ?</h3>
This file is used to do the changes to your database (adding/modifying a table) to make the MOD working properly.
If you have any problem during this part, you can contact me to get support. Now, if you are ready, click on the button.
<br>
<center>
<form>
<input>
</form>
</center>
<?php
$submit = ( isset($HTTP_POST_VARS['submit']) ) ? $HTTP_POST_VARS['submit'] : 0;
if ( $submit )
{
switch ( SQL_LAYER )
{
case 'mysql':
case 'mysql4':
$sql[]= 'CREATE TABLE '. KB_ARTICLES_TABLE .' (
article_id mediumint(8) unsigned NOT NULL auto_increment,
article_category_id mediumint(8) unsigned NOT NULL default "0",
article_title varchar(255) binary NOT NULL default "",
article_description varchar(255) binary NOT NULL default "",
article_date varchar(255) binary NOT NULL default "",
article_author_id mediumint(8) NOT NULL,
username VARCHAR(255),
bbcode_uid varchar(10) binary NOT NULL default "",
article_body text NOT NULL,
article_type mediumint(8) unsigned NOT NULL default "0",
approved tinyint(1) unsigned NOT NULL default "0",
topic_id mediumint(8) unsigned NOT NULL default "0",
views BIGINT(8) NOT NULL DEFAULT "0",
article_rating double(6,4) NOT NULL default "0.0000",
article_totalvotes int(255) NOT NULL default "0",
KEY article_id (article_id)
) TYPE=MyISAM;';
$sql[] = 'INSERT INTO '. KB_ARTICLES_TABLE .' VALUES (
1, 1, "Test Article", "This is a test article for your KB", "1057708235", 2, "", "93074f48a9", "This is a test article for your Knowledge Base. This MOD is based on code written by wGEric < eric@egcnetwork.com > (Eric Faerber) - http://eric.best-1.biz/, now supervised by _Haplo < jonohlsson@hotmail.com > (Jon Ohlsson) - http://www.mx-system.com/ \r\n\r\nBe sure you add categories and article types in the ACP and also change the Configuration to your liking.\r\n\r\nHave fun and enjoy your new Knowledge Base!", 1, 1, 0, 0,0,0
);';
$sql[] = 'CREATE TABLE '.KB_CATEGORIES_TABLE.' (
category_id mediumint(8) unsigned NOT NULL auto_increment,
category_name VARCHAR(255) binary NOT NULL,
category_details VARCHAR(255) binary NOT NULL,
number_articles mediumint(8) unsigned NOT NULL,
parent mediumint(8) unsigned,
cat_order mediumint(8) unsigned NOT NULL,
auth_view tinyint(3) NOT NULL DEFAULT "0",
auth_post tinyint(3) NOT NULL DEFAULT "0",
auth_rate tinyint(3) NOT NULL DEFAULT "0",
auth_comment tinyint(3) NOT NULL DEFAULT "0",
auth_edit tinyint(3) NOT NULL DEFAULT "0",
auth_delete tinyint(3) NOT NULL DEFAULT "2",
auth_approval tinyint(3) NOT NULL DEFAULT "0",
auth_approval_edit tinyint(3) NOT NULL DEFAULT "0",
auth_view_groups varchar(255),
auth_post_groups varchar(255),
auth_rate_groups varchar(255),
auth_comment_groups varchar(255),
auth_edit_groups varchar(255),
auth_delete_groups varchar(255),
auth_approval_groups varchar(255),
auth_approval_edit_groups varchar(255),
auth_moderator_groups varchar(255),
comments_forum_id tinyint(3) NOT NULL DEFAULT "-1",
KEY category_id (category_id)
) TYPE=MyISAM';
$sql[] = 'INSERT INTO '.KB_CATEGORIES_TABLE.' VALUES (1, "Test Category 1", "This is a test category", "0", "0", "10", "0", "0", "0", "0", "0", "2", "0", "0", "", "", "", "", "", "", "", "", "", "0" );';
$sql[] = 'CREATE TABLE '.KB_CONFIG_TABLE.' (
config_name VARCHAR(255) NOT NULL default "",
config_value varchar(255) NOT NULL default "",
PRIMARY KEY (config_name)
) TYPE=MyISAM';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_new", "1")';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("notify", "1")';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("admin_id", "2")';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) values("show_pretext",0);';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) values("pt_header","Article Submission Instructions");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) values("pt_body","Please check your references and include as much information as you can.");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("use_comments", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("del_topic", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("use_ratings", "0");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("comments_show", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("bump_post", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("stats_list", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("header_banner", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("votes_check_userid", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("votes_check_ip", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("art_pagination", "5");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("comments_pagination", "5");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("news_sort", "Alphabetic");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("news_sort_par", "ASC");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("wysiwyg", "0");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("wysiwyg_path", "modules/");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_html", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_bbcode", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allow_smilies", "1");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("formatting_fixup", "0");';
$sql[] = 'INSERT INTO '.KB_CONFIG_TABLE.' (config_name, config_value) VALUES ("allowed_html_tags", "b,i,u,a");';
$sql[] = 'CREATE TABLE ' . KB_TYPES_TABLE . ' (
id mediumint(8) unsigned NOT NULL auto_increment,
type varchar(255) binary DEFAULT "" NOT NULL,
KEY id (id)
) TYPE=MyISAM';
$sql[] = 'INSERT INTO '. KB_TYPES_TABLE . ' VALUES (1, "Test Type 1")';
$sql[] = 'CREATE TABLE '. KB_VOTES_TABLE . ' (
votes_ip varchar(50) NOT NULL default "0",
votes_userid int(50) NOT NULL default "0",
votes_file int(50) NOT NULL default "0"
) TYPE=MyISAM';
$sql[] = 'CREATE TABLE ' . KB_SEARCH_TABLE . ' (
search_id int(11) unsigned NOT NULL default "0",
session_id varchar(32) NOT NULL default "",
search_array text NOT NULL,
PRIMARY KEY (search_id),
KEY session_id (session_id)
) TYPE=MyISAM;';
$sql[] = 'CREATE TABLE ' . KB_WORD_TABLE . ' (
word_text varchar(50) binary NOT NULL default "",
word_id mediumint(8) unsigned NOT NULL auto_increment,
word_common tinyint(1) unsigned NOT NULL default "0",
PRIMARY KEY (word_text),
KEY word_id (word_id)
) TYPE=MyISAM;';
$sql[] = 'CREATE TABLE ' . KB_MATCH_TABLE . ' (
article_id mediumint(8) unsigned NOT NULL default "0",
word_id mediumint(8) unsigned NOT NULL default "0",
title_match tinyint(1) NOT NULL default "0",
KEY post_id (article_id),
KEY word_id (word_id)
) TYPE=MyISAM;';
$sql[] = 'CREATE TABLE ' . KB_CUSTOM_TABLE . ' (
custom_id int(50) NOT NULL auto_increment,
custom_name text NOT NULL,
custom_description text NOT NULL,
data text NOT NULL,
field_order int(20) NOT NULL default "0",
field_type tinyint(2) NOT NULL default "0",
regex varchar(255) NOT NULL default "",
PRIMARY KEY (custom_id)
) TYPE=MyISAM;';
$sql[] = 'CREATE TABLE ' . KB_CUSTOM_DATA_TABLE . ' (
customdata_file int(50) NOT NULL default "0",
customdata_custom int(50) NOT NULL default "0",
data text NOT NULL
) TYPE=MyISAM;';
break;
case 'mssql':
case 'mssql-odbc':
default:
die("/!\ No Database Abstraction Layer (DBAL) found /!\\");
break;
}
echo("<h2>Adding/modifying tables to your database</h2>\n");
for ($i=0; $i <count>sql_query($sql[$i])) )
{
$error_code = TRUE;
$error = $db->sql_error();
echo(" -> <b><span>ERROR - QUERY FAILED</span></b> ----> <u>" . $error['message'] . "</u><br><br>\n\n");
}
else
{
echo(" -> <b><span>GOOD - QUERY OK</span></b><br><br>\n\n");
}
}
$error_message = "";
if ( $error_code )
{
$error_message .= "<br>At least one query failed : check the error message and contact me if you need help to resolve the problem. <br>";
}
else
{
$error_message .= "<br>All the queries have been successfully done - Enjoy. <br>";
}
echo("\n<br>\n<b>COMPLETE - INSTALLATION IS ENDED</b><br>\n");
echo($error_message . "<br>");
echo("<br><b>NOW, DELETE THIS FILE FROM YOUR SERVER</b><br>\n");
}