jack2509
06-12-2008, 19:46
Tình hình là e đã tạo cái db rùi, giả sử cái usename: abcssd pass: ddddff. Thì mình phải config cái file db.txt như thế nào? các pác chỉ e, e gà quá
cái file db.txt trong code web nó như thế này
CREATE TABLE `attributes` (
`name` varchar(40) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
`attribute` varchar(20) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
INSERT INTO `attributes` (`name`, `value`, `attribute`) VALUES ('featured_price', '120.00', ''),
('admin', 'admin', 'site_manager'),
('currency_code', 'USD', ''),
('currency_symbol', '$', ''),
('email_manager', 'email@yourmail.com', ''),
('listing_days', '14', ''),
('site_title', 'Web Directory Script', ''),
('site_description', 'Web Directory Script', ''),
('site_keywords', 'directory, classifieds, listing, listings, php, script, business', ''),
('baner_href', 'http://www.yourdomain.com', 'jpg'),
('baner_enabled', 'true', '');
-- --------------------------------------------------------
CREATE TABLE `bills` (
`id` int(11) NOT NULL auto_increment,
`user_id` varchar(15) NOT NULL default '0',
`amount` varchar(7) NOT NULL default '',
`status` varchar(15) NOT NULL default '',
`date` varchar(19) NOT NULL default '',
`repeated_period` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=98 ;
-- --------------------------------------------------------
CREATE TABLE `categories` (
`id` int(11) NOT NULL auto_increment,
`category` varchar(40) NOT NULL default '',
`subcategory` varchar(40) NOT NULL default '',
`parent` varchar(4) NOT NULL default '',
`subsubcategory` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
CREATE TABLE `images` (
`id` int(11) NOT NULL auto_increment,
`listing_id` int(11) NOT NULL default '0',
`file` varchar(60) NOT NULL default '',
`thmb_caption` varchar(60) NOT NULL default '',
`image_caption` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=13 ;
-- --------------------------------------------------------
CREATE TABLE `listings` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`category` varchar(40) NOT NULL default '',
`subcategory` varchar(40) NOT NULL default '',
`featured` char(1) NOT NULL default '1',
`logo` varchar(60) NOT NULL default '',
`summary` text NOT NULL,
`details` text NOT NULL,
`address` varchar(60) NOT NULL default '',
`city` varchar(25) NOT NULL default '',
`state` varchar(25) NOT NULL default '',
`zip` varchar(10) NOT NULL default '',
`phone` varchar(17) NOT NULL default '',
`fax` varchar(17) NOT NULL default '',
`website` varchar(80) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`country` varchar(25) NOT NULL default '',
`user_id` varchar(15) NOT NULL default '0',
`bill_id` int(11) NOT NULL default '0',
`friendly_url` varchar(60) NOT NULL default '',
`status` varchar(15) NOT NULL default '',
`keywords` text NOT NULL,
`subsubcategory` varchar(4) NOT NULL default '',
`posted_on` timestamp NOT NULL default '0000-00-00 00:00:00',
`expires_on` timestamp NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=87 ;
-- --------------------------------------------------------
CREATE TABLE `locations` (
`id` int(11) NOT NULL auto_increment,
`Country` varchar(25) NOT NULL default '',
`State` varchar(25) NOT NULL default '',
`City` varchar(25) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=30 ;
-- --------------------------------------------------------
CREATE TABLE `members` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(80) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`fname` varchar(40) NOT NULL default '',
`lname` varchar(40) NOT NULL default '',
`company` varchar(50) NOT NULL default '',
`address` varchar(80) NOT NULL default '',
`city` varchar(40) NOT NULL default '',
`state` varchar(30) NOT NULL default '',
`zip` varchar(10) NOT NULL default '',
`country` varchar(30) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`fax` varchar(20) NOT NULL default '',
`url` varchar(80) NOT NULL default '',
`last_login` varchar(19) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=36 ;
-- --------------------------------------------------------
CREATE TABLE `notifications` (
`id` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`body` text NOT NULL,
`notice` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
INSERT INTO `notifications` (`id`, `subject`, `body`, `notice`) VALUES (1, 'DIRECTORY_TITLE Account', 'Dear ACCOUNT_NAME,\r\n\r\nThank you for signing up for an account in DEFAULT_URL\r\nLogin to manage your account with the username and password below.\r\n\r\nDEFAULT_URL/members/\r\n\r\nUsername: ACCOUNT_USERNAME\r\nPassword: ACCOUNT_PASSWORD\r\n\r\n<a href=''DEFAULT_URL''>DEFAULT_URL</a>', 'Email sent to the listing owner when he creates an account.'),
(2, 'DIRECTORY_TITLE account information', 'As requested, here is the information regarding your DIRECTORY_TITLE account.\r\n\r\nLogin to manage your account with the username and password below.\r\n\r\n<a href=''DEFAULT_URL/members/''>DEFAULT_URL/members/</a>\r\n\r\nUsername: ACCOUNT_USERNAME\r\nPassword: ACCOUNT_PASSWORD\r\n\r\nFor further assistance please contact DIRECTORY_EMAIL.\r\n\r\nThank you for being a member of the DIRECTORY_TITLE.', 'Email sent to the listing owner informing his password when requested.'),
(3, 'DIRECTORY_TITLE admin information', 'Adminstrator General E-mail was set up to this e-mail address.\r\n\r\n<a href=''DEFAULT_URL''>DEFAULT_URL</a>', 'Email sent to the administrator general email address.'),
(4, 'DIRECTORY_TITLE listing information', 'Hello, ACCOUNT_USERNAME.\r\n\r\nYour listing "LISTING_TITLE" at DIRECTORY_TITLE has been suspended.\r\n\r\nLogin and prolong your listing.\r\n\r\n<a href=''DEFAULT_URL/members/''>DEFAULT_URL/members/</a>', 'Email sent to the listing owner informing that his listing date has expired.'),
(5, 'DIRECTORY_TITLE new listing information', 'Hello, ACCOUNT_USERNAME.\r\n\r\nYou have created a new listing "LISTING_TITLE" at DIRECTORY_TITLE.\r\nMake the payment for this listing and wait for approval by admin.\r\n\r\nLogin to edit your listing.\r\n\r\n<a href=''DEFAULT_URL/members/''>DEFAULT_URL/members/</a>', 'Email sent to the listing owner, informing that his listing has been created succesfully.'),
(6, 'DIRECTORY_TITLE listing approved', 'Hello, ACCOUNT_USERNAME.\r\n\r\nYour listing "LISTING_TITLE" at DIRECTORY_TITLE has been approved by admin.\r\n\r\nLogin to edit your listing.\r\n\r\n<a href=''DEFAULT_URL/members/''>DEFAULT_URL/members/</a>', 'Email sent to the listing owner, informing that his listing have been succesfully approved by admin.'),
(7, 'DIRECTORY_TITLE listing deleted', 'Hello, ACCOUNT_USERNAME.\r\n\r\nYour listing "LISTING_TITLE" at DIRECTORY_TITLE has been deleted by you or by admin.\r\n\r\nContact admin to get details.\r\n\r\nDIRECTORY_EMAIL', 'Email sent to the listing owner, informing that his listing has been deleted.');
-- --------------------------------------------------------
CREATE TABLE `transactions` (
`id` int(11) NOT NULL auto_increment,
`TransactionID` varchar(30) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`amount` float NOT NULL default '0',
`ip` varchar(60) NOT NULL default '',
`listings` text NOT NULL,
`payer_email` varchar(50) NOT NULL default '',
`date` varchar(19) NOT NULL default '',
`status` varchar(25) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=48 ;
cái file db.txt trong code web nó như thế này
CREATE TABLE `attributes` (
`name` varchar(40) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
`attribute` varchar(20) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
INSERT INTO `attributes` (`name`, `value`, `attribute`) VALUES ('featured_price', '120.00', ''),
('admin', 'admin', 'site_manager'),
('currency_code', 'USD', ''),
('currency_symbol', '$', ''),
('email_manager', 'email@yourmail.com', ''),
('listing_days', '14', ''),
('site_title', 'Web Directory Script', ''),
('site_description', 'Web Directory Script', ''),
('site_keywords', 'directory, classifieds, listing, listings, php, script, business', ''),
('baner_href', 'http://www.yourdomain.com', 'jpg'),
('baner_enabled', 'true', '');
-- --------------------------------------------------------
CREATE TABLE `bills` (
`id` int(11) NOT NULL auto_increment,
`user_id` varchar(15) NOT NULL default '0',
`amount` varchar(7) NOT NULL default '',
`status` varchar(15) NOT NULL default '',
`date` varchar(19) NOT NULL default '',
`repeated_period` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=98 ;
-- --------------------------------------------------------
CREATE TABLE `categories` (
`id` int(11) NOT NULL auto_increment,
`category` varchar(40) NOT NULL default '',
`subcategory` varchar(40) NOT NULL default '',
`parent` varchar(4) NOT NULL default '',
`subsubcategory` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
CREATE TABLE `images` (
`id` int(11) NOT NULL auto_increment,
`listing_id` int(11) NOT NULL default '0',
`file` varchar(60) NOT NULL default '',
`thmb_caption` varchar(60) NOT NULL default '',
`image_caption` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=13 ;
-- --------------------------------------------------------
CREATE TABLE `listings` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`category` varchar(40) NOT NULL default '',
`subcategory` varchar(40) NOT NULL default '',
`featured` char(1) NOT NULL default '1',
`logo` varchar(60) NOT NULL default '',
`summary` text NOT NULL,
`details` text NOT NULL,
`address` varchar(60) NOT NULL default '',
`city` varchar(25) NOT NULL default '',
`state` varchar(25) NOT NULL default '',
`zip` varchar(10) NOT NULL default '',
`phone` varchar(17) NOT NULL default '',
`fax` varchar(17) NOT NULL default '',
`website` varchar(80) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`country` varchar(25) NOT NULL default '',
`user_id` varchar(15) NOT NULL default '0',
`bill_id` int(11) NOT NULL default '0',
`friendly_url` varchar(60) NOT NULL default '',
`status` varchar(15) NOT NULL default '',
`keywords` text NOT NULL,
`subsubcategory` varchar(4) NOT NULL default '',
`posted_on` timestamp NOT NULL default '0000-00-00 00:00:00',
`expires_on` timestamp NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=87 ;
-- --------------------------------------------------------
CREATE TABLE `locations` (
`id` int(11) NOT NULL auto_increment,
`Country` varchar(25) NOT NULL default '',
`State` varchar(25) NOT NULL default '',
`City` varchar(25) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=30 ;
-- --------------------------------------------------------
CREATE TABLE `members` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(80) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`fname` varchar(40) NOT NULL default '',
`lname` varchar(40) NOT NULL default '',
`company` varchar(50) NOT NULL default '',
`address` varchar(80) NOT NULL default '',
`city` varchar(40) NOT NULL default '',
`state` varchar(30) NOT NULL default '',
`zip` varchar(10) NOT NULL default '',
`country` varchar(30) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`fax` varchar(20) NOT NULL default '',
`url` varchar(80) NOT NULL default '',
`last_login` varchar(19) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=36 ;
-- --------------------------------------------------------
CREATE TABLE `notifications` (
`id` int(11) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`body` text NOT NULL,
`notice` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
INSERT INTO `notifications` (`id`, `subject`, `body`, `notice`) VALUES (1, 'DIRECTORY_TITLE Account', 'Dear ACCOUNT_NAME,\r\n\r\nThank you for signing up for an account in DEFAULT_URL\r\nLogin to manage your account with the username and password below.\r\n\r\nDEFAULT_URL/members/\r\n\r\nUsername: ACCOUNT_USERNAME\r\nPassword: ACCOUNT_PASSWORD\r\n\r\n<a href=''DEFAULT_URL''>DEFAULT_URL</a>', 'Email sent to the listing owner when he creates an account.'),
(2, 'DIRECTORY_TITLE account information', 'As requested, here is the information regarding your DIRECTORY_TITLE account.\r\n\r\nLogin to manage your account with the username and password below.\r\n\r\n<a href=''DEFAULT_URL/members/''>DEFAULT_URL/members/</a>\r\n\r\nUsername: ACCOUNT_USERNAME\r\nPassword: ACCOUNT_PASSWORD\r\n\r\nFor further assistance please contact DIRECTORY_EMAIL.\r\n\r\nThank you for being a member of the DIRECTORY_TITLE.', 'Email sent to the listing owner informing his password when requested.'),
(3, 'DIRECTORY_TITLE admin information', 'Adminstrator General E-mail was set up to this e-mail address.\r\n\r\n<a href=''DEFAULT_URL''>DEFAULT_URL</a>', 'Email sent to the administrator general email address.'),
(4, 'DIRECTORY_TITLE listing information', 'Hello, ACCOUNT_USERNAME.\r\n\r\nYour listing "LISTING_TITLE" at DIRECTORY_TITLE has been suspended.\r\n\r\nLogin and prolong your listing.\r\n\r\n<a href=''DEFAULT_URL/members/''>DEFAULT_URL/members/</a>', 'Email sent to the listing owner informing that his listing date has expired.'),
(5, 'DIRECTORY_TITLE new listing information', 'Hello, ACCOUNT_USERNAME.\r\n\r\nYou have created a new listing "LISTING_TITLE" at DIRECTORY_TITLE.\r\nMake the payment for this listing and wait for approval by admin.\r\n\r\nLogin to edit your listing.\r\n\r\n<a href=''DEFAULT_URL/members/''>DEFAULT_URL/members/</a>', 'Email sent to the listing owner, informing that his listing has been created succesfully.'),
(6, 'DIRECTORY_TITLE listing approved', 'Hello, ACCOUNT_USERNAME.\r\n\r\nYour listing "LISTING_TITLE" at DIRECTORY_TITLE has been approved by admin.\r\n\r\nLogin to edit your listing.\r\n\r\n<a href=''DEFAULT_URL/members/''>DEFAULT_URL/members/</a>', 'Email sent to the listing owner, informing that his listing have been succesfully approved by admin.'),
(7, 'DIRECTORY_TITLE listing deleted', 'Hello, ACCOUNT_USERNAME.\r\n\r\nYour listing "LISTING_TITLE" at DIRECTORY_TITLE has been deleted by you or by admin.\r\n\r\nContact admin to get details.\r\n\r\nDIRECTORY_EMAIL', 'Email sent to the listing owner, informing that his listing has been deleted.');
-- --------------------------------------------------------
CREATE TABLE `transactions` (
`id` int(11) NOT NULL auto_increment,
`TransactionID` varchar(30) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`amount` float NOT NULL default '0',
`ip` varchar(60) NOT NULL default '',
`listings` text NOT NULL,
`payer_email` varchar(50) NOT NULL default '',
`date` varchar(19) NOT NULL default '',
`status` varchar(25) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=48 ;