Добавление новых игровых критерий (user.php)

Synth (LM) · 8 дек 2010

Тут я вам покажу, как добавить новых "квадратиков" на страницу статистики каждого игрока и ссылки на игры этих критерий.

Первое.

Открываем user.php. Находим строку

PHP:

 '{MPHERO}', 

после нее, на следущей строке, ставим следущее:

PHP:

 '{TOTRAP}', '{TOPN}', '{TOPC}', '{TOPD}', '{TOPT}', 

затем после

PHP:

 '{MPCOUNT}', 

на следущую строку вставляем

PHP:

 '{RAPCOUNT}', '{TOPNCOUNT}', '{TOPCCOUNT}', '{TOPDCOUNT}', '{TOPTCOUNT}', 

Теперь находим

PHP:

 $mostplayedcount, 

Ниже строкой пишем

PHP:

 $rapires, $mostnkillscount, $mostckillscount, $mostdkillscount, $mosttkillscount, 

Ниже будет строка

PHP:

$mkhimg, $mdhimg, $mahimg, $mwhimg, $mlhimg, $mphimg, 

Замените ее на
Код:
$mkhimg, $mdhimg, $mahimg, $mwhimg, $mlhimg, $mphimg, $rapimg, $topnimg, $topcimg, $topdimg, $toptimg,
С user.php закончили.

Второе.

Идем в includes/get_user_stats.php | редактируем.

Ищем

PHP:

/////////////////////////////////// HERO STATS /////////////////////////////////// 

И удаляем все (если вы там не редактировали код) до строки

PHP:

 ////////////////////////////// //Using score table 

Вставляем в удаленный промежуток этот код (разделен на две части)

PHP:

 /////////////////////////////////// HERO STATS /////////////////////////////////// ////////////////////////////// //Find hero with most kills $sql = " SELECT original, a.gameid, description, max(kills) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' group by original ORDER BY topValue DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostkillshero=strtoupper($list["original"]); $mostkillsheroname=$list["description"]; $totkk=$list["topValue"]; //Find gameid with most kills $sql = " SELECT a.gameid, original, max(kills) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' and kills=$totkk group by original ORDER BY topValue DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostkkillsgi=$list["gameid"]; $mostkillscount="<a href='game.php?gameid=$mostkkillsgi'>$totkk</a>"; ////////////////////////////// //Find hero with most deaths $sql = "SELECT original, description, max(deaths) FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid WHERE LOWER(name) = LOWER('$username') GROUP BY original ORDER BY max(deaths) DESC LIMIT 1 "; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostdeathshero=strtoupper($list["original"]); $mostdeathsheroname=$list["description"]; $mostdeathscount=$list["max(deaths)"]; //Find gameid with most deaths $sql = " SELECT a.gameid, original, max(deaths) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' and deaths=$mostdeathscount group by original ORDER BY topValue DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostdeathsgi=$list["gameid"]; $mostdeathscount="<a href='game.php?gameid=$mostdeathsgi'>$mostdeathscount</a>"; ////////////////////////////// //Find total divines $sql = "SELECT COUNT( a.id ), ( item1 = 'I0A1') AS totRapir1, SUM( item2 = 'I0A1') AS totRapir2, SUM( item3 = 'I0A1') AS totRapir3, SUM( item4 = 'I0A1') AS totRapir4, SUM( item5 = 'I0A1') AS totRapir5, SUM( item6 = 'I0A1') AS totRapir6, name FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid AND a.colour = b.colour WHERE name = '$username' GROUP BY name"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $rapires1=$list["totRapir1"]; $rapires2=$list["totRapir2"]; $rapires3=$list["totRapir3"]; $rapires4=$list["totRapir4"]; $rapires5=$list["totRapir5"]; $rapires6=$list["totRapir6"]; $rapires=$rapires1+$rapires2+$rapires3+$rapires4+$rapires5+$rapires6; ////////////////////////////// //Find hero with most assists $sql = "SELECT original, description, max(assists) FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid WHERE LOWER(name) = LOWER('$username') GROUP BY original ORDER BY max(assists) DESC LIMIT 1 "; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostassistshero=strtoupper($list["original"]); $mostassistsheroname=$list["description"]; $mostassistscountlist=$list["max(assists)"]; $mostassistscount=$list["max(assists)"]; //Find gameid with most assists $sql = " SELECT a.gameid, original, max(assists) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' and assists=$mostassistscount group by original ORDER BY topValue DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostassistsgi=$list["gameid"]; $mostassistscount="<a href='game.php?gameid=$mostassistsgi'>$mostassistscount</a>"; ////////////////////////////// //Get hero with most wins $sql = " SELECT original, description, COUNT(*) as wins FROM gameplayers LEFT JOIN games ON games.id=gameplayers.gameid LEFT JOIN dotaplayers ON dotaplayers.gameid=games.id AND dotaplayers.colour=gameplayers.colour LEFT JOIN dotagames ON games.id=dotagames.gameid LEFT JOIN heroes on hero = heroid WHERE LOWER(name) = LOWER('$username') AND((winner=1 AND dotaplayers.newcolour>=1 AND dotaplayers.newcolour<=5) OR (winner=2 AND dotaplayers.newcolour>=7 AND dotaplayers.newcolour<=11)) GROUP BY original order by wins desc limit 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostwinshero=strtoupper($list["original"]); $mostwinsheroname=$list["description"]; $mostwinscount=$list["wins"]; ////////////////////////////// //Get hero with most neutrals $sql = " SELECT original, a.gameid, description, max(neutralkills) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' group by original ORDER BY topValue DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostnkillshero=strtoupper($list["original"]); $mostnkillsheroname=$list["description"]; $mostnkillscount=$list["topValue"]; $totn=$list["topValue"]; 

