MMOCoin

Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Banned

    Join Date
    Jan 2010
    Location
    Baltimore,Maryland
    Posts
    260
    Post Thanks / Like
    Rep Power
    0
    Reputation
    87

    Arrow [Request]Pet Scaling Fix

    ya im kinda sick of having to do .mod scale everytiem i zone some where or when i relog,ive tried to make my own fixes a few times but it hasnt worked to good failed attempts but anyways..im trying to find a fix for all pets caz once they are tamed they go from 1.0 scale to 0.5 and there very tiny i wanna make all pets after tame stay 1.0 scale no matter what anyone got a idea of how to fix this or aready has it fixed and wants to share. to if someone can help

    Edit:Forgot I Need It For Mangos

    Last edited by Noblebeastx; 27-03-10 at 10:52 PM.



  2. Related Threads - Scroll Down after related threads if you are only interested to view replies for above post/thread

  3. #2
    Contributor
    Cocain's Avatar
    Join Date
    Mar 2010
    Posts
    208
    Post Thanks / Like
    Rep Power
    17
    Reputation
    92
    I believe you can edit your Beasts scale in your database. If you want to do a mass update, just do

    Code:
    UPDATE `...` SET `scalecollumn`='...'

  4. #3
    Banned

    Join Date
    Jan 2010
    Location
    Baltimore,Maryland
    Posts
    260
    Post Thanks / Like
    Rep Power
    0
    Reputation
    87
    How bout say for a whole 500 playes with a hunter pet mass update at ocne insetad of editing it all at ocne for mangos lol trying to help eclonedwow or whatever out caz i play on tehre blizzliek and its jsut like retial but they got a bug where when u tame a pet it goes to 0.5 scale instead of 1.0 liek supsoe to and then there so small it annoys every hunter and it does me to i was told if i could come up with a fix i could prob get a spot as a dev,but ive tried a few things on my test core is use mangos and they all filed any help will be good

  5. #4
    Contributor
    Cocain's Avatar
    Join Date
    Mar 2010
    Posts
    208
    Post Thanks / Like
    Rep Power
    17
    Reputation
    92
    I've had that problem when I was working for Infinity, a 255 realm. You can just update the collumns for the creatures with the 'pet' restricted collumn.

  6. #5
    Banned

    Join Date
    Jan 2010
    Location
    Baltimore,Maryland
    Posts
    260
    Post Thanks / Like
    Rep Power
    0
    Reputation
    87
    how do i posibly do it for over 500 toon's that have a pet and so that everytime someone tames a pet it turns to 1.0scale caz i gotta do this for a whole 500 or more people and i also dont got acess to echolenedwow datbase i was told if i could try to fix it i could be dev tehre li9ek i said plus there on the top like 10 list for servers so i really wanan help them also caz iam hunter like could u possibly make a Sql that i could send to Khell so he can excute into teh database,thats my issue i am not dev yet so i cant look into teh database

  7. #6
    Contributor
    Cocain's Avatar
    Join Date
    Mar 2010
    Posts
    208
    Post Thanks / Like
    Rep Power
    17
    Reputation
    92
    You need database for the SQL to execute. And I don't know the ManGOS DB structure, but I know that it is possible.

  8. #7
    Banned

    Join Date
    Jan 2010
    Location
    Baltimore,Maryland
    Posts
    260
    Post Thanks / Like
    Rep Power
    0
    Reputation
    87
    i know that but can u make up a sql Fix for it caz i can send it to Khell and hell put it in

  9. #8
    Contributor
    Cocain's Avatar
    Join Date
    Mar 2010
    Posts
    208
    Post Thanks / Like
    Rep Power
    17
    Reputation
    92
    I believe that the ManGOS Database structure works with the same way as an ArcEmu structure does. Let me download a repack, and if I find it, I'll make you a quick SQL patch.

  10. #9
    Contributor
    Cocain's Avatar
    Join Date
    Mar 2010
    Posts
    208
    Post Thanks / Like
    Rep Power
    17
    Reputation
    92
    Perhaps this :

    Try :

    UPDATE `creature_template` SET `scale`='1.0' where `family` = 2

    Somthing like that should update the scale of ALL cat pets to 1.0, or you can make it less. (Cat - Hunter Pet - World of Warcraft)

    Do the same, but than search the ID for the other pet sorts. I'm not sure if this will work though, I suck with ManGOS, but hey. I gave it a shot. ^^

  11. #10
    Contributor
    Cocain's Avatar
    Join Date
    Mar 2010
    Posts
    208
    Post Thanks / Like
    Rep Power
    17
    Reputation
    92
    Note : I just tested it & that query worked perfectly. All the 'Tamable beats of the "cat" family' had a scale of 0.5 after executing that.


    I'm not sure if this will fix your issue though.

 

 
Page 1 of 2 12 LastLast

Posting Permissions

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