Jump to content
Sign in to follow this  
FWR Media

auctionTastic

Recommended Posts

Local code?

 

Other contributions were added where the auction is also. Is that what you mean?

 

What I mean is that it views properly on a fresh install so the problem must be with the code on your site.

Share this post


Link to post
Share on other sites

Hi Robert,

 

The RC1 release works really well. I have a couple things I noticed though.

 

1) Even though I put an increment amount of 1.00 in the auction listing setup, the increment amount seems to default to .54 cents. ???

 

2) The auction date and time do not correspond to my site date and time. ( Auctions are ending 6 hrs before the scheduled time ) ??

 

 

Any ideas about why these to things might happen ?

 

Thanks

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites
Hi Robert,

 

The RC1 release works really well. I have a couple things I noticed though.

 

1) Even though I put an increment amount of 1.00 in the auction listing setup, the increment amount seems to default to .54 cents. ???

 

2) The auction date and time do not correspond to my site date and time. ( Auctions are ending 6 hrs before the scheduled time ) ??

 

 

Any ideas about why these to things might happen ?

 

Thanks

 

Chris

 

The time thing.

 

Look in two files ..

 

1) catalog/includes/modules/auctions/classes/oscAuctions.php

 

and change var $timeZone = 'Europe/London';

 

2) admin/auctions.php change ..

$timeZone = 'Europe/London';

 

Never heard of the increment thing, I'll have a think on it.

Share this post


Link to post
Share on other sites

Thanks Robert, I will look at the time zone location. Is there a currency code hard coded in the contribution or does it call on the default currency set in the admin ?

 

I was just thinking perhaps it is doing a currency exchange.

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites
Thanks Robert, I will look at the time zone location. Is there a currency code hard coded in the contribution or does it call on the default currency set in the admin ?

 

I was just thinking perhaps it is doing a currency exchange.

 

 

Chris

 

Currency is as set in admin, certainly not hardcoded.

Share this post


Link to post
Share on other sites

Hi Robert,

 

I originally thought the bid increment was set at .54 cents. However, I have been testing the contribution and found that the increment rate is not set at all. It varies depending on item. For example I have set it to 1.00 increment, and a .99 cent starting price. It tells me the minimum bid amount is 1.99 but when I accept the terms and conditions and click "Place Bid" it shows the current price as 1.76. Very confusing.

 

This is on a live site, if you wish to look at it you can log into www<dot>thehotfish<dot>com and create an account to see what I am talking about. Any suggestions would be greatly appreciated.

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites
Hi Robert,

This is on a live site, if you wish to look at it you can log into www<dot>thehotfish<dot>com and create an account to see what I am talking about. Any suggestions would be greatly appreciated.

Chris

I'm curious, I just went to your website. I installed this contribution as well but a person does not have to login to see the prices or the bidders. Is this an added contribution ?

Share this post


Link to post
Share on other sites

Hi Letty,

 

Yes, the owner wanted prices visible to logged in customers only.

 

The contribution used was this one:

 

http://addons.oscommerce.com/info/601

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

Hi Robert,

 

Another question. Has Auctiontastic ever been tested with any of the discount coupon code contributions. ??? The site I mentioned above has a DCC contribution installed and it disables the codes. Which is a good thing for auction items, but not for the rest of the store. It may also have something to do with the increment amount maybe. I am still testing.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites
auctionTastic

 

Create multiple product auctions in osCommerce

 

Originally based on another auction contribution (credits.txt included) this is a total rewrite due to the original having unworkable code. At 27 odd files this is quite a large contribution although changes to core files has been kept to very very little.

 

Full instructions are included:

 

Package includes: -

  • Auto Installer
  • Upload folder (contains all files new to oscommerce)
  • Modified files folder (files where we are modifying oscommerce code)
  • Documentation folder (install instructions including manual file changes - new code syntax highlighted)

 

