Set Avatar for users directly in the db

How to do...

Set Avatar for users directly in the db

Postby Quiqquex » Tue Nov 24, 2015 6:05 pm

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?
Quiqquex
 
Posts: 2
Joined: Tue Nov 24, 2015 5:57 pm

Re: Set Avatar for users directly in the db

Postby kissaki » Tue Dec 08, 2015 2:29 pm

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
MumPI: Your Mumble Web Interface in PHP
User avatar
kissaki
Team member
Team member
 
Posts: 1289
Joined: Sat Jan 09, 2010 12:15 pm

Re: Set Avatar for users directly in the db

Postby Quiqquex » Sun Dec 13, 2015 6:59 pm

Yeah I did restart the server.

Anyway I've settled for the Ice Interface as you suggested
Thanks mate :!:
Quiqquex
 
Posts: 2
Joined: Tue Nov 24, 2015 5:57 pm


Return to Usage

Who is online

Users browsing this forum: No registered users and 1 guest

cron