========================2021-03-26 10:13:10======================== noteurl_start parm_app_code = 046 parm_pc_name = PB-VCHJ7HQ0MQTV parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = D897BA81D04AC0A59A4B sCDKey = 776035659991 sName = PB-VCHJ7HQ0MQTV ========================2021-03-26 10:13: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 = '776035659991' AND r.app_code = '046' AND r.app_block = 0 ========================2021-03-26 10:13:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'millepet1' ========================2021-03-26 10:13:10======================== SELECT idx FROM macs WHERE mac_addr = 'D897BA81D04AC0A59A4B' AND app_code = '046' ========================2021-03-26 10:13:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '233979' ========================2021-03-26 10:13:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '233979' ========================2021-03-26 10:13:10======================== UPDATE mac_detail SET pc_name = 'PB-VCHJ7HQ0MQTV', os_type = '64', user_id = 'millepet1', user_name = '밀레펫주식회사[심준희]', screen_w = '1024', screen_h = '768', cdkey = '776035659991' WHERE mac_idx = '233979' ========================2021-03-26 10:57:12======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-FB4Q5II parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A8A1594EDE9A32E85C33 sCDKey = 037433637550 sName = DESKTOP-FB4Q5II ========================2021-03-26 10:57: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 = '037433637550' AND r.app_code = '048' AND r.app_block = 0 ========================2021-03-26 10:57:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hpf1937' ========================2021-03-26 10:57:12======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1594EDE9A32E85C33' AND app_code = '048' ========================2021-03-26 10:57:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339744' ========================2021-03-26 10:57:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '339744' ========================2021-03-26 10:57: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 ( '339744', 'A8A1594EDE9A32E85C33', '048', 'DESKTOP-FB4Q5II', '�쐢�룄�슦 10', '0', '0', 'hpf1937', '주식회사 햇품유통[이남훈]', '037433637550' ) ========================2021-03-26 13:20:41======================== noteurl_start parm_app_code = 039 parm_pc_name = 양하연 parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 24F5AA73BEED49ED33E sCDKey = 018679125058 sName = 양하연 ========================2021-03-26 13:20:41======================== 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 = '018679125058' AND r.app_code = '039' AND r.app_block = 0 ========================2021-03-26 13:20:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hhh1694' ========================2021-03-26 13:20:42======================== SELECT idx FROM macs WHERE mac_addr = '24F5AA73BEED49ED33E' AND app_code = '039' ========================2021-03-26 13:20:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339750' ========================2021-03-26 13:20:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '339750' ========================2021-03-26 13:20:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '339750', '24F5AA73BEED49ED33E', '039', '양하연', '110', '1366', '768', 'hhh1694', '수타상사[오윤미]', '018679125058' ) ========================2021-03-26 13:23:59======================== noteurl_start parm_app_code = 047 parm_pc_name = 한스머프 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 4CCC6A8FB255883AEBA4 sCDKey = 571336382795 sName = 한스머프 ========================2021-03-26 13:23:59======================== 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 = '571336382795' AND r.app_code = '047' AND r.app_block = 0 ========================2021-03-26 13:23:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hadogi' ========================2021-03-26 13:23:59======================== SELECT idx FROM macs WHERE mac_addr = '4CCC6A8FB255883AEBA4' AND app_code = '047' ========================2021-03-26 13:23:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339762' ========================2021-03-26 13:23:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '339762' ========================2021-03-26 13:23: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 ( '339762', '4CCC6A8FB255883AEBA4', '047', '한스머프', '�쐢�룄�슦 7', '0', '0', 'hadogi', '어업회사법인(주)해어찬[김학철]', '571336382795' ) ========================2021-03-26 14:27:35======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-FQQKNSM parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00E93A246E11604AEA81 sCDKey = 382656506970 sName = DESKTOP-FQQKNSM ========================2021-03-26 14:27:35======================== 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 = '382656506970' AND r.app_code = '047' AND r.app_block = 0 ========================2021-03-26 14:27:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mijung0416' ========================2021-03-26 14:27:35======================== SELECT idx FROM macs WHERE mac_addr = '00E93A246E11604AEA81' AND app_code = '047' ========================2021-03-26 14:27:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339772' ========================2021-03-26 14:27:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '339772' ========================2021-03-26 14:27:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '339772', '00E93A246E11604AEA81', '047', 'DESKTOP-FQQKNSM', '�쐢�룄�슦 10', '0', '0', 'mijung0416', '언니의픽[김성희]', '382656506970' ) ========================2021-03-26 14:30:57======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-070F80L parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CF05DB73B96D4974592 sCDKey = 886585114869 sName = DESKTOP-070F80L ========================2021-03-26 14:30:57======================== 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 = '886585114869' AND r.app_code = '048' AND r.app_block = 0 ========================2021-03-26 14:30:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hak79' ========================2021-03-26 14:30:58======================== SELECT idx FROM macs WHERE mac_addr = '2CF05DB73B96D4974592' AND app_code = '048' ========================2021-03-26 14:30:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '339777' ========================2021-03-26 14:30:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '339777' ========================2021-03-26 14:30:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '339777', '2CF05DB73B96D4974592', '048', 'DESKTOP-070F80L', '�쐢�룄�슦 10', '0', '0', 'hak79', '[이봉학1]', '886585114869' )