Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Change A Location Code Issue
09-08-2017, 11:40 PM (This post was last modified: 09-08-2017 11:48 PM by VortecCPI.)
Post: #1
Change A Location Code Issue
When changing a Location Code (in Utilities section ) the LocationsUsers table is not updated so the change process seems to be incomplete.

I had to change the LocCode in the LocationUsers table manually.
I added the following code to Z_ChangeLocationCode.php at line 236:

echo '<br />' . _('Changing user location records');
$sql = "UPDATE locationusers SET loccode='" . $_POST['NewLocationID'] . "' WHERE loccode='" . $_POST['OldLocationID'] . "'";
$ErrMsg = _('The SQL to update users records failed');
$result = DB_query($sql,$ErrMsg,$DbgMsg,true);
echo ' ... ' . _('completed');

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Change A Location Code Issue - VortecCPI - 09-08-2017 11:40 PM
RE: Change A Location Code Issue - TurboPT - 09-09-2017, 03:47 AM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)