========================2018-10-26 10:07:38======================== noteurl_start parm_app_code = 039 parm_pc_name = User-1810251022 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003018A2666848339DAA sCDKey = 664000149570 sName = User-1810251022 ========================2018-10-26 10:07: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 = '664000149570' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-26 10:07:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljc_1089' ========================2018-10-26 10:07:38======================== SELECT idx FROM macs WHERE mac_addr = '003018A2666848339DAA' AND app_code = '039' ========================2018-10-26 10:07:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '265382' ========================2018-10-26 10:07:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '265382' ========================2018-10-26 10:07: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 ( '265382', '003018A2666848339DAA', '039', 'User-1810251022', '90', '1920', '1080', 'ljc_1089', '대형연일카[이장천]', '664000149570' ) ========================2018-10-26 10:07:40======================== noteurl_start parm_app_code = 039 parm_pc_name = User-1810251022 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003018A2666848339DAA sCDKey = 664000149570 sName = User-1810251022 ========================2018-10-26 10:07:40======================== 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 = '664000149570' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-26 10:43:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-J2RBN9J parm_os_type = 110 parm_screen_w = 2048 parm_screen_h = 1152 parm_user_mac = 503EAA84D644A70B686 sCDKey = 570958675846 sName = DESKTOP-J2RBN9J ========================2018-10-26 10:43: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 = '570958675846' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-26 10:43:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sevin7409' ========================2018-10-26 10:43:04======================== SELECT idx FROM macs WHERE mac_addr = '503EAA84D644A70B686' AND app_code = '039' ========================2018-10-26 10:43:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '260696' ========================2018-10-26 10:43:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '260696' ========================2018-10-26 10:43:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '260696', '503EAA84D644A70B686', '039', 'DESKTOP-J2RBN9J', '110', '2048', '1152', 'sevin7409', '충남모타써비스[한기훈]', '570958675846' ) ========================2018-10-26 11:41:23======================== noteurl_start parm_app_code = 039 parm_pc_name = WROK_PC01 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 960 parm_user_mac = 1C6F65D6D630A8AB6FF5 sCDKey = 113374082662 sName = WROK_PC01 ========================2018-10-26 11:41: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 = '113374082662' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-26 11:41:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'paint1881' ========================2018-10-26 11:41:23======================== SELECT idx FROM macs WHERE mac_addr = '1C6F65D6D630A8AB6FF5' AND app_code = '039' ========================2018-10-26 11:41:23======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '265390' ========================2018-10-26 11:41:23======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '265390' ========================2018-10-26 11:41: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 ( '265390', '1C6F65D6D630A8AB6FF5', '039', 'WROK_PC01', '110', '1280', '960', 'paint1881', '조영공사[안문상]', '113374082662' ) ========================2018-10-26 11:42:01======================== noteurl_start parm_app_code = 039 parm_pc_name = WROK_PC01 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 960 parm_user_mac = 1C6F65D6D630A8AB6FF5 sCDKey = 113374082662 sName = WROK_PC01 ========================2018-10-26 11:42:01======================== 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 = '113374082662' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-26 13:55:14======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-GRUDP0A parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2789C2F320ECDD0 sCDKey = 698296768630 sName = 펫하우스역곡점 ========================2018-10-26 13:55:14======================== 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 = '698296768630' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-26 13:55:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'xjwlsenqn' ========================2018-10-26 13:55:14======================== SELECT idx FROM macs WHERE mac_addr = '7085C2789C2F320ECDD0' AND app_code = '046' ========================2018-10-26 13:55:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '265423' ========================2018-10-26 13:55:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '265423' ========================2018-10-26 13:55:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '265423', '7085C2789C2F320ECDD0', '046', '펫하우스역곡점', '110', '1920', '1080', 'xjwlsenqn', '펫하우스[박성환]', '698296768630' ) ========================2018-10-26 15:51:17======================== noteurl_start parm_app_code = 047 parm_pc_name = ULT-20160316ZVI parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 408D5CD3A11368ABBD73 sCDKey = 970977670807 sName = ULT-20160316ZVI ========================2018-10-26 15:51:17======================== 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 = '970977670807' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-26 15:51:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'homepasi8848' ========================2018-10-26 15:51:17======================== SELECT idx FROM macs WHERE mac_addr = '408D5CD3A11368ABBD73' AND app_code = '047' ========================2018-10-26 15:51:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '265440' ========================2018-10-26 15:51:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '265440' ========================2018-10-26 15:51:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '265440', '408D5CD3A11368ABBD73', '047', 'ULT-20160316ZVI', '�쐢�룄�슦 7', '0', '0', 'homepasi8848', '홈파시주식회사[손원오]', '970977670807' ) ========================2018-10-26 16:11:17======================== noteurl_start parm_app_code = 046 parm_pc_name = HJW-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C23E60CB96AC8D143 sCDKey = 113190230173 sName = HJW-PC ========================2018-10-26 16:11:17======================== 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 = '113190230173' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-26 16:11:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjw179' ========================2018-10-26 16:11:17======================== SELECT idx FROM macs WHERE mac_addr = '309C23E60CB96AC8D143' AND app_code = '046' ========================2018-10-26 16:11:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '265447' ========================2018-10-26 16:11:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '265447' ========================2018-10-26 16:11:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '265447', '309C23E60CB96AC8D143', '046', 'HJW-PC', '110', '1920', '1080', 'hjw179', '엠제이소프트[홍재원]', '113190230173' )