========================2022-09-24 09:36:04======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00E04CB2C40EE4C8F79C sCDKey = 278125570271 sName = 포스4번 ========================2022-09-24 09:36:04======================== 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 = '278125570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-09-24 09:36:25======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00E04CB2C40EE4C8F79C sCDKey = 278126570271 sName = 포스4번 ========================2022-09-24 09:36:25======================== 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 = '278126570271' AND r.app_code = '047' AND r.app_block = 0 ========================2022-09-24 09:36:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hmh563' ========================2022-09-24 09:36:25======================== SELECT idx FROM macs WHERE mac_addr = '00E04CB2C40EE4C8F79C' AND app_code = '047' ========================2022-09-24 09:36:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '362149' ========================2022-09-24 09:36:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '362149' ========================2022-09-24 09:36:25======================== UPDATE mac_detail SET pc_name = '포스4번', os_type = '�쐢�룄�슦 10', user_id = 'hmh563', user_name = '동광종합물산[한민희]', screen_w = '0', screen_h = '0', cdkey = '278126570271' WHERE mac_idx = '362149' ========================2022-09-24 20:08:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SLSBKFS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3024A94A610B5C0637E6 sCDKey = 422114683375 sName = DESKTOP-SLSBKFS ========================2022-09-24 20:08:29======================== 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 = '422114683375' AND r.app_code = '039' AND r.app_block = 0 ========================2022-09-24 20:08:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'id4love' ========================2022-09-24 20:08:30======================== SELECT idx FROM macs WHERE mac_addr = '3024A94A610B5C0637E6' AND app_code = '039' ========================2022-09-24 20:08:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '374068' ========================2022-09-24 20:08:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '374068' ========================2022-09-24 20:08:30======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '374068', '3024A94A610B5C0637E6', '039', 'DESKTOP-SLSBKFS', '110', '1920', '1080', 'id4love', '파란컴퓨터[김현우]', '422114683375' )