========================2019-09-17 11:11:44======================== noteurl_start parm_app_code = 051 parm_pc_name = SKIN-0502662NB1 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B0359F8CA26722171454 sCDKey = 003401679376 sName = center ========================2019-09-17 11:11:44======================== 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 = '003401679376' AND r.app_code = '051' AND r.app_block = 0 ========================2019-09-17 13:44:53======================== noteurl_start parm_app_code = 039 parm_pc_name = PCC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 624F20524153E09DE69B sCDKey = 300172870098 sName = PCC ========================2019-09-17 13:44:53======================== 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 = '300172870098' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-17 13:44:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modern4211' ========================2019-09-17 13:44:53======================== SELECT idx FROM macs WHERE mac_addr = '624F20524153E09DE69B' AND app_code = '039' ========================2019-09-17 13:44:53======================== 값이 없을 경우 ========================2019-09-17 13:46:57======================== noteurl_start parm_app_code = 039 parm_pc_name = PCC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 624F20524153E09DE69B sCDKey = 300172870098 sName = PCC ========================2019-09-17 13:46: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 = '300172870098' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-17 13:46:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'modern4211' ========================2019-09-17 13:46:57======================== SELECT idx FROM macs WHERE mac_addr = '624F20524153E09DE69B' AND app_code = '039' ========================2019-09-17 13:46:57======================== 값이 없을 경우 ========================2019-09-17 13:52:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-TGDLB3S parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA141C3E16BAA24C35 sCDKey = 436154374134 sName = DESKTOP-TGDLB3S ========================2019-09-17 13:52:20======================== 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 = '436154374134' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-17 13:52:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'samhwa05' ========================2019-09-17 13:52:20======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA141C3E16BAA24C35' AND app_code = '039' ========================2019-09-17 13:52:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '296662' ========================2019-09-17 13:52:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '296662' ========================2019-09-17 13:52:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '296662', 'FCAA141C3E16BAA24C35', '039', 'DESKTOP-TGDLB3S', '110', '1920', '1080', 'samhwa05', '삼화프라스틱[이영진]', '436154374134' ) ========================2019-09-17 15:11:19======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-QLE40JF parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 448A5B2146F57A421124 sCDKey = 513199193625 sName = DESKTOP-QLE40JF ========================2019-09-17 15:11: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 = '513199193625' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-17 15:11:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mcyang82' ========================2019-09-17 15:11:19======================== SELECT idx FROM macs WHERE mac_addr = '448A5B2146F57A421124' AND app_code = '039' ========================2019-09-17 15:11:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '296675' ========================2019-09-17 15:11:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '296675' ========================2019-09-17 15:11: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 ( '296675', '448A5B2146F57A421124', '039', 'DESKTOP-QLE40JF', '110', '1680', '1050', 'mcyang82', '구구시스템[양성민]', '513199193625' ) ========================2019-09-17 16:22:19======================== noteurl_start parm_app_code = 039 parm_pc_name = FRAMOKOREA-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 002454340CFCB0434B0F sCDKey = 375473433742 sName = FRAMOKOREA-PC ========================2019-09-17 16:22: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 = '375473433742' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-17 16:22:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mycou' ========================2019-09-17 16:22:19======================== SELECT idx FROM macs WHERE mac_addr = '002454340CFCB0434B0F' AND app_code = '039' ========================2019-09-17 16:22:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269067' ========================2019-09-17 16:22:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269067' ========================2019-09-17 16:22: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 ( '269067', '002454340CFCB0434B0F', '039', 'FRAMOKOREA-PC', '90', '1600', '900', 'mycou', '인제공업사[허영무]', '375473433742' ) ========================2019-09-17 16:47:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3FD8LLL parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 08606E756E01DE2D826B sCDKey = 087474082639 sName = 옥천도금 ========================2019-09-17 16:47:23======================== 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 = '087474082639' AND r.app_code = '039' AND r.app_block = 0 ========================2019-09-17 16:47:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'oc0672' ========================2019-09-17 16:47:23======================== SELECT idx FROM macs WHERE mac_addr = '08606E756E01DE2D826B' AND app_code = '039' ========================2019-09-17 16:47:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '296672' ========================2019-09-17 16:47:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '296672' ========================2019-09-17 16:47:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '296672', '08606E756E01DE2D826B', '039', '옥천도금', '110', '1280', '1024', 'oc0672', '옥천도금[조정익]', '087474082639' )