Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
gTeamSpeak - TeamSpeak User Management Details »
gTeamSpeak - TeamSpeak User Management
Mod Version: 3.31, by Gryphon (Coder) Gryphon is offline
Developer Last Online: Sep 2018 I like it Show Printable Version Email this Page

vB Version: 3.7.x Rating: (18 votes - 4.33 average) Installs: 182
Released: 26 Jul 2006 Last Update: 30 Oct 2008 Downloads: 1750
Supported DB Changes Uses Plugins Template Edits Auto-Template Additional Files External Content  

What is it?

gTeamSpeak* is a addon for vBulletin which allows your choice of usergroups to register for a TeamSpeak server. It creates a system in which you can link TeamSpeak users to a forum user accounts.

If you use this mod, please Mark as Installed, and if you really enjoy this mod, please Nominate for MOTM, and if you really really enjoy this mod, feel free to Support Developer! Thank you!

You can find more information about TeamSpeak at http://www.teamspeak.com. You should have good knowledge about running your own TeamSpeak server prior to using the mod.

* gTeamSpeak was previously known as vBTeamSpeak.


Support

I use my released mods daily, if I find an issue with them or add features for myself I will release updates. If there are significant bugs or simple feature requests I will do my best to release fixes. Some of my mods rely on fetching data from 3rd party websites, due to the unreliable results, my mods will require users to troubleshoot for themselves if they find the addon is not working for them specifically. I am offering my personal mods that work ok for me for you to use, I am sorry I do not have time to troubleshoot many user specific issues. Thank you for your understanding.

Features

  • Optionally connect to a remote TeamSpeak database you have administrative control over if TeamSpeak is not hosted on the same db as your vBulletin.
  • Optionally automatically add links to navbar and quick launch menu.
  • Choose what usergroups get SA by default.
  • Choose what usergroups can access the sign up form.
  • Limit access by days registered.
  • Limit access by user post count.
  • Promote/Demote SA.
  • Delete user accounts.
  • Ban users from creating accounts.
  • Send broadcast message to server.
  • Send text message to a user.
  • Prune inactive users.
  • Display who is online on forum home.
  • Cron checks vBulletin ban list every 10 minutes and bans users from TeamSpeak accordingly.
  • Plugins: People can write their own feature plugins for doing things like banning, kicking, messaging users etc...

Support


I will offer limited setup/installation support this script. While I do use the Remote Server option personally, I will not support this feature, you should have advanced knowledge of your server setup and troubleshoot this yourself. If you have purchased TeamSpeak hosting from a voice comm service provider, it is highly unlikely they will grant you database access. For best results and performance, have your TeamSpeak server use your vBulletin database as it's database.

1. Setup TeamSpeak to use mySQL

