#
# Table structure for table `PHPAUCTION_adminusers`
#
CREATE TABLE `PHPAUCTION_adminusers` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(32) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`created` varchar(8) NOT NULL default '',
`lastlogin` varchar(14) NOT NULL default '',
`status` int(2) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_adminusers`
#
# ############################
#
# Table structure for table `PHPAUCTION_auccounter`
#
CREATE TABLE `PHPAUCTION_auccounter` (
`auction_id` int(11) NOT NULL default '0',
`counter` int(11) NOT NULL default '0',
PRIMARY KEY (`auction_id`)
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_auccounter`
#
# ############################
#
# Table structure for table `PHPAUCTION_auctionblacklists`
#
CREATE TABLE `PHPAUCTION_auctionblacklists` (
`auction_id` int(32) NOT NULL default '0',
`list_id` int(11) NOT NULL default '0',
KEY `auction_id` (`auction_id`)
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_auctionblacklists`
#
# ############################
#
# Table structure for table `PHPAUCTION_auctionextension`
#
CREATE TABLE `PHPAUCTION_auctionextension` (
`status` enum('enabled','disabled') NOT NULL default 'enabled',
`prior` int(11) NOT NULL default '0',
`prolong` int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_auctionextension`
#
INSERT INTO `PHPAUCTION_auctionextension` VALUES ('enabled', 120, 300);
# ############################
#
# Table structure for table `PHPAUCTION_auctioninvitedlists`
#
CREATE TABLE `PHPAUCTION_auctioninvitedlists` (
`auction_id` int(32) NOT NULL default '0',
`list_id` int(11) NOT NULL default '0',
KEY `auction_id` (`auction_id`)
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_auctioninvitedlists`
#
# ############################
#
# Table structure for table `PHPAUCTION_auctions`
#
CREATE TABLE `PHPAUCTION_auctions` (
`id` int(32) NOT NULL auto_increment,
`user` int(32) default NULL,
`title` tinytext,
`starts` varchar(14) default NULL,
`description` text,
`pict_url` tinytext,
`category` int(11) default NULL,
`minimum_bid` double(16,4) default NULL,
`reserve_price` double(16,4) default NULL,
`buy_now` double(16,4) default NULL,
`auction_type` char(1) default NULL,
`duration` varchar(7) default NULL,
`increment` double(8,4) NOT NULL default '0.0000',
`location` varchar(30) default NULL,
`location_zip` varchar(10) default NULL,
`shipping` char(1) default NULL,
`payment` tinytext,
`international` char(1) default NULL,
`ends` varchar(14) default NULL,
`current_bid` double(16,4) default NULL,
`closed` char(2) default NULL,
`photo_uploaded` char(1) default NULL,
`quantity` int(11) default NULL,
`suspended` int(1) default '0',
`private` enum('y','n') NOT NULL default 'n',
`num_bids` int(11) NOT NULL default '0',
`sold` enum('y','n','s') NOT NULL default 'n',
`shipping_terms` tinytext NOT NULL,
`relist` enum('0','1') NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_auctions`
#
# ############################
#
# Table structure for table `PHPAUCTION_banners`
#
CREATE TABLE `PHPAUCTION_banners` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`type` enum('gif','jpg','png','swf') default NULL,
`views` int(11) default NULL,
`clicks` int(11) default NULL,
`url` varchar(255) default NULL,
`sponsortext` varchar(255) default NULL,
`alt` varchar(255) default NULL,
`purchased` int(11) NOT NULL default '0',
`width` int(11) NOT NULL default '0',
`height` int(11) NOT NULL default '0',
`user` int(11) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_banners`
#
# ############################
#
# Table structure for table `PHPAUCTION_bannerscategories`
#
CREATE TABLE `PHPAUCTION_bannerscategories` (
`banner` int(11) NOT NULL default '0',
`category` int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_bannerscategories`
#
# ############################
#
# Table structure for table `PHPAUCTION_bannerskeywords`
#
CREATE TABLE `PHPAUCTION_bannerskeywords` (
`banner` int(11) NOT NULL default '0',
`keyword` varchar(255) NOT NULL default ''
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_bannerskeywords`
#
# ############################
#
# Table structure for table `PHPAUCTION_bannerssettings`
#
CREATE TABLE `PHPAUCTION_bannerssettings` (
`id` int(11) NOT NULL auto_increment,
`sizetype` enum('fix','any') default NULL,
`width` int(11) default NULL,
`height` int(11) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
#
# Dumping data for table `PHPAUCTION_bannerssettings`
#
INSERT INTO `PHPAUCTION_bannerssettings` VALUES (1, 'any', 468, 60);
# ############################
#
# Table structure for table `PHPAUCTION_bannersstats`
#
CREATE TABLE `PHPAUCTION_bannersstats` (
`banner` int(11) default NULL,
`purchased` int(11) default NULL,
`views` int(11) default NULL,
`clicks` int(11) default NULL,
KEY `id` (`banner`)
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_bannersstats`
#
# ############################
#
# Table structure for table `PHPAUCTION_bannersusers`
#
CREATE TABLE `PHPAUCTION_bannersusers` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`company` varchar(255) default NULL,
`email` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_bannersusers`
#
# ############################
#
# Table structure for table `PHPAUCTION_bids`
#
CREATE TABLE `PHPAUCTION_bids` (
`id` int(11) NOT NULL auto_increment,
`auction` int(32) default NULL,
`bidder` int(32) default NULL,
`bid` double(16,4) default NULL,
`bidwhen` varchar(14) default NULL,
`quantity` int(11) default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_bids`
#
# ############################
#
# Table structure for table `PHPAUCTION_blackbuyerslist`
#
CREATE TABLE `PHPAUCTION_blackbuyerslist` (
`list_id` int(11) NOT NULL auto_increment,
`list_name` varchar(20) default NULL,
`user_id` int(32) NOT NULL default '0',
PRIMARY KEY (`list_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_blackbuyerslist`
#
# ############################
#
# Table structure for table `PHPAUCTION_blackbuyersrows`
#
CREATE TABLE `PHPAUCTION_blackbuyersrows` (
`list_id` int(11) NOT NULL default '0',
`buyer_id` varchar(20) NOT NULL default ''
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_blackbuyersrows`
#
# ############################
#
# Table structure for table `PHPAUCTION_categories`
#
CREATE TABLE `PHPAUCTION_categories` (
`cat_id` int(4) NOT NULL auto_increment,
`parent_id` int(4) default NULL,
`cat_name` tinytext,
`deleted` int(1) default NULL,
`sub_counter` int(11) default NULL,
`counter` int(11) default NULL,
`cat_colour` tinytext NOT NULL,
`cat_image` tinytext NOT NULL,
PRIMARY KEY (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=214 ;
#
# Dumping data for table `PHPAUCTION_categories`
#
INSERT INTO `PHPAUCTION_categories` VALUES (1, 0, 'Art & Antiques', 0, 0, 0, '', 'images/categoryimages/art.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (2, 1, 'Ancient World', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (3, 1, 'Amateur Art', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (4, 1, 'Ceramics & Glass', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (5, 4, 'Glass', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (6, 5, '40s, 50s & 60s', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (7, 5, 'Art Glass', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (8, 5, 'Carnival', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (9, 5, 'Contemporary Glass', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (10, 5, 'Porcelain', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (11, 5, 'Chalkware', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (12, 5, 'Chintz & Shelley', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (13, 5, 'Decorative', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (14, 1, 'Fine Art', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (15, 1, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (16, 1, 'Painting', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (17, 1, 'Photographic Images', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (18, 1, 'Prints', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (19, 1, 'Books & Manuscripts', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (20, 1, 'Cameras', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (21, 1, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (22, 1, 'Musical Instruments', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (23, 1, 'Orientalia', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (24, 1, 'Post-1900', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (25, 1, 'Pre-1900', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (26, 1, 'Scientific Instruments', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (27, 1, 'Silver & Silver Plate', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (28, 1, 'Textiles & Linens', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (29, 0, 'Books', 0, 0, 0, '', 'images/categoryimages/book.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (30, 29, 'Arts, Architecture & Photography', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (31, 29, 'Audiobooks', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (32, 29, 'Biographies & Memoirs', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (33, 29, 'Business & Investing', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (34, 29, 'Children''s Books', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (35, 29, 'Computers & Internet', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (36, 29, 'Cooking, Food & Wine', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (37, 29, 'Entertainment', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (38, 29, 'Foreign Language Instruction', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (39, 29, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (40, 29, 'Health, Mind & Body', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (41, 29, 'History', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (42, 29, 'Home & Garden', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (43, 29, 'Horror', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (44, 29, 'Literature & Fiction', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (45, 29, 'Animals', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (46, 29, 'Catalogs', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (47, 29, 'Children', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (48, 29, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (49, 29, 'Illustrated', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (50, 29, 'Men', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (51, 29, 'News', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (52, 29, 'Science Fiction & Fantasy', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (53, 29, 'Sports', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (54, 29, 'Women', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (55, 29, 'Mystery & Thrillers', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (56, 29, 'Nonfiction', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (57, 29, 'Parenting & Families', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (58, 29, 'Poetry', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (59, 29, 'Rare', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (60, 29, 'Reference', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (61, 29, 'Religion & Spirituality', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (62, 29, 'Contemporary', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (63, 29, 'Historical', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (64, 29, 'Regency', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (65, 29, 'Science & Nature', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (66, 29, 'Science Fiction & Fantasy', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (67, 29, 'Sports & Outdoors', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (68, 29, 'Teens', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (69, 29, 'Textbooks', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (70, 29, 'Travel', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (71, 0, 'Clothing & Accessories', 0, 0, 0, '', 'images/categoryimages/clothes.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (72, 71, 'Accessories', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (73, 71, 'Clothing', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (74, 71, 'Watches', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (75, 0, 'Coins & Stamps', 0, 0, 0, '', 'images/categoryimages/coins.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (76, 75, 'Coins', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (77, 75, 'Philately', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (78, 0, 'Collectibles', 0, 0, 0, '', 'images/categoryimages/collect.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (79, 78, 'Advertising', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (80, 78, 'Animals', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (81, 78, 'Animation', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (82, 78, 'Antique Reproductions', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (83, 78, 'Autographs', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (84, 78, 'Barber Shop', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (85, 78, 'Bears', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (86, 78, 'Bells', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (87, 78, 'Bottles & Cans', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (88, 78, 'Breweriana', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (89, 78, 'Cars & Motorcycles', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (90, 78, 'Cereal Boxes & Premiums', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (91, 78, 'Character', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (92, 78, 'Circus & Carnival', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (93, 78, 'Collector Plates', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (94, 78, 'Dolls', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (95, 78, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (96, 78, 'Historical & Cultural', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (97, 78, 'Holiday & Seasonal', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (98, 78, 'Household Items', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (99, 78, 'Kitsch', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (100, 78, 'Knives & Swords', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (101, 78, 'Lunchboxes', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (102, 78, 'Magic & Novelty Items', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (103, 78, 'Memorabilia', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (104, 78, 'Militaria', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (105, 78, 'Music Boxes', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (106, 78, 'Oddities', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (107, 78, 'Paper', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (108, 78, 'Pinbacks', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (109, 78, 'Porcelain Figurines', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (110, 78, 'Railroadiana', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (111, 78, 'Religious', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (112, 78, 'Rocks, Minerals & Fossils', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (113, 78, 'Scientific Instruments', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (114, 78, 'Textiles', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (115, 78, 'Tobacciana', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (116, 0, 'Comics, Cards & Science Fiction', 0, 0, 0, '', 'images/categoryimages/comic.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (117, 116, 'Anime & Manga', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (118, 116, 'Comic Books', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (119, 116, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (120, 116, 'Godzilla', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (121, 116, 'Star Trek', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (122, 116, 'The X-Files', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (123, 116, 'Toys', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (124, 116, 'Trading Cards', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (125, 0, 'Computers & Software', 0, 0, 0, '', 'images/categoryimages/computer.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (126, 125, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (127, 125, 'Hardware', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (128, 125, 'Internet Services', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (129, 125, 'Software', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (130, 0, 'Electronics & Photography', 0, 0, 0, '', 'images/categoryimages/camera.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (131, 130, 'Consumer Electronics', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (132, 130, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (133, 130, 'Photo Equipment', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (134, 130, 'Recording Equipment', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (135, 130, 'Video Equipment', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (136, 0, 'Gemstones & Jewelry', 0, 0, 0, '', 'images/categoryimages/jewelery.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (137, 136, 'Ancient', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (138, 136, 'Beaded Jewelry', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (139, 136, 'Beads', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (140, 136, 'Carved & Cameo', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (141, 136, 'Contemporary', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (142, 136, 'Costume', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (143, 136, 'Fine', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (144, 136, 'Gemstones', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (145, 136, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (146, 136, 'Gold', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (147, 136, 'Necklaces', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (148, 136, 'Silver', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (149, 136, 'Victorian', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (150, 136, 'Vintage', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (151, 0, 'Home & Garden', 0, 0, 0, '', 'images/categoryimages/garden.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (152, 151, 'Baby Items', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (153, 151, 'Crafts', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (154, 151, 'Furniture', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (155, 151, 'Garden', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (156, 151, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (157, 151, 'Household Items', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (158, 151, 'Pet Supplies', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (159, 151, 'Tools & Hardware', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (160, 151, 'Weddings', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (161, 0, 'Movies & Video', 0, 0, 0, '', 'images/categoryimages/movie.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (162, 161, 'DVD', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (163, 161, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (164, 161, 'Laser Discs', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (165, 161, 'VHS', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (166, 0, 'Music', 0, 0, 0, '', 'images/categoryimages/music.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (167, 166, 'CDs', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (168, 166, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (169, 166, 'Instruments', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (170, 166, 'Memorabilia', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (171, 166, 'Records', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (172, 166, 'Tapes', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (173, 0, 'Office & Business', 0, 0, 0, '', 'images/categoryimages/office.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (174, 173, 'Briefcases', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (175, 173, 'Fax Machines', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (176, 173, 'General Equipment', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (177, 173, 'Pagers', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (178, 0, 'Other Goods & Services', 0, 0, 0, '', 'images/categoryimages/dump.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (179, 178, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (180, 178, 'Metaphysical', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (181, 178, 'Property', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (182, 178, 'Services', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (183, 178, 'Tickets & Events', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (184, 178, 'Transportation', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (185, 178, 'Travel', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (186, 0, 'Sports & Recreation', 0, 0, 0, '', 'images/categoryimages/sports.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (187, 186, 'Apparel & Equipment', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (188, 186, 'Exercise Equipment', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (189, 186, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (190, 0, 'Toys & Games', 0, 0, 0, '', 'images/categoryimages/games.gif');
INSERT INTO `PHPAUCTION_categories` VALUES (191, 190, 'Action Figures', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (192, 190, 'Beanie Babies & Beanbag Toys', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (193, 190, 'Diecast', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (194, 190, 'Fast Food', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (195, 190, 'Fisher-Price', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (196, 190, 'Furby', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (197, 190, 'Games', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (198, 190, 'General', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (199, 190, 'Giga Pet & Tamagotchi', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (200, 190, 'Hobbies', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (201, 190, 'Marbles', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (202, 190, 'My Little Pony', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (203, 190, 'Peanuts Gang', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (204, 190, 'Pez', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (205, 190, 'Plastic Models', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (206, 190, 'Plush Toys', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (207, 190, 'Puzzles', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (208, 190, 'Slot Cars', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (209, 190, 'Teletubbies', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (210, 190, 'Toy Soldiers', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (211, 190, 'Vintage Tin', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (212, 190, 'Vintage Vehicles', 0, 0, 0, '', '');
INSERT INTO `PHPAUCTION_categories` VALUES (213, 190, 'Vintage', 0, 0, 0, '', '');
# ############################
#
# Table structure for table `PHPAUCTION_categories_plain`
#
CREATE TABLE `PHPAUCTION_categories_plain` (
`id` int(11) NOT NULL auto_increment,
`cat_id` int(11) default NULL,
`cat_name` tinytext,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=214 ;
#
# Dumping data for table `PHPAUCTION_categories_plain`
#
INSERT INTO `PHPAUCTION_categories_plain` VALUES (1, 1, 'Art & Antiques');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (2, 3, ' Amateur Art');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (3, 2, ' Ancient World');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (4, 19, ' Books & Manuscripts');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (5, 20, ' Cameras');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (6, 4, ' Ceramics & Glass');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (7, 5, ' Glass');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (8, 6, ' 40s, 50s & 60s');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (9, 7, ' Art Glass');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (10, 8, ' Carnival');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (11, 11, ' Chalkware');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (12, 12, ' Chintz & Shelley');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (13, 9, ' Contemporary Glass');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (14, 13, ' Decorative');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (15, 10, ' Porcelain');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (16, 14, ' Fine Art');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (17, 15, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (18, 21, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (19, 22, ' Musical Instruments');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (20, 23, ' Orientalia');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (21, 16, ' Painting');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (22, 17, ' Photographic Images');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (23, 24, ' Post-1900');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (24, 25, ' Pre-1900');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (25, 18, ' Prints');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (26, 26, ' Scientific Instruments');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (27, 27, ' Silver & Silver Plate');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (28, 28, ' Textiles & Linens');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (29, 29, 'Books');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (30, 45, ' Animals');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (31, 30, ' Arts, Architecture & Photography');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (32, 31, ' Audiobooks');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (33, 32, ' Biographies & Memoirs');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (34, 33, ' Business & Investing');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (35, 46, ' Catalogs');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (36, 47, ' Children');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (37, 34, ' Children''s Books');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (38, 35, ' Computers & Internet');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (39, 62, ' Contemporary');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (40, 36, ' Cooking, Food & Wine');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (41, 37, ' Entertainment');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (42, 38, ' Foreign Language Instruction');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (43, 39, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (44, 48, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (45, 40, ' Health, Mind & Body');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (46, 63, ' Historical');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (47, 41, ' History');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (48, 42, ' Home & Garden');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (49, 43, ' Horror');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (50, 49, ' Illustrated');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (51, 44, ' Literature & Fiction');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (52, 50, ' Men');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (53, 55, ' Mystery & Thrillers');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (54, 51, ' News');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (55, 56, ' Nonfiction');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (56, 57, ' Parenting & Families');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (57, 58, ' Poetry');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (58, 59, ' Rare');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (59, 60, ' Reference');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (60, 64, ' Regency');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (61, 61, ' Religion & Spirituality');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (62, 65, ' Science & Nature');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (63, 52, ' Science Fiction & Fantasy');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (64, 66, ' Science Fiction & Fantasy');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (65, 53, ' Sports');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (66, 67, ' Sports & Outdoors');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (67, 68, ' Teens');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (68, 69, ' Textbooks');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (69, 70, ' Travel');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (70, 54, ' Women');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (71, 71, 'Clothing & Accessories');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (72, 72, ' Accessories');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (73, 73, ' Clothing');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (74, 74, ' Watches');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (75, 75, 'Coins & Stamps');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (76, 76, ' Coins');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (77, 77, ' Philately');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (78, 78, 'Collectibles');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (79, 79, ' Advertising');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (80, 80, ' Animals');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (81, 81, ' Animation');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (82, 82, ' Antique Reproductions');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (83, 83, ' Autographs');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (84, 84, ' Barber Shop');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (85, 85, ' Bears');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (86, 86, ' Bells');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (87, 87, ' Bottles & Cans');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (88, 88, ' Breweriana');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (89, 89, ' Cars & Motorcycles');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (90, 90, ' Cereal Boxes & Premiums');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (91, 91, ' Character');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (92, 92, ' Circus & Carnival');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (93, 93, ' Collector Plates');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (94, 94, ' Dolls');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (95, 95, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (96, 96, ' Historical & Cultural');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (97, 97, ' Holiday & Seasonal');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (98, 98, ' Household Items');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (99, 99, ' Kitsch');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (100, 100, ' Knives & Swords');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (101, 101, ' Lunchboxes');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (102, 102, ' Magic & Novelty Items');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (103, 103, ' Memorabilia');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (104, 104, ' Militaria');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (105, 105, ' Music Boxes');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (106, 106, ' Oddities');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (107, 107, ' Paper');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (108, 108, ' Pinbacks');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (109, 109, ' Porcelain Figurines');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (110, 110, ' Railroadiana');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (111, 111, ' Religious');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (112, 112, ' Rocks, Minerals & Fossils');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (113, 113, ' Scientific Instruments');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (114, 114, ' Textiles');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (115, 115, ' Tobacciana');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (116, 116, 'Comics, Cards & Science Fiction');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (117, 117, ' Anime & Manga');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (118, 118, ' Comic Books');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (119, 119, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (120, 120, ' Godzilla');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (121, 121, ' Star Trek');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (122, 122, ' The X-Files');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (123, 123, ' Toys');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (124, 124, ' Trading Cards');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (125, 125, 'Computers & Software');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (126, 126, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (127, 127, ' Hardware');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (128, 128, ' Internet Services');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (129, 129, ' Software');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (130, 130, 'Electronics & Photography');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (131, 131, ' Consumer Electronics');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (132, 132, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (133, 133, ' Photo Equipment');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (134, 134, ' Recording Equipment');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (135, 135, ' Video Equipment');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (136, 136, 'Gemstones & Jewelry');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (137, 137, ' Ancient');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (138, 138, ' Beaded Jewelry');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (139, 139, ' Beads');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (140, 140, ' Carved & Cameo');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (141, 141, ' Contemporary');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (142, 142, ' Costume');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (143, 143, ' Fine');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (144, 144, ' Gemstones');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (145, 145, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (146, 146, ' Gold');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (147, 147, ' Necklaces');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (148, 148, ' Silver');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (149, 149, ' Victorian');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (150, 150, ' Vintage');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (151, 151, 'Home & Garden');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (152, 152, ' Baby Items');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (153, 153, ' Crafts');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (154, 154, ' Furniture');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (155, 155, ' Garden');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (156, 156, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (157, 157, ' Household Items');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (158, 158, ' Pet Supplies');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (159, 159, ' Tools & Hardware');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (160, 160, ' Weddings');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (161, 161, 'Movies & Video');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (162, 162, ' DVD');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (163, 163, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (164, 164, ' Laser Discs');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (165, 165, ' VHS');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (166, 166, 'Music');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (167, 167, ' CDs');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (168, 168, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (169, 169, ' Instruments');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (170, 170, ' Memorabilia');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (171, 171, ' Records');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (172, 172, ' Tapes');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (173, 173, 'Office & Business');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (174, 174, ' Briefcases');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (175, 175, ' Fax Machines');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (176, 176, ' General Equipment');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (177, 177, ' Pagers');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (178, 178, 'Other Goods & Services');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (179, 179, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (180, 180, ' Metaphysical');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (181, 181, ' Property');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (182, 182, ' Services');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (183, 183, ' Tickets & Events');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (184, 184, ' Transportation');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (185, 185, ' Travel');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (186, 186, 'Sports & Recreation');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (187, 187, ' Apparel & Equipment');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (188, 188, ' Exercise Equipment');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (189, 189, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (190, 190, 'Toys & Games');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (191, 191, ' Action Figures');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (192, 192, ' Beanie Babies & Beanbag Toys');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (193, 193, ' Diecast');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (194, 194, ' Fast Food');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (195, 195, ' Fisher-Price');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (196, 196, ' Furby');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (197, 197, ' Games');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (198, 198, ' General');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (199, 199, ' Giga Pet & Tamagotchi');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (200, 200, ' Hobbies');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (201, 201, ' Marbles');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (202, 202, ' My Little Pony');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (203, 203, ' Peanuts Gang');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (204, 204, ' Pez');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (205, 205, ' Plastic Models');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (206, 206, ' Plush Toys');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (207, 207, ' Puzzles');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (208, 208, ' Slot Cars');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (209, 209, ' Teletubbies');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (210, 210, ' Toy Soldiers');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (211, 213, ' Vintage');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (212, 211, ' Vintage Tin');
INSERT INTO `PHPAUCTION_categories_plain` VALUES (213, 212, ' Vintage Vehicles');
# ############################
#
# Table structure for table `PHPAUCTION_closedrelisted`
#
CREATE TABLE `PHPAUCTION_closedrelisted` (
`auction` int(32) default '0',
`relistdate` varchar(8) NOT NULL default '',
`newauction` int(32) NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_closedrelisted`
#
# ############################
#
# Table structure for table `PHPAUCTION_counters`
#
CREATE TABLE `PHPAUCTION_counters` (
`users` int(11) default '0',
`auctions` int(11) default '0',
`closedauctions` int(11) NOT NULL default '0',
`inactiveusers` int(11) NOT NULL default '0',
`bids` int(11) NOT NULL default '0',
`transactions` int(11) NOT NULL default '0',
`totalamount` double NOT NULL default '0',
`resetdate` varchar(8) NOT NULL default '',
`fees` double NOT NULL default '0',
`suspendedauction` int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_counters`
#
INSERT INTO `PHPAUCTION_counters` VALUES (1, 0, 0, 0, 0, 135, 1001423, '20020101', 548.95, 1);
# ############################
#
# Table structure for table `PHPAUCTION_counterstoshow`
#
CREATE TABLE `PHPAUCTION_counterstoshow` (
`auctions` enum('y','n') NOT NULL default 'y',
`users` enum('y','n') NOT NULL default 'y',
`online` enum('y','n') NOT NULL default 'y'
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_counterstoshow`
#
INSERT INTO `PHPAUCTION_counterstoshow` VALUES ('y', 'y', 'y');
# ############################
#
# Table structure for table `PHPAUCTION_countries`
#
CREATE TABLE `PHPAUCTION_countries` (
`country` varchar(30) NOT NULL default '',
PRIMARY KEY (`country`)
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_countries`
#
INSERT INTO `PHPAUCTION_countries` VALUES ('Afghanistan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Albania');
INSERT INTO `PHPAUCTION_countries` VALUES ('Algeria');
INSERT INTO `PHPAUCTION_countries` VALUES ('American Samoa');
INSERT INTO `PHPAUCTION_countries` VALUES ('Andorra');
INSERT INTO `PHPAUCTION_countries` VALUES ('Angola');
INSERT INTO `PHPAUCTION_countries` VALUES ('Anguilla');
INSERT INTO `PHPAUCTION_countries` VALUES ('Antarctica');
INSERT INTO `PHPAUCTION_countries` VALUES ('Antigua And Barbuda');
INSERT INTO `PHPAUCTION_countries` VALUES ('Argentina');
INSERT INTO `PHPAUCTION_countries` VALUES ('Armenia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Aruba');
INSERT INTO `PHPAUCTION_countries` VALUES ('Australia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Austria');
INSERT INTO `PHPAUCTION_countries` VALUES ('Azerbaijan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Bahamas');
INSERT INTO `PHPAUCTION_countries` VALUES ('Bahrain');
INSERT INTO `PHPAUCTION_countries` VALUES ('Bangladesh');
INSERT INTO `PHPAUCTION_countries` VALUES ('Barbados');
INSERT INTO `PHPAUCTION_countries` VALUES ('Belarus');
INSERT INTO `PHPAUCTION_countries` VALUES ('Belgium');
INSERT INTO `PHPAUCTION_countries` VALUES ('Belize');
INSERT INTO `PHPAUCTION_countries` VALUES ('Benin');
INSERT INTO `PHPAUCTION_countries` VALUES ('Bermuda');
INSERT INTO `PHPAUCTION_countries` VALUES ('Bhutan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Bolivia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Bosnia and Herzegowina');
INSERT INTO `PHPAUCTION_countries` VALUES ('Botswana');
INSERT INTO `PHPAUCTION_countries` VALUES ('Bouvet Island');
INSERT INTO `PHPAUCTION_countries` VALUES ('Brazil');
INSERT INTO `PHPAUCTION_countries` VALUES ('British Indian Ocean Territory');
INSERT INTO `PHPAUCTION_countries` VALUES ('Brunei Darussalam');
INSERT INTO `PHPAUCTION_countries` VALUES ('Bulgaria');
INSERT INTO `PHPAUCTION_countries` VALUES ('Burkina Faso');
INSERT INTO `PHPAUCTION_countries` VALUES ('Burma');
INSERT INTO `PHPAUCTION_countries` VALUES ('Burundi');
INSERT INTO `PHPAUCTION_countries` VALUES ('Cambodia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Cameroon');
INSERT INTO `PHPAUCTION_countries` VALUES ('Canada');
INSERT INTO `PHPAUCTION_countries` VALUES ('Cape Verde');
INSERT INTO `PHPAUCTION_countries` VALUES ('Cayman Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Central African Republic');
INSERT INTO `PHPAUCTION_countries` VALUES ('Chad');
INSERT INTO `PHPAUCTION_countries` VALUES ('Chile');
INSERT INTO `PHPAUCTION_countries` VALUES ('China');
INSERT INTO `PHPAUCTION_countries` VALUES ('Christmas Island');
INSERT INTO `PHPAUCTION_countries` VALUES ('Cocos (Keeling) Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Colombia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Comoros');
INSERT INTO `PHPAUCTION_countries` VALUES ('Congo');
INSERT INTO `PHPAUCTION_countries` VALUES ('Congo, the Democratic Republic');
INSERT INTO `PHPAUCTION_countries` VALUES ('Cook Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Costa Rica');
INSERT INTO `PHPAUCTION_countries` VALUES ('Cote d''Ivoire');
INSERT INTO `PHPAUCTION_countries` VALUES ('Croatia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Cyprus');
INSERT INTO `PHPAUCTION_countries` VALUES ('Czech Republic');
INSERT INTO `PHPAUCTION_countries` VALUES ('Denmark');
INSERT INTO `PHPAUCTION_countries` VALUES ('Djibouti');
INSERT INTO `PHPAUCTION_countries` VALUES ('Dominica');
INSERT INTO `PHPAUCTION_countries` VALUES ('Dominican Republic');
INSERT INTO `PHPAUCTION_countries` VALUES ('East Timor');
INSERT INTO `PHPAUCTION_countries` VALUES ('Ecuador');
INSERT INTO `PHPAUCTION_countries` VALUES ('Egypt');
INSERT INTO `PHPAUCTION_countries` VALUES ('El Salvador');
INSERT INTO `PHPAUCTION_countries` VALUES ('England');
INSERT INTO `PHPAUCTION_countries` VALUES ('Equatorial Guinea');
INSERT INTO `PHPAUCTION_countries` VALUES ('Eritrea');
INSERT INTO `PHPAUCTION_countries` VALUES ('Estonia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Ethiopia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Falkland Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Faroe Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Fiji');
INSERT INTO `PHPAUCTION_countries` VALUES ('Finland');
INSERT INTO `PHPAUCTION_countries` VALUES ('France');
INSERT INTO `PHPAUCTION_countries` VALUES ('French Guiana');
INSERT INTO `PHPAUCTION_countries` VALUES ('French Polynesia');
INSERT INTO `PHPAUCTION_countries` VALUES ('French Southern Territories');
INSERT INTO `PHPAUCTION_countries` VALUES ('Gabon');
INSERT INTO `PHPAUCTION_countries` VALUES ('Gambia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Georgia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Germany');
INSERT INTO `PHPAUCTION_countries` VALUES ('Ghana');
INSERT INTO `PHPAUCTION_countries` VALUES ('Gibraltar');
INSERT INTO `PHPAUCTION_countries` VALUES ('Great Britain');
INSERT INTO `PHPAUCTION_countries` VALUES ('Greece');
INSERT INTO `PHPAUCTION_countries` VALUES ('Greenland');
INSERT INTO `PHPAUCTION_countries` VALUES ('Grenada');
INSERT INTO `PHPAUCTION_countries` VALUES ('Guadeloupe');
INSERT INTO `PHPAUCTION_countries` VALUES ('Guam');
INSERT INTO `PHPAUCTION_countries` VALUES ('Guatemala');
INSERT INTO `PHPAUCTION_countries` VALUES ('Guinea');
INSERT INTO `PHPAUCTION_countries` VALUES ('Guinea-Bissau');
INSERT INTO `PHPAUCTION_countries` VALUES ('Guyana');
INSERT INTO `PHPAUCTION_countries` VALUES ('Haiti');
INSERT INTO `PHPAUCTION_countries` VALUES ('Heard and Mc Donald Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Holy See (Vatican City State)');
INSERT INTO `PHPAUCTION_countries` VALUES ('Honduras');
INSERT INTO `PHPAUCTION_countries` VALUES ('Hong Kong');
INSERT INTO `PHPAUCTION_countries` VALUES ('Hungary');
INSERT INTO `PHPAUCTION_countries` VALUES ('Iceland');
INSERT INTO `PHPAUCTION_countries` VALUES ('India');
INSERT INTO `PHPAUCTION_countries` VALUES ('Indonesia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Ireland');
INSERT INTO `PHPAUCTION_countries` VALUES ('Israel');
INSERT INTO `PHPAUCTION_countries` VALUES ('Italy');
INSERT INTO `PHPAUCTION_countries` VALUES ('Jamaica');
INSERT INTO `PHPAUCTION_countries` VALUES ('Japan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Jordan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Kazakhstan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Kenya');
INSERT INTO `PHPAUCTION_countries` VALUES ('Kiribati');
INSERT INTO `PHPAUCTION_countries` VALUES ('Korea (South)');
INSERT INTO `PHPAUCTION_countries` VALUES ('Kuwait');
INSERT INTO `PHPAUCTION_countries` VALUES ('Kyrgyzstan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Lao People''s Democratic Republ');
INSERT INTO `PHPAUCTION_countries` VALUES ('Latvia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Lebanon');
INSERT INTO `PHPAUCTION_countries` VALUES ('Lesotho');
INSERT INTO `PHPAUCTION_countries` VALUES ('Liberia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Liechtenstein');
INSERT INTO `PHPAUCTION_countries` VALUES ('Lithuania');
INSERT INTO `PHPAUCTION_countries` VALUES ('Luxembourg');
INSERT INTO `PHPAUCTION_countries` VALUES ('Macau');
INSERT INTO `PHPAUCTION_countries` VALUES ('Macedonia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Madagascar');
INSERT INTO `PHPAUCTION_countries` VALUES ('Malawi');
INSERT INTO `PHPAUCTION_countries` VALUES ('Malaysia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Maldives');
INSERT INTO `PHPAUCTION_countries` VALUES ('Mali');
INSERT INTO `PHPAUCTION_countries` VALUES ('Malta');
INSERT INTO `PHPAUCTION_countries` VALUES ('Marshall Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Martinique');
INSERT INTO `PHPAUCTION_countries` VALUES ('Mauritania');
INSERT INTO `PHPAUCTION_countries` VALUES ('Mauritius');
INSERT INTO `PHPAUCTION_countries` VALUES ('Mayotte');
INSERT INTO `PHPAUCTION_countries` VALUES ('Mexico');
INSERT INTO `PHPAUCTION_countries` VALUES ('Micronesia, Federated States o');
INSERT INTO `PHPAUCTION_countries` VALUES ('Moldova, Republic of');
INSERT INTO `PHPAUCTION_countries` VALUES ('Monaco');
INSERT INTO `PHPAUCTION_countries` VALUES ('Mongolia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Montserrat');
INSERT INTO `PHPAUCTION_countries` VALUES ('Morocco');
INSERT INTO `PHPAUCTION_countries` VALUES ('Mozambique');
INSERT INTO `PHPAUCTION_countries` VALUES ('Namibia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Nauru');
INSERT INTO `PHPAUCTION_countries` VALUES ('Nepal');
INSERT INTO `PHPAUCTION_countries` VALUES ('Netherlands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Netherlands Antilles');
INSERT INTO `PHPAUCTION_countries` VALUES ('New Caledonia');
INSERT INTO `PHPAUCTION_countries` VALUES ('New Zealand');
INSERT INTO `PHPAUCTION_countries` VALUES ('Nicaragua');
INSERT INTO `PHPAUCTION_countries` VALUES ('Niger');
INSERT INTO `PHPAUCTION_countries` VALUES ('Nigeria');
INSERT INTO `PHPAUCTION_countries` VALUES ('Niuev');
INSERT INTO `PHPAUCTION_countries` VALUES ('Norfolk Island');
INSERT INTO `PHPAUCTION_countries` VALUES ('Northern Ireland');
INSERT INTO `PHPAUCTION_countries` VALUES ('Northern Mariana Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Norway');
INSERT INTO `PHPAUCTION_countries` VALUES ('Oman');
INSERT INTO `PHPAUCTION_countries` VALUES ('Pakistan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Palau');
INSERT INTO `PHPAUCTION_countries` VALUES ('Panama');
INSERT INTO `PHPAUCTION_countries` VALUES ('Papua New Guinea');
INSERT INTO `PHPAUCTION_countries` VALUES ('Paraguay');
INSERT INTO `PHPAUCTION_countries` VALUES ('Peru');
INSERT INTO `PHPAUCTION_countries` VALUES ('Philippines');
INSERT INTO `PHPAUCTION_countries` VALUES ('Pitcairn');
INSERT INTO `PHPAUCTION_countries` VALUES ('Poland');
INSERT INTO `PHPAUCTION_countries` VALUES ('Portugal');
INSERT INTO `PHPAUCTION_countries` VALUES ('Puerto Rico');
INSERT INTO `PHPAUCTION_countries` VALUES ('Qatar');
INSERT INTO `PHPAUCTION_countries` VALUES ('Reunion');
INSERT INTO `PHPAUCTION_countries` VALUES ('Romania');
INSERT INTO `PHPAUCTION_countries` VALUES ('Russian Federation');
INSERT INTO `PHPAUCTION_countries` VALUES ('Rwanda');
INSERT INTO `PHPAUCTION_countries` VALUES ('Saint Kitts and Nevis');
INSERT INTO `PHPAUCTION_countries` VALUES ('Saint Lucia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Saint Vincent and the Grenadin');
INSERT INTO `PHPAUCTION_countries` VALUES ('Samoa (Independent)');
INSERT INTO `PHPAUCTION_countries` VALUES ('San Marino');
INSERT INTO `PHPAUCTION_countries` VALUES ('Sao Tome and Principe');
INSERT INTO `PHPAUCTION_countries` VALUES ('Saudi Arabia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Scotland');
INSERT INTO `PHPAUCTION_countries` VALUES ('Senegal');
INSERT INTO `PHPAUCTION_countries` VALUES ('Seychelles');
INSERT INTO `PHPAUCTION_countries` VALUES ('Sierra Leone');
INSERT INTO `PHPAUCTION_countries` VALUES ('Singapore');
INSERT INTO `PHPAUCTION_countries` VALUES ('Slovakia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Slovenia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Solomon Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Somalia');
INSERT INTO `PHPAUCTION_countries` VALUES ('South Africa');
INSERT INTO `PHPAUCTION_countries` VALUES ('South Georgia and the South Sa');
INSERT INTO `PHPAUCTION_countries` VALUES ('Spain');
INSERT INTO `PHPAUCTION_countries` VALUES ('Sri Lanka');
INSERT INTO `PHPAUCTION_countries` VALUES ('St. Helena');
INSERT INTO `PHPAUCTION_countries` VALUES ('St. Pierre and Miquelon');
INSERT INTO `PHPAUCTION_countries` VALUES ('Suriname');
INSERT INTO `PHPAUCTION_countries` VALUES ('Svalbard and Jan Mayen Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Swaziland');
INSERT INTO `PHPAUCTION_countries` VALUES ('Sweden');
INSERT INTO `PHPAUCTION_countries` VALUES ('Switzerland');
INSERT INTO `PHPAUCTION_countries` VALUES ('Taiwan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Tajikistan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Tanzania');
INSERT INTO `PHPAUCTION_countries` VALUES ('Thailand');
INSERT INTO `PHPAUCTION_countries` VALUES ('Togo');
INSERT INTO `PHPAUCTION_countries` VALUES ('Tokelau');
INSERT INTO `PHPAUCTION_countries` VALUES ('Tonga');
INSERT INTO `PHPAUCTION_countries` VALUES ('Trinidad and Tobago');
INSERT INTO `PHPAUCTION_countries` VALUES ('Tunisia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Turkey');
INSERT INTO `PHPAUCTION_countries` VALUES ('Turkmenistan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Turks and Caicos Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Tuvalu');
INSERT INTO `PHPAUCTION_countries` VALUES ('Uganda');
INSERT INTO `PHPAUCTION_countries` VALUES ('Ukraine');
INSERT INTO `PHPAUCTION_countries` VALUES ('United Arab Emiratesv');
INSERT INTO `PHPAUCTION_countries` VALUES ('United States');
INSERT INTO `PHPAUCTION_countries` VALUES ('Uruguay');
INSERT INTO `PHPAUCTION_countries` VALUES ('Uzbekistan');
INSERT INTO `PHPAUCTION_countries` VALUES ('Vanuatu');
INSERT INTO `PHPAUCTION_countries` VALUES ('Venezuela');
INSERT INTO `PHPAUCTION_countries` VALUES ('Viet Nam');
INSERT INTO `PHPAUCTION_countries` VALUES ('Virgin Islands (British)');
INSERT INTO `PHPAUCTION_countries` VALUES ('Virgin Islands (U.S.)');
INSERT INTO `PHPAUCTION_countries` VALUES ('Wales');
INSERT INTO `PHPAUCTION_countries` VALUES ('Wallis and Futuna Islands');
INSERT INTO `PHPAUCTION_countries` VALUES ('Western Sahara');
INSERT INTO `PHPAUCTION_countries` VALUES ('Yemen');
INSERT INTO `PHPAUCTION_countries` VALUES ('Zambia');
INSERT INTO `PHPAUCTION_countries` VALUES ('Zimbabwe');
# ############################
#
# Table structure for table `PHPAUCTION_currencies`
#
CREATE TABLE `PHPAUCTION_currencies` (
`id` int(11) NOT NULL auto_increment,
`currency` varchar(100) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_currencies`
#
# ############################
#
# Table structure for table `PHPAUCTION_durations`
#
CREATE TABLE `PHPAUCTION_durations` (
`days` int(11) NOT NULL default '0',
`description` varchar(30) default NULL
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_durations`
#
INSERT INTO `PHPAUCTION_durations` VALUES (1, '1 day');
INSERT INTO `PHPAUCTION_durations` VALUES (2, '2 days');
INSERT INTO `PHPAUCTION_durations` VALUES (3, '3 days');
INSERT INTO `PHPAUCTION_durations` VALUES (7, '1 week');
# ############################
#
# Table structure for table `PHPAUCTION_faqs`
#
CREATE TABLE `PHPAUCTION_faqs` (
`id` int(11) NOT NULL auto_increment,
`question` varchar(200) NOT NULL default '',
`answer` text NOT NULL,
`category` int(11) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
#
# Dumping data for table `PHPAUCTION_faqs`
#
INSERT INTO `PHPAUCTION_faqs` VALUES (2, 'Registering', 'To register as a new user, click on Register at the top of the window. You will be asked for your name, a username and password, and contact information, including your email address.\n\nYou must be at least 18 years of age to register.', 1);
INSERT INTO `PHPAUCTION_faqs` VALUES (4, 'Item Watch', 'Item watch notifies you when someone bids on the auctions that you have added to your Item Watch. ', 3);
INSERT INTO `PHPAUCTION_faqs` VALUES (5, 'How to bid', ' To bid on an item, type your maximum bid amount in the box next to the item description, and click the ''Go'' button. Your bid must be above the Minimum Bid amount specified in the box.\nYou will be asked to confirm your bid. Fill in your username and password and click ''Submit'' to complete your bid.\n\nNote*** Maximum bid and proxy bid are the same thing. To place a proxy bid, just enter the maximum amount you are willing to pay. Automatic bids will be placed for you up to your maximum amount. Using proxy bidding, you can win the item at the lowest possible price. Your maximum bid is only placed when a competing bidder bids the same amount.\nPlease note that if the current high bidder''s maximum bid is higher than the bid you place, you are immediately outbid because your bid is not high enough to beat the earlier maximum bid. Remember: Proxy bidding will confidentially & automatically bid up to your maximum, but in order to avoid being outbid, you must have the highest maximum bid. Also, if another bidder placed a higher maximum bid, your bid will increase to your maximum bid because proxy bidding bids on your behalf up to your maximum bid.', 3);
INSERT INTO `PHPAUCTION_faqs` VALUES (6, 'Auction Watch', ' Auction Watch is your assistant to keep an eye on auctions which are opened pertaining to your keywords.\n\nTo use this feature, insert keyword(s) into the Auction Watch list that you are interested in. When these keywords appear in an auction''s title or description, you will receive an e-mail informing you that an auction has been opened containing your keyword(s). You may also add a user''s nickname and if that user opens an auction you will get notification by e-mail. All keywords must be separated by a space when entering into your Auction Watch list.', 3);
INSERT INTO `PHPAUCTION_faqs` VALUES (7, 'Dutch Auctions', ' Dutch Auctions are used to sell multiple quantities of the same item. They allow sellers to sell the same item in various quantities as one single lot in an auction. With a Dutch Auction the items do not have to be listed separately saving time. In a Dutch Auction, all the winning bidders pay the same price. The final price is determined by the lowest winning bid. So, even if your bid is higher than the lowest winning bid, you will still pay the lower amount. The highest bidders of the available quantities win, and the lowest bid within the group of winners sets the final price. As an example, if three people bid on one of three items, the price each bidder would pay would be the third highest bidder''s bid amount and each would receive one item as per their bid. If there are multiple buyers bidding on various quantities in a lot the highest bidders are the ones that get first service. The highest bidders'' request for their quantities will be honored, while quantities last. In other words, the lowest winning bidder may not get the quantity they wanted. Therefore, it is not always good to be the lowest successful bidder. The highest bidder will get theirs first which may leave you with just one item, or an amount less than you wanted. If you want more than one of an item in a Dutch Auction don''t be stingy with your maximum bid. By maximizing your bid you may win your requested quantitiy and pay the lowest winning bid price instead of paying the lowest bid price with only one item.', 1);
INSERT INTO `PHPAUCTION_faqs` VALUES (8, 'Feedback System', 'You may only leave feedback about another user if you have had a \'sold\' auction transaction with that user. In order to leave feedback, you must go to the item page of that closed auction, or go to your control panel and view your winners/sellers list. From the list, click on the user\'s name to go to their profile page. On the user\'s profile page, click on \'Leave Feedback\'.We use a 0-5 Star rating system to rate the number of users\' feedbacks, with one star being 5 feedbacks and five stars being over 30 the number of feedbacks.
A \'Trusted\' user is one who has an 80% positive feedback score (4 out of 5, 8 out of 10, etc).
You must fill in all form elements to leave feedback. You must choose your rating, -1(negative), 0(fair), +1(positive), as well as leave your written comment about the transaction and/or user.', 1);
INSERT INTO PHPAUCTION_faqs VALUES (9, 'How to sell', ' To sell an item, you must be a registered user.
Click on \'Sell an Item\' at the top of the window to create a new auction. Login. Indicate the title and description of your item, and select a graphic image from your local hard drive. It is very important to note that the image must be under 51 Kbs (Kilobytes).
To check on the size of an image, you should be able to browse to the image in My Computer. Hold your cursor over the image name or thumbnail. A small box should appear giving you the size information on that particular image. If it is over 51 Kb, you will need to resize it using any kind of image editing software.
Specify the minimum bid and reserve price (optional) for your auction, and what types of payment you will accept. While this site allows you to specify payment methods, it does not process the payment for you.
Choose the category in which your item should be. You may suggest a new category, but you must select an existing category for your new auction.
How to complete the deal
After a person has won an auction, it is the responsibility of both parties( buyer & seller) to contact each other via email within 3 days of the end of the auction. After an auction closes, the buyer as well as the seller should receive an email with each other\'s information.
How can I leave Feedback?
Once an auction closes, you will receive an email from this auction site. There will be a link to the item. Click on this link. This will bring up the item page. Now, you must click on the user name of the person you want to leave feedback for. The feedback window will pop up.', 2);
# ############################
#
# Table structure for table `PHPAUCTION_faqscategories`
#
CREATE TABLE `PHPAUCTION_faqscategories` (
`id` int(11) NOT NULL auto_increment,
`category` varchar(200) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
#
# Dumping data for table `PHPAUCTION_faqscategories`
#
INSERT INTO `PHPAUCTION_faqscategories` VALUES (1, 'General');
INSERT INTO `PHPAUCTION_faqscategories` VALUES (2, 'Selling');
INSERT INTO `PHPAUCTION_faqscategories` VALUES (3, 'Buying');
# ############################
#
# Table structure for table `PHPAUCTION_feedbacks`
#
CREATE TABLE `PHPAUCTION_feedbacks` (
`id` int(11) NOT NULL auto_increment,
`rated_user_id` int(32) default NULL,
`rater_user_nick` varchar(20) default NULL,
`feedback` mediumtext,
`rate` int(2) default NULL,
`feedbackdate` varchar(14) default NULL,
`auction_id` int(32) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_feedbacks`
#
# ############################
#
# Table structure for table `PHPAUCTION_feedbacksanswers`
#
CREATE TABLE `PHPAUCTION_feedbacksanswers` (
`id` int(11) NOT NULL auto_increment,
`feedbackid` int(11) NOT NULL default '0',
`rated_user_id` int(32) default NULL,
`comment` text,
`feedbackdate` varchar(14) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_feedbacksanswers`
#
# ############################
#
# Table structure for table `PHPAUCTION_feedforum`
#
CREATE TABLE `PHPAUCTION_feedforum` (
`id` int(11) NOT NULL auto_increment,
`feed_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`seqnum` int(11) NOT NULL default '0',
`commentdate` varchar(14) default NULL,
`COMMENT` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_feedforum`
#
# ############################
#
# Table structure for table `PHPAUCTION_fontsandcolors`
#
CREATE TABLE `PHPAUCTION_fontsandcolors` (
`err_font` int(2) NOT NULL default '0',
`err_font_size` int(2) default NULL,
`err_font_color` varchar(7) default NULL,
`err_font_bold` enum('y','n') default NULL,
`err_font_italic` enum('y','n') default NULL,
`std_font` int(2) NOT NULL default '0',
`std_font_size` int(2) default NULL,
`std_font_color` varchar(7) default NULL,
`std_font_bold` enum('y','n') default NULL,
`std_font_italic` enum('y','n') default NULL,
`sml_font` int(2) NOT NULL default '0',
`sml_font_size` int(2) NOT NULL default '0',
`sml_font_color` varchar(7) NOT NULL default '',
`sml_font_bold` enum('y','n') NOT NULL default 'y',
`sml_font_italic` enum('y','n') NOT NULL default 'y',
`tlt_font` int(2) NOT NULL default '0',
`tlt_font_size` int(2) default NULL,
`tlt_font_color` varchar(7) default NULL,
`tlt_font_bold` enum('y','n') default NULL,
`tlt_font_italic` enum('y','n') default NULL,
`nav_font` int(2) NOT NULL default '0',
`nav_font_size` int(2) NOT NULL default '0',
`nav_font_color` varchar(7) NOT NULL default '',
`nav_font_bold` enum('y','n') NOT NULL default 'y',
`nav_font_italic` enum('y','n') NOT NULL default 'y',
`footer_font` int(2) NOT NULL default '0',
`footer_font_size` int(2) NOT NULL default '0',
`footer_font_color` varchar(7) NOT NULL default '',
`footer_font_bold` enum('y','n') NOT NULL default 'y',
`footer_font_italic` enum('y','n') NOT NULL default 'y',
`bordercolor` varchar(7) NOT NULL default '0',
`headercolor` varchar(7) NOT NULL default '0',
`tableheadercolor` varchar(7) NOT NULL default '0000',
`linkscolor` varchar(7) NOT NULL default '0',
`vlinkscolor` varchar(7) NOT NULL default '0',
`highlighteditems` varchar(7) NOT NULL default ''
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_fontsandcolors`
#
INSERT INTO `PHPAUCTION_fontsandcolors` VALUES (1, 2, '#FF9900', 'y', 'n', 1, 2, '#003333', 'n', 'n', 2, 1, '#006633', 'n', 'n', 1, 4, '#003399', 'y', 'n', 1, 2, '#003333', 'n', 'n', 1, 1, '#330033', 'n', 'n', '#738fbf', '#EEEEEE', '#3399FF', '#FF6600', '#CC6600', '#FFFF99');
# ############################
#
# Table structure for table `PHPAUCTION_https`
#
CREATE TABLE `PHPAUCTION_https` (
`https` enum('yes','no') default NULL,
`httpsurl` varchar(255) default NULL
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_https`
#
INSERT INTO `PHPAUCTION_https` VALUES ('no', 'https://yourdomain.com/path/to/phpauction/');
# ############################
#
# Table structure for table `PHPAUCTION_increments`
#
CREATE TABLE `PHPAUCTION_increments` (
`id` char(3) default NULL,
`low` double(16,4) default NULL,
`high` double(16,4) default NULL,
`increment` double(16,4) default NULL
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_increments`
#
INSERT INTO `PHPAUCTION_increments` VALUES ('1', 0.0000, 0.9900, 0.2800);
INSERT INTO `PHPAUCTION_increments` VALUES ('2', 1.0000, 9.9900, 0.5000);
INSERT INTO `PHPAUCTION_increments` VALUES ('3', 10.0000, 29.9900, 1.0000);
INSERT INTO `PHPAUCTION_increments` VALUES ('4', 30.0000, 99.9900, 2.0000);
INSERT INTO `PHPAUCTION_increments` VALUES ('5', 100.0000, 249.9900, 5.0000);
INSERT INTO `PHPAUCTION_increments` VALUES ('6', 250.0000, 499.9900, 10.0000);
INSERT INTO `PHPAUCTION_increments` VALUES ('7', 500.0000, 999.9900, 25.0000);
# ############################
#
# Table structure for table `PHPAUCTION_invitedbuyerslist`
#
CREATE TABLE `PHPAUCTION_invitedbuyerslist` (
`list_id` int(11) NOT NULL auto_increment,
`list_name` varchar(20) default NULL,
`user_id` int(32) NOT NULL default '0',
PRIMARY KEY (`list_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_invitedbuyerslist`
#
# ############################
#
# Table structure for table `PHPAUCTION_invitedbuyersrows`
#
CREATE TABLE `PHPAUCTION_invitedbuyersrows` (
`list_id` int(11) NOT NULL default '0',
`buyer_id` varchar(20) NOT NULL default ''
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_invitedbuyersrows`
#
# ############################
#
# Table structure for table `PHPAUCTION_lastupdate`
#
CREATE TABLE `PHPAUCTION_lastupdate` (
`last_update` datetime default NULL,
`updateinterval` int(11) NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_lastupdate`
#
INSERT INTO `PHPAUCTION_lastupdate` VALUES ('2004-06-11 17:40:10', 100);
# ############################
#
# Table structure for table `PHPAUCTION_membertypes`
#
CREATE TABLE `PHPAUCTION_membertypes` (
`id` int(11) NOT NULL auto_increment,
`feedbacks` int(11) NOT NULL default '0',
`membertype` varchar(30) NOT NULL default '',
`discount` tinyint(4) NOT NULL default '0',
`icon` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=25 ;
#
# Dumping data for table `PHPAUCTION_membertypes`
#
INSERT INTO `PHPAUCTION_membertypes` VALUES (24, 4, '0', 0, 'estrella_0.gif');
INSERT INTO `PHPAUCTION_membertypes` VALUES (14, 9, '5', 0, 'estrella_1.gif');
INSERT INTO `PHPAUCTION_membertypes` VALUES (15, 14, '10', 0, 'estrella_2.gif');
INSERT INTO `PHPAUCTION_membertypes` VALUES (16, 19, '15', 0, 'estrella_3.gif');
INSERT INTO `PHPAUCTION_membertypes` VALUES (17, 29, '20', 0, 'estrella_4.gif');
INSERT INTO `PHPAUCTION_membertypes` VALUES (18, 999999, '30', 0, 'estrella_5.gif');
# ############################
#
# Table structure for table `PHPAUCTION_news`
#
CREATE TABLE `PHPAUCTION_news` (
`id` int(32) NOT NULL auto_increment,
`title` varchar(200) NOT NULL default '',
`content` longtext NOT NULL,
`new_date` int(8) NOT NULL default '0',
`suspended` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_news`
#
# ############################
#
# Table structure for table `PHPAUCTION_online`
#
CREATE TABLE `PHPAUCTION_online` (
`ID` bigint(21) NOT NULL auto_increment,
`SESSION` varchar(255) NOT NULL default '',
`time` bigint(21) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=130 ;
#
# Dumping data for table `PHPAUCTION_online`
#
INSERT INTO `PHPAUCTION_online` VALUES (129, '07b58ee251908b4a2fc1e793a25ad3e0', 1098776703);
# ############################
#
# Table structure for table `PHPAUCTION_package`
#
CREATE TABLE `PHPAUCTION_package` (
`id` int(11) NOT NULL auto_increment,
`scriptname` varchar(60) NOT NULL default '',
`scriptdir` varchar(60) NOT NULL default '',
`scriptdate` varchar(8) NOT NULL default '',
`scriptversion` varchar(10) NOT NULL default '',
`scriptstatus` enum('inuse','updated') NOT NULL default 'inuse',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_package`
#
# ############################
#
# Table structure for table `PHPAUCTION_payments`
#
CREATE TABLE `PHPAUCTION_payments` (
`id` int(2) default NULL,
`description` varchar(30) default NULL
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_payments`
#
INSERT INTO `PHPAUCTION_payments` VALUES (1, 'Paypal');
INSERT INTO `PHPAUCTION_payments` VALUES (2, 'Wire Transfer');
# ############################
#
# Table structure for table `PHPAUCTION_proxybid`
#
CREATE TABLE `PHPAUCTION_proxybid` (
`itemid` int(32) default NULL,
`userid` int(32) default NULL,
`bid` double(16,4) default NULL
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_proxybid`
#
# ############################
#
# Table structure for table `PHPAUCTION_rates`
#
CREATE TABLE `PHPAUCTION_rates` (
`id` int(11) NOT NULL auto_increment,
`ime` tinytext NOT NULL,
`valuta` tinytext NOT NULL,
`rate` float(8,2) NOT NULL default '0.00',
`sifra` tinytext NOT NULL,
`symbol` char(3) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=64 ;
#
# Dumping data for table `PHPAUCTION_rates`
#
INSERT INTO `PHPAUCTION_rates` VALUES (1, 'United States', 'U.S. Dollar', 1.00, 'U.S. Dollar ', 'USD');
INSERT INTO `PHPAUCTION_rates` VALUES (2, 'Argentina', 'Argentinian Peso', 2.97, 'Argentine Peso ', 'ARS');
INSERT INTO `PHPAUCTION_rates` VALUES (3, 'Australia', 'Australian Dollar ', 1.45, 'Australian Dollar ', 'AUD');
INSERT INTO `PHPAUCTION_rates` VALUES (5, 'Brazil', 'Brazilian Real ', 3.15, 'Brazilian Real ', 'BRL');
INSERT INTO `PHPAUCTION_rates` VALUES (6, 'Chile', 'Chilean Peso ', 649.86, 'Chilean Peso ', 'CLP');
INSERT INTO `PHPAUCTION_rates` VALUES (7, 'China', 'Chinese Renminbi ', 8.28, 'Chinese Renminbi ', 'CNY');
INSERT INTO `PHPAUCTION_rates` VALUES (8, 'Colombia', 'Colombian Peso ', 2734.87, 'Colombian Peso ', 'COP');
INSERT INTO `PHPAUCTION_rates` VALUES (10, 'Czech. Republic', 'Czech. Republic Koruna ', 26.17, 'Czech. Republic Koruna ', 'CZK');
INSERT INTO `PHPAUCTION_rates` VALUES (11, 'Denmark', 'Danish Krone ', 6.19, 'Danish Krone ', 'DKK');
INSERT INTO `PHPAUCTION_rates` VALUES (12, 'European Union', 'EURO', 0.83, 'European Monetary Union EURO', 'EUR');
INSERT INTO `PHPAUCTION_rates` VALUES (13, 'Fiji', 'Fiji Dollar ', 1.78, 'Fiji Dollar ', 'FJD');
INSERT INTO `PHPAUCTION_rates` VALUES (16, 'Hong Kong', 'Hong Kong Dollar', 7.80, 'Hong Kong Dollar ', 'HKD');
INSERT INTO `PHPAUCTION_rates` VALUES (18, 'Iceland', 'Icelandic Krona ', 72.47, 'Icelandic Krona ', 'INR');
INSERT INTO `PHPAUCTION_rates` VALUES (19, 'India', 'Indian Rupee', 45.07, 'Indian Rupee ', 'INR');
INSERT INTO `PHPAUCTION_rates` VALUES (20, 'Indonesia', 'Indonesian Rupiah ', 9411.72, 'Indonesian Rupiah ', 'IDR');
INSERT INTO `PHPAUCTION_rates` VALUES (21, 'Israel', 'Israeli New Shekel ', 4.53, 'Israeli New Shekel ', 'ILS');
INSERT INTO `PHPAUCTION_rates` VALUES (22, 'Japan', 'Japanese Yen', 110.08, 'Japanese Yen ', 'JPY');
INSERT INTO `PHPAUCTION_rates` VALUES (23, 'Malaysia', 'Malaysian Ringgit ', 3.80, 'Malaysian Ringgit ', 'MYR');
INSERT INTO `PHPAUCTION_rates` VALUES (24, 'Mexico', 'New Peso', 10.81, 'Mexican New Peso ', 'MXN');
INSERT INTO `PHPAUCTION_rates` VALUES (25, 'Morocco', 'Moroccan Dirham ', 9.11, 'Moroccan Dirham ', 'MAD');
INSERT INTO `PHPAUCTION_rates` VALUES (28, 'New Zealand', 'New Zealand Dollar', 1.59, 'New Zealand Dollar ', 'NZD');
INSERT INTO `PHPAUCTION_rates` VALUES (29, 'Norway', 'Norwege Krone', 6.92, 'Norwegian Krone ', 'NOK');
INSERT INTO `PHPAUCTION_rates` VALUES (30, 'Pakistan', 'Pakistan Rupee ', 57.83, 'Pakistan Rupee ', 'PKR');
INSERT INTO `PHPAUCTION_rates` VALUES (31, 'Panama', 'Panamanian Balboa ', 1.00, 'Panamanian Balboa ', 'PAB');
INSERT INTO `PHPAUCTION_rates` VALUES (32, 'Peru', 'Peruvian New Sol', 3.48, 'Peruvian New Sol ', 'PEN');
INSERT INTO `PHPAUCTION_rates` VALUES (33, 'Philippine', 'Philippine Peso ', 55.79, 'Philippine Peso ', 'PHP');
INSERT INTO `PHPAUCTION_rates` VALUES (34, 'Poland', 'Polish Zloty', 3.82, 'Polish Zloty ', 'PLN');
INSERT INTO `PHPAUCTION_rates` VALUES (35, 'Russian', 'Russian Rouble', 29.02, 'Russian Rouble ', 'RUR');
INSERT INTO `PHPAUCTION_rates` VALUES (36, 'Singapore', 'Singapore Dollar ', 1.72, 'Singapore Dollar ', 'SGD');
INSERT INTO `PHPAUCTION_rates` VALUES (37, 'Slovakia', 'Koruna', 33.16, 'Slovak Koruna ', 'SKK');
INSERT INTO `PHPAUCTION_rates` VALUES (38, 'Slovenia', 'Slovenian Tolar', 198.94, 'Slovenian Tolar ', 'SIT');
INSERT INTO `PHPAUCTION_rates` VALUES (39, 'South Africa', 'South African Rand', 6.51, 'South African Rand ', 'ZAR');
INSERT INTO `PHPAUCTION_rates` VALUES (40, 'South Korea', 'South Korean Won', 1164.42, 'South Korean Won ', 'KRW');
INSERT INTO `PHPAUCTION_rates` VALUES (41, 'Sri Lanka', 'Sri Lanka Rupee ', 99.98, 'Sri Lanka Rupee ', 'LKR');
INSERT INTO `PHPAUCTION_rates` VALUES (42, 'Sweden', 'Swedish Krona', 7.62, 'Swedish Krona ', 'SEK');
INSERT INTO `PHPAUCTION_rates` VALUES (43, 'Switzerland', 'Swiss Franc', 1.26, 'Swiss Franc ', 'CHF');
INSERT INTO `PHPAUCTION_rates` VALUES (44, 'Taiwan', 'Taiwanese New Dollar ', 33.46, 'Taiwanese New Dollar ', 'TWD');
INSERT INTO `PHPAUCTION_rates` VALUES (45, 'Thailand', 'Thailand Thai Baht ', 40.69, 'Thai Baht ', 'THB');
INSERT INTO `PHPAUCTION_rates` VALUES (47, 'Tunisia', 'Tunisisan Dinar', 1.27, 'Tunisian Dinar ', 'TND');
INSERT INTO `PHPAUCTION_rates` VALUES (48, 'Turkey', 'Turkish Lira', 150.05, 'Turkish Lira (2) ', 'TRL');
INSERT INTO `PHPAUCTION_rates` VALUES (49, 'Great Britain', 'Pound Sterling ', 0.57, 'Pound Sterling ', 'GBP');
INSERT INTO `PHPAUCTION_rates` VALUES (50, 'Venezuela', 'Bolivar ', 1916.71, 'Venezuelan Bolivar ', 'VEB');
INSERT INTO `PHPAUCTION_rates` VALUES (51, 'Bahamas', 'Bahamian Dollar', 1.00, 'Bahamian Dollar', 'BSD');
INSERT INTO `PHPAUCTION_rates` VALUES (52, 'Croatia', 'Croatian Kuna', 6.16, 'Croatian Kuna', 'HRK');
INSERT INTO `PHPAUCTION_rates` VALUES (53, 'East Caribe', 'East Caribbean Dollar', 0.00, 'East Caribbean Dollar', 'XCD');
INSERT INTO `PHPAUCTION_rates` VALUES (54, 'CFA Franc (African Financial Community)', 'African Financial Community Franc', 0.00, 'African Financial Community Franc', 'CFA');
INSERT INTO `PHPAUCTION_rates` VALUES (55, 'Pacific Financial Community', 'Pacific Financial Community Franc', 0.00, 'Pacific Financial Community', 'CFP');
INSERT INTO `PHPAUCTION_rates` VALUES (56, 'Ghana', 'Ghanaian Cedi', 8978.29, 'Ghanaian Cedi', 'GHC');
INSERT INTO `PHPAUCTION_rates` VALUES (57, 'Honduras', 'Honduras Lempira', 0.00, 'Honduras Lempira', 'HNL');
INSERT INTO `PHPAUCTION_rates` VALUES (58, 'Hungaria', 'Hungarian Forint', 210.83, 'Hungarian Forint', 'HUF');
INSERT INTO `PHPAUCTION_rates` VALUES (59, 'Jamaica', 'Jamaican Dollar', 60.52, 'Jamaican Dollar', 'JMD');
INSERT INTO `PHPAUCTION_rates` VALUES (60, 'Burma', 'Myanmar (Burma) Kyat', 5.82, 'Myanmar (Burma) Kyat', 'MMK');
INSERT INTO `PHPAUCTION_rates` VALUES (61, 'Neth. Antilles', 'Neth. Antilles Guilder', 1.78, 'Neth. Antilles Guilder', 'ANG');
INSERT INTO `PHPAUCTION_rates` VALUES (62, 'Trinidad & Tobago', 'Trinidad & Tobago Dollar', 6.15, 'Trinidad & Tobago Dollar', 'TTD');
INSERT INTO `PHPAUCTION_rates` VALUES (63, 'Canadian', 'Canadian Dollar', 1.31, 'Canadian Dollar', 'CAD');
# ############################
#
# Table structure for table `PHPAUCTION_request`
#
CREATE TABLE `PHPAUCTION_request` (
`id` int(11) NOT NULL auto_increment,
`req_auction` int(32) default NULL,
`req_user` int(32) default NULL,
`req_text` text,
`req_date` varchar(14) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_request`
#
# ############################
#
# Table structure for table `PHPAUCTION_settings`
#
CREATE TABLE `PHPAUCTION_settings` (
`sitename` varchar(255) NOT NULL default '',
`siteurl` varchar(255) NOT NULL default '',
`cookiesprefix` varchar(100) NOT NULL default '',
`loginbox` int(1) NOT NULL default '0',
`newsbox` int(1) NOT NULL default '0',
`newstoshow` int(11) NOT NULL default '0',
`moneyformat` int(1) NOT NULL default '0',
`moneydecimals` int(11) NOT NULL default '0',
`moneysymbol` int(1) NOT NULL default '0',
`currency` varchar(10) NOT NULL default '',
`showacceptancetext` int(1) NOT NULL default '0',
`acceptancetext` longtext NOT NULL,
`adminmail` varchar(100) NOT NULL default '',
`banners` int(1) NOT NULL default '0',
`newsletter` int(1) NOT NULL default '0',
`logo` varchar(255) NOT NULL default '',
`timecorrection` int(11) NOT NULL default '0',
`cron` int(1) NOT NULL default '0',
`archiveafter` int(11) NOT NULL default '0',
`datesformat` enum('USA','EUR') NOT NULL default 'USA',
`errortext` text NOT NULL,
`errormail` varchar(255) NOT NULL default '',
`maxpictures` int(11) NOT NULL default '0',
`maxpicturesize` int(11) NOT NULL default '0',
`buy_now` int(1) NOT NULL default '1',
`alignment` varchar(15) NOT NULL default '',
`thumb_show` smallint(6) NOT NULL default '100',
`lastitemsnumber` int(11) NOT NULL default '0',
`higherbidsnumber` int(11) NOT NULL default '0',
`endingsoonnumber` int(11) NOT NULL default '0',
`boards` enum('y','n') NOT NULL default 'y',
`boardslink` enum('y','n') NOT NULL default 'y',
`wordsfilter` enum('y','n') NOT NULL default 'n',
`aboutus` enum('y','n') NOT NULL default 'y',
`aboutustext` text NOT NULL,
`terms` enum('y','n') NOT NULL default 'y',
`termstext` text NOT NULL,
`defaultcountry` varchar(30) NOT NULL default '0',
`defaultlanguage` char(2) NOT NULL default '',
`aboutme` enum('y','n') default 'n',
`pagewidth` int(11) NOT NULL default '80',
`pagewidthtype` enum('perc','fix') NOT NULL default 'perc',
`taxname` varchar(10) NOT NULL default 'TVA',
`catsorting` enum('alpha','counter') NOT NULL default 'alpha',
`usersauth` enum('y','n') NOT NULL default 'y',
`background` tinytext NOT NULL,
`brepeat` enum('repeat','repeat-x','repeat-y','no-repeat','no') NOT NULL default 'no',
`descriptiontag` text NOT NULL,
`keywordstag` text NOT NULL,
`maxuploadsize` int(11) NOT NULL default '0',
`contactseller` enum('always','logged','never') NOT NULL default 'always'
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_settings`
#
INSERT INTO `PHPAUCTION_settings` VALUES ('My Site Name', 'http://www.mydomain.com/auction/', 'PHPAUCTIONPREFIX', 1, 1, 5, 1, 2, 2, 'USD', 1, 'Qualifications for Registration
We are very serious in presenting you a pleasant and safe venue for buying and selling items online. We have not and will not accept in this auction any sort of fraud, scamming, or illegal activity of any sort. Persons engaging in such will be terminated from this auction and may be subject to criminal prosecution. Below are the legalities we are required to state and which you agree to abide by when registering to bid or sell in this auction:
Article 1. Eligibility of membership - This auction site is only available to people who are legally able to form binding contracts as the seller/buyer of an auction item. People who are of under the age of 18 are not eligible for membership. If you do not meet these requirements, you are not eligible to use these auction services.
Article 2. This site is only providing auction services - We only provide services to people interested in selling and buying merchandise via internet auction. We do not have control over the items that are posted in the auction site, and cannot guarantee the authenticity and quality of said product. We are not responsible for the actions the sellers/buyers take before, during, and after the auction, typographical errors, misprints, loss of merchandise/money, damage or failure of equipment, due to your visit to this auction site. Use of this site is at your own risk, and content is presented \'As-Is\'.
Article 3. Bidding and Selling - As a user, you may bid and/or sell merchandise over this auction. As a bidder, you know that placing a bid is a binding contract between you and the seller, and the bid cannot be retracted unless due to fault by the seller of typographical error, or other error, due to human error on the seller\'s part. Once you place a bid, and if you win, you will be obligated to buy the product at the said price you indicated as your bid. Placing a bid on this auction site, and winning, then not paying for the product is illegal in most states, and prosecution can result to you. As a seller, the item that you place up for bids must be real. Pre-sales are excepted as long as the item is so noted prominently. Once a bid has been placed for your item, you are being placed in a binding contract with the potential buyer of the product, if that bid shall be the highest bid. Once the auction is over, if over reserve price, you are obligated to sell to the potential buyer which is the highest bidder in your auction. If, reserve price was not met, you are not obligated in any way to sell this item at all. As a seller, you are not in any way to bid on your own items. If reported, your auction will be deleted.
Article 4. Posting Items - As a user, you are welcome to post items up for sale on this auction. We do have restrictions on what items you may sell, and what you may not sell. You may not sell illegal merchandise, including pirated software and music, firearms, adult videos, or anything that is affiliated with pornography, etc. Items that are posted for bids are subject to review by the staff , and my be removed without prior notice, if in violation of the User Agreement. For more information please see our list of Prohibited items.
Article 5. Charges - Posting an item up for bid, bidding on an item, and registering are free on this server. Do not abuse this privilege.
Article 6. Privacy - We gather your information so that other people will have it on hand when they win your auction, or you win their auction. Personal information is not sold, rented, or used in any other way without your permission. Personal information sent to a user regarding a product bought or sold on the auction is not to be used for any other purpose, except for communication with the auction item.
Article 7. Warranty - This site provides this website in an \'as-is\' condition, without a warranty or condition. This site is not liable for any damages resulting in an auction, or your visit to the site.
Suspension or Termination
Here are some things that will get you suspended, terminated, and/or prosecuted:
· Giving us false information when registering, such as a false name or fraudulent contact information.
· We are against Spam and we respect the privacy of our users. We do not use \"cookies\" or any other method to gather information about other than legitimate registration. We use your e-mail address for contacting buyers or sellers only. Any use of this private information by anyone else is strictly prohibited and we WILL take action.
· Don\'t bid unless you intend to buy. Don\'t offer an item unless you intend to follow though with the winning bidder. For a buyer or seller not to honor an auction bid is illegal in many states.
· Don\'t list items in inappropriate categories just to get additional exposure or for any other reason. Violators of this policy are subject to suspension or termination. If you have something that does not fit any of our categories, please e-mail the administrator at email at bottom of page and request that category be added to the auction.
· No sellers can bid on their own products to artificially raise the selling price. However, if you made a legitimate mistake and started the item too low (and no one has bid on it yet) you may edit the information by viewing your item, and clicking on \"Edit Item\". If you need assistance email the administrator.
· Any one attempting to compromise the safety, security, data integrity, service, or any other fact of this auction site will be suspended or terminated and WILL face possible legal action. We\'ve worked hard to present this auction opportunity for you and will not allow one or two to ruin it for the many.
· Any one attempting to post illegal merchandise, including pirated software and music, firearms, adult videos, any item in any way infringing on a legitimate copyright, or anything that is affiliated with pornography, etc. Links within your auctions to sites violating the above are included. Items that are posted for bids are subject to review by the staff, and may be removed without prior notice, if in violation of the User Agreement. Then the person posting them is in trouble with us! For more information please see our list of which follow the Conditions of Service.
Conditions of Service
This auction acts only in providing a place for buyers and sellers to buy and sell approved items. We have no control over quality, usability, legality, et al of the items put up here for auction. In other words, we provide this website in an \'as-is\' condition, without a warranty or condition. This auction site is not liable for any damages resulting in an auction, or your visit to the site. This auction site is not responsible nor liable for any damages caused or alleged to be caused directly, indirectly, incidentally, or consequentially by anything on or related to this auction site.
We cannot and will not get involved in disputes between users. In the case that you have such a dispute, by registering on this site, you are releasing this auction site and its agents, employees, and assignees, and any affiliated companies or individuals from any claims, suspected and unsuspected, whether disclosed or undisclosed, arising out of, or in any way connected to, any disputes. We suggest and expect that users will employ common good business practices and personal courtesy to avoid disputes. If another user has a complaint with you, please establish a polite dialog with him or her to resolve the dispute to mutual satisfaction. Above all, when buying something from someone--whether on the internet or anywhere else--your best protection to be an informed buyer. In Latin: Caveat Emptor! The age-old warning of Buyer Beware!
We cannot, and will not, be held responsible for any interruption in service, caused by any means, therefore we cannot guarantee continual, uninterrupted service as our website could be interfered with by means out of our control.
The use of a trademark or service mark in your auctions should be capitalized and indication as such. Since we have no control over posting, the use of any trademark or service mark in this auction, proper or improper, cannot and should not be construed as affecting the validity of that trademark or service mark.
We reserve the right to remove anyone from this auction at any time for any reason we deem sufficient and without explanation required.
We will tolerate no violations of law or regulations by any actions, especially those that are libelous, threatening, harassing, or obscene.
Prohibited Items
This auction site places certain restrictions on the types of items and services offered for sale and the types of listings posted to the site. Please review the following list of items, services and listing types that may not be listed and, upon discovery, will be removed at our sole discretion.
Items and Services
Items and services that infringe on another party\'s copyright, patent, license, trademark or other proprietary right, including rights of publicity and privacy or where the offering of such items and services is prohibited by law.
Any item that is illegal to sell under any applicable law, statute, ordinance or regulation.
Items to which a false or illegal description is applied.
Stolen or illegally imported goods.
Adult Items that depict, simulate, display, offer or describe in textual or visual depiction all manner of sexual acts, genitalia, pornography, erotica, child pornography, sexual toys and related accessories, links to Adult Only websites, Adult Only domain names for sale, or any item that would fall under the category of Adult Only.
All Firearms, Military weapons, Explosives and ammunition
All Fireworks, pyrotechnics, and explosives.
Alcoholic beverages for consumption.
Drugs, drug paraphernalia, narcotics, prescription medication.
Human body parts, remains, fluids.
Live or stuffed animals, pets, livestock or animal body parts, skins, pelts.
Clothing advertised as used, dirty, soiled, or unwashed.
Any device or component used to illegally acquire the use of a utility or service, i.e., TV Descramblers.
Bulk e-mail lists.
Lottery tickets, raffle tickets or raffle auctions.
Multi-level marketing schemes(MLM) or Pyramid schemes.
Stock, bonds, or securities of live or existing companies.
Books, Manuals, Software, or literature promoting violence or containing hate literature.
Books, Manuals, Software, or literature that provide instructions on how to perform or engage in any form of illegal activity.
Items and Services which, in our sole discretion, are objectionable or otherwise inconsistent with our terms of use.
Listing Types
Listings that are wholly or mainly intended to divert buyers away from the listings themselves.
Listings with links to another website where you are offering the same item for sale at a value lower than your stated opening price.
Listings that sell low-valued items advertising other site\'s sales.
Listings that require bidders to purchase additional items or services.
Listings that require bidders to participate in raffles or lotteries.
Listings that charge excessive shipping and handling fees to winning bidders.
Listing Types which, in our sole discretion, are objectionable or otherwise inconsistent with our terms of use.
Your use of this auction marks your acceptance
in full of these Terms and Conditions.', 'admin@yourdomain.com', 1, 1, 'logo.gif', 0, 2, 360, 'USA', 'Place your text here', 'admin@yourdomain.com', 5, 50, 2, 'center', 100, 5, 5, 5, 'y', 'y', 'n', 'y', 'Your About us text goes here', 'y', 'Your Terms and Conditions go here', 'United States', 'EN', 'y', 85, 'perc', 'Taxes', 'alpha', 'n', 'purplebackground.jpg', 'repeat', '', '', 51200, 'always');
# ############################
#
# Table structure for table `PHPAUCTION_updates`
#
CREATE TABLE `PHPAUCTION_updates` (
`id` int(11) NOT NULL default '0',
`updatedate` varchar(8) NOT NULL default '',
`status` enum('ok','notok') NOT NULL default 'ok',
KEY `id` (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_updates`
#
# ############################
#
# Table structure for table `PHPAUCTION_users`
#
CREATE TABLE `PHPAUCTION_users` (
`id` int(32) NOT NULL auto_increment,
`nick` varchar(20) default NULL,
`password` varchar(32) default NULL,
`name` tinytext,
`address` tinytext,
`city` varchar(25) default NULL,
`prov` varchar(10) default NULL,
`country` varchar(30) default NULL,
`zip` varchar(6) default NULL,
`phone` varchar(40) default NULL,
`email` varchar(50) default NULL,
`reg_date` varchar(8) default NULL,
`rate_sum` int(11) default NULL,
`rate_num` int(11) default NULL,
`birthdate` int(8) default NULL,
`suspended` int(1) default '0',
`nletter` int(1) NOT NULL default '0',
`auc_watch` varchar(20) default '',
`item_watch` text,
`endemailmode` enum('one','cum','none') NOT NULL default 'one',
`startemailmode` enum('yes','no') NOT NULL default 'yes',
`trusted` enum('y','n') NOT NULL default 'n',
`lastlogin` varchar(14) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_users`
#
# ############################
#
# Table structure for table `PHPAUCTION_usersips`
#
CREATE TABLE `PHPAUCTION_usersips` (
`id` int(11) NOT NULL auto_increment,
`user` int(32) default NULL,
`ip` varchar(15) default NULL,
`type` enum('first','after') NOT NULL default 'first',
`action` enum('accept','deny') NOT NULL default 'accept',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_usersips`
#
# ############################
#
# Table structure for table `PHPAUCTION_userslanguage`
#
CREATE TABLE `PHPAUCTION_userslanguage` (
`user` int(32) NOT NULL default '0',
`language` char(2) NOT NULL default ''
) TYPE=MyISAM;
#
# Dumping data for table `PHPAUCTION_userslanguage`
#
# ############################
#
# Table structure for table `PHPAUCTION_winners`
#
CREATE TABLE `PHPAUCTION_winners` (
`id` int(11) NOT NULL auto_increment,
`auction` int(32) NOT NULL default '0',
`seller` varchar(32) NOT NULL default '',
`winner` varchar(32) NOT NULL default '',
`bid` double NOT NULL default '0',
`closingdate` varchar(14) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#
# Dumping data for table `PHPAUCTION_winners`
#