| Author |
Message |
Rantin_26
New Member
Joined: Mar 26, 2006
Posts: 13
|
 Posted:
Mon May 29, 2006 10:35 pm |
|
Lets see how to Explain this.
I currently have Enhanced Downloads v2.1 on my WebSite , and I am switching to NSN GR Downloads so i can have the ability of setting group permission to certain Catagorys..
What i am in need of is a way to export my Downloads & Catagorys Tables from my database and be able to import them to the NSN GR Downloads Tables.
the Reason is a have over 350 downloads in the Enhanced Downloads and i really do not wanna have to readd these manully.
Any Help on this will be Greatly Appreciated! |
| |
|
   
 |
|
gregexp
The Mouse Is Extension Of Arm
Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol
|
| Posted:
Mon May 29, 2006 11:08 pm |
|
ok heres an update script that i made a while ago that will take care of u and it will keep all data and will allow u to manage it still...what u need to do is run the installer via phpmyadmin or nuke installer...then run this in phpmyadmin and u should have no problems:
Code:ALTER TABLE `nuke_downloads_categories` RENAME `nuke_nsngd_categories` ;
ALTER TABLE `nuke_nsngd_categories` ADD `whoadd` TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD `uploaddir` VARCHAR( 255 ) NOT NULL ,
ADD `canupload` TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD `active` TINYINT( 2 ) DEFAULT '1' NOT NULL ;
#SQL query for downloads:
ALTER TABLE `nuke_downloads_downloads` CHANGE `lid` `lid` INT( 11 ) NOT NULL AUTO_INCREMENT ,
CHANGE `cid` `cid` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `sid` `sid` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `title` `title` VARCHAR( 100 ) NOT NULL ,
CHANGE `url` `url` VARCHAR( 100 ) NOT NULL ,
CHANGE `description` `description` TEXT NOT NULL ,
CHANGE `date` `date` DATETIME NULL DEFAULT NULL ,
CHANGE `name` `name` VARCHAR( 100 ) NOT NULL ,
CHANGE `email` `email` VARCHAR( 100 ) NOT NULL ,
CHANGE `hits` `hits` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `submitter` `submitter` VARCHAR( 60 ) NOT NULL ,
CHANGE `downloadratingsummary` `sub_ip` VARCHAR( 16 ) NOT NULL DEFAULT '0.0.0.0',
CHANGE `totalvotes` `totalvotes` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `totalcomments` `totalcomments` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `filesize` `filesize` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `version` `version` VARCHAR( 10 ) NOT NULL ,
CHANGE `homepage` `homepage` VARCHAR( 200 ) NOT NULL ;
ALTER TABLE `nuke_downloads_downloads` DROP `totalvotes` ,
DROP `totalcomments` ;
ALTER TABLE `nuke_downloads_downloads` RENAME `nuke_nsngd_downloads` ;
ALTER TABLE `nuke_nsngd_downloads` ADD `active` TINYINT( 2 ) DEFAULT '1' NOT NULL AFTER `homepage` ;
|
now this does a lot more then it has to i know..but it will work ..ive tested this and use it to update my test sites so i know it works.
Edit: forgot this one...sorry..run this phpmyadmin also:
Code:ALTER TABLE `nuke_downloads_newdownload` ADD `date` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL AFTER `description` ;
ALTER TABLE `nuke_downloads_newdownload` ADD `sub_ip` VARCHAR( 16 ) DEFAULT '0.0.0.0' NOT NULL AFTER `submitter` ;
ALTER TABLE `nuke_downloads_newdownload` RENAME `nuke_nsngd_new` ;
|
|
_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! |
|
 |
|
Rantin_26
|
| Posted:
Tue May 30, 2006 12:00 am |
|
OMG!, Thank You, Worked Perfectly, Again Thank You, I was so dredding readding 355 downloads manually, these accumulated over a 2 year period, adding manually would have took me a month!
 |
