+ Reply to Thread
Results 1 to 6 of 6

Thread: [SQL] Mohawk Grenade

  1. #1
    MMOpro Owner Jerry has a reputation beyond repute Jerry has a reputation beyond repute Jerry has a reputation beyond repute Jerry has a reputation beyond repute Jerry has a reputation beyond repute Jerry has a reputation beyond repute Jerry has a reputation beyond repute Jerry has a reputation beyond repute Jerry has a reputation beyond repute Jerry has a reputation beyond repute Jerry has a reputation beyond repute Jerry's Avatar
    Join Date
    Mar 2009
    Location
    Serbia
    Posts
    1,286
    Thanks
    14
    Thanked 27 Times in 24 Posts
    Rep Power
    10

    [SQL] Mohawk Grenade

    Credits: LeetLOL

    Mohawk Grenade
    No Display ID! Not In DB!
    Update It Yourself! It's Not In DB!

    Core Pack
    (ArcEmu, Aspire, Ascent, MaNGOS)
    [Only registered and activated users can see links. ]

  2. #2
    MMOPro Active User Vicious88 is on a distinguished road Vicious88's Avatar
    Join Date
    Nov 2009
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    1

    AWESOME! Thank you so much for this, and thanks to LeetLOL!

  3. #3
    Leecher aptiva is on a distinguished road
    Join Date
    Nov 2009
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    1

    hmm.. has anyone else tested this on asp.hs and acremu?

    seems this mohawk is bad - custom and wrong spell id

    it will cast on the wrong player faction... seems abit buggy,
    i might make repost for arcemu, after i finish my db,
    ive got it on csv from cache file...

    if anyone else has this properly working ...
    post the fix(s) for the rest of the community please.

  4. #4
    MMOPro Active User Vicious88 is on a distinguished road Vicious88's Avatar
    Join Date
    Nov 2009
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    1

    Quote Originally Posted by aptiva View Post
    hmm.. has anyone else tested this on asp.hs and acremu?

    seems this mohawk is bad - custom and wrong spell id

    it will cast on the wrong player faction... seems abit buggy,
    i might make repost for arcemu, after i finish my db,
    ive got it on csv from cache file...

    if anyone else has this properly working ...
    post the fix(s) for the rest of the community please.
    I tested this on MaNGOS and Trinity, and I think it depends on the compile you're using...

    With MaNGOS, the items for Mohawk Mask and Grenade were not even in the Database, and then after I added them in, they didn't really work right (missing icons, invalid spell data, so on so forth). With Trinity, the items were already in the database, but had been blocked from showing up in the ".lookup item" searches and if you attempted to add them manually, you were propted that the items were broken and cannot be added (sort of like if you try to learn a broken spell or place a game object with invalid data associated with it). The quickest way around this was to learn the "Mohawked!" spell, and cast it as if throwing the grenade. **Note: Because the Mohawk Mask and Grenade were already in trinity, I did not try this SQL dump with the trinity DB.

    So, and here again this is pure speculation, you'd probably have to have compile your core specifically to account for whatever sort of bad data is associated with the Mohawk Grenade and Mask in the DB.

  5. #5
    Leecher Triple is on a distinguished road
    Join Date
    Dec 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Hey, I really need this for my mangos server... Could anyone give me the right item and a link how to find the display ids and stuff??

    Thank you.

    Best Regards. Triple:)

  6. #6
    MMOPro Active User Vicious88 is on a distinguished road Vicious88's Avatar
    Join Date
    Nov 2009
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    1

    Quote Originally Posted by Triple View Post
    Hey, I really need this for my mangos server... Could anyone give me the right item and a link how to find the display ids and stuff??

    Thank you.

    Best Regards. Triple:)
    There is a download link in the original post (the green button), but if for some reason that's not showing up for you here's a text link: [Only registered and activated users can see links. ]

    Inside that download, you'll find various Mohawk Grenade SQL querys sorted by Emulator -- you'll be looking for the MaNGOS ones.

    If for some reason this does not work for you, you may want to just look up the spell yourself ".lookup spell mohawked" and then learn that spell via ".learn ####" or ".learn [Mohawked!]" Then you can cast it just as you would through the grenade.

    **Please note that the animations and effects of this spell will vary from core to core. With basic MaNGOS, I was unable to get the feathers and streamers aura that accompanied the grenades explosion, however with Trinity Core, it works fine.

+ Reply to Thread

Similar Threads

  1. Mohawk Pack !
    By Jerry in forum SQL Querys
    Replies: 0
    Last Post: 12-06-2009, 07:13 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts