Facebook - Mists of Pandaria
Facebook - Draenor

AbonnentenAbonnenten: 0
LesezeichenLesezeichen: 0
Zugriffe: 270

[TrinityCore] Alliance And Horde Starting Place!

Beitragvon Baxxter » 24. Sep 2014 00:49

[TrinityCore] Alliance And Horde Starting Place!

Hey,

This is very very easy, I just wanna share it with you guys.
I know some people change this in the Database Manually, But here is the sql Files to change the starting place for both Alliance and Horde.

I have 2 Sql files, One for Alliance and One for Horde!

Alliance One:
Code: Alles auswählen
SET
@MAP := 'MAP',
@ZONE := 'ZONE',
@X := 'X-Cordinate',
@Y := 'Y-Cordinate',
@Z := 'Z-Cordinate',
@O := 'Orientation';

UPDATE playercreateinfo SET map=@MAP, zone=@ZONE, position_X=@X, position_Y=@Y, position_Z=@Z, orientation=@O WHERE race IN(1, 3, 4, 7, 11);


Horde One:

Code: Alles auswählen
SET
@MAP := 'MAP',
@ZONE := 'ZONE',
@X := 'X-Cordinate',
@Y := 'Y-Cordinate',
@Z := 'Z-Cordinate',
@O := 'Orientation';

UPDATE playercreateinfo SET map=@MAP, zone=@ZONE, position_X=@X, position_Y=@Y, position_Z=@Z, orientation=@O WHERE race IN(2, 5, 6, 8, 10);


This is for Trinity Core, It goes into the World DB.
But fisr you gotta edit those to where you want the Characters to spawn.

Go in-game and type .gps ( where you want them to spawn ).
And just Write the Map,Zone, X, Y, Z and Orientation down.
Open these Files and enter them where it says.

I hope this will get needed for some people!
Thanks for reading!

Btw, This is my first Release/Share or something. I will Release real stuff later on!

Really nice forum and great People!
credit by
Regards
Agetheria
Baxxter
Benutzeravatar
 
Beiträge: 6
Registriert: 02.2014
Geschlecht: männlich
Wohnort: Fuxbau




Forum Statistiken

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast

Optionen

Zurück zu "Sql skripte & C++"