Code:
INSERT INTO `staffpanel` VALUES (1, 'Polls', 'makepoll', 'Make a Poll', 5, 1, 1221495944);
INSERT INTO `staffpanel` VALUES (2, 'Unconfirmed Users', 'pusers', 'Manage unconfirmed users', 5, 1, 1221496037);
INSERT INTO `staffpanel` VALUES (3, 'Look for a user', 'usersearch', 'Advanced search user', 5, 1, 1221496239);
INSERT INTO `staffpanel` VALUES (4, 'Maybe Cheaters', 'maybecheaters', 'A list of users with a ratio above 100. (VIP class and under)', 5, 1, 1221496333);
INSERT INTO `staffpanel` VALUES (5, 'Reports', 'reports', 'Show Reports (forum,comment,torrent,request)', 5, 1, 1221496380);
INSERT INTO `staffpanel` VALUES (6, 'Duplicate IP Check', 'ipcheck', 'Check for Duplicate IP Users', 5, 1, 1221496423);
INSERT INTO `staffpanel` VALUES (7, 'Warned users', 'warninfo', 'See all warned users on tracker', 5, 1, 1221496484);
INSERT INTO `staffpanel` VALUES (8, 'Add User', 'adduser', 'Create new user account', 5, 1, 1221496534);
INSERT INTO `staffpanel` VALUES (9, 'Newest users', 'newsuser', '100 newest user accounts', 5, 1, 1221496579);
INSERT INTO `staffpanel` VALUES (10, 'Uploaders info panel', 'statsuploaders', 'Addon to monitor uploades activity', 5, 1, 1221496648);
INSERT INTO `staffpanel` VALUES (11, 'Logs', 'log', 'Show Logs', 5, 1, 1221496713);
INSERT INTO `staffpanel` VALUES (12, 'Leechers', 'leechers', 'Show users with ratio under 0.50', 5, 1, 1221496773);
INSERT INTO `staffpanel` VALUES (13, 'Delete Account', 'delacctadmin', 'Delete User Account', 6, 1, 1221496822);
INSERT INTO `staffpanel` VALUES (14, 'Poll overview', 'polloverview', 'View poll votes', 6, 1, 1221496907);
INSERT INTO `staffpanel` VALUES (15, 'Mass PM', 'staffmess', 'Send PM to all users', 6, 1, 1221496946);
INSERT INTO `staffpanel` VALUES (16, 'Ban System', 'bans', 'Ban / Unban IP', 6, 1, 1221496995);
INSERT INTO `staffpanel` VALUES (17, 'What is changing', 'modlog', 'Activity of the staff', 7, 1, 1221497300);
INSERT INTO `staffpanel` VALUES (18, 'Site Statistics', 'statistics', 'Registration, Rating, Post, PM, Torrents, Ban, Comment', 7, 1, 1221497506);
INSERT INTO `staffpanel` VALUES (19, 'Cleanup', 'docleanup', 'Perform a cleanup', 7, 1, 1221497544);
INSERT INTO `staffpanel` VALUES (20, 'Mass mailer', 'massmail', 'Send e-mail to all users on the tracker', 7, 1, 1221497596);
INSERT INTO `staffpanel` VALUES (21, 'MySQL Stats', 'status', 'See MySql stats', 7, 1, 1221497649);
INSERT INTO `staffpanel` VALUES (22, 'Spam', 'showmsg', 'Check Spam Pms', 7, 1, 1221497828);
INSERT INTO `staffpanel` VALUES (23, 'Mass Invite', 'massinvite', 'Give all users X invites', 7, 1, 1221497940);
INSERT INTO `staffpanel` VALUES (24, 'Abnormal Upload Speed Detector', 'cheaters', 'See cheaters', 5, 1, 1221498248);
INSERT INTO `staffpanel` VALUES (25, 'News page', 'news', 'Add, edit and remove news items from the homepage', 7, 1, 1221498396);
INSERT INTO `staffpanel` VALUES (26, 'Request to be Uploader', 'uploadapp', 'Uploader Requests', 5, 1, 1221498662);
INSERT INTO `staffpanel` VALUES (27, 'Failed Logins', 'maxlogin', 'Show Failed Login Attempts', 6, 1, 1221501051);
INSERT INTO `staffpanel` VALUES (28, 'Manage Tracker Categories', 'category', 'Edit/Delete tracker categories', 7, 1, 1221823909);
Code:
CREATE TABLE `staffpanel` (
`id` int(10) unsigned NOT NULL auto_increment,
`page_name` varchar(30) NOT NULL default '',
`file_name` varchar(30) NOT NULL default '',
`description` varchar(100) NOT NULL default '',
`av_class` tinyint(3) unsigned NOT NULL default '0',
`added_by` int(10) unsigned NOT NULL default '0',
`added` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `file_name` (`file_name`),
KEY `av_class` (`av_class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
|