PDA

View Full Version : Link to db from guild website.


Derzhus
11-13-2008, 11:46 PM
Will we be able to link items from db from our guild website? It would be nice to have the item listed and be able to hover mouse over it and have it displayed without having to do the click on link redirect to db thing.

YGAdmin
11-14-2008, 01:42 AM
Yep, that will be added shortly. We are working right now on fixing the filter section and adding rarity into our name sorting as well as a few other bugs.

Tarka
11-20-2008, 05:29 PM
Excellent to hear this. I am using our own tooltip screenshots on my guilds website, but it would be really nice to be confident in linking to an external one again such as YG.

Keep up the good work guys.

YGAdmin
11-21-2008, 08:26 PM
We just got the beta of this in the new release. There is a new link on each item details page allowing you to link specific items on your external websites.

Let us know if you run into any issues.

Tarka
11-30-2008, 12:13 AM
Hi, just thought I'd give some feedback on linking to your pages.

I've tried the details given on linking to an item. I entered the details onto our guildportal site, but for some reason the mouseover isn't working, but you can click on the link and it WILL switch to the correct yg.com page for the item.

This is the coding which I entered:

<script type="text/javascript" src="http://aoc.yg.com/extern/tooltip.js"></script>
<a href="http://aoc.yg.com/item/Blacksulphur-Robe/973735"
onmouseover="ShowToolTip(event, 'http://aoc.yg.com/etooltip/Blacksulphur-Robe/023f43f7fd598a36aa2ad8d63fe475747')">Blacksulphur Robe</a>

There doesn't appear to be any script errors when refreshing the page. And IE7 seems to be trying to do something when you mouseover the link. But no tooltip appears.

It can't a problem specific to Guildportal sites as I created a new text document on my desktop, pasted the coding in, changed the extension to html, and then viewed it in IE7. Still no tooltip appears.

Mozilla Firefox doesn't do it either (an icon appears on the cursor which looks like a piece of paper with a squiggle on it, I dont use Firefox normally so I'm unsure what this means).

YGAdmin
11-30-2008, 12:23 AM
Hey Tarka,

This appears to be a bug with our link gen code for English only. A temporary workaround for this is to add a /0 to the end of the numerical portion of the link (023f43f7fd598a36aa2ad8d63fe475747 in this case)

Example using your item would be (workaround is in bold):

<script type="text/javascript" src="http://aoc.yg.com/extern/tooltip.js"></script>
<a href="http://aoc.yg.com/item/Blacksulphur-Robe/973735"
onmouseover="ShowToolTip(event, 'http://aoc.yg.com/etooltip/Blacksulphur-Robe/023f43f7fd598a36aa2ad8d63fe475747/0')">Blacksulphur Robe</a>

Edit: This fixed the linking issue and will work in Firefox 3 but IE7 seems to have an additional script bug that I will have to take a look at. Please let me know if you have similar results.

Tarka
11-30-2008, 01:01 AM
Just tried it out and yes it works in Mozilla but not in IE7. I was looking at the difference between the image link on the yg page and the tooltip link and was wondering about that /0 bit.

I don't know javascript (yet), but I'm glad to see that I was on the right track for a "work around". ;)

Keep up the good work, I look forward to seeing this little beauty working.

Tarka
01-07-2009, 11:46 AM
Hiya, I'm still finding that the tooltips aren't showing when you mouse over a link, even with the /0 in it. Obviously, this only happens with IE7, Mozilla works fine.

Just thought I'd let you know.

YGAdmin
01-07-2009, 07:26 PM
At some point this was fixed but it does appear to be broken again in IE. I will look into the issue and try and get a hotfix out today. Thanks for reporting it.

Mordread
01-11-2009, 04:54 PM
Hi,

I was just wondering if there was any new news on this issue? I'm also an admin on our guild website and am very interested in seeing this work. :)

Cannibal
01-12-2009, 03:38 PM
Hi, I know my guild would also be very interested in this as well, currently we use aoc.mmodb.com, but there DB pales compared to yours, Since our guild website runs best In IE it would be great to have this feature working.

YGAdmin
01-13-2009, 04:22 PM
Hey guys, we've found one cause of this issue in IE and are working on a fix right now. In the meantime can you guys post some live examples of this not working and what steps you took to add the links to your site? Also can you describe what happens? We've seen odd behavior where the hover-over works a few times and stops for a while.

Thanks in advance.

Edit: After some further testing the fix we are working on fixes another issue and is most likely not related to the problems being experienced. Once we get the additional information and see some examples of it we should be able to find the cause. In the additional information please put what version of IE you are using. This can be found in the menu Help > About Internet Explorer.

