Here is a newly updated Shaman spell set. I ran queries for at least 40-70 to make sure that there was only ever 15 spells trying to load, including the best heal.
As an example, here's the 70 loadout. type 8 is buff, 2 is heal, 1 is slow or debuff, 256 is a dot, and 32 is the pet. I had to sacrifice DD (I have a mage for that) but am otherwise pretty happy with the loadout.
Code:
ID: Name: Type:
172 Swift Like the Wind 8
278 Spirit of Wolf 8
1588 Turgur's Insects 1
3378 Agility of the Wrulan 8
3380 Cloud of Grummus 1
3386 Malicious Decay 1
3394 Breath of Ultor 256
3395 Malos 1
3396 Blood of Saryrn 256
5389 Farrel's Companion 32
5395 Yoppa's Mending 2
5406 Talisman of Perseverance 8
5415 Talisman of Wunshi 8
5417 Champion 8
6667 Spirit of the Panther 8
SQL code for type 518:
Code:
--
-- Dumping data for table `npc_spells_entries`
--
-- WHERE: npc_spells_id=518
LOCK TABLES `npc_spells_entries` WRITE;
/*!40000 ALTER TABLE `npc_spells_entries` DISABLE KEYS */;
INSERT INTO `npc_spells_entries` (`id`, `npc_spells_id`, `spellid`, `type`, `minlevel`, `maxlevel`, `manacost`, `recast_delay`, `priority`) VALUES (2662,518,12,2,19,28,-1,-1,1),(2663,518,15,2,29,48,-1,-1,1),(2661,518,17,2,9,18,-1,-1,1),(2647,518,39,8,29,43,-1,-1,90),(2621,518,40,8,1,18,-1,-1,1),(2549,518,75,256,5,18,-1,-1,1),(2530,518,93,1,1,9,-1,-1,1),(2562,518,110,1,19,33,-1,-1,1),(2563,518,111,1,34,48,-1,-1,1),(2666,518,144,2,24,38,-1,-1,1),(2667,518,145,8,39,51,-1,-1,1),(2635,518,146,8,24,28,-1,-1,1),(2622,518,147,8,19,28,-1,-1,1),(2629,518,148,8,19,33,-1,-1,1),(2642,518,149,8,24,33,-1,-1,1),(2623,518,151,8,29,38,-1,-1,1),(2637,518,152,8,39,48,-1,-1,1),(2624,518,153,8,39,48,-1,-1,1),(2644,518,158,8,44,53,-1,-1,1),(2630,518,160,8,34,43,-1,-1,1),(2643,518,161,8,34,43,-1,-1,1),(2576,518,162,1,29,43,-1,-1,1),(2577,518,163,1,44,52,-1,-1,2),(2669,518,164,32,34,38,-1,-1,1),(2671,518,165,32,41,44,-1,-1,1),(2672,518,166,32,49,54,-1,-1,1),(2614,518,167,8,34,9,-1,-1,1),(2615,518,168,8,44,9,-1,-1,1),(2648,518,170,8,44,55,-1,-1,1),(2649,518,171,8,56,62,-1,-1,1),(2650,518,172,8,63,255,-1,-1,1),(2660,518,200,2,1,8,-1,-1,1),(2588,518,201,1,1,38,-1,200,1),(2612,518,225,8,1,23,-1,-1,1),(2610,518,226,8,9,33,-1,-1,1),(2604,518,227,8,14,38,-1,-1,1),(2606,518,228,8,19,43,-1,-1,1),(2590,518,230,4,14,33,-1,-1,1),(2634,518,266,8,1,23,-1,-1,1),(2596,518,267,8,1,4,-1,-1,1),(2628,518,269,8,5,18,-1,-1,1),(2569,518,270,1,5,13,-1,-1,1),(2651,518,271,8,5,13,-1,-1,1),(2597,518,274,8,5,13,-1,-1,1),(2531,518,275,1,5,13,-1,-1,1),(2555,518,277,256,9,23,-1,-1,1),(2659,518,278,8,9,255,-1,-1,1),(2641,518,279,8,9,23,-1,-1,1),(2652,518,280,8,14,18,-1,-1,1),(2575,518,281,1,14,28,-1,-1,1),(2532,518,282,1,14,23,-1,-1,1),(2598,518,283,8,14,23,-1,-1,1),(2653,518,308,8,19,33,-1,-1,1),(2654,518,326,8,34,48,-1,-1,1),(2655,518,337,8,49,58,-1,-1,1),(2636,518,349,8,29,38,-1,-1,1),(2551,518,365,256,19,33,-1,-1,1),(2600,518,431,8,34,43,-1,-1,1),(2556,518,434,256,24,38,-1,-1,1),(2557,518,435,256,39,48,-1,-1,1),(2558,518,436,256,49,55,-1,-1,1),(2538,518,437,1,24,33,-1,-1,1),(2540,518,438,1,39,43,-1,-1,1),(2570,518,505,1,14,28,-1,-1,1),(2571,518,506,1,29,38,-1,-1,1),(2572,518,507,1,39,50,-1,-1,1),(2533,518,508,1,24,33,-1,-1,1),(2534,518,509,1,34,43,-1,-1,1),(2550,518,511,256,19,33,-1,-1,1),(2608,518,524,8,5,28,-1,-1,1),(2579,518,526,1,19,38,-1,-1,1),(2599,518,649,8,24,33,-1,-1,1),(3290,518,1290,2,55,61,-1,-1,1),(2539,518,1427,1,34,43,-1,-1,1),(2541,518,1429,1,44,48,-1,-1,1),(2618,518,1432,8,60,61,-1,-1,1),(2668,518,1568,8,52,60,-1,-1,1),(2673,518,1574,32,55,60,-1,-1,1),(2565,518,1577,1,57,59,-1,-1,2),(2566,518,1578,1,60,62,-1,-1,2),(2632,518,1579,8,53,61,-1,-1,1),(2573,518,1588,1,51,255,-1,-1,1),(2559,518,1590,1,56,59,-1,-1,2),(2553,518,1591,1,59,63,-1,-1,2),(2657,518,1598,8,60,64,-1,-1,1),(2656,518,1599,8,59,59,-1,-1,1),(2560,518,2113,256,60,64,-1,-1,1),(2617,518,2525,8,46,48,-1,-1,1),(2665,518,3233,2,62,67,-1,-1,1),(2619,518,3235,8,62,64,-1,-1,1),(2674,518,3377,32,61,66,-1,-1,1),(2633,518,3378,8,62,255,-1,-1,1),(2587,518,3380,1,61,255,-1,-1,2),(2582,518,3386,1,63,255,-1,-1,2),(2567,518,3387,1,63,64,-1,-1,2),(2554,518,3394,256,64,255,-1,-1,1),(2568,518,3395,1,65,255,-1,-1,2),(2561,518,3396,256,65,255,-1,-1,1),(2620,518,3397,8,65,69,-1,-1,1),(2658,518,3399,8,65,69,-1,-1,1),(3293,518,3433,8,61,68,-1,-1,1),(3292,518,3454,8,49,59,-1,-1,1),(2542,518,3573,1,49,53,-1,-1,2),(3299,518,5389,32,67,255,-1,-1,1),(3300,518,5395,2,68,255,-1,-1,1),(3294,518,5406,8,69,255,-1,-1,0),(3301,518,5415,8,70,255,-1,-1,1),(3298,518,5417,8,70,255,-1,-1,0),(3297,518,6667,8,69,255,-1,-1,0),(3289,518,6877,2,49,54,-1,-1,1),(3295,518,6906,8,50,56,-1,-1,0),(3296,518,6907,8,57,68,-1,-1,0);
|