Шаблон:СлучайныйАвтор: различия между версиями

Версия от 18:40, 28 сентября 2023

490

490

All list

Ошибка выражения: неопознанный символ пунктуации «»

-1

0 ALL1

-1 Random

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1,100' at line 1

Function: CargoSQLQuery::run Query: SELECT `Persona`.`_pageID` AS `cargo_backlink_page_id_Persona`,`Persona`.`Image` AS `Image` FROM `cargo__Persona` `Persona` WHERE `Persona`.`Image` IS NOT NULL ORDER BY `Persona`.`_pageID` DESC LIMIT -1,100

no-page

Читать дальше:

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1,100' at line 1

Function: CargoSQLQuery::run Query: SELECT `Persona`.`_pageID` AS `cargo_backlink_page_id_Persona`,`Persona`.`_pageName` AS `_pageName` FROM `cargo__Persona` `Persona` WHERE `Persona`.`Image` IS NOT NULL ORDER BY `Persona`.`_pageID` DESC LIMIT -1,100

@@ Строка 1: / Строка 1: @@
-{{#vardefine:random|{{#expr:{{#invoke:math|random|1|{{formatnum:{{PAGESINCATEGORY:Персоналии по алфавиту}}|R}}}}-1}}}}
+{{#vardefine:all|{{#cargo_query:tables=Persona|fields=COUNT(*)=Count|where=Persona.Image IS NOT NULL|format=ul}}}}
+{{#vardefine:all1|{{#invoke:StringToNum1|main|{{#var:all}}}}}}
+{{#vardefine:random|{{#expr:{{#invoke:math|random|1|{{#var:all1}}}}-1}}}}
 {{#vardefine:pname|{{#cargo_query:tables=Persona|fields=Persona._pageTitle|order by=Persona._pageID DESC|limit=1|no html|offset={{#var:random}}|more results text=|format=list}}|}}
+----
+{{#cargo_query:tables=Persona|fields=COUNT(*)=Count|where=Persona.Image IS NOT NULL|format=ul|columns=1}}
+{{#var:all}} All list
+{{#expr: {{#var:all}} round 0 }}
+{{#explode:{{#var:all}}|<ul><li>|0}} 0
+{{#explode:{{#var:all}}|•|1}} 1
+{{#explode:{{#var:all}}|•|2}} 2
+{{#explode:{{#var:all}}|•|-1}} -1
+{{#var:all1}} ALL1
+{{#var:random}} Random
 {{#cargo_query:
 tables=Persona
 |fields=Persona.Image
+|where=Persona.Image IS NOT NULL
 |order by=Persona._pageID DESC
 |limit=1
@@ Строка 15: / Строка 39: @@
 {{#invoke:TranscluderText|main|{{#var:pname}}#|sections = 1|templates=song|category=v}}__nocat__
 ----
-Читать дальше: {{#cargo_query:tables=Persona|fields=Persona._pageName|order by=Persona._pageID DESC|limit=1|offset={{#var:random}}|more results text=|format=list}}
+Читать дальше: {{#cargo_query:tables=Persona|fields=Persona._pageName|where=Persona.Image IS NOT NULL|order by=Persona._pageID DESC|limit=1|offset={{#var:random}}|more results text=|format=list}}