wiki | forum | trac | otrs | joomla | tech blog | mailman | bewelcome Branches: test.bw | alpha.bw | www.bw Participate: download | get involved

Public profiles

We call Public profiles the members who have chosen in their preferences to make there general data public (i.e. : google browsable, or visible by not logged in members).

As a typical consequence, if without beeing logged in :

  • you call the url of a classical profile, you will see nothing
  • you call the url of a profile which is a Public profile, you will be able to see part of it.

Functional description

see ["http://www.bevolunteer.org/wiki/Public_profiles"

Data Structure

This is achieved using the memberspublicprofiles table

To know if a profile is public or not just do a SELECT IdMember FROM memberspublicprofiles where IdMember=XXX (where XXX is the membersid of the member)

if a row is returned, the profile is public, if not it is not a public profile

Another example :

to know all the username of public profile who have used BeWelcome since 2008, April 4th

 SELECT Username from members,memberspublicprofiles 
 WHERE  members.id=memberspublicprofiles.IdMember AND lastlogin >'20080426000000'

The following url https://www.bewelcome.org/bw/members.php list all public profiles (when the user is not logged in) and all profiles (if the user is logged in)

Trac Customization: trac stylesheet
SourceForge.net Logo