Total System Coins in Circulation

[stevehead]

Dear All

A member recently asked how to see the total number of coins in circulation on PES Pro. This tweak will do the job assuming that you are using 1.8.4 (latest version at time of writing this)

IMPORTANT
1. Back up the original page first!
2. Use Dreamweaver (better as it has line numbers) or Notepad only for editing, to avoid adding any spurious code - do not use Front Page or WordPad
3. You may have to re-do this tweak following future version updates that replace the footer.php page - so note it down if it's important to you
4. If in doubt - don't do it!

Tweak - Display Total System Coins to Admin
1. Open footer.php in Notepad or preferably Dreamweaver
2. Look for the following code string - should be in the middle of the page (this is the code that displays the script load and database queries in small black text at the bottom of the screen)

<?if($data['admin'] == 1){?><p align="center" style="font-size:12px">Script: <?=(round(microtime(true)-$starttime - $db->UsedTime, 4))?> sec - Database: <?=(round($db->UsedTime, 4))?> sec - MySQL Queries: <?=$db->GetNumberOfQueries()?>
</p><?}?>

3. Insert this code string immediately before the closing </p>

<?
$sql = $db->Query("SELECT SUM(coins) as system_coins FROM users");
$row = $db->FetchArray($sql);
$totalsystemcoins = $row['system_coins'];
?> &nbsp;System Coins: <?=$totalsystemcoins?>

Save file and replace on server

When you login the total system coins will now display in small black text at the very bottom of your page

PROBLEMS?
Any problems replace the edited file with the original file you backed up earlier.

I hope you find this useful

Steve

[Galaxian]

Thanks for posting this, works well!