NSN GR Downloads Script Needed

Rantin_26 · New Member Joined: Mar 26, 2006 Posts: 13

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 · 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` ;

Rantin_26 · New Member Joined: Mar 26, 2006 Posts: 13

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!

:clap:

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: 4852

Nice job, darklord! Now, it's posted for all eternity...or pretty close. Thanks again.

Rantin_26 · New Member Joined: Mar 26, 2006 Posts: 13

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 · New Member Joined: Mar 26, 2006 Posts: 13

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... Blonde Moment

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.

Rantin_26 · New Member Joined: Mar 26, 2006 Posts: 13

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 · New Member Joined: Mar 26, 2006 Posts: 13

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 · New Member Joined: Mar 26, 2006 Posts: 13

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..

Only registered users can see links on this board!
Get registered or login to the forums!

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 Dance-Y

...i love this smile Laughing

Rantin_26 · New Member Joined: Mar 26, 2006 Posts: 13

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 Dance-Y

...i told u i love that smiley