Blackscorpian

Hallo, ich habe echt ein blödes problem, ich hab alles gemacht was in der anleitung für einen WoW privatserver steht aber wenn ich WoW starte und administrator und administrator eingebe steht da: Fehlgeschlagen dan kann ich ok oder hilfe aussuchen, was muss ich machen?

ich bins mal wieder kannst du mal bitte ein backup von playercreateinfo_item machen, hochladen und mir link geben? hab was vercheckt und will die ganze db nich wieder neu batchen

aso und wollte noch etwas fragen, wenn ich wotlk server mach muss dan jeder das addon haben damit man drauf spielen kann? also wrath of lich king?

aso und wollte noch etwas fragen, wenn ich wotlk server mach muss dan jeder das addon haben damit man drauf spielen kann? also wrath of lich king?

also auf der webpage dort das forum löschen^^

ok sry hat sich auch wieder erledigt jetzt funzt alles ^^ hab mich eben vertippt beim forum kannst du mir sagen wie ich da ein forum wieder löschen kann hab die page neu installiert funzt aber nicht

Ok hat sich erledigt^^ hab nurnoch eine frage wiso kommt auf der WebPage oben immer

SQL Error: Unknown database 'character' at C:\xampp\htdocs\index.php line 210

Array
(
[code] => 1049
[message] => Unknown database 'character'
[query] => mysql_select_db()
[context] => C:\xampp\htdocs\index.php line 210
)

funktioniert ja sonst alles aber das nervt :P Ich post mal was in index.php drin steht

<?php
/************************************************** **************************/
/* < MangosWeb is a Web-Fonted for Mangos (mangosproject.org) > */
/* Copyright (C) <2007> <Sasha,TGM,Peec,Nafe> */
/* */
/* 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. */
/* */
/* This program is distributed in the hope that it will be useful, */
/* but WITHOUT ANY WARRANTY; without even the implied warranty of */
/* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the */
/* GNU General Public License for more details. */
/* */
/* You should have received a copy of the GNU General Public License */
/* along with this program. If not, see <http://www.gnu.org/licenses/>. */
/* */
/* $Rev$ */
/************************************************** **************************/
// Set error reporting to only a few things.
error_reporting(E_ERROR | E_PARSE | E_WARNING);
// Define INCLUDED so that we can check other pages if they are included by this file
define('INCLUDED', true);

// Start a variable that shows how fast page loaded.
$time_start = microtime(1);
$_SERVER['REQUEST_TIME'] = time();

// Initialize config's.
include('core/class.mangosweb.php');
$MW = new mangosweb; // Super global.

// Site functions & classes ...
include('core/common.php');
include "core/mangos.class.php";
include('core/class.auth.php');
require_once('core/dbsimple/Generic.php');
require ('core/class.captcha.php');
include("core/cache_class/safeIO.php");
include("core/cache_class/gCache.php");


//Site notice cookie
if(file_exists("ToS.html") && !isset($_COOKIE['agreement_accepted'])) {
include('notice.php');
exit();
}



// Inizialize difrent variables.
global $MW, $mangos;
// Super-Global variables.
$GLOBALS['users_online']=array();
$GLOBALS['guests_online']=0;
$GLOBALS['messages'] = '';
$GLOBALS['redirect'] = '';
$GLOBALS['sidebarmessages'] = '';
$GLOBALS['context_menu'] = array();
$GLOBALS['user_cur_lang'] = (string)$MW->getConfig->generic->default_lang;

// Inzizalize Cache class
$cache = new gCache;
$cache->folder = './core/cache/sites';
$cache->timeout = $MW->getConfig->generic->cache_expiretime;

// Assign a connect variable to class call.
// DB layer documentation at http://en.dklab.ru/lib/DbSimple/
$DB = dbsimple_Generic::connect("".$MW->getDbInfo['db_type']."://".$MW->getDbInfo['db_username'].":".$MW->getDbInfo['db_password']."@".$MW->getDbInfo['db_host'].":".$MW->getDbInfo['db_port']."/".$MW->getDbInfo['db_name']."");
// Set error handler for $DB.
$DB->setErrorHandler('databaseErrorHandler');
// Also set to default encoding for $DB
$DB->query("SET NAMES ".$MW->getDbInfo['db_encoding']);

