Simple SQL teleporter

[manofwar95]

Greetings;

I have been working on a simple teleporter script that teleports to various locations, it's entirely DB, which means your core can already be compiled, and you will still be able to apply the teleporter. If you want to add or remove locations it's very easy to setup, everything is pretty self explanatory, enjoy.

P.S: Feel free to modify the code to suit your needs or wants.

-- CODE --

[url]http://pastebin.com/2hdbXt1U[/url]

[Patman128]

You probably could have done it as a gossip script instead of quests.

[manofwar95]

I suppose, but this is mostly to examine SQL. I'll make the next version gossip.

[Patman128]

Most of the queries could also be combined together. For example:

DELETE FROM `creature_questrelation` WHERE `quest` IN (999105, 900001, 999102, 999103, 999104, 999025, 999030, 999033, 999034, 999037, 999039, 999040);

instead of individual DELETEs. And you can REPLACE multiple rows at the same time.

[manofwar95]

Most of the queries could also be combined together. For example:

DELETE FROM `creature_questrelation` WHERE `quest` IN (999105, 900001, 999102, 999103, 999104, 999025, 999030, 999033, 999034, 999037, 999039, 999040);

instead of individual DELETEs. And you can REPLACE multiple rows at the same time.

Hmm, I will try merging them, try to make it as clean and as simple as possible.