Notice to all users

We are migrating towards a new forum system located at, as such this forum will become read-only on January 29, 2020

Results 1 to 3 of 3
  1. #1
    Join Date
    January 2010
    Secret Base in Arctic Region

    Avatar/User Relation

    Hai Folks,

    can someone tell how Avatars are stored in the DB (looks like some checksum-hash) or is this a business secret?
    Reason is, many users on our servers use them, as intended, but when it comes to delete unused users or duplicates (due to the user re-installing TS or his OS) the files are left in "files/virtual_server<id>/internal" folder.
    So, how to tell which file belongs to which user to remove those no longer needed (or re-assigning if possible)? We (as probably most hoster) cant go to each server and ask every user about their avatar.

    Thanks in advance.

  2. #2
    Join Date
    May 2010
    Hello Alcazar,

    Effectively, all avatars are stored in "internal" server folder.
    In database, the link is in "client_flag_avatar" propertie, but the link between user and the avatar file is on the "client_base64hashClientUID" propertie.

    But, currently, you have this information for only connected users.

  3. #3
    Join Date
    July 2002

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. User avatar
    By Barofioso in forum General Questions
    Replies: 1
    Last Post: July 19th, 2014, 11:27 PM
  2. Theme; User Avatar Size
    By Neekita in forum Skins / Icon & Sound Packs
    Replies: 2
    Last Post: January 7th, 2014, 11:33 AM
  3. Change User Avatar
    By T.S. Excreta in forum Windows
    Replies: 6
    Last Post: March 15th, 2010, 08:54 AM
  4. how to remove an user's avatar?
    By DarkPepe in forum Client Support
    Replies: 5
    Last Post: January 2nd, 2010, 06:10 AM

Posting Permissions

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