Hallo,
mit Hilfe des ServerQuery Befehls "clientlist" kannst du dir die Liste aller vorhandenen Clients anzeigen lassen, die aktuell online sind. Hier musst du dann für jeden Client dann prüfen, welchen "created" Wert er hat.
Zitat
clientinfo clid=1
cid=1 client_idle_time=7632 client_unique_identifier=serveradmin client_nickname=serveradmin\sfrom\s10.40.0.10:43307 client_version=ServerQuery client_platform=ServerQuery client_input_muted=0 client_output_muted=0 client_outputonly_muted=0 client_input_hardware=0 client_output_hardware=0 client_default_channel client_meta_data client_is_recording=0 client_version_sign client_security_hash client_login_name client_database_id=1 client_channel_group_id=8 client_servergroups=2 client_created=0 client_lastconnected=0 client_totalconnections=0 client_away=0 client_away_message client_type=1 client_flag_avatar client_talk_power=0 client_talk_request=0 client_talk_request_msg client_description client_is_talker=0 client_month_bytes_uploaded=0 client_month_bytes_downloaded=0 client_total_bytes_uploaded=0 client_total_bytes_downloaded=0 client_is_priority_speaker=0 client_unread_messages=0 client_nickname_phonetic client_needed_serverquery_view_power=100 client_default_token client_icon_id=0 client_is_channel_commander=0 client_country client_channel_group_inherited_channel_id=1 client_badges client_base64HashClientUID connection_filetransfer_bandwidth_sent=0 connection_filetransfer_bandwidth_received=0 connection_filetransfer_bandwidth_sent=0 connection_filetransfer_bandwidth_received=0 connection_packets_sent_total=0 connection_bytes_sent_total=0 connection_packets_received_total=0 connection_bytes_received_total=0 connection_bandwidth_sent_last_second_total=0 connection_bandwidth_sent_last_minute_total=0 connection_bandwidth_received_last_second_total=0 connection_bandwidth_received_last_minute_total=0 connection_connected_time=0 connection_client_ip
Info: Das ist ein ServerQuery, daher hat er den mir nicht erklärbaren Wert "0".
Eine andere Möglichkeit wäre die "clientdblist". Die liefert dir alle Clients zurück, die bereits auf deinem Server waren - egal ob on- oder offline:
Zitat
clientdblist
cldbid=2 client_unique_identifier=A1vqlVfj55RN5UbESxZ7n+c4DUs= client_nickname=Sebbo1 client_created=1428082249 client_lastconnected=1428428569 client_totalconnections=4 client_description client_lastip=217.225.97.229|cldbid=3 client_unique_identifier=ServerQuery client_nickname=ServerQuery\sGuest client_created=1428082531 client_lastconnected=1428082531 client_totalconnections=0 client_description client_lastip
Das ganze kannst du dir natürlich auch in der Datenbank ausgeben lassen:
mysql> SELECT * FROM client_properties WHERE ident="client_created";
Zitat
+-----------+------+----------------+------------+
| server_id | id | ident | value |
+-----------+------+----------------+------------+
| 2 | 13 | client_created | 1403253130 |
| 3 | 21 | client_created | 1403364357 |
| 3 | 22 | client_created | 1403386605 |
| 3 | 31 | client_created | 1403462403 |
| 3 | 14 | client_created | 1403284174 |
| 2 | 37 | client_created | 1403624900 |
| 2 | 38 | client_created | 1403635562 |
| 2 | 41 | client_created | 1403708387 |
| 2 | 26 | client_created | 1403430189 |
| 2 | 42 | client_created | 1403719485 |
| 2 | 34 | client_created | 1403599964 |
| 2 | 47 | client_created | 1403785458 |
| 2 | 48 | client_created | 1403794272 |
| 77 | 4240 | client_created | 1428418267 |
| 77 | 4241 | client_created | 1428418533 |
| 1 | 4242 | client_created | 1428421452 |
| 1 | 4243 | client_created | 1428421472 |
| 1 | 4244 | client_created | 1428421499 |
| 114 | 4245 | client_created | 1428426575 |
| 114 | 4246 | client_created | 1428426575 |
[...]
| 85 | 2119 | client_created | 1421300137 |
| 85 | 3250 | client_created | 1425316072 |
| 85 | 2135 | client_created | 1421351422 |
| 2 | 27 | client_created | 1403430795 |
+-----------+------+----------------+------------+
2809 rows in set (0.00 sec)
Alles anzeigen
// EDIT: Um ein Wort verlesen, daher Inhalt angepasst.