Extra Features on Forums

[Acaos]

I've added a Google Search box for the forums, which you can find at the lower right of the main page.

Acaos

[Acaos]

You can now embed a google spreadsheet by placing the key between 'gsheet' tags, like this:

[gsheet ]pkPtUjd4yKNyECL1UOopNbQ[ /gsheet]

The above is from the URL:

spreadsheets.google.com/pub?key=pkPtUjd4yKNyECL1UOopNbQ&output=html

Which is the HG Conceal/Listen Chart.

Acaos

[dodrudon]

Awesome!

Was this feature provided by the forum provider or a third party plugin, or did one of you code it up?

[niarte1]

this is fantastic........

[mrbadexample]

Was this something you had to add to the Forums Header/Footer Code to make work Acaos?

if so any chance you'll publish it?

[nataani]

Would love to know how this was done so we can do the same on the DT boards

[jonuhey]

This dont seem to work in IE7, where I am atm, nor in my Firefox "3.something" at home. And yes, I removed the spaces...

[jonuhey]

I went to see if Funky's post was working (when it didnt work at home) and it did work now And I finally saw how cool is that feature ;D

The post Im talking about is this one: highergroundpoa.proboards.com/index.cgi?board=faqs&action=display&thread=15159&page=1#142936

Gotta check at home later and I'll post wheter its working or not.

[Acaos]

Aug 4, 2009 16:40:25 GMT nataani said:

Would love to know how this was done so we can do the same on the DT boards

This was added to the board global footer:

<script type="text/javascript"><!--
if (location.href.match(/action=(display|recent)/i)) {
 var aTD = document.getElementsByTagName("TD");
 for (a=0; a < aTD.length; a++) {
   if (aTD[a].colSpan == 3 &&
       aTD[a].vAlign == "top" &&
       aTD[a].firstChild.nodeName.toLowerCase() == "hr" &&
       aTD[a].innerHTML.match(/\[gsheet\]([-A-Za-z0-9]+?)\[\/gsheet\]/gi)) {
         aTD[a].innerHTML = aTD[a].innerHTML.replace(/\[gsheet\]([-A-Za-z0-9]+?)\[\/gsheet\]/gi, "<blockquote><iframe width='600' height='400' frameborder='0' src='http://spreadsheets.google.com/pub?key=$1&output=html&widget=true'></iframe></blockquote>");
   }
 }
 var aFONT = document.getElementsByTagName("FONT");
 for (a = 0; a < aFONT.length; a++) {
   if (aFONT[a].className == "code") {
     aFONT[a].innerHTML = aFONT[a].innerHTML.replace(/ /g, " ");
   }
 }
} else if (document.postForm) {
 if (location.href.match(/quote=/i)) {
   var m = document.postForm.message;
   m.value = m.value.replace(/\[gsheet\][-A-Za-z0-9]+?\[\/gsheet\]/gi,"");
 }
}
// -->
</script>

Acaos

[Acaos]

I've added category collapse to the main page to make it a bit less cluttered.

Acaos

[MightyKhan]

why am I missing the "like" button? must be spending too much time on facebook, hrm ..

[jchamlin]

Made a slight tweak to this to allow the user to specify the height and width on the gsheet tag. Hope you like it:


<script type="text/javascript"><!--
if (location.href.match(/action=(display|recent)/i)) {
 var aTD = document.getElementsByTagName("TD");
 var exp1 = /\[gsheet\]([-A-Za-z0-9]+?)\[\/gsheet\]/gi;
 var exp2 = /\[gsheet width=([0-9]+)\]([-A-Za-z0-9]+?)\[\/gsheet\]/gi;
 var exp3 = /\[gsheet height=([0-9]+)\]([-A-Za-z0-9]+?)\[\/gsheet\]/gi;
 var exp4 = /\[gsheet width=([0-9]+) height=([0-9]+)\]([-A-Za-z0-9]+?)\[\/gsheet\]/gi;
 for (a=0; a < aTD.length; a++) {
   if (aTD[a].colSpan == 3 && aTD[a].vAlign == "top" && aTD[a].firstChild.nodeName.toLowerCase() == "hr") {
    if (aTD[a].innerHTML.match(exp1))
         aTD[a].innerHTML = aTD[a].innerHTML.replace(exp1, "<blockquote><iframe width='635' height='400' frameborder='0' src='http://spreadsheets.google.com/pub?key=$1&output=html&widget=true'></iframe></blockquote>");
    else if (aTD[a].innerHTML.match(exp2))
         aTD[a].innerHTML = aTD[a].innerHTML.replace(exp2, "<blockquote><iframe width='$1' height='400' frameborder='0' src='http://spreadsheets.google.com/pub?key=$2&output=html&widget=true'></iframe></blockquote>");
    else if (aTD[a].innerHTML.match(exp3))
         aTD[a].innerHTML = aTD[a].innerHTML.replace(exp3, "<blockquote><iframe width='635' height='$1' frameborder='0' src='http://spreadsheets.google.com/pub?key=$2&output=html&widget=true'></iframe></blockquote>");
    else if (aTD[a].innerHTML.match(exp4))
         aTD[a].innerHTML = aTD[a].innerHTML.replace(exp4, "<blockquote><iframe width='$1' height='$2' frameborder='0' src='http://spreadsheets.google.com/pub?key=$3&output=html&widget=true'></iframe></blockquote>");
   }
 }
 var aFONT = document.getElementsByTagName("FONT");
 for (a = 0; a < aFONT.length; a++) {
   if (aFONT[a].className == "code") {
     aFONT[a].innerHTML = aFONT[a].innerHTML.replace(/ /g, " ");
   }
 }
} else if (document.postForm) {
 if (location.href.match(/quote=/i)) {
   var m = document.postForm.message;
   m.value = m.value.replace(/\[gsheet[^\]]*\][-A-Za-z0-9]+?\[\/gsheet\]/gi,"");
 }
}
// -->
</script>


[Acaos]

Thanks for the contribution! I'll get it put in.

Please be aware that we did select the default size to display on 95% of browsers, so making it larger may mean people without high-resolution displays will have to scroll horizontally to see your sheets.

Acaos