API tools faq
paste
Advertisement
Rochet2

Gurubashi Theme Generator ELUNA

Rochet2
Mar 4th, 2013
544
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 24.52 KB | None | 0 0
raw download clone embed print report diff
  1. --[[
  2. ## Gurubashi Theme Generator ##
  3. Original credits to Hkarta.
  4.  
  5. Base for this script here by Sdyess: (link dead)
  6. http://www.ac-web.org/forums/showthread.php?t=150939
  7.  
  8. Modified to lua by Rochet2
  9.  
  10. SQL originally provided by Sdyess.
  11. SQL by Daveido1h
  12. ]]
  13.  
  14. --[[
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET NAMES utf8 */;
  18. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  19. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  20.  
  21. -- Dumping structure for table gurubashi_spawns
  22. CREATE TABLE IF NOT EXISTS `gurubashi_spawns` (
  23.   `theme` int(11) unsigned NOT NULL,
  24.   `entry` int(11) unsigned NOT NULL,
  25.   `x` float NOT NULL,
  26.   `y` float NOT NULL,
  27.   `z` float NOT NULL,
  28.   `o` float NOT NULL
  29. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  30.  
  31. -- Dumping data for table gurubashi_spawns: 167 rows
  32. /*!40000 ALTER TABLE `gurubashi_spawns` DISABLE KEYS */;
  33. INSERT INTO `gurubashi_spawns` (`theme`, `entry`, `x`, `y`, `z`, `o`) VALUES
  34.     (1, 6000118, -13205.8, 274.844, 27.6802, 4.30156),
  35.     (1, 6000117, -13168, 275.081, 21.8574, 2.72372),
  36.     (1, 6000110, -13205.5, 274.828, 30.32, 4.27407),
  37.     (1, 6000119, -13187.7, 239.463, 21.8582, 3.77539),
  38.     (1, 6000119, -13180.5, 291.8, 21.8582, 3.22953),
  39.     (1, 6000119, -13178.4, 283.759, 21.8579, 4.64874),
  40.     (1, 6000119, -13227.1, 278.129, 21.8582, 5.76243),
  41.     (1, 6000119, -13173.3, 295.848, 21.8579, 4.20499),
  42.     (1, 6000119, -13202.6, 244.986, 21.8579, 2.8816),
  43.     (1, 6000119, -13186.4, 291.49, 21.8579, 5.90144),
  44.     (1, 6000119, -13192.9, 235.159, 21.8582, 3.5437),
  45.     (1, 6000119, -13173.4, 255.883, 21.8582, 4.31731),
  46.     (1, 6000119, -13205.5, 250.809, 21.8582, 2.8329),
  47.     (1, 6000119, -13218.7, 268.308, 21.8582, 5.81348),
  48.     (1, 6000119, -13170.4, 287.805, 21.8582, 2.30276),
  49.     (1, 6000119, -13228, 249.127, 21.8582, 5.77814),
  50.     (1, 6000119, -13215.8, 312.145, 21.8582, 0.928307),
  51.     (1, 6000119, -13180.1, 239.075, 21.8579, 5.35167),
  52.     (1, 6000119, -13221.7, 274.7, 21.8571, 4.26782),
  53.     (1, 6000119, -13167.4, 256.948, 21.8579, 6.12921),
  54.     (1, 6000119, -13170.8, 249.312, 21.8579, 5.68546),
  55.     (1, 6000119, -13184.4, 274.314, 21.8582, 5.65248),
  56.     (1, 6000119, -13210.4, 283.529, 21.8582, 5.86061),
  57.     (1, 6000119, -13198.1, 271.543, 21.8582, 2.64048),
  58.     (1, 6000119, -13193.6, 258.863, 21.8582, 2.69153),
  59.     (1, 6000119, -13199.2, 314.904, 21.8582, 1.06968),
  60.     (1, 6000119, -13203.6, 298.728, 21.8582, 6.15121),
  61.     (1, 6000119, -13231.4, 261.383, 21.8571, 4.62517),
  62.     (1, 6000119, -13175.7, 274.391, 21.8579, 5.77107),
  63.     (1, 6000119, -13177.2, 267.055, 21.8579, 0.591363),
  64.     (1, 6000119, -13180.3, 245.738, 21.8582, 3.9521),
  65.     (1, 6000119, -13210.4, 302.124, 21.8582, 4.39192),
  66.     (1, 6000119, -13233.7, 262.174, 21.8582, 4.16415),
  67.     (1, 6000119, -13173.5, 260.887, 21.8582, 5.30691),
  68.     (1, 6000119, -13186.7, 282.938, 21.8582, 4.39585),
  69.     (1, 6000119, -13242.4, 276.602, 21.8573, 0.159389),
  70.     (1, 6000119, -13238.3, 281.879, 21.8573, 0.921225),
  71.     (1, 6000119, -13225.4, 300.29, 21.8573, 3.53268),
  72.     (1, 6000119, -13214.3, 292.125, 21.8573, 4.3652),
  73.     (1, 6000119, -13220.4, 307.884, 21.8573, 1.96581),
  74.     (1, 6000119, -13176.7, 304.866, 21.8573, 1.06653),
  75.     (2, 6000113, -13203.6, 265.7, 21.8, 0),
  76.     (2, 6000113, -13204.2, 263, 21.8, 0),
  77.     (2, 6000113, -13201.4, 262.59, 21.8, 0),
  78.     (2, 6000111, -13211.4, 276.35, 21.8, 0),
  79.     (2, 6000111, -13185.8, 256.4, 21.8, 0),
  80.     (2, 6000111, -13202.1, 250.3, 21.8, 0),
  81.     (2, 6000114, -13174.5, 284.3, 21.8, 0),
  82.     (2, 6000114, -13190.1, 302.3, 21.8, 0),
  83.     (2, 6000114, -13215.4, 301.6, 21.8, 0),
  84.     (2, 6000112, -13194.1, 282.35, 19, 0),
  85.     (2, 6000119, -13187.7, 239.463, 21.8582, 3.77539),
  86.     (2, 6000119, -13180.5, 291.8, 21.8582, 3.22953),
  87.     (2, 6000119, -13178.4, 283.759, 21.8579, 4.64874),
  88.     (2, 6000119, -13227.1, 278.129, 21.8582, 5.76243),
  89.     (2, 6000119, -13173.3, 295.848, 21.8579, 4.20499),
  90.     (2, 6000119, -13202.6, 244.986, 21.8579, 2.8816),
  91.     (2, 6000119, -13186.4, 291.49, 21.8579, 5.90144),
  92.     (2, 6000119, -13192.9, 235.159, 21.8582, 3.5437),
  93.     (2, 6000119, -13173.4, 255.883, 21.8582, 4.31731),
  94.     (2, 6000119, -13205.5, 250.809, 21.8582, 2.8329),
  95.     (2, 6000119, -13218.7, 268.308, 21.8582, 5.81348),
  96.     (2, 6000119, -13170.4, 287.805, 21.8582, 2.30276),
  97.     (2, 6000119, -13228, 249.127, 21.8582, 5.77814),
  98.     (2, 6000119, -13215.8, 312.145, 21.8582, 0.928307),
  99.     (2, 6000119, -13180.1, 239.075, 21.8579, 5.35167),
  100.     (2, 6000119, -13221.7, 274.7, 21.8571, 4.26782),
  101.     (2, 6000119, -13167.4, 256.948, 21.8579, 6.12921),
  102.     (2, 6000119, -13170.8, 249.312, 21.8579, 5.68546),
  103.     (2, 6000119, -13184.4, 274.314, 21.8582, 5.65248),
  104.     (2, 6000119, -13210.4, 283.529, 21.8582, 5.86061),
  105.     (2, 6000119, -13198.1, 271.543, 21.8582, 2.64048),
  106.     (2, 6000119, -13193.6, 258.863, 21.8582, 2.69153),
  107.     (2, 6000119, -13199.2, 314.904, 21.8582, 1.06968),
  108.     (2, 6000119, -13203.6, 298.728, 21.8582, 6.15121),
  109.     (2, 6000119, -13231.4, 261.383, 21.8571, 4.62517),
  110.     (2, 6000119, -13175.7, 274.391, 21.8579, 5.77107),
  111.     (2, 6000119, -13177.2, 267.055, 21.8579, 0.591363),
  112.     (2, 6000119, -13180.3, 245.738, 21.8582, 3.9521),
  113.     (2, 6000119, -13210.4, 302.124, 21.8582, 4.39192),
  114.     (2, 6000119, -13233.7, 262.174, 21.8582, 4.16415),
  115.     (2, 6000119, -13173.5, 260.887, 21.8582, 5.30691),
  116.     (2, 6000119, -13186.7, 282.938, 21.8582, 4.39585),
  117.     (2, 6000119, -13242.4, 276.602, 21.8573, 0.159389),
  118.     (2, 6000119, -13238.3, 281.879, 21.8573, 0.921225),
  119.     (2, 6000119, -13225.4, 300.29, 21.8573, 3.53268),
  120.     (2, 6000119, -13214.3, 292.125, 21.8573, 4.3652),
  121.     (2, 6000119, -13220.4, 307.884, 21.8573, 1.96581),
  122.     (2, 6000119, -13176.7, 304.866, 21.8573, 1.06653),
  123.     (3, 6000110, -293.268, -2664.01, 120.55, 4.76707),
  124.     (3, 6000110, -297.909, -2667.51, 127.08, 1.03251),
  125.     (3, 6000111, -262.17, -2645.9, 125.866, 5.60904),
  126.     (3, 6000111, -1486.42, 526.784, 142.354, 1.77347),
  127.     (3, 6000112, -241.205, -2648.73, 122.741, 5.38912),
  128.     (3, 6000113, -254.937, -2664.5, 122.403, 0.877),
  129.     (3, 6000114, -251.201, -2667.65, 121.778, 1.17624),
  130.     (3, 6000115, -276.437, -2660.31, 122.567, 4.27856),
  131.     (3, 6000115, -271.854, -2658.65, 122.628, 0.418328),
  132.     (3, 6000116, -267.148, -2655.72, 122.602, 2.31507),
  133.     (3, 6000117, -267.712, -2658.16, 125.609, 4.53539),
  134.     (3, 6000117, -272.264, -2649.73, 122.459, 5.64908),
  135.     (3, 6000117, -270.348, -2652.22, 122.613, 2.31114),
  136.     (3, 6000117, -272.47, -2652.4, 122.674, 3.24184),
  137.     (3, 6000120, -238.774, -2570.31, 163.17, 2.01427),
  138.     (3, 6000120, -233.616, -2587.23, 185.726, 4.83934),
  139.     (3, 6000120, -13204, 273, 17.4388, 1.50755),
  140.     (3, 6000121, -251.025, -2603.47, 192.756, 0.812609),
  141.     (3, 6000122, -241.481, -2584.59, 185.905, 1.29955),
  142.     (3, 6000122, -13201.5, 280.86, 25.2712, 3.87555),
  143.     (3, 6000122, -13207.5, 256.319, 24.8636, 4.47638),
  144.     (3, 6000122, -13227, 273.394, 24.7136, 2.3558),
  145.     (3, 6000122, -13214.8, 289.288, 24.8299, 4.74341),
  146.     (3, 6000123, -186.58, -2605.13, 207.157, 2.64021),
  147.     (3, 6000123, -218.607, -2578.01, 196.721, 4.11755),
  148.     (3, 6000124, -234.26, -2600.91, 208.531, 1.80219),
  149.     (3, 6000124, -228.942, -2594.19, 222.955, 0.675144),
  150.     (3, 6000124, -13204.2, 263.16, 25.1665, 1.66072),
  151.     (3, 6000124, -13204.3, 268.294, 25.3861, 3.07836),
  152.     (3, 6000124, -13214.4, 270.035, 25.1944, 4.25253),
  153.     (3, 6000124, -13208.7, 276.679, 25.4071, 1.07559),
  154.     (3, 6000124, -13217.1, 278.225, 25.0689, 2.85059),
  155.     (3, 6000124, -13224.5, 283.428, 24.7078, 2.54822),
  156.     (3, 6000124, -13222.2, 291.453, 24.5588, 0.824266),
  157.     (3, 6000124, -13231.4, 262.306, 24.4435, 3.55746),
  158.     (3, 6000124, -13233.5, 251.119, 23.8527, 3.70668),
  159.     (3, 6000124, -13241, 271.689, 24.0802, 2.93306),
  160.     (3, 6000124, -13233.2, 291.237, 24.2631, 2.17908),
  161.     (3, 6000124, -13212.3, 303.589, 24.2717, 0.333392),
  162.     (3, 6000124, -13212.3, 303.589, 24.2717, 1.25624),
  163.     (3, 6000124, -13212.2, 307.054, 24.0447, 1.76675),
  164.     (3, 6000124, -13198.8, 308.434, 23.9304, 1.46044),
  165.     (3, 6000124, -13185.6, 301.572, 24.2001, 4.5392),
  166.     (3, 6000124, -13167.1, 286.922, 23.5056, 2.88987),
  167.     (3, 6000124, -13173.5, 278.781, 24.3101, 3.92267),
  168.     (3, 6000124, -13176.7, 273.083, 25.0311, 4.80232),
  169.     (3, 6000124, -13196.1, 242.097, 24.2017, 4.89264),
  170.     (3, 6000124, -13208.6, 244.898, 24.3776, 4.05226),
  171.     (3, 6000125, -13186.4, 256.64, 24.5668, 2.27724),
  172.     (3, 6000125, -13182.2, 259.654, 24.5465, 0.180231),
  173.     (3, 6000125, -13184.4, 286.078, 24.6236, 3.67133),
  174.     (3, 6000125, -13189, 289.142, 24.6753, 0.781064),
  175.     (3, 6000125, -13181.8, 291.011, 24.3994, 6.271),
  176.     (3, 6000126, -186.979, -2617, 206.865, 4.86525),
  177.     (3, 6000126, -13210.4, 279.867, 23.5357, 5.72907),
  178.     (3, 6000126, -13199.6, 267.771, 23.6485, 2.37149),
  179.     (3, 6000126, -13216.6, 264.357, 23.4314, 1.00882),
  180.     (3, 6000127, -163.572, -2611.32, 205.179, 1.55714),
  181.     (3, 6000127, -13239.3, 261.181, 23.0034, 3.36503),
  182.     (3, 6000127, -13236.6, 263.074, 23.2352, 0.612207),
  183.     (3, 6000127, -13233.5, 264.871, 23.3779, 0.462981),
  184.     (3, 6000127, -13230.2, 266.156, 23.5204, 0.305901),
  185.     (3, 6000127, -13227.2, 266.984, 23.6516, 0.246996),
  186.     (3, 6000127, -13223.8, 267.906, 23.7959, 0.282339),
  187.     (3, 6000127, -13220.3, 268.995, 23.9446, 0.341244),
  188.     (3, 6000127, -13216.9, 270.403, 24.0969, 0.415857),
  189.     (3, 6000127, -13213.8, 271.861, 24.233, 0.466908),
  190.     (3, 6000127, -13210.7, 273.792, 24.3767, 0.290194),
  191.     (3, 6000127, -13207.1, 273.777, 24.5207, 6.23959),
  192.     (3, 6000127, -13202.6, 273.419, 24.5323, 6.17675),
  193.     (3, 6000127, -13198.2, 273.688, 24.3519, 0.140973),
  194.     (3, 6000127, -13194.1, 273.484, 24.1867, 5.91365),
  195.     (3, 6000127, -13189.8, 272.922, 24.02, 0.160611),
  196.     (3, 6000127, -13185.5, 273.637, 23.8414, 0.168465),
  197.     (3, 6000127, -13181.5, 274.256, 23.6722, 6.1532),
  198.     (3, 6000127, -13176.8, 273.006, 23.4937, 5.96078),
  199.     (3, 6000127, -13172, 272.635, 23.3019, 0.0585103),
  200.     (3, 6000127, -13167.1, 272.97, 22.9589, 0.0820722);
  201. /*!40000 ALTER TABLE `gurubashi_spawns` ENABLE KEYS */;
  202.  
  203.  
  204. -- Dumping structure for table gurubashi_themes
  205. CREATE TABLE IF NOT EXISTS `gurubashi_themes` (
  206.   `theme` int(11) unsigned NOT NULL,
  207.   `name` text,
  208.   PRIMARY KEY (`theme`)
  209. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  210.  
  211. -- Dumping data for table gurubashi_themes: 4 rows
  212. /*!40000 ALTER TABLE `gurubashi_themes` DISABLE KEYS */;
  213. INSERT INTO `gurubashi_themes` (`theme`, `name`) VALUES
  214.     (0, 'No Theme'),
  215.     (1, 'Marsh Theme'),
  216.     (2, 'Elwynn Theme'),
  217.     (3, 'Winter Theme');
  218. /*!40000 ALTER TABLE `gurubashi_themes` ENABLE KEYS */;
  219. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  220. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  221. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  222.  
  223.  
  224. -- ----------------------------
  225. -- Items By Hkarta
  226. -- ----------------------------
  227.  
  228. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000113, 5, 28, 'ARENA_bush', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  229. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000110, 5, 7331, 'ARENA_water', '', '', '', 0, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  230. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000111, 5, 967, 'ARENA_tree', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  231. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000114, 5, 7341, 'ARENA_hugetree', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  232. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000112, 14, 7465, 'ARENA_humanhouse', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  233. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000118, 14, 7051, 'ARENA_bridge', '', '', '', 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  234. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000115, 5, 6151, 'ARENA_fence', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  235. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000116, 5, 4315, 'ARENA_rock', '', '', '', 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  236. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000127, 5, 362, 'ARENA_walkstone', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  237. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000117, 5, 223, 'ARENA_boat', '', '', '', 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  238. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000119, 5, 2315, 'ARENA_grass', '', '', '', 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  239. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000120, 5, 8557, 'ARENA_snow_A', '', '', '', 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  240. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000121, 14, 8557, 'ARENA_snow_B', '', '', '', 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  241. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000122, 5, 927, 'ARENA_snow_tree_1', '', '', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  242. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000123, 5, 7801, 'ARENA_snow_tree_2', '', '', '', 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  243. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000124, 5, 8219, 'ARENA_snow_myst', '', '', '', 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  244. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000125, 5, 7492, 'ARENA_frozenrock', '', '', '', 0, 0, 0.23, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  245. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `ScriptName`) VALUES (6000126, 5, 7666, 'ARENA_frostmonolite', '', '', '', 0, 0, 1.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');
  246.  
  247. ]]
  248.  
  249. local NPCID = 123123 -- NPC ENTRY HERE
  250. local ThemeChangeDelay = 10*60 -- time until a theme can be changed again in seconds
  251.  
  252. -- dont touch
  253. local OFFSET_THEME = 1000
  254. local Themes = {}
  255. local LastThemeTime = 0
  256. local CurrentTheme = -1
  257. do
  258.     -- Load themes on startup
  259.    
  260.     local ids = {}
  261.     local Q = WorldDBQuery("SELECT `theme`, `name` FROM `gurubashi_themes` ORDER BY `theme` ASC")
  262.     if (Q) then
  263.         repeat
  264.             local theme = Q:GetUInt32(0)
  265.             Themes[theme] = {name = Q:GetString(1), spawns = {}}
  266.             table.insert(ids, theme)
  267.         until not Q:NextRow()
  268.     else
  269.         error("No themes found for Gurubashi arena creator!")
  270.     end
  271.    
  272.     Q = WorldDBQuery("SELECT `x`, `y`, `z`, `o`, `entry`, `theme` FROM `gurubashi_spawns` WHERE `theme` IN ("..table.concat(ids, ", ")..")")
  273.     if (Q) then
  274.         repeat
  275.             table.insert(Themes[Q:GetUInt32(5)].spawns, {Q:GetUInt32(4), Q:GetFloat(0), Q:GetFloat(1), Q:GetFloat(2), Q:GetFloat(3), 0})
  276.         until not Q:NextRow()
  277.     else
  278.         error("No spawns found for Gurubashi arena creator!")
  279.     end
  280. end
  281.  
  282. local function OnGossipHello(event, player, creature)
  283.     local curtime = os.time()
  284.     if (LastThemeTime <= curtime) then
  285.         for k,v in pairs(Themes) do
  286.             player:GossipMenuAddItem(4, v.name, 1, OFFSET_THEME + k, 0)
  287.         end
  288.         player:GossipSendMenu(100, creature)
  289.     else
  290.         local remaining = LastThemeTime - curtime
  291.         if (remaining <= 60) then
  292.             player:SendNotification("Next change possible in "..remaining.." seconds.")
  293.         else
  294.             player:SendNotification("Next change possible in "..math.ceil(remaining / 60).." minutes.")
  295.         end
  296.     end
  297. end
  298.  
  299. local function DespawnObjectIfNeed(theme, eventid, delay, repeats, go)
  300.     if (not theme or CurrentTheme < 0 or CurrentTheme ~= theme) then
  301.         go:RemoveEvents()
  302.         go:Despawn()
  303.     end
  304. end
  305.  
  306. local function OnGossipSelect(event, player, creature, sender, action, code)
  307.     if (action >= OFFSET_THEME) then
  308.         local theme = action - OFFSET_THEME
  309.        
  310.         if (not Themes[theme]) then
  311.             player:SendBroadcastMessage("Invalid theme ("..theme..") selected")
  312.             OnGossipHello(event, player, creature)
  313.             return
  314.         end
  315.        
  316.         if (CurrentTheme == theme) then
  317.             player:SendAreaTriggerMessage("The theme is already active")
  318.             OnGossipHello(event, player, creature)
  319.             return
  320.         end
  321.        
  322.         player:SendAreaTriggerMessage("Changing theme..")
  323.        
  324.         CurrentTheme = theme
  325.         LastThemeTime = os.time() + ThemeChangeDelay
  326.        
  327.         for k,v in ipairs(Themes[theme].spawns) do
  328.             local go = creature:SummonGameObject(table.unpack(v))
  329.             if(go) then
  330.                 go:RegisterEvent(function(...) DespawnObjectIfNeed(theme, ...) end, 5000, 0)
  331.             end
  332.         end
  333.     end
  334.     player:GossipComplete()
  335. end
  336.  
  337. RegisterCreatureGossipEvent(NPCID, 1, OnGossipHello)
  338. RegisterCreatureGossipEvent(NPCID, 2, OnGossipSelect)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!