Hello modcraft people, i am following this tutorial
viewtopic.php?f=26&t=165to add somes races to my trinitycore server.
And i have a problem with the SQL part. When i run the first querry:
[spoiler:1f2e4j8u]SET @NEW_RACE = 9; -- ID of adding race.
SET @NEW_CLASS = 1; -- ID of class of the new race.
SET @COPY_RACE = 1; -- ID of the race where we copy datas.
DELETE FROM `playercreateinfo_spell` WHERE race = @NEW_RACE AND class = @NEW_CLASS ;
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`)
SELECT @NEW_RACE, @NEW_CLASS, `Spell`, `Note` FROM `playercreateinfo_spell` WHERE race = @COPY_RACE AND class = @NEW_CLASS;[/spoiler:1f2e4j8u]
I get this ....
[spoiler:1f2e4j8u][SQL] SET @NEW_RACE = 9;
Affected rows: 0
Time: 0.001ms
[SQL] -- ID of adding race.
SET @NEW_CLASS = 1;
Affected rows: 0
Time: 0.000ms
[SQL] -- ID of class of the new race.
SET @COPY_RACE = 1;
Affected rows: 0
Time: 0.000ms
[SQL] -- ID of the race where we copy datas.
DELETE FROM `playercreateinfo_spell` WHERE race = @NEW_RACE AND class = @NEW_CLASS ;
[Err] 1054 - Unknown column 'race' in 'where clause'[/spoiler:1f2e4j8u]
I am running a Mysql 5.5.9 server, TrinityCore compiled by me
. And it's 3.3.5a.
Sorry if my english is bad.
Thanks for you're help.
Show Posts