hello everyone Richard here
i have a script that im having some issues with and was hoping to find someone here who can help me figure out the problem ok the script in php i get a notice when tryng to create an admin passowrd
"User not verified" im using tukanas freelance script
i can send the code if anybody interested
thanks
Hmmm.... I don't know if I can help with this particular issue (kinda rusty). But you don't have to "send" it. Just post it here.
heres the database thanks in advance
-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 06, 2007 at 07:50 AM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
--
-- --------------------------------------------------------
--
-- Table structure for table `dbmastermain`
--
CREATE TABLE `dbmastermain` (
`id` int(6) NOT NULL auto_increment,
`mastername` varchar(255) NOT NULL default '',
`tablename` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;
--
-- Dumping data for table `dbmastermain`
--
INSERT INTO `dbmastermain` VALUES (25, 'Gender', 'mast_gender');
INSERT INTO `dbmastermain` VALUES (24, 'Countries', 'mast_countryname');
INSERT INTO `dbmastermain` VALUES (21, 'Status', 'mast_status');
INSERT INTO `dbmastermain` VALUES (32, 'Nationality', 'mast_nationality');
INSERT INTO `dbmastermain` VALUES (34, 'Yes NO', 'mast_yesno');
INSERT INTO `dbmastermain` VALUES (67, 'Escrow Fee', 'mast_escrowfee');
INSERT INTO `dbmastermain` VALUES (66, 'Cancel Reason', 'mast_cancelreason');
INSERT INTO `dbmastermain` VALUES (65, 'Rating', 'mast_rating');
INSERT INTO `dbmastermain` VALUES (64, 'Reason', 'mast_reason');
INSERT INTO `dbmastermain` VALUES (63, 'Payment Type', 'mast_paymenttype');
INSERT INTO `dbmastermain` VALUES (62, 'provider Status', 'mast_pickproviderstatus');
INSERT INTO `dbmastermain` VALUES (61, 'Hide Option', 'mast_hideoption');
INSERT INTO `dbmastermain` VALUES (60, 'Database Type', 'mast_databasetype');
INSERT INTO `dbmastermain` VALUES (59, 'Budget Range', 'mast_budgetrange');
INSERT INTO `dbmastermain` VALUES (58, 'Email Notofication Type', 'mast_emailnotification');
INSERT INTO `dbmastermain` VALUES (57, 'Project Category Type', 'mast_pcategorytype');
INSERT INTO `dbmastermain` VALUES (68, 'Operating System', 'mast_opsystype');
-- --------------------------------------------------------
--
-- Table structure for table `mast_budgetrange`
--
CREATE TABLE `mast_budgetrange` (
`id` int(6) NOT NULL auto_increment,
`budgetrange` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `mast_budgetrange`
--
INSERT INTO `mast_budgetrange` VALUES (1, '200-300');
INSERT INTO `mast_budgetrange` VALUES (2, '400-500');
INSERT INTO `mast_budgetrange` VALUES (3, '$ 20-100');
-- --------------------------------------------------------
--
-- Table structure for table `mast_cancelreason`
--
CREATE TABLE `mast_cancelreason` (
`id` int(6) NOT NULL auto_increment,
`cancelreason` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `mast_cancelreason`
--
INSERT INTO `mast_cancelreason` VALUES (1, 'Mutual aggrement by both parties to cancel project.');
-- --------------------------------------------------------
--
-- Table structure for table `mast_countryname`
--
CREATE TABLE `mast_countryname` (
`id` int(11) NOT NULL auto_increment,
`countryname` text NOT NULL,
`isdcode` int(11) NOT NULL default '0',
`cr_rate` float NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=247 ;
--
-- Dumping data for table `mast_countryname`
--
INSERT INTO `mast_countryname` VALUES (39, 'Canada', 1, 1.5);
INSERT INTO `mast_countryname` VALUES (230, 'United States of America', 1, 1.5);
INSERT INTO `mast_countryname` VALUES (234, 'US Virgin Islands', 1, 1);
INSERT INTO `mast_countryname` VALUES (113, 'Kazakhstan', 7, 1.5);
INSERT INTO `mast_countryname` VALUES (183, 'Russia', 7, 1.5);
INSERT INTO `mast_countryname` VALUES (221, 'Tajikistan', 7, 1.5);
INSERT INTO `mast_countryname` VALUES (67, 'Egypt', 20, 1);
INSERT INTO `mast_countryname` VALUES (195, 'South Africa', 27, 1);
INSERT INTO `mast_countryname` VALUES (85, 'Greece', 30, 2.5);
INSERT INTO `mast_countryname` VALUES (161, 'Netherlands', 31, 2.5);
INSERT INTO `mast_countryname` VALUES (19, 'Belgium', 32, 1.5);
INSERT INTO `mast_countryname` VALUES (76, 'France', 33, 2.5);
INSERT INTO `mast_countryname` VALUES (196, 'Spain', 34, 2);
INSERT INTO `mast_countryname` VALUES (101, 'Hungary', 36, 2.5);
INSERT INTO `mast_countryname` VALUES (110, 'Italy', 39, 2);
INSERT INTO `mast_countryname` VALUES (182, 'Romania', 40, 1);
INSERT INTO `mast_countryname` VALUES (123, 'Liechtenstein', 41, 1.5);
INSERT INTO `mast_countryname` VALUES (199, 'Switzerland', 41, 1.5);
INSERT INTO `mast_countryname` VALUES (8, 'Austria', 43, 1);
INSERT INTO `mast_countryname` VALUES (233, 'United Kingdom', 44, 2);
INSERT INTO `mast_countryname` VALUES (61, 'Denmark', 45, 1);
INSERT INTO `mast_countryname` VALUES (212, 'Sweden', 46, 3);
INSERT INTO `mast_countryname` VALUES (159, 'Norway', 47, 1);
INSERT INTO `mast_countryname` VALUES (176, 'Poland', 48, 1);
INSERT INTO `mast_countryname` VALUES (91, 'Germany', 49, 2);
INSERT INTO `mast_countryname` VALUES (175, 'Peru', 51, 1.5);
INSERT INTO `mast_countryname` VALUES (147, 'Mexico', 52, 1);
INSERT INTO `mast_countryname` VALUES (59, 'Cuba', 53, 1);
INSERT INTO `mast_countryname` VALUES (12, 'Argentina', 54, 2.5);
INSERT INTO `mast_countryname` VALUES (23, 'Brazil', 55, 1.5);
INSERT INTO `mast_countryname` VALUES (42, 'Chile', 56, 1);
INSERT INTO `mast_countryname` VALUES (66, 'Easter Island', 56, 1);
INSERT INTO `mast_countryname` VALUES (44, 'Colombia', 57, 1.5);
INSERT INTO `mast_countryname` VALUES (237, 'Venezuela', 58, 1.5);
INSERT INTO `mast_countryname` VALUES (131, 'Malaysia', 60, 1);
INSERT INTO `mast_countryname` VALUES (14, 'Australia', 61, 3);
INSERT INTO `mast_countryname` VALUES (43, 'Christmas Island', 61, 1);
INSERT INTO `mast_countryname` VALUES (55, 'Cocos-Keeling Islands', 61, 1);
INSERT INTO `mast_countryname` VALUES (103, 'Indonesia', 62, 1);
INSERT INTO `mast_countryname` VALUES (171, 'Philippines', 63, 1);
INSERT INTO `mast_countryname` VALUES (53, 'Chatham Island (NewZealand)', 64, 3);
INSERT INTO `mast_countryname` VALUES (163, 'New Zealand', 64, 1);
INSERT INTO `mast_countryname` VALUES (206, 'Singapore', 65, 1);
INSERT INTO `mast_countryname` VALUES (222, 'Thailand', 66, 1);
INSERT INTO `mast_countryname` VALUES (115, 'Korea (South)', 82, 1);
INSERT INTO `mast_countryname` VALUES (209, 'South Korea', 82, 1.5);
INSERT INTO `mast_countryname` VALUES (239, 'Vietnam', 84, 1.5);
INSERT INTO `mast_countryname` VALUES (54, 'China (PRC)', 86, 1);
INSERT INTO `mast_countryname` VALUES (219, 'Turkey', 90, 2);
INSERT INTO `mast_countryname` VALUES (107, 'India', 91, 1);
INSERT INTO `mast_countryname` VALUES (168, 'Pakistan', 92, 1.5);
INSERT INTO `mast_countryname` VALUES (1, 'Afghanistan', 93, 1.5);
INSERT INTO `mast_countryname` VALUES (210, 'Sri Lanka', 94, 1);
INSERT INTO `mast_countryname` VALUES (36, 'Burma (Myanmar)', 95, 1);
INSERT INTO `mast_countryname` VALUES (140, 'Myanmar', 95, 1);
INSERT INTO `mast_countryname` VALUES (108, 'Iran', 98, 3);
INSERT INTO `mast_countryname` VALUES (139, 'Morocco', 212, 1);
INSERT INTO `mast_countryname` VALUES (2, 'Algeria', 213, 1.5);
INSERT INTO `mast_countryname` VALUES (225, 'Tunisia', 216, 2);
INSERT INTO `mast_countryname` VALUES (127, 'Libya', 218, 3);
INSERT INTO `mast_countryname` VALUES (90, 'Gambia', 220, 1);
INSERT INTO `mast_countryname` VALUES (204, 'Senegal', 221, 1.5);
INSERT INTO `mast_countryname` VALUES (134, 'Mauritania', 222, 1);
INSERT INTO `mast_countryname` VALUES (132, 'Mali Republic', 223, 1);
INSERT INTO `mast_countryname` VALUES (89, 'Guinea (PRP)', 224, 1);
INSERT INTO `mast_countryname` VALUES (106, 'Ivory Coast(C?ted''Ivoire)', 225, 1);
INSERT INTO `mast_countryname` VALUES (25, 'Burkina Faso', 226, 2);
INSERT INTO `mast_countryname` VALUES (164, 'Niger', 227, 1);
INSERT INTO `mast_countryname` VALUES (223, 'Togo', 228, 1);
INSERT INTO `mast_countryname` VALUES (20, 'Benin', 229, 2);
INSERT INTO `mast_countryname` VALUES (146, 'Mauritius', 230, 1);
INSERT INTO `mast_countryname` VALUES (122, 'Liberia', 231, 1);
INSERT INTO `mast_countryname` VALUES (192, 'Sierra Leone', 232, 2);
INSERT INTO `mast_countryname` VALUES (84, 'Ghana', 233, 1);
INSERT INTO `mast_countryname` VALUES (157, 'Nigeria', 234, 2);
INSERT INTO `mast_countryname` VALUES (41, 'Chad', 235, 1);
INSERT INTO `mast_countryname` VALUES (52, 'Central African Republic', 236, 1);
INSERT INTO `mast_countryname` VALUES (50, 'Cameroon', 237, 1);
INSERT INTO `mast_countryname` VALUES (51, 'Cape Verde Islands', 238, 1);
INSERT INTO `mast_countryname` VALUES (203, 'S?o Tom?and Principe', 239, 1);
INSERT INTO `mast_countryname` VALUES (68, 'Equatorial Guinea', 240, 1);
INSERT INTO `mast_countryname` VALUES (82, 'Gabon', 241, 2);
INSERT INTO `mast_countryname` VALUES (16, 'Bahamas', 242, 1);
INSERT INTO `mast_countryname` VALUES (37, 'Bahamas', 242, 1);
INSERT INTO `mast_countryname` VALUES (45, 'Congo', 242, 1);
INSERT INTO `mast_countryname` VALUES (10, 'Angola', 244, 1);
INSERT INTO `mast_countryname` VALUES (96, 'Guinea-Bissau', 245, 1);
INSERT INTO `mast_countryname` VALUES (28, 'Barbados', 246, 1);
INSERT INTO `mast_countryname` VALUES (64, 'Diego Garcia', 246, 1);
INSERT INTO `mast_countryname` VALUES (7, 'Ascension Island', 247, 1);
INSERT INTO `mast_countryname` VALUES (205, 'Seychelles Islands', 248, 1);
INSERT INTO `mast_countryname` VALUES (197, 'Sudan', 249, 1);
INSERT INTO `mast_countryname` VALUES (181, 'Rwanda', 250, 1);
INSERT INTO `mast_countryname` VALUES (73, 'Ethiopia', 251, 1);
INSERT INTO `mast_countryname` VALUES (208, 'Somalia', 252, 1);
INSERT INTO `mast_countryname` VALUES (62, 'Djibouti', 253, 1);
INSERT INTO `mast_countryname` VALUES (117, 'Kenya', 254, 1);
INSERT INTO `mast_countryname` VALUES (215, 'Tanzania', 255, 1);
INSERT INTO `mast_countryname` VALUES (228, 'Uganda', 256, 1);
INSERT INTO `mast_countryname` VALUES (26, 'Burundi', 257, 2);
INSERT INTO `mast_countryname` VALUES (151, 'Mozambique', 258, 1);
INSERT INTO `mast_countryname` VALUES (245, 'Zambia', 260, 1);
INSERT INTO `mast_countryname` VALUES (130, 'Madagascar', 261, 1);
INSERT INTO `mast_countryname` VALUES (179, 'R?union Island', 262, 3);
INSERT INTO `mast_countryname` VALUES (246, 'Zimbabwe', 263, 1.5);
INSERT INTO `mast_countryname` VALUES (4, 'Anguilla', 264, 1);
INSERT INTO `mast_countryname` VALUES (152, 'Namibia', 264, 1);
INSERT INTO `mast_countryname` VALUES (142, 'Malawi', 265, 1);
INSERT INTO `mast_countryname` VALUES (126, 'Lesotho', 266, 2);
INSERT INTO `mast_countryname` VALUES (33, 'Botswana', 267, 1);
INSERT INTO `mast_countryname` VALUES (5, 'Antigua', 268, 1);
INSERT INTO `mast_countryname` VALUES (18, 'Barbuda', 268, 1);
INSERT INTO `mast_countryname` VALUES (198, 'Swaziland', 268, 1);
INSERT INTO `mast_countryname` VALUES (56, 'Comoros', 269, 1);
INSERT INTO `mast_countryname` VALUES (135, 'Mayotte Island', 269, 1);
INSERT INTO `mast_countryname` VALUES (34, 'British Virgin Islands', 284, 1);
INSERT INTO `mast_countryname` VALUES (72, 'Eritrea', 291, 1);
INSERT INTO `mast_countryname` VALUES (13, 'Aruba', 297, 1.5);
INSERT INTO `mast_countryname` VALUES (74, 'Faeroe Islands', 298, 1);
INSERT INTO `mast_countryname` VALUES (93, 'Greenland', 299, 1);
INSERT INTO `mast_countryname` VALUES (40, 'Cayman Islands', 345, 1);
INSERT INTO `mast_countryname` VALUES (92, 'Gibraltar', 350, 1);
INSERT INTO `mast_countryname` VALUES (172, 'Portugal', 351, 1.5);
INSERT INTO `mast_countryname` VALUES (124, 'Luxembourg', 352, 1);
INSERT INTO `mast_countryname` VALUES (109, 'Ireland', 353, 1);
INSERT INTO `mast_countryname` VALUES (102, 'Iceland', 354, 1);
INSERT INTO `mast_countryname` VALUES (144, 'Malta', 356, 1);
INSERT INTO `mast_countryname` VALUES (60, 'Cyprus', 357, 1);
INSERT INTO `mast_countryname` VALUES (79, 'Finland', 358, 2);
INSERT INTO `mast_countryname` VALUES (35, 'Bulgaria', 359, 1);
INSERT INTO `mast_countryname` VALUES (128, 'Lithuania', 370, 1);
INSERT INTO `mast_countryname` VALUES (125, 'Latvia', 371, 1);
INSERT INTO `mast_countryname` VALUES (69, 'Estonia', 372, 1);
INSERT INTO `mast_countryname` VALUES (137, 'Moldova', 373, 1);
INSERT INTO `mast_countryname` VALUES (6, 'Armenia', 374, 1);
INSERT INTO `mast_countryname` VALUES (29, 'Belarus', 375, 1);
INSERT INTO `mast_countryname` VALUES (3, 'Andorra', 376, 1);
INSERT INTO `mast_countryname` VALUES (238, 'Vatican City', 376, 1);
INSERT INTO `mast_countryname` VALUES (149, 'Monaco', 377, 1);
INSERT INTO `mast_countryname` VALUES (189, 'San Marino', 378, 1);
INSERT INTO `mast_countryname` VALUES (232, 'Ukraine', 380, 1.5);
INSERT INTO `mast_countryname` VALUES (191, 'Serbia', 381, 1.5);
INSERT INTO `mast_countryname` VALUES (244, 'Yugoslavia', 381, 1);
INSERT INTO `mast_countryname` VALUES (47, 'Croatia', 385, 1);
INSERT INTO `mast_countryname` VALUES (207, 'Slovenia', 386, 1);
INSERT INTO `mast_countryname` VALUES (22, 'Bosnia & Herzogovina', 387, 1);
INSERT INTO `mast_countryname` VALUES (141, 'Macedonia (former Yugoslav Rep.)', 389, 1.5);
INSERT INTO `mast_countryname` VALUES (49, 'Czech Republic', 420, 1);
INSERT INTO `mast_countryname` VALUES (193, 'Slovak Republic', 421, 1);
INSERT INTO `mast_countryname` VALUES (31, 'Bermuda', 441, 1);
INSERT INTO `mast_countryname` VALUES (86, 'Grenada', 473, 1);
INSERT INTO `mast_countryname` VALUES (78, 'Falkland Islands', 500, 1);
INSERT INTO `mast_countryname` VALUES (30, 'Belize', 501, 1.5);
INSERT INTO `mast_countryname` VALUES (88, 'Guatemala', 502, 1);
INSERT INTO `mast_countryname` VALUES (71, 'El Salvador', 503, 1.5);
INSERT INTO `mast_countryname` VALUES (100, 'Honduras', 504, 1);
INSERT INTO `mast_countryname` VALUES (156, 'Nicaragua', 505, 1);
INSERT INTO `mast_countryname` VALUES (58, 'Costa Rica', 506, 1);
INSERT INTO `mast_countryname` VALUES (169, 'Panama', 507, 1);
INSERT INTO `mast_countryname` VALUES (201, 'St.Pierre & Miquelon', 508, 1);
INSERT INTO `mast_countryname` VALUES (98, 'Haiti', 509, 1);
INSERT INTO `mast_countryname` VALUES (94, 'Guadeloupe', 590, 1);
INSERT INTO `mast_countryname` VALUES (32, 'Bolivia', 591, 1);
INSERT INTO `mast_countryname` VALUES (97, 'Guyana', 592, 2.5);
INSERT INTO `mast_countryname` VALUES (70, 'Ecuador', 593, 1);
INSERT INTO `mast_countryname` VALUES (77, 'French Guiana', 594, 1);
INSERT INTO `mast_countryname` VALUES (170, 'Paraguay', 595, 1);
INSERT INTO `mast_countryname` VALUES (80, 'French Antilles', 596, 1);
INSERT INTO `mast_countryname` VALUES (145, 'Martinique', 596, 1);
INSERT INTO `mast_countryname` VALUES (211, 'Suriname', 597, 1);
INSERT INTO `mast_countryname` VALUES (231, 'Uruguay', 598, 1);
INSERT INTO `mast_countryname` VALUES (154, 'Netherlands Antilles', 599, 1);
INSERT INTO `mast_countryname` VALUES (220, 'Turksand Caicos Islands', 649, 1);
INSERT INTO `mast_countryname` VALUES (150, 'Montserrat', 664, 1);
INSERT INTO `mast_countryname` VALUES (87, 'Guam', 670, 1);
INSERT INTO `mast_countryname` VALUES (180, 'Rota Island', 670, 1);
INSERT INTO `mast_countryname` VALUES (202, 'Saipan Island', 670, 1);
INSERT INTO `mast_countryname` VALUES (216, 'Tinian Island', 670, 1);
INSERT INTO `mast_countryname` VALUES (11, 'Antarctica', 672, 1);
INSERT INTO `mast_countryname` VALUES (158, 'Norfolk Island', 672, 1);
INSERT INTO `mast_countryname` VALUES (24, 'Brunei', 673, 1);
INSERT INTO `mast_countryname` VALUES (160, 'Nauru', 674, 1);
INSERT INTO `mast_countryname` VALUES (174, 'Papua New Guinea', 675, 1);
INSERT INTO `mast_countryname` VALUES (224, 'Tonga Islands', 676, 1);
INSERT INTO `mast_countryname` VALUES (194, 'Solomon Islands', 677, 1);
INSERT INTO `mast_countryname` VALUES (236, 'Vanuatu', 678, 1);
INSERT INTO `mast_countryname` VALUES (75, 'Fiji Islands', 679, 1);
INSERT INTO `mast_countryname` VALUES (173, 'Palau', 680, 1);
INSERT INTO `mast_countryname` VALUES (242, 'Wallisand Futuna Islands', 681, 1);
INSERT INTO `mast_countryname` VALUES (46, 'Cook Islands', 682, 1);
INSERT INTO `mast_countryname` VALUES (165, 'Niue', 683, 1);
INSERT INTO `mast_countryname` VALUES (9, 'American Samoa', 684, 1);
INSERT INTO `mast_countryname` VALUES (241, 'Western Samoa', 685, 1);
INSERT INTO `mast_countryname` VALUES (114, 'Kiribati', 686, 1);
INSERT INTO `mast_countryname` VALUES (155, 'New Caledonia', 687, 3);
INSERT INTO `mast_countryname` VALUES (227, 'Tuvalu', 688, 1);
INSERT INTO `mast_countryname` VALUES (81, 'French Polynesia', 689, 1);
INSERT INTO `mast_countryname` VALUES (217, 'Tokelau', 690, 1);
INSERT INTO `mast_countryname` VALUES (136, 'Micronesia', 691, 1);
INSERT INTO `mast_countryname` VALUES (133, 'Marshall Islands', 692, 1);
INSERT INTO `mast_countryname` VALUES (65, 'Dominica', 767, 1);
INSERT INTO `mast_countryname` VALUES (177, 'Puerto Rico', 787, 1);
INSERT INTO `mast_countryname` VALUES (148, 'Midway Island', 808, 1);
INSERT INTO `mast_countryname` VALUES (240, 'Wake Island', 808, 1);
INSERT INTO `mast_countryname` VALUES (63, 'Dominican Republic', 809, 1);
INSERT INTO `mast_countryname` VALUES (188, 'St. Vincent & Grenadines', 809, 1);
INSERT INTO `mast_countryname` VALUES (118, 'Korea (North)', 850, 1);
INSERT INTO `mast_countryname` VALUES (166, 'North Korea', 850, 1);
INSERT INTO `mast_countryname` VALUES (99, 'Hong Kong', 852, 1);
INSERT INTO `mast_countryname` VALUES (129, 'Macau', 853, 1);
INSERT INTO `mast_countryname` VALUES (38, 'Cambodia', 855, 1);
INSERT INTO `mast_countryname` VALUES (120, 'Laos', 856, 1);
INSERT INTO `mast_countryname` VALUES (218, 'Trinidad & Tobago', 868, 1);
INSERT INTO `mast_countryname` VALUES (162, 'Nevis', 869, 1);
INSERT INTO `mast_countryname` VALUES (200, 'St.Kitts/Nevis', 869, 1);
INSERT INTO `mast_countryname` VALUES (111, 'Jamaica', 876, 1);
INSERT INTO `mast_countryname` VALUES (17, 'Bangladesh', 880, 2);
INSERT INTO `mast_countryname` VALUES (214, 'Taiwan', 886, 1);
INSERT INTO `mast_countryname` VALUES (143, 'Maldives', 960, 1);
INSERT INTO `mast_countryname` VALUES (121, 'Lebanon', 961, 1);
INSERT INTO `mast_countryname` VALUES (112, 'Jordan', 962, 1);
INSERT INTO `mast_countryname` VALUES (213, 'Syria', 963, 1);
INSERT INTO `mast_countryname` VALUES (104, 'Iraq', 964, 1.5);
INSERT INTO `mast_countryname` VALUES (119, 'Kuwait', 965, 1);
INSERT INTO `mast_countryname` VALUES (190, 'Saudi Arabia', 966, 1);
INSERT INTO `mast_countryname` VALUES (243, 'Yemen', 967, 1);
INSERT INTO `mast_countryname` VALUES (167, 'Oman', 968, 1);
INSERT INTO `mast_countryname` VALUES (229, 'United Arab Emirates', 971, 1);
INSERT INTO `mast_countryname` VALUES (105, 'Israel', 972, 1);
INSERT INTO `mast_countryname` VALUES (27, 'Bahrain', 973, 1);
INSERT INTO `mast_countryname` VALUES (178, 'Qatar', 974, 1);
INSERT INTO `mast_countryname` VALUES (21, 'Bhutan', 975, 1);
INSERT INTO `mast_countryname` VALUES (138, 'Mongolia', 976, 1);
INSERT INTO `mast_countryname` VALUES (153, 'Nepal', 977, 1);
INSERT INTO `mast_countryname` VALUES (226, 'Turkmenistan', 993, 1);
INSERT INTO `mast_countryname` VALUES (15, 'Azerbaijan', 994, 1);
INSERT INTO `mast_countryname` VALUES (83, 'Georgia', 995, 1);
INSERT INTO `mast_countryname` VALUES (116, 'Kyrgyz Republic', 996, 1);
INSERT INTO `mast_countryname` VALUES (235, 'Uzbekistan', 998, 1);
INSERT INTO `mast_countryname` VALUES (48, 'Cuba (GuantanamoBay)', 5399, 1);
INSERT INTO `mast_countryname` VALUES (95, 'Guantanamo Bay', 5399, 1);
-- --------------------------------------------------------
--
-- Table structure for table `mast_databasetype`
--
CREATE TABLE `mast_databasetype` (
`id` int(6) NOT NULL auto_increment,
`databasetype` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `mast_databasetype`
--
INSERT INTO `mast_databasetype` VALUES (1, 'MYSQL');
INSERT INTO `mast_databasetype` VALUES (2, 'MS-SQL');
INSERT INTO `mast_databasetype` VALUES (4, 'Postgres');
INSERT INTO `mast_databasetype` VALUES (6, 'mysql');
INSERT INTO `mast_databasetype` VALUES (9, '-Uncertain-');
-- --------------------------------------------------------
--
-- Table structure for table `mast_emailnotification`
--
CREATE TABLE `mast_emailnotification` (
`id` int(6) NOT NULL auto_increment,
`emailnotification` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `mast_emailnotification`
--
INSERT INTO `mast_emailnotification` VALUES (1, 'HTML');
INSERT INTO `mast_emailnotification` VALUES (2, 'TEXT');
INSERT INTO `mast_emailnotification` VALUES (3, 'Sheetal project');
INSERT INTO `mast_emailnotification` VALUES (4, 'SonalV');
-- --------------------------------------------------------
--
-- Table structure for table `mast_escrowfee`
--
CREATE TABLE `mast_escrowfee` (
`id` int(6) NOT NULL auto_increment,
`escrowfee` varchar(20) NOT NULL default '',
`url` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `mast_escrowfee`
--
INSERT INTO `mast_escrowfee` VALUES (1, 'Paypal', 'http://www.paypal.com');
INSERT INTO `mast_escrowfee` VALUES (2, 'Moneybookers', 'http://www.moneybookers.com');
-- --------------------------------------------------------
--
-- Table structure for table `mast_gender`
--
CREATE TABLE `mast_gender` (
`id` int(6) NOT NULL auto_increment,
`gender` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `mast_gender`
--
INSERT INTO `mast_gender` VALUES (1, 'Male');
INSERT INTO `mast_gender` VALUES (2, 'Female');
-- --------------------------------------------------------
--
-- Table structure for table `mast_hideoption`
--
CREATE TABLE `mast_hideoption` (
`id` int(6) NOT NULL auto_increment,
`hideoption` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `mast_hideoption`
--
INSERT INTO `mast_hideoption` VALUES (1, 'I want my project to be listed as a featured project. ($25 cost). Recommended!');
INSERT INTO `mast_hideoption` VALUES (2, 'I want to hide all bids on my project from other users. To view bids you must login.($3 cost)');
INSERT INTO `mast_hideoption` VALUES (3, 'I want my project to be for gold members only.');
-- --------------------------------------------------------
--
-- Table structure for table `mast_memshiptype`
--
CREATE TABLE `mast_memshiptype` (
`id` int(6) NOT NULL auto_increment,
`memshiptype` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `mast_memshiptype`
--
-- --------------------------------------------------------
--
-- Table structure for table `mast_nationality`
--
CREATE TABLE `mast_nationality` (
`id` int(6) NOT NULL auto_increment,
`nationality` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `mast_nationality`
--
INSERT INTO `mast_nationality` VALUES (1, 'Indian');
-- --------------------------------------------------------
--
-- Table structure for table `mast_opsystype`
--
CREATE TABLE `mast_opsystype` (
`id` int(6) NOT NULL auto_increment,
`opsystype` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `mast_opsystype`
--
INSERT INTO `mast_opsystype` VALUES (1, 'WinNT');
INSERT INTO `mast_opsystype` VALUES (2, 'Linux');
-- --------------------------------------------------------
--
-- Table structure for table `mast_paymenttype`
--
CREATE TABLE `mast_paymenttype` (
`id` int(6) NOT NULL auto_increment,
`paymenttype` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `mast_paymenttype`
--
INSERT INTO `mast_paymenttype` VALUES (1, 'cpm');
INSERT INTO `mast_paymenttype` VALUES (2, 'cpc');
-- --------------------------------------------------------
--
-- Table structure for table `mast_pcategorytype`
--
CREATE TABLE `mast_pcategorytype` (
`id` int(11) NOT NULL auto_increment,
`pcategorytype` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;
--
-- Dumping data for table `mast_pcategorytype`
--
INSERT INTO `mast_pcategorytype` VALUES (8, '.NET');
INSERT INTO `mast_pcategorytype` VALUES (9, 'AudioServices');
INSERT INTO `mast_pcategorytype` VALUES (10, 'Banner Design');
INSERT INTO `mast_pcategorytype` VALUES (11, 'C/C++');
INSERT INTO `mast_pcategorytype` VALUES (12, 'Cold Fusion');
INSERT INTO `mast_pcategorytype` VALUES (13, 'Copywriting');
INSERT INTO `mast_pcategorytype` VALUES (14, 'Data Entry');
INSERT INTO `mast_pcategorytype` VALUES (15, 'Data Processing');
INSERT INTO `mast_pcategorytype` VALUES (16, 'Delphi');
INSERT INTO `mast_pcategorytype` VALUES (17, 'Flash');
INSERT INTO `mast_pcategorytype` VALUES (18, 'Graphic Design');
INSERT INTO `mast_pcategorytype` VALUES (19, 'Java');
INSERT INTO `mast_pcategorytype` VALUES (20, 'Javascript');
INSERT INTO `mast_pcategorytype` VALUES (21, 'JSP');
INSERT INTO `mast_pcategorytype` VALUES (22, 'Legal Advice');
INSERT INTO `mast_pcategorytype` VALUES (23, 'Link Building');
INSERT INTO `mast_pcategorytype` VALUES (24, 'Linux');
INSERT INTO `mast_pcategorytype` VALUES (25, 'Logo Design');
INSERT INTO `mast_pcategorytype` VALUES (26, 'Perl/CGI');
INSERT INTO `mast_pcategorytype` VALUES (27, 'Photography');
INSERT INTO `mast_pcategorytype` VALUES (28, 'PHP');
INSERT INTO `mast_pcategorytype` VALUES (29, 'Project Management');
INSERT INTO `mast_pcategorytype` VALUES (30, 'Python');
INSERT INTO `mast_pcategorytype` VALUES (31, 'Script Installation');
INSERT INTO `mast_pcategorytype` VALUES (32, 'SEO');
INSERT INTO `mast_pcategorytype` VALUES (33, 'System Admin');
INSERT INTO `mast_pcategorytype` VALUES (34, 'Website Design');
INSERT INTO `mast_pcategorytype` VALUES (35, 'Website Security');
INSERT INTO `mast_pcategorytype` VALUES (36, 'Windows');
INSERT INTO `mast_pcategorytype` VALUES (37, 'Web Promotion');
INSERT INTO `mast_pcategorytype` VALUES (38, 'Wireless');
INSERT INTO `mast_pcategorytype` VALUES (39, 'XML');
INSERT INTO `mast_pcategorytype` VALUES (40, 'ASP');
INSERT INTO `mast_pcategorytype` VALUES (41, 'PHP');
-- --------------------------------------------------------
--
-- Table structure for table `mast_pickproviderstatus`
--
CREATE TABLE `mast_pickproviderstatus` (
`id` int(6) NOT NULL auto_increment,
`pickproviderstatus` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `mast_pickproviderstatus`
--
INSERT INTO `mast_pickproviderstatus` VALUES (1, 'Waiting');
INSERT INTO `mast_pickproviderstatus` VALUES (2, 'Accept');
INSERT INTO `mast_pickproviderstatus` VALUES (3, 'Deny');
-- --------------------------------------------------------
--
-- Table structure for table `mast_rating`
--
CREATE TABLE `mast_rating` (
`id` int(6) NOT NULL auto_increment,
`rating` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `mast_rating`
--
INSERT INTO `mast_rating` VALUES (1, '1');
INSERT INTO `mast_rating` VALUES (2, '2');
INSERT INTO `mast_rating` VALUES (3, '3');
INSERT INTO `mast_rating` VALUES (4, '4');
INSERT INTO `mast_rating` VALUES (5, '5');
INSERT INTO `mast_rating` VALUES (6, '6');
INSERT INTO `mast_rating` VALUES (7, '7');
INSERT INTO `mast_rating` VALUES (8, '8');
INSERT INTO `mast_rating` VALUES (9, '9');
INSERT INTO `mast_rating` VALUES (10, '10');
INSERT INTO `mast_rating` VALUES (11, '11');
-- --------------------------------------------------------
--
-- Table structure for table `mast_reason`
--
CREATE TABLE `mast_reason` (
`id` int(6) NOT NULL auto_increment,
`reason` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `mast_reason`
--
INSERT INTO `mast_reason` VALUES (1, 'Posting contact information');
INSERT INTO `mast_reason` VALUES (2, 'Advertising another website');
INSERT INTO `mast_reason` VALUES (3, 'Non-featured project posted requiring abnormal bidding');
INSERT INTO `mast_reason` VALUES (4, 'Other');
-- --------------------------------------------------------
--
-- Table structure for table `mast_status`
--
CREATE TABLE `mast_status` (
`id` int(11) NOT NULL auto_increment,
`status` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `mast_status`
--
INSERT INTO `mast_status` VALUES (1, 'OPEN');
INSERT INTO `mast_status` VALUES (2, 'CLOSED');
INSERT INTO `mast_status` VALUES (9, 'FROZEN');
INSERT INTO `mast_status` VALUES (8, 'CANCEL');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_additionalprojectupload`
--
CREATE TABLE `tbl_additionalprojectupload` (
`id` int(6) NOT NULL auto_increment,
`userid` int(6) NOT NULL default '0',
`projectid` int(6) NOT NULL default '0',
`addtional_desc` varchar(255) default NULL,
`uploadfilename` varchar(250) NOT NULL default '',
`posteddate` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `tbl_additionalprojectupload`
--
INSERT INTO `tbl_additionalprojectupload` VALUES (1, 1, 15, NULL, '20060131101135.jpg', '2006-01-31 10:11:35');
INSERT INTO `tbl_additionalprojectupload` VALUES (2, 1, 15, NULL, '20060131102058.jpg', '2006-01-31 10:20:58');
INSERT INTO `tbl_additionalprojectupload` VALUES (3, 1, 15, NULL, '20060131102116.jpg', '2006-01-31 10:21:16');
INSERT INTO `tbl_additionalprojectupload` VALUES (4, 1, 15, NULL, '20060131102223.jpg', '2006-01-31 10:22:23');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_administrator`
--
CREATE TABLE `tbl_administrator` (
`userid` int(11) NOT NULL auto_increment,
`username` varchar(50) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`first_name` varchar(100) default NULL,
`last_name` varchar(100) default NULL,
`email` varchar(150) default NULL,
`regular_admin` enum('yes','no') NOT NULL default 'yes',
`status` enum('active','inactive') NOT NULL default 'active',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`userid`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
--
-- Dumping data for table `tbl_administrator`
--
INSERT INTO `tbl_administrator` VALUES (17, '', '', 'Administrator', 'Manage', 'admin@yahoo.com', 'yes', 'active', '2006-12-19 21:11:36');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_advertise`
--
CREATE TABLE `tbl_advertise` (
`id` int(11) NOT NULL auto_increment,
`advertisename` varchar(255) NOT NULL default '',
`paymenttypeid` int(4) NOT NULL default '0',
`crt` varchar(255) NOT NULL default '',
`minbid` int(4) NOT NULL default '0',
`bidincrement` int(4) NOT NULL default '0',
`topbid` int(4) NOT NULL default '0',
`createddate` datetime NOT NULL default '0000-00-00 00:00:00',
`adddesc` varchar(255) NOT NULL default '',
`statusid` int(10) default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `tbl_advertise`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_advertiseplacebid`
--
CREATE TABLE `tbl_advertiseplacebid` (
`placebidid` int(6) NOT NULL auto_increment,
`advertiseid` int(6) NOT NULL default '0',
`userid` int(10) NOT NULL default '0',
`bid` int(10) NOT NULL default '0',
`maxamt` int(10) NOT NULL default '0',
`emailnotiication` enum('yes','no') NOT NULL default 'no',
`createddt` datetime default NULL,
`url` varchar(255) NOT NULL default '',
`adtext` varchar(255) NOT NULL default '',
`pickid` varchar(100) NOT NULL default '0',
`paystatus` enum('yes','no') NOT NULL default 'no',
`aprovalstatus` enum('yes','no') NOT NULL default 'no',
PRIMARY KEY (`placebidid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;
--
-- Dumping data for table `tbl_advertiseplacebid`
--
INSERT INTO `tbl_advertiseplacebid` VALUES (23, 5, 97, 0, 0, 'no', NULL, '', '', '0', 'no', 'no');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_bueryrating`
--
CREATE TABLE `tbl_bueryrating` (
`id` int(11) NOT NULL auto_increment,
`userid` int(4) NOT NULL default '0',
`buyer_userid` int(4) NOT NULL default '0',
`rating` int(4) NOT NULL default '0',
`createddate` datetime NOT NULL default '0000-00-00 00:00:00',
`ratedesc` text,
`projectid` int(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `tbl_bueryrating`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_deposit`
--
CREATE TABLE `tbl_deposit` (
`id` int(11) NOT NULL auto_increment,
`userid` int(4) NOT NULL default '0',
`total_amt` varchar(50) NOT NULL default '0',
`depositdt` datetime NOT NULL default '0000-00-00 00:00:00',
`paymenttype` int(4) NOT NULL default '0',
`status` varchar(255) NOT NULL default '',
`fee_amt` varchar(50) NOT NULL default '0',
`amt_added` varchar(50) NOT NULL default '0',
`taken_fee` varchar(50) NOT NULL default '0',
`taken_fee_reasion` varchar(100) default NULL,
`country` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;
--
-- Dumping data for table `tbl_deposit`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_escrow`
--
CREATE TABLE `tbl_escrow` (
`id` int(11) NOT NULL auto_increment,
`userid` int(4) NOT NULL default '0',
`amt` varchar(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
--
-- Dumping data for table `tbl_escrow`
--
INSERT INTO `tbl_escrow` VALUES (5, 1, '40.64');
INSERT INTO `tbl_escrow` VALUES (4, 97, '990');
INSERT INTO `tbl_escrow` VALUES (6, 110, '16');
INSERT INTO `tbl_escrow` VALUES (7, 115, '4');
INSERT INTO `tbl_escrow` VALUES (8, 119, '0');
INSERT INTO `tbl_escrow` VALUES (9, 120, '-80');
INSERT INTO `tbl_escrow` VALUES (10, 118, '-15');
INSERT INTO `tbl_escrow` VALUES (11, 136, '0');
INSERT INTO `tbl_escrow` VALUES (12, 137, '0');
INSERT INTO `tbl_escrow` VALUES (13, 117, '1000');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_escrowfee`
--
CREATE TABLE `tbl_escrowfee` (
`id` int(6) NOT NULL auto_increment,
`escrowfeemethodid` int(4) NOT NULL default '0',
`takenfee` varchar(10) NOT NULL default '',
`fixedfee` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `tbl_escrowfee`
--
INSERT INTO `tbl_escrowfee` VALUES (2, 1, '5', '5');
INSERT INTO `tbl_escrowfee` VALUES (6, 2, '10', '10');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_escrowincoming`
--
CREATE TABLE `tbl_escrowincoming` (
`id` int(11) NOT NULL auto_increment,
`fromuserid` int(4) NOT NULL default '0',
`touserid` int(4) NOT NULL default '0',
`total_amt` varchar(10) NOT NULL default '0',
`status` varchar(255) NOT NULL default '',
`icogid` varchar(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `tbl_escrowincoming`
--
INSERT INTO `tbl_escrowincoming` VALUES (5, 97, 120, '10', 'no', 'c6deaz7e');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_escrowoutgoing`
--
CREATE TABLE `tbl_escrowoutgoing` (
`id` int(11) NOT NULL auto_increment,
`fromuserid` int(4) NOT NULL default '0',
`touserid` int(4) NOT NULL default '0',
`total_amt` varchar(10) NOT NULL default '0',
`status` varchar(255) NOT NULL default '',
`icogid` varchar(100) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `tbl_escrowoutgoing`
--
INSERT INTO `tbl_escrowoutgoing` VALUES (5, 97, 120, '10', 'no', 'c6deaz7e');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_pickaprovider`
--
CREATE TABLE `tbl_pickaprovider` (
`id` int(6) NOT NULL auto_increment,
`buyerid` int(6) NOT NULL default '0',
`providerid` int(6) NOT NULL default '0',
`projectid` int(6) NOT NULL default '0',
`pickdate` datetime default NULL,
`providerstatus` int(10) NOT NULL default '0',
`rated` enum('yes','no') NOT NULL default 'no',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=106 ;
--
-- Dumping data for table `tbl_pickaprovider`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_placebid`
--
CREATE TABLE `tbl_placebid` (
`id` int(11) NOT NULL auto_increment,
`pid` int(4) NOT NULL default '0',
`userid` int(4) NOT NULL default '0',
`bidfortotalproject` int(11) NOT NULL default '0',
`deliverydays` int(4) NOT NULL default '0',
`biddetails` text NOT NULL,
`emailnotify` enum('yes','no') default 'no',
`createddate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;
--
-- Dumping data for table `tbl_placebid`
--
INSERT INTO `tbl_placebid` VALUES (67, 103, 97, 34, 0, 'sdf', '', '2007-01-11 09:04:26');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_portfolio`
--
CREATE TABLE `tbl_portfolio` (
`id` tinyint(11) NOT NULL auto_increment,
`userid` tinyint(11) NOT NULL default '0',
`template_path` varchar(200) default NULL,
`link` varchar(200) default NULL,
`description` text,
`date` date default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `tbl_portfolio`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_postproject`
--
CREATE TABLE `tbl_postproject` (
`pid` int(11) NOT NULL auto_increment,
`pname` varchar(50) NOT NULL default '',
`bid` int(11) default '0',
`avgbid` int(11) default '0',
`statusid` int(11) default '1',
`pcattype` varchar(100) NOT NULL default '0',
`userid` int(4) NOT NULL default '0',
`pdesc` blob NOT NULL,
`databasetypeid` int(4) NOT NULL default '0',
`ostypeid` int(4) NOT NULL default '0',
`pstartdt` varchar(100) NOT NULL default '0000-00-00 00:00:00',
`penddate` varchar(100) NOT NULL default '0000-00-00 00:00:00',
`uploadfile` varchar(50) NOT NULL default '0',
`budgetrangeid` int(4) NOT NULL default '0',
`openbidmaxdays` int(4) NOT NULL default '0',
`hide` varchar(50) NOT NULL default '0',
`createddate` datetime NOT NULL default '0000-00-00 00:00:00',
`comment` text,
`cancelreasonid` int(11) default '0',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=183 ;
--
-- Dumping data for table `tbl_postproject`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_privatemsg`
--
CREATE TABLE `tbl_privatemsg` (
`pmid` int(11) NOT NULL auto_increment,
`pmprojectid` int(4) NOT NULL default '0',
`pmdesc` text NOT NULL,
`pmattachedoc` blob NOT NULL,
`pmfromuserid` int(4) NOT NULL default '0',
`pmtouserid` int(4) NOT NULL default '0',
`pmposteddate` datetime NOT NULL default '0000-00-00 00:00:00',
`pmparentid` int(4) NOT NULL default '0',
PRIMARY KEY (`pmid`),
KEY `pmparentid` (`pmparentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=66 ;
--
-- Dumping data for table `tbl_privatemsg`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_providerrating`
--
CREATE TABLE `tbl_providerrating` (
`id` int(11) NOT NULL auto_increment,
`userid` int(4) NOT NULL default '0',
`provider_userid` int(4) NOT NULL default '0',
`rating` int(4) NOT NULL default '0',
`createddate` datetime NOT NULL default '0000-00-00 00:00:00',
`ratedesc` text NOT NULL,
`projectid` int(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `tbl_providerrating`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_publicmsg`
--
CREATE TABLE `tbl_publicmsg` (
`publicmid` int(11) NOT NULL auto_increment,
`publicmprojectid` int(4) NOT NULL default '0',
`publicmdesc` varchar(255) NOT NULL default '',
`publicmattachedoc` varchar(255) NOT NULL default '',
`publicmfromuserid` int(4) NOT NULL default '0',
`publicmposteddate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`publicmid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=143 ;
--
-- Dumping data for table `tbl_publicmsg`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_ref_userd`
--
CREATE TABLE `tbl_ref_userd` (
`id` tinyint(11) NOT NULL auto_increment,
`refuserid` tinyint(11) default NULL,
`sendtouserid` tinyint(11) default NULL,
`sendtomailid` varchar(150) default NULL,
`earnmoney` varchar(150) default NULL,
`date` date default NULL,
`signup` enum('Yes','No') default 'No',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `tbl_ref_userd`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_refamount`
--
CREATE TABLE `tbl_refamount` (
`id` tinyint(11) NOT NULL auto_increment,
`refamt` tinyint(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_refamount`
--
INSERT INTO `tbl_refamount` VALUES (1, 5);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_reportviolation`
--
CREATE TABLE `tbl_reportviolation` (
`id` int(11) NOT NULL auto_increment,
`vbyuserid` tinyint(11) default NULL,
`touserid` tinyint(11) default NULL,
`projectid` tinyint(11) default NULL,
`violationurl` varchar(255) NOT NULL default '',
`reasonid` int(4) NOT NULL default '0',
`comments` varchar(255) NOT NULL default '',
`createddate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
--
-- Dumping data for table `tbl_reportviolation`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_sitecontent`
--
CREATE TABLE `tbl_sitecontent` (
`content_id` int(11) NOT NULL auto_increment,
`content_pagename` varchar(100) NOT NULL default '',
`pageurl` varchar(255) NOT NULL default '',
`content_showpagetitle` varchar(100) NOT NULL default '',
`content_actcontent` text,
PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
--
-- Dumping data for table `tbl_sitecontent`
--
INSERT INTO `tbl_sitecontent` VALUES (1, 'Home', 'Home Page', 'Home Page', '<p>NITIN N BANDICHOODE</p>\r\n<p> </p>');
INSERT INTO `tbl_sitecontent` VALUES (2, 'Sam is HAPPY', 'About', 'About Us', 'nitinsdfsdffsd');
INSERT INTO `tbl_sitecontent` VALUES (3, 'General', 'general info', 'Travel general information', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (16, 'faq', 'faq', 'faq', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (14, 'resources', 'resources submit site', 'resources', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (15, 'contact', 'contact', 'contact', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (13, 'Affiliates', 'Affiliates', 'Affiliates', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (8, 'Company', 'Company Info', 'Company Info', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (9, 'Privacy', 'Privacy Policy', 'Privacy Policy', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (10, 'Terms', 'Terms Of Service', 'Terms Of Service', '<p>Information here </p>');
INSERT INTO `tbl_sitecontent` VALUES (11, 'Advertise', 'Advertise With Us', 'Advertise With Us', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (12, 'Help', 'Help', 'Help', '<p>Information here</p>');
INSERT INTO `tbl_sitecontent` VALUES (17, 'Articles', 'Articles', 'show Articles', 'Information here');
INSERT INTO `tbl_sitecontent` VALUES (18, 'Advertiser', 'Advertiser', 'Advertiser', '<p>Information here</p>');
INSERT INTO `tbl_sitecontent` VALUES (19, 'Service Provider', 'Serivce Provider', 'Service Provider', '');
INSERT INTO `tbl_sitecontent` VALUES (20, 'Service', 'Serivce Buyer', 'Service Buyer', 'Information here');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_transaction`
--
CREATE TABLE `tbl_transaction` (
`id` int(11) NOT NULL auto_increment,
`fromuserid` int(4) NOT NULL default '0',
`touserid` int(4) NOT NULL default '0',
`transdt` datetime NOT NULL default '0000-00-00 00:00:00',
`projectid` int(4) NOT NULL default '0',
`transdesc` varchar(255) NOT NULL default '',
`paymenttype` int(4) NOT NULL default '0',
`fee_amt` int(11) NOT NULL default '0',
`amt_added` int(11) NOT NULL default '0',
`token_fee` int(11) NOT NULL default '0',
`total_amt` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `tbl_transaction`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_userhideoption`
--
CREATE TABLE `tbl_userhideoption` (
`id` int(11) NOT NULL auto_increment,
`userid` int(4) NOT NULL default '0',
`hideid` int(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `tbl_userhideoption`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_userpcattype`
--
CREATE TABLE `tbl_userpcattype` (
`id` int(11) NOT NULL auto_increment,
`userid` int(4) NOT NULL default '0',
`pcattypeid` int(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
--
-- Dumping data for table `tbl_userpcattype`
--
INSERT INTO `tbl_userpcattype` VALUES (1, 18, 8);
INSERT INTO `tbl_userpcattype` VALUES (7, 1, 15);
INSERT INTO `tbl_userpcattype` VALUES (6, 1, 12);
INSERT INTO `tbl_userpcattype` VALUES (5, 1, 9);
INSERT INTO `tbl_userpcattype` VALUES (8, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (9, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (10, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (11, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (12, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (13, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (14, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (15, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (16, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (17, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (18, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (19, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (20, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (21, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (22, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (23, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (24, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (25, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (26, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (27, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (28, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (29, 1, 8);
INSERT INTO `tbl_userpcattype` VALUES (30, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (31, 1, 14);
INSERT INTO `tbl_userpcattype` VALUES (32, 1, 11);
INSERT INTO `tbl_userpcattype` VALUES (33, 1, 20);
INSERT INTO `tbl_userpcattype` VALUES (34, 1, 23);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_userquote`
--
CREATE TABLE `tbl_userquote` (
`id` int(11) NOT NULL auto_increment,
`userid` int(4) NOT NULL default '0',
`txtquote` text,
`url` varchar(255) default NULL,
`createddate` datetime NOT NULL default '0000-00-00 00:00:00',
`status` enum('YES','NO') NOT NULL default 'NO',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
--
-- Dumping data for table `tbl_userquote`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_users`
--
CREATE TABLE `tbl_users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(50) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`signupdt` datetime NOT NULL default '0000-00-00 00:00:00',
`first_name` varchar(100) NOT NULL default '',
`last_name` varchar(50) NOT NULL default '',
`gender` varchar(20) NOT NULL default '',
`phone` varchar(50) default NULL,
`emai_addrs` varchar(150) NOT NULL default '',
`city` varchar(100) NOT NULL default '',
`country` varchar(50) NOT NULL default '',
`areaofexpertise` varchar(100) NOT NULL default '0',
`skills` varchar(255) NOT NULL default '',
`vision` varchar(255) NOT NULL default '',
`keyword` varchar(255) NOT NULL default '',
`avghourlyrate` int(4) NOT NULL default '0',
`companyname` varchar(255) NOT NULL default '',
`companylogo` varchar(255) NOT NULL default '',
`address1` varchar(200) default NULL,
`address2` varchar(200) default NULL,
`state` varchar(100) default NULL,
`postalcode` varchar(20) default NULL,
`profiledesc` varchar(255) NOT NULL default '',
`user_activation` enum('yes','no') NOT NULL default 'no',
`user_adminapproval` enum('active','inactive','suspend') NOT NULL default 'inactive',
`web` varchar(255) NOT NULL default '',
`notifytype` varchar(50) NOT NULL default '',
`pdetails` enum('yes','no') NOT NULL default 'no',
`pannouncement` enum('yes','no') NOT NULL default 'no',
`verifycode` varchar(100) NOT NULL default '',
`memshiptype` int(11) NOT NULL default '0',
`isactive_mail` enum('yes','no') NOT NULL default 'no',
`refid` tinyint(11) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=146 ;
--
-- Dumping data for table `tbl_users`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_useruploadedfile`
--
CREATE TABLE `tbl_useruploadedfile` (
`id` int(11) NOT NULL auto_increment,
`userid` int(4) NOT NULL default '0',
`filename` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_useruploadedfile`
--
INSERT INTO `tbl_useruploadedfile` VALUES (1, 1, 'a.jpg');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_withdrawmoney`
--
CREATE TABLE `tbl_withdrawmoney` (
`id` int(6) NOT NULL auto_increment,
`userid` int(4) NOT NULL default '0',
`wamt` varchar(10) NOT NULL default '',
`paypalemail` varchar(35) NOT NULL default '',
`wdt` datetime NOT NULL default '0000-00-00 00:00:00',
`paymenttypeid` int(10) NOT NULL default '0',
`status` enum('YES','NO') NOT NULL default 'NO',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
--
-- Dumping data for table `tbl_withdrawmoney`
---------------------------
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.