// Play arround for IIS lake on $_SERVER['REQUEST_URI']
if ($_SERVER['REQUEST_URI'] == "") {
if ($_SERVER['QUERY_STRING'] != "") {
$__SERVER['REQUEST_URI'] = $_SERVER["SCRIPT_NAME"] ."?". $_SERVER['QUERY_STRING'];
} else {
$__SERVER['REQUEST_URI'] = $_SERVER["SCRIPT_NAME"];
}
} else {
$__SERVER['REQUEST_URI'] = $_SERVER['REQUEST_URI'];
}


// Build path vars //
$MW->add_temp_confs(array(
'site_href' => str_replace('//','/',str_replace('\\','/',dirname($_SERVER['SCRIPT_NAME']).'/'))
));
$MW->add_temp_confs(array(
'site_domain' => $_SERVER['HTTP_HOST'],
'email_href' => $_SERVER['HTTP_HOST']
));
$MW->add_temp_confs(array(
'base_href' => 'http://'.$MW->getConfig->temp->email_href.''.$MW->getConfig->temp->site_href,
'template_href' => $MW->getConfig->temp->site_href.'templates/'.$MW->getConfig->generic->template.'/',
));


// Check lang ======================================
if(isset($_COOKIE['Language'])) $GLOBALS['user_cur_lang'] = $_COOKIE['Language'];
loadLanguages();
// ================================================

// Load auth system //
$auth = new AUTH($DB,$MW->getConfig);
$user = $auth->user;
// ================== //
// Load Permissions and aviable sites.
include('core/default_components.php');

// Start of context menu. ( Only make an array for later output )
$GLOBALS['context_menu'][] = array('title'=>$lang['mainpage'],'link'=>'index.php');

if($user['id']<=0){
$GLOBALS['context_menu'][] = array('title'=>$lang['register'],'link'=>'index.php?n=account&sub=register');
}
$GLOBALS['context_menu'][] = array('title'=>'Forum','link'=>'index.php?n=forum' );
$GLOBALS['context_menu'][] = array('title'=>$lang['players_online'],'link'=>'index.php?n=server&sub=playersonline');
if((isset($user['g_is_admin']) || isset($user['g_is_supadmin'])) && ($user['g_is_admin']==1 || $user['g_is_supadmin']==1)){
$allowed_ext[] = 'admin';
$GLOBALS['context_menu'][] = array('title'=>'------------------','link'=>'#');
$GLOBALS['context_menu'][] = array('title'=>$lang['admin_panel'],'link'=>'index.php?n=admin');
}

// for mod_rewrite query_string fix //
global $_GETVARS;

$req_vars = parse_url($__SERVER['REQUEST_URI']);
if(isset($req_vars['query'])){
parse_str($req_vars['query'], $req_arr);
$_GETVARS = $req_arr;
}
unset($req_arr, $req_vars);
// ================================================== ===== //

// Finds out what realm we are viewing.
// This long operation is only if its more than one realm.
$MW->getConfig->generic_values->realm_info->multirealm = (int)$DB->selectCell("SELECT count(id) FROM `realmlist`") > 1 ? 1 : 0;


//Part of the Realm-Select System
if ((int)$MW->getConfig->generic_values->realm_info->multirealm){

if (isset($_REQUEST['changerealm_to'])){
setcookie("cur_selected_realmd", intval($_REQUEST['changerealm_to']), time()+(3600*24)); /* expire in 24 hour */
}
}
//end part



// Only load function to choose what realm if user is logged in and we have more than one realm
if ((int)$MW->getConfig->generic_values->realm_info->multirealm && isset($_COOKIE['cur_selected_realmd'])){
$user['cur_selected_realmd'] = intval($_COOKIE['cur_selected_realmd']);
}else{
$user['cur_selected_realmd'] = $MW->getConfig->generic_values->realm_info->default_realm_id;
}
$mangos_info = $DB->selectCell("SELECT dbinfo FROM `realmlist` WHERE id=?d",$user['cur_selected_realmd']);