By default TeamSpeak uses a file system called SQLite. To make it use a mySQL database edit the server.ini and add:
[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=database_name
Hostname=localhost
User_name=database_username
Password=database_password
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1
When you start the server it will create all the necessary tables:
  • ts2_bans
  • ts2_channels
  • ts2_channel_privileges
  • ts2_clients
  • ts2_servers
  • ts2_server_privileges
Make sure these tables exist and that your TeamSpeak server is actively using your mySQL database properly before even downloading the gTeamSpeak modification.

For more information about setting TeamSpeak up to use a mySQL database visit http://www.teamspeak.com.

2. gTeamSpeak Installation

  1. Make sure that your TeamSpeak server is setup to use a mySQL database prior to installing this product. For best results prevent users and admins ability to register with the server via client. Also password the server to something gibberish as you will not be supplying the password to anyone. Also disable the ability for SA to grant SA for security.
  2. Upload all files prior to installing product.
  3. Install the product.
  4. Create a Single-Selection Menu User Profile Field.
    • /admincp/?loc=profilefield.php%3Fdo%3Dadd
    • Single-Selection Menu
    • Continue
    • Title: TeamSpeak Access
    • Description: Can register self with TeamSpeak server.
    • Options:
      • yes
      • no
    • Set Default: Yes, but No First Blank Option
    • Field Required: No
    • Field Editable by User: No
    • Private Field: Yes
    • Field Searchable on Members List: No
    • Show on Members List: No
    • Save
    • Look and see what the field name is for TeamSpeak Access, example field25.
  5. Fill in the gTeamSpeak configuration options.
  6. Install any plugins you wish to use from the /admincp/gtsplugin directory.
  7. That is all, send people to the form to sign up.
Note: You need to add your user id to the config.php under superadministrators. I will attempt to remove the need to require this in a future version.

TeamSpeak Access Profile Field Usage


This is used if you want to ban a user from TeamSpeak and do not want to ban them entirely from the forums or change their usergroup.
  • Set this profile option to No to prevent a user from creating a TeamSpeak account.
  • When a user is banned from the gTeamSpeak user management, this option is automatically set to No. If you wish to unban them, set this option to Yes and they will be able to create a TeamSpeak account again.

Changes


v3.31 - Upload files, Import product with Overwrite enabled
  • Fix Admin CP nav
  • Fix Whois online display

v3.29 - Upload files, Import product with Overwrite enabled
  • Non-essential style tweaks.

v3.27 - Import product with Overwrite enabled
  • Fix template cache

v3.24 - Import product with Overwrite enabled. Upload gteamspeak.php
  • Navbar links now use $template_hook introduced with vBulletin 3.6.6
  • Added option to limit access by days registered.
  • Added option to limit access by user post count.

v3.22 - Import product with Overwrite enabled.
  • Fixed typo in product file.
  • Release German translation by Trantor.

v3.21 - Import product with Overwrite enabled.
  • Fixed potential XSS vulnerability. Thanks Apophis.

v3.20 - Upload all files, import product with Overwrite enabled.
  • Fixed an error with enable/disable plugins.
  • Added option to display who's online on TeamSpeak signup form.

v3.10 - Upload all files, import product with Overwrite enabled.
  • Cron created to check for banned users and remove their TeamSpeak account.
  • Fixed some query statements.

v3.00 - v2.00 users no need to upgrade if you do not wish. If you do, vBTeamSpeak needs to be un-installed, and then follow fresh installation instructions. Your existing TeamSpeak user database will stay intact.
  • Initial Re-Release.
  • vBTeamSpeak re-branded gTeamSpeak.
  • Code clean up.
  • User Profile field now needs to be created manually.
  • Added a couple phrases.
  • Change templates slightly.

Hooks

  • I will consider hook requests.

Copyright

gTeamSpeak, Copyright Ryan Snook (www.gryphonllc.com)
Please do not redistribute this script without my consent. While updates may not be made to this product regularly, I still maintain it. If you have fixes, improvements or other additions to make to this mod, please contact me at rsnook@gmail.com for collaboration. I appreciate your consideration.

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	usercp.1.gif
Views:	6759
Size:	61.6 KB
ID:	51081   Click image for larger version

Name:	gts_options_1.jpg
Views:	2483
Size:	66.3 KB
ID:	61467   Click image for larger version

Name:	gts_options_2.jpg
Views:	1224
Size:	68.0 KB
ID:	61468   Click image for larger version

Name:	gts_options_3.jpg
Views:	1102
Size:	41.8 KB
ID:	61469  

Click image for larger version

Name:	gts_user_management.jpg
Views:	3172
Size:	231.8 KB
ID:	61470   Click image for larger version

Name:	gts_plugin_management.jpg
Views:	2128
Size:	44.2 KB
ID:	61471  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Administrative and Maintenance Tools Un-Activated User Management 3.1 sabret00the vBulletin 3.8 Add-ons 215 18 Nov 2012 09:33
Un-Activated User Management sabret00the vBulletin 3.0 Full Releases 204 02 Feb 2007 17:52

  #196  
Old 26 Nov 2007, 12:05
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Hi Iratus,

can you please do the following?
Empty the server.log file, start your server and try to manage it via this mod.
Wait for the error and then post the content of your server.log file here?

/jluerken
__________________
Ciao jluerken
Reply With Quote
  #197  
Old 26 Nov 2007, 16:01
Iratus Iratus is offline
 
Join Date: Jul 2006
It isn't erroring in the TS log, that's what's making me think that it's some type of PHP error, IE it's never getting as far as the SQL

---------------------------------------------------------------
-------------- log started at 26-11-07 10:44 -------------
---------------------------------------------------------------
26-11-07 10:44:23,ALL,Info,server, Server init initialized
26-11-07 10:44:23,ALL,Info,server, Server version: 2.0.24.1 Linux
26-11-07 10:44:24,ALL,Info,server, Starting VirtualServer id:1 with port:8767
26-11-07 10:44:24,ALL,Info,server, Started VirtualServer id:1 with port:8767
26-11-07 10:44:25,ALL,Info,server, Server init finished
26-11-07 10:44:25,WARNING,Info,server, TeamSpeak Server daemon activated
and just for congruity to show I'm hooking into sql properly

[Main Config]
BoundToIp1=
ExternalIPDectection=1
HTTPServer Port=14534
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=51234
AllowedClientNameChars=
DisAllowedClientNameChars=()[]{}

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

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL

[WebPost]
AdminEmail=na
ISPLinkURL=na
ISPName=Private
ISPCountryNumber=5317
Enabled=1
PostURL=
ListPublic=0
UserAgent=teamspeak

[log]
access_r=0
access_u=0
channel_registerred=0
channel_unregisterred=0
sa=0
chat=0
kick_server=0
kick_channel=0

[Spam]
max_commands=10
in_seconds=2
Just for reference

PHP Version 5.2.3
Apache 2.2.3
MySQL 5.0.27
(So typical of Linux that staying on top of security updates has screwed me )

I was taking Gryphons advice that he wouldn't support it to a seperate database so I could have a problem with the connection but as it uses the same login details as TS itself I can't see where the problem is. Shall I just try connecting it to my VBulletin Database and creating the tables there and see if that works? I was trying to avoid it because I'd have to do the password compatibility change on the VBulletin dba account.

Last edited by Iratus; 26 Nov 2007 at 16:15.
Reply With Quote
  #198  
Old 27 Nov 2007, 18:32
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
I am not positive of the differences in PHP 4/5 and MySQL 4/5 so unfortunately I can not help much in that regard. I am unsure why this would be happening and it will require that someone who does know help answer this and I will implement a possible compatibility fix if needed.
Reply With Quote
  #199  
Old 30 Nov 2007, 22:57
Brandje Brandje is offline
 
Join Date: Nov 2007
In installed this on my TS server that was allready running a Mysqldb, and it works like a charm! thanks for the great mod!

Ohw, and I am using php5/mysql5, and found no errors what so ever
Reply With Quote
  #200  
Old 03 Dec 2007, 22:36
xTerMn8R xTerMn8R is offline
 
Join Date: Mar 2004
Will this hack work if I'm connecting to MYSQL using dbxODBC instead of dbxmda which costs 70-150 bucks. My 30 days just ran out and I see on goteamspeak they have alternative methods of connecting TS to MySQL using odbc.

Thanks,
xTerMn8R
www.superskunkracing.org
Reply With Quote
  #201  
Old 04 Dec 2007, 04:02
xTerMn8R xTerMn8R is offline
 
Join Date: Mar 2004
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
Reply With Quote
  #202  
Old 10 Dec 2007, 08:20
xTerMn8R xTerMn8R is offline
 
Join Date: Mar 2004
Is there any way to change the Blue color to another color in the team speak Client background?

Thx
Reply With Quote
  #203  
Old 10 Dec 2007, 15:55
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
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.
Reply With Quote
  #204  
Old 10 Dec 2007, 16:23
xTerMn8R xTerMn8R is offline
 
Join Date: Mar 2004
Talking

Cool but I found the stylesheet and made the changes there... and it worked
Thx for the reply though ... ^5
Reply With Quote
  #205  
Old 10 Dec 2007, 16:52
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
Stylesheet? Hmm, I must not have followed what blue background you were requesting before.
Reply With Quote
  #206  
Old 26 Jan 2008, 22:34
Hawaiian-TV Hawaiian-TV is offline
 
Join Date: Sep 2007
Question gTeamspeak: "connection refused" error in AdminCP, who's online not working for me

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:

Array
(
[0] => Array
(
[cmd] =>
[rpl] => Connection refused
)
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
Reply With Quote
  #207  
Old 27 Jan 2008, 00:40
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
Originally Posted by Hawaiian-TV View Post
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?)
The defaults that are there are fine.

Originally Posted by Hawaiian-TV View Post
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.
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.

Originally Posted by Hawaiian-TV View Post
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. (?)
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.

Originally Posted by Hawaiian-TV View Post
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.
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.
Reply With Quote
  #208  
Old 03 Feb 2008, 11:52
TomJames TomJames is offline
 
Join Date: Apr 2006
Hey, just wondering if there is any reason this wouldn't show who's on?

Reply With Quote
  #209  
Old 03 Feb 2008, 22:31
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
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.
Reply With Quote
  #210  
Old 03 Feb 2008, 22:54
gdavis480's Avatar
gdavis480 gdavis480 is offline
 
Join Date: Oct 2006
how does this mod work? does the server and the site have to be on the same system?
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 04:05.

Layout Options | Width: Wide Color: