View Single Post
  #1  
Old 03-29-2010, 01:09 AM
  amy2203's Avatar 
amy2203 amy2203 is offline
 

X-Wizard
  
Join Date: Jul 2004
Location: Watford, UK
Posts: 1,509
 

Default status change audit

I've added this code so that it puts time/date details of a status change i n the order notes.

in include/func/func.order.php add:
Code:
#ag added to add details to order notes $statusdate = date("D dS F Y G:i"); $qag1 = "UPDATE $sql_tbl[orders] SET notes = CONCAT(notes,' ', '"; $qag1.=$status." ".$statusdate; $qag1.="') WHERE orderid='".$orderid."'"; db_query ($qag1);

just after this line:
Code:
db_query("UPDATE $sql_tbl[orders] SET status='$status'".(($advinfo)? ", details='".$info."'" : "")." WHERE orderid='$orderid'");
__________________
X-Cart version 5 (Previously 3.5-4)

Previous Versions included
BCSE Reward Points Mod
Altered Cart On Sale Mod
Wordpress Plugin

Please don't PM me for support. I help where I can on the forum and your question will more likely be answered there.

Shout me a Coffee!
Reply With Quote