How to get character type in query.

[mackyntosh2002]

I am developing cabal tools(website) using codeigniter framework, is there a way I can get the character type? for example, Warrior class and display it on my tool? Can't find the stored procedure that gets what kind of character. Thanks