========================2022-08-17 10:50:54======================== noteurl_start parm_app_code = 039 parm_pc_name = PC-001 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D0509969322988B0937 sCDKey = 657279571543 sName = PC-001 ========================2022-08-17 10:50:54======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '657279571543' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-17 10:50:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksgo0322' ========================2022-08-17 10:50:54======================== SELECT idx FROM macs WHERE mac_addr = 'D0509969322988B0937' AND app_code = '039' ========================2022-08-17 10:50:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308085' ========================2022-08-17 10:50:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308085' ========================2022-08-17 10:50:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '308085', 'D0509969322988B0937', '039', 'PC-001', '110', '1536', '864', 'ksgo0322', '강진기업[김상근]', '657279571543' ) ========================2022-08-17 10:52:21======================== noteurl_start parm_app_code = 039 parm_pc_name = PC-001 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = D050996932296662AA25 sCDKey = 657279571543 sName = PC-001 ========================2022-08-17 10:52:21======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '657279571543' AND r.app_code = '039' AND r.app_block = 0 ========================2022-08-17 10:52:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ksgo0322' ========================2022-08-17 10:52:21======================== SELECT idx FROM macs WHERE mac_addr = 'D050996932296662AA25' AND app_code = '039' ========================2022-08-17 10:52:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '308086' ========================2022-08-17 10:52:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '308086' ========================2022-08-17 10:52:21======================== UPDATE mac_detail SET pc_name = 'PC-001', os_type = '110', user_id = 'ksgo0322', user_name = '강진기업[김상근]', screen_w = '1536', screen_h = '864', cdkey = '657279571543' WHERE mac_idx = '308086' ========================2022-08-17 14:04:24======================== noteurl_start parm_app_code = 046 parm_pc_name = BSTPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA45702F9ED0BB3E sCDKey = 407891925720 sName = BSTPOS ========================2022-08-17 14:04:24======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '407891925720' AND r.app_code = '046' AND r.app_block = 0 ========================2022-08-17 14:04:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ykk9411' ========================2022-08-17 14:04:24======================== SELECT idx FROM macs WHERE mac_addr = '68EDA45702F9ED0BB3E' AND app_code = '046' ========================2022-08-17 14:04:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '371986' ========================2022-08-17 14:04:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '371986' ========================2022-08-17 14:04:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '371986', '68EDA45702F9ED0BB3E', '046', 'BSTPOS', '110', '1024', '768', 'ykk9411', '진우종합상사[유기선]', '407891925720' )