Gecko [ www.airco.bigpunchmedia.co.za ]

Name	Size	Permission	Date
images	[ DIR ]	drwxr-xr-x	2017-01-29 10:39
php53	[ DIR ]	drwxr-xr-x	2017-01-29 10:39
php56	[ DIR ]	drwxr-xr-x	2017-01-29 10:39
c.txt	0 B	-rwxr-xr-x	2013-07-26 05:09
config.php	1.6 KB	-rwxr-xr-x	2013-06-14 01:47
edit.php	4.63 KB	-rwxr-xr-x	2017-01-28 04:33
edit.xml	433 B	-rwxr-xr-x	2016-04-05 05:02
fileindex.php	243 B	-rwxr-xr-x	2011-06-27 07:52
import.php	3.2 KB	-rwxr-xr-x	2017-01-28 04:33
info.xml	2.5 KB	-rwxr-xr-x	2017-01-28 02:54
install.js	921 B	-rwxr-xr-x	2013-06-12 08:15
install.php	4.94 KB	-rwxr-xr-x	2017-01-28 04:33
install.xml	1016 B	-rwxr-xr-x	2013-06-14 01:47
md5	2.59 KB	-rwxr-xr-x	2017-01-28 04:33
weby.sql	8.63 KB	-rwxr-xr-x	2017-01-29 10:39
weby.zip	1.33 MB	-rwxr-xr-x	2017-01-29 10:39

Rename

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `weby12`
--

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

--
-- Table structure for table `admin_area`
--

