[Account ID Error]

I do not know where to post this. I thought mysql is part of database so I guess i will post this here. There is some error that my account ID went out number I have no clue how to fix this to get along with other number. 

 

 

So how to fix that huge number back on task with other number?

Oh i forgot When you registering the number keep going higher that number so how to fix the registration?

[Debug Error, please help]

bump

[Debug Error, please help]

wd.damage = battle_calc_base_damage(sstatus, &sstatus->rhw, sc, tstatus->size, sd, i); //Monsters have no weight and use ATK instead

[Debug Error, please help]

I don't know what to do.

 

 

Help me please.

['HP' DB error]

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.....

['HP' DB error]

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.

['HP' DB error]

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 

['HP' DB error]

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.