Warrior Stances SQL Query menu

User Tag List

Results 1 to 5 of 5
  1. #1
    toxic11b's Avatar Corporal
    Reputation
    21
    Join Date
    Nov 2007
    Posts
    27
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Warrior Stances SQL Query

    Here is a small query that I made for my server that will start all warriors off with there stances . This script is really meant for instant 70 funservers but it could be used for a blizzlike. Enjoy


    Code:
    INSERT INTO `playercreateinfo_spells` VALUES('1','71');
    
    INSERT INTO `playercreateinfo_spells` VALUES('1','2458'); INSERT INTO `playercreateinfo_spells` VALUES('1','20611'); INSERT INTO `playercreateinfo_spells` VALUES('2','71'); INSERT INTO `playercreateinfo_spells` VALUES('2','2458'); INSERT INTO `playercreateinfo_spells` VALUES('2','20611'); INSERT INTO `playercreateinfo_spells` VALUES('3','71');
    INSERT INTO `playercreateinfo_spells` VALUES('3','2458'); INSERT INTO `playercreateinfo_spells` VALUES('3','20611'); INSERT INTO `playercreateinfo_spells` VALUES('4','71'); INSERT INTO `playercreateinfo_spells` VALUES('4','2458'); INSERT INTO `playercreateinfo_spells` VALUES('4','20611'); INSERT INTO `playercreateinfo_spells` VALUES('5','71'); INSERT INTO `playercreateinfo_spells` VALUES('5','2458'); INSERT INTO `playercreateinfo_spells` VALUES('5','20611'); INSERT INTO `playercreateinfo_spells` VALUES('6','71'); INSERT INTO `playercreateinfo_spells` VALUES('6','2458'); INSERT INTO `playercreateinfo_spells` VALUES('6','20611'); INSERT INTO `playercreateinfo_spells` VALUES('7','71'); INSERT INTO `playercreateinfo_spells` VALUES('7','2458'); INSERT INTO `playercreateinfo_spells` VALUES('7','20611'); INSERT INTO `playercreateinfo_spells` VALUES('8','71'); INSERT INTO `playercreateinfo_spells` VALUES('8','2458'); INSERT INTO `playercreateinfo_spells` VALUES('8','20611'); INSERT INTO `playercreateinfo_spells` VALUES('44','71'); INSERT INTO `playercreateinfo_spells` VALUES('44','2458'); INSERT INTO `playercreateinfo_spells` VALUES('44','20611');


    Here is another for Druids stances . =D

    Code:
    INSERT INTO `playercreateinfo_spells` VALUES('42','40120'); 
    INSERT INTO `playercreateinfo_spells` VALUES('42','33943');
    INSERT INTO `playercreateinfo_spells` VALUES('42','24858');
    INSERT INTO `playercreateinfo_spells` VALUES('42','9634');
    INSERT INTO `playercreateinfo_spells` VALUES('42','783');
    INSERT INTO `playercreateinfo_spells` VALUES('42','768');
    INSERT INTO `playercreateinfo_spells` VALUES('42','5487');
    INSERT INTO `playercreateinfo_spells` VALUES('42','1066');
    INSERT INTO `playercreateinfo_spells` VALUES('42','33891');
    INSERT INTO `playercreateinfo_spells` VALUES('43','40120'); 
    INSERT INTO `playercreateinfo_spells` VALUES('43','33943');
    INSERT INTO `playercreateinfo_spells` VALUES('43','24858');
    INSERT INTO `playercreateinfo_spells` VALUES('43','9634');
    INSERT INTO `playercreateinfo_spells` VALUES('43','783');
    INSERT INTO `playercreateinfo_spells` VALUES('43','768');
    INSERT INTO `playercreateinfo_spells` VALUES('43','5487');
    INSERT INTO `playercreateinfo_spells` VALUES('43','1066');
    INSERT INTO `playercreateinfo_spells` VALUES('43','33891');
    Last edited by toxic11b; 12-18-2007 at 03:14 PM.

    These ads disappear when you log in.

  2. #2
    Dryice's Avatar Contributor
    Reputation
    86
    Join Date
    Sep 2007
    Posts
    485
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Good Job, +rep

  3. #3
    Illidan1's Avatar Banned
    Reputation
    244
    Join Date
    Jul 2007
    Posts
    2,251
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Great going toxic11b

  4. #4
    toxic11b's Avatar Corporal
    Reputation
    21
    Join Date
    Nov 2007
    Posts
    27
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yah sorry they posted wrong in the code box. I will update it here in a few with all of the common missing talents .

    These are the common missing talents people can not train on my server so I am going to start them off with these to decrease the amount of tickets for the GM's . I figured it would help someone else also. But I will upload a SQL that will install all of it here within a hour or so .


    Warrior

    MS Rank 6
    Intercept
    Stances

    Druid
    Stances

    Warlock
    Pets
    Mounts

    Paladin
    Redemption
    Hammer of Justice
    Mounts

  5. #5
    Pwntzyou's Avatar Contributor
    Reputation
    264
    Join Date
    Dec 2007
    Posts
    393
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sweet post man... very nice
    Last edited by Pwntzyou; 12-18-2007 at 08:32 PM.

    <3 MysterioussouL for the sig

All times are GMT -5. The time now is 01:12 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2020 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search