Yup went thought the process they suggest and went smooth as cake. Remember to take the <> out of the example they give for the entries in the ini file... ie: DSN, DB, Username, and Password. That threw me a curve but after looking at the other code in my ini I saw that no of the other valures required the <> so I took um out and bam everything worked and it connected to my existing db with NO changes necessary.

Screw that dbxmda.dll Crap, now I know I'm good to go LONG term :)

Is there any way to change the Blue color to another color in the team speak Client background?

Thx

Yes. There is a program someone made that hacks the TeamSpeak.exe and changes the colors. I host the file at http://www.thzclan.com/files/index.php?cat=47.

Cool but I found the stylesheet and made the changes there... and it worked
Thx for the reply though ... ^5

Stylesheet? Hmm, I must not have followed what blue background you were requesting before.

First of all thanks for writing such great products and plugins!! I followed all the installation steps on the currently updated official gTeamspeak page here at the VBulletin.Org Official Modifications Site (forum). Just today I upgraded from 3.24 to 3.27 and also for the first time noticed new instructions explaining what to fill in in some of the Custom User Profile Fields. I did it exactly as shown there (although the bottom two sections, for "Optional Input" and "Display Page"; there were no instructions for how to set these, maybe that's part of the problem?)


gTeamspeak 3.27 works perfectly for me so far except for two problems:

I keep getting the following message in the Manage Users page and at the bottom of the gTeamspeak main configuration page:

in a big black square that looks like a borderless console window.

I searched various threads but couldn't even find "[rpl] => Connection refused"
doing a Google search.
)

This means I can't use any of the plugins and probably cannot auto-ban users from
the Teamspeak server when they are banned by usergroup. (?)

The other problem I'm having (probably related to the above one?) is that the Who's Online
part of the product isn't working for me. It's permanently stuck at "0 Active and 1 Inactive Users"
no matter how many people log in to both the site and the voice chat system or how long they stay
logged on. Everything else in both the TS server itself and the product seems to work perfectly so far though.


It's VBulletin version 3.6.8 Patch 2, gTeamspeak v.3.27,
being run on Red Hat Linux Enterprise ES 4.5, Apache 2.0.52 handler, PHP 5.2.1, MySQL v. 5.0.27 etc. as below.

Here's my MySQL and PHP info (xxxxxxx's substituted in places for privacy):



MySQL Stats mysql_stat() Uptime: 4375
Threads: 2
Questions: 8855
Slow queries: 0
Opens: 431
Flush tables: 1
Open tables: 400
Queries per second avg: 2.024

