About this Page
This is a discussion on nuke_module table within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; Hi, this is a dump of my nuke_module table. Code: -- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://...

Oztac · #1 (**permalink**) 11-12-2005, 05: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, '');

About this PageThis is a discussion on nuke_module table within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; Hi, this is a dump of my nuke_module table. Code: -- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://...

nuke_module table

About this Page
This is a discussion on nuke_module table within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; Hi, this is a dump of my nuke_module table. Code: -- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://...