public function lb_getInfraction($type, $id)
{
if ($type === "ban" || $type === "temp_ban") {
$results = $this->_db->get($this->_prefix . 'bans', array("id", "=", $id))->results();
$username = $this->_db->get($this->_prefix . 'history', array('uuid', '=', htmlspecialchars($results[0]->uuid)))->results();
if (count($username) > 1) {
// get most recent name
usort($username, function ($a, $b) {
return strtotime($b->date) - strtotime($a->date);
});
}
if (count($username)) {
$username = htmlspecialchars($username[0]->name);
} else {
$username = 'Unknown';
}
return array($results[0], $username);
} else {
if ($type === "mute") {
$results = $this->_db->get($this->_prefix . 'mutes', array("id", "=", $id))->results();
$username = $this->_db->get($this->_prefix . 'history', array('uuid', '=', htmlspecialchars($results[0]->uuid)))->results();
if (count($username) > 1) {
// get most recent name
usort($username, function ($a, $b) {
return strtotime($b->date) - strtotime($a->date);
});
}
if (count($username)) {
$username = htmlspecialchars($username[0]->name);
} else {
$username = 'Unknown';
}
return array($results[0], $username);
} else {
if ($type === "warning") {
$results = $this->_db->get($this->_prefix . 'warnings', array("id", "=", $id))->results();
$username = $this->_db->get($this->_prefix . 'history', array('uuid', '=', htmlspecialchars($results[0]->uuid)))->results();
if (count($username) > 1) {
// get most recent name
usort($username, function ($a, $b) {
return strtotime($b->date) - strtotime($a->date);
});
}
if (count($username)) {
$username = htmlspecialchars($username[0]->name);
} else {
$username = 'Unknown';
}
return array($results[0], $username);
} else {
if ($type === "kick") {
$results = $this->_db->get($this->_prefix . 'kicks', array("id", "=", $id))->results();
$username = $this->_db->get($this->_prefix . 'history', array('uuid', '=', htmlspecialchars($results[0]->uuid)))->results();
if (count($username) > 1) {
// get most recent name
usort($username, function ($a, $b) {
return strtotime($b->date) - strtotime($a->date);
});
}
if (count($username)) {
$username = htmlspecialchars($username[0]->name);
} else {
$username = 'Unknown';
}
return array($results[0], $username);
}
}
}
}
return false;
}