YaTQA - Query Admin Tool

[numma_cway]

Introduction

Here it is, the first version of my own admin tool, called YaTQA. Although it stands for Yet another TeamSpeak³ Query App, I hope it's not just another, but a very good one. It supports almost every feature of the query interface.


Download

DOWNLOAD from addons.teamspeak.com (around 1 MiB)

The downloaded file will ask you which version you like (German or English, current or 1.0.1). You can also enable the portable mode and select desktop and start menu shortcuts. It does not modify your system in any way, it just unpacks what you like and creates shortcuts if you want. You can also unpack that file with 7-Zip and stuff. If not in portable mode, YaTQA creates a settings file in your AppData folder.

You can find a German description and the complete English changelog of the tool on my website. The site also lists features that are planned or implemented in unreleased future versions (marked as TBA on the site).


Screenshots

See the addons website for more screenshots.

Ports on the screenshots were changed.


Feature overview

• Quick connect and list of server bookmarks
• Instance stats and settings
• List and create virtual servers
• Send a message of everyone on the instance
• Change your login and display name
• Server snapshots
• Vrtual server details, stats and settings
• List, delete and add bans
• List and delete complaints
• Channel/user tree
• Move, kick and ban users (even more than one at the same time)
• Move and modify channels
• Change client icons
• List, upload/download, move (even to other channels) and delete files and even folder/file structures
• List, delete, ban, search and (to some degree) edit database users
• Full-featured permission editor
• Revolutionary editable permission overview
• Client channel groups
• List, delete and use tokens
• List, add and delete temp passwords
• List and add log entries
• Read and send offline messages
• List running file transfers
• List and correlate avatars
• Manage icons

Detailed feature list

The program has 11 tabs of three categories: The first one is the general login tab. If you log in, the three instance tabs are shown. You can choose a virtual server on the second tab of these, which will show you seven tabs with the virtual server features.

• Tab 0: Start
  
  • Login
  • Server bookmarks
  
  
• Tab 1: Statistics
  
  • Instance info
  • Connection info
  • Version info
  • Some basic settings
  
  
• Tab 2: Servers
  
  • Server list
  • Start/stop servers
  • Select a server to show the virtual server tabs
  • Rename servers
  • Create a server
  
  
• Tab 3: Miscellaneous
  
  • Send a message to all clients on all virtual servers
  • Information on your identity
  • Change login name (=generate new password)
  • Snapshots
  • Permission reset
  
  
• Tab 4: Statistics
  
  • Basic information
  • Basic settings (name, port, ...)
  • Connection info
  
  
• Tab 5: Advanced
  
  • Virtual server configuration
  
  
• Tab 6: Bans etc.
  
  • Bans
    
    • Ban list
    • Delete bans
    • Add bans
    
    
  • Complaints
    
    • Complaint list
    • Delete complaints
    • Ban people
    
    
  
  
• Tab 7: Users
  
  • Channel and user list
  • Edit channels and users
  • Move channels and users (you can move multiple users at the same time)
  • View files
  • Move files (you can move files to a different channel as well)
  • Upload and download files (YaTQA also supports processing of folder structures)
  • Send messages
  
  
• Tab 8: User DB
  
  • View user database
  • Delete user details
  • Ban user
  • Open this user in the permission tab
  • Find users
  • Edit description
  
  
• Tab 9: Permissions
  
  • Permission editor like the official client's advanced permission view
  • Permission overview with direct editing
  • View a user's channel groups
  • Display created tokens
  
  
• Tab 10: Miscellaneous
  
  • Log
    
    • View log
    • Add custom entries to log
    
    
  • Messages
    
    • Read offline messages
    • Write offline messsages
    • Send a message to all clients on the virtual server
    
    
  • Running File Transfers
    
    • View running file transfers
    
    
  • Avatars
    
    • Display a list of avatars that are stored on the server
    • View and download avatars
    • Display an avatar's owner
    
    
  • Icons
    
    • Display a list of icons on the server
    • Upload icons (if you upload the same icon with YaTQA and the official client, it will have the identical name)
    • Download icons on your computer
    • Replace icons while keeping the name (not recommended)
    
    
  
  

Other notable features:

