Topic: Who knows how to do google docs?  (Read 2800 times)

0 Members and 1 Guest are viewing this topic.

Offline manitoba1073

  • FLEET ADMIRAL OF THE YARDS
  • Lt. Commander
  • *
  • Posts: 1119
  • Gender: Male
    • manitobashipyards
Who knows how to do google docs?
« on: July 21, 2010, 09:45:57 am »
I got this far on my Google docs.

http://pwibelial.freeforums.org/post3.html#p3

 Now I need to know how to get it to show in the post instead of redirecting to a seperate page.

Then be able to have it show up the results in another section in forums.
 
 Then another one that allows officers to vote with name , yes or no ,  and comments

 and have that show up with results also.

 Any ideas from anyone?
« Last Edit: July 22, 2010, 12:25:30 pm by manitoba1073 »



Offline Age

  • D.Net VIP
  • Commander
  • *
  • Posts: 2690
  • Gender: Male
Re: Who knows how to do google docs?
« Reply #1 on: July 23, 2010, 12:26:12 pm »
I imagine this  is your Perfect World International Faction.I see though that Blue colour Facton is owning the map on Heavens Tears.It is what Nefarious being red was owning of  Sanctuary.

Offline manitoba1073

  • FLEET ADMIRAL OF THE YARDS
  • Lt. Commander
  • *
  • Posts: 1119
  • Gender: Male
    • manitobashipyards
Re: Who knows how to do google docs?
« Reply #2 on: July 26, 2010, 12:35:09 pm »
Yea age thats what its for.  Noone knows how to get it done like that here?



Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: Who knows how to do google docs?
« Reply #3 on: July 27, 2010, 01:47:44 am »
Here, an admin can embed a google document in a post like so:

Code: [Select]
[html]<iframe width='900' height='600' frameborder='0' src='http://spreadsheets.google.com/pub?key=tBcMvTkSxqM62s6ncAKpuOw&output=html&widget=true'></iframe>[/html]
as in this post: http://www.dynaverse.net/forum/index.php/topic,163389409.0.html

Something similar should apply to your free phpbb forum. Just check the settings for which membergroups can post html in bbc code tags, if any.

Offline manitoba1073

  • FLEET ADMIRAL OF THE YARDS
  • Lt. Commander
  • *
  • Posts: 1119
  • Gender: Male
    • manitobashipyards
Re: Who knows how to do google docs?
« Reply #4 on: July 27, 2010, 02:40:05 am »
ok i tried your code, just showed up as text. yes i replaced ur google doc link with mine lol  yea im an admin there so i have full permissions for everything since i made the forums. ty so far.



Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: Who knows how to do google docs?
« Reply #5 on: July 27, 2010, 03:15:30 am »
Ah, I see, no html bbc code tags for admin in phpbb like in smf... so my reccomendation (if running phpbb3) would be to create a custom bb code tag:
http://www.phpbb.com/support/documentation/3.0/adminguide/acp_posting.php#acp_posting_bbcodes

something like :

[gdoc]#docurl#[/gdoc]

to the desired output html...

Offline manitoba1073

  • FLEET ADMIRAL OF THE YARDS
  • Lt. Commander
  • *
  • Posts: 1119
  • Gender: Male
    • manitobashipyards
Re: Who knows how to do google docs?
« Reply #6 on: July 27, 2010, 03:59:00 pm »
um say what, lol english man english.


 ill look into but its sorta gibberish at the moment from first glance.  ty so far though.



Offline manitoba1073

  • FLEET ADMIRAL OF THE YARDS
  • Lt. Commander
  • *
  • Posts: 1119
  • Gender: Male
    • manitobashipyards
Re: Who knows how to do google docs?
« Reply #7 on: July 27, 2010, 04:50:26 pm »


 I got this far. lol If I understand what you said I put that in the top like I did, but how would I do it for the middle section.



Offline manitoba1073

  • FLEET ADMIRAL OF THE YARDS
  • Lt. Commander
  • *
  • Posts: 1119
  • Gender: Male
    • manitobashipyards
Re: Who knows how to do google docs?
« Reply #8 on: July 27, 2010, 05:44:29 pm »
got it i think. hehe


 http://pwibelial.freeforums.org/apply-here-t3.html


 tell me how it looks.



Offline Age

  • D.Net VIP
  • Commander
  • *
  • Posts: 2690
  • Gender: Male
Re: Who knows how to do google docs?
« Reply #9 on: July 27, 2010, 06:12:32 pm »
Vic would be great at helping you with this if you take our boards of Star Trek Gamers.

Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: Who knows how to do google docs?
« Reply #10 on: July 29, 2010, 05:01:33 pm »
got it i think. hehe


 http://pwibelial.freeforums.org/apply-here-t3.html


 tell me how it looks.


Coolio! Nice job man. Good work on figuring it out the rest of the way. (maybe post the codes here that you entered in the phpbb3 admin interface to generate hits here on our forums? ;) - when people search google for similar solutions... )

I did not test it for functionality, assuming you have. Anyway, good job. I like it. Creative use - I hadn't thought of (I'd have done that right in php/mysql) but this is a good everyman's solution to this kind of thing.

Well done Manitoba.  :thumbsup:

edit: one suggestion - you might want to make the iframe height a little bigger for this kind of application. Alternatively, I think there is a multi-step/page option for those google docs forms...? Or you could add the height and width as parameters to your new custom BB code too? (Assuming you are using phpbb3's custom Bb codes feature)  - just some thoughts/ suggestions for others doing the same.

Offline manitoba1073

  • FLEET ADMIRAL OF THE YARDS
  • Lt. Commander
  • *
  • Posts: 1119
  • Gender: Male
    • manitobashipyards
Re: Who knows how to do google docs?
« Reply #11 on: July 29, 2010, 05:32:49 pm »
ty. Im glad I got it to work. and heres how I wrote it, I kinda cheated used the Iframe parameters lol  :laugh:



and not sure how to post the actual codes here for it like you did, but ur more than welcome to lol

 But like I said I just kinda cheated lmao.



Offline Bonk

  • Commodore
  • *
  • Posts: 13298
  • You don't have to live like a refugee.
Re: Who knows how to do google docs?
« Reply #12 on: July 31, 2010, 01:46:18 am »
Cool... security advice...:

The way you have it written, any url can be used. OK so long as this BB code is only accessible to admins... but if you want users to be able to use the BB code to post their own google documents ... make it more restrictive (and accurate to the tag description) like so:

e.g.:
Code: [Select]
[gss={DWID},{DHGT}]{GDOCKEY}[/gss]
Code: [Select]
<iframe width='{DWID}' height='{DHGT}' frameborder='0' src='http://spreadsheets.google.com/pub?key={GDOCKEY}&output=html&widget=true'></iframe>
Or perhaps there is a more general url for google docs that will pick up the document type with just the document key... would only take a little test or two. As this example should only work for spreadsheets.


Offline manitoba1073

  • FLEET ADMIRAL OF THE YARDS
  • Lt. Commander
  • *
  • Posts: 1119
  • Gender: Male
    • manitobashipyards
Re: Who knows how to do google docs?
« Reply #13 on: August 01, 2010, 12:24:20 pm »
i only have it set for myself to know the codes really. and it dont show up for others when they post. like a hidden secret lol.

 Ok I tried setting your codes up, either I was doing it wrong or theres a problem with google docs.

this is my google doc

http://spreadsheets.google.com/pub?key=0AmfelSdzDPC2dGxLamFyYk1ISnpGZ1h5NnVuY1lxRlE&hl=en&output=html
« Last Edit: August 01, 2010, 01:55:03 pm by manitoba1073 »