Loading...   

[Show Table of Contents]


zone database schema
Field Name Field Description Field Type Field Default Value
id Represents an auto_increment field (passive field, not used) int(11) auto_increment
zoneidnumber Represents the hard coded id number that the client uses to align with the short_name (http://www.kheprigames.com/ZoneIDs.txt) int(4) 0
long_name Represents the full name of the zone, eg. 'South Qeynos' text NULL
short_name Represents the short name of the zone, eg. 'qeynos' varchar(32) NULL
map_file_name Represents the map file name (usually the short_name) to use for line of sight and water maps. varchar(16) NULL
safe_x This is the X location should the player fall under world or a player is zoned without the use of a zone point (eg. using the /zone or #zone command) float 0
safe_y This is the Y location should the player fall under world or a player is zoned without the use of a zone point (eg. using the /zone or #zone command) float 0
safe_z This is the Z location should the player fall under world or a player is zoned without the use of a zone point (eg. using the /zone or #zone command) float 0
underworld This is the bottom Z to represent when the player is under the world float 0
minclip This is the minimum clipping distance in which the player view extends float 0
maxclip This is the maximum clipping distance in which the player view extends float 0
zone_exp_multiplier This will multiply the XP to this percentage value (decimal based, 100% = 1.0) decimal(6,2) 0.00
sky Sky type the client will present as the backdrop tinyint(3) 1

fog_red

fog_red2

fog_red3

fog_red4

These fields represent the correlating R (red) value of RGB for the four fog fields.  This number can be 0-255. tinyint(3) 0

fog_green

fog_green2

fog_green3

fog_green4

These fields represent the correlating G (green) value of RGB for the four fog fields.  This number can be 0-255. tinyint(3) 0

fog_blue

fog_blue2

fog_blue3

fog_blue4

These fields represent the correlating B (blue) value of RGB for the four fog fields.  This number can be 0-255. tinyint(3) 0

fog_minclip

fog_minclip2

fog_minclip3

fog_minclip4

These represent the four fog fields minimum distance before fog starts to build. float 450

fog_maxclip

fog_maxclip2

fog_maxclip3

fog_maxclip4

These represent the four fog fields maximum distance for fog. float 450
fog_density This is the intensity of the fog, this should be a number between 0-1, most commonly used is .1 or .33 float 0
canbind This determines whether or not bind affinity can be used in the zone, 0 = no bind allowed, 1 = bind allowed (for caster), 2 = bind allowed for all, also marks zone as city (is_city=true) tinyint(4) 0
cancombat This determines whether detrimental spell casting or attacks can take place in this zone, 0 = combat not allowed, 1 = combat allowed tinyint(4) 0
canlevitate This determines whether levitate spells will work or not, 0 = levitate not allowed, 1 = levitate allowed, this does not apply to those with the GM flag on tinyint(4) 0
castoutdoor This determines if certain spells are allowed (those which only are allowed outdoors), 0 = outdoor casting is not allowed (eg. those spells are refused in this zone), 1 = they are allowed. tinyint(4) 0
hotzone This determines if the zone is considered a hotzone, 1 = hotzone, 0 = not a hotzone, when a hotzone (1) it will add on top of experience earned by multiplying experience by RuleR(Zone, HotZoneBonus) value, which is by default .75 (75%) tinyint(3) 0
ruleset This matches the ruleset_id of rule_sets which should apply to the current zone int(10) 0
suspendbuffs This determines if the buff (spell) process for non-detrimental spells will be disabled (eg. tics will not be consumed) in the current zone.  1 = buffs tics suspended (no tics, less detrimental spell), 0 = buff tics not suspended tinyint(1) 0
time_type This value varies depending on the zone but it is sent to the client on zone in.  Most starting zones/newbie areas have this value set to 2, dungeons tyically have this set to 0, some zones break from the norm and have values greater than 2, (akanon = 3, blackburrow = 5, cazicthule = 5, crushbone = 5, erudnint = 4, kaladima = 3, etc.) tinyint(3) 2
ztype This field is sent directly to the client on zone-in, most zones are set to 0, 1 or 255. tinyint(3) 1
version This field allows custom versioning of a zone, the version field passes on to spawn2 , doors , ground_spawns , traps and object tinyint(3) 0

rain_chance1

rain_chance2

rain_chance3

rain_chance4

These represent the four rain chance fields for a chance to rain in each zone. int(4) 0

rain_duration1

rain_duration2

rain_duration3

rain_duration4

These represent the four rain duration fields for a length of time to rain in each zone. int(4) 0

snow_chance1

snow_chance2

snow_chance3

snow_chance4

These represent the four snow chance fields for a chance to snow in each zone. int(4) 0

snow_duration1

snow_duration2

snow_duration3

snow_duration4

These represent the four snow duration fields for a length of time to snow in each zone. int(4) 0

ยงzone

Used With
  • Zones
  • Instances (inherit from zone)
  • Spawns ( spawn2 )
Loaded When
  • On zone init/boot (static zone on its initial boot, dynamics on each startup of a zone)
Loaded From ZoneDatabase::GetZoneConfig in zone/zonedb.cpp
Related Commands