日志筛选

debian:/home/haoyou/lfs1/game_os/log# cat day/item_20130227.txt |grep n71908|grep 23:55:
2013-02-27 23:55:09     1       item_output     n71908  1016244 [s1]??? 0       32101   ?????   9       1       (["Amount":1,])
2013-02-27 23:55:11     1       item_output     n71908  1016244 [s1]??? 0       32101   ?????   9       1       (["Amount":1,])
2013-02-27 23:55:14     1       item_output     n71908  1016244 [s1]??? 0       32101   ?????   9       1       (["Amount":1,])
2013-02-27 23:55:16     1       item_output     n71908  1016244 [s1]??? 0       32101   ?????   9       1       (["Amount":1,])
debian:/home/haoyou/lfs1/game_os/log# cat day/item_20130227.txt |grep n71908|grep 23:55:
2013-02-27 23:55:09     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
2013-02-27 23:55:11     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
2013-02-27 23:55:14     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
2013-02-27 23:55:16     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
debian:/home/haoyou/lfs1/game_os/log# cat day/item_20130227.txt |grep n71908|grep 23:55:
2013-02-27 23:55:09     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
2013-02-27 23:55:11     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
2013-02-27 23:55:14     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
2013-02-27 23:55:16     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
debian:/home/haoyou/lfs1/game_os/log# cat day/item_20130227.txt |grep n71908|grep 23:55:
2013-02-27 23:55:09     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
2013-02-27 23:55:11     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
2013-02-27 23:55:14     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
2013-02-27 23:55:16     1       item_output     n71908  1016244 [s1]棰ㄤ箣鐥?  0       32101   鍧绾ц摑娉㈢悆  9       1       (["Amount":1,])
debian:/home/haoyou/lfs1/game_os/log# cat hour/db_exec_sql_20130227
db_exec_sql_2013022700.txt  db_exec_sql_2013022706.txt  db_exec_sql_2013022712.txt  db_exec_sql_2013022718.txt
db_exec_sql_2013022701.txt  db_exec_sql_2013022707.txt  db_exec_sql_2013022713.txt  db_exec_sql_2013022719.txt
db_exec_sql_2013022702.txt  db_exec_sql_2013022708.txt  db_exec_sql_2013022714.txt  db_exec_sql_2013022720.txt
db_exec_sql_2013022703.txt  db_exec_sql_2013022709.txt  db_exec_sql_2013022715.txt  db_exec_sql_2013022721.txt
db_exec_sql_2013022704.txt  db_exec_sql_2013022710.txt  db_exec_sql_2013022716.txt  db_exec_sql_2013022722.txt
db_exec_sql_2013022705.txt  db_exec_sql_2013022711.txt  db_exec_sql_2013022717.txt  db_exec_sql_2013022723.txt
debian:/home/haoyou/lfs1/game_os/log# cat hour/db_exec_sql_2013022723.txt | grep 32101|grep n71908|grep player_item
debian:/home/haoyou/lfs1/game_os/log# cat hour/db_exec_sql_201302272*.txt | grep 32101|grep n71908|grep player_item

debian:/home/haoyou/lfs1/game_os/log# cat hour/db_exec_sql_20130227*.txt | grep 32101|grep n71908|grep player_item

mysql> select * from name_list where player_account='9000135268662808884';
ERROR 1146 : Table 'koa_game1_db2.name_list' doesn't exist
mysql> select * from koa_account1_db.name_list where player_account='9000135268662808884';
+------------------+---------+---------------------+----------+
| player_name      | role_id | player_account      | db_op_id |
+------------------+---------+---------------------+----------+
| [s1]文森尼奧                 |    1028 | 9000135268662808884 |        2 |
| [s2]趙完松       |  500008 | 9000135268662808884 |        2 |
| [s2]布克邦傑弗   |  508422 | 9000135268662808884 |        2 |
| [s1]馬默蓓爾卡蘿 |  508417 | 9000135268662808884 |        2 |
+------------------+---------+---------------------+----------+
4 rows in set

mysql> select * from koa_account1_db.name_list where role_id=508409;
Empty set

