Arcturus {diamonds} {gotw_points}

[JoshuaS]

Hi dear developers.

I've been working on an arcturus revcms edit for the past months and for some reason i can't figure out how to add the reference {gotw_points} and {diamonds}. Normally if it was plusemu, the code would be like this: $this->setParams('activitypoints', $users->getInfo($_SESSION['user']['id'], 'points'));. But Arcturus has it's values stored in another table users_currency, where the tables are user_id-> type(different value codes)->amount. So how do i make this reference? Thx for any help you can give!

 

[Object]

grab the values where user_id matches the user & where currency type is 5 & 103 then output the amount (103 is atleast what my "gotw" points r set to)

 

[JoshuaS]

grab the values where user_id matches the user & where currency type is 5 & 103 then output the amount

But i don't see how i can set that parameter?

 

[Object]

$sql = "SELECT amount FROM users_currency WHERE user_id = SESSION USER ID AND `type` = '5' OR `type` = '103'"; (idk how rev works so you obviously gotta modify it a bit)