MySQL Status query: SHOW STATUS Aborted_clients: 0
Aborted_connects: 0
Binlog_cache_disk_use: 0
Binlog_cache_use: 0
Bytes_received: 8684117
Bytes_sent: 203496648
Com_admin_commands: 0
Com_alter_db: 0
Com_alter_table: 3
Com_analyze: 0
Com_backup_table: 0
Com_begin: 0
Com_change_db: 324
Com_change_master: 0
Com_check: 0
Com_checksum: 0
Com_commit: 0
Com_create_db: 0
Com_create_function: 0
Com_create_index: 0
Com_create_table: 3
Com_dealloc_sql: 0
Com_delete: 91
Com_delete_multi: 0
Com_do: 0
Com_drop_db: 0
Com_drop_function: 0
Com_drop_index: 0
Com_drop_table: 5
Com_drop_user: 0
Com_execute_sql: 0
Com_flush: 0
Com_grant: 0
Com_ha_close: 0
Com_ha_open: 0
Com_ha_read: 0
Com_help: 0
Com_insert: 135
Com_insert_select: 3
Com_kill: 0
Com_load: 0
Com_load_master_data: 0
Com_load_master_table: 0
Com_lock_tables: 5
Com_optimize: 1
Com_preload_keys: 0
Com_prepare_sql: 0
Com_purge: 0
Com_purge_before_date: 0
Com_rename_table: 0
Com_repair: 0
Com_replace: 147
Com_replace_select: 0
Com_reset: 0
Com_restore_table: 0
Com_revoke: 0
Com_revoke_all: 0
Com_rollback: 0
Com_savepoint: 0
Com_select: 2335
Com_set_option: 0
Com_show_binlog_events: 0
Com_show_binlogs: 0
Com_show_charsets: 0
Com_show_collations: 0
Com_show_column_types: 0
Com_show_create_db: 0
Com_show_create_table: 350
Com_show_databases: 0
Com_show_errors: 0
Com_show_fields: 12
Com_show_grants: 0
Com_show_innodb_status: 0
Com_show_keys: 6
Com_show_logs: 0
Com_show_master_status: 0
Com_show_ndb_status: 0
Com_show_new_master: 0
Com_show_open_tables: 0
Com_show_privileges: 0
Com_show_processlist: 0
Com_show_slave_hosts: 0
Com_show_slave_status: 0
Com_show_status: 3
Com_show_storage_engines: 0
Com_show_tables: 16
Com_show_variables: 10
Com_show_warnings: 0
Com_slave_start: 0
Com_slave_stop: 0
Com_stmt_close: 0
Com_stmt_execute: 0
Com_stmt_prepare: 0
Com_stmt_reset: 0
Com_stmt_send_long_data: 0
Com_truncate: 3
Com_unlock_tables: 5
Com_update: 2215
Com_update_multi: 3
Connections: 330
Created_tmp_disk_tables: 11
Created_tmp_files: 0
Created_tmp_tables: 67
Delayed_errors: 0
Delayed_insert_threads: 0
Delayed_writes: 0
Flush_commands: 1
Handler_commit: 0
Handler_delete: 379
Handler_discover: 0
Handler_read_first: 1171
Handler_read_key: 132793
Handler_read_next: 83642
Handler_read_prev: 261
Handler_read_rnd: 7688
Handler_read_rnd_next: 1678508
Handler_rollback: 0
Handler_update: 758
Handler_write: 8017
Key_blocks_not_flushed: 0
Key_blocks_unused: 57031
Key_blocks_used: 959
Key_read_requests: 352700
Key_reads: 1082
Key_write_requests: 11023
Key_writes: 1367
Max_used_connections: 3
Not_flushed_delayed_rows: 0
Open_files: 782
Open_streams: 0
Open_tables: 400
Opened_tables: 431
Qcache_free_blocks: 37
Qcache_free_memory: 60639360
Qcache_hits: 2853
Qcache_inserts: 1908
Qcache_lowmem_prunes: 0
Qcache_not_cached: 427
Qcache_queries_in_cache: 599
Qcache_total_blocks: 1574
Questions: 8855
Rpl_status: NULL
Select_full_join: 11
Select_full_range_join: 0
Select_range: 566
Select_range_check: 0
Select_scan: 635
Slave_open_temp_tables: 0
Slave_retried_transactions: 0
Slave_running: OFF
Slow_launch_threads: 0
Slow_queries: 0
Sort_merge_passes: 0
Sort_range: 49
Sort_rows: 71093
Sort_scan: 295
Table_locks_immediate: 6765
Table_locks_waited: 1
Threads_cached: 1
Threads_connected: 2
Threads_created: 3
Threads_running: 1
Uptime: 4375 MySQL Vars query: SHOW VARIABLES back_log: 50
basedir: /usr/local/mysql-standard-4.1.22-linux-i686/
binlog_cache_size: 32768
bulk_insert_buffer_size: 8388608
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_results: latin1
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/local/mysql-standard-4.1.22-linux-i686/share/mysql/charsets/
collation_connection: latin1_swedish_ci
collation_database: latin1_swedish_ci
collation_server: latin1_swedish_ci
concurrent_insert: ON
connect_timeout: 5
datadir: /var/lib/mysql/
date_format: %Y-%m-%d
datetime_format: %Y-%m-%d %H:%i:%s
default_week_format: 0
delay_key_write: ON
delayed_insert_limit: 100
delayed_insert_timeout: 300
delayed_queue_size: 1000
expire_logs_days: 0
flush: OFF
flush_time: 0
ft_boolean_syntax: + -><()~*:""&|
ft_max_word_len: 84
ft_min_word_len: 4
ft_query_expansion_limit: 20
ft_stopword_file: (built-in)
group_concat_max_len: 1024
have_archive: YES
have_bdb: NO
have_blackhole_engine: NO
have_compress: YES
have_crypt: YES
have_csv: NO
have_example_engine: NO
have_geometry: YES
have_innodb: DISABLED
have_isam: NO
have_merge_engine: YES
have_ndbcluster: NO
have_openssl: NO
have_query_cache: YES
have_raid: NO
have_rtree_keys: YES
have_symlink: YES
init_connect:
init_file:
init_slave:
innodb_additional_mem_pool_size: 1048576
innodb_autoextend_increment: 8
innodb_buffer_pool_awe_mem_mb: 0
innodb_buffer_pool_size: 8388608
innodb_data_file_path:
innodb_data_home_dir:
innodb_fast_shutdown: ON
innodb_file_io_threads: 4
innodb_file_per_table: OFF
innodb_flush_log_at_trx_commit: 1
innodb_flush_method:
innodb_force_recovery: 0
innodb_lock_wait_timeout: 50
innodb_locks_unsafe_for_binlog: OFF
innodb_log_arch_dir:
innodb_log_archive: OFF
innodb_log_buffer_size: 1048576
innodb_log_file_size: 5242880
innodb_log_files_in_group: 2
innodb_log_group_home_dir:
innodb_max_dirty_pages_pct: 90
innodb_max_purge_lag: 0
innodb_mirrored_log_groups: 1
innodb_open_files: 300
innodb_table_locks: ON
innodb_thread_concurrency: 8
interactive_timeout: 28800
join_buffer_size: 67104768
key_buffer_size: 67108864
key_cache_age_threshold: 300
key_cache_block_size: 1024
key_cache_division_limit: 100
language: /usr/local/mysql-standard-4.1.22-linux-i686/share/mysql/english/
large_files_support: ON
lc_time_names: en_US
license: GPL
local_infile: ON
locked_in_memory: OFF
log: ON
log_bin: OFF
log_error:
log_slave_updates: OFF
log_slow_queries: OFF
log_update: OFF
log_warnings: 1
long_query_time: 10
low_priority_updates: OFF
lower_case_file_system: OFF
lower_case_table_names: 0
max_allowed_packet: 67107840
max_binlog_cache_size: 4294967295
max_binlog_size: 1073741824
max_connect_errors: 10
max_connections: 100
max_delayed_threads: 20
max_error_count: 64
max_heap_table_size: 67107840
max_insert_delayed_threads: 20
max_join_size: 4294967295
max_length_for_sort_data: 1024
max_prepared_stmt_count: 16382
max_relay_log_size: 0
max_seeks_for_key: 4294967295
max_sort_length: 1024
max_tmp_tables: 32
max_user_connections: 0
max_write_lock_count: 4294967295
myisam_data_pointer_size: 4
myisam_max_extra_sort_file_size: 2147483648
myisam_max_sort_file_size: 2147483647
myisam_recover_options: OFF
myisam_repair_threads: 1
myisam_sort_buffer_size: 8388608
myisam_stats_method: nulls_unequal
net_buffer_length: 16384
net_read_timeout: 30
net_retry_count: 10
net_write_timeout: 60
new: OFF
old_passwords: OFF
open_files_limit: 65535
pid_file: /var/lib/mysql/hawaiian-tv.com.pid
port: 3306
preload_buffer_size: 32768
prepared_stmt_count: 0
protocol_version: 10
query_alloc_block_size: 8192
query_cache_limit: 131072
query_cache_min_res_unit: 4096
query_cache_size: 67108864
query_cache_type: ON
query_cache_wlock_invalidate: OFF
query_prealloc_size: 8192
range_alloc_block_size: 2048
read_buffer_size: 67104768
read_only: OFF
read_rnd_buffer_size: 262144
relay_log_purge: ON
relay_log_space_limit: 0
rpl_recovery_rank: 0
secure_auth: OFF
server_id: 0
skip_external_locking: ON
skip_networking: ON
skip_show_database: OFF
slave_net_timeout: 3600
slave_transaction_retries: 0
slow_launch_time: 2
socket: /var/lib/mysql/mysql.sock
sort_buffer_size: 67108856
sql_mode:
sql_notes: ON
sql_warnings: ON
storage_engine: MyISAM
sync_binlog: 0
sync_frm: ON
sync_replication: 0
sync_replication_slave_id: 0
sync_replication_timeout: 0
system_time_zone: MST
table_cache: 32712
table_type: MyISAM
thread_cache_size: 80
thread_stack: 131072
time_format: %H:%i:%s
time_zone: SYSTEM
tmp_table_size: 8388608
tmpdir:
transaction_alloc_block_size: 8192
transaction_prealloc_size: 4096
tx_isolation: REPEATABLE-READ
version: 4.1.22-standard-log
version_comment: MySQL Community Edition - Standard (GPL)
version_compile_machine: i686
version_compile_os: pc-linux-gnu
wait_timeout: 28800+++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++

