Web Auction Installation Instructions

System requirements

PHP 4.3 or higher (Safe mode must be turned off, and short tags turned on)
MySQL 4.1 or higher

Before you can use WebAuction, you need to set up the database and make some changes to the conf.ini file.

License

Step 1: Create the MySQL database & MySQL User

Please create a database in your MySQL server where WebAuction can store its data. Also create a MySQL user account that WebAuction can use to access the database. This user account should have full access privileges to this database.

Step 2: Create database tables

Please run the following MySQL commands to set up the Web Auction database. (You can copy and paste these commands directly into MySQL if you like).

-- phpMyAdmin SQL Dump
-- version 2.8.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost:3306
-- Generation Time: Feb 09, 2008 at 09:40 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.4
-- 
-- Database: `apps_12`
--

-- --------------------------------------------------------

-- 
-- Table structure for table `bids`
--

CREATE TABLE `bids` (
  `bid_id` int(11) NOT NULL auto_increment,
  `product_id` int(11) NOT NULL default '0',
  `username` varchar(32) NOT NULL default '',
  `time_of_bid` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `bid_amount` float NOT NULL default '0',
  `bid_status` enum('PENDING','APPROVED','REJECTED') NOT NULL default 'PENDING',
  PRIMARY KEY  (`bid_id`),
  KEY `product_id` (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `bids`
--

-- --------------------------------------------------------

-- 
-- Table structure for table `closed`
--

CREATE TABLE `closed` (
  `product_id` int(11) NOT NULL default '0',
  `winner` varchar(32) NOT NULL default '',
  `bid_amount` float NOT NULL default '0',
  `email_sent` tinyint(1) NOT NULL default '0',
  `admin_email_sent` tinyint(4) NOT NULL default '0',
  `close_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `closed`
--

-- --------------------------------------------------------

-- 
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `auction_id` int(11) NOT NULL auto_increment,
  `title` varchar(64) default NULL,
  `admin_email` varchar(128) default NULL,
  `notification_from_address` varchar(128) default NULL,
  `closing_time` datetime default NULL,
  `bid_increment` float default NULL,
  `minimum_bid` float default NULL,
  `default_closing_time` datetime default NULL,
  `default_opening_time` datetime default NULL,
  `timezone` varchar(64) default NULL,
  `send_email_notifications` tinyint(1) default NULL,
  `send_outbid_notifications_to_admin` tinyint(1) default NULL,
  `winner_instructions` text,
  `reverse_auction` tinyint(1) unsigned NOT NULL default '0',
  `custom_header` text,
  `custom_footer` text,
  `custom_css` text,
  PRIMARY KEY  (`auction_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `config`
--

INSERT INTO `config` (`auction_id`, `title`, `admin_email`, `notification_from_address`, `closing_time`, `bid_increment`, `minimum_bid`, `default_closing_time`, `default_opening_time`, `timezone`, `send_email_notifications`, `send_outbid_notifications_to_admin`, `winner_instructions`, `reverse_auction`, `custom_header`, `custom_footer`, `custom_css`) VALUES (1, 'My Super Auction', 'admin@yourdomain.com', 'Auction <admin@yourdomain.com>', NULL, 5, 5, '2007-12-31 20:08:00', '2007-12-21 20:09:00', NULL, 1, 1, 'You have won the auction.', 0, NULL, NULL, NULL);

-- --------------------------------------------------------

-- 
-- Table structure for table `dataface__version`
--

CREATE TABLE `dataface__version` (
  `version` int(5) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `dataface__version`
--

INSERT INTO `dataface__version` (`version`) VALUES (30);

-- --------------------------------------------------------

-- 
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `category_id` int(11) NOT NULL auto_increment,
  `category_name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` (`category_id`, `category_name`) VALUES (6, 'VCRs');

-- --------------------------------------------------------

-- 
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `product_id` int(11) NOT NULL auto_increment,
  `product_name` varchar(64) NOT NULL default '',
  `product_description` text,
  `product_image` varchar(128) default NULL,
  `product_image_mimetype` varchar(128) default NULL,
  `product_categories` varchar(32) default NULL,
  `seller_username` varchar(32) NOT NULL default '',
  `minimum_bid` float default NULL,
  `bid_increment` float NOT NULL default '5',
  `opening_time` datetime default NULL,
  `closing_time` datetime default NULL,
  `created_date` datetime default NULL,
  `modified_date` datetime default NULL,
  `entered_by` varchar(32) default NULL,
  PRIMARY KEY  (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `products`
--

-- --------------------------------------------------------

-- 
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `username` varchar(32) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `firstname` varchar(32) default NULL,
  `lastname` varchar(32) default NULL,
  `title` varchar(32) default NULL,
  `department` varchar(32) default NULL,
  `phone` varchar(15) default NULL,
  `email` varchar(64) NOT NULL default '',
  `role` enum('USER','ADMIN') NOT NULL default 'USER',
  `prefs_receive_outbid_notifications` tinyint(1) NOT NULL default '1',
  `timezone` varchar(64) default NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `users`
--

INSERT INTO `users` (`username`, `password`, `firstname`, `lastname`, `title`, `department`, `phone`, `email`, `role`, `prefs_receive_outbid_notifications`, `timezone`) VALUES ('admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '', 'Admin', 'Auction', '555-5555', 'admin@weblite.ca', 'ADMIN', 1, NULL);

Step 3: Update conf.ini file

Please update the [_database] section of the conf.ini file so that it reflects the connection information to the database that you just created for WebAuction.

Step 4: File Permissions

Make the templates_c directory writable by the web server. This is where the Smarty templates are cached.
Make the tables/products/product_image directory writable by the web server. This is where the images for the auction products will be stored.

Step 5: Log In

At this point, your web auction installation is available here. You can log into the administration section here with username admin and password password.

Troubleshooting

Support

If you run into problems with the installation, please visit the WebAuction forum.

Common Problems

I get a blank page when I try to access the auction script

If your PHP installation is configured to suppress errors in the browser, then any error will result in a blank page. Your first troubleshooting step should be to find out what the error is by either:

Checking your error log. (Error logs may be located anywhere, but a common location for Linux distributions in /var/log/httpd/error_log). If you have shell access you can read the last few lines of the error log with the command:
```
tail /var/log/httpd/error_log
```
.

If you do not have shell access then you may be able to access your error log through your web administration panel. Please check with your hosting provider to find out how to access the error log.
Turning on display of errors in your browser. You can do this by adding the following line to the beginning of the index.php file (after the opening <?php tag):
```
ini_set('display_errors','on');
error_reporting(E_ALL);
					
```