OK here is the link for the conntest.php
http://www.jsm-inc.com/nuke/html/conntest.php
And here is a snippet of the sql file I used for creating DB
#
# Table structure for table `nuke_downloads_categories`
#
CREATE TABLE nuke_downloads_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',
PRIMARY KEY (cid),
KEY cid (cid),
KEY title (title)
) TYPE=MyISAM;
#
# Dumping data for table `nuke_downloads_categories`
#
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads_downloads`
#
CREATE TABLE 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 '',
url varchar(100) NOT NULL default '',
description text NOT NULL,
date datetime default NULL,
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 '',
downloadratingsummary double(6,4) NOT NULL default '0.0000',
totalvotes int(11) NOT NULL default '0',
totalcomments int(11) NOT NULL default '0',
filesize int(11) NOT NULL default '0',
version varchar(10) NOT NULL default '',
homepage varchar(200) NOT NULL default '',
PRIMARY KEY (lid),
KEY lid (lid),
KEY cid (cid),
KEY sid (sid),
KEY title (title)
) TYPE=MyISAM;
#
# Dumping data for table `nuke_downloads_downloads`
#
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads_editorials`
#
CREATE TABLE nuke_downloads_editorials (
downloadid int(11) NOT NULL default '0',
adminid varchar(60) NOT NULL default '',
editorialtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
editorialtext text NOT NULL,
editorialtitle varchar(100) NOT NULL default '',
PRIMARY KEY (downloadid),
KEY downloadid (downloadid)
) TYPE=MyISAM;
#
# Dumping data for table `nuke_downloads_editorials`
#
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads_modrequest`
#
CREATE TABLE nuke_downloads_modrequest (
requestid 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(100) NOT NULL default '',
description text NOT NULL,
modifysubmitter varchar(60) NOT NULL default '',
brokendownload int(3) NOT NULL default '0',
name varchar(100) NOT NULL default '',
email varchar(100) NOT NULL default '',
filesize int(11) NOT NULL default '0',
version varchar(10) NOT NULL default '',
homepage varchar(200) NOT NULL default '',
PRIMARY KEY (requestid),
UNIQUE KEY requestid (requestid)
) TYPE=MyISAM;
#
# Dumping data for table `nuke_downloads_modrequest`
#
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads_newdownload`
#
CREATE TABLE nuke_downloads_newdownload (
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(100) NOT NULL default '',
description text NOT NULL,
name varchar(100) NOT NULL default '',
email varchar(100) NOT NULL default '',
submitter varchar(60) NOT NULL default '',
filesize int(11) NOT NULL default '0',
version varchar(10) NOT NULL default '',
homepage varchar(200) NOT NULL default '',
PRIMARY KEY (lid),
KEY lid (lid),
KEY cid (cid),
KEY sid (sid),
KEY title (title)
) TYPE=MyISAM;
#
# Dumping data for table `nuke_downloads_newdownload`
#
# --------------------------------------------------------
#
# Table structure for table `nuke_downloads_votedata`
#
CREATE TABLE nuke_downloads_votedata (
ratingdbid int(11) NOT NULL auto_increment,
ratinglid int(11) NOT NULL default '0',
ratinguser varchar(60) NOT NULL default '',
rating int(11) NOT NULL default '0',
ratinghostname varchar(60) NOT NULL default '',
ratingcomments text NOT NULL,
ratingtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (ratingdbid),
KEY ratingdbid (ratingdbid)
) TYPE=MyISAM;
#
# Dumping data for table `nuke_downloads_votedata`
#
# --------------------------------------------------------