Jump to content

sakwoya

Members
  • Content count

    94
  • Joined

  • Last visited


Reputation Activity

  1. Like
    sakwoya got a reaction from Leo2 in Specials valid from   
    I've installed V1.0.4 of this and it works fine for me - however note the following:
     
    1) If you do not set an expiry date for the Special then it will not display in the store front as the new code in catalog/specials.php will exclude any specials where the expiry date = 0
    2) In the admin you may have to apply a Register Globals fix to the file specials.php as this apeared to prevent us from editing the dates for existing specials
    3) If you change the status of a special from 'on' to 'off' and then back to 'on' this will wipe the expiry date from your special (and it will not display in the storefront for the reason stated in (1)). To stop this happening you will have to edit the file catalog/admin/includes/functions/general.php at around line 739 find
     

    //// // Sets the status of a product on special function tep_set_specials_status($specials_id, $status) { if ($status == '1') { return tep_db_query("update " . TABLE_SPECIALS . " set status = '1', expires_date = NULL, date_status_change = NULL where specials_id = '" . (int)$specials_id . "'"); } elseif ($status == '0') { return tep_db_query("update " . TABLE_SPECIALS . " set status = '0', date_status_change = now() where specials_id = '" . (int)$specials_id . "'"); } else { return -1; } }
    change to:

    //// // Sets the status of a product on special function tep_set_specials_status($specials_id, $status) { // if ($status == '1') { // return tep_db_query("update " . TABLE_SPECIALS . " set status = '1', expires_date = NULL, date_status_change = NULL where specials_id = '" . (int)$specials_id . "'"); if ($status == '1') { return tep_db_query("update " . TABLE_SPECIALS . " set status = '1', date_status_change = now() where specials_id = '" . (int)$specials_id . "'"); } elseif ($status == '0') { return tep_db_query("update " . TABLE_SPECIALS . " set status = '0', date_status_change = now() where specials_id = '" . (int)$specials_id . "'"); } else { return -1; } }
    Graeme
  2. Like
    sakwoya reacted to FWR Media in [contribution] KISS FileSafe ( file security )   
    Thanks for the report.
     
    Glad it's working for you. I don't get errors for the 0.5 on the servers I tried it on but I can see that 0.5 may need to be a string "0.5" where as a digit is fine.
  3. Like
    sakwoya got a reaction from Follkes in Who's Online Enhancement 1.4   
    Hi all - solved my above problem
     
    If, like me, you have downloaded 3.5.9 you will only have the admin files - there is a missing file and some SQL statements.
     
    To fix this download 3.5.4 by SteveDallas and copy the file catalog/includes/functions/whos_online.php to your store. Then run the following in your phpMyadmin:
     
    ALTER TABLE whos_online ADD http_referer VARCHAR(255) NOT NULL;
    ALTER TABLE whos_online ADD user_agent VARCHAR(255) NOT NULL;
    ALTER TABLE `whos_online` ADD `hostname` VARCHAR( 255 ) NOT NULL AFTER `ip_address` ;
     
    This fixed it for me.
     
    Graeme
     
    (I have an updated package but the contribution page is refusing to let me upload at the present time)
×