You are here: Cops>Main Web>SitePreferences (31 Jan 2023, RaymondLutz)Edit Attach

Site Preferences

Foswiki's default preferences are located in System.Default Preferences, however settings defined here have override priority and should be used for local customisations.

Default Overrides

Up to 1GB attachments. This preference setting is in KB.

Set ATTACHFILESIZELIMIT = 1000000

Customize logo and tooltip texts:

#Set WIKILOGOIMG =
Set WIKILOGOIMG =

#Set WIKILOGOALT = Powered by Foswiki, The Free and Open Source Wiki
#Set WIKILOGOURL = https://copswiki.org/Main/WebHome
Set WIKILOGOURL = /Common/WebHome
Set WIKILOGOALT = COPs
Set SKIN = sidetoggle,natedit,pattern
Set WIKITOOLNAME = Cops
Set FAVICON = https://copswiki.org/img/favicon.ico

Customize your top bar background image and color

Set WEBHEADERART = /w/pub/System/PatternSkin/header5.gif
Set WEBHEADERBGCOLOR = #ffffff

#Set BROADCASTMESSAGE = Site Undergoing Maintenance. No Edits are allowed until further notice.
Set AMP = &

Output a warning if an included file is missing.

Set INCLUDEWARNING = on

Finalisation

FINALPREFERENCES locks site-level preferences that are not allowed to be overridden by Web Preferences or user preferences:

Set FINALPREFERENCES = ATTACHFILESIZELIMIT, PREVIEWBGIMAGE, WIKITOOLNAME, WIKIHOMEURL, ALLOWROOTCHANGE, DENYROOTCHANGE, DOCWEB, WIKIWEBMASTER, WIKIWEBMASTERNAME, WIKIAGENTEMAIL, WIKIAGENTNAME

General Macros

Set SERVERTIME = %DATETIME{"$year-$mo-$day $hours:$minutes:$seconds"}%
Set LOCALTIME = %DATETIME{format="$year-$mo-$day $hours:$minutes:$seconds" inchours="-7"}%
Set GMTIMEVAR = 04 Jun 2023 - 10:03

Set HILITE =
Set ENDHILITE =

Set BG_GREEN =
Set BG_YELLOW =
Set BG_RED =
Set BG_ORANGE =
Set BG_TAN =
Set BG_WHITE =
Set BG_BLACK =

Set ENDBG =

Plugin Settings

Do not make settings in plugins because they are overwritten whenever the foswiki system is updated. Instead, add your entries here.

Set INTERWIKIPLUGIN_RULESTOPIC = Inter Wikis, Inter Wikis
- Note: Future upgrades will need to propagate topic Main.InterWikis

Set TABLEPLUGIN_TABLEATTRIBUTES = tableborder="1" headerrows="1" footerrows="0" initdirection="down" databg="#FFFFFF,#99FFFF" headerbg="#003366" headercolor="#FFFFFF"

Set SPACEDWIKIWORDPLUGIN_DONTSPACE = My Space, Face Book, Mc Clellan, Dyn Corp, Cops Wiki, Ro V, Ca Dem, Mc Intyre, Mc Kitrick, So S, Mc Govern, Mc Cain, Mc Cann, Do D, Ph D, Ha Levy, Mc Donald, Mc Swain, Audit Engine
Set CALENDARPLUGIN_VCELLALIGNMENT = top
Set CALENDARPLUGIN_WIDTH = 100%
Set CALENDARPLUGIN_GMTOFFSET = "-07"
Set CALENDARPLUGIN_FORMAT = $old
$description
Set CALENDARPLUGIN_TODAYCOLOR = #CCFF00

Set SLIDESHOWPLUGIN_TEMPLATE = Slide Show Template
Set JSCALENDARCONTRIB_FORMAT = %Y-%m-%d

The setting below does not work.

Set DATETIMEPLUGIN_TIMEZONEOFFSET = "-7"

Set UPDATEINFOPLUGIN_UPDATEINFODAYS = 30

SKIN

Set PATTERNSKIN_JQUERY_THEME = Pattern Skin Theme
Enable sidebar toggle
- Set USERSTYLEURL = /w/pub/System/PatternSkinCssCookbookSidebarToggle/SidebarToggle.css

Caching

The following setting is if caching as supplied by foswiki is enabled. I have had trouble with this. # Set CACHELINK =

Cached at %DATETIME{format="$year-$mo-$day $hours:$minutes:$seconds" inchours="-7"}%. Rebuild this page.

The following setting is for the VARCACHE plugin. For this to work, an invocation like this %VARCACHE{refresh="n"}% must exist EXPLICITLY on the page, probably in comment braces. w/o nop!

This is no longer being used because it is not compatible with: Image Gallery Plugin nor multiple paged search outputs.
CACHELINK is set to nothing.
Set CACHELINK =
Set OLDCACHELINK =
Cached at %DATETIME{format="$year-$mo-$day $hours:$minutes:$seconds" inchours="-7"}%. Rebuild the page.

Site-specific Macros

Set PHYSICALADDRESS = Citizens Oversight
771 Jamacha Rd. #148
El Cajon, CA 92019

   * Set NONOISEWHDR = nosummary="on" nosearch="on" nototal="on" zeroresults="off" noempty="on"
   * Set PAGEBREAK = <sticky><div style="page-break-before: always">&nbsp;</div></sticky>

