========================2019-08-30 11:25:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7V4AF4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F640205241533EFC0AEC sCDKey = 853846793831 sName = DESKTOP-L7V4AF4 ========================2019-08-30 11:25: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 11:25:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2019-08-30 11:25:57======================== SELECT idx FROM macs WHERE mac_addr = 'F640205241533EFC0AEC' AND app_code = '039' ========================2019-08-30 11:25:57======================== 값이 없을 경우 ========================2019-08-30 11:26:11======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7V4AF4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F640205241533EFC0AEC sCDKey = 853846793831 sName = DESKTOP-L7V4AF4 ========================2019-08-30 11:26:11======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 11:26:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2019-08-30 11:26:11======================== SELECT idx FROM macs WHERE mac_addr = 'F640205241533EFC0AEC' AND app_code = '039' ========================2019-08-30 11:26:11======================== 값이 없을 경우 ========================2019-08-30 11:26:14======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7V4AF4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F640205241533EFC0AEC sCDKey = 853846793831 sName = DESKTOP-L7V4AF4 ========================2019-08-30 11:26:14======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 11:26:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2019-08-30 11:26:14======================== SELECT idx FROM macs WHERE mac_addr = 'F640205241533EFC0AEC' AND app_code = '039' ========================2019-08-30 11:26:14======================== 값이 없을 경우 ========================2019-08-30 11:26:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7V4AF4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F640205241533EFC0AEC sCDKey = 853846793831 sName = DESKTOP-L7V4AF4 ========================2019-08-30 11:26: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 11:26:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2019-08-30 11:26:23======================== SELECT idx FROM macs WHERE mac_addr = 'F640205241533EFC0AEC' AND app_code = '039' ========================2019-08-30 11:26:23======================== 값이 없을 경우 ========================2019-08-30 11:29:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7V4AF4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F640205241533EFC0AEC sCDKey = 853846793831 sName = DESKTOP-L7V4AF4 ========================2019-08-30 11:29:33======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 11:29:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2019-08-30 11:29:33======================== SELECT idx FROM macs WHERE mac_addr = 'F640205241533EFC0AEC' AND app_code = '039' ========================2019-08-30 11:29:33======================== 값이 없을 경우 ========================2019-08-30 11:36:07======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7V4AF4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F640205241533EFC0AEC sCDKey = 853846793831 sName = DESKTOP-L7V4AF4 ========================2019-08-30 11:36:07======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 11:36:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2019-08-30 11:36:07======================== SELECT idx FROM macs WHERE mac_addr = 'F640205241533EFC0AEC' AND app_code = '039' ========================2019-08-30 11:36:07======================== 값이 없을 경우 ========================2019-08-30 11:40:28======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7V4AF4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 34A8205241533EFC0AEC sCDKey = 853846793831 sName = DESKTOP-L7V4AF4 ========================2019-08-30 11:40:28======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 11:40:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2019-08-30 11:40:28======================== SELECT idx FROM macs WHERE mac_addr = '34A8205241533EFC0AEC' AND app_code = '039' ========================2019-08-30 11:40:28======================== 값이 없을 경우 ========================2019-08-30 11:41:31======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L7V4AF4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 34A8205241533EFC0AEC sCDKey = 853846793831 sName = DESKTOP-L7V4AF4 ========================2019-08-30 11:41:31======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 11:41:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2019-08-30 11:41:31======================== SELECT idx FROM macs WHERE mac_addr = '34A8205241533EFC0AEC' AND app_code = '039' ========================2019-08-30 11:41:31======================== 값이 없을 경우 ========================2019-08-30 15:25:09======================== noteurl_start parm_app_code = 047 parm_pc_name = MIJIN_JUNPYO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 005056C0000838540FC2 sCDKey = 433586618041 sName = MIJIN_JUNPYO ========================2019-08-30 15:25:09======================== 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 = '433586618041' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-30 15:25:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tkekcomtest' ========================2019-08-30 15:25:09======================== SELECT idx FROM macs WHERE mac_addr = '005056C0000838540FC2' AND app_code = '047' ========================2019-08-30 15:25:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '216783' ========================2019-08-30 15:25:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '216783' ========================2019-08-30 15:25:09======================== UPDATE mac_detail SET pc_name = 'MIJIN_JUNPYO', os_type = '�쐢�룄�슦 10', user_id = 'tkekcomtest', user_name = '엠제이소프트[김준표(mj)]', screen_w = '0', screen_h = '0', cdkey = '433586618041' WHERE mac_idx = '216783' ========================2019-08-30 15:52:09======================== noteurl_start parm_app_code = 045 parm_pc_name = JJPNET parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 988389154104D0AC9486 sCDKey = 146996398397 sName = JJPNET ========================2019-08-30 15:52:09======================== 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 = '146996398397' AND r.app_code = '045' AND r.app_block = 0 ========================2019-08-30 15:52:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nfkorea' ========================2019-08-30 15:52:09======================== SELECT idx FROM macs WHERE mac_addr = '988389154104D0AC9486' AND app_code = '045' ========================2019-08-30 15:52:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294436' ========================2019-08-30 15:52:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294436' ========================2019-08-30 15:52:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '294436', '988389154104D0AC9486', '045', 'JJPNET', '90', '1366', '768', 'nfkorea', '엔에프코리아[최신혜]', '146996398397' ) ========================2019-08-30 15:54:27======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = E84920524153C8045B50 sCDKey = 935851285112 sName = 유니푸드텍 ========================2019-08-30 15:54: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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 15:54:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2019-08-30 15:54:27======================== SELECT idx FROM macs WHERE mac_addr = 'E84920524153C8045B50' AND app_code = '039' ========================2019-08-30 15:54:27======================== 값이 없을 경우 ========================2019-08-30 15:55:45======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = E84920524153C8045B50 sCDKey = 935851285112 sName = 유니푸드텍 ========================2019-08-30 15:55:45======================== 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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 15:55:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2019-08-30 15:55:45======================== SELECT idx FROM macs WHERE mac_addr = 'E84920524153C8045B50' AND app_code = '039' ========================2019-08-30 15:55:45======================== 값이 없을 경우 ========================2019-08-30 15:58:59======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = E84920524153C8045B50 sCDKey = 935851285112 sName = 1 ========================2019-08-30 15:58: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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 15:58:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2019-08-30 15:58:59======================== SELECT idx FROM macs WHERE mac_addr = 'E84920524153C8045B50' AND app_code = '039' ========================2019-08-30 15:58:59======================== 값이 없을 경우 ========================2019-08-30 16:00:27======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = E84920524153C8045B50 sCDKey = 935851285112 sName = 1 ========================2019-08-30 16:00: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 = '935851285112' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 16:00:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'unifoodkorea' ========================2019-08-30 16:00:27======================== SELECT idx FROM macs WHERE mac_addr = 'E84920524153C8045B50' AND app_code = '039' ========================2019-08-30 16:00:27======================== 값이 없을 경우 ========================2019-08-30 16:35:45======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-30 16:35:45======================== 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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 16:39:43======================== noteurl_start parm_app_code = 039 parm_pc_name = RYU-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0000000000055633C922 sCDKey = 343190615587 sName = RYU-PC ========================2019-08-30 16:39:43======================== 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 = '343190615587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-30 16:39:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rjd6243' ========================2019-08-30 16:39:43======================== SELECT idx FROM macs WHERE mac_addr = '0000000000055633C922' AND app_code = '039' ========================2019-08-30 16:39:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '294376' ========================2019-08-30 16:39:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '294376' ========================2019-08-30 16:39:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '294376', '0000000000055633C922', '039', 'RYU-PC', '90', '1920', '1080', 'rjd6243', '대우메디텍[류재덕]', '343190615587' )