Hey there.
I've just uploaded a simple script which might be helpful for some people in order to prepare for the upcoming server release (
beta23). The script is inteded to be started from the command-line and requires
PHP >= 5.2.1 to be installed on your systems.
http://download.planetteamspeak.com/...ion_Update.zip
First, you need to open the file called
startme and enter your servers connection information and ServerQuery admin credentials in the configuration area. In addition, please enter the name of the template group you want to use for the update.
When you start the script, it will TRY to identify the most powerful group (which should be the admin group) on any virtual server and compares its permissions with the template you specified in the config. Depending on the virtual servers configuration, the results may differ. Anyway... If the template has a permission that's missing in the admin group, the script will automatically assign it. If the template is missing a permission that's assigned to the admin group, it will be removed. In short... you only need to adjust your template groups and the script will do the rest on your customers servers.
The output should look like this:
Code:
TeamSpeak 3 Permission Update Script
PHP Version: 5.2.4-2ubuntu5.10
LIB Version: 1.0.27-beta
[voice.planetteamspeak.com] Loading virtual server list ... DONE
[voice.planetteamspeak.com] Loading list of permissions available ... DONE
[PORT: 9987] Loading template group information ... DONE
[PORT: 9987] Loading Server Owners (ID 3) template permissions ... DONE
[PORT: 9987] Trying to identify most powerful server group ... DONE
[PORT: 9987] Loading Server Owners (ID 7) permissions ... DONE
[PORT: 9988] Loading template group information ... DONE
[PORT: 9988] Loading Server Owners (ID 3) template permissions ... DONE
[PORT: 9988] Trying to identify most powerful server group ... DONE
[PORT: 9988] Loading Server Owners (ID 15) permissions ... DONE
[PORT: 9988] Assigning missing permission b_virtualserver_custom_search (ID 8479) ... DONE
[PORT: 9988] Assigning missing permission i_group_auto_update_type (ID 16507) ... DONE
[PORT: 9988] Assigning missing permission b_client_custom_info_view (ID 20896) ... DONE
[PORT: 9988] Assigning missing permission i_needed_modify_power_virtualserver_custom_search (ID 65311) ... DONE
[PORT: 9988] Assigning missing permission i_needed_modify_power_client_custom_info_view (ID 65440) ... DONE
[PORT: 9989] Loading template group information ... DONE
[PORT: 9989] Loading Server Owners (ID 3) template permissions ... DONE
[PORT: 9989] Trying to identify most powerful server group ... DONE
[PORT: 9989] Loading Server Owners (ID 27) permissions ... DONE
[PORT: 9989] Assigning missing permission i_icon_id (ID 16503) ... DONE
[PORT: 9989] Assigning missing permission i_group_auto_update_type (ID 16507) ... DONE
[PORT: 9989] Assigning missing permission b_client_modify_own_description (ID 21692) ... DONE
[PORT: 9989] Assigning missing permission i_needed_modify_power_client_modify_own_description (ID 65468) ... DONE
[PORT: 9990] Loading template group information ... DONE
[PORT: 9990] Loading Server Owners (ID 3) template permissions ... DONE
[PORT: 9990] Trying to identify most powerful server group ... DONE
[PORT: 9990] Loading Server Owners (ID 40) permissions ... DONE
[PORT: 9990] Assigning missing permission i_group_auto_update_type (ID 16507) ... DONE
[PORT: 9990] Assigning missing permission b_client_modify_own_description (ID 21692) ... DONE
[PORT: 9990] Assigning missing permission i_needed_modify_power_client_modify_own_description (ID 65468) ... DONE
[PORT: 9991] Loading template group information ... DONE
[PORT: 9991] Loading Server Owners (ID 3) template permissions ... DONE
[PORT: 9991] Trying to identify most powerful server group ... DONE
[PORT: 9991] Loading Server Admin (ID 57) permissions ... DONE
Generated in 5.6430439949 seconds
Note that I strongly recommend that you create a backup of your servers database before using this script!!!
Have fun!