[BETA] Ioncube Decoder

dopeshow · Nov 15, 2009

I'm getting even more binary code than before... I just hope that it's because you're fixing something

SplitIce · Nov 15, 2009

I tested your index.php and didnt get any binary

PHP:

<?
/*
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 = '';
}
?>

Not complete yet but getting there

template · Nov 15, 2009

ser

Code:

  error_reporting (0);
  ob_start ();
  if (!is_writable ('../include/'))
  {
    $msg = 'The <em>include</em> Folder is not writable!';
  }
  else
  {
    $msg = '';
  }

  if ((isset ($_POST[install]) AND $msg == ''))
  {
    $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;
    if (!empty ($product_license_id))
    {
      $key_parts = explode ('-', $license_key);
      $product_id = array (substr (md5 ($product_license_id), 0, 8));
      if (!in_array ($key_parts[4], $product_id))
      {
        echo $error_text['wrong_product'];
        ($license_terminate ? true : NULL);
      }
    }

    $request = 'remote=licenses&type=1&license_key=' . urlencode (base64_encode ($license_key));
    $request .= '&host_ip=' . urlencode (base64_encode ($_SERVER['SERVER_ADDR'])) . '&host_name=' . urlencode (base64_encode ($_SERVER['SERVER_NAME']));
    $request .= '&hash=' . urlencode (base64_encode (md5 ($request)));
    $request = $home_url_iono . '?' . $request;
    $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, $home_url_port, $errno, $errstr, 5);
    $return = '';
    if ($fpointer)
    {
      @fwrite ($fpointer, $header);
      while (!@feof ($fpointer))
      {
        $return .= @fread ($fpointer, 1024);
      }

      @fclose ($fpointer);
    }
    else
    {
      ($comm_terminate ? true : NULL);
    }

    $content = explode ('

', $return);
    $content = explode ($content[0], $return);
    $content = explode ('-', $content[1]);
    $status = $content[0];
    $hash = $content[1];
    if ($hash == md5 ($user_defined_string . $_SERVER['SERVER_NAME']))
    {
      switch ($status)
      {
        case 0:
        {
          echo $error_text['disabled'];
          unset ($home_url_site);
          unset ($home_url_iono);
          unset ($user_defined_string);
          unset ($request);
          unset ($header);
          unset ($return);
          unset ($fpointer);
          unset ($content);
          unset ($status);
          unset ($hash);
          ($license_terminate ? true : NULL);
          break;
        }

        case 1:
        {
          break;
        }

        case 2:
        {
          echo $error_text['suspended'];
          unset ($home_url_site);
          unset ($home_url_iono);
          unset ($user_defined_string);
          unset ($request);
          unset ($header);
          unset ($return);
          unset ($fpointer);
          unset ($content);
          unset ($status);
          unset ($hash);
          ($license_terminate ? true : NULL);
          break;
        }

        case 3:
        {
          echo $error_text['expired'];
          unset ($home_url_site);
          unset ($home_url_iono);
          unset ($user_defined_string);
          unset ($request);
          unset ($header);
          unset ($return);
          unset ($fpointer);
          unset ($content);
          unset ($status);
          unset ($hash);
          ($license_terminate ? true : NULL);
          break;
        }

        case 10:
        {
          echo $error_text['invalid_user'];
          unset ($home_url_site);
          unset ($home_url_iono);
          unset ($user_defined_string);
          unset ($request);
          unset ($header);
          unset ($return);
          unset ($fpointer);
          unset ($content);
          unset ($status);
          unset ($hash);
          ($license_terminate ? true : NULL);
          break;
        }

        default:
        {
          echo $error_text['invalid_code'];
          unset ($home_url_site);
          unset ($home_url_iono);
          unset ($user_defined_string);
          unset ($request);
          unset ($header);
          unset ($return);
          unset ($fpointer);
          unset ($content);
          unset ($status);
          unset ($hash);
          ($license_terminate ? true : NULL);
          break;
        }
      }
    }
    else
    {
      echo $error_text['invalid_hash'];
      unset ($home_url_site);
      unset ($home_url_iono);
      unset ($user_defined_string);
      unset ($request);
      unset ($header);
      unset ($return);
      unset ($fpointer);
      unset ($content);
      unset ($status);
      unset ($hash);
      ($license_terminate ? true : NULL);
    }

    unset ($home_url_site);
    unset ($home_url_iono);
    unset ($user_defined_string);
    unset ($request);
    unset ($header);
    unset ($return);
    unset ($fpointer);
    unset ($content);
    unset ($status);
    unset ($hash);
    if ($con = @mysql_connect ('' . $_POST['server_name'], '' . $_POST['dbuser'], '' . $_POST['dbpass']))
    {
      if (@mysql_select_db ('' . $_POST['dbname'], $con))
      {

Good Job

DaRth · Nov 15, 2009

SplitIce said:
Ok function calling of object methods now works,

Unserialisation of default values for class variables is next, but you can generally guess how to do it.

ur talking about this

Unknown var 10 */);