// Make an array from `dbinfo` column for the selected realm..
$dbinfo_mangos = explode(';', $mangos_info);
if((int)$MW->getConfig->generic->use_archaeic_dbinfo_format) {
//alternate config - for users upgrading from Modded MaNGOS Web
//DBinfo column: host;port;username;password;WorldDBname;CharDBname
$mangos = array(
'db_type' => 'mysql',
'db_host' => $dbinfo_mangos['0'], //ip of db world
'db_port' => $dbinfo_mangos['1'], //port
'db_username' => $dbinfo_mangos['2'], //world user
'db_password' => $dbinfo_mangos['3'], //world password
'db_name' => $dbinfo_mangos['4'], //world db name
'db_char' => $dbinfo_mangos['5'], //character db name
'db_encoding' => 'utf8', // don't change
);
}
else {
//normal config, as outlined in how-to
//DBinfo column: username;password;port;host;WorldDBname;CharDBname
$mangos = array(
'db_type' => 'mysql',
'db_host' => $dbinfo_mangos['3'], //ip of db world
'db_port' => $dbinfo_mangos['2'], //port
'db_username' => $dbinfo_mangos['0'], //world user
'db_password' => $dbinfo_mangos['1'], //world password
'db_name' => $dbinfo_mangos['4'], //world db name
'db_char' => $dbinfo_mangos['5'], //character db name
'db_encoding' => 'utf8', // don't change
);
}
unset($dbinfo_mangos, $mangos_info); // Free up memory.

if((int)$MW->getConfig->generic->use_alternate_mangosdb_port) {
$mangos['db_port'] = (int)$MW->getConfig->generic->use_alternate_mangosdb_port;
}

// Output error message and die if user has not changed info in realmd.realmlist.`dbinfo` .
if($mangos['db_host'] == '127.0.0.1' && $mangos['db_port'] == '3306' && $mangos['db_username'] == 'username' && $mangos['db_password'] == 'password' && $mangos['db_name'] == 'DBName'){
echo "Please read README_HOWTO.txt, This is a error message btw. You must remember to setup the WORLD database information in the realm.realmlist database! <br />Edit the `dbinfo` to: World database info: username;password;3306;127.0.0.1;DBName";
die;
}

//Connects to WORLD DB
$WSDB = DbSimple_Generic::connect("".$mangos['db_type']."://".$mangos['db_username'].":".$mangos['db_password']."@".$mangos['db_host'].":".$mangos['db_port']."/".$mangos['db_name']."");
if($WSDB)$WSDB->setErrorHandler('databaseErrorHandler');
if($WSDB)$WSDB->query("SET NAMES ".$mangos['db_encoding']);

$CHDB = DbSimple_Generic::connect("".$mangos['db_type']."://".$mangos['db_username'].":".$mangos['db_password']."@".$mangos['db_host'].":".$mangos['db_port']."/".$mangos['db_char']."");
if($CHDB)$CHDB->setErrorHandler('databaseErrorHandler');
if($CHDB)$CHDB->query("SET NAMES ".$mangos['db_encoding']);
unset($mangos); // Free up memory.


if(empty($_GET['p']) OR $_GET['p'] < 1)$p = 1;else $p = $_GET['p'];
$ext = (isset($_REQUEST['n'])?$_REQUEST['n']string)$MW->getConfig->generic->default_component);
$sub = (isset($_REQUEST['sub'])?$_REQUEST['sub']:'index');
$req_tpl = false;

//initialize modules
//if installing a new module, please delete the cache file
include('components/modules/initialize.php');



