Avatar Taken Hack

I added the modify avatarbit taken template and changes to version 2.03...I just upgraded to 2.20 and need to make some modifications to have the avatars taken option work with the new registration pick avatar option ( was glad to see that in the update!). Could someone give me a hand? I still have the modify avatarbit taken template and I made the old change in the member.php already...hope it was okay to do it in the new ver.2.20 member.php.
:surprised

[Stryker]

Surely someone must know? This is really starting to bug me now (did you like the pun guys? Sorry I couldn't resist). :stupid:

Does anyone know how I'd go about removing the avatar selection dropdown menu from register.php? I've got a feeling that will solve the problem.

[DarkReaper]

What's this do...?

[Littlebit]

Firefly,
I just realized that something else needs modified. In the get info for Avatars, it has the taken avatars listed as available.
Will you help with this part too?

[Admin]

What's the "get info for avatars"?

[Littlebit]

Oops, I meant more info. Its usercp--------->edit options-------->more info at the bottom Avatar section.

[Stryker]

My problem has been solved now thanks to Firefly, but I was just thinking, wouldn't it be better if these hacks were put in a read only forum or on a separate non-dynamic page so they could be easily updated and people would know when they've been modified? As it is it's a bit confusing going through old posts and reading through all the problems, updates and modifications. It's also not very clear which hacks will work with which board version.

Don't mean to whinge, just constructive criticism

[Admin]

In misc.php, replace this:

  $minposts=0;
  $avatarbits="";

  $avatars=$DB_site->query("SELECT title,minimumposts,avatarpath FROM avatar ORDER BY minimumposts,title");

with this:

  $minposts=0;
  $avatarbits="";

  $takenids="";
  $avatarids=$DB_site->query("SELECT avatarid FROM user");
  while ($avatarid=$DB_site->fetch_array($avatarids)) {
    $takenids.=",$avatarid[avatarid]";
  }

  $avatars=$DB_site->query("SELECT title,minimumposts,avatarpath FROM avatar WHERE avatarid NOT IN (0$takenids) ORDER BY minimumposts,title");

[Littlebit]

Worked like a charm. Thank you Firefly!

[Littlebit]

Stryker, I agree ...also, it might make it easier to re-do all the hacks after updating the board by always having your list of installed hacks and referring to them in a read only forum with last updated and version info clear...so novice people like me don't try to piece together bits of old and new hacks and mess everything up!

[DarkReaper]

Originally posted by DarkReaper
What's this do...?