Index: branches/2.8.x/CHANGELOG
===================================================================
--- branches/2.8.x/CHANGELOG	(revision 1808)
+++ branches/2.8.x/CHANGELOG	(revision 1809)
@@ -13,6 +13,9 @@
 
 
 
+07 Nov-2012 Build 1809 Dietmar Woellbrink (Luisehahne)
+! remove login_ip after 60days set in /admin/start/index.php
+! add confirm_code and confirm_timeout fields in users table in /install/save.php
 07 Nov-2012 Build 1808 Dietmar Woellbrink (Luisehahne)
 ! add ErrorMsgException in /framework/globalExceptionHandler.php
 ! ErrorMessage "ADMIN_INSUFFICIENT_PRIVELLIGES" now can be styled 
Index: branches/2.8.x/wb/admin/start/index.php
===================================================================
--- branches/2.8.x/wb/admin/start/index.php	(revision 1808)
+++ branches/2.8.x/wb/admin/start/index.php	(revision 1809)
@@ -131,6 +131,12 @@
 $sql = 'DELETE FROM `'.TABLE_PREFIX.'users` WHERE `confirm_timeout` BETWEEN 1 AND '.time();
 WbDatabase::getInstance()->query($sql);
 
+/**
+ * delete Outdated Confirmations
+ */
+$sql = 'UPDATE `'.TABLE_PREFIX.'users` SET `login_ip` = \'\' WHERE `login_when` < '.(time()-(60*84600));
+WbDatabase::getInstance()->query($sql);
+
 // ---------------------------------------
 // Setup template object, parse vars to it, then parse it
 // Create new template object
Index: branches/2.8.x/wb/admin/interface/version.php
===================================================================
--- branches/2.8.x/wb/admin/interface/version.php	(revision 1808)
+++ branches/2.8.x/wb/admin/interface/version.php	(revision 1809)
@@ -51,5 +51,5 @@
 
 // check if defined to avoid errors during installation (redirect to admin panel fails if PHP error/warnings are enabled)
 if(!defined('VERSION')) define('VERSION', '2.8.3');
-if(!defined('REVISION')) define('REVISION', '1808');
+if(!defined('REVISION')) define('REVISION', '1809');
 if(!defined('SP')) define('SP', '');
Index: branches/2.8.x/wb/install/save.php
===================================================================
--- branches/2.8.x/wb/install/save.php	(revision 1808)
+++ branches/2.8.x/wb/install/save.php	(revision 1809)
@@ -494,6 +494,8 @@
 	       . ' `active` INT NOT NULL DEFAULT \'0\','
 	       . ' `username` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
 	       . ' `password` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
+	       . ' `confirm_code` VARCHAR( 32 ) NOT NULL DEFAULT \'\','
+	       . ' `confirm_timeout` INT NOT NULL DEFAULT \'0\','
 	       . ' `remember_key` VARCHAR( 255 ) NOT NULL DEFAULT \'\','
 	       . ' `last_reset` INT NOT NULL DEFAULT \'0\','
 	       . ' `display_name` VARCHAR( 255 ) NOT NULL DEFAULT \'\' ,'
