Get the current servers from server.dbs and check if running, etc. …

listservers.sh

#!/bin/bash
# Get the current servers from server.dbs and check if running, etc.
# You need sqlite 2 to use this.
 
# 2009 Natenom - natenom@natenom.com
 
# Example
# Status|ID|Slots|Port(<)|Passwort|Name
# ----------------------------------
# [ ]  1|100|8767||Server0
# [ ]  2|100|8768|onlymembers|Server2
# [ ]  3|100|8769||Blueserver
# [ ]  4|100|8760|lalapw|Yellowserver
# 
# Slots at all: 400
 
 
IFS=$'\n';
echo "Status|ID|Slots|Port(<)|Passwort|Name"
echo "----------------------------------"
for server in $(sqlite server.dbs "select i_server_id,i_server_maxusers,i_server_udpport,s_server_password,s_server_name from ts2_servers ORDER BY i_server_udpport;"); do netstat -tulpen 2>/dev/null| grep "$(echo $server | cut -d'|' -f 3)"  &>/dev/null && echo '[x] ' $server || echo '[ ] ' $server; done
 
 
GES=0; for i in $(sqlite server.dbs "select i_server_maxusers from ts2_servers;"); do GES=$(($GES+$i)); done;
echo -e "\nSlots at all: $GES\n"

Secure your server and check your SA passwords …

sapw.sh

#!/bin/bash
# To make your server more secure, you should check passwords of your SA Users.
# You need sqlite 2 to use this.
 
# 2009 Natenom - natenom@natenom.com
 
# Example:
# ServerID|PlayerID|Login|Passwort
# 0|3332|AdminYZ|badpw
# 1|3981|Admin8|badpw2
# 1|3981|AdminX|lkuadrf23
# 2|4421|Admin9|lala
 
echo "ServerID|PlayerID|Login|Password"
sqlite server.dbs "select i_client_server_id,i_client_id,s_client_name,s_client_password from ts2_clients where b_client_privilege_serveradmin=-1 ORDER BY i_client_server_id,i_client_id ASC;"