Game weather

From OregonCore Wiki
Jump to: navigation, search

Back to world database list of tables.


The `game_weather` table

This table holds the percentages for weather changes in various zones. Not all zones can have their weather changed. For any given zone the percentage of all weather types for each season should total, and not exceed 100%.

Schema Last Modified: TC1-1828 - Schema Verified: Rev 665


Structure

Field Type Attributes Key Null Default Extra Comment
zone mediumint(8) unsigned PRI NO 0
spring_rain_chance tinyint(3) unsigned NO 25
spring_snow_chance tinyint(3) unsigned NO 25
spring_storm_chance tinyint(3) unsigned NO 25
summer_rain_chance tinyint(3) unsigned NO 25
summer_snow_chance tinyint(3) unsigned NO 25
summer_storm_chance tinyint(3) unsigned NO 25
fall_rain_chance tinyint(3) unsigned NO 25
fall_snow_chance tinyint(3) unsigned NO 25
fall_storm_chance tinyint(3) unsigned NO 25
winter_rain_chance tinyint(3) unsigned NO 25
winter_snow_chance tinyint(3) unsigned NO 25
winter_storm_chance tinyint(3) unsigned NO 25


Description of the fields

zone

This field contains the zone id from AreaTable.dbc that you wish to change the weather for.

spring_rain_chance

Percentage chance for rain in the Spring

spring_snow_chance

Percentage chance for snow in the Spring

spring_storm_chance

Percentage chance for a sand storm in the Spring

summer_rain_chance

Percentage chance for rain in the Summer

summer_snow_chance

Percentage chance for snow in the Summer

summer_storm_chance

Percentage chance for a sand storm in the Summer

fall_rain_chance

Percentage chance for rain in the Fall

fall_snow_chance

Percentage chance for snow in the Fall

fall_storm_chance

Percentage chance for a sand storm in the Fall

winter_rain_chance

Percentage chance for rain in the Winter

winter_snow_chance

Percentage chance for snow in the Winter

winter_storm_chance

Percentage chance for a sand storm in the Winter