Changing Member Gallery (Group?)

[Hobbs]

I have over 11,000 Regular Members on my smf, i'd like to change the Default Category (Member Gallery) from the 11,000+ "Regular Members" to my "Members" group.

So that way when i click on the first Category Member Gallery, i would only see my custom group, and not everyone registered on the site.

Where can i find the edit? And what to edit?

Thanks!

[SMFHacks]

In themes/default/UserGallery.template.php

In the template_userlist function

Find

Code: [Select]

  ON (p.id_member = m.id_member AND p.user_id_cat <> 0 AND p.approved = 1 )

After it add

Code: [Select]

WHERE ID_GROUP = ###
Replace ### with the your membergroups id

[Hobbs]

I did the edit, no change. However using the latest gallery i only have: UseGallery2.template.php

This is what i have:

$dbresult = $smcFunc['db_query']('',"
      SELECT m.id_member, COUNT(p.ID_PICTURE )as total
         FROM {db_prefix}members as m
      LEFT JOIN {db_prefix}gallery_pic as p  ON (p.id_member = m.id_member AND p.user_id_cat <> 0 AND p.approved = 1 ) WHERE ID_GROUP = 4
      GROUP BY m.id_member HAVING  COUNT(p.ID_PICTURE) > 0      
       ");
      $rowCount = $smcFunc['db_num_rows']($dbresult);
      $num_rows  = $rowCount;
      $ptotalCheck  = ' HAVING  COUNT(p.ID_PICTURE) > 0 ';
   }

Any ideas?

[SMFHacks]

There should be another similar query under that one.

[Hobbs]

That worked, many thanks.

Only issue, if an ID_GROUP = 30 user is an admin, they do not show in the Member Gallery for ID_GROUP = 30,
because they are ID_GROUP = 0.

The admins are in the Members group, and we just need the Members group to be listed for the gallery, including admins.

Any ideas, aside from "ID_GROUP =30,0

Thanks

[SMFHacks]

Change to
m.ID_GROUP IN(30,1)

[Hobbs]

just throws an error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'm.ID_GROUP IN(30,1)

GROUP BY m.id_member ORDER BY total DESC LIMIT 0' at line 3/quote]

[SMFHacks]

Try just
WHERE ID_GROUP IN(30,1)

[Hobbs]

spoke too soon, roger that. I forgot the WHERE, Works like a charm.

Many thanks for the help.