Add DNA Test Results

From TNG_Wiki
Jump to navigation Jump to search
Restricted Downloads of Add DNA Test Results are restricted to logged in users. If you do not have a user account on the TNG Wiki use the Request Account link to request a user account Restricted
Caution If you have trouble downloading with Google Chrome, Vivaldi, Brave or other Chromium based browser, try using a right-click and select Open in new Window, then F5, or use another browser such as Firefox Caution


Ambox notice.png The Add DNA Test Results applies to TNG v11 only. This mod is obsolete with TNG v12 which incorporated the code.
TNG 11.0


Add DNA Test Results
Summary This mod adds input fields for test results to the new DNA feature in TNG V11.
Validation This mod is XHTML compliant.Valid-xhtml10.png
Mod Updated 8 Mar 2018
Download link
TNG 11.1.1

add_dna_test_results_v11.1.1.9a.zip


TNG 11.0

add_dna_test_results_v11.0.0.7g.zip


Download stats See download statistics
Author(s) Jeff Robison, Ken Roy
Homepage Add DNA Test Results (This page)
Mod Support TNG Community Forums
Contact Developer My Mod Support
Latest Mod 11.1.1.9a
Min TNG V 11.0
Max TNG V 11.1.2
Files modified

languages/English/cust_text.php
languages/English-UTF8/cust_text.php
admin_add_dna_test.php
admin_update_dna_test.php
admin_new_dna_test.php
admin_edit_dna_test.php
show_dna_test.php
getperson.php (v11.0.0.1 of mod)
Related Mods
Notes

Purpose of the mod

This mod adds input fields for test results to the new DNA feature in TNG V11.

  • Tests displayed on a person's page are collapsed.
  • Create DNA test groups.
  • Select tests on the Y-DNA Tests page for comparison.
  • Moved all DNA related setting to Admin Setup >> Configuration >> General Settings >> DNA Tests.
  • Input fields were added in Admin Setup >> Configuration >> General Settings >> DNA Tests for column heading background and text colors on the Y-DNA comparison page.
    To initialize the column heading colors go to Admin Setup >> Configuration >> General Settings >> DNA Tests and then click 'Save' at the bottom of the page.

Clicking the 'Update DNA Tests Table' button in Mod Manager for this mod is required after installation. Be sure to back up ALL dna tables before clicking the 'Update DNA Tests Table' button.

Developer

This mod was developed by Jeff Robison and Ken Roy.
Credits also go to Darryl Brady, Leanne Chilver, LornaHen, and Roger Moffat for suggestions.
* View all mods by Jeff Robison

Requirements

  • A working TNG V11 installation.
  • An installed current version of the Mod Manager.

Automated Installation

  1. Download the zip file. Upload and Extract to the mods folder.
  2. Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files to install Add DNA Test Results

Post Install Requirements

You need to, at a minimum, open and save the Admin > Setup > General Settings. You may want to review the DNA Tests section and make some changes before clicking the Save button.

In the event of a problem

Conflicts

If you install the Mobile Site Enhancements mod before you install this mod
After you install this mod, the Mobile Site Enhancements will show a Bad Target at line 383 in Mod Manager
Both mods are actually installed and show work correctly.

Revision History

Version Date Contents
v11.1.1.9a 26 Mar 2018 Updated to
  • remove obsolete code in admin_add_dna_test.php
  • update German translation
v11.1.1.9 8 Mar 2018 Updated for fix following:
  • removed Haplogroup from atDNA tests
  • set confirmed flag when adding/editing mtDNA tests
  • show haplogroup as confirmed only if confirmed flag is set
  • removed automatically finding Ancestral Surnames for atDNA test to fix max execution timeouts
  • added German text provided by Tobias Kemper