Tarka
01-13-2009, 09:59 PM
Hiya, I've created a test page specifically for links to YG.com on our guild website:

http://inner-sanctum.guildportal.com/Guild.aspx?GuildID=292190&TabID=2491160

It would appear that the tooltip style links ARE now working. However, you're database doesn't yet have the Blacksulphur Armbands (shoulders) yet ;)

Firstly I placed the javascript line into the bottom window pane (which I am doing on each of the website pages just in case we want to link to your items).
Then all I did was copy the link for the item and pasted it directly into the table.

Anyhoo, good work guys :)

YGAdmin
01-14-2009, 12:50 AM
I'm glad to see they are working now. If anyone else can post some live test versions of the links we'll do more tests on them all to see if we can find any issues with it.

Mordread
01-14-2009, 07:22 AM
Ok, so what I've just learned is that there's a whole lot more to making this work than I am capable of doing. LOL

I have no problem admitting that I'm a noob when it comes to administrating a website. Our guild lost our website guru sometime ago and a few of us have been doing the best we can till we can find a replacment.

All I've been doing as a matter of "testing" is copying the text in the "Link to" window and pasting it in a "test post". But when I "preview" the post all I get is:

<script></script>
<a>Gida of the Ecliptic</a>

After seeing it work on Tarka's website it's obvious that the problem is me. Am I missing a step?

BTW,
Tarka I think your website is totally awesome!!

jimango
01-14-2009, 11:52 AM
Hey, im also quite new to this, can someone pls make a howto make this work at my phpbb3 forum..

And is it possible to download the DB or will the loading time not be an issue?

kind regards jimango

Tarka
01-14-2009, 04:48 PM
The process is pretty simple.
Basically guys you need two bits on whatever website you want to show the tooltips.
BOTH pieces of information are provided by yg.com when you click the "Link Item" option in the top right corner of any item page that you view on the database.

For instance, click the following link: http://aoc.yg.com/item/Blacksulphur-Robe/973735
You'll notice that by clicking the "Link Item" option that is in the top right quarter of that page, you get the following instructions appear:

Please add the following lines to your html document:

1. <script type="text/javascript" src="http://aoc.yg.com/extern/tooltip.js"></script>
2. <a href="http://aoc.yg.com/item/Blacksulphur-Robe/973735"
onmouseover="ShowToolTip(event, 'http://aoc.yg.com/etooltip/Blacksulphur-Robe/023f43f7fd598a36aa2ad8d63fe475747/0')">Blacksulphur Robe</a>

wherever you want to link to this item.

HOW TO LINK TO AN ITEM ON THE YG.COM SITE

So, you do the following:

1) Copy the first bit of code shown on the instructions, and paste it into the html code on your webpage. This is what forces your site to link to the yg.com database:

<script type="text/javascript" src="http://aoc.yg.com/extern/tooltip.js"></script>

NOTE:
This can be ANYWHERE on the page that you want to link to yg.com's database on.
It is the same code used for ANY item that you want to link to.

2) Next you copy and paste the item specific code that is on the instructions, directly into the html coding of your page where you want the hyperlink to appear:

Example:

<a href="http://aoc.yg.com/item/Blacksulphur-Robe/973735"
onmouseover="ShowToolTip(event, 'http://aoc.yg.com/etooltip/Blacksulphur-Robe/023f43f7fd598a36aa2ad8d63fe475747/0')">Blacksulphur Robe</a>

3) Save and refresh your page, and you're done!

Hopefully when you put your cursor over the hyperlink for the item, a tooltip should now appear.

YGAdmin
01-14-2009, 06:00 PM
Awesome guide Tarka!

<script type="text/javascript" src="http://aoc.yg.com/extern/tooltip.js"></script>To clarify what Tarka mentioned about the script line seen above; It only needs to be added to the page once to allow any link to have the tool-tip functionality.

Hey, im also quite new to this, can someone pls make a howto make this work at my phpbb3 forum..

And is it possible to download the DB or will the loading time not be an issue?

One issue that may occur with forums specifically is that by default most do not allow users to post straight HTML code for security reasons. Many boards do not even allow the option to turn this feature on. This limits the ability to allow general users to simply copy and paste the script into a post. I'm sure there is a way to get it to work but I'm guessing it would require some editing of the forum templates/scripts.

As for downloading the whole DB that is not currently possible. The benefit of having us host the tool-tips and script is that it takes the load and bandwidth costs away from our users. We are also working on a new system that will cut the size for most tool-tips in half resulting in faster tool-tip load times.

