[SQL] Death Knight Gear & Charger Upon Creation menu

User Tag List

Results 1 to 12 of 12
  1. #1
    pubicbear's Avatar Member
    Reputation
    13
    Join Date
    Aug 2009
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [SQL] Death Knight Gear & Charger Upon Creation

    Death Knight Gear & Charger on Creation


    I don't know whether or not this has been released before, it wasn't difficult to do but was very time consuming.

    Query this code and Death Knights will start with the Quest Reward gear, and have all three weapons located in bags, relic included.

    Death Knights will also start already having their Death Charger.


    Code:
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '56';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '57';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '58';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '59';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '60';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '61';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '62';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '63';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '64';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '65';
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38675', '12', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38661', '0', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38674', '13', '1');
    
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38672', '10', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38671', '11', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38662', '1', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38632', '27', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38633', '28', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38707', '29', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38663', '2', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38665', '4', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38668', '5', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38669', '6', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38670', '7', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38666', '8', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38667', '9', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '39322', '14', '1');
    
    INSERT INTO playercreateinfo_items VALUES ('56', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '39208', '38', '1');
    
    INSERT INTO playercreateinfo_spells VALUES ('56', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('58', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('59', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('62', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('64', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('57', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('60', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('61', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('63', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('65', '48778');





    Credit to me! Not that much is due, but i hope it saves you a little time. [/center]

    [SQL] Death Knight Gear & Charger Upon Creation
  2. #2
    P1raten's Avatar Banned
    Reputation
    500
    Join Date
    Mar 2008
    Posts
    1,323
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nice and clean release. +rep x3

  3. #3
    Moaradin's Avatar Contributor
    Reputation
    163
    Join Date
    Feb 2008
    Posts
    439
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nice release. It is the quest gear, but the quest never seems to work anywhere due to massive use of phasing.

    +rep x3

    +rep people who help you

  4. #4
    Found's Avatar Banned
    Reputation
    239
    Join Date
    Mar 2009
    Posts
    642
    Thanks G/R
    1/4
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nice release.

    +rep

  5. #5
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Simple, but useful. +Rep

    Edit: Got to spread.

  6. #6
    pubicbear's Avatar Member
    Reputation
    13
    Join Date
    Aug 2009
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah it's all the quest gear, including the choice of weapons.

  7. #7
    djbaird5's Avatar Corporal
    Reputation
    1
    Join Date
    Nov 2009
    Posts
    17
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hey im a big noob at wow servers soo how i add this stuff too my server please reply soon
    code:
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '56';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '57';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '58';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '59';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '60';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '61';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '62';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '63';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '64';
    DELETE FROM `playercreateinfo_items` WHERE `indexid` = '65';

    INSERT INTO playercreateinfo_items VALUES ('56', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38675', '12', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38675', '12', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38661', '0', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38661', '0', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38674', '13', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38674', '13', '1');


    INSERT INTO playercreateinfo_items VALUES ('56', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38672', '10', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38672', '10', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38671', '11', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38671', '11', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38662', '1', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38662', '1', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38632', '27', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38632', '27', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38633', '28', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38633', '28', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38707', '29', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38707', '29', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38663', '2', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38663', '2', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38665', '4', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38665', '4', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38668', '5', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38668', '5', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38669', '6', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38669', '6', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38670', '7', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38670', '7', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38666', '8', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38666', '8', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '38667', '9', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '38667', '9', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '39322', '14', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '39322', '14', '1');

    INSERT INTO playercreateinfo_items VALUES ('56', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('58', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('59', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('62', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('64', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('57', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('60', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('61', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('63', '39208', '38', '1');
    INSERT INTO playercreateinfo_items VALUES ('65', '39208', '38', '1');

    INSERT INTO playercreateinfo_spells VALUES ('56', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('58', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('59', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('62', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('64', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('57', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('60', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('61', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('63', '48778');
    INSERT INTO playercreateinfo_spells VALUES ('65', '48778');
    Last edited by djbaird5; 12-13-2009 at 01:59 PM.

  8. #8
    pubicbear's Avatar Member
    Reputation
    13
    Join Date
    Aug 2009
    Posts
    22
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Download Navicat/HeidiSQL and then simply query the code into your databse.

  9. #9
    djbaird5's Avatar Corporal
    Reputation
    1
    Join Date
    Nov 2009
    Posts
    17
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is this arcemu or mangos cause i got mangos? atm tryin too look for good arcemu 3.3.0 source some one's i found pile of sh*t lol if u know any arcemu ones please put link xD id be greatful and if this arcemu id add this too my server cause i think its epic =D

  10. #10
    iMurloc's Avatar Member
    Reputation
    5
    Join Date
    Nov 2009
    Posts
    76
    Thanks G/R
    0/3
    Trade Feedback
    13 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Simple, yet useful +Rep and Merry Christmas

  11. #11
    ReAcTiOnZ's Avatar Member
    Reputation
    5
    Join Date
    Sep 2009
    Posts
    164
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Would it be possible for the benefit of the death knight to add the spell Teleport archeus? +rep for a nice query

  12. #12
    glh290's Avatar Member
    Reputation
    7
    Join Date
    Apr 2008
    Posts
    56
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is there any possible way to get this for mangos? i cant use arcemu anymore

Similar Threads

  1. Replies: 32
    Last Post: 06-02-2013, 09:43 AM
  2. [Sql] Death Knight Start NPC Updates
    By Pedregon in forum WoW EMU General Releases
    Replies: 3
    Last Post: 04-26-2010, 06:27 AM
  3. [Reskin] Green Death Knight Gear + Mount
    By jackknife35 in forum World of Warcraft Model Editing
    Replies: 6
    Last Post: 03-15-2009, 01:13 AM
  4. [Model Reskin] Charger -> Death Knight Charger
    By *ChAoS* in forum World of Warcraft Model Editing
    Replies: 42
    Last Post: 05-30-2008, 04:59 PM
All times are GMT -5. The time now is 02:40 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search