v11.1.1.8 23 May 2017 Updated for PHP prepared statements for MySQL changes made in TNG 11.1.1. No other code changes from v11.0.0.7.g
v11.0.0.7g 20 May 2017 Updated to dummy proof the Max DNA results if users do not save the Admin > General Settings after installing the mod
v11.0.0.7f 24 March 2017
  • Fixed the page navigation when max results per page is exceeded.
  • Added a tab to return to DNA tests page after adding group(s).
  • Added a 'DNA Tests Max Search Results' field in Admin >> Setup >> General Settings >> DNA Tests.
v11.0.0.7d 21 March 2017 Fixed the Administrator Notes field to accept quotation marks.
v11.0.0.7c 14 February 2017 Fixed mode value row alignment on the Y-DNA test compare page when empty values are present.
Such as this partial Ancestry 46 marker test result...
13,23,15,11,11,14,12,12,13,13,14,30,17,9,10,11,11,24,15,20,29,15,15,17,17,10,12,19,23,16,,,,,,17,12,,,,,,,,,,,,,,,,,,,,12
v11.0.0.7b 13 February 2017 Updated for sites using PHP versions earlier than 5.5.
v11.0.0.7a 05 February 2017 Updated for TNG V11.1
  • Removed code from the mod that is now present with TNG v11.1
  • Fixed mod conflict with Family Indicators Mod
  • DNA groups table will now optimize/back-up on batch optimize/back-up.
  • Moved all DNA related settings to Admin Setup >> Configuration >> General Settings >> DNA Tests.
  • Input fields were added in Admin Setup >> Configuration >> General Settings >> DNA Tests for column heading background and text colors on the Y-DNA comparison page.
    To initialize the column heading colors go to Admin Setup >> Configuration >> General Settings >> DNA Tests and then click 'Save' at the bottom of the page.

Clicking the 'Update DNA Tests Table' button in Mod Manager for this mod is required after installation.

v11.0.0.7 29 January 2017
  • DNA groups table will now optimize/back-up on batch optimize/back-up.
  • Moved all DNA related settings to Admin Setup >> Configuration >> General Settings >> DNA Tests.
  • Input fields were added in Admin Setup >> Configuration >> General Settings >> DNA Tests for column heading background and text colors on the Y-DNA comparison page.
    To initialize the column heading colors go to Admin Setup >> Configuration >> General Settings >> DNA Tests and then click 'Save' at the bottom of the page.

Clicking the 'Update DNA Tests Table' button in Mod Manager for this mod is required after installation.

v11.0.0.6 12 December 2016
  • Media Links field added. In this field you enter the media ID's separated with commas. (5228,5229)
  • You can now enter a family ID in the Most Recent Common Ancestor field.

Clicking the 'Update DNA Tests Table' button in Mod Manager for this mod is required after installation.

v11.0.0.5 30 October 2016 The following fields added
  • Most Distant Ancestor.
  • Most Recent Common Ancestor for all test types.
  • Administrator notes (Admin only) for all test types.
  • Show DNA Test Number Publicly option is available in Admin>>Setup>>General settings>>Privacy.
  • mtDNA Reference sequence selection (RSRS or rCRS).
  • mtDNA Coding region differences.
  • mtDNA Extra mutations.

Clicking the 'Update DNA Tests Table' button in Mod Manager for this mod is required after installation.

v11.0.0.4 18 September 2016 Following changes made
  • After suggestions by Darryl Brady:
    Added 'Ancestral surnames' field to atDNA tests.
    The field is auto-filled if a person ID is present and the field is empty.
    Added a parameter in Mod Manager after installation to exclude surnames in this 'Ancestral surnames' field, such as 'Unknown', when auto-filling.
  • Column headings were not displayed when only 1 test was attached to a person in getperson.php. Fixed.

Clicking the 'Update DNA Tests Table' button in Mod Manager for this mod is required after installation.

