========================2019-04-17 08:36:37======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838987DB4ED87CAEF4 sCDKey = 434133617514 sName = 김수영 ========================2019-04-17 08:36: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-04-17 08:38:01======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838987DB4ED87CAEF4 sCDKey = 434133617514 sName = 김수영 ========================2019-04-17 08: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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-04-17 09:15:09======================== noteurl_start parm_app_code = 039 parm_pc_name = SS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 74D435CEE596C059AEBC sCDKey = 316625035678 sName = SS-PC ========================2019-04-17 09:15: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 = '316625035678' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-17 09:15:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tpwjd1121' ========================2019-04-17 09:15:09======================== SELECT idx FROM macs WHERE mac_addr = '74D435CEE596C059AEBC' AND app_code = '039' ========================2019-04-17 09:15:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283605' ========================2019-04-17 09:15:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283605' ========================2019-04-17 09:15: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 ( '283605', '74D435CEE596C059AEBC', '039', 'SS-PC', '90', '1920', '1080', 'tpwjd1121', '세정정밀[김태숙]', '316625035678' ) ========================2019-04-17 10:16:01======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00089FD8E06BA41C65F sCDKey = 834962125925 sName = test ========================2019-04-17 10:16: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-17 10:16:01======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2019-04-17 10:16:01======================== SELECT idx FROM macs WHERE mac_addr = '00089FD8E06BA41C65F' AND app_code = '046' ========================2019-04-17 10:16:01======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '278621' ========================2019-04-17 10:16:01======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '278621' ========================2019-04-17 10:16:01======================== UPDATE mac_detail SET pc_name = 'test', os_type = '90', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1024', screen_h = '768', cdkey = '834962125925' WHERE mac_idx = '278621' ========================2019-04-17 11:46:41======================== noteurl_start parm_app_code = 048 parm_pc_name = 김수영 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 98838987DB4ED87CAEF4 sCDKey = 434133617514 sName = 김수영 ========================2019-04-17 11:46:41======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-04-17 11:46:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'weblink' ========================2019-04-17 11:46:41======================== SELECT idx FROM macs WHERE mac_addr = '98838987DB4ED87CAEF4' AND app_code = '048' ========================2019-04-17 11:46:41======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268463' ========================2019-04-17 11:46:41======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268463' ========================2019-04-17 11:46:41======================== UPDATE mac_detail SET pc_name = '김수영', os_type = '�쐢�룄�슦 10', user_id = 'weblink', user_name = '대성활어[강정미]', screen_w = '0', screen_h = '0', cdkey = '434133617514' WHERE mac_idx = '268463' ========================2019-04-17 16:34:26======================== noteurl_start parm_app_code = 039 parm_pc_name = PC-180811B parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55EBB36C1C620ABDD sCDKey = 585397753358 sName = PC-180811B ========================2019-04-17 16:34: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 = '585397753358' AND r.app_code = '039' AND r.app_block = 0 ========================2019-04-17 16:34:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mihiki' ========================2019-04-17 16:34:26======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EBB36C1C620ABDD' AND app_code = '039' ========================2019-04-17 16:34:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283618' ========================2019-04-17 16:34:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283618' ========================2019-04-17 16:34:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '283618', 'E0D55EBB36C1C620ABDD', '039', 'PC-180811B', '110', '1920', '1080', 'mihiki', '(주)이레산업[김경남]', '585397753358' ) ========================2019-04-17 16:59:46======================== noteurl_start parm_app_code = 046 parm_pc_name = POS-P3CF8WQ5LX3 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F05E1E3F891C0B4 sCDKey = 297812847494 sName = POS-P3CF8WQ5LX3 ========================2019-04-17 16:59: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 = '297812847494' AND r.app_code = '046' AND r.app_block = 0 ========================2019-04-17 16:59:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'qnwk' ========================2019-04-17 16:59:46======================== SELECT idx FROM macs WHERE mac_addr = '00190F05E1E3F891C0B4' AND app_code = '046' ========================2019-04-17 16:59:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '283668' ========================2019-04-17 16:59:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '283668' ========================2019-04-17 16:59: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 ( '283668', '00190F05E1E3F891C0B4', '046', 'POS-P3CF8WQ5LX3', '64', '1024', '768', 'qnwk', '부자식품[박성호]', '297812847494' )