mysqlc

package
v0.0.0-...-26b89f5 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Sep 2, 2024 License: MIT Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Author 

type Author struct {
	ID   int64
	Name string
	Bio  sql.NullString
}

type CharacterDatum 

type CharacterDatum struct {
	ID                    uint32
	AccountID             int32
	Name                  string
	LastName              string
	Title                 string
	Suffix                string
	ZoneID                uint32
	ZoneInstance          uint32
	Y                     float64
	X                     float64
	Z                     float64
	Heading               float64
	Gender                uint8
	Race                  uint16
	Class                 uint8
	Level                 uint32
	Deity                 uint32
	Birthday              uint32
	LastLogin             uint32
	TimePlayed            uint32
	Level2                uint8
	Anon                  uint8
	Gm                    uint8
	Face                  uint32
	HairColor             uint8
	HairStyle             uint8
	Beard                 uint8
	BeardColor            uint8
	EyeColor1             uint8
	EyeColor2             uint8
	DrakkinHeritage       uint32
	DrakkinTattoo         uint32
	DrakkinDetails        uint32
	AbilityTimeSeconds    uint8
	AbilityNumber         uint8
	AbilityTimeMinutes    uint8
	AbilityTimeHours      uint8
	Exp                   uint32
	ExpEnabled            bool
	AaPointsSpent         uint32
	AaExp                 uint32
	AaPoints              uint32
	GroupLeadershipExp    uint32
	RaidLeadershipExp     uint32
	GroupLeadershipPoints uint32
	RaidLeadershipPoints  uint32
	Points                uint32
	CurHp                 uint32
	Mana                  uint32
	Endurance             uint32
	Intoxication          uint32
	Str                   uint32
	Sta                   uint32
	Cha                   uint32
	Dex                   uint32
	Int                   uint32
	Agi                   uint32
	Wis                   uint32
	ZoneChangeCount       uint32
	Toxicity              uint32
	HungerLevel           uint32
	ThirstLevel           uint32
	AbilityUp             uint32
	LdonPointsGuk         uint32
	LdonPointsMir         uint32
	LdonPointsMmc         uint32
	LdonPointsRuj         uint32
	LdonPointsTak         uint32
	LdonPointsAvailable   uint32
	TributeTimeRemaining  uint32
	CareerTributePoints   uint32
	TributePoints         uint32
	TributeActive         uint32
	PvpStatus             uint8
	PvpKills              uint32
	PvpDeaths             uint32
	PvpCurrentPoints      uint32
	PvpCareerPoints       uint32
	PvpBestKillStreak     uint32
	PvpWorstDeathStreak   uint32
	PvpCurrentKillStreak  uint32
	Pvp2                  uint32
	PvpType               uint32
	ShowHelm              uint32
	GroupAutoConsent      uint8
	RaidAutoConsent       uint8
	GuildAutoConsent      uint8
	LeadershipExpOn       uint8
	Resttimer             uint32
	AirRemaining          uint32
	AutosplitEnabled      uint32
	Lfp                   bool
	Lfg                   bool
	Mailkey               string
	Xtargets              uint8
	Firstlogon            int8
	EAaEffects            uint32
	EPercentToAa          uint32
	EExpendedAaSpent      uint32
	AaPointsSpentOld      uint32
	AaPointsOld           uint32
	ELastInvsnapshot      uint32
	DeletedAt             sql.NullTime
}

type DBTX 

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DiscoveredItem 

type DiscoveredItem struct {
	ItemID         uint32
	CharName       string
	DiscoveredDate uint32
	AccountStatus  int32
}

type FactionList 

type FactionList struct {
	ID   int32
	Name string
	Base int16
}

type Item 

