Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

auctionTastic


FWR Media

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.

Link to comment
Share on other sites

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

 

Thanks.

 

ldon

 

Yes, when there is one.

Link to comment
Share on other sites

Nothing new since 28 May 2009?

 

Yes plenty .. just nothing new here.

Link to comment
Share on other sites

:D , and are you still working on it?

 

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

Link to comment
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:

Link to comment
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
Link to comment
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:

Link to comment
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.

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

  • 3 weeks later...

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

Link to comment
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.

Link to comment
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).

Link to comment
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.

Link to comment
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?

Link to comment
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 (+=) + (+=) = ++==

Link to comment
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
Link to comment
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
Link to comment
Share on other sites

  • 2 weeks later...

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?

Link to comment
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

Link to comment
Share on other sites

  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...