In Memoriam: Tai'lahr
OpenUru.org, along with the rest of the Mystonline community, is mourning the loss of Tai'lahr on October 16th, 2019.
Rest in Peace, friend.
Difference between revisions of "User talk:Mac Fife"
Jump to navigation
Jump to search
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | == List in Code == | |
| + | For the convenience of shard operators, below is the names list as of 17 Oct 2015 | ||
| + | Richard "ShadowCats" Bader\nJeannie "jmb30321" Barcus\nJanet "Pehpsi" Burress\nCAGrayWolf\nJames "Aquila" Carpenter\n | ||
| + | Virginia "Terra" Cinova\nWillow "Wheely" Engberg\nCindy Farrar\nGandhar\nRon Hayter\nJahuti\nMaureen "Mo\'zie" Jannot\n | ||
| + | JDrake\nDeirdre Karris\nKatzi\nWilliam "oldmanjob" Maier\nLen "Flyboy" Mumbower\nMyst\'Aken\nPerlenstern\n | ||
| + | Mark "Zardoz" Plummer\nRamsine\nJim "Dust\'ei" Rhodes\nJosef Riedl\nSil-Oh-Wet\nRosette Taylor\n | ||
| + | Generally, when copying the above, you will need to remove any line breaks to create a string on a single line. | ||
| + | |||
| + | '''SQL code for MOSS servers'''<ref>Coding provided by Christian Walther.</ref> | ||
| + | |||
| + | A sample SQL statement to update the database directly is given below where <code>string_of_names</code> should be replaced by the string given above. The example is for MOSS and PostgreSQL but the syntax for other servers and databases will be similar. | ||
| + | <syntaxhighlight lang="sql">UPDATE textnote SET value = E'string_of_names' WHERE title = 'MemorialImager';</syntaxhighlight> | ||
| + | |||
| + | == List in Code, CW’s version == | ||
| + | '''SQL code for MOSS servers'''<ref>Coding provided by Christian Walther.</ref> | ||
| + | |||
| + | A sample SQL statement to update the directly in the database is given below. The example is for MOSS and PostgreSQL but the syntax for other servers and databases will be similar. | ||
| + | <pre style="white-space: pre-wrap;">UPDATE textnote SET value = E'Richard "ShadowCats" Bader\nJeannie "jmb30321" Barcus\nJanet "Pehpsi" Burress\nCAGrayWolf\nJames "Aquila" Carpenter\nVirginia "Terra" Cinova\nWillow "Wheely" Engberg\nCindy Farrar\nGandhar\nRon Hayter\nJahuti\nMaureen "Mo\'zie" Jannot\nJDrake\nDeirdre Karris\nKatzi\nWilliam "oldmanjob" Maier\nLen "Flyboy" Mumbower\nMyst\'Aken\nPerlenstern\nMark "Zardoz" Plummer\nRamsine\nJim "Dust\'ei" Rhodes\nJosef Riedl\nSil-Oh-Wet\nRosette Taylor\n' WHERE title = 'MemorialImager';</pre> | ||
| + | <syntaxhighlight lang="sql" style="overflow: auto;">UPDATE textnote SET value = E'Richard "ShadowCats" Bader\nJeannie "jmb30321" Barcus\nJanet "Pehpsi" Burress\nCAGrayWolf\nJames "Aquila" Carpenter\nVirginia "Terra" Cinova\nWillow "Wheely" Engberg\nCindy Farrar\nGandhar\nRon Hayter\nJahuti\nMaureen "Mo\'zie" Jannot\nJDrake\nDeirdre Karris\nKatzi\nWilliam "oldmanjob" Maier\nLen "Flyboy" Mumbower\nMyst\'Aken\nPerlenstern\nMark "Zardoz" Plummer\nRamsine\nJim "Dust\'ei" Rhodes\nJosef Riedl\nSil-Oh-Wet\nRosette Taylor\n' WHERE title = 'MemorialImager';</syntaxhighlight> | ||
| + | |||
| + | == List in Code (Mac V2) == | ||
| + | For the convenience of shard operators, below is the names list as of 17 Oct 2015 | ||
| + | <syntaxhighlight lang="postgresql" style="overflow: auto;">E'Richard "ShadowCats" Bader\nJeannie "jmb30321" Barcus\nJanet "Pehpsi" Burress\nCAGrayWolf\nJames "Aquila" Carpenter\nVirginia "Terra" Cinova\nWillow "Wheely" Engberg\nCindy Farrar\nGandhar\nRon Hayter\nJahuti\nMaureen "Mo\'zie" Jannot\nJDrake\nDeirdre Karris\nKatzi\nWilliam "oldmanjob" Maier\nLen "Flyboy" Mumbower\nMyst\'Aken\nPerlenstern\nMark "Zardoz" Plummer\nRamsine\nJim "Dust\'ei" Rhodes\nJosef Riedl\nSil-Oh-Wet\nRosette Taylor\n'</syntaxhighlight> | ||
| + | |||
| + | '''SQL code for MOSS servers'''<ref>Coding provided by Christian Walther.</ref> | ||
| − | + | A sample SQL statement to update database directly is given below where <code>string_of_names</code> should be replaced by the string given above. The example is for MOSS and PostgreSQL but the syntax for other servers and databases will be similar. | |
| − | + | <syntaxhighlight lang="postgresql">UPDATE textnote SET value = string_of_names WHERE title = 'MemorialImager';</syntaxhighlight> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 14:41, 20 October 2015
List in Code
For the convenience of shard operators, below is the names list as of 17 Oct 2015
Richard "ShadowCats" Bader\nJeannie "jmb30321" Barcus\nJanet "Pehpsi" Burress\nCAGrayWolf\nJames "Aquila" Carpenter\n Virginia "Terra" Cinova\nWillow "Wheely" Engberg\nCindy Farrar\nGandhar\nRon Hayter\nJahuti\nMaureen "Mo\'zie" Jannot\n JDrake\nDeirdre Karris\nKatzi\nWilliam "oldmanjob" Maier\nLen "Flyboy" Mumbower\nMyst\'Aken\nPerlenstern\n Mark "Zardoz" Plummer\nRamsine\nJim "Dust\'ei" Rhodes\nJosef Riedl\nSil-Oh-Wet\nRosette Taylor\n
Generally, when copying the above, you will need to remove any line breaks to create a string on a single line.
SQL code for MOSS servers[1]
A sample SQL statement to update the database directly is given below where string_of_names should be replaced by the string given above. The example is for MOSS and PostgreSQL but the syntax for other servers and databases will be similar.
UPDATE textnote SET value = E'string_of_names' WHERE title = 'MemorialImager';List in Code, CW’s version
SQL code for MOSS servers[2]
A sample SQL statement to update the directly in the database is given below. The example is for MOSS and PostgreSQL but the syntax for other servers and databases will be similar.
UPDATE textnote SET value = E'Richard "ShadowCats" Bader\nJeannie "jmb30321" Barcus\nJanet "Pehpsi" Burress\nCAGrayWolf\nJames "Aquila" Carpenter\nVirginia "Terra" Cinova\nWillow "Wheely" Engberg\nCindy Farrar\nGandhar\nRon Hayter\nJahuti\nMaureen "Mo\'zie" Jannot\nJDrake\nDeirdre Karris\nKatzi\nWilliam "oldmanjob" Maier\nLen "Flyboy" Mumbower\nMyst\'Aken\nPerlenstern\nMark "Zardoz" Plummer\nRamsine\nJim "Dust\'ei" Rhodes\nJosef Riedl\nSil-Oh-Wet\nRosette Taylor\n' WHERE title = 'MemorialImager';
UPDATE textnote SET value = E'Richard "ShadowCats" Bader\nJeannie "jmb30321" Barcus\nJanet "Pehpsi" Burress\nCAGrayWolf\nJames "Aquila" Carpenter\nVirginia "Terra" Cinova\nWillow "Wheely" Engberg\nCindy Farrar\nGandhar\nRon Hayter\nJahuti\nMaureen "Mo\'zie" Jannot\nJDrake\nDeirdre Karris\nKatzi\nWilliam "oldmanjob" Maier\nLen "Flyboy" Mumbower\nMyst\'Aken\nPerlenstern\nMark "Zardoz" Plummer\nRamsine\nJim "Dust\'ei" Rhodes\nJosef Riedl\nSil-Oh-Wet\nRosette Taylor\n' WHERE title = 'MemorialImager';List in Code (Mac V2)
For the convenience of shard operators, below is the names list as of 17 Oct 2015
E'Richard "ShadowCats" Bader\nJeannie "jmb30321" Barcus\nJanet "Pehpsi" Burress\nCAGrayWolf\nJames "Aquila" Carpenter\nVirginia "Terra" Cinova\nWillow "Wheely" Engberg\nCindy Farrar\nGandhar\nRon Hayter\nJahuti\nMaureen "Mo\'zie" Jannot\nJDrake\nDeirdre Karris\nKatzi\nWilliam "oldmanjob" Maier\nLen "Flyboy" Mumbower\nMyst\'Aken\nPerlenstern\nMark "Zardoz" Plummer\nRamsine\nJim "Dust\'ei" Rhodes\nJosef Riedl\nSil-Oh-Wet\nRosette Taylor\n'SQL code for MOSS servers[3]
A sample SQL statement to update database directly is given below where string_of_names should be replaced by the string given above. The example is for MOSS and PostgreSQL but the syntax for other servers and databases will be similar.
UPDATE textnote SET value = string_of_names WHERE title = 'MemorialImager';