mysql> select * from koa_account1_db.name_list where player_account='9000135268662808884';
+------------------+---------+---------------------+----------+
| player_name      | role_id | player_account      | db_op_id |
+------------------+---------+---------------------+----------+
| [s1]文森尼奧      |    1028 | 9000135268662808884 |        2 |
| [s2]趙完松       |  500008 | 9000135268662808884 |        2 |
| [s2]布克邦傑弗   |  508422 | 9000135268662808884 |        2 |
| [s1]馬默蓓爾卡蘿 |  508417 | 9000135268662808884 |        2 |
+------------------+---------+---------------------+----------+
4 rows in set

mysql> select * from player_base_info where uid=508409;
+--------+--------------+-----+---------------------+-------+--------+------+----------+--------+---------------------+-------+------+----+---+---+----+--------------+-------------+------------+-------+-----+------+-----+-------------+----------+------------+------------+------------+----------------+--------+---------+
| uid    | name         | sex | birthday            | level | region | host | position | family | account             | photo | type | x  | y | d | z  | channel_flag | skill_point | gift_point | title | vip | rank | exp | upgrade_exp | fighting | reg_time   | reg_ip     | ontime     | onip           | online | outline |
+--------+--------------+-----+---------------------+-------+--------+------+----------+--------+---------------------+-------+------+----+---+---+----+--------------+-------------+------------+-------+-----+------+-----+-------------+----------+------------+------------+------------+----------------+--------+---------+
| 508409 | [s2]捷惠萊麗 |   2 | 2013-03-01 17:34:46 |     2 |      3 |    2 |         0 |       1 | 9000135268662808884                    | NULL  |     0 |   11 |  9 |  0 |   73 |             0 |            1 | NULL       | 0      |    0 |     0 |    0 |            59 |         10 |           1362130486 | 1.34.218.6           |           1362388331 | 219.136.30.158               |       1 |        0 |
+--------+--------------+-----+---------------------+-------+--------+------+----------+--------+---------------------+-------+------+----+---+---+----+--------------+-------------+------------+-------+-----+------+-----+-------------+----------+------------+------------+------------+----------------+--------+---------+
1 row in set

mysql> select * from player_base_info where account='9000135268662808884';
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+------+------+--+--+
| uid | name | sex | birthday | level | region | host | position | family | account | photo     | type | x | y | d | z | channel_flag | skill_point | gift_point     | title | vip | rank | exp | upgrade_exp | fighting | reg_time | reg_ip | ontime     | onip     | online | outline |
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+------+------+--+--+
| 1028 | [s1]文森尼奧 | 1 | 2012-12-12 11:04:23 | 15 | 3 | 1 | 0 | 2 | 9000135268662808884 | NULL | 0 | 55 | 33 | 1 | 72 | 0 | 1 | NULL | 0 | 0 | 7474 | 40 | 231 | 581 | 1355281463 | 183.60.99.216 |     1362357767 | 58.64.163.254     | 0 | 0 |
| 508409 | [s2]捷惠萊麗 | 2 | 2013-03-01 17:34:46 | 2 | 3 | 2 | 0 | 1 | 9000135268662808884 | NULL | 0 | 12 | 9 | 0 | 73 | 0 | 1 | NULL | 0 | 0 | 0 | 0 | 59 | 10 | 1362130486 | 1.34.218.6 |     1362388763 | 219.136.30.158     | 1 | 0 |
| 500008 | [s2]趙完松 | 1 | 2013-01-19 12:27:02 | 14 | 3 | 2 | 0 | 3 | 9000135268662808884 | NULL | 0 | 58 | 13 | 1 | 77 | 0 | 1 | NULL | 0 | 3 | 11687 | 180 | 218 | 804 | 1358569622 | 58.64.163.254 |     1362130494 | 1.34.218.6     | 0 | 0 |
| 508417 | [s1]馬默蓓爾卡蘿 | 2 | 2013-03-01 18:27:59 | 1 | 3 | 1 | 0 | 1 | 9000135268662808884 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | 0 | 0 | 0 | 1 | 0 | 0 | 1362133679 | 219.136.30.155 | NULL | NULL | 0 | 0 |
| 508422 | [s2]布克邦傑弗 | 1 | 2013-03-01 18:47:29 | 1 | 3 | 2 | 0 | 2 | 9000135268662808884 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | 0 | 0 | 0 | 1 | 0 | 0 | 1362134849 | 219.136.30.155 | NULL | NULL | 0 | 0 |
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+------+------+--+--+
5 rows in set