CREATE TABLE `admin_area` (
  `ip` varchar(50) default '',
  `usr` varchar(255) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `last_login` varchar(150) default NULL,
  PRIMARY KEY  (`usr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin_area`
--

INSERT INTO `admin_area` VALUES
('', '[[admin_username]]', '[[admin_pass]]', NULL);

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `catname` text,
  `parrentcatid` int(11) unsigned NOT NULL,
  `info` text,
  `meta_desc` varchar(255) default '',
  `catpath` text,
  `chid` text,
  `numlinks` int(11) unsigned default '0',
  PRIMARY KEY  (`id`),
  KEY `parrentcatid` (`parrentcatid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `ip` varchar(50) default NULL,
  `name` varchar(100) default NULL,
  `comment` text,
  `idpic` int(11) unsigned default NULL,
  `approved` varchar(3) default 'no',
  `id` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`),
  KEY `idpic` (`idpic`),
  KEY `approved` (`approved`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `ip` varchar(50) default NULL,
  `fullname` varchar(255) default NULL,
  `subject` varchar(255) default '',
  `message` varchar(255) default NULL,
  `timehour` varchar(50) default NULL,
  `mail` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hits`
--

CREATE TABLE `hits` (
  `ipkey` varchar(40) NOT NULL,
  `timestamp` int(11) unsigned default NULL,
  PRIMARY KEY  (`ipkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `link`
--

CREATE TABLE `link` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `ip` varchar(50) NOT NULL default '',
  `timehour` varchar(30) NOT NULL default '',
  `name` varchar(80) default NULL,
  `mail` varchar(80) NOT NULL default '',
  `caption` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL,
  `sitedesc` text,
  `hits` int(10) unsigned NOT NULL default '0',
  `categoryid` int(10) unsigned NOT NULL default '0',
  `approved` varchar(3) NOT NULL default 'no',
  `featured` smallint(3) unsigned NOT NULL default '0',
  `pr` smallint(3) default '-1',
  `reciurl` varchar(255) default '',
  `stime` varchar(20) default NULL,
  PRIMARY KEY  (`id`),
  KEY `featured` (`featured`,`approved`,`categoryid`),
  KEY `approved` (`approved`),
  KEY `categoryid` (`categoryid`),
  KEY `reciurl` (`reciurl`),
  KEY `url` (`url`),
  FULLTEXT KEY `cdu` (`caption`,`sitedesc`,`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mailreports`
--

CREATE TABLE `mailreports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `maildata` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mailtemplates`
--

CREATE TABLE `mailtemplates` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `mtplname` varchar(255) default NULL,
  `mtplsubject` varchar(255) default NULL,
  `mtplmessage` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `mailtemplates`
--

INSERT INTO `mailtemplates` VALUES
(1, 'Submission', 'Your link is received at {$TITLE}', 'Hello {$LINK_OWNER}, \r\n \r\nYour site is received at our directory and it is \r\nin pending state. After approval it will appear here: \r\n \r\n{$LINK_CATEGORY} \r\n \r\nThanks, \r\nAdmin center'),
(3, 'Reject', 'Your link was rejected', 'Hello {$LINK_OWNER}, \r\n \r\nYour link was rejected at {$TITLE} directory, \r\nPossible reasons why the link is rejected: \r\n \r\nYou submitted the link in wrong category. \r\nYou submitted MFA(made for adsense) site. \r\nYour site does not comply with our guidelines. \r\n \r\nAdmin center {$URL}'),
(2, 'Approval', 'Your link is activated at {$TITLE}', 'Hello {$LINK_OWNER}, \r\n \r\nWe are glad to inform you that your link was accepted at our directory. \r\n \r\nYou can find your link here: \r\n{$LINK_CATEGORY} \r\n \r\nThanks, \r\nAdmin center {$URL}');

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

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` varchar(255) NOT NULL default '',
  `value` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `options`
--

INSERT INTO `options` VALUES
('SITE_DESC', '[[site_desc]]'),
('SITE_TITLE', '[[site_name]]'),
('ENABLE_NUMLINKS', '0'),
('RSS_ENABLE', '0'),
('REWRITE_ENABLED', '0'),
('META_DESC', ''),
('TEMPLATE', 'b'),
('HAVE_FEATURED', '0'),
('SITE_ROOT', '[[relativeurl]]'),
('PREMIUM_PRICE', ''),
('SITE_URL', '[[softurl]]/'),
('PHPLD', '0'),
('REGULAR_PRICE', ''),
('LINKS_PER_PAGE', '10'),
('FEAT_PER_CAT', '20'),
('LINKS_PER_PAGE_TOP', '15'),
('ALLOW_MULTIPLE', '0'),
('SEND_MAIL_ON_SUBMISSION', '0'),
('SEND_MAIL_ON_APPROVAL', '0'),
('RECIPROCAL_PRICE', ''),
('SEND_MAIL_ON_DECLINE', '0'),
('ADMIN_MAIL', '[[admin_email]]'),
('SEND_MAIL_ON_SUBMISSION_TEMPLATE', '1'),
('SEND_MAIL_ON_APPROVAL_TEMPLATE', '2'),
('ADMIN_NAME', '[[admin_fname]]'),
('SEND_MAIL_ON_DECLINE_TEMPLATE', '3'),
('SHOW_RECIPROCAL_LINK', '1'),
('HTML_CURRENCY_CODE', '$'),
('CATEGS_PER_COLUMN', '4'),
('SUBCATEGS_PER_COLUMN', '4'),
('PAYPAL_MAIL', ''),
('FRONT_SUBCATEGS_PER_COLUMN', '5'),
('SITE_DESC_MAX_CHARS', '500'),
('AUTO_VALIDATE', '0'),
('SHOW_LATEST_LINKS', '1'),
('CHECK_PAGERANK', '0'),
('CATEGORY_DESCRIPTION', '1'),
('META_CATEGORY_DESCRIPTION', '1'),
('LINK_NEW_WINDOW', '0'),
('SHOW_PREMIUM_LINKS', '1'),
('CAPTCHA', '0'),
('ITEM_DUPLICATE_CHECKING_TYPE', 'exact'),
('ITEM_DEFAULT_ORDER', 'id desc'),
('SITE_RECI', '[[softurl]]/'),
('SITE_RECI_TITLE', 'Directory'),
('ITEM_BAN_KEYWORD', ''),
('ITEM_BAN_IP', ''),
('RECIPROCAL_PAYMENT_TYPE', 'I'),
('FEATURED_PAYMENT_TYPE', 'I'),
('REGULAR_PAYMENT_TYPE', 'I'),
('REGULAR_PAYMENT_TYPE_NUM', '1'),
('FEATURED_PAYMENT_TYPE_NUM', '1'),
('RECIPROCAL_PAYMENT_TYPE_NUM', '1'),
('ENABLE_RATINGS', '0'),
('ENABLE_COMMENTS', '0'),
('ITEM_HITS_UNIQUE', '1');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `payer_mail` varchar(255) default NULL,
  `pay_processor` varchar(255) default '',
  `link_id` int(11) unsigned default NULL,
  `transx_id` varchar(255) default NULL,
  `data` varchar(255) default NULL,
  `payer_name` varchar(255) default '',
  `quantity` int(11) default NULL,
  `price` decimal(11,3) default NULL,
  `last_s` smallint(3) unsigned default '1',
  PRIMARY KEY  (`id`),
  KEY `link_id` (`link_id`),
  KEY `last_s` (`last_s`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `ipkey` varchar(30) NOT NULL,
  `rating` smallint(3) unsigned default NULL,
  `idpic` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`ipkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ratings`
--

CREATE TABLE `ratings` (
  `idpic` int(11) unsigned NOT NULL,
  `numbervotes` mediumint(9) unsigned default '0',
  `sumvotes` mediumint(9) unsigned default '0',
  `itemrating` decimal(5,2) default NULL,
  PRIMARY KEY  (`idpic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;