========================2018-05-02 06:39:02======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-MCITE40DMQL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E04C68009B16A63CF3 sCDKey = 191195918677 sName = WIN-MCITE40DMQL ========================2018-05-02 06:39:02======================== 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 = '191195918677' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-02 06:39:36======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-MCITE40DMQL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E04C68009B16A63CF3 sCDKey = 191195918677 sName = WIN-MCITE40DMQL ========================2018-05-02 06:39: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 = '191195918677' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-02 06:40:44======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-MCITE40DMQL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00E04C68009B16A63CF3 sCDKey = 191195918677 sName = WIN-MCITE40DMQL ========================2018-05-02 06:40: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 = '191195918677' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-02 15:03:13======================== noteurl_start parm_app_code = 048 parm_pc_name = 한지수 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 6C626D5D391AAE81FA52 sCDKey = 825088734286 sName = 한지수 ========================2018-05-02 15:03:13======================== 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 = '825088734286' AND r.app_code = '048' AND r.app_block = 0 ========================2018-05-02 15:03:42======================== noteurl_start parm_app_code = 048 parm_pc_name = 한지수 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 6C626D5D391AAE81FA52 sCDKey = 825088734286 sName = 한지수 ========================2018-05-02 15:03:42======================== 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 = '825088734286' AND r.app_code = '048' AND r.app_block = 0 ========================2018-05-02 15:03:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjs1' ========================2018-05-02 15:03:42======================== SELECT idx FROM macs WHERE mac_addr = '6C626D5D391AAE81FA52' AND app_code = '048' ========================2018-05-02 15:03:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '243935' ========================2018-05-02 15:03:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '243935' ========================2018-05-02 15:03:42======================== UPDATE mac_detail SET pc_name = '한지수', os_type = '�쐢�룄�슦 10', user_id = 'hjs1', user_name = '엠제이소프트[한지수1]', screen_w = '0', screen_h = '0', cdkey = '825088734286' WHERE mac_idx = '243935' ========================2018-05-02 16:28:43======================== noteurl_start parm_app_code = 039 parm_pc_name = YR-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23169E3C8995752 sCDKey = 792270009777 sName = YR-PC ========================2018-05-02 16:28: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 = '792270009777' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-02 16:28:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jk2014421' ========================2018-05-02 16:28:43======================== SELECT idx FROM macs WHERE mac_addr = '7085C23169E3C8995752' AND app_code = '039' ========================2018-05-02 16:28:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248785' ========================2018-05-02 16:28:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248785' ========================2018-05-02 16:28: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 ( '248785', '7085C23169E3C8995752', '039', 'YR-PC', '90', '1920', '1080', 'jk2014421', '제이케이디자인주식회사[인선희]', '792270009777' )