日志分析：根据用户ID统计在线时长

nblity

根据[login]判断登陆   [logout]判断登出
[playerid][2095]   playerid后边方括号内的数字为用户ID
统计判断该ID在线时长

请教一下高手，该怎样处理。


[2009-12-03 10:01:09103](LoginManagerImpl.java:229) [ messageReceiveStart [961531:0] [1] +[LoginSystem]] - [login][failed][accountid:961531]
[2009-12-03 10:01:13185](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][25]
[2009-12-03 13:50:55211](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 13:50:55213](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 13:50:55214](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 13:50:57309](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 14:20:20104](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 14:20:20105](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 14:20:20105](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 14:21:26465](LoginManagerImpl.java:229) [ messageReceiveStart [961531:0] [1] +[LoginSystem]] - [login][failed][accountid:961531]
[2009-12-03 14:21:28464](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 14:52:15782](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 14:52:15783](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 14:52:15784](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [10] +[BagMessageProcessManager]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 14:52:47172](LoginManagerImpl.java:229) [ messageReceiveStart [961531:0] [1] +[LoginSystem]] - [login][failed][accountid:961531]
[2009-12-03 14:52:48882](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 14:52:59738](LoginManagerImpl.java:229) [ messageReceiveStart [tester110:0] [1] +[LoginSystem]] - [login][failed][accountid:tester110]
[2009-12-03 14:53:05224](LoginManagerImpl.java:205) [ messageReceiveStart [tester110:2730] [1] +[LoginSystem]] - [login][enterWorld][accountid][tester110][playerid][2730][name][能见度][career][战士][level][80]
[2009-12-03 15:11:33544](LoginManagerImpl.java:183) [ messageReceiveStart [tester110:2730] [1] +[LoginSystem]] - [logout][accountid][tester110][playerid][2725][name][苔丝特][career][战士][level][1]
[2009-12-03 15:11:33545](LoginManagerImpl.java:183) [ messageReceiveStart [tester110:2730] [1] +[LoginSystem]] - [logout][accountid][tester110][playerid][2730][name][能见度][career][战士][level][80]
[2009-12-03 15:11:33620](LoginManagerImpl.java:183) [ messageReceiveStart [tester110:2730] [1] +[LoginSystem]] - [logout][accountid][tester110][playerid][2729][name][雨夹雪][career][法师][level][80]
[2009-12-03 15:11:34983](LoginManagerImpl.java:205) [ messageReceiveStart [tester110:2725] [1] +[LoginSystem]] - [login][enterWorld][accountid][tester110][playerid][2725][name][苔丝特][career][战士][level][1]
[2009-12-03 15:13:10239](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [5] +[CombatSystem]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 15:13:10240](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [5] +[CombatSystem]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 15:13:10241](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:2736] [5] +[CombatSystem]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 15:46:52136](LoginManagerImpl.java:229) [ messageReceiveStart [961531:0] [1] +[LoginSystem]] - [login][failed][accountid:961531]
[2009-12-03 15:46:53738](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 15:57:31679](LoginManagerImpl.java:183) [ messageReceiveEnd [tester110:2725] [3] +[PlayerSystem]] - [logout][accountid][tester110][playerid][2725][name][苔丝特][career][战士][level][1]
[2009-12-03 15:57:31698](LoginManagerImpl.java:183) [ messageReceiveEnd [tester110:2725] [3] +[PlayerSystem]] - [logout][accountid][tester110][playerid][2730][name][能见度][career][战士][level][80]
[2009-12-03 15:57:31699](LoginManagerImpl.java:183) [ messageReceiveEnd [tester110:2725] [3] +[PlayerSystem]] - [logout][accountid][tester110][playerid][2729][name][雨夹雪][career][法师][level][80]
[2009-12-03 16:16:16689](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 16:16:16690](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 16:16:16691](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 16:16:18260](LoginManagerImpl.java:205) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [login][enterWorld][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 16:22:40970](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 16:22:40970](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 16:22:40971](LoginManagerImpl.java:183) [ messageReceiveStart [961531:2736] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 16:22:42495](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:0] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2088][name][小小英雄][career][法师][level][80]
[2009-12-03 16:22:42496](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:0] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2095][name][79帅哥][career][战士][level][70]
[2009-12-03 16:22:42497](LoginManagerImpl.java:183) [ messageReceiveEnd [961531:0] [1] +[LoginSystem]] - [logout][accountid][961531][playerid][2736][name][MINI][career][战士][level][26]
[2009-12-03 16:22:49333](LoginManagerImpl.java:229) [ messageReceiveStart [96153c:0] [1] +[LoginSystem]] - [login][failed][accountid:96153c]
[2009-12-03 16:23:23488](LoginManagerImpl.java:205) [ messageReceiveStart [96153c:2732] [1] +[LoginSystem]] - [login][enterWorld][accountid][96153c][playerid][2732][name][任务享][career][法师][level][8]

[ 本帖最后由 nblity 于 2009-12-3 16:51 编辑 ]

ly5066113

login logout 不配对的怎么处理？

nblity

只有login没有logout的，截止到当天23：59
没有login只有logout的，从00:00起计算

ly5066113

try:

1. $ cat test.awk
   
2. #! /usr/bin/awk -f
   
3. 
   
4. BEGIN {
   
5.         FS = "[][]"
   
6. }
   
7. 
   
8. /login/ && ! /failed/ {
   
9.         a[$22] = d2s($2)
   
10. }
    
11. /logout/ {
    
12.         c[$20] = d2s($2)
    
13. 
    
14.         if(a[$20])
    
15.         {
    
16.                 b[$20] += c[$20] - a[$20]
    
17.         }
    
18.         else
    
19.         {
    
20.                 b[$20] += c[$20] - d2s(substr($2, 1, 10)" 00:00:00")
    
21.         }
    
22. }
    
23. END {
    
24.         for(i in a)
    
25.         {
    
26.                 if(c[i] < a[i])
    
27.                 {
    
28.                         b[i] = d2s(strftime("%Y %m %d", a[i])" 23:59:59") - a[i]
    
29.                 }
    
30.         }
    
31.         for(i in b)
    
32.         {
    
33.                 print i, b[i]
    
34.         }
    
35. }
    
36. 
    
37. function d2s(d)
    
38. {
    
39.         gsub(/[-:]/, " ", d)
    
40.         s = mktime(substr(d, 1, 19))
    
41.         return s
    
42. }
    
43. $ awk -f test.awk urfile
    
44. 2730 4974
    
45. 2732 27396
    
46. 2095 386298
    
47. 2725 57450
    
48. 2088 386298
    
49. 2736 21143
    
50. 2729 112144

复制代码

[ 本帖最后由 ly5066113 于 2009-12-3 18:00 编辑 ]

nblity

保存为test.awk
chmod +x test.awk
./test.awk之后
提示信息：
./test.awk: line 1: $: command not found
./test.awk: line 4: BEGIN: command not found
./test.awk: line 5: FS: command not found
./test.awk: line 6: syntax error near unexpected token `}'
./test.awk: line 6: `}'

lucash

晕，你不会把第一行的 $ cat test.awk也放进去了吧？

nblity

第一行跟最后一行都不放进去？
呵呵，我是做java的，对shell一点都不懂
见笑了，不过正在学习

walkerxk

$ 开头的行不要放进去，就这两个$ 中间的部分就行了，$ 是shell提示符

nblity

嗯，明白了
已经测试出结果
谢谢两位
我还得继续研究研究

nblity

弱弱的再问一下，怎样让上述代码的结果输出到一个文本文件中呢？