Skip to content

Instantly share code, notes, and snippets.

@Naios

Naios/MyCSG output example

Created May 7, 2013 18:39
Show Gist options
  • Save Naios/5535009 to your computer and use it in GitHub Desktop.
Save Naios/5535009 to your computer and use it in GitHub Desktop.
Download ZIP
An output example of Naios/MyCSG
Raw
MyCSG output example
#ifndef MyCSG_Structure_h
#define MyCSG_Structure_h
//////////////////////////
// MyCSG Config
#define USE_CPP11
#define USE_DATATYPES
//////////////////////////
#include <my_global.h>
#include <mysql.h>
#ifdef USE_CPP11
#include <tuple>
#include <thread>
#include <unordered_map>
typedef std::unordered_map SQLStorageType;
#else
#include <map>
typedef std::map SQLStorageType;
#endif
#ifdef USE_DATATYPES
#include <stdint.h>
typedef int8_t int8;
typedef int16_t int16;
typedef int32_t int32;
typedef int64_t int64;
typedef uint8_t uint8;
typedef uint16_t uint16;
typedef uint32_t uint32;
typedef uint64_t uint64;
#endif
template <typename T>
class SQLStorage
{
SQLStorage() {}
~SQLStorage() {}
public:
typedef SQLStorageType<typename T::primary_key, T> Type;
typedef T Content;
inline T const& getEntry(typename T::primary_key const& key) const
{
Type::const_iterator itr = storage.find(key);
return itr != storage.end() ? &*itr: NULL;
}
inline bool hasEntry(typename T::primary_key const& key) const
{
return storage.count(key);
}
private:
Type storage;
};
// access_requirement
struct Structure_access_requirement
{
uint16 mapId;
uint8 difficulty;
uint8 level_min;
uint8 level_max;
uint16 item;
uint16 item2;
uint16 quest_done_A;
uint16 quest_done_H;
uint16 completed_achievement;
std::string quest_failed_text;
std::string comment;
typedef std::pair<uint16 /*mapId*/, uint8 /*difficulty*/> primary_key;
static uint32 const fieldCount = 11;
}
typedef SQLStorage<Structure_access_requirement> Storage_access_requirement;
// achievement_criteria_data
struct Structure_achievement_criteria_data
{
int16 criteria_id;
uint8 type;
uint16 value1;
uint16 value2;
std::string ScriptName;
typedef std::pair<int16 /*criteria_id*/, uint8 /*type*/> primary_key;
static uint32 const fieldCount = 5;
}
typedef SQLStorage<Structure_achievement_criteria_data> Storage_achievement_criteria_data;
// achievement_dbc
struct Structure_achievement_dbc
{
uint32 ID;
int32 requiredFaction;
int32 mapID;
uint32 points;
uint32 flags;
uint32 count;
uint32 refAchievement;
typedef uint32 /*ID*/ primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_achievement_dbc> Storage_achievement_dbc;
// achievement_reward
struct Structure_achievement_reward
{
uint16 entry;
uint16 title_A;
uint16 title_H;
uint16 item;
uint16 sender;
std::string subject;
std::string text;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_achievement_reward> Storage_achievement_reward;
// areatrigger_involvedrelation
struct Structure_areatrigger_involvedrelation
{
uint16 id;
uint16 quest;
typedef uint16 /*id*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_areatrigger_involvedrelation> Storage_areatrigger_involvedrelation;
// areatrigger_scripts
struct Structure_areatrigger_scripts
{
int16 entry;
std::string ScriptName;
typedef int16 /*entry*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_areatrigger_scripts> Storage_areatrigger_scripts;
// areatrigger_tavern
struct Structure_areatrigger_tavern
{
uint16 id;
std::string name;
typedef uint16 /*id*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_areatrigger_tavern> Storage_areatrigger_tavern;
// areatrigger_teleport
struct Structure_areatrigger_teleport
{
uint16 id;
std::string name;
uint16 target_map;
float target_position_x;
float target_position_y;
float target_position_z;
float target_orientation;
typedef uint16 /*id*/ primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_areatrigger_teleport> Storage_areatrigger_teleport;
// autobroadcast
struct Structure_autobroadcast
{
int32 id;
std::string text;
typedef int32 /*id*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_autobroadcast> Storage_autobroadcast;
// battleground_template
struct Structure_battleground_template
{
uint16 id;
uint16 MinPlayersPerTeam;
uint16 MaxPlayersPerTeam;
uint8 MinLvl;
uint8 MaxLvl;
uint16 AllianceStartLoc;
float AllianceStartO;
uint16 HordeStartLoc;
float HordeStartO;
float StartMaxDist;
uint8 Weight;
std::string ScriptName;
std::string Comment;
typedef uint16 /*id*/ primary_key;
static uint32 const fieldCount = 13;
}
typedef SQLStorage<Structure_battleground_template> Storage_battleground_template;
// battlemaster_entry
struct Structure_battlemaster_entry
{
uint16 entry;
uint16 bg_template;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_battlemaster_entry> Storage_battlemaster_entry;
// command
struct Structure_command
{
std::string name;
uint8 security;
std::string help;
typedef std::string /*name*/ primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_command> Storage_command;
// conditions
struct Structure_conditions
{
int16 SourceTypeOrReferenceId;
uint16 SourceGroup;
int16 SourceEntry;
int32 SourceId;
uint16 ElseGroup;
int16 ConditionTypeOrReference;
uint8 ConditionTarget;
uint16 ConditionValue1;
uint16 ConditionValue2;
uint16 ConditionValue3;
uint8 NegativeCondition;
uint16 ErrorType;
uint16 ErrorTextId;
std::string ScriptName;
std::string Comment;
typedef std::tuple<int16 /*SourceTypeOrReferenceId*/, uint16 /*SourceGroup*/, int16 /*SourceEntry*/, int32 /*SourceId*/, uint16 /*ElseGroup*/, int16 /*ConditionTypeOrReference*/, uint8 /*ConditionTarget*/, uint16 /*ConditionValue1*/> primary_key;
static uint32 const fieldCount = 15;
}
typedef SQLStorage<Structure_conditions> Storage_conditions;
// creature
struct Structure_creature
{
uint32 guid;
uint16 id;
uint16 map;
uint8 spawnMask;
uint16 phaseMask;
uint16 modelid;
int8 equipment_id;
float position_x;
float position_y;
float position_z;
float orientation;
uint32 spawntimesecs;
float spawndist;
uint16 currentwaypoint;
uint32 curhealth;
uint32 curmana;
uint8 MovementType;
uint32 npcflag;
uint32 unit_flags;
uint32 dynamicflags;
typedef uint32 /*guid*/ primary_key;
static uint32 const fieldCount = 20;
}
typedef SQLStorage<Structure_creature> Storage_creature;
// creature_addon
struct Structure_creature_addon
{
uint32 guid;
uint32 path_id;
uint16 mount;
uint32 bytes1;
uint32 bytes2;
uint32 emote;
std::string auras;
typedef uint32 /*guid*/ primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_creature_addon> Storage_creature_addon;
// creature_ai_scripts
struct Structure_creature_ai_scripts
{
uint32 id;
uint32 creature_id;
uint8 event_type;
int32 event_inverse_phase_mask;
uint32 event_chance;
uint32 event_flags;
int32 event_param1;
int32 event_param2;
int32 event_param3;
int32 event_param4;
uint8 action1_type;
int32 action1_param1;
int32 action1_param2;
int32 action1_param3;
uint8 action2_type;
int32 action2_param1;
int32 action2_param2;
int32 action2_param3;
uint8 action3_type;
int32 action3_param1;
int32 action3_param2;
int32 action3_param3;
std::string comment;
typedef uint32 /*id*/ primary_key;
static uint32 const fieldCount = 23;
}
typedef SQLStorage<Structure_creature_ai_scripts> Storage_creature_ai_scripts;
// creature_ai_texts
struct Structure_creature_ai_texts
{
int16 entry;
std::string content_default;
std::string content_loc1;
std::string content_loc2;
std::string content_loc3;
std::string content_loc4;
std::string content_loc5;
std::string content_loc6;
std::string content_loc7;
std::string content_loc8;
uint16 sound;
uint8 type;
uint8 language;
uint16 emote;
std::string comment;
typedef int16 /*entry*/ primary_key;
static uint32 const fieldCount = 15;
}
typedef SQLStorage<Structure_creature_ai_texts> Storage_creature_ai_texts;
// creature_classlevelstats
struct Structure_creature_classlevelstats
{
int8 level;
int8 class;
int16 basehp0;
int16 basehp1;
int16 basehp2;
int16 basemana;
int16 basearmor;
typedef std::pair<int8 /*level*/, int8 /*class*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_creature_classlevelstats> Storage_creature_classlevelstats;
// creature_equip_template
struct Structure_creature_equip_template
{
uint16 entry;
uint8 id;
uint16 itemEntry1;
uint16 itemEntry2;
uint16 itemEntry3;
typedef std::pair<uint16 /*entry*/, uint8 /*id*/> primary_key;
static uint32 const fieldCount = 5;
}
typedef SQLStorage<Structure_creature_equip_template> Storage_creature_equip_template;
// creature_formations
struct Structure_creature_formations
{
uint32 leaderGUID;
uint32 memberGUID;
std::string dist;
std::string angle;
uint32 groupAI;
typedef uint32 /*memberGUID*/ primary_key;
static uint32 const fieldCount = 5;
}
typedef SQLStorage<Structure_creature_formations> Storage_creature_formations;
// creature_involvedrelation
struct Structure_creature_involvedrelation
{
uint16 id;
uint16 quest;
typedef std::pair<uint16 /*id*/, uint16 /*quest*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_creature_involvedrelation> Storage_creature_involvedrelation;
// creature_loot_template
struct Structure_creature_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_creature_loot_template> Storage_creature_loot_template;
// creature_model_info
struct Structure_creature_model_info
{
uint16 modelid;
float bounding_radius;
float combat_reach;
uint8 gender;
uint16 modelid_other_gender;
typedef uint16 /*modelid*/ primary_key;
static uint32 const fieldCount = 5;
}
typedef SQLStorage<Structure_creature_model_info> Storage_creature_model_info;
// creature_onkill_reputation
struct Structure_creature_onkill_reputation
{
uint16 creature_id;
int16 RewOnKillRepFaction1;
int16 RewOnKillRepFaction2;
int8 MaxStanding1;
int8 IsTeamAward1;
int16 RewOnKillRepValue1;
int8 MaxStanding2;
int8 IsTeamAward2;
int16 RewOnKillRepValue2;
uint8 TeamDependent;
typedef uint16 /*creature_id*/ primary_key;
static uint32 const fieldCount = 10;
}
typedef SQLStorage<Structure_creature_onkill_reputation> Storage_creature_onkill_reputation;
// creature_questrelation
struct Structure_creature_questrelation
{
uint16 id;
uint16 quest;
typedef std::pair<uint16 /*id*/, uint16 /*quest*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_creature_questrelation> Storage_creature_questrelation;
// creature_summon_groups
struct Structure_creature_summon_groups
{
uint16 summonerId;
uint8 summonerType;
uint8 groupId;
uint16 entry;
float position_x;
float position_y;
float position_z;
float orientation;
uint8 summonType;
uint32 summonTime;
typedef uint16 /*summonerId*/ primary_key;
static uint32 const fieldCount = 10;
}
typedef SQLStorage<Structure_creature_summon_groups> Storage_creature_summon_groups;
// creature_template
struct Structure_creature_template
{
uint16 entry;
uint16 difficulty_entry_1;
uint16 difficulty_entry_2;
uint16 difficulty_entry_3;
uint32 KillCredit1;
uint32 KillCredit2;
uint16 modelid1;
uint16 modelid2;
uint16 modelid3;
uint16 modelid4;
std::string name;
std::string subname;
std::string IconName;
uint16 gossip_menu_id;
uint8 minlevel;
uint8 maxlevel;
int16 exp;
uint16 faction_A;
uint16 faction_H;
uint32 npcflag;
float speed_walk;
float speed_run;
float scale;
uint8 rank;
float mindmg;
float maxdmg;
int8 dmgschool;
uint32 attackpower;
float dmg_multiplier;
uint32 baseattacktime;
uint32 rangeattacktime;
uint8 unit_class;
uint32 unit_flags;
uint32 unit_flags2;
uint32 dynamicflags;
int8 family;
int8 trainer_type;
uint16 trainer_spell;
uint8 trainer_class;
uint8 trainer_race;
float minrangedmg;
float maxrangedmg;
uint16 rangedattackpower;
uint8 type;
uint32 type_flags;
uint16 lootid;
uint16 pickpocketloot;
uint16 skinloot;
int16 resistance1;
int16 resistance2;
int16 resistance3;
int16 resistance4;
int16 resistance5;
int16 resistance6;
uint16 spell1;
uint16 spell2;
uint16 spell3;
uint16 spell4;
uint16 spell5;
uint16 spell6;
uint16 spell7;
uint16 spell8;
uint16 PetSpellDataId;
uint16 VehicleId;
uint16 mingold;
uint16 maxgold;
std::string AIName;
uint8 MovementType;
uint8 InhabitType;
float HoverHeight;
float Health_mod;
float Mana_mod;
float Armor_mod;
uint8 RacialLeader;
uint32 questItem1;
uint32 questItem2;
uint32 questItem3;
uint32 questItem4;
uint32 questItem5;
uint32 questItem6;
uint32 movementId;
uint8 RegenHealth;
uint32 mechanic_immune_mask;
uint32 flags_extra;
std::string ScriptName;
int16 WDBVerified;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 86;
}
typedef SQLStorage<Structure_creature_template> Storage_creature_template;
// creature_template_addon
struct Structure_creature_template_addon
{
uint16 entry;
uint32 path_id;
uint16 mount;
uint32 bytes1;
uint32 bytes2;
uint16 emote;
std::string auras;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_creature_template_addon> Storage_creature_template_addon;
// creature_text
struct Structure_creature_text
{
uint16 entry;
uint8 groupid;
uint8 id;
std::string text;
uint8 type;
uint8 language;
float probability;
uint16 emote;
uint16 duration;
uint16 sound;
std::string comment;
typedef std::tuple<uint16 /*entry*/, uint8 /*groupid*/, uint8 /*id*/> primary_key;
static uint32 const fieldCount = 11;
}
typedef SQLStorage<Structure_creature_text> Storage_creature_text;
// creature_transport
struct Structure_creature_transport
{
int32 guid;
int32 transport_entry;
int32 npc_entry;
float TransOffsetX;
float TransOffsetY;
float TransOffsetZ;
float TransOffsetO;
int32 emote;
typedef std::pair<int32 /*guid*/, int32 /*transport_entry*/> primary_key;
static uint32 const fieldCount = 8;
}
typedef SQLStorage<Structure_creature_transport> Storage_creature_transport;
// db_script_string
struct Structure_db_script_string
{
uint32 entry;
std::string content_default;
std::string content_loc1;
std::string content_loc2;
std::string content_loc3;
std::string content_loc4;
std::string content_loc5;
std::string content_loc6;
std::string content_loc7;
std::string content_loc8;
typedef uint32 /*entry*/ primary_key;
static uint32 const fieldCount = 10;
}
typedef SQLStorage<Structure_db_script_string> Storage_db_script_string;
// disables
struct Structure_disables
{
uint32 sourceType;
uint32 entry;
uint8 flags;
std::string params_0;
std::string params_1;
std::string comment;
typedef std::pair<uint32 /*sourceType*/, uint32 /*entry*/> primary_key;
static uint32 const fieldCount = 6;
}
typedef SQLStorage<Structure_disables> Storage_disables;
// disenchant_loot_template
struct Structure_disenchant_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_disenchant_loot_template> Storage_disenchant_loot_template;
// event_scripts
struct Structure_event_scripts
{
uint16 id;
uint32 delay;
uint16 command;
uint16 datalong;
uint32 datalong2;
int32 dataint;
float x;
float y;
float z;
float o;
typedef uint16 /*id*/ primary_key;
static uint32 const fieldCount = 10;
}
typedef SQLStorage<Structure_event_scripts> Storage_event_scripts;
// exploration_basexp
struct Structure_exploration_basexp
{
uint8 level;
int16 basexp;
typedef uint8 /*level*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_exploration_basexp> Storage_exploration_basexp;
// fishing_loot_template
struct Structure_fishing_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_fishing_loot_template> Storage_fishing_loot_template;
// game_event
struct Structure_game_event
{
uint8 eventEntry;
std::string start_time;
std::string end_time;
uint64 occurence;
uint64 length;
uint16 holiday;
std::string description;
uint8 world_event;
typedef uint8 /*eventEntry*/ primary_key;
static uint32 const fieldCount = 8;
}
typedef SQLStorage<Structure_game_event> Storage_game_event;
// game_event_arena_seasons
struct Structure_game_event_arena_seasons
{
uint8 eventEntry;
uint8 season;
typedef std::pair<uint8 /*eventEntry*/, uint8 /*season*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_game_event_arena_seasons> Storage_game_event_arena_seasons;
// game_event_battleground_holiday
struct Structure_game_event_battleground_holiday
{
uint8 eventEntry;
uint32 bgflag;
typedef uint8 /*eventEntry*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_game_event_battleground_holiday> Storage_game_event_battleground_holiday;
// game_event_condition
struct Structure_game_event_condition
{
uint8 eventEntry;
uint16 condition_id;
float req_num;
uint16 max_world_state_field;
uint16 done_world_state_field;
std::string description;
typedef std::pair<uint8 /*eventEntry*/, uint16 /*condition_id*/> primary_key;
static uint32 const fieldCount = 6;
}
typedef SQLStorage<Structure_game_event_condition> Storage_game_event_condition;
// game_event_creature
struct Structure_game_event_creature
{
int8 eventEntry;
uint32 guid;
typedef std::pair<int8 /*eventEntry*/, uint32 /*guid*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_game_event_creature> Storage_game_event_creature;
// game_event_creature_quest
struct Structure_game_event_creature_quest
{
uint8 eventEntry;
uint16 id;
uint16 quest;
typedef std::pair<uint16 /*id*/, uint16 /*quest*/> primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_game_event_creature_quest> Storage_game_event_creature_quest;
// game_event_gameobject
struct Structure_game_event_gameobject
{
int8 eventEntry;
uint32 guid;
typedef std::pair<int8 /*eventEntry*/, uint32 /*guid*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_game_event_gameobject> Storage_game_event_gameobject;
// game_event_gameobject_quest
struct Structure_game_event_gameobject_quest
{
uint8 eventEntry;
uint16 id;
uint16 quest;
typedef std::tuple<uint8 /*eventEntry*/, uint16 /*id*/, uint16 /*quest*/> primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_game_event_gameobject_quest> Storage_game_event_gameobject_quest;
// game_event_model_equip
struct Structure_game_event_model_equip
{
int8 eventEntry;
uint32 guid;
uint16 modelid;
uint8 equipment_id;
typedef uint32 /*guid*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_game_event_model_equip> Storage_game_event_model_equip;
// game_event_npc_vendor
struct Structure_game_event_npc_vendor
{
int8 eventEntry;
uint16 guid;
int16 slot;
uint16 item;
uint16 maxcount;
uint16 incrtime;
uint16 ExtendedCost;
typedef std::pair<uint16 /*guid*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_game_event_npc_vendor> Storage_game_event_npc_vendor;
// game_event_npcflag
struct Structure_game_event_npcflag
{
uint8 eventEntry;
uint16 guid;
uint32 npcflag;
typedef std::pair<uint8 /*eventEntry*/, uint16 /*guid*/> primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_game_event_npcflag> Storage_game_event_npcflag;
// game_event_pool
struct Structure_game_event_pool
{
int8 eventEntry;
uint16 pool_entry;
typedef uint16 /*pool_entry*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_game_event_pool> Storage_game_event_pool;
// game_event_prerequisite
struct Structure_game_event_prerequisite
{
uint8 eventEntry;
uint16 prerequisite_event;
typedef std::pair<uint8 /*eventEntry*/, uint16 /*prerequisite_event*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_game_event_prerequisite> Storage_game_event_prerequisite;
// game_event_quest_condition
struct Structure_game_event_quest_condition
{
uint8 eventEntry;
uint16 quest;
uint16 condition_id;
float num;
typedef uint16 /*quest*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_game_event_quest_condition> Storage_game_event_quest_condition;
// game_event_seasonal_questrelation
struct Structure_game_event_seasonal_questrelation
{
uint32 questId;
uint16 eventEntry;
typedef std::pair<uint32 /*questId*/, uint16 /*eventEntry*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_game_event_seasonal_questrelation> Storage_game_event_seasonal_questrelation;
// game_graveyard_zone
struct Structure_game_graveyard_zone
{
uint16 id;
uint16 ghost_zone;
uint16 faction;
typedef std::pair<uint16 /*id*/, uint16 /*ghost_zone*/> primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_game_graveyard_zone> Storage_game_graveyard_zone;
// game_tele
struct Structure_game_tele
{
uint16 id;
float position_x;
float position_y;
float position_z;
float orientation;
uint16 map;
std::string name;
typedef uint16 /*id*/ primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_game_tele> Storage_game_tele;
// game_weather
struct Structure_game_weather
{
uint16 zone;
uint8 spring_rain_chance;
uint8 spring_snow_chance;
uint8 spring_storm_chance;
uint8 summer_rain_chance;
uint8 summer_snow_chance;
uint8 summer_storm_chance;
uint8 fall_rain_chance;
uint8 fall_snow_chance;
uint8 fall_storm_chance;
uint8 winter_rain_chance;
uint8 winter_snow_chance;
uint8 winter_storm_chance;
std::string ScriptName;
typedef uint16 /*zone*/ primary_key;
static uint32 const fieldCount = 14;
}
typedef SQLStorage<Structure_game_weather> Storage_game_weather;
// gameobject
struct Structure_gameobject
{
uint32 guid;
uint16 id;
uint16 map;
uint8 spawnMask;
uint16 phaseMask;
float position_x;
float position_y;
float position_z;
float orientation;
float rotation0;
float rotation1;
float rotation2;
float rotation3;
int32 spawntimesecs;
uint8 animprogress;
uint8 state;
typedef uint32 /*guid*/ primary_key;
static uint32 const fieldCount = 16;
}
typedef SQLStorage<Structure_gameobject> Storage_gameobject;
// gameobject_involvedrelation
struct Structure_gameobject_involvedrelation
{
uint16 id;
uint16 quest;
typedef std::pair<uint16 /*id*/, uint16 /*quest*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_gameobject_involvedrelation> Storage_gameobject_involvedrelation;
// gameobject_loot_template
struct Structure_gameobject_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_gameobject_loot_template> Storage_gameobject_loot_template;
// gameobject_questrelation
struct Structure_gameobject_questrelation
{
uint16 id;
uint16 quest;
typedef std::pair<uint16 /*id*/, uint16 /*quest*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_gameobject_questrelation> Storage_gameobject_questrelation;
// gameobject_template
struct Structure_gameobject_template
{
uint16 entry;
uint8 type;
uint16 displayId;
std::string name;
std::string IconName;
std::string castBarCaption;
std::string unk1;
uint16 faction;
uint32 flags;
float size;
uint32 questItem1;
uint32 questItem2;
uint32 questItem3;
uint32 questItem4;
uint32 questItem5;
uint32 questItem6;
uint32 data0;
int32 data1;
uint32 data2;
uint32 data3;
uint32 data4;
uint32 data5;
int32 data6;
uint32 data7;
uint32 data8;
uint32 data9;
uint32 data10;
uint32 data11;
uint32 data12;
uint32 data13;
uint32 data14;
uint32 data15;
uint32 data16;
uint32 data17;
uint32 data18;
uint32 data19;
uint32 data20;
uint32 data21;
uint32 data22;
uint32 data23;
std::string AIName;
std::string ScriptName;
int16 WDBVerified;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 43;
}
typedef SQLStorage<Structure_gameobject_template> Storage_gameobject_template;
// gossip_menu
struct Structure_gossip_menu
{
uint16 entry;
uint16 text_id;
typedef std::pair<uint16 /*entry*/, uint16 /*text_id*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_gossip_menu> Storage_gossip_menu;
// gossip_menu_option
struct Structure_gossip_menu_option
{
uint16 menu_id;
uint16 id;
uint16 option_icon;
std::string option_text;
uint8 option_id;
uint32 npc_option_npcflag;
uint32 action_menu_id;
uint16 action_poi_id;
uint8 box_coded;
uint32 box_money;
std::string box_text;
typedef std::pair<uint16 /*menu_id*/, uint16 /*id*/> primary_key;
static uint32 const fieldCount = 11;
}
typedef SQLStorage<Structure_gossip_menu_option> Storage_gossip_menu_option;
// instance_encounters
struct Structure_instance_encounters
{
uint32 entry;
uint8 creditType;
uint32 creditEntry;
uint16 lastEncounterDungeon;
std::string comment;
typedef uint32 /*entry*/ primary_key;
static uint32 const fieldCount = 5;
}
typedef SQLStorage<Structure_instance_encounters> Storage_instance_encounters;
// instance_template
struct Structure_instance_template
{
uint16 map;
uint16 parent;
std::string script;
uint8 allowMount;
typedef uint16 /*map*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_instance_template> Storage_instance_template;
// ip2nation
struct Structure_ip2nation
{
uint32 ip;
std::string country;
typedef uint32 /*ip*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_ip2nation> Storage_ip2nation;
// ip2nationcountries
struct Structure_ip2nationcountries
{
std::string code;
std::string iso_code_2;
std::string iso_code_3;
std::string iso_country;
std::string country;
float lat;
float lon;
typedef std::string /*code*/ primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_ip2nationcountries> Storage_ip2nationcountries;
// item_enchantment_template
struct Structure_item_enchantment_template
{
uint16 entry;
uint16 ench;
std::string chance;
typedef std::pair<uint16 /*entry*/, uint16 /*ench*/> primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_item_enchantment_template> Storage_item_enchantment_template;
// item_loot_template
struct Structure_item_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_item_loot_template> Storage_item_loot_template;
// item_set_names
struct Structure_item_set_names
{
uint16 entry;
std::string name;
uint8 InventoryType;
int16 WDBVerified;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_item_set_names> Storage_item_set_names;
// item_template
struct Structure_item_template
{
uint16 entry;
uint8 class;
uint8 subclass;
int8 SoundOverrideSubclass;
std::string name;
uint16 displayid;
uint8 Quality;
int64 Flags;
uint32 FlagsExtra;
uint8 BuyCount;
int64 BuyPrice;
uint32 SellPrice;
uint8 InventoryType;
int32 AllowableClass;
int32 AllowableRace;
uint16 ItemLevel;
uint8 RequiredLevel;
uint16 RequiredSkill;
uint16 RequiredSkillRank;
uint16 requiredspell;
uint16 requiredhonorrank;
uint16 RequiredCityRank;
uint16 RequiredReputationFaction;
uint16 RequiredReputationRank;
int32 maxcount;
int32 stackable;
uint8 ContainerSlots;
uint8 StatsCount;
uint8 stat_type1;
int16 stat_value1;
uint8 stat_type2;
int16 stat_value2;
uint8 stat_type3;
int16 stat_value3;
uint8 stat_type4;
int16 stat_value4;
uint8 stat_type5;
int16 stat_value5;
uint8 stat_type6;
int16 stat_value6;
uint8 stat_type7;
int16 stat_value7;
uint8 stat_type8;
int16 stat_value8;
uint8 stat_type9;
int16 stat_value9;
uint8 stat_type10;
int16 stat_value10;
int16 ScalingStatDistribution;
uint32 ScalingStatValue;
float dmg_min1;
float dmg_max1;
uint8 dmg_type1;
float dmg_min2;
float dmg_max2;
uint8 dmg_type2;
uint16 armor;
uint8 holy_res;
uint8 fire_res;
uint8 nature_res;
uint8 frost_res;
uint8 shadow_res;
uint8 arcane_res;
uint16 delay;
uint8 ammo_type;
float RangedModRange;
int16 spellid_1;
uint8 spelltrigger_1;
int16 spellcharges_1;
float spellppmRate_1;
int32 spellcooldown_1;
uint16 spellcategory_1;
int32 spellcategorycooldown_1;
int16 spellid_2;
uint8 spelltrigger_2;
int16 spellcharges_2;
float spellppmRate_2;
int32 spellcooldown_2;
uint16 spellcategory_2;
int32 spellcategorycooldown_2;
int16 spellid_3;
uint8 spelltrigger_3;
int16 spellcharges_3;
float spellppmRate_3;
int32 spellcooldown_3;
uint16 spellcategory_3;
int32 spellcategorycooldown_3;
int16 spellid_4;
uint8 spelltrigger_4;
int16 spellcharges_4;
float spellppmRate_4;
int32 spellcooldown_4;
uint16 spellcategory_4;
int32 spellcategorycooldown_4;
int16 spellid_5;
uint8 spelltrigger_5;
int16 spellcharges_5;
float spellppmRate_5;
int32 spellcooldown_5;
uint16 spellcategory_5;
int32 spellcategorycooldown_5;
uint8 bonding;
std::string description;
uint16 PageText;
uint8 LanguageID;
uint8 PageMaterial;
uint16 startquest;
uint16 lockid;
int8 Material;
uint8 sheath;
int16 RandomProperty;
uint16 RandomSuffix;
uint16 block;
uint16 itemset;
uint16 MaxDurability;
uint16 area;
int16 Map;
int16 BagFamily;
int16 TotemCategory;
int8 socketColor_1;
int16 socketContent_1;
int8 socketColor_2;
int16 socketContent_2;
int8 socketColor_3;
int16 socketContent_3;
int16 socketBonus;
int16 GemProperties;
int16 RequiredDisenchantSkill;
float ArmorDamageModifier;
uint32 duration;
int16 ItemLimitCategory;
uint32 HolidayId;
std::string ScriptName;
uint16 DisenchantID;
uint8 FoodType;
uint32 minMoneyLoot;
uint32 maxMoneyLoot;
uint32 flagsCustom;
int16 WDBVerified;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 139;
}
typedef SQLStorage<Structure_item_template> Storage_item_template;
// lfg_dungeon_rewards
struct Structure_lfg_dungeon_rewards
{
uint32 dungeonId;
uint8 maxLevel;
uint32 firstQuestId;
uint32 otherQuestId;
typedef std::pair<uint32 /*dungeonId*/, uint8 /*maxLevel*/> primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_lfg_dungeon_rewards> Storage_lfg_dungeon_rewards;
// lfg_entrances
struct Structure_lfg_entrances
{
uint32 dungeonId;
std::string name;
float position_x;
float position_y;
float position_z;
float orientation;
typedef uint32 /*dungeonId*/ primary_key;
static uint32 const fieldCount = 6;
}
typedef SQLStorage<Structure_lfg_entrances> Storage_lfg_entrances;
// linked_respawn
struct Structure_linked_respawn
{
uint32 guid;
uint32 linkedGuid;
uint8 linkType;
typedef std::pair<uint32 /*guid*/, uint8 /*linkType*/> primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_linked_respawn> Storage_linked_respawn;
// locales_achievement_reward
struct Structure_locales_achievement_reward
{
uint16 entry;
std::string subject_loc1;
std::string subject_loc2;
std::string subject_loc3;
std::string subject_loc4;
std::string subject_loc5;
std::string subject_loc6;
std::string subject_loc7;
std::string subject_loc8;
std::string text_loc1;
std::string text_loc2;
std::string text_loc3;
std::string text_loc4;
std::string text_loc5;
std::string text_loc6;
std::string text_loc7;
std::string text_loc8;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 17;
}
typedef SQLStorage<Structure_locales_achievement_reward> Storage_locales_achievement_reward;
// locales_creature
struct Structure_locales_creature
{
uint16 entry;
std::string name_loc1;
std::string name_loc2;
std::string name_loc3;
std::string name_loc4;
std::string name_loc5;
std::string name_loc6;
std::string name_loc7;
std::string name_loc8;
std::string subname_loc1;
std::string subname_loc2;
std::string subname_loc3;
std::string subname_loc4;
std::string subname_loc5;
std::string subname_loc6;
std::string subname_loc7;
std::string subname_loc8;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 17;
}
typedef SQLStorage<Structure_locales_creature> Storage_locales_creature;
// locales_creature_text
struct Structure_locales_creature_text
{
uint16 entry;
uint8 groupid;
uint8 id;
std::string text_loc1;
std::string text_loc2;
std::string text_loc3;
std::string text_loc4;
std::string text_loc5;
std::string text_loc6;
std::string text_loc7;
std::string text_loc8;
typedef std::tuple<uint16 /*entry*/, uint8 /*groupid*/, uint8 /*id*/> primary_key;
static uint32 const fieldCount = 11;
}
typedef SQLStorage<Structure_locales_creature_text> Storage_locales_creature_text;
// locales_gameobject
struct Structure_locales_gameobject
{
uint16 entry;
std::string name_loc1;
std::string name_loc2;
std::string name_loc3;
std::string name_loc4;
std::string name_loc5;
std::string name_loc6;
std::string name_loc7;
std::string name_loc8;
std::string castbarcaption_loc1;
std::string castbarcaption_loc2;
std::string castbarcaption_loc3;
std::string castbarcaption_loc4;
std::string castbarcaption_loc5;
std::string castbarcaption_loc6;
std::string castbarcaption_loc7;
std::string castbarcaption_loc8;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 17;
}
typedef SQLStorage<Structure_locales_gameobject> Storage_locales_gameobject;
// locales_gossip_menu_option
struct Structure_locales_gossip_menu_option
{
uint16 menu_id;
uint16 id;
std::string option_text_loc1;
std::string option_text_loc2;
std::string option_text_loc3;
std::string option_text_loc4;
std::string option_text_loc5;
std::string option_text_loc6;
std::string option_text_loc7;
std::string option_text_loc8;
std::string box_text_loc1;
std::string box_text_loc2;
std::string box_text_loc3;
std::string box_text_loc4;
std::string box_text_loc5;
std::string box_text_loc6;
std::string box_text_loc7;
std::string box_text_loc8;
typedef std::pair<uint16 /*menu_id*/, uint16 /*id*/> primary_key;
static uint32 const fieldCount = 18;
}
typedef SQLStorage<Structure_locales_gossip_menu_option> Storage_locales_gossip_menu_option;
// locales_item
struct Structure_locales_item
{
uint16 entry;
std::string name_loc1;
std::string name_loc2;
std::string name_loc3;
std::string name_loc4;
std::string name_loc5;
std::string name_loc6;
std::string name_loc7;
std::string name_loc8;
std::string description_loc1;
std::string description_loc2;
std::string description_loc3;
std::string description_loc4;
std::string description_loc5;
std::string description_loc6;
std::string description_loc7;
std::string description_loc8;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 17;
}
typedef SQLStorage<Structure_locales_item> Storage_locales_item;
// locales_item_set_names
struct Structure_locales_item_set_names
{
uint16 entry;
std::string name_loc1;
std::string name_loc2;
std::string name_loc3;
std::string name_loc4;
std::string name_loc5;
std::string name_loc6;
std::string name_loc7;
std::string name_loc8;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 9;
}
typedef SQLStorage<Structure_locales_item_set_names> Storage_locales_item_set_names;
// locales_npc_text
struct Structure_locales_npc_text
{
uint16 ID;
std::string Text0_0_loc1;
std::string Text0_0_loc2;
std::string Text0_0_loc3;
std::string Text0_0_loc4;
std::string Text0_0_loc5;
std::string Text0_0_loc6;
std::string Text0_0_loc7;
std::string Text0_0_loc8;
std::string Text0_1_loc1;
std::string Text0_1_loc2;
std::string Text0_1_loc3;
std::string Text0_1_loc4;
std::string Text0_1_loc5;
std::string Text0_1_loc6;
std::string Text0_1_loc7;
std::string Text0_1_loc8;
std::string Text1_0_loc1;
std::string Text1_0_loc2;
std::string Text1_0_loc3;
std::string Text1_0_loc4;
std::string Text1_0_loc5;
std::string Text1_0_loc6;
std::string Text1_0_loc7;
std::string Text1_0_loc8;
std::string Text1_1_loc1;
std::string Text1_1_loc2;
std::string Text1_1_loc3;
std::string Text1_1_loc4;
std::string Text1_1_loc5;
std::string Text1_1_loc6;
std::string Text1_1_loc7;
std::string Text1_1_loc8;
std::string Text2_0_loc1;
std::string Text2_0_loc2;
std::string Text2_0_loc3;
std::string Text2_0_loc4;
std::string Text2_0_loc5;
std::string Text2_0_loc6;
std::string Text2_0_loc7;
std::string Text2_0_loc8;
std::string Text2_1_loc1;
std::string Text2_1_loc2;
std::string Text2_1_loc3;
std::string Text2_1_loc4;
std::string Text2_1_loc5;
std::string Text2_1_loc6;
std::string Text2_1_loc7;
std::string Text2_1_loc8;
std::string Text3_0_loc1;
std::string Text3_0_loc2;
std::string Text3_0_loc3;
std::string Text3_0_loc4;
std::string Text3_0_loc5;
std::string Text3_0_loc6;
std::string Text3_0_loc7;
std::string Text3_0_loc8;
std::string Text3_1_loc1;
std::string Text3_1_loc2;
std::string Text3_1_loc3;
std::string Text3_1_loc4;
std::string Text3_1_loc5;
std::string Text3_1_loc6;
std::string Text3_1_loc7;
std::string Text3_1_loc8;
std::string Text4_0_loc1;
std::string Text4_0_loc2;
std::string Text4_0_loc3;
std::string Text4_0_loc4;
std::string Text4_0_loc5;
std::string Text4_0_loc6;
std::string Text4_0_loc7;
std::string Text4_0_loc8;
std::string Text4_1_loc1;
std::string Text4_1_loc2;
std::string Text4_1_loc3;
std::string Text4_1_loc4;
std::string Text4_1_loc5;
std::string Text4_1_loc6;
std::string Text4_1_loc7;
std::string Text4_1_loc8;
std::string Text5_0_loc1;
std::string Text5_0_loc2;
std::string Text5_0_loc3;
std::string Text5_0_loc4;
std::string Text5_0_loc5;
std::string Text5_0_loc6;
std::string Text5_0_loc7;
std::string Text5_0_loc8;
std::string Text5_1_loc1;
std::string Text5_1_loc2;
std::string Text5_1_loc3;
std::string Text5_1_loc4;
std::string Text5_1_loc5;
std::string Text5_1_loc6;
std::string Text5_1_loc7;
std::string Text5_1_loc8;
std::string Text6_0_loc1;
std::string Text6_0_loc2;
std::string Text6_0_loc3;
std::string Text6_0_loc4;
std::string Text6_0_loc5;
std::string Text6_0_loc6;
std::string Text6_0_loc7;
std::string Text6_0_loc8;
std::string Text6_1_loc1;
std::string Text6_1_loc2;
std::string Text6_1_loc3;
std::string Text6_1_loc4;
std::string Text6_1_loc5;
std::string Text6_1_loc6;
std::string Text6_1_loc7;
std::string Text6_1_loc8;
std::string Text7_0_loc1;
std::string Text7_0_loc2;
std::string Text7_0_loc3;
std::string Text7_0_loc4;
std::string Text7_0_loc5;
std::string Text7_0_loc6;
std::string Text7_0_loc7;
std::string Text7_0_loc8;
std::string Text7_1_loc1;
std::string Text7_1_loc2;
std::string Text7_1_loc3;
std::string Text7_1_loc4;
std::string Text7_1_loc5;
std::string Text7_1_loc6;
std::string Text7_1_loc7;
std::string Text7_1_loc8;
typedef uint16 /*ID*/ primary_key;
static uint32 const fieldCount = 129;
}
typedef SQLStorage<Structure_locales_npc_text> Storage_locales_npc_text;
// locales_page_text
struct Structure_locales_page_text
{
uint16 entry;
std::string Text_loc1;
std::string Text_loc2;
std::string Text_loc3;
std::string Text_loc4;
std::string Text_loc5;
std::string Text_loc6;
std::string Text_loc7;
std::string Text_loc8;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 9;
}
typedef SQLStorage<Structure_locales_page_text> Storage_locales_page_text;
// locales_points_of_interest
struct Structure_locales_points_of_interest
{
uint16 entry;
std::string icon_name_loc1;
std::string icon_name_loc2;
std::string icon_name_loc3;
std::string icon_name_loc4;
std::string icon_name_loc5;
std::string icon_name_loc6;
std::string icon_name_loc7;
std::string icon_name_loc8;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 9;
}
typedef SQLStorage<Structure_locales_points_of_interest> Storage_locales_points_of_interest;
// locales_quest
struct Structure_locales_quest
{
uint16 Id;
std::string Title_loc1;
std::string Title_loc2;
std::string Title_loc3;
std::string Title_loc4;
std::string Title_loc5;
std::string Title_loc6;
std::string Title_loc7;
std::string Title_loc8;
std::string Details_loc1;
std::string Details_loc2;
std::string Details_loc3;
std::string Details_loc4;
std::string Details_loc5;
std::string Details_loc6;
std::string Details_loc7;
std::string Details_loc8;
std::string Objectives_loc1;
std::string Objectives_loc2;
std::string Objectives_loc3;
std::string Objectives_loc4;
std::string Objectives_loc5;
std::string Objectives_loc6;
std::string Objectives_loc7;
std::string Objectives_loc8;
std::string OfferRewardText_loc1;
std::string OfferRewardText_loc2;
std::string OfferRewardText_loc3;
std::string OfferRewardText_loc4;
std::string OfferRewardText_loc5;
std::string OfferRewardText_loc6;
std::string OfferRewardText_loc7;
std::string OfferRewardText_loc8;
std::string RequestItemsText_loc1;
std::string RequestItemsText_loc2;
std::string RequestItemsText_loc3;
std::string RequestItemsText_loc4;
std::string RequestItemsText_loc5;
std::string RequestItemsText_loc6;
std::string RequestItemsText_loc7;
std::string RequestItemsText_loc8;
std::string EndText_loc1;
std::string EndText_loc2;
std::string EndText_loc3;
std::string EndText_loc4;
std::string EndText_loc5;
std::string EndText_loc6;
std::string EndText_loc7;
std::string EndText_loc8;
std::string CompletedText_loc1;
std::string CompletedText_loc2;
std::string CompletedText_loc3;
std::string CompletedText_loc4;
std::string CompletedText_loc5;
std::string CompletedText_loc6;
std::string CompletedText_loc7;
std::string CompletedText_loc8;
std::string ObjectiveText1_loc1;
std::string ObjectiveText1_loc2;
std::string ObjectiveText1_loc3;
std::string ObjectiveText1_loc4;
std::string ObjectiveText1_loc5;
std::string ObjectiveText1_loc6;
std::string ObjectiveText1_loc7;
std::string ObjectiveText1_loc8;
std::string ObjectiveText2_loc1;
std::string ObjectiveText2_loc2;
std::string ObjectiveText2_loc3;
std::string ObjectiveText2_loc4;
std::string ObjectiveText2_loc5;
std::string ObjectiveText2_loc6;
std::string ObjectiveText2_loc7;
std::string ObjectiveText2_loc8;
std::string ObjectiveText3_loc1;
std::string ObjectiveText3_loc2;
std::string ObjectiveText3_loc3;
std::string ObjectiveText3_loc4;
std::string ObjectiveText3_loc5;
std::string ObjectiveText3_loc6;
std::string ObjectiveText3_loc7;
std::string ObjectiveText3_loc8;
std::string ObjectiveText4_loc1;
std::string ObjectiveText4_loc2;
std::string ObjectiveText4_loc3;
std::string ObjectiveText4_loc4;
std::string ObjectiveText4_loc5;
std::string ObjectiveText4_loc6;
std::string ObjectiveText4_loc7;
std::string ObjectiveText4_loc8;
typedef uint16 /*Id*/ primary_key;
static uint32 const fieldCount = 89;
}
typedef SQLStorage<Structure_locales_quest> Storage_locales_quest;
// mail_level_reward
struct Structure_mail_level_reward
{
uint8 level;
uint16 raceMask;
uint16 mailTemplateId;
uint16 senderEntry;
typedef std::pair<uint8 /*level*/, uint16 /*raceMask*/> primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_mail_level_reward> Storage_mail_level_reward;
// mail_loot_template
struct Structure_mail_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_mail_loot_template> Storage_mail_loot_template;
// milling_loot_template
struct Structure_milling_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_milling_loot_template> Storage_milling_loot_template;
// npc_spellclick_spells
struct Structure_npc_spellclick_spells
{
uint32 npc_entry;
uint32 spell_id;
uint8 cast_flags;
uint16 user_type;
typedef std::pair<uint32 /*npc_entry*/, uint32 /*spell_id*/> primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_npc_spellclick_spells> Storage_npc_spellclick_spells;
// npc_text
struct Structure_npc_text
{
uint16 ID;
std::string text0_0;
std::string text0_1;
uint8 lang0;
float prob0;
uint16 em0_0;
uint16 em0_1;
uint16 em0_2;
uint16 em0_3;
uint16 em0_4;
uint16 em0_5;
std::string text1_0;
std::string text1_1;
uint8 lang1;
float prob1;
uint16 em1_0;
uint16 em1_1;
uint16 em1_2;
uint16 em1_3;
uint16 em1_4;
uint16 em1_5;
std::string text2_0;
std::string text2_1;
uint8 lang2;
float prob2;
uint16 em2_0;
uint16 em2_1;
uint16 em2_2;
uint16 em2_3;
uint16 em2_4;
uint16 em2_5;
std::string text3_0;
std::string text3_1;
uint8 lang3;
float prob3;
uint16 em3_0;
uint16 em3_1;
uint16 em3_2;
uint16 em3_3;
uint16 em3_4;
uint16 em3_5;
std::string text4_0;
std::string text4_1;
uint8 lang4;
float prob4;
uint16 em4_0;
uint16 em4_1;
uint16 em4_2;
uint16 em4_3;
uint16 em4_4;
uint16 em4_5;
std::string text5_0;
std::string text5_1;
uint8 lang5;
float prob5;
uint16 em5_0;
uint16 em5_1;
uint16 em5_2;
uint16 em5_3;
uint16 em5_4;
uint16 em5_5;
std::string text6_0;
std::string text6_1;
uint8 lang6;
float prob6;
uint16 em6_0;
uint16 em6_1;
uint16 em6_2;
uint16 em6_3;
uint16 em6_4;
uint16 em6_5;
std::string text7_0;
std::string text7_1;
uint8 lang7;
float prob7;
uint16 em7_0;
uint16 em7_1;
uint16 em7_2;
uint16 em7_3;
uint16 em7_4;
uint16 em7_5;
int16 WDBVerified;
typedef uint16 /*ID*/ primary_key;
static uint32 const fieldCount = 82;
}
typedef SQLStorage<Structure_npc_text> Storage_npc_text;
// npc_trainer
struct Structure_npc_trainer
{
uint16 entry;
int16 spell;
uint32 spellcost;
uint16 reqskill;
uint16 reqskillvalue;
uint8 reqlevel;
typedef std::pair<uint16 /*entry*/, int16 /*spell*/> primary_key;
static uint32 const fieldCount = 6;
}
typedef SQLStorage<Structure_npc_trainer> Storage_npc_trainer;
// npc_vendor
struct Structure_npc_vendor
{
uint16 entry;
int16 slot;
int16 item;
uint8 maxcount;
uint32 incrtime;
uint16 ExtendedCost;
typedef std::tuple<uint16 /*entry*/, int16 /*item*/, uint16 /*ExtendedCost*/> primary_key;
static uint32 const fieldCount = 6;
}
typedef SQLStorage<Structure_npc_vendor> Storage_npc_vendor;
// outdoorpvp_template
struct Structure_outdoorpvp_template
{
uint8 TypeId;
std::string ScriptName;
std::string comment;
typedef uint8 /*TypeId*/ primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_outdoorpvp_template> Storage_outdoorpvp_template;
// page_text
struct Structure_page_text
{
uint16 entry;
std::string text;
uint16 next_page;
int16 WDBVerified;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_page_text> Storage_page_text;
// pet_levelstats
struct Structure_pet_levelstats
{
uint16 creature_entry;
uint8 level;
uint16 hp;
uint16 mana;
uint32 armor;
uint16 str;
uint16 agi;
uint16 sta;
uint16 inte;
uint16 spi;
typedef std::pair<uint16 /*creature_entry*/, uint8 /*level*/> primary_key;
static uint32 const fieldCount = 10;
}
typedef SQLStorage<Structure_pet_levelstats> Storage_pet_levelstats;
// pet_name_generation
struct Structure_pet_name_generation
{
uint16 id;
std::string word;
uint16 entry;
uint8 half;
typedef uint16 /*id*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_pet_name_generation> Storage_pet_name_generation;
// pickpocketing_loot_template
struct Structure_pickpocketing_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_pickpocketing_loot_template> Storage_pickpocketing_loot_template;
// player_classlevelstats
struct Structure_player_classlevelstats
{
uint8 class;
uint8 level;
uint16 basehp;
uint16 basemana;
typedef std::pair<uint8 /*class*/, uint8 /*level*/> primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_player_classlevelstats> Storage_player_classlevelstats;
// player_factionchange_achievement
struct Structure_player_factionchange_achievement
{
uint32 alliance_id;
uint32 horde_id;
typedef std::pair<uint32 /*alliance_id*/, uint32 /*horde_id*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_player_factionchange_achievement> Storage_player_factionchange_achievement;
// player_factionchange_items
struct Structure_player_factionchange_items
{
uint32 race_A;
uint32 alliance_id;
std::string commentA;
uint32 race_H;
uint32 horde_id;
std::string commentH;
typedef std::pair<uint32 /*alliance_id*/, uint32 /*horde_id*/> primary_key;
static uint32 const fieldCount = 6;
}
typedef SQLStorage<Structure_player_factionchange_items> Storage_player_factionchange_items;
// player_factionchange_quests
struct Structure_player_factionchange_quests
{
uint32 alliance_id;
uint32 horde_id;
typedef std::pair<uint32 /*alliance_id*/, uint32 /*horde_id*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_player_factionchange_quests> Storage_player_factionchange_quests;
// player_factionchange_reputations
struct Structure_player_factionchange_reputations
{
uint32 alliance_id;
uint32 horde_id;
typedef std::pair<uint32 /*alliance_id*/, uint32 /*horde_id*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_player_factionchange_reputations> Storage_player_factionchange_reputations;
// player_factionchange_spells
struct Structure_player_factionchange_spells
{
uint32 alliance_id;
uint32 horde_id;
typedef std::pair<uint32 /*alliance_id*/, uint32 /*horde_id*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_player_factionchange_spells> Storage_player_factionchange_spells;
// player_factionchange_titles
struct Structure_player_factionchange_titles
{
int32 alliance_id;
int32 horde_id;
typedef std::pair<int32 /*alliance_id*/, int32 /*horde_id*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_player_factionchange_titles> Storage_player_factionchange_titles;
// player_levelstats
struct Structure_player_levelstats
{
uint8 race;
uint8 class;
uint8 level;
uint8 str;
uint8 agi;
uint8 sta;
uint8 inte;
uint8 spi;
typedef std::tuple<uint8 /*race*/, uint8 /*class*/, uint8 /*level*/> primary_key;
static uint32 const fieldCount = 8;
}
typedef SQLStorage<Structure_player_levelstats> Storage_player_levelstats;
// player_xp_for_level
struct Structure_player_xp_for_level
{
uint8 lvl;
uint32 xp_for_next_level;
typedef uint8 /*lvl*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_player_xp_for_level> Storage_player_xp_for_level;
// playercreateinfo
struct Structure_playercreateinfo
{
uint8 race;
uint8 class;
uint16 map;
uint16 zone;
float position_x;
float position_y;
float position_z;
float orientation;
typedef std::pair<uint8 /*race*/, uint8 /*class*/> primary_key;
static uint32 const fieldCount = 8;
}
typedef SQLStorage<Structure_playercreateinfo> Storage_playercreateinfo;
// playercreateinfo_action
struct Structure_playercreateinfo_action
{
uint8 race;
uint8 class;
uint16 button;
uint32 action;
uint16 type;
typedef std::tuple<uint8 /*race*/, uint8 /*class*/, uint16 /*button*/> primary_key;
static uint32 const fieldCount = 5;
}
typedef SQLStorage<Structure_playercreateinfo_action> Storage_playercreateinfo_action;
// playercreateinfo_item
struct Structure_playercreateinfo_item
{
uint8 race;
uint8 class;
uint16 itemid;
int8 amount;
typedef std::tuple<uint8 /*race*/, uint8 /*class*/, uint16 /*itemid*/> primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_playercreateinfo_item> Storage_playercreateinfo_item;
// playercreateinfo_spell
struct Structure_playercreateinfo_spell
{
uint32 racemask;
uint32 classmask;
uint16 Spell;
std::string Note;
typedef std::tuple<uint32 /*racemask*/, uint32 /*classmask*/, uint16 /*Spell*/> primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_playercreateinfo_spell> Storage_playercreateinfo_spell;
// playercreateinfo_spell_custom
struct Structure_playercreateinfo_spell_custom
{
uint32 racemask;
uint32 classmask;
uint16 Spell;
std::string Note;
typedef std::tuple<uint32 /*racemask*/, uint32 /*classmask*/, uint16 /*Spell*/> primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_playercreateinfo_spell_custom> Storage_playercreateinfo_spell_custom;
// points_of_interest
struct Structure_points_of_interest
{
uint16 entry;
float x;
float y;
uint16 icon;
uint16 flags;
uint16 data;
std::string icon_name;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_points_of_interest> Storage_points_of_interest;
// pool_creature
struct Structure_pool_creature
{
uint32 guid;
uint16 pool_entry;
std::string chance;
std::string description;
typedef uint32 /*guid*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_pool_creature> Storage_pool_creature;
// pool_gameobject
struct Structure_pool_gameobject
{
uint32 guid;
uint16 pool_entry;
std::string chance;
std::string description;
typedef uint32 /*guid*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_pool_gameobject> Storage_pool_gameobject;
// pool_pool
struct Structure_pool_pool
{
uint16 pool_id;
uint16 mother_pool;
float chance;
std::string description;
typedef uint16 /*pool_id*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_pool_pool> Storage_pool_pool;
// pool_quest
struct Structure_pool_quest
{
uint32 entry;
uint16 pool_entry;
std::string description;
typedef uint32 /*entry*/ primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_pool_quest> Storage_pool_quest;
// pool_template
struct Structure_pool_template
{
uint16 entry;
uint32 max_limit;
std::string description;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_pool_template> Storage_pool_template;
// prospecting_loot_template
struct Structure_prospecting_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_prospecting_loot_template> Storage_prospecting_loot_template;
// quest_poi
struct Structure_quest_poi
{
uint32 questId;
uint32 id;
int32 objIndex;
uint32 mapid;
uint32 WorldMapAreaId;
uint32 FloorId;
uint32 unk3;
uint32 unk4;
typedef std::pair<uint32 /*questId*/, uint32 /*id*/> primary_key;
static uint32 const fieldCount = 8;
}
typedef SQLStorage<Structure_quest_poi> Storage_quest_poi;
// quest_poi_points
struct Structure_quest_poi_points
{
uint32 questId;
uint32 id;
uint32 idx;
int32 x;
int32 y;
typedef std::tuple<uint32 /*questId*/, uint32 /*id*/, uint32 /*idx*/> primary_key;
static uint32 const fieldCount = 5;
}
typedef SQLStorage<Structure_quest_poi_points> Storage_quest_poi_points;
// quest_template
struct Structure_quest_template
{
uint16 Id;
uint8 Method;
int16 Level;
uint8 MinLevel;
uint8 MaxLevel;
int16 ZoneOrSort;
uint16 Type;
uint8 SuggestedPlayers;
uint32 LimitTime;
uint16 RequiredClasses;
uint16 RequiredRaces;
uint16 RequiredSkillId;
uint16 RequiredSkillPoints;
uint16 RequiredFactionId1;
uint16 RequiredFactionId2;
int16 RequiredFactionValue1;
int16 RequiredFactionValue2;
uint16 RequiredMinRepFaction;
uint16 RequiredMaxRepFaction;
int16 RequiredMinRepValue;
int16 RequiredMaxRepValue;
int16 PrevQuestId;
int16 NextQuestId;
int16 ExclusiveGroup;
uint16 NextQuestIdChain;
uint8 RewardXPId;
int32 RewardOrRequiredMoney;
uint32 RewardMoneyMaxLevel;
uint16 RewardSpell;
int32 RewardSpellCast;
int32 RewardHonor;
float RewardHonorMultiplier;
uint16 RewardMailTemplateId;
uint32 RewardMailDelay;
uint16 SourceItemId;
uint8 SourceItemCount;
uint16 SourceSpellId;
uint32 Flags;
uint8 SpecialFlags;
uint8 RewardTitleId;
uint8 RequiredPlayerKills;
uint8 RewardTalents;
uint16 RewardArenaPoints;
uint16 RewardItemId1;
uint16 RewardItemId2;
uint16 RewardItemId3;
uint16 RewardItemId4;
uint16 RewardItemCount1;
uint16 RewardItemCount2;
uint16 RewardItemCount3;
uint16 RewardItemCount4;
uint16 RewardChoiceItemId1;
uint16 RewardChoiceItemId2;
uint16 RewardChoiceItemId3;
uint16 RewardChoiceItemId4;
uint16 RewardChoiceItemId5;
uint16 RewardChoiceItemId6;
uint16 RewardChoiceItemCount1;
uint16 RewardChoiceItemCount2;
uint16 RewardChoiceItemCount3;
uint16 RewardChoiceItemCount4;
uint16 RewardChoiceItemCount5;
uint16 RewardChoiceItemCount6;
uint16 RewardFactionId1;
uint16 RewardFactionId2;
uint16 RewardFactionId3;
uint16 RewardFactionId4;
uint16 RewardFactionId5;
int16 RewardFactionValueId1;
int16 RewardFactionValueId2;
int16 RewardFactionValueId3;
int16 RewardFactionValueId4;
int16 RewardFactionValueId5;
int16 RewardFactionValueIdOverride1;
int16 RewardFactionValueIdOverride2;
int16 RewardFactionValueIdOverride3;
int16 RewardFactionValueIdOverride4;
int16 RewardFactionValueIdOverride5;
uint16 PointMapId;
float PointX;
float PointY;
uint16 PointOption;
std::string Title;
std::string Objectives;
std::string Details;
std::string EndText;
std::string OfferRewardText;
std::string RequestItemsText;
std::string CompletedText;
int16 RequiredNpcOrGo1;
int16 RequiredNpcOrGo2;
int16 RequiredNpcOrGo3;
int16 RequiredNpcOrGo4;
uint16 RequiredNpcOrGoCount1;
uint16 RequiredNpcOrGoCount2;
uint16 RequiredNpcOrGoCount3;
uint16 RequiredNpcOrGoCount4;
uint16 RequiredSourceItemId1;
uint16 RequiredSourceItemId2;
uint16 RequiredSourceItemId3;
uint16 RequiredSourceItemId4;
uint16 RequiredSourceItemCount1;
uint16 RequiredSourceItemCount2;
uint16 RequiredSourceItemCount3;
uint16 RequiredSourceItemCount4;
uint16 RequiredItemId1;
uint16 RequiredItemId2;
uint16 RequiredItemId3;
uint16 RequiredItemId4;
uint16 RequiredItemId5;
uint16 RequiredItemId6;
uint16 RequiredItemCount1;
uint16 RequiredItemCount2;
uint16 RequiredItemCount3;
uint16 RequiredItemCount4;
uint16 RequiredItemCount5;
uint16 RequiredItemCount6;
uint16 RequiredSpellCast1;
uint16 RequiredSpellCast2;
uint16 RequiredSpellCast3;
uint16 RequiredSpellCast4;
uint8 Unknown0;
std::string ObjectiveText1;
std::string ObjectiveText2;
std::string ObjectiveText3;
std::string ObjectiveText4;
uint16 DetailsEmote1;
uint16 DetailsEmote2;
uint16 DetailsEmote3;
uint16 DetailsEmote4;
uint32 DetailsEmoteDelay1;
uint32 DetailsEmoteDelay2;
uint32 DetailsEmoteDelay3;
uint32 DetailsEmoteDelay4;
uint16 EmoteOnIncomplete;
uint16 EmoteOnComplete;
uint16 OfferRewardEmote1;
uint16 OfferRewardEmote2;
uint16 OfferRewardEmote3;
uint16 OfferRewardEmote4;
uint32 OfferRewardEmoteDelay1;
uint32 OfferRewardEmoteDelay2;
uint32 OfferRewardEmoteDelay3;
uint32 OfferRewardEmoteDelay4;
int16 WDBVerified;
typedef uint16 /*Id*/ primary_key;
static uint32 const fieldCount = 145;
}
typedef SQLStorage<Structure_quest_template> Storage_quest_template;
// reference_loot_template
struct Structure_reference_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_reference_loot_template> Storage_reference_loot_template;
// reputation_reward_rate
struct Structure_reputation_reward_rate
{
uint16 faction;
float quest_rate;
float quest_daily_rate;
float quest_weekly_rate;
float quest_monthly_rate;
float creature_rate;
float spell_rate;
typedef uint16 /*faction*/ primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_reputation_reward_rate> Storage_reputation_reward_rate;
// reputation_spillover_template
struct Structure_reputation_spillover_template
{
uint16 faction;
uint16 faction1;
float rate_1;
uint8 rank_1;
uint16 faction2;
float rate_2;
uint8 rank_2;
uint16 faction3;
float rate_3;
uint8 rank_3;
uint16 faction4;
float rate_4;
uint8 rank_4;
typedef uint16 /*faction*/ primary_key;
static uint32 const fieldCount = 13;
}
typedef SQLStorage<Structure_reputation_spillover_template> Storage_reputation_spillover_template;
// script_waypoint
struct Structure_script_waypoint
{
uint16 entry;
uint16 pointid;
float location_x;
float location_y;
float location_z;
uint32 waittime;
std::string point_comment;
typedef std::pair<uint16 /*entry*/, uint16 /*pointid*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_script_waypoint> Storage_script_waypoint;
// skill_discovery_template
struct Structure_skill_discovery_template
{
uint16 spellId;
uint16 reqSpell;
uint16 reqSkillValue;
float chance;
typedef std::pair<uint16 /*spellId*/, uint16 /*reqSpell*/> primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_skill_discovery_template> Storage_skill_discovery_template;
// skill_extra_item_template
struct Structure_skill_extra_item_template
{
uint16 spellId;
uint16 requiredSpecialization;
float additionalCreateChance;
uint8 additionalMaxNum;
typedef uint16 /*spellId*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_skill_extra_item_template> Storage_skill_extra_item_template;
// skill_fishing_base_level
struct Structure_skill_fishing_base_level
{
uint16 entry;
int16 skill;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_skill_fishing_base_level> Storage_skill_fishing_base_level;
// skinning_loot_template
struct Structure_skinning_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_skinning_loot_template> Storage_skinning_loot_template;
// smart_scripts
struct Structure_smart_scripts
{
int32 entryorguid;
uint8 source_type;
uint16 id;
uint16 link;
uint8 event_type;
uint8 event_phase_mask;
uint8 event_chance;
uint8 event_flags;
uint32 event_param1;
uint32 event_param2;
uint32 event_param3;
uint32 event_param4;
uint8 action_type;
uint32 action_param1;
uint32 action_param2;
uint32 action_param3;
uint32 action_param4;
uint32 action_param5;
uint32 action_param6;
uint8 target_type;
uint32 target_param1;
uint32 target_param2;
uint32 target_param3;
float target_x;
float target_y;
float target_z;
float target_o;
std::string comment;
typedef std::tuple<int32 /*entryorguid*/, uint8 /*source_type*/, uint16 /*id*/, uint16 /*link*/> primary_key;
static uint32 const fieldCount = 28;
}
typedef SQLStorage<Structure_smart_scripts> Storage_smart_scripts;
// spell_area
struct Structure_spell_area
{
uint16 spell;
uint16 area;
uint16 quest_start;
uint16 quest_end;
int16 aura_spell;
uint16 racemask;
uint8 gender;
uint8 autocast;
int32 quest_start_status;
int32 quest_end_status;
typedef std::tuple<uint16 /*spell*/, uint16 /*area*/, uint16 /*quest_start*/, int16 /*aura_spell*/, uint16 /*racemask*/, uint8 /*gender*/> primary_key;
static uint32 const fieldCount = 10;
}
typedef SQLStorage<Structure_spell_area> Storage_spell_area;
// spell_bonus_data
struct Structure_spell_bonus_data
{
uint16 entry;
float direct_bonus;
float dot_bonus;
float ap_bonus;
float ap_dot_bonus;
std::string comments;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 6;
}
typedef SQLStorage<Structure_spell_bonus_data> Storage_spell_bonus_data;
// spell_dbc
struct Structure_spell_dbc
{
uint32 Id;
uint32 Dispel;
uint32 Mechanic;
uint32 Attributes;
uint32 AttributesEx;
uint32 AttributesEx2;
uint32 AttributesEx3;
uint32 AttributesEx4;
uint32 AttributesEx5;
uint32 AttributesEx6;
uint32 AttributesEx7;
uint32 Stances;
uint32 StancesNot;
uint32 Targets;
uint32 CastingTimeIndex;
uint32 AuraInterruptFlags;
uint32 ProcFlags;
uint32 ProcChance;
uint32 ProcCharges;
uint32 MaxLevel;
uint32 BaseLevel;
uint32 SpellLevel;
uint32 DurationIndex;
uint32 RangeIndex;
uint32 StackAmount;
int32 EquippedItemClass;
int32 EquippedItemSubClassMask;
int32 EquippedItemInventoryTypeMask;
uint32 Effect1;
uint32 Effect2;
uint32 Effect3;
int32 EffectDieSides1;
int32 EffectDieSides2;
int32 EffectDieSides3;
float EffectRealPointsPerLevel1;
float EffectRealPointsPerLevel2;
float EffectRealPointsPerLevel3;
int32 EffectBasePoints1;
int32 EffectBasePoints2;
int32 EffectBasePoints3;
uint32 EffectMechanic1;
uint32 EffectMechanic2;
uint32 EffectMechanic3;
uint32 EffectImplicitTargetA1;
uint32 EffectImplicitTargetA2;
uint32 EffectImplicitTargetA3;
uint32 EffectImplicitTargetB1;
uint32 EffectImplicitTargetB2;
uint32 EffectImplicitTargetB3;
uint32 EffectRadiusIndex1;
uint32 EffectRadiusIndex2;
uint32 EffectRadiusIndex3;
uint32 EffectApplyAuraName1;
uint32 EffectApplyAuraName2;
uint32 EffectApplyAuraName3;
int32 EffectAmplitude1;
int32 EffectAmplitude2;
int32 EffectAmplitude3;
float EffectMultipleValue1;
float EffectMultipleValue2;
float EffectMultipleValue3;
int32 EffectMiscValue1;
int32 EffectMiscValue2;
int32 EffectMiscValue3;
int32 EffectMiscValueB1;
int32 EffectMiscValueB2;
int32 EffectMiscValueB3;
uint32 EffectTriggerSpell1;
uint32 EffectTriggerSpell2;
uint32 EffectTriggerSpell3;
uint32 EffectSpellClassMaskA1;
uint32 EffectSpellClassMaskA2;
uint32 EffectSpellClassMaskA3;
uint32 EffectSpellClassMaskB1;
uint32 EffectSpellClassMaskB2;
uint32 EffectSpellClassMaskB3;
uint32 EffectSpellClassMaskC1;
uint32 EffectSpellClassMaskC2;
uint32 EffectSpellClassMaskC3;
uint32 MaxTargetLevel;
uint32 SpellFamilyName;
uint32 SpellFamilyFlags1;
uint32 SpellFamilyFlags2;
uint32 SpellFamilyFlags3;
uint32 MaxAffectedTargets;
uint32 DmgClass;
uint32 PreventionType;
float DmgMultiplier1;
float DmgMultiplier2;
float DmgMultiplier3;
int32 AreaGroupId;
uint32 SchoolMask;
std::string Comment;
typedef uint32 /*Id*/ primary_key;
static uint32 const fieldCount = 93;
}
typedef SQLStorage<Structure_spell_dbc> Storage_spell_dbc;
// spell_enchant_proc_data
struct Structure_spell_enchant_proc_data
{
uint32 entry;
uint32 customChance;
std::string PPMChance;
uint32 procEx;
typedef uint32 /*entry*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_spell_enchant_proc_data> Storage_spell_enchant_proc_data;
// spell_group
struct Structure_spell_group
{
uint32 id;
int32 spell_id;
typedef std::pair<uint32 /*id*/, int32 /*spell_id*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_spell_group> Storage_spell_group;
// spell_group_stack_rules
struct Structure_spell_group_stack_rules
{
uint32 group_id;
int8 stack_rule;
typedef uint32 /*group_id*/ primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_spell_group_stack_rules> Storage_spell_group_stack_rules;
// spell_learn_spell
struct Structure_spell_learn_spell
{
uint16 entry;
uint16 SpellID;
uint8 Active;
typedef std::pair<uint16 /*entry*/, uint16 /*SpellID*/> primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_spell_learn_spell> Storage_spell_learn_spell;
// spell_linked_spell
struct Structure_spell_linked_spell
{
int16 spell_trigger;
int16 spell_effect;
uint8 type;
std::string comment;
typedef std::tuple<int16 /*spell_trigger*/, int16 /*spell_effect*/, uint8 /*type*/> primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_spell_linked_spell> Storage_spell_linked_spell;
// spell_loot_template
struct Structure_spell_loot_template
{
uint16 entry;
uint16 item;
float ChanceOrQuestChance;
uint16 lootmode;
uint8 groupid;
int16 mincountOrRef;
uint8 maxcount;
typedef std::pair<uint16 /*entry*/, uint16 /*item*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_spell_loot_template> Storage_spell_loot_template;
// spell_pet_auras
struct Structure_spell_pet_auras
{
uint16 spell;
uint8 effectId;
uint16 pet;
uint16 aura;
typedef std::tuple<uint16 /*spell*/, uint8 /*effectId*/, uint16 /*pet*/> primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_spell_pet_auras> Storage_spell_pet_auras;
// spell_proc
struct Structure_spell_proc
{
int16 spellId;
int8 schoolMask;
uint16 spellFamilyName;
uint32 spellFamilyMask0;
uint32 spellFamilyMask1;
uint32 spellFamilyMask2;
uint32 typeMask;
uint32 spellTypeMask;
int32 spellPhaseMask;
int32 hitMask;
uint32 attributesMask;
float ratePerMinute;
float chance;
std::string cooldown;
uint32 charges;
typedef int16 /*spellId*/ primary_key;
static uint32 const fieldCount = 15;
}
typedef SQLStorage<Structure_spell_proc> Storage_spell_proc;
// spell_proc_event
struct Structure_spell_proc_event
{
uint16 entry;
int8 SchoolMask;
uint16 SpellFamilyName;
uint32 SpellFamilyMask0;
uint32 SpellFamilyMask1;
uint32 SpellFamilyMask2;
uint32 procFlags;
uint32 procEx;
float ppmRate;
float CustomChance;
uint32 Cooldown;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 11;
}
typedef SQLStorage<Structure_spell_proc_event> Storage_spell_proc_event;
// spell_ranks
struct Structure_spell_ranks
{
uint32 first_spell_id;
uint32 spell_id;
uint8 rank;
typedef std::pair<uint32 /*first_spell_id*/, uint8 /*rank*/> primary_key;
static uint32 const fieldCount = 3;
}
typedef SQLStorage<Structure_spell_ranks> Storage_spell_ranks;
// spell_required
struct Structure_spell_required
{
int16 spell_id;
int16 req_spell;
typedef std::pair<int16 /*spell_id*/, int16 /*req_spell*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_spell_required> Storage_spell_required;
// spell_script_names
struct Structure_spell_script_names
{
int32 spell_id;
std::string ScriptName;
typedef std::pair<int32 /*spell_id*/, std::string /*ScriptName*/> primary_key;
static uint32 const fieldCount = 2;
}
typedef SQLStorage<Structure_spell_script_names> Storage_spell_script_names;
// spell_scripts
struct Structure_spell_scripts
{
uint16 id;
uint8 effIndex;
uint32 delay;
uint16 command;
uint16 datalong;
uint32 datalong2;
int32 dataint;
float x;
float y;
float z;
float o;
typedef uint16 /*id*/ primary_key;
static uint32 const fieldCount = 11;
}
typedef SQLStorage<Structure_spell_scripts> Storage_spell_scripts;
// spell_target_position
struct Structure_spell_target_position
{
uint16 id;
uint16 target_map;
float target_position_x;
float target_position_y;
float target_position_z;
float target_orientation;
typedef uint16 /*id*/ primary_key;
static uint32 const fieldCount = 6;
}
typedef SQLStorage<Structure_spell_target_position> Storage_spell_target_position;
// spell_threat
struct Structure_spell_threat
{
uint16 entry;
int32 flatMod;
float pctMod;
float apPctMod;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_spell_threat> Storage_spell_threat;
// spelldifficulty_dbc
struct Structure_spelldifficulty_dbc
{
uint32 id;
uint32 spellid0;
uint32 spellid1;
uint32 spellid2;
uint32 spellid3;
typedef uint32 /*id*/ primary_key;
static uint32 const fieldCount = 5;
}
typedef SQLStorage<Structure_spelldifficulty_dbc> Storage_spelldifficulty_dbc;
// transports
struct Structure_transports
{
uint32 guid;
uint16 entry;
std::string name;
uint16 period;
std::string ScriptName;
typedef uint32 /*guid*/ primary_key;
static uint32 const fieldCount = 5;
}
typedef SQLStorage<Structure_transports> Storage_transports;
// trinity_string
struct Structure_trinity_string
{
uint16 entry;
std::string content_default;
std::string content_loc1;
std::string content_loc2;
std::string content_loc3;
std::string content_loc4;
std::string content_loc5;
std::string content_loc6;
std::string content_loc7;
std::string content_loc8;
typedef uint16 /*entry*/ primary_key;
static uint32 const fieldCount = 10;
}
typedef SQLStorage<Structure_trinity_string> Storage_trinity_string;
// vehicle_accessory
struct Structure_vehicle_accessory
{
uint16 guid;
uint16 accessory_entry;
int8 seat_id;
uint8 minion;
std::string description;
uint8 summontype;
uint32 summontimer;
typedef std::pair<uint16 /*guid*/, int8 /*seat_id*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_vehicle_accessory> Storage_vehicle_accessory;
// vehicle_template_accessory
struct Structure_vehicle_template_accessory
{
uint16 entry;
uint16 accessory_entry;
int8 seat_id;
uint8 minion;
std::string description;
uint8 summontype;
uint32 summontimer;
typedef std::pair<uint16 /*entry*/, int8 /*seat_id*/> primary_key;
static uint32 const fieldCount = 7;
}
typedef SQLStorage<Structure_vehicle_template_accessory> Storage_vehicle_template_accessory;
// version
struct Structure_version
{
std::string core_version;
std::string core_revision;
std::string db_version;
int32 cache_id;
typedef std::string /*core_version*/ primary_key;
static uint32 const fieldCount = 4;
}
typedef SQLStorage<Structure_version> Storage_version;
// warden_checks
struct Structure_warden_checks
{
uint16 id;
uint8 type;
std::string data;
std::string str;
uint32 address;
uint8 length;
std::string result;
std::string comment;
typedef uint16 /*id*/ primary_key;
static uint32 const fieldCount = 8;
}
typedef SQLStorage<Structure_warden_checks> Storage_warden_checks;
// waypoint_data
struct Structure_waypoint_data
{
uint32 id;
uint16 point;
float position_x;
float position_y;
float position_z;
float orientation;
uint32 delay;
int8 move_flag;
int32 action;
int16 action_chance;
int32 wpguid;
typedef std::pair<uint32 /*id*/, uint16 /*point*/> primary_key;
static uint32 const fieldCount = 11;
}
typedef SQLStorage<Structure_waypoint_data> Storage_waypoint_data;
// waypoint_scripts
struct Structure_waypoint_scripts
{
uint32 id;
uint32 delay;
uint32 command;
uint32 datalong;
uint32 datalong2;
uint32 dataint;
float x;
float y;
float z;
float o;
int32 guid;
typedef int32 /*guid*/ primary_key;
static uint32 const fieldCount = 11;
}
typedef SQLStorage<Structure_waypoint_scripts> Storage_waypoint_scripts;
// waypoints
struct Structure_waypoints
{
uint16 entry;
uint16 pointid;
float position_x;
float position_y;
float position_z;
std::string point_comment;
typedef std::pair<uint16 /*entry*/, uint16 /*pointid*/> primary_key;
static uint32 const fieldCount = 6;
}
typedef SQLStorage<Structure_waypoints> Storage_waypoints;
#endif // MyCSG_Structure_h
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment