========================2020-06-01 11:14:18======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C39F571DF0FD5433 sCDKey = 277886843570 sName = USER-PC ========================2020-06-01 11:14:18======================== 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 = '277886843570' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-01 11:14:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cs8419' ========================2020-06-01 11:14:19======================== SELECT idx FROM macs WHERE mac_addr = '50B7C39F571DF0FD5433' AND app_code = '039' ========================2020-06-01 11:14:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '318704' ========================2020-06-01 11:14:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '318704' ========================2020-06-01 11:14:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '318704', '50B7C39F571DF0FD5433', '039', 'USER-PC', '90', '1920', '1080', 'cs8419', '창성정육유통[정행심]', '277886843570' ) ========================2020-06-01 15:46:58======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-33G7UU4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AA346DF48BE62D sCDKey = 731917363583 sName = 현대자동차삼천대리점 ========================2020-06-01 15:46:58======================== 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 = '731917363583' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-01 15:46:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'randm' ========================2020-06-01 15:46:59======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AA346DF48BE62D' AND app_code = '039' ========================2020-06-01 15:46:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '317347' ========================2020-06-01 15:46:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '317347' ========================2020-06-01 15:46:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '317347', '50B7C3AA346DF48BE62D', '039', '현대자동차삼천대리점', '110', '1920', '1080', 'randm', '현대자동차삼천판매대리점[강정호]', '731917363583' ) ========================2020-06-01 15:54:52======================== noteurl_start parm_app_code = 039 parm_pc_name = G10 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B42E99F96F6BC8CDE059 sCDKey = 506205661748 sName = G10 ========================2020-06-01 15:54:52======================== 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 = '506205661748' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-01 15:54:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'japa2928' ========================2020-06-01 15:54:52======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99F96F6BC8CDE059' AND app_code = '039' ========================2020-06-01 15:54:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '318748' ========================2020-06-01 15:54:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '318748' ========================2020-06-01 15:54:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '318748', 'B42E99F96F6BC8CDE059', '039', 'G10', '110', '1600', '900', 'japa2928', '청수무역[장재일]', '506205661748' ) ========================2020-06-01 16:14:06======================== noteurl_start parm_app_code = 048 parm_pc_name = PJH parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 7085C2B92617DABAE9EC sCDKey = 998129831603 sName = PJH ========================2020-06-01 16:14:06======================== 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 = '998129831603' AND r.app_code = '048' AND r.app_block = 0 ========================2020-06-01 16:14:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youi92' ========================2020-06-01 16:14:06======================== SELECT idx FROM macs WHERE mac_addr = '7085C2B92617DABAE9EC' AND app_code = '048' ========================2020-06-01 16:14:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285999' ========================2020-06-01 16:14:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285999' ========================2020-06-01 16:14:06======================== UPDATE mac_detail SET pc_name = 'PJH', os_type = '�쐢�룄�슦 10', user_id = 'youi92', user_name = '[박주현]', screen_w = '0', screen_h = '0', cdkey = '998129831603' WHERE mac_idx = '285999' ========================2020-06-01 17:42:27======================== noteurl_start parm_app_code = 039 parm_pc_name = HIYA-BUQU8IL7BK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D3004932BE311A60 sCDKey = 361943364959 sName = HIYA-BUQU8IL7BK ========================2020-06-01 17:42:27======================== 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 = '361943364959' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-01 17:42:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'haiduk7596' ========================2020-06-01 17:42:27======================== SELECT idx FROM macs WHERE mac_addr = 'F44D3004932BE311A60' AND app_code = '039' ========================2020-06-01 17:42:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '318774' ========================2020-06-01 17:42:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '318774' ========================2020-06-01 17:42:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '318774', 'F44D3004932BE311A60', '039', 'HIYA-BUQU8IL7BK', '110', '1920', '1080', 'haiduk7596', '금원에어테크[유태원]', '361943364959' )