Jump to content

Simple SQL teleporter


Guest manofwar95

Recommended Posts

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. :D

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

-- CODE --

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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. :o

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use