========================2021-01-18 09:22:08======================== noteurl_start parm_app_code = 039 parm_pc_name = ALMOCO0116 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E9172C6AC66760E6 sCDKey = 720357298336 sName = ALMOCO0116 ========================2021-01-18 09:22:08======================== 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 = '720357298336' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-18 09:22:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'almoco7844' ========================2021-01-18 09:22:08======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E9172C6AC66760E6' AND app_code = '039' ========================2021-01-18 09:22:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '335039' ========================2021-01-18 09:22:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '335039' ========================2021-01-18 09:22:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '335039', '8CB0E9172C6AC66760E6', '039', 'ALMOCO0116', '110', '1920', '1080', 'almoco7844', '(주)알모코[배한숙]', '720357298336' ) ========================2021-01-18 09:45:12======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-9NFSC93 parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 74E5F99FB41F3850E1AD sCDKey = 990376035504 sName = DESKTOP-9NFSC93 ========================2021-01-18 09:45:12======================== 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 = '990376035504' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-18 09:45:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sgj3333' ========================2021-01-18 09:45:12======================== SELECT idx FROM macs WHERE mac_addr = '74E5F99FB41F3850E1AD' AND app_code = '039' ========================2021-01-18 09:45:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334994' ========================2021-01-18 09:45:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334994' ========================2021-01-18 09:45:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334994', '74E5F99FB41F3850E1AD', '039', 'DESKTOP-9NFSC93', '110', '1360', '768', 'sgj3333', '하자보수119[신계주]', '990376035504' ) ========================2021-01-18 15:00:10======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 24F5AAAC63EED7A84FC0 sCDKey = 046965795036 sName = SAMSUNG-PC ========================2021-01-18 15:00:10======================== 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 = '046965795036' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-18 15:00:36======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 24F5AAAC63EED7A84FC0 sCDKey = 076965795036 sName = SAMSUNG-PC ========================2021-01-18 15:00:36======================== 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 = '076965795036' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-18 15:00:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'leesgym' ========================2021-01-18 15:00:36======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAAC63EED7A84FC0' AND app_code = '039' ========================2021-01-18 15:00:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '329204' ========================2021-01-18 15:00:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '329204' ========================2021-01-18 15:00:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '329204', '24F5AAAC63EED7A84FC0', '039', 'SAMSUNG-PC', '90', '1920', '1200', 'leesgym', '명지인더스트리[이한규]', '076965795036' ) ========================2021-01-18 15:00:50======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 24F5AAAC63EED7A84FC0 sCDKey = 076965795036 sName = SAMSUNG-PC ========================2021-01-18 15:00:50======================== 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 = '076965795036' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-18 15:48:19======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00E04CD0E57598119493 sCDKey = 918717095898 sName = POS-PC ========================2021-01-18 15:48:19======================== 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 = '918717095898' AND r.app_code = '047' AND r.app_block = 0 ========================2021-01-18 15:48:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ybbike' ========================2021-01-18 15:48:19======================== SELECT idx FROM macs WHERE mac_addr = '00E04CD0E57598119493' AND app_code = '047' ========================2021-01-18 15:48:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '335104' ========================2021-01-18 15:48:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '335104' ========================2021-01-18 15:48: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 ( '335104', '00E04CD0E57598119493', '047', 'POS-PC', '�쐢�룄�슦 10', '0', '0', 'ybbike', 'yb바이크 성북구자전거가게[김용백]', '918717095898' ) ========================2021-01-18 16:55:18======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-KI5DSD3 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 44AF28C783B4BA430FCE sCDKey = 348062087344 sName = DESKTOP-KI5DSD3 ========================2021-01-18 16:55: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 = '348062087344' AND r.app_code = '047' AND r.app_block = 0 ========================2021-01-18 16:55:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yongmj' ========================2021-01-18 16:55:18======================== SELECT idx FROM macs WHERE mac_addr = '44AF28C783B4BA430FCE' AND app_code = '047' ========================2021-01-18 16:55:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '335112' ========================2021-01-18 16:55:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '335112' ========================2021-01-18 16:55:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '335112', '44AF28C783B4BA430FCE', '047', 'DESKTOP-KI5DSD3', '�쐢�룄�슦 10', '0', '0', 'yongmj', '금강하우징[변영미]', '348062087344' )