| |
|
|
|
|
gregexp
|
| Posted:
Tue May 30, 2006 9:11 am |
|
no problem...not sure if some1 had ever made one..but i found the need for one a while ago...and dreaded the idea myself...lol |
| |
|
|
|
|
kguske
Site Admin
Joined: Jun 04, 2004
Posts: 6437
|
| Posted:
Tue May 30, 2006 8:15 pm |
|
Nice job, darklord! Now, it's posted for all eternity...or pretty close. Thanks again. |
_________________
I search, therefore I exist...
Only registered users can see links on this board! Get registered or login! |
|
|
|
|
Rantin_26
|
| Posted:
Sun Jun 04, 2006 2:22 am |
|
Problem I am having now is it want let me Add any new ones now, I put in all info, then page reloads and it's not added?? |
| |
|
|
|
|
gregexp
|
| Posted:
Sun Jun 04, 2006 3:58 am |
|
Plz check that all tables are there and correct spelling
This is the layout for the tables...i hope this is simple enough..if not ill add more detailed description to it at the bottom.
Sql query:
CREATE TABLE `nuke_nsngd_accesses` (
`username` varchar(60) NOT NULL default '',
`downloads` int(11) NOT NULL default '0',
`uploads` int(11) NOT NULL default '0',
PRIMARY KEY (`username`)
) TYPE=MyISAM;
CREATE TABLE `nuke_nsngd_categories` (
`cid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`cdescription` text NOT NULL,
`parentid` int(11) NOT NULL default '0',
`whoadd` tinyint(2) NOT NULL default '0',
`uploaddir` varchar(255) NOT NULL default '',
`canupload` tinyint(2) NOT NULL default '0',
`active` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`cid`),
KEY `cid` (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=64 ;
CREATE TABLE `nuke_nsngd_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` text NOT NULL,
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
CREATE TABLE `nuke_nsngd_downloads` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '1',
`title` varchar(100) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`hits` int(11) NOT NULL default '0',
`submitter` varchar(60) NOT NULL default '',
`sub_ip` varchar(16) NOT NULL default '0.0.0.0',
`filesize` bigint(20) NOT NULL default '0',
`version` varchar(20) NOT NULL default '',
`homepage` varchar(255) NOT NULL default '',
`active` tinyint(2) NOT NULL default '1',
PRIMARY KEY (`lid`),
KEY `lid` (`lid`),
KEY `cid` (`cid`),
KEY `sid` (`sid`),
KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=688 ;
CREATE TABLE `nuke_nsngd_extensions` (
`eid` int(11) NOT NULL auto_increment,
`ext` varchar(6) NOT NULL default '',
`file` tinyint(1) NOT NULL default '0',
`image` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`eid`),
KEY `ext` (`eid`)
) TYPE=MyISAM AUTO_INCREMENT=21 ;
--
-- Dumping data for table `nuke_nsngd_extensions`
--
INSERT INTO `nuke_nsngd_extensions` VALUES (1, '.ace', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (2, '.arj', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (3, '.bz', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (4, '.bz2', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (5, '.cab', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (6, '.exe', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (7, '.gif', 0, 1);
INSERT INTO `nuke_nsngd_extensions` VALUES (8, '.gz', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (9, '.iso', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (10, '.jpeg', 0, 1);
INSERT INTO `nuke_nsngd_extensions` VALUES (11, '.jpg', 0, 1);
INSERT INTO `nuke_nsngd_extensions` VALUES (12, '.lha', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (13, '.lzh', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (14, '.png', 0, 1);
INSERT INTO `nuke_nsngd_extensions` VALUES (15, '.rar', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (16, '.tar', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (17, '.tgz', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (18, '.uue', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (19, '.zip', 1, 0);
INSERT INTO `nuke_nsngd_extensions` VALUES (20, '.zoo', 1, 0);
CREATE TABLE `nuke_nsngd_mods` (
`rid` int(11) NOT NULL auto_increment,
`lid` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`modifier` varchar(60) NOT NULL default '',
`sub_ip` varchar(16) NOT NULL default '0.0.0.0',
`brokendownload` int(3) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`filesize` bigint(20) NOT NULL default '0',
`version` varchar(20) NOT NULL default '',
`homepage` varchar(255) NOT NULL default '',
PRIMARY KEY (`rid`),
UNIQUE KEY `rid` (`rid`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
CREATE TABLE `nuke_nsngd_new` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`submitter` varchar(60) NOT NULL default '',
`sub_ip` varchar(16) NOT NULL default '0.0.0.0',
`filesize` bigint(20) NOT NULL default '0',
`version` varchar(20) NOT NULL default '',
`homepage` varchar(255) NOT NULL default '',
PRIMARY KEY (`lid`),
KEY `lid` (`lid`),
KEY `cid` (`cid`),
KEY `sid` (`sid`),
KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
Where it says Create table...thats the table name
all the code held within the () are table structure....this is just as important as the table being there because if the table is there...this will be most likely ur problem
The query with the INSERT tag is filling that table with information that it needs by default.
THIS IS NOT AN UPDATE!!!!
this is a query able to be run from phpmyadmin and this query will make all the tables and fill in with appropriate data but this will not keep ur old downloads...the update is listed above in the post...use this to run on ur database for installing but also to verify that all ur tables are correctly made. |
| |
|
|
|
|
Rantin_26
|
| Posted:
Sun Jun 04, 2006 4:12 am |
|
Thank You for Such Quick Response, Will Try Now,
After I couldn't get that option you gave me in the first reply you gave on coping them and i couldn't add more, i tried the Coping downloads option that came in the nsngd.php installer after creating the tables and it was failing to copy bout 20% of my Downloads, But i could add more after that, But 20% not being copieds was around 115 files not being transferred, so that approach didn't work.
And Ty you for such quick Reponses! |
| |
|
|
|
|
gregexp
|
| Posted:
Sun Jun 04, 2006 4:27 am |
|
whoa..u lost me...are we talkin upgrading or installing or just ading downloads...sorry but right now u through me for a loop.
Where are u in the installation and what are u trying to accomplish...plz be as specific as u can be.
EDIT:...im sorry i just realized what u were talkin bout and who u are... 
ok lets figure this out then...ur trying to add new downloads and it wont take...right?...then we need to look at the tables and see what may have went wrong and whether or not the script is working correctly.
ohh duh...im so sorry
u need to run these queries in order for ALL tables to be made
AFTER u run the update...run these:
CREATE TABLE nuke_nsngd_accesses (
`username` varchar(60) NOT NULL,
`downloads` int(11) DEFAULT '0' NOT NULL,
`uploads` int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (username)
);
CREATE TABLE nuke_nsngd_config (
`config_name` varchar(255) NOT NULL,
`config_value` text NOT NULL,
PRIMARY KEY (config_name)
);
INSERT INTO nuke_nsngd_config VALUES ('admperpage', '50');
INSERT INTO nuke_nsngd_config VALUES ('blockunregmodify', '0');
INSERT INTO nuke_nsngd_config VALUES ('dateformat', 'D M j G:i:s T Y');
INSERT INTO nuke_nsngd_config VALUES ('mostpopular', '25');
INSERT INTO nuke_nsngd_config VALUES ('mostpopulartrig', '0');
INSERT INTO nuke_nsngd_config VALUES ('perpage', '10');
INSERT INTO nuke_nsngd_config VALUES ('popular', '500');
INSERT INTO nuke_nsngd_config VALUES ('results', '10');
INSERT INTO nuke_nsngd_config VALUES ('show_links_num', '1');
INSERT INTO nuke_nsngd_config VALUES ('usegfxcheck', '1');
INSERT INTO nuke_nsngd_config VALUES ('show_download', '1');
INSERT INTO nuke_nsngd_config VALUES ('version_number', '1.0.2');
CREATE TABLE nuke_nsngd_extensions (
`eid` int(11) NOT NULL auto_increment,
`ext` varchar(6) NOT NULL,
`file` tinyint(1) DEFAULT '0' NOT NULL,
`image` tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (eid),
KEY ext (eid)
);
#
# Dumping data for table 'nuke_nsngd_extensions'
#
INSERT INTO nuke_nsngd_extensions VALUES ('1', '.ace', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('2', '.arj', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('3', '.bz', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('4', '.bz2', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('5', '.cab', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('6', '.exe', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('7', '.gif', '0', '1');
INSERT INTO nuke_nsngd_extensions VALUES ('8', '.gz', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('9', '.iso', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('10', '.jpeg', '0', '1');
INSERT INTO nuke_nsngd_extensions VALUES ('11', '.jpg', '0', '1');
INSERT INTO nuke_nsngd_extensions VALUES ('12', '.lha', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('13', '.lzh', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('14', '.png', '0', '1');
INSERT INTO nuke_nsngd_extensions VALUES ('15', '.rar', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('16', '.tar', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('17', '.tgz', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('18', '.uue', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('19', '.zip', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('20', '.zoo', '1', '0');
# --------------------------------------------------------
#
# Table structure for table 'nuke_nsngd_mods'
#
CREATE TABLE nuke_nsngd_mods (
`rid` int(11) NOT NULL auto_increment,
`lid` int(11) DEFAULT '0' NOT NULL,
`cid` int(11) DEFAULT '0' NOT NULL,
`sid` int(11) DEFAULT '0' NOT NULL,
`title` varchar(100) NOT NULL,
`url` varchar(255) NOT NULL,
`description` text NOT NULL,
`modifier` varchar(60) NOT NULL,
`sub_ip` varchar(16) DEFAULT '0.0.0.0' NOT NULL,
`brokendownload` int(3) DEFAULT '0' NOT NULL,
`name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`filesize` bigint(20) DEFAULT '0' NOT NULL,
`version` varchar(20) NOT NULL,
`homepage` varchar(255) NOT NULL,
PRIMARY KEY (rid),
UNIQUE rid (rid)
);
#
# Dumping data for table 'nuke_nsngd_mods'
#
My apologies...but the update and these are all u should need to run...DO NOT run the installer.
if need be...restore ur backup of the download tables and drop all nsngd tables...then run the upgrade then this... my apologies for this error.
IF need be...plz contact me via yahoo and well get this straight. |
| |
|
|
|
|
gregexp
|
| Posted:
Sun Jun 04, 2006 4:43 am |
|
i see how this all got mumbled....so heres the FULL update script:
Run this via phpmyadmin:
Code:
#
#Table structure for table 'nuke_nsngd_accesses'
#
DROP TABLE IF EXISTS nuke_nsngd_accesses;
CREATE TABLE nuke_nsngd_accesses (
`username` varchar(60) NOT NULL,
`downloads` int(11) DEFAULT '0' NOT NULL,
`uploads` int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (username)
);
#
# Dumping data for table 'nuke_nsngd_accesses'
#
#sql query for categories
ALTER TABLE `nuke_downloads_categories` RENAME `nuke_nsngd_categories` ;
ALTER TABLE `nuke_nsngd_categories` ADD `whoadd` TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD `uploaddir` VARCHAR( 255 ) NOT NULL ,
ADD `canupload` TINYINT( 2 ) DEFAULT '0' NOT NULL ,
ADD `active` TINYINT( 2 ) DEFAULT '1' NOT NULL ;
#SQL query for downloads:
ALTER TABLE `nuke_downloads_downloads` CHANGE `lid` `lid` INT( 11 ) NOT NULL AUTO_INCREMENT ,
CHANGE `cid` `cid` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `sid` `sid` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `title` `title` VARCHAR( 100 ) NOT NULL ,
CHANGE `url` `url` VARCHAR( 100 ) NOT NULL ,
CHANGE `description` `description` TEXT NOT NULL ,
CHANGE `date` `date` DATETIME NULL DEFAULT NULL ,
CHANGE `name` `name` VARCHAR( 100 ) NOT NULL ,
CHANGE `email` `email` VARCHAR( 100 ) NOT NULL ,
CHANGE `hits` `hits` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `submitter` `submitter` VARCHAR( 60 ) NOT NULL ,
CHANGE `downloadratingsummary` `sub_ip` VARCHAR( 16 ) NOT NULL DEFAULT '0.0.0.0',
CHANGE `totalvotes` `totalvotes` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `totalcomments` `totalcomments` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `filesize` `filesize` INT( 11 ) NOT NULL DEFAULT '0',
CHANGE `version` `version` VARCHAR( 10 ) NOT NULL ,
CHANGE `homepage` `homepage` VARCHAR( 200 ) NOT NULL ;
ALTER TABLE `nuke_downloads_downloads` DROP `totalvotes` ,
DROP `totalcomments` ;
ALTER TABLE `nuke_downloads_downloads` RENAME `nuke_nsngd_downloads` ;
ALTER TABLE `nuke_nsngd_downloads` ADD `active` TINYINT( 2 ) DEFAULT '1' NOT NULL AFTER `homepage` ;
#
# Table structure for table 'nuke_nsngd_config'
#
DROP TABLE IF EXISTS nuke_nsngd_config;
CREATE TABLE nuke_nsngd_config (
`config_name` varchar(255) NOT NULL,
`config_value` text NOT NULL,
PRIMARY KEY (config_name)
);
#
# Dumping data for table 'nuke_nsngd_config'
#
INSERT INTO nuke_nsngd_config VALUES ('admperpage', '50');
INSERT INTO nuke_nsngd_config VALUES ('blockunregmodify', '0');
INSERT INTO nuke_nsngd_config VALUES ('dateformat', 'D M j G:i:s T Y');
INSERT INTO nuke_nsngd_config VALUES ('mostpopular', '25');
INSERT INTO nuke_nsngd_config VALUES ('mostpopulartrig', '0');
INSERT INTO nuke_nsngd_config VALUES ('perpage', '10');
INSERT INTO nuke_nsngd_config VALUES ('popular', '500');
INSERT INTO nuke_nsngd_config VALUES ('results', '10');
INSERT INTO nuke_nsngd_config VALUES ('show_links_num', '1');
INSERT INTO nuke_nsngd_config VALUES ('usegfxcheck', '1');
INSERT INTO nuke_nsngd_config VALUES ('show_download', '1');
INSERT INTO nuke_nsngd_config VALUES ('version_number', '1.0.2');
#
# Table structure for table 'nuke_nsngd_extensions'
#
DROP TABLE IF EXISTS nuke_nsngd_extensions;
CREATE TABLE nuke_nsngd_extensions (
`eid` int(11) NOT NULL auto_increment,
`ext` varchar(6) NOT NULL,
`file` tinyint(1) DEFAULT '0' NOT NULL,
`image` tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (eid),
KEY ext (eid)
);
#
# Dumping data for table 'nuke_nsngd_extensions'
#
INSERT INTO nuke_nsngd_extensions VALUES ('1', '.ace', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('2', '.arj', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('3', '.bz', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('4', '.bz2', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('5', '.cab', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('6', '.exe', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('7', '.gif', '0', '1');
INSERT INTO nuke_nsngd_extensions VALUES ('8', '.gz', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('9', '.iso', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('10', '.jpeg', '0', '1');
INSERT INTO nuke_nsngd_extensions VALUES ('11', '.jpg', '0', '1');
INSERT INTO nuke_nsngd_extensions VALUES ('12', '.lha', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('13', '.lzh', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('14', '.png', '0', '1');
INSERT INTO nuke_nsngd_extensions VALUES ('15', '.rar', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('16', '.tar', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('17', '.tgz', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('18', '.uue', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('19', '.zip', '1', '0');
INSERT INTO nuke_nsngd_extensions VALUES ('20', '.zoo', '1', '0');
# --------------------------------------------------------
#
# Table structure for table 'nuke_nsngd_mods'
#
DROP TABLE IF EXISTS nuke_nsngd_mods;
CREATE TABLE nuke_nsngd_mods (
`rid` int(11) NOT NULL auto_increment,
`lid` int(11) DEFAULT '0' NOT NULL,
`cid` int(11) DEFAULT '0' NOT NULL,
`sid` int(11) DEFAULT '0' NOT NULL,
`title` varchar(100) NOT NULL,
`url` varchar(255) NOT NULL,
`description` text NOT NULL,
`modifier` varchar(60) NOT NULL,
`sub_ip` varchar(16) DEFAULT '0.0.0.0' NOT NULL,
`brokendownload` int(3) DEFAULT '0' NOT NULL,
`name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`filesize` bigint(20) DEFAULT '0' NOT NULL,
`version` varchar(20) NOT NULL,
`homepage` varchar(255) NOT NULL,
PRIMARY KEY (rid),
UNIQUE rid (rid)
);
#
# Dumping data for table 'nuke_nsngd_mods'
#
# --------------------------------------------------------
#
# Update new downloads table to make nuke_nsngd_new table
#
ALTER TABLE `nuke_downloads_newdownload` CHANGE `url` `url` VARCHAR( 255 ) NOT NULL
ALTER TABLE `nuke_downloads_newdownload` ADD `date` DATETIME DEFAULT '' NOT NULL AFTER `description` ;
ALTER TABLE `nuke_downloads_newdownload` ADD `sub_ip` VARCHAR( 16 ) DEFAULT '0.0.0.0' NOT NULL AFTER `submitter` ;
ALTER TABLE `nuke_downloads_newdownload` CHANGE `filesize` `filesize` BIGINT( 20 ) NOT NULL DEFAULT '0'
ALTER TABLE `nuke_downloads_newdownload` CHANGE `version` `version` VARCHAR( 20 ) NOT NULL
ALTER TABLE `nuke_downloads_newdownload` CHANGE `homepage` `homepage` VARCHAR( 255 ) NOT NULL
ALTER TABLE `nuke_downloads_newdownload` RENAME `nuke_nsngd_new` ;
#
# Dumping data for table 'nuke_nsngd_new'
#
|
this will COMPLETLY update ur nuke site to the correct tables in one shot. |
Last edited by gregexp on Sat Jul 01, 2006 10:03 pm; edited 3 times in total |
|
|
|
|
Rantin_26
|
| Posted:
Sun Jun 04, 2006 4:44 am |
|
lol ok, i installed the nsn gr tables, uploaded the nsn downloads files to my ftp and then deleted the tables nsngd_catagories, nsngd_downloads, and nsngd_new, then ran the script you gave me in the first post on how to add my old downloads from edl tables to nsngd tables, that all work perfect but now i cannot add new downloads..
Maybe I am doing this Completely wrong, errr |
| |
|
|
|
|
Rantin_26
|
| Posted:
Sun Jun 04, 2006 4:44 am |
|
oops sorry i musta been typing while you was posting... |
| |
|
|
|
|
gregexp
|
| Posted:
Sun Jun 04, 2006 4:47 am |
|
the error was in me....i forgot to add these things to the update...now remember it changes the name of the downloads table...so the old downloads are no longer in ur database...do NOT drop the nsngd downloads table...unless u have a backup of the original downloads. |
| |
|
|
|
|
Rantin_26
|
| Posted:
Sun Jun 04, 2006 5:04 am |
|
I just don't get what i am doing wrong, i hate to be such a pain, but it's just not playing out like i thought.. I have pasted a link to my tables below, maybe you might see my problem to why i can not still add new downloads..
www.rantinracing.com/my_nsngd_tables.txt
everything has transferred fine, just not able to add any, and do i need to maybe drop all the old edl tables?? after i ran the script that renames the ones it was suppose to?? |
| |
|
|
|
|
gregexp
|
| Posted:
Sun Jun 04, 2006 7:06 am |
|
UPDATE...problem fixed
As much as my update alone would have messed it up...it surprisingly was the original script
It added some fields to the tables...go no clue what they were for ( assuming it was an updated version)
I downgraded him to the version i use and altered the tables...and tada  ...i love this smile  |
| |
|
|
|
|
Rantin_26
|
| Posted:
Sun Jun 04, 2006 8:52 pm |
|
I wanna say that I appreciate all the help and support darklord gave me, when we couldn't get it done by me doing it, i gave him control and it was fixed in a matter of 2 minutes!!
Excellent Member he is! Great Support and was Very, I mean Very Patiance with me lol |
| |
|
|
|
|
gregexp
|
| Posted:
Sun Jun 04, 2006 10:21 pm |
|
 where i started my phpnuke experience!
and thank u for the added thanx..with those...it makes helpin other completely worth it ...i told u i love that smiley |
| |
|
|
|
|
|
|
![[Valid RSS]](https://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
