[whodah]

OK - so for Google charts, we are a bit stuck because ideally we would have 4 {param}'s available. As it stands now, we have two:
{param}
{option}

So I've set option = google charts "oid", and param = google charts chart number. I've hard coded the width to 800 and height to 600, and let users know they need to size their published charts to this size. Shy of installing a mod allowing multiple {param}'s, this is where we are. But it works well.


Title: Google Chart
BB Code Tag Name: BB Code Tag Name
Replacement:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Example:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Description:

Embed a Google Spreadsheet Chart. The chart will render at 800x600, so be sure to size your chart accordingly at Google Docs/Drive/Charts. This one is a bit tricky to use... The 'oid' of the link needs to be the option (i.e. [gc=oid_number]) and the chart number the parameter. It is just the way google charts does it.

Use {option}: yes
Button Image (Optional): -- create an image if you desire --
Remove Tag If Empty: yes
All other Disable options: yes

Feel free to clean it up more, but that gets it going at least.

[klaush]

Thanks; this made my day!

Originally Posted by kylek

Just surfing on google and found this: https://support.google.com/drive/answer/3541068

"Starting in March and April 2014, Google Sheets users creating new spreadsheets will be automatically directed to the new Sheets. All previously created spreadsheets will remain in the older version of Sheets for now. If you need to create a spreadsheet using the old Sheets, you can do so at g.co/oldsheets"

[Pittski]

Hmm, I tried messing around with it but can't seem to get it to work. The new spreadsheet link that is.

Anyone else get it working?

Key= has been replaced with /d/ now


Edit: I think I fixed it. Not positive. But here is the new code.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

I replaced the /Key= part with /d/{param}/edit#gid=0 in both html lines, and it worked for me.

Edit 2:when it loads the spreadsheet it sends you to the top of the page. also if you click in the spreadsheet after clicking out of it, it will send you to top of the page. No idea how to stop that.

[Grimholtt]

Can anyone assist with this? After the changes were made by Google, I use the /d/ now and it loads the spreadsheet just fine, but now instead of just the cells appearing, I get the entire Spreadsheet including the Tools at the top.

For example:

I'm looking to see just this:



What I'm actually seeing:



Any way to clean this up that anyone knows about?

[kylek]

Does the same for me shows everything, guess will stick to using the iframe code they give for the embed share link.

[willie53]

Ok tried for about 3 weeks to get google spreadsheets working on vb 5.2.6 then on vb 5.3.0 alpha as it is something i really needed the way i was getting them to display the sheet was to embed it with iframe and to do this i had to enable html which is not a good idea so it was left to me do update the sheets.
I finally got it working the solution was staring me in the face i got the google docs working no problem but the spreadsheet would not so i compared the 2 sets of replacement code the spreadsheet code used single qoute ' instead of double qoute " so this is the amended code i am using now and works a treat

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Many thanks for this.
Regards Willie

[willie53]

Here is a quick and easy way to install these bbcodes it can be done in admincp or in phpmyadmin simply run the sql query below i have tested this method on all versions of vbulletin from vb3.6.8 through 5.3.0 and it works on all versions though you may need to edit 1 word depending if you set a prefix for db tables the simply put the prefix in front of bbcode example is vbbbcode

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[BirdOPrey5]

Originally Posted by willie53

Here is a quick and easy way to install these bbcodes it can be done in admincp or in phpmyadmin simply run the sql query below i have tested this method on all versions of vbulletin from vb3.6.8 through 5.3.0 and it works on all versions though you may need to edit 1 word depending if you set a prefix for db tables the simply put the prefix in front of bbcode example is vbbbcode

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

VB 5.x doesn't have a plugin system to which this code would be compatible, FYI.

[willie53]

Originally Posted by BirdOPrey5

VB 5.x doesn't have a plugin system to which this code would be compatible, FYI.

It is actually running on my main site which can be seen @ this post https://cometbar.co.uk/forum/darts/4...pionship-stats

also have it installed on various versions of vb

[BirdOPrey5]

My bad I thought you were supplying plugin code. Your code makes direct alterations to the BBCode table. Guess I should have looked closer.

I would still advise caution, there are reasons manual edits to database tables are last resorts. People shouldn't get in the habit of inserting BB Codes via direct queries. One mistake/typo and you can screw up your site.

[willie53]

I do agree there if you are not comfortable altering the database then leave it alone this is why i always use one of my my testing sites on my laptop before i put anything on my live site also i backup the database beforehand.

[IggyP]

Originally Posted by Grimholtt

Can anyone assist with this? After the changes were made by Google, I use the /d/ now and it loads the spreadsheet just fine, but now instead of just the cells appearing, I get the entire Spreadsheet including the Tools at the top.

For example:

I'm looking to see just this:



What I'm actually seeing:



Any way to clean this up that anyone knows about?

i am curious of this too....the extra header can be a security concern would be nice to hide it....also it now added a chat as well, which we dont really want....i tried hiding them by css, even tho its loading the main sheet from google, but fail...not sure what else to even try...

also have got errors loading spreadsheets like this:

GET filesystem:htt ps://docs.google.c om/persistent/docs/fonts/cCwcoZCh95jEfkePtzfl9_k_vArhqVIZ0nv9q090hN8.woff2 net::ERR_FILE_NOT_FOUND

Refused to display 'htt ps://docs.google.c om/sharing/init?id=14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAnfM&foreignService=ritz&gaiaSer vice=wise&shareService=ritz&subapp=10&popupWindowsEnabled=true&shareUiType=defau lt&hl=en&authuser=0&rand=1504167017294' in a frame because it set 'X-Frame-Options' to 'sameorigin'.

GET ht tps://docs.google.c om/sharing/init?id=14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAnfM&foreignService=ritz&gaiaSer vice=wise&shareService=ritz&subapp=10&popupWindowsEnabled=true&shareUiType=defau lt&hl=en&authuser=0&rand=1504167017294[/url] net::ERR_BLOCKED_BY_RESPONSE

be nice to clean it up and secure it a little better but seems to basically work..vb4.2.5 php 5.6


oh and btw, that is result by using this replacement code which is the one that seemed to work for me

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[[email protected]]

Add

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

to your bbcode remove the toolbars.

Eg:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[IggyP]

Originally Posted by [email protected]

Add

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

to your bbcode remove the toolbars.

Eg:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

that works perfectly thank you....i tried the same however for the google docs and didnt seem to work..is it slightly different there? i know that first part at least is the same with the updated "htt ps://docs.google.co m/document/d/{param}" format but the after part i tried matching your ss code then a few other ways and still failed..

[[email protected]]

Originally Posted by IggyP

that works perfectly thank you....i tried the same however for the google docs and didnt seem to work..is it slightly different there? i know that first part at least is the same with the updated "htt ps://docs.google.co m/document/d/{param}" format but the after part i tried matching your ss code then a few other ways and still failed..

Try this for a Google Doc.

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.