Mam dwie takie instrukcje i nie wiem co z nimi zrobic :
Kod:
INSERT INTO `phpbb_unicomm` (`uc_name`, `uc_type`, `uc_link`, `uc_cgi`, `uc_button`, `uc_icon`, `uc_iconx`, `uc_icony`, `uc_order`, `uc_but_width`, `uc_but_height`, `uc_pattern`, `uc_find`, `uc_replace`)
VALUES
('Gadu Gadu', 0, 'gg:{VALUE}', '', 'uc_gg.gif', 'http://www.gadu-gadu.pl/users/status.asp?id={VALUE}&styl=1', 1, 2, 1, 59, 18, '(\\d+)', '', ''),
('Tlen', 0, 'http://ludzie.tlen.pl/{VALUE}', 'gg.php', 'uc_tlen.gif', 'http://status.tlen.pl/?u={VALUE}&t=1', 2, 0, 2, 59, 18, '(\\w+)', '#@(tlen|o2)\\.pl#i', ''),
('ICQ', 0, 'http://wwp.icq.com/{VALUE}', 'gg.php', 'uc_icq.gif', 'http://web.icq.com/whitepages/online?icq={VALUE}&img=5', 3, -1, 3, 59, 18, '(\\d+)', '', ''),
('Jabber', 0, 'http://edgar.netflint.net/status.php?jid={VALUE}', 'gg.php', 'uc_jabber.gif', 'http://edgar.netflint.net/status.php?jid={VALUE}&type=image&iconset=gabber', 2, 2, 4, 59, 18, '', '', '');
Kod:
ALTER TABLE `phpbb_users` DROP `user_icq`;
ALTER TABLE `phpbb_users` DROP `user_aim`;
ALTER TABLE `phpbb_users` DROP `user_yim`;
ALTER TABLE `phpbb_users` DROP `user_msnm`;
ALTER TABLE `phpbb_users` ADD `user_unicomm` TEXT;