========================2020-06-04 09:45:05======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JU2O5EL parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 0C9D9212602988F3BF5D sCDKey = 658340978890 sName = DESKTOP-JU2O5EL ========================2020-06-04 09:45:05======================== 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 = '658340978890' AND r.app_code = '046' AND r.app_block = 0 ========================2020-06-04 09:45:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'prolinesmj' ========================2020-06-04 09:45:06======================== SELECT idx FROM macs WHERE mac_addr = '0C9D9212602988F3BF5D' AND app_code = '046' ========================2020-06-04 09:45:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '318995' ========================2020-06-04 09:45:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '318995' ========================2020-06-04 09:45:06======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '318995', '0C9D9212602988F3BF5D', '046', 'DESKTOP-JU2O5EL', '110', '1366', '768', 'prolinesmj', '핫독애견용품 덕천점[최창수]', '658340978890' ) ========================2020-06-04 10:21:03======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2020-06-04 10:21:03======================== 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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-04 10:23:37======================== noteurl_start parm_app_code = 039 parm_pc_name = HANDO parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981F74D76D7F1ED sCDKey = 173379187341 sName = HANDO ========================2020-06-04 10:23:37======================== 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 = '173379187341' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-04 10:23:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hando77' ========================2020-06-04 10:23:37======================== SELECT idx FROM macs WHERE mac_addr = '98838981F74D76D7F1ED' AND app_code = '039' ========================2020-06-04 10:23:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235354' ========================2020-06-04 10:23:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235354' ========================2020-06-04 10:23:37======================== UPDATE mac_detail SET pc_name = 'HANDO', os_type = '110', user_id = 'hando77', user_name = '한도교역[한도교역]', screen_w = '1920', screen_h = '1080', cdkey = '173379187341' WHERE mac_idx = '235354' ========================2020-06-04 10:40:26======================== noteurl_start parm_app_code = 039 parm_pc_name = MRC-20160925VXU parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1078D2D0ABF416E05707 sCDKey = 915449382845 sName = MRC-20160925VXU ========================2020-06-04 10:40:26======================== 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 = '915449382845' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-04 10:40:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bs470' ========================2020-06-04 10:40:26======================== SELECT idx FROM macs WHERE mac_addr = '1078D2D0ABF416E05707' AND app_code = '039' ========================2020-06-04 10:40:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319004' ========================2020-06-04 10:40:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319004' ========================2020-06-04 10:40:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319004', '1078D2D0ABF416E05707', '039', 'MRC-20160925VXU', '90', '1920', '1080', 'bs470', '우성뉴매틱남부[부산지사]', '915449382845' ) ========================2020-06-04 11:12:26======================== noteurl_start parm_app_code = 039 parm_pc_name = USER parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = BC5FF4094008BA5F4CA4 sCDKey = 244942174075 sName = 김경주 ========================2020-06-04 11:12:26======================== 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 = '244942174075' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-04 11:12:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyungju0516' ========================2020-06-04 11:12:26======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4094008BA5F4CA4' AND app_code = '039' ========================2020-06-04 11:12:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319011' ========================2020-06-04 11:12:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319011' ========================2020-06-04 11:12:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319011', 'BC5FF4094008BA5F4CA4', '039', '김경주', '90', '1280', '1024', 'kyungju0516', '경주산업[김경주]', '244942174075' ) ========================2020-06-04 17:00:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-GJFA9N0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A8A1591EA42FAAD621C4 sCDKey = 084682829041 sName = DESKTOP-GJFA9N0 ========================2020-06-04 17:00: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 = '084682829041' AND r.app_code = '039' AND r.app_block = 0 ========================2020-06-04 17:00:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kkmtac' ========================2020-06-04 17:00:57======================== SELECT idx FROM macs WHERE mac_addr = 'A8A1591EA42FAAD621C4' AND app_code = '039' ========================2020-06-04 17:00:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '319053' ========================2020-06-04 17:00:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '319053' ========================2020-06-04 17:00:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '319053', 'A8A1591EA42FAAD621C4', '039', 'DESKTOP-GJFA9N0', '110', '1920', '1080', 'kkmtac', '(주)부경피티씨[김경민]', '084682829041' )