marcinmf

Members
  • Content count

    37
  • Joined

  • Last visited

Community Reputation

0 Neutral

About marcinmf

  • Birthday 06/07/1982

Profile Information

  • Real Name
    Martin Filipowicz
  • Gender
    Male
  • Location
    New York

Contact Methods

  1. First you will have to get the time remaining, break it apart and create: $hours, $minutes, $seconds, $month, $day, $year And this should create your new ending time return date('Y-m-d H:i:s', mktime($hours, $minutes, $seconds + '30', $month, $day, $year)); You could define time first for configuration purpose: $_amount = '30'; return date('Y-m-d H:i:s', mktime($hours, $minutes, $seconds + $_amount, $month, $day, $year)); //this will print $insertmenow = date('Y-m-d H:i:s', mktime($hours, $minutes, $seconds + $_amount, $month, $day, $year)); // this is ready insert I did not test that, this is just the logic how to approach that.
  2. I do auction just simple cheap items and they do not have any attribute choice. If I would add one the selection would be hidden and product without attribute will be added to the cart. I see that attribute could be problematic, does your auction shave this option? Logically customer before bidding will have to choose their selection and there should be some validation to check if they really did select or not. I have some validation in my store, one of the selection option is “-select-”, if that is selected it gives warning that nothing was selected and customer is being forced to make selection. If you don’t have the attribute feature it will require some additional DB field that will contain customer selection of the attribute. When auction is won and finished the selection will be inserted in to customers_basket_attributes.
  3. -removed-
  4. I was asking because I made my own auction system by joining bunch of other contribution accordingly to my store modification and just wanted to have a look how this one is going. Have a look: http://www.alphaimports.com/auctions.php
  5. Does anyone have working version of it on live or demo store or any screen shots?
  6. I use template system and there are no problems. It would depend on the version and contribution but most likely you will do modification in: /templates/templatename/main_page.tpl.php
  7. I would say it is recommended to have some kind of sitemap installed with this contribution so crawlers can index all of your main categories and product pages. In my case my URLs have some additional information for tool tip functions so actually it will be impossible for regular crawler to find normal page. All my products url’s look like this: 18x13-mm-oval-golden-citrine-aaa-grade-p-26399.html?prodID=26399 where prodID=26399 is for tool tip and recently I found Google indexed over 3000 duplicated pages because of my tool tip so I hope this contrib will be very helpful. Thanks a lot for your work! I made a lot of changes to my own store and I know how much effort it takes to create a contribution that will work for everybody. I think the concern will be duplicated content and not in only my case. For example page: My-categoty-c-21.html Will have the same content as: My-categoty-c-21.html?page=1 Solution for that will be more difficult because no one know (to the best of my knowledge) how Google finds duplicated content. If adding one paragraph of text would make new content we could add text like “You are on page_xx of category_xxx and searching by_xxx, let us know how we can help…..” Or add some random text that will change every time you will reload page. Does anyone have any ideas or different thoughts about this?
  8. Hello all, nice contrib. works perfectly tested in IE7 and FF3. I believe that the nice add-on would be possibility to display the code on the category page. I think something like that would work: <img src="social/buttonshare_trans.png" class="socializer" id="social_but" title="MYSITE : <?php echo $category['categories_heading_title']; ?>" alt="<?php echo tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('')) . ''); ?>" /> Works for me. Good luck.
  9. I was having some countdown problem, time left was not correct and it was off for about 1 hour. On the French version of this contrib. there is another script to do countdown. For me it fixed the problem. You will need some skill in PHP to replace this code with existing one. I cannot give you the full code because mine is highly customized already. If the countdown works fine for you just ignore it. $datetime_count_down = strtotime($auctions['expires_date'])-time(); $jours = floor($datetime_count_down/86400); $heures = floor(($datetime_count_down/3600)-($jours*24)); $minutes = floor(($datetime_count_down/60)-($jours*1440+$heures*60)); $secondes = floor($datetime_count_down-($jours*86400+$heures*3600+$minutes*60)); if (strtotime($auctions['expires_date'])>time()){ echo '<font style="font-weight: bold;" color="#ff0000">' . TEXT_DATETIME_LEFT. ' ' . $jours.'d '.$heures.'h '.$minutes.'m '.$secondes.'s</font>'; } else { echo '<font style="font-weight: bold;" color="#ff0000">Countdown Complete</font>'; }
  10. Sorry this should not come here it is regarding auction contribution. http://forums.oscommerce.com/index.php?showtopic=300066 For mods, please move it if possible or just delete this.
  11. I was having some countdown problem, time left was not correct and it was off for about 1 hour. On the French version of this contrib. there is another script to do countdown. For me it fixed the problem. You will need some skill in PHP to replace this code with existing one. I cannot give you the full code because mine is highly customized already. If the countdown works fine for you just ignore it. $datetime_count_down = strtotime($auctions['expires_date'])-time(); $jours = floor($datetime_count_down/86400); $heures = floor(($datetime_count_down/3600)-($jours*24)); $minutes = floor(($datetime_count_down/60)-($jours*1440+$heures*60)); $secondes = floor($datetime_count_down-($jours*86400+$heures*3600+$minutes*60)); if (strtotime($auctions['expires_date'])>time()){ echo '<font style="font-weight: bold;" color="#ff0000">' . TEXT_DATETIME_LEFT. ' ' . $jours.'d '.$heures.'h '.$minutes.'m '.$secondes.'s</font>'; } else { echo '<font style="font-weight: bold;" color="#ff0000">Countdown Complete</font>'; }
  12. Something like this will do: select max(ab.bid_price), ab.customers_id,ap.auctions_id, ap.products_id, pp.products_name, pr.products_model, cc.customers_firstname, cc.customers_lastname, cc.customers_email_address from auctions_bids ab, auctions ap, customers cc, products_description pp, products pr where ab.auctions_id=ap.auctions_id and ab.customers_id = cc.customers_id and ap.products_id = pp.products_id and ap.products_id = pr.products_id and ap.status = 1 and pr.products_id = ap.products_id and ap.expires_date < 'now()' group by ab.bid_price order by ab.bid_date_added asc limit 1 I will have account ready today and pm you with all info.
  13. I took the latest version of the contrib and the same problem came, here is the case. Try to recreate that there are 3 customers, John, Mike and Tom. John bid 10 Mike bid 20 Tom bid 30 Again John bid 40 After auction finish Tom got email that he won auction with price of 40. not john, i was studying the select MAX query. I will consult that with friend of my and we will come with some solution.
  14. Well i am customizing this contribution to fit my already customized store maybe thats the problem. I can provide server for testing with fresh os cstore, let me know if you would like to work on it so i will provide you some access, or pm me.
  15. I found one bug. I have created 3 users, and was placing bids randomly. After auction ended email with winning info was send to the bidder who had highest number in auctions_bids_id in table auctions bids. Problem is if customer will place bid again he still will have the same auctions_bids_id and if he won email will be send to someone else. Problem is in aucton2.php $query="select MAX I will look on it tomorrow and give correct query.