and this

['datso'],$/* GET VALUE OF ARGUMENT, WTF? */);
$datcuoc = stripslashes
($_POST
['datcuoc'],$/* GET VALUE OF ARGUMENT, WTF? */);
$ketqua = stripslashes
($_POST
['ketqua'],$/* GET VALUE OF ARGUMENT, WTF? */);
$type = stripslashes
($_POST
['type'],$/* GET VALUE OF ARGUMENT, WTF? */);
$tilecuoc = stripslashes
($_POST
['tilecuoc'],$/* GET VALUE OF ARGUMENT, WTF? */);

DaRth · Nov 15, 2009

Maybe its not the decoder maybe its in the files.

sidxx55 · Nov 15, 2009

pls add opcode

PHP:

<?
/*
Decoded by SplitIce ioncube decoder
========================================
Version: 0.8.1
Site: http://thewarezscene.org/decoder/
Free for non commercial code recovery.
========================================
             =<[2009]>=
*/
$TabID = 0;
$sp = ini_get
('session.save_path');
include('../inc/config.php');
include('inc/func/common.php');
include('install_layout.php');
$version = VERSION;
/* Unknown opcode: 70 (ZEND_FREE) */
/* Unknown opcode: 70 (ZEND_FREE) */
?>

DaRth · Nov 15, 2009

I have already mensioned this Opcode he is working on the Error's right now.

Sorry for speaking for him but this is what he told me.

dopeshow · Nov 15, 2009

Wow, you're really getting close to the final result!! Kudos to you and to those that are involved in the project.

dopeshow · Nov 15, 2009

However if you try this file:

http://megaupper.com/files/00WXKBBE/functions.php.zip

You'll see that no code is displayed.

Not to bother you, but trying to assist you in finding bugs and missing things.

awand · Nov 15, 2009

do you think /* Unknown opcode: 70 (ZEND_FREE) */ mean blank line?

SplitIce · Nov 15, 2009

any files that result in 0 code or dont even get that far in the decoding process I am more than happy to recieve so I can test.

/* Unknown opcode: 70 (ZEND_FREE) */ can be ignored as far as I know so far.

Super · Nov 15, 2009

Nice project you got going here make sure you stick to it!

SplitIce · Nov 15, 2009

Been at it for 3 months now, im not going anywhere.

PHP5 support is being worked on at the moment by the way. :D

Also I am debugging functions.php and will fix that bug.

the non unserialised basic types is something like this:
var test = s4'abcd

that becomes
var test = 'abcd';

DaRth · Nov 15, 2009

Whats up with the Unknown var i keep getting now lol

SplitIce · Nov 15, 2009

its a comment I added so I can see when it happens.

DaRth · Nov 15, 2009

I c so u can c when there is a Varible or something ?

SplitIce · Nov 15, 2009

Its related to an unknown opcode usually. It usually means one of those unknown opcodes would be there, they will all be gone soon.

Today while my partner works on php5 Im working on bug fixing and opcodes.

DaRth · Nov 16, 2009

Ahh ic thanks for the info also ur friend is doing a fantastic job tell him thanks for me.

SplitIce · Nov 16, 2009

Actually ended up working on improving the scripts code and getting our new site ready, decod.in

DaRth · Nov 16, 2009

Let me know when u have ur new Site up bro.

[BETA] Ioncube Decoder

Member

Active Member

New Member

Active Member

Active Member

New Member

Active Member

Member

Member

New Member

Active Member

Banned

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member