Note, have had trouble with edit mode in this tblediticon definition because it does not pick up recent edits.
   * Set TBLEDITICON = [[$web.$topic][<img src=\"%ICONURL{viewtopic}%\" width=13 height=13 alt=\"View\" border=0 />]]

This is the part that does not work:<br>
[[%SCRIPTURL{edit}%/$web/$topic?nowysiwyg=1][<img src=\"%ICONURL{edittopic}%\" width=13 height=13 alt=\"Edit\" border=0 />]]

   * Set TBLEDITHDR = %ICON{note}%
   * Set VIEWURL = https://%HTTP_HOST%
   * Set STDTOC = %TWISTY{mode="div" showlink="Show Table of Contents&nbsp;" hidelink="Hide Table of Contents&nbsp;" 
     remember="on"  firststart="show" showimgright="%ICONURLPATH{toggleopen-small}%" 
     hideimgright="%ICONURLPATH{toggleclose-small}%"}%%TOC{depth="3" title="Table of Contents"}%%ENDTWISTY%

   * Set STDTOC2 = %TWISTY{mode="div" showlink="Show Table of Contents&nbsp;" hidelink="Hide Table of Contents&nbsp;" 
     remember="on"  firststart="show" showimgright="%ICONURLPATH{toggleopen-small}%" 
     hideimgright="%ICONURLPATH{toggleclose-small}%"}%%TOC{depth="2" title="Table of Contents"}%%ENDTWISTY%

   * Set VENUEOPTIONLIST = <OPTION selected="selected" name="OtherVenue">Other Venue</OPTION> 
      %SEARCH{search="form.name~'*VenueForm' AND PublishStatus != 'Hidden' " web="Common" nonoise="on" type="query" nosearch="on"  
      format="<OPTION value=\"$topic\">$formfield(Name)</OPTION> " nofinalnewline="on" separator=" "}%

   * Set USSTATESOPTIONLIST = <OPTION>AL</OPTION> <OPTION>AK</OPTION> <OPTION>AZ</OPTION> <OPTION>AR</OPTION> <OPTION SELECTED>CA</OPTION> <OPTION>CO</OPTION> <OPTION>CT</OPTION> <OPTION>DE</OPTION> <OPTION>FL</OPTION> <OPTION>GA</OPTION> <OPTION>HI</OPTION> <OPTION>ID</OPTION> <OPTION>IL</OPTION> <OPTION>IN</OPTION> <OPTION>IA</OPTION> <OPTION>KS</OPTION> <OPTION>KY</OPTION> <OPTION>LA</OPTION> <OPTION>ME</OPTION> <OPTION>MD</OPTION> <OPTION>MA</OPTION> <OPTION>MI</OPTION> <OPTION>MN</OPTION> <OPTION>MS</OPTION> <OPTION>MO</OPTION> <OPTION>MT</OPTION> <OPTION>NE</OPTION> <OPTION>NV</OPTION> <OPTION>NH</OPTION> <OPTION>NJ</OPTION> <OPTION>NM</OPTION> <OPTION>NY</OPTION> <OPTION>NC</OPTION> <OPTION>ND</OPTION> <OPTION>OH</OPTION> <OPTION>OK</OPTION> <OPTION>OR</OPTION> <OPTION>PA</OPTION> <OPTION>RI</OPTION> <OPTION>SC</OPTION> <OPTION>SD</OPTION> <OPTION>TN</OPTION> <OPTION>TX</OPTION> <OPTION>UT</OPTION> <OPTION>VT</OPTION> <OPTION>VA</OPTION> <OPTION>WA</OPTION> <OPTION>WV</OPTION> <OPTION>WI</OPTION> <OPTION>WY</OPTION> <OPTION>Other</OPTION>

   * Set CAELECTIONDISTRICTLIST = <OPTION>CA_Alameda</OPTION> <OPTION>CA_Alpine</OPTION> <OPTION>CA_Amador</OPTION> <OPTION>CA_Butte</OPTION> <OPTION>CA_Calaveras</OPTION> <OPTION>CA_Colusa</OPTION> <OPTION>CA_ContraCosta</OPTION> <OPTION>CA_DelNorte</OPTION> <OPTION>CA_ElDorado</OPTION> <OPTION>CA_Fresno</OPTION> <OPTION>CA_Glenn</OPTION> <OPTION>CA_Humboldt</OPTION> <OPTION>CA_Imperial</OPTION> <OPTION>CA_Inyo</OPTION> <OPTION>CA_Kern</OPTION> <OPTION>CA_Kings</OPTION> <OPTION>CA_Lake</OPTION> <OPTION>CA_Lassen</OPTION> <OPTION>CA_LosAngeles</OPTION> <OPTION>CA_Madera</OPTION> <OPTION>CA_Marin</OPTION> <OPTION>CA_Mariposa</OPTION> <OPTION>CA_Mendocino</OPTION> <OPTION>CA_Merced</OPTION> <OPTION>CA_Modoc</OPTION> <OPTION>CA_Mono</OPTION> <OPTION>CA_Monterey</OPTION> <OPTION>CA_Napa</OPTION> <OPTION>CA_Nevada</OPTION> <OPTION>CA_Orange</OPTION> <OPTION>CA_Placer</OPTION> <OPTION>CA_Plumas</OPTION> <OPTION>CA_Riverside</OPTION> <OPTION>CA_Sacramento</OPTION> <OPTION>CA_SanBenito</OPTION> <OPTION>CA_SanBernardino</OPTION> <OPTION>CA_SanDiego</OPTION> <OPTION>CA_SanFrancisco</OPTION> <OPTION>CA_SanJoaquin</OPTION> <OPTION>CA_SanLuisObispo</OPTION> <OPTION>CA_SanMateo</OPTION> <OPTION>CA_SantaBarbara</OPTION> <OPTION>CA_SantaClara</OPTION> <OPTION>CA_SantaCruz</OPTION> <OPTION>CA_Shasta</OPTION> <OPTION>CA_Sierra</OPTION> <OPTION>CA_Siskiyou</OPTION> <OPTION>CA_Solano</OPTION> <OPTION>CA_Sonoma</OPTION> <OPTION>CA_Stanislaus</OPTION> <OPTION>CA_Sutter</OPTION> <OPTION>CA_Tehama</OPTION> <OPTION>CA_Trinity</OPTION> <OPTION>CA_Tulare</OPTION> <OPTION>CA_Tuolumne</OPTION> <OPTION>CA_Ventura</OPTION> <OPTION>CA_Yolo</OPTION> <OPTION>CA_Yuba</OPTION>

   * Set COUNTRYOPTIONLIST = <OPTION>Afghanistan</OPTION> <OPTION>Albania</OPTION> <OPTION>Algeria</OPTION> <OPTION>Andorra</OPTION> <OPTION>Angola</OPTION> <OPTION>Anguilla</OPTION> <OPTION>Antigua & Barbuda</OPTION> <OPTION>Argentina</OPTION> <OPTION>Armenia</OPTION> <OPTION>Aruba</OPTION> <OPTION>Australia</OPTION> <OPTION>Austria</OPTION> <OPTION>Azerbaijan</OPTION> <OPTION>Bahamas</OPTION> <OPTION>Bahrain</OPTION> <OPTION>Bangladesh</OPTION> <OPTION>Barbados</OPTION> <OPTION>Belarus</OPTION> <OPTION>Belgium</OPTION> <OPTION>Belize</OPTION> <OPTION>Benin</OPTION> <OPTION>Bermuda</OPTION> <OPTION>Bhutan</OPTION> <OPTION>Bolivia</OPTION> <OPTION>Bosnia & Herzegovina</OPTION> <OPTION>Botswana</OPTION> <OPTION>Brazil</OPTION> <OPTION>Brunei</OPTION> <OPTION>Bulgaria</OPTION> <OPTION>Burkina Faso</OPTION> <OPTION>Burundi</OPTION> <OPTION>Cambodia</OPTION> <OPTION>Cameroon</OPTION> <OPTION>Canada</OPTION> <OPTION>Cape Verde</OPTION> <OPTION>Cayman Islands</OPTION> <OPTION>Central African Rep.</OPTION> <OPTION>Chad</OPTION> <OPTION>Chile</OPTION> <OPTION>China</OPTION> <OPTION>Colombia</OPTION> <OPTION>Comoros</OPTION> <OPTION>Congo</OPTION> <OPTION>Cook Islands</OPTION> <OPTION>Costa Rica</OPTION> <OPTION>Cote d'Ivoire</OPTION> <OPTION>Croatia</OPTION> <OPTION>Cuba</OPTION> <OPTION>Cyprus</OPTION> <OPTION>Czech Republic</OPTION> <OPTION>Denmark</OPTION> <OPTION>Djibouti</OPTION> <OPTION>Dominica</OPTION> <OPTION>Dominican Republic</OPTION> <OPTION>East Timor</OPTION> <OPTION>Ecuador</OPTION> <OPTION>Egypt</OPTION> <OPTION>El Salvador</OPTION> <OPTION>England</OPTION> <OPTION>Equatorial Guinea</OPTION> <OPTION>Eritrea</OPTION> <OPTION>Estonia</OPTION> <OPTION>Ethiopia</OPTION> <OPTION>Fareoe Islands</OPTION> <OPTION>Falkland Islands</OPTION> <OPTION>Fiji</OPTION> <OPTION>Finland</OPTION> <OPTION>France</OPTION> <OPTION>French Guiana</OPTION> <OPTION>French Polynesia</OPTION> <OPTION>Gabon</OPTION> <OPTION>Gambia</OPTION> <OPTION>Georgia</OPTION> <OPTION>Germany</OPTION> <OPTION>Ghana</OPTION> <OPTION>Gibraltar</OPTION> <OPTION>Great Britain</OPTION> <OPTION>Greece</OPTION> <OPTION>Greenland</OPTION> <OPTION>Grenada</OPTION> <OPTION>Guadeloupe</OPTION> <OPTION>Guam</OPTION> <OPTION>Guatemala</OPTION> <OPTION>Guinea</OPTION> <OPTION>Guinea-Bissau</OPTION> <OPTION>Guyana</OPTION> <OPTION>Haiti</OPTION> <OPTION>Honduras</OPTION> <OPTION>Hong Kong</OPTION> <OPTION>Hungary</OPTION> <OPTION>Iceland</OPTION> <OPTION>India</OPTION> <OPTION>Indonesia</OPTION> <OPTION>Iran</OPTION> <OPTION>Iraq</OPTION> <OPTION>Ireland</OPTION> <OPTION>Israel</OPTION> <OPTION>Italy</OPTION> <OPTION>Jamaica</OPTION> <OPTION>Japan</OPTION> <OPTION>Jordan</OPTION> <OPTION>Kazakhstan</OPTION> <OPTION>Kenya</OPTION> <OPTION>Kiribati</OPTION> <OPTION>Korea</OPTION> <OPTION>Kuwait</OPTION> <OPTION>Kyrgyzstan</OPTION> <OPTION>Laos</OPTION> <OPTION>Latvia</OPTION> <OPTION>Lebanon</OPTION> <OPTION>Lesotho</OPTION> <OPTION>Liberia</OPTION> <OPTION>Libya</OPTION> <OPTION>Liechtenstein</OPTION> <OPTION>Lithuania</OPTION> <OPTION>Luxembourg</OPTION> <OPTION>Macao</OPTION> <OPTION>Macedonia</OPTION> <OPTION>Madagascar</OPTION> <OPTION>Malawi</OPTION> <OPTION>Malaysia</OPTION> <OPTION>Maldives</OPTION> <OPTION>Mali</OPTION> <OPTION>Malta</OPTION> <OPTION>Marshall Islands</OPTION> <OPTION>Martinique</OPTION> <OPTION>Mauritania</OPTION> <OPTION>Mauritius</OPTION> <OPTION>Mexico</OPTION> <OPTION>Micronesia</OPTION> <OPTION>Moldova</OPTION> <OPTION>Monaco</OPTION> <OPTION>Mongolia</OPTION> <OPTION>Montserrat</OPTION> <OPTION>Morocco</OPTION> <OPTION>Mozambique</OPTION> <OPTION>Myanmar</OPTION> <OPTION>Namibia</OPTION> <OPTION>Nauru</OPTION> <OPTION>Nepal</OPTION> <OPTION>Netherlands</OPTION> <OPTION>Netherlands Antilles</OPTION> <OPTION>New Caledonia</OPTION> <OPTION>New Zealand</OPTION> <OPTION>Nicaragua</OPTION> <OPTION>Niger</OPTION> <OPTION>Nigeria</OPTION> <OPTION>Niue</OPTION> <OPTION>Norway</OPTION> <OPTION>Oman</OPTION> <OPTION>Pakistan</OPTION> <OPTION>Palau</OPTION> <OPTION>Panama</OPTION> <OPTION>Papua New Guinea</OPTION> <OPTION>Paraguay</OPTION> <OPTION>Peru</OPTION> <OPTION>Philippines</OPTION> <OPTION>Pitcairn</OPTION> <OPTION>Poland</OPTION> <OPTION>Portugal</OPTION> <OPTION>Puerto Rico</OPTION> <OPTION>Qatar</OPTION> <OPTION>Reunion</OPTION> <OPTION>Romania</OPTION> <OPTION>Russia</OPTION> <OPTION>Rwanda</OPTION> <OPTION>Samoa</OPTION> <OPTION>San Marino</OPTION> <OPTION>Sao Tome & Principe</OPTION> <OPTION>Saudi Arabia</OPTION> <OPTION>Senegal</OPTION> <OPTION>Seychelles</OPTION> <OPTION>Sierra Leone</OPTION> <OPTION>Singapore</OPTION> <OPTION>Slovakia</OPTION> <OPTION>Slovenia</OPTION> <OPTION>Solomon Islands</OPTION> <OPTION>Somalia</OPTION> <OPTION>South Africa</OPTION> <OPTION>Spain</OPTION> <OPTION>Sri Lanka</OPTION> <OPTION>St Helena</OPTION> <OPTION>St Kitts & Nevis</OPTION> <OPTION>St Lucia</OPTION> <OPTION>St Pierre & Miquelon</OPTION> <OPTION>St Vincent</OPTION> <OPTION>Sudan</OPTION> <OPTION>Suriname</OPTION> <OPTION>Swaziland</OPTION> <OPTION>Sweden</OPTION> <OPTION>Switzerland</OPTION> <OPTION>Syria</OPTION> <OPTION>Taiwan</OPTION> <OPTION>Tajikistan</OPTION> <OPTION>Tanzania</OPTION> <OPTION>Thailand</OPTION> <OPTION>Togo</OPTION> <OPTION>Tonga</OPTION> <OPTION>Trinidad & Tobago</OPTION> <OPTION>Tunisia</OPTION> <OPTION>Turkey</OPTION> <OPTION>Turkmenistan</OPTION> <OPTION>Turks & Caicos Is</OPTION> <OPTION>Tuvalu</OPTION> <OPTION>Uganda</OPTION> <OPTION>Ukraine</OPTION> <OPTION>United Arab Emirates</OPTION> <OPTION>United Kingdom</OPTION> <OPTION SELECTED>United States</OPTION> <OPTION>Uruguay</OPTION> <OPTION>Uzbekistan</OPTION> <OPTION>Vanuatu</OPTION> <OPTION>Vatican City</OPTION> <OPTION>Venezuela</OPTION> <OPTION>Vietnam</OPTION> <OPTION>Virgin Islands (US)</OPTION> <OPTION>Wallis & Futuna</OPTION> <OPTION>Yemen</OPTION> <OPTION>Zambia</OPTION> <OPTION>Zimbabwe</OPTION>

   * Set USSTATELIST = AL, AK, AZ, AR, CA, CO, CT, DE, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY, Other

   * Set COUNTRYLIST = Afghanistan, Albania, Algeria, Andorra, Angola, Anguilla, Antigua & Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Barbados, Belarus, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia & Herzegovina, Botswana, Brazil, Brunei, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde, Cayman Islands, Central African Rep., Chad, Chile, China, Colombia, Comoros, Congo, Cook Islands, Costa Rica, Cote d'Ivoire, Croatia, Cuba, Cyprus, Czech Republic, Denmark, Djibouti, Dominica, Dominican Republic, East Timor, Ecuador, Egypt, El Salvador, England, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Fareoe Islands, Falkland Islands, Fiji, Finland, France, French Guiana, French Polynesia, Gabon, Gambia, Georgia, Germany, Ghana, Gibraltar, Great Britain, Greece, Greenland, Grenada, Guadeloupe, Guam, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Iran, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jordan, Kazakhstan, Kenya, Kiribati, Korea, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Libya, Liechtenstein, Lithuania, Luxembourg, Macao, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Martinique, Mauritania, Mauritius, Mexico, Micronesia, Moldova, Monaco, Mongolia, Montserrat, Morocco, Mozambique, Myanmar, Namibia, Nauru, Nepal, Netherlands, Netherlands Antilles, New Caledonia, New Zealand, Nicaragua, Niger, Nigeria, Niue, Norway, Oman, Pakistan, Palau, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Pitcairn, Poland, Portugal, Puerto Rico, Qatar, Reunion, Romania, Russia, Rwanda, Samoa, San Marino, Sao Tome & Principe, Saudi Arabia, Senegal, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, Spain, Sri Lanka, St Helena, St Kitts & Nevis, St Lucia, St Pierre & Miquelon, St Vincent, Sudan, Suriname, Swaziland, Sweden, Switzerland, Syria, Taiwan, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad & Tobago, Tunisia, Turkey, Turkmenistan, Turks & Caicos Is, Tuvalu, Uganda, Ukraine, United Arab Emirates, United Kingdom, United States, Uruguay, Uzbekistan, Vanuatu, Vatican City, Venezuela, Vietnam, Virgin Islands (US), Wallis & Futuna, Yemen, Zambia, Zimbabwe

General

Set PROGRESSBAR =
%TITLE% (Currently $%CURRENT%)

$0$%GOAL%
- Usage: PROGRESSBAR{TITLE="title" GOAL="number" CURRENT="number" WIDTH="pixels"}%

Set LINK = %TEXT%

Elections Web related

   * Set ALLAUDITS = %SEARCH{web="Elections" search="form.name~'*AuditForm' " noheader="on"  nototal="on" type="query" nosearch="on" format="   * [[$topic]]" order="$topic" excludetopic="AuditTopicTemplate"}%
   * Set DISTRICTAUDITS = %SEARCH{web="Elections" search="form.name~'*AuditForm' AND ElectionDistrict~'*%TOPIC%*' " noheader="on"  nototal="on" type="query" nosearch="on" format="   * [[$topic]]" order="$topic" excludetopic="AuditTopicTemplate"}%
   * Set DISTRICTAUDITHEADER = ---++ Audits of this District ([[Elections.NewAuditTopic][Add]])
   * Set ATTACHEDAUDITFILES = %ATTACHMENTLIST{sort="$fileName" sortorder="ascending" header="All files:" footer="Number of files: $fileCount" format="   * $fileIcon [[$fileUrl][$fileName]] ($fileSize) -- $fileComment" }%

Legal Web related

   * Set SUBMITINCIDENTLINK = %SCRIPTURL{edit}%/Legal/LAUTOINC00000?templatetopic=Legal.LegalIncidentTopicTemplate&topicparent=Legal.LegalIncidents
   * Set INCIDENTLISTHDR = |  *Name (Last,First M)*  |  *Law Enforcement Dept*  |  *Book Num<br>Case Num*  |  *Date<br>Time*  |  *Violation Desc*  |  *Violation Location*  |  *Officer Name (Last, First)<br>Badge Num*  |  *Court Date*  |  *Bail /<br>Bond*  |  *Note*  |  *Tags*  |  *Event Topic*  |  *%TBLEDITHDR%*  |
   * Set INCIDENTLISTFORMAT = |$formfield(NameLast), $formfield(NameFirst) $formfield(NameMiddle)  |$web.$formfield(LawEnforcementDept)  |$formfield(BookNumber)<br>$formfield(CaseNum)  |$formfield(Date)<br>$formfield(Time)  |$formfield(ViolationDescription)  |$formfield(ViolationLocation)  |$formfield(OfficerLastName),&nbsp;$formfield(OfficerFirstName)<br>[[$web.$formfield(LawEnforcementDept)$formfield(BadgeNumber)][$formfield(BadgeNumber)]]  |$formfield(CourtDate)  |$formfield(BailAmount)<br>$formfield(BondAmount) |$formfield(Note)  |$formfield(Tags)  |$formfield(EventTopic)  |  %TBLEDITICON%  |
   * Set INCIDENTSBYDEPT = %SEARCH{search="form.name~'*LegalIncidentForm' AND LawEnforcementDept~'*%TOPIC%*' " web="Legal" type="query" nonoise="on" nosearch="on" format="%INCIDENTLISTFORMAT%" order="$formfield(Name)" excludetopic="LegalIncidentTopicTemplate"}%
   * Set INCIDENTSBYEVENT = %SEARCH{search="form.name~'*LegalIncidentForm' AND EventTopic~'*%TOPIC%*' " web="Legal" type="query" nonoise="on" nosearch="on" format="%INCIDENTLISTFORMAT%" order="$formfield(Name)" excludetopic="LegalIncidentTopicTemplate"}%

   * Set BADGELISTHDR = |  *Name (Last, First)*  |  *Law Enforcement Dept*  |  *Badge Num*  |  *Rank*  |
   * Set BADGELISTFORMAT = |$formfield(OfficerLastName),&nbsp;$formfield(OfficerFirstName)  | $formfield(LawEnforcementDept)  |   [[$web.$topic][$formfield(BadgeNumber)]]  |$formfield(OfficerRank)  |
   * Set BADGESBYDEPT = %SEARCH{search="form.name~'*BadgeForm' AND LawEnforcementDept~'*%TOPIC%*' " web="Legal" type="query" nonoise="on" nosearch="on" format="%BADGELISTFORMAT%" order="$formfield(OfficerLastName)" excludetopic="LegalIncidentTopicTemplate"}%
   * Set ALLBADGES = %SEARCH{search="form.name~'*BadgeForm' " web="Legal" type="query" nonoise="on" nosearch="on" format="%BADGELISTFORMAT%" order="$formfield(OfficerLastName)" excludetopic="BadgeTopicTemplate"}%

Affiliate Programs

Set AMAZONAFFILIATELINK =

Social Bookmarks

DEPRECATED


   * Set SOCIALBOOKMARKS = <!-- Hupso Share Buttons - https://www.hupso.com/share/ --><div class="hupso-share-buttons"> [[https://www.hupso.com/share/][<img alt="Share Button" src="https://static.hupso.com/share/buttons/share-medium.png" style="border: 0px; padding-top: 5px; float: left;" />]]<script type="text/javascript">var hupso_services_t=new Array("Twitter","Facebook","Google Plus","Pinterest","Linkedin","Tumblr","StumbleUpon","Digg","Reddit","Bebo","Delicious");var hupso_url_t="https://www.CitizensOversight.org";var hupso_title_t="Citizens Oversight Projects (COPs)";var hupso_toolbar_size_t="medium";</script><script type="text/javascript" src="https://static.hupso.com/share/js/share_toolbar.js"></script></div>

   * Set MEDIASOCIALBOOKMARKS = <!-- Hupso Share Buttons - http://www.hupso.com/share/ --><div class="hupso-share-buttons"> [[http://www.hupso.com/share/][<img alt="Share Button" src="http://static.hupso.com/share/buttons/share-medium.png" style="border: 0px; padding-top: 5px; float: left;" />]]<script type="text/javascript">var hupso_services_t=new Array("Twitter","Facebook","Google Plus","Pinterest","Linkedin","Tumblr","StumbleUpon","Digg","Reddit","Bebo","Delicious");var hupso_url_t="http://www.CitizensOversight.org";var hupso_title_t="Citizens Oversight Projects (COPs)";var hupso_toolbar_size_t="medium";</script><script type="text/javascript" src="http://static.hupso.com/share/js/share_toolbar.js"></script></div>

   * Set FBCOMMENTS = %IF{" '%QUERY{"'%BASETOPIC%'/fields.ForumLink"}%' " then="<a href='%QUERY{"'%BASETOPIC%'/fields.ForumLink"}%' target='_blank'>Goto Discussion</a>" else="<div id=\"fb-root\"></div><script src=\"http://connect.facebook.net/en_US/all.js#appId=113186098729812&amp;xfbml=1\"></script><fb:comments href=\"http://%HTTP_HOST%/%BASEWEB%/%BASETOPIC%\" num_posts=\"50\" width=\"500\" reverse=\"0\"></fb:comments>"}%

Cops Canvass Report Related

Set REFSPEC = type="regex" format=" * $topic" nonoise="on" excludetopic="CopsCanvassReportIssuesBriefSummary" topic="CopsCanvassReport*"

Event Related

   * Set VENUENAMEADDR_LINKED_INCLUDE = [[ Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}% ][ %FORMFIELD{"Name" topic="Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}%"}% ]] at %FORMFIELD{"Address" topic="Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}%"}%  %FORMFIELD{"CityStateZip" topic="Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}%"}%

   * Set VENUENAMEADDR_SEARCHFORMAT = [[ Common.$formfield(Venue) ][ $percntFORMFIELD{\"Name\" topic=\"Common.$formfield(Venue)\"}$percnt ]] at 
      $percntFORMFIELD{\"Address\" topic=\"Common.$formfield(Venue)\"}$percnt  $percntFORMFIELD{\"CityStateZip\" topic=\"Common.$formfield(Venue)\"}$percnt

   * Set VENUENAMEADDR_FORHEAD =%FORMFIELD{"Name" topic="Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}%"}% at 
      %FORMFIELD{"Address" topic="Common.%FORMFIELD{"Venue" topic="%BASETOPIC%"}%"}%  %FORMFIELD{"CityStateZip" topic="Common.%FORMFIELD{Venue}%"}%

   * Set SPONSORINFO_LINKED_INCLUDE = %FORMFIELD{"Phone1" topic="Common.%FORMFIELD{"Sponsor" topic="%BASETOPIC%"}%"}% or visit
      %FORMFIELD{"Website" topic="Common.%FORMFIELD{"Sponsor" topic="%BASETOPIC%"}%"}%

   * Set SPONSORINFO_FOR_HEAD = %FORMFIELD{"Phone1" topic="Common.%FORMFIELD{"Sponsor" topic="%BASETOPIC%"}%"}% or visit 
      %FORMFIELD{"Website" topic="Common.%FORMFIELD{"Sponsor" topic="%BASETOPIC%"}%"}%

   * Set SPONSORINFO_SEARCHFORMAT = $percntFORMFIELD{\"Phone1\" topic=\"Common.$formfield(Sponsor)\"}$percnt or visit 
      $percntFORMFIELD{\"Website\" topic=\"Common.$formfield(Sponsor)\"}$percnt

   * Set PROGRAMINFO_LINKED_INCLUDE = [[%FORMFIELD{"Program" topic="%BASETOPIC%"}%][%FORMFIELD{"Title" topic="%FORMFIELD{"Program" topic="%BASETOPIC%"}%"}%]] -- %FORMFIELD{"Note" topic="%FORMFIELD{"Program" topic="%BASETOPIC%"}%"}%

   * Set PROGRAMINFO_FOR_HEAD = %FORMFIELD{"Title" topic="%FORMFIELD{"Program" topic="%BASETOPIC%"}%"}% -- %FORMFIELD{"Note" topic="%FORMFIELD{"Program" topic="%BASETOPIC%"}%"}%

   * Set PROGRAMINFO_SEARCHFORMAT = [[$topic][$percntFORMFIELD{\"Title\" topic=\"$formfield(Program)\"}$percnt]] -- $percntFORMFIELD{\"Note\" topic=\"$formfield(Program)\"}$percnt

   * Set THUMBNAILURL_LINKED_INCLUDE = %FORMFIELD{"ThumbnailLink" topic="%FORMFIELD{"Program" topic="%BASETOPIC%"}%"}%

   * Set OURCALENDARENTRY_LINKED_INCLUDE =  %DATETIME{"$day $month $year" date="%FORMFIELD{"Date" topic="%INCLUDINGTOPIC%"}%"}% - %FORMFIELD{"Title" topic="%INCLUDINGTOPIC%"}% presents %PROGRAMINFO_LINKED_INCLUDE%  %VENUENAMEADDR_LINKED_INCLUDE% (%FORMFIELD{"EventTime" topic="%INCLUDINGTOPIC%"}%) sponsored by %FORMFIELD{"Sponsor" topic="%INCLUDINGTOPIC%"}%  Info: %SPONSORINFO_LINKED_INCLUDE% [[%WEB%.%TOPIC%][Details]]

   * Set GENCALENDARENTRY_INCLUDE = %DATETIME{"$lwday, $month $day" date="%FORMFIELD{"Date" topic="%BASETOPIC%"}%"}%, %FORMFIELD{"EventTime" topic="%BASETOPIC%"}%: - %FORMFIELD{"Title" topic="%BASETOPIC%"}% presents %PROGRAMINFO_LINKED_INCLUDE%, %VENUENAMEADDR_LINKED_INCLUDE% (%FORMFIELD{"Policy" topic="%BASETOPIC%"}%) Info: %SPONSORINFO_LINKED_INCLUDE%

   * Set GENNEWSENTRY_INCLUDE = %FORMFIELD{"Sponsor" topic="%BASETOPIC%"}% will sponsor %FORMFIELD{"Title" topic="%BASETOPIC%"}% presents %PROGRAMINFO_LINKED_INCLUDE% %DATETIME{"$lwday, $month $day" date="%FORMFIELD{"Date" topic="%BASETOPIC%"}%"}%, %FORMFIELD{"EventTime" topic="%BASETOPIC%"}%. At %VENUENAMEADDR_LINKED_INCLUDE% (%FORMFIELD{"Policy" topic="%BASETOPIC%"}%) Info: %SPONSORINFO_LINKED_INCLUDE%

   * Set SDDEMENTRY_LINKED_INCLUDE = 
%FORMFIELD{"Sponsor" topic="%BASETOPIC%"}% %FORMFIELD{"Title" topic="%BASETOPIC%"}%. %DATETIME{"$lwday, $lmonth $day" date="%FORMFIELD{"Date" topic="%BASETOPIC%"}%"}%, %FORMFIELD{"EventTime" topic="%BASETOPIC%"}% %PROGRAMINFO_LINKED_INCLUDE%. %VENUENAMEADDR_LINKED_INCLUDE% (%FORMFIELD{"Policy" topic="%BASETOPIC%"}%) Info: %SPONSORINFO_LINKED_INCLUDE%

   * Set SDDEMENTRY_SEARCHFORMAT = $formfield(Sponsor) $formfield(Title). $percntDATETIME{\"$lwday, $lmonth $day\" date=\"$formfield(Date)\"}$percnt, $formfield(EventTime): %PROGRAMINFO_SEARCHFORMAT%. %VENUENAMEADDR_SEARCHFORMAT% ($formfield(Policy)) Info: %SPONSORINFO_SEARCHFORMAT%

Note:Upcoming events will use only MediaForm topics.
   * Set UPCOMINGEVENTS = <table border="0" cellspacing="1">
     %SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 1)) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" 
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" 
         order="formfield(PubDate)" excludetopic="MediaTopicTemplate" }%</table>

   * Set KEYWORDUPCOMINGEVENTS = <table border=0 cellspacing=1>
     %SEARCH{web="Events,Common" search="form.name~'*MediaForm*' AND MediaType~'*Meeting*'  AND ((D2N PubDate) >= (NOW - 86400 * 1)) AND PublishStatus != 'Hidden' AND (Keywords~'*%TOPIC%*' OR Note~'*%TOPIC%*')" 
         nonoise="on" type="query" nosearch="on" 
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" 
         order="formfield(PubDate)" excludetopic="MediaTopicTemplate" }%</table>

   * Set KEYWORDUPCOMINGEVENTS400 = <table border=0 cellspacing=1>
     %SEARCH{web="Events,Common" search="form.name~'*MediaForm*' AND MediaType~'*Meeting*'  AND ((D2N PubDate) >= (NOW - 86400 * 1)) AND PublishStatus != 'Hidden' AND (Keywords~'*%TOPIC%*' OR Note~'*%TOPIC%*')" 
         nonoise="on" type="query" nosearch="on" 
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' width='400' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" 
         order="formfield(PubDate)" excludetopic="MediaTopicTemplate" }%</table>

   * Set RECENTEVENTS = <table border=0 cellspacing=1>%SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 30)) AND ((D2N PubDate) <= (NOW)) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" 
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" 
         order="formfield(PubDate)" reverse="on" excludetopic="PromoTopicTemplate" limit="20"}%</table>

   * Set KEYWORDRECENTEVENTS = <table border=0 cellspacing=1>%SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 30)) AND ((D2N PubDate) <= (NOW)) AND PublishStatus != 'Hidden'  AND (Keywords~'*%TOPIC%*' OR Note~'*%TOPIC%*')" 
         nonoise="on" type="query" nosearch="on" 
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" 
         order="formfield(PubDate)" reverse="on" excludetopic="PromoTopicTemplate" limit="20"}%</table>

   * Set KEYWORDPASTEVENTS400 = %SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) <= (NOW)) AND PublishStatus != 'Hidden'  AND (Keywords~'*%TOPIC%*' OR Note~'*%TOPIC%*')" 
         nonoise="on" type="query" nosearch="on" 
         format="$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]<br>[[$web.$topic][<img src='$formfield(ThumbnailLink)' width='400' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]]<br>$formfield(EmbedHTML)<br><hr><br>" 
         order="formfield(PubDate)" reverse="on" excludetopic="PromoTopicTemplate,%TOPIC%"}%

   * Set RECENTEVENTSSHORT = <table border=0 cellspacing=1>%SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 30)) AND ((D2N PubDate) <= (NOW)) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" reverse="on" excludetopic="PromoTopicTemplate" limit="5"
         format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]] </td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" order="formfield(Date)"}%</table>

   * Set RECENTEVENTTHUMBS = %SEARCH{web="Events,Common" search="(form.name~'*PromoForm*'  AND ((D2N Date) >= (NOW - 86400 * 30))  AND ((D2N PubDate) <= (NOW)) OR form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 30))  AND ((D2N PubDate) <= (NOW))) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" order="formfield(Date)" reverse="on" excludetopic="PromoTopicTemplate" limit="20" nofinalnewline="on" separator=""
         format="[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='$formfield(Program)' onMouseOver=\"window.status='$formfield(Program)'; return true;\" onMouseOut=\"window.status=''; return true;\">]]" }%

   * Set UPCOMINGEVENTSCALFORMAT = %SEARCH{web="Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*'  AND ((D2N PubDate) >= (NOW - 86400 * 1)) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" 
         format="   * $pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*)" order="formfield(PubDate)" excludetopic="MediaTopicTemplate" }%

   * Set UPCOMINGEVENTSNEWSFORMAT = %SEARCH{web="Events,Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND ((D2N PubDate) >= (NOW - 86400 * 1)) AND PublishStatus != 'Hidden' " 
         nonoise="on" type="query" nosearch="on" format="$n   * $formfield(Title)" order="formfield(PubDate)" excludetopic="MediaTopicTemplate" }%

   * Set ADDPROMOEVENTLINK = %SCRIPTURLPATH{edit}%/Events/EAUTOINC00000?templatetopic=PromoTopicTemplate&topicparent=WebHome&formtemplate=PromoForm

   * Set RELATEDEVENTS = <table border=0 cellspacing=1>%SEARCH{web="Events,Common" 
         search="form.name~'*MediaForm*' AND MediaType~'*Meeting*' AND (Program~'*%BASETOPIC%*' OR Venue~'*%BASETOPIC%*') AND PublishStatus != 'Hidden'" 
         nonoise="on" type="query" nosearch="on" format="<tr><td>$pattern(.*STARTSECTION{.*?CommonCalendarEntry.*?}.(.*?).ENDSECTION.*) [[$web.$topic][Event Details]]</td><td align='center' valign='middle'>[[$web.$topic][<img src='$formfield(ThumbnailLink)' alt='%QUERY{"Title"}%' onMouseOver=\"window.status='%QUERY{"Title"}%'; return true;\" onMouseOut=\"window.status=''; return true;\">]] </td></tr>" order="formfield(PubDate)" excludetopic="PromoTopicTemplate"}%</table>

