Category: Life: Work and Techy

  • Snippet: London Underground “Tube” – Oyster or Travelcard

    I’ve suspected it, but it’s nice to have confirmation -it is cheaper for me to use Oyster Pay as you go then a Transport For London (TfL) travel code for my commutes between Zone 5 and Zone 1. Is it cheaper for you? (by looks of things, only if you regularly travel in to London […]

  • Snippet: Weird Pricing on TheCloud

    I’m just helping somebody find temporary wireless internet access (ideally free wireless in London), and I remembered The Cloud. Their pricing is a bit odd: for Pay as you go access, the price if £6.99 for 3 hours or £9.99 for 24 hours, or you can go for their subscription wireless access, it’s £6.99 for […]

  • ClickCartPro: Extracting Sales Figures

    If you want to get an idea of the stock you’ve sold using the ClickCartPro UK e-commerce software, then you may find the following SQL query useful. Run in phpMySQL to be able to export the data into a spreadsheet. SELECT SUM(itemquan) as itemssold, count(*) AS timesordered, itemname, itemnum, itemopts, SUM(itemquan)/COUNT(*) AS average FROM `gbu0_orderitems` […]

  • Facebook: Copyrighted Content

    I’ve just answered a post on LinkedIn where somebody asked (in the “Casual Games” discussion group): “There is a hacked flash version of one of our games listed as an application at facebook. I could not find any real support contact information at the facebook website. Just FAQs and canned responses. Do you know anybody […]

  • e-Commerce: ClickCartPro making all product ids safe

    Basically, in ClickCartPro product “identifers” can not have spaces, commas, full stops or brackets in them (basically only the letters A-z, numbers and underscores) and they have to be a maximum length (I’m not sure what the exact maximum is). If you are maintaining an “established” store (i.e. one with products) where a number of […]