Playercreateinfo table - Change spawn location?

[scarfaze]

Hi MMOwned

I tried to change the spawn location of the human race on my trinity private server, but now It isn't possible to login or create as a human because in the server console, eg. worldserver.exe it says that its an incorrect race/class combination..

Does anyone know how to fix this?

Thanks in advance for any help, Anton

[Zymus]

Restore the database from a backup before you tried to edit it.

[Namor]

Export your table into an SQL file and give it to us, I'll fix it for you.

[scarfaze]

It was a repack so I am trying to compile my own build now I hope it'll work then

[scarfaze]

Actually, after compiling my own core I still have this problem. And when dumping the sql file it dumps it without any records :S
SQL | /* Navicat MySQL Data Transfe - Php error - q9kpX0sk - Pastebin.com

[Namor]

DELETE FROM playercreateinfo
WHERE race > = 0

INSERT INTO playercreateinfo
VALUES (1, 1, MAP, ZONE, X, Y, Z, O)
VALUES (1, 2, MAP, ZONE, X, Y, Z, O)
VALUES (1, 8, MAP, ZONE, X, Y, Z, O)
VALUES (1, 16, MAP, ZONE, X, Y, Z, O)
VALUES (1, 32, MAP, ZONE, X, Y, Z, O)
VALUES (1, 128, MAP, ZONE, X, Y, Z, O)
VALUES (1, 256, MAP, ZONE, X, Y, Z, O)

Do this, but edit the MAP, ZONE, X, Y, Z, and O. O being origin.
Then try to make a human, and tell me if it works and I'll make you one for ever race/class combination.

[scarfaze]

1, 2, 8, 16, 32, 128, 256... Are 16 32 128 and 256 classes at all? xp

[Namor]

yes. It goes up by * 2

1 | 1 }} Human
2 | 2 }} Orc
4 | 3 }} Dwarf
8 | 4 }} Night Elf
16 | 5 }} Undead
32 | 6 }} Tauren
64 | 7 }} Gnome
128 | 8 }} Troll
512 | 10 }} Blood Elf
1024 | 11 }} Draenei

1 | 1 }} Warrior
2 | 2 }} Paladin
4 | 3 }} Hunter
8 | 4 }} Rogue
16 | 5 }} Priest
32 | 6 }} Death Knight
64 | 7 }} Shaman
128 | 8 }} Mage
256 | 9 }} Warlock
1024 | 11 }} Druid

[Namor]

O. No probably not, then. XD
Just change those to the appropriate class.

[thesixth]

Well, I actually saw this thread and decided to customize my character start locations on my server and I did it by tapping new cordinates into the playerinfocreate table via navicat.
Works just like a charm!

[scarfaze]

Well it didn't work for me, but now I have created some queries and it works