type Item struct {
	ID                  int32
	Minstatus           int16
	Name                string
	Aagi                int32
	Ac                  int32
	Accuracy            int32
	Acha                int32
	Adex                int32
	Aint                int32
	Artifactflag        uint8
	Asta                int32
	Astr                int32
	Attack              int32
	Augrestrict         int32
	Augslot1type        int8
	Augslot1visible     int8
	Augslot2type        int8
	Augslot2visible     int8
	Augslot3type        int8
	Augslot3visible     int8
	Augslot4type        int8
	Augslot4visible     int8
	Augslot5type        int8
	Augslot5visible     int8
	Augslot6type        int8
	Augslot6visible     int8
	Augtype             int32
	Avoidance           int32
	Awis                int32
	Bagsize             int32
	Bagslots            int32
	Bagtype             int32
	Bagwr               int32
	Banedmgamt          int32
	Banedmgraceamt      int32
	Banedmgbody         int32
	Banedmgrace         int32
	Bardtype            int32
	Bardvalue           int32
	Book                int32
	Casttime            int32
	CastTime2           int32
	Charmfile           string
	Charmfileid         string
	Classes             int32
	Color               uint32
	Combateffects       string
	Extradmgskill       int32
	Extradmgamt         int32
	Price               int32
	Cr                  int32
	Damage              int32
	Damageshield        int32
	Deity               int32
	Delay               int32
	Augdistiller        uint32
	Dotshielding        int32
	Dr                  int32
	Clicktype           int32
	Clicklevel2         int32
	Elemdmgtype         int32
	Elemdmgamt          int32
	Endur               int32
	Factionamt1         int32
	Factionamt2         int32
	Factionamt3         int32
	Factionamt4         int32
	Factionmod1         int32
	Factionmod2         int32
	Factionmod3         int32
	Factionmod4         int32
	Filename            string
	Focuseffect         int32
	Fr                  int32
	Fvnodrop            int32
	Haste               int32
	Clicklevel          int32
	Hp                  int32
	Regen               int32
	Icon                int32
	Idfile              string
	Itemclass           int32
	Itemtype            int32
	Ldonprice           int32
	Ldontheme           int32
	Ldonsold            int32
	Light               int32
	Lore                string
	Loregroup           int32
	Magic               int32
	Mana                int32
	Manaregen           int32
	Enduranceregen      int32
	Material            int32
	Herosforgemodel     int32
	Maxcharges          int32
	Mr                  int32
	Nodrop              int32
	Norent              int32
	Pendingloreflag     uint8
	Pr                  int32
	Procrate            int32
	Races               int32
	Range               int32
	Reclevel            int32
	Recskill            int32
	Reqlevel            int32
	Sellrate            float64
	Shielding           int32
	Size                int32
	Skillmodtype        int32
	Skillmodvalue       int32
	Slots               int32
	Clickeffect         int32
	Spellshield         int32
	Strikethrough       int32
	Stunresist          int32
	Summonedflag        uint8
	Tradeskills         int32
	Favor               int32
	Weight              int32
	Unk012              int32
	Unk013              int32
	Benefitflag         int32
	Unk054              int32
	Unk059              int32
	Booktype            int32
	Recastdelay         int32
	Recasttype          int32
	Guildfavor          int32
	Unk123              int32
	Unk124              int32
	Attuneable          int32
	Nopet               int32
	Updated             sql.NullTime
	Comment             string
	Unk127              int32
	Pointtype           int32
	Potionbelt          int32
	Potionbeltslots     int32
	Stacksize           int32
	Notransfer          int32
	Stackable           int32
	Unk134              string
	Unk137              int32
	Proceffect          int32
	Proctype            int32
	Proclevel2          int32
	Proclevel           int32
	Unk142              int32
	Worneffect          int32
	Worntype            int32
	Wornlevel2          int32
	Wornlevel           int32
	Unk147              int32
	Focustype           int32
	Focuslevel2         int32
	Focuslevel          int32
	Unk152              int32
	Scrolleffect        int32
	Scrolltype          int32
	Scrolllevel2        int32
	Scrolllevel         int32
	Unk157              int32
	Serialized          sql.NullTime
	Verified            sql.NullTime
	Serialization       sql.NullString
	Source              string
	Unk033              int32
	Lorefile            string
	Unk014              int32
	Svcorruption        int32
	Skillmodmax         int32
	Unk060              int32
	Augslot1unk2        int32
	Augslot2unk2        int32
	Augslot3unk2        int32
	Augslot4unk2        int32
	Augslot5unk2        int32
	Augslot6unk2        int32
	Unk120              int32
	Unk121              int32
	Questitemflag       int32
	Unk132              sql.NullString
	Clickunk5           int32
	Clickunk6           string
	Clickunk7           int32
	Procunk1            int32
	Procunk2            int32
	Procunk3            int32
	Procunk4            int32
	Procunk6            string
	Procunk7            int32
	Wornunk1            int32
	Wornunk2            int32
	Wornunk3            int32
	Wornunk4            int32
	Wornunk5            int32
	Wornunk6            string
	Wornunk7            int32
	Focusunk1           int32
	Focusunk2           int32
	Focusunk3           int32
	Focusunk4           int32
	Focusunk5           int32
	Focusunk6           string
	Focusunk7           int32
	Scrollunk1          uint32
	Scrollunk2          int32
	Scrollunk3          int32
	Scrollunk4          int32
	Scrollunk5          int32
	Scrollunk6          string
	Scrollunk7          int32
	Unk193              int32
	Purity              int32
	Evoitem             int32
	Evoid               int32
	Evolvinglevel       int32
	Evomax              int32
	Clickname           string
	Procname            string
	Wornname            string
	Focusname           string
	Scrollname          string
	Dsmitigation        int16
	HeroicStr           int16
	HeroicInt           int16
	HeroicWis           int16
	HeroicAgi           int16
	HeroicDex           int16
	HeroicSta           int16
	HeroicCha           int16
	HeroicPr            int16
	HeroicDr            int16
	HeroicFr            int16
	HeroicCr            int16
	HeroicMr            int16
	HeroicSvcorrup      int16
	Healamt             int16
	Spelldmg            int16
	Clairvoyance        int16
	Backstabdmg         int16
	Created             string
	Elitematerial       int16
	Ldonsellbackrate    int16
	Scriptfileid        int32
	Expendablearrow     int16
	Powersourcecapacity int32
	Bardeffect          int32
	Bardeffecttype      int16
	Bardlevel2          int16
	Bardlevel           int16
	Bardunk1            int16
	Bardunk2            int16
	Bardunk3            int16
	Bardunk4            int16
	Bardunk5            int16
	Bardname            string
	Bardunk7            int16
	Unk214              int16
	Subtype             int32
	Unk220              int32
	Unk221              int32
	Heirloom            int32
	Unk223              int32
	Unk224              int32
	Unk225              int32
	Unk226              int32
	Unk227              int32
	Unk228              int32
	Unk229              int32
	Unk230              int32
	Unk231              int32
	Unk232              int32
	Unk233              int32
	Unk234              int32
	Placeable           int32
	Unk236              int32
	Unk237              int32
	Unk238              int32
	Unk239              int32
	Unk240              int32
	Unk241              int32
	Epicitem            int32
}

