I'm using several queries, with different SET info and slightly different WHERE criterias. The problem is that for some reason, they do not work correctly.
Code:
-- ROGUE
UPDATE playercreateinfo
SET mapID=0, zoneid=0, introid=0, positionx=1, positiony=1, positionz=1
WHERE race=1 OR race=3 OR race=4 OR race=7 OR race=11 AND classid=4;
-- PRIEST
UPDATE playercreateinfo
SET mapID=0, zoneid=0, introid=0, positionx=2, positiony=2, positionz=2
WHERE race=1 OR race=3 OR race=4 OR race=7 OR race=11 AND classid=5;
The idea is that the alliance priests and rogues will get different spawn locations. However, running those two in sqlyog will set BOTH priest and rogues to spawn at 2, 2, 2 - or with other words, the location which only the priest should spawn at.
Why is this so, and how can I fix it?
EDIT:
SOLVED
For those who might be interested in a solution, this is how it's done:
WHERE race in(1,3,4,7,11) AND classid=5;
Note that you might have to have the numbers inside ' '
('1','3', and so on