PHP INFO:


PHP Version 5.2.1


System Linux hawaiian-tv.com 2.6.9-42.0.3.ELsmp #1 SMP Mon Sep 25 17:28:02 EDT 2006 i686 Build Date Mar 4 2007 14:46:57 Configure Command './configure' '--prefix=/usr/local/php' '--enable-safe-mode' '--enable-sockets' '--enable-ftp' '--enable-mbstring' '--enable-dbx' '--enable-dio' '--enable-memory-limit' '--enable-bcmath' '--enable-calendar' '--enable-dbase' '--enable-exif' '--enable-mbregex' '--enable-track-vars' '--enable-soap' '--enable-zend-multibyte' '--enable-dba' '--disable-mbstr-enc-trans' '--with-dom' '--with-bz2' '--with-pear' '--with-ldap=/usr/local/php/dependencies' '--with-xmlrpc' '--with-gd' '--with-openssl' '--with-imap-ssl' '--with-regex=system' '--with-config-file-path=/etc' '--with-apxs2=/usr/sbin/apxs' '--with-gettext=/usr/local/php/dependencies' '--with-jpeg-dir=/usr/local/php/dependencies' '--with-png-dir=/usr/local/php/dependencies' '--with-ttf=/usr/local/php/dependencies' '--with-pgsql=/usr/local/php/dependencies' '--with-mysql=/usr/local/php/dependencies' '--with-mysqli=/usr/local/php/dependencies/bin/mysql_config' '--with-pdo-mysql=/usr/local/php/dependencies' '--with-pdo-pgsql=/usr/local/php/dependencies' '--with-mssql=/usr/local/php/dependencies' '--with-db4=/usr/local/php/dependencies' '--with-freetype-dir=/usr/local/php/dependencies' '--with-iconv=/usr/local/php/dependencies' '--with-iconv-dir=/usr/local/php/dependencies' '--with-gmp=/usr/local/php/dependencies' '--with-t1lib=/usr/local/php/dependencies' '--with-mhash=/usr/local/php/dependencies' '--with-mcrypt=/usr/local/php/dependencies' '--with-zlib=/usr/local/php/dependencies' '--with-expat-dir=/usr/local/php/dependencies' '--with-xsl=/usr/local/php/dependencies' '--with-libxml-dir=/usr/local/php/dependencies' '--with-curl=/usr/local/php/dependencies' '--with-imap=/home/php5/src/dependencies/imap-2006f' '--with-pspell=/usr/local/php/dependencies' '--with-magickwand=/usr/local/php/dependencies' Server API Apache 2.0 Handler Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php.ini PHP API 20041225 PHP Extension 20060613 Zend Extension 220060519 Debug Build no Thread Safety disabled Zend Memory Manager enabled IPv6 Support enabled Registered PHP Streams php, file, data, http, ftp, compress.bzip2, compress.zlib, https, ftps Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with eAccelerator v0.9.5, Copyright (c) 2004-2006 eAccelerator, by eAccelerator
with Zend Extension Manager v1.2.0, Copyright (c) 2003-2006, by Zend Technologies
with Zend Optimizer v3.2.2, Copyright (c) 1998-2006, by Zend Technologies