mysql> select uid,name,account,host from player_base_info where account='9000135268662808884';
+--+--+--+--+
| uid | name | account | host |
+--+--+--+--+
| 1028 | [s1]文森尼奧 | 9000135268662808884 | 1 |
| 508409 | [s2]捷惠萊麗 | 9000135268662808884 | 2 |
| 500008 | [s2]趙完松 | 9000135268662808884 | 2 |
| 508417 | [s1]馬默蓓爾卡蘿 | 9000135268662808884 | 1 |
| 508422 | [s2]布克邦傑弗 | 9000135268662808884 | 2 |
+--+--+--+--+
5 rows in set

mysql> select uid,account,host,name from player_base_info where account='9000135268662808884';
+--+--+--+--+
| uid | account | host | name |
+--+--+--+--+
| 1028 | 9000135268662808884 | 1 | [s1]文森尼奧 |
| 508409 | 9000135268662808884 | 2 | [s2]捷惠萊麗 |
| 500008 | 9000135268662808884 | 2 | [s2]趙完松 |
| 508417 | 9000135268662808884 | 1 | [s1]馬默蓓爾卡蘿 |
| 508422 | 9000135268662808884 | 2 | [s2]布克邦傑弗 |
+--+--+--+--+



mysql> select * from koa_account1_db.name_list where player_account='9000135268662808884';
+------------------+---------+---------------------+----------+
| player_name      | role_id | player_account      | db_op_id |
+------------------+---------+---------------------+----------+
| [s1]文森尼奧      |    1028 | 9000135268662808884 |        2 |
| [s2]趙完松       |  500008 | 9000135268662808884 |        2 |
| [s2]布克邦傑弗                 |  508422 | 9000135268662808884 |        2 |
| [s1]馬默蓓爾卡蘿 |  508417 | 9000135268662808884 |        2 |
+------------------+---------+---------------------+----------+
4 rows in set

mysql> select * from koa_account1_db.name_list where role_id in (508422, 508417);
+------------------+---------+---------------------+----------+
| player_name      | role_id | player_account      | db_op_id |
+------------------+---------+---------------------+----------+
| [s1]馬默蓓爾卡蘿 |  508417 | 9000135268662808884 |        2 |
| [s2]布克邦傑弗   |  508422 | 9000135268662808884 |        2 |
+------------------+---------+---------------------+----------+
2 rows in set

