========================2019-08-20 09:06:46======================== noteurl_start parm_app_code = 039 parm_pc_name = PC-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B340D0D2CAACC1B0F sCDKey = 644939780548 sName = PC-PC ========================2019-08-20 09:06:46======================== 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 = '644939780548' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-20 09:06:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pr7221366' ========================2019-08-20 09:06:46======================== SELECT idx FROM macs WHERE mac_addr = '902B340D0D2CAACC1B0F' AND app_code = '039' ========================2019-08-20 09:06:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293513' ========================2019-08-20 09:06:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293513' ========================2019-08-20 09:06:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293513', '902B340D0D2CAACC1B0F', '039', 'PC-PC', '90', '1920', '1080', 'pr7221366', '광고기획푸름[박동근]', '644939780548' ) ========================2019-08-20 09:30:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-17AAT74 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 8EC2205241538442791F sCDKey = 408939466587 sName = DESKTOP-17AAT74 ========================2019-08-20 09:30: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 = '408939466587' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-20 09:30:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goomung2' ========================2019-08-20 09:30:17======================== SELECT idx FROM macs WHERE mac_addr = '8EC2205241538442791F' AND app_code = '039' ========================2019-08-20 09:30:17======================== 값이 없을 경우 ========================2019-08-20 09:34:30======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-SMI6PBQ parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E9966FC36FA84F9 sCDKey = 286398115302 sName = DESKTOP-SMI6PBQ ========================2019-08-20 09:34: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 = '286398115302' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-20 09:34:30======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'redcarman' ========================2019-08-20 09:34:30======================== SELECT idx FROM macs WHERE mac_addr = 'B42E9966FC36FA84F9' AND app_code = '046' ========================2019-08-20 09:34:30======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293519' ========================2019-08-20 09:34:30======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293519' ========================2019-08-20 09:34: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 ( '293519', 'B42E9966FC36FA84F9', '046', 'DESKTOP-SMI6PBQ', '110', '1920', '1080', 'redcarman', '용광상사[김명한]', '286398115302' ) ========================2019-08-20 09:42:17======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN10-64B4G parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B42E990A7277DE88697D sCDKey = 962277679641 sName = WIN10-64B4G ========================2019-08-20 09:42: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 = '962277679641' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-20 09:42:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'panyjane' ========================2019-08-20 09:42:17======================== SELECT idx FROM macs WHERE mac_addr = 'B42E990A7277DE88697D' AND app_code = '039' ========================2019-08-20 09:42:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293522' ========================2019-08-20 09:42:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293522' ========================2019-08-20 09:42: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 ( '293522', 'B42E990A7277DE88697D', '039', 'WIN10-64B4G', '110', '1600', '900', 'panyjane', '미쉘레[조현주]', '962277679641' ) ========================2019-08-20 11:28:19======================== noteurl_start ========================2019-08-20 11:28: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 = '' AND r.app_code = '' AND r.app_block = 0 ========================2019-08-20 15:07:29======================== noteurl_start parm_app_code = 047 parm_pc_name = VPS-D550G parm_os_type = �쐢�룄�슦 XP parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = C86000A1457318CA2379 sCDKey = 848717979251 sName = VPS-D550G ========================2019-08-20 15:07: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 = '848717979251' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-20 15:07:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'eastps' ========================2019-08-20 15:07:29======================== SELECT idx FROM macs WHERE mac_addr = 'C86000A1457318CA2379' AND app_code = '047' ========================2019-08-20 15:07:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293575' ========================2019-08-20 15:07:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293575' ========================2019-08-20 15:07: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 ( '293575', 'C86000A1457318CA2379', '047', 'VPS-D550G', '�쐢�룄�슦 XP', '0', '0', 'eastps', '아시아넷[주동진]', '848717979251' ) ========================2019-08-20 17:20:50======================== noteurl_start parm_app_code = 047 parm_pc_name = APROMAN-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 74D435AF540FEE1999FD sCDKey = 230362309828 sName = 사무실pc ========================2019-08-20 17:20:50======================== 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 = '230362309828' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-20 17:20:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jclocal' ========================2019-08-20 17:20:50======================== SELECT idx FROM macs WHERE mac_addr = '74D435AF540FEE1999FD' AND app_code = '047' ========================2019-08-20 17:20:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '293596' ========================2019-08-20 17:20:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '293596' ========================2019-08-20 17:20:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '293596', '74D435AF540FEE1999FD', '047', '사무실pc', '�쐢�룄�슦 7', '0', '0', 'jclocal', '제천로컬푸드협동조합[김현주]', '230362309828' ) ========================2019-08-20 17:54:55======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-D8OVV1J parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 802BF9045A0338B36F7E sCDKey = 916970945314 sName = DESKTOP-D8OVV1J ========================2019-08-20 17:54:55======================== 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 = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2019-08-20 17:54:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2019-08-20 17:54:55======================== SELECT idx FROM macs WHERE mac_addr = '802BF9045A0338B36F7E' AND app_code = '046' ========================2019-08-20 17:54:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270762' ========================2019-08-20 17:54:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270762' ========================2019-08-20 17:54:55======================== UPDATE mac_detail SET pc_name = 'DESKTOP-D8OVV1J', os_type = '110', user_id = 'danjinail', user_name = '단지네네일가게[임재완]', screen_w = '1536', screen_h = '864', cdkey = '916970945314' WHERE mac_idx = '270762'