# File: `WorldDatabase.h`

## Classes

- `StartingItem`
- `ClaimItems`
- `Bot`
- `WorldDatabase`

## Functions

- `bool ConnectNewDatabase();`
- `void PingNewDB();`
- `string	GetZoneName(int32 id);`
- `string	GetZoneDescription(int32 id);`
- `int32	LoadCharacterSkills(int32 char_id, Player* player);`
- `void	DeleteCharacterSkill(int32 char_id, Skill* skill);`
- `void	DeleteCharacterSpell(int32 character_id, int32 spell_id);`
- `int32	LoadCharacterSpells(int32 char_id, Player* player);`
- `int32	LoadItemBlueStats();`
- `void	SaveQuickBar(int32 char_id, vector<QuickBarItem*>* quickbar_items);`
- `void	SavePlayerSpells(Client* client);`
- `int32	LoadSkills();`
- `void	LoadCommandList();`
- `void	UpdateCharacterMacro(int32 char_id, int8 number, const char* name, int16 icon, vector<string>* updates);`
- `void	SaveWorldTime(WorldTime* time);`
- `bool	SaveSpawnInfo(Spawn* spawn);`
- `int32	GetNextSpawnIDInZone(int32 zone_id);`
- `bool	SaveSpawnEntry(Spawn* spawn, const char* spawn_location_name, int8 percent, float x_offset, float y_offset, float z_offset, bool save_zonespawn = true, bool create_spawnlocation = true);`
- `float	GetSpawnLocationPlacementOffsetX(int32 location_id);`
- `float	GetSpawnLocationPlacementOffsetY(int32 location_id);`
- `float	GetSpawnLocationPlacementOffsetZ(int32 location_id);`
- `int32	GetNextSpawnLocation();`
- `bool	CreateNewSpawnLocation(int32 id, const char* name);`
- `bool	RemoveSpawnFromSpawnLocation(Spawn* spawn);`
- `int32	GetSpawnLocationCount(int32 location, Spawn* spawn = 0);`
- `void	LoadSubCommandList();`
- `void	LoadGlobalVariables();`
- `void	UpdateVitality(int32 timestamp, float amount);`
- `void	SaveVariable(const char* name, const char* value, const char* comment);`
- `void	LoadVisualStates();`
- `void	LoadAppearanceMasterList();`
- `void	Save(Client* client);`
- `void	SaveItems(Client* client);`
- `void	SaveItem(int32 account_id, int32 char_id, Item* item, const char* type);`
- `void	DeleteBuyBack(int32 char_id, int32 item_id, int16 quantity, int32 price);`
- `void	LoadBuyBacks(Client* client);`
- `void	SaveBuyBacks(Client* client);`
- `void	SaveBuyBack(int32 char_id, int32 item_id, int16 quantity, int32 price);`
- `void	DeleteItem(int32 char_id, Item* item, const char* type);`
- `void	SaveCharacterColors(int32 char_id, const char* type, EQ2_Color color);`
- `void	SaveCharacterFloats(int32 char_id, const char* type, float float1, float float2, float float3, float multiplier = 100.0f);`
- `int16	GetAppearanceID(string name);`
- `string	GetAppearanceName(int16 appearance_id);`
- `void	UpdateRandomize(int32 spawn_id, sint32 value);`
- `int32	SaveCharacter(PacketStruct* create, int32 loginID);`
- `int32	LoadNPCAppearanceEquipmentData(ZoneServer* zone);`
- `void	SaveNPCAppearanceEquipment(int32 spawn_id, int8 slot_id, int16 type, int8 red=0, int8 green=0, int8 blue=0, int8 hred=0, int8 hgreen=0, int8 hblue=0);`
- `void	LoadSpecialZones();`
- `void	SaveCharacterSkills(Client* client);`
- `void	SaveCharacterQuests(Client* client);`
- `void	SaveCharacterQuestProgress(Client* client, Quest* quest);`
- `void	DeleteCharacterQuest(int32 quest_id, int32 char_id, bool repeated_quest = false);`
- `void	LoadCharacterQuests(Client* client);`
- `void	LoadPlayerAA(Player *player);`
- `void	LoadCharacterQuestProgress(Client* client);`
- `void	LoadCharacterFriendsIgnoreList(Player* player);`
- `void	LoadZoneInfo(ZoneServer* zone, int32 minLevel=0, int32 maxLevel=0, int32 avgLevel=0, int32 firstLevel=0);`
- `void	LoadZonePlayerLevels(ZoneServer* zone);`
- `void	LoadZoneInfo(ZoneInfo* zone_info);`
- `int32	GetZoneID(const char* name);`
- `void	SaveZoneInfo(int32 zone_id, const char* field, sint32 value);`
- `void	SaveZoneInfo(int32 zone_id, const char* field, float value);`
- `void	SaveZoneInfo(int32 zone_id, const char* field, const char* value);`
- `bool	GetZoneRequirements(const char* zoneName,sint16* minStatus, int16* minLevel, int16* maxLevel, int16* minVersion);`
- `int16	GetMinimumClientVersion(int8 expansion_id);`
- `string	GetExpansionIDByVersion(int16 version);`
- `int32	CheckTableVersions(char* tablename);`
- `bool	RunDatabaseQueries(TableQuery* queries, bool output_result = true, bool data = false);`
- `void	UpdateTableVersion(char* name, int32 version);`
- `void	UpdateDataTableVersion(char* name, int32 version);`
- `void	UpdateStartingFactions(int32 char_id, int8 choice);`
- `string	GetStartingZoneName(int8 choice);`
- `void	UpdateStartingZone(int32 char_id, int8 class_id, int8 race_id, PacketStruct* create);`
- `void	UpdateStartingItems(int32 char_id, int8 class_id, int8 race_id, bool base_class = false);`
- `void	UpdateStartingSkills(int32 char_id, int8 class_id, int8 race_id);`
- `void	UpdateStartingSpells(int32 char_id, int8 class_id, int8 race_id);`
- `void	UpdateStartingSkillbar(int32 char_id, int8 class_id, int8 race_id);`
- `void	UpdateStartingTitles(int32 char_id, int8 class_id, int8 race_id, int8 gender_id);`
- `bool	UpdateSpawnLocationSpawns(Spawn* spawn);`
- `bool	UpdateSpawnWidget(int32 widget_id, char* query);`
- `bool	CheckVersionTable();`
- `void	LoadFactionAlliances();`
- `void	LoadFactionList();`
- `bool	LoadPlayerFactions(Client* client);`
- `void	SavePlayerFactions(Client* client);`
- `bool    VerifyFactionID(int32 char_id, int32 faction_id);`
- `void	LoadSpawnScriptData();`
- `void	LoadZoneScriptData();`
- `int32	LoadSpellScriptData();`
- `bool	UpdateSpawnScriptData(int32 spawn_id, int32 spawn_location_id, int32 spawnentry_id, const char* name);`
- `bool	VerifyZone(const char* name);`
- `int8	GetInstanceTypeByZoneID(int32 zoneID);`
- `void	LoadNPCAppearances();*/`
- `void	ResetDatabase();`
- `void	EnableConstraints();`
- `void	DisableConstraints();`
- `int32	SaveCombinedSpawnLocation(ZoneServer* zone, Spawn* spawn, const char* name);`
- `int32	ProcessSpawnLocations(ZoneServer* zone, const char* sql_query, int8 type);`
- `int32	LoadSpawnLocationGroupAssociations(ZoneServer* zone);`
- `int32	LoadSpawnLocationGroups(ZoneServer* zone);`
- `int32	LoadSpawnGroupChances(ZoneServer* zone);`
- `bool	SpawnGroupAddAssociation(int32 group1, int32 group2);`
- `bool	SpawnGroupRemoveAssociation(int32 group1, int32 group2);`
- `bool	SpawnGroupAddSpawn(Spawn* spawn, int32 group_id);`
- `bool	SpawnGroupRemoveSpawn(Spawn* spawn, int32 group_id);`
- `int32	CreateSpawnGroup(Spawn* spawn, string name);`
- `void	DeleteSpawnGroup(int32 id);`
- `bool	SetGroupSpawnChance(int32 id, float chance);`
- `void	LoadGroundSpawnEntries(ZoneServer* zone);`
- `void	LoadGroundSpawnItems(ZoneServer* zone);`
- `void	LoadSpawns(ZoneServer* zone);`
- `int8	GetAppearanceType(string type);`
- `void	LoadNPCs(ZoneServer* zone);`
- `void	LoadSpiritShards(ZoneServer* zone);`
- `int32	LoadAppearances(ZoneServer* zone, Client* client = 0);`
- `int32	LoadNPCSpells();`
- `int32	LoadNPCSkills(ZoneServer* zone);`
- `int32	LoadNPCEquipment(ZoneServer* zone);`
- `void	LoadObjects(ZoneServer* zone);`
- `void	LoadGroundSpawns(ZoneServer* zone);`
- `void	LoadWidgets(ZoneServer* zone);`
- `void	LoadSigns(ZoneServer* zone);`
- `void	ReloadItemList(int32 item_id = 0);`
- `void	LoadItemList(int32 item_id = 0);`
- `int32	LoadItemStats(int32 item_id = 0);`
- `int32	LoadItemModStrings(int32 item_id = 0);`
- `int32	LoadItemAppearances(int32 item_id = 0);`
- `int32	LoadItemLevelOverride(int32 item_id = 0);`
- `int32	LoadItemEffects(int32 item_id = 0);`
- `int32	LoadBookPages(int32 item_id = 0);`
- `int32	LoadNextUniqueItemID();`
- `int32	LoadSkillItems(int32 item_id = 0);`
- `int32	LoadRangeWeapons(int32 item_id = 0);`
- `int32	LoadThrownWeapons(int32 item_id = 0);`
- `int32	LoadBaubles(int32 item_id = 0);`
- `int32	LoadBooks(int32 item_id = 0);`
- `int32	LoadItemsets(int32 item_id = 0);`
- `int32	LoadHouseItem(int32 item_id = 0);`
- `int32	LoadRecipeBookItems(int32 item_id = 0);`
- `int32	LoadArmor(int32 item_id = 0);`
- `int32	LoadAdornments(int32 item_id = 0);`
- `int32	LoadClassifications();`
- `int32	LoadShields(int32 item_id = 0);`
- `int32	LoadBags(int32 item_id = 0);`
- `int32	LoadFoods(int32 item_id = 0);`
- `int32	LoadWeapons(int32 item_id = 0);`
- `int32	LoadRanged();`
- `int32   LoadHouseContainers(int32 item_id = 0);`
- `void	LoadBrokerItemStats();`
- `void	SaveSignMark(int32 char_id, int32 sign_id, char* char_name, Client* client);`
- `string	GetSignMark(int32 char_id, int32 sign_id, char* char_name); // returns the string containing the character name`
- `void	LoadTransporters(ZoneServer* zone);`
- `void	LoadTransportMaps(ZoneServer* zone);`
- `void	LoadDataFromRow(DatabaseResult *result, Item* item);`
- `void	LoadCharacterItemList(int32 account_id, int32 char_id, Player* player, int16);`
- `bool	loadCharacter(const char* name, int32 account_id, Client* client);`
- `std::string	loadCharacterFromLogin(ZoneChangeDetails* details, int32 char_id, int32 account_id);`
- `bool	LoadCharacterStats(int32 id, int32 account_id, Client* client);`
- `void	LoadCharacterQuestRewards(Client* client);`
- `void	LoadCharacterQuestTemporaryRewards(Client* client, int32 quest_id);`
- `bool	InsertCharacterStats(int32 character_id, int8 class_id, int8 race_id);`
- `bool	UpdateCharacterTimeStamp(int32 account_id, int32 character_id, int32 timestamp);`
- `bool	insertCharacterProperty(Client* client, char* propName, char* propValue);`
- `bool	loadCharacterProperties(Client* client);`
- `string	GetPlayerName(char* name);`
- `int32	GetCharacterTimeStamp(int32 character_id, int32 account_id,bool* char_exists);`
- `int32	GetCharacterTimeStamp(int32 character_id);`
- `sint32	GetLatestDataTableVersion(char* name);`
- `sint16	GetLowestCharacterAdminStatus(int32 account_id);`
- `sint16	GetHighestCharacterAdminStatus(int32 account_id);`
- `sint16	GetCharacterAdminStatus(char* character_name);`
- `sint16	GetCharacterAdminStatus(int32 account_id , int32 char_id);`
- `bool	UpdateAdminStatus(char* character_name, sint16 flag);`
- `void	LoadMerchantInformation();`
- `void	LoadMerchantInventory();`
- `string	GetMerchantDescription(int32 merchant_id);`
- `void	LoadPlayerStatistics(Player* player, int32 char_id);`
- `void	WritePlayerStatistic(Player* player, Statistic* stat);`
- `void	LoadServerStatistics();`
- `void	WriteServerStatistic(Statistic* stat);`
- `void	WriteServerStatistic(int32 stat_id, sint32 stat_value);`
- `void	WriteServerStatisticsNeededQueries();`
- `void	SavePlayerMail(Mail* mail);`
- `void	SavePlayerMail(Client* client);`
- `void	LoadPlayerMail(Client* client, bool new_only = false);`
- `void	DeletePlayerMail(Mail* mail);`
- `void GetPetNames(ZoneServer* zone);`
- `int8	GetCharacterLevel(int32 character_id);`
- `int16	GetCharacterModelType(int32 character_id);`
- `int8	GetCharacterClass(int32 character_id);`
- `int8	GetCharacterGender(int32 character_id);`
- `int32	GetCharacterID(const char* name);`
- `int32	GetCharacterCurrentZoneID(int32 character_id);`
- `int32	GetCharacterAccountID(int32 character_id);`
- `void	LoadEntityCommands(ZoneServer* zone);`
- `void	LoadSpells();`
- `void	LoadSpellEffects();`
- `void	LoadSpellLuaData();`
- `void	LoadTraits();`
- `int32	LoadPlayerSkillbar(Client* client);`
- `string	GetColumnNames(char* name);`
- `string	GetZoneName(char* zone_description);`
- `bool	GetItemResultsToClient (Client* client, const char* varSearch, int maxResults=20);`
- `void	LoadRevivePoints(vector<RevivePoint*>* revive_points, int32 zone_id);`
- `void	SaveBugReport(const char* category, const char* subcategory, const char* causes_crash, const char* reproducible, const char* summary, const char* description, const char* version, const char* player, int32 account_id, const char* spawn_name, int32 spawn_id, int32 zone_id);`
- `void	FixBugReport();`
- `int32	LoadQuests();`
- `void	LoadQuestDetails(Quest* quest);`
- `bool	DeleteCharacter(int32 account_id, int32 character_id);`
- `int32	GetMaxHotBarID();`
- `int8	CheckNameFilter(const char* name, int8 min_length = 4, int8 max_length = 15);`
- `void	LoadFogInit(string zone, PacketStruct* packet);`
- `void ToggleCharacterOnline();`
- `void ToggleCharacterOnline(Client* client, int8 toggle);`
- `int32				CreateNewInstance(int32 zone_id, int32 playersMinLevel=0, int32 playersMaxLevel=0, int32 playersavgLevel=0, int32 playersfirstLevel=0);`
- `int32				AddCharacterInstance(int32 char_id, int32 instance_id, string zone_name, int8 instance_type, int32 last_success, int32 last_failure, int32 success_lockout, int32 failure_lockout);`
- `bool				UpdateCharacterInstanceTimers(int32 char_id, int32 instance_id, int32 lockout_time=0, int32 reset_time=0, int32 reenter_time=0 );`
- `bool				UpdateCharacterInstance(int32 char_id, string zone_name, int32 instance_id, int8 type = 0, int32 timestamp = 0);`
- `bool				VerifyInstanceID(int32 char_id, int32 instance_id);`
- `bool				CheckVectorForValue(vector<int32>* vector, int32 value);`
- `int32				CheckSpawnRemoveInfo(map<int32,int32>* inmap, int32 spawn_location_entry_id);`
- `bool				UpdateInstancedSpawnRemoved(int32 spawn_location_entry_id, int32 spawn_type, int32 respawn_time, int32 instance_id );`
- `int32				CreateInstanceSpawnRemoved(int32 spawn_location_entry_id, int32 spawn_type, int32 respawn_time, int32 instance_id );`
- `bool				DeleteInstance(int32 instance_id);`
- `bool				DeleteInstanceSpawnRemoved(int32 instance_id, int32 spawn_location_entry_id);`
- `bool				DeleteCharacterFromInstance(int32 char_id, int32 instance_id);`
- `bool				LoadCharacterInstances(Client* client);`
- `bool				DeletePersistedRespawn(int32 zone_id, int32 spawn_location_entry_id);`
- `int32				CreatePersistedRespawn(int32 spawn_location_entry_id, int32 spawn_type, int32 respawn_time, int32 zone_id);`
- `void				UpdateLoginEquipment();`
- `void				UpdateLoginZones();`
- `void				LoadLocationGrids(ZoneServer* zone);`
- `bool				LoadLocationGridLocations(LocationGrid* grid);`
- `int32				CreateLocation(int32 zone_id, int32 grid_id, const char* name, bool include_y);`
- `bool				AddLocationPoint(int32 location_id, float x, float y, float z);`
- `bool				DeleteLocation(int32 location_id);`
- `bool				DeleteLocationPoint(int32 location_point_id);`
- `void				ListLocations(Client* client);`
- `void				ListLocationPoints(Client* client, int32 location_id);`
- `bool				LocationExists(int32 location_id);`
- `bool				GetTableVersions(vector<TableVersion *> *table_versions);`
- `bool				QueriesFromFile(const char *file);`
- `void				LoadAchievements();`
- `int32				LoadAchievementRequirements(Achievement *achievement);`
- `int32				LoadAchievementRewards(Achievement *achievement);`
- `void				LoadPlayerAchievements(Player *player);`
- `int32				LoadPlayerAchievementsUpdates(Player *player);`
- `int32				LoadPlayerAchievementsUpdateItems(AchievementUpdate *update, int32 player_id);`
- `void				LoadAltAdvancements();`
- `void				LoadTreeNodes();`
- `void				LoadCollections();`
- `int32				LoadCollectionItems(Collection *collection);`
- `int32				LoadCollectionRewards(Collection *collection);`
- `void				LoadPlayerCollections(Player *player);`
- `void				LoadPlayerCollectionItems(Player *player, Collection *collection);`
- `void				SavePlayerCollections(Client *client);`
- `void				SavePlayerCollection(Client *client, Collection *collection);`
- `void				SavePlayerCollectionItems(Client *client, Collection *collection);`
- `void				SavePlayerCollectionItem(Client *client, Collection *collection, int32 item_id);`
- `int32				SaveSpawnTemplate(int32 placement_id, const char* template_name);`
- `bool				RemoveSpawnTemplate(int32 template_id);`
- `int32				CreateSpawnFromTemplateByID(Client* client, int32 template_id);`
- `int32				CreateSpawnFromTemplateByName(Client* client, const char* template_name);`
- `bool				SaveZoneSafeCoords(int32 zone_id, float x, float y, float z, float heading);`
- `bool				SaveSignZoneToCoords(int32 spawn_id, float x, float y, float z, float heading);`
- `void				LoadGuilds();`
- `void				LoadGuild(int32 guild_id);`
- `int32				LoadGuildMembers(Guild* guild);`
- `void				LoadGuildEvents(Guild* guild);`
- `void				LoadGuildRanks(Guild* guild);`
- `void				LoadGuildEventFilters(Guild* guild);`
- `void				LoadGuildPointsHistory(Guild* guild, GuildMember* guild_member);`
- `void				LoadGuildRecruiting(Guild* guild);`
- `void				SaveGuild(Guild* guild, bool new_guild = false);`
- `void				SaveGuildMembers(Guild* guild);`
- `void				SaveGuildEvents(Guild* guild);`
- `void				SaveGuildRanks(Guild* guild);`
- `void				SaveGuildEventFilters(Guild* guild);`
- `void				SaveGuildPointsHistory(Guild* guild);`
- `void				SaveGuildRecruiting(Guild* guild);`
- `void				DeleteGuild(Guild* guild);`
- `void				DeleteGuildMember(Guild* guild, int32 character_id);`
- `void				DeleteGuildEvent(Guild* guild, int64 event_id);`
- `void				DeleteGuildPointHistory(Guild* guild, int32 character_id, PointHistory* point_history);`
- `void				ArchiveGuildEvent(Guild* guild, GuildEvent* guild_event);`
- `void				SaveHiddenGuildEvent(Guild* guild, GuildEvent* guild_event);`
- `void				LoadGuildDefaultRanks(Guild* guild);`
- `void				LoadGuildDefaultEventFilters(Guild* guild);`
- `bool				AddNewPlayerToServerGuild(int32 account_id, int32 char_id);`
- `int32				GetGuildIDByCharacterID(int32 char_id);`
- `void LoadChannels();`
- `void	LoadRecipes();`
- `void	LoadRecipeBooks();`
- `void	LoadPlayerRecipes(Player *player);`
- `int32	LoadPlayerRecipeBooks(int32 char_id, Player *player);`
- `void	SavePlayerRecipeBook(Player* player, int32 recipebook_id);`
- `void	LoadRecipeComponents();`
- `void	UpdatePlayerRecipe(Player* player, int32 recipe_id, int8 highest_rank);`
- `void	SavePlayerRecipe(Player* player, int32 recipe_id);`
- `void	LoadTradeskillEvents();`
- `void LoadGlobalRuleSet();`
- `void LoadRuleSets(bool reload=false);`
- `void LoadRuleSetDetails(RuleSet *rule_set);`
- `sint32				AddMasterTitle(const char* titleName, int8 isPrefix = 0);`
- `void				LoadTitles();`
- `sint32				LoadCharacterTitles(int32 char_id, Player *player);`
- `sint32				GetCharPrefixIndex(int32 char_id, Player *player);`
- `sint32				GetCharSuffixIndex(int32 char_id, Player *player);`
- `void				SaveCharPrefixIndex(sint32 index, int32 char_id);`
- `void				SaveCharSuffixIndex(sint32 index, int32 char_id);`
- `sint32				AddCharacterTitle(sint32 index, int32 char_id, Spawn* player);`
- `void				LoadLanguages();`
- `int32				LoadCharacterLanguages(int32 char_id, Player *player);`
- `int16				GetCharacterCurrentLang(int32 char_id, Player *player);`
- `void				SaveCharacterCurrentLang(int32 id, int32 char_id, Client *client);`
- `void 				UpdateStartingLanguage(int32 char_id, uint8 race_id, int32 starting_city=0);`
- `void	SaveCharacterLang(int32 char_id, int32 lang_id);`
- `void				SaveCharacterHistory(Player* player, int8 type, int8 subtype, int32 value, int32 value2, char* location, int32 event_date);`
- `void				LoadHouseZones();`
- `int64				AddPlayerHouse(int32 char_id, int32 house_id, int32 instance_id, int32 upkeep_due);`
- `void				SetHouseUpkeepDue(int32 char_id, int32 house_id, int32 instance_id, int32 upkeep_due);`
- `void				RemovePlayerHouse(int32 char_id, int32 house_id);`
- `void				UpdateHouseEscrow(int32 house_id, int32 instance_id, int64 amount_coins, int32 amount_status);`
- `void				LoadPlayerHouses();`
- `void				LoadDeposits(PlayerHouse* house);`
- `void				LoadHistory(PlayerHouse* house);`
- `void				AddHistory(PlayerHouse* house, char* name, char* reason, int32 timestamp, int64 amount = 0, int32 status = 0, int8 pos_flag = 0);`
- `bool				CheckBannedIPs(const char* loginIP);`
- `void				LoadHOStarters();`
- `void				LoadHOWheel();`
- `void				LoadClaimItems(int32 char_id);`
- `int16				CountCharClaimItems(int32 char_id);`
- `vector<ClaimItems>  LoadCharacterClaimItems(int32 char_id);`
- `void				ClaimItem(int32 char_id, int32 item_id, Client* client);`
- `int32				GetAccountAge(int32 account_id);`
- `void				LoadRaceTypes();`
- `void				LoadLoot(ZoneServer* zone);`
- `void				LoadGlobalLoot(ZoneServer* zone);`
- `bool				LoadSpawnLoot(ZoneServer* zone, Spawn* spawn);`
- `void				AddLootTableToSpawn(Spawn* spawn, int32 loottable_id);`
- `bool				RemoveSpawnLootTable(Spawn* spawn, int32 loottable_id);`
- `void				LoadCharacterHistory(int32 char_id, Player *player);`
- `void				LoadSpellErrors();`
- `bool				LoadSign(ZoneServer* zone, int32 spawn_id);`
- `bool				LoadWidget(ZoneServer* zone, int32 spawn_id);`
- `bool				LoadObject(ZoneServer* zone, int32 spawn_id);`
- `bool				LoadGroundSpawn(ZoneServer* zone, int32 spawn_id);`
- `void				LoadGroundSpawnEntry(ZoneServer* zone, int32 entry_id);`
- `void				LoadGroundSpawnItems(ZoneServer* zone, int32 entry_id);`
- `bool				LoadNPC(ZoneServer* zone, int32 spawn_id);`
- `void				LoadAppearance(ZoneServer* zone, int32 spawn_id);`
- `void				LoadNPCAppearanceEquipmentData(ZoneServer* zone, int32 spawn_id);`
- `void				SaveCharacterPicture(int32 characterID, int8 type, uchar* picture, int32 picture_size);`
- `void				SaveCharRepeatableQuest(Client* client, int32 quest_id, int16 quest_complete_count);`
- `void				LoadZoneFlightPaths(ZoneServer* zone);`
- `void				LoadZoneFlightPathLocations(ZoneServer* zone);`
- `void				SaveCharacterLUAHistory(Player* player, int32 event_id, int32 value, int32 value2);`
- `void				LoadCharacterLUAHistory(int32 char_id, Player* player);`
- `int32				CreateNewBot(int32 char_id, string name, int8 race, int8 advClass, int8 gender, int16 model_id, int32& index);`
- `void				SaveBotAppearance(Bot* bot);`
- `void				SaveBotColors(int32 bot_id, const char* type, EQ2_Color color);`
- `void				SaveBotFloats(int32 bot_id, const char* type, float float1, float float2, float float3);`
- `bool				LoadBot(int32 char_id, int32 bot_index, Bot* bot);`
- `void				LoadBotAppearance(Bot* bot);`
- `void				SaveBotItem(int32 bot_id, int32 item_id, int8 slot);`
- `void				LoadBotEquipment(Bot* bot);`
- `string				GetBotList(int32 char_id);`
- `void				DeleteBot(int32 char_id, int32 bot_index);`
- `void				SetBotStartingItems(Bot* bot, int8 class_id, int8 race_id);`
- `void                LoadTransmuting();`
- `void				FindSpell(Client* client, char* findString);`
- `void				LoadChestTraps();`
- `bool				CheckExpansionFlags(ZoneServer* zone, int32 spawnXpackFlag);`
- `bool				CheckHolidayFlags(ZoneServer* zone, int32 spawnHolidayFlag);`
- `void				GetHouseSpawnInstanceData(ZoneServer* zone, Spawn* spawn);`
- `int32				FindHouseInstanceSpawn(Spawn* spawn);`
- `void				LoadStartingSkills(World* world);`
- `void				LoadStartingSpells(World* world);`
- `void				LoadVoiceOvers(World* world);`
- `bool				DeleteSpiritShard(int32 id);`
- `void				LoadCharacterSpellEffects(int32 char_id, Client *client, int8 db_spell_type);`
- `int32				GetMysqlExpCurve(int level);`

## Notable Comments

- /*
- */
- /*void	loadNPCAppearance(int32 appearance_id);
- //void	LoadMerchantMultipliers();
- // Zone Instance DB Functions
- //int32				AddCharacterInstance(int32 char_id, int32 instance_id, int32 grant_reenter_time_left=0, int32 grant_reset_time_left=0, int32 lockout_time=0);
- //
- /* Achievements */
- /* Alternate Advancement */
- /* Collections */