Vyexportuj si tabulku uživatelů. Pak doplň požadované věci. Nějak takto:
CREATE TABLE IF NOT EXISTS `testovani-users` (
`id` int(11) NOT NULL,
`group` int(11) NOT NULL,
`levelshift` tinyint(1) NOT NULL,
`username` tinytext NOT NULL,
`publicname` tinytext NOT NULL,
`password` tinytext NOT NULL,
`salt` tinytext NOT NULL,
`logincounter` int(11) NOT NULL,
`registertime` int(11) NOT NULL,
`activitytime` int(11) NOT NULL,
`blocked` tinyint(1) NOT NULL,
`massemail` tinyint(1) NOT NULL,
`wysiwyg` tinyint(1) NOT NULL,
`language` tinytext NOT NULL,
`ip` tinytext NOT NULL,
`email` tinytext NOT NULL,
`avatar` tinytext NOT NULL,
`web` tinytext NOT NULL,
`skype` tinytext NOT NULL,
`msn` tinytext NOT NULL,
`icq` int(11) NOT NULL,
`jabber` tinytext NOT NULL,
`facebook` tinytext NOT NULL,
`bydliště` tinytext NOT NULL,
`zájmy` tinytext NOT NULL,
`note` text NOT NULL,
`code` varchar(6) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `group` (`group`,`username`(4),`registertime`,`activitytime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Vypisuji data pro tabulku `testovani-users`
--
INSERT INTO `testovani-users` (`id`, `group`, `levelshift`, `username`, `publicname`, `password`, `salt`, `logincounter`, `registertime`, `activitytime`, `blocked`, `massemail`, `wysiwyg`, `language`, `ip`, `email`, `avatar`, `web`, `skype`, `msn`, `icq`, `jabber`, `facebook`, `bydliště`, `zájmy`, `note`, `code`) VALUES
(0, 1, 1, 'Root', 'Landsman', '585809379a7891d830813cefcc9881a4', 'sahep946', 26, 1281018164, 1281287638, 0, 1, 0, '', '85.70.211.01.88', 'landsman@insuit.cz', '', '', '', '', 0, '', '', '', '', '', NULL);Aktualizuj db. Pak je třeba upravit /require/settings.php a profile.php. Tam také přidáš tyto položky. Do jazykového souboru musíš přidat nové názvy.