========================2024-04-01 09:07:32======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-3I290EG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122D27663444E9474 sCDKey = 508057129833 sName = DESKTOP-3I290EG ========================2024-04-01 09:07:32======================== 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 = '508057129833' AND r.app_code = '048' AND r.app_block = 0 ========================2024-04-01 09:07:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dong031kr' ========================2024-04-01 09:07:32======================== SELECT idx FROM macs WHERE mac_addr = '581122D27663444E9474' AND app_code = '048' ========================2024-04-01 09:07:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '403235' ========================2024-04-01 09:07:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '403235' ========================2024-04-01 09:07:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '403235', '581122D27663444E9474', '048', 'DESKTOP-3I290EG', '�쐢�룄�슦 10', '0', '0', 'dong031kr', '참푸드[백성동]', '508057129833' ) ========================2024-04-01 11:15:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4PRKU0R parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = E89C25C162F79084BA16 sCDKey = 299848666998 sName = DESKTOP-4PRKU0R ========================2024-04-01 11:15: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 = '299848666998' AND r.app_code = '039' AND r.app_block = 0 ========================2024-04-01 11:15:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hangil2024' ========================2024-04-01 11:15:57======================== SELECT idx FROM macs WHERE mac_addr = 'E89C25C162F79084BA16' AND app_code = '039' ========================2024-04-01 11:15:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '403302' ========================2024-04-01 11:15:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '403302' ========================2024-04-01 11:15: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 ( '403302', 'E89C25C162F79084BA16', '039', 'DESKTOP-4PRKU0R', '110', '1536', '864', 'hangil2024', '한길테크[이우열]', '299848666998' ) ========================2024-04-01 14:49:55======================== noteurl_start parm_app_code = 055 parm_pc_name = DESKTOP-SPP12Q4 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B06EBFD216EC109223B5 sCDKey = 231546787530 sName = DESKTOP-SPP12Q4 ========================2024-04-01 14:49:55======================== 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 = '231546787530' AND r.app_code = '055' AND r.app_block = 0 ========================2024-04-01 14:49:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sw0213lee' ========================2024-04-01 14:49:55======================== SELECT idx FROM macs WHERE mac_addr = 'B06EBFD216EC109223B5' AND app_code = '055' ========================2024-04-01 14:49:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '403435' ========================2024-04-01 14:49:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '403435' ========================2024-04-01 14:49:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '403435', 'B06EBFD216EC109223B5', '055', 'DESKTOP-SPP12Q4', '�쐢�룄�슦 10', '0', '0', 'sw0213lee', '명석종합전기[이설원]', '231546787530' ) ========================2024-04-01 16:57:08======================== noteurl_start parm_app_code = 046 parm_pc_name = POS4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74563C9E4064C0A222C3 sCDKey = 319243365467 sName = POS4 ========================2024-04-01 16:57:08======================== 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 = '319243365467' AND r.app_code = '046' AND r.app_block = 0 ========================2024-04-01 16:57:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyk0909' ========================2024-04-01 16:57:08======================== SELECT idx FROM macs WHERE mac_addr = '74563C9E4064C0A222C3' AND app_code = '046' ========================2024-04-01 16:57:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '403451' ========================2024-04-01 16:57:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '403451' ========================2024-04-01 16:57:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '403451', '74563C9E4064C0A222C3', '046', 'POS4', '110', '1920', '1080', 'kyk0909', '동양종합식품[김영국]', '319243365467' ) ========================2024-04-01 17:22:50======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74563CD6001C1C33BA75 sCDKey = 319243365467 sName = POS2 ========================2024-04-01 17:22:50======================== 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 = '319243365467' AND r.app_code = '046' AND r.app_block = 0 ========================2024-04-01 17:22:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyk0909' ========================2024-04-01 17:22:50======================== SELECT idx FROM macs WHERE mac_addr = '74563CD6001C1C33BA75' AND app_code = '046' ========================2024-04-01 17:22:50======================== 값이 없을 경우 ========================2024-04-01 17:23:10======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74563CD6001C1C33BA75 sCDKey = 319243365467 sName = POS2 ========================2024-04-01 17:23: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 = '319243365467' AND r.app_code = '046' AND r.app_block = 0 ========================2024-04-01 17:23:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyk0909' ========================2024-04-01 17:23:10======================== SELECT idx FROM macs WHERE mac_addr = '74563CD6001C1C33BA75' AND app_code = '046' ========================2024-04-01 17:23:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '403454' ========================2024-04-01 17:23:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '403454' ========================2024-04-01 17:23:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '403454', '74563CD6001C1C33BA75', '046', 'POS2', '110', '1920', '1080', 'kyk0909', '동양종합식품[김영국]', '319243365467' ) ========================2024-04-01 17:47:54======================== noteurl_start parm_app_code = 046 parm_pc_name = POS3 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 74563C9EC24C90254FFB sCDKey = 319243365467 sName = POS3 ========================2024-04-01 17:47:54======================== 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 = '319243365467' AND r.app_code = '046' AND r.app_block = 0 ========================2024-04-01 17:47:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyk0909' ========================2024-04-01 17:47:54======================== SELECT idx FROM macs WHERE mac_addr = '74563C9EC24C90254FFB' AND app_code = '046' ========================2024-04-01 17:47:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '403457' ========================2024-04-01 17:47:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '403457' ========================2024-04-01 17:47:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '403457', '74563C9EC24C90254FFB', '046', 'POS3', '110', '1600', '900', 'kyk0909', '동양종합식품[김영국]', '319243365467' )