Jump to content
Sign in to follow this  
FWR Media

auctionTastic

Recommended Posts

Help needed. I'm assuming that this is where I post. I just installed the Auctiontastic contribution but it's not working. The "Auction Products" shows up in the admin section, but when I click on it I get the following:

 

1146 - Table 'coruscan_p_os1.auctions' doesn't exist

 

select count(*) as total from products p, auctions a, products_description pd where p.products_id = pd.products_id and a.products_id = p.products_id and pd.language_id = '1' and p.products_id = a.products_id

 

[TEP STOP]

 

 

I don't recall seeing an sql add in. Also, I ran the installer.php and it showed that everything was fine. Am I missing something?

 

Thanks,

Mike

 

No if you ran the installer then everything should be in place in the database .. but it isn't, you don't have an auctions table .. someone must have dropped it by mistake.

Share this post


Link to post
Share on other sites

Will you upload the latest version of auctionTastic on osCommerce contributions?

 

Thanks.

 

ldon

Share this post


Link to post
Share on other sites

Will you upload the latest version of auctionTastic on osCommerce contributions?

 

Thanks.

 

ldon

 

Yes, when there is one.

Share this post


Link to post
Share on other sites

Nothing new since 28 May 2009?

 

Yes plenty .. just nothing new here.

Share this post


Link to post
Share on other sites

:D , and are you still working on it?

 

Not seen any point in upgrading .. no bugs that I've seen.

Share this post


Link to post
Share on other sites

Not seen any point in upgrading .. no bugs that I've seen.

 

What about my neverending problem? :'(

 

1.let's say I've got 25 products in stock.

 

2. One of 25 products added to auction

3. Few bids on the product

4. All 25 products were bought before the auction has ended - BUY NOW

5. The product is out of stock

6. Auction ended – the product added to shopping cart of the winning bidder

7. The winning bidder received a winner e-mail

8. Click on a link - log in

9. The winner can’t pay for the product because it is out of stock and he’s not able to pay for it so he decided to buy another product as buy now

10. He still can’t go true checkout process because in his shopping cart is product from ended auction and he can’t finish the checkout process and he can’t remove the auction product out from his shopping cart..

 

 

???

 

I think this is the point which makes the auction not PRO.

 

And one more question.

 

Can you have a look on http://www.oscommerce.com/community/contributions,1237/category,all/search,anti+robot

This seems to be a good idea but it doesn't work at all.

 

First problem was to instal sql but after small changes I've done it.

Now I've got error 'Missing SID, please refresh borwser'

In IE 8 doesn't work alternate view.

 

Cheers :thumbsup:

Share this post


Link to post
Share on other sites

What about my neverending problem? :'(

 

1.let's say I've got 25 products in stock.

 

2. One of 25 products added to auction

3. Few bids on the product

4. All 25 products were bought before the auction has ended - BUY NOW

5. The product is out of stock

6. Auction ended – the product added to shopping cart of the winning bidder

7. The winning bidder received a winner e-mail

8. Click on a link - log in

9. The winner can’t pay for the product because it is out of stock and he’s not able to pay for it so he decided to buy another product as buy now

10. He still can’t go true checkout process because in his shopping cart is product from ended auction and he can’t finish the checkout process and he can’t remove the auction product out from his shopping cart..

 

 

???

 

I think this is the point which makes the auction not PRO.

 

And one more question.

 

Can you have a look on http://www.oscommerce.com/community/contributions,1237/category,all/search,anti+robot

This seems to be a good idea but it doesn't work at all.

 

First problem was to instal sql but after small changes I've done it.

Now I've got error 'Missing SID, please refresh borwser'

In IE 8 doesn't work alternate view.

 

Cheers :thumbsup:

 

:blink:

 

The first thing was a request by you alone . .I don't upgrade for individual requests unless I feel there is a significant and universal benefit.

 

The second point is nothing to do with me whatsoever.

Edited by FWR Media

Share this post


Link to post
Share on other sites

:blink:

 

The first thing was a request by you alone . .I don't upgrade for individual requests unless I feel there is a significant and universal benefit.

 

The second point is nothing to do with me whatsoever.

 

 

"The first thing"

So if just one person will send you a bug, you not going to fix it until more people will do the same?

If not, can you fix it for me please? I do not understand why you don't want to do it.

 

"The second point"

I know, it was just call of favour.

 

:rolleyes:

Share this post


Link to post
Share on other sites

"The first thing"

So if just one person will send you a bug, you not going to fix it until more people will do the same?

If not, can you fix it for me please? I do not understand why you don't want to do it.

 

I don't see it as a bug as I've mentioned before.

Share this post


Link to post
Share on other sites

I don't see it as a bug as I've mentioned before.

 

:thumbsup:

But can you just make an option in admin to do not display auction item in categories please?

This will prevent all (I think not just my) troubles.

 

Thank you.

Share this post


Link to post
Share on other sites

Yes, when there is one.

 

 

Total problem with auction.

 

Everything was all right until I allowed Tax for prices. Now I've got a big problem.

When auction is ended biggest auction price is different from subtotal price.

 

Subtotal price is actually original product price.

 

Can anybody help me?

 

Thanks

Share this post


Link to post
Share on other sites

Total problem with auction.

 

Everything was all right until I allowed Tax for prices. Now I've got a big problem.

When auction is ended biggest auction price is different from subtotal price.

 

Subtotal price is actually original product price.

 

Can anybody help me?

 

Thanks

 

I'll test this over the weekend.

Share this post


Link to post
Share on other sites

I'll test this over the weekend.

 

I've done a new installation of oscommerce and then auctionTastic and the problem is there.

