[Mangos TBC] Custom Portals

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:

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.

lol never thought i would help but fine.

ill tell u how i got them to work and yes they work. u can come to my server and see.

1st i added them all manully. the script in ur post was out of date.

u add them in the way it says yea. i thyink i said that right if i didnt ill try to explain it better when i get my cable at home back up. then i can throughly explain it better.

but dont use the command. thing with u add them.

i remember this excat error lol and i fixed it. just dont remember how. i have like 15 of them now. ill give the ones that work for naxx cuz the doors in naxx r broken so ill send them to you.

i also used G.O 700000+ that might be a minor prob

another big pointer. i copied the stormwind portal and use the 450008, 27, 5231, "Portal to Theramore Isle", 0, 64, 1, 35008, 0, 1, 0, 0, 0, 0, 0, 0, 0,'', thing just dont inject it thro a sql update wont work. i think that line doesnt need the "" part

Please come on msn to have an little talk. :P

i wont be online til mid week this is how to get them 100% working the line u had has one extra column

it should be like this

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);
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);


try that see if that works and let me know ill check back tomorrow morning when im at college. what i want to find is the portal model id (spell is scarsheild) use .learn all in mangos to get it. that one model i cant find lol. well give it a shot if that dont work ill send u one portal i made that fully works.