PHP Credits

Configuration

PHP Core

DirectiveLocal ValueMaster Value allow_call_time_pass_referenceOnOn allow_url_fopenOnOn allow_url_includeOnOn always_populate_raw_post_dataOffOff arg_separator.input&& arg_separator.output&& asp_tagsOffOff auto_append_fileno valueno value auto_globals_jitOnOn auto_prepend_fileno valueno value browscapno valueno value default_charsetno valueno value default_mimetypetext/htmltext/html define_syslog_variablesOffOff detect_unicodeOnOn disable_classesno valueno value disable_functionsno valueno value display_errorsOffOff display_startup_errorsOffOff doc_rootno valueno value docref_extno valueno value docref_rootno valueno value enable_dlOnOn error_append_stringno valueno value error_logno valueno value error_prepend_stringno valueno value error_reporting61356135 expose_phpOnOn extension_dir/usr/local/php/lib/php/extensions/no-debug-non-zts-20060613/usr/local/php/lib/php/extensions/no-debug-non-zts-20060613 file_uploadsOnOn highlight.bg#FFFFFF#FFFFFF highlight.comment#FF8000#FF8000 highlight.default#0000BB#0000BB highlight.html#000000#000000 highlight.keyword#007700#007700 highlight.string#DD0000#DD0000 html_errorsOnOn ignore_repeated_errorsOffOff ignore_repeated_sourceOffOff ignore_user_abortOffOff implicit_flushOffOff include_path.:/php/includes:/usr/local/lib/php:/usr/local/php/lib/php.:/php/includes:/usr/local/lib/php:/usr/local/php/lib/php log_errorsOffOff log_errors_max_len10241024 magic_quotes_gpcOnOn magic_quotes_runtimeOffOff magic_quotes_sybaseOffOff mail.force_extra_parametersno valueno value max_execution_time36003600 max_input_time36003600 memory_limit2000M2000M open_basedirno valueno value output_buffering40964096 output_handlerno valueno value post_max_size5000M5000M precision1212 realpath_cache_size16K16K realpath_cache_ttl120120 register_argc_argvOnOn register_globalsOffOff register_long_arraysOnOn report_memleaksOnOn report_zend_debugOnOn safe_modeOffOff safe_mode_exec_dirno valueno value safe_mode_gidOffOff safe_mode_include_dirno valueno value sendmail_fromno valueno value sendmail_path/bin/sendmail -t -i/bin/sendmail -t -i serialize_precision100100 short_open_tagOnOn SMTPlocalhostlocalhost smtp_port2525 sql.safe_modeOffOff track_errorsOffOff unserialize_callback_funcno valueno value upload_max_filesize5000M5000M upload_tmp_dirno valueno value user_dirno valueno value variables_orderEGPCSEGPCS xmlrpc_error_number00 xmlrpc_errorsOffOff y2k_complianceOffOff zend.ze1_compatibility_modeOffOff
apache2handler