type ItemDiscoveredOnlyByIDRow 

type ItemDiscoveredOnlyByIDRow struct {
	ID                  int32
	Minstatus           int16
	Name                string
	Aagi                int32
	Ac                  int32
	Accuracy            int32
	Acha                int32
	Adex                int32
	Aint                int32
	Artifactflag        uint8
	Asta                int32
	Astr                int32
	Attack              int32
	Augrestrict         int32
	Augslot1type        int8
	Augslot1visible     int8
	Augslot2type        int8
	Augslot2visible     int8
	Augslot3type        int8
	Augslot3visible     int8
	Augslot4type        int8
	Augslot4visible     int8
	Augslot5type        int8
	Augslot5visible     int8
	Augslot6type        int8
	Augslot6visible     int8
	Augtype             int32
	Avoidance           int32
	Awis                int32
	Bagsize             int32
	Bagslots            int32
	Bagtype             int32
	Bagwr               int32
	Banedmgamt          int32
	Banedmgraceamt      int32
	Banedmgbody         int32
	Banedmgrace         int32
	Bardtype            int32
	Bardvalue           int32
	Book                int32
	Casttime            int32
	CastTime2           int32
	Charmfile           string
	Charmfileid         string
	Classes             int32
	Color               uint32
	Combateffects       string
	Extradmgskill       int32
	Extradmgamt         int32
	Price               int32
	Cr                  int32
	Damage              int32
	Damageshield        int32
	Deity               int32
	Delay               int32
	Augdistiller        uint32
	Dotshielding        int32
	Dr                  int32
	Clicktype           int32
	Clicklevel2         int32
	Elemdmgtype         int32
	Elemdmgamt          int32
	Endur               int32
	Factionamt1         int32
	Factionamt2         int32
	Factionamt3         int32
	Factionamt4         int32
	Factionmod1         int32
	Factionmod2         int32
	Factionmod3         int32
	Factionmod4         int32
	Filename            string
	Focuseffect         int32
	Fr                  int32
	Fvnodrop            int32
	Haste               int32
	Clicklevel          int32
	Hp                  int32
	Regen               int32
	Icon                int32
	Idfile              string
	Itemclass           int32
	Itemtype            int32
	Ldonprice           int32
	Ldontheme           int32
	Ldonsold            int32
	Light               int32
	Lore                string
	Loregroup           int32
	Magic               int32
	Mana                int32
	Manaregen           int32
	Enduranceregen      int32
	Material            int32
	Herosforgemodel     int32
	Maxcharges          int32
	Mr                  int32
	Nodrop              int32
	Norent              int32
	Pendingloreflag     uint8
	Pr                  int32
	Procrate            int32
	Races               int32
	Range               int32
	Reclevel            int32
	Recskill            int32
	Reqlevel            int32
	Sellrate            float64
	Shielding           int32
	Size                int32
	Skillmodtype        int32
	Skillmodvalue       int32
	Slots               int32
	Clickeffect         int32
	Spellshield         int32
	Strikethrough       int32
	Stunresist          int32
	Summonedflag        uint8
	Tradeskills         int32
	Favor               int32
	Weight              int32
	Unk012              int32
	Unk013              int32
	Benefitflag         int32
	Unk054              int32
	Unk059              int32
	Booktype            int32
	Recastdelay         int32
	Recasttype          int32
	Guildfavor          int32
	Unk123              int32
	Unk124              int32
	Attuneable          int32
	Nopet               int32
	Updated             sql.NullTime
	Comment             string
	Unk127              int32
	Pointtype           int32
	Potionbelt          int32
	Potionbeltslots     int32
	Stacksize           int32
	Notransfer          int32
	Stackable           int32
	Unk134              string
	Unk137              int32
	Proceffect          int32
	Proctype            int32
	Proclevel2          int32
	Proclevel           int32
	Unk142              int32
	Worneffect          int32
	Worntype            int32
	Wornlevel2          int32
	Wornlevel           int32
	Unk147              int32
	Focustype           int32
	Focuslevel2         int32
	Focuslevel          int32
	Unk152              int32
	Scrolleffect        int32
	Scrolltype          int32
	Scrolllevel2        int32
	Scrolllevel         int32
	Unk157              int32
	Serialized          sql.NullTime
	Verified            sql.NullTime
	Serialization       sql.NullString
	Source              string
	Unk033              int32
	Lorefile            string
	Unk014              int32
	Svcorruption        int32
	Skillmodmax         int32
	Unk060              int32
	Augslot1unk2        int32
	Augslot2unk2        int32
	Augslot3unk2        int32
	Augslot4unk2        int32
	Augslot5unk2        int32
	Augslot6unk2        int32
	Unk120              int32
	Unk121              int32
	Questitemflag       int32
	Unk132              sql.NullString
	Clickunk5           int32
	Clickunk6           string
	Clickunk7           int32
	Procunk1            int32
	Procunk2            int32
	Procunk3            int32
	Procunk4            int32
	Procunk6            string
	Procunk7            int32
	Wornunk1            int32
	Wornunk2            int32
	Wornunk3            int32
	Wornunk4            int32
	Wornunk5            int32
	Wornunk6            string
	Wornunk7            int32
	Focusunk1           int32
	Focusunk2           int32
	Focusunk3           int32
	Focusunk4           int32
	Focusunk5           int32
	Focusunk6           string
	Focusunk7           int32
	Scrollunk1          uint32
	Scrollunk2          int32
	Scrollunk3          int32
	Scrollunk4          int32
	Scrollunk5          int32
	Scrollunk6          string
	Scrollunk7          int32
	Unk193              int32
	Purity              int32
	Evoitem             int32
	Evoid               int32
	Evolvinglevel       int32
	Evomax              int32
	Clickname           string
	Procname            string
	Wornname            string
	Focusname           string
	Scrollname          string
	Dsmitigation        int16
	HeroicStr           int16
	HeroicInt           int16
	HeroicWis           int16
	HeroicAgi           int16
	HeroicDex           int16
	HeroicSta           int16
	HeroicCha           int16
	HeroicPr            int16
	HeroicDr            int16
	HeroicFr            int16
	HeroicCr            int16
	HeroicMr            int16
	HeroicSvcorrup      int16
	Healamt             int16
	Spelldmg            int16
	Clairvoyance        int16
	Backstabdmg         int16
	Created             string
	Elitematerial       int16
	Ldonsellbackrate    int16
	Scriptfileid        int32
	Expendablearrow     int16
	Powersourcecapacity int32
	Bardeffect          int32
	Bardeffecttype      int16
	Bardlevel2          int16
	Bardlevel           int16
	Bardunk1            int16
	Bardunk2            int16
	Bardunk3            int16
	Bardunk4            int16
	Bardunk5            int16
	Bardname            string
	Bardunk7            int16
	Unk214              int16
	Subtype             int32
	Unk220              int32
	Unk221              int32
	Heirloom            int32
	Unk223              int32
	Unk224              int32
	Unk225              int32
	Unk226              int32
	Unk227              int32
	Unk228              int32
	Unk229              int32
	Unk230              int32
	Unk231              int32
	Unk232              int32
	Unk233              int32
	Unk234              int32
	Placeable           int32
	Unk236              int32
	Unk237              int32
	Unk238              int32
	Unk239              int32
	Unk240              int32
	Unk241              int32
	Epicitem            int32
	ItemID              uint32
	CharName            string
	DiscoveredDate      uint32
	AccountStatus       int32
}