Tarka
01-14-2009, 09:32 PM
Awesome guide Tarka!

To clarify what Tarka mentioned about the script line seen above; It only needs to be added to the page once to allow any link to have the tool-tip functionality.

One issue that may occur with forums specifically is that by default most do not allow users to post straight HTML code for security reasons. Many boards do not even allow the option to turn this feature on. This limits the ability to allow general users to simply copy and paste the script into a post. I'm sure there is a way to get it to work but I'm guessing it would require some editing of the forum templates/scripts.

As for downloading the whole DB that is not currently possible. The benefit of having us host the tool-tips and script is that it takes the load and bandwidth costs away from our users. We are also working on a new system that will cut the size for most tool-tips in half resulting in faster tool-tip load times.

Cheers admin :)

Just a note: Guildportal websites have a built in "wysiwyg" editor which allows you access to the html coding both on the guild website forums (as well as obviously for any pages that you create for the website).

Just like ygadmin stated, the line for the javascript only has to exist once on the webpage.
Therefore, if your guildportal website admin guy/girl creates a "content box" which is placed at the bottom of the forum page,
then this box will show on ALL forum pages automatically when they are viewed.

So, if he/she then pastes the javascript line (section 1 of the instructions) into the html editor for that content box, the the links should work fine.
The line that needs to be pasted into the html code is:

<script type="text/javascript" src="http://aoc.yg.com/extern/tooltip.js"></script>

Visit my site (link in my sig) and notice the content box labelled "Extra Coding" on the forum page, this contains the coding for the javascript link.


And so, if you're trying to link these items on a forum created on Guildportal hosted site, then do the following:

1) Edit your post in the normal way.
2) You'll see an "<>" button at the bottom of the edit window. This is the button which switches to html code viewing.
3a) If your Guild website admin hasn't ALREADY embedded the link to the javascript into the website page/forum then copy the quoted line above and paste it into the html coding of your post.
3b) Now do the same with the item specific code (section 2 of the item linking details) but this time paste it into the position where you want the item link to appear.
4) Save your post. And if all is well, then clicking the link should take you directly to the item page on yg.com AND when you put your cursor over it, you should see the tooltip.

Of course, this means that you need to know a tiny bit of html to understand where your placing the link.

HOWEVER, if you're unsure or you're not that bothered about showing the tooltip, just create a standard hyperlink (on guildportal you click the button that has a globe+chain) and paste the item webpage address straight in. The hyperlink editing GUI will even allow you to state whether you want it to open on the same page or a new one. So, no need to learn any html ;)

jimango
01-15-2009, 09:02 AM
Thanks..

What i now did to make this work was to make an custom BBcode in phpBB3 ;)

This way i could add the custom html-replacement :)

This acctualy works now when i roll my mouse over =D

I did this as the new bbcode:
{TEXT1}

And this as the html-replacement:
<script type="text/javascript" src="http://aoc.yg.com/extern/tooltip.js"></script>
<a href="http://aoc.yg.com/item/{TEXT1}"
onmouseover="ShowToolTip(event, 'http://aoc.yg.com/etooltip/{TEXT2}')">{TEXT1}</a>

The things any member need to do now is:
Girdle of Vernant Fury

this will add and mouseover image for the Girdle of Vernant Fury.
The number of the item will have to be copied from the imagelink found at the items location at aoc.yg.com


The only thing i now have to do is make the link work to ur site ;)
But i have not time to find out now, will update post when i do.
Or if u want to enlighten me, feel free =D

the thing is that i want only the name of the item showing, not the "/somekindofnumber" after name. =D

jimango

Mordread
01-15-2009, 05:07 PM
I just wanted to say thanks to ygadmin and Tarka. I was finally able to make it work. Like a noob I kept thinking it was enough simply to post the "link to" info into a post and it would work. Duh! :o

Turns out I had to actually create a new page in our forum and place the code there. When I did it worked great.

Now all I need to do is learn HTML so I can actually creat a nice looking page like Tarka's rather than just a blank page with item links on it...............yeah no biggie huh? LOL

Anyway, I least I know it works. Maybe someday I'll learn html, who knows.

Thanks again guys!! :)

Funkadelic
01-16-2009, 12:15 AM
Anyway, I least I know it works. Maybe someday I'll learn html, who knows.
GuildPortal is pretty HTML friendly especially when editing their template system, with that said it is always a good day to learn something new!

Here is a good HTML cheet sheet for you to play with in your quest for knowledge.. http://psacake.com/web/dy.asp

If only the SHC forums allowed html code :rolleyes:


