eqdb

type Account struct {
	ID             int32          `json:"id" db:"id"`
	LSAccountID    int32          `json:"lsaccount_id" db:"lsaccount_id"`
	Name           string         `json:"name" db:"name"`
	CharName       sql.NullString `json:"charname" db:"charname"`
	Status         int32          `json:"status" db:"status"`
	Revoked        bool           `json:"revoked" db:"revoked"`
	SuspendedUntil sql.NullTime   `json:"suspended_until" db:"suspendeduntil"`
	BanReason      sql.NullString `json:"ban_reason" db:"ban_reason"`
	SuspendReason  sql.NullString `json:"suspend_reason" db:"suspend_reason"`
	RevokedUntil   sql.NullTime   `json:"revoked_until" db:"revokeduntil"`
}

type Character struct {
	ID      int32  `json:"id" db:"id"`
	Name    string `json:"name" db:"name"`
	Surname string `json:"surname" db:"surname"`
	Race    int32  `json:"race" db:"race"`
	Class   int32  `json:"class" db:"class"`
	Level   int32  `json:"level" db:"level"`
	ZoneID  int32  `json:"zone_id" db:"zone_id"`
	Stats   Stats  `json:"stats" db:"stats"`
}

type Inventory []InventoryItem

type InventoryItem struct {
	SlotID   int32  `json:"slot_id" db:"slot_id"`
	ItemID   int32  `json:"item_id" db:"item_id"`
	Charges  int32  `json:"charges" db:"charges"`
	Location string `json:"location" db:"location"` // Original TAKP location string
}

type ItemName struct {
	ID   int32  `json:"id" db:"id"`
	Name string `json:"name" db:"name"`
}

type LSAccount struct {
	ID            int32     `json:"id" db:"LoginServerID"`
	Name          string    `json:"account_name" db:"AccountName"`
	Password      string    `json:"password" db:"AccountPassword"`
	LastLoginDate time.Time `json:"last_login_date" db:"LastLoginDate"`
}

type ListCharactersRequest struct {
	AccountID int32 `json:"account_id"`
}

type Stats struct {
	HP   int32 `json:"hp"`
	Mana int32 `json:"mana"`
	Str  int32 `json:"str"`
	Sta  int32 `json:"sta"`
	Agi  int32 `json:"agi"`
	Dex  int32 `json:"dex"`
	Wis  int32 `json:"wis"`
	Int  int32 `json:"int"`
	Cha  int32 `json:"cha"`
}