diff options
| author | Lance <Lance@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-05-31 08:44:43 +0000 |
|---|---|---|
| committer | Lance <Lance@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2006-05-31 08:44:43 +0000 |
| commit | f2fd4a251da74bb8311c321e800f8fce9f5e5fef (patch) | |
| tree | 89c1589e3348e636cad26312c024380dc30c8180 | |
| parent | 28b5e759f5e55f9b9ba508403dce2d02b98c154b (diff) | |
| download | hercules-f2fd4a251da74bb8311c321e800f8fce9f5e5fef.tar.gz hercules-f2fd4a251da74bb8311c321e800f8fce9f5e5fef.tar.bz2 hercules-f2fd4a251da74bb8311c321e800f8fce9f5e5fef.tar.xz hercules-f2fd4a251da74bb8311c321e800f8fce9f5e5fef.zip | |
[Improved]:
- SQL upgrade file for the new loginlog. Thanks to ultramage.
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@6883 54d463be-8e91-2dee-dedb-b68131a5f0ec
| -rw-r--r-- | Changelog-Trunk.txt | 2 | ||||
| -rw-r--r-- | sql-files/upgrade_svn6868.sql | 3 |
2 files changed, 4 insertions, 1 deletions
diff --git a/Changelog-Trunk.txt b/Changelog-Trunk.txt index 625e74cf1..ae8f59fcc 100644 --- a/Changelog-Trunk.txt +++ b/Changelog-Trunk.txt @@ -4,6 +4,8 @@ AS OF SVN REV. 5091, WE ARE NOW USING TRUNK. ALL UNTESTED BUGFIXES/FEATURES GO IF YOU HAVE A WORKING AND TESTED BUGFIX PUT IT INTO STABLE AS WELL AS TRUNK.
2006/05/31
+ * [Improved]:
+ - SQL upgrade file for the new loginlog. Thanks to ultramage. [Lance]
* [Fixed]:
- nullpo in pet.c caused by equipping without checking if the pet is available.
[Lance]
diff --git a/sql-files/upgrade_svn6868.sql b/sql-files/upgrade_svn6868.sql index dc9d69906..000237297 100644 --- a/sql-files/upgrade_svn6868.sql +++ b/sql-files/upgrade_svn6868.sql @@ -1 +1,2 @@ -ALTER TABLE `loginlog` CHANGE `ip` `ip` INT( 10 ) UNSIGNED NOT NULL;
+UPDATE `loginlog` SET `ip` = inet_aton(`ip`);
+ALTER TABLE `loginlog` CHANGE `ip` `ip` INT( 10 ) UNSIGNED ZEROFILL NOT NULL DEFAULT '0';
\ No newline at end of file |