<?
error_reporting(0);
$datecheck=date("Y-m-d H:i:s");
require 'include/databaseinfo.php';
	$sql=mysql_connect($dbhost,$dbuser,$dbpass);
 	if(!$sql) {
		echo "<h1>Unable to Establish Connection to the Server</h1><hr noshade size=2 color=#000000>";
		exit();
	}
	$db_sel=mysql_select_db($dbname,$sql);
	if(!$db_sel) {
		echo "<h1>Unable to Connect to the Database</h1><hr noshade size=2 color=#000000>";
		exit();
	}


 function AddDays_d($date,$interval) 
{ 
  if (!isset($date)) 
  $date = date("Y-m-d"); 
  $elts = explode("-", $date); 
  $inter=$interval*24*3600; 
  $dcour=mktime(1,0,0,$elts[1],$elts[2],$elts[0]); 
  $dres=$dcour+$inter; 
  $date1=date("Y-m-d",$dres);
  $sec=date("G:i:s");
  $ret_date="$date1"." "."$sec";
  return $ret_date; 
}
$dur=5;
$expiredate=AddDays_d($date,$dur);


$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `aboutme`");
$SQL=MYSQL_QUERY("CREATE TABLE `aboutme` (
  `auto` bigint(100) NOT NULL auto_increment,
  `userid` bigint(20) NOT NULL,
  `yahoo` varchar(100) NOT NULL,
  `msn` varchar(100) NOT NULL,
  `skype` varchar(100) NOT NULL,
  `googletalk` varchar(100) NOT NULL,
  `about` text NOT NULL,
  `enable` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2");

//
// Dumping data for table `aboutme`
//

$SQL=MYSQL_QUERY("INSERT INTO `aboutme` (`auto`, `userid`, `yahoo`, `msn`, `skype`, `googletalk`, `about`, `enable`) VALUES
(1, 23, 'chaudhurisuvarthi', 'chaudhurisuvarthi', 'chaudhurisuvarthi', 'chaudhurisuvarthi', '<p>userid</p>', 'yes')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `about_us`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `about_us`");
$SQL=MYSQL_QUERY("CREATE TABLE `about_us` (
  `company_id` bigint(20) NOT NULL default '0',
  `company_name` varchar(30) NOT NULL default '',
  `company_detail` text NOT NULL,
  `company_address` text NOT NULL,
  `company_phone` varchar(30) NOT NULL default '',
  `company_fax` varchar(30) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1");

//
// Dumping data for table `about_us`
//

$SQL=MYSQL_QUERY("INSERT INTO `about_us` (`company_id`, `company_name`, `company_detail`, `company_address`, `company_phone`, `company_fax`) VALUES
(1, 'iTechScripts.com', '', '', '', '')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `addfunds`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `addfunds`");
$SQL=MYSQL_QUERY("CREATE TABLE `addfunds` (
  `auto_id` bigint(20) NOT NULL auto_increment,
  `member_id` bigint(20) default NULL,
  `fund_date` datetime default NULL,
  `fund_thru` tinyint(4) default NULL,
  `fund_amount` decimal(10,2) default NULL,
  PRIMARY KEY  (`auto_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38");

//
// Dumping data for table `addfunds`
//

$SQL=MYSQL_QUERY("INSERT INTO `addfunds` (`auto_id`, `member_id`, `fund_date`, `fund_thru`, `fund_amount`) VALUES
(22, 20, '0000-00-00 00:00:00', NULL, '200.00'),
(23, 23, '2008-10-13 00:00:00', NULL, '1011.80'),
(31, 35, '0000-00-00 00:00:00', NULL, '190.00'),
(30, 33, '0000-00-00 00:00:00', NULL, '-45.00'),
(32, 38, '0000-00-00 00:00:00', NULL, '463.24'),
(33, 39, '0000-00-00 00:00:00', NULL, '560.76'),
(34, 40, '0000-00-00 00:00:00', NULL, '804.64'),
(35, 41, '0000-00-00 00:00:00', NULL, '-31.64'),
(36, 45, '0000-00-00 00:00:00', NULL, '120.00'),
(37, 48, '2008-09-30 00:00:00', NULL, '10.00')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `admin`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `admin`");
$SQL=MYSQL_QUERY("CREATE TABLE `admin` (
  `admin_id` bigint(20) NOT NULL auto_increment,
  `user_name` text NOT NULL,
  `password` text NOT NULL,
  `email` varchar(50) NOT NULL default '',
  `status` enum('sub','main') NOT NULL default 'sub',
  `fname` varchar(100) NOT NULL,
  `lname` varchar(100) NOT NULL,
  PRIMARY KEY  (`admin_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14");

//
// Dumping data for table `admin`
//

$SQL=MYSQL_QUERY("INSERT INTO `admin` (`admin_id`, `user_name`, `password`, `email`, `status`, `fname`, `lname`) VALUES
(1, 'fc76ff5b5120054af315c5b11955c36cc4d59b0008fbb4fcea9cd4070eee6972fe4ca1f5b5120054af315c5b11955c36cc4d59b0d42a8edc061afd8324d0fb40abc137d20054af315c5b11955c36cc4d59be90261f63f35fcd4400be38b35604eb6af315c5b11955c36cc4d59bd7e22ad997ca37eee3aa5126ec218c14c5b11955c36cc4d59b044096e1b5238ae7750c641bda207f0d955c36cc4d59b5be51956dce07f601f145181aac0815e6cc4d59b80a1e0e552e82ad42090750d54e7cadd59bebac431ed3e0ae766659b9ccb9438ec7', 'fc76ff5b5120054af315c5b11955c36cc4d59b0008fbb4fcea9cd4070eee6972fe4ca1f5b5120054af315c5b11955c36cc4d59b0d42a8edc061afd8324d0fb40abc137d20054af315c5b11955c36cc4d59be90261f63f35fcd4400be38b35604eb6af315c5b11955c36cc4d59bd7e22ad997ca37eee3aa5126ec218c14c5b11955c36cc4d59b044096e1b5238ae7750c641bda207f0d955c36cc4d59b5be51956dce07f601f145181aac0815e6cc4d59b80a1e0e552e82ad42090750d54e7cadd59bebac431ed3e0ae766659b9ccb9438ec7', 'admin@itechscripts.com', 'main', '', '')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `admin_commission`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `admin_commission`");
$SQL=MYSQL_QUERY("CREATE TABLE `admin_commission` (
  `auto` tinyint(10) NOT NULL,
  `type` enum('flat','percent') NOT NULL,
  `fee` float(6,2) NOT NULL,
  `pay_who` enum('seller','buyer') NOT NULL default 'seller',
  `f_discount` float(6,2) NOT NULL,
  `f_type` enum('flat','percent') NOT NULL default 'flat',
  `site_mode` enum('account','live') NOT NULL,
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1");

//
// Dumping data for table `admin_commission`
//

$SQL=MYSQL_QUERY("INSERT INTO `admin_commission` (`auto`, `type`, `fee`, `pay_who`, `f_discount`, `f_type`, `site_mode`) VALUES
(1, 'percent', 5.00, 'seller', 0.00, 'flat', 'live')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `admin_earnings`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `admin_earnings`");
$SQL=MYSQL_QUERY("CREATE TABLE `admin_earnings` (
  `payment_id` bigint(20) NOT NULL auto_increment,
  `user_id` bigint(20) NOT NULL default '0',
  `payment_date` date NOT NULL default '2005-09-29',
  `amount` float(6,2) NOT NULL default '0.00',
  `type` enum('endauctionearly','feature_fee','commission') NOT NULL default 'endauctionearly',
  UNIQUE KEY `payment_id` (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1");

//
// Dumping data for table `admin_earnings`
//


// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `askseller`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `askseller`");
$SQL=MYSQL_QUERY("CREATE TABLE `askseller` (
  `qst_id` bigint(20) NOT NULL auto_increment,
  `from_id` varchar(200) NOT NULL default '',
  `productid` bigint(20) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `question` varchar(200) NOT NULL default '',
  `to_id` varchar(200) NOT NULL default '',
  `answer` varchar(220) NOT NULL default '',
  `status` enum('read','unread','delete','reply') NOT NULL default 'unread',
  PRIMARY KEY  (`qst_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16");

//
// Dumping data for table `askseller`
//

$SQL=MYSQL_QUERY("INSERT INTO `askseller` (`qst_id`, `from_id`, `productid`, `date`, `question`, `to_id`, `answer`, `status`) VALUES
(7, '1', 0, '2008-09-28', 'test', '45', 'test', 'read'),
(8, '45', 0, '2008-09-29', 'test', '1', 'test', 'reply'),
(9, '53', 668, '2008-11-11', 'can I combine payments for my auctions?', '1', '', 'unread'),
(10, '1', 0, '2008-11-11', 'this is a test email', '55', 'testing email', 'delete'),
(11, '', 0, '2008-12-09', 'test', '55', 'testing', 'delete'),
(12, '55', 637, '2008-12-11', 'How does this work', '1', '', 'unread'),
(13, '56', 643, '2008-12-13', 'help me', '1', '', 'unread'),
(14, '56', 643, '2008-12-13', 'xcghxz', '1', '', 'unread'),
(15, '', 0, '2008-12-13', 'test', '56', 'testing', '')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `auction_details`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `auction_details`");
$SQL=MYSQL_QUERY("CREATE TABLE `auction_details` (
  `productid` bigint(20) NOT NULL auto_increment,
  `user_id` bigint(20) NOT NULL default '0',
  `category_main` bigint(20) NOT NULL,
  `category_id` bigint(20) NOT NULL default '0',
  `producttitle` longtext NOT NULL,
  `item_counter_style` enum('1','2') NOT NULL default '1',
  `Quantity` int(5) NOT NULL default '0',
  `payment_gateway` varchar(20) NOT NULL default '0.00',
  `detailed_descrip` longtext NOT NULL,
  `selling_method` varchar(20) NOT NULL default '',
  `min_bid_amount` decimal(30,2) NOT NULL default '0.00',
  `bidincrement` double NOT NULL default '0',
  `shipping_cost` float(6,2) NOT NULL default '0.00',
  `who_pay_shipping` enum('Inclusive','Exclusive') NOT NULL default 'Inclusive',
  `shipping_route` varchar(50) NOT NULL default '',
  `duration` int(3) NOT NULL default '0',
  `currency` varchar(8) NOT NULL default '$',
  `reserve_price` decimal(30,2) NOT NULL default '0.00',
  `quick_buy_price` decimal(30,2) NOT NULL default '0.00',
  `bid_starting_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `start_delay` int(3) default '0',
  `status` enum('Active','Inactive','Closed','Sold','suspended','new','unapproved') NOT NULL default 'new',
  `picture1` varchar(200) NOT NULL default '',
  `picture2` varchar(200) NOT NULL default '',
  `picture3` varchar(200) NOT NULL default '',
  `picture4` varchar(200) NOT NULL default '',
  `picture5` varchar(200) NOT NULL default '',
  `picture6` varchar(200) NOT NULL default '',
  `picture7` varchar(200) NOT NULL default '',
  `picture8` varchar(200) NOT NULL default '',
  `payment_name` varchar(20) NOT NULL default '',
  `quantity_sold` bigint(20) NOT NULL default '0',
  `clicks` bigint(20) NOT NULL default '0',
  `expire_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `payment_id` varchar(30) NOT NULL default '0',
  `size_of_quantity` varchar(15) NOT NULL default '',
  `tax` float(6,2) NOT NULL default '0.00',
  `sniper` enum('yes','no') NOT NULL default 'yes',
  `no_of_repost` tinyint(4) NOT NULL default '0',
  `sale_price` float(6,2) NOT NULL default '0.00',
  `s_repost` varchar(10) NOT NULL default '',
  `shop` enum('yes','no') NOT NULL default 'no',
  `relisted` enum('yes','no') NOT NULL default 'no',
  `or_price` float(6,2) NOT NULL default '0.00',
  `return_pol` text NOT NULL,
  `timetoadd` bigint(100) NOT NULL default '0',
  `special` enum('yes','no') NOT NULL default 'no',
  `discount` int(10) NOT NULL default '0',
  `totbid` bigint(100) NOT NULL,
  `stopped` enum('yes','no') NOT NULL default 'no',
  `closetime` datetime NOT NULL,
  `ship_stat` enum('unpaid','paid','awaiting shipping','shipped','completed') NOT NULL default 'unpaid',
  `or_expire_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_bidder` bigint(100) NOT NULL,
  `locked` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`productid`),
  UNIQUE KEY `productid` (`productid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=647 ");

//
// Dumping data for table `auction_details`
//
//$expiredate 16:17:36

$SQL=MYSQL_QUERY("INSERT INTO `auction_details` (`productid`, `user_id`, `category_main`, `category_id`, `producttitle`, `item_counter_style`, `Quantity`, `payment_gateway`, `detailed_descrip`, `selling_method`, `min_bid_amount`, `bidincrement`, `shipping_cost`, `who_pay_shipping`, `shipping_route`, `duration`, `currency`, `reserve_price`, `quick_buy_price`, `bid_starting_date`, `start_delay`, `status`, `picture1`, `picture2`, `picture3`, `picture4`, `picture5`, `picture6`, `picture7`, `picture8`, `payment_name`, `quantity_sold`, `clicks`, `expire_date`, `payment_id`, `size_of_quantity`, `tax`, `sniper`, `no_of_repost`, `sale_price`, `s_repost`, `shop`, `relisted`, `or_price`, `return_pol`, `timetoadd`, `special`, `discount`, `totbid`, `stopped`, `closetime`, `ship_stat`) VALUES
(574, 20, 4, 23, 'Juwelis Selina Diamond Ladies Watch / JW-0602-GW', '1', 1, '', '<p><b>Juwelis Selina Diamond Ladies Watch / JW-0602-GW</b></p>\r\n<p><b>Description:</b></p>\r\n<p>An elegant ladies watch from Juwelis, which features a stunning design and a face set with 7 geniuine diamonds. The Selina is definitely an eye catcher!</p>\r\n<p><b>Details:</b></p>\r\n<p>&bull;Model-No: Juwelis Selina JW-0602-GW <br />\r\n&bull;Type: Automatic <br />\r\n&bull;Movement: Quarz <br />\r\n&bull;Material: Stainless Steel 316L, gold gilding <br />\r\n&bull;Watch Face: White and silver, set with 7 genuine diamonds <br />\r\n&bull;Water Resistance: 5 ATM (50m) <br />\r\n&bull;Functions: Date, Chronograph <br />\r\n&bull;Dimensions: 43 x 11 mm <br />\r\n&bull;Weight: 65g</p>\r\n<p><br />\r\n<b>What''s in the box: </b><br />\r\n&nbsp;</p>', '11', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '15', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092322151_Juwelis_Selina_Diamond_Ladies_Watch.gif', '', '', '', '', '', '', '', '', 1, 64, date_add(NOW(),INTERVAL 6547 SECOND), '', '', 32.00, 'yes', 1, 0.08, '', 'no', 'no', 200.00, '', 300, 'no', 0, 2, 'no', '0000-00-00 00:00:00', 'completed'),
(576, 20, 4, 23, 'Asus VW222S 22', '1', 0, '', '<p><b>Asus VW222S 22&quot; Widescreen LCD </b></p>\r\n<p><b>TFT MonitorLarge 22&quot; Widescreen Display - Fast 2ms Reponse Time - 2000:1 Contrast Ratio - 1680 x 1050 Resolution - Brightness 300 cd/m</b></p>\r\n<p><b><br />\r\nDescription:</b></p>\r\n<p>The Asus VW222S TFT screen produces larger-than-life images at unbelievable speeds. It''s ideal for graphics applications, as well as for photo editing, films and video games.</p>\r\n<p>High-quality 16:10 widescreen panel<br />\r\n1680 x 1050 high resolution and wide viewing angle make the LCD monitor perfect for viewing high-quality DVD images. 16.7 million display colours deliver rich and colourful images to surprise your eyes.</p>\r\n<p>Fit two A4 size pages on screen<br />\r\nThe 22&quot; widescreen of VW222S provides a 27% wider viewing area compared with 19&quot; monitors and can also fit two A4 size pages at the same time, meaning ample screen space for different contents. The VW222S helps double your working efficiency.</p>\r\n<p>Trace Free Technology<br />\r\nDelivers 2ms (GTG) extremely quick response time for smoother video display and results in no image delay and ghosting during speedy games.</p>\r\n<p>Intelligent image enhancement<br />\r\nSplendid Video Intelligence Technology fine tunes the colour, brightness, contrast and sharpness of images in different video applications and offers 5 preset video modes (Scenery, Theatre, Games, Night View and Standard) selection via hotkey and 3 skin tone options (Reddish, Yellowish and Natural).</p>\r\n<p><br />\r\nDetails:</p>\r\n<p>General</p>\r\n<p>&bull;Weight: 4.8 kg <br />\r\n&bull;Model: Asus VW222S <br />\r\n&bull;Dimensions: 513 x 405 x 210 mm <br />\r\nAudio output <br />\r\n&bull;Audio Loudspeakers: 2 x 1 W RMS <br />\r\nPower supply <br />\r\n&bull;Power consumption (in use): 55W <br />\r\nDisplay <br />\r\n&bull;Maximum resolution: 1680 x 1050 <br />\r\n&bull;Diagonal screen size: 22&quot; Widescreen <br />\r\n&bull;Response time: 2ms <br />\r\n&bull;Frequency page: Horizontal: 31.3-80.2 KHz, Vertical: 56-75 Hz <br />\r\n&bull;Colours: 16.7 million colours <br />\r\nImage <br />\r\n&bull;Maximum vertical viewing angle: 160 degrees <br />\r\n&bull;Contrast Ratio: 2000:1 <br />\r\n&bull;Maximum horizontal viewing angle: 170 degrees <br />\r\n&bull;Brightness (cd/m&sup2;): 300</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Asus VW222S 22&quot; Widescreen LCD TFT Monitor<br />\r\n&bull;Power Lead<br />\r\n&bull;User Manual</p>', '11', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '15', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092331138_Asus_VW222S_22inch_Monitor.gif', '', '', '', '', '', '', '', '', 1, 65, date_add(NOW(),INTERVAL 7860 SECOND), '', '', 32.00, 'yes', 1, 3.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'unpaid'),
(579, 20, 4, 23, 'Samsung i900 Omnia TEST', '1', 1, '', '<p><b>Samsung i900 Omnia SIM Free</b></p>\r\n<p><b>Description:</b></p>\r\n<p><br />\r\nThe i900 Omnia runs atop of version 6.1 of Microsoft''s Windows Mobile Professional operating system. It supports quad-band GSM/EDGE as well as 2100MHz UMTS/HSDPA (7.2Mbps) network connectivity, with WiFi thrown in for good measure. Highlights of the Omnia include a large, 3.2-inch WQVGA (240x400 pixel) touchscreen display with stylus support. The display supports auto-rotation for apps and there is a TV-out function for when 3.2-inch just isn''t large enough. The i900 Omnia supports many different music and video formats, including Ogg Vorbis music and DivX and Xvid video. An FM radio is also included in case you forget to load up the i900''s 8GB internal storage with your favorite music, and you don''t have a microSDHC card lying around. Music can be enjoyed with wired or Bluetooth wireless headsets, thanks to the i900''s A2DP stereo Bluetooth capability. The Omnia also sports a high-spec camera, as well. The camera uses a 5 megapixel CMOS sensor with an autofocus lens and has such high end features as face and smile detection, image stabilization, wide dynamic range mode, and an automatic panoramic mode. A built-in GPS module with nav and geotagging capabilities is also on-board. The SGH-i900 Omnia uses Samsung''s TouchWiz user interface extensions on top of Windows Mobile. This means that users are free to navigate with taps, sweeps, or drags and drops as well as use the built-in optical mouse controller. Text input is handled by an on-screen virtual QWERTY keyboard.</p>\r\n<p><br />\r\nGeneral features:</p>\r\n<p>&bull;Quadband GSM 850/900/1800/1900 <br />\r\n&bull;Dimensions : 112 x 56.9 x 12.5 mm <br />\r\n&bull;Weight : 127 g <br />\r\n&bull;Display: TFT touchscreen, 65K colors <br />\r\n&bull;Display size: 240 x 400 pixels, 3.2 inches <br />\r\nRingtones:</p>\r\n<p>&bull;Polyphonic, MP3 <br />\r\nMemory: <br />\r\n&bull;Card Slot: MicroSD (TransFlash) <br />\r\n&bull;Internal Memory: 8 GB <br />\r\nConnectivity: <br />\r\n&bull;GPRS: Yes <br />\r\n&bull;HSDPA: Yes <br />\r\n&bull;Edge: Yes <br />\r\n&bull;WiFi: Yes <br />\r\n&bull;3G: HSDPA <br />\r\n&bull;Bluetooth: Yes <br />\r\n&bull;A2DP: Yes <br />\r\n&bull;USB: Yes <br />\r\nVideo</p>\r\n<p>&bull;Yes <br />\r\nFlashlight</p>\r\n<p>&bull;Yes <br />\r\nCamera resolution</p>\r\n<p>&bull;5 megapixels <br />\r\nBattery</p>\r\n<p>&bull;Stand-by-time: Up to 500 hours <br />\r\n&bull;Talk-time: Up to 5 hours and 50 <br />\r\nOther</p>\r\n<p>&bull;Messaging: SMS, EMS, MMS, Email, Instant Messaging <br />\r\n&bull;FM radio: Yes <br />\r\n&bull;Games: Yes <br />\r\n&bull;Speaker phone: Yes <br />\r\n&bull;Operating System:Microsoft Windows Mobile 6.1 Professional <br />\r\n&bull;Touch-screen: Yes</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Samsung i900 Omnia SIM Free<br />\r\n&bull;Battery<br />\r\n&bull;Charger<br />\r\n&bull;EarPlug<br />\r\n&bull;CD-Rom<br />\r\n&bull;User Manual<br />\r\n&bull;Stylus</p>', '11', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '15', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092331824_Nokia_N78_SIM.gif', '', '', '', '', '', '', '', '', 0, 85, date_add(NOW(),INTERVAL 3426 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 220.00, '', 300, 'no', 0, 2, 'no', '0000-00-00 00:00:00', 'unpaid'),
(580, 20, 4, 23, 'TomTom Go 730T GPS Sat Nav', '1', 1, '', '<p><b>TomTom Go 730T GPS Sat Nav</b></p>\r\n<p><b>Description:</b></p>\r\n<p>The Go 730 T comes with a voice recognition feature, an FM transmitter and a Bluetooth function, so you can make hands-free calls in complete safety. You can use the the Go 730 T to calculate itineraries - you just need to state the address of your destination to get it going. The Go 730 T includes an IQ Routes mode, which provides more &quot;intelligent&quot; information based on the average road speeds during the weekday and weekends, giving you a more accurate idea of driving and arrival times, saving you time, and cutting back on fuel costs. An advanced guidance programme displays the number of lanes and which lane you should be in for your upcoming turn on-screen, and gives you a 3D image of what''s ahead, which is particularly useful for complicated junctions.</p>\r\n<p>IQ Routes technology</p>\r\n<p><br />\r\n&bull;Easy access to traffic information <br />\r\n&bull;Extensive traffic information/options <br />\r\n&bull;4.3&quot; large, high-quality touchscreen <br />\r\n&bull;Fast and Accurate Positioning <br />\r\n&bull;Fast route (re-)calculation <br />\r\n&bull;Text-to-speech <br />\r\n&bull;Enhanced Points of Interest <br />\r\nBest Maps</p>\r\n<p>&bull;Make corrections to your own map and benefit from thousands of corrections made by TomTom <br />\r\n&bull;TomTom Map Share technology Latest &amp; most accurate maps Latest map guarantee Future Proof <br />\r\nEasy to use</p>\r\n<p>&bull;Fits perfectly in your car, hand or pocket. <br />\r\n&bull;Stylish slim design with luxurious black finish <br />\r\n&bull;Easy to operate <br />\r\n&bull;Voice address input <br />\r\n&bull;Faster &amp; easier address input <br />\r\n&bull;Easy location search and selection <br />\r\n&bull;Plug &amp; Go <br />\r\n&bull;High quality lithium-polymer battery <br />\r\n&bull;Customizable status bar <br />\r\n&bull;Tip feature <br />\r\n&bull;Extensive guided tour <br />\r\nSafe and Efficient Driving</p>\r\n<p>&bull;Gives you extra clarity when navigating difficult junctions. <br />\r\n&bull;Advanced lane guidance <br />\r\n&bull;Safety camera alerts <br />\r\n&bull;High-quality hands-free car kit <br />\r\n&bull;High quality connection <br />\r\n&bull;Automatic pick-up High quality speaker <br />\r\n&bull;Clear visual and spoken instructions in your own language <br />\r\n&bull;Realistic visual instructions <br />\r\n&bull;Speeding alert <br />\r\n&bull;Help Me! emergency menu <br />\r\n&bull;Personalized shortcut menu <br />\r\n&bull;Safety preferences <br />\r\n&bull;Anti-glare screen <br />\r\nSmart Extras</p>\r\n<p>&bull;Everything you need to keep your TomTom device up to date - get new software, download new <br />\r\n&bull;TomTom HOME desktop software <br />\r\n&bull;Enjoy your music on the GO <br />\r\n&bull;Record your own navigation instructions <br />\r\n&bull;Bluetooth remote control included <br />\r\n&bull;&quot;Current location icon&quot; options <br />\r\n&bull;Photos <br />\r\n&bull;Document viewer <br />\r\n&bull;Device-to-device content sharing <br />\r\n&bull;Online services <br />\r\nServices</p>\r\n<p>&bull;Make driving more relaxed and travel safer. <br />\r\n&bull;Locations and warnings for safety cameras <br />\r\n&bull;Real-time weather reports <br />\r\n&bull;Buddies</p>\r\n<p>Details:</p>\r\n<p>General</p>\r\n<p>&bull;Model: TomTom GO 730T <br />\r\n&bull;Dimensions: 118 x 83 x 24mm <br />\r\nDisplay <br />\r\n&bull;Diagonal screen size: 4.3&quot;</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Car Power Adapter<br />\r\n&bull;Docking Station<br />\r\n&bull;Mounting Bracket<br />\r\n&bull;TomTom Go 730T GPS Sat Nav</p>', '11', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '15', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092335018_TomTom_Go_730T.gif', '', '', '', '', '', '', '', '', 0, 81, date_add(NOW(),INTERVAL 7609 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 2, 'no', '0000-00-00 00:00:00', 'unpaid'),
(581, 20, 4, 23, 'Canon EOS 450D DSLR + EF-S ', '1', 1, '', '<p><b>Canon EOS 450D DSLR + EF-S </b></p>\r\n<p><b>18-55mm Lens12.2 Megapixels - 3.5 fps continuous shooting - Wide-area 9-point AF system - 3.0&quot; LCD with Live View mode - EOS Integrated Cleaning System - Compact and lightweight build</b></p>\r\n<p><b><br />\r\nDescription:</b></p>\r\n<p>For stunning photography with point and shoot ease, look no further than Canon&rsquo;s EOS 450D. The EOS 450D brings staggering technological innovation to the masses. It features Canon&rsquo;s EOS Integrated Cleaning System, Live View Function, a powerful DIGIC III Image Processor, plus a new 12.2-megapixel CMOS sensor and is available in a kit with the new EF-S 18-55mm f/3.5-5.6 IS lens with Optical Image Stabilizer. The EOS 450D&rsquo;s refined, ergonomic design includes a new 3.0-inch LCD monitor, compatibility with SD and SDHC memory cards and new accessories that enhance every aspect of the photographic experience.</p>\r\n<p>12.2 Megapixels</p>\r\n<p>The number of megapixels determines the amount of sharp detail a digital camera can record. With more megapixels, you can print at larger sizes, plus crop and enlarge without sacrificing quality. EOS cameras provide all the resolution you need for finely detailed, photo-quality prints with plenty of scope for post-shoot cropping.</p>\r\n<p>A 12.2 Megapixel sensor lets you capture every scene in ultra-high levels of detail &ndash; perfect for turning your experiences into poster-sized photo prints.</p>\r\n<p>9 Point Wide Area AF</p>\r\n<p>The precise auto focus system of the EOS 450D keeps you focused for sharp images. Featuring a diamond-shaped array of nine AF points, this newly improved system delivers outstanding coverage of nearly any subject, both in horizontal and vertical formats. The nine AF points &mdash; one high-precision cross-type center AF point with f/2.8 sensitivity and eight others compatible at f/5.6 &mdash; provide fast, accurate auto focus for any Canon EF lens even when shooting in low-light environments. Focus points can be assigned automatically using one of three different AF modes or manually.</p>\r\n<p>EOS Integrated Cleaning System</p>\r\n<p>The EOS Integrated Cleaning System combats sensor dust in three important ways: Reduce, Repel and Remove. The camera''s Self-Cleaning Sensor Unit shakes dust particles off of the low-pass filter in front of the sensor. The dust is then trapped by an adhesive along the base, preventing it from causing further nuisance. Cleaning is engaged each time the camera is powered up or shut down or manually through the &quot;clean now&quot; function.</p>\r\n<p>DIGIC III</p>\r\n<p>Canon&rsquo;s revolutionary DIGIC image processors work at the heart of every EOS digital camera. It is the power of DIGIC that delivers the superb EOS image quality, responsive camera performance, faster AF, faster continuous shooting and extended battery life. DIGIC processors are so fast they can read, process, compress and write image data back to the buffer between exposures, reducing the data bottleneck for extended continuous shooting.</p>\r\n<p>3.0&quot; LCD with Live View</p>\r\n<p>The Cameras Live View mode makes it easier to shoot from awkward angles, such as ground-level macro shots or when shooting from a tripod. The image from the Live View mode is displayed as a smooth, 30fps video feed on the 3.0&rdquo; LCD, which is 50% brighter than the screen of the EOS 400D. A grid line display and live histogram can be selected to help with shot composition and exposure. While focusing, the photographer can zoom in on specific details with up to 10x magnification of the image displayed on the LCD screen.</p>\r\n<p>RAW</p>\r\n<p>The EOS 450D is supplied with a comprehensive software suite that provides everything the photograph needs to manage and process images. This includes Digital Photo Professional (DPP), a powerful RAW converter that provides complete RAW image processing control.</p>\r\n<p>EF / EFS / EX</p>\r\n<p>The EOS 450D camera is fully compatible with all Canon EF and EF-S lenses, as well as EX-series Speedlites.</p>\r\n<p>DPOF</p>\r\n<p>DPOF (Digital Print Order format) is a format which allows the user of the EOS 450D to define which captured images on the storage card are to be printed, together with information on the number of copies or other image information such as paper size, image title text, image orientation, contact information and much more.</p>\r\n<p>Details:</p>\r\n<p>Pixels</p>\r\n<p>&bull;CCD: 12.4-megapixel (including 12.2 effective) CMOS sensor - 22.2 x 14.8 mm <br />\r\n&bull;Resolution: 4272 x 2848 pixels <br />\r\nOptical <br />\r\n&bull;Optical zoom: 3x <br />\r\n&bull;ISO range: ISO auto (100-800), 100, 200, 400, 800, 1600 <br />\r\n&bull;Aperture and shutter speed: Speed: from 1/4000 to 30 secs <br />\r\nComputer Interface <br />\r\n&bull;Port: USB 2.0 <br />\r\n&bull;Compatibility: Windows 2000 (SP4) / XP (SP2) / Vista (excluding Starter Edition) OS X v10.3-10.4 <br />\r\n&bull;Included software: ZoomBrowser EX, Image Browser, Photo Stitch, EOS Utility, TWAIN PTP driver (Windows 2000), Digital Photo Professional <br />\r\nGeneral <br />\r\n&bull;Dimensions: 12.9 cm x 6.2 cm x 9.8 cm (W x D x H) <br />\r\n&bull;Type: Consumer reflex camera <br />\r\nMain Features <br />\r\n&bull;Shooting Modes: Landscape, portrait mode, close-up, night portrait, sports mode <br />\r\n&bull;Special Effects: Neutral, Faithful, monochrome, landscape, portrait <br />\r\n&bull;Supported Flash Memory: SD / SDHC card <br />\r\n&bull;Still Image Format: JPEG, RAW, RAW + JPEG <br />\r\n&bull;Other: DIGIC III processor, Direct aim mode, Burst mode: 3.5 fps, PictBridge, 13 customised function with 34 settings, 9-point AF large range, Built-in EOS cleaning system, Polycarbonate/stainless steel casing <br />\r\nLens <br />\r\n&bull;Aperture: F/3.5-5.6 <br />\r\n&bull;Construction: 9 group(s) / 11 element(s) <br />\r\n&bull;Focal Length: Equivalent to 35mm Camera: 29 - 88mm <br />\r\n&bull;Focal Length: 18 mm - 55 mm <br />\r\n&bull;Minimum Focus Range: 25 cm <br />\r\n&bull;Focus Adjustment: Automatic, manual <br />\r\nFlash <br />\r\n&bull;Type: Built-in flash <br />\r\n&bull;Modes: Auto, manual on/off, red-eye reduction <br />\r\n&bull;Features: Coverage up to 17 mm focal length, Flash exposure correction: +/- 2 IL (by 1/2 or 1/3 values) <br />\r\nDisplay <br />\r\n&bull;Type: TFT <br />\r\n&bull;Resolution: 230,000 pixels <br />\r\n&bull;Size: 3&quot; <br />\r\nViewfinder <br />\r\n&bull;Diopter Adjustment: Dioptric correction: -3 to +1 (1/m) <br />\r\n&bull;Type: Eye-level viewfinder (with fixed Penta mirror) <br />\r\n&bull;Magnification: Approx. 0.87x</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Body Cap<br />\r\n&bull;Canon EOS 450D DSLR Body<br />\r\n&bull;Dust Cap<br />\r\n&bull;EF-S18-55mm Lens<br />\r\n&bull;Neck Strap<br />\r\n&bull;USB Cable<br />\r\n&bull;User Guide<br />\r\n&bull;Video Cable<br />\r\n&bull;Battery<br />\r\n&bull;Charger</p>', '11', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '15', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092335300_Canon_EOS.gif', '', '', '', '', '', '', '', '', 1, 68, date_add(NOW(),INTERVAL 8976 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'unpaid'),
(583, 20, 4, 23, '300 FreeBids Voucher ', '1', -1, '', '<p><b>300 FreeBids Voucher</b></p>\r\n<p><b>Description:</b></p>\r\n<p>You know what they say: you can''t win an auction without bids. Give yourself a helping hand all over Quibids with 300 more: it might just be the edge you need to grab the TV/coffee machine/laptop that you''ve been eyeing.</p>\r\n<p>This 100% off auction makes every other deal on the site that much sweeter. Get in on the bidding, before you miss out!</p>\r\n<p>If you win this auction, the FreeBids will be credited to your account within 24 hours. The update takes place at 2am each morning.<br />\r\n&nbsp;</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092335440_300_FreeBids_Voucher.gif', '', '', '', '', '', '', '', '', 2, 74, date_add(NOW(),INTERVAL 3224 SECOND), '', '', 32.00, 'yes', 1, 125.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'unpaid'),
(589, 20, 4, 23, 'Wii | Nintendo Console + Wii Sports', '1', 1, '', '<p><b>Wii | Nintendo Console + Wii Sports</b></p>\r\n<p><b>UK PAL Version - Wii Sports (bowling, boxing, baseball, tennis and golf) - IBM Processing chip - ATI Graphics card - Built in Wi-Fi - Wii Channel for news, weather, photo viewing and more - Like everything you see on TeleBid this Wii is brand new!</b></p>\r\n<p><b><br />\r\nDescription:</b></p>\r\n<p>Nintendo''s giant leap into the next generation of games comes in the form of the Wii, and is one of the most innovative and dynamic creations ever seen in the games market. Featuring a totally unique wireless controller, a line-up of games set to turn the games market upside down and access to 25 years of classic Nintendo gaming, the Wii looks set to change the way we play games forever!</p>\r\n<p>''Wii'' is Japanese for ''Everybody'', and Nintendo have made sure they''ve created something that can be enjoyed by anyone who has the pleasure of picking up the controller. Take some time to read a bit more about the console below, and find out exactly why the Wii is adding a fresh spark of excitement in the game market, and pre-order your console now so that you can be amongst the first to enjoy the Wii in all its glory! The console comes with a wireless controller, Nunchuck controller and a copy of the most excellent ''Wii Sports'' - click the link on the left to find out more about this great title, where you get to play games like Tennis and Golf the way you would in real life!</p>\r\n<p>Controls<br />\r\nIntuitive control for anyone using the physical motion of the Wii Remote controller, which resembles a television remote control. Up to four Wii Remote controllers can be connected at once using wireless Bluetooth technology. The wireless signal can be detected within 10 meters of the console. Both the Wii Remote and Nunchuk controllers include a three-axis motion sensor. The Wii Remote controller also includes a speaker, rumble feature and expansion port, and can be used as a pointer within 5 meters of the screen. The Wii Remote controller has a power switch, plus pad, A, B, Minus, Home, 1 and 2 buttons. The Nunchuk controller includes an analog control stick and C and Z buttons.</p>\r\n<p>The Look<br />\r\nThe Wii console features a compact design that will make it a natural addition to any television setup. It can be displayed either vertically or horizontally.</p>\r\n<p>Media<br />\r\nA single self-loading media bay will play single - or double-layered 12-centimeter optical discs for the Wii console, as well as 8-centimeter Nintendo GameCube discs.</p>\r\n<p>Channels<br />\r\nThe Wii Channel Menu is the main gateway for a variety of easy-to-use, interactive multimedia, entertainment and communication functions.</p>\r\n<p>Communication<br />\r\nThe Wii console can communicate with the Internet even when the power is turned off. The WiiConnect24 service delivers a new surprise or game update, even if the system is idle. Users can connect wirelessly or with a USB 2.0 LAN adaptor. The Wii console also can communicate wirelessly with Nintendo DS.</p>\r\n<p>Virtual Console<br />\r\nThe Wii console will have downloadable access to 20 years of fan-favourite titles originally released for Nintendo 64, the Super Nintendo Entertainment System (SNES) and even the Nintendo Entertainment System (NES). The Virtual Console also will feature a &quot;best of&quot; selection from Sega Genesis titles and games from the TURBO GRAFX16 console (a system jointly developed by NEC and Hudson). It also will be home to new games conceived by indie developers whose creativity is larger than their budgets.</p>\r\n<p>Wii Sports<br />\r\nWii Sports offers five distinct sports experiences, each using the Wii Remote to provide a natural, intuitive and realistic feel. Players can use their own Mii caricatures in the game and play them against their friends'' Miis for a more personalised experience. As players improve, their Miis'' skill levels will increase, so that they can see exactly how much better they''ve become.</p>\r\n<p>&nbsp;</p>\r\n<p><br />\r\n&bull;In Tennis, you''ll grab the controller like a racket and swing - the game will register forehands, backhands, volleys, lobs, slices, spin and power depending on how fast you swing and at what angle.</p>\r\n<p>&bull;Baseball will have you gripping the controller like a bat and swatting fastballs out of the park in a home run derby.</p>\r\n<p>&bull;In Golf you''ll step up to the tee, hold the controller like a golf club and swing naturally to smack the ball onto the green.</p>\r\n<p>&bull;In Bowling, players raise the Wii Remote in their hand just like a bowling ball, and then swing their arms to roll the ball.</p>\r\n<p>&bull;When Boxing, using the Nunchuk controller as one glove and the Wii Remote as the other, players dodge, weave and punch their opponents.</p>\r\n<p>Details:</p>\r\n<p>General</p>\r\n<p>&bull;Version: UK PAL <br />\r\nProcessor <br />\r\n&bull;Details: PowerPC CPU (code-named &quot;Broadway&quot;) Made with a 90 nm SOI CMOS process, jointly developed with and manufactured by IBM. <br />\r\nConnections <br />\r\n&bull;Connections: AV Multi-output port for component, composite or S-video. <br />\r\n&bull;Built in Wi-Fi: Yes <br />\r\n&bull;USB: 2 x USB 2.0 ports <br />\r\n&bull;Other: Four ports for classic Nintendo GameCube controllers. Two slots for Nintendo GameCube Memory Cards. SD memory card slot. <br />\r\nMemory <br />\r\n&bull;Details: 512 MB Internal Flash</p>\r\n<p><b>What''s in the box: </b></p>\r\n<p>&bull;AC Adapter<br />\r\n&bull;Console Stand<br />\r\n&bull;Nintendo Nunchuk<br />\r\n&bull;Nintendo Wii Console <br />\r\n&bull;Sensor Bar<br />\r\n&bull;Wii Sports<br />\r\n&bull;Wireless Wii Remote</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092340129_WiiNintendo_Console.gif', '', '', '', '', '', '', '', '', 0, 76, date_add(NOW(),INTERVAL 4333 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'unpaid'),
(590, 20, 4, 23, 'Wii Fit | Nintendo WiiFit + Balance Board', '1', 1, '', '<p><b>Wii Fit | Nintendo WiiFit + Balance Board</b></p>\r\n<p><b>Description:</b></p>\r\n<p>Please note, due to shortages of Wii Fit stock across the UK, delivery of this item may be delayed by up to 4 weeks from payment.</p>\r\n<p>Wii Fit is designed to be enjoyed by the whole family. In Japan it has been encouraging family members as a whole to discuss the topic of fitness and take an active interest in understanding their own fitness in a fun and entertaining way, all in the comfort of their own home.</p>\r\n<p>Wii Fit comes bundled with the Wii Balance Board, an accessory developed exclusively for the Wii console that will have a far-reaching impact for all who use it. It&rsquo;s innovative, exciting and most of all fun and simple for all to use. It is a pressure sensitive, wireless balance board that goes on the floor &ndash; so someone can stand on it in front of the TV. It senses weight and shift in balance in any direction and therefore by standing on the Wii Balance Board during activities allows players to follow along to movements ensuring they have full control of the on-screen activities. This allows personal improvement goals to be set to effectively help you and your family to train and stay fit.</p>\r\n<p>Increasing your awareness of the importance that fitness has on everyday life and keeping yourself and family motivated should be easier with Wii Fit. The programme allows up to 8 people to track progress and monitor performance. Once you insert the Wii Fit Disc into a Wii console, a new channel - Wii Fit Channel can be added to your Wii Menu system. Once the Wii Fit Channel is added it enables users to not have to insert the Wii Fit Disc into a Wii console in order for the Wii Balance Board to scale your weight to calculate your BMI, measure the center of your bodily balance and conduct a balance test in order to calculate your Wii Fit Age. It also allows you to monitor how long you did which category of exercise for in one day, all in the comfort of your own home and without the need to keep inserting the Wii Fit Disk into your Wii console each time.</p>\r\n<p>There are 4 training categories including Aerobic Exercises, Muscle Workouts, Yoga and Balance Games that will help you and your family to develop bodily balance control ability, burn fat in the body, help tone and condition muscles, as well as help increase aerobic stamina. Discover over 40 different activities within these training categories such as Hula Hoop&trade;, Ski Jump, Press-up Challenge, Rhythm Boxing, Rowing Squat, Lunge and classic Yoga poses such as Half Moon, Tree and Crocodile Twist. With all this on offer and much more, Wii Fit along with the Wii Balance Board introduces an accessible and intuitive programme for all the family to enjoy.</p>\r\n<p>Through Wii Fit&rsquo;s training programme, helpful tutorials and encouragements from your on-screen fitness trainer, who will change his or her verbal instructions depending on how you actually perform, and the included Wii Fit Channel, you will continue to have endless fun whilst having the satisfaction of knowing you are aiding yourself, and your family, on towards a path of a healthier lifestyle.</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Balance Board<br />\r\n&bull;Nintendo Wii Fit</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092340259_wiifit.gif', '', '', '', '', '', '', '', '', 0, 79, date_add(NOW(),INTERVAL 4563 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'unpaid'),
(592, 20, 4, 23, 'DS | Nintendo DS Lite (Red)', '1', 1, '', '<p><b>DS | Nintendo DS Lite (Red)</b></p>\r\n<p><b>Dual Display - Touch Screen (use stylus or finger) - PictoChat - Built-in Microphone - Advanced 3D graphics engine - Wi-Fi Capability</b></p>\r\n<p><b><br />\r\nDescription:</b></p>\r\n<p>With impressive 3D rendered graphics and ultra-bright screens, Nintendo DS Lite delivers cutting-edge portable games for fans of any genre. Plus, you can connect wirelessly to Nintendo Wi-Fi Connection and challenge players around the world. Sleeker than the original Nintendo DS console, it features a more streamlined flip-top DS design.</p>\r\n<p>Nintendo DS Lite retains the advanced touch screen technology, allowing players to control the software with a stylus or even their finger, as well as dual screens, voice recognition and Wi-Fi capabilities of the Nintendo DS but is now both smaller and lighter. Weighing nearly 60g less than the original, it is just two thirds of the original size. The redesign isn''t only cosmetic though, the Nintendo DS Lite features adjustable screen brightness with four settings, a repositioned microphone for ease of use and a larger and more comfortable stylus. With its new design and unique features, this console is perfect for everyone regardless of age, gender and gaming skills.</p>\r\n<p>&nbsp;</p>\r\n<p><br />\r\n&bull;Dual Screens open up new possibilities - use the touch screen as an inventory reference for role-playing games, to view maps for your favourite strategy game, or see racing action from two perspectives at once</p>\r\n<p>&bull;Navigate menus or access inventory items simply by touching the screen with stylus or fingertip</p>\r\n<p>&bull;Tough film over touchscreen offers good protection</p>\r\n<p>&bull;Advanced 3D graphics engine and 16-channel audio, for graphics and Sound that are superior to other portable game systems</p>\r\n<p>&bull;All-new PictoChat feature allows DS users to write messages with an on-screen Keyboard or the stylus and send them wirelessly</p>\r\n<p>&bull;Built-in Microphone port for voice control of games, or for voice chat with other DS players</p>\r\n<p>&bull;Less than two-thirds the size of the original Nintendo DS</p>\r\n<p>&bull;More than 20 percent lighter than original DS</p>\r\n<p>&bull;4 adjustable brightness levels to extend battery life</p>\r\n<p>&bull;Repositioned microphone and LED lights</p>\r\n<p>&bull;Stylus has been redesigned//now 1cm longer and 1mm thicker</p>\r\n<p>&bull;Repositioned start and select buttons</p>\r\n<p><br />\r\nDetails:</p>\r\n<p>Console Specifications</p>\r\n<p>&bull;Model: Nintendo DS Lite <br />\r\n&bull;Colour: Red <br />\r\n&bull;Audio: Integrated stereo speakers <br />\r\n&bull;Secondary display: 3&quot; Touchscreen LCD <br />\r\n&bull;Main Display: 3&quot; LCD TFT. Resolution 256 x 192 <br />\r\n&bull;Features: Built-in microphone, voice control, Wi-Fi <br />\r\n&bull;Dimensions: 2.2 (D) x 7.4 (W) x 13.3 (H) cm <br />\r\n&bull;Battery: Rechargeable Lithium Ion <br />\r\n&bull;Video Output: 2D/3D graphics acceleration <br />\r\n&bull;Version: UK</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Charger<br />\r\n&bull;Nintendo DS Lite (Red)<br />\r\n&bull;User Guide</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092340449_DS_Nintendo_Red.gif', '', '', '', '', '', '', '', '', 0, 59, date_add(NOW(),INTERVAL 4543 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 0, 'no', '0000-00-00 00:00:00', 'unpaid'),
(593, 20, 4, 23, 'DS | Nintendo DS Lite (Turquoise', '1', 1, '', '<p><b>DS | Nintendo DS Lite (Turquoise)</b></p>\r\n<p><b>Dual Display - Touch Screen (use stylus or finger) - PictoChat - Built-in Microphone - Advanced 3D graphics engine - Wi-Fi Capability</b></p>\r\n<p><b><br />\r\nDescription:</b></p>\r\n<p>With impressive 3D rendered graphics and ultra-bright screens, Nintendo DS Lite delivers cutting-edge portable games for fans of any genre. Plus, you can connect wirelessly to Nintendo Wi-Fi Connection and challenge players around the world. Sleeker than the original Nintendo DS console, it features a more streamlined flip-top DS design.</p>\r\n<p>Nintendo DS Lite retains the advanced touch screen technology, allowing players to control the software with a stylus or even their finger, as well as dual screens, voice recognition and Wi-Fi capabilities of the Nintendo DS but is now both smaller and lighter. Weighing nearly 60g less than the original, it is just two thirds of the original size. The redesign isn''t only cosmetic though, the Nintendo DS Lite features adjustable screen brightness with four settings, a repositioned microphone for ease of use and a larger and more comfortable stylus. With its new design and unique features, this console is perfect for everyone regardless of age, gender and gaming skills.</p>\r\n<p>&nbsp;</p>\r\n<p><br />\r\n&bull;Dual Screens open up new possibilities - use the touch screen as an inventory reference for role-playing games, to view maps for your favourite strategy game, or see racing action from two perspectives at once</p>\r\n<p>&bull;Navigate menus or access inventory items simply by touching the screen with stylus or fingertip</p>\r\n<p>&bull;Tough film over touchscreen offers good protection</p>\r\n<p>&bull;Advanced 3D graphics engine and 16-channel audio, for graphics and Sound that are superior to other portable game systems</p>\r\n<p>&bull;All-new PictoChat feature allows DS users to write messages with an on-screen Keyboard or the stylus and send them wirelessly</p>\r\n<p>&bull;Built-in Microphone port for voice control of games, or for voice chat with other DS players</p>\r\n<p>&bull;Less than two-thirds the size of the original Nintendo DS</p>\r\n<p>&bull;More than 20 percent lighter than original DS</p>\r\n<p>&bull;4 adjustable brightness levels to extend battery life</p>\r\n<p>&bull;Repositioned microphone and LED lights</p>\r\n<p>&bull;Stylus has been redesigned//now 1cm longer and 1mm thicker</p>\r\n<p>&bull;Repositioned start and select buttons</p>\r\n<p><br />\r\nDetails:</p>\r\n<p>Console Specifications</p>\r\n<p>&bull;Model: Nintendo DS Lite <br />\r\n&bull;Colour: Turquoise <br />\r\n&bull;Audio: Integrated stereo speakers <br />\r\n&bull;Secondary display: 3&quot; Touchscreen LCD <br />\r\n&bull;Main Display: 3&quot; LCD TFT. Resolution 256 x 192 <br />\r\n&bull;Features: Built-in microphone, voice control, Wi-Fi <br />\r\n&bull;Dimensions: 2.2 (D) x 7.4 (W) x 13.3 (H) cm <br />\r\n&bull;Battery: Rechargeable Lithium Ion <br />\r\n&bull;Video Output: 2D/3D graphics acceleration <br />\r\n&bull;Version: UK</p>\r\n<p><b><br />\r\nWhat''s in the box: </b></p>\r\n<p>&bull;Charger<br />\r\n&bull;Nintendo DS Lite (Turquoise)<br />\r\n&bull;User Guide</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092342854_D_Nintendo_Turquoise.gif', '', '', '', '', '', '', '', '', 0, 52, date_add(NOW(),INTERVAL 4576 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 0, 'no', '0000-00-00 00:00:00', 'unpaid'),
(594, 20, 4, 23, 'Epson Stylus DX8400 ', '1', 0, '', '<p><b>Epson Stylus DX8400 </b></p>\r\n<p><b>All-in-one PrinterPrint directly from memory cards - Scan documents up to 1200DPI - 2.5&quot; LCD screen - Complete printing and copying solution - Prints 32ppm</b></p>\r\n<p><b><br />\r\nDescription:</b></p>\r\n<p>Bring quality, versatility and value to all your home printing. Print, scan and copy documents and photos from one compact desktop location and use the LCD viewer for even easier PC-free operation. This advanced all-in-one printer, scanner and copier is perfect for high-quality document and photo management. You can easily print directly from your PictBridge digital camera or memory card via the 6.3 cm LCD viewer - even without a PC.</p>\r\n<p>Epson''s latest generation of DURABrite Ultra Ink provides laser-like text and glossy photos, and is resistant to water, smudging and fading. It is also cost-effective due to individual ink cartridges.</p>\r\n<p>Details:</p>\r\n<p>General</p>\r\n<p>&bull;Width: 45 cm <br />\r\n&bull;Depth: 34 cm <br />\r\n&bull;Height: 17.9 cm <br />\r\n&bull;Weight: 6 kg <br />\r\n&bull;Type: Copier / printer / scanner <br />\r\n&bull;Display Size: 2.5&quot; <br />\r\n&bull;Supported Flash Memory: CompactFlash, IBM Microdrive, Memory Stick, Memory Stick PRO, MultiMediaCard, SD Memory Card, SmartMedia, XD-Picture Card <br />\r\nPower supply <br />\r\n&bull;Required voltage: AC 230 V <br />\r\n&bull;Power Consumption (in use): 12 Watt <br />\r\n&bull;Power Consumption (sleep): 3 Watt <br />\r\nCopying <br />\r\n&bull;Max Copying Speed: 29 ppm (b/w and colour) <br />\r\nPrinter <br />\r\n&bull;Colour: Yes <br />\r\n&bull;Technology: Ink-jet <br />\r\n&bull;Max Resolution: 5760 x 1440 dpi (b/w and colour) <br />\r\n&bull;Max Printing Speed: 32ppm (b/w and colour) <br />\r\nScanning <br />\r\n&bull;Scan Element: CIS <br />\r\n&bull;Optical Resolution: 1200 x 2400 dpi <br />\r\nDocument and Media Handling <br />\r\n&bull;Supported Media Type: Photo paper, plain paper, envelopes <br />\r\n&bull;Standard Media Capacity: 120 <br />\r\nPC Connectivity <br />\r\n&bull;Software included: ABBYY FineReader 5.0 Sprint Plus, ABBYY FineReader 6.0 Sprint Plus, Drivers &amp; Utilities, EPSON Attach to Email, EPSON Copy Utility, EPSON Creativity Suite, Epson Easy Photo Print, Epson Scan Assistant, EPSON Web-to-Page <br />\r\n&bull;PC Connection Availability: Yes <br />\r\n&bull;PC Connection: Hi-Speed USB, USB host <br />\r\n&bull;Supported operating systems: Apple MacOS X 10.2.8 or later, MS Windows 2000, MS Windows 98 SE, MS Windows ME, MS Windows Vista, MS Windows XP, MS Windows XP 64-bit Edition <br />\r\nPrinting System <br />\r\n&bull;Minimum Ink Droplet Size: 3 pl <br />\r\n&bull;Nozzle Configuration: 4 x 90 nozzles <br />\r\n&bull;Inkjet Technology: Epson Micro Piezo <br />\r\n&bull;Colour: 4-ink <br />\r\n&bull;Ink Palette Supported (Colours): Cyan, magenta, yellow, black <br />\r\n&bull;Ink Type: Epson DURABrite Ultra inks</p>\r\n<p>&nbsp;</p>\r\n<p><b>What''s in the box: </b></p>\r\n<p>&bull;Epson Stylus DX8400 All-in-one Printer<br />\r\n&bull;Power Lead<br />\r\n&bull;User Guide</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092343041_Epson_Stylus.gif', '', 'special.jpg', '', '', '', '', '', '', 1, 80, date_add(NOW(),INTERVAL 8997 SECOND), '', '', 32.00, 'yes', 1, 137.00, '', 'no', 'no', 200.00, '', 300, 'yes', 0, 0, 'no', '0000-00-00 00:00:00', 'unpaid'),
(595, 20, 4, 23, 'Logitech Cordless Wave Keyboard and Mouse', '1', 1, '', '<p><b>Logitech Cordless Wave Keyboard and Mouse</b></p>\r\n<p><b>Description:</b></p>\r\n<p>Catch the wave, with the Logitech Wave Keyboard - the exciting new shape of comfort, that conforms naturally to your fingers.</p>\r\n<p>Comfort</p>\r\n<p><br />\r\n&bull;Wave key design: Contoured, wave-shaped key design conforms naturally to your fingers. <br />\r\n&bull;Constant Curve design: A curved profile and uniform-size keys promote an ergonomically correct, more comfortable hand position. Start enjoying the benefits instantly, without having to re-learn typing on a different keyboard layout. <br />\r\n&bull;Cushioned, contoured palm rest: The soft surface encourages a relaxed position for long typing sessions. <br />\r\n&bull;Adjustable keyboard height: Use the three-way tilt legs to set the height to suit your personal style. <br />\r\n&bull;Comfortable mouse design: Also built for comfort, with contoured sides and soft rubber grips, the high-performance laser mouse adds unmatched precision and control on virtually all surfaces. <br />\r\n&bull;Audio cable management: Keep headphone cords out of the way by routing them through the channel on the underside of the keyboard.</p>\r\n<p>Control and Convenience</p>\r\n<p>&bull;Easy access to Windows Vista: Large, one-touch controls give you direct access to key Windows Vista features, including Flip 3D, Zoom, Photo Gallery, and Gadgets. <br />\r\n&bull;Instant media access: Use the convenient one-touch controls for volume and media playback. A dedicated button starts Media Center or Front Row. <br />\r\n&bull;Programmable F-keys: Get instant access to favourite applications, games, folders, and Web pages with customisable F-keys. <br />\r\n&bull;Longer battery life: Enjoy extended battery life&mdash;up to 15 months for the keyboard and 6 months for the mouse. Battery status lights on both the keyboard and mouse alert you when power is getting low. <br />\r\n&bull;Cordless freedom: End cable clutter with fast, reliable Logitech&reg; wireless technology. <br />\r\n&bull;High-performance Laser Mouse: Experience unmatched precision and control on surfaces where ordinary optical mice can''t go.</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Logitech Cordless Wave Keyboard<br />\r\n&bull;Logitech LX8 Cordless Laser Mouse<br />\r\n&bull;USB mini-receiver<br />\r\n&bull;USB extension cable<br />\r\n&bull;Plastic keyboard dust cover<br />\r\n&bull;4 AA alkaline batteries<br />\r\n&bull;CD with software, comfort guidelines, and help center<br />\r\n&bull;Quick Start guide<br />\r\n&bull;5-year limited hardware warranty</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092343542_Logitech_Cordless_Wave.gif', '', '', '', '', '', '', '', '', 0, 60, date_add(NOW(),INTERVAL 4567 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 0, 'no', '0000-00-00 00:00:00', 'unpaid'),
(596, 20, 4, 23, 'Rothenschild Stingray RS-0612-SR Gents Watch', '1', 1, '', '<p><b>Rothenschild Stingray RS-0612-SR Gents Watch</b></p>\r\n<p><b>Description:</b></p>\r\n<p>A luxury watch from Rothenschild, crafted to the highest specificationand features a 316L stainless casing. Rothenschild set the stakes high when it comes to design, manufacturing and function. These high standards are evident in the entire range of luxury watches that Rothenschild offer, and the Stingray RS-0612-SR gents watch is no exception!</p>\r\n<p>Details:</p>\r\n<p><br />\r\n&bull;Model-No: Rothenschild Stingray RS-0612-SR <br />\r\n&bull;Type: Automatic Caliber <br />\r\n&bull;Material: Stainless Steel 316L <br />\r\n&bull;Dial colour: Red <br />\r\n&bull;Water Resistance: 5 ATM (50m) <br />\r\n&bull;Diameter: 44mm (without housing) <br />\r\n&bull;Height: 14mm <br />\r\n&bull;Weight: 188g <br />\r\n&bull;Features: Hour, minute, seconds, days.</p>\r\n<p><b><br />\r\nWhat''s in the box: </b></p>\r\n<p>&bull;Rothenschild Stingray RS-0612-SR Gents Watch<br />\r\n&bull;Presentation Box<br />\r\n&bull;2 Year Warranty</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092343726_Rothenschild_Stingray.gif', '', '', '', '', '', '', '', '', 0, 61, date_add(NOW(),INTERVAL 3456 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 0, 'no', '0000-00-00 00:00:00', 'unpaid'),
(597, 20, 4, 23, 'TomTom Go 930T Sat Nav', '1', 0, '', '<p><b>TomTom Go 930T Sat Nav</b></p>\r\n<p><b>Description:</b></p>\r\n<p>You''ll never get lost again while you''re on your travels with the Go930T GPS from TomTom! It has maps of Europe and North America and a whole host of applications to make your journey easier. This GPS includes the IQ Routes function, which calculates the amount of time your journey will take according to the time and day you''re driving. For example, if you''re on a fast road but it''s rush hour, the TomTom 930T will suggest another route so you can avoid traffic jams ? and save on petrol! The traffic information feature will come in very handy when you''re coming up to tricky intersections and motorway exits, because you won''t need to hesitate before you find which direction you''re heading in. Advanced lane guidance technology gives you an accurate idea of which lane you need to be in for the next turn, which is especially useful for complicated junctions. You can even make hands-free calls thanks to built-in Bluetooth technology and a built-in FM transmitter. The TomTom 930T really does have everything you need to make driving a breeze!</p>\r\n<p>Features:</p>\r\n<p><br />\r\n&bull;IQ Routes technology <br />\r\n&bull;Advanced lane guidance <br />\r\n&bull;Easy access to traffic information <br />\r\n&bull;TomTom Map Share technology <br />\r\n&bull;Maps of Europe, US and Canada <br />\r\n&bull;Enhanced Positioning Technology <br />\r\n&bull;Voice address input <br />\r\n&bull;Hands-free calling <br />\r\n&bull;Built-in FM transmitter <br />\r\nSpecifications:</p>\r\n<p>&bull;Display: 4.3'' widescreen 16:9 format LCD (WQVGA: 480*272 pixels) <br />\r\n&bull;Processor: CPU 400 MHz, 64MB RAM <br />\r\n&bull;Memory: 4GB internal flash memory <br />\r\n&bull;Memory Card Slot: SD card socket compatible with SD and MMC cards <br />\r\n&bull;GPS: High sensitivity GPS receiver <br />\r\n&bull;Traffic Info: RDS-TMC traffic information receiver <br />\r\n&bull;Transmitter: Integrated FM transmitter <br />\r\n&bull;Bluetooth: Yes <br />\r\n&bull;Maps: Europe (Germany, Andorra, Austria, Belgium, Denmark, Spain (including Canary Islands), Finland, France, Great Britain, Italy, Liechtenstein, Luxembourg, Monaco, Norway, Netherlands, Portugal, Ireland, San Marino, Sweden, Switzerland, Vatican City, Croatia, Estonia, Hungary, Latvia, Lithuania, Poland, Slovakia, Slovenia, Czech Republic and Russia. Also includes the main roads in Albania, Belarus, Bosnia-Herzegovina, Bulgaria, Macedonia, Moldavia, Montenegro, Romania, Serbia and Ukraine) United States and Canada <br />\r\n&bull;Battery: Lithium-polymer (up to 5 hours autonomous operation) <br />\r\n&bull;Audio: Optimised integrated microphones and speaker for high quality hands-free functionality <br />\r\n&bull;Dimensions: 118 x 83 x 24mm <br />\r\n&bull;Weight: 220 grams</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;TomTom Go 930T Sat Nav<br />\r\n&bull;Windscreen mount<br />\r\n&bull;Desk dock<br />\r\n&bull;Car Charger<br />\r\n&bull;RDS-TMC receiver<br />\r\n&bull;Bluetooth remote control<br />\r\n&bull;CD-Rom<br />\r\n&bull;Documentation</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092344634_TomTom_Go_930T_Sat_Nav.gif', '', '', '', '', '', '', '', '', 2, 95, date_add(NOW(),INTERVAL 5643 SECOND), '', '', 32.00, 'yes', 1, 45.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 0, 'no', '0000-00-00 00:00:00', 'unpaid')");
$SQL=MYSQL_QUERY("INSERT INTO `auction_details` (`productid`, `user_id`, `category_main`, `category_id`, `producttitle`, `item_counter_style`, `Quantity`, `payment_gateway`, `detailed_descrip`, `selling_method`, `min_bid_amount`, `bidincrement`, `shipping_cost`, `who_pay_shipping`, `shipping_route`, `duration`, `currency`, `reserve_price`, `quick_buy_price`, `bid_starting_date`, `start_delay`, `status`, `picture1`, `picture2`, `picture3`, `picture4`, `picture5`, `picture6`, `picture7`, `picture8`, `payment_name`, `quantity_sold`, `clicks`, `expire_date`, `payment_id`, `size_of_quantity`, `tax`, `sniper`, `no_of_repost`, `sale_price`, `s_repost`, `shop`, `relisted`, `or_price`, `return_pol`, `timetoadd`, `special`, `discount`, `totbid`, `stopped`, `closetime`, `ship_stat`) VALUES
(598, 20, 4, 23, '16 GB SDHC Class 6 Memory Card', '1', 1, '', '<p><b>16 GB SDHC Class 6 Memory Card</b></p>\r\n<p><b>Description:</b></p>\r\n<p>With 16GB of storage space and a lightning-fast class 6 transfer rate, this SDHC memory card is perfect for storing photos on your digital camera.</p>\r\n<p>Details:</p>\r\n<p>General</p>\r\n<p>&bull;Product type: Flash memory card <br />\r\n&bull;Compatability: SDHC <br />\r\n&bull;Memory capacity: 16GB <br />\r\n&bull;Class: 6 - 6 MB/s <br />\r\n&bull;Transfer Rate: 133x</p>\r\n<p><b>What''s in the box: </b></p>\r\n<p>&bull;16 GB SDHC Class 6 Memory Card</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092520531_16GBMemory_Card.gif', '', '', '', '', '', '', '', '', 0, 66, date_add(NOW(),INTERVAL 4567 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 0, 'no', '0000-00-00 00:00:00', 'unpaid'),
(603, 20, 8, 51, 'Segafredo Intermezzo Espresso Coffee Beans 8kg', '1', 1, '', '<p><b>Segafredo Intermezzo Espresso Coffee Beans 8kg</b></p>\r\n<p><b>Description:</b></p>\r\n<p>Born out of the coffee professionals&rsquo; passion and experience, a mature taste, full of energy, it offers real pleasure! No intermezzo but rather an excellent coffee for every occasion. When it was still only sold in Italy this blend of Arabica and Robusta coffees was simply called Tradizionale Rossa, especially since it is one of the oldest recipes from Segafredo. For many years Segafredo Intermezzo was the only espresso available as beans in Germany; it has done the groundwork for today&rsquo;s espresso wave. This coffee and Segafredo must be praised for this job. Segafredo Intermezzo is mostly used in coffee machines in major offices as it also boasts a good price-performance ratio. One can say Segafredo Intermezzo is a relatively strong and spicy coffee with a good structure and full-bodied aromas and presence.</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Segafredo Intermezzo Espresso Coffee Beans 8kg</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092520650_Segafredo.gif', '', '', '', '', '', '', '', '', 0, 66, date_add(NOW(),INTERVAL 2376 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'unpaid'),
(604, 20, 4, 23, 'Corsair Voyager Mini 4 GB', '1', 1, '', '<p><b>Corsair Voyager Mini 4 GB</b></p>\r\n<p><b>Description:</b></p>\r\n<p><br />\r\nThe Flash Voyager Mini utilizes a cap-less retractable connector plug which easily opens with the flick of the thumb, and its ergonomic rubberized housing makes it easy to connect and disconnect from any computer. This makes it the perfect flash drive for users with busy and active lifestyles. Utilizing the latest Chip-on-Board technology the Flash Voyager Mini is the perfect synergy of size, looks and function.</p>\r\n<p>&nbsp;</p>\r\n<p>Details:</p>\r\n<p>&bull;Durable &amp; Shock Proof <br />\r\n&bull;Retractable connector tip <br />\r\n&bull;Warranty: 10 Years <br />\r\n&bull;Capacity: 4 GB <br />\r\n&bull;Interface: USB 2.0 <br />\r\n&bull;Transfer Rate: Up to 480mbps <br />\r\n&bull;Dimensions: Width 95mm / Height 132mm / Depth 20mm</p>\r\n<p><b><br />\r\nWhat''s in the box: </b></p>\r\n<p>&bull;Corsair Voyager Mini 4 GB</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092520758_Corsair_Voyager.gif', '', '', '', '', '', '', '', '', 0, 70, date_add(NOW(),INTERVAL 4578 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 0, 'no', '0000-00-00 00:00:00', 'unpaid'),
(605, 20, 4, 23, 'DS | Nintendo DS Lite Black', '1', 1, '', '<p><b>DS | Nintendo DS Lite Black</b></p>\r\n<p><b>Dual Display - Touch Screen (use stylus or finger) - PictoChat - Built-in Microphone - Advanced 3D graphics engine - Wi-Fi Enabled</b></p>\r\n<p><b><br />\r\nDescription:</b></p>\r\n<p>With impressive 3D rendered graphics and ultra-bright screens, Nintendo DS Lite delivers cutting-edge portable games for fans of any genre. Plus, you can connect wirelessly to Nintendo Wi-Fi Connection and challenge players around the world. Sleeker than the original Nintendo DS console, it features a more streamlined flip-top DS design.</p>\r\n<p>Nintendo DS Lite retains the advanced touch screen technology, allowing players to control the software with a stylus or even their finger, as well as dual screens, voice recognition and Wi-Fi capabilities of the Nintendo DS but is now both smaller and lighter. Weighing nearly 60g less than the original, it is just two thirds of the original size. The redesign isn''t only cosmetic though, the Nintendo DS Lite features adjustable screen brightness with four settings, a repositioned microphone for ease of use and a larger and more comfortable stylus. With its new design and unique features, this console is perfect for everyone regardless of age, gender and gaming skills.</p>\r\n<p>&nbsp;</p>\r\n<p><br />\r\n&bull;Dual Screens open up new possibilities - use the touch screen as an inventory reference for role-playing games, to view maps for your favourite strategy game, or see racing action from two perspectives at once</p>\r\n<p>&bull;Navigate menus or access inventory items simply by touching the screen with stylus or fingertip</p>\r\n<p>&bull;Tough film over touchscreen offers good protection</p>\r\n<p>&bull;Advanced 3D graphics engine and 16-channel audio, for graphics and Sound that are superior to other portable game systems</p>\r\n<p>&bull;All-new PictoChat feature allows DS users to write messages with an on-screen Keyboard or the stylus and send them wirelessly</p>\r\n<p>&bull;Built-in Microphone port for voice control of games, or for voice chat with other DS players</p>\r\n<p>&bull;Less than two-thirds the size of the original Nintendo DS</p>\r\n<p>&bull;More than 20 percent lighter than original DS</p>\r\n<p>&bull;4 adjustable brightness levels to extend battery life</p>\r\n<p>&bull;Repositioned microphone and LED lights</p>\r\n<p>&bull;Stylus has been redesigned//now 1cm longer and 1mm thicker</p>\r\n<p>&bull;Repositioned start and select buttons</p>\r\n<p><br />\r\nDetails:</p>\r\n<p>Console Specifications</p>\r\n<p>&bull;Model: Nintendo DS Lite <br />\r\n&bull;Colour: Black <br />\r\n&bull;Audio: Integrated stereo speakers <br />\r\n&bull;Secondary display: 3&quot; Touchscreen LCD <br />\r\n&bull;Main Display: 3&quot; LCD TFT. Resolution 256 x 192 <br />\r\n&bull;Features: Built-in microphone, voice control, Wi-Fi <br />\r\n&bull;Dimensions: 2.2 (D) x 7.4 (W) x 13.3 (H) cm <br />\r\n&bull;Battery: Rechargeable Lithium Ion <br />\r\n&bull;Video Output: 2D/3D graphics acceleration <br />\r\n&bull;Version: UK</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Nintendo DS Lite Black<br />\r\n&bull;User Guide</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092521008_Nintend_+DS.gif', '', '', '', '', '', '', '', '', 0, 82, date_add(NOW(),INTERVAL 8756 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'unpaid'),
(606, 20, 4, 23, 'Maxtor OneTouch 4 Mini 250GB Portable Hard Drive', '1', 1, '', '<p><b>Maxtor OneTouch 4 Mini 250GB Portable Hard Drive</b></p>\r\n<p><b>Description:</b></p>\r\n<p>You and your content belong together. The Maxtor OneTouch 4 Mini is a portable hard drive weighing less than 6 ounces, making it easy to confidently carry your up-to-date portfolio and important files in your pocket, briefcase, or backpack. Ideal for students and traveling business people, this portable external hard drive is designed for ease-of-use, with a simple user interface that makes automated backup scheduling, specific file restoration, and security a snap. You can also automatically sync data on multiple computers so you always have your latest files handy. The OneTouch 4 Mini now includes Maxtor SafetyDrill&trade; for complete recovery of your PC hard drive&rsquo;s contents in case of a system crash or virus/spyware attack. To further safeguard your important files, Maxtor OneTouch 4 Mini comes with two levels of security - both data encryption and Maxtor DrivePass.</p>\r\n<p><br />\r\n&bull;Portable - Work and play on the go. This lightweight, portable drive lets you bring important files with you. <br />\r\n&bull;Rugged Design - Built in shock-resistent design ensures durability <br />\r\n&bull;USB Interface - Connect using the USB 2.0 cable. The Mini draws power from the computer, to help free you from carrying around an extra power cord. <br />\r\n&bull;5400 RPM, 8 MB cache buffer - For fast drive performance and instant access to your files. <br />\r\n&bull;Maxtor SafteyDrill - Prepares, reboots, and recovers your PC&rsquo;s entire internal drive contents in case of system failure or virus/spyware infection. Windows only. <br />\r\n&bull;Sync your files - Automatically synchronize your files between two computers every time you connect or disconnect the drive so you are always working with the most current data. <br />\r\n&bull;Easy to Use Interface - Get up and running fast. Simplifies drive management, security, and backup scheduling. <br />\r\n&bull;Maxtor DrivePass and encryption - Password protect the contents of your drive with two levels of security. <br />\r\n&bull;Simple set up - Plug it in, connect the USB 2.0 cable, and your Maxtor OneTouch&trade; 4 Mini automatically appears on your desktop.</p>\r\n<p>Details:</p>\r\n<p>General</p>\r\n<p>&bull;Weight: 167g <br />\r\n&bull;Dimensions: 124.63 x 15 x 81.86 mm <br />\r\nSoftware/System requirements <br />\r\n&bull;Compatability: PC &amp; Mac <br />\r\nHard Drive <br />\r\n&bull;Speed: 5400 RPM <br />\r\n&bull;Form Factor: 2.5-inch ATA <br />\r\n&bull;Capacity: 250GB <br />\r\n&bull;Interface Type: USB 2.0 and 1.1 compliant <br />\r\n&bull;Interface Transfer Rate: Up to USB 2.0 480Mb/sec <br />\r\n&bull;Cache: 8MB</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Maxtor Backup and OneTouch Manager software applications<br />\r\n&bull;Maxtor 5-Year Limited Warranty<br />\r\n&bull;Quick start guide<br />\r\n&bull;USB 2.0 Y cable<br />\r\n&bull;Maxtor OneTouch 4 Mini 250GB Portable Hard Drive with preloaded installation software<br />\r\n&bull;Maxtor SafetyDrill Recovery CD</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092521118_Maxtor.gif', '', '', '', '', '', '', '', '', 0, 56, date_add(NOW(),INTERVAL 3452 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'unpaid'),
(607, 20, 4, 23, 'Sony BRAVIA KDL-40D3500U 40', '1', 1, '', '<p><b>Sony BRAVIA KDL-40D3500U 40&quot; HD </b></p>\r\n<p><b>Ready LCD TVHD 1080p Compatible - 16,000:1 Dynamic Contrast Ratio - Brightness 450cd/m&sup2; - 1920 x 1080 Pixel Resolution - BRAVIA Engine - 2x HDMI Inputs - Integrated Freeview</b></p>\r\n<p><b><br />\r\nDescription:</b></p>\r\n<p>The BRAVIA D3500 Series LCD TVs are HD1080 and come packed with technology, delivering stunning picture as a result of Sony unique technologies including BRAVIA Engine and a Dynamic Contrast ratio of 16,000:1! Ideal if you''re looking to to buy into HD1080 technology and have access to HD1080 content such as Sky Sports / Blu-ray / PlayStation 3. This 40&quot; TV from Sony also has a built in Freeview tuner, giving you access to plenty of free channels. Other features include:</p>\r\n<p><br />\r\n&bull;6.2 Mega Pixel resolution and BRAVIA Engine for enhanced picture clarity and definition <br />\r\n&bull;Live Colour Creation producing vibrant and natural colours <br />\r\n&bull;HD 1080p compatible to display High Definition signals in breathtaking quality, i.e. Playstation 3, Blu-Ray, etc. <br />\r\n&bull;2 x HDMI inputs for easy connectivity <br />\r\n&bull;24p True Cinema to experience home cinema exactly as the director intended <br />\r\n&bull;BRAVIA Theatre Sync enabling you to operate your TV and entire home cinema system by pushing one button <br />\r\n&bull;Built-in Digital TV (MPEG 2) terrestrial tuner (also receives analogue) <br />\r\n&bull;Photo TV HD technology for viewing high-resolution digital still photographs in optimal quality <br />\r\n&bull;S Force Front Surround creating the effect of full surround sound from just 2 front speakers</p>\r\n<p>Details:</p>\r\n<p>General</p>\r\n<p>&bull;Width: 981 mm <br />\r\n&bull;Colour: Black <br />\r\n&bull;Weight with stand: 24 <br />\r\n&bull;Weight without stand: 20.5 <br />\r\n&bull;Depth with ped. Stand: 265 mm <br />\r\n&bull;Depth without ped. Stand: 110 mm <br />\r\n&bull;Height with ped. Stand: 692 <br />\r\n&bull;Height without ped. Stand : 643 <br />\r\nAudio output <br />\r\n&bull;Power output: 10W + 10W (Total 20W) <br />\r\n&bull;Digital Amplifier: Yes <br />\r\n&bull;Sound Mode: Dynamic/Standard/Custom <br />\r\n&bull;S-Force Front Surround: Yes <br />\r\nPower supply <br />\r\n&bull;Power consumption (in use): 193 W <br />\r\n&bull;Standby power consumption: 0.3 W <br />\r\nConnections <br />\r\n&bull;SCART: 2 <br />\r\n&bull;PC Input: Yes <br />\r\n&bull;HDMI: 2 <br />\r\n&bull;Component Video: Yes <br />\r\n&bull;Headphones: Yes <br />\r\n&bull;PCMCIA Card Slot: Yes <br />\r\n&bull;RF Input: Yes <br />\r\n&bull;Bravia Theatre Sync: Yes <br />\r\n&bull;Rca AV Input: Yes <br />\r\n&bull;RCA Out: Yes <br />\r\nInteractive Features <br />\r\n&bull;Digital Text: Yes <br />\r\n&bull;Electronic Programme Guide: Yes <br />\r\nPicture <br />\r\n&bull;3D Digital Comb Filter: Yes <br />\r\n&bull;Dynamic Contrast Ratio: 16000:1 <br />\r\n&bull;Panel resolution: 1920 x 1080 pixels <br />\r\n&bull;Contrast Ratio: 1800:1 <br />\r\n&bull;Viewing angle: 178 Degrees <br />\r\n&bull;1080 HD Ready: Yes <br />\r\n&bull;Response time: 8ms <br />\r\n&bull;Screen Size: 40&quot; (102cm) <br />\r\n&bull;BRAVIA Engine: Yes <br />\r\nAspect Ratio: 16:9 <br />\r\nBrightness (cd/m&sup2;): 450 <br />\r\nDisplay Resolution: 6.2 Mega Pixels <br />\r\nPicture Mode: Vivid/Standard/Cinema <br />\r\nTuning <br />\r\n&bull;Digital ready: Ye <br />\r\n&bull;Freeview Digital Tuner: Yes <br />\r\n&bull;Analogue Tuner: Yes</p>\r\n<p><b>What''s in the box: </b></p>\r\n<p>&bull;Sony BRAVIA KDL-40D3500U 40&quot; HD Ready LCD TV<br />\r\n&bull;User Guide<br />\r\n&bull;Remote Control<br />\r\n&bull;Power Lead</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092521246_Sony_BRAVIA.gif', '', '', '', '', '', '', '', '', 0, 60, date_add(NOW(),INTERVAL 5674 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'unpaid'),
(608, 20, 4, 23, 'Samsung i900 Omnia SIM Free', '1', 1, '', '<p><b>Samsung i900 Omnia SIM Free</b></p>\r\n<p><b>Description:</b></p>\r\n<p><br />\r\nThe i900 Omnia runs atop of version 6.1 of Microsoft''s Windows Mobile Professional operating system. It supports quad-band GSM/EDGE as well as 2100MHz UMTS/HSDPA (7.2Mbps) network connectivity, with WiFi thrown in for good measure. Highlights of the Omnia include a large, 3.2-inch WQVGA (240x400 pixel) touchscreen display with stylus support. The display supports auto-rotation for apps and there is a TV-out function for when 3.2-inch just isn''t large enough. The i900 Omnia supports many different music and video formats, including Ogg Vorbis music and DivX and Xvid video. An FM radio is also included in case you forget to load up the i900''s 8GB internal storage with your favorite music, and you don''t have a microSDHC card lying around. Music can be enjoyed with wired or Bluetooth wireless headsets, thanks to the i900''s A2DP stereo Bluetooth capability. The Omnia also sports a high-spec camera, as well. The camera uses a 5 megapixel CMOS sensor with an autofocus lens and has such high end features as face and smile detection, image stabilization, wide dynamic range mode, and an automatic panoramic mode. A built-in GPS module with nav and geotagging capabilities is also on-board. The SGH-i900 Omnia uses Samsung''s TouchWiz user interface extensions on top of Windows Mobile. This means that users are free to navigate with taps, sweeps, or drags and drops as well as use the built-in optical mouse controller. Text input is handled by an on-screen virtual QWERTY keyboard.</p>\r\n<p><br />\r\nGeneral features:</p>\r\n<p>&bull;Quadband GSM 850/900/1800/1900 <br />\r\n&bull;Dimensions : 112 x 56.9 x 12.5 mm <br />\r\n&bull;Weight : 127 g <br />\r\n&bull;Display: TFT touchscreen, 65K colors <br />\r\n&bull;Display size: 240 x 400 pixels, 3.2 inches <br />\r\nRingtones:</p>\r\n<p>&bull;Polyphonic, MP3 <br />\r\nMemory: <br />\r\n&bull;Card Slot: MicroSD (TransFlash) <br />\r\n&bull;Internal Memory: 8 GB <br />\r\nConnectivity: <br />\r\n&bull;GPRS: Yes <br />\r\n&bull;HSDPA: Yes <br />\r\n&bull;Edge: Yes <br />\r\n&bull;WiFi: Yes <br />\r\n&bull;3G: HSDPA <br />\r\n&bull;Bluetooth: Yes <br />\r\n&bull;A2DP: Yes <br />\r\n&bull;USB: Yes <br />\r\nVideo</p>\r\n<p>&bull;Yes <br />\r\nFlashlight</p>\r\n<p>&bull;Yes <br />\r\nCamera resolution</p>\r\n<p>&bull;5 megapixels <br />\r\nBattery</p>\r\n<p>&bull;Stand-by-time: Up to 500 hours <br />\r\n&bull;Talk-time: Up to 5 hours and 50 <br />\r\nOther</p>\r\n<p>&bull;Messaging: SMS, EMS, MMS, Email, Instant Messaging <br />\r\n&bull;FM radio: Yes <br />\r\n&bull;Games: Yes <br />\r\n&bull;Speaker phone: Yes <br />\r\n&bull;Operating System:Microsoft Windows Mobile 6.1 Professional <br />\r\n&bull;Touch-screen: Yes</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Samsung i900 Omnia SIM Free<br />\r\n&bull;Battery<br />\r\n&bull;Charger<br />\r\n&bull;EarPlug<br />\r\n&bull;CD-Rom<br />\r\n&bull;User Manual<br />\r\n&bull;Stylus</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092521410_Samsungi900.gif', '', '', '', '', '', '', '', '', 0, 80, date_add(NOW(),INTERVAL 5678 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'unpaid'),
(609, 20, 4, 23, 'Casio Exilim EX-Z100 Silver', '1', 1, '', '<p><b>Casio Exilim EX-Z100 Silver</b></p>\r\n<p><b>10 Megapixel Sensor - Large 2.7&quot; Display - 4x Optical Zoom - Ultra Thin Design - Image Resolution 3648 x 2736 Pixels</b></p>\r\n<p><b><br />\r\nDescription:</b></p>\r\n<p>The Ex-Z100 from Casio has a 10 Megapixel sensor mounted on a 28 mm wide-angle lens plus a 4x optical zoom, so you''re guaranteed beautiful photos that are packed with detail, even in low lighting, thanks to its 1600 ISO sensitivity.</p>\r\n<p>10 Megapixel Resolution<br />\r\nLife seems 10 times more vivid once this Exilim starts shooting. The Exilim&rsquo;s 10 million pixels of extremely high resolution maximize clarity so detailed moments are captured the way you envisioned. Super-high resolution is maintained when printing very large sizes as well.</p>\r\n<p>Wide Angle 28 mm Lens<br />\r\nWith the new Wide Angle 28 mm lens you can get more picture in your frame. Get the entire football field or mountain range with one perfect shot.</p>\r\n<p>4x Optical Zoom<br />\r\nAllows zoom photography between 28 mm and 112 mm (35 mm film camera equivalent). This increases photographic enjoyment, from wide angle photography suitable for capturing large subjects or shooting up close in small spaces, right through to telephoto work.</p>\r\n<p>Wide 2.7 Inch Super Clear LCD<br />\r\nCasio Exilim has created a whole new viewing experience when taking pictures. With the high contrast and highest brightness, the new Super Clear LCD lets you see your shots better than ever, from any angle.</p>\r\n<p>Auto Shutter<br />\r\nLet your Casio Exilim do the thinking for you. With Auto Shutter functions, your camera will detect the perfect time to snap your picture. The new Casio Exilim cameras are equipped with Auto Shutter Functions that will make blurry pictures a thing of the past.</p>\r\n<p>Auto Best Shot<br />\r\nSometimes navigating through a camera&rsquo;s settings for the perfect shot can be a challenge. Not anymore. With Auto Best Shot, the Casio Exilim will analyze faces, focus, and exposure to find the perfect setting for your picture. So now you can shoot like a professional from your very first shot.</p>\r\n<p>Enhanced Video H.264 Wide<br />\r\nH.264 technology delivers superior-quality video, providing 30 frames per second at 640 x 480, that can be easily viewed on most video-sharing Web sites. With the wide video-shooting function (16:9 ratio), the Exilim plays true to your plasma or LCD television, regardless of size. The future of video is in your Exilim.</p>\r\n<p>Movie Button<br />\r\nWith the Movie Button on your Casio Exilim, you can record your favorite moments without having to change the settings on your camera. Finally, just point and record.</p>\r\n<p>Prerecord Video Mode<br />\r\nNow you never have to worry about &ldquo;just missing&rdquo; a moment. With the Prerecord Video Mode feature, your camera is recording video before you even press the button. In Prerecord Video Mode, the Exilim captures 5 seconds of video and saves it into memory then adds it to your video when you press the shutter. Never miss a moment with Exilim.</p>\r\n<p>Details:</p>\r\n<p>General</p>\r\n<p>&bull;Width: 111g <br />\r\n&bull;Product type: Ultra Compact Digital Camera <br />\r\n&bull;Colour: Silver <br />\r\n&bull;Model: Casio Exilim EX-Z100 Silver <br />\r\n&bull;Dimensions: 93.0 x 55.0 x 21.2 mm <br />\r\nDisplay <br />\r\n&bull;Type: LCD colour screen <br />\r\n&bull;Size: 2.7&quot; <br />\r\n&bull;Resolution: 959 x 240 resolution <br />\r\n&bull;Features: Ultra Bright <br />\r\nMain features <br />\r\n&bull;Digital Zoom: 4x <br />\r\n&bull;Video format: 848 x 480 at 30 fps <br />\r\n&bull;Picture format: JPEG <br />\r\n&bull;Shutter speeds: Auto: 1/2 - 1/1000 s, BEST SHOT night scene: 4 - 1/1000 s <br />\r\n&bull;Image resolution: 3648 x 2736 pixels <br />\r\n&bull;Video function: Yes, with sound <br />\r\n&bull;ISO Sensitivity: ISO 50 / 100 / 200 / 400 / 800 / 1600, automatic <br />\r\n&bull;CCD: 1/2.3&quot; CCD <br />\r\n&bull;Sensor Resolution: 10 Megapixels <br />\r\nMemory <br />\r\n&bull;Supported flash memory: SD Card, SDHC Card, MMC, MMC Plus <br />\r\n&bull;Internal Memory: 12.1 MB <br />\r\nFlash <br />\r\n&bull;Flash Modes: Automatic, forced, suppressed, red-eye reduction, soft flash, quick flash <br />\r\nLens <br />\r\n&bull;Aperture: F2.6 (GA) - 5.8 (T), f = 4.9 (GA) - 19.6 mm (T) (approx.28 mm - 35 mm equivalent: 112 mm ) <br />\r\n&bull;Macro range: 15 cm <br />\r\n&bull;Optical Zoom: 4x <br />\r\n&bull;Normal Range: From 40 cm upwards <br />\r\n&bull;Configuration: 7 lenses in 6 groups with an aspheric lens <br />\r\nConnections <br />\r\n&bull;Connections: USB 2.0 <br />\r\n&bull;TV Output: NTSC or PAL video output <br />\r\nPC connectivity <br />\r\n&bull;Supported Platforms: PC and Mac</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Charger<br />\r\n&bull;Battery<br />\r\n&bull;AV Cable<br />\r\n&bull;USB Lead<br />\r\n&bull;CD-ROM<br />\r\n&bull;Casio Exilim EX-Z100 Silver</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092521620_Casio.gif', '', '', '', '', '', '', '', '', 0, 65, date_add(NOW(),INTERVAL 3434 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 0, 'no', '0000-00-00 00:00:00', 'unpaid'),
(611, 20, 4, 23, 'Electrolux ZB404WD Rapido Wet & Dry Handheld', '1', 1, '', '<p><b>Electrolux ZB404WD Rapido Wet &amp; Dry Handheld</b></p>\r\n<p><b>Description:</b></p>\r\n<p>The Electrolux ZB404WD is a handheld cleaner suitable for every home, and thanks to its good lucks and super performance, you won''t want to put it down!</p>\r\n<p>Features:</p>\r\n<p><br />\r\n&bull;Quiet - Rapido handheld is one of the quietest handheld on the market, at just 76dBA. <br />\r\n&bull;Cyclonic suction power - By combining cyclonic suction with a motorised brush, the Ergorapido 2 in 1 can pick up hair and fibres, dust and crumbs from hard floors and carpets with ease. <br />\r\n&bull;2 front wheels and handy - Rapido handheld is always at hand and ready to use. Unique front wheel action this is so easy to use and will protect your furniture. <br />\r\n&bull;Hygienic emptying - Patented dust cup lid for hygienic emptying. Opens in 3 different ways. <br />\r\n&bull;Cordless, Rechargeable - Rechargeable battery operated cleaner. Can be taken anywhere! Convenient for quick and easy cleaning.</p>\r\n<p>&bull;Edge-to-Edge Cleaning - The wide floor nozzle has side air channels which reach right to the edge of your flooring. This gives improved pick-up of dirt in hard to reach places.</p>\r\n<p>&bull;Folding crevice nozzle&nbsp; - Extends to reach into awkward corners.</p>\r\n<p>&bull;Integrated crevice nozzle - Clean those hard to reach places. <br />\r\nSpecifications:</p>\r\n<p>&bull;Model Number:&nbsp; ZB404WD <br />\r\n&bull;Voltage: 4.8V <br />\r\n&bull;Running time: 10 mins</p>\r\n<p><br />\r\n<b>What''s in the box: </b></p>\r\n<p>&bull;Electrolux ZB404WD Rapido Wet &amp; Dry Handheld Vacuum Cleaner<br />\r\n&bull;Crevice nozzle and rubber squeegee<br />\r\n&bull;Table standing and wall mountable unit <br />\r\n&bull;Instructions</p>', 'auction', '125.00', 2, 65.00, 'Inclusive', '', 60, '$', '0.00', '150.00', '2005-10-19 07:18:59', 1, 'Active', '2008092522337_Electrolux.gif', '', '', '', '', '', '', '', '', 1, 75, date_add(NOW(),INTERVAL 3424 SECOND), '', '', 32.00, 'yes', 1, 0.00, '', 'no', 'no', 200.00, '', 300, 'no', 0, 0, 'no', '0000-00-00 00:00:00', 'unpaid'),
(646, 1, 8, 49, 'test', '1', 0, '', '<p>test</p>', '5', '0.01', 0.01, 0.00, 'Inclusive', 'Americanada ', 0, '$', '0.00', '0.00', '2009-07-24 13:07:22', 0, 'Closed', 'a82c32bc4f-image.png', '00b7691d86-image.png', 'b77d27756c-image.png', '2a4d72d29e-image.png', 'a9428c0cba-image.png', '96ec403d07-image.png', '', '', '', 1, 5, date_add(NOW(),INTERVAL 8567 SECOND), '', '', 0.00, 'yes', 0, 0.01, '', 'no', 'no', 24.99, '', 59, 'no', 0, 1, 'no', '0000-00-00 00:00:00', 'awaiting shipping')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `auction_duration`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `auction_duration`");
$SQL=MYSQL_QUERY("CREATE TABLE `auction_duration` (
  `duration_id` smallint(6) NOT NULL auto_increment,
  `duration` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`duration_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7");

//
// Dumping data for table `auction_duration`
//

$SQL=MYSQL_QUERY("INSERT INTO `auction_duration` (`duration_id`, `duration`) VALUES
(6, 6),
(5, 53),
(3, 1),
(4, 3)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `auction_fees`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `auction_fees`");
$SQL=MYSQL_QUERY("CREATE TABLE `auction_fees` (
  `fee_id` bigint(20) NOT NULL auto_increment,
  `productid` bigint(20) NOT NULL default '0',
  `gallery_fee` float(6,2) NOT NULL default '0.00',
  `homepage_featureditem_fee` float(6,2) NOT NULL default '0.00',
  `boldlisting_fee` float(6,2) NOT NULL default '0.00',
  `highlighted_fee` float(6,2) NOT NULL default '0.00',
  `endauction_fee` float(6,2) NOT NULL default '0.00',
  `classifedad_fee` float(6,2) NOT NULL default '0.00',
  `Insertion_fee` float(6,2) NOT NULL default '0.00',
  `private_fee` float(6,2) NOT NULL,
  PRIMARY KEY  (`fee_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25");

//
// Dumping data for table `auction_fees`
//

$SQL=MYSQL_QUERY("INSERT INTO `auction_fees` (`fee_id`, `productid`, `gallery_fee`, `homepage_featureditem_fee`, `boldlisting_fee`, `highlighted_fee`, `endauction_fee`, `classifedad_fee`, `Insertion_fee`, `private_fee`) VALUES
(1, 583, 0.00, 4.00, 5.00, 0.00, 0.00, 0.00, 100.00, 0.00),
(2, 584, 0.00, 4.00, 0.00, 0.00, 0.00, 0.00, 100.00, 0.00),
(3, 585, 0.00, 4.00, 5.00, 0.00, 0.00, 0.00, 100.00, 0.00),
(4, 586, 0.00, 4.00, 5.00, 0.00, 0.00, 0.00, 100.00, 0.00),
(5, 587, 0.00, 4.00, 5.00, 0.00, 0.00, 0.00, 100.00, 0.00),
(6, 588, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 100.00, 0.00),
(7, 589, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 100.00, 0.00),
(8, 590, 231.00, 0.00, 0.00, 4.00, 0.00, 0.00, 100.00, 10.00),
(9, 591, 231.00, 0.00, 0.00, 0.00, 0.00, 0.00, 100.00, 0.00),
(10, 592, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 100.00, 0.00),
(11, 593, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(12, 597, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 5.00, 0.00),
(13, 599, 0.00, 4.00, 0.00, 0.00, 0.00, 0.00, 5.00, 0.00),
(14, 600, 0.00, 4.00, 5.00, 0.00, 0.00, 0.00, 5.00, 0.00),
(15, 601, 231.00, 4.00, 0.00, 4.00, 0.00, 0.00, 5.00, 0.00),
(16, 602, 231.00, 4.00, 0.00, 0.00, 0.00, 0.00, 5.00, 0.00),
(17, 603, 0.00, 4.00, 5.00, 4.00, 0.00, 0.00, 5.00, 0.00),
(18, 605, 231.00, 4.00, 5.00, 4.00, 0.00, 0.00, 5.00, 0.00),
(19, 606, 0.00, 4.00, 5.00, 4.00, 0.00, 0.00, 5.00, 0.00),
(20, 607, 0.00, 4.00, 5.00, 0.00, 0.00, 0.00, 5.00, 0.00),
(21, 608, 0.00, 4.00, 0.00, 4.00, 0.00, 0.00, 5.00, 0.00),
(22, 609, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(23, 610, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(24, 611, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `autobids`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `autobids`");
$SQL=MYSQL_QUERY("CREATE TABLE `autobids` (
  `auto` bigint(100) NOT NULL auto_increment,
  `productid` bigint(100) NOT NULL,
  `user_id` bigint(100) NOT NULL,
  `maxbid` float(6,2) NOT NULL,
  `minbid` float(6,2) NOT NULL,
  `bidnum` int(10) NOT NULL,
  `randomtime` int(5) NOT NULL,
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=175");

//
// Dumping data for table `autobids`
//

$SQL=MYSQL_QUERY("INSERT INTO `autobids` (`auto`, `productid`, `user_id`, `maxbid`, `minbid`, `bidnum`, `randomtime`) VALUES
(173, 580, 57, 222.00, 1.00, 12, 9),
(174, 646, 57, 1.00, 0.03, 5, 3)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `banners`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `banners`");
$SQL=MYSQL_QUERY("CREATE TABLE `banners` (
  `banner_id` bigint(20) NOT NULL auto_increment,
  `banner_name` varchar(50) NOT NULL default '',
  `banner_path` varchar(100) NOT NULL default '',
  `site_url` varchar(100) NOT NULL default '',
  `status` enum('On','Off','default','ad') NOT NULL default 'On',
  PRIMARY KEY  (`banner_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15");

//
// Dumping data for table `banners`
//

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `bidback_levels`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `bidback_levels`");
$SQL=MYSQL_QUERY("CREATE TABLE `bidback_levels` (
  `level_id` int(100) NOT NULL auto_increment,
  `levels` varchar(10) NOT NULL,
  `level_name` varchar(100) NOT NULL,
  `bidback_levels` int(100) NOT NULL,
  `test` varchar(100) NOT NULL,
  PRIMARY KEY  (`level_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7");

//
// Dumping data for table `bidback_levels`
//

$SQL=MYSQL_QUERY("INSERT INTO `bidback_levels` (`level_id`, `levels`, `level_name`, `bidback_levels`, `test`) VALUES
(1, '1', 'Silver', 0, ''),
(2, '2', 'Gold', 50, ''),
(3, '3', 'Plat', 40, ''),
(4, '4', 'Pre', 35, ''),
(5, '5', 'sub', 30, ''),
(6, '6 and Up', 'All', 25, '')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `bidincrement`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `bidincrement`");
$SQL=MYSQL_QUERY("CREATE TABLE `bidincrement` (
  `bid_id` bigint(20) NOT NULL auto_increment,
  `bid_from` varchar(11) NOT NULL default '0',
  `bid_to` varchar(11) NOT NULL default '0',
  `bid_inc` varchar(11) NOT NULL default '0',
  PRIMARY KEY  (`bid_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8");

//
// Dumping data for table `bidincrement`
//

$SQL=MYSQL_QUERY("INSERT INTO `bidincrement` (`bid_id`, `bid_from`, `bid_to`, `bid_inc`) VALUES
(1, '1', '50', '10'),
(2, '51', '100', '20'),
(3, '101', '500', '5'),
(5, '1000', '5000', '55'),
(6, '10', '20', '2'),
(7, '10', '20', '2')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `blocked_domain`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `blocked_domain`");
$SQL=MYSQL_QUERY("CREATE TABLE `blocked_domain` (
  `block_id` bigint(20) NOT NULL auto_increment,
  `blocked_domain` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`block_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1");

//
// Dumping data for table `blocked_domain`
//


// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `blocked_ip`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `blocked_ip`");
$SQL=MYSQL_QUERY("CREATE TABLE `blocked_ip` (
  `block_id` bigint(20) NOT NULL auto_increment,
  `blocked_ip` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`block_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4");

//
// Dumping data for table `blocked_ip`
//

$SQL=MYSQL_QUERY("INSERT INTO `blocked_ip` (`block_id`, `blocked_ip`) VALUES
(3, '192.168.1.1')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `closing`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `closing`");
$SQL=MYSQL_QUERY("CREATE TABLE `closing` (
  `auto` int(1) NOT NULL default '0',
  `totime` time NOT NULL default '00:00:00',
  `fromtime` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");

//
// Dumping data for table `closing`
//

$SQL=MYSQL_QUERY("INSERT INTO `closing` (`auto`, `totime`, `fromtime`) VALUES
(1, '11:05:00', '11:05:00')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `coupons`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `coupons`");
$SQL=MYSQL_QUERY("CREATE TABLE `coupons` (
  `auto` bigint(100) NOT NULL auto_increment,
  `c_name` varchar(10) NOT NULL,
  `type` enum('gift','permanent') NOT NULL,
  `v_type` enum('flat','percent') NOT NULL,
  `amount` float(6,2) NOT NULL,
  `c_date` date NOT NULL,
  `status` enum('active','expired') NOT NULL default 'active',
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2");

//
// Dumping data for table `coupons`
//

$SQL=MYSQL_QUERY("INSERT INTO `coupons` (`auto`, `c_name`, `type`, `v_type`, `amount`, `c_date`, `status`) VALUES
(1, 'CTest', 'permanent', 'percent', 10.00, '2008-05-15', 'active')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `downcats`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `downcats`");
$SQL=MYSQL_QUERY("CREATE TABLE `downcats` (
  `category_id` bigint(20) NOT NULL default '0',
  `tablename` varchar(75) NOT NULL default '',
  `file_path` varchar(75) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1");

//
// Dumping data for table `downcats`
//

$SQL=MYSQL_QUERY("INSERT INTO `downcats` (`category_id`, `tablename`, `file_path`) VALUES
(152, 'xx', 'templates/xx.tpl'),
(140, 'goggles', 'themes/goggles.tpl'),
(141, 'Misc', 'themes/Misc.tpl'),
(142, 'watches', 'themes/watches.tpl')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `faq`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `faq`");
$SQL=MYSQL_QUERY("CREATE TABLE `faq` (
  `faq_id` bigint(20) NOT NULL auto_increment,
  `question` varchar(50) NOT NULL default '',
  `answer` text NOT NULL,
  `h_cat` int(10) NOT NULL,
  PRIMARY KEY  (`faq_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17");

//
// Dumping data for table `faq`
//

$SQL=MYSQL_QUERY("INSERT INTO `faq` (`faq_id`, `question`, `answer`, `h_cat`) VALUES
(8, 'What is paypal?', '<table width=730 cellspacing=0 cellpadding=7 border=0 class=help_tr>\r\n    <tbody>\r\n        <tr>\r\n            <td><font color=blue><b>What is PayPal?</b></font></td>\r\n        </tr>\r\n    </tbody>\r\n</table>\r\n<table cellspacing=0 cellpadding=10 border=0 class=help_content>\r\n    <tbody>\r\n        <tr>\r\n            <td>PayPal is iTechScripts preferred way to pay. It is a system that lets anyone with an email address securely send and receive online payments using their  PayPal account, credit card,&Acirc);&nbsp; debt card or bank account. iTechScripts auction members can use PayPal to quickly and easily pay for items  won on iTechScripts auction.</td>\r\n        </tr>\r\n    </tbody>\r\n</table>', 6),
(14, 'Registration', '<table class=help_tr border=0  cellpadding=7 width=730 cellspacing=0>\r\n <tr> <td><font color=blue><b>Registering to Buy </b></font>\r\n </td></tr></table>\r\n<table class=help_content  border=0 cellpadding=10 cellspacing=0>\r\n<tr>\r\n <td>\r\nYou only have to register once. Just follow these three steps: \r\n\r\n<ul>\r\n  <li>When you register at iTechScripts auction, you will be asked to provide your basic contact information. <b>Your information will be kept private </b>on \r\n  our secure servers.</li>\r\n\r\n<br><br><li>Check your email- iTechScripts auction will send you a message with a link and instructions for confirming your registration.</li>\r\n\r\n<br><br><li>For security purposes, you will choose your own User ID and password for signing in to \r\n  our auction site. </li>\r\n</ul>\r\n </td></tr></table>', 1),
(15, 'How to buy an item', '<table class=help_tr  border=0 cellpadding=7 width=730 cellspacing=0>\r\n <tr><td><font color=blue><b>How to Buy an item?<b></font></td></tr></table>\r\n<table class=help_content  border=0 cellpadding=10 cellspacing=0>\r\n<tr>\r\n<td>\r\nBuying on Ultimate Bids is easy - and fun!<br><br>\r\n\r\n<b>Here are a few basic steps to get you started:</b><br/>\r\n<ul>\r\n  <li><b>Find an item.</b><br/>\r\nSearch by typing in a keyword for an item your interested in, or browse through our categories.</li><br><br>\r\n\r\n  </li>\r\n  <li><b>Learn about the item you found.</b><br/>\r\nRead the item description of the Auction fully and look at the pictures \r\nincluded.<br><br>\r\n\r\n  </li>\r\n  <li><b>Place your Bid.</b><br/>\r\nOnce you have found the item you want, you can place a bid.<br><br>\r\n\r\n  </li>\r\n  <li><b>Pay for the item.</b><br/>\r\nAfter you win the item, send your payment. Clicking on the Pay Now button will allow you to pay quickly and easily with PayPal, \r\nUltimate Bids preferred way to pay.<br></li>\r\n  </ul>\r\n  </td></tr></table>', 6)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `featuredproducts`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `featuredproducts`");
$SQL=MYSQL_QUERY("CREATE TABLE `featuredproducts` (
  `feature_id` bigint(20) NOT NULL auto_increment,
  `productid` bigint(20) NOT NULL default '0',
  `gallery_feature` enum('No','Yes') NOT NULL default 'No',
  `home_feature` enum('No','Yes') NOT NULL default 'No',
  `bold` enum('No','Yes') NOT NULL default 'No',
  `border` enum('No','Yes') NOT NULL default 'No',
  `highlight` enum('No','Yes') NOT NULL default 'No',
  `subtitle_feature` enum('No','Yes') NOT NULL default 'No',
  `subtitle` varchar(70) NOT NULL default '',
  `privateauc` enum('No','Yes') NOT NULL default 'No',
  PRIMARY KEY  (`feature_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=91");

//
// Dumping data for table `featuredproducts`
//

$SQL=MYSQL_QUERY("INSERT INTO `featuredproducts` (`feature_id`, `productid`, `gallery_feature`, `home_feature`, `bold`, `border`, `highlight`, `subtitle_feature`, `subtitle`, `privateauc`) VALUES
(86, 582, '', 'Yes', 'Yes', '', 'Yes', '', '', ''),
(85, 602, 'Yes', 'Yes', '', '', '', '', '', ''),
(84, 601, 'Yes', 'Yes', '', '', 'Yes', '', '', '')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `feedback`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `feedback`");
$SQL=MYSQL_QUERY("CREATE TABLE `feedback` (
  `f_id` bigint(20) NOT NULL auto_increment,
  `productid` double NOT NULL default '0',
  `seller_id` bigint(20) NOT NULL default '0',
  `feedback` varchar(200) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `feedback_type` enum('Positive','Negative','Neutral') NOT NULL default 'Positive',
  `feedback_to` bigint(20) NOT NULL default '0',
  `buyer_id` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`f_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2");

//
// Dumping data for table `feedback`
//

$SQL=MYSQL_QUERY("INSERT INTO `feedback` (`f_id`, `productid`, `seller_id`, `feedback`, `date`, `feedback_type`, `feedback_to`, `buyer_id`) VALUES
(1, 660, 0, 'Great, fantastic', '2008-11-11', 'Positive', 1, 53)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `f_members`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `f_members`");
$SQL=MYSQL_QUERY("CREATE TABLE `f_members` (
  `auto` bigint(100) NOT NULL auto_increment,
  `userid` bigint(100) NOT NULL,
  `start_date` date NOT NULL,
  `exp_date` date NOT NULL,
  `fee_id` bigint(20) NOT NULL,
  `status` enum('Active','Suspended','Expired') NOT NULL,
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37");

//
// Dumping data for table `f_members`
//

$SQL=MYSQL_QUERY("INSERT INTO `f_members` (`auto`, `userid`, `start_date`, `exp_date`, `fee_id`, `status`) VALUES
(1, 23, '2008-06-19', '2008-08-18', 3, 'Expired'),
(2, 24, '2008-03-19', '0000-00-00', 1, 'Active'),
(3, 34, '2008-06-06', '0000-00-00', 1, 'Active'),
(4, 35, '2008-06-08', '2008-07-08', 2, 'Active'),
(5, 36, '2008-07-16', '0000-00-00', 1, 'Active'),
(6, 38, '2008-07-31', '0000-00-00', 1, 'Active'),
(7, 39, '2008-07-31', '0000-00-00', 1, 'Active'),
(8, 40, '2008-07-31', '0000-00-00', 1, 'Active'),
(9, 41, '2008-07-31', '0000-00-00', 1, 'Active'),
(10, 42, '2008-08-03', '0000-00-00', 1, 'Active'),
(11, 43, '2008-09-11', '0000-00-00', 1, 'Active'),
(12, 44, '2008-09-22', '0000-00-00', 1, 'Active'),
(13, 45, '2008-09-28', '0000-00-00', 1, 'Active'),
(14, 46, '2008-09-29', '0000-00-00', 1, 'Active'),
(15, 47, '2008-09-30', '0000-00-00', 1, 'Active'),
(16, 48, '2008-09-30', '0000-00-00', 1, 'Active'),
(17, 50, '2008-10-18', '0000-00-00', 1, 'Active'),
(18, 51, '2008-10-29', '0000-00-00', 1, 'Active'),
(19, 52, '2008-10-29', '0000-00-00', 1, 'Active'),
(20, 53, '2008-11-03', '0000-00-00', 1, 'Active'),
(21, 54, '2008-11-05', '0000-00-00', 1, 'Active'),
(22, 55, '2008-11-06', '0000-00-00', 1, 'Active'),
(23, 56, '2008-11-20', '0000-00-00', 1, 'Active'),
(24, 57, '2008-11-22', '0000-00-00', 1, 'Active'),
(25, 58, '2008-11-25', '0000-00-00', 1, 'Active'),
(26, 60, '2008-12-05', '0000-00-00', 1, 'Active'),
(27, 61, '2008-12-05', '0000-00-00', 1, 'Active'),
(28, 54, '2008-12-08', '0000-00-00', 1, 'Active'),
(29, 55, '2008-12-09', '0000-00-00', 1, 'Active'),
(30, 56, '2008-12-09', '0000-00-00', 1, 'Active'),
(31, 57, '2008-12-11', '0000-00-00', 1, 'Active'),
(32, 58, '2008-12-13', '0000-00-00', 1, 'Active'),
(33, 65, '2009-07-17', '0000-00-00', 1, 'Active'),
(34, 66, '2009-07-18', '0000-00-00', 1, 'Active'),
(35, 67, '2009-07-22', '0000-00-00', 1, 'Active'),
(36, 68, '2009-07-22', '0000-00-00', 1, 'Active')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `genaralsettings`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `genaralsettings`");
$SQL=MYSQL_QUERY("CREATE TABLE `genaralsettings` (
  `set_id` bigint(20) NOT NULL auto_increment,
  `set_name` varchar(100) NOT NULL,
  `set_value` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`set_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=65");

//
// Dumping data for table `genaralsettings`
//

$SQL=MYSQL_QUERY("INSERT INTO `genaralsettings` (`set_id`, `set_name`, `set_value`) VALUES
(1, 'Domain Name', 'http://exactQuibids.com'),
(2, 'Site Title', 'The Best Quibids Clone Scripts Available In PHP/ Mysql'),
(3, 'Admin Email', 'admin@itechscripts.com'),
(16, 'Launch date', '2009-01-01'),
(17, 'Last update Date', '2008-05-25'),
(20, 'Olditem cleanup duration in days', '1'),
(21, 'Top Seller Range', '6'),
(22, 'Record Limit Per Page', '50'),
(23, 'Auction setting start date', 'yes'),
(24, 'Auction setting end date', 'yes'),
(25, 'Auction setting start_delay', '0'),
(26, 'Auction setting duration', '0'),
(37, 'No of repost allowed', '5'),
(27, 'Maximum Delay Time', '10'),
(45, 'Contact Seller', '2'),
(46, 'Logo', 'logo.gif'),
(5, 'Site Name', 'Quibids Clone'),
(54, 'Results Per Page', '10'),
(55, 'Default Currency', '$'),
(56, 'Default  Currency Code', 'USD'),
(57, 'Maximum size of uploaded file(In Bytes)', '1000000'),
(61, 'Sign up credit (Bids)', '10'),
(62, 'Suspend account after days', '30'),
(63, 'Maximum Credit', '100'),
(4, 'Site Slogan', 'Going, Going, Gone'),
(64, 'Number Of News Item At Home', '3'),
(58, 'Bid Cost', '.50'),
(28, 'Maximum Auction an User can Win', '10')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `help_categories`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `help_categories`");
$SQL=MYSQL_QUERY("CREATE TABLE `help_categories` (
  `category_id` bigint(20) NOT NULL auto_increment,
  `category_name` text NOT NULL,
  `serial` int(10) NOT NULL,
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10");

//
// Dumping data for table `help_categories`
//

$SQL=MYSQL_QUERY("INSERT INTO `help_categories` (`category_id`, `category_name`, `serial`) VALUES
(3, 'Auctions', 3),
(2, 'Bids', 2),
(1, 'Why iTechScripts ?', 1),
(4, 'Auction Types', 4),
(5, 'Managing My Account', 5),
(6, 'Payments', 6),
(7, 'Technical Problems', 7),
(8, 'Security', 8)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `home_announcements`
//
$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `home_announcements`");
$SQL=MYSQL_QUERY("CREATE TABLE `home_announcements` (
  `id` bigint(20) NOT NULL default '0',
  `title` varchar(50) NOT NULL default '',
  `home_announcements` text NOT NULL,
  `site_announcements` longtext NOT NULL,
  `font_color` varchar(100) NOT NULL,
  `back_color` varchar(100) NOT NULL,
  `border_color` varchar(100) NOT NULL,
  UNIQUE KEY `index` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1");

//
// Dumping data for table `home_announcements`
//

$SQL=MYSQL_QUERY("INSERT INTO `home_announcements` (`id`, `title`, `home_announcements`, `site_announcements`, `font_color`, `back_color`, `border_color`) VALUES
(1, '', '<p align=center><script type=text/javascript>\r\ngoogle_ad_client = \"pub-6130138262899164\";\r\ngoogle_ad_slot = \"9102382896\";\r\ngoogle_ad_width = 468;\r\ngoogle_ad_height = 60;\r\n</script>\r\n<script type=\"text/javascript\"\r\nsrc=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\">\r\n</script></p>', '', 'white', '#3a3a3a', 'white')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `language`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `language`");
$SQL=MYSQL_QUERY("CREATE TABLE `language` (
  `auto` bigint(20) NOT NULL,
  `filename` varchar(100) NOT NULL,
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1");

//
// Dumping data for table `language`
//

$SQL=MYSQL_QUERY("INSERT INTO `language` (`auto`, `filename`) VALUES
(1, 'English.php')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `membership_level`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `membership_level`");
$SQL=MYSQL_QUERY("CREATE TABLE `membership_level` (
  `mid` bigint(20) NOT NULL auto_increment,
  `feedback_score_from` bigint(20) NOT NULL default '0',
  `icon` varchar(100) NOT NULL default '',
  `feedback_score_to` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`mid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10");

//
// Dumping data for table `membership_level`
//

$SQL=MYSQL_QUERY("INSERT INTO `membership_level` (`mid`, `feedback_score_from`, `icon`, `feedback_score_to`) VALUES
(7, 0, 'green_star.gif', 0),
(6, 1, 'yellowstar.gif', 10),
(8, 11, 'red_star.gif', 12),
(9, 13, 'arrow-4.GIF', 23)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `member_details`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `member_details`");
$SQL=MYSQL_QUERY("CREATE TABLE `member_details` (
  `user_id` bigint(20) NOT NULL auto_increment,
  `intro_id` bigint(20) NOT NULL default '0',
  `plan_id` bigint(20) NOT NULL default '0',
  `member_account` enum('1','2','3') NOT NULL default '1',
  `user_name` varchar(25) NOT NULL default '',
  `date_of_birth` date NOT NULL default '0000-00-00',
  `email` varchar(35) NOT NULL default '',
  `first_name` varchar(25) NOT NULL default '',
  `last_name` varchar(25) NOT NULL default '',
  `html_profile` varchar(100) NOT NULL default '',
  `address` varchar(20) NOT NULL default '',
  `city` varchar(20) NOT NULL default '',
  `state` varchar(20) NOT NULL default '',
  `pin_code` varchar(15) NOT NULL default '',
  `country` varchar(50) NOT NULL default '0',
  `home_phone` bigint(20) NOT NULL default '0',
  `work_phone` bigint(20) NOT NULL default '0',
  `password` text NOT NULL,
  `verified` enum('yes','no') NOT NULL default 'no',
  `veri_code` varchar(30) NOT NULL default '',
  `status` enum('Active','Inactive','suspended','new') NOT NULL default 'Inactive',
  `date_of_registration` date NOT NULL default '0000-00-00',
  `expire_date` date NOT NULL default '0000-00-00',
  `last_login_date` date NOT NULL default '0000-00-00',
  `Onlinestatus` enum('Online','Offline') NOT NULL default 'Offline',
  `ip_address` varchar(15) NOT NULL default '',
  `email_enable_status` enum('Yes','No') NOT NULL default 'Yes',
  `paid` enum('No','Yes') NOT NULL default 'Yes',
  `original_account` enum('1','2','3') NOT NULL default '1',
  `trusted` enum('inactive','active','trusted') NOT NULL default 'inactive',
  `postpermission` enum('yes','no') NOT NULL default 'yes',
  `payment_status` enum('yes','no') NOT NULL default 'yes',
  `approved` enum('yes','no') NOT NULL,
  `member_type` bigint(20) NOT NULL default '1',
  `bid_num` bigint(100) NOT NULL,
  `user_type` enum('original','bot') NOT NULL default 'original',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `user_name` (`user_name`,`email`,`status`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=69");

//
// Dumping data for table `member_details`
//

$SQL=MYSQL_QUERY("INSERT INTO `member_details` (`user_id`, `intro_id`, `plan_id`, `member_account`, `user_name`, `date_of_birth`, `email`, `first_name`, `last_name`, `html_profile`, `address`, `city`, `state`, `pin_code`, `country`, `home_phone`, `work_phone`, `password`, `verified`, `veri_code`, `status`, `date_of_registration`, `expire_date`, `last_login_date`, `Onlinestatus`, `ip_address`, `email_enable_status`, `paid`, `original_account`, `trusted`, `postpermission`, `payment_status`, `approved`, `member_type`, `bid_num`, `user_type`) VALUES
(58, 0, 0, '1', 'rld', '1955-08-12', 'rdamewood@convad.net', 'Richard', 'Damewood', '', '627 Fort Collier Rd', 'Winchester', 'Virginia', '22655', '224', 5406647701, 5406649874, '08bd90a3a2ffb35a495e602efcaed572a808480008fbb4fcea9cd4070eee6972fe4ca10a3a2ffb35a495e602efcaed572a808480d42a8edc061afd8324d0fb40abc137dffb35a495e602efcaed572a80848e90261f63f35fcd4400be38b35604eb6a495e602efcaed572a80848d7e22ad997ca37eee3aa5126ec218c14602efcaed572a80848044096e1b5238ae7750c641bda207f0dcaed572a808485be51956dce07f601f145181aac0815e72a8084880a1e0e552e82ad42090750d54e7cadd848ebac431ed3e0ae766659b9ccb9438ec7', 'yes', 'e90c8e', 'Active', '2008-12-13', '0000-00-00', '2008-12-13', 'Online', '76.123.0.29', '', 'Yes', '', 'inactive', 'yes', 'yes', 'yes', 1, 6, 'original'),
(56, 55, 0, '1', 'jsd', '1950-11-28', 'jsd@convad.net', 'jane', 'damewood', '', '123', 'winc', 'va', '123456', '224', 1234567890, 1234567890, '08bd90a3a2ffb35a495e602efcaed572a808480008fbb4fcea9cd4070eee6972fe4ca10a3a2ffb35a495e602efcaed572a808480d42a8edc061afd8324d0fb40abc137dffb35a495e602efcaed572a80848e90261f63f35fcd4400be38b35604eb6a495e602efcaed572a80848d7e22ad997ca37eee3aa5126ec218c14602efcaed572a80848044096e1b5238ae7750c641bda207f0dcaed572a808485be51956dce07f601f145181aac0815e72a8084880a1e0e552e82ad42090750d54e7cadd848ebac431ed3e0ae766659b9ccb9438ec7', 'yes', '0a488f', 'Active', '2008-12-09', '0000-00-00', '2008-12-13', 'Online', '76.123.0.29', '', 'Yes', '', 'inactive', 'yes', 'yes', 'yes', 1, 0, 'original'),
(57, 0, 0, '1', 'userdemo', '1980-01-01', 'support@itechscripts.com', 'Fredric', 'Brook', '', 'gdfg', 'dfsgsdf', 'gsdfgsdf', '56456', '98', 444444444444, 444444444444, '4728317a94fd765c5c17883ea4b8131e3716480008fbb4fcea9cd4070eee6972fe4ca117a94fd765c5c17883ea4b8131e3716480d42a8edc061afd8324d0fb40abc137dfd765c5c17883ea4b8131e371648e90261f63f35fcd4400be38b35604eb6c5c17883ea4b8131e371648d7e22ad997ca37eee3aa5126ec218c14883ea4b8131e371648044096e1b5238ae7750c641bda207f0d4b8131e3716485be51956dce07f601f145181aac0815e1e37164880a1e0e552e82ad42090750d54e7cadd648ebac431ed3e0ae766659b9ccb9438ec7', 'yes', '8db565', 'Active', '2008-12-11', '0000-00-00', '2009-08-06', 'Online', '59.93.209.134', 'Yes', 'Yes', '1', 'inactive', 'yes', 'yes', 'yes', 1, 82, 'original'),
(59, 0, 0, '1', 'botuser1', '0000-00-00', '', '', '', '', '', '', '', '', '0', 0, 0, '', 'no', '', 'Inactive', '2009-07-15', '0000-00-00', '0000-00-00', 'Offline', '', 'Yes', 'Yes', '1', 'inactive', 'yes', 'yes', 'yes', 1, 0, 'bot'),
(60, 0, 0, '1', 'botuser2', '0000-00-00', '', '', '', '', '', '', '', '', '0', 0, 0, '', 'no', '', 'Inactive', '2009-07-15', '0000-00-00', '0000-00-00', 'Offline', '', 'Yes', 'Yes', '1', 'inactive', 'yes', 'yes', 'yes', 1, 0, 'bot')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `meta_tag`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `meta_tag`");

$SQL=MYSQL_QUERY("CREATE TABLE `meta_tag` (
 `key_id` int(5) NOT NULL auto_increment,
 `key_s` text NOT NULL,
 `key_des` text NOT NULL,
 PRIMARY KEY  (`key_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='key words of meta tag' AUTO_INCREMENT=2 ");



//

// Dumping data for table `meta_tag`

//



$SQL=MYSQL_QUERY("INSERT INTO `meta_tag` (`key_id`, `key_s`, `key_des`) VALUES

(1, 'itechscripts.com, itechbids.com, penny auction, lowest unique bid auction, Quibids clone, bidrivals clone, bidster clone, alibaba clone, facebook clone, biding script, live auction script, auction script, auction software, classified script, listing script, directory software, free demo, cheap script', 'The Best Penny Auction Scripts Available In PHP/ Mysql.')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `news`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `news`");
$SQL=MYSQL_QUERY("CREATE TABLE `news` (
  `news_id` bigint(10) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `newsdetails` text NOT NULL,
  `date` date NOT NULL,
  `status` enum('active','expired') NOT NULL,
  PRIMARY KEY  (`news_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7");

//
// Dumping data for table `news`
//

$SQL=MYSQL_QUERY("INSERT INTO `news` (`news_id`, `title`, `newsdetails`, `date`, `status`) VALUES
(6, 'PRE-LAUNCH', 'This site is in Pre-Launch.\r\n\r\nLaunch Date Will be January 15, 2009', '0000-00-00', 'active')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `offline_payments`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `offline_payments`");
$SQL=MYSQL_QUERY("CREATE TABLE `offline_payments` (
  `auto` bigint(100) NOT NULL auto_increment,
  `username` varchar(100) NOT NULL,
  `contact_name` varchar(100) NOT NULL,
  `acc_title` varchar(100) NOT NULL,
  `bank_name` varchar(100) NOT NULL,
  `swift_code` varchar(100) NOT NULL,
  `acc_number` varchar(100) NOT NULL,
  `country` bigint(20) NOT NULL,
  `Other` text NOT NULL,
  `type` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`auto`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4");

//
// Dumping data for table `offline_payments`
//

$SQL=MYSQL_QUERY("INSERT INTO `offline_payments` (`auto`, `username`, `contact_name`, `acc_title`, `bank_name`, `swift_code`, `acc_number`, `country`, `Other`, `type`) VALUES
(1, 'administrator_account', 'Administrator', 'ITECH', 'ICICI', '45871eeee', '456372835467', 0, 'Other', '1'),
(2, '23', 'Userdemo', 'Userdemo', 'ICICI', 'YTYRFHI', '65436789543', 0, '', '0'),
(3, '', '', '', '', '', '', 0, '', '0')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `options`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `options`");
$SQL=MYSQL_QUERY("CREATE TABLE `options` (
  `auto` bigint(20) NOT NULL auto_increment,
  `descr` varchar(100) NOT NULL,
  `options` enum('yes','no') NOT NULL,
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15");

//
// Dumping data for table `options`
//

$SQL=MYSQL_QUERY("INSERT INTO `options` (`auto`, `descr`, `options`) VALUES
(3, 'Registration Terms and Conditions', 'yes'),
(8, 'Registration Required Approval', 'no'),
(9, 'Email Verification', 'yes'),
(2, 'Enable Referral System', 'yes'),
(1, 'Enable Bid Back', 'yes'),
(4, 'Display Benners', 'yes')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `payment_gateway`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `payment_gateway`");
$SQL=MYSQL_QUERY("CREATE TABLE `payment_gateway` (
  `gateway_id` bigint(20) NOT NULL auto_increment,
  `payment_gateway` varchar(250) NOT NULL default '',
  `status` enum('Yes','No') NOT NULL default 'Yes',
  `gate_id` varchar(100) NOT NULL,
  PRIMARY KEY  (`gateway_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8");

//
// Dumping data for table `payment_gateway`
//

$SQL=MYSQL_QUERY("INSERT INTO `payment_gateway` (`gateway_id`, `payment_gateway`, `status`, `gate_id`) VALUES
(1, 'Paypal', 'Yes', 'admin@itechscripts.com'),
(2, '2Checkout', 'Yes', 'admin@itechscripts.com'),
(3, 'Worldpay', 'Yes', 'admin@itechscripts.com'),
(4, 'Money Bookers', 'Yes', 'admin@itechscripts.com'),
(5, 'Nochex', 'Yes', 'admin@itechscripts.com'),
(6, 'ITechBids (Test)', 'No', 'N/A'),
(7, 'Bank Transfer', 'No', 'N/A')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `plan`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `plan`");
$SQL=MYSQL_QUERY("CREATE TABLE `plan` (
  `plan_id` bigint(20) NOT NULL auto_increment,
  `scheme` varchar(100) NOT NULL,
  `amount` float(6,2) NOT NULL,
  `items` bigint(20) NOT NULL default '10',
  `status` varchar(100) NOT NULL,
  PRIMARY KEY  (`plan_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6");

//
// Dumping data for table `plan`
//

$SQL=MYSQL_QUERY("INSERT INTO `plan` (`plan_id`, `scheme`, `amount`, `items`, `status`) VALUES
(1, 'five', 5.00, 5, 'active'),
(2, 'ten', 20.00, 10, 'active'),
(3, 'twenty', 50.00, 20, 'active'),
(5, 'OneHundred', 100.00, 100, 'active')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `referral_commission`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `referral_commission`");
$SQL=MYSQL_QUERY("CREATE TABLE `referral_commission` (
  `ref_id` tinyint(11) NOT NULL auto_increment,
  `intro_id` tinyint(11) NOT NULL default '0',
  `user_id` tinyint(11) NOT NULL default '0',
  `referral_commission` decimal(11,2) NOT NULL default '0.00',
  `ref_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`ref_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=36");

//
// Dumping data for table `referral_commission`
//

$SQL=MYSQL_QUERY("INSERT INTO `referral_commission` (`ref_id`, `intro_id`, `user_id`, `referral_commission`, `ref_date`) VALUES
(19, 0, 22, '0.00', '0000-00-00'),
(17, 0, 22, '0.00', '0000-00-00'),
(15, 0, 22, '0.00', '0000-00-00')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `ref_levels`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `ref_levels`");
$SQL=MYSQL_QUERY("CREATE TABLE `ref_levels` (
  `level_id` int(100) NOT NULL auto_increment,
  `levels` varchar(10) NOT NULL,
  `level_name` varchar(100) NOT NULL,
  `ref_levels` int(100) NOT NULL,
  `reg_bid` int(10) NOT NULL,
  PRIMARY KEY  (`level_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6");

//
// Dumping data for table `ref_levels`
//

$SQL=MYSQL_QUERY("INSERT INTO `ref_levels` (`level_id`, `levels`, `level_name`, `ref_levels`, `reg_bid`) VALUES
(1, '1', 'Silver', 0, 5),
(2, '2', 'Gold', 0, 4),
(3, '3', 'Plat', 0, 3),
(4, '4', 'Pre', 0, 2),
(5, '5', 'sub', 0, 1)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `relist_fee`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `relist_fee`");
$SQL=MYSQL_QUERY("CREATE TABLE `relist_fee` (
  `auto` tinyint(10) NOT NULL,
  `type` enum('flat','percent') NOT NULL,
  `fee` bigint(20) NOT NULL,
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1");

//
// Dumping data for table `relist_fee`
//

$SQL=MYSQL_QUERY("INSERT INTO `relist_fee` (`auto`, `type`, `fee`) VALUES
(1, 'percent', 50)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `save_searchresult`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `save_searchresult`");
$SQL=MYSQL_QUERY("CREATE TABLE `save_searchresult` (
  `sid` bigint(20) NOT NULL auto_increment,
  `user_id` varchar(100) NOT NULL default '',
  `save_name` varchar(100) NOT NULL default '',
  `save_query` text NOT NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52");

//
// Dumping data for table `save_searchresult`
//


// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `shopfronts`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `shopfronts`");
$SQL=MYSQL_QUERY("CREATE TABLE `shopfronts` (
  `id` bigint(20) NOT NULL auto_increment,
  `user_id` bigint(20) NOT NULL default '0',
  `logo` varchar(150) NOT NULL default '',
  `description` text NOT NULL,
  `shop_name` varchar(150) NOT NULL default '',
  `status` enum('disable','enable','suspend') NOT NULL default 'enable',
  `start_date` datetime NOT NULL,
  `expir_date` datetime default NULL,
  `expired` enum('no','yes') NOT NULL default 'no',
  `scheme` int(100) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9");

//
// Dumping data for table `shopfronts`
//

$SQL=MYSQL_QUERY("INSERT INTO `shopfronts` (`id`, `user_id`, `logo`, `description`, `shop_name`, `status`, `start_date`, `expir_date`, `expired`, `scheme`) VALUES
(1, 20, '2057aeebackground1.jpg', 'des', 'name', 'enable', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 'no', 0),
(6, 23, '', '<p><b>jhgkhjkghjkghjkghjk</b></p>', 'My Shop', 'enable', '2008-06-19 09:32:30', '2008-08-18 10:32:30', 'no', 99),
(8, 35, '', '', 'My Shop', 'enable', '2008-06-08 10:52:58', '2008-07-08 11:52:58', 'no', 99)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `site_bids`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `site_bids`");
$SQL=MYSQL_QUERY("CREATE TABLE `site_bids` (
  `bid_id` bigint(20) NOT NULL auto_increment,
  `user_id` bigint(20) NOT NULL default '0',
  `productid` bigint(20) NOT NULL default '0',
  `quantity` bigint(20) NOT NULL default '0',
  `bidding_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `bidding_amount` decimal(10,2) NOT NULL default '0.00',
  `sale_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_pos` enum('No','Yes','Delete') NOT NULL default 'No',
  `checkbid` enum('yes','no') NOT NULL default 'no',
  `cashback` enum('yes','no') NOT NULL default 'no',
  `bidpool` enum('paid','bonus') NOT NULL default 'paid',
  `bid_type` enum('Single Bid','Auto Bidder') NOT NULL default 'Single Bid',
  `bot_bid` enum('yes','no') NOT NULL default 'no',
  UNIQUE KEY `bid_id` (`bid_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4937");

//
// Dumping data for table `site_bids`
//

$SQL=MYSQL_QUERY("INSERT INTO `site_bids` (`bid_id`, `user_id`, `productid`, `quantity`, `bidding_date`, `bidding_amount`, `sale_date`, `user_pos`, `checkbid`, `cashback`, `bidpool`) VALUES
(4929, 57, 646, 1, '2009-07-24 12:08:31', '0.01', '0000-00-00 00:00:00', 'Yes', 'no', 'yes', 'paid', 'Single Bid'),
(4930, 57, 574, 1, '2009-07-24 12:14:18', '125.00', '0000-00-00 00:00:00', 'No', 'no', 'no', 'paid', 'Single Bid')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `site_categories`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `site_categories`");
$SQL=MYSQL_QUERY("CREATE TABLE `site_categories` (
  `category_id` bigint(20) NOT NULL auto_increment,
  `category_name` varchar(20) NOT NULL default '',
  `category_head_id` int(6) NOT NULL default '0',
  `serial` int(10) NOT NULL,
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=139");

//
// Dumping data for table `site_categories`
//

$SQL=MYSQL_QUERY("INSERT INTO `site_categories` (`category_id`, `category_name`, `category_head_id`, `serial`) VALUES
(4, 'Business', 0, 0),
(5, 'Cameras', 0, 0),
(7, 'Computers', 0, 0),
(8, 'DVD''s', 0, 0),
(9, 'Electronics', 0, 0),
(12, 'Music', 0, 0),
(13, 'Sports', 0, 0),
(14, 'Tickets', 0, 0),
(16, 'Travel', 0, 0),
(17, 'VideoGames', 0, 0),
(18, 'Art', 4, 0),
(19, 'Furniture', 4, 0),
(20, 'Rugs', 4, 0),
(21, 'Silver', 4, 0),
(22, 'Other Vechicles', 4, 0),
(23, 'Cars', 4, 0),
(24, 'Trucks', 4, 0),
(25, 'Motor Cycles', 4, 0),
(26, 'Parts', 4, 0),
(27, 'Fictions', 4, 0),
(28, 'Magazines', 4, 0),
(29, 'Notification', 4, 0),
(30, 'Textbooks', 4, 0),
(31, 'Childrens', 4, 0),
(32, 'Reference', 4, 0),
(33, 'Equipment', 4, 0),
(34, 'Furniture', 4, 0),
(35, 'Suppliers', 4, 0),
(36, 'Telephones', 4, 0),
(37, 'Digital Cameras', 5, 0),
(38, 'Film Cameras', 5, 0),
(39, 'Accessories', 5, 0),
(40, 'Women', 6, 0),
(41, 'Men', 6, 0),
(42, 'Girls', 6, 0),
(43, 'Boy', 6, 0),
(44, 'Infant', 6, 0),
(45, 'Computer System', 7, 0),
(46, 'Components', 7, 0),
(47, 'Pheripherals', 7, 0),
(48, 'Software', 7, 0),
(49, 'Action', 8, 0),
(50, 'Animation', 8, 0),
(51, 'Comedy', 8, 0),
(52, 'Drama', 8, 0),
(53, 'Horror', 8, 0),
(54, 'Sci-Fi', 8, 0),
(55, 'Cell Phone', 9, 0),
(56, 'Audio & Video', 9, 0),
(57, 'ITechBids Auction', 9, 0),
(58, 'PDA''s', 9, 0),
(59, 'Digital Cameras', 9, 0),
(60, 'CamCorders', 9, 0),
(61, 'Portable', 9, 0),
(62, 'Gadgets', 9, 0),
(63, 'Fine', 11, 0),
(64, 'Watches', 11, 0),
(65, 'Costume', 11, 0),
(66, 'Men', 11, 0),
(67, 'Beads', 11, 0),
(68, 'Boxes', 11, 0),
(69, 'Guitars', 12, 0),
(70, 'Pro Audio', 12, 0),
(71, 'Autograph', 13, 0),
(72, 'Memorabilia', 13, 0),
(73, 'Trading', 13, 0),
(74, 'Concerts', 14, 0),
(75, 'Movies', 14, 0),
(76, 'Sports', 14, 0),
(77, 'Theater', 14, 0),
(78, 'Auction Figure', 15, 0),
(79, 'Classic', 15, 0),
(80, 'Puzzle', 15, 0),
(81, 'Games', 15, 0),
(82, 'Luggage', 16, 0),
(83, 'Cruises', 16, 0),
(84, 'Vacation', 16, 0),
(85, 'Timeshares', 16, 0),
(86, 'Sony', 17, 0),
(87, 'Microsoft', 17, 0),
(88, 'Nitendo', 17, 0),
(89, 'Sega', 17, 0),
(90, 'Old Systems', 17, 0),
(91, 'Black', 4, 0),
(92, 'Television', 9, 0),
(93, 'Campers', 22, 0),
(94, 'Scooters', 22, 0),
(95, 'Show Mobiles', 22, 0),
(96, 'Accessories', 26, 0),
(97, 'ITechBids', 26, 0),
(98, 'Trunck Parts', 26, 0),
(99, 'Tools', 26, 0),
(100, 'Apparel', 26, 0),
(101, 'Manuals', 26, 0),
(102, 'Adventure', 27, 0),
(103, 'Fantasy', 27, 0),
(104, 'Horror', 27, 0),
(105, 'Humor', 27, 0),
(106, 'Military', 27, 0),
(107, 'Mystery', 27, 0),
(108, 'Plays', 27, 0),
(109, 'Romance', 27, 0),
(110, 'Sci-Fi', 27, 0),
(111, 'Western', 27, 0),
(112, 'Biography', 29, 0),
(113, 'History', 29, 0),
(114, 'Humor', 29, 0),
(115, 'Pets', 29, 0),
(116, 'Sports', 29, 0),
(117, 'Travel', 29, 0),
(118, 'Apple', 45, 0),
(119, 'Laptops', 45, 0),
(120, 'PC''s', 45, 0),
(121, 'CPU''s', 46, 0),
(122, 'Drives', 46, 0),
(123, 'Memory', 46, 0),
(124, 'MotherBoard', 46, 0),
(125, 'Video Wind', 46, 0),
(126, 'Home Video', 56, 0),
(127, 'Home Audio', 56, 0),
(128, 'Accessories', 56, 0),
(129, 'Sony Systems', 86, 0),
(130, 'Sony Games', 86, 0),
(131, 'Microsoft Systems', 87, 0),
(132, 'Microsoft Games', 87, 0),
(133, 'Nitendo Systems', 88, 0),
(134, 'Nitendo Games', 88, 0),
(135, 'Sega Systems', 89, 0),
(136, 'Sega Games', 89, 0),
(137, 'Bycycle', 22, 0)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `site_countries`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `site_countries`");
$SQL=MYSQL_QUERY("CREATE TABLE `site_countries` (
  `country_id` bigint(20) NOT NULL auto_increment,
  `country` varchar(50) default NULL,
  PRIMARY KEY  (`country_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=240");

//
// Dumping data for table `site_countries`
//

$SQL=MYSQL_QUERY("INSERT INTO `site_countries` (`country_id`, `country`) VALUES
(1, 'Afghanistan'),
(2, 'Albania'),
(3, 'Algeria'),
(4, 'American Samoa'),
(5, 'Andorra'),
(6, 'Angola'),
(7, 'Anguilla'),
(8, 'Antarctica'),
(9, 'Antigua And Barbuda'),
(10, 'Argentina'),
(11, 'Armenia'),
(12, 'Aruba'),
(13, 'Australia'),
(14, 'Austria'),
(15, 'Azerbaijan'),
(16, 'Bahamas'),
(17, 'Bahrain'),
(18, 'Bangladesh'),
(19, 'Barbados'),
(20, 'Belarus'),
(21, 'Belgium'),
(22, 'Belize'),
(23, 'Benin'),
(24, 'Bermuda'),
(25, 'Bhutan'),
(26, 'Bolivia'),
(27, 'Bosnia and Herzegovina'),
(28, 'Botswana'),
(29, 'Bouvet Island'),
(30, 'Brazil'),
(31, 'British Indian Ocean Territory'),
(32, 'Brunei'),
(33, 'Bulgaria'),
(34, 'Burkina Faso'),
(35, 'Burundi'),
(36, 'Cambodia'),
(37, 'Cameroon'),
(38, 'Canada'),
(39, 'Cape verde'),
(40, 'Cayman Islands'),
(41, 'Central African Republic'),
(42, 'Chad'),
(43, 'Chile'),
(44, 'China'),
(45, 'Christmas Island'),
(46, 'Cocos (keeling) Islands'),
(47, 'Colombia'),
(48, 'Comoros'),
(49, 'Congo'),
(50, 'Cook Islands'),
(51, 'Costa Rica'),
(52, 'Croatia'),
(53, 'Cuba'),
(54, 'Cyprus'),
(55, 'Czech Republic'),
(56, 'Dem Rep of Congo (Zaire)'),
(57, 'Denmark'),
(58, 'Djibouti'),
(59, 'Dominica'),
(60, 'Dominican Republic'),
(61, 'East Timor'),
(62, 'Ecuador'),
(63, 'Egypt'),
(64, 'El Salvador'),
(65, 'England'),
(66, 'Equatorial Guinea'),
(67, 'Eritrea'),
(68, 'Estonia'),
(69, 'Ethiopia'),
(70, 'Falkland Islands'),
(71, 'Faroe Islands'),
(72, 'Fiji'),
(73, 'Finland'),
(74, 'France'),
(75, 'French Guiana'),
(76, 'French Polynesia'),
(77, 'French Southern Territories'),
(78, 'Gabon'),
(79, 'Gambia'),
(80, 'Georgia'),
(81, 'Germany'),
(82, 'Ghana'),
(83, 'Gibraltar'),
(84, 'Greece'),
(85, 'Greenland'),
(86, 'Grenada'),
(87, 'Guadeloupe'),
(88, 'Guam'),
(89, 'Guatemala'),
(90, 'Guinea'),
(91, 'Guinea-Bissau'),
(92, 'Guyana'),
(93, 'Haiti'),
(94, 'Heard and McDonald Islands'),
(95, 'Honduras'),
(96, 'Hungary'),
(97, 'Iceland'),
(98, 'India'),
(99, 'Indonesia'),
(100, 'Iran'),
(101, 'Iraq'),
(102, 'Ireland'),
(103, 'Israel'),
(104, 'Italy'),
(105, 'Ivory Coast'),
(106, 'Jamaica'),
(107, 'Japan'),
(108, 'Jordan'),
(109, 'Kazakhstan'),
(110, 'Kenya'),
(111, 'Kiribati'),
(112, 'Korea'),
(113, 'Korea (D.P.R.)'),
(114, 'Kuwait'),
(115, 'Kyrgyzstan'),
(116, 'Lao'),
(117, 'Latvia'),
(118, 'Lebanon'),
(119, 'Lesotho'),
(120, 'Liberia'),
(121, 'Libya'),
(122, 'Liechtenstein'),
(123, 'Lithuania'),
(124, 'Luxembourg'),
(125, 'Macedonia'),
(126, 'Madagas'),
(127, 'Malawi'),
(128, 'Malaysia'),
(129, 'Maldives'),
(130, 'Mali'),
(131, 'Malta'),
(132, 'Marshall Islands'),
(133, 'Martinique'),
(134, 'Mauritania'),
(135, 'Mauritius'),
(136, 'Mayotte'),
(137, 'Mexico'),
(138, 'Micronesia'),
(139, 'Moldova'),
(140, 'Monaco'),
(141, 'Mongolia'),
(142, 'Montserrat'),
(143, 'Morocco'),
(144, 'Mozambique'),
(145, 'Myanmar'),
(146, 'Namibia'),
(147, 'Nauru'),
(148, 'Nepal'),
(149, 'Netherlands'),
(153, 'NiITechBids Auction Script a'),
(154, 'Niger'),
(155, 'Nigeria'),
(156, 'Niue'),
(157, 'Norfolk Island'),
(158, 'Northern Mariana Islands'),
(159, 'Norway'),
(160, 'Oman'),
(161, 'Other'),
(162, 'Pakistan'),
(163, 'Palau'),
(164, 'Palestinian Territory, Occupie'),
(165, 'Panama'),
(166, 'Papua new Guinea'),
(167, 'Paraguay'),
(168, 'Peru'),
(169, 'Philippines'),
(170, 'Pitcairn Island'),
(171, 'Poland'),
(172, 'Portugal'),
(173, 'Puerto Rico'),
(174, 'Qatar'),
(175, 'Reunion'),
(176, 'Romania'),
(177, 'Russia'),
(178, 'Rwanda'),
(179, 'Saint Kitts And Nevis'),
(180, 'Saint Lucia'),
(181, 'Saint Vincent And The Grenadin'),
(182, 'Samoa'),
(183, 'San Marino'),
(184, 'Sao Tome and Principe'),
(185, 'Saudi Arabia'),
(186, 'Scotland'),
(187, 'Senegal'),
(188, 'Seychelles'),
(189, 'Sierra Leone'),
(190, 'Singapore'),
(191, 'Slovak Republic'),
(192, 'Slovenia'),
(193, 'Solomon Islands'),
(194, 'Somalia'),
(195, 'South Africa'),
(196, 'South Georgia, Sth Sandwich Islands'),
(197, 'Spain'),
(198, 'Sri Lanka'),
(199, 'St Helena'),
(200, 'St Pierre and Miquelon'),
(201, 'Sudan'),
(202, 'Suriname'),
(203, 'Svalbard And Jan Mayen Islands'),
(204, 'Swaziland'),
(205, 'Sweden'),
(206, 'Switzerland'),
(207, 'Syria'),
(208, 'Taiwan'),
(209, 'Tajikistan'),
(210, 'Tanzania'),
(211, 'Thailand'),
(212, 'Togo'),
(213, 'Tokelau'),
(214, 'Tonga'),
(215, 'Trinidad And Tobago'),
(216, 'Tunisia'),
(217, 'Turkey'),
(218, 'Turkmenistan'),
(219, 'Turks And Caicos Islands'),
(220, 'Tuvalu'),
(221, 'Uganda'),
(222, 'Ukraine'),
(223, 'United Arab Emirates'),
(224, 'United States'),
(225, 'Uruguay'),
(226, 'Uzbekistan'),
(227, 'Vanuatu'),
(228, 'Vatican City State (Holy See)'),
(229, 'Venezuela'),
(230, 'Vietnam'),
(231, 'Virgin Islands (British)'),
(232, 'Virgin Islands (US)'),
(233, 'Wales'),
(234, 'Wallis And Futuna Islands'),
(235, 'Western Sahara'),
(236, 'Yemen'),
(237, 'Zambia'),
(238, 'Zimbabwe'),
(239, 'Sweden')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `site_currencies`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `site_currencies`");
$SQL=MYSQL_QUERY("CREATE TABLE `site_currencies` (
  `currency_id` bigint(20) NOT NULL auto_increment,
  `currency` varchar(15) NOT NULL default '',
  `statuss` enum('show','hide') NOT NULL default 'show',
  `eq_value` float NOT NULL default '0',
  PRIMARY KEY  (`currency_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5");

//
// Dumping data for table `site_currencies`
//

$SQL=MYSQL_QUERY("INSERT INTO `site_currencies` (`currency_id`, `currency`, `statuss`, `eq_value`) VALUES
(1, '$', 'show', 1),
(2, '&yen;', 'hide', 0.5),
(3, 'Rs', 'hide', 46),
(4, '&euro;', 'show', 1.5)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `site_fees`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `site_fees`");
$SQL=MYSQL_QUERY("CREATE TABLE `site_fees` (
  `admin_id` int(5) NOT NULL auto_increment,
  `scheme` varchar(25) NOT NULL,
  `gallery_price` float(6,2) NOT NULL default '0.00',
  `homepage_price` float(6,2) NOT NULL default '0.00',
  `subtitle_price` float(6,2) NOT NULL default '0.00',
  `bold_price` float(6,2) NOT NULL default '0.00',
  `highlight_price` float(6,2) NOT NULL default '0.00',
  `Insertion_fee` float(6,2) NOT NULL default '0.00',
  `Classified_fee` float(6,2) NOT NULL default '0.00',
  `private_fee` float(6,2) NOT NULL default '0.00',
  `registration_fee` float(6,2) NOT NULL default '0.00',
  `want_it_fee` float(6,2) NOT NULL default '0.00',
  `admin_fee` float(6,2) NOT NULL,
  `a_fee_type` enum('flat','percent') NOT NULL default 'flat',
  `duration` bigint(20) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL default 'Active',
  `shop_free` enum('yes','no') NOT NULL,
  `aboutme` enum('yes','no') NOT NULL default 'yes',
  PRIMARY KEY  (`admin_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5");

//
// Dumping data for table `site_fees`
//

$SQL=MYSQL_QUERY("INSERT INTO `site_fees` (`admin_id`, `scheme`, `gallery_price`, `homepage_price`, `subtitle_price`, `bold_price`, `highlight_price`, `Insertion_fee`, `Classified_fee`, `private_fee`, `registration_fee`, `want_it_fee`, `admin_fee`, `a_fee_type`, `duration`, `status`, `shop_free`, `aboutme`) VALUES
(1, 'Basic', 231.00, 4.00, 5.00, 5.00, 4.00, 0.00, 11.00, 10.00, 0.00, 15.00, 0.00, 'flat', 0, 'Active', 'yes', 'yes'),
(2, 'Silver', 231.00, 4.00, 5.00, 5.00, 4.00, 5.00, 11.00, 10.00, 10.00, 0.00, 0.00, 'flat', 30, 'Active', 'yes', 'yes'),
(3, 'Gold', 231.00, 4.00, 5.00, 5.00, 4.00, 5.00, 11.00, 10.00, 15.00, 10.00, 5.00, 'flat', 60, 'Active', 'yes', 'yes'),
(4, 'Platinum', 231.00, 4.00, 5.00, 5.00, 4.00, 5.00, 11.00, 10.00, 20.00, 10.00, 0.00, 'flat', 180, 'Active', 'yes', 'yes')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `site_states`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `site_states`");
$SQL=MYSQL_QUERY("CREATE TABLE `site_states` (
  `state_id` bigint(20) NOT NULL auto_increment,
  `state` varchar(50) default NULL,
  `country_id` bigint(20) default NULL,
  PRIMARY KEY  (`state_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3405");

//
// Dumping data for table `site_states`
//

$SQL=MYSQL_QUERY("INSERT INTO `site_states` (`state_id`, `state`, `country_id`) VALUES
(461, 'Alberta', 38),
(462, 'British Columbia', 38),
(463, 'Manitoba', 38),
(464, 'New Brunswick', 38),
(465, 'Newfoundland', 38),
(466, 'North West Territories', 38),
(467, 'Nova Scotia', 38),
(468, 'Nunavut', 38),
(469, 'Ontario', 38),
(470, 'Prince Edward Island', 38),
(471, 'Quebec', 38),
(472, 'Saskatchewan', 38),
(473, 'Yukon Territory', 38),
(3215, 'Alabama', 224),
(3216, 'Alaska', 224),
(3217, 'Arizona', 224),
(3218, 'Arkansas', 224),
(3219, 'California', 224),
(3220, 'Colorado', 224),
(3221, 'Connecticut', 224),
(3222, 'Delaware', 224),
(3223, 'District of Columbia', 224),
(3224, 'Florida', 224),
(3225, 'Georgia', 224),
(3226, 'Hawaii', 224),
(3227, 'Idaho', 224),
(3228, 'Illinois', 224),
(3229, 'Indiana', 224),
(3230, 'Iowa', 224),
(3231, 'Kansas', 224),
(3232, 'Kentucky', 224),
(3233, 'Louisiana', 224),
(3234, 'Maine', 224),
(3235, 'Maryland', 224),
(3236, 'Massachusetts', 224),
(3237, 'Michigan', 224),
(3238, 'Minnesota', 224),
(3239, 'Mississippi', 224),
(3240, 'Missouri', 224),
(3241, 'Montana', 224),
(3242, 'Nebraska', 224),
(3243, 'Nevada', 224),
(3244, 'New Hampshire', 224),
(3245, 'New  Jersey', 224),
(3246, 'New Mexico', 224),
(3247, 'New York', 224),
(3249, 'North Dakota', 224),
(3250, 'Ohio', 224),
(3251, 'Oklahoma', 224),
(3252, 'Oregon', 224),
(3253, 'Pennsylvania', 224),
(3254, 'Rhode Island', 224),
(3256, 'South Dakota', 224),
(3257, 'Tennessee', 224),
(3258, 'Texas', 224),
(3259, 'Utah', 224),
(3260, 'Vermont', 224),
(3261, 'Virginia', 224),
(3262, 'Washington', 224),
(3263, 'West Virginia', 224),
(3264, 'Wisconsin', 224),
(3265, 'Wyoming', 224)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `subscriptions`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `subscriptions`");
$SQL=MYSQL_QUERY("CREATE TABLE `subscriptions` (
  `id` bigint(20) NOT NULL auto_increment,
  `user_id` bigint(20) NOT NULL default '0',
  `logo` varchar(150) NOT NULL default '',
  `status` enum('disable','enable','suspend') NOT NULL default 'enable',
  `start_date` datetime NOT NULL,
  `expir_date` datetime NOT NULL,
  `expired` enum('no','yes') NOT NULL default 'no',
  `scheme` varchar(100) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5");

//
// Dumping data for table `subscriptions`
//


// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `tellafriend`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `tellafriend`");
$SQL=MYSQL_QUERY("CREATE TABLE `tellafriend` (
  `auto` bigint(100) NOT NULL auto_increment,
  `user_id` bigint(100) NOT NULL default '0',
  `email` varchar(100) NOT NULL default '',
  `message` text NOT NULL,
  `rdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `reg` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3");

//
// Dumping data for table `tellafriend`
//

$SQL=MYSQL_QUERY("INSERT INTO `tellafriend` (`auto`, `user_id`, `email`, `message`, `rdate`, `reg`) VALUES
(1, 57, 'chaudhurisuvarthi@gmail.com', 'sdfsdfsdf', '2009-02-12 16:08:54', 'no'),
(2, 61, 'markus.boox@o2online.de', 'Yeaaah BidLoop', '2009-03-23 18:19:59', 'no')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `templates`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `templates`");
$SQL=MYSQL_QUERY("CREATE TABLE `templates` (
  `t_id` bigint(20) NOT NULL auto_increment,
  `folder` varchar(25) NOT NULL,
  `template` enum('yes','no') NOT NULL default 'no',
  `logo` varchar(100) NOT NULL,
  PRIMARY KEY  (`t_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=123");

//
// Dumping data for table `templates`
//

$SQL=MYSQL_QUERY("INSERT INTO `templates` (`t_id`, `folder`, `template`, `logo`) VALUES
(1, 'Default', 'yes', 'logo.png')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `terms`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `terms`");
$SQL=MYSQL_QUERY("CREATE TABLE `terms` (
  `term_id` bigint(20) NOT NULL auto_increment,
  `term_title` varchar(30) NOT NULL default '',
  `term_body` text NOT NULL,
  UNIQUE KEY `term_id` (`term_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6");

//
// Dumping data for table `terms`
//

$SQL=MYSQL_QUERY("INSERT INTO `terms` (`term_id`, `term_title`, `term_body`) VALUES
(1, 'Your Terms', 'Terms coming soon...'),
(2, 'Privacy', 'Privacy coming soon.....'),
(3, 'About Us', 'About Us coming soon.....')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `usertransaction`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `usertransaction`");
$SQL=MYSQL_QUERY("CREATE TABLE `usertransaction` (
  `pay_id` bigint(20) NOT NULL auto_increment,
  `trans_amount` float(6,2) NOT NULL default '0.00',
  `itemid` bigint(20) NOT NULL default '0',
  `user_id` bigint(20) NOT NULL default '0',
  `trans_batchnumber` varchar(100) NOT NULL default '0',
  `trans_date` date NOT NULL default '0000-00-00',
  `trans_details` text NOT NULL,
  `seller_id` bigint(20) NOT NULL,
  `buyer_id` bigint(20) NOT NULL,
  `txn_id` varchar(100) NOT NULL,
  `type` enum('debit','credit') NOT NULL,
  `currency` varchar(10) NOT NULL,
  `status` enum('Pending','Queued','Complete') NOT NULL default 'Complete',
  `typeofpay` varchar(10) NOT NULL,
  `service` varchar(100) NOT NULL,
  `purchase` enum('yes','no') NOT NULL default 'no',
  `shipped` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`pay_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1");

//
// Dumping data for table `usertransaction`
//


// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `user_account`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `user_account`");
$SQL=MYSQL_QUERY("CREATE TABLE `user_account` (
  `crmodifyid` bigint(20) NOT NULL auto_increment,
  `user_id` bigint(20) NOT NULL default '0',
  `type` varchar(20) NOT NULL default '',
  `amount` float(6,2) NOT NULL default '0.00',
  UNIQUE KEY `crmodifyid` (`crmodifyid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26");

//
// Dumping data for table `user_account`
//

$SQL=MYSQL_QUERY("INSERT INTO `user_account` (`crmodifyid`, `user_id`, `type`, `amount`) VALUES
(1, 20, '', 12.00)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `user_alert`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `user_alert`");
$SQL=MYSQL_QUERY("CREATE TABLE `user_alert` (
  `alert_id` bigint(20) NOT NULL auto_increment,
  `seller_id` bigint(20) NOT NULL default '0',
  `buyer_id` bigint(20) NOT NULL default '0',
  `productid` bigint(20) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `alert_type` enum('R','P','D') NOT NULL default 'R',
  PRIMARY KEY  (`alert_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=51");

//
// Dumping data for table `user_alert`
//

$SQL=MYSQL_QUERY("INSERT INTO `user_alert` (`alert_id`, `seller_id`, `buyer_id`, `productid`, `date`, `alert_type`) VALUES
(38, 20, 23, 575, '2008-02-02', 'R'),
(39, 23, 20, 583, '2008-02-03', 'R'),
(40, 33, 23, 597, '2008-05-29', 'R'),
(41, 38, 39, 605, '2008-07-31', 'R'),
(42, 40, 41, 606, '2008-07-31', 'R'),
(43, 40, 41, 606, '2008-07-31', 'R'),
(44, 40, 41, 606, '2008-07-31', 'R'),
(45, 40, 41, 606, '2008-07-31', 'R'),
(46, 40, 41, 606, '2008-07-31', 'R'),
(47, 40, 41, 606, '2008-07-31', 'R'),
(48, 40, 41, 606, '2008-07-31', 'R'),
(49, 23, 41, 601, '2008-08-06', 'R'),
(50, 38, 41, 607, '2008-08-06', 'R')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `user_plan`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `user_plan`");
$SQL=MYSQL_QUERY("CREATE TABLE `user_plan` (
  `plan_id` bigint(20) NOT NULL auto_increment,
  `amount` float(6,2) NOT NULL,
  `period` bigint(20) NOT NULL,
  PRIMARY KEY  (`plan_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6");

//
// Dumping data for table `user_plan`
//

$SQL=MYSQL_QUERY("INSERT INTO `user_plan` (`plan_id`, `amount`, `period`) VALUES
(1, 10.00, 30),
(4, 15.00, 60),
(5, 20.00, 120)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `want_it_now`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `want_it_now`");
$SQL=MYSQL_QUERY("CREATE TABLE `want_it_now` (
  `want_id` bigint(20) NOT NULL auto_increment,
  `wanted_itemid` bigint(20) NOT NULL default '0',
  `responseed_itemid` bigint(20) NOT NULL default '0',
  `response_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`want_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1");

//
// Dumping data for table `want_it_now`
//


// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `watches`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `watches`");
$SQL=MYSQL_QUERY("CREATE TABLE `watches` (
  `tableid` int(11) NOT NULL auto_increment,
  `productid` int(11) default '0',
  PRIMARY KEY  (`tableid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1");

//
// Dumping data for table `watches`
//


// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `watch_list`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `watch_list`");
$SQL=MYSQL_QUERY("CREATE TABLE `watch_list` (
  `watchlist_id` bigint(20) NOT NULL auto_increment,
  `user_id` bigint(20) NOT NULL default '0',
  `productid` bigint(20) NOT NULL default '0',
  UNIQUE KEY `watchlist_id` (`watchlist_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=502");

//
// Dumping data for table `watch_list`
//

$SQL=MYSQL_QUERY("INSERT INTO `watch_list` (`watchlist_id`, `user_id`, `productid`) VALUES
(498, 53, 652),
(500, 23, 659)");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `withdraw_gateway`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `withdraw_gateway`");
$SQL=MYSQL_QUERY("CREATE TABLE `withdraw_gateway` (
  `gateway_id` bigint(20) NOT NULL auto_increment,
  `payment_gateway` varchar(250) NOT NULL default '',
  `status` enum('Yes','No') NOT NULL default 'Yes',
  `fees` float(6,2) NOT NULL default '0.00',
  `min_ammount` float(6,2) NOT NULL,
  `comments` text NOT NULL,
  PRIMARY KEY  (`gateway_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8");

//
// Dumping data for table `withdraw_gateway`
//

$SQL=MYSQL_QUERY("INSERT INTO `withdraw_gateway` (`gateway_id`, `payment_gateway`, `status`, `fees`, `min_ammount`, `comments`) VALUES
(1, 'Paypal', 'Yes', 10.00, 5.00, ''),
(2, '2Checkout', 'Yes', 10.00, 5.00, ''),
(3, 'Worldpay', 'Yes', 10.00, 5.00, ''),
(4, 'Money Bookers', 'Yes', 10.00, 0.00, ''),
(5, 'Nochex', 'Yes', 11.00, 0.00, ''),
(6, 'Bank Transfer', 'Yes', 10.00, 5.00, ''),
(7, 'Check', 'Yes', 10.00, 10.00, '')");

// //-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//-//

//
// Table structure for table `withdraw_requests`
//

$SQL=MYSQL_QUERY("DROP TABLE IF EXISTS `withdraw_requests`");
$SQL=MYSQL_QUERY("CREATE TABLE `withdraw_requests` (
  `auto` bigint(100) NOT NULL auto_increment,
  `userid` bigint(100) NOT NULL,
  `method` tinyint(4) NOT NULL,
  `amount` float(6,2) NOT NULL,
  `uid1` varchar(100) NOT NULL,
  `r_date` date NOT NULL,
  `payee_name` varchar(100) NOT NULL,
  `status` enum('pending','completed') NOT NULL,
  `suspend` enum('yes','no') NOT NULL default 'no',
  `comments` text NOT NULL,
  PRIMARY KEY  (`auto`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4");

//
// Dumping data for table `withdraw_requests`
//

$SQL=MYSQL_QUERY("INSERT INTO `withdraw_requests` (`auto`, `userid`, `method`, `amount`, `uid1`, `r_date`, `payee_name`, `status`, `suspend`, `comments`) VALUES
(1, 23, 1, 50.00, 'paypal@itechscripts.com', '2008-05-14', '', 'pending', 'no', ''),
(2, 23, 1, 20.00, 'paypal@itechscripts.com', '2008-05-25', '', 'completed', 'no', '')");
?>