Question Custom Buttons field calculation in database-

[kcwayland]

Ok, so as a test I made a custom button called "Bug Hunter"- The goal, and one of the reasons I bought the pro version, was so that I could let admins or moderators award bug hunting points to users. Then I could create a plugin easily that reads the field in the user profile that says how many bugs they have hunted.

BUT, the custom button doesn't create a field in the profile? Is it supposed to be this way? Or is it the field setting 2?

Thanks!

 

[Fillip H.]

The statistics you want are in the table dbtech_thanks_statistics

 

[kcwayland]

The statistics you want are in the table dbtech_thanks_statistics

I went there, but there doesn't seem to be much deciphering of what is the userID. I recalculated the statistics as well for user id 114 and nothing's in the statistics. Is there a step I'm missing for how it adds the stats to the database?

 

[Fillip H.]

If you explain to me what you're trying to get out of the table I may be able to craft you a query - I didn't have much luck trying to interpret your existing query

 

[kcwayland]

If you explain to me what you're trying to get out of the table I may be able to craft you a query - I didn't have much luck trying to interpret your existing query

It updated and the values filled in. I wasn't sure what the hickup was on my end.

In case anyone is ever wondering, here was the code I ended up using for the query:

$user_bugs = $vbulletin->db->query_first("
SELECT BugHunterNum_received
FROM " . TABLE_PREFIX . "dbtech_thanks_statistics
WHERE userid = " . $user['userid'] . "
");