These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Google Spreadsheet and the ingame javascript functions
Author
Previous Topic Next Topic
Influenca Pandemik
Anubis Logistics and Services
#1 - 2012-02-13 21:14:54 UTC
Hi,

is there any way to make the CCPEVE javascript functions work in google spreadsheets, while using the ingame browser?

Regards,
IP
Project 69
Aurora Coalition
Synergy of Support
#2 - 2012-02-14 11:26:14 UTC
Influenca Pandemik wrote:
Hi,

is there any way to make the CCPEVE javascript functions work in google spreadsheets, while using the ingame browser?

Regards,
IP


I highly doubt that.

don't know about online spreadshirts like google docs tho
Max Kolonko
Caldari Provisions
Caldari State
#3 - 2012-02-14 12:27:00 UTC  |  Edited by: Max Kolonko
i tried forcing the links to appear via hyperlink() function, but to no effect :(

it appears that it will not work, - but if someone will mange to get it working please post it here

Read and support: Don't mess with OUR WH's What is Your stance on WH stuff?
Max Kolonko
Caldari Provisions
Caldari State
#4 - 2012-02-14 12:32:01 UTC  |  Edited by: Max Kolonko
ok, this just hitted me as potential solution - will require some testing thou:

you make link in google docs, using hyperlink() function, something like this:

www.myphpserver.com/evejavafunctioncall.php?type=Showinfo&id=xyz

than in that file you parse the variables into javascript call made at "onload" in body part of page - this ofcourse require you to have your own php server/hosting service

i will test it to se if it will work, but probably not today - if someone is willing to test it themself - please post Your results

Read and support: Don't mess with OUR WH's What is Your stance on WH stuff?
Max Kolonko
Caldari Provisions
Caldari State
#5 - 2012-02-15 19:00:41 UTC
Ok, so tested it myself AND IT IS POSSIBLE to do it.

i've made php file with following code:



if($type=="showinfo")
{

echo "< html >< body onload=\"CCPEVE.showInfo(1377, $id)\" >";
echo "< /body >< /html >";
}


$type and $id is passed via link in google docs spreadsheet

once opened in IGB it will pop-up valid showinfo for character (in this example)

to actually have link available in google spreadsheet you have to either:
type link manualy with those parameters in URL (server.com/filename.php?type=showinfo&id=123435456)
or use HYPERLINK() function to make convinient links with different label and being able to create them dynamically.

in both cases you will get link in google spreadsheet - however to force it to open in IGB you have to open it in specific way - You have to actually middle click on linked part of cell to force it to open in new tab, otherwise you can left click all you want with no effect.

side effect of it is that you end up with open (and currently active) blank page tab. if someone find a way to force the tab to auto-close on opening please post it here (self.close() and window.close() is not working)

Read and support: Don't mess with OUR WH's What is Your stance on WH stuff?