v11.0.0.3b 08 September 2016 With the introduction of Haplogoup in browse_dna_tests.php the displays for atDNA and X-DNA were misaligned. Fixed.
v11.0.0.3a 05 September 2016 Following changes made
  • Added Haplogroup to browse_dna_tests.php and to compare_selected_dna.php.
  • In compare_selected_dna.php the compound Y-DNA DYS value column headings are expanded.
  • With this version you can enter compound Y-DNA DYS values such as (DYS 464) as ,15-15-16-17,.
  • In my case, for example, I COULD enter
    13,24,14,10,11-14,12,12,12,13,14,30,17,9-10,11,11,24,15,19,30,15-15-16-17,11,11,19,23,15,15,16,17,36-37,12,12
    OR I could enter all CSV
    13,24,14,10,11,14,12,12,12,13,14,30,17,9,10,11,11,24,15,19,30,15,15,16,17,11,11,19,23,15,15,16,17,36,37,12,12
    There is no need to change your existing Y-DNA data entry for Y-DNA tests.
    Compound Y-DNA DYS values will still be hyphenated whichever way you choose for display.

Clicking the 'Update DNA Tests Table' button in Mod Manager for this mod is required after installation.

v11.0.0.3 06 August 2016 Following changes made
  • DNA display on a person's page is collapsed if there is more than 1 test.
  • Search by 'Test Type' and/or 'Test Group' added.

Clicking the 'Update DNA Tests Table' button in Mod Manager for this mod is required after installation.

v11.0.0.2 16 June 2016 Following changes made
  • Added the ability to create DNA groups and assign tests to a group (Admin>>DNA Tests>>'DNA Groups' tab).
  • Added test selection (check box) to DNA Tests page (For comparison).
  • Added a test result comparison page for selected tests.
  • Added a tab 'All DNA tests' (DNA Tests page) to the show_dna_test.php page.
v11.0.0.1 21 May 2016 Following changes made
  • Added DNA Test Results display to getperson.php for Y-DNA and mtDNA tests
  • Added a Person not in database field for test taker who is not in the TNG database (Ken Roy)
  • Added a Confirmed Haplogroup field that displays the results in green
  • Added new options that control what is displayed for the test on a person's page
  • Added a Keep Name Private option to protect the privacy of the test taker
v11.0.0.0 25 October 2015 Initial Release of the mod

Custom Text Additions

Note: The config file only includes the English language changes, so if you support multiple languages you can modify the config file to add the custom text for those other languages, or manually add the following custom text to each of your other languages with appropriate translations.

English custom text is included in the mod. This Is For Reference Only!

