asianadam Posted March 25, 2013 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 8 Reputation: 0 Joined: 01/26/13 Last Seen: June 2, 2015 Share Posted March 25, 2013 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. Quote Link to comment Share on other sites More sharing options...
Emistry Posted March 26, 2013 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: Sunday at 05:32 PM Share Posted March 26, 2013 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 ~ Quote Link to comment Share on other sites More sharing options...
Emistry Posted March 26, 2013 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: Sunday at 05:32 PM Share Posted March 26, 2013 trunk/conf/battle/player.conf // Maximum HP. (Default is 1000000) max_hp: 1000000 Quote Link to comment Share on other sites More sharing options...
asianadam Posted March 26, 2013 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 8 Reputation: 0 Joined: 01/26/13 Last Seen: June 2, 2015 Author Share Posted March 26, 2013 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 Quote Link to comment Share on other sites More sharing options...
asianadam Posted March 26, 2013 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 8 Reputation: 0 Joined: 01/26/13 Last Seen: June 2, 2015 Author Share Posted March 26, 2013 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. Quote Link to comment Share on other sites More sharing options...
Emistry Posted March 26, 2013 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: Sunday at 05:32 PM Share Posted March 26, 2013 run it in ur SQL Machine Quote Link to comment Share on other sites More sharing options...
asianadam Posted March 26, 2013 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 8 Reputation: 0 Joined: 01/26/13 Last Seen: June 2, 2015 Author Share Posted March 26, 2013 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..... Quote Link to comment Share on other sites More sharing options...
Question
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.
Link to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.