Add DNA Test Results
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 | ||
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 |
The Add DNA Test Results applies to TNG v11 only. This mod is obsolete with TNG v12 which incorporated the code. |
|
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. | ||
Mod Updated | 8 Mar 2018 | ||
Download link |
add_dna_test_results_v11.1.1.9a.zip
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
- Download the zip file. Upload and Extract to the mods folder.
- 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
- Try using the Mod Manager Remove capability
- Contact me through My Mod Support.
Conflicts
- Conflicts with Mobile Site Enhancements
- 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
|
v11.1.1.9 | 8 Mar 2018 | Updated for fix following:
|
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 |
|
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
Clicking the 'Update DNA Tests Table' button in Mod Manager for this mod is required after installation. |
v11.0.0.7 | 29 January 2017 |
Clicking the 'Update DNA Tests Table' button in Mod Manager for this mod is required after installation. |
v11.0.0.6 | 12 December 2016 |
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
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
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
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
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
|
v11.0.0.1 | 21 May 2016 | Following changes made
|
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 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.
It also may not display the person who took the test because the person is not in the TNG database
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
After V11.0.0.2
After installing V11.0.0.2 version of the mod, you can select Y-DNA tests for comparison
which will return a test comparison screen
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.
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