• Welcome to SERENDIPITY CLOUD Forums (a subsidiary of FusionWings & GenealogyWings).
 

Recent posts

Pages1 2
#1
Reports / Living Flag: People who died m...
Last post by JMM -
The purpose of these MySQL queries for TNG, is to produce TNG Reports which search for individuals in our TNG databases that cause the following:



Look at the husband where the arrow points to (above); note that he lived in the 1600s-1700s, yet he shows as still living, and therefore for TNG privacy reasons, no name or details are displayed.

In order to know which individuals need to be corrected, the four below TNG reports display all individuals in our TNG database who:
  • have no birth or baptism or death or burial date(s); and
  • have a spouse that was born or baptized or died or buried more than 110 years ago.

Individuals who were born more than 110 years ago, who therefore theoretically should no longer be living, but who are incorrectly set & showing as still living.

Based on: Either the husband or wife having a date showing when they were born & which was more than 110 years ago, but their spouse shows no date for birth.

Code Select
SELECT h.personID AS husband, h.lastname AS hlast, h.firstname AS hfirst, h.birthdatetr AS hus_birth, h.living AS h_living, w.personID AS wife, w.lastname AS wlast, w.firstname AS wfirst, w.birthdatetr AS wif_birth, w.living AS w_living
FROM tng_families f 
LEFT JOIN tng_people h ON f.gedcom = h.gedcom AND f.husband = h.personID
LEFT JOIN tng_people w ON f.gedcom = w.gedcom AND f.wife = w.personID 
WHERE
((h.birthdatetr = '0000-00-00' AND w.birthdatetr <> '0000-00-00' AND YEAR(CURDATE()) - YEAR(w.birthdatetr) > 110 AND h.living = 1)
OR
(w.birthdatetr = '0000-00-00' AND h.birthdatetr <> '0000-00-00' AND YEAR(CURDATE()) - YEAR(h.birthdatetr) > 110 AND w.living = 1))
The query (above) in TNG produces the following TNG report (below):


Individuals who died more than 110 years ago, who therefore theoretically should no longer be living, but who are incorrectly set & showing as still living.

Based on: Either the husband or wife having a date showing when they died & which was more than 110 years ago, but their spouse shows no date for death.

Code Select
SELECT h.personID AS husband, h.lastname AS hlast, h.firstname AS hfirst, h.deathdatetr AS hus_death, h.living AS h_living, w.personID AS wife, w.lastname AS wlast, w.firstname AS wfirst, w.deathdatetr AS wif_death, w.living AS w_living
FROM tng_families f 
LEFT JOIN tng_people h ON f.gedcom = h.gedcom AND f.husband = h.personID
LEFT JOIN tng_people w ON f.gedcom = w.gedcom AND f.wife = w.personID 
WHERE
((h.deathdatetr = '0000-00-00' AND w.deathdatetr <> '0000-00-00' AND YEAR(CURDATE()) - YEAR(w.deathdatetr) > 110 AND h.living = 1)
OR
(w.deathdatetr = '0000-00-00' AND h.deathdatetr <> '0000-00-00' AND YEAR(CURDATE()) - YEAR(h.deathdatetr) > 110 AND w.living = 1))
The query (above) in TNG produces the following TNG report (below):


#2
Settings/Configurations / Cloudflare
Last post by JMM -
How to set & configure things in Cloudflare

Included on the above page:

  • Add website to Cloudflare;
  • Show visitors a JavaScript challenge when they visit your site;
  • Activate 10 core speed and security features included in your Free plan;
  • View the Activity Log, to see what events Cloudflare has blocked;
  • Identify and mitigate automated traffic to protect your domain from bad bots;
  • Set up Cloudflare Turnstile, to embed a smart CAPTCHA alternative into any website, without sending traffic through Cloudflare;
  • Embed a smart CAPTCHA alternative into any website, without sending traffic through Cloudflare;
  • ...more items to come

These instructions pertain to free plan of Cloudflare, as their paid plans might be different

My website(s) protected by Cloudflare:

#3
TNG / TNG mods that I use on my TNG ...
Last post by JMM -
TNG mods that I use on my TNG sites

Included on the above page:
  • Coming soon

These instructions pertain to TNG (v14.0.5), as the code and/or line numbers might be different in previous and/or future versions

My sites running TNG:

#4
TNG / TNG files that I have modified...
Last post by JMM -
Stock TNG files that I have modified myself, to tweak TNG to suit my own needs

My sites running TNG:

#5
Links to various topics in Support Forums for items that I use on my websites / X3 Photo Gallery forums
Last post by JMM -
These are questions that I asked in the X3 Photo Gallery forums, listed here for my own reference so I can easily find the answers:


(links in blue are questions that I myself asked; links in red are questions that others asked, but that I found useful for my own X3 websites)
#6
Tips & Tricks & Hacks / X3 Photo Gallery
Last post by JMM -
My changes (consisting mostly of Custom CSS) to Karl's stock X3, to tweak it to suit my needs

Included on the above page:
  • Coming soon

Unless otherwise noted, these instructions pertain to X3 Photo Gallery (X3.32.0), as the code might be different in previous and/or future versions

Some of my sites running X3 Photo Gallery:

#7
Tips & Tricks & Hacks / TNG (v14.0.5)
Last post by JMM -
My changes to Darrin's stock TNG, to tweak it to suit my needs

Included on the above page:
  • Coming soon

These instructions pertain to TNG (v14.0.5), as the code and/or line numbers might be different in previous and/or future versions

My sites running TNG:

#8
Tips & Tricks & Hacks / phpWebStats (v20.01)
Last post by JMM -
My changes to phpWebStats, to tweak it to suit my needs

Included on the above page:

  • To select the Colour that phpWebStats will be displayed in:
    * Default colour-scheme (for all my websites except TNG)
    * Mousegray colour-scheme (TNG websites, to match my TNG template)
  • To change the delimiters, from a dot to a comma
  • To add the Domain Name on the left, above the section listings
  • To add my own Footer
  • To add padding around the counts at the bottom of each module
  • To track viewing of phpWebStat itself

These instructions pertain to phpWebStats v20.01, as the code and/or line numbers might be different in previous and/or future versions

Some of my sites running phpWebStats:

#9
Tips & Tricks & Hacks / phpDVDProfiler (v20230807)
Last post by JMM -
My changes to Julien Mudry's stock phpDVDProfiler, to tweak it to suit my needs

Included on the above page:
  • Coming soon

These instructions pertain to phpDVDProfiler (v20230807), as the code and/or line numbers might be different in previous and/or future versions

My collections using phpDVDProfiler:

#10
Tips & Tricks & Hacks / PHP-Fusion (v7.02.07 - IUP / D...
Last post by JMM -

My changes to Krelli's stock PHP-Fusion v7, to tweak it to suit my needs

Included on the above page:
  • Coming soon

These instructions pertain to PHP-Fusion v7.02.07 (IUP - DE update v1.7), as the code and/or line numbers might be different in previous and/or future versions

My site(s) running PHP-Fusion v7:


Pages1 2
🡱 🡳
Serendipity.cloud © Copyright 2019-2025 by John Mark Motyer, CD [8.4.8]