I suppose there is no way you guys could get this feature to work in a BBC format?

YGAdmin
01-16-2009, 03:27 AM
I suppose there is no way you guys could get this feature to work in a BBC format?

Jimango started to do this. His post is the last one on page 2 for reference. If we can get a working forum alteration/script for some of the popular forums that is easy for admins to add then we'll generate a BBC version of the link in the pop-ups so it is easier for users to just copy/past in. We can also put a sticky with a how-to for admins to make the changes to their forums.

jimango
01-16-2009, 06:54 AM
I updated my previous post with, what to do as a normal member to get the link in a post :)

jim

Tarka
01-19-2009, 02:05 AM
You're welcome Mordread :)

Now...if only I could work out how to enable BBcode on our guildportal site forums, I'll be able to help.

There's no tag button on the editor at all :(

Time to ask the GP community......

In the words of Arnie..."I'll be baaack".

Funkadelic
01-19-2009, 07:43 AM
Unless they have added the code to support it since the last time I ran a site through them, there isn't a way you can enable BBC on the GP user forums.

Not to say that you shouldn't suggest it to Aaron and his crew though! Heh GP that brings back some memories..

Tarka
01-19-2009, 03:13 PM
Yeah I noticed, I'm trying to get a response on the GP community forums about it.

In the meantime, I must ask, what exactly IS the long number on the end of the tooltip links anyhow?
I mean, it looks like the tooltips are segragated from each other by the item name anyhow.

YGAdmin
01-19-2009, 09:36 PM
The number has many purposes but primarily is a hash code used to designate between items that have the same name but different levels.

Last week we redesigned the entire system to avoid huge links for the tool-tips and we're going to be implementing the system changes to help with performance, ease of use, and general better database design over the next month or so.

Tarka
01-20-2009, 12:06 AM
The number has many purposes but primarily is a hash code used to designate between items that have the same name but different levels.

Last week we redesigned the entire system to avoid huge links for the tool-tips and we're going to be implementing the system changes to help with performance, ease of use, and general better database design over the next month or so.

Excellent to hear :) I look forward to these changes. This will DEFINATELY help with linking items.

So, does this mean that the process of linking to the database maybe streamlined enough for non-admins to use as well (e.g. in html based forums)?

YGAdmin
01-21-2009, 04:41 PM
Excellent to hear :) I look forward to these changes. This will DEFINATELY help with linking items.

So, does this mean that the process of linking to the database maybe streamlined enough for non-admins to use as well (e.g. in html based forums)?

I think that is really dependent on the forum. In all cases you'll need to add in a javascript link to our hover-over code to bring up the items.

Tarka
01-26-2009, 04:53 PM
I think that is really dependent on the forum. In all cases you'll need to add in a javascript link to our hover-over code to bring up the items.

I haven't got a problem with hiding a javascript link on the forum page template which will automatically used in conjunction with forum posts / hyperlinks.

I just hope that you guys can come up with a more "streamlined" solution for the average user who wants to post links in their forum posts.

Tarka
01-27-2009, 02:18 PM
Back on the subject of linking to your database:

I've created links on the IS website on the following page:

http://inner-sanctum.guildportal.com/Guild.aspx?GuildID=292190&TabID=2508051

However, I'm noticing that the tooltips aren't appearing near the cursor, they are appearing near the top of the page (if you zoom out you can see the tooltips ARE appearing).

Is this caused by something that I'm doing? or is it hard coded into the javascript?

YGAdmin
01-27-2009, 02:51 PM
However, I'm noticing that the tooltips aren't appearing near the cursor, they are appearing near the top of the page (if you zoom out you can see the tooltips ARE appearing).

Is this caused by something that I'm doing? or is it hard coded into the javascript?

This looks to be a bug with how our tool-tip code works (or in this case doesn't) in IE. In Firefox we do not get this issue. We are looking into this now.

Tarka
01-27-2009, 05:04 PM
This looks to be a bug with how our tool-tip code works (or in this case doesn't) in IE. In Firefox we do not get this issue. We are looking into this now.

Cheers, it seems to mostly happen with pages that are scrollable.

YGAdmin
01-27-2009, 05:13 PM
Yup, the issue has been found and fixed. This will be live within the next few minutes. Thanks for letting us know.


Edit: You must do a full refresh (ctrl-F5), or clear your cache to update the javascript file.

Tarka
01-28-2009, 12:20 PM
That is MUCH better. Well done guys on the speedy resolution.

We'll have yg.com being THE number 1 database to link to yet ;)

YGAdmin
01-28-2009, 05:27 PM
w00t! That is what we like to hear!