Welcome to AC Web.
Page 1 of 3 123 LastLast
Results 1 to 15 of 34
  1. #1
    Web/SQL Dev & 3D Artist

    Join Date
    Oct 2010
    Location
    somewhere between <?php and ?>
    Posts
    3,191

    Guide to remove 32767 stats cap for TrinityCore


    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    ok so i want to teach you how to increase the stats cap to 2147m for trinity.
    what you need is a compiled core. this wont work with repacks.

    Ok! so go into folder: C:\Trinity\src\server\game\Globals and open ObjectMgr.cpp
    search for "Itemtemplate.itemstat"
    you will see this
    Code:
    itemTemplate.ItemStat[i].ItemStatType  = uint32(fields[28 + i*2].GetUInt8());
    itemTemplate.ItemStat[i].ItemStatValue = int32(fields[29 + i*2].GetInt16());
    Change that to this:

    Code:
    itemTemplate.ItemStat[i].ItemStatType  = uint32(fields[28 + i*2].GetUInt8());
    itemTemplate.ItemStat[i].ItemStatValue = int32(fields[29 + i*2].GetInt32());
    Now recompile the server then open your database and do this

    For navicat:
    Open World find item_template table. right click on it and click "Design Table"
    change Type for this
    Code:
    Stat_value1,
    Stat_value2,
    Stat_value3,
    Stat_value4,
    Stat_value5,
    Stat_value6,
    Stat_value7,
    Stat_value8,
    Stat_value9,
    Stat_value10
    to INT then save it and then you can set stats with higher value than 32767.
    Don't forget so save it!

    For HeidiSQL:
    open item_template and click on the tab [table: item_template]. Find the stat_valueX columns and change their Datatype to INT (X = any number)


    PS. If you dont know how to compile then i suggest that you take a look at the wiki page
    https://trinitycore.atlassian.net/wi...e+Installation
    Last edited by Tok124; 10-26-2016 at 02:10 AM.

  2. #2
    Retired SQL Developer

    Join Date
    Aug 2011
    Location
    Bulgaria
    Posts
    1,271
    Pff,give credits like seejay did here,because Rochet2 did find this.
    Thanks,
    Destiny - out

  3. #3
    Web/SQL Dev & 3D Artist

    Join Date
    Oct 2010
    Location
    somewhere between <?php and ?>
    Posts
    3,191
    i'm not sure if Rochet2 was the first one who found this but anyway he didnt make a guide of this but he replied to a post that you can find here http://www.ac-web.org/forums/showthr...tom-Item-Stats but i explain more detailed on how you change the column types and stuff. and its more easy to find my guide than finding he's reply

  4. #4
    Now i can add stats like 50 k in database but when i type example 50k as stamina it shows -21113 sta or something like that, ive seen other with this problem how do i fix ?

  5. #5
    Quote Originally Posted by Carsten28 View Post
    Now i can add stats like 50 k in database but when i type example 50k as stamina it shows -21113 sta or something like that, ive seen other with this problem how do i fix ?
    If you haven't made the changes to the TrinityCore source, this can still happen. Also, make sure that you delete the client cache or old values may still show up.

  6. #6
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,681
    BUMP because it's needed

  7. #7

    Thumbs up

    kinda helpful for people that didnt know how to fix the issue

  8. #8
    Banned

    Join Date
    Dec 2015
    Location
    Developing the world
    Posts
    1,262
    why this is dead theme/thread. SAY A FKING THANKS! Not everyone knows this!!!! :@@@ bet 10000 ppl saw this, and only 1 thanks?

  9. #9
    http://YugoWoW.com/

    Join Date
    Feb 2014
    Location
    http://yugowow.com
    Posts
    2,681
    See my friend Tok124 does a nice job but noone is bumping the thread or even thanking him <3 +rep if i can bro <3

  10. #10
    Web/SQL Dev & 3D Artist

    Join Date
    Oct 2010
    Location
    somewhere between <?php and ?>
    Posts
    3,191
    Quote Originally Posted by JadaDev View Post
    See my friend Tok124 does a nice job but noone is bumping the thread or even thanking him <3 +rep if i can bro <3
    Thank you bro

  11. #11
    Banned

    Join Date
    Dec 2015
    Location
    Developing the world
    Posts
    1,262
    tok, remove 1000 from your posts, 2337 - 1000 = 1337, 1337= leet, you are leet, illuminati are leet, ILLUMINATI CONFIRMED!
    +I really needed this yesterday ;3333

  12. #12
    Web/SQL Dev & 3D Artist

    Join Date
    Oct 2010
    Location
    somewhere between <?php and ?>
    Posts
    3,191
    Quote Originally Posted by titkata_bg View Post
    tok, remove 1000 from your posts, 2337 - 1000 = 1337, 1337= leet, you are leet, illuminati are leet, ILLUMINATI CONFIRMED!
    +I really needed this yesterday ;3333
    haha yeah i actually remember when i had 1337 posts. That was really epic xD Thanks Tikata

  13. #13

  14. #14
    nice one is there also a way to remove the res cap for holy, fire, nature, frost, shadow, arcane ?

  15. #15
    Web/SQL Dev & 3D Artist

    Join Date
    Oct 2010
    Location
    somewhere between <?php and ?>
    Posts
    3,191

    REGISTER! (FREE)
    Registered members see less ads
    and also gain access to other great features.
    Quote Originally Posted by Infiniteabys View Post
    nice one is there also a way to remove the res cap for holy, fire, nature, frost, shadow, arcane ?
    Should work to just change column type to INT

 

 

Posting Permissions

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