type ItemRecipeAllRow 

type ItemRecipeAllRow struct {
	RecipeID       int32
	RecipeName     string
	Tradeskill     int16
	Trivial        int16
	ItemID         int32
	IsContainer    bool
	ComponentCount int8
	SuccessCount   int8
}

type ItemsAllRow 

type ItemsAllRow struct {
	ID       int32
	Name     string
	Ac       int32
	Reqlevel int32
	Reclevel int32
	Hp       int32
	Damage   int32
	Delay    int32
	Mana     int32
}

type LootdropEntry 

type LootdropEntry struct {
	LootdropID           uint32
	ItemID               int32
	ItemCharges          uint16
	EquipItem            uint8
	Chance               float64
	DisabledChance       float64
	TrivialMinLevel      uint16
	TrivialMaxLevel      uint16
	Multiplier           uint8
	NpcMinLevel          uint16
	NpcMaxLevel          uint16
	MinExpansion         int8
	MaxExpansion         int8
	ContentFlags         sql.NullString
	ContentFlagsDisabled sql.NullString
}

type LoottableEntry 

type LoottableEntry struct {
	LoottableID uint32
	LootdropID  uint32
	Multiplier  uint8
	Droplimit   uint8
	Mindrop     uint8
	Probability float64
}

type Merchantlist 

type Merchantlist struct {
	Merchantid           int32
	Slot                 uint32
	Item                 int32
	FactionRequired      int16
	LevelRequired        uint8
	MinStatus            uint8
	MaxStatus            uint8
	AltCurrencyCost      uint16
	ClassesRequired      int32
	Probability          int32
	BucketName           string
	BucketValue          string
	BucketComparison     sql.NullInt16
	MinExpansion         int8
	MaxExpansion         int8
	ContentFlags         sql.NullString
	ContentFlagsDisabled sql.NullString
}

type NpcFactionEntry 

type NpcFactionEntry struct {
	NpcFactionID uint32
	FactionID    uint32
	Value        int32
	NpcValue     int8
	Temp         int8
}

type NpcFactionsByFactionIDRow 

type NpcFactionsByFactionIDRow struct {
	Name  string
	ID    int32
	Value int32
}

type NpcLootsByLootTableIDRow 

type NpcLootsByLootTableIDRow struct {
	ID          int32
	Name        string
	Itemtype    int32
	Chance      float64
	Probability float64
	LootdropID  uint32
	Multiplier  uint8
}

type NpcLootsDiscoveredOnlyByLootTableIDRow 

type NpcLootsDiscoveredOnlyByLootTableIDRow struct {
	ID          int32
	Name        string
	Itemtype    int32
	Chance      float64
	Probability float64
	LootdropID  uint32
	Multiplier  uint8
}

type NpcMerchantsByMerchantIDRow 

type NpcMerchantsByMerchantIDRow struct {
	ID        int32
	Name      string
	Price     int32
	Ldonprice int32
	Icon      int32
}

type NpcSearchByNameRow 

type NpcSearchByNameRow struct {
	ID    int32
	Name  string
	Level uint8
}

type NpcSpawnsByNpcIDRow 

type NpcSpawnsByNpcIDRow struct {
	LongName     string
	ShortName    sql.NullString
	X            float64
	Y            float64
	Z            float64
	Spawngroup   string
	Spawngroupid int32
	Respawntime  int32
}