Publish Related


   * Set PUBLISHTEST = %SEARCH{"PUBLISH_" topic="PublishConfigTest" type="regex" multiple="on" nonoise="on" format="   * $pattern(^ +\* Set *PUBLISH_([^\n\r]+).*)"}%<p><form method="POST" name="rename" action="%SCRIPTURLPATH{rest}%/PublishPlugin/publish"><input type="hidden" name="topic" value="%WEB%.%TOPIC%" /><input type="hidden" name="configtopic" value="%WEB%.PublishConfigTest" /><input type="hidden" name="ping" value="%SERVERTIME%" /><input type="submit" class="twikiSubmit" value="Publish to publishtest" /></form>

   * Set PUBLISHRELEASE = %SEARCH{"PUBLISH_" topic="PublishConfigRelease" type="regex" multiple="on" nonoise="on" format="   * $pattern(^ +\* Set *PUBLISH_([^\n\r]+).*)"}%<p><form method="POST" name="rename" action="%SCRIPTURLPATH{rest}%/PublishPlugin/publish"><input type="hidden" name="topic" value="%WEB%.%TOPIC%" /><input type="hidden" name="configtopic" value="%WEB%.PublishConfigRelease" /><input type="hidden" name="ping" value="%SERVERTIME%" /><input type="submit" class="twikiSubmit" value="Publish to root" /></form><p> *Command Line:* <br> perl -T rest /PublishPlugin/publish topic=%WEB%.%TOPIC% configtopic=%WEB%.PublishConfigRelease

   * Set PUBLISHCOMMON = %SEARCH{"PUBLISH_" topic="PublishConfigCommon" type="regex" multiple="on" nonoise="on" format="   * $pattern(^ +\* Set *PUBLISH_([^\n\r]+).*)"}%