mysql> select * from koa_game1_db2.player_base_info where account='9000135268662808884';
+--------+------------------+-----+---------------------+-------+--------+------+----------+--------+---------------------+-------+------+----+----+---+----+--------------+-------------+------------+-------+-----+-------+-----+-------------+----------+------------+----------------+------------+----------------+--------+---------+
| uid    | name             | sex | birthday            | level | region | host | position | family | account             | photo | type | x  | y  | d | z  | channel_flag | skill_point | gift_point | title | vip | rank  | exp | upgrade_exp | fighting | reg_time   | reg_ip         | ontime     | onip           | online | outline |
+--------+------------------+-----+---------------------+-------+--------+------+----------+--------+---------------------+-------+------+----+----+---+----+--------------+-------------+------------+-------+-----+-------+-----+-------------+----------+------------+----------------+------------+----------------+--------+---------+
|   1028 | [s1]文森尼奧     |   1 | 2012-12-12 11:04:23 |    15 |      3 |    1 |        0 |      2 | 9000135268662808884 | NULL  |    0 | 55 | 33 | 1 | 72 |            0 |           1 | NULL       | 0     |   0 |  7474 |  40 |         231 |      581 | 1355281463 | 183.60.99.216   | 1362357767 | 58.64.163.254   |      0 |       0 |
| 508409 | [s2]捷惠萊麗      |   2 | 2013-03-01 17:34:46   |     2 |      3 |    2 |        0 |      1 | 9000135268662808884 | NULL  |    0 |  3 | 13 | 0 | 73 |            0 |           1 | NULL       | 0     |   0 |     0 |   0 |          59 |       10 | 1362130486 | 1.34.218.6      | 1362388763 | 219.136.30.158  |      0 |       0 |
| 500008 | [s2]趙完松        |   1 | 2013-01-19 12:27:02   |    14 |      3 |    2 |        0 |      3 | 9000135268662808884 | NULL  |    0 | 58 | 13 | 1 | 77 |            0 |           1 | NULL       | 0     |   3 | 11687 | 180 |         218 |      804 | 1358569622 | 58.64.163.254   | 1362130494 | 1.34.218.6      |      0 |       0 |
| 508417 | [s1]馬默蓓爾卡蘿  |   2 | 2013-03-01 18:27:59   |     1 |      3 |    1 |        0 |      1 | 9000135268662808884 | NULL  |    0 |  0 |  0 | 0 |  0 |            0 |           1 | NULL       | 0     |   0 |     0 |   1 |           0 |        0 | 1362133679 | 219.136.30.155  | NULL       | NULL           |      0 |       0 |
| 508422 | [s2]布克邦傑弗    |   1 | 2013-03-01 18:47:29   |     1 |      3 |    2 |        0 |      2 | 9000135268662808884 | NULL  |    0 |  0 |  0 | 0 |  0 |            0 |           1 | NULL       | 0     |   0 |     0 |   1 |           0 |        0 | 1362134849 | 219.136.30.155  | NULL       | NULL           |      0 |       0 |
+--------+------------------+-----+---------------------+-------+--------+------+----------+--------+---------------------+-------+------+----+----+---+----+--------------+-------------+------------+-------+-----+-------+-----+-------------+----------+------------+----------------+------------+----------------+--------+---------+
5 rows in set

mysql> select * from koa_game1_db2.player_base_info where uid in (508422, 508417, 508409);
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+------+------+--+--+
| uid | name | sex | birthday | level | region | host | position | family | account | photo     | type | x | y | d | z | channel_flag | skill_point | gift_point     | title | vip | rank | exp | upgrade_exp | fighting | reg_time | reg_ip | ontime     | onip     | online | outline |
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+------+------+--+--+
| 508409 | [s2]捷惠萊麗 | 2 | 2013-03-01 17:34:46 | 2 | 3 | 2 | 0 | 1 | 9000135268662808884 | NULL | 0 | 3 | 13 | 0 | 73 | 0 | 1 | NULL | 0 | 0 | 0 | 0 | 59 | 10 | 1362130486 | 1.34.218.6 |     1362388763 | 219.136.30.158     | 0 | 0 |
| 508417 | [s1]馬默蓓爾卡蘿 | 2 | 2013-03-01 18:27:59 | 1 | 3 | 1 | 0 | 1 | 9000135268662808884 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | 0 | 0 | 0 | 1 | 0 | 0 | 1362133679 | 219.136.30.155 | NULL | NULL | 0 | 0 |
| 508422 | [s2]布克邦傑弗 | 1 | 2013-03-01 18:47:29 | 1 | 3 | 2 | 0 | 2 | 9000135268662808884 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | 0 | 0 | 0 | 1 | 0 | 0 | 1362134849 | 219.136.30.155 | NULL | NULL | 0 | 0 |
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+------+------+--+--+
3 rows in set

