Forum

Results 1 to 15 of 15
  1. #1
    Join Date
    December 2009
    Location
    Germany
    Posts
    226

    Teamspeak3 Statistics

    Hi,

    I hacked together a php script to create some statistics from TS3. If you are interested in the result, check http://ts.dark-phönix.de/ts3stats/. You can chose a time range by clicking on the dates.

    Has someone use for this? If so, I would try to clean it up and release it here. The script directly connects to the database (atm SQLite, but MySQL shouldn't be any problem at all) and reads the data from the log table. (So you need to deactivate pruning of old log entries if you want data for more than 90 days)

    ATM the dates are a bit screwed, because the timestamps are in GMT, but it's enough for a proof of concept.
    Last edited by Baraan; July 22nd, 2010 at 10:11 AM.

  2. #2
    Join Date
    December 2009
    Location
    Germany
    Posts
    62
    thats cool....

    i'd like to get the script...

  3. #3
    Join Date
    November 2008
    Location
    United States
    Posts
    1,719
    That is a pretty nifty thing you got going. I wouldn't personally use it, but i can see the use.

  4. #4
    Join Date
    December 2009
    Location
    Germany
    Posts
    62
    This is very cool.
    Can you give us the Script?

  5. #5
    Join Date
    January 2010
    Location
    Netherlands
    Posts
    76
    Wow.
    That's looking great man. please release the script

  6. #6
    Join Date
    December 2009
    Location
    Germany
    Posts
    226
    I will need some time to clean it up, but I'll hope to release it in a couple of days.

  7. #7
    Join Date
    June 2010
    Location
    Paris
    Posts
    3
    have you got some news or not ?

  8. #8
    Join Date
    December 2009
    Location
    Germany
    Posts
    226
    Fair enough. I hadn't had much time for this and sadly the whole date issue isn't nicely solved in php IMHO. The times might be a bit off, because the logs are all in GMT, if someone wants to fix that, feel free, I licensed it under the GPL. Also, but not that important, it would be nice to see the actual partial online times in the last two graphs.

    Well, if anyone has use for it in its current state, there you go:
    (Edit: And before you say something: There is nothing nice about that code. )

    Edit2: removed the attachement
    Last edited by Baraan; August 8th, 2010 at 06:23 PM.

  9. #9
    Join Date
    January 2010
    Location
    US
    Posts
    133
    Hey, I just grabbed this, have some issues.

    #1, there an extra */ in the index.php file that'll throw errors.

    #2, where do I set my config data at?

    #3, Your demo link doesn't work.

    #4, I hope sqlite works on my host, but that's hardly your problem. =)

  10. #10
    Join Date
    January 2010
    Location
    US
    Posts
    133
    I also found this in the index.php, how do I figure out what I need to set it to on my server? I checking PHPInfo, but... didn't find anything that seemed to fit.

    Code:
    $sqlite_path = '/opt/teamspeak3-server_linux-x86/ts3server.sqlitedb';

  11. #11
    Join Date
    December 2009
    Location
    Pitt
    Posts
    103
    Put it on my server. changed the $sqlite_path to the sqlitedb on the server.

    Get nothing but a blank page.

  12. #12
    Join Date
    January 2010
    Location
    Switzerland
    Posts
    6
    Thanks for the script, works like a charm on my debian unstable distribution with php 5.3.2 and teamspeak sqlite database.

  13. #13
    Join Date
    August 2007
    Location
    Berlin
    Posts
    12
    Quote Originally Posted by Soljia View Post
    Put it on my server. changed the $sqlite_path to the sqlitedb on the server.

    Get nothing but a blank page.
    same here, get only a blank page

  14. #14
    Join Date
    December 2009
    Location
    Germany
    Posts
    226
    I removed the attachement. Seemed like too many ppl aren't able to read my posts. This isn't releas quality software, thats a script I hacked together in a long afternoon. It needs work and if you cannot modify it to your needs, you shouldn't be using it.

  15. #15
    Join Date
    December 2009
    Location
    Pitt
    Posts
    103
    Quote Originally Posted by Baraan View Post
    I removed the attachement. Seemed like too many ppl aren't able to read my posts. This isn't releas quality software, thats a script I hacked together in a long afternoon. It needs work and if you cannot modify it to your needs, you shouldn't be using it.
    Sounds a bit harsh, but it's your code.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Poke Statistics
    By SunBakedMike in forum General Questions
    Replies: 1
    Last Post: June 24th, 2011, 08:53 AM
  2. Statistics
    By Thran in forum Windows
    Replies: 4
    Last Post: June 18th, 2010, 08:44 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •