台灣破天玩家經驗分享 - 破天一劍数据库用户表分析

字段:account[帐号],size,ver,date,data[256位],chr1,chr2,chr3,ver_ex
varchar[17],int,int,datetime,varbinary[7500],int,int,int,int
例子分析:
account:adetion
size:5780
ver:537137685
date:2008-12-15 15:35:45.000
chr1:1834 序号而已,库里的触发器自动设置了chr2,chr3递增1
chr2:1835
chr3:1836
ver_ex:537137685
data:
0x 后的前62位为该帐号特征标识,不能动,否则数据清零。这里虽然分析了,但不是最全的,个人别乱改啊,否则物品和仓库会全部清空的,只剩等级了。
没有金钱信息,无身上装备信息,无排行, 详细分析如下
0x343536000000000000000000000000000001000C0000006700职业秀雅
D0E3D0E30000名字6个编码
0000000000000000000000000000
0000000000000000000000000000
64000900110009002E0066028400D7000000820300008CF587FA000000003737393900000000000000000000000000000000000000000000000000000000000006120000D70066027F00A8014C00000000009B00010001000100390001000A000100010000000100630087000000BD403E490000000000000000060000000000000000000000AB000000A200000000000000000000007E01B80B09000000AF0000007C000000
装备
AD0BDE268C000000
1F08AE248B000000
CE0BF4268F000000
D90B302690000000
C30BBA268E000000
EF0B762692000000
E40B162791000000
050C6E2794000000
B80B1E278D000000
FA0BCB2593000000
0000000000000000
背包开始
3F0C581B05000000
580600002F000000A30B6829B0000000E8020000010000004B06000054030000E702000001000000FE00000002000000AB0000000D000000B0000000050000004E0C1027A300000047030000320000004F0C0000010000000601000009000000000000000000000000000000000000004C0C000005000000410C00000500000042054826B30000004B0C0000050000004A0C0000140000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000
0000000000000000背包结束
0200040002000200000002000100030006000A0005000500
0700070007000700
02095400钱
E044000050660100000000030003000000000000000E0E0E0011000000
6500第二个职业
616161000000第二个人名字
0000000000000000000000000000
0000000000000000000000000000
0100110009000900000020001E007800000000000000C8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000780020001E000300020000002C010800010001000100030001000A0001000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000头巾
0000000000000000
5700000001000000
0000000000000000
0000000000000000
6F00000001000000
6900000001000000
6A01000001000000
0000000000000000
7500000001000000
0000000000000000
背包
0100000001000000
920AB80B01000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000背包结束
040004000400040004000400040004000A000A000A000A000A000A000A000A00
00000000钱
C06E0000800C0000000000010000000000000000000000000000000000
0000职业
000000000000名字
0000000000000000000000000000
0000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
装备
0000000000000000
00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000
0000000000000000背包开始
00000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000背包结束
0000000000000000000000000000000000000000
仓库
C802A00FAF000000
7001B80B09000000
8901100EB3000000
8901100EB4000000
8901100EB5000000
8901100EB6000000
8901100EB70000008901100EB80000008901100EB90000008901100EBA0000008901100EBB0000008901100EBC0000008901100EBD0000008901100EBE0000008901100EBF0000008901100EC00000008901100EC10000008901100EC20000008901100EC30000008901100EC40000008901100EC50000008901100EC6000000A900B80B090000000B02000001000000DD030000080000008900B80B09000000AA0000002900000009000000B20000008B000000010000000101000001000000BA0000000100000049030000010000000F02000007000000AB0000000B0000000E0200000600000082010000020000007A010000040000004B0C0000050000004C0C000005000000410C00000F00000078010000090000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
0000000000000000仓库结束
00000000000000000000000000000000000000000000000000000000000000000000000000000