In the course of installing adquick 2.4 as instructed. I came across this error
Parse error: syntax error, unexpected '''' (T_CONSTANT_ENCAPSED_STRING), expecting identifier (T_STRING) in C:\xampp\htdocs\ads\install\index.php on line 1226. I HAVE JUST BOLDED THE LINE 1226 FOR EASY REFERENCE IN THE CODE.
<?
function startparsing ()
{
$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);
$query = '';
foreach ($file_content as $sql_line)
{
if ((trim ($sql_line) != '' AND strpos ($sql_line, '--') === false))
{
$query .= $sql_line;
if (preg_match ('/(.*);/', $sql_line))
{
$query = substr ($query, 0, strlen ($query) - 1);
if (!($result = mysql_query ($query)))
{
exit (mysql_error ());
;
}
$query = '';
continue;
}
continue;
}
}
return true;
}
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 = '';
$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))
{
$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());
}
?>';
if (file_exists ('../include/db_connection.php'))
{
@unlink ('../include/db_connection.php');
}
$fp = fopen ('../include/db_connection.php', 'w');
fwrite ($fp, $db_con);
fclose ($fp);
if (file_exists ('../include/db_connection.php'))
{
include '../include/db_connection.php';
if (startparsing ())
{
mysql_query ('' . 'update configurations set value=\'' . $_POST['key_string'] . '\' where name = \'key_string\' ');
header ('location: ../admin/?pref&install_success');
exit ();
}
else
{
$msg .= '<br>Error executing SQL file! <br>' . mysql_error ();
}
}
else
{
$msg .= '<br>Error Creating DB connection file!';
}
}
else
{
$msg .= '<br>Incorrect Database name!';
}
}
else
{
$msg .= '<br>Incorrect Database user/pass!';
}
}
ob_end_clean ();
echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<link rel="stylesheet" href="../templates/default/css/adquick.css" type="text/css" />
<title>AdQuick</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
</head>
<body>
<div id="wrap">
<div id="';
echo 'header">
<h1 id="logo"><img src="../templates/default/images/AdQuick_logo.jpg" alt="" width="156" height="60" /></h1>
</div>
<div id="content-wrap">
<div id="sidebar" >
<h1> </h1>
<h1> </h1>
</div>
<div id="main">
<h1><a href="../install/" class="style27">Script Nulled By Goldorak sharemafia.com</a></h1>
<table width="100%" border="0">
<tr>
<td class="style39"><h1>';
echo '<s';
echo 'pan class="green">Please make sure you read the instructions that came with this software, before running this installation.</span></h1></td>
</tr>
</table>
<table width="100%" border="0" align="center">
<tr>
<td width="100%"><div class="splitleft">
<div class="box">
<div align="left">
<form action="" method="post" enctype="';
echo 'multipart/form-data" onsubmit="javascript: return confirm(\'WARNING: All tables relate to AdQuick (if any) in the selected database will be flushed.\\n\\n Do you really want to Proceed?\')">
<table width="100%" cellspacing="1" cellpadding="5" border="0">
<tr>
<td colspan="3" class="error">';
echo $msg;
echo '</td>
</tr>
<tr>
<td width="14%"> </td>
<td width="42%"> </td>
<td width="44%"> </td>
</tr>
<tr>
<td> </td>
<td class="td">';
echo '<s';
echo 'trong>Database host server</strong></td>
<td class="td"><input name="server_name" type="text" class="effect" id="server_name" value="';
echo $_POST['server_name'];
echo '" size="20" alt="blank" /></td>
</tr>
<tr>
<td> </td>
<td class="td">';
echo '<s';
echo 'trong>Database user name</strong></td>
<td class="td"><input name="dbuser" type="text" class="effect" id="dbuser" value="';
echo $_POST['dbuser'];
echo '" size="20" alt="blank" /></td>
</tr>
<tr>
<td> </td>
<td>';
echo '<s';
echo 'trong>Database password</strong></td>
<td>';
echo '<s';
echo 'pan class="td">
<input name="dbpass" type="password" class="effect" id="dbpass" value="';
echo $_POST['dbpass'];
echo '" size="20" alt="blank" />
</span></td>
</tr>
<tr>
<td> </td>
<td class="td">';
echo '<s';
echo 'trong>Database name</strong></td>
<td class="td"><input name="dbname" type="text" class="effect" id="dbname" value="';
echo $_POST['dbname'];
echo '" size="20" alt="blank" /></td>
</tr>
<tr>
<td class="td" colspan="3"> </td>
</tr>
<tr>
<td class="td"> </td>
<td class="td">';
echo '<s';
echo 'trong>License: (2-4-3-1229940097-a87ff679)</strong></td>
<td class="td"><input name="key_string" type="text" class="effect" value="';
echo $_POST['key_string'];
echo '" size="20" alt="blank" /></td>
</tr>
<tr>
<td class="td"> </td>
<td class="td"> </td>
<td class="td"> </td>
</tr>
<tr>
<td class="td"> </td>
<td class="td"> </td>
';
echo ' <td class="td"><input type="submit" name="install" id="install" value="Install" class="button" /></td>
</tr>
<tr>
<td class="td"> </td>
<td class="td"> </td>
<td class="td"> </td>
</tr>
</table>
</form>
';
echo ' </div>
</div>
</div></td>
</tr>
</table>
<div class="splitleft"><br />
</div>
</div>
</div>
<div id="footer">
<div class="footer-right">
<p class="align-right"> <a href="#" target="_blank">Script</a></p>
</div>
</div>
</div>
</body>
</html>
';
?>