========================2018-05-04 07:13:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-98AQJOK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 702C1F10C2FB1409F9F4 sCDKey = 70821409F9F4 sName = DESKTOP-98AQJOK ========================2018-05-04 07:13:44======================== 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 = '70821409F9F4' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-04 07:13:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-98AQJOK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 702C1F10C2FB1409F9F4 sCDKey = 00001409F9F4 sName = DESKTOP-98AQJOK ========================2018-05-04 07:13: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 = '00001409F9F4' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-04 09:16:23======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-5EG05MF parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 7085C27B3F1CC83973BB sCDKey = 760170211075 sName = DESKTOP-5EG05MF ========================2018-05-04 09:16:23======================== 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 = '760170211075' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-04 09:16:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kunok1' ========================2018-05-04 09:16:23======================== SELECT idx FROM macs WHERE mac_addr = '7085C27B3F1CC83973BB' AND app_code = '039' ========================2018-05-04 09:16:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248954' ========================2018-05-04 09:16:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248954' ========================2018-05-04 09:16:23======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248954', '7085C27B3F1CC83973BB', '039', 'DESKTOP-5EG05MF', '110', '1600', '900', 'kunok1', '근옥테크[고상수]', '760170211075' ) ========================2018-05-04 10:44:36======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2 parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00E04C4C219052DF354C sCDKey = 749421869585 sName = POS2 ========================2018-05-04 10:44:36======================== 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 = '749421869585' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-04 10:44:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jg0000' ========================2018-05-04 10:44:36======================== SELECT idx FROM macs WHERE mac_addr = '00E04C4C219052DF354C' AND app_code = '046' ========================2018-05-04 10:44:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248978' ========================2018-05-04 10:44:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248978' ========================2018-05-04 10:44:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248978', '00E04C4C219052DF354C', '046', 'POS2', '90', '1280', '1024', 'jg0000', '중앙식자재마트[김기양]', '749421869585' ) ========================2018-05-04 10:44:47======================== noteurl_start parm_app_code = 046 parm_pc_name = POS2 parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00E04C4C219052DF354C sCDKey = 749421869585 sName = POS2 ========================2018-05-04 10:44:47======================== 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 = '749421869585' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-04 10:44:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jg0000' ========================2018-05-04 10:44:47======================== SELECT idx FROM macs WHERE mac_addr = '00E04C4C219052DF354C' AND app_code = '046' ========================2018-05-04 10:44:47======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248978' ========================2018-05-04 10:44:47======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248978' ========================2018-05-04 10:44:47======================== UPDATE mac_detail SET pc_name = 'POS2', os_type = '90', user_id = 'jg0000', user_name = '중앙식자재마트[김기양]', screen_w = '1280', screen_h = '1024', cdkey = '749421869585' WHERE mac_idx = '248978' ========================2018-05-04 10:46:10======================== noteurl_start parm_app_code = 046 parm_pc_name = POS1 parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 00E04C8083B252DF354C sCDKey = 749421869585 sName = POS1 ========================2018-05-04 10:46: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 = '749421869585' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-04 10:46:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jg0000' ========================2018-05-04 10:46:10======================== SELECT idx FROM macs WHERE mac_addr = '00E04C8083B252DF354C' AND app_code = '046' ========================2018-05-04 10:46:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '208682' ========================2018-05-04 10:46:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '208682' ========================2018-05-04 10:46:10======================== UPDATE mac_detail SET pc_name = 'POS1', os_type = '90', user_id = 'jg0000', user_name = '중앙식자재마트[김기양]', screen_w = '1280', screen_h = '1024', cdkey = '749421869585' WHERE mac_idx = '208682' ========================2018-05-04 15:06:29======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JHK3Q03 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C325EB96784D78 sCDKey = 834943396579 sName = DESKTOP-JHK3Q03 ========================2018-05-04 15:06: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 = '834943396579' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-04 15:06:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wellknown98' ========================2018-05-04 15:06:29======================== SELECT idx FROM macs WHERE mac_addr = '408D5C325EB96784D78' AND app_code = '046' ========================2018-05-04 15:06:29======================== 값이 없을 경우 ========================2018-05-04 15:08:51======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JHK3Q03 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C325EB96784D78 sCDKey = 834943396579 sName = DESKTOP-JHK3Q03 ========================2018-05-04 15:08:51======================== 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 = '834943396579' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-04 15:08:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wellknown98' ========================2018-05-04 15:08:51======================== SELECT idx FROM macs WHERE mac_addr = '408D5C325EB96784D78' AND app_code = '046' ========================2018-05-04 15:08:51======================== 값이 없을 경우 ========================2018-05-04 15:17:32======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JHK3Q03 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5C325EB96784D78 sCDKey = 834943396579 sName = DESKTOP-JHK3Q03 ========================2018-05-04 15:17: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 = '834943396579' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-04 15:17:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'wellknown98' ========================2018-05-04 15:17:32======================== SELECT idx FROM macs WHERE mac_addr = '408D5C325EB96784D78' AND app_code = '046' ========================2018-05-04 15:17:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248997' ========================2018-05-04 15:17:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248997' ========================2018-05-04 15:17: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 ( '248997', '408D5C325EB96784D78', '046', 'DESKTOP-JHK3Q03', '110', '1920', '1080', 'wellknown98', '(주)제이에스엘앤씨[박동식]', '834943396579' ) ========================2018-05-04 15:35:06======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8OHKIU4 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 003067BAEBDFB2760122 sCDKey = 768441341488 sName = DESKTOP-8OHKIU4 ========================2018-05-04 15:35:06======================== 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 = '768441341488' AND r.app_code = '047' AND r.app_block = 0 ========================2018-05-04 15:35:34======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8OHKIU4 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 003067BAEBDFB2760122 sCDKey = 768441341488 sName = DESKTOP-8OHKIU4 ========================2018-05-04 15:35:34======================== 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 = '768441341488' AND r.app_code = '047' AND r.app_block = 0 ========================2018-05-04 15:36:35======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8OHKIU4 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 003067BAEBDFB2760122 sCDKey = 055193099518 sName = DESKTOP-8OHKIU4 ========================2018-05-04 15:36:35======================== 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 = '055193099518' AND r.app_code = '047' AND r.app_block = 0 ========================2018-05-04 15:36:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdod123' ========================2018-05-04 15:36:35======================== SELECT idx FROM macs WHERE mac_addr = '003067BAEBDFB2760122' AND app_code = '047' ========================2018-05-04 15:36:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248999' ========================2018-05-04 15:36:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248999' ========================2018-05-04 15:36:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248999', '003067BAEBDFB2760122', '047', 'DESKTOP-8OHKIU4', '�쐢�룄�슦 10', '0', '0', 'kdod123', '엠제이소프트[송태진]', '055193099518' ) ========================2018-05-04 16:46:43======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = B8975AFDFBFA68C7CAFB sCDKey = 562622642169 sName = OKPOS ========================2018-05-04 16:46:43======================== 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 = '562622642169' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-04 16:46:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'son1518' ========================2018-05-04 16:46:43======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AFDFBFA68C7CAFB' AND app_code = '046' ========================2018-05-04 16:46:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249008' ========================2018-05-04 16:46:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249008' ========================2018-05-04 16:46:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249008', 'B8975AFDFBFA68C7CAFB', '046', 'OKPOS', '110', '1024', '768', 'son1518', '쉐르홈즈전북총판[임숙자]', '562622642169' ) ========================2018-05-04 16:57:34======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 90 parm_screen_w = 768 parm_screen_h = 768 parm_user_mac = 00E0B4148F58B2DBC6B6 sCDKey = 057134299982 sName = POS ========================2018-05-04 16:57:34======================== 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 = '057134299982' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-04 16:57:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hello' ========================2018-05-04 16:57:34======================== SELECT idx FROM macs WHERE mac_addr = '00E0B4148F58B2DBC6B6' AND app_code = '046' ========================2018-05-04 16:57:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248848' ========================2018-05-04 16:57:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248848' ========================2018-05-04 16:57:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248848', '00E0B4148F58B2DBC6B6', '046', 'POS', '90', '768', '768', 'hello', '헬로펫 신탄진점[강형묵]', '057134299982' ) ========================2018-05-04 17:17:43======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-8OHKIU4 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003067BAEBDFB2760122 sCDKey = 298504286643 sName = DESKTOP-8OHKIU4 ========================2018-05-04 17:17:43======================== 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 = '298504286643' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-04 17:17:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdod123' ========================2018-05-04 17:17:43======================== SELECT idx FROM macs WHERE mac_addr = '003067BAEBDFB2760122' AND app_code = '046' ========================2018-05-04 17:17:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248418' ========================2018-05-04 17:17:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248418' ========================2018-05-04 17:17:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '248418', '003067BAEBDFB2760122', '046', 'DESKTOP-8OHKIU4', '110', '1920', '1080', 'kdod123', '엠제이소프트[송태진]', '298504286643' )