Apache Version Apache/2.0.52 (Red Hat) Apache API Version 20020903 Server Administrator Postmaster@hawaiian-tv.com Hostname:Port vip-hawaii.com:0 User/Group hawaiian-tv(2222)/101 Max Requests Per Child: 4000 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 300 - Keep-Alive: 15 Virtual Server Yes Server Root /etc/httpd Loaded Modules core prefork http_core mod_so mod_access mod_auth mod_auth_anon mod_auth_dbm mod_auth_digest util_ldap mod_auth_ldap mod_include mod_log_config mod_env mod_mime_magic mod_cern_meta mod_expires mod_deflate mod_headers mod_usertrack mod_setenvif mod_mime mod_dav mod_status mod_autoindex mod_asis mod_info mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_imap mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_proxy proxy_ftp proxy_http proxy_connect mod_cache mod_suexec mod_disk_cache mod_file_cache mod_mem_cache mod_cgi mod_fastcgi mod_fpcgid mod_perl mod_python mod_php5 mod_ssl
DirectiveLocal ValueMaster Value engine11 last_modified00 xbithack00



MSSQL Supportenabled Active Persistent Links 0 Active Links 0 Library version FreeTDS
DirectiveLocal ValueMaster Value mssql.allow_persistentOnOn mssql.batchsize00 mssql.charsetno valueno value mssql.compatability_modeOffOff mssql.connect_timeout55 mssql.datetimeconvertOnOn mssql.max_linksUnlimitedUnlimited mssql.max_persistentUnlimitedUnlimited mssql.max_procsUnlimitedUnlimited mssql.min_error_severity1010 mssql.min_message_severity1010 mssql.secure_connectionOffOff mssql.textlimitServer defaultServer default mssql.textsizeServer defaultServer default mssql.timeout6060
mysql

