![]() |
How do I add a line to history on authorize? - Printable Version +- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com) +-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html) +--- Forum: OpenDocMan Support - Community Based (https://forum.opendocman.com/forum-6.html) +--- Thread: How do I add a line to history on authorize? (/thread-25.html) |
How do I add a line to history on authorize? - Stephen - 01-12-2010 I'm trying to add what sounds like a very simple feature, but am having some issues with PHP. I can read and somewhat understand the PHP, but am more comfortable with VB and Java. What I'm trying to add looks like it should be no more than 2 lines of code, but I cannot get those to work. I am trying to get it to record in history when someone authorizes a document. I took the code that is added when someone adds a document from add.php. Here is the code that looks like it is making the history comment:// Add a log entry $query = "INSERT INTO log (id,modified_on, modified_by, note, revision) VALUES ( '$fileId', NOW(), '" . addslashes($username) . "', 'Initial import', 'current')"; $result = mysql_query($query, $GLOBALS['connection']) or die ("Error in query: $query. " . mysql_error()); When I add this to toBePublished.php I get errors. If any one could help me out I would appreciate it. Thank you. dvst8s Re: How do I add a line to history on authorize? - Stephen - 01-12-2010 In case anyone else is wanting to do this the code below is what worked for me. You would just insert it above the } above the header('Location:' . $_SERVER['PHP_SELF'] .....line at the bottom of tobepublished.php. //Find out the owners' username to add to log $query = "SELECT username from user where id='$_SESSION[uid]'"; $result = mysql_query($query, $GLOBALS['connection']) or die ("Error in query: $query. " . mysql_error()); list($username) = mysql_fetch_row($result); // Add a log entry for authorizing $query = "INSERT INTO log (id,modified_on, modified_by, note, revision) VALUES ( '$fileid', NOW(), '" . addslashes($username) . "', 'Authorized', 'current')"; $result = mysql_query($query, $GLOBALS['connection']) or die ("Error in query: $query. " . mysql_error()); //End Added to try and log when someone Authorizes a document dvst8s |