========================2018-06-14 09:11:13======================== noteurl_start parm_app_code = 039 parm_pc_name = 사용자-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 0013775905A938E8669E sCDKey = 095884872865 sName = 사용자-PC ========================2018-06-14 09:11:13======================== 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 = '095884872865' AND r.app_code = '039' AND r.app_block = 0 ========================2018-06-14 09:11:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jxlovep1' ========================2018-06-14 09:11:13======================== SELECT idx FROM macs WHERE mac_addr = '0013775905A938E8669E' AND app_code = '039' ========================2018-06-14 09:11:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250523' ========================2018-06-14 09:11:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250523' ========================2018-06-14 09:11:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '250523', '0013775905A938E8669E', '039', '사용자-PC', '90', '1600', '900', 'jxlovep1', '동서울중앙교회[박범종]', '095884872865' ) ========================2018-06-14 12:25:07======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-PC1-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 1831BF4F7AE4FCC4D116 sCDKey = 951887133959 sName = POS-PC1-PC ========================2018-06-14 12:25:07======================== 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 = '951887133959' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-14 12:25:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodnom35' ========================2018-06-14 12:25:07======================== SELECT idx FROM macs WHERE mac_addr = '1831BF4F7AE4FCC4D116' AND app_code = '046' ========================2018-06-14 12:25:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '251621' ========================2018-06-14 12:25:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '251621' ========================2018-06-14 12:25:07======================== UPDATE mac_detail SET pc_name = 'POS-PC1-PC', os_type = '90', user_id = 'goodnom35', user_name = '일등식품[소인환]', screen_w = '1280', screen_h = '1024', cdkey = '951887133959' WHERE mac_idx = '251621' ========================2018-06-14 13:35:26======================== noteurl_start parm_app_code = 046 parm_pc_name = POS1 parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA40104C84246ADD8 sCDKey = 951887133959 sName = POS1 ========================2018-06-14 13:35: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 = '951887133959' AND r.app_code = '046' AND r.app_block = 0 ========================2018-06-14 13:35:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodnom35' ========================2018-06-14 13:35:26======================== SELECT idx FROM macs WHERE mac_addr = '68EDA40104C84246ADD8' AND app_code = '046' ========================2018-06-14 13:35:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '229872' ========================2018-06-14 13:35:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '229872' ========================2018-06-14 13:35:26======================== UPDATE mac_detail SET pc_name = 'POS1', os_type = '90', user_id = 'goodnom35', user_name = '일등식품[소인환]', screen_w = '1024', screen_h = '768', cdkey = '951887133959' WHERE mac_idx = '229872' ========================2018-06-14 13:45:25======================== noteurl_start parm_app_code = 047 parm_pc_name = MIJIN_JUNPYO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 3497F693221638540FC2 sCDKey = 473620408060 sName = MIJIN_JUNPYO ========================2018-06-14 13:45: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 = '473620408060' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-14 13:45:39======================== noteurl_start parm_app_code = 047 parm_pc_name = MIJIN_JUNPYO parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 3497F693221638540FC2 sCDKey = 473620408060 sName = MIJIN_JUNPYO ========================2018-06-14 13:45:39======================== 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 = '473620408060' AND r.app_code = '047' AND r.app_block = 0 ========================2018-06-14 13:45:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tkekcom' ========================2018-06-14 13:45:39======================== SELECT idx FROM macs WHERE mac_addr = '3497F693221638540FC2' AND app_code = '047' ========================2018-06-14 13:45:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '252006' ========================2018-06-14 13:45:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '252006' ========================2018-06-14 13:45:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '252006', '3497F693221638540FC2', '047', 'MIJIN_JUNPYO', '�쐢�룄�슦 10', '0', '0', 'tkekcom', '엠제이소프트[김준표]', '473620408060' )