私人-Database

將軍

Map
mapPID:integer
mapClass:integer(player,building,terrain)
mapTerrainID:integer(terrainID)
mapBuildingID:integer(buildingPID)
mapOwner:integer(unitPID)
mapImgID:integer(imgID)
mapX:integer
mapY:integer
mapCreatingTime:timestamp

Player
playerPID:integer
playerID:String
playerPW:String
playerName:String
playerMail:String
playerCreatingTime:timestamp
playerLastLoginTime:timestamp
playerCreatingIP:String
playerLastLoginIP:String
playerLanguage:String
playerBrowser:String

Building
buildingPID:integer
buildingClass:integer
buildingName:String
buildingBuilder:integer(playerPID)
buildingState:integer
buildingX:integer
buildingY:integer
buildingHP:integer
buildingMaxHP:integer
buildingCreatingTime:timestamp

Room
RoomPID:integer
RoomClass:integer
RoomBelong:integer(BuildingPID)
RoomOwner:integer(playerPID)
RoomStander:integer(unitPID)
RoomImgID:integer(imgID)
RoomState:integer
RoomX:integer
RoomY:integer
RoomGate:integer
RoomStair:integer


Unit
unitPID:integer
unitOwner:integer(playerPID)
unitState:integer
unitX:integer
unitY:integer
unitName:String
unitHP:integer
unitMaxHP:integer
unitPower:integer
unitMaxPower:integer
unitMoneyType        :integer
unitMoneyAmount:integer
unitGroupID:integer(groupPID)
unitSkill1ID:integer
unitSkill2ID:integer
unitSkill3ID:integer
unitSkill4ID:integer
unitSkill5ID:integer
unitAttribute1:float
unitAttribute2:float
unitAttribute3:float
unitAttribute4:float
unitAttribute5:float
unitAttribute6:float
unitAttribute7:float
unitAttribute8:float
unitHelmet(equipmentID)
unitArmor(equipmentID)
unitRangeWeapon(equipmentPID)
unitMeleeWeapon(equipmentPID)
unitProtableDevice(equipmentPID)
unitUnknowSlot:integer(equipmentPID)
unitRAtt:integer
unitMatt:integer
unitDef:integer
unitAttRange:String
unitCreatingTime:timestamp

Equipment

Group

BattleLog
battleLogPID:integer
battleLogState:integer (0: active attack, 1: passive attack, 2: attacked unit miss, 3: attacking unit miss, 4: attacked unit dead, 5: attacking unit dead)
battleLogAttackedUnit:integer(playerPID)
battleLogAttackingUnit:integer(playerPID)
battleLogAttackedUnitWeapon(equipmentPID)
battleLogAttackingUnitWeapon(equipmentPID)
battleLogMelee:integer
battleLogDamage:integer
battleLogCreatingTime:timestamp

將軍

Type of Terrain (mapTerrainID):
0: unknow
1: dust

Type of Character Img (mapImgID):
0: unknow
1: go up
2: go down
3: go left
4: go right
5: stand face up
6: stand face down
7: stand face left
8: stand face right
9: attack face up
10: attack face down
11: attack face left
12: attack face right
13: melee attack face up
14: melee attack face down
15: melee attack face left
16: melee attack face right
17: talk face up
18: talk attack face down
19: talk attack face left
20: talk attack face right

Type of Unit State:
0: normal
1: collapsing
2: AlertMode