Advanced Downloads V1.2.1
Select messages from # through # Forum FAQ
[/[Print]\]

HeadShot Extreme -> Nuke Blocks / Modules Support
#1: No icon Advanced Downloads V1.2.1 Author: BODYBAGS_UK,  PostPosted: Wed Jun 12, 2013 8:29 am
    —
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
#2: No icon Re: Advanced Downloads V1.2.1 Author: [HSX]coRpSE, Location: Back of your mind!!! PostPosted: Wed Jun 12, 2013 11:52 am
    —
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.
#3: No icon Re: Advanced Downloads V1.2.1 Author: BODYBAGS_UK,  PostPosted: Wed Jun 12, 2013 12:55 pm
    —
— 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
#4: No icon Re: Advanced Downloads V1.2.1 Author: [HSX]coRpSE, Location: Back of your mind!!! PostPosted: Wed Jun 12, 2013 1:12 pm
    —
No problem.
#5: No icon Re: Advanced Downloads V1.2.1 Author: MAGNET,  PostPosted: Sun Jan 03, 2016 12:53 pm
    —
Will this code make the downloads scroll?
#6: No icon Re: Advanced Downloads V1.2.1 Author: [HSX]coRpSE, Location: Back of your mind!!! PostPosted: Sun Jan 03, 2016 9:59 pm
    —
No, this code I supplied to him was just SQL code, for the database.
HeadShot Extreme -> Nuke Blocks / Modules Support


output generated using printer-friendly topic mod. All times are GMT - 7 Hours

Page 1 of 1