Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

marcinmf

Pioneers
  • Posts

    37
  • Joined

  • Last visited

Everything posted by marcinmf

  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. 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
  4. Does anyone have working version of it on live or demo store or any screen shots?
  5. 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
  6. 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?
  7. 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.
  8. 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>'; }
  9. Sorry this should not come here it is regarding auction contribution. http://www.oscommerce.com/forums/index.php?showtopic=300066 For mods, please move it if possible or just delete this.
  10. 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>'; }
  11. 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.
  12. 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.
  13. 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.
  14. 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.
  15. By any chance do you have installed any of those contributions? Separate price per customer, Product quantity price brake or Make an offer? If yes, than the way final price is calculate in your stoner will be different and given installation instructions won’t work.
  16. Hello, Last week I start to play with auction code. My store is highly modified CRE but still I managed to make it work. During my custom installation I found some places for improvement. I did not try the beta version yet but I will try it during this week. I think it will be good to change request from POST to GET so you can capture request in the URL. If you have it in URL you could use snapshot that you have commented out in product_info.php //$navigation->set_snapshot(); It still wont work with the commented code. You would have to give something like that: $navigation->set_snapshot(array('mode' => 'SSL', 'page' => FILENAME_PRODUCT_INFO . '?products_id='.$products_id)); And is you have your request in URL you could add it to my example. For those who don knot what this snap shot is here is explanation: When you are not logged in and you placed a bid you are redirected to the log in page. When snap shot is not set after log in you will be taken back to the index(home) page and after that customer have to navigate again to the auction product and place bid again. In my example customer will be taken back to the auction product but still he/she have to place bid again. If we can place request in URL customer would be redirected to the auction page with bid approved or disapproved. I also made a lot of modification to the email message. My message looks like this: define('AUCTION_HIGHER_BID_NOTIFY_EMAIL','Hello [customer_firstname] [customer_lastname], We are sorry to inform you that you have been out bided. Another customer have just placed higher offer for item: ([auction_name]) at [auction_url] . The New Price is: $[bid_price] Please fallow the link if you wish to raise your bid. --------------------------- Auction details: --------------------------- Item Title : [auction_name] Item Number : [products_id] Item SKU : [auction_sku] Item URL : [auction_url] End Date : [auction_ends] Current Bid : $[bid_price] ---------------------------- * For more information please visit our auction details and rules on the product detail page. ** If you need more assistance please reply to this email. Regards, xxxxxxxxxxxx '); Let me know if you want to see how I did this. Good luck and I will give my feedback after testing beta version.
  17. Just a quick observation. I am running CRE loaded with template system. This observation is for those who are running on CRE or have template system integrated. If someone does not want to create second footer page, or will have problems with the code (template system) here is a simple solution. The idea is to show tracking code before </body> tag on every page but not checkout_success.php. On this page you need only include analytic file on the top of the page. According to Google if you will have both codes your analytics might not be correct. For those with cre or template system replace in templates/**yourtemplatename**/main_page.tpl.php --or where you are keeping Google tracking code replace: <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> var pageTracker = _gat._getTracker("xx-xxxxxxx"); pageTracker._initData(); pageTracker._trackPageview(); </script> and place this: <?php if ($_SERVER['SCRIPT_NAME'] == '/checkout_success.php') { echo ''; } else { ?> <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> var pageTracker = _gat._getTracker("xx-xxxxxx"); pageTracker._initData(); pageTracker._trackPageview(); </script> <?php } ?> What it will do , it will hide Google tracking code at /checkout_success.php page. Those with out template systems or CRE, can replace the same on checkout_success.php page. I believe it is little less confusing and maybe should be integrated with main installation.
  18. I have prepared English translation: here is to replace content of the file admin/includes/languages/english/multiorders.php with <?php /* $Id: multiorders.php,v 1.25 2007/12/17 00:28:44 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ //multi order update define('HEADING_TITLE', 'Orders'); define('HEADING_TITLE_SEARCH', 'Order Number :'); define('HEADING_TITLE_STATUS', 'Status :'); define('EMAIL_SEPARATOR', '------------------------------------------------------'); define('EMAIL_TEXT_SUBJECT', 'Update of the order'); define('EMAIL_TEXT_ORDER_NUMBER', 'Number of order :'); define('EMAIL_TEXT_INVOICE_URL', 'Itemized bill :'); define('EMAIL_TEXT_DATE_ORDERED', 'Go back to command :'); define('EMAIL_TEXT_STATUS_UPDATE', 'The statute of your order was updated.' . "\n\n" . 'New Status: %s' . "\n\n" . 'If you have any questions please reply to this e-mail.' . "\n"); define('EMAIL_TEXT_COMMENTS_UPDATE', 'Here are comments for your order' . "\n\n%s\n\n"); define('ERROR_ORDER_DOES_NOT_EXIST', 'Error: The order n\' does not exist'); define('SUCCESS_ORDER_UPDATED', 'Success: The order is updated.'); define('WARNING_ORDER_NOT_UPDATED', 'Caution: No modification n\' was carried out. The order n\' was not updated.'); define('BUS_HEADING_TITLE','fast update'); define('BUS_TEXT_NEW_STATUS', 'To choose New Status'); define('BUS_NOTIFY_CUSTOMERS', 'To notify Customer(s)'); define('BUS_SELECT_ALL', 'Select All'); define('BUS_SELECT_NONE', 'Select None'); define('BUS_SUBMIT', 'Update Status'); define('TABLE_HEADING_ORDER_NUMBER','Order number'); define('TABLE_HEADING_CUSTOMERS', 'Customer'); define('TABLE_HEADING_ORDER_TOTAL', 'Order Total'); define('TABLE_HEADING_DATE_PURCHASED', 'Date of purchase'); define('TABLE_HEADING_STATUS', 'Status'); define('HEADING_TITLE_STATUS', 'Status :'); define('TEXT_MAX_LIGNES_CMD', 'lines per page :'); define('TEXT_ALL_ORDERS', 'All orders'); ?> I Am getting small problem, when i am changing status either the box to notify customer is selected or not customer is always getting email. I did not have a change to look on the code. If someone have fix for that please post. I will also try to look on that.
  19. I am having small problem on this page: admin/modules.php?set=giftwrap&osCAdminID=xxxxxxxx Error! Unable to determine connection method on a link! Known methods: NONSSL SSL Function used: tep_href_link('modules.php', 'set=giftwrap&module=nogiftwrap', '') I am running cre loaded, Any ideas where i should start to look for the solution?
  20. Hello I want to say thanks for this contribution and I hope it will speed p things in my company. For the moment I am making successfully exports of products orders and customers. I am able to import customers and products to the QB. When trying to imports Orders I am getting this message: QuickBooks has detected that one of your items does not have an account associated with it. Go to the item list to make sure all items are associated with accounts. After clicking ok I have: Error on line 13: Can’t record invalid transaction. [ok/cancel] What should I do? Thanks Martin.
  21. Hello I have quick question. I am about to install this contribution, after reading user guide it looks like from the admin side you are selecting items from the drop down menu to relate them to each other. So my concern is I have over 20.000 products, and I don’t really want to load them to the drop down menu because it will take forever. Should I be concern or should I go ahead with installing it? Thanks Martin.
  22. I just updated to the latest version it is very nice, the only thing that I am having problem is the total in the shopping cart for customer with the present cart is not appearing. Just quantity and product name. Any suggestions? Thanks
  23. Got it solved just need to pay more attention to instructions.
  24. I was getting error message with unknown table if someone is having the same problem just replace: // customers drop down in orders list begins } elseif (isset($HTTP_GET_VARS['customers_id']) && ($HTTP_GET_VARS['customers_id'] > 0)) { $invoice_number = tep_db_prepare_input($HTTP_GET_VARS['customers_id']); $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "select o.orders_id, o.invoice_serial, o.invoice_number, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$customers_id . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC"; // customers drop down in orders list ends With : // customers drop down in orders list begins } elseif (isset($HTTP_GET_VARS['customers_id']) && ($HTTP_GET_VARS['customers_id'] > 0)) { $invoice_number = tep_db_prepare_input($HTTP_GET_VARS['customers_id']); $status = tep_db_prepare_input($HTTP_GET_VARS['status']); $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$customers_id . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC"; // customers drop down in orders list ends Also if you want to display them with the last name than first replace: <? // customers drop down in orders list begins ?> <tr> <? $customers_query = tep_db_query("select customers_id, customers_firstname, customers_lastname from " . TABLE_CUSTOMERS . " order by customers_lastname"); while ($customers = tep_db_fetch_array($customers_query)) { $customers_firstname = $customers['customers_firstname']; $customers_lastname = $customers['customers_lastname']; $customers_array[] = array('id' => $customers['customers_id'], 'text' => $customers_firstname . ' ' . $customers_lastname); } ?> <td class="smallText" align="right"><?php echo tep_draw_form('customers', FILENAME_ORDERS, '', 'get') . TABLE_HEADING_CUSTOMERS . ' ' . tep_draw_pull_down_menu('customers_id', array_merge(array(array('id' => '', 'text' => '')), $customers_array), (isset($HTTP_GET_VARS['customers_id']) ? $HTTP_GET_VARS['customers_id'] : ''), 'onChange="this.form.submit();"'); ?></form></td> </tr> <? // customers drop down in orders list ends ?> With: <? // customers drop down in orders list begins ?> <tr> <? $customers_query = tep_db_query("select customers_id, customers_lastname, customers_firstname from " . TABLE_CUSTOMERS . " order by customers_lastname"); while ($customers = tep_db_fetch_array($customers_query)) { $customers_lastname = $customers['customers_lastname']; $customers_firstname = $customers['customers_firstname']; $customers_array[] = array('id' => $customers['customers_id'], 'text' => $customers_lastname . ' ' . $customers_firstname); } ?> <td class="smallText" align="right"><?php echo tep_draw_form('customers', FILENAME_ORDERS, '', 'get') . TABLE_HEADING_CUSTOMERS . ' ' . tep_draw_pull_down_menu('customers_id', array_merge(array(array('id' => '', 'text' => '')), $customers_array), (isset($HTTP_GET_VARS['customers_id']) ? $HTTP_GET_VARS['customers_id'] : ''), 'onChange="this.form.submit();"'); ?></form></td> </tr> <? // customers drop down in orders list ends Nice addition, all credit credit goes to niviche
×
×
  • Create New...