X-Cart forums - 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'");