Changing Member Gallery (Group?)

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
  
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   HostRocket Webhosting for SMF
  
   Site Showcase

Advanced search

[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:

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

After it add

Code:

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.

Help Support the SMFHacks.com mod making.