Activist Letters


   * Set ACTIVISTLETTERFORMAT = "<div style=\"page-break-before: always\"> <div align=\"center\"> %URLPARAM{UserNameFirst}% %URLPARAM{UserNameLast}%<br/> %URLPARAM{UserAddress}% <br/> %URLPARAM{UserCityStateZip}% <br/> %URLPARAM{UserPhone}% <br/> %URLPARAM{UserEmail}% <br/> <br/></div> %DATE% <br/><br/> 
$formfield(NameFirst) $formfield(NameLast)<br/> %SPACEOUT{$formfield(Organization)}%  <br/> $formfield(PositionTitle)  <br/> $formfield(Address)  <br/> $formfield(CityStateZip)  <br/> &nbsp; <p/> Dear $formfield(NameFirst) $formfield(NameLast): <br/> <br/> %URLPARAM{"LetterBody" newline="<br />"}% <br/> <br/> Sincerely, <br>&nbsp;<br>&nbsp;<br>&nbsp;<br/> %URLPARAM{UserNameFirst}% %URLPARAM{UserNameLast}% </div>"

Media Database


   * Set PAGESIZE = 100

   * Set UNQMEDIAFORMAT =  $percntIF{\"'$formfield(MediaType)'~'*Pictures*'\" then=\"<img src=\\"%ICONURLPATH{jpg}%\\" alt=\\"Images\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Video*'\" then=\"<img src=\\"%ICONURLPATH{mov}%\\" alt=\\"Video\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Audio*'\" then=\"<img src=\\"%ICONURLPATH{mp3}%\\" alt=\\"Audio\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*PDF*'\" then=\"<img src=\\"%ICONURLPATH{pdf}%\\" alt=\\"PDF\\" title=\\"PDF\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Presentation*'\" then=\"<img src=\\"%ICONURLPATH{ppt}%\\" alt=\\"Presentation\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Book*'\" then=\"<img src=\\"%ICONURLPATH{book}%\\" alt=\\"Book\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Article*' OR '$formfield(MediaType)'~'*File*'\" then=\"<img src=\\"%ICONURLPATH{viewtopic}%\\" alt=\\"Article\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Website*'\" then=\"<img src=\\"%ICONURLPATH{sitetree}%\\" alt=\\"Website\\" width=16 height=16 border=0 />\"}$percnt[[$web.$topic][($topic)]] $formfield(PubDate) <i>[[$web.$topic][$formfield(Title)]] $percntISNEW$nop%</i> -- $percntIF{\"istopic '$formfield(Author)'\" then=\"$formfield(Author)\" else=\"$percntSPACEOUT{$formfield(Author)}%\"}$percnt, $percntIF{\"istopic '$formfield(Publisher)'\" then=\"$formfield(Publisher)\" else=\"$percntSPACEOUT{$formfield(Publisher)}%\"}$percnt, $formfield(Note)
   * Set MEDIAFORMAT = "   * %UNQMEDIAFORMAT%"

   * Set MEDIAFORMATWEMBED = "<p>%UNQMEDIAFORMAT%</p><p><noautolink>$formfield(EmbedHTML)<autolink></p><p>&nbsp;"

   * Set MEDIAFORMAT_NOISNEW = "   * $percntIF{\"'$formfield(MediaType)'*'*Pictures*'\" then=\"<img src=\\"%ICONURLPATH{jpg}%\\" alt=\\"Images\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Video*'\" then=\"<img src=\\"%ICONURLPATH{mov}%\\" alt=\\"Video\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Audio*'\" then=\"<img src=\\"%ICONURLPATH{mp3}%\\" alt=\\"Audio\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*PDF*'\" then=\"<img src=\\"%ICONURLPATH{pdf}%\\" alt=\\"PDF\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Presentation*'\" then=\"<img src=\\"%ICONURLPATH{ppt}%\\" alt=\\"Presentation\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Book*'\" then=\"<img src=\\"%ICONURLPATH{book}%\\" alt=\\"Book\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Article*' OR '$formfield(MediaType)'~'*File*'\" then=\"<img src=\\"%ICONURLPATH{viewtopic}%\\" alt=\\"Article\\" title=\\"Article\\" width=16 height=16 border=0 />\"}$percnt$percntIF{\"'$formfield(MediaType)'~'*Website*'\" then=\"<img src=\\"%ICONURLPATH{sitetree}%\\" alt=\\"Website\\" width=16 height=16 border=0 />\"}$percnt$percnt[[$web.$topic][($topic)]] $formfield(PubDate) <i>[[$web.$topic][$formfield(Title)]]</i> -- $percntIF{\"istopic '$formfield(Author)'\" then=\"$formfield(Author)\" else=\"$percntSPACEOUT{$formfield(Author)}%\"}$percnt, $percntIF{\"istopic '$formfield(Publisher)'\" then=\"$formfield(Publisher)\" else=\"$percntSPACEOUT{$formfield(Publisher)}%\"}$percnt, $formfield(Note)

   * Set SUBMITMEDIALINK = %SCRIPTURL{edit}%/Common/MAUTOINC0?templatetopic=Common.MediaTopicTemplate&topicparent=Common.NewsMedia&formtemplate=Common.MediaForm

   * Set KEYWORDTOPICRECENTMEDIA = %SEARCH{web="Common" 
     search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Author~'*%BASETOPIC%*' OR Publisher~'*%BASETOPIC%*' OR Activist~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden'"
     noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" limit="20"}%

   * Set KEYWORDTOPICMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="off" type="query" nosearch="on" format="" }%
     %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%"}%

   * Set KEYWORDTOPICRESEARCH = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden' AND MediaGroup~'*Research*' " noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% reverse="on" order="formfield(PubDate)"}%

   * Set KEYWORDMEDIAHIGHLIGHTED = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%KEYWORD%*' OR Note~'*%KEYWORD%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden' AND CuratorRating='Highlighted' " noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" header="$pager" footer="$pager" pagesize="%PAGESIZE%"}%
      * Usage: % KEYWORDMEDIAHIGHLIGHTED{KEYWORD="keyword"}%

   * Set TOPICMEDIAHIGHLIGHTEDWEMBED = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*' ) AND PublishStatus!='Hidden' AND CuratorRating='Highlighted' AND MediaType~'*Video*' " noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMATWEMBED% order="formfield(PubDate)" reverse="on"}%

   * Set KEYWORDMEDIA = %SEARCH{web="Common" 
         search="form.name~'*MediaForm' AND (Keywords~'*%KEYWORD%*' OR Note~'*%KEYWORD%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden' " 
         noheader="on"  nototal="off" type="query" nosearch="on" format="" }%
      %SEARCH{web="Common" 
         search="form.name~'*MediaForm' AND (Keywords~'*%KEYWORD%*' OR Note~'*%KEYWORD%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden' " 
         noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%"}%
      * Usage: % KEYWORDMEDIA{KEYWORD="keyword"}%

   * Set KEYWORDRECENTMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%KEYWORD%*' OR Note~'*%KEYWORD%*'  OR text~'*%KEYWORD%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden' " noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" limit="20"}%
      * Usage: % KEYWORDRECENTMEDIA{KEYWORD="keyword"}%

   * Set KEYWORDTOPICMEDIABYTITLE = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Keywords~'*%BASETOPIC%*' OR Author~'*%BASETOPIC%*' OR Publisher~'*%BASETOPIC%*' OR Activist~'*%BASETOPIC%*' OR Note~'*%BASETOPIC%*'   OR text~'*%BASETOPIC%*' OR RelatedKeywords~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(Title)"}%

   * Set LISTEXPLICITMEDIA = %FORMAT{"%TOPICLIST%" type="topic" format=%MEDIAFORMAT%}%
      * Usage: LISTEXPLICITMEDIA{TOPICLIST="topic,topic"}%

   * Set LISTEXPLICITMEDIAWEMBED = %FORMAT{"%TOPICLIST%" type="topic" format=%MEDIAFORMATWEMBED%}%
      * Usage: LISTEXPLICITMEDIAWEMBED{TOPICLIST="topic,topic"}%

   * Set CONTEXTTOPICMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (text~'*%SPACEOUT{%BASETOPIC%}%*' OR text~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on"}%

   * Set CONTEXTTOPICS = %SEARCH{web="Common" search="(NOT form.name~'*MediaForm') AND (text~'*%SPACEOUT{%BASETOPIC%}%*' OR text~'*%BASETOPIC%*') AND PublishStatus!='Hidden'" noheader="on"  nototal="on" type="query" nosearch="on" format="  * $topic" order="$topic"}%

   * Set SELECTEDMEDIA1 = %SEARCH{web="Common" search="form.name~'*MediaForm' AND %MEDIASELECTCRITERIA1% 
     AND PublishStatus!='Hidden'" noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT%}%

   * Set SELECTEDMEDIA2 = %SEARCH{web="Common" search="form.name~'*MediaForm' AND %MEDIASELECTCRITERIA2% AND 
     PublishStatus!='Hidden'" noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT%}%

   * Set SELECTEDMEDIA3 = %SEARCH{web="Common" search="form.name~'*MediaForm' AND %MEDIASELECTCRITERIA3% AND
      PublishStatus!='Hidden'" noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT%}%

   * Set ALLMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="off" nosearch="on" type="query" format="" excludetopic="MediaTopicTemplate"}%
     %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%"}%

   * Set PRESSROOM = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND MediaGroup~'*NewsRelease*' AND Publisher~'*CitizensOversight*' " 
     noheader="on"  nototal="off" type="query" nosearch="on" format="" excludetopic="MediaTopicTemplate"}%
     %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND MediaGroup~'*NewsRelease*' AND Publisher~'*CitizensOversight*' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%"}%

   * Set LATESTPRESS = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND MediaGroup~'*NewsRelease*' AND Publisher~'*CitizensOversight*' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate" limit="10"}%

   * Set ALLMEDIABYNAME = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="$topic" excludetopic="MediaTopicTemplate"  header="$pager" footer="$pager" pagesize="%PAGESIZE%"}%

   * Set ALLCOPSMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND (MediaGroup~'*RequestLetter*' OR MediaGroup~'*ResponseLetter*)' " 
     noheader="on"  nototal="off" type="query" nosearch="on" 
     format="" excludetopic="MediaTopicTemplate"}%
     %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND (MediaGroup~'*RequestLetter*' OR MediaGroup~'*ResponseLetter*)' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate"  header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%"}%

   * Set ALLGOVTMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND (MediaGroup~'*GovtDoc*' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate"  header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%"}%

   * Set ALLMODIFIEDMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="modified" reverse="on" excludetopic="MediaTopicTemplate"  header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%"}%

   * Set MODIFIEDMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMAT% order="modified" reverse="on" excludetopic="MediaTopicTemplate" limit="10"}%

   * Set MODIFIEDNONMEDIA = %SEARCH{web="Common" search="NOT form.name~'*MediaForm' AND NOT uc(text)~'*INFRASTRUCTURE*' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format="   * [[$topic]] %ISNEW% - $summary" order="modified" reverse="on" excludetopic="Web*, EventList, MediaTopicHeader, MediaTopicTemplate" limit="10"}%

   * Set ALLHIDDENMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus='Hidden'" 
     noheader="on"  nototal="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" 
     reverse="on" excludetopic="MediaTopicTemplate" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%"}%

   * Set AUTHORSEARCH = %SEARCH{web="Common" 
      search="form.name~'*MediaForm' AND (Author~'*%TOPIC%*' OR Publisher~'*%TOPIC%*' OR Activist~'*%TOPIC%*' OR Note~'*%TOPIC%*' OR Keywords~'*%TOPIC%*'  OR text~'*%TOPIC%*') AND PublishStatus!='Hidden'" 
      noheader="on"  nototal="off" nosearch="on" type="query"  format="" excludetopic="MediaTopicTemplate" }%
      %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Author~'*%TOPIC%*' OR Publisher~'*%TOPIC%*' OR Activist~'*%TOPIC%*' OR Note~'*%TOPIC%*' OR Keywords~'*%TOPIC%*'  OR text~'*%TOPIC%*') AND PublishStatus!='Hidden'" 
      noheader="on"  nosummary="on" type="query" nototal="on" nosearch="on" format=%MEDIAFORMAT% excludetopic="MediaTopicTemplate" 
      order="formfield(PubDate)" reverse="on" header="$pager$nop" footer="$pager" pagesize="%PAGESIZE%"}%


   * Set PUBLISHERSEARCH = %AUTHORSEARCH%

   * Set DATASETLIST = %SEARCH{web="Common" search="form.name~'*MediaForm' AND (Author~'*%TOPIC%*' OR Publisher~'*%TOPIC%*' OR Activist~'*%TOPIC%*' OR Note~'*%TOPIC%*' OR Keywords~'*%TOPIC%*'  OR text~'*%TOPIC%*') AND PublishStatus!='Hidden' AND MediaType~'*Dataset*'" 
     noheader="on"  nosummary="on" type="query" nosearch="on" format=%MEDIAFORMAT% order="formfield(PubDate)" reverse="on" header="$pager" footer="$pager" pagesize="%PAGESIZE%"}%

   * Set MEDIASUMMARYHEADER = ---++ Summary of articles submitted ([[%SUBMITMEDIALINK%][Add]]  | [[Common.NewsMedia][All]]):

Note: embed does not work in Chrome. Must use iframe but if this is used in firefox, it pops open the document in another window instead of in-line.
   * Set EMBEDPDFMEDIA = <iframe src="%QUERY{"MediaLink"}%" type="application/x-pdf" width="700" height="890"></iframe>
   * Set EMBEDPDFMEDIALAND = <iframe src="%QUERY{"MediaLink"}%" type="application/x-pdf" width="700" height="540"></iframe>
Note: embed does not work in Chrome. Must use iframe but if this is used in firefox, it pops open the document in another window instead of in-line.

   * Set EMBEDPDFBYURL = <iframe  src='%ENCODE{"%URL%"}%#toolbar=1' type='application/pdf' width='700px' height='890px'>iframe tag not supported. Click <a href="%URL%" target="new">here</a> to view the document.</iframe><br>If the document does not display above, click <noautolink><a href="%URL%" target="new">here</a></noautolink>
      * Usage: EMBEDPDFBYURL{URL="full pdf url"}%
   * Set EMBEDPDFLANDBYURL = <iframe  src='%ENCODE{"%URL%"}%#toolbar=1' type='application/pdf' width='700px' height='540px'>iframe tag not supported. Click <a href="%URL%" target="new">here</a> to view the document.</iframe><br>If the document does not display above, click <noautolink><a href="%URL%" target="new">here</a></noautolink>
      * Usage: EMBEDPDFLANDBYURL{URL="full pdf url"}%

   * S et EMBEDPDFMEDIA = <embed src="%QUERY{"MediaLink"}%" type="application/x-pdf" width="700" height="890"/><br>If the document does not display above, click <a href="%QUERY{"MediaLink"}%" target="new">here</a>
   * S et EMBEDPDFMEDIALAND = <embed src="%QUERY{"MediaLink"}%" type="application/x-pdf" width="700" height="540"/><br>If the document does not display above, click <a href="%QUERY{"MediaLink"}%" target="new">here</a>

   * S et EMBEDPDFMEDIA = <object data='%ENCODE{"%QUERY{"MediaLink"}%"}%#toolbar=1' type='application/pdf' width='700px' height='890px'>Object tag not supported. Click <a href="%QUERY{"MediaLink"}%" target="new">here</a> to view the document.</object><br>If the document does not display above, click <noautolink><a href="%QUERY{"MediaLink"}%" target="new">here</a></noautolink>
   * S et EMBEDPDFMEDIALAND = <object data='%ENCODE{"%QUERY{"MediaLink"}%"}%#toolbar=1' type='application/pdf' width='700px' height='540px'>Object tag not supported. Click <a href="%QUERY{"MediaLink"}%" target="new">here</a> to view the document.</object><br>If the document does not display above, click <noautolink><a href="%QUERY{"MediaLink"}%" target="new">here</a></noautolink>

   * S et EMBEDPDFBYURL = <iframe  data='%ENCODE{"%URL%"}%#toolbar=1' type='application/pdf' width='700px' height='890px'>Object tag not supported. Click <a href="%URL%" target="new">here</a> to view the document.</object><br>If the document does not display above, click <noautolink><a href="%URL%" target="new">here</a></noautolink>
      * Usage: EMBEDPDFBYURL{URL="full pdf url"}%
   * S et EMBEDPDFLANDBYURL = <object data='%ENCODE{"%URL%"}%#toolbar=1' type='application/pdf' width='700px' height='540px'>Object tag not supported. Click <a href="%URL%" target="new">here</a> to view the document.</object><br>If the document does not display above, click <noautolink><a href="%URL%" target="new">here</a></noautolink>
      * Usage: EMBEDPDFLANDBYURL{URL="full pdf url"}%

   * Set RIGHTBARFORMAT = "<tr><td bgcolor=\"#FFFFFF\" colspan=2><center><b> [[$topic][$formfield(Title,1000,\"<br/>\")]] </b>$formfield(Note,1000,\"<br/>\")<br>$formfield(EmbedHTML)</center></td></tr>"

   * Set RIGHTBARSCREENDIM = width="300" height="212"

   * Set COPSVIDEOMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND MediaType~'*Video*' AND Publisher='CitizensOversight' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMATWEMBED% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate"  header="$pager" footer="$pager" pagesize="25"}%

   * Set OTHERVIDEOMEDIA = %SEARCH{web="Common" search="form.name~'*MediaForm' AND PublishStatus!='Hidden' AND MediaType~'*Video*' AND Publisher!='CitizensOversight' " 
     noheader="on"  nototal="on" type="query" nosearch="on" 
     format=%MEDIAFORMATWEMBED% order="formfield(PubDate)" reverse="on" excludetopic="MediaTopicTemplate" header="$pager" footer="$pager" pagesize="25"}%

   * Set AUDIOMEDIA = <audio controls><source src="%QUERY{"MediaLink"}%" type="audio/mpeg">Your browser does not support the audio element. [[%QUERY{"MediaLink"}%][Try playing it directly.]]</audio>

#   * Set AUDIOMEDIA = <audio controls><source src="formfield(MediaLink)" type="audio/mpeg">Your browser does not support the audio element. [[formfield(MediaLink)][Try playing it directly.]]</audio>


   * Set ATTACHEDFILELIST = %ATTACHMENTLIST{sort="$fileName" sortorder="ascending" header="All files:" footer="Number of files: $fileCount" format="   * $fileIcon <a href=\"$fileUrl\" target=\"_blank\">$fileName</a> ($fileSize) -- $fileComment" }%

People Database


   * Set PROJECTPEOPLEHDR = |  *Name*  |  *Address<BR>City, State, Zip*  |  *Phone1<BR>Phone2*  |  *email*  |  *Orgs; Positions; Notes*  |  *Edit*  |
   * Set PROJECTPEOPLEFORMATNQ = |<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink>  |<span style='white-space: nowrap;'>$formfield(Address)</span><BR><span style='white-space: nowrap;'>$formfield(CityStateZip)</span>  |$formfield(Phone1)<BR>$formfield(Phone2)  |$formfield(Email)  |$formfield(Organization); $formfield(PositionsHeld); $formfield(Note)  |  %TBLEDITICON%  |
   * Set PROJECTPEOPLE = %SEARCH{web="People" search="form.name ~ '*PeopleForm' AND (KeywordTags ~ '*%TOPIC%*' OR Tags ~ '*%TOPIC%*' OR Note ~ '*%TOPIC%*') AND NOT Association~'Adversary' " noheader="on"  type="query" nosearch="on" format="%PROJECTPEOPLEFORMATNQ%"}%
   * Set PROJECTADVERSARIES = %SEARCH{web="People" search="form.name ~ '*PeopleForm' AND (KeywordTags ~ '*%TOPIC%*' OR Tags ~ '*%TOPIC%*' OR Note ~ '*%TOPIC%*') AND Association~'Adversary'  " noheader="on"  type="query" nosearch="on" format="%PROJECTPEOPLEFORMATNQ%"}%
   * Set PROJECTPEOPLEEMAILLIST = %SEARCH{web="People" search="form.name ~ '*PeopleForm' AND (KeywordTags ~ '*%TOPIC%*' OR Tags ~ '*%TOPIC%*' OR Note ~ '*%TOPIC%*') AND NOT Association~'Adversary'  " noheader="on"  type="query" nosearch="on" format="$formfield(Email)<br>"}%
   * Set CONTACTFORMAT = "   * [[$topic][$formfield(NameFirst) $formfield(NameLast)]] $formfield(Email) $formfield(Phone1)"

   * Set MEMBTRANSACTIONHEADER = |  *Date*  |  *Num*  |  *Amt*  |  *Pmt Type*  |  *Type*  |  *Item*  |  *Description*  |  *Count*  |  *Entity*  |  *...*  |

   * Set MEMBTRANSACTIONFORMATNQ = |$formfield(TransDate)  |$formfield(TransChkNum)  |$formfield(TransAmt)  |<noautolink>$formfield(TransPmtType) </noautolink> |$formfield(TransType)  |$formfield(TransItem)  |$formfield(TransDesc)  |$formfield(TransCount)  |<noautolink>$formfield(TransEntity)<autolink>  |  %TBLEDITICON%  |

   * Set MEMBTRANSACTIONFORMAT = "%MEMBTRANSACTIONFORMATNQ%"

   * Set TRANSACTIONHEADER = %MEMBTRANSACTIONHEADER%  *Memb Topic*  |

   * Set TRANSACTIONFORMAT = "%MEMBTRANSACTIONFORMATNQ% [[People.$formfield(MembTopic)][$percntFORMFIELD{\"NameFirst\" topic=\"People.$formfield(MembTopic)\"}$percnt $percntFORMFIELD{\"NameLast\" topic=\"People.$formfield(MembTopic)\"}$percnt]]  |"

   * Set MEMBLISTTRANSFORMAT = "<p>[[People.$formfield(MembTopic)][$percntFORMFIELD{\"NameFirst\" topic=\"People.$formfield(MembTopic)\"}$percnt $percntFORMFIELD{\"NameLast\" topic=\"People.$formfield(MembTopic)\"}$percnt]] ($formfield(TransCount))<br>$percntFORMFIELD{\"Address\" topic=\"People.$formfield(MembTopic)\"}$percnt <br> $percntFORMFIELD{\"CityStateZip\" topic=\"People.$formfield(MembTopic)\"}$percnt <br> $percntFORMFIELD{\"Phone1\" topic=\"People.$formfield(MembTopic)\"}$percnt $percntFORMFIELD{\"Phone2\" topic=\"People.$formfield(MembTopic)\"}$percnt"<br> $percntFORMFIELD{\"Email\" topic=\"People.$formfield(MembTopic)\"}$percnt $percntFORMFIELD{\"Email2\" topic=\"People.$formfield(MembTopic)\"}$percnt"

   * Set MEMBERINFOHEADER = |  *Name*  |  *Address / email*  |  *Phone*  |  *Level<BR>Date*  |  *Interest<br>Contrib*  |  *Note / Tags*  |  *...*  |

   * Set MEMBERINFOFORMAT = "|<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink> [[$web.$topic][<nop>]] %ISNEW%  |<noautolink><span style='white-space: nowrap;'>$formfield(Address)</span><BR><span style='white-space: nowrap;'>$formfield(CityStateZip)</span><br></noautolink> $formfield(Email, 35) $formfield(Email2, 35)   |<noautolink>$formfield(Phone1)<BR>$formfield(Phone2)</noautolink> |$formfield(Level)<BR>$formfield(DatePaid2008)  $formfield(DatePaid)  |$formfield(Interest) <br> $formfield(Lutz08Contrib)  |$formfield(Note) $formfield(Tags) $formfield(Processing) |  %TBLEDITICON%  |"

   * Set MEMBERSEARCHSPEC = search="form.name~'*PeopleForm' AND lc(NameLast)~lc('%URLPARAM{NameLast}%*') AND lc(NameFirst)~lc('%URLPARAM{NameFirst}%*') AND (lc(Email)~lc('*%URLPARAM{Email}%*') OR  lc(Email2)~lc('*%URLPARAM{Email}%*') ) AND (Phone1~'*%URLPARAM{Phone}%*' OR Phone2~'*%URLPARAM{Phone}%*') AND lc(Address)~lc('%URLPARAM{Address}%*') AND lc(CityStateZip)~lc('%URLPARAM{CityStateZip}%*') "


   * Set CONTACTSIMPLEHEADER = |  *Name*  |  *Address / email*  |  *Phone*  |  *...*  |

   * Set CONTACTSIMPLEFORMAT = "|<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink> [[$web.$topic][<nop>]] %ISNEW% <br>$formfield(PositionsHeld)  |<noautolink><span style='white-space: nowrap;'>$formfield(Address)</span><BR><span style='white-space: nowrap;'>$formfield(CityStateZip)</span><br></noautolink> $formfield(Email) $formfield(Email2)   |<noautolink>$formfield(Phone1)<BR>$formfield(Phone2)</noautolink> |  %TBLEDITICON%  |"

   * Set TAGGEDMEMBERS = %SEARCH{web="People" search="form.name~'*PeopleForm*' AND Tags~'*%TOPIC%*' " format=%CONTACTSIMPLEFORMAT% nonoise="on" type="query" nosearch="on" }%

   * Set TAGGEDMEMBERHEADER = %CONTACTSIMPLEHEADER%

Use:
TAGGEDMEMBERHEADER%
TAGGEDMEMBERS%

   * Set MEMBERORGHEADER = |  *Name*  |  *Organization*  |  *Address / email*  |  *Phone*  |  *Notes*  |  *...*  |

   * Set MEMBERORGFORMAT = "|<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink> [[$web.$topic][<nop>]] %ISNEW%  |$formfield(Organization)  |<noautolink><span style='white-space: nowrap;'>$formfield(Address)</span><BR><span style='white-space: nowrap;'>$formfield(CityStateZip)</span><br></noautolink> $formfield(Email, 35) $formfield(Email2, 35)   |<noautolink>$formfield(Phone1)<BR>$formfield(Phone2)</noautolink>  |$formfield(Note)  |  %TBLEDITICON%  |"

   * Set PHONELISTHEADERNOEMAIL = |  *Name*  |  *Phones* |  *Notes*  |  *...*  |
   * Set PHONELISTFORMATNOEMAIL = "|<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink>  |$formfield(Phone1)<br>$formfield(Phone2)  |Paid: $formfield(DatePaid2008) <br> $formfield(Note); $formfield(LastContact)  |  %TBLEDITICON%  |"

   * Set PHONELISTHEADEREMAIL = |  *Name*  |  *Phones* |  *Email*  |  *Notes*  |  *...*  |
   * Set PHONELISTFORMATEMAIL = "|<noautolink>$formfield(NameLast), $formfield(NameFirst)</noautolink>  |$formfield(Phone1)<br>$formfield(Phone2)  |$formfield(Email) <br> $formfield(Email2)   |Paid: $formfield(DatePaid2008) <br> $formfield(Note); $formfield(LastContact)  |  %TBLEDITICON%  |"


   * Set MEMBERCSVHEADER = "NameLast","NameFirst","Address","CityStateZip","Phone1","Phone2","Email","Email2","Organization","Website","Note","Tags","PositionsHeld","Volunteer Activities","House Party Info"<br/>
   * Set MEMBERCSVFORMAT = "\"$formfield(NameLast)\",\"$formfield(NameFirst)\",\"$formfield(Address)\",\"$formfield(CityStateZip)\",\"$formfield(Phone1)\",\"$formfield(Phone2)\",\"$formfield(Email)\",\"$formfield(Email2)\",\"$formfield(Organization)\",\"$formfield(Website)\",\"$formfield(Note)\",\"$formfield(Tags)\",\"$formfield(PositionsHeld)\",\"$formfield(Volunteer Activities)\",\"$formfield(House Party Info)\"<br/>"

Contacts Database


   * Set CONTACTORGHEADER = |  *Organization*  |  *Address / web / email*  |  *Phone*  |  *Notes*  |  *...*  |

   * Set CONTACTORGFORMAT = "|$formfield(Organization) [[$web.$topic][<nop>]] %ISNEW%  |<noautolink><span style='white-space: nowrap;'>$formfield(Address)</span><BR><span style='white-space: nowrap;'>$formfield(CityStateZip)</span><br></noautolink> $formfield(Website)  $formfield(Email) $formfield(Email2)   |<noautolink>$formfield(Phone1)<BR>$formfield(Phone2)</noautolink>  |$formfield(Note)  |  %TBLEDITICON%  |"

   * Set CONTACTLISTFORMAT = "   * [[$web.$topic][$formfield(Organization)]] %ISNEW% --  [[$formfield(Website)][Website]] [[mailto:$formfield(Email)][Email]] -- <noautolink>$formfield(Address), $formfield(CityStateZip)</noautolink> -- $formfield(Phone1) -- $formfield(Note)"

   * Set RELATEDTOORGHEADER = ---++ Contacts related to this Organization ([[NewContact][Add]])

   * Set RELATEDTOORGSEARCH = %SEARCH{search="form.name~'*ContactForm*' AND (Organization~'*%TOPIC%*' OR Organization~'*%FORMFIELD{Organization}%*') "
     noheader="on"  nosummary="on" type="query" nosearch="on" 
     format=%CONTACTFORMAT% order="formfield(NameLast)" excludetopic="%TOPIC%"}%
     <h4>Contacts from Secured Database</h4>
     %SEARCH{search="form.name~'*PeopleForm*' AND (Organization~'*%TOPIC%*' OR Organization~'*%FORMFIELD{Organization}%*') " 
     header="$n%MEMBERORGHEADER%"  nosummary="on" type="query" nosearch="on" 
     format=%MEMBERORGFORMAT% order="formfield(NameLast)" excludetopic="%TOPIC%"}%

Listserve


   * Set LISTSERVEHEADER = |  *List Title<br>(Name)*  |  *Description*  |  *Project*  |  *Who may subscribe?*  |  *Who May Post*  |  *Info <br> Admin*  |
   * Set LISTSERVEFORMAT = "| [[$topic]]<br>($formfield(ListName))   | $formfield(ListDescription)  |   $formfield(ProjectTopic)  |   $formfield(WhoMayJoin) <br> [[$formfield(SubscribeLink)][Subscribe]]    |   $formfield(WhoMayPost) <br> [[mailto:$formfield(PostEmail)][Post]]    |  [[$formfield(ListInfoLink)][Info]]    [[$formfield(ArchiveLink)][Archive]]   [[$formfield(AdministrateLink)][Admin]]    |"

   * Set LISTSERVELIST = %SEARCH{search="form.name~'*ListServeForm' AND Hidden != 'Yes'" header="%LISTSERVEHEADER%"  nototal="on" type="query" nosearch="on" format=%LISTSERVEFORMAT% order="topic" excludetopic="ListServeTopicTemplate, ListServe,ListServeForm"}%

   * Set KEYWORDTOPICLISTSERVE = %SEARCH{search="form.name~'*ListServeForm' AND (ProjectTopic~'*%BASETOPIC%*' OR ListTags~'*%BASETOPIC%*'" 
     header="$n%LISTSERVEHEADER%"  nototal="on" type="query" nosearch="on" format=%LISTSERVEFORMAT% order="topic" excludetopic="ListServeTopicTemplate, ListServe,ListServeForm"}%

The following to be used in ListServeTopicHeader
   * Set LISTTOPICLISTSERVE = %SEARCH{search="form.name~'*ListServeForm' AND name='%BASETOPIC%' " header="$n%LISTSERVEHEADER%"  nototal="on"  type="query" nosearch="on" format=%LISTSERVEFORMAT% order="topic" excludetopic="ListServeTopicTemplate, ListServe,ListServeForm"}%

The following used in subscription forms
   * Set SELECTLISTSERVES = %SEARCH{search="form.name='ListServeForm' AND (Advertise = 'Yes' OR name='%BASETOPIC%' " nototal="on" type="query" nosearch="on" format="<input type=\"checkbox\" name=\"lists\" value=\"$formfield(ListName)\" $percentIF{\" '%BASETOPIC%'=$'topic' \" then=\"checked\" else=\"\"}$percent><b>[[$topic]]</b> - ($formfield(ListName)) $formfield(ListDescription)<br>" separator="" order="topic" excludetopic="ListServeTopicTemplate, ListServe,ListServeForm"}%

Subscription Blocks

Set SUBSCRIBE_COPSMAIN =
Email: Name: Info

Set SUBSCRIBE_COPSMAIN_VERTBAR =
Email:

Name:

Info

Projects


   * Set PROJECTLISTHEADER = |  *Project*  |  *Description*  |  *Parent Project*  |  *Curator*  |  *Status*  |

   * Set PROJECTLISTFORMAT = "| [[$topic][$formfield(ProjectName)]]   | $formfield(ProjectDescription)  |   $formfield(ProjectParents)  |   $formfield(ProjectCurator)  |   $formfield(ProjectStatus)    |"

   * Set CREATEPROJECT = <form action="%SCRIPTURLPATH%/edit%SCRIPTSUFFIX%/%WEB%/">Add Project: Topic Name: <input type="text" name="topic" size="32" /><input type="submit" value="Create" /><input type="hidden" name="templatetopic" value="ProjectTopicTemplate" /><input type="hidden" name="topicparent" value="WebHome" /><input type="hidden" name="topicform" value="ProjectForm" /></form>

   * Set CHILDPROJECTLIST = %SEARCH{web="Common" search="form.name~'*ProjectForm' AND ProjectParents~'*%TOPIC%*'" header="$n|  *Topic*  |  *Description*  |  *Status*  |  *Parents*  |"  nototal="on" type="query" nosearch="on" format="| [[$topic]] %ISNEW%  | $formfield(ProjectDescription)  | $formfield(ProjectStatus)  | $formfield(ProjectParents)  |" order="ProjectName" excludetopic="ProjectTopicTemplate"}%

   * Set RELATEDPROJECTLIST = %SEARCH{web="Common" search="form.name~'*ProjectForm' AND (RelatedKeywords~'*%TOPIC%*' OR ProjectParents~'*%TOPIC%*') " header="$n|  *Topic*  |  *Description*  |  *Status*  |  *Parents*  |"  nototal="on" type="query" nosearch="on" format="| [[$topic]] %ISNEW%  | $formfield(ProjectDescription)  | $formfield(ProjectStatus)  | $formfield(ProjectParents)  |" order="ProjectName" excludetopic="ProjectTopicTemplate"}%

   * Set MAINPROJECTLIST = %INCLUDE{Common.MainProjectList}%
% SEARCH{web="Common" search="form.name~'*ProjectForm' AND ProjectParents='' AND (ProjectStatus='Active' OR ProjectStatus='Hot' AND (ProjectType='IssueOversight') " 
  nonoise="on" type="query" format="   * [[$topic]]" 
  order="ProjectName" excludetopic="ProjectTopicTemplate"}%



   * Set PROJECTSIMPLELIST2LEVEL = %SEARCH{web="Common" 
   search="form.name~'*ProjectForm' AND ProjectParents='' AND (ProjectStatus='Active' OR ProjectStatus='Hot')" 
   nonoise="on" type="query" 
   format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $n$percntSEARCH{web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND (ProjectStatus='Active' OR ProjectStatus='Hot')\" nonoise=\"on\" type=\"query\" format=\"   * &nbsp;&nbsp; [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]]\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"off\"}$percnt" 
   order="ProjectName" 
   excludetopic="ProjectTopicTemplate" 
   separator=""}%
   
   * Set PROJECTSIMPLELIST2LEVELISSUES = %SEARCH{web="Common" 
   search="form.name~'*ProjectForm' AND ProjectParents='' AND (ProjectStatus='Active' OR ProjectStatus='Hot') AND ProjectType='IssueOversight' " 
   nonoise="on" type="query" 
   format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $n$percntSEARCH{web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND (ProjectStatus='Active' OR ProjectStatus='Hot')\" nonoise=\"on\" type=\"query\" format=\"   * &nbsp;&nbsp; [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]]\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"off\"}$percnt" 
   order="ProjectName" 
   excludetopic="ProjectTopicTemplate" 
   separator=""}%

   * Set PROJECTSIMPLELIST2LEVELGOVT = %SEARCH{web="Common" 
   search="form.name~'*ProjectForm' AND ProjectParents='' AND (ProjectStatus='Active' OR ProjectStatus='Hot') AND ProjectType='GovtOversight' " 
   nonoise="on" type="query" 
   format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $n$percntSEARCH{web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND (ProjectStatus='Active' OR ProjectStatus='Hot')\" nonoise=\"on\" type=\"query\" format=\"   * &nbsp;&nbsp; [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]]\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"off\"}$percnt" 
   order="ProjectName" 
   excludetopic="ProjectTopicTemplate" 
   separator=""}%

   * Set PROJECTSIMPLELIST2LEVELINFRASTRUCTURE = %SEARCH{web="Common" 
   search="form.name~'*ProjectForm' AND ProjectParents='' AND (ProjectStatus='Active' OR ProjectStatus='Hot') AND ProjectType='Infrastructure Project' " 
   nonoise="on" type="query" 
   format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $n$percntSEARCH{web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND (ProjectStatus='Active' OR ProjectStatus='Hot')\" nonoise=\"on\" type=\"query\" format=\"   * &nbsp;&nbsp; [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]]\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"off\"}$percnt" 
   order="ProjectName" 
   excludetopic="ProjectTopicTemplate" 
   separator=""}%


   * Set PROJECTLISTGROUPED = %INCLUDE{Common.ProjectListGrouped}%
 
   * Set PROJECTKEYWORDS = %SEARCH{web="Common" search="form.name~'*ProjectForm' " nonoise="on" type="query" format="$topic " order="ProjectName" excludetopic="ProjectTopicTemplate"}%

% SEARCH{
      header="$n<b> [[Common.InfrastructureProjects][Infrastructure]] </b> - Projects related to how we manage projects and support information.$n" 
      web="Common" search="form.name~'*ProjectForm' AND ProjectParents='' AND ProjectType='InfrastructureProject' "  
      type="query" nosearch="on" nototal="on" order="ProjectName" excludetopic="ProjectTopicTemplate" separator=""
      format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $percntISNEW% -- $formfield(ProjectDescription)$n$percntSEARCH{
         web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND ProjectType='InfrastructureProject' \" 
         type=\"query\"  nosearch=\"on\" nototal=\"on\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\" nofinalnewline=\"on\"
         format=\"      * [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]] $dollarpercntISNEW% -- $dollarformfield(ProjectDescription)\"  }$percnt"
    }%%SEARCH{ 
      header="$n<b> Common.GovtOversight </b> - Choose a governmental body and monitor it.$n"
      web="Common" search="form.name~'*ProjectForm' AND ProjectParents='' AND ProjectType='GovtOversight' " 
      type="query" nosearch="on" nototal="on" order="ProjectName" excludetopic="ProjectTopicTemplate"  separator=""
      format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $percntISNEW% -- $formfield(ProjectDescription)$n$percntSEARCH{
         web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*' AND ProjectType='GovtOversight'\" 
         type=\"query\" nosearch=\"on\" nototal=\"on\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"on\"
         format=\"      * [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]] $dollarpercntISNEW% -- $dollarformfield(ProjectDescription)\"  }$percnt"
    }%%SEARCH{
      header="$n<b> Common.IssueOversight </b> - When important issues arise, we track them as projects.$n"
      web="Common" search="form.name~'*ProjectForm' AND ProjectParents='' AND ProjectType='IssueOversight' " 
      type="query" nosearch="on" nototal="on" order="ProjectName" excludetopic="ProjectTopicTemplate"  separator=""
      format="   * [[$web.$topic][$percntSPACEOUT{$topic}$percnt]] $percntISNEW% -- $formfield(ProjectDescription)$n$percntSEARCH{
         web=\"Common\" search=\"form.name~'*ProjectForm' AND ProjectParents~'*$topic*'  AND ProjectType='IssueOversight'\" 
         type=\"query\"  nosearch=\"on\" nototal=\"on\" order=\"ProjectName\" excludetopic=\"ProjectTopicTemplate\"  nofinalnewline=\"on\"
         format=\"      * [[$dollarweb.$dollartopic][$dollarpercntSPACEOUT{$dollartopic}$dollarpercnt]] $dollarpercntISNEW% -- $dollarformfield(ProjectDescription)\"  }$percnt" }%

List Contacts with %TOPIC%Core (sans Con) included in Keywords

   * Set TOPIC_CORE_CONTACTS = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%Core*' AND NOT Keywords~'*%TOPIC%CoreCon*' " 
            header="$n%CONTACTORGHEADER%" type="query" %NONOISEWHDR% 
            format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%
   * Set TOPIC_LINK_LIST = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%*' AND NOT (Keywords~'*%TOPIC%CoreCon*' OR Keywords~'*%TOPIC%Con*' ) " 
            noheader="on" type="query" %NONOISEWHDR% 
            format=%CONTACTLISTFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

List Members with %TOPIC%Core (sans Con) included in Tags

   * Set TOPIC_CORE_MEMBERS = %SEARCH{ web="People" search="form.name~'*PeopleForm' AND Tags~'*%TOPIC%Core*' AND NOT Tags~'*%TOPIC%CoreCon*' " 
            header="$n%MEMBERORGHEADER%" type="query" %NONOISEWHDR% 
            format=%MEMBERORGFORMAT% order="formfield(NameLast)" excludetopic="MembersTopicTemplate"}%

List Opponent Contacts with %TOPIC%CoreCon included in Keywords

   * Set TOPIC_CORE_CON_CONTACTS = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%CoreCon*' " 
             header="$n%CONTACTORGHEADER%" type="query" %NONOISEWHDR% 
             format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

List Opponent Members with %TOPIC%CoreCon included in Tags

   * Set TOPIC_CORE_CON_MEMBERS = %SEARCH{search="form.name~'*PeopleForm' AND Tags~'*%TOPIC%CoreCon*' " 
            header="$n%MEMBERORGHEADER%" type="query" %NONOISEWHDR% web="People"
            format=%MEMBERORGFORMAT% order="formfield(NameLast)" excludetopic="MembersTopicTemplate"}%

List Allied Contacts with %TOPIC% (sans Con or Core or Decider or Neutral) included in Keywords

   * Set TOPIC_CONTACTS = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%*' AND NOT (Keywords~'*%TOPIC%Core*'  OR Keywords~'*%TOPIC%Con*' OR Keywords~'*%TOPIC%Decider*' OR Keywords~'*%TOPIC%Neutral*')  " 
           header="$n%CONTACTORGHEADER%" type="query" %NONOISEWHDR% web="Common"
           format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

List Opponent Contacts with %TOPIC%Con included in Keywords

   * Set TOPIC_CON_CONTACTS = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%Con*' " 
            header="$n%CONTACTORGHEADER%"  type="query" %NONOISEWHDR% web="People"
             format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

List Stakeholder Members with %TOPIC% (sans Con or Core or Decider or Neutral) included in Tags

   * Set TOPIC_MEMBERS = %SEARCH{search="form.name~'*PeopleForm' AND Tags~'*%TOPIC%*' AND NOT (Tags~'*%TOPIC%Core*' OR Tags~'*%TOPIC%Con*' OR Tags~'*%TOPIC%Decider*' OR Tags~'*%TOPIC%Neutral*') " 
            header="$n%MEMBERORGHEADER%"   type="query" %NONOISEWHDR% web="People"
            format=%MEMBERORGFORMAT% order="formfield(NameLast)" excludetopic="MembersTopicTemplate"}%

List Opponent Followers - Citizens and activists who support and follow the opponents. %TOPIC%Con included in Tags

   * Set TOPIC_CON_MEMBERS = %SEARCH{search="form.name~'*PeopleForm' AND Tags~'*%TOPIC%Con*' " 
            header="$n%MEMBERORGHEADER%"  type="query" %NONOISEWHDR% web="People"
            format=%MEMBERORGFORMAT% order="formfield(NameLast)" excludetopic="MembersTopicTemplate"}%

List Governmental Decision Makers: Contacts with %TOPIC%Decider included in Keywords

   * Set TOPIC_DECIDER_CONTACTS = %SEARCH{search="form.name~'ContactForm' AND Keywords~'%TOPIC%Decider' " 
            header="$n%CONTACTORGHEADER%"  type="query" %NONOISEWHDR% 
            format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

List Primary "Neutral" News Media Contacts

   * Set TOPIC_NEUTRAL_CONTACTS = %SEARCH{search="form.name~'*ContactForm' AND Keywords~'*%TOPIC%Neutral*' " 
            header="$n%CONTACTORGHEADER%"   type="query" %NONOISEWHDR% 
            format=%CONTACTORGFORMAT% order="formfield(Organization)" excludetopic="%TOPIC%"}%

Summary of all contacts related to this project.

   * Set TOPIC_RELATED_CONTACTS =
    <p>[[Common.NewContact][Add Organization]] | [[People.NewMember][Add Person (secured)]] 
    <h3>Core Proponents</h3>%TOPIC_CORE_CONTACTS%
    <p>%TOPIC_CORE_MEMBERS%
    <h3>Other Proponents</h3>%TOPIC_CONTACTS%
    <p>%TOPIC_MEMBERS%
    <h3>Decision Makers</h3>%TOPIC_DECIDER_CONTACTS%
    <h3>Primary "Neutral" and News Media Contacts</h3>%TOPIC_NEUTRAL_CONTACTS%
    <h3>Core Opponents</h3>%TOPIC_CORE_CON_CONTACTS%
    <p>%TOPIC_CORE_CON_MEMBERS%
    <h3>Other Opponents</h3>%TOPIC_CON_CONTACTS%
    <p>%TOPIC_CON_MEMBERS%

Here is the dynamic MAINPROJECTLIST. This takes too many CPU cycles to do it all the time without caching.

COPs Program

ISSUE OVERSIGHT

GOVT OVERSIGHT

MEDIA PROJECTS

INFRASTRUCTURE

Here is the dynamic PROJECTLISTGROUPED. This takes too many CPU cycles to do it all the time without caching.

Infrastructure - Projects related to how we manage projects and support information.

COPs Program -- Parent project to all COPs projects.
- COPs Resources -- Compilation of resources and related information useful to COPs participants.
- Project Anatomy -- A "project of projects" -- how we manage and organize COPs projects on this site.

Govt Oversight - Choose a governmental body and monitor it.

Grossmont Healthcare Board -- After being cited by the California Medical review board, the community became aware that the District Board was unaware of these events, despite a clear expectation by the community that they stay perform hospital oversight.
Grossmont Union High School District -- Oppose the sad story of a high school district taken over by religious radicals and left in disarray. Now, they've done it again.

Issue Oversight - When important issues arise, we track them as projects.

Border Security -- This topic includes discussion of the border fence, and the larger issue of border security and immigration reform.
Election Integrity -- Comprises all election integrity issues
- Manual Tally Issues -- 1% Manual Tally is required for certification of elections but are either not completed or are insufficient to report vote-substitution errors. SERIOUS PROBLEMS DETECTED IN SAN DIEGO!
- Open Ballot Initiative -- Describes a method of election canvass processing that uses high-speed electronic equipment but is not subject to hacking vulnerabilities
- Scanner Tape Review -- Our attempt to audit the elections process in San DIego County regarding Diebold scanner tapes.
Energy Policy -- Consideration of various approaches to solving fossil fuel addiction.
- Sunrise Powerlink -- Project to oppose the installation of the Sunrise Powerlink
Local Politics -- East County Politics that is not covered by another project
Private Mercenaries -- Considers the rise of private mercenary firms and warfare training camps.
- Blackwater Otay -- Opposition to private mercenary training center in Otay Mesa, San Diego
- Blackwater Worldwide -- Considers the entire family of companies related to Erik Prince, the founder of Blackwater Lodge Training Center.
- Covert Canyon -- A shooting range training area in East San Diego County, off Japatul Valley Rd and operated by Marc Halcon.
- Procinctu Group -- Opposition to development of "The Ranch", a mercenary training center in Riverside County
- Wind Zero -- Mercenary-style trainging camp just east of San Diego County in Ocotillo/Nomirage.

Amazon Smile affiliate image:

I	Attachment	Action	Size	Date	Who	Comment
JPG	AmazonSmile.JPG	manage	28 K	27 Sep 2018 - 21:13	Raymond Lutz	Amazon Smile affiliate image

Topic revision: r27 - 31 Jan 2023, RaymondLutz

Main

Volunteer Sign Up
About Us

Your Copswiki Acct

Webs
Common
Cops

Copyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Cops? Send feedback