Flag of England.gif
Open justice | Let us know if you have a tribunal decision you would like to publish (see Re A)
Email updates | CPD scheme

Online forum | Latest topic on forum: Notional section 37 -- tribunal referral at 6 months? | News

Contact

Magic Book: Difference between revisions

No edit summary
No edit summary
Line 8: Line 8:
{{#forminput:form=Contact|size=60|query string=namespace=Contact|autocomplete on namespace=Contact}}
{{#forminput:form=Contact|size=60|query string=namespace=Contact|autocomplete on namespace=Contact}}


==List==
<div class="row">
<div class="large-6 columns">
{{#cargo_query:
tables=Contact
|fields= _pageName=Name,Type,Address,Coordinates
|format=googlemaps
|width=100%
}}
 
</div>
<div class="large-6 columns">
{{#cargo_query:
tables=Contact
|fields= CONCAT("[[",_pageName,"|",_pageTitle,"]]")=Name,CONCAT("<span class='plainlinks'>[http://www.mentalhealthlaw.co.uk/Special:Drilldown/Contact?Type=", REPLACE(Type," ","_"), " ", Type, "]</span>")=Type,Address
|format=dynamic table
}}
</div>
</div>
 
 
==View==
Click on a name to see further details - including maps and a link to find directions on Google.
Click on a name to see further details - including maps and a link to find directions on Google.
{{#cargo_query:
{{#cargo_query:
Line 15: Line 35:
|format=dynamic table
|format=dynamic table
}}
}}
==Search==
You can search using the table above, or for a more detailed search click here: [[Special:Drilldown/Contact]].


==Google Map==
==Google Map==
Line 28: Line 45:
|width=inherit
|width=inherit
}}
}}
==Search==
You can search using the table above, or for a more detailed search click here: [[Special:Drilldown/Contact]].


==Places with no coordinates saved==
==Places with no coordinates saved==

Revision as of 00:50, 18 December 2016

Magic tree icon.gif

This is all still in draft format. The Magic Book is named after an old database of hospitals, experts etc, which I used in a previous job.

Create or edit

(1) Hospitals/places: please add everything from your address book! The Magic Book will only be a success if everyone joins in. (2) People: add personal information (e.g. experts) with permission, unless publicly available already; no opinions; inclusion does not imply recommendation.

Type a place (e.g. hospital) or person (e.g. independent expert) name in the box below. If it exists already, it will be auto-completed for you: just click on the blue text to view/edit that page.


More...

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"]</span>"),`Address` LIMIT 100' at line 1

Function: CargoSQLQuery::run Query: SELECT `wm_cargo__Contact`.`_pageID` AS `cargo_backlink_page_id_Contact`,CONCAT("",_pageTitle,"") AS `Name`,CONCAT("<span class='plainlinks'>", REPLACE(Type," ","_"), " ", Type, "</span>") AS `Type`,`Address` AS `Address` FROM `wm_cargo__Contact` ORDER BY `wm_cargo__Contact`.`_pageID`,CONCAT("",_pageTitle,""),CONCAT("<span class='plainlinks'>", REPLACEContact.Type__full " ","_"), " ",`wm_cargo__Contact`.`Type__full` "</span>"),`Address` LIMIT 100


View

Click on a name to see further details - including maps and a link to find directions on Google.

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"]</span>"),`Address` LIMIT 100' at line 1

Function: CargoSQLQuery::run Query: SELECT `wm_cargo__Contact`.`_pageID` AS `cargo_backlink_page_id_Contact`,CONCAT("",_pageTitle,"") AS `Name`,CONCAT("<span class='plainlinks'>", REPLACE(Type," ","_"), " ", Type, "</span>") AS `Type`,`Address` AS `Address` FROM `wm_cargo__Contact` ORDER BY `wm_cargo__Contact`.`_pageID`,CONCAT("",_pageTitle,""),CONCAT("<span class='plainlinks'>", REPLACEContact.Type__full " ","_"), " ",`wm_cargo__Contact`.`Type__full` "</span>"),`Address` LIMIT 100

Google Map

This shows every place which has coordinates saved. Click on the red marker to see what it is, then click on the place name to view its details.

More...

Search

You can search using the table above, or for a more detailed search click here: Special:Drilldown/Contact.

Places with no coordinates saved

If you know where these places are, help by locating them on the map:

Retrieved from "https://www.mentalhealthlaw.co.uk/index.php?title=Contact:Magic_Book&oldid=31291"