Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

AoM_Scott

Pioneers
  • Posts

    59
  • Joined

  • Last visited

Profile Information

  • Real Name
    Scott Lucas
  • Gender
    Male

AoM_Scott's Achievements

  1. Kymation, I would like to thank you again for all the hard work that went in to this project, it really has made a difference to sales this year once we integrated your contribution. Do you have any more plans for features soon or are you having a well deserved rest? Scott
  2. Ha you weren't kidding when you said the filter queries needed to be optimised. I'm averaging 100 a page on most categories.. but a staggering 835 queries (mostly due to filters) on some categories! I'm thinking cache for the counts? Still not ideal though.. and combining of the queries to get the filter lists. I'll have to think about it.. it's way too slow right now ;) Otherwise great contribution! Scott
  3. Great news! This has to be one of the best and most customisable contributions ever released for osC. Many thanks
  4. Hi integration with the products_price would probably be best, as in the "final_price" on oscommerce.. Number 38, that's alot! Obviously if nobody wants it I'm sure I can take it myself and have a look once I get round to integrating it. Scott
  5. Hmm.. I've tested previous versions and this contribution does seem very promising. I'll soon be updating my main site to include this.. just a lot of products to add specs for unfortunately :( Anyway.. we use a lot of special prices on our products and we would like to use a filter to manage the prices.. ie. £100 - £200, this obviously doesn't work with the products price field. Will the specials field be making an appearance any time soon? I know it's a different table so seems unlikely to happen soon but just thought I'd "log my interest". Great work by the way, very grateful for everything you and others have done so far. Scott
  6. Double check the installation instructions. Specifically where it may ask you to add a line or two to your language files or to upload a new file. Scott
  7. AoM_Scott

    Protx Direct v2.22

    I tired to edit the above post but couldn't.. With regards to the information above.. the module doesn't seem to actually be broken for none iframe.. it's just a result of me messing with the database trying to get PREAUTH with the new module.. Tried with a deferred transaction and went through fine. Still getting the error with the iframe though (Java) either way. My advice to anyone with the same problem without the iframe.. would be to uninstall the module in admin, and reinstall it.. so the configuration is not still for PREAUTH.. (mine is not like that I just added the PREAUTH type because I thought it would work the same - I was wrong :blush: ) Scott
  8. AoM_Scott

    Protx Direct v2.22

    Without iframe.. 3D Secure part with debug on.. Request URL=https://ukvpstest.protx.com/vpsDirectAuth/Callback3D.asp Data string sent=MD=011182440339933400&PARes=eJylWFmTokgQfvdXdPQ+GjNyeNFhu1HFJUqhIIfwhoAcAtqCIvz6LdTp7pnd2NjpNYKQyq rM/PLLzKJg8uc1S58uwamID/nrM/mdeH4Kcu/gx3n4+mzowrfx85/TzkSPTkHArQPvfAqmExQUhRsGT7H/+kyQJDmm+n2CphmGpvsE8TydrIAWFLfpo3sKihfi+2DYH1B0fzgcU6MxQdB40cPrFDv9Tk56P4bY+smL 3LycTlzvDUrKtM+Qw9Fo0nsMJ1lwkrjpgCTp0YCkiPtv0ruLJ70P/dW5vSsw4mvsT2GyJxGpVIJMxyQ6Wmoe+QtBy9ae9DrptSsmvlsGU2xxRAwp8okcvtDjlwEz6d3kk2NrD mSHM7ZN4mj7k95n0QSTc8Lk1dMxNZz03keT4Ho85AFeQU167/eT3ge6o5vjICnmEQqBtVvRRN9MJ2Wc/QKJeSExXTf5pCjd8lxMwaT3uJt47uUyBQBAoGmDfQV+/eFQb0smgRdPiQFGhP9vWiAND6e4jLIW58+CSa+F0rulFbNUvKzjMMf+TsETrp+8ePGL1+eoLI8vvV5VV d8r+vvhFPba3PQIpofX+EUc/vGMK+mhHPhSvjt8RZt180Mee24aN26JCwYFZXTwn97B/pMpXWutkT2NZ79hc988sp9/ayUETQ6efw9F7yOIGwP/xf+vRk6F+62IXPJrrrVgF7SlFTwZmvT6/JtG7jb0k5sXu8MpK/6X9u+FHeSXID0cA/9b8YO9rzHwH/3/a9r/sLAae8gy3I3FF2D0fmLxjouLw6Aov1IRX6+Gu0/TTc+/24waMZL1BoAzEYzzhj+cyRMVp1yRyfvXW3ifTD8Cfi+9x/ijlX/piq/g6RSn/ZtMnvh1nIXBcIV05HDDaDxIWNtI7OHmDXkg2tqOVWtryZnJATbB97e8sULFW5HCROR2XnTxF8mo1xmUN bpeIVWz9Gl3pvbiTlWlrnwOGKmmhIbsHhNtzLjj9eZkFRm3VeDqdO4mYhUV210t17NFBI4iafrqIegsY7 pEbD1yGFHpj8dwnOxfPxj4iPjOwiKov7q7bQYEw7ml+1VdNjiV8Q5vj+Vvs48kSQA6y0LxLQSVBEEoqWB prsOFNpdnhm/2xEU0WjhEAhQY7t+ifSwyFQGBagiAY+E54XcIEiIgDb7DRsgyM7N2TeXoUP3QnM1Jj1ZDPTMJn2Jqt+E 3CBq3xewVLT+tLSQ+Pdt1/4oacIWhYnYgKPRF6qReluqu5Z/bBb5o1ttMIFyLOdtWFRqUWfvYiMQrUGKJUKWukUejEDXCHPHew5ECOj7t03J+M9a0xuRMuWzXDGcIKFx bg2RLzys5mw8kYZ46cT/U+RSq+xStTc2R+Kuhsf2DXe8HSg2tjrOZHw0qzbcJCISKqJQENCiRKsQBfEG3lS05QCLdqFFjDBQ9dTH PEDS8jMD+hgpGiNUI6drhmpZYxcTM63B/vWwz7bJN+BUCd1LhVRV1kTk7+EIaqnjV5kxVXQjgqBp7xrBYiHxRxXNF1RHvk7IA5zpGSbmWkkq8lnqi UPsimW5z9arooLk7LHRZwHMZ2Ugik0kzs3HWMPJZiMnyzp2WWHdzy87ZpsZn3youXg4jiY2ShY7DW0uVB O4O+WsK/Y12cKwBTo4S4UTtJbHl857ATks6WnvVXP2hMFAci4ydjVT8WHTLsqDV/kYhJH6Q+jP/4mXFdcYB944YGTxtnjp+DhvsofHZQeVlDBGwOIMUUYXOuOJUe744OFJ08RSg8hCqgAttAiAMBxxECGTK lJsiCcySlG1L6qycmJ4fqcKLEsmnrtp2HMfUlWURk1773UbqNl2aCPSRWYqslZns27orI61/UmepDzWCW7JIp64+NZaXm44TWmE5p9Rl0eux+4S2PJ5Yu9aJ00jQlQbX1NoQs11eOa4U79NT5ieGdDWk ZrzVdjw91+M5WB0bJQOkMurEs54OQgQBEJMwFIdtDZUJmLdczDTEgwQABIq2THyuUnncv8KBg+Jtfg34V QMYxBUiS7FiZw1EscsbEF49DrFVtQhtaVHZmB9jBkLemmUR4c9gs4zHl3/qFjk3TzLuElsH484dwZhvawlxYigPQRnF5cGfaVVrwCCdNW4rYsuSiZdV559LiSllUrGMfdvP1blj0/MCceotjLmq4i0XQ8ZXu8XACkEYhicY8gJUPQ6E9tyWHFx2274aqnju0M7xwJZoNkRcB834T8o4/aJR2Q3YfzJSAdu23ZlGeNzhIlNM4tHgbwhb3jrvhhrARjHzT+FFrsX/W3ilbaUR5i/teAksP6GAHNAiJHSjjQu3SNhXZgNNIUyPW0vInTWTu5ZdSTrYIeCJcF0scXZdCNergY/cTvRWK0l24Zo+fCP50JZnhSMnIBVi5R3lVmTybT2g2u3Ka7er+NYlFz9Xii3lX+TMPzp4W+/8bV8HS4i59fuj+TAl7Li+bGZBMb/AdD9YCbw6l+rB2mMDc6TPq26yjIhZXRiF7AjmpnNcSG/cyTyKKyFTR1K506XhqqCdnd4fWobRDxdR5RDcaKld+0TODAmLulzOS9bbePnbLAt2ulmdV7o/O3p1h+7aRTOjNmWhu2kvoYYZjcr59WSRSp2R5Yrdz/tj8bgN1dfHk/mXx+H0Q9o+YN+f1F86qdyO4Wvwf9TRwT+n598+fl8c47KslYFFG2Vkh0wme1nuXmsRRfRWEC71Qt7ykt RQm1kyQsloNdppg1VpEfbcdYzFUe7jXTQuQWASQmemor50XW0FelsVAz+DLkvkDhg2vfFivfKdStfmR7d QZgbXT3LRdHaq393B9BAv1tbZoRQ1EdRkdS2Fsd7x0qW0B90cUTZn0Gdpx6BHJh6h3uPmH2/Avxk4UAG8Gfuh/+NE+pGFh+Tvw8f59Kfj2u1Dwe0zRvt2+/nzxl+aEo1R Protx response=VPSProtocol=2.22 Status=REJECTED StatusDetail=Your 3D Secure rulebase Rejected this transaction. 3D-Secure validation returned a status of - 3DSecureStatus= curl_error= My 3D Secure rulebase for test server is empty.. I added a rule for all transactions with the boxes all ticked.. same error. Can't get that far with debug off as I get the java error as above? It feels like the information isn't being transferred to the 3DSecure server properly.. Not sure how this is done? Is it a POST or something? Scott
  9. AoM_Scott

    Protx Direct v2.22

    We're using Streamline merchant number with Protx, and 3DSecure (has been working fine for months), can't get it working with the latest module though.. Iframe produces the same javascript error on as above, and none iframe is slightly better but produces a 'technical error' after submitting password on test server. Scott
  10. AoM_Scott

    Protx Direct v2.22

    Just installed the new update, didn't realise Protx weren't accepting authenticate types yet in production? Any idea of when this will be ready to go live? Also for the more accurate order id.. the default query doesn't work but this one does: $last_order_id_query = tep_db_query("SHOW TABLE STATUS from " . DB_DATABASE . " like '" . TABLE_ORDERS . "'"); Scott
  11. Recently, I have been looking into the database queries from my site. I noticed that a large amount of queries come from each page because of the SEO Url generation from tep_href_link. As my urls are already processed they are selected from the database each time. This has increased my parse times to 0.5 seconds on my all products page with 50 products.. up from 0.1. These timings are from a store with page cache disabled. It made me think, wouldn't it make more sense to cache processed URLs so they can be accessed quicker. I quickly got aquainted with chemos advanced cache class and used it to make a compressed array cache of all the processed urls with original urls as array keys, which was loaded on each page. I then modified the seo url class to retrieve these urls from the array instead of the database. I was able to much improve parse time, just slightly over the original timings. This is my very primitive poorly implemented proof of concept code, which should give you some idea of what I was trying to achieve: Application top just under // include the language translations require(DIR_WS_LANGUAGES . $language . '.php'); // check to see if it's seo urls cached $cache->is_cached('seo_urls', $is_cached, $is_expired); // Notice that $is_cached and $is_expired is passed by reference! if ( !$is_cached || $is_expired ){ // must not be cached or is expired $cache_array = array(); $url_check_query = tep_db_query("select seo_url_get, seo_url_org from " . TABLE_SEO_URL); while ($url_check_result = tep_db_fetch_array($url_check_query)) { $cache_array[$url_check_result['seo_url_org']] = $url_check_result['seo_url_get']; } //save the cache data $cache->save_cache('seo_urls', $cache_array, 'ARRAY', 1, 0, '1/months'); } $url_check = $cache->get_cache('seo_urls','ARRAY'); Handles basic cache creation and loads the array on every page. SEO URL Class function get_seo_url($url, &$separator, $store=true) { global $url_check; // Check if the url is recorded, if so skip processing /*$check_query = tep_db_query("select seo_url_get from " . TABLE_SEO_URL . " where seo_url_org = '" . tep_db_input(tep_db_prepare_input($url)) . "'"); if( $seo_array = tep_db_fetch_array($check_query) ) { $separator = '?'; return $seo_array['seo_url_get']; }*/ if ($url_check[$url] !== NULL) { $seperator = '?'; return $url_check[$url]; } return false; I have commented out the original db checking, and then quickly got the url from the array, I then returned false after so I was sure the urls were from the array. Let me know if you have any suggestions. Scott.
  12. The actual page query string get array support (ie. they are being replaced by the database get parameters) is broken for me in this latest version, because of this keywords for the quick search do not work. A solution such as this maybe? $tmp_array = array_merge($HTTP_GET_VARS,$tmp_array); // Synchronize global arrays. $HTTP_GET_VARS = $_GET = $tmp_array; unset($tmp_array); Scott
  13. AoM_Scott

    Protx Direct v2.22

    Like you said the transaction has been saved but the ID for the order and last order + 1 do not match due to an order deletion so its referencing an order that doesn't exist. But I can't relate that to this other problem I'm having. Here is a screenshot from my protx_direct table. It shows a duplicate transaction report, although one transaction is carrying no data. The first highlight shows the duplicates and the second shows the order with the wrong ID. Scott
  14. AoM_Scott

    Protx Direct v2.22

    I am also getting a problem listed above where I receive multiple transactions per order and in one case now, no transaction has been saved in the database at all, but it is still in the VSP Admin. I can't quite work out why this occurs. Also, just recently the new protocols for Authenticate and Authorise has been released for simulator testing so this could be added to the module. Scott
  15. Thanks, I've seen both of those caches before. Your Cache HTML I recently installed just yesterday and the other I have yet to look into, as I assume it requires you to decide parts to be cached. Cache HTML does look like an interesting client side solution but I've yet to completely get my head around the configuration and workings. I also fear that a contribution or piece of code will not get executed server side because of my poor configuration so I have temporarily disabled it (probably best as the new store in question is still under development). Scott
×
×
  • Create New...