========================2018-01-22 09:26:56======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-AHJ2UAR parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883898182284CA1F0E3 sCDKey = 434133617514 sName = DESKTOP-AHJ2UAR ========================2018-01-22 09:26:56======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-01-22 09:26:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-01-22 09:26:56======================== SELECT idx FROM macs WHERE mac_addr = '9883898182284CA1F0E3' AND app_code = '048' ========================2018-01-22 09:26:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239964' ========================2018-01-22 09:26:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239964' ========================2018-01-22 09:26:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239964', '9883898182284CA1F0E3', '048', 'DESKTOP-AHJ2UAR', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2018-01-22 09:45:12======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 909F330C31B286C2E80F sCDKey = 224412850603 sName = 제우산업 ========================2018-01-22 09:45:12======================== 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 = '224412850603' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 09:45:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pjk8298' ========================2018-01-22 09:45:12======================== SELECT idx FROM macs WHERE mac_addr = '909F330C31B286C2E80F' AND app_code = '039' ========================2018-01-22 09:45:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239992' ========================2018-01-22 09:45:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239992' ========================2018-01-22 09:45:12======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239992', '909F330C31B286C2E80F', '039', '제우산업', '90', '1600', '900', 'pjk8298', '제우산업[박종길]', '224412850603' ) ========================2018-01-22 10:22:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LG42LDA parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 408D5C713740BC12C310 sCDKey = 363621144146 sName = DESKTOP-LG42LDA ========================2018-01-22 10:22: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 = '363621144146' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 10:22:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pjh1692' ========================2018-01-22 10:22:29======================== SELECT idx FROM macs WHERE mac_addr = '408D5C713740BC12C310' AND app_code = '039' ========================2018-01-22 10:22:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239911' ========================2018-01-22 10:22:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239911' ========================2018-01-22 10:22:29======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239911', '408D5C713740BC12C310', '039', 'DESKTOP-LG42LDA', '110', '1600', '900', 'pjh1692', '(주)고려철물건재[박지환]', '363621144146' ) ========================2018-01-22 10:22:37======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LG42LDA parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 408D5C713740BC12C310 sCDKey = 363621144146 sName = DESKTOP-LG42LDA ========================2018-01-22 10:22:37======================== 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 = '363621144146' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 10:22:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LG42LDA parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 408D5C713740BC12C310 sCDKey = 363621144146 sName = DESKTOP-LG42LDA ========================2018-01-22 10:22:48======================== 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 = '363621144146' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 10:23:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LG42LDA parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 408D5C713740BC12C310 sCDKey = 363621144146 sName = DESKTOP-LG42LDA ========================2018-01-22 10:23:42======================== 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 = '363621144146' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 10:23:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pjh1692' ========================2018-01-22 10:23:42======================== SELECT idx FROM macs WHERE mac_addr = '408D5C713740BC12C310' AND app_code = '039' ========================2018-01-22 10:23:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239911' ========================2018-01-22 10:23:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239911' ========================2018-01-22 10:23:42======================== UPDATE mac_detail SET pc_name = 'DESKTOP-LG42LDA', os_type = '110', user_id = 'pjh1692', user_name = '(주)고려철물건재[박지환]', screen_w = '1600', screen_h = '900', cdkey = '363621144146' WHERE mac_idx = '239911' ========================2018-01-22 10:23:45======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LG42LDA parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 408D5C713740BC12C310 sCDKey = 363621144146 sName = DESKTOP-LG42LDA ========================2018-01-22 10:23:45======================== 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 = '363621144146' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 10:26:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LG42LDA parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 408D5C713740BC12C310 sCDKey = 363621144146 sName = DESKTOP-LG42LDA ========================2018-01-22 10:26:21======================== 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 = '363621144146' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 10:26:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pjh1692' ========================2018-01-22 10:26:21======================== SELECT idx FROM macs WHERE mac_addr = '408D5C713740BC12C310' AND app_code = '039' ========================2018-01-22 10:26:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239911' ========================2018-01-22 10:26:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239911' ========================2018-01-22 10:26:21======================== UPDATE mac_detail SET pc_name = 'DESKTOP-LG42LDA', os_type = '110', user_id = 'pjh1692', user_name = '(주)고려철물건재[박지환]', screen_w = '1600', screen_h = '900', cdkey = '363621144146' WHERE mac_idx = '239911' ========================2018-01-22 11:13:19======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 001377CB32C41230F0C3 sCDKey = 853846793831 sName = USER-PC ========================2018-01-22 11:13:19======================== 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 11:13:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-01-22 11:13:19======================== SELECT idx FROM macs WHERE mac_addr = '001377CB32C41230F0C3' AND app_code = '039' ========================2018-01-22 11:13:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240009' ========================2018-01-22 11:13:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240009' ========================2018-01-22 11:13:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240009', '001377CB32C41230F0C3', '039', 'USER-PC', '90', '1360', '768', 'ijs7740', '(주)고려양행[김기범]', '853846793831' ) ========================2018-01-22 11:16:56======================== noteurl_start parm_app_code = 039 parm_pc_name = KOJ-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00270E1225827281B5B8 sCDKey = 341505658679 sName = KOJ-PC ========================2018-01-22 11:16:56======================== 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 = '341505658679' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 11:16:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aa8132532' ========================2018-01-22 11:16:56======================== SELECT idx FROM macs WHERE mac_addr = '00270E1225827281B5B8' AND app_code = '039' ========================2018-01-22 11:16:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240011' ========================2018-01-22 11:16:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240011' ========================2018-01-22 11:16:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240011', '00270E1225827281B5B8', '039', 'KOJ-PC', '90', '1920', '1080', 'aa8132532', '연수식자재[박창문]', '341505658679' ) ========================2018-01-22 11:34:02======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-9A8SRQS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883897E060368F70999 sCDKey = 434133617514 sName = DESKTOP-9A8SRQS ========================2018-01-22 11:34:02======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-01-22 11:34:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-01-22 11:34:02======================== SELECT idx FROM macs WHERE mac_addr = '9883897E060368F70999' AND app_code = '048' ========================2018-01-22 11:34:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240015' ========================2018-01-22 11:34:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240015' ========================2018-01-22 11:34:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240015', '9883897E060368F70999', '048', 'DESKTOP-9A8SRQS', '�쐢�룄�슦 10', '0', '0', 'weblink', '대성활어[강정미]', '434133617514' ) ========================2018-01-22 11:34:12======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-9A8SRQS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883897E060368F70999 sCDKey = 434133617514 sName = DESKTOP-9A8SRQS ========================2018-01-22 11:34:12======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-01-22 11:34:26======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-9A8SRQS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883897E060368F70999 sCDKey = 434133617514 sName = DESKTOP-9A8SRQS ========================2018-01-22 11:34: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-01-22 11:34:54======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-9A8SRQS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883897E060368F70999 sCDKey = 434133617514 sName = DESKTOP-9A8SRQS ========================2018-01-22 11:34:54======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-01-22 11:36:49======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-9A8SRQS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9883897E060368F70999 sCDKey = 434133617514 sName = DESKTOP-9A8SRQS ========================2018-01-22 11:36:49======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2018-01-22 11:36:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2018-01-22 11:36:49======================== SELECT idx FROM macs WHERE mac_addr = '9883897E060368F70999' AND app_code = '048' ========================2018-01-22 11:36:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240015' ========================2018-01-22 11:36:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240015' ========================2018-01-22 11:36:49======================== UPDATE mac_detail SET pc_name = 'DESKTOP-9A8SRQS', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '240015' ========================2018-01-22 13:08:13======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D739E9FEAFD372A sCDKey = 475639642848 sName = USER-PC ========================2018-01-22 13:08: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 = '475639642848' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-22 13:08:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sharon' ========================2018-01-22 13:08:13======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D739E9FEAFD372A' AND app_code = '046' ========================2018-01-22 13:08:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '201414' ========================2018-01-22 13:08:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '201414' ========================2018-01-22 13:08:13======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'sharon', user_name = '샤론플라워랜드[김보필]', screen_w = '1920', screen_h = '1080', cdkey = '475639642848' WHERE mac_idx = '201414' ========================2018-01-22 13:10:06======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D76AEAAEAFD372A sCDKey = 475639642848 sName = USER-PC ========================2018-01-22 13:10: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 = '475639642848' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-22 13:10:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sharon' ========================2018-01-22 13:10:06======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D76AEAAEAFD372A' AND app_code = '046' ========================2018-01-22 13:10:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '202015' ========================2018-01-22 13:10:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '202015' ========================2018-01-22 13:10:06======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'sharon', user_name = '샤론플라워랜드[김보필]', screen_w = '1920', screen_h = '1080', cdkey = '475639642848' WHERE mac_idx = '202015' ========================2018-01-22 14:48:05======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-UC5GCVJ parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307CAC253935 sCDKey = 870336105845 sName = DESKTOP-UC5GCVJ ========================2018-01-22 14:48:05======================== 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 = '870336105845' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-22 14:48:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ria8210' ========================2018-01-22 14:48:05======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307CAC253935' AND app_code = '050' ========================2018-01-22 14:48:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238150' ========================2018-01-22 14:48:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238150' ========================2018-01-22 14:48:05======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238150', '0030676B307CAC253935', '050', 'DESKTOP-UC5GCVJ', '109', '1920', '1080', 'ria8210', '미진소프트[김민정]', '870336105845' ) ========================2018-01-22 15:10:39======================== noteurl_start parm_app_code = 039 parm_pc_name = SEJONG-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A3F2BCEE33344A sCDKey = 887480579769 sName = SEJONG-PC ========================2018-01-22 15:10: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 = '887480579769' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 15:10:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rnjs71732314' ========================2018-01-22 15:10:39======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A3F2BCEE33344A' AND app_code = '039' ========================2018-01-22 15:10:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240047' ========================2018-01-22 15:10:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240047' ========================2018-01-22 15:10: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 ( '240047', '50B7C3A3F2BCEE33344A', '039', 'SEJONG-PC', '90', '1920', '1080', 'rnjs71732314', '(주)세종에프앤씨[권대근]', '887480579769' ) ========================2018-01-22 15:28:39======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-32V7TT9 parm_os_type = 109 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 1078D2C65E7698D432E7 sCDKey = 721062265539 sName = 오상목테스트Q6600 ========================2018-01-22 15:28: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 = '721062265539' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-22 15:28:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adam5352' ========================2018-01-22 15:28:39======================== SELECT idx FROM macs WHERE mac_addr = '1078D2C65E7698D432E7' AND app_code = '050' ========================2018-01-22 15:28:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '230929' ========================2018-01-22 15:28:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '230929' ========================2018-01-22 15:28: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 ( '230929', '1078D2C65E7698D432E7', '050', '오상목테스트Q6600', '109', '1280', '1024', 'adam5352', '오상목[오상목]', '721062265539' ) ========================2018-01-22 15:55:51======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00E04C2F9273045B5D4E sCDKey = 925921130363 sName = POS-PC ========================2018-01-22 15:55: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 = '925921130363' AND r.app_code = '047' AND r.app_block = 0 ========================2018-01-22 15:55:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sichan' ========================2018-01-22 15:55:51======================== SELECT idx FROM macs WHERE mac_addr = '00E04C2F9273045B5D4E' AND app_code = '047' ========================2018-01-22 15:55:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240057' ========================2018-01-22 15:55:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240057' ========================2018-01-22 15:55:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240057', '00E04C2F9273045B5D4E', '047', 'POS-PC', '�쐢�룄�슦 7', '0', '0', 'sichan', '보람유통[성시찬]', '925921130363' ) ========================2018-01-22 16:22:30======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = E811326DBB78D0936849 sCDKey = 918885395923 sName = SAMSUNG-PC ========================2018-01-22 16:22:30======================== 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 = '918885395923' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 16:22:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'semi' ========================2018-01-22 16:22:30======================== SELECT idx FROM macs WHERE mac_addr = 'E811326DBB78D0936849' AND app_code = '039' ========================2018-01-22 16:22:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240060' ========================2018-01-22 16:22:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240060' ========================2018-01-22 16:22: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 ( '240060', 'E811326DBB78D0936849', '039', 'SAMSUNG-PC', '90', '1366', '768', 'semi', '세미켐[유근웅]', '918885395923' ) ========================2018-01-22 16:22:43======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = E811326DBB78D0936849 sCDKey = 918885395923 sName = SAMSUNG-PC ========================2018-01-22 16:22: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 = '918885395923' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 16:31:41======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E2EE6277895CD8E sCDKey = 058322643212 sName = 삼진지에프 ========================2018-01-22 16:31:41======================== 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 = '058322643212' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-22 16:31:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sjfco412' ========================2018-01-22 16:31:41======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E2EE6277895CD8E' AND app_code = '039' ========================2018-01-22 16:31:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '240064' ========================2018-01-22 16:31:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '240064' ========================2018-01-22 16:31:41======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '240064', 'E0D55E2EE6277895CD8E', '039', '삼진지에프', '90', '1920', '1080', 'sjfco412', '(주)삼진지.에프[(주)삼진지.에프]', '058322643212' )