Cod: Selectaţi tot
phpBB : Critical Error
Could not query config information
DEBUG MODE
SQL Error : 1146 Table 'xzone_1g.CONFIG_TABLE' doesn't exist
SELECT * FROM CONFIG_TABLE
Line : 215
File : common.php
Cod: Selectaţi tot
phpBB : Critical Error
Could not query config information
DEBUG MODE
SQL Error : 1146 Table 'xzone_1g.CONFIG_TABLE' doesn't exist
SELECT * FROM CONFIG_TABLE
Line : 215
File : common.php
Cod: Selectaţi tot
#
# STEP 3/3: Updating the database
#
Run:
reputation_mod_install_db_v100.php
reputation_mod_install_users_v100.php
Then delete them!
Cod: Selectaţi tot
Warning: include() [function.include]: Unable to access ./extension.inc in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 8
Warning: include(./extension.inc) [function.include]: failed to open stream: No such file or directory in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 8
Warning: include() [function.include]: Failed opening './extension.inc' for inclusion (include_path='.:./includes:../includes:/users/common') in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 8
Warning: include() [function.include]: Unable to access ./common. in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 9
Warning: include(./common.) [function.include]: failed to open stream: No such file or directory in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 9
Warning: include() [function.include]: Failed opening './common.' for inclusion (include_path='.:./includes:../includes:/users/common') in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 9
Fatal error: Call to undefined function session_pagestart() in /users/1gb.at/x/xz/xzone/f2/admin/mods/reputation_mod_install_db_v100.php on line 11
Cod: Selectaţi tot
<?php
//copyright © 2004 IdleVoid & brustverein
//copyright © 2003 Volodymy (CLowN) Skoryk
//this update template copyright © 2006 Anton Granik
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
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=reputation_mod_install_db_v100.$phpEx", true));
exit;
}
if( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}
$page_title = 'Setting the database for Reputation Mod v.1.0.0 by Anton Granik';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
echo '<table>';
echo '<tr><th>Setting the database for Reputation Mod v.1.0.0 by Anton Granik</th></tr><tr><td><span><ul>';
$sql = array();
$sql[] = " CREATE TABLE `" . $table_prefix . "reputation` (
`user_id` mediumint(8) NOT NULL default '0',
`user_id_2` mediumint(8) NOT NULL default '0',
`post_id` mediumint(8) NOT NULL default '0',
`rep_sum` FLOAT NOT NULL default '0',
`rep_neg` tinyint(1) NOT NULL default '0',
`rep_comment` varchar(200) NOT NULL default '',
`rep_time` int(11) NOT NULL default '0',
KEY `user_id` (`user_id`)
) TYPE=MyISAM;";
$sql[] = " CREATE TABLE `" . $table_prefix . "reputation_config` (
`config_name` VARCHAR( 255 ) NOT NULL ,
`config_value` VARCHAR( 255 ) NOT NULL
) TYPE=MyISAM;";
$sql[] = " ALTER TABLE `" . $table_prefix . "users` ADD `user_reputation` FLOAT DEFAULT '0' NOT NULL";
$sql[] = " ALTER TABLE `" . $table_prefix . "users` ADD `user_rep_last_time` INT( 11 ) NOT NULL AFTER `user_reputation`";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('posts_to_earn', '50')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('rep_disable', '0')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('days_to_earn', '30')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('flood_control_time', '30')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('graphic_version', '1')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal4_to_earn', '10')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal3_to_earn', '50')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal2_to_earn', '100')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal1_to_earn', '200')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('given_rep_to_earn', '20')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('show_stats_to_mods', '0')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('repsum_limit', '0')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('pm_notify', '1')";
$sql[] = " INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('default_amount', '0')";
$errors = 0;
for( $i = 0; $i <count>sql_query ($sql[$i]) )
{
$error = $db->sql_error();
echo '<li>' . $sql[$i] . '<br> +++ <font><b>Error:</b></font> ' . $error['message'] . '</li><br>';
}
else
{
echo '<li>' . $sql[$i] . '<br> +++ <font><b>Successfull</b></font></li><br>';
}
}
if ($errors == 0)
echo '<tr><th>Finish</th></tr><tr><td><span>Now run <a href="reputation_mod_install_users_v100.php">reputation_mod_install_users_v100.php</a> to create reputations for users with default settings. Or go to the admin panel -> reputation and change the config values according to what you want on your board and run the file after that.</span></td></tr></table>';
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>
Cod: Selectaţi tot
CREATE TABLE `" . $table_prefix . "reputation` (
`user_id` mediumint(8) NOT NULL default '0',
`user_id_2` mediumint(8) NOT NULL default '0',
`post_id` mediumint(8) NOT NULL default '0',
`rep_sum` FLOAT NOT NULL default '0',
`rep_neg` tinyint(1) NOT NULL default '0',
`rep_comment` varchar(200) NOT NULL default '',
`rep_time` int(11) NOT NULL default '0',
KEY `user_id` (`user_id`)
) TYPE=MyISAM;";
CREATE TABLE `" . $table_prefix . "reputation_config` (
`config_name` VARCHAR( 255 ) NOT NULL ,
`config_value` VARCHAR( 255 ) NOT NULL
) TYPE=MyISAM;";
ALTER TABLE `" . $table_prefix . "users` ADD `user_reputation` FLOAT DEFAULT '0' NOT NULL";
ALTER TABLE `" . $table_prefix . "users` ADD `user_rep_last_time` INT( 11 ) NOT NULL AFTER `user_reputation`";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('posts_to_earn', '50')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('rep_disable', '0')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('days_to_earn', '30')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('flood_control_time', '30')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('graphic_version', '1')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal4_to_earn', '10')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal3_to_earn', '50')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal2_to_earn', '100')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('medal1_to_earn', '200')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('given_rep_to_earn', '20')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('show_stats_to_mods', '0')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('repsum_limit', '0')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('pm_notify', '1')";
INSERT INTO `" . $table_prefix . "reputation_config` VALUES ('default_amount', '0')";
Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 5 vizitatori