WoW TrinityCore playercreateinfo FAIL!

Zhulkis · 08/06/2014, 17:34

Hallo,
Ich habe einen Server für linux compiliert und ihn über meinen Server laufen lassen. Jetzt habe ich in der Tabelle "playercreateinfo" die Koordinaten für alle klassen & rassen auf dalaran geändert. das scheint aber nicht zu funktionieren und jetzt startet der server zwar, aber lädt die charackter nicht mehr, heißt ich komme nur bis "Verbindung hergestellt".

Hat jmd. die unveränderte playercreateinfo für 3.3.5 und könnte diese Tabelle hier hochladen? Gibt auch 'n thanks

(oder eine einfache sql oder sonstwas, hab leider vor der Änderung dort kein Backup gemacht...)

Kaev <3 · 08/07/2014, 07:53

Hab mmn. keine Möglichkeit auf meine Datenbank zuzugreifen.
Wenn du die TDB noch drauf hast, könntest du dir den Teil aus dem SQL-Dump kopieren und einfügen.

°"Crazy"° · 08/10/2014, 13:02

Code:

/*
SQLyog Ultimate v8.54 
MySQL - 5.5.37-0+wheezy1 
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `playercreateinfo` (
	`race` tinyint (3),
	`class` tinyint (3),
	`map` int ,
	`zone` int ,
	`position_x` float ,
	`position_y` float ,
	`position_z` float ,
	`orientation` float 
); 
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('1','1','0','12','-8949.95','-132.493','83.5312','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('1','2','0','12','-8949.95','-132.493','83.5312','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('1','4','0','12','-8949.95','-132.493','83.5312','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('1','5','0','12','-8949.95','-132.493','83.5312','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('1','8','0','12','-8949.95','-132.493','83.5312','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('1','9','0','12','-8949.95','-132.493','83.5312','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('2','1','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('2','3','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('2','4','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('2','7','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('2','9','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('3','1','0','1','-6240.32','331.033','382.758','6.17716');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('3','2','0','1','-6240.32','331.033','382.758','6.17716');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('3','3','0','1','-6240.32','331.033','382.758','6.17716');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('3','4','0','1','-6240.32','331.033','382.758','6.17716');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('3','5','0','1','-6240.32','331.033','382.758','6.17716');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('4','1','1','141','10311.3','832.463','1326.41','5.69632');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('4','3','1','141','10311.3','832.463','1326.41','5.69632');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('4','4','1','141','10311.3','832.463','1326.41','5.69632');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('4','5','1','141','10311.3','832.463','1326.41','5.69632');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('4','11','1','141','10311.3','832.463','1326.41','5.69632');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('5','1','0','85','1676.71','1678.31','121.67','2.70526');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('5','4','0','85','1676.71','1678.31','121.67','2.70526');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('5','5','0','85','1676.71','1678.31','121.67','2.70526');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('5','8','0','85','1676.71','1678.31','121.67','2.70526');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('5','9','0','85','1676.71','1678.31','121.67','2.70526');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('6','1','1','215','-2917.58','-257.98','52.9968','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('6','3','1','215','-2917.58','-257.98','52.9968','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('6','7','1','215','-2917.58','-257.98','52.9968','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('6','11','1','215','-2917.58','-257.98','52.9968','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('7','1','0','1','-6240.32','331.033','382.758','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('7','9','0','1','-6240','331','383','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('7','8','0','1','-6240','331','383','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('7','4','0','1','-6240','331','383','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('8','1','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('8','3','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('8','4','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('8','5','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('8','7','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('8','8','1','14','-618.518','-4251.67','38.718','0');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('10','2','530','3431','10349.6','-6357.29','33.4026','5.31605');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('10','3','530','3431','10349.6','-6357.29','33.4026','5.31605');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('10','4','530','3431','10349.6','-6357.29','33.4026','5.31605');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('10','5','530','3431','10349.6','-6357.29','33.4026','5.31605');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('10','8','530','3431','10349.6','-6357.29','33.4026','5.31605');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('10','9','530','3431','10349.6','-6357.29','33.4026','5.31605');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('11','1','530','3526','-3961.64','-13931.2','100.615','2.08364');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('11','2','530','3526','-3961.64','-13931.2','100.615','2.08364');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('11','3','530','3526','-3961.64','-13931.2','100.615','2.08364');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('11','5','530','3526','-3961.64','-13931.2','100.615','2.08364');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('11','7','530','3526','-3961.64','-13931.2','100.615','2.08364');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('11','8','530','3526','-3961.64','-13931.2','100.615','2.08364');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('1','6','609','4298','2355.84','-5664.77','426.028','3.65997');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('2','6','609','4298','2358.44','-5666.9','426.023','3.65997');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('3','6','609','4298','2358.44','-5666.9','426.023','3.65997');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('4','6','609','4298','2356.21','-5662.21','426.026','3.65997');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('5','6','609','4298','2356.21','-5662.21','426.026','3.65997');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('6','6','609','4298','2358.17','-5663.21','426.027','3.65997');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('7','6','609','4298','2355.05','-5661.7','426.026','3.65997');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('8','6','609','4298','2355.05','-5661.7','426.026','3.65997');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('10','6','609','4298','2355.84','-5664.77','426.028','3.65997');
insert into `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`) values('11','6','609','4298','2358.17','-5663.21','426.027','3.65997');

Dump aus einer LiveDB.