So this is a unique form of SQL that someone taught me a while ago. Whoever they learned it from must have been a genius. That, or I'm just horrible at SQL!



Basically, what this portal does, is teleport a user to a secret zone within Ahn'Qiraj. But you're still outside the instance. It's a great place for a mall, and you can really change it as you see fit.

All you have to do is copy and paste it into a .txt document, change the file extension to .sql, and load it into your chosen software. I tend to use HeidiSQL.

Code:
SET

@GOB_Entry := 200000,
@GOB_Name := "Mall",
@GOB_Display := 6956,
@Event_scriptID := 200000,
@MAP := 1,
@X := -11840.558594,
@Y := -4757.416504,
@Z := 6.223837,
@O := 4.675663;

INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `size`, `data2`) 
VALUES (@GOB_Entry, 10, @GOB_Display, @GOB_Name, 1, @Event_scriptID);

INSERT INTO `event_scripts` (`id`, `command`, `datalong`, `x`, `y`, `z`, `o`) 
VALUES (@Event_scriptID, 6, @MAP, @X, @Y, @Z, @O);


› See More: [SQL][Release] Custom Portal