========================2018-01-16 12:49:26======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CQI8UQP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 2CFDA15917D5AA49EB7E sCDKey = 638265972681 sName = DESKTOP-CQI8UQP ========================2018-01-16 12:49: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 = '638265972681' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-16 13:17:43======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CQI8UQP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 2CFDA15917D5AA49EB7E sCDKey = 638265972681 sName = DESKTOP-CQI8UQP ========================2018-01-16 13:17: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 = '638265972681' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-16 13:17:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'funnymall' ========================2018-01-16 13:17:43======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA15917D5AA49EB7E' AND app_code = '046' ========================2018-01-16 13:17:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239419' ========================2018-01-16 13:17:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239419' ========================2018-01-16 13:17:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239419', '2CFDA15917D5AA49EB7E', '046', 'DESKTOP-CQI8UQP', '110', '1536', '864', 'funnymall', '퍼니몰[이영은]', '638265972681' ) ========================2018-01-16 13:17:54======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CQI8UQP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 2CFDA15917D5AA49EB7E sCDKey = 638265972681 sName = DESKTOP-CQI8UQP ========================2018-01-16 13:17: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 = '638265972681' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-16 13:17:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'funnymall' ========================2018-01-16 13:17:54======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA15917D5AA49EB7E' AND app_code = '046' ========================2018-01-16 13:17:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239419' ========================2018-01-16 13:17:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239419' ========================2018-01-16 13:17:54======================== UPDATE mac_detail SET pc_name = 'DESKTOP-CQI8UQP', os_type = '110', user_id = 'funnymall', user_name = '퍼니몰[이영은]', screen_w = '1536', screen_h = '864', cdkey = '638265972681' WHERE mac_idx = '239419' ========================2018-01-16 18:08:11======================== noteurl_start parm_app_code = 046 parm_pc_name = parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B06EBF83284474A3B0B9 sCDKey = 638265972681 sName = pos ========================2018-01-16 18:08: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 = '638265972681' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-16 18:08:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'funnymall' ========================2018-01-16 18:08:11======================== SELECT idx FROM macs WHERE mac_addr = 'B06EBF83284474A3B0B9' AND app_code = '046' ========================2018-01-16 18:08:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239534' ========================2018-01-16 18:08:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239534' ========================2018-01-16 18:08:11======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239534', 'B06EBF83284474A3B0B9', '046', 'pos', '110', '1600', '900', 'funnymall', '퍼니몰[이영은]', '638265972681' ) ========================2018-01-16 18:09:10======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-CQI8UQP parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 2CFDA15917D5AA49EB7E sCDKey = 638265972681 sName = DESKTOP-CQI8UQP ========================2018-01-16 18:09:10======================== 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 = '638265972681' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-16 18:09:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'funnymall' ========================2018-01-16 18:09:10======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA15917D5AA49EB7E' AND app_code = '046' ========================2018-01-16 18:09:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239419' ========================2018-01-16 18:09:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239419' ========================2018-01-16 18:09:10======================== UPDATE mac_detail SET pc_name = 'DESKTOP-CQI8UQP', os_type = '110', user_id = 'funnymall', user_name = '퍼니몰[이영은]', screen_w = '1536', screen_h = '864', cdkey = '638265972681' WHERE mac_idx = '239419' ========================2018-01-16 19:55:03======================== noteurl_start parm_app_code = 046 parm_pc_name = DDORANG-BOOK parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 720 parm_user_mac = 24F5AACF9AAB1C419873 sCDKey = 361074279643 sName = DDORANG-BOOK ========================2018-01-16 19:55: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 = '361074279643' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-16 19:55:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ds7098' ========================2018-01-16 19:55:03======================== SELECT idx FROM macs WHERE mac_addr = '24F5AACF9AAB1C419873' AND app_code = '046' ========================2018-01-16 19:55:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '217338' ========================2018-01-16 19:55:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '217338' ========================2018-01-16 19:55:03======================== UPDATE mac_detail SET pc_name = 'DDORANG-BOOK', os_type = '110', user_id = 'ds7098', user_name = '덕수상사[곽회출]', screen_w = '1280', screen_h = '720', cdkey = '361074279643' WHERE mac_idx = '217338'