Jump to content
Sign in to follow this  
deathgod

[Contribution] Auction Module

Recommended Posts

KVallema: Look in your product_info.php and search for: tep_image_submit('button_in_cart.gif

 

There should be two instances of this. The second one you should remove/comment out. You probably also have to comment out the table-cells that it is located in as well.

(note that I have also commented out the review-button, as I do not use it)

 

Looking at your code I had the same approach.

My question is now to make the " Terms & Conditions: " radio button working.

 

I succeed the countdown to be functionnal! Wouf.

Still looking to get the " You won " message.

But I do not know the exact conditions to get it ...

 

Keep on the good work.

Share this post


Link to post
Share on other sites
Looking at your code I had the same approach.

My question is now to make the " Terms & Conditions: " radio button working.

 

I succeed the countdown to be functionnal! Wouf.

Still looking to get the " You won " message.

But I do not know the exact conditions to get it ...

 

Keep on the good work.

Look at my post at the top of the page. I have a suggestion for at least a partial solution, but I am totally green with javascript unfortunately. :P

 

The "You Won" message -should- work out of the box with this contribution. There is also an enhanced version of the mail part of the script a few pages back.

Share this post


Link to post
Share on other sites
KVallema: Look in your product_info.php and search for: tep_image_submit('button_in_cart.gif

 

There should be two instances of this. The second one you should remove/comment out. You probably also have to comment out the table-cells that it is located in as well.

 

It should look like this:

 

			<!-- eof moved from bellow by jobonline201@yahoo.com for auction product contribution -->

			<?php
			//bof added by jobonline2001@yahoo.com for auction product contribution
							//rewriten by MarcusDesign
				if ($auction_product) {
					include_once(DIR_WS_MODULES.'/auction_bids.php');
									} else {
							?>
								  <!--<tr>
									<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
									  <tr class="infoBoxContents">
										<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
										  <tr>
											<td width="10"><?php //echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
											<td class="main"><?php //echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td>
											<td class="main" align="right"><?php //echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>
											<td width="10"><?php //echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
										  </tr>
										</table></td>
									  </tr>
									</table></td>
								  </tr>
								  <tr>
									<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
								  </tr>-->
							<?php
			  }
							//eof added by jobonline2001@yahoo.com for auction product contribution

 

(note that I have also commented out the review-button, as I do not use it)

 

hmm....I didn't find this 'second' instance...but I think maybe I am referring to the wrong place...it's the NEW PRODUCTS section that has the BUY NOW -link

 

cheers,

KImmo

Share this post


Link to post
Share on other sites
hmm....I didn't find this 'second' instance...but I think maybe I am referring to the wrong place...it's the NEW PRODUCTS section that has the BUY NOW -link

I hadn't thought of that. This is perhaps another problem that needs addressing, the fact that the buy-it-now button is still visible and usable on all the other pages where the products are listed.

 

I haven't tested it, but I think a simple check like on the product_info page should be enough to fix it:

 

if ($auction_product) {
  //product is an auction, do nothing
 } else {
//regular product,   print the buy-it-now button
<?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?>
}

 

Or reverse it:

 

if (!$auction_product) {
  <?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?>
 } else {
}

 

Find all instances of where you need this done, and replace it with the above.

Share this post


Link to post
Share on other sites

I have to look into removing the Add to Cart or Buy Now links from the what's new pages a bit later....just ran into a curious problem

 

I got the outbid-emails going out...did some re-writing for the email...and realized there was something funky with the highest bidder thingy

 

I've done the change mentioned here a bit earlier to show the firstname of the bidders...but now that I go and make a bid...the new highest bid gets registered on the list...but the firstname doesn't change...

 

I am about to hire someone to install this thingy for me and fix all the bugs....but before I go and spend my money...anyone here that can help me??

 

I also need to get the overbid amount thing working as well... :(

Share this post


Link to post
Share on other sites
I am about to hire someone to install this thingy for me and fix all the bugs....but before I go and spend my money...anyone here that can help me??

I would advise against it, as currently there are several people working on the next version of this contribution. Now there is no particular release date for it, as the fix/todo-list is rather extensive as you can see from my post (not a complete list either), but hopefully it will be done in due time.

Share this post


Link to post
Share on other sites

okay...but now something else showed up....it allows me to place bids below the minimum...I might've repaired the thing to pieces :(

Share this post


Link to post
Share on other sites

and my countdown is continuously the same...no matter what I change to the TZ offset...

Share this post


Link to post
Share on other sites
and my countdown is continuously the same...no matter what I change to the TZ offset...

 

Hello,

 

May be this could help you to get the stuff working: I performed some cosmetic in " catalog/includes/modules/auction_bids.php " (in order to add/remove colums).

<?php
/*
 $Id: auctions_bids.php,v 1.4 2007/06/18 08:11:33 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/
?>
<!-- beg /includes/modules/auctions_bids.php -->
<tr>
<td>
	<!-- beg of table_1 -->
	<table width="686">
		<tr>
			<td width="278">
			<!-- bof added by jobonline2001@yahoo.com for auction product contribution -->
<?php
if ($auction_product) { 
	$auction_query = tep_db_query("select auctions_starting_price, expires_date, overbid_amount from " . TABLE_AUCTIONS_PRODUCTS . " where products_id = '" . $product_info['products_id']. "' and status = '1' ");
	$auction_infor = tep_db_fetch_array($auction_query);
	//$datetime_count_down = strtotime($auction_infor['expires_date'])-time();
	$datetime_count_down = tep_date_count_down($auction_infor['expires_date']);
	$thours = AUCTION_END_TIMEOFFSET;
?>
<script language="Javascript">
function termWindow() {
window.open ("auction_terms.php");
}
</script>
				<!-- beg of table_2 -->
				<table class="infoBox">
					<tr>
						<td width="239" class="infoBoxContents"><?php echo TEXT_AUCTION_PRICE . ' ' . $products_price; ?></td>
					</tr>
					<tr>
						<td class="infoBoxContents"><?php echo TEXT_EXPIRED_DATE . ' ' . $auction_infor['expires_date']; ?>
						<br />
						(<b><span id="countdown_date" > </span></b> <?php echo TEXT_DATETIME_LEFT; ?>)
						</td>
					</tr>
					<tr>
						<td class="infoBoxContents"><?php echo TEXT_OVERBID_AMOUNT . ' ' . $currencies->display_price($auction_infor['overbid_amount'], tep_get_tax_rate($product_info['products_tax_class_id'])); ?></td>
					</tr>
				</table>
				<!-- end of table_2 -->
<?php
 } // end if ($auction_product)
else {
  echo $products_price; 
 } // end else if
?>
<!-- eof added by jobonline2001@yahoo.com for auction product contribution -->
			</td>
			<td width="396">
<!-- bof added by jobonline2001@yahoo.com for auction product contribution -->
<?php // If auction has expired
$mfo_auction_query = mysql_fetch_object(tep_db_query("select auctions_starting_price, expires_date, overbid_amount from " . TABLE_AUCTIONS_PRODUCTS . " where products_id = '" . $product_info['products_id']. "' and status = '1' "));
if (strtotime($mfo_auction_query->expires_date)<time()) {
echo tep_end_auction_valid();
} elseif ( $auction_product ) { // Not sure, but probably similar to - If auction has not expired
?>
<!-- beg of form -->
<?php
echo tep_draw_form('auction_bid',tep_href_link(FILENAME_PRODUCT_INFO),'post', 'onsubmit="return check_agree(this);"');
?>
<input type="hidden" name="placebid" value="true" id="placebid" />
<input type="hidden" name="auction_id" id="auction_id" value="<?php echo $auction_id; ?>" />
<input type="hidden" name="products_id" value="<?php echo (int)$HTTP_GET_VARS['products_id']; ?>" id="products_id" />
<!-- beg of table_3 -->
<table>
	<tr>
		<td class="main" colspan="2"><?php echo TEXT_BID_PRICE . ' ' . tep_draw_input_field('bid_price', $bid_price);?></td>
	</tr>
	<tr>
		<td class="main"><a href="java script:void(0);" onclick="NewWindow('<?php echo tep_href_link(FILENAME_AUCTION_TERMS); ?>','auction_terms','400','300','yes');return false"><?php echo CONDITIONS; ?>:</a></td>
		<td onclick="window.document.auction_bid.agree.checked = !window.document.auction_bid.agree.checked;" align="right" width="20px"><?php echo tep_draw_checkbox_field('agree','true', false, 'onclick="window.document.auction_bid.agree.checked = !window.document.auction_bid.agree.checked;"'); ?></td>
	</tr>
	<tr>
		<td colspan="2"><?php echo tep_image_submit('placebid.gif', IMAGE_BUTTON_PLACEBID); ?></td>
	</tr>
</table>
<!-- end of table_3 -->
</form>
<!-- end of form -->
</td>
<?php
} // end elseif ( $auction_product )
?>
<!-- eof added by jobonline2001@yahoo.com for auction product contribution -->
</td>
</tr>
</table>
</td>
</tr>
<!-- beg auction_bid_list -->
<tr>
<td class="main"><b><?php echo TEXT_AUCTIONS_BID_LIST; ?></b></td>
</tr>
<tr>
<td>
	<!-- beg of table_4 -->
	<table border="0" width="100%" cellspacing="0" cellpadding="0">
		<tr>
			<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2" >
				<tr class="productListing-heading" >
					<td class="productListing-heading"><?php echo TABLE_HEADING_NUMBER; ?></td>
					<td class="productListing-heading"><?php echo TABLE_HEADING_CUSTOMERS; ?></td>
					<td class="productListing-heading" align="center"><?php echo TABLE_HEADING_BID_PRICE; ?> </td>
					<td class="productListing-heading"><?php echo TABLE_HEADING_BID_DATE_ADDED; ?></td>
					<td class="productListing-heading" align="center"> </td>
				</tr>
<?php
if (isset($HTTP_GET_VARS['page']) && ($HTTP_GET_VARS['page'] > 1)) $rows = $HTTP_GET_VARS['page'] * MAX_DISPLAY_SEARCH_RESULTS - MAX_DISPLAY_SEARCH_RESULTS;
$products_query_raw = "select concat(c.customers_firstname, c.customers_lastname) as customers_name, c.customers_id, ab.bid_price, ab.bid_status, ab.bid_date_added from ".TABLE_CUSTOMERS." c, ".TABLE_AUCTIONS_BIDS.' ab,'.TABLE_AUCTIONS_PRODUCTS.' ap where c.customers_id = ab.customers_id and ab.auctions_id=ap.auctions_id and ab.auctions_id='.$auction_id.' order by bid_price DESC ';
$rows = 0;
$products_query = tep_db_query($products_query_raw);
while ($products = tep_db_fetch_array($products_query)) {
$rows++;
if (strlen($rows) < 2) {
	$rows = '0' . $rows;
}
?>
				<tr class="productListing-data" >
					<td class="productListing-data"><?php echo $rows; ?>.</td>
					<td class="productListing-data"><?php echo $products['customers_id']; ?></td>
					<td class="productListing-data" align="center"><?php echo $currencies->display_price($products['bid_price'], tep_get_tax_rate($products['products_tax_class_id']) ); ?> </td>
					<td class="productListing-data"><?php echo $products['bid_date_added']; ?></td>
					<td>
						<?php if ($products['bid_status']=='won') { echo tep_image(DIR_WS_ICONS.'auctionwon.gif',IMAGE_BUTTON_AUCTION_WON); }?>
					</td>
				</tr>
<?php
} // end while
?>
			</table>
			<!-- end of table_4 -->
		</td>
	</tr>
</table>
<!-- end of table_1 -->
</td>
</tr>
<!-- end auction_bid_list -->
<script type="text/javascript">
// beg TZCountDown //
// ****  Time Zone Count Down Javascript  **** //
/*
Visit http://rainbow.arch.scriptmania.com/scripts/
for this script and many more
*/

////////// CONFIGURE THE COUNTDOWN SCRIPT HERE //////////////////
// $datetime_count_down calculated by /includes/functions/general.php tep_date_count_down
var month = '<?php echo $datetime_count_down['1']; ?>'	 //  '*' for next month, '0' for this month or 1 through 12 for the month 
var day = '<?php echo "+".$datetime_count_down['2']; ?>';	   //  Offset for day of month day or + day  
var hour = '<?php echo $datetime_count_down['3']; ?>';		//  0 through 23 for the hours of the day
var tz = 0;		 //  Offset for your timezone in hours from UTC
var lab = 'countdown_date';	//  The id of the page entry where the timezone countdown is to show

function start() {displayTZCountDown(setTZCountDown(month,day,hour,tz),lab);}

// **	The start function can be changed if required   **
window.onload = start();

////////// DO NOT EDIT PAST THIS LINE //////////////////

function setTZCountDown(month,day,hour,tz) {
var toDate = new Date();
if (month == '*')toDate.setMonth(toDate.getMonth() + 1);
else if (month > 0) {
	if (month <= toDate.getMonth())toDate.setYear(toDate.getYear() + 1);
		toDate.setMonth(month-1);
}
if (day.substr(0,1) == '+') {
	var day1 = parseInt(day.substr(1));
	toDate.setDate(toDate.getDate()+day1-1);
}
else {
	toDate.setDate(day);
}
toDate.setHours(0);
toDate.setMinutes(0-(tz*60));
toDate.setSeconds(0);
var fromDate = new Date();
//fromDate.setMinutes(fromDate.getMinutes());
var diffDate = new Date(0);
diffDate.setMilliseconds(toDate - fromDate);
return Math.floor(diffDate.valueOf()/1000);
}

function displayTZCountDown(countdown,tzcd) {
if (countdown < 0) document.getElementById(tzcd).innerHTML = "Sorry, you are too late.";
else {
	var secs = countdown % 60; 
	if (secs < 10) secs = '0'+secs;
	var countdown1 = (countdown - secs) / 60;
	var mins = countdown1 % 60; 
	if (mins < 10) mins = '0'+mins;
	countdown1 = (countdown1 - mins) / 60;
	var hours = countdown1 % 24;
	var days = (countdown1 - hours) / 24;
	document.getElementById(tzcd).innerHTML = days + " <?php echo COUNTDOWN_DAYS; ?> " + (days == 1 ? '' : '<?php echo COUNTDOWN_SECS; ?>') + ' ' +hours+ '<?php echo COUNTDOWN_HOURS; ?>'+'  : ' +mins+ '<?php echo COUNTDOWN_MINS; ?> : '+secs+'<?php echo COUNTDOWN_SECS;?>';
	setTimeout('displayTZCountDown('+(countdown-1)+',\''+tzcd+'\');',999);
}
}
// end TZCountDown //
</script>

<!-- eof added by jobonline2001@yahoo.com for auction product contribution	  -->
<!-- end /includes/modules/auctions_bids.php -->

 

You should also check the functions in general.php ($datetime_count_down calculated by /includes/functions/general.php tep_date_count_down above)

Read your install.txt carefully. If the problem is still there, it may be located in product_info.php ( tricky stuff ).

 

Visit My dummy development Website

 

dimitryous

Edited by dimitryous

Share this post


Link to post
Share on other sites
7. Something needs to happen when the auction ends, either:

 

7.1) The product is added to the customers Shopping Cart with the correct price (I think this is the best method, and it's already halfway implemented in the current Auction version, although it doesn't work).

7.2) An order is created with the auction product, but the customer has to pay manually.

 

And preferably an email should be automatically sent to the winner.

 

8. Infobox (at the moment shows the newest auction, haven't been able to figure out how to show the auction that is closest to ending)

 

-Upload latest_auction.php to includes\boxes

 

-Open column_left.php or column_right.php and add:

require(DIR_WS_BOXES . 'latest_auction.php');

 

-In includes\languages\english.php (or translate to the language of your choice), add:

define('BOX_HEADING_AUCTON_LATEST', 'Latest Auction');

 

Hello,

 

I did'nt suceed to get latest_aution.php...

 

Someone has the code somewhere?

 

Thanks.

 

dimitryous.

Share this post


Link to post
Share on other sites

Sorry dimitryous, I forgot to post it here.

 

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2007 osCommerce

 Released under the GNU General Public License
*/
?>
<!-- latest_auction //-->
	  <tr>
		<td>
<?php

$auctions_query_box = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, a.auctions_starting_price, a.expires_date from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_AUCTIONS_PRODUCTS . " a where p.products_status = '1' and a.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and a.status = '1' order by expires_date DESC LIMIT 1";

 $info_box_contents = array();
 $info_box_contents[] = array('text' => BOX_HEADING_AUCTON_LATEST);

 new infoBoxHeading($info_box_contents, false, false);

$auctions_query = tep_db_query($auctions_query_box);
while ($auctions = tep_db_fetch_array($auctions_query)) {
 $info_box_contents = array();
 $info_box_contents[] = array('text' => '<div align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $auctions['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $auctions['products_image'], $auctions['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $auctions['products_id']) . '">' . $auctions['products_name'] . '</a><br>' .$currencies->display_price($auctions['auctions_starting_price'], tep_get_tax_rate($auctions['products_tax_class_id'])) . '<br><br><a href="auctions.php"><b>View All Auctions</a></b></div>');
  } 

new infoBox($info_box_contents);
?>
		</td>
	  </tr>
<!-- latest_auction //-->

Share this post


Link to post
Share on other sites
Sorry dimitryous, I forgot to post it here.

 

Thank you much for your code: ok.

 

I tried an " advanced search " and believe that advanced_search.php file need some modifications: I will try to pin-point where more exactly because the results may lead to confuse users (products are either " auctions products " or " regular products ").

The result - if orphan ( I mean only one product coming out of the search ) - should presents the relevant screen.

 

Thanks and keep on the good work.

 

_______________________________

L'esprit anime la main qui guide l'outil.

Share this post


Link to post
Share on other sites
You'll need this manual order maker contribution to do that. If you can activate an auction you are not missing anything inside the contrib package...

//Micke

( see page 7 of this topic )

 

Hello,

I just installed the above contribution but I get the following error:

404 Not Found

The requested URL /catalog/admin/FILENAME_ORDERS_EDIT was not found on this server.

 

FILENAME_ORDERS_EDIT = " some_code.php " not being defined in " /catalog/admin/includes/filenames.php " file...

This is due to line 154

tep_redirect(tep_href_link(FILENAME_ORDERS_EDIT, 'oID=' . $insert_id, 'SSL'));

in " /catalog/admin/create_order_process.php " near the end of the file...

 

Did I miss to download/upload a file?

 

Some help, please otherwise all collapse.

 

TIA

Edited by dimitryous

Share this post


Link to post
Share on other sites

@dimitryous: Insert this into filenames.php in admin\includes

 

define('FILENAME_ORDERS_EDIT', 'edit_orders.php');

Share this post


Link to post
Share on other sites
@dimitryous: Insert this into filenames.php in admin\includes

 

define('FILENAME_ORDERS_EDIT', 'edit_orders.php');

 

Hello,

Thanks a lot but I still miss something:

404 File Not Found

" The requested URL /catalog/admin/edit_orders.php was not found on this server. "

 

I'm a little bit confused to disturb you but would like my stuff to work.

 

TIA

Share this post


Link to post
Share on other sites
Hello,

Thanks a lot but I still miss something:

404 File Not Found

" The requested URL /catalog/admin/edit_orders.php was not found on this server. "

 

I'm a little bit confused to disturb you but would like my stuff to work.

 

TIA

 

I printed this entire topic to get a .pdf file, performed a global search of " edit_orders ": no result.

Share this post


Link to post
Share on other sites
@dimitryous: Insert this into filenames.php in admin\includes

 

define('FILENAME_ORDERS_EDIT', 'edit_orders.php');

 

Hello,

I got all the stuff working fine now. It was a little bit difficult because of the use of order editor contribution

 

I finally conclude that ( at least in my case ) :

 

1- admin is requested to place a manual order for the winner of the auction: an e-mail is sent to the winner

2- the winner is invited to log-in and complete his order

 

Is the above correct?

 

Thank you.

Share this post


Link to post
Share on other sites

Hi all,

 

I've corrected some errors within the auction module and uploaded v1.4.4 today !

 

- corrected the countdown-script for users with Internet Explorer

- corrected the checkbox 'Agree with terms'. Now you HAVE to click on the checkbox to bid.

 

Marcus

Share this post


Link to post
Share on other sites
Hello,

I got all the stuff working fine now. It was a little bit difficult because of the use of order editor contribution

 

I finally conclude that ( at least in my case ) :

 

1- admin is requested to place a manual order for the winner of the auction: an e-mail is sent to the winner

2- the winner is invited to log-in and complete his order

 

Is the above correct?

 

Thank you.

 

Hi dimitryous,

As i see on your test page you have a fix for the following problems?

 

2. Overbid Amount does not work.

3. Time when the Auction ends needs to be able to be set

Date bid added to be shown in real time, not 0000-00-...

 

It would be a real help for me if you could let me know how did you fixed the problem with Date bid added to be shown in real time.

Share this post


Link to post
Share on other sites

Excelent idea that needs more work.

 

 

1. it has SQL injection risks.

you need to make sure you clean the data from the URL before you insert it into your database as a query.

 

like:

 

$mfo_auction_query = mysql_fetch_object(tep_db_query('select auctions_starting_price, expires_date, overbid_amount from ' . TABLE_AUCTIONS_PRODUCTS . ' where products_id = ' . $_GET['products_id'] . ' and status'));

2. it has many bugs in implementation and design.

For instance, If you use a module to make some of the code why not use two modules to make product_info as clean as possible.

 

 

3. Timestamp is not saved in the bid, mistakes with table names, forgotten code parts.

fixed:

 

$sql_auction = "insert into ".TABLE_AUCTIONS_BIDS." (auctions_bids_id, auctions_id,customers_id,bid_price,bid_status, bid_date_added) values('','$auction_id','$customers_id','$bid_price', '', now())";

thanks

I hope to add some bug fixes to this post.

Share this post


Link to post
Share on other sites
3. Timestamp is not saved in the bid, mistakes with table names, forgotten code parts.

fixed:

 

$sql_auction = "insert into ".TABLE_AUCTIONS_BIDS." (auctions_bids_id, auctions_id,customers_id,bid_price,bid_status, bid_date_added) values('','$auction_id','$customers_id','$bid_price', '', now())";

 

I've tryed the code above this way:

 

INSERT INTO `table_auction_bids` (`auctions_bids_id`, `auctions_id`, `customers_id`, `bid_price', `bid_status`, `bid_date_added`) VALUES (``,`$auction_id`,`$customers_id`,`$bid_price`, ``, now());

 

But the mysql gives an error:

ERROR: Unclosed quote @ 182

 

Wheare is that unclosed quote?

Share this post


Link to post
Share on other sites
I've tryed the code above this way:

INSERT INTO `table_auction_bids` (`auctions_bids_id`, `auctions_id`, `customers_id`, `bid_price', `bid_status`, `bid_date_added`) VALUES (``,`$auction_id`,`$customers_id`,`$bid_price`, ``, now());

But the mysql gives an error:

ERROR: Unclosed quote @ 182

Wheare is that unclosed quote?

 

 

 

show me the exact code and not only the query.

Share this post


Link to post
Share on other sites

Sorry, which code do you mean? I've tryed only this query in mysql.

Is there anything else to change in one of the php files?

Share this post


Link to post
Share on other sites

Hello folks, and congrats on a great script, i have come from CRELoaded land, and have even ported this contrib to work with CRE 6.2, i have only one problem? I had the script working for a few moments and can not figure what i did wrong to get it un-working? If I remember correctly at the time of working there was an html error with the layout ( a <table> or <td> or similar) well i got it straightened out and later on after many more edits i realized it was not working, the Place Bid button just adds the item to the cart, and i have no idea what i might have done to the script or related files to cause it's undoing??? you can view the test here: Techinfoline Test Auctions, i will set an auction that does not expire for someone to help with it please. I will continue to test and see if i get anywhere? If you guys could help at all it would be greatly appreciated :)


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

Best Regards,

 

ggbig (maestro)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×