User talk:Mac Fife - Revision history

Mac Fife: /* List in Code (Mac V2) */

2015-10-20T21:41:39Z

List in Code (Mac V2)

Mac Fife at 21:32, 20 October 2015

2015-10-20T21:32:42Z

Christian Walther: more suggestions

2015-10-20T21:22:44Z

more suggestions

Mac Fife: /* List in Code */

2015-10-20T19:49:23Z

List in Code

Mac Fife at 19:47, 20 October 2015

2015-10-20T19:47:51Z

Mac Fife: /* List in Code */

2015-10-19T20:14:44Z

List in Code

Mac Fife at 19:57, 19 October 2015

2015-10-19T19:57:51Z

Mac Fife: Reverted edits by Mac Fife (talk) to last revision by Tai'lahr

2015-09-02T18:05:01Z

Reverted edits by Mac Fife (talk) to last revision by Tai'lahr

Mac Fife at 18:04, 2 September 2015

2015-09-02T18:04:38Z

Tai'lahr at 23:40, 25 August 2015

2015-08-25T23:40:39Z

@@ Line 21: / Line 21: @@
 == List in Code (Mac V2) ==
 For the convenience of shard operators, below is the names list as of 17 Oct 2015
-<syntaxhighlight lang="text" style="overflow: auto;">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>
+<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 = E'string_of_names' WHERE title = 'MemorialImager';</syntaxhighlight>
+<syntaxhighlight lang="postgresql">UPDATE textnote SET value = string_of_names WHERE title = 'MemorialImager';</syntaxhighlight>

@@ Line 9: / Line 9: @@
 '''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 where <code>string_of_names</code> should be replaced by the string given above.  The example is for MOSS and PostgeSQL but the syntax for other servers and databases will be similar.
+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>
@@ Line 18: / Line 18: @@
 <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>

← Older revision		Revision as of 21:22, 20 October 2015
Line 11:		Line 11:
	A sample SQL statement to update the directly in the database is given below where <code>string_of_names</code> should be replaced by the string given above. The example is for MOSS and PostgeSQL but the syntax for other servers and databases will be similar.		A sample SQL statement to update the directly in the database is given below where <code>string_of_names</code> should be replaced by the string given above. The example is for MOSS and PostgeSQL 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>		<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>

@@ Line 6: / Line 6: @@
   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.
 A sample SQL statement to update the directly in the database is given below where <code>string_of_names</code> should be replaced by the string given above.  The example is for MOSS and PostgeSQL but the syntax for other servers and databases will be similar.
-'''SQL code for MOSS servers'''<ref>Coding provided by Christian Walther.</ref><hr><syntaxhighlight lang="sql">UPDATE textnote SET value = E'string_of_names' WHERE title = 'MemorialImager';</syntaxhighlight>
+<syntaxhighlight lang="sql">UPDATE textnote SET value = E'string_of_names' WHERE title = 'MemorialImager';</syntaxhighlight>

@@ Line 1: / Line 1: @@
-Awww, I'm sorry, I guess my methods are pretty messy.  I was thoroughly embarrassed to see the 500 edits when I looked at it.  I don't suppose the slate can be wiped clean, can it?  ; )
+== List in Code ==
-{{Memorial|
+A sample SQL statement to update the directly in the database is given below where <code>string_of_names</code> should be replaced by the string given above.  The example is for MOSS and PostgeSQL but the syntax for other servers and databases will be similar.
-Name=Test|
+'''SQL code for MOSS servers'''<ref>Coding provided by Christian Walther.</ref><hr><syntaxhighlight lang="sql">UPDATE textnote SET value = E'string_of_names' WHERE title = 'MemorialImager';</syntaxhighlight>

@@ Line 11: / Line 11: @@
 For the convenience of shard operators, below is the names list as of 17 Oct
 with coding in place to update it directly in the database.
-<pre>'''SQL code for MOSS servers'''<ref>Coding provided by Christian Walthers.</ref><hr>UPDATE textnote SET value = E'Richard "ShadowCats" Bader\nJeannie "jmb30321" Barcus\nJanet "Pehpsi"
+'''SQL code for MOSS servers'''<ref>Coding provided by Christian Walther.</ref><hr><syntaxhighlight lang="sql">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>

← Older revision		Revision as of 19:57, 19 October 2015
Line 8:		Line 8:
	Memberships=None\|		Memberships=None\|
	Remembrances=Some\|}}		Remembrances=Some\|}}
		+	== List in Code ==
		+	For the convenience of shard operators, below is the names list as of 17 Oct
		+	2015 with coding in place to update it directly in the database.
		+	<pre>'''SQL code for MOSS servers'''<ref>Coding provided by Christian Walthers.</ref><hr>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>

← Older revision		Revision as of 18:05, 2 September 2015
Line 8:		Line 8:
	Memberships=None\|		Memberships=None\|
	Remembrances=Some\|}}		Remembrances=Some\|}}
−
−	~~Testing~~

← Older revision		Revision as of 18:04, 2 September 2015
Line 8:		Line 8:
	Memberships=None\|		Memberships=None\|
	Remembrances=Some\|}}		Remembrances=Some\|}}
		+
		+	Testing

← Older revision		Revision as of 23:40, 25 August 2015
Line 1:		Line 1:
		+	Awww, I'm sorry, I guess my methods are pretty messy. I was thoroughly embarrassed to see the 500 edits when I looked at it. I don't suppose the slate can be wiped clean, can it? ; )
		+
	{{Memorial\|		{{Memorial\|
	Name=Test\|		Name=Test\|