NAME
Teamspeak::SQL - SQL-Interface to administrate Teamspeak-Voice-Server
CLASS METHODS
connect ( user => $dbuser, pwd => $pwd )
MySQL needs a username and password to connect to the database.
new ( host => 'localhost', port => 3306, db => $dbname ) =head2 new ( file => $filename )
MySQL needs a host, port and db parameter. SQLite needs the filename of the server.dbm.
sl
Returns a list of "Teamspeak::Server"s.
get_channel
Retrieves or refreshes the channel list of the TS-Server.
DATABASE STRUCTURE
for TS-Server of Version 2.0.23.19
ts2_bans
i_ban_id integer primary key
i_ban_server_id integer
s_ban_ip varchar(40)
s_ban_by varchar(40)
dt_ban_created varchar(20)
i_ban_minutes integerts2_channel_privileges
i_cp_id integer primary key
i_cp_server_id integer
i_cp_channel_id integer
i_cp_client_id integer
b_cp_flag_admin integer
b_cp_flag_autoop integer
b_cp_flag_autovoice integerts2_channels
i_channel_id integer primary key
i_channel_server_id integer
i_channel_parent_id integer
b_channel_flag_moderated integer
b_channel_flag_hierarchical integer
b_channel_flag_default integer
i_channel_codec integer
i_channel_order integer
i_channel_maxusers integer
s_channel_name varchar(40)
s_channel_topic varchar(40)
s_channel_description text
s_channel_password varchar(80)
dt_channel_created varchar(20)ts2_clients
i_client_id integer primary key
i_client_server_id integer
b_client_privilege_serveradmin integer
s_client_name varchar(40)
s_client_password varchar(80)
dt_client_created varchar(20)
dt_client_lastonline varchar(20)ts2_nicks
i_nick_id integer primary key
i_nick_server_id integer
i_nick_client_id integer
s_nick_name varchar(40)ts2_server_privileges
i_sp_id integer primary key
i_sp_server_id integer
s_sp_usergroup varchar(40)
b_sp_AccessWebAdminServer integer
b_sp_AccessTcpServer integer
b_sp_AccessVoice integer
b_sp_AdminRegisterPlayer integer
b_sp_AdminSetServerPermissions integer
b_sp_AdminAddServer integer
b_sp_AdminDeleteServer integer
b_sp_AdminEditServerIpPort integer
b_sp_AdminEditServerWebpostUrl integer
b_sp_AdminEditServerName integer
b_sp_AdminEditServerWelcomeMessage integer
b_sp_AdminEditServerPassword integer
b_sp_AdminEditServerType integer
b_sp_AdminEditServerAllodCodecs integer
b_sp_AdminBanIp integer
b_sp_AdminMovePlayer integer
b_sp_AdminListDBUsers integer
b_sp_AdminChangeOwnPassword integer
b_sp_AdminChangeUserPassword integer
b_sp_AdminListDBServers integer
b_sp_AdminEditServerMaxUsers integer
b_sp_AdminStopServer integer
b_sp_AdminStartServer integer
b_sp_ChannelJoinRegisterred integer
b_sp_ChannelCreateRegisterred integer
b_sp_ChannelCreateUnregisterred integer
b_sp_ChannelCreateDefault integer
b_sp_ChannelCreateSubchannels integer
b_sp_ChannelCreateModerated integer
b_sp_ChannelDelete integer
b_sp_ChannelEditName integer
b_sp_ChannelEditPassword integer
b_sp_ChannelEditTopic integer
b_sp_ChannelEditDescription integer
b_sp_ChannelEditOrder integer
b_sp_ChannelEditMaxUsers integer
b_sp_ChannelEditCodec integer
b_sp_ChannelJoinChannelWithoutPassword integer
b_sp_PrivilegeGrantSA integer
b_sp_PrivilegeGrantCA integer
b_sp_PrivilegeGrantAutoOp integer
b_sp_PrivilegeGrantOp integer
b_sp_PrivilegeGrantAutoV integer
b_sp_PrivilegeGrantV integer
b_sp_PrivilegeGrantAllowRegistration integer
b_sp_PrivilegeRevokeSA integer
b_sp_PrivilegeRevokeCA integer
b_sp_PrivilegeRevokeAutoOp integer
b_sp_PrivilegeRevokeOp integer
b_sp_PrivilegeRevokeAutoV integer
b_sp_PrivilegeRevokeV integer
b_sp_PrivilegeRevokeAllowRegistration integer
b_sp_PrivilegeAdminPlayerRegister integer
b_sp_PrivilegePlayerDelete integer
b_sp_PrivilegeRegisterSelfByDefault integer
b_sp_SendTextToAll integer
b_sp_SendTextToOwnChannel integer
b_sp_SendTextToAllChannel integer
b_sp_SendTextToPlayer integer
b_sp_KickPlayerFromServer integer
b_sp_KickPlayerFromChannel integer
b_sp_AllowChannelCommanderStatus integerts2_servers
i_server_id integer primary key
s_server_name varchar(40)
s_server_welcomemessage varchar(80)
i_server_maxusers integer
i_server_udpport integer
s_server_password varchar(80)
b_server_clan_server integer
b_server_allow_codec_celp51 integer
b_server_allow_codec_celp63 integer
b_server_allow_codec_gsm148 integer
b_server_allow_codec_gsm164 integer
b_server_allow_codec_celp52 integer
b_server_allow_codec_speex2150 integer
b_server_allow_codec_speex3950 integer
b_server_allow_codec_speex5950 integer
b_server_allow_codec_speex8000 integer
b_server_allow_codec_speex11000 integer
b_server_allow_codec_speex15000 integer
b_server_allow_codec_speex18200 integer
b_server_allow_codec_speex24600 integer
s_server_webposturl varchar(200)
s_server_weblinkurl varchar(200)
b_server_active integer
dt_server_created varchar(20)
s_server_description varchar(100)ts2_settings
i_setting_id integer primary key
i_setting_server_id integer
s_setting_section varchar(40)
s_setting_ident varchar(40)
s_setting_value varchar(40)