MySQL Supportenabled Active Persistent Links 0 Active Links 1 Client API version 5.0.27 MYSQL_MODULE_TYPE external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/local/php/dependencies/include/mysql MYSQL_LIBS -L/usr/local/php/dependencies/lib/mysql -lmysqlclient
DirectiveLocal ValueMaster Value mysql.allow_persistentOnOn mysql.connect_timeout9090 mysql.default_hostno valueno value mysql.default_passwordno valueno value mysql.default_portno valueno value mysql.default_socket/var/lib/mysql/mysql.sock/var/lib/mysql/mysql.sock mysql.default_userno valueno value mysql.max_linksUnlimitedUnlimited mysql.max_persistentUnlimitedUnlimited mysql.trace_modeOffOff
mysqli

MysqlI Supportenabled Client API library version 5.0.27 Client API header version 5.0.27 MYSQLI_SOCKET /tmp/mysql.sock
DirectiveLocal ValueMaster Value mysqli.default_hostno valueno value mysqli.default_port33063306 mysqli.default_pwno valueno value mysqli.default_socket/var/lib/mysql/mysql.sock/var/lib/mysql/mysql.sock mysqli.default_userno valueno value mysqli.max_linksUnlimitedUnlimited mysqli.reconnectOffOff


PDO supportenabled PDO drivers sqlite2, sqlite, pgsql, mysql
pdo_mysql

PDO Driver for MySQL, client library version5.0.27
pdo_pgsql

The defaults that are there are fine.

You have enabled debug mode in advanced options. This is showing you the information that is happening when it is trying to connect to the teamspeak server to access live data via tcp.

No, that is done by database access and if you can add members ok, they can be banned ok. The advanced options just allow you to do live things to the users like kick and message and obtain whois online information.

Yup, that is handled by the tcp connection for live data. You will have to enter a admin username and password to access tcp. The script is pretty smart, it can try and figure out the name and pass on its own and fill those values in automatically, and if it cant it will create a randomly named admin and pass for access. If you still cant access, it is probably due to something blocking the ports on the TeamSpeak server for tcp access. There are tools to determine the accessibility on the TeamSpeak forums.

The most important feature of the script, user access, will work just fine without tcp information. The tcp data is for fluff and fun, and unfortunately setting that up is something you will have to troubleshoot as there is no general fix all solution. There is a lot of information available on the TeamSpeak forums and I think Planet TeamSpeak has a port checking form on their site.

Good luck, thank you for the complements.

Hey, just wondering if there is any reason this wouldn't show who's on?

https://vborg.vbsupport.ru/external/2008/02/21.png

Possibly if you allowed people to register without this system. Login names need to be in a specific format, so you should have an empty TS database and only allow registration through this mod. If you have done that, any another reason escapes me at the moment.

how does this mod work? does the server and the site have to be on the same system?

