Hey guys! I got something around to this. Let's get few things out of the way and then I'll explain stuff.
@Adrahil: color-coded names are not a bad idea but it requires to display a legend to show which color and which class. I'll like to reduce memory time each time a user gets on the website. I could get creative with it and doesn't require users to memorize which color/which class. Although, that's something I need to think about with UI design. The player names already have a hyperlink with style rules. Throwing color-coded in would get messy.
@Rexa: I can definitely add a class column on overview rpp page. I can even go further and include them in player page, too.
@Everyone: I did something with forum custom fields long time ago and I didn't get around to it until now. I created two fields: 'Class' and 'Primary Alt'. We could be more creative with custom fields if you'd like. Example: Deity, Primary Alt Class, Levels, AA counts, etc. This step requires you to input the information in your account settings info in the forum.
As for the roster page, I'm sure we can come up with something but I don't have a set of requirements to go with. We can show a list of rosters (active, retired, casuals, etc.) or just (active). The roster page should be public display while RPP page is limited to registered user and few specific membergroups only.
Or, we can do both. Building a roster page AND update RPP page to include class and primary alt.
This morning, I managed to whip up a nice query from active raiders with SMF profile/custom fields. Here's the test page:
https://www.silentredemption.net/testroster.phpIf you see that your info has not been inputted, you can go ahead and update your account settings info. Then, refresh the 'testroster' page. You should be able to see new changes you made.
After a set of requirements has been determined, I can apply them to new roster page and/or the rpp pages.