Difference between revisions of "Cousins"

From TNG_Wiki
Jump to navigation Jump to search
(2f corrects problem if no in-law marriages)
(Remove Category.)
 
(92 intermediate revisions by 29 users not shown)
Line 1: Line 1:
{{TNGmod
+
{{V12_cust_text}}{{TNGmod
| mod_name        = Cousins
+
| mod_name        = {{PAGENAME}}
 
| mod_summary    = Presents tables of all cousins of an individual or all cousin marriages or in-law marriages in a tree.  
 
| mod_summary    = Presents tables of all cousins of an individual or all cousin marriages or in-law marriages in a tree.  
 
| mod_validation  = The mod is XHTML compliant.[[Image:Valid-xhtml10.png|44px]]
 
| mod_validation  = The mod is XHTML compliant.[[Image:Valid-xhtml10.png|44px]]
| mod_last_update = 16 Dec 2017
+
| mod_last_update = 4 Mar 2023
| download_link  = [http://mossfamilytree.info/download.php?mod=cousins&version=10.1.3.2f 10.1.3.2f]
+
| download_link  = For{{Tv140}}<br />[https://www.royandboucher.com/ccount/click.php?id=709&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} cousins_14.0.0.5a.zip]<hr style="clear: both;"/>For PHP 8{{Tv130}}{{Tv120}}<br />[https://www.royandboucher.com/ccount/click.php?id=650&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} cousins_12.0.0.3.zip]<hr style="clear: both;"/>For{{Tv130}}{{Tv120}}{{Tv110}}{{Tv1010}}<br />[https://tng.lythgoes.net/wiki/images/0/07/Cousins_10.1.3.2g.zip Cousins_10.1.3.2g.zip]<!-- [http://mossfamilytree.info/download.php?mod=cousins&version=10.1.3.2g 10.1.3.2g] -->
| download_stats = [http://mossfamilytree.info/downloadstats.php?mod=cousins Downloads]
+
| download_stats = <!-- [http://mossfamilytree.info/downloadstats.php?mod=cousins Downloads] -->[https://www.royandboucher.com/ccount/index.php?action=stats&id=650-674-675-689-698-709 V12/v14 statistics]
 
| mod_author      = [[User:Chris Moss|Chris Moss]]
 
| mod_author      = [[User:Chris Moss|Chris Moss]]
| mod_url       = [[Cousins]]
+
| mod_url         = '''{{PAGENAME}}''' (this page)
| mod_support    = [http://mossfamilytree.info/suggest.php contact author]
+
| mod_support    = [https://tng.community/index.php?/forums/forum/21-addons/ TNG Community Forums]
| mod_contact    = [http://mossfamilytree.info/suggest.php contact author]
+
| mod_contact    = [https://tng.community/index.php?/forums/forum/21-addons/ TNG Community Forums]
| mod_version    = 10.1.3.2f
+
| mod_version    = 14.0.0.5a for TNG 14<br />12.0.0.3 for PHP 8/8.1<br />10.1.3.2g
 
| min_TNG_ver    = 10.1.3
 
| min_TNG_ver    = 10.1.3
| max_TNG_ver    = 11.1.1
+
| max_TNG_ver    = 14+
| TNG_file_list  = relateform.php, relationship.php, cust_text.php for English, French
+
| TNG_file_list  = relateform.php<br />relationship.php<br />cust_text.php<br />languages/English/cust_text.php<br />languages/English-UTF8/cust_text.php<br />languages/French/cust_text.php<br />languages/French-UTF8/cust_text.php<br />languages/Danish-UTF8/cust_text.php<br />languages/Dutch-UTF8/cust_text.php
 
| related_mods    =  
 
| related_mods    =  
 
| notes          =  
 
| notes          =  
}}
+
}}{| style="margin-right:0.5 em;" align="right"  
<!--{| style="margin-right:0.5 em;" align="right"  
 
 
| __TOC__
 
| __TOC__
|}-->
+
|}
 +
== Purpose of the mod ==
 +
This TNG modification presents tables of all cousins of an individual or all cousin marriages or in-law marriages in a tree.
 +
 
 +
== Developer ==
 +
This mod was developed by [[User:Chris Moss|Chris Moss]]. [[User:Newfloridian|Alan Craxford]] provided much of the inspiration for these reports with constant feedback. [[User:KenRoy|Ken Roy]] provided the French translation and many useful comments.
 +
 
 +
==Introduction==
 
The '''Cousins''' mod provides three modules which all include cousins and appear on the inner menu of the Relationships tab:
 
The '''Cousins''' mod provides three modules which all include cousins and appear on the inner menu of the Relationships tab:
 
#'''Cousins''' lists all the cousins of an individual up to a predefined limit which is initially 4th cousin.
 
#'''Cousins''' lists all the cousins of an individual up to a predefined limit which is initially 4th cousin.
Line 60: Line 66:
 
File:victoria-cousin-marriages.png|Cousin marriages involving Queen Victoria
 
File:victoria-cousin-marriages.png|Cousin marriages involving Queen Victoria
 
</gallery>
 
</gallery>
 +
 +
== Revision History ==
 +
{| border="0" cellspacing="1" cellpadding="2" class="wikitable"
 +
|-
 +
! Mod Version
 +
! TNG Version
 +
! Date
 +
! Contents
 +
 +
|- style="vertical-align:top;"
 +
| 14.0.0.5a
 +
| 14.0
 +
| style="white-space: nowrap;"|4 Mar 2023
 +
| Updated by [[User:KenRoy|Ken Roy]] to fix PHP Warning: Undefined variable $cousinsfound
 +
 +
|- style="vertical-align:top;"
 +
| 14.0.0.5
 +
| 14.0
 +
| style="white-space: nowrap;"|2 Feb 2023
 +
| Updated by [[User:KenRoy|Ken Roy]] with contributions by [[User:MichelKirsch|Michel Kirsch]], [[User:Bhemph|Brent Hemphill]]
 +
* Add collation and engine string to tables creations (cousins_mariages.php and inlaw_marriages.php)
 +
* updated Dutch translations provided by  [[User:Ckworld|Cees Kloosterman]]
 +
* updated Danish translations provided by [[User:Mfenger|Mogens C. Fenger]]
 +
* updated French translations by [[User:MichelKirsch|Michel Kirsch]]
 +
* Fix matching individual to family errors and minor corrections provided by Brent Hemphill
 +
* Fix old notations $row[index] as {$row['index']} in inlaw_marriages.php, cousins.php and cousin_marriages.php
 +
* fix issue with $tngconfig['tabs'] being deleted by TNG 14 once you make any changes to General Settings.
 +
 +
|- style="vertical-align:top;"
 +
| 14.0.0.4d_rc2
 +
| 14.0
 +
| style="white-space: nowrap;"|27 Dec 2022
 +
| Updated by [[User:KenRoy|Ken Roy]] to add Danish language provided by [[User:Mfenger|Mogens C. Fenger]]
 +
 +
|- style="vertical-align:top;"
 +
| 14.0.0.4c_b111
 +
| 14.0
 +
| style="white-space: nowrap;"|26 Nov 2022
 +
| Updated by [[User:KenRoy|Ken Roy]] with help from [[User:MichelKirsch|Michel Kirsch]] and [[User:Tngrlkrz|Ron Krzmarzick]] to correct previously posted v14.0.0.4c_b11, to include folder cousins_14.0.0.4c_b111 which was cleaned up to drop unused files
 +
 +
|- style="vertical-align:top;"
 +
| 14.0.0.4c_b11
 +
| 14.0
 +
| style="white-space: nowrap;"|25 Nov 2022
 +
| Updated by [[User:KenRoy|Ken Roy]] with help from [[User:MichelKirsch|Michel Kirsch]] and [[User:Tngrlkrz|Ron Krzmarzick]] to show the innermenu for Cousins All cousin marriages All in-law marriages on both the Relationships and Connections search forms
 +
 +
|- style="vertical-align:top;"
 +
| 12.0.0.3
 +
| 12.0
 +
| style="white-space: nowrap;"|10 Apr 2022
 +
| Updated by [[User:MichelKirsch|Michel Kirsch]] and [[User:KenRoy|Ken Roy]] to eliminate PHP 8 and 8.1 errors and to use TNG v12 cust_text anchors<br />Tested on TNG 12.3 by Michel and [[User:Tngrlkrz|Ron Krzmarzick]] and on TNG 13.1.1 and 13.1.2 by Ken who also tested with both MySQL 5.7 and MySQL 8 on TNG 13.1.2 beta
 +
 +
|- style="vertical-align:top;"
 +
| 10.1.3.2g
 +
| 10.1.3
 +
| style="white-space: nowrap;"|3 Sep 2018
 +
| Corrected another null issue. Also cleaned up the inner menu. Thanks Rick.
 +
 +
|- style="vertical-align:top;"
 +
| 10.1.3.2f
 +
| 10.1.3
 +
| style="white-space: nowrap;"|11 May 2018
 +
| Corrected issue when no in-law marriages. Thanks Ernest.
 +
 +
|- style="vertical-align:top;"
 +
| 10.1.3.2e
 +
| 10.1.3
 +
| style="white-space: nowrap;"|16 Dec 2017
 +
| Corrected problem for people not using default MySQL table names such as tng_children.
 +
 +
|- style="vertical-align:top;"
 +
| 10.1.3.2c
 +
| 10.1.3
 +
| style="white-space: nowrap;"|22 Jun 2017
 +
| Corrected a MySQL error in certain large Cousins queries. Also got the delete_tables link working. Made $text additions conditional so they only are loaded when needed.
 +
 +
|- style="vertical-align:top;"
 +
| 10.1.3.2a
 +
| 10.1.3
 +
| style="white-space: nowrap;"|22 Jun 2017
 +
| Restrict text changes to apply only to files in which they are used
 +
 +
|- style="vertical-align:top;"
 +
| 10.1.3.2
 +
| 10.1.3
 +
| style="white-space: nowrap;"|22 Jun 2017
 +
| Handle log file and bookmark and clean up urls
 +
 +
|- style="vertical-align:top;"
 +
| 10.1.3.1c
 +
| 10.1.3
 +
| style="white-space: nowrap;"|22 Jun 2017
 +
| Wouldn't install or ignore French version, didn't hide GEDCOM tab appropriately
 +
|}
  
 
==Installation==
 
==Installation==
 
The mod is installed in the normal way: unzip it; copy the files to the mods directory on your system, go to the mod manager, select it and press install. However it is strongly recommended that you do this first on a private computer with TNG set up on it because it can take some time to run the initial search, particularly if you have a large tree.  
 
The mod is installed in the normal way: unzip it; copy the files to the mods directory on your system, go to the mod manager, select it and press install. However it is strongly recommended that you do this first on a private computer with TNG set up on it because it can take some time to run the initial search, particularly if you have a large tree.  
 +
 +
<span style="color: red">After installation, remember to "Update the TNG Variables" in the WordPress Admin ------> TNG screen if you are using the TNG-WordPress-Plugin</span>
  
 
Below are some search results found in several trees. The first two were historic trees dating back at least 1,000 years and including many royalty and nobility. The third is a modern tree but still having a significant number of such relationships. The times are elapsed times on a standard Mac desktop. As you can see, the search time varies significantly not only with the size of the tree but also with the number of hits.
 
Below are some search results found in several trees. The first two were historic trees dating back at least 1,000 years and including many royalty and nobility. The third is a modern tree but still having a significant number of such relationships. The times are elapsed times on a standard Mac desktop. As you can see, the search time varies significantly not only with the size of the tree but also with the number of hits.
Line 85: Line 187:
  
 
The search times for in-law marriages were less severe ranging from 0.5 to 6.5 seconds for the above trees, but this is handled the same way thus reducing the risk from repetitive use. You will find that two tables have been added to the database: tng_cousinmarriages and tng_inlaw marriages. You can use different names if necessary using the options below.
 
The search times for in-law marriages were less severe ranging from 0.5 to 6.5 seconds for the above trees, but this is handled the same way thus reducing the risk from repetitive use. You will find that two tables have been added to the database: tng_cousinmarriages and tng_inlaw marriages. You can use different names if necessary using the options below.
 +
 +
=== TNG 14 anchors ===
 +
{{TNG 14.0|and after}}
 +
Relationship: The Relationship tab has been supplemented by an advanced relationship/connection search, powered by the Connections mod (by Michal Jarocinski).
 +
 +
In TNG v14 and later, the Cousins mod innermenu is anchored in both the Relationship tab/form and in the Connections search form.
 +
 +
{| class="wikitable"
 +
|-
 +
| Relationship tab anchor
 +
| [[File:TNG_14_relationship_tab.png|thumbs|600px]]
 +
|-
 +
| Connections form anchor showed on two separate lines on a laptop screen
 +
|[[File:TNG_14_connections_form.png|thumbs|600px]]
 +
|}
  
 
===Options available===
 
===Options available===
 
 
There are a large number of options and most of these use a commons settings file (cousins_inc.php). $maxcousins and $generations will affect the maximum time for search if there is sufficient 'width' in the tree to exercise them.
 
There are a large number of options and most of these use a commons settings file (cousins_inc.php). $maxcousins and $generations will affect the maximum time for search if there is sufficient 'width' in the tree to exercise them.
  
Line 120: Line 236:
 
|-
 
|-
 
| $birth || value of frel and mrel in children table || birth
 
| $birth || value of frel and mrel in children table || birth
 
 
|}
 
|}
  
==Acknowledgments==
+
== Sites using this mod ==
Alan Craxford provided much of the inspiration for these reports with constant feedback. [[User:KenRoy|Ken Roy]] provided the French translation and many useful comments.
+
If you download and install this mod, please add your TNG site to the table below:
  
== TNG User sites using this mod ==
+
{| border="0" cellspacing="1" cellpadding="2" class="wikitable" width="100%"
 
 
If you download and install this mod, please add your TNG sites to the table below.
 
 
 
{| border="0" cellspacing="1" cellpadding="2" class="wikitable"
 
 
|-
 
|-
 
! URL
 
! URL
 
! User
 
! User
 
! Note
 
! Note
! Mod-Version/TNG-Version
+
! Mod-Version
 +
! TNG-Version
 
! User-language
 
! User-language
|-
+
 
| [http://dustybits.info Dusty Bits of the Past]
+
|- style="vertical-align:top;"
| [[User:AlPrunty|Allen Prunty]]
 
| Using Amazon LightSail / Public
 
| 10.1.3.2e/11.1.2
 
| EN
 
|-
 
 
| [http://mossfamilytree.info Moss Family Tree]
 
| [http://mossfamilytree.info Moss Family Tree]
| [[User:Chris Moss|Chris Moss]]
+
| style="white-space: nowrap;"|[[User:Chris Moss|Chris Moss]]
 
|  
 
|  
| 10.1.3.1/11.0.1
+
| 10.1.3.1
| EN, Fr
+
| 11.0.1
|-
+
| EN,FR
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://www.royandboucher.com Our Roy and Boucher Family]
 +
| style="white-space: nowrap;"|[[User:KenRoy|Ken Roy]]
 +
| Beta tested on PHP 8, 8.1, and 8.2
 +
| 14.0.0.5a
 +
| 14.0.4
 +
| EN,FR
 +
 
 +
|- style="vertical-align:top;"
 
| [https://www.kmtrees.com Roots & Relatives Remembered]
 
| [https://www.kmtrees.com Roots & Relatives Remembered]
| [[User:Tngrlkrz|Ron Krzmarzick]]
+
| style="white-space: nowrap;"|[[User:Tngrlkrz|Ron Krzmarzick]]
| public / private
+
| Public & private
| 10.1.3.2e/11.1.2
+
| [https://www.kmtrees.com/mods-installed See Here]
| EN,DE,CS,ES
+
| [https://www.kmtrees.com/mods-installed See Here]
|-
+
| EN,DE,CS
 +
 
 +
|- style="vertical-align:top;"
 +
| [http://genealogy.mkirsch.be Racines Luxo-hennuyères]
 +
| style="white-space: nowrap;"|[[User:MichelKirsch|Michel Kirsch]]
 +
| Public site (registration)
 +
| 10.1.3.2g
 +
| 13.0.3
 +
| FR,EN,DE,NL
 +
 
 +
|- style="vertical-align:top;"
 
| [https://www.craxford-family.co.uk Craxford Family Genealogy Magazine]
 
| [https://www.craxford-family.co.uk Craxford Family Genealogy Magazine]
| [[User:newfloridian|Alan Craxford]]
+
| style="white-space: nowrap;"|[[User:newfloridian|Alan Craxford]]
| public and Wampserver
+
| Public and Wampserver
| 10.1.3.1/10.1.3
+
| 10.1.3.1
 +
| 10.1.3
 
| EN
 
| EN
|-
+
 
| [https://www.royandboucher.com Our Roy and Boucher Family]
+
|- style="vertical-align:top;"
| [[User:KenRoy|Ken Roy]]
+
| [http://dustybits.info Dusty Bits of the Past]
| Wampserver only currently.  Provided French translations
+
| style="white-space: nowrap;"|[[User:Alprunty|Allen Prunty]]
| 10.1.3.2/11.1.1
+
| Using Amazon LightSail / Public
| English, French
+
| 10.1.3.2e
|-
+
| 11.1.2
 +
| EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [http://drzewo.online/ Family tree of Marcin & Emilia Senderski]
 +
| style="white-space: nowrap;"|[[User:Mycroft|Marcin Senderski]]
 +
| Only home page is public
 +
| 10.1.3.2g
 +
| 13.0.4
 +
| EN,PL
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://lein.se/familjenjohnson/index.php Familjen Johnson]
 +
| style="white-space: nowrap;"|[[User:Leif Sweden|Leif Johnson]]
 +
| Public
 +
| 14.0.0.5a
 +
| 14.0.3
 +
| SE, EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [http://genealogy.oceanwharf.com Hooley Family Links]
 +
| style="white-space: nowrap;"|[[User:lastejas|Rick Hooley]]
 +
| Public/Private
 +
| [[User: lastejas|See Here]]
 +
| [[User: lastejas|See Here]]
 +
| EN
 +
 
 +
|- style="vertical-align:top;"
 
| [http://racine-ad.fr/TNG/index.php Racine d'Alsace]
 
| [http://racine-ad.fr/TNG/index.php Racine d'Alsace]
| J-Louis Valory
+
| style="white-space: nowrap;"|[[User:Louis42|J-Louis Valory]]
| Public/Private - Template 1
+
| Public/Private - T17 customised
| 10.1.3.2d/11.1.1
+
| 10.1.3.2g
| French
+
| 12.0.2
|-
+
| FR
| [https://www.thebrownfamilytree.com/index.php The Brown Family Tree]
+
 
| [[User:Slowjim|James Brown]]
+
|- style="vertical-align:top;"
| Public/Private - Template 4
 
| 10.1.3.2d/11.1.1
 
| EN
 
|-
 
 
| [https://www.martius-familie.de Martius Family]
 
| [https://www.martius-familie.de Martius Family]
| [[User:Hemar|Hendrik Martius]]
+
| style="white-space: nowrap;"|[[User:Hemar|Hendrik Martius]]
 
| Half public
 
| Half public
| 10.1.3.2d/11.0.2
+
| 10.1.3.2d
| DE, EN, FR, NL
+
| 12.0.1
|-
+
| DE,EN,FR,NL
 +
 
 +
|- style="vertical-align:top;"
 
| [https://www.ennever.com Ennever Family]
 
| [https://www.ennever.com Ennever Family]
| [[User:bennever|Barry Ennever]]
+
| style="white-space: nowrap;"|[[User:bennever|Barry Ennever]]
 
| Customised T4
 
| Customised T4
| 11.1.2
+
| 10.1.3.2
 +
| 13
 
| EN
 
| EN
|-
+
 
 +
|- style="vertical-align:top;"
 
| [https://www.famille-sabourin.net/index.php Les Sabourin d'Amérique]
 
| [https://www.famille-sabourin.net/index.php Les Sabourin d'Amérique]
| [[User:msabour|Michel Sabourin]]
+
| style="white-space: nowrap;"|[[User:msabour|Michel Sabourin]]
 
| public / private
 
| public / private
 
| 11.1.2
 
| 11.1.2
| French
+
| 13.0.4
|-
+
| FR
 +
 
 +
|- style="vertical-align:top;"
 
| [https://ourfamilyhistory.club/ Our Family History]
 
| [https://ourfamilyhistory.club/ Our Family History]
| [[User:Paul Barrett|Paul Barrett]]
+
| style="white-space: nowrap;"|[[User:Paul Barrett|Paul Barrett]]
 
| Public/Private site
 
| Public/Private site
| 10.1.3.2d / 11.1.2
+
| 10.1.3.2d
 +
| 11.1.2
 +
| EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [http://www.colegenealogy.net/ The Cole / Tanner Family Tree]
 +
| style="white-space: nowrap;"|[[User:dlcole|David Cole]]
 +
| Public/Private
 +
| [[User:Dlcole|see here]]
 +
| [[User:Dlcole|see here]]
 +
| EN,DE,FR,ES,NL
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://theroadtoethel.com The Road to Ethel]
 +
| style="white-space: nowrap;"|[[User:Alicia|Alicia Clemmons]]
 +
| Public site
 +
| 10.1.3.2d
 +
| 12.0.1
 
| EN
 
| EN
 
|-
 
|-
|}
 
  
== Revision History ==
+
|- style="vertical-align:top;"
 +
| [https://thebrownfamilytree.info/ Our Family History]
 +
| style="white-space: nowrap;"|[[User:Slowjim|James Brown]]
 +
| Public/Private site
 +
| 10.1.3.2g
 +
| 12.1
 +
| EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://www.ourfamilyhistories.org Our Family Histories]
 +
| style="white-space: nowrap;"|[[User:Bsl20b50|Bryan S. Larson]]
 +
| Public - T8 customized
 +
| [[User:Bsl20b50|see here]]
 +
| [[User:Bsl20b50|see here]]
 +
| EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [http://jarocinscy.pl/drzewo/index.php Baza danych Rodziny Jarocińskich]
 +
| style="white-space: nowrap;"|[[User:Mjaro|Michał Jarociński]]
 +
| non-public site, Template 7
 +
| 10.1.3.2g
 +
| 12.3
 +
| PL,EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://www.duttongenealogy.com The Duttons of New England]
 +
| style="white-space: nowrap;"|[[User:Darrin65|Darrin Dutton]]
 +
| Public / Private
 +
| 14.0.0.5a
 +
| 14.0.1
 +
| EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://huygens-vandemoortel-ancestry.be/ Huygens - Van de Moortel]
 +
| style="white-space: nowrap;"|[[User:Fluffy82|Tom Huygens]]
 +
| Public/Private on WordPress
 +
| 12.0.0.3
 +
| 13.1.2
 +
|NL
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://osagecountycousins.com Osage County Cousins]
 +
| style="white-space: nowrap;"|[[User:Milatech|Larry G Banks]]
 +
| Public / Private
 +
| 14.0.0.5a
 +
| 14.0
 +
| EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://www.genealogywings.com/ MOTYER Family Genealogy]
 +
| style="white-space: nowrap;"|[[User:JMM|John Mark Motyer]]
 +
| Public site
 +
| [https://www.genealogywings.com/jmm_pages/My-TNG-mods.php See here]
 +
| [https://www.genealogywings.com/jmm_pages/My-TNG-mods.php See here]
 +
| EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [http://www.mes-racines.com/saga/index.php La Saga BIGEY]
 +
| style="white-space: nowrap;"|[[User:Yegib|François BIGEY]]
 +
| Public
 +
| 14.0.0.5
 +
| 14.0
 +
|FR
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://www.josephoranholtz.com/ Joseph Oran Holtz Genealogy Pages]
 +
| style="white-space: nowrap;"|[[User:Stores|Jim Holt]]
 +
| Private
 +
| [[User:Stores|See Here]]
 +
| [[User:Stores|See Here]]
 +
| EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://harnettsheehanfamilies.com/ Harnett Sheehan Families]
 +
| style="white-space: nowrap;"|[[User:Kathy|Kathy Harnett Sheehan]]
 +
| Private/Very helpful mod!
 +
| 14.0.0.5a
 +
| 14.0.2
 +
| EN
  
{| border="1" cellspacing="5" cellpadding="2" width="100%" class="wikitable"
+
|- style="vertical-align:top;"
|-
+
| [https://datschetzky.genealogenstammtisch.net Stammbaum der Familie Datschetzky]
! Version
+
| style="white-space: nowrap;"|[[User:ChristianD|Christian Datschetzky]]
! Date
+
| Public
! Contents
+
| 14.0.0.5a
|-
+
| 14.0.3
| 10.1.3.2f
+
| DE,EN
| 11 May 2018
 
| corrected issue when no in-law marriages. Thanks Ernest.
 
|-
 
| 10.1.3.2e
 
| 16 Dec 2017
 
| corrected problem for people not using default MySQL table names such as tng_children.
 
|-
 
| 10.1.3.2c
 
| 22 Jun 2017
 
| corrected a MySQL error in certain large Cousins queries. Also got the delete_tables link working. Made $text additions conditional so they only are loaded when needed.
 
|-
 
| 10.1.3.2a
 
| 22 Jun 2017
 
| restrict text changes to apply only to files in which they are used
 
|-
 
| 10.1.3.2
 
| 22 Jun 2017
 
| handle log file and bookmark and clean up urls
 
|-
 
| 10.1.3.1c
 
| 22 Jun 2017
 
| wouldn't install or ignore French version, didn't hide GEDCOM tab appropriately
 
 
|}
 
|}
  
 +
[[Category:Mods for TNG v14]]
 +
[[Category:Mods for TNG v13]]
 +
[[Category:Mods for TNG v12]]
 
[[Category:Mods for TNG v11]]
 
[[Category:Mods for TNG v11]]
 
[[Category:Mods for TNG v10]]
 
[[Category:Mods for TNG v10]]
 +
 +
[[Category:relateform.php mods]]
 +
[[Category:relationship.php mods]]
 +
 +
[[Category:cust_text.php English mods]]
 +
[[Category:cust_text.php French mods]]
 +
[[Category:cust_text.php Danish mods]]
 +
[[Category:cust_text.php Dutch mods]]

Latest revision as of 17:50, 20 March 2024


Ambox notice.png The latest version of this mod uses the guidelines for TNG v12+ cust_text.php files. If you are using TNGv12+, and any cust_text.php file in this mod is marked with a Bad Target error, you need to update your cust_text.php files before you can install this mod. [Show instructions]

If you upgraded to TNGv12+, and did not update your cust_text.php files as instructed in the upgrade readme script, then you must use the TNG Mod Manager to update them. To do so:

  1. Go to Mod Manager, and select its "Recommended Updates" tab.
    (If the "Recommended Updates" tab is not visible, then go to the Mod Manager Options tab, select "Display Settings", and turn on the "Recommended Updates" tab.)
  2. Click the "Update" button in the "Recommended Updates" tab.
    Installed mods do not interfere with the update, and if you already have (or think you may have) run this update, it will not hurt for you to run it again.

[See details in the TNGv12 Change Impacts Article][Hide the instructions]

TNG 14.0
TNG 13.0
TNG 12.0


Cousins
Summary Presents tables of all cousins of an individual or all cousin marriages or in-law marriages in a tree.
Validation The mod is XHTML compliant.Valid-xhtml10.png
Mod Updated 4 Mar 2023
Download link For
TNG 14.0

cousins_14.0.0.5a.zip
For PHP 8
TNG 13.0
TNG 12.0

cousins_12.0.0.3.zip
For
TNG 13.0
TNG 12.0
TNG 11.0
TNG 10.1.0

Cousins_10.1.3.2g.zip
Download stats V12/v14 statistics
Author(s) Chris Moss
Homepage Cousins (this page)
Mod Support TNG Community Forums
Contact Developer TNG Community Forums
Latest Mod 14.0.0.5a for TNG 14
12.0.0.3 for PHP 8/8.1
10.1.3.2g
Min TNG V 10.1.3
Max TNG V 14+
Files modified
relateform.php
relationship.php
cust_text.php
languages/English/cust_text.php
languages/English-UTF8/cust_text.php
languages/French/cust_text.php
languages/French-UTF8/cust_text.php
languages/Danish-UTF8/cust_text.php
languages/Dutch-UTF8/cust_text.php
Related Mods
Notes

Purpose of the mod

This TNG modification presents tables of all cousins of an individual or all cousin marriages or in-law marriages in a tree.

Developer

This mod was developed by Chris Moss. Alan Craxford provided much of the inspiration for these reports with constant feedback. Ken Roy provided the French translation and many useful comments.

Introduction

The Cousins mod provides three modules which all include cousins and appear on the inner menu of the Relationships tab:

  1. Cousins lists all the cousins of an individual up to a predefined limit which is initially 4th cousin.
  2. All cousin marriages provides a list of of those marriages which have occurred between close relatives.
  3. All in-law marriages explores multiple marriages between two families, both siblings and cousins.

Apart from the first, these searches can take quite a long time depending on the size of the tree. Therefore the search itself is restricted to administrators and the basic results are cached in the database so that anyone can retrieve them on a subsequent use (including the administrator). The table can be updated when it is necessary, It is also possible that the searches can be computed on a personal computer and uploaded to the webserver. Caution: The computation uses temporary tables and these are usually not available for servers based on USB memory sticks.

Description of mod

Cousins

The start of a listing of Queen Victoria's cousins (click to enlarge)

The first display shows for any person in the tree all their cousins, by default from first to fourth, if they have any. The number to display may be set to any number but increasing it to 7, 10 or more will inevitably take more time if at many generations exist in the tree. (Click on the picture on the right to enlarge it.)

The name of the cousin is followed by brief defails of their life. Clicking on the cousin's name will show the relationship between the root person and the cousin including the ancestors through whom they are connected.

All cousin marriages

The start of a listing of cousin marriages of European royalty (click to enlarge)

Occasional examples are found in many family trees of cousins or other close relatives marrying each other. Although marriages between first cousins are illegal in many US states, more distant cousin marriages are permitted and may be more common than people expect. This display collects all the examples in a tree together. The display puts the names of the husband and wife alongside the names of their common ancestors with dates and places of marriage. The list is sorted by the closeness of the relationship and the date of the marriage.

The number in the "Descent" column shows the number of generations from the common ancestor on the husband and wife's side resepectively. First cousins are thus represented as 2:2, second cousins 3:3 etc. The reason for this is that it is possible to go lower. The picture at the right shows examples of nephew-niece marriages (1:2). Brother-sister incest is represented as 1:1 and father daughter incest as 0:1. The example of Louis XIV and Marie-Therese of Spain shows an example of double first-cousin marriage. Where only one of the ancestors is shared, so that it is a half-cousin relationship, a footnote annotation (*) is added in the descent column and only the common ancestor is shown.

The relationship can be explored by clicking on the husband or wife's name which will always show their marriage first followed by their other relationships. Clicking on an ancestor shows instead a descendancy tree in which the cousin marriage will appear twice. This also works where there is only one common ancestor.

Most examples are not as close as these, and involve more distant cousins. So 2:3 (or 3:2) is a first cousin once removed, . They sometimes occur in clusters and to make these easier to spot, when names are repeated an occurrence number is added in square brackets after the name - [2], [3] etc. These are actually links to a filter which will produce a separate report for the person concerned.

All in-law marriages

This records multiple marriages between two families. Sometimes two siblings in one family marry siblings or cousins in another family. This strengthens the ties between the two families more than a single marriage but does not in itself bring any genetic implications. It can include affinal marriages such as a man marrying his dead wife's sister, but most such marriages are not properly described as affinal and indeed there is no common name for this. They usually occur in pairs but sometimes happen in groups of three or more.

In-law marriages in royal tree (click to enlarge)

This display shows all such marriages in a tree in groups ordered by date of marriage. The second line of each group shows the way in which the second marriage relates to the first using the codes "s" for sibling, "c" for cousin, "h" for half-sibling and "p" for same person. Thus one can have "s-s" where two siblings in one family marry siblings in the other family, "s-c" for siblings in one and cousins in the other, "c-c" where cousins in one marry cousins in the other, "h-s" where half-siblings in one marry siblings in the other and so on. If the same person marries two members of another family one can get "p-s", "p-c" etc.

On each line, members of one family are placed first and the other second, so the second line is marked "Sibling/Cousin/Person" and "Spouse" instead of "Husband" and "Wife", because the first person on the second line may be female. Clicking on a person's name will clarify their relation to the person in the same family. The first person on a third line (if there is one) will also relate to the first person.

Examples of all of these are shown in the royal example on the right. A repeated person is also marked with a number in square brackets. Thus Henry VIII is shown three times--not only were Ann Boleyn and Catherine Howard related, but Catherine of Aragon had previously been married to Henry VIII's brother.

Extra Screenshots

Revision History

Mod Version TNG Version Date Contents
14.0.0.5a 14.0 4 Mar 2023 Updated by Ken Roy to fix PHP Warning: Undefined variable $cousinsfound
14.0.0.5 14.0 2 Feb 2023 Updated by Ken Roy with contributions by Michel Kirsch, Brent Hemphill
  • Add collation and engine string to tables creations (cousins_mariages.php and inlaw_marriages.php)
  • updated Dutch translations provided by Cees Kloosterman
  • updated Danish translations provided by Mogens C. Fenger
  • updated French translations by Michel Kirsch
  • Fix matching individual to family errors and minor corrections provided by Brent Hemphill
  • Fix old notations $row[index] as {$row['index']} in inlaw_marriages.php, cousins.php and cousin_marriages.php
  • fix issue with $tngconfig['tabs'] being deleted by TNG 14 once you make any changes to General Settings.
14.0.0.4d_rc2 14.0 27 Dec 2022 Updated by Ken Roy to add Danish language provided by Mogens C. Fenger
14.0.0.4c_b111 14.0 26 Nov 2022 Updated by Ken Roy with help from Michel Kirsch and Ron Krzmarzick to correct previously posted v14.0.0.4c_b11, to include folder cousins_14.0.0.4c_b111 which was cleaned up to drop unused files
14.0.0.4c_b11 14.0 25 Nov 2022 Updated by Ken Roy with help from Michel Kirsch and Ron Krzmarzick to show the innermenu for Cousins All cousin marriages All in-law marriages on both the Relationships and Connections search forms
12.0.0.3 12.0 10 Apr 2022 Updated by Michel Kirsch and Ken Roy to eliminate PHP 8 and 8.1 errors and to use TNG v12 cust_text anchors
Tested on TNG 12.3 by Michel and Ron Krzmarzick and on TNG 13.1.1 and 13.1.2 by Ken who also tested with both MySQL 5.7 and MySQL 8 on TNG 13.1.2 beta
10.1.3.2g 10.1.3 3 Sep 2018 Corrected another null issue. Also cleaned up the inner menu. Thanks Rick.
10.1.3.2f 10.1.3 11 May 2018 Corrected issue when no in-law marriages. Thanks Ernest.
10.1.3.2e 10.1.3 16 Dec 2017 Corrected problem for people not using default MySQL table names such as tng_children.
10.1.3.2c 10.1.3 22 Jun 2017 Corrected a MySQL error in certain large Cousins queries. Also got the delete_tables link working. Made $text additions conditional so they only are loaded when needed.
10.1.3.2a 10.1.3 22 Jun 2017 Restrict text changes to apply only to files in which they are used
10.1.3.2 10.1.3 22 Jun 2017 Handle log file and bookmark and clean up urls
10.1.3.1c 10.1.3 22 Jun 2017 Wouldn't install or ignore French version, didn't hide GEDCOM tab appropriately

Installation

The mod is installed in the normal way: unzip it; copy the files to the mods directory on your system, go to the mod manager, select it and press install. However it is strongly recommended that you do this first on a private computer with TNG set up on it because it can take some time to run the initial search, particularly if you have a large tree.

After installation, remember to "Update the TNG Variables" in the WordPress Admin ------> TNG screen if you are using the TNG-WordPress-Plugin

Below are some search results found in several trees. The first two were historic trees dating back at least 1,000 years and including many royalty and nobility. The third is a modern tree but still having a significant number of such relationships. The times are elapsed times on a standard Mac desktop. As you can see, the search time varies significantly not only with the size of the tree but also with the number of hits.

Cousin marriages
Families People Total cousin marriages found Time taken (secs)
3rd cousins 6th cousins 3rd cousins 6th cousins
1,400 3,000 78 106 1.5 2.7
20,000 39,000 798 2,033 14.9 110
4,900 17,000 48 65 4.0 6.2

When the system is installed, the cousin marriages and in-law marriages can only be activated by an administrator. Anyone else will simply get a message asking them to contact an administrator. When an administrator runs it, the basic results will be stored in a new table in the database from which they can then be retrieved by anyone at low cost. (The low cost is basically making sure that the proper visibility rules for living persons are observed.) Subsequently even an administrator will get the same results unless they want to redo the search. The inner menu will at this stage look like this:

Cousin-marriage-inner-menu.png

Clicking on All Cousin Marriages will retrieve the current stored results. To redo the search, click on the "redo" circular arrow symbol.

The search times for in-law marriages were less severe ranging from 0.5 to 6.5 seconds for the above trees, but this is handled the same way thus reducing the risk from repetitive use. You will find that two tables have been added to the database: tng_cousinmarriages and tng_inlaw marriages. You can use different names if necessary using the options below.

TNG 14 anchors

TNG version: 14.0

Relationship: The Relationship tab has been supplemented by an advanced relationship/connection search, powered by the Connections mod (by Michal Jarocinski).

In TNG v14 and later, the Cousins mod innermenu is anchored in both the Relationship tab/form and in the Connections search form.

Relationship tab anchor thumbs
Connections form anchor showed on two separate lines on a laptop screen thumbs

Options available

There are a large number of options and most of these use a commons settings file (cousins_inc.php). $maxcousins and $generations will affect the maximum time for search if there is sufficient 'width' in the tree to exercise them.

Option Purpose Default value
$cousins include cousins module 1
$cousinmarriages include cousin marriages module 1
$inlaws include in-law marriages module 1
$relationships max relationships to show in relationships display 4
$maxcousins max cousins number in cousins module 4
$generations max generations for cousin marriages (=cousins+1) 4
$updateoption allows online updates for cousin marriages and inlaw marriages 1
$cousin_marriages_table table name in database tng_cousin_marriages
$inlaw_marriages_table table name in database tng_inlaw_marriages
Options for cousin_marriages only
$print_time provide detailed timings for the search 0
$showmarriages show marriage place and date, which takes 4 extra columns 1
$allcousins include non-genetic cousins (e.g. adopted) 1
$birth value of frel and mrel in children table birth

Sites using this mod

If you download and install this mod, please add your TNG site to the table below:

URL User Note Mod-Version TNG-Version User-language
Moss Family Tree Chris Moss 10.1.3.1 11.0.1 EN,FR
Our Roy and Boucher Family Ken Roy Beta tested on PHP 8, 8.1, and 8.2 14.0.0.5a 14.0.4 EN,FR
Roots & Relatives Remembered Ron Krzmarzick Public & private See Here See Here EN,DE,CS
Racines Luxo-hennuyères Michel Kirsch Public site (registration) 10.1.3.2g 13.0.3 FR,EN,DE,NL
Craxford Family Genealogy Magazine Alan Craxford Public and Wampserver 10.1.3.1 10.1.3 EN
Dusty Bits of the Past Allen Prunty Using Amazon LightSail / Public 10.1.3.2e 11.1.2 EN
Family tree of Marcin & Emilia Senderski Marcin Senderski Only home page is public 10.1.3.2g 13.0.4 EN,PL
Familjen Johnson Leif Johnson Public 14.0.0.5a 14.0.3 SE, EN
Hooley Family Links Rick Hooley Public/Private See Here See Here EN
Racine d'Alsace J-Louis Valory Public/Private - T17 customised 10.1.3.2g 12.0.2 FR
Martius Family Hendrik Martius Half public 10.1.3.2d 12.0.1 DE,EN,FR,NL
Ennever Family Barry Ennever Customised T4 10.1.3.2 13 EN
Les Sabourin d'Amérique Michel Sabourin public / private 11.1.2 13.0.4 FR
Our Family History Paul Barrett Public/Private site 10.1.3.2d 11.1.2 EN
The Cole / Tanner Family Tree David Cole Public/Private see here see here EN,DE,FR,ES,NL
The Road to Ethel Alicia Clemmons Public site 10.1.3.2d 12.0.1 EN
Our Family History James Brown Public/Private site 10.1.3.2g 12.1 EN
Our Family Histories Bryan S. Larson Public - T8 customized see here see here EN
Baza danych Rodziny Jarocińskich Michał Jarociński non-public site, Template 7 10.1.3.2g 12.3 PL,EN
The Duttons of New England Darrin Dutton Public / Private 14.0.0.5a 14.0.1 EN
Huygens - Van de Moortel Tom Huygens Public/Private on WordPress 12.0.0.3 13.1.2 NL
Osage County Cousins Larry G Banks Public / Private 14.0.0.5a 14.0 EN
MOTYER Family Genealogy John Mark Motyer Public site See here See here EN
La Saga BIGEY François BIGEY Public 14.0.0.5 14.0 FR
Joseph Oran Holtz Genealogy Pages Jim Holt Private See Here See Here EN
Harnett Sheehan Families Kathy Harnett Sheehan Private/Very helpful mod! 14.0.0.5a 14.0.2 EN
Stammbaum der Familie Datschetzky Christian Datschetzky Public 14.0.0.5a 14.0.3 DE,EN