========================2018-11-20 10:33:12======================== noteurl_start parm_app_code = 046 parm_pc_name = POS parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F0DBACDECB8A99D sCDKey = 834962125925 sName = 전시회POS ========================2018-11-20 10:33: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-20 10:33:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2018-11-20 10:33:12======================== SELECT idx FROM macs WHERE mac_addr = '00190F0DBACDECB8A99D' AND app_code = '046' ========================2018-11-20 10:33:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268294' ========================2018-11-20 10:33:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268294' ========================2018-11-20 10:33: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 ( '268294', '00190F0DBACDECB8A99D', '046', '전시회POS', '64', '1024', '768', 'ericaan', '주식회사 메종드파리[안진현]', '834962125925' ) ========================2018-11-20 13:08:50======================== noteurl_start parm_app_code = 047 parm_pc_name = POS-1-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 003018CB25F98CFAC1C4 sCDKey = 939762112985 sName = POS-1-PC ========================2018-11-20 13:08: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 = '939762112985' AND r.app_code = '047' AND r.app_block = 0 ========================2018-11-20 13:08:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hansol22910' ========================2018-11-20 13:08:50======================== SELECT idx FROM macs WHERE mac_addr = '003018CB25F98CFAC1C4' AND app_code = '047' ========================2018-11-20 13:08:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268317' ========================2018-11-20 13:08:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268317' ========================2018-11-20 13:08: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 ( '268317', '003018CB25F98CFAC1C4', '047', 'POS-1-PC', '�쐢�룄�슦 7', '0', '0', 'hansol22910', '한솔만물상[김강식]', '939762112985' ) ========================2018-11-20 13:43:12======================== noteurl_start parm_app_code = 039 parm_pc_name = OWNER-PC parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = E0D55E1098C140C66A9E sCDKey = 683187009788 sName = OWNER-PC ========================2018-11-20 13:43: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 = '683187009788' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-20 13:43:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cs0458' ========================2018-11-20 13:43:12======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E1098C140C66A9E' AND app_code = '039' ========================2018-11-20 13:43:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '259213' ========================2018-11-20 13:43:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '259213' ========================2018-11-20 13:43:12======================== UPDATE mac_detail SET pc_name = 'OWNER-PC', os_type = '90', user_id = 'cs0458', user_name = '천수관광[박천수]', screen_w = '1440', screen_h = '900', cdkey = '683187009788' WHERE mac_idx = '259213' ========================2018-11-20 14:51:54======================== 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 = 68EDA41C9643942362F3 sCDKey = 062937579655 sName = ADMINISTRATOR ========================2018-11-20 14:51: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 = '062937579655' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-20 14:51:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'interbet' ========================2018-11-20 14:51:54======================== SELECT idx FROM macs WHERE mac_addr = '68EDA41C9643942362F3' AND app_code = '046' ========================2018-11-20 14:51:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268334' ========================2018-11-20 14:51:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268334' ========================2018-11-20 14:51:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268334', '68EDA41C9643942362F3', '046', 'ADMINISTRATOR', '90', '1024', '768', 'interbet', '호산유통[우일]', '062937579655' ) ========================2018-11-20 15:30:22======================== noteurl_start parm_app_code = 047 parm_pc_name = POS2-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 003018CB24B154061DDF sCDKey = 939762112985 sName = POS2-PC ========================2018-11-20 15:30:22======================== 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 = '939762112985' AND r.app_code = '047' AND r.app_block = 0 ========================2018-11-20 15:30:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hansol22910' ========================2018-11-20 15:30:22======================== SELECT idx FROM macs WHERE mac_addr = '003018CB24B154061DDF' AND app_code = '047' ========================2018-11-20 15:30:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268339' ========================2018-11-20 15:30:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268339' ========================2018-11-20 15:30:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268339', '003018CB24B154061DDF', '047', 'POS2-PC', '�쐢�룄�슦 7', '0', '0', 'hansol22910', '한솔만물상[김강식]', '939762112985' ) ========================2018-11-20 15:37:34======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-33BP6FF parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 1831BF4CE8BE38C38F19 sCDKey = 902906003428 sName = DESKTOP-33BP6FF ========================2018-11-20 15:37:34======================== 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 = '902906003428' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-20 15:37:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'freshjeen' ========================2018-11-20 15:37:34======================== SELECT idx FROM macs WHERE mac_addr = '1831BF4CE8BE38C38F19' AND app_code = '039' ========================2018-11-20 15:37:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268340' ========================2018-11-20 15:37:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268340' ========================2018-11-20 15:37:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268340', '1831BF4CE8BE38C38F19', '039', 'DESKTOP-33BP6FF', '110', '1600', '900', 'freshjeen', '리버스팜[제진욱]', '902906003428' ) ========================2018-11-20 16:47:54======================== noteurl_start parm_app_code = 047 parm_pc_name = POS3-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 003018CB258D006809EA sCDKey = 939762112985 sName = POS3-PC ========================2018-11-20 16:47: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 = '939762112985' AND r.app_code = '047' AND r.app_block = 0 ========================2018-11-20 16:47:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hansol22910' ========================2018-11-20 16:47:54======================== SELECT idx FROM macs WHERE mac_addr = '003018CB258D006809EA' AND app_code = '047' ========================2018-11-20 16:47:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268355' ========================2018-11-20 16:47:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268355' ========================2018-11-20 16:47:54======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268355', '003018CB258D006809EA', '047', 'POS3-PC', '�쐢�룄�슦 7', '0', '0', 'hansol22910', '한솔만물상[김강식]', '939762112985' )