Remove rain from Database

[KaMakaZe]

Hey, i was wondering if anyone knows how to remove rain from the weather table in the database?

No one on my server likes it and want it off, i personally hate it too but i dont know the numbers for rain so i need someone who knows the code.

If someone could tell me ill +Rep you.

[lilbdiablo12]

Can you just search Rain Effect? in the table

[KaMakaZe]

Nope, they dont have names. Its all numbers that make no sense to me.
Thats why im looking for a list of numbers for the types of weather.

zoneId, high_chance, high_type, med_chance, med_type, low_chance, low_type

[marcelo_20xx]

If is only the rain is a little time consuming but if its all the weather is a easy SQL. Oddly enough the only weather effect that I like is the rain.

[KaMakaZe]

If is only the rain is a little time consuming but if its all the weather is a easy SQL. Oddly enough the only weather effect that I like is the rain.

I live in England, i have enough of it outside, i dont wanna come online and even my Private Server is raining. xD
No one knows the code for rain? :P

[lilbdiablo12]

Nope, i have even check google, wowhead, i have checked everything.. lol, wait, see if this works,

go into where it is raining type in this

#weathertype

and see if it says anything

i think you can set all your areas to wheathertype 0, and it will be nothing, but im not sure, lol