<?
/*
Decoded by SplitIce ioncube decoder
========================================
Version: 0.8.1
Site: http://thewarezscene.org/decoder/
Free for non commercial code recovery.
========================================
=<[2009]>=
*/
error_reporting(0);
ob_start(/* No args for function 1 */);
$msg = 'The <em>include</em> Folder is not writable!';
}
$msg = '';
default:
$license_key = $_POST[key_string];
$error_text['disabled'] = '<p><strong>License Error:</strong> Your license is disabled. Please contact your software vendor for support.</p>';
$error_text['suspended'] = '<p><strong>License Error:</strong> Your license has been suspended. Please contact your software vendor for support.</p>';
$error_text['expired'] = '<p><strong>License Error:</strong> Your license has expired. Please contact your software vendor for support.</p>';
$error_text['invalid_user'] = '<p><strong>License Error:</strong> Invalid license key. Please contact your software vendor for support.</p>';
$error_text['invalid_code'] = '<p><strong>License Error:</strong> Invalid license status code. Please contact your software vendor for support.</p>';
$error_text['invalid_hash'] = '<p><strong>License Error:</strong> Invalid communication hash. Please contact your software vendor for support.</p>';
$error_text['wrong_product'] = '<p><strong>License Error:</strong> The license key you provided is not for this product. Please contact your software vendor for support.</p>';
$home_url_site = 'phplemon.com';
$home_url_port = 80;
$home_url_iono = '/license/remote.php';
$user_defined_string = 'db043bdef0d2';
$comm_terminate = true;
$license_terminate = true;
$product_license_id = 1;
$key_parts = explode('-',$license_key,$/* Unknown var 60 */);
$product_id = array(substr($md5($product_license_id,$/* Unknown var 64 */),0,8));
}
/* Unknown opcode: 70 (ZEND_FREE) */
}
$request = 'remote=licenses&type=1&license_key='.urlencode($base64_encode($license_key,$/* Unknown var 80 */));
$request .= '&host_ip='.urlencode($base64_encode($_SERVER['SERVER_ADDR'],$/* GET VALUE OF ARGUMENT, WTF? */)).'&host_name='.urlencode($base64_encode($_SERVER['SERVER_NAME'],$/* GET VALUE OF ARGUMENT, WTF? */));
$request .= '&hash='.urlencode($base64_encode($md5($request,$/* Unknown var 99 */)));
$request = $home_url_iono.'?'.$request;
/* Unknown opcode: 54 (ZEND_ADD_CHAR) */
$header = "GET {$request} HTTP/1.0
Host: {$home_url_site}
Connection: Close
User-Agent: iono (www.olate.co.uk/iono)
";
$header .= '
';
$fpointer = @fsockopen($home_url_site,$/* Unknown var 120 */,$home_url_port,$/* Unknown var 121 */,$errno,$/* Unknown var 122 */,$errstr,$/* Unknown var 123 */,5);
$return = '';
@fwrite($fpointer,$/* Unknown var 130 */,$header,$/* Unknown var 131 */);
$return .= @fread($fpointer,$/* Unknown var 139 */,1024);
}
@fclose($fpointer,$/* Unknown var 143 */);
}
}
/* Unknown opcode: 70 (ZEND_FREE) */
$content = explode('
',$return,$/* Unknown var 149 */);
$content = explode($content[0],$/* GET VALUE OF ARGUMENT, WTF? */,$return,$/* Unknown var 155 */);
$content = explode('-',$content[1],$/* GET VALUE OF ARGUMENT, WTF? */);
$status = $content[0];
$hash = $content[1];
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
}
/* Unknown opcode: 70 (ZEND_FREE) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
}
/* Unknown opcode: 70 (ZEND_FREE) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
}
/* Unknown opcode: 70 (ZEND_FREE) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
}
/* Unknown opcode: 70 (ZEND_FREE) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
}
/* Unknown opcode: 70 (ZEND_FREE) */
}
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
}
/* Unknown opcode: 70 (ZEND_FREE) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
/* Unknown opcode: 74 (ZEND_UNSET_VAR) */
$db_con = "<?php
$host_name = \'{$_POST['server_name']}\';
$db_user = \'{$_POST['dbuser']}\';
$db_pass = \'{$_POST['dbpass']}\';
$db_name = \'{$_POST['dbname']}\';
$con = mysql_connect($host_name, $db_user, $db_pass);
if (!$con) {
die(\'Could not connect: \' . mysql_error());
}
$db_selected = mysql_select_db($db_name, $con);
if (!$db_selected) {
die (\'Can not use database : \' . mysql_error());
}
?>";
@unlink('../include/db_connection.php');
}
$fp = fopen('../include/db_connection.php','w');
fwrite($fp,$/* Unknown var 316 */,$db_con,$/* Unknown var 317 */);
fclose($fp,$/* Unknown var 319 */);
include('../include/db_connection.php');
mysql_query("update configurations set value=\'{$_POST['key_string']}\' where name = \'key_string\' ");
header('location: ../admin/?pref&install_success');
}
$msg .= '<br>Error executing SQL file! <br>'.mysql_error(/* No args for function 36 */);
}
$msg .= '<br>Error Creating DB connection file!';
}
$msg .= '<br>Incorrect Database name!';
}
$msg .= '<br>Incorrect Database user/pass!';
ob_end_clean(/* No args for function 37 */);
function startparsing() {
$site_full_url = dirname($dirname($_SERVER['HTTP_REFERER'],$/* GET VALUE OF ARGUMENT, WTF? */));
}
$site_full_url = dirname($_SERVER['HTTP_REFERER'],$/* GET VALUE OF ARGUMENT, WTF? */);
$content = "
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 04, 2007 at 04:25 PM
-- Server version: 5.0.27
-- PHP Version: 5.2.0
--
-- Database: `adquick`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`user` varchar(50) collate utf8_unicode_ci NOT NULL,
`pass` varchar(50) collate utf8_unicode_ci NOT NULL,
`balance` float NOT NULL,
`last_login` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`email` varchar(255) collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` VALUES (\'admin\', \'admin\', 0, \'2007-11-08 20:18:19\', \'\');
-- --------------------------------------------------------
--
-- Table structure for table `admin_earnings`
--
DROP TABLE IF EXISTS `admin_earnings`;
CREATE TABLE `admin_earnings` (
`date` date NOT NULL,
`earning` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `admin_earnings`
--
-- --------------------------------------------------------
--
-- Table structure for table `adquick_hits`
--
DROP TABLE IF EXISTS `adquick_hits`;
CREATE TABLE `adquick_hits` (
`hit_id` bigint(20) NOT NULL auto_increment,
`date` date NOT NULL,
`ip` varchar(20) collate utf8_unicode_ci NOT NULL,
`ip_detail` varchar(255) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`hit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `adquick_hits`
--
-- --------------------------------------------------------
--
-- Table structure for table `adv_campaign`
--
DROP TABLE IF EXISTS `adv_campaign`;
CREATE TABLE `adv_campaign` (
`cmp_id` bigint(20) NOT NULL auto_increment,
`uid` bigint(20) NOT NULL,
`title` tinytext collate utf8_unicode_ci NOT NULL,
`geo_target` text collate utf8_unicode_ci,
`cat_target` text collate utf8_unicode_ci,
`key_target` text collate utf8_unicode_ci,
`lang_target` int(11) NOT NULL default \'0\',
`is_adult` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
`total_budget` float NOT NULL,
`max_cpc` float NOT NULL,
`daily_budget` float NOT NULL,
`expense_today` float NOT NULL,
`last_click_date` date NOT NULL,
`remaining_budget` float NOT NULL,
`ad_type` tinytext collate utf8_unicode_ci NOT NULL,
`site_name` tinytext collate utf8_unicode_ci NOT NULL,
`ad_hl` text collate utf8_unicode_ci NOT NULL,
`ad_des` text collate utf8_unicode_ci NOT NULL,
`ad_url` text collate utf8_unicode_ci NOT NULL,
`ad_img` tinytext collate utf8_unicode_ci NOT NULL,
`size` int(11) NOT NULL default \'0\',
`buying_date` date NOT NULL,
`start_date` date NOT NULL,
`approved` enum(\'Y\',\'N\',\'R\') collate utf8_unicode_ci NOT NULL default \'N\',
`refuse_reason` text collate utf8_unicode_ci NOT NULL,
`is_paid` enum(\'Y\',\'N\',\'A\') collate utf8_unicode_ci NOT NULL default \'N\',
`is_auth` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
`is_shown` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
`is_emailed` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
PRIMARY KEY (`cmp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `adv_campaign`
--
-- --------------------------------------------------------
--
-- Table structure for table `advertisersinfo`
--
DROP TABLE IF EXISTS `advertisersinfo`;
CREATE TABLE `advertisersinfo` (
`adv_id` bigint(20) NOT NULL auto_increment,
`uid` bigint(20) NOT NULL,
`pub_uid` bigint(20) NOT NULL,
`pid` bigint(20) NOT NULL,
`ad_type` tinytext collate utf8_unicode_ci NOT NULL,
`ad_id` bigint(20) NOT NULL,
`site_name` tinytext collate utf8_unicode_ci NOT NULL,
`ad_hl` text collate utf8_unicode_ci NOT NULL,
`ad_des` text collate utf8_unicode_ci NOT NULL,
`ad_url` text collate utf8_unicode_ci NOT NULL,
`ad_img` tinytext collate utf8_unicode_ci NOT NULL,
`price` float NOT NULL,
`ppc_balance` float NOT NULL,
`total_budget` float NOT NULL,
`req_date` date NOT NULL,
`buying_date` date NOT NULL,
`money_sent_to_pub` date NOT NULL,
`start_date` date NOT NULL,
`end_date` date NOT NULL,
`approved` enum(\'Y\',\'N\',\'R\') collate utf8_unicode_ci NOT NULL default \'N\',
`refuse_reason` text collate utf8_unicode_ci NOT NULL,
`is_paid` enum(\'Y\',\'N\',\'A\') collate utf8_unicode_ci NOT NULL default \'N\',
`is_auth` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
`is_shown` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
`is_emailed` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
PRIMARY KEY (`adv_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `advertisersinfo`
--
-- --------------------------------------------------------
--
-- Table structure for table `advertisersinfo_edit`
--
DROP TABLE IF EXISTS `advertisersinfo_edit`;
CREATE TABLE `advertisersinfo_edit` (
`adv_id` bigint(20) NOT NULL,
`uid` bigint(20) NOT NULL,
`ad_id` bigint(20) NOT NULL,
`site_name` tinytext collate utf8_unicode_ci NOT NULL,
`ad_hl` text collate utf8_unicode_ci NOT NULL,
`ad_des` text collate utf8_unicode_ci NOT NULL,
`ad_url` text collate utf8_unicode_ci NOT NULL,
`ad_img` tinytext collate utf8_unicode_ci NOT NULL,
`req_date` date NOT NULL,
`approved` enum(\'Y\',\'N\',\'R\') collate utf8_unicode_ci NOT NULL default \'N\',
`refuse_reason` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`adv_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `advertisersinfo_edit`
--
-- --------------------------------------------------------
--
-- Table structure for table `category`
--
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`cid` int(11) NOT NULL auto_increment,
`category` varchar(100) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `category`
--
-- --------------------------------------------------------
--
-- Table structure for table `configurations`
--
DROP TABLE IF EXISTS `configurations`;
CREATE TABLE `configurations` (
`name` varchar(255) collate utf8_unicode_ci NOT NULL,
`value` tinytext collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `configurations`
--
INSERT INTO `configurations` VALUES (\'lang\', \'English\');
INSERT INTO `configurations` VALUES (\'template\', \'default\');
INSERT INTO `configurations` VALUES (\'currency\', \'$\');
INSERT INTO `configurations` VALUES (\'www\', \'{$site_full_url}\');
INSERT INTO `configurations` VALUES (\'featured_rate\', \'19.99\');
INSERT INTO `configurations` VALUES (\'PayPal\', \'parbon@gmail.com\');
INSERT INTO `configurations` VALUES (\'2CO\', \'106919\');
INSERT INTO `configurations` VALUES (\'Setcom\', \'1234567891\');
INSERT INTO `configurations` VALUES (\'pay_method\', \'PayPal\');
INSERT INTO `configurations` VALUES (\'CURRENCY_CODE\', \'USD\');
INSERT INTO `configurations` VALUES (\'default_pay_rate\', \'80\');
INSERT INTO `configurations` VALUES (\'website_name\', \'AdQuick 2.1\');
INSERT INTO `configurations` VALUES (\'admin_email\', \'test2@ad.com\');
INSERT INTO `configurations` VALUES (\'max_featured\', \'6\');
INSERT INTO `configurations` VALUES (\'min_pub_payout\', \'20.00\');
INSERT INTO `configurations` VALUES (\'approve_new_user\', \'no\');
INSERT INTO `configurations` VALUES (\'approve_new_site\', \'no\');
INSERT INTO `configurations` VALUES (\'get_email_notification\', \'no\');
INSERT INTO `configurations` VALUES (\'key_string\', \'123456\');
INSERT INTO `configurations` VALUES (\'video_ad\', \'off\');
INSERT INTO `configurations` VALUES (\'popunder_ad\', \'off\');
INSERT INTO `configurations` VALUES (\'inline_ad\', \'off\');
INSERT INTO `configurations` VALUES (\'invideo_ad\', \'off\');
INSERT INTO `configurations` VALUES (\'fullpage_ad\', \'off\');
INSERT INTO `configurations` VALUES (\'ePassport_pi_code\', \'123\');
INSERT INTO `configurations` VALUES (\'ePassport_acc_num\', \'test\');
INSERT INTO `configurations` VALUES (\'google_merchant_id\', \'1234567#89\');
INSERT INTO `configurations` VALUES (\'moneybookers_email\', \'test@mo#neybookers.com\');
INSERT INTO `configurations` VALUES (\'alertpay_acc\', \'23424324234#\');
INSERT INTO `configurations` VALUES (\'moneywindow_acc\', \'35422352354325#\');
INSERT INTO `configurations` VALUES (\'min_gpr\', \'0\');
INSERT INTO `configurations` VALUES (\'max_alexa\', \'0\');
INSERT INTO `configurations` VALUES (\'BankTransfer\', \'BankTransfer info here...\');
-- --------------------------------------------------------
--
-- Table structure for table `country`
--
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
`countrysel` int(11) NOT NULL auto_increment,
`country` varchar(100) collate utf8_unicode_ci NOT NULL,
`status` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'Y\',
PRIMARY KEY (`countrysel`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=221 ;
--
-- Dumping data for table `country`
--
INSERT INTO `country` VALUES (5, \'Jamaica\', \'Y\');
INSERT INTO `country` VALUES (6, \'Guatemala\', \'Y\');
INSERT INTO `country` VALUES (7, \'Belize\', \'Y\');
INSERT INTO `country` VALUES (8, \'Honduras\', \'Y\');
INSERT INTO `country` VALUES (9, \'El Salvador\', \'Y\');
INSERT INTO `country` VALUES (10, \'Nicaragua\', \'Y\');
INSERT INTO `country` VALUES (11, \'Costa Rica\', \'Y\');
INSERT INTO `country` VALUES (12, \'Panama\', \'Y\');
INSERT INTO `country` VALUES (13, \'Cuba\', \'Y\');
INSERT INTO `country` VALUES (14, \'Bahamas\', \'Y\');
INSERT INTO `country` VALUES (15, \'Haiti\', \'Y\');
INSERT INTO `country` VALUES (16, \'Dominican Republic\', \'Y\');
INSERT INTO `country` VALUES (17, \'Puerto Rico\', \'Y\');
INSERT INTO `country` VALUES (18, \'Us Virgin Islands\', \'Y\');
INSERT INTO `country` VALUES (19, \'Anguilla\', \'Y\');
INSERT INTO `country` VALUES (20, \'Antigua and Barbuda\', \'Y\');
INSERT INTO `country` VALUES (21, \'Netherlands Antilles\', \'Y\');
INSERT INTO `country` VALUES (22, \'Aruba\', \'Y\');
INSERT INTO `country` VALUES (23, \'Saint Kitts\', \'Y\');
INSERT INTO `country` VALUES (24, \'Montserrat\', \'Y\');
INSERT INTO `country` VALUES (25, \'Guadeloupe\', \'Y\');
INSERT INTO `country` VALUES (26, \'Dominica\', \'Y\');
INSERT INTO `country` VALUES (27, \'Martinique\', \'Y\');
INSERT INTO `country` VALUES (28, \'SaintLucia\', \'Y\');
INSERT INTO `country` VALUES (29, \'SaintVincent\', \'Y\');
INSERT INTO `country` VALUES (30, \'Grenada\', \'Y\');
INSERT INTO `country` VALUES (31, \'Trinidad and Tobago\', \'Y\');
INSERT INTO `country` VALUES (32, \'Barbados\', \'Y\');
INSERT INTO `country` VALUES (33, \'Galapagos Islands\', \'Y\');
INSERT INTO `country` VALUES (34, \'Ecuador\', \'Y\');
INSERT INTO `country` VALUES (35, \'Colombia\', \'Y\');
INSERT INTO `country` VALUES (36, \'Venezuela\', \'Y\');
INSERT INTO `country` VALUES (37, \'Guyana\', \'Y\');
INSERT INTO `country` VALUES (38, \'Suriname\', \'Y\');
INSERT INTO `country` VALUES (39, \'French Guiana\', \'Y\');
INSERT INTO `country` VALUES (40, \'Peru\', \'Y\');
INSERT INTO `country` VALUES (41, \'Bolivia\', \'Y\');
INSERT INTO `country` VALUES (42, \'Paraguay\', \'Y\');
INSERT INTO `country` VALUES (43, \'Brazil\', \'Y\');
INSERT INTO `country` VALUES (44, \'Uruguay\', \'Y\');
INSERT INTO `country` VALUES (45, \'Argentina\', \'Y\');
INSERT INTO `country` VALUES (46, \'Chile\', \'Y\');
INSERT INTO `country` VALUES (47, \'Falkland Islands\', \'Y\');
INSERT INTO `country` VALUES (48, \'South Georgia\', \'Y\');
INSERT INTO `country` VALUES (49, \'Australia\', \'Y\');
INSERT INTO `country` VALUES (50, \'New Zealand\', \'Y\');
INSERT INTO `country` VALUES (51, \'Palau (PA)\', \'Y\');
INSERT INTO `country` VALUES (52, \'Guam (GU)\', \'Y\');
INSERT INTO `country` VALUES (53, \'N.Mariana Islands (MA)\', \'Y\');
INSERT INTO `country` VALUES (54, \'Micronesia (MI)\', \'Y\');
INSERT INTO `country` VALUES (55, \'Nauru (NA)\', \'Y\');
INSERT INTO `country` VALUES (56, \'Marshall Islands (MI)\', \'Y\');
INSERT INTO `country` VALUES (57, \'Papua-New.Guinea (PG)\', \'Y\');
INSERT INTO `country` VALUES (58, \'Hawaii (HI)\', \'Y\');
INSERT INTO `country` VALUES (59, \'Tuvalu (TU)\', \'Y\');
INSERT INTO `country` VALUES (60, \'Fiji (FI)\', \'Y\');
INSERT INTO `country` VALUES (61, \'Vanuatu (VA)\', \'Y\');
INSERT INTO `country` VALUES (62, \'New Caledonia (NC)\', \'Y\');
INSERT INTO `country` VALUES (63, \'Solomon Islands (SI)\', \'Y\');
INSERT INTO `country` VALUES (64, \'Kiribati (KI)\', \'Y\');
INSERT INTO `country` VALUES (65, \'Western Samoa (WS)\', \'Y\');
INSERT INTO `country` VALUES (66, \'Cook Islands (CI)\', \'Y\');
INSERT INTO `country` VALUES (67, \'French Polynesia (FP)\', \'Y\');
INSERT INTO `country` VALUES (68, \'Tonga (TO)\', \'Y\');
INSERT INTO `country` VALUES (69, \'Cyprus\', \'Y\');
INSERT INTO `country` VALUES (70, \'Lebanon\', \'Y\');
INSERT INTO `country` VALUES (71, \'Israel\', \'Y\');
INSERT INTO `country` VALUES (72, \'Turkey\', \'Y\');
INSERT INTO `country` VALUES (73, \'Palestine\', \'Y\');
INSERT INTO `country` VALUES (74, \'Egypt\', \'Y\');
INSERT INTO `country` VALUES (75, \'Jordan\', \'Y\');
INSERT INTO `country` VALUES (76, \'Syria\', \'Y\');
INSERT INTO `country` VALUES (77, \'Saudi-Arabia\', \'Y\');
INSERT INTO `country` VALUES (78, \'Yemen\', \'Y\');
INSERT INTO `country` VALUES (79, \'Oman\', \'Y\');
INSERT INTO `country` VALUES (80, \'United-Arab-Emirates\', \'Y\');
INSERT INTO `country` VALUES (81, \'Iraq\', \'Y\');
INSERT INTO `country` VALUES (82, \'Qatar\', \'Y\');
INSERT INTO `country` VALUES (83, \'Bahrain\', \'Y\');
INSERT INTO `country` VALUES (84, \'Kuwait\', \'Y\');
INSERT INTO `country` VALUES (85, \'Iran\', \'Y\');
INSERT INTO `country` VALUES (86, \'Azerbaijan\', \'Y\');
INSERT INTO `country` VALUES (87, \'Armenia\', \'Y\');
INSERT INTO `country` VALUES (88, \'Georgia\', \'Y\');
INSERT INTO `country` VALUES (89, \'Italy (ITA)\', \'Y\');
INSERT INTO `country` VALUES (90, \'Germany (GER)\', \'Y\');
INSERT INTO `country` VALUES (91, \'Iceland (ISL)\', \'Y\');
INSERT INTO `country` VALUES (92, \'Faroe Islands (FAR)\', \'Y\');
INSERT INTO `country` VALUES (93, \'Ireland (IRE)\', \'Y\');
INSERT INTO `country` VALUES (94, \'United Kingdom (UK)\', \'Y\');
INSERT INTO `country` VALUES (95, \'Norway (NOR)\', \'Y\');
INSERT INTO `country` VALUES (96, \'Sweden (SWE)\', \'Y\');
INSERT INTO `country` VALUES (97, \'Finland (FIN)\', \'Y\');
INSERT INTO `country` VALUES (98, \'Estonio (EST)\', \'Y\');
INSERT INTO `country` VALUES (99, \'Denmark (DEN)\', \'Y\');
INSERT INTO `country` VALUES (100, \'Netherlands (NL)\', \'Y\');
INSERT INTO `country` VALUES (101, \'Belgium (BEL)\', \'Y\');
INSERT INTO `country` VALUES (102, \'Latvia (LAT)\', \'Y\');
INSERT INTO `country` VALUES (103, \'Lithuania (LTU)\', \'Y\');
INSERT INTO `country` VALUES (104, \'Poland (POL)\', \'Y\');
INSERT INTO `country` VALUES (105, \'Belarus (BLR)\', \'Y\');
INSERT INTO `country` VALUES (106, \'Czech Republic (CZE)\', \'Y\');
INSERT INTO `country` VALUES (107, \'Slovakia (SVK)\', \'Y\');
INSERT INTO `country` VALUES (108, \'Moldava (MDA)\', \'Y\');
INSERT INTO `country` VALUES (109, \'Ukraine (UKR)\', \'Y\');
INSERT INTO `country` VALUES (110, \'Cyprus (CYP)\', \'Y\');
INSERT INTO `country` VALUES (111, \'Malta (MLT)\', \'Y\');
INSERT INTO `country` VALUES (112, \'Georgia (GEO)\', \'Y\');
INSERT INTO `country` VALUES (113, \'Armenia (ARM)\', \'Y\');
INSERT INTO `country` VALUES (114, \'Azerbaijan (AZE)\', \'Y\');
INSERT INTO `country` VALUES (115, \'Turkey (TUR)\', \'Y\');
INSERT INTO `country` VALUES (116, \'Russia (RUS)\', \'Y\');
INSERT INTO `country` VALUES (117, \'Greece (GRE)\', \'Y\');
INSERT INTO `country` VALUES (118, \'Albania (ALB)\', \'Y\');
INSERT INTO `country` VALUES (119, \'Macedonia (MKD)\', \'Y\');
INSERT INTO `country` VALUES (120, \'Bulgaria (BUL)\', \'Y\');
INSERT INTO `country` VALUES (121, \'Spain (ESP)\', \'Y\');
INSERT INTO `country` VALUES (122, \'Andorra (AND)\', \'Y\');
INSERT INTO `country` VALUES (123, \'Monaco (MON)\', \'Y\');
INSERT INTO `country` VALUES (124, \'France (FRA)\', \'Y\');
INSERT INTO `country` VALUES (125, \'Luxembourg (LUX)\', \'Y\');
INSERT INTO `country` VALUES (126, \'Switzerland (SUI)\', \'Y\');
INSERT INTO `country` VALUES (127, \'Austria (AUT)\', \'Y\');
INSERT INTO `country` VALUES (128, \'Slovenia (SLO)\', \'Y\');
INSERT INTO `country` VALUES (129, \'Hungary (HUN)\', \'Y\');
INSERT INTO `country` VALUES (130, \'Croatia (CRO)\', \'Y\');
INSERT INTO `country` VALUES (131, \'Bosnia-Herzegovina (BIH)\', \'Y\');
INSERT INTO `country` VALUES (132, \'Romania (ROM)\', \'Y\');
INSERT INTO `country` VALUES (133, \'Yugoslavia (YUG)\', \'Y\');
INSERT INTO `country` VALUES (134, \'Liechtenstein (LIE)\', \'Y\');
INSERT INTO `country` VALUES (135, \'Canary Islands\', \'Y\');
INSERT INTO `country` VALUES (136, \'Algeria (ALG)\', \'Y\');
INSERT INTO `country` VALUES (137, \'Morocco (MAR)\', \'Y\');
INSERT INTO `country` VALUES (138, \'Western-Sahara (WES)\', \'Y\');
INSERT INTO `country` VALUES (139, \'Mali (MLI)\', \'Y\');
INSERT INTO `country` VALUES (140, \'Mauritania (MTN)\', \'Y\');
INSERT INTO `country` VALUES (141, \'Senegal (SEN)\', \'Y\');
INSERT INTO `country` VALUES (142, \'Nigeria (NGR)\', \'Y\');
INSERT INTO `country` VALUES (143, \'Benin (BEN)\', \'Y\');
INSERT INTO `country` VALUES (144, \'Burkina-Faso (BUR)\', \'Y\');
INSERT INTO `country` VALUES (145, \'Gambia (GAM)\', \'Y\');
INSERT INTO `country` VALUES (146, \'Guinea-Bissau (GBS)\', \'Y\');
INSERT INTO `country` VALUES (147, \'Tunisia (TUN)\', \'Y\');
INSERT INTO `country` VALUES (148, \'Libya (LBA)\', \'Y\');
INSERT INTO `country` VALUES (149, \'Niger (NIG)\', \'Y\');
INSERT INTO `country` VALUES (150, \'Chad (CHA)\', \'Y\');
INSERT INTO `country` VALUES (151, \'Egypt (EGY)\', \'Y\');
INSERT INTO `country` VALUES (152, \'Guinea (GUI)\', \'Y\');
INSERT INTO `country` VALUES (153, \'Sierra-Leone (SLE)\', \'Y\');
INSERT INTO `country` VALUES (154, \'Liberia (LBR)\', \'Y\');
INSERT INTO `country` VALUES (155, \'Cote-Divoire (CIV)\', \'Y\');
INSERT INTO `country` VALUES (156, \'Togo (TOG)\', \'Y\');
INSERT INTO `country` VALUES (157, \'Equatorial-Guinea (EGU)\', \'Y\');
INSERT INTO `country` VALUES (158, \'Central African Republic (CAF)\', \'Y\');
INSERT INTO `country` VALUES (159, \'Cameroon (CMR)\', \'Y\');
INSERT INTO `country` VALUES (160, \'Sudan (SUD)\', \'Y\');
INSERT INTO `country` VALUES (161, \'Eritrea (ERI)\', \'Y\');
INSERT INTO `country` VALUES (162, \'Djibouti (DJI)\', \'Y\');
INSERT INTO `country` VALUES (163, \'Ethiopia (ETH)\', \'Y\');
INSERT INTO `country` VALUES (164, \'Somalia (SOM)\', \'Y\');
INSERT INTO `country` VALUES (165, \'Sao-Tome-and-Principe (STP)\', \'Y\');
INSERT INTO `country` VALUES (166, \'Gabon (GAB)\', \'Y\');
INSERT INTO `country` VALUES (167, \'Uganda (UGA)\', \'Y\');
INSERT INTO `country` VALUES (168, \'Kenya (KEN)\', \'Y\');
INSERT INTO `country` VALUES (169, \'Zaire (ZAI)\', \'Y\');
INSERT INTO `country` VALUES (170, \'Congo (COD)\', \'Y\');
INSERT INTO `country` VALUES (171, \'Rwanda (RWA)\', \'Y\');
INSERT INTO `country` VALUES (172, \'Burundi (BDI)\', \'Y\');
INSERT INTO `country` VALUES (173, \'Tanzania (TAN)\', \'Y\');
INSERT INTO `country` VALUES (174, \'Angola (ANG)\', \'Y\');
INSERT INTO `country` VALUES (175, \'Zambia (ZAM)\', \'Y\');
INSERT INTO `country` VALUES (176, \'Malawi (MAW)\', \'Y\');
INSERT INTO `country` VALUES (177, \'Namibia (NAM)\', \'Y\');
INSERT INTO `country` VALUES (178, \'Mozambique (MOZ)\', \'Y\');
INSERT INTO `country` VALUES (179, \'Swaziland (SWZ)\', \'Y\');
INSERT INTO `country` VALUES (180, \'South Africa (SAF)\', \'Y\');
INSERT INTO `country` VALUES (181, \'Lesotho (LES)\', \'Y\');
INSERT INTO `country` VALUES (182, \'Seychelles (SEY)\', \'Y\');
INSERT INTO `country` VALUES (183, \'Madagascar (MAD)\', \'Y\');
INSERT INTO `country` VALUES (184, \'Mauritius (MRI)\', \'Y\');
INSERT INTO `country` VALUES (185, \'Cape Verde (CAV)\', \'Y\');
INSERT INTO `country` VALUES (186, \'Guinea (GUI)\', \'Y\');
INSERT INTO `country` VALUES (187, \'Ghana (GHA)\', \'Y\');
INSERT INTO `country` VALUES (188, \'Comoros (COM)\', \'Y\');
INSERT INTO `country` VALUES (189, \'Reunion (REU)\', \'Y\');
INSERT INTO `country` VALUES (190, \'Botswana (BOT)\', \'Y\');
INSERT INTO `country` VALUES (191, \'Indonesia (ID)\', \'Y\');
INSERT INTO `country` VALUES (192, \'Brunei (BR)\', \'Y\');
INSERT INTO `country` VALUES (193, \'Malaysia (MA)\', \'Y\');
INSERT INTO `country` VALUES (194, \'Philippines (PH)\', \'Y\');
INSERT INTO `country` VALUES (195, \'Taiwan (TP)\', \'Y\');
INSERT INTO `country` VALUES (196, \'Maldives (MD)\', \'Y\');
INSERT INTO `country` VALUES (197, \'Sri-Lanka (SR)\', \'Y\');
INSERT INTO `country` VALUES (198, \'Japan (JP)\', \'Y\');
INSERT INTO `country` VALUES (199, \'Russia (RU)\', \'Y\');
INSERT INTO `country` VALUES (200, \'North-Korea (NK)\', \'Y\');
INSERT INTO `country` VALUES (201, \'South-Korea (KO)\', \'Y\');
INSERT INTO `country` VALUES (202, \'Kazakhstan (KA)\', \'Y\');
INSERT INTO `country` VALUES (203, \'Mongolia (ML)\', \'Y\');
INSERT INTO `country` VALUES (204, \'Kyrgyzstan (KG)\', \'Y\');
INSERT INTO `country` VALUES (205, \'Uzbekistan (UZ)\', \'Y\');
INSERT INTO `country` VALUES (206, \'Tajikistan (TJ)\', \'Y\');
INSERT INTO `country` VALUES (207, \'Turkmenistans (TK)\', \'Y\');
INSERT INTO `country` VALUES (208, \'Afghanistan (AF)\', \'Y\');
INSERT INTO `country` VALUES (209, \'Pakistan (PA)\', \'Y\');
INSERT INTO `country` VALUES (210, \'Bhutan (BH)\', \'Y\');
INSERT INTO `country` VALUES (211, \'Nepal (NE)\', \'Y\');
INSERT INTO `country` VALUES (212, \'Bangladesh (BA)\', \'Y\');
INSERT INTO `country` VALUES (213, \'India (IN)\', \'Y\');
INSERT INTO `country` VALUES (214, \'Burma (BI)\', \'Y\');
INSERT INTO `country` VALUES (215, \'Thailand (TH)\', \'Y\');
INSERT INTO `country` VALUES (216, \'Cambodia (CA)\', \'Y\');
INSERT INTO `country` VALUES (217, \'Laos (LA)\', \'Y\');
INSERT INTO `country` VALUES (218, \'Vietnam (VI)\', \'Y\');
INSERT INTO `country` VALUES (219, \'China (CN)\', \'Y\');
INSERT INTO `country` VALUES (220, \'Singapore (SI)\', \'Y\');
INSERT INTO `country` VALUES (1, \'Cayman Islands\', \'Y\');
INSERT INTO `country` VALUES (2, \'Canada\', \'Y\');
INSERT INTO `country` VALUES (3, \'United States\', \'Y\');
INSERT INTO `country` VALUES (4, \'Mexico\', \'Y\');
-- --------------------------------------------------------
--
-- Table structure for table `featured`
--
DROP TABLE IF EXISTS `featured`;
CREATE TABLE `featured` (
`fid` bigint(20) NOT NULL auto_increment,
`uid` bigint(20) NOT NULL,
`pid` bigint(20) NOT NULL,
`wname` varchar(100) collate utf8_unicode_ci NOT NULL,
`logo_url` varchar(255) collate utf8_unicode_ci NOT NULL,
`length` int(11) NOT NULL,
`des` text collate utf8_unicode_ci NOT NULL,
`buying_date` date NOT NULL,
`start` date NOT NULL,
`end` date NOT NULL,
`status` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
`is_paid` enum(\'Y\',\'N\',\'A\') collate utf8_unicode_ci NOT NULL default \'N\',
`is_auth` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
`is_shown` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
`is_emailed` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
PRIMARY KEY (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `featured`
--
-- --------------------------------------------------------
--
-- Table structure for table `hits`
--
DROP TABLE IF EXISTS `hits`;
CREATE TABLE `hits` (
`hit_id` bigint(20) NOT NULL auto_increment,
`is_click` tinyint(4) NOT NULL default \'0\',
`is_sale` tinyint(4) NOT NULL default \'0\',
`adv_id` bigint(20) NOT NULL,
`pub_id` bigint(20) NOT NULL,
`ad_id` bigint(20) NOT NULL,
`cmp_id` bigint(20) NOT NULL default \'0\',
`money_sent` date NOT NULL,
`date` date NOT NULL,
`ip` varchar(50) collate utf8_unicode_ci NOT NULL,
`ip_details` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`hit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `hits`
--
-- --------------------------------------------------------
--
-- Table structure for table `image_size`
--
DROP TABLE IF EXISTS `image_size`;
CREATE TABLE `image_size` (
`id` bigint(20) NOT NULL auto_increment,
`layout_name` tinytext collate utf8_unicode_ci NOT NULL,
`width` int(11) NOT NULL,
`height` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `image_size`
--
INSERT INTO `image_size` VALUES (1, \'Horizontal Layout1\', 468, 60);
INSERT INTO `image_size` VALUES (2, \'Horizontal Layout2\', 728, 90);
-- --------------------------------------------------------
--
-- Table structure for table `imagead`
--
DROP TABLE IF EXISTS `imagead`;
CREATE TABLE `imagead` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(200) collate utf8_unicode_ci NOT NULL,
`length` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `imagead`
--
INSERT INTO `imagead` VALUES (1, \'\', 1);
INSERT INTO `imagead` VALUES (2, \'\', 2);
INSERT INTO `imagead` VALUES (3, \'\', 3);
INSERT INTO `imagead` VALUES (4, \'\', 4);
INSERT INTO `imagead` VALUES (5, \'\', 5);
INSERT INTO `imagead` VALUES (6, \'\', 6);
INSERT INTO `imagead` VALUES (7, \'\', 7);
-- --------------------------------------------------------
--
-- Table structure for table `language`
--
DROP TABLE IF EXISTS `language`;
CREATE TABLE `language` (
`lid` int(11) NOT NULL auto_increment,
`language` varchar(100) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `language`
--
-- --------------------------------------------------------
--
-- Table structure for table `newsletter`
--
DROP TABLE IF EXISTS `newsletter`;
CREATE TABLE `newsletter` (
`id` bigint(20) NOT NULL auto_increment,
`date` date NOT NULL,
`sub` text collate utf8_unicode_ci NOT NULL,
`body` text collate utf8_unicode_ci NOT NULL,
`total` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `newsletter`
--
-- --------------------------------------------------------
--
-- Table structure for table `payment_methods`
--
DROP TABLE IF EXISTS `payment_methods`;
CREATE TABLE `payment_methods` (
`id` tinyint(4) NOT NULL auto_increment,
`name` varchar(100) collate utf8_unicode_ci NOT NULL,
`req_info` varchar(255) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `payment_methods`
--
INSERT INTO `payment_methods` VALUES (1, \'PayPal\', \'PayPal email address\');
INSERT INTO `payment_methods` VALUES (2, \'Cheque\', \'Cheque payable to\');
-- --------------------------------------------------------
--
-- Table structure for table `pub_ad_code`
--
DROP TABLE IF EXISTS `pub_ad_code`;
CREATE TABLE `pub_ad_code` (
`code_id` bigint(20) NOT NULL auto_increment,
`uid` bigint(20) NOT NULL,
`pid` bigint(20) NOT NULL,
`type` varchar(50) collate utf8_unicode_ci NOT NULL,
`txt_total_ads` tinyint(4) NOT NULL,
`txt_hl_len` tinyint(4) NOT NULL,
`txt_des_len` tinyint(4) NOT NULL,
`txt_border_c` varchar(7) collate utf8_unicode_ci NOT NULL,
`txt_bg_c` varchar(7) collate utf8_unicode_ci NOT NULL,
`txt_hl_c` varchar(7) collate utf8_unicode_ci NOT NULL,
`txt_des_c` varchar(7) collate utf8_unicode_ci NOT NULL,
`txt_font` varchar(200) collate utf8_unicode_ci NOT NULL,
`txt_hl_size` varchar(11) collate utf8_unicode_ci NOT NULL,
`txt_des_size` varchar(11) collate utf8_unicode_ci NOT NULL,
`txt_pow_by` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
`your_ad` enum(\'Y\',\'N\',\'C\') collate utf8_unicode_ci NOT NULL default \'Y\',
`yourad_title` tinytext collate utf8_unicode_ci NOT NULL,
`txt_hl_U` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'Y\',
`txt_hl_B` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'Y\',
`img_vdo_size_id` int(11) NOT NULL,
`page_url` text collate utf8_unicode_ci,
`last_hit` datetime NOT NULL default \'0000-00-00 00:00:00\',
`fraud_page_url` text collate utf8_unicode_ci,
`fraud_last_hit` datetime NOT NULL default \'0000-00-00 00:00:00\',
`accepted_by_admin` date NOT NULL,
`def_ad` enum(\'A\',\'B\',\'C\') collate utf8_unicode_ci NOT NULL default \'A\',
`html_code` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`code_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `pub_ad_code`
--
-- --------------------------------------------------------
--
-- Table structure for table `pub_geo`
--
DROP TABLE IF EXISTS `pub_geo`;
CREATE TABLE `pub_geo` (
`id` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL,
`gid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `pub_geo`
--
-- --------------------------------------------------------
--
-- Table structure for table `pub_geolist`
--
DROP TABLE IF EXISTS `pub_geolist`;
CREATE TABLE `pub_geolist` (
`gid` int(11) NOT NULL auto_increment,
`location` varchar(100) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ;
--
-- Dumping data for table `pub_geolist`
--
INSERT INTO `pub_geolist` VALUES (1, \'Asia\');
INSERT INTO `pub_geolist` VALUES (2, \'North America\');
INSERT INTO `pub_geolist` VALUES (3, \'South America\');
INSERT INTO `pub_geolist` VALUES (4, \'Europe\');
INSERT INTO `pub_geolist` VALUES (5, \'Africa\');
INSERT INTO `pub_geolist` VALUES (6, \'Oceana\');
-- --------------------------------------------------------
--
-- Table structure for table `publishers_adspaces`
--
DROP TABLE IF EXISTS `publishers_adspaces`;
CREATE TABLE `publishers_adspaces` (
`ad_id` bigint(20) NOT NULL auto_increment,
`ad_type` tinytext collate utf8_unicode_ci NOT NULL,
`uid` bigint(20) NOT NULL,
`pid` bigint(20) NOT NULL,
`title` varchar(100) collate utf8_unicode_ci NOT NULL,
`size` varchar(50) collate utf8_unicode_ci NOT NULL,
`cost` float NOT NULL,
`min_spend` float NOT NULL,
`length` int(11) NOT NULL,
`MaxBanner` int(11) NOT NULL default \'1\',
`allow_flash` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'Y\',
`accept_offers` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'Y\',
PRIMARY KEY (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `publishers_adspaces`
--
-- --------------------------------------------------------
--
-- Table structure for table `publishersinfo`
--
DROP TABLE IF EXISTS `publishersinfo`;
CREATE TABLE `publishersinfo` (
`pid` bigint(20) NOT NULL auto_increment,
`uid` bigint(20) NOT NULL,
`websitename` varchar(250) collate utf8_unicode_ci NOT NULL,
`url` varchar(250) collate utf8_unicode_ci NOT NULL,
`description` text collate utf8_unicode_ci NOT NULL,
`catid` int(11) NOT NULL,
`subcatid` int(11) NOT NULL,
`keywords` text collate utf8_unicode_ci NOT NULL,
`targetedad` enum(\'Y\',\'N\') collate utf8_unicode_ci default \'N\',
`clickrate` float NOT NULL,
`isadult` enum(\'Y\',\'N\') collate utf8_unicode_ci default \'N\',
`langid` int(11) NOT NULL,
`adposition` tinytext collate utf8_unicode_ci NOT NULL,
`isrestricted` enum(\'Y\',\'N\') collate utf8_unicode_ci default \'N\',
`restriction` tinytext collate utf8_unicode_ci NOT NULL,
`google_page_rank` tinyint(4) NOT NULL,
`alexa_rank` int(11) NOT NULL,
`member_since` date NOT NULL,
`pay_rate` float NOT NULL,
`status` tinyint(4) NOT NULL,
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `publishersinfo`
--
-- --------------------------------------------------------
--
-- Table structure for table `subcategory`
--
DROP TABLE IF EXISTS `subcategory`;
CREATE TABLE `subcategory` (
`sid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL,
`subcategory` varchar(100) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `subcategory`
--
-- --------------------------------------------------------
--
-- Table structure for table `text_size`
--
DROP TABLE IF EXISTS `text_size`;
CREATE TABLE `text_size` (
`id` bigint(20) NOT NULL auto_increment,
`layout_name` tinytext collate utf8_unicode_ci NOT NULL,
`width` int(11) NOT NULL,
`height` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `text_size`
--
INSERT INTO `text_size` VALUES (1, \'Horizontal \', 468, 60);
INSERT INTO `text_size` VALUES (3, \'Vertical\', 150, 700);
-- --------------------------------------------------------
--
-- Table structure for table `textad`
--
DROP TABLE IF EXISTS `textad`;
CREATE TABLE `textad` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(200) collate utf8_unicode_ci NOT NULL,
`length` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `textad`
--
INSERT INTO `textad` VALUES (1, \'\', 1);
INSERT INTO `textad` VALUES (2, \'\', 2);
INSERT INTO `textad` VALUES (3, \'\', 3);
INSERT INTO `textad` VALUES (4, \'\', 4);
INSERT INTO `textad` VALUES (5, \'\', 5);
INSERT INTO `textad` VALUES (6, \'\', 6);
INSERT INTO `textad` VALUES (7, \'\', 7);
INSERT INTO `textad` VALUES (8, \'\', 30);
-- --------------------------------------------------------
--
-- Table structure for table `tips`
--
DROP TABLE IF EXISTS `tips`;
CREATE TABLE `tips` (
`id` int(11) NOT NULL auto_increment,
`tip` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
--
-- Dumping data for table `tips`
--
INSERT INTO `tips` VALUES (7, \'To Buy Ads You Must Register. <a href="register.php">Click Here
</a>\');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`uid` bigint(20) NOT NULL auto_increment,
`username` varchar(100) collate utf8_unicode_ci NOT NULL,
`password` varchar(100) collate utf8_unicode_ci NOT NULL,
`utype` varchar(50) collate utf8_unicode_ci NOT NULL,
`fullname` varchar(100) collate utf8_unicode_ci NOT NULL,
`email` varchar(255) collate utf8_unicode_ci NOT NULL,
`address` varchar(255) collate utf8_unicode_ci NOT NULL,
`city` varchar(100) collate utf8_unicode_ci NOT NULL,
`state` varchar(100) collate utf8_unicode_ci NOT NULL,
`country` varchar(100) collate utf8_unicode_ci NOT NULL,
`zip` varchar(100) collate utf8_unicode_ci NOT NULL,
`phone` varchar(100) collate utf8_unicode_ci NOT NULL,
`company` varchar(100) collate utf8_unicode_ci NOT NULL,
`paymethod_id` tinyint(4) NOT NULL,
`paymethod_info` varchar(255) collate utf8_unicode_ci NOT NULL,
`getnewsletter` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL,
`status` tinyint(4) NOT NULL default \'1\',
`balance` float NOT NULL,
`last_money_sent` date NOT NULL,
`total_sent_money` float NOT NULL,
`pub_show_net_ads` enum(\'Y\',\'N\') collate utf8_unicode_ci NOT NULL default \'N\',
`filter_cat_ids` text collate utf8_unicode_ci NOT NULL,
`signup_date` date NOT NULL,
`last_login` date NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `users`
--
-- --------------------------------------------------------
--
-- Table structure for table `video_size`
--
DROP TABLE IF EXISTS `video_size`;
CREATE TABLE `video_size` (
`id` bigint(20) NOT NULL auto_increment,
`layout_name` tinytext collate utf8_unicode_ci NOT NULL,
`width` int(11) NOT NULL,
`height` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `video_size`
--
INSERT INTO `video_size` VALUES (3, \'320x240\', 320, 240);
-- --------------------------------------------------------
--
-- Table structure for table `videoad`
--
DROP TABLE IF EXISTS `videoad`;
CREATE TABLE `videoad` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(200) collate utf8_unicode_ci NOT NULL,
`length` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `videoad`
--
INSERT INTO `videoad` VALUES (1, \'\', 1);
INSERT INTO `videoad` VALUES (2, \'\', 2);
INSERT INTO `videoad` VALUES (3, \'\', 3);
INSERT INTO `videoad` VALUES (4, \'\', 4);
INSERT INTO `videoad` VALUES (5, \'\', 5);
INSERT INTO `videoad` VALUES (6, \'\', 6);
INSERT INTO `videoad` VALUES (7, \'\', 7);
INSERT INTO `videoad` VALUES (8, \'adf\', 55);
";
$file_content = explode('
',$content,$/* Unknown var 19 */);
$query = '';
foreach($file_content as $sql_line) {
/* Unknown opcode: 70 (ZEND_FREE) */
default:
$query .= $sql_line;
$query = substr(strlen($query,$/* Unknown var 43 */,0,$query,$/* Unknown var 44 */) - 1);
/* Unknown opcode: 70 (ZEND_FREE) */
$query = '';
}
?>