Our board has forums we've established for people who live in geographic areas around the country. I have also created groups so that when a new user is signed up, that user is added to a group manually when the account is approved. This allows me to easily send emails to particular groups.
I'd like to create a series of scripts so that each person in a selected geographical area group has the watch list for the forum that matches that group enabled so they automatically receive notification of posts in their geographical area. The following table shows the mapping of geographic areas for the groups, and what number corresponds to the regional forums established listed as the "Forum Keyword #" from the admin panel.
Group # - Group Name - Forum Keyword #
10 - SNE District - 20
11 - NNE District - 19
12 - LIS District - 29
13 - Gulf Coast District - 23
14 - Chesapeake District - 3
15 - Southeast District - 22
16 - California District - 24
17 - Carolinas District - 21
18 - Eastern Great Lakes District - 27
19 - Western Great Lakes District - 26
20 - PNW District - 25
21 - Other & International - 28
Can somebody help me with a series of SQL scripts I can execute to set the correct users to the geographic groups for watch lists? Assume that "F" is the number for the forum keyword assigned to a geographic area, and "G" is the geographical area group assigned an individual.
