Parašė lexys· 2008 Lie. 22 20:07:30
#11
Chipas, ir tai ką tu man daviai, tai dabar profilio neatnaujina net standartinių laukų :D
Kur vartotojų info hash ir pan, tai to neduodu ;D
CREATE TABLE `fusion_users` (
`user_id` smallint(5) unsigned NOT NULL auto_increment,
`user_name` varchar(30) NOT NULL default '',
`user_password` varchar(32) NOT NULL default '',
`user_email` varchar(100) NOT NULL default '',
`user_hide_email` tinyint(1) unsigned NOT NULL default '1',
`user_location` varchar(50) NOT NULL default '',
`user_birthdate` date NOT NULL default '0000-00-00',
`user_aim` varchar(16) NOT NULL default '',
`user_icq` varchar(15) character set utf8 collate utf8_lithuanian_ci NOT NULL default '',
`user_yahoo` varchar(100) character set utf8 collate utf8_lithuanian_ci NOT NULL default '',
`user_web` varchar(200) character set utf8 collate utf8_lithuanian_ci NOT NULL default '',
`user_theme` varchar(100) character set utf8 collate utf8_lithuanian_ci NOT NULL default 'Default',
`user_msn` varchar(100) NOT NULL default '',
`user_offset` char(3) NOT NULL default '0',
`user_avatar` varchar(100) NOT NULL default '',
`user_sig` text NOT NULL,
`user_posts` smallint(5) unsigned NOT NULL default '0',
`user_joined` int(10) unsigned NOT NULL default '0',
`user_lastvisit` int(10) unsigned NOT NULL default '0',
`user_ip` varchar(20) NOT NULL default '0.0.0.0',
`user_rights` text NOT NULL,
`user_groups` text NOT NULL,
`user_level` tinyint(3) unsigned NOT NULL default '101',
`user_status` tinyint(1) unsigned NOT NULL default '0',
`strike1` tinyint(4) NOT NULL default '0',
`strike2` tinyint(4) NOT NULL default '0',
`strike3` tinyint(4) NOT NULL default '0',
`user_klanopavadinimas` varchar(255) NOT NULL default '',
`user_wincm` varchar(255) NOT NULL default '',
`user_lostcm` varchar(255) NOT NULL default '',
`user_clanweb` varchar(255) NOT NULL default '',
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1099 ;