PHP:

 //Find gameid with most neutrals $sql = " SELECT a.gameid, original, max(neutralkills) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' and neutralkills=$totn group by original ORDER BY topValue DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostnkillsgameid=$list["gameid"]; $mostnkillscount="<a href='game.php?gameid=$mostnkillsgameid'>$totn</a>"; ////////////////////////////// //Get hero with most towers $sql = " SELECT original, a.gameid, description, max( towerkills) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' group by original ORDER BY topValue DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mosttkillshero=strtoupper($list["original"]); $mosttkillsheroname=$list["description"]; $tott=$list["topValue"]; //Find gameid with most towers $sql = " SELECT a.gameid, original, max( towerkills) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' and towerkills=$tott group by original ORDER BY topValue DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mosttkillsgameid=$list["gameid"]; $mosttkillscount="<a href='game.php?gameid=$mosttkillsgameid'>$tott</a>"; ////////////////////////////// //Get hero with most creeps denies $sql = " SELECT original, a.gameid, description, max(creepdenies) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' group by original ORDER BY topValue DESC LIMIT 1 "; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostdkillshero=strtoupper($list["original"]); $mostdkillsheroname=$list["description"]; $mostdkillsgameid=$list["gameid"]; $totd=$list["topValue"]; $mostdkillscount="<a href='game.php?gameid=$mostdkillsgameid'>$totd</a>"; //Find gameid with most denies $sql = " SELECT a.gameid, original, max(creepdenies) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' and creepdenies=$totd group by original ORDER BY topValue DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostdkillsgameid=$list["gameid"]; $mostdkillscount="<a href='game.php?gameid=$mostdkillsgameid'>$totd</a>"; ////////////////////////////// //Get hero with most creeps $sql = " SELECT original, a.gameid, description, max(creepkills) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' group by original ORDER BY topValue DESC LIMIT 1 "; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostckillshero=strtoupper($list["original"]); $mostckillsheroname=$list["description"]; $mostckillscount=$list["topValue"]; $mostckillsgameid=$list["gameid"]; $totc=$list["topValue"]; //Find gameid with most towers $sql = " SELECT a.gameid, original, max(creepkills) as topValue FROM dotaplayers AS a LEFT JOIN gameplayers AS b ON b.gameid = a.gameid and a.colour = b.colour LEFT JOIN heroes on hero = heroid where name= '$username' and creepkills=$totc group by original ORDER BY topValue DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostckillsgameid=$list["gameid"]; $mostckillscount="<a href='game.php?gameid=$mostckillsgameid'>$totc</a>"; ////////////////////////////// //Get hero with most losses $sql = " SELECT original, description, COUNT(*) as losses FROM gameplayers LEFT JOIN games ON games.id=gameplayers.gameid LEFT JOIN dotaplayers ON dotaplayers.gameid=games.id AND dotaplayers.colour=gameplayers.colour LEFT JOIN dotagames ON games.id=dotagames.gameid LEFT JOIN heroes on hero = heroid WHERE LOWER(name) = LOWER('$username') AND((winner=2 AND dotaplayers.newcolour>=1 AND dotaplayers.newcolour<=5) OR (winner=1 AND dotaplayers.newcolour>=7 AND dotaplayers.newcolour<=11)) GROUP BY original order by losses desc limit 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostlosseshero=strtoupper($list["original"]); $mostlossesheroname=$list["description"]; $mostlossescount=$list["losses"]; ////////////////////////////// //Get hero you have played most with $sql = "SELECT SUM(`left`) AS timeplayed, original, description, COUNT(*) AS played FROM gameplayers LEFT JOIN games ON games.id=gameplayers.gameid LEFT JOIN dotaplayers ON dotaplayers.gameid=games.id AND dotaplayers.colour=gameplayers.colour LEFT JOIN dotagames ON games.id=dotagames.gameid JOIN heroes on hero = heroid WHERE LOWER(name)=LOWER('$username') GROUP BY original ORDER BY played DESC LIMIT 1"; $result = $db->query($sql); $list = $db->fetch_array($result,'assoc'); $mostplayedhero=strtoupper($list["original"]); $mostplayedheroname=$list["description"]; $mostplayedcount=$list["played"]; $mostplayedtime=secondsToTime($list["timeplayed"]); ////////////////////////////// //Using score table 

