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);