if(in_array($ext,$allowed_ext)){

// load component

//set defaults here to be loaded -- these can be changed via the main.php or whatnot
//this is used especially in the case of the module system
$script_file = 'components/'.$ext.'/'.$ext.'.'.$sub.'.php';
$template_file = 'templates/'.(string)$MW->getConfig->generic->template.'/'.$ext.'/'.$ext.'.'.$sub.'.php';

require('components/'.$ext.'/'.'main.php');
if($com_content[$ext]['index'][0] && $user[((string)$com_content[$ext]['index'][0])] != 1)
exit('<h2>Forbidden</h2><meta http-equiv=refresh content="3;url=\'./\'">');
// ==================== //
if(isset($_REQUEST['n']) && isset($lang[$com_content[$ext]['index'][1]]))$pathway_info[] = array('title'=>$lang[$com_content[$ext]['index'][1]],'link'=>$com_content[$ext]['index'][2]);
// ==================== //
foreach ($com_content[(string)$ext] as $sub_name => $sub_conf){
if($sub_conf[4]==1){
if($sub_conf[0]){
if($user[$sub_conf[0]]==1){
$GLOBALS['context_menu'][] = array('title'=>(isset($lang[$sub_conf[1]]) ? $lang[$sub_conf[1]] : '??title??'),'link'=>(isset($sub_conf[2]) ? $sub_conf[2] : '?link?'));
}
}
else{
if(isset($lang[$sub_conf[1]]))$GLOBALS['context_menu'][] = array('title'=>$lang[$sub_conf[1]],'link'=>$sub_conf[2]);
}
}
}
if($sub){
if($com_content[$ext][$sub]){
if($com_content[$ext][$sub][0]){
if($user[$com_content[$ext][$sub][0]]==1){
$req_tpl = TRUE;
@include($script_file);
}
}
else{
$req_tpl = TRUE;
@include($script_file);

}
}
}
if(empty($_GET['nobody'])){
include('templates/'.(string)$MW->getConfig->generic->template.'/body_functions.php');
ob_start();
include('templates/'.(string)$MW->getConfig->generic->template.'/body_header.php');
ob_end_flush();

// DEBUG //
if((int)$MW->getConfig->generic->debuginfo){
output_message('debug','DEBUG://'.$DB->_statistics['count']);
output_message('debug','<pre>'.print_r($_SERVER,tr ue).'</pre>');
}
// =======//
if($req_tpl){
if(file_exists($template_file)){
// Only cache if user is not logged in.
if ($user['id'] < 0 && (int)$MW->getConfig->generic->cache_expiretime != 0){

// Start caching process But we want to exclude some cases.
if (
isset($_REQUEST['n']) && $_REQUEST['n'] != 'account'
){
$cache->contentId = md5('CONTENT'.$_SERVER['REQUEST_URI']);
if ($cache->Valid()) {
echo $cache->content;
}else{
$cache->capture();
include($template_file);
$cache->endcapture();
}
}else{
include($template_file);
}

}else{
// Create output buffer
ob_start();
include($template_file);
ob_end_flush();
}
}
}
$time_end = microtime(1);
$exec_time = $time_end - $time_start;
include('templates/'.(string)$MW->getConfig->generic->template.'/body_footer.php');
}
else{
if(file_exists($template_file)){

include($template_file);

}
}
}
else{
echo'<h2>Forbidden</h2><meta http-equiv=refresh content="3;url=\'./\'">';
}


?>

weißt du was ich ändern muss?

Hallo, kannst du mir mal helfen? Wenn ich Server starten will kommt "Error in creature-template table, probably sql file format was updated (there should be 63 fields in sql)" hier ist mein Server log

2008-06-30 12:26:50 Using configuration file mangosd.conf.
2008-06-30 12:26:50 MaNGOS daemon /0.11.0-SVN (Revision 5937) (Win32)
2008-06-30 12:26:50 <Ctrl-C> to stop.


MM MM MM MM MMMMM MMMM MMMMM
MM MM MM MM MMM MMM MM MM MMM MMM
MMM MMM MMM MM MMM MMM MM MM MMM
MM M MM MMMM MM MMM MM MM MMM
MM M MM MMMMM MM MMMM MMM MM MM MMM
MM M MM M MMM MM MMM MMMMMMM MM MM MMM
MM MM MMM MM MM MM MMM MM MM MMM
MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM
MM MM MM MMM MM MM MMMMMM MMMM MMMMM
MM MMM
MMMMMM


2008-06-30 12:26:50 World Database: 127.0.0.1;3306;root;root;mangos
2008-06-30 12:26:50 MySQL client library: 5.0.56
2008-06-30 12:26:50 MySQL server ver: 5.0.45-community-nt
2008-06-30 12:26:50 Character Database: 127.0.0.1;3306;root;root;characters
2008-06-30 12:26:50 MySQL client library: 5.0.56
2008-06-30 12:26:50 MySQL server ver: 5.0.45-community-nt
2008-06-30 12:26:50 Login Database: 127.0.0.1;3306;root;root;realmd
2008-06-30 12:26:50 MySQL client library: 5.0.56
2008-06-30 12:26:50 MySQL server ver: 5.0.45-community-nt
2008-06-30 12:26:50 Realm running as realm ID 1
2008-06-30 12:26:50 Using SD2 427
2008-06-30 12:26:50 Using DataDir ./
2008-06-30 12:26:50 WORLD: VMap support included. LineOfSight:0, getHeight:0
2008-06-30 12:26:50 WORLD: VMap data directory is: ./vmaps
2008-06-30 12:26:50 WORLD: VMap config keys are: vmap.enableLOS, vmap.enableHeight, vmap.ignoreMapIds, vmap.ignoreSpellIds
2008-06-30 12:26:51
2008-06-30 12:26:51 Loading MaNGOS strings...
2008-06-30 12:26:51
2008-06-30 12:26:51 >> Loaded 552 MaNGOS strings
2008-06-30 12:26:51 Initialize data stores...
2008-06-30 12:26:53
2008-06-30 12:26:53 >> Loaded 52 data stores
2008-06-30 12:26:53
2008-06-30 12:26:53 Using Autodetected DBC Locale (3).

