How to isolate point user dan bonus points ? I wanna add in other line

Question

Please, i need your help

Answer 1

You can define and use a custom function easily. 

It should look like below.

function custom_userpoints_without_bonus($userid) {

$record = qa_db_query_sub(

"SELECT ABS(points - bonus)

FROM ^userpoints

WHERE userid = #",

$userid

);

return $record;

}