mysql> select * from koa_game1_db2.player_base_info where uid in (508422, 508417, 508409);
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+------+------+--+--+
| uid | name | sex | birthday | level | region | host | position | family | account | photo     | type | x | y | d | z | channel_flag | skill_point | gift_point     | title | vip | rank | exp | upgrade_exp | fighting | reg_time | reg_ip | ontime     | onip     | online | outline |
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+------+------+--+--+
| 508409 | [s2]捷惠萊麗 | 2 | 2013-03-01 17:34:46 | 2 | 3 | 2 | 0 | 1 | 9000135268662808884 | NULL | 0 | 3 | 13 | 0 | 73 | 0 | 1 | NULL | 0 | 0 | 0 | 0 | 59 | 10 | 1362130486 | 1.34.218.6 |     1362388763 | 219.136.30.158     | 0 | 0 |
| 508417 | [s1]馬默蓓爾卡蘿 | 2 | 2013-03-01 18:27:59 | 1 | 3 | 1 | 0 | 1 | 9000135268662808884 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | 0 | 0 | 0 | 1 | 0 | 0 | 1362133679 | 219.136.30.155 | NULL | NULL | 0 | 0 |
| 508422 | [s2]布克邦傑弗 | 1 | 2013-03-01 18:47:29 | 1 | 3 | 2 | 0 | 2 | 9000135268662808884 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 1 | NULL | 0 | 0 | 0 | 1 | 0 | 0 | 1362134849 | 219.136.30.155 | NULL | NULL | 0 | 0 |
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+------+------+--+--+
3 rows in set

mysql> select * from koa_account1_db.name_list where role_id in (508422, 508417);
Empty set

mysql> select * from koa_account1_db.name_list where role_id in (508422, 508417);
Empty set

mysql> select * from koa_game1_db2.player_base_info where uid in (508422, 508417, 508409);
Empty set

mysql> select * from koa_account1_db.name_list where player_account='9000135268662808884';
+--+--+--+--+
| player_name | role_id | player_account | db_op_id |
+--+--+--+--+
| [s1]文森尼奧 | 1028 | 9000135268662808884 | 2 |
| [s2]趙完松 | 500008 | 9000135268662808884 | 2 |
+--+--+--+--+
2 rows in set

mysql> select * from koa_game1_db2.player_base_info where account='9000135268662808884';
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+--+--+--+--+
| uid | name | sex | birthday | level | region | host | position | family | account | photo     | type | x | y | d | z | channel_flag | skill_point | gift_point     | title | vip | rank | exp | upgrade_exp | fighting | reg_time | reg_ip | ontime | onip | online | outline |
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+--+--+--+--+
| 1028 | [s1]文森尼奧 | 1 | 2012-12-12 11:04:23 | 15 | 3 | 1 | 0 | 2 | 9000135268662808884 | NULL | 0 | 55 | 33 | 1 | 72 | 0 | 1 | NULL | 0 | 0 | 7474 | 40 | 231 | 581 | 1355281463 | 183.60.99.216 | 1362357767 | 58.64.163.254 | 0 | 0 |
| 500008 | [s2]趙完松 | 1 | 2013-01-19 12:27:02 | 14 | 3 | 2 | 0 | 3 | 9000135268662808884 | NULL | 0 | 58 | 13 | 1 | 77 | 0 | 1 | NULL | 0 | 3 | 11687 | 180 | 218 | 804 | 1358569622 | 58.64.163.254 | 1362130494 | 1.34.218.6 | 0 | 0 |
+--+--+--+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+------+--+--+--+--+--+--+--+--+--+--+--+--+
2 rows in set

mysql> 




delete from  koa_account1_db.name_list where role_id in (508422, 508417, 508409);
use koa_game1_db2;
delete from `pet` where uid in (508422, 508417, 508409);
delete from `player_copy` where uid in (508422, 508417, 508409);
delete from `player_fight_info` where uid in (508422, 508417, 508409);
delete from `player_file` where uid in (508422, 508417, 508409);
delete from `player_file_ex` where uid in (508422, 508417, 508409);
delete from `player_friend` where uid in (508422, 508417, 508409);
delete from `player_glory_info` where playerid in (508422, 508417, 508409);
delete from `player_item` where uid in (508422, 508417, 508409);
delete from `player_money` where uid in (508422, 508417, 508409);
delete from `player_shape` where uid in (508422, 508417, 508409);
delete from `player_skill` where uid in (508422, 508417, 508409);
delete from `player_base_info` where uid in (508422, 508417, 508409);





评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值