Difference between revisions of "User talk:Mac Fife"

From OpenUru
Jump to: navigation, search
(List in Code)
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 ==
 +
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.
  
{{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>
Dates=1 to 2|
 
Location=Here|
 
Bio=Some words|
 
Memberships=None|
 
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.
 
'''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>
 

Revision as of 12:47, 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.

A sample SQL statement to update the directly in the database is given below where string_of_names 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[1]
UPDATE textnote SET value = E'string_of_names' WHERE title = 'MemorialImager';
  1. Coding provided by Christian Walther.