Changeset 181 for trunk

Timestamp:

Mar 24, 2009, 10:49:59 PM (16 years ago)

Author:

george

Message:

• Přidáno: Nastavení telefóního čísla a ICQ uživatele.
• Opraveno: Nelogovat odhlášení anonymního uživatele.

Location:

trunk

Files:

• form_classes.php (modified) (1 diff)
• sql/full.sql (modified) (12 diffs)
• sql/updates/181.sql (added)
• user.php (modified) (1 diff)

trunk/form_classes.php

@@ -57 +57 @@
       'SecondName' => array('Type' => 'String', 'Caption' => 'Přijmení jméno', 'Default' => ''),
       'Email' => array('Type' => 'String', 'Caption' => 'E-mail', 'Default' => ''),
+      'PhoneNumber' => array('Type' => 'String', 'Caption' => 'Telefón', 'Default' => ''),
+      'ICQ' => array('Type' => 'String', 'Caption' => 'ICQ', 'Default' => ''),
     ),
   ),

trunk/sql/full.sql

@@ -4 +4 @@
 --
 -- Počítač: localhost
--- Vygenerováno: Úterý 24. března 2009, 13:43
+-- Vygenerováno: Úterý 24. března 2009, 22:51
 -- Verze MySQL: 5.0.51
 -- Verze PHP: 5.2.6
@@ -147 +147 @@
   `Text` varchar(255) collate utf8_czech_ci NOT NULL default '',
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4182 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4183 ;
 
 -- --------------------------------------------------------
@@ -254 +254 @@
 
 --
--- Struktura tabulky `finance_operations`
---
-
-CREATE TABLE IF NOT EXISTS `finance_operations` (
+-- Struktura tabulky `finance_operations_old`
+--
+
+CREATE TABLE IF NOT EXISTS `finance_operations_old` (
   `id` int(11) NOT NULL auto_increment,
   `user` int(11) NOT NULL default '0',
@@ -321 +321 @@
   `used` int(11) NOT NULL default '1',
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=347 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=348 ;
 
 -- --------------------------------------------------------
@@ -448 +448 @@
   `NetworkSegment` int(11) NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=98 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=99 ;
 
 -- --------------------------------------------------------
@@ -466 +466 @@
   `Cash` float NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=83 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=84 ;
 
 -- --------------------------------------------------------
@@ -580 +580 @@
   `date` datetime NOT NULL default '0000-00-00 00:00:00',
   `target_date` datetime NOT NULL default '0000-00-00 00:00:00',
-  `author` varchar(32) collate utf8_czech_ci NOT NULL default 'Anonym',
+  `author` varchar(32) collate utf8_czech_ci NOT NULL default '',
   `ip` varchar(16) collate utf8_czech_ci NOT NULL default '',
   `category` int(11) NOT NULL default '0',
@@ -588 +588 @@
   KEY `category` (`category`),
   KEY `date` (`date`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30854 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30855 ;
 
 -- --------------------------------------------------------
@@ -716 +716 @@
   `WWW` varchar(255) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=105 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=106 ;
 
 -- --------------------------------------------------------
@@ -822 +822 @@
   `SecondName` varchar(128) collate utf8_czech_ci NOT NULL default '',
   `Nick` varchar(128) collate utf8_czech_ci NOT NULL default '',
-  `Password` text collate utf8_czech_ci NOT NULL,
+  `Password` varchar(255) collate utf8_czech_ci NOT NULL,
   `Email` varchar(128) collate utf8_czech_ci NOT NULL default '',
   `LastIpAddress` varchar(16) collate utf8_czech_ci NOT NULL default '',
@@ -828 +828 @@
   `RegistrationTime` datetime NOT NULL default '0000-00-00 00:00:00',
   `Member` int(11) NOT NULL,
-  `Locked` tinyint(1) NOT NULL default '1',
+  `Locked` tinyint(1) NOT NULL default '0',
   `ICQ` int(11) NOT NULL default '0',
   `PhoneNumber` varchar(32) collate utf8_czech_ci NOT NULL default '',
   `InitPassword` varchar(255) collate utf8_czech_ci NOT NULL,
-  PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=99 ;
+  PRIMARY KEY  (`Id`),
+  UNIQUE KEY `Name` (`Name`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=104 ;
 
 -- --------------------------------------------------------
@@ -852 +853 @@
   PRIMARY KEY  (`Id`),
   KEY `User` (`User`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=299 ;
 
 -- --------------------------------------------------------

trunk/user.php

@@ -66 +66 @@
     {
       $this->Database->delete('UserOnline', 'Id='.$DbRow['Id']);
-      if($DbRow['Id'] != $this->AnonymousUserId) $this->System->Modules['Log']->NewRecord('User', 'Logout');
+      if($DbRow['User'] != $this->AnonymousUserId) $this->System->Modules['Log']->NewRecord('User', 'Logout');
     }
     //$this->LoadPermission($this->User['Role']);