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 (5, '', 'weroska', 'wercia_wasswa@op.pl', '', '', 'gallery/blank.gif', 'Mar 16, 2006', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '46b22d8adc5854e9d45f30849b605', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, '0', 1142539076, 0, 1142539015, 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, 0, 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');
INSERT INTO `nuke_users` VALUES (803, '', 'Adka', 'adaaka@wp.pl', '', '', 'gallery/blank.gif', 'Jun 28, 2007', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '35ce62fb4cb7dca5698d0d19648701a', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, '0', 1183034835, -4, 1183034689, 1, NULL, 'polish', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, NULL, NULL, NULL, 90, 1, 0, 0, 1, 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');
INSERT INTO `nuke_users` VALUES (803, '', 'Adka', 'adaaka@wp.pl', '', '', 'gallery/blank.gif', 'Jun 28, 2007', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '35ce62fb4cb7dca5698d0d19648701a', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 1, 0, 0, 1, 1, 0, 1, '0', 1183034835, -4, 1183034689, 1, NULL, 'polish', 'D M d, Y g:i a', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, NULL, NULL, NULL, 90, 1, 0, 0, 1, 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');
i jak widac uzytkownik adka ma 90 pkt weroska ma 0punktow
Mam tych rekordow bardzo duzo, jak mozna wszystkim ludziom te punkty wyzerowac, zeby wszyscy mieli po 0??