From f2fd4a251da74bb8311c321e800f8fce9f5e5fef Mon Sep 17 00:00:00 2001 From: Lance Date: Wed, 31 May 2006 08:44:43 +0000 Subject: [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 --- Changelog-Trunk.txt | 2 ++ sql-files/upgrade_svn6868.sql | 3 ++- 2 files changed, 4 insertions(+), 1 deletion(-) 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 -- cgit v1.2.3-70-g09d2