Highest bit price is different from price in my shopping basket. (After auction was ended).

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.

Share this post


Link to post
Share on other sites

I'll test this over the weekend.

 

On fresh installation:

 

SHOPPING CART after auction ended

 

Product: Speed (WON in auction)

Price: Total = $2 (auction highest bid)

Sub-Total = $41.99 (original price)

 

Why is sub-total different from auction highest bid?

Share this post


Link to post
Share on other sites

Hi ldon,

 

I read the post from start bis end (...)

Hummm first u are right ldon but FWmedia work too much but we remerciate alls for this work, thank u buddy.

 

 

so ldon, go and catalog/includes/classes/shopping_cart.php

 

find, line approximativ 271->285

 

          // 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);
       }

 

and replace with :

 

          // 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->weight += ($qty * $products_weight);
         }else{
         $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);
         }
         // EOF AUCTIONS

 

And THE FIRST BIG BUGS FROM THIS CONTRIB WERE RESOLV....YOU MIND ?

 

in PHP (+=) + (+=) = ++==

Share this post


Link to post
Share on other sites

If you make take advantage and open oscAuction.php classes

 

change

 

  /**
 * includes/boxes/categories.php
 * 
 * @param mixed $info_box_contents
 */
 function categoriesAdd(&$info_box_contents){ 

   $info_box_contents[] = array('text' => '<a href="'.tep_href_link(FILENAME_AUCTIONS).'" >' . AUCTIONS_AUCTION_PRODUCTS . '</a>');
   return $info_box_contents;  
 }

 

To

 

 /**
 * includes/boxes/categories.php
 * 
 * @param mixed $info_box_contents
 */
 function categoriesAdd(&$info_box_contents){ 
//if ($this->count_available_auctions)
$auctions_count = 0;
     $auctions_query = tep_db_query("SELECT COUNT(auctions_id) as total FROM " . TABLE_AUCTIONS . " WHERE status = '1' and expires_date > '" .  date("Y-m-d H:i:s") . "'");

   $auctions = tep_db_fetch_array($auctions_query);
   $auctions_count += $auctions['total'];
   $info_box_contents[] = array('text' => '<a href="'.tep_href_link(FILENAME_AUCTIONS).'" >' . AUCTIONS_AUCTION_PRODUCTS . '</a>' .' ('. $auctions_count . ')');
   return $info_box_contents;  
 }

 

You will find a fine counter in you categories menu...

 

Take more advantage if you check some date("Y-M-d ... To date("Y-m-d in sql request example..

 

;)

 

ALL RESOLV ARE FOR ms2.2/rc2.2a

+++++++++++++++++++++++++++++++

 

;)

Edited by PiBo

Share this post


Link to post
Share on other sites

Hi ldon,

 

I read the post from start bis end (...)

Hummm first u are right ldon but FWmedia work too much but we remerciate alls for this work, thank u buddy.

 

 

so ldon, go and catalog/includes/classes/shopping_cart.php

 

find, line approximativ 271->285

 

          // 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);
       }

 

and replace with :

 

          // 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->weight += ($qty * $products_weight);
         }else{
         $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);
         }
         // EOF AUCTIONS

 

And THE FIRST BIG BUGS FROM THIS CONTRIB WERE RESOLV....YOU MIND ?

 

in PHP (+=) + (+=) = ++==

 

Thank you PiBo.

 

And do you know to sort out my other problem?

 

1.let's say I've got 25 products in stock.

 

2. One of 25 products added to auction

3. Few bids on the product

4. All 25 products were bought before the auction has ended - BUY NOW

5. The product is out of stock

6. Auction ended – the product added to shopping cart of the winning bidder

7. The winning bidder received a winner e-mail

8. Click on a link - log in

9. The winner can’t pay for the product because it is out of stock and he’s not able to pay for it so he decided to buy another product as buy now

10. He still can’t go true checkout process because in his shopping cart is product from ended auction and he can’t finish the checkout process and he can’t remove the auction product out from his shopping cart..

 

 

???

 

I think this is the point which makes the auction not PRO.

Edited by ldon

Share this post


Link to post
Share on other sites

Thank you PiBo.

 

And do you know to sort out my other problem?

 

1.let's say I've got 25 products in stock.

 

2. One of 25 products added to auction

3. Few bids on the product

4. All 25 products were bought before the auction has ended - BUY NOW

5. The product is out of stock

6. Auction ended – the product added to shopping cart of the winning bidder

7. The winning bidder received a winner e-mail

8. Click on a link - log in

9. The winner can’t pay for the product because it is out of stock and he’s not able to pay for it so he decided to buy another product as buy now

10. He still can’t go true checkout process because in his shopping cart is product from ended auction and he can’t finish the checkout process and he can’t remove the auction product out from his shopping cart..

 

 

???

 

I think this is the point which makes the auction not PRO.

 

 

Anybody else can help with this solution please?

Share this post


Link to post
Share on other sites

I installed this contribution and it seems to work fine other than a few issues im having.

 

1. auction info isnt showing in "my account" for members who have bid

2. Is there suppose to be a "buy now" button on the auction page?

3. im getting an error for the auction terms when clicking the link.

Fatal error: Class 'infoBoxheading' not found in /home/bryn28/public_html/auction_terms.php on line 40

4. Is there a way to control bidding increments? It seems to be whatever the starting bid is, is what the minimum bidding is going to be.

 

im still testing but these are some issues ive come across so far....how can I fix these? thanks

Share this post


Link to post
Share on other sites

can anyone tell me how to fix bidding increments?

 

example: auction starting price : 5.00

overbid amount :2.00

 

bid price = $6.71 instead of $7.00

 

any ideas?

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  

×