Newbie Spellweaver
Hello Everyone, I am currently looking for help making custom portals, I have over 20 vendors and it's kinda filling up Orgrimmar and Stormwind.. so I found an nice spot but I want to make an portal to it, I found this on another forum so I wanted to test if this works, Its an DB Quiery that must be run on the mangos DB:
I used Theramore Isle just as an test example to see if it works so I can add more portals later, altho I am getting the following error:
Now my SQL Skills aint as good as they sould be so I have no idea what the problem is here, would be nice if some one could fill me in....
I am using the lastest version of WoW (Burning Crusade)
Thank You,
- Danerf.
Code:
INSERT INTO gameobject_template VALUES
(450008, 27, 5231, "Portal to Theramore Isle", 0, 64, 1, 35008, 0, 1, 0, 0, 0, 0, 0, 0, 0,'', 0);
INSERT INTO areatrigger_template VALUES
(35008, "Portal to Theramore Isle", 1, -3987.150146, -4710.850098, 4.376084, 1, -3987.150146, -4710.850098, 4.376084, 0.807214);
I used Theramore Isle just as an test example to see if it works so I can add more portals later, altho I am getting the following error:
Code:
ERROR 1136 : Column count doesn't match value count at row 1
ERROR 1136 : Column count doesn't match value count at row 1
Now my SQL Skills aint as good as they sould be so I have no idea what the problem is here, would be nice if some one could fill me in....
I am using the lastest version of WoW (Burning Crusade)
Thank You,
- Danerf.