//added by Add DNA Test Results
$admtext['dnatestsettings'] = "DNA Tests Settings";
$admtext['dnatestscomparecolors'] = "Y-DNA Compare Tests Column Heading Colors";
$admtext['getcolorcodes'] = "Get Color Codes Here";
$admtext['mainbackground'] = "Main heading background color";
$admtext['modebackground'] = "Mode values background color";
$admtext['fastmutbackground'] = "Fast mutating background color";
$admtext['background1_12'] = "Markers 1-12 background color";
$admtext['background13_25'] = "Markers 13-25 background color";
$admtext['background26_37'] = "Markers 26-37 background color";
$admtext['background38_67'] = "Markers 38-67 background color";
$admtext['background111'] = "Markers 68-111 background color";
$admtext['textcolor'] = "Text color";
$admtext['dnalater'] = "Note: More information may be added, and the test linked to more individuals, on the next screen.";
$admtext['markers'] = "Number of Markers";
$admtext['marker_values'] = "Marker Values";
$admtext['test_values'] = "Test Values";
$admtext['hvr_values'] = "HVR Differences";
$admtext['hvr1_values'] = "HVR1 Differences";
$admtext['hvr2_values'] = "HVR2 Differences";
$admtext['separate'] = "Separate values with commas";
$admtext['person_name'] = "Person not in database";
$admtext['text_and'] = "AND";
$admtext['privsection'] = "Privacy";
$admtext['text_private'] = "Private";
$admtext['configsettings'] = "General Settings";
$admtext['addtotestgroup'] = "Add Test To A Group";
$admtext['dna_group'] = "DNA Group";
$admtext['dna_groups'] = "DNA Groups";
$admtext['groupid'] = "Group ID";
$admtext['addgroup'] = "Add Group";
$admtext['entergroupid'] = "Please enter a group ID";
$admtext['entergroupdesc'] = "Please enter a group description";
$admtext['confgroupdelete'] = "Are you sure you want to delete this group?";
$admtext['modifygroup'] = "Edit Existing Group";
$admtext['ancestral_surnames'] = "Ancestral surnames";
$admtext['mda'] = "Most distant ancestor";
$admtext['mrca'] = "Most recent common ancestor";
$admtext['coding_reg'] = "Coding region differences";
$admtext['xtra_mut'] = "Extra mutations";
$admtext['admin_notes'] = "Administrator notes";
$admtext['ref_seq'] = "Reference sequence";
$admtext['rsrs'] = "RSRS (Reconstructed Sapiens Reference Sequence)";
$admtext['rcrs'] = "rCRS (revised Cambridge Reference Sequence)";
$admtext['show_test_number'] = "Show DNA Test Number Publicly";
$admtext['medialinks'] = "Media links";
$text['test_number'] = "Test Number/Name";
$text['mode_values'] = "Mode Values";
$text['select'] = "Select";
$text['selectall'] = "Select All";
$text['clearall'] = "Clear All";
$text['compareselected'] = "Compare Selected";
$text['dnatestscompare'] = "Compare DNA Tests";
$text['test_type'] = "Test Type";
$text['taken_by'] = "Taken By";
$text['keep_name_private'] = "Keep Name Private";
$text['haplogroup'] = "Haplogroup";
$text['confirmed'] = "Confirmed";
$text['predicted'] = "Predicted";
$text['test_results'] = "Test Results";
$text['test_info'] = "Test Information";
$text['test_info_display'] = "Test Information To Display";
$text['relevant_links'] = "Relevant links";
$text['hvr1'] = "HVR1";
$text['hvr2'] = "HVR2";
$text['testgroup'] = "Test Group";
$text['dna_test'] = "DNA test";
$text['dna_tests'] = "DNA Tests";
$text['browsealltests'] = "Browse All Tests";
$text['all_dna_tests'] = "All DNA tests";
$text['fastmutating'] = "Fast Mutating";
$text['people_have'] = "people have linked a DNA test to";
$text['person_has'] = "person has linked a DNA test to";
$text['dna_info_head'] = "DNA Test Info";
$text['alltypes'] = "All Types";
$text['allgroups'] = "All Groups";
$text['Ydna_LITbox_info'] = "Test(s) linked to this person were not necessarily taken by this person.<br />The 'Haplogroup' column displays data in red if the result is 'Predicted' or green if the test is 'Confirmed'";

Norwegian/cust_text.php or the Norwegian-UTF8/cust_text.php

