kazya3, I think, there is error somewhere in SQL query, but I don't have time to find/fix that, sorry.
Alfari_zero, Hawkins, plugin have a wide range of natives / forwards to retrieve such information (see examples in main post and included files).
You have a full control over that. Just modify your "announcement" and "chat processor" related plugins to retrieve the information about rank. Here is an API:
PHP Code:
int rank = HX_GetPoints(target, HX_COUNTING_ACTUAL, HX_PLACE);
for general rank.
PHP Code:
int rank = HX_GetPoints(target, HX_COUNTING_ACTUAL, HX_PLACE_WEEK);
for rank of this week.