Features:-

 

  • Multiple auction products
  • Products with attributes can be auctioned
  • Products can be bought as normal even if auctioned
  • Standard product price shown above auction price (including addition of attributes value)
  • product info page refresh options in admin
  • My Auction view in My Account
  • Inform current highest bidders of new bids
  • Inform winning bidders at end of auction
  • Product added to cart of winning bidder at end of auction (Can't be removed by them)
  • Valid HTML (I hope)
  • Compatible with PHP4/5 MySQL4/5
  • Error free (error_reporting(E_ALL))
  • Compatible with .. RC2a (lower probably will work but untested)

 

Feedback and bug reports appreciated as always.

 

The files are http://addons.oscommerce.com/info/6431

 

The contribution is set so that no others can add packages this is to maintain some quality. This does not stop users from making suggestions here that could be integrated into a later release.

 

Finally I wanted to mention that this was not built by design it started off as a customer asking me to install another auctions contrib, the further I went into it the clearer it became that the previous contribution just couldn't work with the code in place, before I knew it I wasn't just changing code I was rewriting it . . the code would have been a lot better if planned from the start but it seems relatively solid.

 

 

Hi,

I would like to have a special kind of auction in which each one can make a bid the nearest possible to a maximum price (defined for each prduct) but which can cancel the bid of someone else or be canceled if someone make the same bid. At the end of the auction (a time should be defined for the auction), if the minimum quantity of bids was reach, the nearest bid which was not canceled takes the product. Making a bid has a cost even if it was canceled.

Is it possible to add this mode in auctiontastic ?

Thanks a lot.

Share this post


Link to post
Share on other sites

Hi!

Thank you for this great contribution!

I just want to know if it's possible to have all the auctions on the front/main page. So the website opens with the Auctions category?

 

Thanks in advance!

ps: I have translated auctions_general.php into Dutch if you're interested. I'm still working on auction_terms.php

Share this post


Link to post
Share on other sites

Is it any chance you will rewrite this auction scripts for osCommerce Online Merchant v3.0 Alpha 5?

Share this post


Link to post
Share on other sites
Is it any chance you will rewrite this auction scripts for osCommerce Online Merchant v3.0 Alpha 5?

 

None whatsoever .. v3.0 is years from being ready to use as a live cart.

Share this post


Link to post
Share on other sites

Hi FWR,

 

Its been long time to discuss on this.

 

Today i notice a strange thing i thought to consult with you.

 

While auction we have validation function validate(form)

 

I am worried because on some particular situation my condition code not worked / or disabled or something.....

 

do you have any visibility of such situations.......

Share this post


Link to post
Share on other sites
Hi FWR,

 

Its been long time to discuss on this.

 

Today i notice a strange thing i thought to consult with you.

 

While auction we have validation function validate(form)

 

I am worried because on some particular situation my condition code not worked / or disabled or something.....

 

do you have any visibility of such situations.......

 

 

// Check to see if bid_price has any data

if(document.auction_bid.bid_price.value==''){

alert('<?php echo AUCTIONS_JS_BIDS_EMPTY_INPUT; ?>');

return false;

}

 

It seems 'document.auction_bid.bid_price.value' not been checked...........is this due to some browser issue.......plz suggest.....

Share this post


Link to post
Share on other sites

Hello Guys!

 

I managed to install this contribution in a 2002 osc! GREAT WORK!

 

I think that I have found a Possible bug, I had no time to go through this entire topic in this forum.

If this is a known issue, please ignore.

 

in file

/includes/classes/shopping_cart.php

 

code:

 

// BOF AUCTIONS

if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){

$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');

}

 

$this->total += tep_add_tax($products_price, $products_tax) * $qty;

 

should be:

 

// BOF AUCTIONS

if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){

$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');

}

else

$this->total += tep_add_tax($products_price, $products_tax) * $qty;

 

 

Thanks

D

Share this post


Link to post
Share on other sites
Hello Guys!

 

I managed to install this contribution in a 2002 osc! GREAT WORK!

 

I think that I have found a Possible bug, I had no time to go through this entire topic in this forum.

If this is a known issue, please ignore.

 

in file

/includes/classes/shopping_cart.php

 

code:

 

// BOF AUCTIONS

if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){

$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');

}

 

$this->total += tep_add_tax($products_price, $products_tax) * $qty;

 

should be:

 

// BOF AUCTIONS

if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){

$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');

}

else

$this->total += tep_add_tax($products_price, $products_tax) * $qty;

 

 

Thanks

D

 

Don't know which version you are looking at but in mine ..

 

Replace with ...

		  $products_weight = $product['products_weight'];
	  // BOF AUCTIONS
	  if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){
		$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');
	  }
	  // EOF AUCTIONS

 

The second $this->total += doesn't exist.

Share this post


Link to post
Share on other sites
Don't know which version you are looking at but in mine ..

 

Replace with ...

		  $products_weight = $product['products_weight'];
	  // BOF AUCTIONS
	  if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){
		$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');
	  }
	  // EOF AUCTIONS

 

The second $this->total += doesn't exist.

 

 

I am looking at the latest version.

several lines bellow your new code

 

I marked the line in underline bold italic red :-)

 

 

function calculate() {

global $currencies;

 

$this->total = 0;

$this->weight = 0;

if (!is_array($this->contents)) return 0;

 

reset($this->contents);

while (list($products_id, ) = each($this->contents)) {

$qty = $this->contents[$products_id]['qty'];

 

// products price

$product_query = tep_db_query("select products_id, products_price, products_tax_class_id, products_weight from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'");

if ($product = tep_db_fetch_array($product_query)) {

$prid = $product['products_id'];

$products_tax = tep_get_tax_rate($product['products_tax_class_id']);

$products_price = $product['products_price'];

$products_weight = $product['products_weight'];

// BOF AUCTIONS

if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){

$this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');

}

// EOF AUCTIONS

 

$specials_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . (int)$prid . "' and status = '1'");

if (tep_db_num_rows ($specials_query)) {

$specials = tep_db_fetch_array($specials_query);

$products_price = $specials['specials_new_products_price'];

}

 

$this->total += $currencies->calculate_price($products_price, $products_tax, $qty);

$this->weight += ($qty * $products_weight);

}

 

