Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

status change audit

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #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
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 04:11 AM.

   

 
X-Cart forums © 2001-2020