|
Junior Member
Status: Offline
Posts: 1
Join Date: Jul 2005
|
nuke_module table -
11-12-2005, 06:09 PM
Hi, this is a dump of my nuke_module table.
Code:
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 12, 2005 at 03:12 PM
-- Server version: 4.0.18
-- PHP Version: 4.3.11
--
-- Database: `robert20_nuke1`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_modules`
--
CREATE TABLE `nuke_modules` (
`mid` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`custom_title` varchar(255) NOT NULL default '',
`active` int(1) NOT NULL default '0',
`view` int(1) NOT NULL default '0',
`inmenu` tinyint(1) NOT NULL default '1',
`mod_group` int(10) default '0',
`admins` varchar(255) NOT NULL default '',
`mcid` int(11) NOT NULL default '1',
`url` varchar(255) default '',
PRIMARY KEY (`mid`),
KEY `mid` (`mid`),
KEY `title` (`title`),
KEY `custom_title` (`custom_title`)
) TYPE=MyISAM AUTO_INCREMENT=1416 ;
--
-- Dumping data for table `nuke_modules`
--
INSERT INTO `nuke_modules` VALUES (2, 'Content', 'Content', 1, 1, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (3, 'Downloads', 'Downloads', 1, 0, 1, 0, 'Kim Grotans,', 3, '');
INSERT INTO `nuke_modules` VALUES (4, 'Encyclopedia', 'Encyclopedia', 0, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (5, 'FAQ', 'FAQ', 0, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (6, 'Feedback', 'Feedback', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (7, 'Forums', 'Forums', 1, 0, 1, 0, '', 4, '');
INSERT INTO `nuke_modules` VALUES (8, 'Journal', 'Journal', 1, 1, 1, 0, '', 4, '');
INSERT INTO `nuke_modules` VALUES (9, 'Members_List', 'Members List', 1, 1, 1, 0, '', 4, '');
INSERT INTO `nuke_modules` VALUES (10, 'News', 'News', 1, 0, 1, 0, 'Kim Grotans,', 2, '');
INSERT INTO `nuke_modules` VALUES (11, 'Private_Messages', 'Private Messages', 1, 0, 1, 0, '', 5, '');
INSERT INTO `nuke_modules` VALUES (12, 'Recommend_Us', 'Recommend Us', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (13, 'Reviews', 'Reviews', 1, 0, 1, 0, 'Kim Grotans,', 4, '');
INSERT INTO `nuke_modules` VALUES (14, 'Search', 'Search', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (15, 'Statistics', 'Statistics', 1, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (16, 'Stories_Archive', 'Stories Archive', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (17, 'Submit_News', 'Submit News', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (18, 'Surveys', 'Surveys', 1, 0, 1, 0, 'Kim Grotans,', 1, '');
INSERT INTO `nuke_modules` VALUES (19, 'Top', 'Top 10', 0, 0, 1, 0, '', 1, '');
INSERT INTO `nuke_modules` VALUES (20, 'Topics', 'Topics', 1, 0, 1, 0, '', 2, '');
INSERT INTO `nuke_modules` VALUES (21, 'Web_Links', 'Web Links', 1, 0, 1, 0, 'Kim Grotans,', 3, '');
INSERT INTO `nuke_modules` VALUES (22, 'Your_Account', 'Your Account', 1, 0, 1, 0, '', 5, '');
INSERT INTO `nuke_modules` VALUES (251, '$mtitle</td><td align=''center'' width=''15%''>$custom_title</td><td align=''center'' width=''10%''>$active</td><td align=''center'' width=''20%''>$who_view</td><td align=''center'' width=''10%''>$mod_group</td><td align=''center'' width=''25%''>[ <a href=''admin.php?op=modul', '', 0, 0, 0, NULL, '', 1, '');
INSERT INTO `nuke_modules` VALUES (315, '$mtitle</td><td align=''center'' width=''15%''>$custom_title</td><td align=''center'' width=''10%''>$active</td><td align=''center'' width=''20%''>$who_view</td><td align=''center'' width=''10%''>$mod_group</td><td align=''center'' width=''25%''>[ <a href=''admin.php?op=modul', '', 0, 0, 0, NULL, '', 1, '');
INSERT INTO `nuke_modules` VALUES (381, '$mtitle</td><td align=''center'' width=''15%''>$custom_title</td><td align=''center'' width=''10%''>$active</td><td align=''center'' width=''20%''>$who_view</td><td align=''center'' width=''10%''>$mod_group</td><td align=''center'' width=''25%''>[ <a href=''admin.php?op=modul', '', 0, 0, 0, NULL, '', 1, '');
INSERT INTO `nuke_modules` VALUES (1415, 'AvantGo', 'AvantGo', 0, 0, 1, 0, '1', 0, '');
INSERT INTO `nuke_modules` VALUES (1413, 'CZNews', 'CZNews', 1, 0, 1, 0, '1', 2, '');
And I would like to delete the following lines out of the table. Is there a way to do this
Code:
INSERT INTO `nuke_modules` VALUES (251, '$mtitle</td><td align=''center'' width=''15%''>$custom_title</td><td align=''center'' width=''10%''>$active</td><td align=''center'' width=''20%''>$who_view</td><td align=''center'' width=''10%''>$mod_group</td><td align=''center'' width=''25%''>[ <a href=''admin.php?op=modul', '', 0, 0, 0, NULL, '', 1, '');
INSERT INTO `nuke_modules` VALUES (315, '$mtitle</td><td align=''center'' width=''15%''>$custom_title</td><td align=''center'' width=''10%''>$active</td><td align=''center'' width=''20%''>$who_view</td><td align=''center'' width=''10%''>$mod_group</td><td align=''center'' width=''25%''>[ <a href=''admin.php?op=modul', '', 0, 0, 0, NULL, '', 1, '');
INSERT INTO `nuke_modules` VALUES (381, '$mtitle</td><td align=''center'' width=''15%''>$custom_title</td><td align=''center'' width=''10%''>$active</td><td align=''center'' width=''20%''>$who_view</td><td align=''center'' width=''10%''>$mod_group</td><td align=''center'' width=''25%''>[ <a href=''admin.php?op=modul', '', 0, 0, 0, NULL, '', 1, '');
|
Linear Mode
