========================2018-12-26 10:45:01======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IRHSG5M parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 309C23637E2C865AF052 sCDKey = 868114698301 sName = DESKTOP-IRHSG5M ========================2018-12-26 10:45: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 = '868114698301' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 10:45:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'easy8833' ========================2018-12-26 10:45:01======================== SELECT idx FROM macs WHERE mac_addr = '309C23637E2C865AF052' AND app_code = '039' ========================2018-12-26 10:45:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271990' ========================2018-12-26 10:45:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271990' ========================2018-12-26 10:45:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '271990', '309C23637E2C865AF052', '039', 'DESKTOP-IRHSG5M', '110', '1600', '900', 'easy8833', '이지렌탈[김영모]', '868114698301' ) ========================2018-12-26 10:45:15======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-IRHSG5M parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 309C23637E2C865AF052 sCDKey = 868114698301 sName = DESKTOP-IRHSG5M ========================2018-12-26 10:45:15======================== 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 = '868114698301' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 11:54:13======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 983017299189 sName = IPOS-HDXP ========================2018-12-26 11:54: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 = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-26 11:54:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-12-26 11:54:13======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-12-26 11:54:13======================== 값이 없을 경우 ========================2018-12-26 11:54:17======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 983017299189 sName = IPOS-HDXP ========================2018-12-26 11:54: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 = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-26 11:54:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-12-26 11:54:17======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-12-26 11:54:17======================== 값이 없을 경우 ========================2018-12-26 12:01:13======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 983017299189 sName = IPOS-HDXP ========================2018-12-26 12:01: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 = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-26 12:01:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-12-26 12:01:13======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-12-26 12:01:13======================== 값이 없을 경우 ========================2018-12-26 12:16:32======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 983017299918 sName = IPOS-HDXP ========================2018-12-26 12:16: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 = '983017299918' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-26 12:17:03======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 983017299189 sName = IPOS-HDXP ========================2018-12-26 12:17:03======================== 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 = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-26 12:17:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-12-26 12:17:03======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-12-26 12:17:03======================== 값이 없을 경우 ========================2018-12-26 12:17:11======================== noteurl_start parm_app_code = 046 parm_pc_name = IPOS-HDXP parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = BC5FF4899505646F7D14 sCDKey = 983017299189 sName = IPOS-HDXP ========================2018-12-26 12:17:11======================== 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 = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-26 12:17:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-12-26 12:17:11======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4899505646F7D14' AND app_code = '046' ========================2018-12-26 12:17:11======================== 값이 없을 경우 ========================2018-12-26 13:30:20======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-JUHA9I5 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CCC6A97757CFC9307E8 sCDKey = 690206982903 sName = DESKTOP-JUHA9I5 ========================2018-12-26 13:30:20======================== 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 = '690206982903' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-26 13:30:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hanwoong0622' ========================2018-12-26 13:30:20======================== SELECT idx FROM macs WHERE mac_addr = '4CCC6A97757CFC9307E8' AND app_code = '046' ========================2018-12-26 13:30:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272022' ========================2018-12-26 13:30:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272022' ========================2018-12-26 13:30:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272022', '4CCC6A97757CFC9307E8', '046', 'DESKTOP-JUHA9I5', '110', '1920', '1080', 'hanwoong0622', '한웅건자재[하자수]', '690206982903' ) ========================2018-12-26 13:49:57======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-LR1VVTL parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 9822EF816683DCA2E4F0 sCDKey = 495904941733 sName = DESKTOP-LR1VVTL ========================2018-12-26 13:49: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 = '495904941733' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 13:49:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'konganeng' ========================2018-12-26 13:49:57======================== SELECT idx FROM macs WHERE mac_addr = '9822EF816683DCA2E4F0' AND app_code = '039' ========================2018-12-26 13:49:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272012' ========================2018-12-26 13:49:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272012' ========================2018-12-26 13:49:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272012', '9822EF816683DCA2E4F0', '039', 'DESKTOP-LR1VVTL', '110', '1536', '864', 'konganeng', '공안엔지니어링[김성순]', '495904941733' ) ========================2018-12-26 14:40:01======================== noteurl_start parm_app_code = 039 parm_pc_name = 신우01 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAB21F636EA36BD3 sCDKey = 870286827806 sName = 신우01 ========================2018-12-26 14:40: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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 14:40:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sinwoo6' ========================2018-12-26 14:40:01======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAB21F636EA36BD3' AND app_code = '039' ========================2018-12-26 14:40:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '122325' ========================2018-12-26 14:40:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '122325' ========================2018-12-26 14:40:01======================== UPDATE mac_detail SET pc_name = '신우01', os_type = '110', user_id = 'sinwoo6', user_name = '신우포장[이경재]', screen_w = '1920', screen_h = '1080', cdkey = '870286827806' WHERE mac_idx = '122325' ========================2018-12-26 14:40:06======================== noteurl_start parm_app_code = 039 parm_pc_name = 신우01 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAB21F636EA36BD3 sCDKey = 870286827806 sName = 신우01 ========================2018-12-26 14:40: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 = '870286827806' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 14:41:30======================== noteurl_start parm_app_code = 039 parm_pc_name = LYS-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 513185320426 sName = LYS-PC ========================2018-12-26 14:41: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 = '513185320426' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 14:41:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lys0121' ========================2018-12-26 14:41:30======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '039' ========================2018-12-26 14:41:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269693' ========================2018-12-26 14:41:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269693' ========================2018-12-26 14:41:30======================== UPDATE mac_detail SET pc_name = 'LYS-PC', os_type = '110', user_id = 'lys0121', user_name = '[이윤솔]', screen_w = '1920', screen_h = '1080', cdkey = '513185320426' WHERE mac_idx = '269693' ========================2018-12-26 14:44:35======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN-F8L0PP3BFQO parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 1C1B0DF70EBF8475E1D6 sCDKey = 564286598646 sName = WIN-F8L0PP3BFQO ========================2018-12-26 14:44: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 = '564286598646' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 14:44:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'khg7454' ========================2018-12-26 14:44:35======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DF70EBF8475E1D6' AND app_code = '039' ========================2018-12-26 14:44:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272039' ========================2018-12-26 14:44:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272039' ========================2018-12-26 14:44: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 ( '272039', '1C1B0DF70EBF8475E1D6', '039', 'WIN-F8L0PP3BFQO', '90', '1680', '1050', 'khg7454', '우림정밀[김해권]', '564286598646' ) ========================2018-12-26 14:57:36======================== noteurl_start parm_app_code = 046 parm_pc_name = ADMINISTRATOR parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 68EDA41FAC2A942362F3 sCDKey = 983017299189 sName = ADMINISTRATOR ========================2018-12-26 14:57: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 = '983017299189' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-26 14:57:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bbongga33' ========================2018-12-26 14:57:36======================== SELECT idx FROM macs WHERE mac_addr = '68EDA41FAC2A942362F3' AND app_code = '046' ========================2018-12-26 14:57:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272041' ========================2018-12-26 14:57:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272041' ========================2018-12-26 14:57: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 ( '272041', '68EDA41FAC2A942362F3', '046', 'ADMINISTRATOR', '90', '1024', '768', 'bbongga33', '지장산막국수[정학본]', '983017299189' ) ========================2018-12-26 15:09:07======================== noteurl_start parm_app_code = 039 parm_pc_name = LYS-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 513185320426 sName = LYS-PC ========================2018-12-26 15:09: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 = '513185320426' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 15:09:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lys0121' ========================2018-12-26 15:09:07======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '039' ========================2018-12-26 15:09:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269693' ========================2018-12-26 15:09:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269693' ========================2018-12-26 15:09:07======================== UPDATE mac_detail SET pc_name = 'LYS-PC', os_type = '110', user_id = 'lys0121', user_name = '[이윤솔]', screen_w = '1920', screen_h = '1080', cdkey = '513185320426' WHERE mac_idx = '269693' ========================2018-12-26 15:12:39======================== noteurl_start parm_app_code = 039 parm_pc_name = LYS-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0030676B307C92E57388 sCDKey = 513185320426 sName = LYS-PC ========================2018-12-26 15:12: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 = '513185320426' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 15:12:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lys0121' ========================2018-12-26 15:12:39======================== SELECT idx FROM macs WHERE mac_addr = '0030676B307C92E57388' AND app_code = '039' ========================2018-12-26 15:12:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '269693' ========================2018-12-26 15:12:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '269693' ========================2018-12-26 15:12:39======================== UPDATE mac_detail SET pc_name = 'LYS-PC', os_type = '110', user_id = 'lys0121', user_name = '[이윤솔]', screen_w = '1920', screen_h = '1080', cdkey = '513185320426' WHERE mac_idx = '269693' ========================2018-12-26 15:50:05======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3EJJANE parm_os_type = 110 parm_screen_w = 2560 parm_screen_h = 1440 parm_user_mac = 1CB72CAC2A3C88CD55F6 sCDKey = 378871337565 sName = DESKTOP-3EJJANE ========================2018-12-26 15:50: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 = '378871337565' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 15:50:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hhc7278' ========================2018-12-26 15:50:05======================== SELECT idx FROM macs WHERE mac_addr = '1CB72CAC2A3C88CD55F6' AND app_code = '039' ========================2018-12-26 15:50:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '271881' ========================2018-12-26 15:50:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '271881' ========================2018-12-26 15:50: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 ( '271881', '1CB72CAC2A3C88CD55F6', '039', 'DESKTOP-3EJJANE', '110', '2560', '1440', 'hhc7278', '(주)흥해전기[최근호]', '378871337565' ) ========================2018-12-26 16:20:33======================== noteurl_start parm_app_code = 046 parm_pc_name = WINION3-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C2701FAA1CD983C8 sCDKey = 154716655259 sName = WINION3-PC ========================2018-12-26 16:20:33======================== 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 = '154716655259' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-26 16:20:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'winion' ========================2018-12-26 16:20:33======================== SELECT idx FROM macs WHERE mac_addr = '7085C2701FAA1CD983C8' AND app_code = '046' ========================2018-12-26 16:20:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272055' ========================2018-12-26 16:20:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272055' ========================2018-12-26 16:20:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272055', '7085C2701FAA1CD983C8', '046', 'WINION3-PC', '90', '1920', '1080', 'winion', '(주)위니온[이동섭]', '154716655259' ) ========================2018-12-26 16:38:01======================== noteurl_start parm_app_code = 039 parm_pc_name = MAINPC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 4CEDDEDC2C7252178FCB sCDKey = 884734283497 sName = MAINPC ========================2018-12-26 16:38: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 = '884734283497' AND r.app_code = '039' AND r.app_block = 0 ========================2018-12-26 16:38:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimjd25' ========================2018-12-26 16:38:01======================== SELECT idx FROM macs WHERE mac_addr = '4CEDDEDC2C7252178FCB' AND app_code = '039' ========================2018-12-26 16:38:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '272062' ========================2018-12-26 16:38:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '272062' ========================2018-12-26 16:38:01======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '272062', '4CEDDEDC2C7252178FCB', '039', 'MAINPC', '90', '1366', '768', 'kimjd25', '정무하이테크[김진덕]', '884734283497' ) ========================2018-12-26 17:40:02======================== noteurl_start parm_app_code = 046 parm_pc_name = HOMESPOS parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50AF7325BFF3A4AF7DFD sCDKey = 921252470168 sName = HOMESPOS ========================2018-12-26 17:40: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 = '921252470168' AND r.app_code = '046' AND r.app_block = 0 ========================2018-12-26 17:40:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cherhomes' ========================2018-12-26 17:40:02======================== SELECT idx FROM macs WHERE mac_addr = '50AF7325BFF3A4AF7DFD' AND app_code = '046' ========================2018-12-26 17:40:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236522' ========================2018-12-26 17:40:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236522' ========================2018-12-26 17:40:02======================== UPDATE mac_detail SET pc_name = 'HOMESPOS', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]', screen_w = '1920', screen_h = '1080', cdkey = '921252470168' WHERE mac_idx = '236522'