Set Avatar for users directly in the db

How to do...
Post Reply
Quiqquex
Posts: 2
Joined: 24 Nov 2015, 17:57

Set Avatar for users directly in the db

Post by Quiqquex »

So I want to set my users avatar directly from the server.
I had a look in the murmur.sqlite db and I can see the table users has a BLOB column named texture.

For the users that had set their own avatar I can correctly see and export the image.
So I thought that importing an image with DBbrowser for SQLite for the users who didn't set any image would work, but even if I can see correctly the image saved in the table, the avatar is not visible in mumble nor in the in game overlay.

The images are all 64x64, the database was of course edited while murmur was not running, and the the changes correctly written to it (reopening the table shows the avatar I manually set).
Am I doing something wrong? Or my initial assumption is wrong?

User avatar
kissaki
Team member
Team member
Posts: 1469
Joined: 09 Jan 2010, 12:15
Contact:

Re: Set Avatar for users directly in the db

Post by kissaki »

Mumble (server) does not support manually triggered DB changes.
Did you restart the server after inserting the new avatars?

We do provide the Ice interface to live-update data like the avatar images.
See setTexture reference

Quiqquex
Posts: 2
Joined: 24 Nov 2015, 17:57

Re: Set Avatar for users directly in the db

Post by Quiqquex »

Yeah I did restart the server.

Anyway I've settled for the Ice Interface as you suggested
Thanks mate :!:

Post Reply