Make access code accessible to views 2, Drupal 6 so that a list of users can be created showing the access code.

Comments

flickerfly’s picture

flickerfly commented

In the mean time, I can use this sql code

SELECT name, access_code
FROM rcourier_user
LEFT JOIN users ON (`rcourier_user`.`uid` = `users`.`uid`)
WHERE (`rcourier_user`.`uid` >= 0)
ORDER BY `rcourier_user`.`access_code` DESC