====== sites ======
This page was used to test the [[wiki:database2_plugin]], which is not currently installed. Therefore, what would be a table is just the code used to show it.
[[.:]]
This page isn't intended for navigating Hârn, although it'll do in a pinch. This is a view of the database table that feeds and has been used to generate many of the other pages of holds, hundreds, shires, and grid squares. Notably, most of the links are rendered in a basic fashion. There are two ways of producing a working wiki link, with the ''onclick'' option being the uglier but faster-rendering one with respect to ''wikimarkup''. The latter can hopefully be used more broadly on pages with fewer of these rows and columns.
The former doesn't handle link text well, as can be seen in the Hundred column.
Additions to this table are also not intended to be made here directly. It's easier to paste the data into csv files, though the method of uploading them is still pretty wonky. It involves manipulating a different instance of HârnWiki on a local computer, exporting the data with the Advanced plugin, and then importing that zip here with that same plugin.
Edits to the existing data to correct errors may probably be done more easily here. Such changes made to the data here will be reflected in those pages querying this table, though the pages written directly with the data as it was at that time will stay as they are.
sitename, text, Site name, unique onclick=%{value}
altname , text, Alt name
hundred, "related SELECT id, hundred FROM districts", Hundred, wikimarkup
title, text, Title
holder, text, Holder, onclick=%{value}
acres, integer, Acres, headerlabel=AC
landquality, float, Land Quality, headerlabel=LQ
households, integer, Households, headerlabel=HH
liegeseat, "related SELECT id, sitename FROM sites a", Liege, onclick=%{value}
grid, text, Grid, wikimarkup
sitetype, "related SELECT id, abbrev FROM sitetypes", Site type
realm, text, Realm
domain, text, Domain
market, integer, Market, headerlabel=Mkt
manors, integer, Manors (levy), headerlabel=Manors
guard, text, Guard
acreslevy, integer, Acres (levy), headerlabel=ACL
householdslevy, integer, Households (levy), headerlabel=HHL
elevation, integer, Elevation, headerlabel=Elev
ore, text, Ore
population, integer, Population, headerlabel=Pop
work, text, Work, wikimarkup
===== Notes =====
==== Kaldor ====
- [[works:harnic_lore:greatclans:kaldor]] gives Laris Indama as the Bailiff of Kirden, while [[works:harnic_lore:knights:knights_lynnfana_hundred]] names Makel Ravintry. I've left the latter in place because I saw that one first and those Indamas are freaking everywhere.
- [[works:harnic_lore:greatclans:kaldor]] has Bailiff Towson's first name as Eldan vs. Marbic in [[works:harn:kaldor:wybend]]. The names in the latter work vary from canon elsewhere.
- The politics of Trobridge are murky at best. I've given the nod to self-styled "Lord" Kurson of Ondailis, though Freemaster Innkeeper Terlin of Wesindan could be named as well.
- [[works:harn:kaldor:fethael:elmeze]] and [[works:harn:kaldor:uldien]] name different Lord Dolasters of Elmeze: Talnin and Firkin, respectively. Likewise, the latter work differs in the same way with [[works:harn:kaldor:fethael:hyzevel]] (Selin vs. Tommas), [[works:harn:kaldor:fethael:medtald]] (Ilvos vs. Garulf), and with [[works:harn:kaldor:fethael:fethael]] for the Reeve of Tasthult (Tarryn of Gelt vs. Kobin of Sharlyn).
- [[works:harn:kaldor:nelafayn:nothrine]] names Sir Asket Cedamyne as Lord of Irians Manor, as oppsed to Clan Drasyme given in canon.
===== References =====
In addition to the articles cited within the table, information was also drawn from the following works.
==== Kaldor ====
* [[works:atlas_harnica:]]
* [[works:harn:kaldor:kaldor]]
* [[works:harnic_lore:greatclans:kaldor]]
* [[works:harnic_lore:knights:major_knights_kaldor]]
* [[works:harnic_lore:knights:minor_knights_kaldor_1]]
* [[works:harnic_lore:knights:minor_knights_kaldor_2]]
* [[works:harnic_lore:knights:knights_lynnfana_hundred]]
* [[works:harn:kaldor:uldien]] provides many names for the holders of surrounding manors.
* [[works:harn:kaldor:nelafayn:hasebe_nelafayn]] gave a few names from the surroundings.
* [[works:harn:kaldor:nelafayn:iversen]] gave up a couple bailiffs.
* [[works:wilderness:tontury]] names Ardin Labarn as Serolan of Halaina and Warden of Valdrun.
* [[works:harn:kaldor:gardiren]] names Ireald Curo as Lord of Ionsal.
* [[works:harn:kaldor:heru]] names Carmin Chelya as Bailiff of Antiven.
* [[works:religion:larani_lady_mould]] names the Rekela of Vadan.