Looks like Andy wasn't running MySQL 4.1.21 (that was his client), his server version was 4.0.27.

So at the moment the two outstanding issues are now both linked to 4.0 - which doesn't support the query used in this mod.

I had a friend of mine build a completely different query. However, the new one doesn't work on mysql 4.0 either.

I've therefore updated the xml installer so that it requires mysql 4.1. Sorry to all those 4.0 users out there (I guess there are still a small number), but unless you upgrade to at least 4.1 you won't be able to use this mod.

The minimum version requirement should cut down on the number of new cases reporting this error, since they won't be able to install it.

I get this:

Is there a way to upgrade sql without messing things up? I really don't know, never upgraded

Excellent, then that little version check has saved another SQL syntax error being posted in here :-)

I'm afraid I can't give you any advice on upgrading your version of mysql - I've never done it myself either so I don't know what the issues are. I'd suggest trying to locate another thread or using google to try and figure that out.

Installed.

Hey there, thanks for making this neat mod.

I'm having trouble. I have the settings set to:

Force unique avatars? no
Display number of times used? yes
Hide used avatars? no


however when I used an avatar it still hides it and doesn't say "used x times"

I would love some help! :)

maybe it was because I was an admin? I had a normal user use one and while it did NOT disappear it also didn't say "Used 1 time" or anything.

:(

You won't have much luck if you set this setting to "no" because then it will disable the mod. The whole point of this mod is to force unique avatars, so by setting it to no you can't be surprised if nothing happens!

Mark

Upgraded MySQL and the mod is working perfectly! Thanks again, mfyvie.

moved hosts and all is working fine thanks

it`s showing me this any idea how to solve this problem. Other than upgrading my SQL version.......

I specifically made it display that message to STOP people with less than 4.1 using this mod. Why? Because it simply won't work - it uses commands which are only present in 4.1. That warning message is there to stop people from installing it then coming to complain when it won't work.

Thanks for this gr8 hack.....

DITTO!!!

And thank you SO much for taking the time to help me with my techy issues. I've waited for this had for so long!

I'm now I'm on my way to Paypal to show my appreciation :up:

gsk8 seems to have removed her original message outlining the bug she found, but I just wanted to let everyone know that I addressed that bug and incremented the version to 1.1 this morning. The only change is that one of the plugins has moved hook locations.

The original bug report (now not visible, presumed deleted) was that when a user had selected a pre-defined avatar it didn't appear as their current avatar when the edit avatar page of the usercp was displayed.

If you are running 1.0 and are not bothered by this (it seems nobody else noticed) then there's no immediate or urgent need to upgrade.

I have a question here. I like the hacks idea, in forcing users to choose different avatars, so that it's easy to visually recognize people. But have we ever tested the theory of what happens if all avatars in the default system are selected?

Do new users have no choice then of a preset system avatar, or does the system cycle and now allow no more than 2 users to have the same avatar, once all of them have been chosen?

(( I mean, I just completed our websites avatars, and I'm not doing anymore...ever. lolz, so I will not keep readding to support this hack if that is required in this scenario ))

lemme know, thanks,

LoA

LOA - Each time an avatar is used then it will be greyed out, therefore impossible to select. The user would then have to go to the next page or avatars, or select another category.

Of course, there's nothing stopping them uploading their own.

On my own system the first page of avatars is completely allocated - users obviously tend to choose one from the first page they see.

I hear what you're saying and I really like your system. Unfortunately I can't use it. See, I hear what you're saying. When all the avatars are used up, there is none to choose from. But still, I actually don't allow custom upload until a post amount, and therefore after they are all used, new users will have to wait to fill the post amount prior to having any avatar at all.

In that case your requirements are absolutely opposite to what this mod does. If you want your avatars to never run out, then you cannot demand of your users that they all be unique.

You could also just give them a larger library to choose from...

I don't know if I'd say they're opposite, but they are incompatible is a better term.

If a function of the hack allowed avatars to be used again, after ALL had been used once that would solve the problem and allow for enough diversity that they would never run out. Meaning that All used once, then it cycles again, once Avatar 1 has been chosen twice, it again is removed from the list until all the other avatars you have are used a second time, etc., etc.

I mean the value of the hack is there, no doubt about it. However admins will have to make a trade off here. They either have to keep adding more avatars to help create a neverending supply, OR they have to always allow custom avatars from the get go without post requirement.

I made 777 custom avatars for my board, that is a ton and could last for years with this hack. However, since I use a post count point before custom av's allowed, it would eventually run out of avatars. After 777 even if I didn't have the post count rule, it "could" eventually still run out or I'd have to delete inactive users to keep avatars available. In short, I like your mod, but I don't want to make anymore avatars after months of doing it. lol

This should be released and posted for vb3.7 users to find and use.:D It is a top mod!

thats an awesome idea especially them being unique

OMG! Wow - Tough situation and I offer my condolensces as well.

Jacquii.

I use this hack and all I can say is we lost an excellent coder and good friend.

I've just granted permission to another coder who has agreed to take over the code from Mark's mods (like this one) and keep them up to date and free to all, which should be good news for all of you who use his mods and allow his legacy to continue.

Robert Fyvie

very very thanks!
i'm finding it!

Edit:
upload it but i didn't run.
vb options -> unique avatars -> Force unique avatars? YES -> Display number of times used? YES

isn't it?

User cp -> edit avatar ...

the same menu again:S

help help ...

Anyone know if I can use this for 3.8?

Has anyone tested this in vb4?

Me. It doesnt work :(

I posted above that I gave another coder permission to work on my late brother's mods. Sadly, I notice that after permission was given, this person has done nothing about it. Good intentions are cheap. If anyone would like to take over this (and mfyvie's other mods) please PM me. I would like to see his work being used and not abandoned. Most of his work was good and should be well written enough for someone to upgrade without too much effort.

Does anyone know if there's a similar mod for vB 4?