Thread Rating:
  • 3 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[For 1.8] DVZ Random Avatars 1.1
#31
(2017-09-19, 12:46 PM)WallBB Wrote: DVZ, I have found an issue with this plugin, if I use the feature "• Assign avatars to users with no avatar" when member count is greater than 50k, I see the page getting timed out. Is there any reason for that ?

Each user is updated with a separate query as the plugin fills some variables and generates a random identifier, but you can try doing this operation in database only - MySQL/MariaDB:

UPDATE `mybb_users`
    SET
        `avatar` = CONCAT('https://secure.gravatar.com/avatar/', MD5(RAND(10)), '?s=100|100&d=identicon&f=y'),
        `avatartype` = 'gravatar',
        `avatardimensions` = '100|100'
    WHERE `avatar` = ''

For PostgreSQL/SQLite change RAND to random.

Users without avatars will be assigned 100x100 identicon ones.

Remember to backup the table beforehand.
devilshakerz.com/pgp (DF3A 34D9 A627 42E5 BC6A 6750 1F2F B8AA 28FF E1BC) ▪ keybase.io/devilshakerz
Reply
#32
(2017-09-19, 09:02 PM)Devilshakerz Wrote:
(2017-09-19, 12:46 PM)WallBB Wrote: DVZ, I have found an issue with this plugin, if I use the feature "• Assign avatars to users with no avatar" when member count is greater than 50k, I see the page getting timed out. Is there any reason for that ?

Each user is updated with a separate query as the plugin fills some variables and generates a random identifier, but you can try doing this operation in database only - MySQL/MariaDB:

UPDATE `mybb_users`
    SET
        `avatar` = CONCAT('https://secure.gravatar.com/avatar/', MD5(RAND(10)), '?s=100|100&d=identicon&f=y'),
        `avatartype` = 'gravatar',
        `avatardimensions` = '100|100'
    WHERE `avatar` = ''

For PostgreSQL/SQLite change RAND to random.

Users without avatars will be assigned 100x100 identicon ones.

Remember to backup the table beforehand.

Worked awesome Smile
Reply
#33
Hi DVZ,
I am using this plugin on my forum but it is not setting random avatars.
Link of a thread for reference
https://wallbb.co.uk/forums/Thread-Focus...le-problem

Can you tell me what might be the problem ?
I am using latest version from MyBB Mods

Regards
WallBB
Reply
#34
(2017-11-09, 11:34 AM)WallBB Wrote: Hi DVZ,
I am using this plugin on my forum but it is not setting random avatars.
Link of a thread for reference
https://wallbb.co.uk/forums/Thread-Focus...le-problem

Can you tell me what might be the problem ?
I am using latest version from MyBB Mods

Regards
WallBB

Does Assign avatars to users with no avatar have any effect? Does the issue affect other places, e.g. profiles?
devilshakerz.com/pgp (DF3A 34D9 A627 42E5 BC6A 6750 1F2F B8AA 28FF E1BC) ▪ keybase.io/devilshakerz
Reply
#35
(2017-11-10, 04:33 PM)Devilshakerz Wrote:
(2017-11-09, 11:34 AM)WallBB Wrote: Hi DVZ,
I am using this plugin on my forum but it is not setting random avatars.
Link of a thread for reference
https://wallbb.co.uk/forums/Thread-Focus...le-problem

Can you tell me what might be the problem ?
I am using latest version from MyBB Mods

Regards
WallBB

Does Assign avatars to users with no avatar have any effect? Does the issue affect other places, e.g. profiles?
Yes, it has not affect.
Also I don't see the random avatar in other places for example :- memberlist, profile, pm
Also I have removed memberlist.
Reply
#36
Does it work after removing an avatar from the ACP with the plugin activated?
Do/did you have any other plugins installed related to default avatars?
Is the avatar column empty in the mybb_users table for affected users?
devilshakerz.com/pgp (DF3A 34D9 A627 42E5 BC6A 6750 1F2F B8AA 28FF E1BC) ▪ keybase.io/devilshakerz
Reply
#37
(2017-11-10, 05:39 PM)Devilshakerz Wrote: Does it work after removing an avatar from the ACP with the plugin activated?
Do/did you have any other plugins installed related to default avatars?
Is the avatar column empty in the mybb_users table for affected users?

1. No
2. No
3. I do see avatar changed in the users table but not in the forums.

Regards
WallBB
Reply
#38
(2017-11-10, 05:53 PM)WallBB Wrote: 3. I do see avatar changed in the users table but not in the forums.

Can you share some example values of avatardimensions, avatartype columns from rows in which avatars are set?

Is the Profile Options → Allow Remote Avatars setting enabled?
devilshakerz.com/pgp (DF3A 34D9 A627 42E5 BC6A 6750 1F2F B8AA 28FF E1BC) ▪ keybase.io/devilshakerz
Reply
#39
(2017-11-10, 07:44 PM)Devilshakerz Wrote:
(2017-11-10, 05:53 PM)WallBB Wrote: 3. I do see avatar changed in the users table but not in the forums.

Can you share some example values of avatardimensions, avatartype columns from rows in which avatars are set?

Is the Profile Options → Allow Remote Avatars setting enabled?

Ah, that was the issue.
I am sorry for raising this, thanks DVZ Smile
Reply
#40
Hallo guys,
in my case it shows only a white avater after i press Assign avatars to users with no avatar
any solutions for that?

grats
Duelist
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)