Changeset 181


Ignore:
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:
1 added
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/form_classes.php

    r156 r181  
    5757      'SecondName' => array('Type' => 'String', 'Caption' => 'Přijmení jméno', 'Default' => ''),
    5858      'Email' => array('Type' => 'String', 'Caption' => 'E-mail', 'Default' => ''),
     59      'PhoneNumber' => array('Type' => 'String', 'Caption' => 'Telefón', 'Default' => ''),
     60      'ICQ' => array('Type' => 'String', 'Caption' => 'ICQ', 'Default' => ''),
    5961    ),
    6062  ),
  • trunk/sql/full.sql

    r169 r181  
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Úterý 24. března 2009, 13:43
     6-- Vygenerováno: Úterý 24. března 2009, 22:51
    77-- Verze MySQL: 5.0.51
    88-- Verze PHP: 5.2.6
     
    147147  `Text` varchar(255) collate utf8_czech_ci NOT NULL default '',
    148148  PRIMARY KEY  (`Id`)
    149 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4182 ;
     149) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4183 ;
    150150
    151151-- --------------------------------------------------------
     
    254254
    255255--
    256 -- Struktura tabulky `finance_operations`
    257 --
    258 
    259 CREATE TABLE IF NOT EXISTS `finance_operations` (
     256-- Struktura tabulky `finance_operations_old`
     257--
     258
     259CREATE TABLE IF NOT EXISTS `finance_operations_old` (
    260260  `id` int(11) NOT NULL auto_increment,
    261261  `user` int(11) NOT NULL default '0',
     
    321321  `used` int(11) NOT NULL default '1',
    322322  PRIMARY KEY  (`id`)
    323 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=347 ;
     323) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=348 ;
    324324
    325325-- --------------------------------------------------------
     
    448448  `NetworkSegment` int(11) NOT NULL,
    449449  PRIMARY KEY  (`Id`)
    450 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=98 ;
     450) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=99 ;
    451451
    452452-- --------------------------------------------------------
     
    466466  `Cash` float NOT NULL,
    467467  PRIMARY KEY  (`Id`)
    468 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=83 ;
     468) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=84 ;
    469469
    470470-- --------------------------------------------------------
     
    580580  `date` datetime NOT NULL default '0000-00-00 00:00:00',
    581581  `target_date` datetime NOT NULL default '0000-00-00 00:00:00',
    582   `author` varchar(32) collate utf8_czech_ci NOT NULL default 'Anonym',
     582  `author` varchar(32) collate utf8_czech_ci NOT NULL default '',
    583583  `ip` varchar(16) collate utf8_czech_ci NOT NULL default '',
    584584  `category` int(11) NOT NULL default '0',
     
    588588  KEY `category` (`category`),
    589589  KEY `date` (`date`)
    590 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30854 ;
     590) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=30855 ;
    591591
    592592-- --------------------------------------------------------
     
    716716  `WWW` varchar(255) collate utf8_czech_ci NOT NULL,
    717717  PRIMARY KEY  (`Id`)
    718 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=105 ;
     718) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=106 ;
    719719
    720720-- --------------------------------------------------------
     
    822822  `SecondName` varchar(128) collate utf8_czech_ci NOT NULL default '',
    823823  `Nick` varchar(128) collate utf8_czech_ci NOT NULL default '',
    824   `Password` text collate utf8_czech_ci NOT NULL,
     824  `Password` varchar(255) collate utf8_czech_ci NOT NULL,
    825825  `Email` varchar(128) collate utf8_czech_ci NOT NULL default '',
    826826  `LastIpAddress` varchar(16) collate utf8_czech_ci NOT NULL default '',
     
    828828  `RegistrationTime` datetime NOT NULL default '0000-00-00 00:00:00',
    829829  `Member` int(11) NOT NULL,
    830   `Locked` tinyint(1) NOT NULL default '1',
     830  `Locked` tinyint(1) NOT NULL default '0',
    831831  `ICQ` int(11) NOT NULL default '0',
    832832  `PhoneNumber` varchar(32) collate utf8_czech_ci NOT NULL default '',
    833833  `InitPassword` varchar(255) collate utf8_czech_ci NOT NULL,
    834   PRIMARY KEY  (`Id`)
    835 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=99 ;
     834  PRIMARY KEY  (`Id`),
     835  UNIQUE KEY `Name` (`Name`)
     836) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=104 ;
    836837
    837838-- --------------------------------------------------------
     
    852853  PRIMARY KEY  (`Id`),
    853854  KEY `User` (`User`)
    854 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;
     855) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=299 ;
    855856
    856857-- --------------------------------------------------------
  • trunk/user.php

    r170 r181  
    6666    {
    6767      $this->Database->delete('UserOnline', 'Id='.$DbRow['Id']);
    68       if($DbRow['Id'] != $this->AnonymousUserId) $this->System->Modules['Log']->NewRecord('User', 'Logout');
     68      if($DbRow['User'] != $this->AnonymousUserId) $this->System->Modules['Log']->NewRecord('User', 'Logout');
    6969    }
    7070    //$this->LoadPermission($this->User['Role']);
Note: See TracChangeset for help on using the changeset viewer.