========================2021-02-25 11:07:09======================== noteurl_start parm_app_code = 039 parm_pc_name = GRAM-SUNGHUN parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = F82819AB53D1D4C21F41 sCDKey = 683156263623 sName = GRAM-SUNGHUN ========================2021-02-25 11:07: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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2021-02-25 11:07:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bangchun' ========================2021-02-25 11:07:09======================== SELECT idx FROM macs WHERE mac_addr = 'F82819AB53D1D4C21F41' AND app_code = '039' ========================2021-02-25 11:07:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '337752' ========================2021-02-25 11:07:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '337752' ========================2021-02-25 11:07: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 ( '337752', 'F82819AB53D1D4C21F41', '039', 'GRAM-SUNGHUN', '110', '1280', '720', 'bangchun', 'Çѹݵµ[ÀÌÁø¼®]', '683156263623' ) ========================2021-02-25 13:22:10======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-9QQTEVN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8CB0E9177E02A4B64364 sCDKey = 291546858846 sName = DESKTOP-9QQTEVN ========================2021-02-25 13:22: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 = '291546858846' AND r.app_code = '046' AND r.app_block = 0 ========================2021-02-25 13:22:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'leesuk5424' ========================2021-02-25 13:22:10======================== SELECT idx FROM macs WHERE mac_addr = '8CB0E9177E02A4B64364' AND app_code = '046' ========================2021-02-25 13:22:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '337595' ========================2021-02-25 13:22:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '337595' ========================2021-02-25 13:22: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 ( '337595', '8CB0E9177E02A4B64364', '046', 'DESKTOP-9QQTEVN', '110', '1920', '1080', 'leesuk5424', 'ÀÚ¿¬ÇÞ»ìÁÖ½Äȸ»ç[ÀÌÈ«¼÷]', '291546858846' )