Customising Drupal for TSA

alan dawson's picture
| |

Used the taxonomy_access module to create public and private tags. Anonymous users can see the public tagged content but only registered users can see the private content.

plagiarised a quick php sql query to list all registered users and links to there profiles.


$header = array(
array('data' => t('Username'), 'field' => '', 'sort' => 'asc')
$sql = "SELECT u.uid, FROM {users} u WHERE u.uid > 1";
$sql .= tablesort_sql($header);
$result = pager_query($sql, 50);

$status = array(t('blocked'), t('active'));
while ($account = db_fetch_object($result)) {
$rows[] = array(theme('username', $account));

$output = theme('table', $header, $rows);
$output .= theme('pager', NULL, 50, 0);
print ($output);


We can add custom fields to the profiles section using the profile admin pages.