• Almost all lists support multi-select. For example, you can select some servers (press Ctrl) and click stop to stop them all. While almost all lists support this, not every feature for working with the list does. For example, you can select more than one server and stop them all at once, but you can only edit one server at a time.
• In the users tab, the tool supports drag and drop in many variations. Select multiple files and drop them on another channel to move them there. You can also create folders and move files to a different folder. If you want to move users, you can select any users from all over the server and move them to a certain channel with only one drag and drop action.
• The tool supports WYSIWYG BBCode editing. Most features that are supported by TS are also supported here, but images and URLs are displayed as source code for easier editing. Feel free to paste content from applications like Microsoft Word into a BBcode text box. BBCode features supported by the WYSIWYG editor are: b, i, u, size={1-7}, color={#abc|#abcdef|1 of 657 possible names}, left, center, right

Background

The program is written in Delphi (that's the language that was used to create TS2). Since YaTQA makes a lot of use from Unicode, Delphi 2009 was used. YaTQA uses only the default Delphi and Indy components, everything else is written by me, except for a bugfix on uppercase Umlaut characters that I found on some forum.
The program uses my own query engine (RedeemerTS3) based on Indy Telnet. If you want it, contact me via PM. It currently has 186 functions (including defined overloads, excluding overloads by optional parameters) and is missing only 5 features from the query interface (help, servernotifyregister, servernotifyunregister, ftinitupload, ftinitdownload), because they don't fit in the application's concept.
The tool also uses my own WYSIWYG BBCode engine (BBCodeUtils). It supports displaying the tags b, i, u, color, size, left, center and right. img and url tags are displayed as source code. You can also pm me if you want it.
Most images in the tool are from IconEden.com, but I licensed them from Axialis for royalty-free use, so the author is not given credit in the tool itself.


Development

Call to Delphi developers: I have basically finished my development on the tool since it's nearly complete (I said that when I released 1.0.0 and we're at 1.3.3.x now...). If you want to further improve it and own Delphi 2009 or newer (and are able to use it), just PM me your visions and you will be given the full source code, graphics, spreadsheets, development tools, etc.


FAQs

How do I get my query credentials?
You can find several ways of doing this here.

How do I delete unused channels?
You don’t, as there is simply no way to do this offered by TeamSpeak. As everyone knows, YaTQA supports EVERY ACTIVE FEATURE of the query interface, so if there is no such feature, it is simply impossible.
The only way to do this is to have a bot running on your server all the time. I’m totally pissed off by people asking me this questions again and again as they fail to get that other channel watcher running, so I wrote this program (documentation and output is in German only). Be happy if it works, but don’t dare to ask ANY quetions about it.

I get disconnected and can't connect for some time!
The program sends a query when you switch to most tabs to fill it with information. This might be too much, depending on your configuration. Please change “Befehle bis Flood” (DE) / “Commands to flood“ (EN) to around 20. You find it right after connecting. Newer versions will prompt you to change this.

Why does it say “Connection refused” all the time?
There might be a reason why the input box says “query port” and not “voice port”.

Why does it say “version lookup failed” or “missing permissions”?
YaTQA is made to be Admin Server Query, the group of the default “serveradmin” account. If you broke your permissions, got hacked or simply run YaTQA with limited permissions, you will be shown error messages.
Running YaTQA with limited permissions is not officially supported.

Does YaTQA work with Wine?
It does, but it has memory leaks, because Wine does not support removing link labels from memory. Wine support was initially added in 1.3.3.2 and finished in 1.3.3.5.
Memory leaks cause that if you switch servers very often without closing the tool in the meanwhile, it will will need more and more memory. If you don't do that, it's alright.
Starting with version 1.3.3.7, YaTQA uses another control class to display the buttons in the permissions tab. This turned out to be not supported by Wine. You can download that last version with the old interface here.

I can't create new servers!
Please make sure you obtained and installed a non-profit license.

Can I run YaTQA directly on my Windows Server?
Multiple people have reported that YaTQA does not run on Windows Server operation systems, at least it's unable to connect to localhost. I have no idea why this happens, but might look into it at a later time.

How does one pronounce YaTQA?
It's pronounced [jatka] in IPA notation. This notation is also suitable for German speakers.

My antivirus does not like YaTQA.
YaTQA is made with Delphi. It is a popular programming language because the applications made with it run on every Windows computer without any requirements. Thus, all Delphi applications include some common code required to run on all the Windows computers. Creators of bad malware detection software might have taken way too common parts of the code to identify some viruses made in Delphi.
Examples:
In June 2012, only Kasperky started to find different viruses (of a class of more than 100.000) in all versions of YaTQA, even in the old 1.0.x versions from 2011, which does not seem too serious to me.
Several programs detected a virus in Version 1.2.x, but stopped detecting Version 1.3.x, most likely because 1.2.x had only a very basic file transfer engine which got more sophisticated in 1.3.x.

Can I download development snapshots?
Yes, you can download a German development snapshot here. I can't take any responsibility for that, just like I can't for any other version. Since the translation is created when a new version is ready, you cannot download an English development version.

Is there a 64-bit version?
There is none right now. I can, however, create a German one if someone needs one. Since the translation is built by several tools that do not support 64-bit executables, there is no way to create an English 64-bit version right now.

Why can’t I set certain permissions even if I have b_permission_modify_power_ignore?
Because that permission doesn’t work thanks to the buggy TS3 server software. You can find a detailed list of permissions affected by this bug on my website (in German).
If that happens, copy your Admin Server Query group a new non-query non-template server group with a certain i_group_auto_update_type (for security reason, the value must not be divisible by 5). Add your normal voice account to that group and assign the needed permissions via the Automatic Groups feature in YaTQA. Now use your voice client to assign these permissions to the Admin Server Query group.

Is there a version in language X?
A user started working on a French version, but there’s no ETA.


That's it. I hope you like it. I'm looking forward to your comments.

[creativeteamspeak]

I love this tool!, very good interface, please translate it in English A.S.P. You can contact me if you need any help with the translation

[numma_cway]

I evaluated the work that needs to be done to translate the tool. It's not that much, so you can expect an English version this month, when the user/channel feature is added. I also want to add a token list.
After that, the tool will be either 0.3 beta or 1.0 final, which depends on how much I think has to be added to make it exactly what I wanted it to be.

I just released v0.2 alpha (but forgot to update the version number, so it's still displayed as 0.1).

• All permission features are now available.
• All images were moved to resource files, which reduced the size of the application by 70 KiB. Anyway, due to the massive addition of functionallity, it got 30 KiB bigger.
• Changed the icon of “deploy running“ to be more emanticipated.
• The titlebar now shows the selected instance and virtual server, but in a shorter form than the while areas on the top.
• The Query Engine was extended in many ways, yet it's not complete.
• You can create tokens now.
• I added a list of a client's groups in the channels of a server. This feature is currently read-only. But you can rename channels there.
• Changed the Unescape function to a new one, since the previous could - in some rare cases - use an escaped backslash to unescape the character after it.
• The input window did not accept negative numbers when in numbers only mode and did not check the input when in float mode. Additionally, there was a problem with the format of floats, which was set to your local format, but in the previous version, it had to be in English, when you wanted to change it. You now have to enter floats in your local format.
• You can't edit the permission names and thereby break the edit feature for a short time feature.

[Nicocaps]

Pretty tool, please translate it to English ASAP. Im a spanish customer, if you need help to translate to spanish let me know i will help you !!!

[numma_cway]

Version 1.0.0 rc1 is out now.
It took a while since the last version, that's because I decided to skip the beta phase entirely and head over directly to the release candidate, which has all the intended features (though I might add a snapshot feature).

Now, I'll start translating the tool into English. After that, we can talk about other languages.

Changes made in this release:

• Fixed a bug that prevented users from editing guest groups
• Added a token list
• Completed the underlying RedeemerTS3 query engine
• Fixed a bug that showed an error message when doubleclicking in an empty area of the premission list
• Added prefixes to the group lists
• Icon IDs must be in Integer range when editing permissions and working with client info (DWord is not allowed). When working with server information, the IDs are retrieved as Integers, but must be set as DWord. The numbers displayed in the icon upload dialog's hints are always DWords, so YaTQA also displays them as DWords.
• You can no longer doubleclick a permission's name (instead of the last columns which are supposed to be doubleclicked in order to change them), which did not cause a change, but send stuff to the server.
• Added kick features to the complain list
• Expanded and improved hint texts all over the application
• Made several improvements to the permission editor (e.g. added default buttons, so you can use Enter)
• Groups can now be added, removed, copied and renamed
• You can now log out by trying to change the account to one with no name or password. This already worked before, but lead to an error.
• Changed the editor for multi-line settings like the welcome message to one that supports multi-line text
• Fixed a bug that prevented the client channel group list from displaying memberships in the last group
• Fixed a bug that prevented users from properly giving channel group permissions
• Fixed a bug that prevented the two permission filter features from being available while editing Channel Groups
• Fixed a bug that prevented the application from unescaping the last character of a string
• Fixed a bug that caused the application to also use the month file traffic stats for the total traffic stats (instead of the real total stats)
• Fixed an interface flaw resulting from that
• Fixed a bug that caused a name inconsistency after editing channel names in the client channel group overview
• Added a running file transfer list
• Added a server view with user and channel details
• Added a channel file list, which can be found in the server view (“Users” tab)
• The server view heavily features multiselect and drag'n'drop, e.g. you can drag some files and directories from a channel's file list and drop it on another channel to move it there
• Displayed permissions are now consistent, even when using the filter features
• Fixed a channel view indent bug that also affected the client channel group list

[yas437]

crashes after entering login credentials.

Beschreibung:
Aufgrund eines Problems kann dieses Programm nicht mehr mit Windows kommunizieren.

Problemsignatur:
Problemereignisname: AppHangB1
Anwendungsname: yatqa.exe
Anwendungsversion: 1.0.0.0
Anwendungszeitstempel: 4e30b076
Absturzsignatur: e57c
Absturztyp: 0
Betriebsystemversion: 6.0.6002.2.2.0.1296.17
Gebietsschema-ID: 1031
Zusätzliche Absturzsignatur 1: a5e9669e1117d33c57f62f1a5e9cc250
Zusätzliche Absturzsignatur 2: 53ba
Zusätzliche Absturzsignatur 3: 09a1004a2cb56ca9cfa8813022ba766f
Zusätzliche Absturzsignatur 4: e57c
Zusätzliche Absturzsignatur 5: a5e9669e1117d33c57f62f1a5e9cc250
Zusätzliche Absturzsignatur 6: 53ba
Zusätzliche Absturzsignatur 7: 09a1004a2cb56ca9cfa8813022ba766f

running on windows server 2008 powered by strato(its a vps)
I already added 2 servers with another admin tool some time ago. could this be the issue?

Edit: FIXED. the issue was clearly sitting in front of the computer. I falsely ran the tool on the server itself.
thanks a lot to the author numma_cway for assisting me.
works like a charm. highly recommended!

[numma_cway]

While helping yas437 and while normally working with the tool, I found some bugs and fixed them. The version is now 1.0.0 rc1b. Following changes were made:

• Fixed a bug that prevented users from copying groups over existing ones.
• Fixed a bug that displayed an incorrect codec bitrate at 620 and 640 ms latency.
• Fixed a bug that prevented the titlebar from displaying the actual server adress.

Additionally, I updated the opening post of this thread.

[yiso91]

I tested the tool on my local server and although I don't know German .. but I can tell this is the finest tool available on the library so far. I hope the English version come out soon, because I can't wait

[Ahmed]

ENGLISH please its nice tool but idk German

[numma_cway]

Final version is out now. Still in German only, but now I've got enough time to start translating. It brings you a bookmark manager for your servers and the ability to create and deploy snapshots (I did not test that a lot) among a huge number of bug fixes.

Here's the complete changelog:

• Updated the permissions SIDs to server version 3.0.0
• Fixed the BBCodeUtils to reset formatting (but it seems like it was not necessary to do that)
• Added scroll bars to RichEdit boxes
• Added ability to create and deploy snapshots, as well as reset the permission groups
• Changed the Flag of Libya (LY) from the Flag of the Libyan Arab Jamahiriya to the Flag of the National Transitional Council
• Fixed a bug that raised an error when editing existing BBCode texts
• Removed the Flag of the United Kingdom (UK), because GeoIP returns Great Britain (GB) instead (the flag was already included before, but twice)
• Removed the Flag of Serbia and Montenegro (CS), because the state does no longer exist and is not a possible result of GeoIP
• Added the missing flags for the following possible results of GeoIP: Anonymous Proxy (A1), Satellite Provider (A2), Asia/Pacific Region (AP), Antarctica (AQ), Saint Barthelemy (BL), Europe (EU), Metropolitan France (FX), Guernsey (GG), Isle of Man (IM), Jersey (JE), Saint Martin (MF), Other (O1).
• Fixed a bug in the BBCode decoder caused by strange behavior of the Windows Rich Edit control (it removes the text formating, but only some of them and only in some rare cases)
• Fixed a bug related to virtual server quota
• Fixed a bug that prevented the Vista icon from displaying correctly, because it was declared a 21060-bit icon
• Added more binary prefixes to keep numbers shorter
• Consilidated the code that is used to display values
• Linked the small icon in the bottom right to my homepage
• Cleaned up code
• Added string display limits
• Changed the name the channel save mode property, because it was saying exactly the opposite of what it was wanted to
• Fixed a bug that broke the chat feature in the user tab
• Fixed a bug that prevented ampersands from displaying correctly
• Fixed a bug that lead to errors when using some characters, e.g. the Eszett ligature
• Fixed a spelling mistake in the client details
• Fixed a small display flaw in the channel details
• Changed the localtion of yatqa.ini from the application's directory to %APPDATA%\YaTQA
• Fixed the text limits for the top bar (in the first concept, there were four buttons in the second button group, but it soon got decreased to the today's three)
• Improved some texts
• Added the logo to the start screen
• Added a bookmark manager
• The stuff stored in yatqa.ini is now encoded. I merely did not do that to prevent data theft but because Delphi doesn't allow me to store Unicode in INIs.

[Ahmed]

wow all these fixes and features .. cant wait for the English translation .. please hurry xD

[numma_cway]

It's done since 24 hours. Just needs to be reviewed by the mods.

[Ahmed]

great job man really great job thank you for your time

[R. Ludwig]

just tested this and i can only say GREAT JOB mate!

[JoshuaK]

Your tool is amazing! It Pretty much saved my server when I had to do backups.