Открыть поиск
Открыть меню
22
724
274
2,1 тыс.
wiki.iccup.org
Открыть персональное меню
Вы не представились системе
Your IP address will be publicly visible if you make any edits.

Шаблон:HeroTable: различия между версиями

Материал из wiki.iccup.org
Дополнительные действия
← Предыдущая правкаСледующая правка →
ВизуальныйВики-текст
Нет описания правки
Метка: редактор вики-текста 2017
Нет описания правки
Метка: редактор вики-текста 2017
Строка 1: Строка 1:
<div class="heroes-panel" data-component="heroes-panel">
<div class="heroes-panel" data-component="heroes-panel">
<div class="heroes-panel__category category--strength">
    <div class="heroes-panel__category category--strength">
<div class="heroes-panel__category-title">
        <div class="heroes-panel__category-title">
[[File:Dota2_Strength_icon_solid_allmode.png|frameless|24px]]
            [[File:Dota2_Strength_icon_solid_allmode.png|frameless|24px]]
[[Сила]] ({{#iccupdb:datapoint|query=count::pagename|conditions=[[type::hero]] and [[extradata_primary::Сила]] and [[extradata_game::iCCup]]|template=Identity{{!}}param=count_pagename}})
            [[Сила]] ({{#cargo_query:table=Heroes|fields=count(DISTINCT name) AS total|where=extradata_primary='Сила' AND game='Dota1'|format=plain}})
</div>
        </div>
<ul class="heroes-panel__category-list">
        <ul class="heroes-panel__category-list">
{{#iccupdb:datapoint
            {{#cargo_query:
| conditions = [[type::hero]] and [[extradata_primary::Сила]] and [[extradata_game::iCCup]]
                table=Heroes
| limit = 1000
                |fields=name
| order = name asc
                |where=extradata_primary='Сила' AND game='Dota1'
| template = Hero Entry{{!}}userparam={{{subpage|}}}{{!}}vercheck={{{vercheck|}}}
                |limit=1000
}}
                |order=name ASC
</ul>
                |format=template
</div>
                |template=Hero Entry
                |named args=yes
                |subpage={{{subpage|}}}
                |vercheck={{{vercheck|}}}
            }}
        </ul>
    </div>


<div class="heroes-panel__category category--agility">
    <div class="heroes-panel__category category--agility">
<div class="heroes-panel__category-title">
        <div class="heroes-panel__category-title">
[[File:Dota2_Agility_icon_solid_allmode.png|frameless|24px]]
            [[File:Dota2_Agility_icon_solid_allmode.png|frameless|24px]]
[[Ловкость]] ({{#iccupdb:datapoint|query=count::pagename|conditions=[[type::hero]] and [[extradata_primary::Ловкость]] and [[extradata_game::iCCup]]|template=Identity{{!}}param=count_pagename}})
            [[Ловкость]] ({{#cargo_query:table=Heroes|fields=count(DISTINCT name) AS total|where=extradata_primary='Ловкость' AND game='Dota1'|format=plain}})
</div>
        </div>
<ul class="heroes-panel__category-list">
        <ul class="heroes-panel__category-list">
{{#iccupdb:datapoint
            {{#cargo_query:
| conditions = [[type::hero]] and [[extradata_primary::Ловкость]] and [[extradata_game::iCCup]]
                table=Heroes
| limit = 1000
                |fields=name
| order = name asc
                |where=extradata_primary='Ловкость' AND game='Dota1'
| template = Hero Entry{{!}}userparam={{{subpage|}}}{{!}}vercheck={{{vercheck|}}}
                |limit=1000
}}
                |order=name ASC
</ul>
                |format=template
</div>
                |template=Hero Entry
                |named args=yes
                |subpage={{{subpage|}}}
                |vercheck={{{vercheck|}}}
            }}
        </ul>
    </div>


<div class="heroes-panel__category category--intelligence">
    <div class="heroes-panel__category category--intelligence">
<div class="heroes-panel__category-title">
        <div class="heroes-panel__category-title">
[[File:Dota2_Intelligence_icon_solid_allmode.png|frameless|24px]]
            [[File:Dota2_Intelligence_icon_solid_allmode.png|frameless|24px]]
[[Интеллект]] ({{#iccupdb:datapoint|query=count::pagename|conditions=[[type::hero]] and [[extradata_primary::Интеллект]] and [[extradata_game::iCCup]]|template=Identity{{!}}param=count_pagename}})
            [[Интеллект]] ({{#cargo_query:table=Heroes|fields=count(DISTINCT name) AS total|where=extradata_primary='Интеллект' AND game='Dota1'|format=plain}})
</div>
        </div>
<ul class="heroes-panel__category-list">
        <ul class="heroes-panel__category-list">
{{#iccupdb:datapoint
            {{#cargo_query:
| conditions = [[type::hero]] and [[extradata_primary::Интеллект]] and [[extradata_game::iCCup]]
                table=Heroes
| limit = 1000
                |fields=name
| order = name asc
                |where=extradata_primary='Интеллект' AND game='Dota1'
| template = Hero Entry{{!}}userparam={{{subpage|}}}{{!}}vercheck={{{vercheck|}}}
                |limit=1000
}}
                |order=name ASC
</ul>
                |format=template
</div>
                |template=Hero Entry
 
                |named args=yes
}}
                |subpage={{{subpage|}}}
                |vercheck={{{vercheck|}}}
            }}
        </ul>
    </div>
</div>
</div>
<noinclude>
<noinclude>
[[Category:Templates]]
[[Category:Templates]]
</noinclude>
</noinclude>

Версия от 18:00, 18 сентября 2024

           Файл:Dota2 Strength icon solid allmode.png
Сила (
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS total LIMIT 100' at line 1

Function: CargoSQLQuery::run Query: SELECT count(DISTINCT name) AS total FROM `cargo__Heroes` WHERE extradata_primary='Сила' AND game='Dota1' ORDER BY count(DISTINCT name) AS total LIMIT 100

)
    Error 1054: Unknown column 'extradata_primary' in 'WHERE'

    Function: CargoSQLQuery::run Query: SELECT `cargo__Heroes`.`_pageID` AS `cargo_backlink_page_id_Heroes`,`name` AS `name` FROM `cargo__Heroes` WHERE extradata_primary='Сила' AND game='Dota1' ORDER BY `cargo__Heroes`.`_pageID`,`name` LIMIT 100 

           Файл:Dota2 Agility icon solid allmode.png
Ловкость (
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS total LIMIT 100' at line 1

Function: CargoSQLQuery::run Query: SELECT count(DISTINCT name) AS total FROM `cargo__Heroes` WHERE extradata_primary='Ловкость' AND game='Dota1' ORDER BY count(DISTINCT name) AS total LIMIT 100

)
    Error 1054: Unknown column 'extradata_primary' in 'WHERE'

    Function: CargoSQLQuery::run Query: SELECT `cargo__Heroes`.`_pageID` AS `cargo_backlink_page_id_Heroes`,`name` AS `name` FROM `cargo__Heroes` WHERE extradata_primary='Ловкость' AND game='Dota1' ORDER BY `cargo__Heroes`.`_pageID`,`name` LIMIT 100 

           Файл:Dota2 Intelligence icon solid allmode.png
Интеллект (
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS total LIMIT 100' at line 1

Function: CargoSQLQuery::run Query: SELECT count(DISTINCT name) AS total FROM `cargo__Heroes` WHERE extradata_primary='Интеллект' AND game='Dota1' ORDER BY count(DISTINCT name) AS total LIMIT 100

)
    Error 1054: Unknown column 'extradata_primary' in 'WHERE'

    Function: CargoSQLQuery::run Query: SELECT `cargo__Heroes`.`_pageID` AS `cargo_backlink_page_id_Heroes`,`name` AS `name` FROM `cargo__Heroes` WHERE extradata_primary='Интеллект' AND game='Dota1' ORDER BY `cargo__Heroes`.`_pageID`,`name` LIMIT 100

Источник — https://wiki.iccup.org/index.php?title=Шаблон:HeroTable&oldid=403