[SOLVED] 255 Level the problem: Stats on items, and start HP (instant 255level)

[Troya]

Hello i em today compile my own source for 255 level. The problem are HP, Stats on items and with HP on instant 255 level

If anyone know fix it pls tell me. Im not sure is it the problem in Source or in Database...

Pic of problem:

http://picpaste.com/WoWScrnShot_051314_194517-ltNHWZQ5.jpg

 

[Foereaper]

Hello i em today compile my own source for 255 level. The problem are HP, Stats on items and with HP on instant 255 level

If anyone know fix it pls tell me. Im not sure is it the problem in Source or in Database...

Pic of problem:

http://picpaste.com/WoWScrnShot_0513...7-ltNHWZQ5.jpg

Link is dead.

 

[Troya]

Link is dead.

try agen http://picpaste.com/WoWScrnShot_051314_194517-ltNHWZQ5.jpg

 

[Tommy]

I think you need to update the stat value fields from smallint to int to support higher values in the item_template table. I mean, smallint does go to 32767 - -32767 and via stamina it is pretty close. I'm not sure what could be causing it besides the fact that some fields aren't made for level 255 and you need to go around updating them to a higher integer value.

 

[Troya]

I think you need to update the stat value fields from smallint to int to support higher values in the item_template table. I mean, smallint does go to 32767 - -32767 and via stamina it is pretty close. I'm not sure what could be causing it besides the fact that some fields aren't made for level 255 and you need to go around updating them to a higher integer value.

so can you tell me how to fix it, update or whatever..?

 

[Tommy]

so can you tell me how to fix it, update or whatever..?

I did, partially. item_template wise, just find the stat_value1-X columns and update smallint(6) to int(10). As I said on other inquires about level 255, I'm not entirely sure what else (integer wise) needs to be updated, as I haven't done a 255 server on TC.

 

[Troya]

I did, partially. item_template wise, just find the stat_value1-X columns and update smallint(6) to int(10). As I said on other inquires about level 255, I'm not entirely sure what else (integer wise) needs to be updated, as I haven't done a 255 server on TC.

I think i didnt understend you. can you show me on some pic or what?

 

[Tommy]

I think i didnt understend you. can you show me on some pic or what?

I understood. However, Foereaper just reminded me that the client doesn't support high-integer stats like that. Visually, you can make the stats show up correctly, but it won't change anything regardless.

BUT, for a future reference on you not knowing how to edit table column type(s):

(I'm using Navicat)

1. Right click the table and click 'Design Table'
2. Find the column you want to edit.
3. Change the type from type to type:

Example:

smallint(6):

to

int(10)

4. Save

 

[Tok124]

I think i didnt understend you. can you show me on some pic or what?

First of all, Before you do any changes to DB you need to edit the source.

Go to src/server/game/Globals/ObjectMGR.cpp

Find row 2274 and you should see the following code

        for (uint8 i = 0; i < itemTemplate.StatsCount; ++i)
        {
            itemTemplate.ItemStat[i].ItemStatType  = uint32(fields[28 + i*2].GetUInt8());
            itemTemplate.ItemStat[i].ItemStatValue = int32(fields[29 + i*2].GetInt16());
        }

Change that to

        for (uint8 i = 0; i < itemTemplate.StatsCount; ++i)
        {
            itemTemplate.ItemStat[i].ItemStatType  = uint32(fields[28 + i*2].GetUInt8());
            itemTemplate.ItemStat[i].ItemStatValue = int32(fields[29 + i*2].GetInt32());
        }

Aften you have done this changes you will need a recompile. When the server is recompiled start your MySQL Console. When MySQL Console is open then open HeidiSQL(i will only explain this for HeidiSQL).

find table "item_template" and then go to the tab "Table: item_template".

When you are on that tab scroll down until you see stat_value* (* means 1, 2, 3, 4 etc...).

When you find it you will see SmallINT next to it. Change the SmallINT to INT and save.

 

[Troya]

I understood. However, Foereaper just reminded me that the client doesn't support high-integer stats like that. Visually, you can make the stats show up correctly, but it won't change anything regardless.

BUT, for a future reference on you not knowing how to edit table column type(s):

(I'm using Navicat)

1. Right click the table and click 'Design Table'
2. Find the column you want to edit.
3. Change the type from type to type:

Example:

smallint(6):

to

int(10)

4. Save

Thanks.. i will test evrthing

- - - Updated - - -

First of all, Before you do any changes to DB you need to edit the source.

Go to src/server/game/Globals/ObjectMGR.cpp

Find row 2274 and you should see the following code

        for (uint8 i = 0; i < itemTemplate.StatsCount; ++i)
        {
            itemTemplate.ItemStat[i].ItemStatType  = uint32(fields[28 + i*2].GetUInt8());
            itemTemplate.ItemStat[i].ItemStatValue = int32(fields[29 + i*2].GetInt16());
        }

Change that to

        for (uint8 i = 0; i < itemTemplate.StatsCount; ++i)
        {
            itemTemplate.ItemStat[i].ItemStatType  = uint32(fields[28 + i*2].GetUInt8());
            itemTemplate.ItemStat[i].ItemStatValue = int32(fields[29 + i*2].GetInt32());
        }

Aften you have done this changes you will need a recompile. When the server is recompiled start your MySQL Console. When MySQL Console is open then open HeidiSQL(i will only explain this for HeidiSQL).

find table "item_template" and then go to the tab "Table: item_template".

When you are on that tab scroll down until you see stat_value* (* means 1, 2, 3, 4 etc...).

When you find it you will see SmallINT next to it. Change the SmallINT to INT and save.

Thanks it is work!! ok what is this? when on custom item in item_template in table scriptname is "internalitemhanler"?

 

[Tommy]

First of all, Before you do any changes to DB you need to edit the source.

Go to src/server/game/Globals/ObjectMGR.cpp

Find row 2274 and you should see the following code

        for (uint8 i = 0; i < itemTemplate.StatsCount; ++i)
        {
            itemTemplate.ItemStat[i].ItemStatType  = uint32(fields[28 + i*2].GetUInt8());
            itemTemplate.ItemStat[i].ItemStatValue = int32(fields[29 + i*2].GetInt16());
        }

Change that to

        for (uint8 i = 0; i < itemTemplate.StatsCount; ++i)
        {
            itemTemplate.ItemStat[i].ItemStatType  = uint32(fields[28 + i*2].GetUInt8());
            itemTemplate.ItemStat[i].ItemStatValue = int32(fields[29 + i*2].GetInt32());
        }

Aften you have done this changes you will need a recompile. When the server is recompiled start your MySQL Console. When MySQL Console is open then open HeidiSQL(i will only explain this for HeidiSQL).

find table "item_template" and then go to the tab "Table: item_template".

When you are on that tab scroll down until you see stat_value* (* means 1, 2, 3, 4 etc...).

When you find it you will see SmallINT next to it. Change the SmallINT to INT and save.

I was trying to find that to tell him to edit the load stuff, but I couldn't find it.

 

[Troya]

I was trying to find that to tell him to edit the load stuff, but I couldn't find it.

It is ok

 

[slp13at420]

http://emudevs.com/showthread.php/2619-TC-255-server-stats-edit we have a tut
also you may want to look at this --> http://emudevs.com/showthread.php/2866-Creature-Class-Stats-for-level-100-255

 

[Troya]

http://emudevs.com/showthread.php/2619-TC-255-server-stats-edit we have a tut
also you may want to look at this --> http://emudevs.com/showthread.php/2866-Creature-Class-Stats-for-level-100-255

Tnx so much