Player Data Structure

[FilipeBS]

Hi folks!

I'm trying to save the player, npcs and itens data into a mysql database and i have some questions. As the server save the player data in a bin format i can't see how the data is stored. There is some way for me to see the data structure?

[Scott]

modtypes on the server

```

Private Type PlayerRec

' Account

Login As String * ACCOUNT_LENGTH

Password As String * NAME_LENGTH

' General

Name As String * ACCOUNT_LENGTH

Sex As Byte

Class As Long

Sprite As Long

Level As Byte

exp As Long

Access As Byte

PK As Byte

' Vitals

Vital(1 To Vitals.Vital_Count - 1) As Long

' Stats

Stat(1 To Stats.Stat_Count - 1) As Byte

POINTS As Long

' Worn equipment

Equipment(1 To Equipment.Equipment_Count - 1) As Long

' Inventory

Inv(1 To MAX_INV) As PlayerInvRec

Spell(1 To MAX_PLAYER_SPELLS) As Long

' Hotbar

Hotbar(1 To MAX_HOTBAR) As HotbarRec

' Position

Map As Long

x As Byte

y As Byte

Dir As Byte

End Type

```

Player Data for example

[FilipeBS]

I kown this. I mean for exemple the "Vitals", the "Stat" and the "Equipment" if you remember i old eclipse/elysium we had HP/MP values stored instead "Vitals" we had the Str, Agi, End, Will, Int instead the "Stat". Do you understand what i want to say now?

I want to know if i have to create a collum HP and MP separated or just Vitals. You got it?

[Scott]

server,modEnumerations under the client/server packets.

```

' Stats used by Players, Npcs and Classes

Public Enum Stats

Strength = 1

Endurance

Intelligence

Agility

Willpower

' Make sure Stat_Count is below everything else

Stat_Count

End Enum

' Vitals used by Players, Npcs and Classes

Public Enum Vitals

HP = 1

MP

' Make sure Vital_Count is below everything else

Vital_Count

End Enum

' Equipment used by Players

Public Enum Equipment

Weapon = 1

Armor

Helmet

Shield

' Make sure Equipment_Count is below everything else

Equipment_Count

End Enum

' Layers in a map

Public Enum MapLayer

Ground = 1

Mask

Mask2

Fringe

Fringe2

' Make sure Layer_Count is below everything else

Layer_Count

End Enum

' Sound entities

Public Enum SoundEntity

seAnimation = 1

seItem

seNpc

seResource

seSpell

' Make sure SoundEntity_Count is below everything else

SoundEntity_Count

End Enum

```