-- Дамп структуры для таблица csstats.csstats_name_history
CREATE TABLE IF NOT EXISTS `csstats_name_history` (
`hash` varchar(35) NOT NULL,
`authid` varchar(35) NOT NULL,
`name` varchar(35) NOT NULL,
`totalplayed` int(11) NOT NULL,
`lastplayed` int(11) NOT NULL,
`lastchange` int(11) NOT NULL,
PRIMARY KEY (`hash`),
UNIQUE KEY `hash` (`hash`),
KEY `authid` (`authid`),
CONSTRAINT `csstats_name_history_ibfk_1` FOREIGN KEY (`authid`) REFERENCES `csstats_players` (`authid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
site.ru\inc\classes\class.getdata.php
в функцию public function stats($start, $server, $limit = 30, $name = null, $by_steam_id = null) {
перед строкой $this->tpl->load_template('elements/stat.tpl');
внести кодif(check_table('csstats_name_history', $pdo2)) {
$STH3 = $pdo2->prepare("SELECT * FROM `csstats_name_history` WHERE `authid` = :auth");
$STH3->setFetchMode(PDO::FETCH_OBJ);
$STH3->execute(array(":auth" => $row->authid));
$name_history = 'История ников:';
while($names = $STH3->fetch()) {
$name_history .= '
'.$names->name.' | '.expand_seconds2($names->totalplayed);
}
}
$this->tpl->set("{name_history}", $name_history);
\tpl\elements\stat.tpl
изменить строку с ником, привести к такому виду<tr>
<td><b> Ник: </b></td>
<td title="{name_history}">{nick}</td>
</tr>