'HP' DB error

[asianadam]

I tried the guide and still not working. Anyone would like to help me? The thing I want is both hp to be max to 20mil. So like, Max Hp 20mil and when heal hp goes 20mil.

[Emistry]

trunk/conf/battle/player.conf

// Maximum HP. (Default is 1000000)
max_hp: 1000000

[asianadam]

What I meant was how to increase the capacity in hp? for example 12345678/20000000. The 12345678 is error but the max hp is fine. 

Lemme show you the picture 

[Emistry]

i think it's the SQL datatype for HP and MAXHP column are not enough to cover 20,000,000 HP...since it can only hold up to around 8,000,000 mil++ HP only..because it's mediumint(8)

 

 

try run this SQL query.

ALTER TABLE `char` CHANGE COLUMN `max_hp` `max_hp` INT UNSIGNED NOT NULL DEFAULT '0'  , CHANGE COLUMN `hp` `hp` INT UNSIGNED NOT NULL DEFAULT '0'  ;

 

Please do a back up before you run this..just in case anything unusual happen ~

[asianadam]

I am not exactly sure where to put that

i think it's the SQL datatype for HP and MAXHP column are not enough to cover 20,000,000 HP...since it can only hold up to around 8,000,000 mil++ HP only..because it's mediumint(8)

try run this SQL query.

ALTER TABLE `char` CHANGE COLUMN `max_hp` `max_hp` INT UNSIGNED NOT NULL DEFAULT '0'  , CHANGE COLUMN `hp` `hp` INT UNSIGNED NOT NULL DEFAULT '0'  ;

Please do a back up before you run this..just in case anything unusual happen ~

I am not sure where to put that. I am sorry for being noob.

[Emistry]

run it in ur SQL Machine

[asianadam]

so I run that "ALTER TABLE `char` CHANGE COLUMN `max_hp` `max_hp` INT UNSIGNED NOT NULL DEFAULT '0' , CHANGE COLUMN `hp` `hp` INT UNSIGNED NOT NULL DEFAULT '0' ;" in the machine.....