type NpcSpell 

type NpcSpell struct {
	ID                   uint32
	Name                 sql.NullString
	ParentList           uint32
	AttackProc           int16
	ProcChance           int8
	RangeProc            int16
	RprocChance          int16
	DefensiveProc        int16
	DprocChance          int16
	FailRecast           uint32
	EngagedNoSpRecastMin uint32
	EngagedNoSpRecastMax uint32
	EngagedBSelfChance   uint8
	EngagedBOtherChance  uint8
	EngagedDChance       uint8
	PursueNoSpRecastMin  uint32
	PursueNoSpRecastMax  uint32
	PursueDChance        uint8
	IdleNoSpRecastMin    uint32
	IdleNoSpRecastMax    uint32
	IdleBChance          uint8
}

type NpcSpellEntriesByNpcSpellIDParams 

type NpcSpellEntriesByNpcSpellIDParams struct {
	NpcSpellsID int32
	Minlevel    uint8
	Maxlevel    uint8
}

type NpcSpellsByNpcSpellIDRow 

type NpcSpellsByNpcSpellIDRow struct {
	ID            uint32
	Name          sql.NullString
	ProcChance    int8
	AttackProc    int16
	RangeProc     int16
	RprocChance   int16
	DefensiveProc int16
	DprocChance   int16
}

type NpcSpellsEntry 

type NpcSpellsEntry struct {
	ID           uint32
	NpcSpellsID  int32
	Spellid      uint16
	Type         uint32
	Minlevel     uint8
	Maxlevel     uint8
	Manacost     int16
	RecastDelay  int32
	Priority     int16
	ResistAdjust sql.NullInt32
	MinHp        sql.NullInt16
	MaxHp        sql.NullInt16
}

type NpcType 

type NpcType struct {
	ID                   int32
	Name                 string
	Lastname             sql.NullString
	Level                uint8
	Race                 uint16
	Class                uint8
	Bodytype             int32
	Hp                   int64
	Mana                 int64
	Gender               uint8
	Texture              uint8
	Helmtexture          uint8
	Herosforgemodel      int32
	Size                 float64
	HpRegenRate          int64
	HpRegenPerSecond     int64
	ManaRegenRate        int64
	LoottableID          uint32
	MerchantID           uint32
	AltCurrencyID        uint32
	NpcSpellsID          uint32
	NpcSpellsEffectsID   uint32
	NpcFactionID         int32
	AdventureTemplateID  uint32
	TrapTemplate         sql.NullInt32
	Mindmg               uint32
	Maxdmg               uint32
	AttackCount          int16
	Npcspecialattks      string
	SpecialAbilities     sql.NullString
	Aggroradius          uint32
	Assistradius         uint32
	Face                 uint32
	LuclinHairstyle      uint32
	LuclinHaircolor      uint32
	LuclinEyecolor       uint32
	LuclinEyecolor2      uint32
	LuclinBeardcolor     uint32
	LuclinBeard          uint32
	DrakkinHeritage      int32
	DrakkinTattoo        int32
	DrakkinDetails       int32
	ArmortintID          uint32
	ArmortintRed         uint8
	ArmortintGreen       uint8
	ArmortintBlue        uint8
	DMeleeTexture1       uint32
	DMeleeTexture2       uint32
	AmmoIdfile           string
	PrimMeleeType        uint8
	SecMeleeType         uint8
	RangedType           uint8
	Runspeed             float64
	Mr                   int16
	Cr                   int16
	Dr                   int16
	Fr                   int16
	Pr                   int16
	Corrup               int16
	Phr                  uint16
	SeeInvis             int16
	SeeInvisUndead       int16
	Qglobal              uint32
	Ac                   int16
	NpcAggro             int8
	SpawnLimit           int8
	AttackSpeed          float64
	AttackDelay          uint8
	Findable             int8
	Str                  uint32
	Sta                  uint32
	Dex                  uint32
	Agi                  uint32
	Int                  uint32
	Wis                  uint32
	Cha                  uint32
	SeeHide              int8
	SeeImprovedHide      int8
	Trackable            int8
	Isbot                int8
	Exclude              int8
	Atk                  int32
	Accuracy             int32
	Avoidance            uint32
	SlowMitigation       int16
	Version              uint16
	Maxlevel             int8
	Scalerate            int32
	PrivateCorpse        uint8
	UniqueSpawnByName    uint8
	Underwater           uint8
	Isquest              int8
	Emoteid              uint32
	Spellscale           float64
	Healscale            float64
	NoTargetHotkey       bool
	RaidTarget           bool
	Armtexture           int8
	Bracertexture        int8
	Handtexture          int8
	Legtexture           int8
	Feettexture          int8
	Light                int8
	Walkspeed            int8
	Peqid                int32
	Unique               int8
	Fixed                int8
	IgnoreDespawn        int8
	ShowName             int8
	Untargetable         int8
	CharmAc              sql.NullInt16
	CharmMinDmg          sql.NullInt32
	CharmMaxDmg          sql.NullInt32
	CharmAttackDelay     sql.NullInt16
	CharmAccuracyRating  sql.NullInt32
	CharmAvoidanceRating sql.NullInt32
	CharmAtk             sql.NullInt32
	SkipGlobalLoot       sql.NullInt16
	RareSpawn            sql.NullInt16
	StuckBehavior        int8
	Model                int16
	Flymode              int8
	AlwaysAggro          bool
	ExpMod               int32
	HeroicStrikethrough  int32
	FactionAmount        int32
	KeepsSoldItems       bool
}