// attributes price

if (isset($this->contents[$products_id]['attributes'])) {

reset($this->contents[$products_id]['attributes']);

while (list($option, $value) = each($this->contents[$products_id]['attributes'])) {

$attribute_price_query = tep_db_query("select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$prid . "' and options_id = '" . (int)$option . "' and options_values_id = '" . (int)$value . "'");

$attribute_price = tep_db_fetch_array($attribute_price_query);

if ($attribute_price['price_prefix'] == '+') {

$this->total += $currencies->calculate_price($attribute_price['options_values_price'], $products_tax, $qty);

} else {

$this->total -= $currencies->calculate_price($attribute_price['options_values_price'], $products_tax, $qty);

}

}

}

}

}

Share this post


Link to post
Share on other sites

Another approach to order completion

this way almost no files are changed on the core OSC code

this is just a sample not a complete code

 

 

1. force all bidding users to enter credit card info before bidding.

2. When the auction is closed create an order

3. delete all non winning customers credit card details

 

 

 

function tep_create_auction_order($auction_id)

{

 

global $currencies, $languages_id;

 

 

// ================================================================================

=

$auction_data_query = tep_db_query("select * from auctions where auctions_id='".(int)$auction_id . "'");

$auction_data_row = tep_db_fetch_array($auction_data_query);

$customer_id = $auction_data_row['auctions_high_cust'];

$auction_closed_time = $auction_data_row['expires_date'];

$auction_produtcs_id = $auction_data_row['products_id'];

$auction_produtcs_price = $auction_data_row['auctions_max'];

$auction_shipp_handle_price = $auction_data_row['auctions_shipp_handle_price'];

 

$customer_data_query = tep_db_query("select * from customers where customers_id='".(int)$customer_id . "'");

$customer_data_row = tep_db_fetch_array($customer_data_query);

$customers_default_address_id = $customer_data_row['customers_default_address_id'];

 

$customer_address_query = tep_db_query("select * from address_book where address_book_id='".$customers_default_address_id."' and customers_id='".(int)$customer_id . "'");

$customer_address_row = tep_db_fetch_array($customer_address_query);

 

$product_data_query = tep_db_query("select products_name from products_description where language_id='".$languages_id."' and products_id='".(int)$auction_produtcs_id . "'");

$product_data_row = tep_db_fetch_array($product_data_query);

$auction_product_name = $product_data_row['products_name'];

 

// ================================================================================

=

$sql_data_array = array('customers_id' => $customer_id,

'customers_name' => $customer_data_row['customers_firstname'] . ' ' . $customer_data_row['customers_lastname'],

'customers_street_address' => $customer_address_row['entry_street_address'],

'customers_city' => $customer_address_row['entry_city'],

'customers_postcode' => $customer_address_row['entry_postcode'],

'customers_state' => $customer_address_row['entry_state'],

'customers_country' => $customer_address_row['entry_country_id'],

'customers_telephone' => $customer_data_row['customers_telephone'],

'customers_email_address' => $customer_data_row['customers_email_address'],

'customers_address_format_id' => 1,

'delivery_name' => $customer_data_row['customers_firstname'] . ' ' . $customer_data_row['customers_lastname'],

'delivery_street_address' => $customer_address_row['entry_street_address'],

'delivery_city' => $customer_address_row['entry_city'],

'delivery_postcode' => $customer_address_row['entry_postcode'],

'delivery_state' => $customer_address_row['entry_state'],

'delivery_country' => $customer_address_row['entry_country_id'],

'ip_address' => "TBD",

'delivery_address_format_id' => 1,

'date_purchased' => $auction_closed_time,

'orders_status' => 2,

'currency' => "ILS",

'currency_value' => '1');

 

tep_db_perform(TABLE_ORDERS, $sql_data_array);

$insert_id = tep_db_insert_id();

 

// ================================================================================

=

$sql_data_array = array('orders_id' => $insert_id,

'new_value' => $new_value,

'date_added' => 'now()');

tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array);

 

// ================================================================================

=

$sql_data_array = array('orders_id' => $insert_id,

'products_id' => $auction_produtcs_id,

'products_tax' => '0',

'products_quantity' => '1',

'products_name' => 'æëéä áîëøæ (î÷"è '.$auction_produtcs_id .") " . $auction_product_name,

'products_price' => $auction_produtcs_price,

'final_price' => $auction_produtcs_price,

'products_stock_attributes' => '');

tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);

 

// ================================================================================

=

$sql_data_array = array('orders_id' => $insert_id,

'title' => "Sub total:",

'text' => $currencies->display_price($auction_produtcs_price, 0),

'value' => $auction_produtcs_price,

'class' => "ot_subtotal",

'sort_order' => "1");

tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);

 

// ================================================================================

=

$sql_data_array = array('orders_id' => $insert_id,

'title' => "Shipping & Handling:",

'text' => $currencies->display_price($auction_shipp_handle_price, 0),

'value' => $auction_shipp_handle_price,

'class' => "ot_custom",

'sort_order' => "2");

tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);

 

// ================================================================================

=

 

$total_amount = $auction_produtcs_price + $auction_shipp_handle_price;

 

$sql_data_array = array('orders_id' => $insert_id,

'title' => "Total:",

'text' => $currencies->display_price($total_amount, 0),

'value' => $total_amount,

'class' => "ot_total",

'sort_order' => "4");

tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);

 

// ================================================================================

=

 

// update order attributes

// update auction - order created successfully

 

}

Share this post


Link to post
Share on other sites
I am looking at the latest version.

several lines bellow your new code

 

I marked the line in underline bold italic red :-)

Hi,

you are right.

 

Find ...

// BOF AUCTIONS
         if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){
           $this->total += $currencies->calculate_price($this->contents[$products_id]['auction_price'], $products_tax, '1');
         }
// EOF AUCTIONS

and replace with

// BOF AUCTIONS
         if( isset($this->contents[$products_id]['auction_id']) && $this->contents[$products_id]['auction_id'] > '0' ){
           $products_price = $this->contents[$products_id]['auction_price'];
           $qty = '1';
         }
// EOF AUCTIONS

It will works ...

Share this post


Link to post
Share on other sites
auctionTastic

 

Create multiple product auctions in osCommerce

 

Originally based on another auction contribution (credits.txt included) this is a total rewrite due to the original having unworkable code. At 27 odd files this is quite a large contribution although changes to core files has been kept to very very little.

 

Full instructions are included:

 

Package includes: -

  • Auto Installer
  • Upload folder (contains all files new to oscommerce)
  • Modified files folder (files where we are modifying oscommerce code)
  • Documentation folder (install instructions including manual file changes - new code syntax highlighted)

 

Features:-

 

  • Multiple auction products
  • Products with attributes can be auctioned
  • Products can be bought as normal even if auctioned
  • Standard product price shown above auction price (including addition of attributes value)
  • product info page refresh options in admin
  • My Auction view in My Account
  • Inform current highest bidders of new bids
  • Inform winning bidders at end of auction
  • Product added to cart of winning bidder at end of auction (Can't be removed by them)
  • Valid HTML (I hope)
  • Compatible with PHP4/5 MySQL4/5
  • Error free (error_reporting(E_ALL))
  • Compatible with .. RC2a (lower probably will work but untested)

 

Feedback and bug reports appreciated as always.

 

The files are http://addons.oscommerce.com/info/6431

 

The contribution is set so that no others can add packages this is to maintain some quality. This does not stop users from making suggestions here that could be integrated into a later release.

 

Finally I wanted to mention that this was not built by design it started off as a customer asking me to install another auctions contrib, the further I went into it the clearer it became that the previous contribution just couldn't work with the code in place, before I knew it I wasn't just changing code I was rewriting it . . the code would have been a lot better if planned from the start but it seems relatively solid.

 

how do I run the installer using EasyPHP?

Share this post


Link to post
Share on other sites

I have quite a few auctions on our website. Is there a way to set a "flag" for the administrator NOT to add another auction for the same product ? This contribution does not support multiple auctions for the same product but it appears I can add multiple auctions for the same product.

ANy assistance as always is greatly appreciated.

Share this post


Link to post
Share on other sites

In admin/configuration/Auction Listing I have set the end of auction listing to 0 - meaning auction goes inactive - disappearing totally. This indeed happens when there is a bid - the information stays listed in admin and in the highest bidder account.

 

HOWEVER - when there are no bids on the auction, it does not disappear ???

 

Can someone verify for me please. Thank you for your time in advance.

Share this post


Link to post
Share on other sites
Is anyone still monitoring this contribution that can help me out with above two questions ?

 

Yes I am monitoring this.

 

I am a bit slower these days as Hotmail in their infinate wisdom have stopped outlook express downloading emails when I press Send/Recv this means that to see if I have received posts to any support threads I am monitoring I have to physically go to hotmail.com.

 

Re: Point one, there is no functionality at this stage to suppress such auctions.

 

Re: point 2 .. no I did not realise this I will try to replicate it and come back.

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  

×