Jump to content
Latest News: (loading..)

deansmar

Members
  • Content count

    65
  • Joined

  • Last visited

Profile Information

  • Real Name
    Colin
  • Gender
    Male
  1. deansmar

    [CONTRIBUTION] Customers list improved

    this is definatly on my todo list... and when i get a bit of time i will try it (convert it) on my test enviroment the only issue i see at the Moment, is that the headers and footers are not 2.3.4 compatable which could cause the Problems @@bruyndoncx thanks for the vote of confidence :thumbsup:
  2. deansmar

    [CONTRIBUTION] Customers list improved

    I guess not...!! looks like I will have to build/alter it my self..
  3. deansmar

    [CONTRIBUTION] Customers list improved

    Does anyone use this Contribution in a 2.3.4 environment..?
  4. deansmar

    Database Optimizer

    thanks for the answer Jack... i think i could possibly say i am quite fix with phpmyadmin, but the syntax to be applyed in MySql would be a bit over the top of my head.. and i am not to sure which Tabels i will have to address..!! i am trying this code at the moment to see what happens... or if it works.. <?php require('includes/application_top.php'); $strip_date = "2008-07-01 00:00:00"; $orders = tep_db_fetch_all_array(tep_db_query("select orders_id from orders where date_purchased < '$strip_date'")); $count_stripped = count($orders); foreach ($orders as $orders_row) { $orders_id = $orders_row['orders_id']; tep_db_query ("delete from orders_products where orders_id = '$orders_id'"); tep_db_query ("delete from orders_products_attributes where orders_id = '$orders_id'"); tep_db_query ("delete from orders_status_history where orders_id = '$orders_id'"); tep_db_query ("delete from orders_total where orders_id = '$orders_id'"); tep_db_query ("delete from orders where orders_id = '$orders_id'"); } echo ("$count_stripped orders before $strip_date where deleted!") ?>
  5. deansmar

    DB Manipulation from Admin

    i think this contribution is fantastic, and has tought me a few things about SQL databases i am still running a v2.2rc2a shop and insted of deleting all of the Orders i would just like to delet Old Orders would this code do the trick..?? thanks for your time.. :thumbsup: <?php require('includes/application_top.php'); $strip_date = "2008-07-01 00:00:00"; $orders = tep_db_fetch_all_array(tep_db_query("select orders_id from orders where date_purchased < '$strip_date'")); $count_stripped = count($orders); foreach ($orders as $orders_row) { $orders_id = $orders_row['orders_id']; tep_db_query ("delete from orders_products where orders_id = '$orders_id'"); tep_db_query ("delete from orders_products_attributes where orders_id = '$orders_id'"); tep_db_query ("delete from orders_status_history where orders_id = '$orders_id'"); tep_db_query ("delete from orders_total where orders_id = '$orders_id'"); tep_db_query ("delete from orders where orders_id = '$orders_id'"); } echo ("$count_stripped orders before $strip_date where deleted!") ?>
  6. deansmar

    Database Optimizer

    Hi Jack, i am still running a V2.2rc2a Shop i would like to know if this MOD, can delete old orders? if the answer is NO, does any one know of a MOD that can do this and if the answer is still NO, it might be a good idea to bring something like that out...!! thanks for your time..
  7. deansmar

    [Contribution] Mindsparx admin

    this is my code to change the Order Status from next to each other to underneath each other swap the code in catalog\admin\index.php between // order summary and // order total summary but leaving all the PHP brackets for example <?php ?> add one define to the catalog\admin\includes\languages\english.php define('TEXT_SUMMARY_ORDERS', 'Your Order Status Is:'); and then upload... hey presto
  8. deansmar

    [Contribution] Mindsparx admin

    so far so good, i have managed to get the Order Status how i would like it, all i have to do is clean things up a little and then i will post the code i have used. which replaces the code in catalog\admin\index.php just below the // order summary to clean things up i will porbably have to edit the catalog\admin\includes\languages\english.php there no were to upload a picture apart from adding a link to an img, otherwise i would have added one to this post to show you what it looks like regards
  9. deansmar

    [Contribution] Mindsparx admin

    Hi Janne thanks for a Fantastic contribution, and i agree with all the others that have writen there compliments in here. the instalation took 20 mins all in all, now i am trying to pimp it a little further to suit my wishes. this idea from Jacko162 was not all that bad, an i am trying to implement it, i have found the code, but im not that PHP perfect to change it. it would be nice if you could point me in the right direction... thanks
  10. deansmar

    Fancier Invoice & Packingslip v1.0

    problem found, just needed to read a little more of the instalation text and the problem is found.. If you have the Edit Orders MOD, add it in catalog\admin\includes\languages\english\edit_orders.php Make sure it is also in: catalog\admin\includes\languages\english\orders.php You should also find it in: catalog\includes\languages\english\checkout_process.php or any other languages that are being used..
  11. deansmar

    Fancier Invoice & Packingslip v1.0

    i have a different problem.... the HTML Emails that are sent out to the customers are not using the correct language file and have things like; INVOICE_ORDER_CONFIRMATION INVOICE_TEXT_NUMBER_SIGN 10INVOICE_TEXT_DASH2015 i have been through nearly every language file, and i can not find the problem, the e-mail seems to be picking up a default language file and not the language file that should be used. could someone point me in the right direction to the correct language file...?? i have OSC 2.2RC2a installed with the latest Fancier_invoice_6.2_Fixed_2009-15-09 installed. thanks for any help.
  12. deansmar

    Fancier Invoice & Packingslip v1.0

    you will have to edit your Catalog\admin\invoice.php in all the places that look anything to do with the images like the bold marked areas; insted of having the 100% default that comes with the MOD it sorted my problem out... which was the same...
  13. deansmar

    NEW! Complete Order Editing Tool!

    I have Installed this contribution sucsessfully; UK Royal Mail & Overseas Shipping Methods for specific categories of products for osCommerce Online Merchant v2.2 Modified contribution by: Alexander Dimelow Based on the Original “UK Royal Mail & Overseas Shipping Methods 21st Aug Prices” contribution: http://addons.oscommerce.com/info/4473 everything seems to work OK .. but when i need to Edit an Order this error occours Fatal error: Call to undefined function tep_get_categories_name() in /public_html/osctestshop/includes/modules/shipping/parcelforce48.php on line 89 i have Order Editor also installed Mod 1435 http://addons.oscommerce.com/info/1435 i would gues that the problem is in the edit_orders.php and not in the parcelforce48.php any chance of a little help ?
  14. I have Installed this contribution sucsessfully; UK Royal Mail & Overseas Shipping Methods for specific categories of products for osCommerce Online Merchant v2.2 Modified contribution by: Alexander Dimelow Based on the Original “UK Royal Mail & Overseas Shipping Methods 21st Aug Prices” contribution: http://addons.oscommerce.com/info/4473 everything seems to work OK .. but when i need to Edit an Order this error occours Fatal error: Call to undefined function tep_get_categories_name() in /public_html/osctestshop/includes/modules/shipping/parcelforce48.php on line 89 i have Order Editor also installed Mod 1435 http://addons.oscommerce.com/info/1435 i would gues that the problem is in the edit_orders.php and not in the parcelforce48.php any chance of a little help ?
  15. deansmar

    Sexy Admin Area

    i have managed to change most of the things to how i would like it!! if you would like to take a look: http://www.deansmarine.co.uk/OSCv2rc2a/admin of course this will disapear once the shop goes live, this is just my Online test site i am still trying to make the Login Button larger, does anyone have any Idea..??
×