diff options
| -rw-r--r-- | Changelog-Trunk.txt | 2 | ||||
| -rw-r--r-- | sql-files/main.sql | 6 | ||||
| -rw-r--r-- | sql-files/upgrade_svn5607.sql | 1 |
3 files changed, 6 insertions, 3 deletions
diff --git a/Changelog-Trunk.txt b/Changelog-Trunk.txt index 1803b22ab..9dcb793ed 100644 --- a/Changelog-Trunk.txt +++ b/Changelog-Trunk.txt @@ -5,6 +5,8 @@ IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK. EV GOES INTO TRUNK AND WILL BE MERGED INTO STABLE BY VALARIS AND WIZPUTER. -- VALARIS
2006/03/14
+ * Fixed the average_lv column size specification for levels above 255.
+ Thanks to Joshuaali (upgrade_svn5607.sql) [Skotlex]
* Updated @rura/@warp. Now you can use both "@warp mapname x y" and
"@warp mapname,x,y". [LuzZza]
* Added at-command @tonpc <NPC_name> (warp to NPC). [LuzZza]
diff --git a/sql-files/main.sql b/sql-files/main.sql index 49f056e6c..f60f36594 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -34,8 +34,8 @@ CREATE TABLE `char` ( `char_num` tinyint(1) NOT NULL default '0',
`name` varchar(30) NOT NULL default '',
`class` smallint(6) unsigned NOT NULL default '0',
- `base_level` smallint(20) unsigned NOT NULL default '1',
- `job_level` smallint(20) unsigned NOT NULL default '1',
+ `base_level` smallint(6) unsigned NOT NULL default '1',
+ `job_level` smallint(6) unsigned NOT NULL default '1',
`base_exp` bigint(20) unsigned NOT NULL default '0',
`job_exp` bigint(20) unsigned NOT NULL default '0',
`zeny` int(11) unsigned NOT NULL default '0',
@@ -143,7 +143,7 @@ CREATE TABLE `guild` ( `guild_lv` tinyint(6) unsigned NOT NULL default '0',
`connect_member` tinyint(6) unsigned NOT NULL default '0',
`max_member` tinyint(6) unsigned NOT NULL default '0',
- `average_lv` tinyint(6) unsigned NOT NULL default '0',
+ `average_lv` smallint(6) unsigned NOT NULL default '1',
`exp` int(11) unsigned NOT NULL default '0',
`next_exp` int(11) unsigned NOT NULL default '0',
`skill_point` tinyint(11) unsigned NOT NULL default '0',
diff --git a/sql-files/upgrade_svn5607.sql b/sql-files/upgrade_svn5607.sql new file mode 100644 index 000000000..7c3f88527 --- /dev/null +++ b/sql-files/upgrade_svn5607.sql @@ -0,0 +1 @@ +ALTER TABLE `guild` MODIFY `average_lv` smallint(6) unsigned NOT NULL default '1';
|