No, they can be on separate systems. You need remote access to the database on the TeamSpeak system however.

Hi Gryphon,

I found a big logic bug in your hack and I hope you can write an update.

Background:
I am running a Teamspeak Server with 3 Virtual Servers (3 different Ports).
The Teamspeak Server is using its own Database.
I've installed two vBulletin Systems now on the Webserver and both vB Installations have
gTeamspeak installed.

Now the problem:
If you have a user called "test" with the id1 on both Servers you cannot delete it for only one.
Also the MANAGE USERS option in the AdminCP shows all users in the database but it should only show Users which use this gTeamSpeak installation, otherwise it could happen that Admins delete or ban the wrong users.

Possible solution:
gTeamSpeak should internally use the following system to store user information:
<username>.<boardid>.<serverport>

All User manage options should then show and use only users where the port matches the one entered in the gteamspeak settings.

I hope you got the problem?
I never thought about this but now where I have this setup I think this could be critial.

Kind regards
jluerken

Update:

Hi Gryphon,

you should update the product .xml file
should be
Kind regards
jluerken

Yeah, I have know about this. The script was never intended to work across multiple boards using the same TeamSpeak database. I really want to just rewrite the entire script.

Thank you. However absolute urls are not standard coding practice for vBulletin templates. As well, I despise absolute urls as it hinders portability and boards with parked domains.

will this work with 3.7 beta 5?

Yes

nice mod, but yep i'm another user that has multiple boards therefore cannot use it.

will check back in the future for an update.

Thanks.

i went in the config.php and changed it to 1 and 6 but still when i click plugins that command prompt it says super.admin and a pass but thats not my user nam or my pass where do i enter that at?

I have a slight problem with this hack.

I have my TS server running with a MySQL Db fine. The tables are present and when I use the hack to create a user the data is inserted correctly into the tables.

However when I try and connect to the server through the TS client I get a Bad Login error from the client.

If I login using the default admin or superadmin details that were created by TS I log in fine, so the server is running as it should.

It appears that only the plain text stored passwords ( i.e. the ones generated by this hack ) are the ones that can't connect.

I'm using MySQL 5 . Any help on this would be much appreciated as this will be very useful for my forum.

@socom0810 I am unsure why it would not be working for just your board.

@PlymWS TeamSpeak only uses plain text passwords, this mod does not do anything differently. First thing that pops to mind is really make sure both are accessing the same database, make sure TS didn't somehow default back to sqlite. I am not sure how mySQL 5 interacts with the script, I don't imagine there should be any issue. If you create a user view the TS client, does that user appear in the database?

If I create a user through the TS backend, the user is added to the MySQL DB fine. The password is hashed as it's not the same as the plain text.

If I create a user through the hack that user also appears in the MySQL DB fine and the password is visible in plain text.

However the TS-created user can connect but the hack-created user gets a bad login message.

Other than that the hack works perfectly. I'll investigate this as well and let you know if I get anywhere.

Hmm, in mySQL 4.0 TS users are plain text. I know that as of 4.1 there was some password changes, but didn't realize it would affect the TS password field. I will have to look into that.

There's MD5 hashing on my passwords for some reason. Possibly a change in MySQL 5.

I'm pretty sure this is to do with the way MySQL 5 hashes passwords. Just to make sure if someone could post me their TS install folder, minus server.ini and server.log so I can try with that I would appreciate it.

If you get an error about client authentication version when connecting to MySQL then it may be because your server is using the new password format, while your mysql client (or PHP script, or JDBC code) is using the old password format.
See: http://dev.mysql.com/doc/mysql/en/Ap...sword_use.html

This means your teamspeak db is now storing passwords in the old format.
Teamspeak2 needs this to work, it has nothing to do with this hack.

I am quite sure this will work for you.

I followed that and got the correct mysql output from the command prompt.

The passwords from the hack are still stored in plain text though and this means they don't connect to the server. I have the following in the database :

