0

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>&nbsp;</h1>
      <h1>&nbsp;</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%">&nbsp;</td>
                        <td width="42%">&nbsp;</td>
                        <td width="44%">&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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">&nbsp;</td>
                      </tr>
                      <tr>
                        <td class="td">&nbsp;</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">&nbsp;</td>
                        <td class="td">&nbsp;</td>
                        <td class="td">&nbsp;</td>
                      </tr>
                      <tr>
                        <td class="td">&nbsp;</td>
                        <td class="td">&nbsp;</td>
                  ';
  echo '      <td class="td"><input type="submit" name="install" id="install" value="Install" class="button" /></td>
                      </tr>
                      <tr>
                        <td class="td">&nbsp;</td>
                        <td class="td">&nbsp;</td>
                        <td class="td">&nbsp;</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>
';
?>
2
Contributors
3
Replies
15
Views
2 Years
Discussion Span
Last Post by pritaeas
0

How do I terminate it correctly.

The Line 1225 starts with

        $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());
    }
?>';
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.