http://forum.php.pl/index.php?showtopic=74866&hl=
Ale to nie to samo
mam tabele nuke users
Kod
CREATE TABLE `nuke_users` (
`user_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
`femail` varchar(255) NOT NULL default '',
`user_website` varchar(255) NOT NULL default '',
`user_avatar` varchar(255) NOT NULL default '',
`user_regdate` varchar(20) NOT NULL default '',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_interests` varchar(150) NOT NULL default '',
`user_sig` varchar(255) default NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(18) default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`user_password` varchar(40) NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`theme` varchar(255) NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`newsletter` int(1) NOT NULL default '0',
`user_posts` int(10) NOT NULL default '0',
`user_attachsig` int(2) NOT NULL default '1',
`user_rank` int(10) NOT NULL default '0',
`user_urank` int(11) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`broadcast` tinyint(1) NOT NULL default '1',
`popmeson` tinyint(1) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`user_warn` char(3) NOT NULL default '0',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_timezone` tinyint(4) NOT NULL default '1',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) NOT NULL default 'polish',
`user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '1',
`user_notify_pm` tinyint(1) NOT NULL default '1',
`user_popup_pm` tinyint(1) NOT NULL default '1',
`user_avatar_type` tinyint(4) NOT NULL default '3',
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`points` int(10) default '0',
`user_allow_arcadepm` tinyint(4) NOT NULL default '1',
`hide_quick_reply` tinyint(1) NOT NULL default '0',
`user_color_group` mediumint(8) unsigned NOT NULL default '0',
`user_sudoku_playing` int(1) NOT NULL default '0',
`user_gg` varchar(10) default NULL,
`user_tlen` varchar(30) default NULL,
`user_viewstat` tinyint(1) NOT NULL default '1',
`user_adr_ban` tinyint(1) NOT NULL default '0',
`user_cell_time` int(11) NOT NULL default '0',
`user_cell_time_judgement` int(11) NOT NULL default '0',
`user_cell_caution` int(8) NOT NULL default '0',
`user_cell_sentence` text,
`user_cell_enable_caution` int(8) NOT NULL default '0',
`user_cell_enable_free` int(8) NOT NULL default '0',
`user_cell_celleds` int(8) NOT NULL default '0',
`user_cell_punishment` tinyint(1) NOT NULL default '0',
`user_points` decimal(11,0) NOT NULL default '0',
`user_group_cp` int(11) NOT NULL default '2',
`user_group_list_cp` varchar(100) NOT NULL default '2',
`user_active_cp` enum('YES','NO') NOT NULL default 'YES',
`user_lastvisit_cp` datetime NOT NULL default '0000-00-00 00:00:00',
`user_regdate_cp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`user_id`),
KEY `uid` (`user_id`),
KEY `uname` (`username`),
KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM AUTO_INCREMENT=866;
--
-- Zrzut danych tabeli `nuke_users`
--
`user_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
`femail` varchar(255) NOT NULL default '',
`user_website` varchar(255) NOT NULL default '',
`user_avatar` varchar(255) NOT NULL default '',
`user_regdate` varchar(20) NOT NULL default '',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_interests` varchar(150) NOT NULL default '',
`user_sig` varchar(255) default NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(18) default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`user_password` varchar(40) NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`theme` varchar(255) NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`newsletter` int(1) NOT NULL default '0',
`user_posts` int(10) NOT NULL default '0',
`user_attachsig` int(2) NOT NULL default '1',
`user_rank` int(10) NOT NULL default '0',
`user_urank` int(11) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`broadcast` tinyint(1) NOT NULL default '1',
`popmeson` tinyint(1) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`user_warn` char(3) NOT NULL default '0',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_timezone` tinyint(4) NOT NULL default '1',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) NOT NULL default 'polish',
`user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '1',
`user_notify_pm` tinyint(1) NOT NULL default '1',
`user_popup_pm` tinyint(1) NOT NULL default '1',
`user_avatar_type` tinyint(4) NOT NULL default '3',
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`points` int(10) default '0',
`user_allow_arcadepm` tinyint(4) NOT NULL default '1',
`hide_quick_reply` tinyint(1) NOT NULL default '0',
`user_color_group` mediumint(8) unsigned NOT NULL default '0',
`user_sudoku_playing` int(1) NOT NULL default '0',
`user_gg` varchar(10) default NULL,
`user_tlen` varchar(30) default NULL,
`user_viewstat` tinyint(1) NOT NULL default '1',
`user_adr_ban` tinyint(1) NOT NULL default '0',
`user_cell_time` int(11) NOT NULL default '0',
`user_cell_time_judgement` int(11) NOT NULL default '0',
`user_cell_caution` int(8) NOT NULL default '0',
`user_cell_sentence` text,
`user_cell_enable_caution` int(8) NOT NULL default '0',
`user_cell_enable_free` int(8) NOT NULL default '0',
`user_cell_celleds` int(8) NOT NULL default '0',
`user_cell_punishment` tinyint(1) NOT NULL default '0',
`user_points` decimal(11,0) NOT NULL default '0',
`user_group_cp` int(11) NOT NULL default '2',
`user_group_list_cp` varchar(100) NOT NULL default '2',
`user_active_cp` enum('YES','NO') NOT NULL default 'YES',
`user_lastvisit_cp` datetime NOT NULL default '0000-00-00 00:00:00',
`user_regdate_cp` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`user_id`),
KEY `uid` (`user_id`),
KEY `uname` (`username`),
KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM AUTO_INCREMENT=866;
--
-- Zrzut danych tabeli `nuke_users`
--
i tu sa uzytkownicy
Kod
INSERT INTO `nuke_users` VALUES (7, '', 'adamus06', 'adamus123456@wp.pl', '', '', 'gallery/blank.gif', 'Mar 17, 2006', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 10, '', 0, 0, 0, '', 0, '', 'HL2', 4096, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, '0', 1142625184, 0, 1142625184, 1, 0, 'polish', 'D M d, Y g:i a', 0, 0, 1142625184, NULL, 1, 1, 1, 1, 1, 1, 0, 1, 1, 3, NULL, NULL, NULL, 25, 1, 0, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 2, '2', 'YES', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
INSERT INTO `nuke_users` VALUES (8, '', 'Blade', 'kubulek123456@interia.pl', '', '', 'gallery/blank.gif', 'Mar 18, 2006', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'bb86e84c96374382695b734d3b3cf6a8', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, '0', 1142692277, 0, 1142692192, 1, NULL, 'polish', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 1, 1, 3, NULL, NULL, NULL, 25, 1, 0, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 2, '2', 'YES', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
INSERT INTO `nuke_users` VALUES (9, '', 'ned', 'denrabin@op.pl', '', '', 'gallery/blank.gif', 'Mar 18, 2006', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'a002a20cc8cd18f804e1eed8ea0edfe5', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, '0', 0, 0, 0, 1, NULL, 'polish', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 1, 1, 3, NULL, NULL, NULL, 25, 1, 0, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 2, '2', 'YES', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
INSERT INTO `nuke_users` VALUES (10, '', 'ula1984', 'ula.lenio@wp.pl', '', '', 'gallery/blank.gif', 'Mar 18, 2006', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '1507649aefba9af6e7340022dce42a05', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, '0', 1142704540, -50, 1142704473, 1, NULL, 'polish', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 1, 1, 3, NULL, NULL, NULL, 25, 1, 0, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 2, '2', 'YES', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
INSERT INTO `nuke_users` VALUES (8, '', 'Blade', 'kubulek123456@interia.pl', '', '', 'gallery/blank.gif', 'Mar 18, 2006', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'bb86e84c96374382695b734d3b3cf6a8', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, '0', 1142692277, 0, 1142692192, 1, NULL, 'polish', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 1, 1, 3, NULL, NULL, NULL, 25, 1, 0, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 2, '2', 'YES', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
INSERT INTO `nuke_users` VALUES (9, '', 'ned', 'denrabin@op.pl', '', '', 'gallery/blank.gif', 'Mar 18, 2006', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'a002a20cc8cd18f804e1eed8ea0edfe5', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, '0', 0, 0, 0, 1, NULL, 'polish', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 1, 1, 3, NULL, NULL, NULL, 25, 1, 0, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 2, '2', 'YES', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
INSERT INTO `nuke_users` VALUES (10, '', 'ula1984', 'ula.lenio@wp.pl', '', '', 'gallery/blank.gif', 'Mar 18, 2006', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '1507649aefba9af6e7340022dce42a05', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, '0', 1142704540, -50, 1142704473, 1, NULL, 'polish', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 0, 1, 1, 3, NULL, NULL, NULL, 25, 1, 0, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 2, '2', 'YES', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);
I uzytkownik o id ma theme HL2 , inni nie maja zadnego wybranego
CO mam teraz zorbic aby automatycznie zminic wszyytskim ludzia te pole theme na EesyBlue
Próbowałem już
update nuke_users set theme=EasyBlue
ale wystapił taki bład
Kod
[b]zapytanie SQL:[/b]
UPDATE nuke_users SET theme = EasyBlue
[b]MySQL zwrócił komunikat: [/b][url="http://dev.mysql.com/doc/mysql/en/error-returns.html"][img]https://dedyk.topworld.org:2083/3rdparty/phpMyAdmin/themes/original/img/b_help.png[/img][/url]
#1054 - Unknown column 'EasyBlue' in 'field list'
UPDATE nuke_users SET theme = EasyBlue
[b]MySQL zwrócił komunikat: [/b][url="http://dev.mysql.com/doc/mysql/en/error-returns.html"][img]https://dedyk.topworld.org:2083/3rdparty/phpMyAdmin/themes/original/img/b_help.png[/img][/url]
#1054 - Unknown column 'EasyBlue' in 'field list'