type NpcsAllRow 

type NpcsAllRow struct {
	ID    int32
	Name  string
	Level uint8
}

type Queries 

type Queries struct {
	// contains filtered or unexported fields
}

func New 

func New(db DBTX) *Queries

func (*Queries) ItemByID 

func (q *Queries) ItemByID(ctx context.Context, id int32) (Item, error)

func (*Queries) ItemDiscoveredOnlyByID 

func (q *Queries) ItemDiscoveredOnlyByID(ctx context.Context, itemID uint32) (ItemDiscoveredOnlyByIDRow, error)

func (*Queries) ItemRecipeAll 

func (q *Queries) ItemRecipeAll(ctx context.Context) ([]ItemRecipeAllRow, error)

func (*Queries) ItemSearchByName 

func (q *Queries) ItemSearchByName(ctx context.Context, name string) ([]Item, error)

func (*Queries) ItemsAll 

func (q *Queries) ItemsAll(ctx context.Context) ([]ItemsAllRow, error)

func (*Queries) NpcByNpcID 

func (q *Queries) NpcByNpcID(ctx context.Context, id int32) (NpcType, error)

func (*Queries) NpcFactionsByFactionID 

func (q *Queries) NpcFactionsByFactionID(ctx context.Context, npcFactionID uint32) ([]NpcFactionsByFactionIDRow, error)

func (*Queries) NpcLootsByLootTableID 

func (q *Queries) NpcLootsByLootTableID(ctx context.Context, loottableID uint32) ([]NpcLootsByLootTableIDRow, error)

func (*Queries) NpcLootsDiscoveredOnlyByLootTableID 

func (q *Queries) NpcLootsDiscoveredOnlyByLootTableID(ctx context.Context, loottableID uint32) ([]NpcLootsDiscoveredOnlyByLootTableIDRow, error)

func (*Queries) NpcMerchantsByMerchantID 

func (q *Queries) NpcMerchantsByMerchantID(ctx context.Context, merchantid int32) ([]NpcMerchantsByMerchantIDRow, error)

func (*Queries) NpcSearchByName 

func (q *Queries) NpcSearchByName(ctx context.Context, name string) ([]NpcSearchByNameRow, error)

func (*Queries) NpcSpawnsByNpcID 

func (q *Queries) NpcSpawnsByNpcID(ctx context.Context, npcid int32) ([]NpcSpawnsByNpcIDRow, error)

func (*Queries) NpcSpellEntriesByNpcSpellID 

func (q *Queries) NpcSpellEntriesByNpcSpellID(ctx context.Context, arg NpcSpellEntriesByNpcSpellIDParams) ([]uint16, error)

func (*Queries) NpcSpellsByNpcSpellID 

func (q *Queries) NpcSpellsByNpcSpellID(ctx context.Context, id uint32) ([]NpcSpellsByNpcSpellIDRow, error)

func (*Queries) NpcsAll 

func (q *Queries) NpcsAll(ctx context.Context) ([]NpcsAllRow, error)

func (*Queries) PlayerByCharacterID 

func (q *Queries) PlayerByCharacterID(ctx context.Context, id uint32) (CharacterDatum, error)

func (*Queries) SpellByID 

func (q *Queries) SpellByID(ctx context.Context, id int32) (SpellsNew, error)

func (*Queries) SpellSearchByName 

func (q *Queries) SpellSearchByName(ctx context.Context, name sql.NullString) ([]SpellsNew, error)

func (*Queries) SpellsAll 

func (q *Queries) SpellsAll(ctx context.Context) ([]SpellsNew, error)

func (*Queries) WithTx 

func (q *Queries) WithTx(tx *sql.Tx) *Queries

func (*Queries) ZoneByShortName 

func (q *Queries) ZoneByShortName(ctx context.Context, arg ZoneByShortNameParams) (Zone, error)

func (*Queries) ZoneByZoneIDNumber 

func (q *Queries) ZoneByZoneIDNumber(ctx context.Context, arg ZoneByZoneIDNumberParams) (Zone, error)

func (*Queries) ZoneSearchByName 

func (q *Queries) ZoneSearchByName(ctx context.Context, arg ZoneSearchByNameParams) ([]Zone, error)

func (*Queries) ZonesAll 

func (q *Queries) ZonesAll(ctx context.Context, expansion int8) ([]Zone, error)

type Spawn2 

type Spawn2 struct {
	ID                   int32
	Spawngroupid         int32
	Zone                 sql.NullString
	Version              int16
	X                    float64
	Y                    float64
	Z                    float64
	Heading              float64
	Respawntime          int32
	Variance             int32
	Pathgrid             int32
	PathWhenZoneIdle     bool
	Condition            uint32
	CondValue            int32
	Animation            uint8
	MinExpansion         int8
	MaxExpansion         int8
	ContentFlags         sql.NullString
	ContentFlagsDisabled sql.NullString
}

type Spawnentry 

type Spawnentry struct {
	Spawngroupid         int32
	Npcid                int32
	Chance               int16
	ConditionValueFilter int32
	MinTime              int16
	MaxTime              int16
	MinExpansion         int8
	MaxExpansion         int8
	ContentFlags         sql.NullString
	ContentFlagsDisabled sql.NullString
}

type Spawngroup 

