Add new Edit Delete History Source

Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.

game_weather

<-Back-to:World

Table Structure

This table holds the percent chances for weather changes to occur 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%.

Field	Type	Attributes	Key	Null
zone	MEDIUMINT	UNSIGNED	PRI	NO
spring_rain_chance	TINYINT	UNSIGNED		NO
spring_snow_chance	TINYINT	UNSIGNED		NO
spring_storm_chance	TINYINT	UNSIGNED		NO
summer_rain_chance	TINYINT	UNSIGNED		NO
summer_snow_chance	TINYINT	UNSIGNED		NO
summer_storm_chance	TINYINT	UNSIGNED		NO
fall_rain_chance	TINYINT	UNSIGNED		NO
fall_snow_chance	TINYINT	UNSIGNED		NO
fall_storm_chance	TINYINT	UNSIGNED		NO
winter_rain_chance	TINYINT	UNSIGNED		NO
winter_snow_chance	TINYINT	UNSIGNED		NO
winter_storm_chance	TINYINT	UNSIGNED		NO

Field Descriptions

zone

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

spring_rain_chance

Percent chance for rain in the Spring

spring_snow_chance

Percentage chance for snow to occur in the Spring

spring_storm_chance

Percent chance for a sand storm to occur in the Spring

summer_rain_chance

Percent chance for rain to occur in the Summer

summer_snow_chance

Percent chance for snow to occur in the Summer

summer_storm_chance

Percent chance for a sand storm to occur in the Summer

fall_rain_chance

Percent chance for rain to occur in the Fall

fall_snow_chance

Percent chance for snow to occur in the Fall

fall_storm_chance

Percent chance for a sand storm to occur in the Fall

winter_rain_chance

Percentage chance for rain to occur in the Winter

winter_snow_chance

Percentage chance for snow to occur in the Winter

winter_storm_chance

Percentage chance for a sand storm to occur in the Winter