2008-06-30 12:26:53 Cleaning up instances...
2008-06-30 12:26:53
2008-06-30 12:26:53 >> Initialized 0 instances, deleted 0 old instances
2008-06-30 12:26:53 Packing instances...
2008-06-30 12:26:53
2008-06-30 12:26:53 >> Instance numbers remapped, next instance id is 1
2008-06-30 12:26:53 Loading Localization strings...
2008-06-30 12:26:53
2008-06-30 12:26:53 >> Loaded 506 MaNGOS locale strings
2008-06-30 12:26:54
2008-06-30 12:26:54 >> Loaded 18065 creature locale strings
2008-06-30 12:26:55
2008-06-30 12:26:55 >> Loaded 13554 gameobject locale strings
2008-06-30 12:26:57
2008-06-30 12:26:57 >> Loaded 23920 Item locale strings
2008-06-30 12:26:58
2008-06-30 12:26:58 >> Loaded 6226 Quest locale strings
2008-06-30 12:26:59
2008-06-30 12:26:59 >> Loaded 4306 NpcText locale strings
2008-06-30 12:26:59
2008-06-30 12:26:59 >> Loaded 0 PageText locale strings. DB table `locales_page_text` is empty.
2008-06-30 12:26:59 Loading Page Texts...
2008-06-30 12:26:59 >> Loaded 1423 page texts
2008-06-30 12:26:59
2008-06-30 12:26:59 Loading Game Object Templates...
2008-06-30 12:27:02 >> Loaded 13554 game object templates
2008-06-30 12:27:02
2008-06-30 12:27:02 Loading Spell Chain Data...
2008-06-30 12:27:02
2008-06-30 12:27:02 >> Loaded 1919 spell chain records
2008-06-30 12:27:02 Loading Spell Elixir types...
2008-06-30 12:27:02
2008-06-30 12:27:02 >> Loaded 98 spell elixir definitions
2008-06-30 12:27:02 Loading Spell Learn Skills...
2008-06-30 12:27:02 ERROR:SQL: SELECT entry, SkillID, Value, MaxValue FROM spell_learn_skill
2008-06-30 12:27:02 ERROR:query ERROR: Table 'mangos.spell_learn_skill' doesn't exist
2008-06-30 12:27:02
2008-06-30 12:27:02 >> Loaded 0 spell learn skills
2008-06-30 12:27:02 ERROR:`spell_learn_skill` table is empty!
2008-06-30 12:27:02 Loading Spell Learn Spells...
2008-06-30 12:27:02
2008-06-30 12:27:02 >> Loaded 12 spell learn spells + 500 found in DBC
2008-06-30 12:27:02 Loading Spell Proc Event conditions...
2008-06-30 12:27:02 ERROR:SQL: SELECT entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate FROM spell_proc_event
2008-06-30 12:27:02 ERROR:query ERROR: Unknown column 'Category' in 'field list'
2008-06-30 12:27:02
2008-06-30 12:27:02 >> Loaded 0 spell proc event conditions
2008-06-30 12:27:02 Loading Aggro Spells Definitions...
2008-06-30 12:27:02 >> Loaded 89 aggro generating spells
2008-06-30 12:27:02
2008-06-30 12:27:02 Loading NPC Texts...
2008-06-30 12:27:03
2008-06-30 12:27:03 >> Loaded 4306 npc texts
2008-06-30 12:27:03 Loading Item Random Enchantments Table...
2008-06-30 12:27:04
2008-06-30 12:27:04 >> Loaded 28393 Item Enchantment definitions
2008-06-30 12:27:04 Loading Items...
2008-06-30 12:27:12 >> Loaded 23920 item prototypes
2008-06-30 12:27:12
2008-06-30 12:27:12 Loading Item Texts...
2008-06-30 12:27:12
2008-06-30 12:27:12 >> Loaded 0 item pages
2008-06-30 12:27:12 Loading Creature Model Based Info Data...
2008-06-30 12:27:13 >> Loaded 16848 creature model based info
2008-06-30 12:27:13
2008-06-30 12:27:13 Loading Equipment templates...
2008-06-30 12:27:13 >> Loaded 2168 equipment template
2008-06-30 12:27:13
2008-06-30 12:27:13 Loading Creature templates...
2008-06-30 12:27:16 ERROR:Error in creature_template table, probably sql file format was updated (there should be 63 fields in sql).

hoffe auf eine schnelle Antwort, danke.