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?