type Spawngroup struct {
	ID           int32
	Name         string
	SpawnLimit   int8
	Dist         float64
	MaxX         float64
	MinX         float64
	MaxY         float64
	MinY         float64
	Delay        int32
	Mindelay     int32
	Despawn      int8
	DespawnTimer int32
	WpSpawns     bool
}

type SpellsNew 

type SpellsNew struct {
	ID                  int32
	Name                sql.NullString
	Player1             sql.NullString
	TeleportZone        sql.NullString
	YouCast             sql.NullString
	OtherCasts          sql.NullString
	CastOnYou           sql.NullString
	CastOnOther         sql.NullString
	SpellFades          sql.NullString
	Range               int32
	Aoerange            int32
	Pushback            int32
	Pushup              int32
	CastTime            int32
	RecoveryTime        int32
	RecastTime          int32
	Buffdurationformula int32
	Buffduration        int32
	Aeduration          int32
	Mana                int32
	EffectBaseValue1    int32
	EffectBaseValue2    int32
	EffectBaseValue3    int32
	EffectBaseValue4    int32
	EffectBaseValue5    int32
	EffectBaseValue6    int32
	EffectBaseValue7    int32
	EffectBaseValue8    int32
	EffectBaseValue9    int32
	EffectBaseValue10   int32
	EffectBaseValue11   int32
	EffectBaseValue12   int32
	EffectLimitValue1   int32
	EffectLimitValue2   int32
	EffectLimitValue3   int32
	EffectLimitValue4   int32
	EffectLimitValue5   int32
	EffectLimitValue6   int32
	EffectLimitValue7   int32
	EffectLimitValue8   int32
	EffectLimitValue9   int32
	EffectLimitValue10  int32
	EffectLimitValue11  int32
	EffectLimitValue12  int32
	Max1                int32
	Max2                int32
	Max3                int32
	Max4                int32
	Max5                int32
	Max6                int32
	Max7                int32
	Max8                int32
	Max9                int32
	Max10               int32
	Max11               int32
	Max12               int32
	Icon                int32
	Memicon             int32
	Components1         int32
	Components2         int32
	Components3         int32
	Components4         int32
	ComponentCounts1    int32
	ComponentCounts2    int32
	ComponentCounts3    int32
	ComponentCounts4    int32
	Noexpendreagent1    int32
	Noexpendreagent2    int32
	Noexpendreagent3    int32
	Noexpendreagent4    int32
	Formula1            int32
	Formula2            int32
	Formula3            int32
	Formula4            int32
	Formula5            int32
	Formula6            int32
	Formula7            int32
	Formula8            int32
	Formula9            int32
	Formula10           int32
	Formula11           int32
	Formula12           int32
	Lighttype           int32
	Goodeffect          int32
	Activated           int32
	Resisttype          int32
	Effectid1           int32
	Effectid2           int32
	Effectid3           int32
	Effectid4           int32
	Effectid5           int32
	Effectid6           int32
	Effectid7           int32
	Effectid8           int32
	Effectid9           int32
	Effectid10          int32
	Effectid11          int32
	Effectid12          int32
	Targettype          int32
	Basediff            int32
	Skill               int32
	Zonetype            int32
	Environmenttype     int32
	Timeofday           int32
	Classes1            int32
	Classes2            int32
	Classes3            int32
	Classes4            int32
	Classes5            int32
	Classes6            int32
	Classes7            int32
	Classes8            int32
	Classes9            int32
	Classes10           int32
	Classes11           int32
	Classes12           int32
	Classes13           int32
	Classes14           int32
	Classes15           int32
	Classes16           int32
	Castinganim         int32
	Targetanim          int32
	Traveltype          int32
	Spellaffectindex    int32
	DisallowSit         int32
	Deities0            int32
	Deities1            int32
	Deities2            int32
	Deities3            int32
	Deities4            int32
	Deities5            int32
	Deities6            int32
	Deities7            int32
	Deities8            int32
	Deities9            int32
	Deities10           int32
	Deities11           int32
	Deities12           int32
	Deities13           int32
	Deities14           int32
	Deities15           int32
	Deities16           int32
	Field142            int32
	Field143            int32
	NewIcon             int32
	Spellanim           int32
	Uninterruptable     int32
	Resistdiff          int32
	DotStackingExempt   int32
	Deleteable          int32
	Recourselink        int32
	NoPartialResist     int32
	Field152            int32
	Field153            int32
	ShortBuffBox        int32
	Descnum             int32
	Typedescnum         sql.NullInt32
	Effectdescnum       sql.NullInt32
	Effectdescnum2      int32
	NpcNoLos            int32
	Field160            int32
	Reflectable         int32
	Bonushate           int32
	Field163            int32
	Field164            int32
	LdonTrap            int32
	Endurcost           int32
	Endurtimerindex     int32
	Isdiscipline        int32
	Field169            int32
	Field170            int32
	Field171            int32
	Field172            int32
	Hateadded           int32
	Endurupkeep         int32
	Numhitstype         int32
	Numhits             int32
	Pvpresistbase       int32
	Pvpresistcalc       int32
	Pvpresistcap        int32
	SpellCategory       int32
	PvpDuration         int32
	PvpDurationCap      int32
	PcnpcOnlyFlag       sql.NullInt32
	CastNotStanding     sql.NullInt32
	CanMgb              int32
	Nodispell           int32
	NpcCategory         int32
	NpcUsefulness       int32
	Minresist           int32
	Maxresist           int32
	ViralTargets        int32
	ViralTimer          int32
	Nimbuseffect        sql.NullInt32
	Conestartangle      int32
	Conestopangle       int32
	Sneaking            int32
	NotExtendable       int32
	Field198            int32
	Field199            int32
	Suspendable         sql.NullInt32
	ViralRange          int32
	Songcap             sql.NullInt32
	Field203            sql.NullInt32
	Field204            sql.NullInt32
	NoBlock             int32
	Field206            sql.NullInt32
	Spellgroup          sql.NullInt32
	Rank                int32
	Field209            sql.NullInt32
	Field210            sql.NullInt32
	Castrestriction     int32
	Allowrest           sql.NullInt32
	Incombat            int32
	Outofcombat         int32
	Field215            sql.NullInt32
	Field216            sql.NullInt32
	Field217            sql.NullInt32
	Aemaxtargets        int32
	Maxtargets          sql.NullInt32
	Field220            sql.NullInt32
	Field221            sql.NullInt32
	Field222            sql.NullInt32
	Field223            sql.NullInt32
	Persistdeath        sql.NullInt32
	Field225            int32
	Field226            int32
	MinDist             float64
	MinDistMod          float64
	MaxDist             float64
	MaxDistMod          float64
	MinRange            int32
	Field232            int32
	Field233            int32
	Field234            int32
	Field235            int32
	Field236            int32
}

