========================2018-05-14 07:11:09======================== noteurl_start parm_app_code = 039 parm_pc_name = HBDS-04 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = F8633F3582076B9E2F5 sCDKey = 683156263623 sName = HBDS-04 ========================2018-05-14 07:11:09======================== 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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 09:10:59======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IEHJ59O parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 701CE704F7459C36B6E9 sCDKey = 805828454752 sName = DESKTOP-IEHJ59O ========================2018-05-14 09:10:59======================== 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 = '805828454752' AND r.app_code = '047' AND r.app_block = 0 ========================2018-05-14 09:10:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodpc' ========================2018-05-14 09:10:59======================== SELECT idx FROM macs WHERE mac_addr = '701CE704F7459C36B6E9' AND app_code = '047' ========================2018-05-14 09:10:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236712' ========================2018-05-14 09:10:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236712' ========================2018-05-14 09:10:59======================== UPDATE mac_detail SET pc_name = 'DESKTOP-IEHJ59O', os_type = '�쐢�룄�슦 10', user_id = 'goodpc', user_name = '좋은컴퓨터[김홍기]', screen_w = '0', screen_h = '0', cdkey = '805828454752' WHERE mac_idx = '236712' ========================2018-05-14 09:19:04======================== 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 = 7085C22F339BCD9906D sCDKey = 872903449106 sName = USER-PC ========================2018-05-14 09:19: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 = '872903449106' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 09:19:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nmw11055' ========================2018-05-14 09:19:04======================== SELECT idx FROM macs WHERE mac_addr = '7085C22F339BCD9906D' AND app_code = '039' ========================2018-05-14 09:19:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '228672' ========================2018-05-14 09:19:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '228672' ========================2018-05-14 09:19:04======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'nmw11055', user_name = '신한텍스[남만우]', screen_w = '1360', screen_h = '768', cdkey = '872903449106' WHERE mac_idx = '228672' ========================2018-05-14 09:22:43======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-0T3BQNM7 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = F828196C86C38486FCAA sCDKey = 808057827774 sName = LAPTOP-0T3BQNM7 ========================2018-05-14 09: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 = '808057827774' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 09:22:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hn0377' ========================2018-05-14 09:22:43======================== SELECT idx FROM macs WHERE mac_addr = 'F828196C86C38486FCAA' AND app_code = '039' ========================2018-05-14 09:22:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249522' ========================2018-05-14 09:22:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249522' ========================2018-05-14 09:22:43======================== UPDATE mac_detail SET pc_name = 'LAPTOP-0T3BQNM7', os_type = '110', user_id = 'hn0377', user_name = '하나텍스[전향희]', screen_w = '1280', screen_h = '720', cdkey = '808057827774' WHERE mac_idx = '249522' ========================2018-05-14 09:28:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-I997NG5 parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = E0D55E9657B6488F96FE sCDKey = 585044867094 sName = DESKTOP-I997NG5 ========================2018-05-14 09:28:09======================== 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 = '585044867094' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 09:28:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tlawlsgh' ========================2018-05-14 09:28:09======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E9657B6488F96FE' AND app_code = '039' ========================2018-05-14 09:28:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249616' ========================2018-05-14 09:28:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249616' ========================2018-05-14 09:28:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249616', 'E0D55E9657B6488F96FE', '039', 'DESKTOP-I997NG5', '110', '1440', '900', 'tlawlsgh', '성진포장[심진호]', '585044867094' ) ========================2018-05-14 10:38:37======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-85T79TV parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E8A23AD439AD sCDKey = 939572845701 sName = DESKTOP-85T79TV ========================2018-05-14 10:38: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 = '939572845701' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 10:38:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'djk64' ========================2018-05-14 10:38:37======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E8A23AD439AD' AND app_code = '039' ========================2018-05-14 10:38:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249629' ========================2018-05-14 10:38:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249629' ========================2018-05-14 10:38:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249629', 'E0D55E8A23AD439AD', '039', 'DESKTOP-85T79TV', '110', '1920', '1080', 'djk64', '예치과기공소[전덕기]', '939572845701' ) ========================2018-05-14 10:42:13======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-N2FOU0T parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A0C589920BDA1523563F sCDKey = 918885395923 sName = DESKTOP-N2FOU0T ========================2018-05-14 10:42: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 = '918885395923' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 10:42:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'semi' ========================2018-05-14 10:42:13======================== SELECT idx FROM macs WHERE mac_addr = 'A0C589920BDA1523563F' AND app_code = '039' ========================2018-05-14 10:42:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249630' ========================2018-05-14 10:42:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249630' ========================2018-05-14 10:42:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249630', 'A0C589920BDA1523563F', '039', 'DESKTOP-N2FOU0T', '110', '1536', '864', 'semi', '세미켐[유근웅]', '918885395923' ) ========================2018-05-14 10:42:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-N2FOU0T parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = A0C589920BDA1523563F sCDKey = 918885395923 sName = DESKTOP-N2FOU0T ========================2018-05-14 10:42: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 = '918885395923' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 10:50:33======================== noteurl_start parm_app_code = 046 parm_pc_name = WIN-BI00 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 408D5CAFBCBBACE01D42 sCDKey = 409643186656 sName = WIN-BI00 ========================2018-05-14 10:50: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 = '409643186656' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-14 11:07:46======================== noteurl_start parm_app_code = 046 parm_pc_name = DUBU-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02F675B619A6F60DC sCDKey = 916970945314 sName = DUBU-PC ========================2018-05-14 11:07: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 = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-14 11:07:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2018-05-14 11:07:46======================== SELECT idx FROM macs WHERE mac_addr = '40F02F675B619A6F60DC' AND app_code = '046' ========================2018-05-14 11:07:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '246781' ========================2018-05-14 11:07:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '246781' ========================2018-05-14 11:07:46======================== UPDATE mac_detail SET pc_name = 'DUBU-PC', os_type = '90', user_id = 'danjinail', user_name = '단지네네일가게[임재완]', screen_w = '1366', screen_h = '768', cdkey = '916970945314' WHERE mac_idx = '246781' ========================2018-05-14 11:28:32======================== noteurl_start parm_app_code = 046 parm_pc_name = HOMESPOS parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF7325BFF3A4AF7DFD sCDKey = 921252470168 sName = HOMESPOS ========================2018-05-14 11:28: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 = '921252470168' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-14 11:28:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cherhomes' ========================2018-05-14 11:28:32======================== SELECT idx FROM macs WHERE mac_addr = '50AF7325BFF3A4AF7DFD' AND app_code = '046' ========================2018-05-14 11:28:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '236522' ========================2018-05-14 11:28:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '236522' ========================2018-05-14 11:28:32======================== UPDATE mac_detail SET pc_name = 'HOMESPOS', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]', screen_w = '1024', screen_h = '768', cdkey = '921252470168' WHERE mac_idx = '236522' ========================2018-05-14 11:30:54======================== noteurl_start parm_app_code = 046 parm_pc_name = OKPOS parm_os_type = 64 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = B8975AA31C6B30BF7982 sCDKey = 222859365472 sName = OKPOS ========================2018-05-14 11:30: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 = '222859365472' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-14 11:30:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ajm5265' ========================2018-05-14 11:30:54======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AA31C6B30BF7982' AND app_code = '046' ========================2018-05-14 11:30:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '158626' ========================2018-05-14 11:30:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '158626' ========================2018-05-14 11:30:54======================== UPDATE mac_detail SET pc_name = 'OKPOS', os_type = '64', user_id = 'ajm5265', user_name = '주식회사광문[안정미]', screen_w = '1280', screen_h = '1024', cdkey = '222859365472' WHERE mac_idx = '158626' ========================2018-05-14 11:48:07======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 50AF732A9E6AEE2B1141 sCDKey = 562622642169 sName = DESKTOP-IR4BE71 ========================2018-05-14 11:48: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 = '562622642169' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-14 11:48:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'son1518' ========================2018-05-14 11:48:07======================== SELECT idx FROM macs WHERE mac_addr = '50AF732A9E6AEE2B1141' AND app_code = '046' ========================2018-05-14 11:48:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249645' ========================2018-05-14 11:48:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249645' ========================2018-05-14 11:48:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249645', '50AF732A9E6AEE2B1141', '046', 'DESKTOP-IR4BE71', '110', '1024', '768', 'son1518', '쉐르홈즈전북총판[임숙자]', '562622642169' ) ========================2018-05-14 13:20:44======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = DCA9711D900CACD6852 sCDKey = 566106175278 sName = USER-PC ========================2018-05-14 13:20: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 = '566106175278' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 13:20:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'choi6042' ========================2018-05-14 13:20:44======================== SELECT idx FROM macs WHERE mac_addr = 'DCA9711D900CACD6852' AND app_code = '039' ========================2018-05-14 13:20:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249658' ========================2018-05-14 13:20:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249658' ========================2018-05-14 13:20:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249658', 'DCA9711D900CACD6852', '039', 'USER-PC', '90', '1366', '768', 'choi6042', '삼흥상사[최정현]', '566106175278' ) ========================2018-05-14 13:47:05======================== noteurl_start parm_app_code = 039 parm_pc_name = DM3 parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 74D43580896CA424230 sCDKey = 272831752859 sName = DM3 ========================2018-05-14 13:47: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 = '272831752859' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 13:47:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljw418' ========================2018-05-14 13:47:05======================== SELECT idx FROM macs WHERE mac_addr = '74D43580896CA424230' AND app_code = '039' ========================2018-05-14 13:47:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249661' ========================2018-05-14 13:47:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249661' ========================2018-05-14 13:47: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 ( '249661', '74D43580896CA424230', '039', 'DM3', '110', '1440', '900', 'ljw418', '(주)대명박스[박근학]', '272831752859' ) ========================2018-05-14 16:53:44======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2F27KD1 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838982FEB4F60ADEE8 sCDKey = 831663810950 sName = DESKTOP-2F27KD1 ========================2018-05-14 16:53: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 = '831663810950' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 16:53:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaesung' ========================2018-05-14 16:53:44======================== SELECT idx FROM macs WHERE mac_addr = '98838982FEB4F60ADEE8' AND app_code = '039' ========================2018-05-14 16:53:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249627' ========================2018-05-14 16:53:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249627' ========================2018-05-14 16:53:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249627', '98838982FEB4F60ADEE8', '039', 'DESKTOP-2F27KD1', '110', '1920', '1080', 'gaesung', '개성대가[이효식]', '831663810950' ) ========================2018-05-14 16:54:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-V76T4KB parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 3CA067002CBB36A7CC6D sCDKey = 831663810950 sName = DESKTOP-V76T4KB ========================2018-05-14 16:54: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 = '831663810950' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-14 16:54:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaesung' ========================2018-05-14 16:54:56======================== SELECT idx FROM macs WHERE mac_addr = '3CA067002CBB36A7CC6D' AND app_code = '039' ========================2018-05-14 16:54:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249668' ========================2018-05-14 16:54:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249668' ========================2018-05-14 16:54: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 ( '249668', '3CA067002CBB36A7CC6D', '039', 'DESKTOP-V76T4KB', '110', '1920', '1080', 'gaesung', '개성대가[이효식]', '831663810950' ) ========================2018-05-14 16:58:48======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-DAVR0JS parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 40F02F675B61E7B8D2C sCDKey = 916970945314 sName = DESKTOP-DAVR0JS ========================2018-05-14 16:58: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 = '916970945314' AND r.app_code = '046' AND r.app_block = 0 ========================2018-05-14 16:58:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'danjinail' ========================2018-05-14 16:58:48======================== SELECT idx FROM macs WHERE mac_addr = '40F02F675B61E7B8D2C' AND app_code = '046' ========================2018-05-14 16:58:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249686' ========================2018-05-14 16:58:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249686' ========================2018-05-14 16:58:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249686', '40F02F675B61E7B8D2C', '046', 'DESKTOP-DAVR0JS', '110', '1366', '768', 'danjinail', '단지네네일가게[임재완]', '916970945314' ) ========================2018-05-14 20:27:18======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-S8EA3M6 parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 909F3309C73FA6E0D61D sCDKey = 921252470168 sName = DESKTOP-S8EA3M6 ========================2018-05-14 20:27:18======================== 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-05-14 20:27:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cherhomes' ========================2018-05-14 20:27:18======================== SELECT idx FROM macs WHERE mac_addr = '909F3309C73FA6E0D61D' AND app_code = '046' ========================2018-05-14 20:27:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '222179' ========================2018-05-14 20:27:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '222179' ========================2018-05-14 20:27:18======================== UPDATE mac_detail SET pc_name = 'DESKTOP-S8EA3M6', os_type = '110', user_id = 'cherhomes', user_name = '쉐르홈즈[최화별]', screen_w = '1536', screen_h = '864', cdkey = '921252470168' WHERE mac_idx = '222179'