//Translation provided by Jan-Thore Solem for Add DNA Test Results
$admtext['dnatestsettings'] = "DNA Tests Settings";
$admtext['dnatestscomparecolors'] = "Y-DNA Compare Tests Column Heading Colors";
$admtext['getcolorcodes'] = "Get Color Codes Here";
$admtext['mainbackground'] = "Main heading background color";
$admtext['modebackground'] = "Mode values background color";
$admtext['fastmutbackground'] = "Fast mutating background color";
$admtext['background1_12'] = "Markers 1-12 background color";
$admtext['background13_25'] = "Markers 13-25 background color";
$admtext['background26_37'] = "Markers 26-37 background color";
$admtext['background38_67'] = "Markers 38-67 background color";
$admtext['background111'] = "Markers 68-111 background color";
$admtext['textcolor'] = "Text color";
$admtext['dnalater'] = "NB: Mer informasjon kan legges til, og testen linkes til flere personer på neste skjermbilde.";
$admtext['markers'] = "Antall markører";
$admtext['marker_values'] = "Markørverdier";
$admtext['test_values'] = "Testverdier";
$admtext['hvr_values'] = "HVR Forskjeller";
$admtext['hvr1_values'] = "HVR1 Forskjeller";
$admtext['hvr2_values'] = "HVR2 Forskjeller";
$admtext['separate'] = "Skill verdier med komma";
$admtext['person_name'] = "Personen ikke i databasen";
$admtext['text_and'] = "OG";
$admtext['privsection'] = "Personvern";
$admtext['text_private'] = "Privat";
$admtext['configsettings'] = "Generelle";
$admtext['addtotestgroup'] = "Legg testen til i en gruppe";
$admtext['dna_group'] = "DNA gruppe";
$admtext['dna_groups'] = "DNA grupper";
$admtext['groupid'] = "Gruppe ID";
$admtext['addgroup'] = "Legg til gruppe";
$admtext['entergroupid'] = "Angi en gruppe ID";
$admtext['entergroupdesc'] = "Angi en gruppebeskrivelse";
$admtext['confgroupdelete'] = "Er du sikker på at du vil slette denne gruppen?";
$admtext['modifygroup'] = "Endre eksisterende gruppe";
$admtext['ancestral_surnames']= "Ancestral etternavn";
$admtext['mda'] = "Most distant ancestor";
$admtext['mrca'] = "Most recent common ancestor";
$admtext['coding_reg'] = "Coding region differences";
$admtext['xtra_mut'] = "Extra mutations";
$admtext['admin_notes'] = "Administrator notes";
$admtext['ref_seq'] = "Reference sequence";
$admtext['rsrs'] = "RSRS (Reconstructed Sapiens Reference Sequence)";
$admtext['rcrs'] = "rCRS (revised Cambridge Reference Sequence)";
$admtext['show_test_number'] = "Show DNA Test Number Publicly";
$admtext['medialinks'] = "Media links";
$text['test_number'] = "Test nummer/navn";
$text['mode_values'] = "Mode Verdier";
$text['select'] = "Velg";
$text['selectall'] = "Velg alle";
$text['clearall'] = "Velg ingen";
$text['compareselected'] = "Sammenlign valgte";
$text['dnatestscompare'] = "Sammenligne DNA tester";
$text['test_type'] = "Testtype";
$text['taken_by'] = "Tatt av";
$text['keep_name_private'] = "Hold navn Privat";
$text['haplogroup'] = "Haplogruppe";
$text['confirmed'] = "Bekreftet";
$text['predicted'] = "Forutsagt";
$text['test_results'] = "Testresultater";
$text['test_info'] = "Testinformasjon";
$text['test_info_display'] = "Testinformasjon som skal vises";
$text['relevant_links'] = "Relevante linker";
$text['hvr1'] = "HVR1";
$text['hvr2'] = "HVR2";
$text['testgroup'] = "Testgruppe";
$text['dna_test'] = "DNA test";
$text['dna_tests'] = "DNA tester";
$text['all_dna_tests'] = "Alle DNA tester";
$text['fastmutating'] = "Hurtigere&nbsp;mutasjonsrate";
$text['people_have'] = "personer har linket en DNA test til";
$text['person_has'] = "person har linket en DNA test til";
$text['dna_info_head'] = "DNA Test Info";
$text['alltypes'] = "Alle typer";
$text['allgroups'] = "Alle grupper";
$text['Ydna_LITbox_info'] = "Test(er) koblet til denne personen ble ikke nødvendigvis tatt av denne personen.<br />'Haplogruppe' kolonnen viser data i rødt hvis resultatet er 'Forutsagt' eller grønt hvis testen er 'Bekreftet'";

Visualization of this mod

Before V11.0.0.1

Before installing V11.0.0.1 version of this mod, the TNG V11 DNA Tests display does not show any test result information.

Add dna no results displayed.png

It also may not display the person who took the test because the person is not in the TNG database

Add dna no person displayed.png

