Teamspeak::SQL - SQL-Interface to administrate Teamspeak-Voice-Server
MySQL needs a username and password to connect to the database.
MySQL needs a host, port and db parameter. SQLite needs the filename of the server.dbm.
Returns a list of "Teamspeak::Server"s.
Retrieves or refreshes the channel list of the TS-Server.
for TS-Server of Version 2.0.23.19
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 integer
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 integer
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)
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)
i_nick_id integer primary key i_nick_server_id integer i_nick_client_id integer s_nick_name varchar(40)
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 integer
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)
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)
To install Teamspeak, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Teamspeak
CPAN shell
perl -MCPAN -e shell install Teamspeak
For more information on module installation, please visit the detailed CPAN module installation guide.