[08/04/2020 06:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/country.php],UPDATE countries SET name= 'Afghanistan',nationality = 'Afghanistan',code= '97',flag_image= '',is_mapped ='manual' WHERE id= '97';
[08/04/2020 06:00:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/country.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 18:00:15',`log_type`= 'Country Mapping',`sql_query`= 'UPDATE countries SET name= \&#039;Afghanistan\&#039;,nationality = \&#039;Afghanistan\&#039;,code= \&#039;97\&#039;,flag_image= \&#039;\&#039;,is_mapped =\&#039;manual\&#039; WHERE id= \&#039;97\&#039;',`log_description`= 'A Manual Country Mapping has been edited.  updated For  -   ---- changed to - ',`ip`= '60.254.42.39';
[08/04/2020 06:01:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/country.php],INSERT INTO countries SET name= 'India',nationality = 'Indian',code= '999',flag_image= '',status ='A';
[08/04/2020 06:01:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/country.php],INSERT INTO nationality SET name= 'India',code= '999';
[08/04/2020 06:01:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/country.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbMjMwMDBdOiBJbnRlZ3JpdHkgY29uc3RyYWludCB2aW9sYXRpb246IDEwNjIgRHVwbGljYXRlIGVudHJ5ICcwJyBmb3Iga2V5ICdQUklNQVJZJyBmcm9tIE90cmFtc0RCLnBocCBvbiAwNC0wOC0yMDIwIDA2OjAxOjE2CiBRdWVyeTpJTlNFUlQgSU5UTyBuYXRpb25hbGl0eSBTRVQgbmFtZT0gJ0luZGlhJyxjb2RlPSAnOTk5JwoKL3Rtcy9jb3VudHJ5LnBocAoKPHByZT4KSG9zdG5hbWU6IHF0ZWNoLm90cmFtcy5jb20KIDxicj4KCkNvbm5lY3Rpb246IG90cmFtc190aGVmYWJAMjA5LjIzNi4xMTQuMTc0CgpCYWNrdHJhY2U6CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ2LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvQ291bnRyeS5waHAnLAogICAgJ2xpbmUnID0+IDQ4NCwKICAgICdmdW5jdGlvbicgPT4gJ3F1ZXJ5JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Db3VudHJ5LnBocCcsCiAgICAnbGluZScgPT4gNzIsCiAgICAnZnVuY3Rpb24nID0+ICdpbnNlcnQnLAogICAgJ2NsYXNzJyA9PiAnQ291bnRyeScsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDMgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvQ291bnRyeS5waHAnLAogICAgJ2xpbmUnID0+IDM5NCwKICAgICdmdW5jdGlvbicgPT4gJ2FjdGlvbicsCiAgICAnY2xhc3MnID0+ICdDb3VudHJ5JywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgNCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY291bnRyeS5waHAnLAogICAgJ2xpbmUnID0+IDQsCiAgICAnZnVuY3Rpb24nID0+ICdzZXRfdGVtcGxhdGUnLAogICAgJ2NsYXNzJyA9PiAnQ291bnRyeScsCiAgICAndHlwZScgPT4gJy0+JywKICApLAopCgovdG1zL2NvdW50cnkucGhwCnVhdC50Zmcub3RyYW1zLm5ldCwgQ2xpZW50IElQOiA2MC4yNTQuNDIuMzk8L3ByZT48YnI+CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ2LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvQ291bnRyeS5waHAnLAogICAgJ2xpbmUnID0+IDQ4NCwKICAgICdmdW5jdGlvbicgPT4gJ3F1ZXJ5JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Db3VudHJ5LnBocCcsCiAgICAnbGluZScgPT4gNzIsCiAgICAnZnVuY3Rpb24nID0+ICdpbnNlcnQnLAogICAgJ2NsYXNzJyA9PiAnQ291bnRyeScsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDMgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvQ291bnRyeS5waHAnLAogICAgJ2xpbmUnID0+IDM5NCwKICAgICdmdW5jdGlvbicgPT4gJ2FjdGlvbicsCiAgICAnY2xhc3MnID0+ICdDb3VudHJ5JywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgNCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY291bnRyeS5waHAnLAogICAgJ2xpbmUnID0+IDQsCiAgICAnZnVuY3Rpb24nID0+ICdzZXRfdGVtcGxhdGUnLAogICAgJ2NsYXNzJyA9PiAnQ291bnRyeScsCiAgICAndHlwZScgPT4gJy0+JywKICApLAop',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/country.php',create_date= '2020-08-04 18:01:16';
[08/04/2020 06:01:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/country.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 18:01:16',`log_type`= 'Country Mapping',`sql_query`= 'INSERT INTO countries SET name= \&#039;India\&#039;,nationality = \&#039;Indian\&#039;,code= \&#039;999\&#039;,flag_image= \&#039;\&#039;,status =\&#039;A\&#039;',`log_description`= 'A Manual Country Mapping has been done',`ip`= '60.254.42.39';
[08/04/2020 06:01:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/country.php],UPDATE countries SET status='D' WHERE id= '217';
[08/04/2020 06:01:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/country.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-08-04 18:01:25',`log_type`= 'Country Mapping',`sql_query`= 'UPDATE countries SET status=\&#039;D\&#039; WHERE id= \&#039;217\&#039;',`log_description`= 'A Manual Country Mapping has been Deleted',`ip`= '60.254.42.39';