After V11.0.0.1

After installing V11.0.0.1 version of the mod, Y-DNA and mtDNA test results will be displayed on the Individual getperson.php page. The test results will wrap as necessary based on the screen width.

Your can also select what to display for each test:

  • test results
  • notes
  • relevant links

Add dna results display.png

After V11.0.0.2

After installing V11.0.0.2 version of the mod, you can select Y-DNA tests for comparison

Add dna select tests-to-compare.png

which will return a test comparison screen

Add dna test comparison.png

Admin Fields Added

The Add DNA Test Results changed the add / edit screens to allow you to enter test results for the mtDNA and Y-DNA tests. V11.0.0.1 version further adds a Person not in the database input field, a Keep Name Private checkbox, and a Confirmed Haplogroup checkbox, and options on how you want to display the specific test record. A DNA Test Group and Common Ancestor fields were also added.

Add dna new fields.png

You can use the Person not in the database field for basically the following reasons:

  • you do not want to show any living individuals in your tree
  • You do not want to add 10 generations down from ancestor that is in your database but not a direct line
  • You could also use this field if you wanted to show your name as the test taker but not show any of your details

If the Keep Name Private is checked when adding or editing a test, 'Private' will be displayed overriding TNG privacy settings for 'Name'.

Sites using this mod

Please add your site if you use this modification.

URL User Note Mod-Version TNG-Version User-language
Robison and Blythe Genealogy Jeff Robison Mod developer along with Ken Roy 11.1.1.8 11.1.1 English
Our Roy and Boucher Families Ken Roy Worked with Jeff to develop the v11.0.0.2 version and alpha test new changes. Media Links in v11.0.0.6 is a nice addition. 11.1.1.9 11.1.2 English, French
MOTYER Family Genealogy John Mark Motyer Public site see here see here EN, DE, RU
Brady Family Tree in Western Australia Darryl Brady Public site 11.0.0.6 11.0.1 EN, DE
Gambrill Family Tree Bobby Gambrill Public site 11.1.1.9a 11.1.2 EN
Kemp(e) Family History Andrew Kemp Public site see here see here EN
Houston and McKelvey Family Trees Malcolm Houston Public site 11.0.0.7c 11.0.1 EN
Hatcher Family Genealogy Association William Watson Public site 11.0.0.7f 11.0.2 EN
Zalewski Family Genealogy Brian Zalewski Public site 11.0.0.7f 11.1.0 EN
Descendants of Samuel G Dennis Sr Carl Dennis Public site 11.0.0.7f 11.1.0 EN
DiFava / Brandt Family History Larry DiFava Public site 11.0.0.7 11.1.0 EN
Hooley Family Links Rick Hooley Public/Private See Here See Here EN
OurRoots&Relatives - genealogy pages of Anne Hegland and Kåre Kjøllesdal Kåre Kjøllesda Not a public site 11.1.1.8 11.1.1 Norwegian
Solem Genealogy Jan-Thore Solem Not a public site 11.1.1.8 11.1.1 Norwegian, English
Family History and Ancestry Jay Santos Not a public site 11.1.1.8 11.1.1 English
Joseph Oran Holtz Genealogy Pages Jim Holt Not a public site 11.1.1.8 11.1.1 English
Total Family History Scott Bennett Not a public site 11.1.1.8 11.1.1 English
racine d'Alsace J-Louis Valory Public/Private - Template 1 11.1.1.8 11.1.1 French
Andersson, Hoppe, Sahlin, Thorell Erik Hoppe Public/Closed 11.1.1.8 11.1.2 Swedish, English, German
Nordic Ancestry Mogens C Fenger Closed 11.1.1.8 11.1.2 Danish, English, Icelandic, Norwegian, Swedish

Related Links

DNA Tests article written by Tom Cloud that provides good explanation of DNA testing

Add DNA Test Results mod that allows adding Y-DNA and mtDNA test results to the TNG DNA test table

TNG and DNA Tests