private function onTop5DamageBest($rank)
{
$db = gdo_db();
$user = GWF_TABLE_PREFIX . 'dog_users';
$user2 = GWF_TABLE_PREFIX . 'dog_users';
$lsh = GWF_TABLE_PREFIX . 'dog_slap_history';
$limit = GDO::getLimit(1, Common::clamp($rank - 1, 0));
$query = "SELECT u.user_name slapper, u2.user_name target, s.* FROM {$lsh} s JOIN {$user} u ON u.user_id=lsh_slapper JOIN {$user2} u2 ON u2.user_id=lsh_target ORDER BY lsh_damage DESC {$limit}";
echo $query . PHP_EOL;
if (false === ($row = $db->queryFirst($query))) {
return 'No database record found.' . PHP_EOL;
}
$adverb = Dog_SlapItem::getByID($row['lsh_adverb']);
$verb = Dog_SlapItem::getByID($row['lsh_verb']);
$adjective = Dog_SlapItem::getByID($row['lsh_adjective']);
$item = Dog_SlapItem::getByID($row['lsh_item']);
$date = $row['lsh_date'];
return sprintf('BestSlap #%d: %s %s %s %s with %s %s. This dealt %d damage and happened on %s, %s ago.', $rank, $row['slapper'], $adverb->getVar('lsi_name'), $verb->getVar('lsi_name'), $row['target'], $adjective->getVar('lsi_name'), $item->getVar('lsi_name'), $row['lsh_damage'], GWF_Time::displayDate($date), GWF_Time::displayAge($date));
}
