Advanced Downloads V1.2.1

320

Wed Jun 12, 2013 8:29 am
NOOB!!!
2 Posts
hi coRpSE

i am having problems with uploading the SQL FILE , I  have done a fresh install deleted the old download module and dropped the tables in php myadmin,
downloaded your advanced Downloads V1.2.1 patched and uploaded all the files ect ,

when i go to upload the '' Full-Install.sql '' file i get the following Error ,

could you advise me what to do as i dont have a clue


Error

SQL query:

--
-- Dumping data for table `nuke_downloads_categories`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_downloads_config`
--
CREATE TABLE IF NOT EXISTS `nuke_downloads_config` (
`config_name` varchar( 255 ) NOT NULL DEFAULT '',
`config_value` text NOT NULL ,
PRIMARY KEY ( `config_name` )
) ENGINE = MYISAM ;

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes
Wed Jun 12, 2013 11:52 am
Clan Leader
Top Dog
2600 Posts
huh, I just tested this and it working on my site. Here, delete any Downloads table there is and try this.

Code: [ Select all ]


--
-- Table structure for table `nuke_downloads_accesses`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_accesses` (
  `username` varchar(60) NOT NULL DEFAULT '',
  `downloads` int(11) NOT NULL DEFAULT '0',
  `uploads` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`username`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_accesses`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_categories`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_categories` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '',
  `usecatcolor` tinyint(2) NOT NULL DEFAULT '0',
  `catcolor` varchar(50) NOT NULL,
  `catimage` varchar(255) NOT NULL DEFAULT './modules/Downloads/images/cat_icons/dir.png',
  `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 `title` (`title`),
  FULLTEXT KEY `catimage` (`catimage`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_categories`
--


-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_config`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_config` (
  `config_name` varchar(255) NOT NULL DEFAULT '',
  `config_value` text NOT NULL,
  PRIMARY KEY (`config_name`(100))
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_config`
--

INSERT INTO `nuke_downloads_config` (`config_name`, `config_value`) VALUES
('admperpage', '50'),
('blockunregmodify', '1'),
('dateformat', ''),
('mostpopular', '10'),
('mostpopulartrig', '0'),
('perpage', '15'),
('popular', '100'),
('results', '30'),
('show_download', '1'),
('show_links_num', '1'),
('usegfxcheck', '1'),
('dlfpath', './modules/Downloads/files'),
('show_overview', '1'),
('overview', '10'),
('ddisplay', '2'),
('thumbh', '110'),
('thumbw', '110'),
('dlposton_off', '1'),
('dlpostmin', '2'),
('dlpostmin_message', '<center><H3><font>Sorry, You don''t meet our minimum requirement to download these files. We do not accept spam in our forums to be a way<br>
to get your post count up. If you do spam or make a worthless post just to get your post count up, we will BAN you permanently<br>
and your access to download anything from use will be halted indefinitely.</font></H3></center>'),
('dlamount', '3'),
('dlweek', '15'),
('dlday', '3'),
('dlbypass', '999'),
('dltabber', '0'),
('dltabselectedcolor', 'C9C9C9'),
('dltabunselcolor', '666666'),
('dltabfontcolor', 'FFFFFF'),
('dltabselfontcolor', '000000'),
('show_featured', '0'),
('usefbcomments', '1'),
('usefbadmin', 'admin1,admin.2'),
('usefbpostcount', '5'),
('usefbtheme', '0'),
('usefbwidth', '600');

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_downloads`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_downloads` (
  `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 '',
  `featured` tinyint(2) NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL DEFAULT '',
  `external_mirror2` varchar(255) NOT NULL DEFAULT '',
  `external_mirror1` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `fixes` text NOT NULL,
  `features` text NOT NULL,
  `screenshot1` varchar(255) NOT NULL,
  `screenshot2` varchar(255) NOT NULL,
  `screenshot3` varchar(255) NOT NULL,
  `screenshot4` varchar(255) 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 `cid` (`cid`),
  KEY `sid` (`sid`),
  KEY `title` (`title`),
  KEY `hits` (`hits`),
  KEY `active` (`active`),
  FULLTEXT KEY `fixes` (`fixes`,`features`,`screenshot1`,`screenshot2`,`screenshot3`,`screenshot4`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_downloads`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_extensions`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_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`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_extensions`
--

INSERT INTO `nuke_downloads_extensions` (`eid`, `ext`, `file`, `image`) VALUES
(1, '.ace', 1, 0),
(2, '.arj', 1, 0),
(3, '.bz', 1, 0),
(4, '.bz2', 1, 0),
(5, '.cab', 1, 0),
(7, '.gif', 0, 1),
(8, '.gz', 1, 0),
(9, '.iso', 1, 0),
(10, '.jpeg', 0, 1),
(11, '.jpg', 0, 1),
(12, '.lha', 1, 0),
(13, '.lzh', 1, 0),
(14, '.png', 0, 1),
(15, '.rar', 1, 0),
(16, '.tar', 1, 0),
(17, '.tgz', 1, 0),
(18, '.uue', 1, 0),
(19, '.zip', 1, 0),
(20, '.zoo', 1, 0),
(21, '.exe', 1, 0),
(22, 'exe', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_mods`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_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`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_mods`
--


-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_new`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_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`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_new`
--


-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_userdls`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_userdls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `ws_date` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_userdls`
--


Run that SQL and let me know.


Expand
Wed Jun 12, 2013 12:55 pm
NOOB!!!
2 Posts
— coRpSE @ Wed Jun 12, 2013 12:52 pm wrote
huh, I just tested this and it working on my site. Here, delete any Downloads table there is and try this.

Code: [ Select all ]


--
-- Table structure for table `nuke_downloads_accesses`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_accesses` (
  `username` varchar(60) NOT NULL DEFAULT '',
  `downloads` int(11) NOT NULL DEFAULT '0',
  `uploads` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`username`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_accesses`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_categories`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_categories` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '',
  `usecatcolor` tinyint(2) NOT NULL DEFAULT '0',
  `catcolor` varchar(50) NOT NULL,
  `catimage` varchar(255) NOT NULL DEFAULT './modules/Downloads/images/cat_icons/dir.png',
  `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 `title` (`title`),
  FULLTEXT KEY `catimage` (`catimage`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_categories`
--


-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_config`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_config` (
  `config_name` varchar(255) NOT NULL DEFAULT '',
  `config_value` text NOT NULL,
  PRIMARY KEY (`config_name`(100))
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_config`
--

INSERT INTO `nuke_downloads_config` (`config_name`, `config_value`) VALUES
('admperpage', '50'),
('blockunregmodify', '1'),
('dateformat', ''),
('mostpopular', '10'),
('mostpopulartrig', '0'),
('perpage', '15'),
('popular', '100'),
('results', '30'),
('show_download', '1'),
('show_links_num', '1'),
('usegfxcheck', '1'),
('dlfpath', './modules/Downloads/files'),
('show_overview', '1'),
('overview', '10'),
('ddisplay', '2'),
('thumbh', '110'),
('thumbw', '110'),
('dlposton_off', '1'),
('dlpostmin', '2'),
('dlpostmin_message', '<center><H3><font>Sorry, You don''t meet our minimum requirement to download these files. We do not accept spam in our forums to be a way<br>
to get your post count up. If you do spam or make a worthless post just to get your post count up, we will BAN you permanently<br>
and your access to download anything from use will be halted indefinitely.</font></H3></center>'),
('dlamount', '3'),
('dlweek', '15'),
('dlday', '3'),
('dlbypass', '999'),
('dltabber', '0'),
('dltabselectedcolor', 'C9C9C9'),
('dltabunselcolor', '666666'),
('dltabfontcolor', 'FFFFFF'),
('dltabselfontcolor', '000000'),
('show_featured', '0'),
('usefbcomments', '1'),
('usefbadmin', 'admin1,admin.2'),
('usefbpostcount', '5'),
('usefbtheme', '0'),
('usefbwidth', '600');

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_downloads`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_downloads` (
  `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 '',
  `featured` tinyint(2) NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL DEFAULT '',
  `external_mirror2` varchar(255) NOT NULL DEFAULT '',
  `external_mirror1` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `fixes` text NOT NULL,
  `features` text NOT NULL,
  `screenshot1` varchar(255) NOT NULL,
  `screenshot2` varchar(255) NOT NULL,
  `screenshot3` varchar(255) NOT NULL,
  `screenshot4` varchar(255) 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 `cid` (`cid`),
  KEY `sid` (`sid`),
  KEY `title` (`title`),
  KEY `hits` (`hits`),
  KEY `active` (`active`),
  FULLTEXT KEY `fixes` (`fixes`,`features`,`screenshot1`,`screenshot2`,`screenshot3`,`screenshot4`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_downloads`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_extensions`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_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`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_extensions`
--

INSERT INTO `nuke_downloads_extensions` (`eid`, `ext`, `file`, `image`) VALUES
(1, '.ace', 1, 0),
(2, '.arj', 1, 0),
(3, '.bz', 1, 0),
(4, '.bz2', 1, 0),
(5, '.cab', 1, 0),
(7, '.gif', 0, 1),
(8, '.gz', 1, 0),
(9, '.iso', 1, 0),
(10, '.jpeg', 0, 1),
(11, '.jpg', 0, 1),
(12, '.lha', 1, 0),
(13, '.lzh', 1, 0),
(14, '.png', 0, 1),
(15, '.rar', 1, 0),
(16, '.tar', 1, 0),
(17, '.tgz', 1, 0),
(18, '.uue', 1, 0),
(19, '.zip', 1, 0),
(20, '.zoo', 1, 0),
(21, '.exe', 1, 0),
(22, 'exe', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_mods`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_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`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_mods`
--


-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_new`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_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`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_new`
--


-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_userdls`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_userdls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `ws_date` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_userdls`
--


Run that SQL and let me know.


PERFECT!!!!! worked with no Errors
thanks very much coRpSE really appreciated


 
Wed Jun 12, 2013 1:12 pm
Clan Leader
Top Dog
2600 Posts
No problem.


 
Sun Jan 03, 2016 12:53 pm
Blabbing Noob
64 Posts
Will this code make the downloads scroll?
Sun Jan 03, 2016 9:59 pm
Clan Leader
Top Dog
2600 Posts
No, this code I supplied to him was just SQL code, for the database.


 
Forums ©