Display Winnings in Message User Info

[nick-harper]

I have tried to edit this and take some of the variables from the statistics template but I assume they aren't set globally so won't show?

I tried to put the following:

{$xenOptions.sbCurrencySymbol}{xen:number $user.total_won, 2}

It just shows as 0.00 though sadly.

 

[Bob]

Ya, that won't work. You can display Sportsbook cash, as that is a static field in the xf_user table, which is part of the array of data that is always available with the user record.

total_won is not a field in the xf_user table, its is a php generated stat, that is fetched and prepared at run time by specific actions within specific sportsbook controllers.

 

[nick-harper]

Thanks, I thought that might be the case.

I guess to calculate it, it is going to need a query run to add it up for every user displayed?

 

[Bob]

I guess to calculate it, it is going to need a query run to add it up for every user displayed?

In a nut shell, yes.

In theory, you could also do something like extend the xf_user table to add a new field that would store that data, then it could be accessed directly like you are attempting in your first post. You'd have to develop a CRON with a set of functions that would fetch and prepare the data, initially populate the field and then update that data every so often (like once a day or once ever 6 hours or so). If you have a large site, it would be an intensive process, so you wouldn't be storing REAL TIME data, it would have to be limited to processing once a day.

 

[nick-harper]

I might look to just create a leaderboard instead like is used on the Statistics page to show it there!