d2jsp
Log InRegister
d2jsp Forums > d2jsp > General Help > Site Suggestions >
Poll > Gold Logs In/out Suggestion
Prev12
Closed New Topic New Poll
  Guests cannot view or vote in polls. Please register or login.
Member
Posts: 1,798
Joined: Mar 14 2005
Gold: 16,579.24
May 7 2024 11:43am
Quote (B99 @ May 7 2024 11:55am)
Any coders want to shine some light on how much work this would be?
Please 👍


Quote (nuvo @ May 7 2024 01:22pm)
Contrary to popular belief, computers are better at numbers than people and its zero effort. It's literally a single SQL query. Of course depending on actual structure of DB, but basically

Code
select user_in, sum(amount) from gold_logs where user_in=2137 or user_out=2137 group by user_in;


Ya, this. Whatever the current query is to show a month would just need to be expanded to show everything. It wouldn't be much work at all.

Even in the case where logs are stored in flat files It could still be done in a single line of code or a few at the very most.
Member
Posts: 14,457
Joined: Jun 22 2010
Gold: 2.00
May 7 2024 01:30pm
This would be cool, voted yes
Admin
Posts: 24,305
Joined: Sep 24 2002
Gold: 24,767.75
Trader: Trusted
May 7 2024 01:53pm
There are no plans to implement this. You have a number of options on your side to calculate this, including exporting your gold logs, and keeping a running total to suit your desires (monthly, yearly, lifetime, etc).
Go Back To Site Suggestions Topic List
Prev12
Closed New Topic New Poll