[SOLVED] how it could lead to all the characters hordes and alliances to a zone with a query?

[Clastor]

how it could lead to all the characters hordes and alliances to a zone with a query?

can someone help me?

for example, take all the hordes to dalaran and all the alliances to Stormwind

 

[blackmetal]

They need when created character or simple transfer all of them to Dalaran?

1. If You need transfer all of them on creation: Take a look at table "playercreateinfo" in World DB
2. If you need transfer all of them now: Take a look at table: "characters" in Character DB

Spend more time and you will remember longer :megusta:

 

[Clastor]

They need when created character or simple transfer all of them to Dalaran?

1. If You need transfer all of them on creation: Take a look at table "playercreateinfo" in World DB
2. If you need transfer all of them now: Take a look at table: "characters" in Character DB

Spend more time and you will remember longer :megusta:

I have 6000 characters in a shop, I want to transfer them to another, how do I?

 

[Tommy]

Here, I made a query for you. All you need to do is set the values of the variables.

SET @mapId := 1;
SET @x := 0;
SET @y := 0;
SET @z := 0;
SET @o := 0;

#Alliance
UPDATE `characters` SET map=@mapId, position_x=@x, position_y=@y, position_z=@z, orientation=@o WHERE race IN ('1', '3', '4', '7', '11');

#Horde
SET @mapId := 1;
SET @x := 0;
SET @y := 0;
SET @z := 0;
SET @o := 0;

UPDATE `characters` SET map=@mapId, position_x=@x, position_y=@y, position_z=@z, orientation=@o WHERE race IN ('2', '5', '6', '8', '10');

 

[Clastor]

Here, I made a query for you. All you need to do is set the values of the variables.

SET @mapId := 1;
SET @x := 0;
SET @y := 0;
SET @z := 0;
SET @o := 0;

#Alliance
UPDATE `characters` SET map=@mapId, position_x=@x, position_y=@y, position_z=@z, orientation=@o WHERE race IN ('1', '3', '4', '7', '11');

#Horde
SET @mapId := 1;
SET @x := 0;
SET @y := 0;
SET @z := 0;
SET @o := 0;

UPDATE `characters` SET map=@mapId, position_x=@x, position_y=@y, position_z=@z, orientation=@o WHERE race IN ('2', '5', '6', '8', '10');

Genius, thank you, greetings.

 

[Tommy]

No problem. Make sure you backup before running the query.