type TradeskillRecipe 

type TradeskillRecipe struct {
	ID                   int32
	Name                 string
	Tradeskill           int16
	Skillneeded          int16
	Trivial              int16
	Nofail               bool
	ReplaceContainer     bool
	Notes                sql.NullString
	MustLearn            int8
	LearnedByItemID      int32
	Quest                bool
	Enabled              bool
	MinExpansion         int8
	MaxExpansion         int8
	ContentFlags         sql.NullString
	ContentFlagsDisabled sql.NullString
}

type TradeskillRecipeEntry 

type TradeskillRecipeEntry struct {
	ID             int32
	RecipeID       int32
	ItemID         int32
	Successcount   int8
	Failcount      int8
	Componentcount int8
	Salvagecount   int8
	Iscontainer    bool
}

type Zone 

type Zone struct {
	ID                      int32
	Zoneidnumber            int32
	Version                 uint8
	ShortName               sql.NullString
	LongName                string
	MinStatus               uint8
	MapFileName             sql.NullString
	Note                    sql.NullString
	MinExpansion            int8
	MaxExpansion            int8
	ContentFlags            sql.NullString
	ContentFlagsDisabled    sql.NullString
	Expansion               int8
	FileName                sql.NullString
	SafeX                   float64
	SafeY                   float64
	SafeZ                   float64
	SafeHeading             float64
	GraveyardID             float64
	MinLevel                uint8
	MaxLevel                uint8
	Timezone                int32
	Maxclients              int32
	Ruleset                 uint32
	Underworld              float64
	Minclip                 float64
	Maxclip                 float64
	FogMinclip              float64
	FogMaxclip              float64
	FogBlue                 uint8
	FogRed                  uint8
	FogGreen                uint8
	Sky                     uint8
	Ztype                   uint8
	ZoneExpMultiplier       string
	Walkspeed               float64
	TimeType                uint8
	FogRed1                 uint8
	FogGreen1               uint8
	FogBlue1                uint8
	FogMinclip1             float64
	FogMaxclip1             float64
	FogRed2                 uint8
	FogGreen2               uint8
	FogBlue2                uint8
	FogMinclip2             float64
	FogMaxclip2             float64
	FogRed3                 uint8
	FogGreen3               uint8
	FogBlue3                uint8
	FogMinclip3             float64
	FogMaxclip3             float64
	FogRed4                 uint8
	FogGreen4               uint8
	FogBlue4                uint8
	FogMinclip4             float64
	FogMaxclip4             float64
	FogDensity              float64
	FlagNeeded              string
	Canbind                 int8
	Cancombat               int8
	Canlevitate             int8
	Castoutdoor             int8
	Hotzone                 uint8
	Insttype                bool
	Shutdowndelay           uint64
	Peqzone                 int8
	BypassExpansionCheck    int8
	Suspendbuffs            bool
	RainChance1             int32
	RainChance2             int32
	RainChance3             int32
	RainChance4             int32
	RainDuration1           int32
	RainDuration2           int32
	RainDuration3           int32
	RainDuration4           int32
	SnowChance1             int32
	SnowChance2             int32
	SnowChance3             int32
	SnowChance4             int32
	SnowDuration1           int32
	SnowDuration2           int32
	SnowDuration3           int32
	SnowDuration4           int32
	Gravity                 float64
	Type                    int32
	Skylock                 int8
	FastRegenHp             int32
	FastRegenMana           int32
	FastRegenEndurance      int32
	NpcMaxAggroDist         int32
	MaxMovementUpdateRange  uint32
	UnderworldTeleportIndex int32
	LavaDamage              sql.NullInt32
	MinLavaDamage           int32
	IdleWhenEmpty           bool
	SecondsBeforeIdle       uint32
}

type ZoneByShortNameParams 

type ZoneByShortNameParams struct {
	ShortName sql.NullString
	Expansion int8
}

type ZoneByZoneIDNumberParams 

type ZoneByZoneIDNumberParams struct {
	Zoneidnumber int32
	Expansion    int8
}

type ZoneSearchByNameParams 

type ZoneSearchByNameParams struct {
	ShortName sql.NullString
	LongName  string
	Expansion int8
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.