I like how Meph thinks this is a fairly simple thing.
Have you bothered to read any of the phpBB documentation?
First you need to make a 'module' aka MOD.
It should be an ACP module. So it can be added, or removed by the administration.
http://wiki.phpbb.com/Creating_modulesYou'll need to call on the SQL database in the script to get the 'user_id' number.
Here is a list of generic tables of phpBB 3.x
http://wiki.phpbb.com/Tables .. clicking on phpbb_users gives you
http://wiki.phpbb.com/Tables/phpbb_usersAt the top is 'user_id' which the users number id.
This is a basic expample of quering the DB.
http://wiki.phpbb.com/Dbal.sql_queryYou will want this displayed in the 'overall_footer.html'
I ain't writing you no dang code. :P
Get yo ass over onto the phpBB forums for some help.
http://www.phpbb.com/community/Everything I've written assumes it is phpBB v3.x