tscreateduser - password : 1d427ce2b82bc4e30b2012c6f6df2e6a (tsuser in plain text)
gteamspeakuser - password : tsuser ( stored in plain text )

I'm going to look today at how I might change the PHP to incorporate the new MySQL 5 hashing of passwords.

There is an option to turn the hashing off. If I am correct its "--disable-hash" but I am not using MySQL 5 and cannot say how this works for a single db.
You can try to check this db with phpMyAdmin and see if you have an option there to turn hashing off.
phpMyAdmin often surprises me which such things :-)

I have done the opposite :) I went into phpMyAdmin and used the MD5 function on a plain text password to create a hashed pass. This then works fine. Now to get it to do this automatically with all passwords :)

EDIT:

OK, what I've done is edit gteamspeak.php, Line 98 (password updates) to read
and line 114 (initial user setup) to read

so that passwords are MD5 encrypted and sent to the DB. This works but the password is displayed as an MD5 string in the password box and the info page lists the password as the MD5 string. Also the Connect/Quick Connect links don't work as the password is called by the product in plain text.

I can live with this for now as I'll just comment out the references and display some text instead and delete the connect links.

I'll work on this further if anyone else wants these features to work.

I'm confused...can I not use this mod if I have a teamspeak server setup somewhere like www.defconservers.com ? I'd really like to incorporate my teamspeak server into my forums if at all possible.

Is the following plugin possible ?

via cron : Check if the teamspeak-user has a forumaccount, if not: ban from the ts ?

Thank you!

Any chance to see channel editor?

Could somebody give me directions on how to move the "Current gTeamSpeak Users:" box under the navbar, even if it's a second one.

if i get this does that mean people still have to download teamspeak in order to work it?

Yes, they still have to download TeamSpeak.

thank"s man good jop nice

I've having the problem that when I enter the password into gteamspeak.php and press go, nothing actually happens. It just loads the page again.

I checked the MySQL database and the user is not inserted. It works fine when adding users through the TeamSpeak web interface.

I'm using PHP5 & MySQL 5

Sadly I can't install this mod, because the change to MySQL isn't working. The options are installing MySQL v3.x somewhere *yuck* or just waiting till TS3 comes out and hope you'll support that too (which is what I will do). :)

[high]* Kagemaru subscribes to thread[/high]

isnt there an instruction txt file so its easier for us to install?

Getting this error.

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT * FROM ts2_clients WHERE s_client_name = 'chad.3' AND i_client_server_id = '1';

MySQL Error : Table 'admin***_vbulletin.ts2_clients' doesn't exist
Error Number : 1146
Request Date : Monday, July 14th 2008 @ 01:33:18 PM
Error Date : Monday, July 14th 2008 @ 01:33:18 PM
Script : http://www.talkjesus.com/gteamspeak.php
Referrer :
IP Address : xxxxx
Username : Chad
Classname : vB_Database
MySQL Version : 5.0.xxxxx-community


My server.ini is:

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=*****
Hostname=localhost
User_name=*****
Password=*****
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1


The actual new database I created does have the inserted, newly created 6 tables as well. The teamspeak server did start up without errors also.


Maybe this part is my problem:

Enter in the server ID assigned to the server. This can be found in the TeamSpeak database.

Exactly where is this found "in the database"? Is there referring to PID for TS process or something else?

I'm getting the below error when attempting to connect to my TS:

However, the TS server is running

In the firewall, I have these enabled

TCP_IN = 8767,51234,14534
TCP_OUT = 8767,51234,14534

I tried the main server IP and even the IP that the domain is hosted on.

For http port, I also tried 80 default. I have no idea what goes in "server id" anyway

root@server [/home/teamspeak/tss2_rc2]# netstat -nap | grep -i "teamspeak"
root@server [/home/teamspeak/tss2_rc2]# netstat -nap | grep -i "ts"
I've tried so many variations.

the server IP is its own default main IP 147.202.66.2

The domain (vbulletin forum) is on the same server, but a different IP of 147.202.66.3

I tried port 5472 enabled in the firewall tcp in and out