Потом находим

PHP:

 if ($mostplayedhero == "") {$mostplayedhero = "blank";} 

И вставляем строкой ниже

PHP:

 if ($mostnkillshero == "") {$mostnkillshero = "blank";} if ($mostckillshero == "") {$mostckillshero = "blank";} if ($mostdkillshero == "") {$mostdkillshero = "blank";} if ($mosttkillshero == "") {$mosttkillshero = "blank";} 

Ищем строку ниже

PHP:

$mphimg = "<a href='hero.php?hero=$mostplayedhero'><img width='64px' title='$mostplayedheroname' alt='' src='img/heroes/$mostplayedhero.gif' border=0/></a>"; 

Вставляем ниже этой строки

PHP:

$rapimg = "<img width='64px' title='Всего собрано рапир' alt='' src='img/items/BTNINV_Sword_25.gif' border=0/>"; $topnimg = "<a href='hero.php?hero=$mostnkillshero'><img width='64px' title='$mostnkillsheroname' alt='' src='img/heroes/$mostnkillshero.gif'/ border=0></a>"; $topcimg = "<a href='hero.php?hero=$mostckillshero'><img width='64px' title='$mostckillsheroname' alt='' src='img/heroes/$mostckillshero.gif'/ border=0></a>"; $topdimg = "<a href='hero.php?hero=$mostdkillshero'><img width='64px' title='$mostdkillsheroname' alt='' src='img/heroes/$mostdkillshero.gif'/ border=0></a>"; $toptimg = "<a href='hero.php?hero=$mosttkillshero'><img width='64px' title='$mosttkillsheroname' alt='' src='img/heroes/$mosttkillshero.gif'/ border=0></a>"; 

С get_user_stats.php - закончили.

Теперь идем в style\dota. В моем случае я делал это для стиля Dotа - вы можете сделать для каждого стиля, тем же способом.

Третье.

Открываем блокнотом user_row.html

Ищем

PHP:

 <td>{L_PLAYED}</td> 

Вставляем ниже

PHP:

 <td>Всего рапир</td> <td>Нейтралов</td> <td>Крипов</td> <td>Денаев</td> <td>Вышек</td> 

Чуть ниже найдите

PHP:

 <td>{MPHERO}</td> 

Вставляем вниз

PHP:

 <td>{TOTRAP}</td> <td>{TOPN}</td> <td>{TOPC}</td> <td>{TOPD}</td> <td>{TOPT}</td> 

И наконец, найдите

PHP:

 <td>({MPCOUNT})</td> 

Вставка вниз

PHP:

 <td>({RAPCOUNT})</td> <td>({TOPNCOUNT})</td> <td>({TOPCCOUNT})</td> <td>({TOPDCOUNT})</td> <td>({TOPTCOUNT})</td> 

На этом все. Можете корректировать нужные вам параметры, типа русскоязычного описания или вообще добавления новых критерий. Также в некоторых значениях, а именно Убийств Смертей Асистов Нейтралов Крипов Денаев Вышек, появилась ссылка на ту игру, где был заработан критерий.

PanSom · 20 янв 2011

Всё зделал как описанно выше но вместо той картинки что у вас у меня отображает вот это

Версия вебморды 1.3.2

PanSom · 20 янв 2011

Причём если не вставлять
Код:
       '{TOTRAP}',
       '{TOPN}',
       '{TOPC}',
       '{TOPD}',
       '{TOPT}', 
Будет отображать это

Synth (LM) · 21 янв 2011

Вот сделай это в user.php

Найди

PHP:

$mkhimg, $mdhimg, $mahimg, $mwhimg, $mlhimg, $mphimg, 

Замени ее на
Код:
$mkhimg, $mdhimg, $mahimg, $mwhimg, $mlhimg, $mphimg, $rapimg, $topnimg, $topcimg, $topdimg, $toptimg,

rost · 27 мар 2011

лонг можно еще добавить скока ты раз убил ROSHAN , если да то скажи плз что вставить нужно ту типа место '{TOTRAP}' ;
просто я хз сработает ли и что писать толи TOTROSHAN или еще что другое

Synth (LM) · 27 мар 2011

Тебе нужно будет в бота писать класс убийства рошана, ибо я не наблюдал в логах его убийство. Мб в брт че придумали, но на моем классическом уане нет такого.

rost · 27 мар 2011

Понятно спс, то так идейка просто, думал че выйдет =))

Войти или зарегистрироваться

Добавление новых игровых критерий (user.php)

Synth (LM) Пантограф!

PanSom Ньюфаг

PanSom Ньюфаг

Synth (LM) Пантограф!

rost Гуру

Synth (LM) Пантограф!

rost Гуру

Войти или зарегистрироваться

Добавление новых игровых критерий (user.php)

Synth (LM) Пантограф!

PanSom Ньюфаг

PanSom Ньюфаг

Synth (LM) Пантограф!

rost Гуру

Synth (LM) Пантограф!

rost Гуру

Быстрый поиск