========================2024-08-14 14:23:38======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-L1JGD5N parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E2BF69FCC91B851 sCDKey = 338270963977 sName = DESKTOP-L1JGD5N ========================2024-08-14 14:23:38======================== 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 = '338270963977' AND r.app_code = '039' AND r.app_block = 0 ========================2024-08-14 14:23:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daall2004' ========================2024-08-14 14:23:38======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E2BF69FCC91B851' AND app_code = '039' ========================2024-08-14 14:23:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '409700' ========================2024-08-14 14:23:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '409700' ========================2024-08-14 14:23:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '409700', 'E0D55E2BF69FCC91B851', '039', 'DESKTOP-L1JGD5N', '110', '1920', '1080', 'daall2004', '(주)다올정밀[(주)다올정밀]', '338270963977' ) ========================2024-08-14 16:38:28======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-J7QBBOP parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = D843AE45E3FEF6140DA4 sCDKey = 320550890604 sName = DESKTOP-J7QBBOP ========================2024-08-14 16:38: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 = '320550890604' AND r.app_code = '039' AND r.app_block = 0 ========================2024-08-14 16:38:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jwon' ========================2024-08-14 16:38:28======================== SELECT idx FROM macs WHERE mac_addr = 'D843AE45E3FEF6140DA4' AND app_code = '039' ========================2024-08-14 16:38:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '409709' ========================2024-08-14 16:38:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '409709' ========================2024-08-14 16:38:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '409709', 'D843AE45E3FEF6140DA4', '039', 'DESKTOP-J7QBBOP', '110', '1600', '900', 'jwon', '제이원[태재원]', '320550890604' )