Issue #537
Merge pull request #538 from nicoschtein/issue-537

Issue #537
Removing orphaned credits from Sidebars

This will remove some confusion for users.

Addresses #524
Merge pull request #540 from TheSerapher/issue-524-remove-orphans

Removing orphaned credits from Sidebars
Find actual row count without LIMITs applied

Addresses #542
removed line by accident
increased limit back to 30
Update POOLS.md

Sheinsha pool updates.
Merge pull request #544 from TheSerapher/issue-542

Issue 542
Merge pull request #539 from nicoschtein/patch-1

Added Prefix Option to run-crons.sh PID File.
Great performance increase on transaction queries

This will address an issue with database including a lot of
transactions. No more nested queries that put unwanted strain on a DB.

Address #536
Fixing WHERE clause for getBalance call

Addresses #536
Refactored admin transactions

* Properly generate the bind_params statement
* Extended from Base Class
* Added methods to Base Class

Addresses #536
Refactored getTransactions, unified admin/user view

* Removed getAllTransactions method
* Unified getTransactions for users and admins
* Added filter abilities to user transaction view

This should speed up things a fair bit for transaction heavy pools.

Addresses #536
fixing missing template warnings
Adding archiving flag for transactions

* Added new column to transactions table (`007_transactions.sql`)
* Added setArchived method to mark old transactions as archived
* Honor archived flag in getBalance and getLockedBalance

This will further address and fix #536 once merged.
properly display auto-confirmed tx
adding index to archived column
Adding Admin MOTD

* Adding MOTD to admin settings
* Adding MOTD to smarty_globals as regular INFO popup

Fixes #545
Update POOLS.md

added nrpatten pools.