Month: December 2008

  • 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` […]

  • Paypal, ClickAndBuy, Google Checkout, NoChex and Worldpay Fees

    Here’s more a reminder to myself and all figures are based off “base rates” currently provided by the various Payment gateways. Check the figures yourself before using them as they may have changed. I can’t accept any liability for how you use this information. Paypal charge a fixed fee of £0.20 and 3.4% of each […]

  • Net: Yahtzee’s Zero Punctuation’s reviews

    Ben “Yahtzee” Croshaw has, for around the last year or so, been busy reviewing games under the “Zero Punctuation” monkier for The Escapist. Why that name? Well, he’s a Brit living in Oz and his video reviews have, erm, not a lot of punctuation in them. They are funny, not kid safe, good animation style […]

  • Film and TV: No more Narnia movies and no more Project Runway

    In a move designed to upset my my other half on Christmas Eve (mhahaha – it’s my evil deed for the week >-) ), I’m passing on the news that it looks very unlikely that Disney will be making any more Narnia movies (source Defamer.com who cite HollywoodReport.com as a source: but also see NationalPost, […]

  • 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 […]