• Status Assigned
  • Percent Complete
  • Task Type Planned Feature
  • Category WebAdmin
  • Assigned To
  • Operating System All
  • Severity Very Low
  • Priority Very Low
  • Reported Version 0.10.0045
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: QELBot
Opened by Krayon - 2010-11-15
Last edited by Krayon - 2010-11-15

QB#76 - WebAdmin to support viewing Transactions

Trac Ticket #41 - Originally reported by: Krayon

WebAdmin should support the viewing of transaction history.
Krayon commented on 2010-11-15 09:48

Comment by: Krayon

I initially created the Transactions view like this:

Select Player Date/Time Direction Item Qty Unit Price Unit Profit
[ ] Korrode 2008-07-18 16:00:00 Player → Bot Gold Coins 1000 0 0
[ ] Korrode 2008-07-18 16:00:00 Bot → Player White Tiger fur 10 10 5
[ ] Korrode 2008-07-18 16:00:00 Bot → Player Gold Coins 900 0 0

Unfortunately this lists unneeded information and a separate entry for each item involved in the trade. This could easily be trimmed down to be a single transaction with optional more information.

Krayon commented on 2010-11-15 09:55

Comment by: Krayon

After some thought, I think the following would be the best way to implement this. I will however get some more opinions.

Details Select Player Date/Time Profit Paid Change
> [ ] Korrode 2008-07-18 16:00:00 50 1000 900
Item Qty Unit Price Unit Profit Profit
White Tiger Fur 10 10 5 50

In the above example, the Details ">" will allow you to collapse and expand the details. There will also be the ability to expand/collapse all in current view. Finally options to filter will also be implemented, allowing to filter by Name (or part there of eg. "Kor*"), Date range, sales, purchases, profit etc

Krayon commented on 2010-11-15 09:56

Comment by: Krayon

Well, after requesting feedback I have heard nothing for quite some time so I will assume that everyone thinks this is the most perfect system ever. :-)
Krayon commented on 2010-11-15 09:58

From revision :

  • Fixed #23 - Created wrapper script to start/stop bot.
  • Fixed #34 - Wrapper script should fix this.
  • Fixed #72 - Marking as fixed as wrapper script should fix this.
  • Fixed #81 - WebAdmin start/stop functionality.
  • Fixed #85 - Online Players list updating configurable using database entry Config.Online_Players_Update.
  • Fixed #80 - Fixed WebAdmin Home Location sitting checkbox.
  • Re #41 (FS#76) - Added basic Transaction list. Enhanced version still to come.
Krayon commented on 2010-11-15 14:35

rev :

NOTE: Bugs are now tracked in FlySpray. FS#n format will be used.
  • Added arrow graphics for sorting transaction history (FS#76).
  • Added ability to sort transaction list by the columns (FS#76).
  • Added new table "Inventory" to store the "Qty" of each item (FS#89).
  • Added fields to "Config" table - "Location_Map", "CoordX", "CoordY"
  • Added Quantity in Inventory to items list (FS#89).
  • Fixed bug where advertising too many items causes bot to crash ( FS#88 ).
  • Added logging on disconnection and kicking from server (part of  FS#88 ).
  • Added storing the map name to database.
Krayon commented on 2010-11-15 14:37

The only thing that may still be desirable is the ability to parse the transaction list, and perhaps the ability to export/download them.


Available keyboard shortcuts


Task Details

Task Editing