Item Linking

[jeffrey]

Any chance we can link items from our web pages to wardb so the tooltips appear on mouseovers? Similar to Itemstats, etc..

[Kody]

Jeffrey, I'll look into the details for this ASAP and get back to you. I'm certain it will be possible for release, but I'm not positive if we have everything set up properly just yet. That's one of the reasons WHA was slow for a bit earlier -- we were testing out the syndication to make sure it worked properly, was bug-free, etc. :)

[jeffrey]

Right on, I imagine you don't want tons of guild sites hammering your DB so a script that builds a local cache would be ideal. You know, something where the item data gets retrieved from you once and gets cached to my DB.

Thanks for the quick reply. :cool:

[Regis]

Yup, it's something I look forward to very much

[Kody]

I spoke with our developer about this. We'll have a page up shortly explaining in more detail how to use the various tooltip syndication, but for now if you want to get started, you can include the following: http://www.wardb.com/js/extooltips.js

The javascript should take care of the rest and will convert links to items, quests, and spells to mouse-over tooltip links. :)

[jeffrey]

Hot!

I'll give it a whirl once I polish off these last few M&Ms.

[jeffrey]

Working, just need to get the CSS sorted so that it auto-formats the links based on item class. I viewed the source of some of these forums posts with items linked but could not find the import of the appropriate stylesheet anywhere in the code. I'll keep digging for now and await further details.

--

Update:
Okay, the CSS issue is solved. The only issue now is I have to manually input the URL whether via BBCode or plain HTML into the <a href="">

So I need to sort out a way to parse the item name and then find the URL automagically. A small hurdle for ease of use but a mountain in terms of scripting. :neutral:

[Shawnley]

Made a little site for this:

Link (http://tx-community.dk/waritems/waritems.php?)

Not that big yet, but it got potential :p

EDIT: Just delete this post if you dont want to many ppl to link to the WARDB database

[jeffrey]

Yeah, good examples Shawnley. That is where I am at too. Now we need something to parse item names and retrieve the appropriate URL. I can setup the BBCode but folks still have to provide a URL at this point instead of just tags and the item name.

[Shawnley]

Allready implantet itemID on my own forum.

But as you said above, this will take great traffic from WARDB.com

And yeah.. Got a problem with the item names aswell :p

[jeffrey]

Well my BBCode is like this:

{TEXT}

converts to

<a class="wardb-item-text" href="{URL}">{TEXT}</a>


But that requires users to enter the URL and the item name to display the formatted item link. Ideally I want to just have users placing item tags around the item name. But it would require parsing of the item name and a URL lookup for it to work.

[Shawnley]

I use followin PHP code:

$text = preg_replace("#\[\s*WarItem\s*\](.+?)\[\/WarItem\s*\]#is", "<a class='wardb-item-full-medium' href='http://www.wardb.com/item.aspx?id=\\1'>\\1</a>", $text);

So the name will be the itemID.. Not really optimal :P

[Shawnley]

You could use the code i posted above, and just add a second parameter so you'll get:

(text)

Then you dont need the full url, but only the ID :)

[Zyuu]

Looking good guys. As Kody said, a page which will explain the details should be up as soon as possible.

[Shawnley]

Looking good guys. As Kody said, a page which will explain the details should be up as soon as possible.

Thanks :)

Well, even though there is a site comming, its still fun with the challenge ;)

And who knows, i might come up with good solution in the end :D

EDIT: I now got a fair solution running on this site. (http://tx-community.dk/waritems/waritems.php?)

[Sanklovich]

btw, we already have a vbulletin plugin that does the item name to linking, like on WHA, once it's 100% bug free, we'll be letting other people use it

[Shawnley]

Ok great :)

iv got it implantet for phpBB forum now, plus in my comment system :p

[jeffrey]

Yeah, don't forget about PHPBB3. :cool:

[Shawnley]

Yeah, don't forget about PHPBB3. :cool:

Thats the one im using ;)

[Kody]

Great job on the page, Shawnley! And don't worry -- you're more than welcome to set this up on your website if you'd like. :)

[Shawnley]

Great job on the page, Shawnley! And don't worry -- you're more than welcome to set this up on your website if you'd like. :)

Thanks :)

Btw. working on a character sheet aswell :p
Will be up later i hope...

[Shawnley]

ok so no character sheet today.. tired of looking at those JavaScript codes.. :roll:

[badrobot]

btw, we already have a vbulletin plugin that does the item name to linking, like on WHA, once it's 100% bug free, we'll be letting other people use it


thanks ;) waiting

[gehmnal]

This thread caught my eye, and I hope it's ok that I've implemented it on my guild site as well.

Anyway, if anyone is interested in knowing how to get it working with item ID's in PHP Fusion, let me know and I'll be glad to assist. I've gotten it working on both the forums and news postings. Of course, it'll be much better with item caching... :)

[ika]

Hi peeps!

I got the linking to work on my phpbb3 forum, with help from Shawnley's guide.
Using the items id parsed, which is good enough for me :D

Using these codes:


--------------------------------------
BB Code

[~item]{TEXT} [/item]
remove the ~
--------------------------------------




--------------------------------------
HTML source

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class='wardb-item-full-medium' href='http://www.wardb.com/item.aspx?id={TEXT}'></a>
--------------------------------------



Example item
http://www.wardb.com/item.aspx?id=88915


Inserting its ID in this parser
[~item]88915[/item]
remove ~

Becomes this

88915 (http://www.wardb.com/item.aspx?id=88915)



Dunno if this is optimal, takes a few sec to load. Im happy with it though.
Don't get much of this really, I'm more a copy/paste kinda guy :rolleyes:

[Shawnley]

I got the linking to work on my phpbb3 forum, with help from Shawnley's guide.
Using the items id parsed, which is good enough for me :grin:

Always nice to know somebody think it was useful :grin:

And yeah, the best way to make BBcode i figured, is indeed to make it as you have, with the id. (And yes, it toke me like 5 hours to notice that your dont need a name in the link :roll:)

Though im still trying to make a link without the text, and only with the image. But it seems that everytime i change something in the JavaScript, its never the right thing i changed :p

oh, and if any figure out how to do this, please tell me.. it would make my day!

[gehmnal]

I'm in the process of taking a look at the old itemstats (WoW)for phpbb addon and trying to adapt it for this so that you can just input item names instead of the actual ID. So far no luck, but I wasn't putting in very much effort as I'm also at work right now and supposed to be doing other stuff. ;)

As I said above my site is PHP Fusion, but the general idea is pretty much the same for phpbb so anything I get working I'll share here.

[jeffrey]

--------------------------------------
HTML source

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class='wardb-item-full-medium' href='http://www.wardb.com/item.aspx?id={TEXT}'></a>
--------------------------------------

You can put the script reference into the header of your page and lose the need to have it appear in every instance of BBCode.

I'm in the process of taking a look at the old itemstats (WoW)for phpbb addon and trying to adapt it for this so that you can just input item names instead of the actual ID. So far no luck, but I wasn't putting in very much effort as I'm also at work right now and supposed to be doing other stuff.

I also looked into Itemstats as I have used it many times before but I had no luck trying to convert it. Hope you can read French! :shock:

Seriously though, keep us posted on this. Using simple item tags and the item name is what we're after instead of having to put in the URL or item ID.

I used the entire URL since it is easier to right click, copy link location than having to look and then remember the item ID. Plus I wanted the display text to be the item name. I posted my BBCode earlier in this thread. What we need is exactly what you are looking into. Simply using item tags around the item's name and having it parse and automatically convert them to item links.

[Shepx83]

First off I wanted to say I love the site and how everything is turning out so far and helping get more data for you guys.

Just wanted to ask if you guys would be making up a SMF 1.1.5 BBC code? I got common knowledge on website stuff, so nothing extensive to figure how to change it around for SMF.

Thanks, and understand if it would be a problem, just an addition id love to see after everything gets finalized, would implement it into my guild website. http://www.drakenrising.com (http://www.drakenrising.com/)

[ika]

You can put the script reference into the header of your page and lose the need to have it appear in every instance of BBCode.


Yeha id really like that, however im using a free of charge phpbb3 forum at freeforums.org.
Don't think I can :<
Or anyways I don't know where to ;) I've looked around the ACP section.

EDIT:
Also i cant seem to get spell linking to work. :confused:

[badrobot]

btw, we already have a vbulletin plugin that does the item name to linking, like on WHA, once it's 100% bug free, we'll be letting other people use it

any chance of having it right before open beta?

regards

[Genesis]

Hi guys,

I have it up and running on my phpbb3, thanks for your help here. Just a little Problem:

The "tooltips" are too small, the contet doesn't fit into them. It tried to overwrite the CCC-Style, or change it, but nothing worked. do you know how I can change the width, or use a fixed size? Which CSS-ID/Class is it?

Thanks for your help!

Genesis

Here's an image of what I'm talking about:

http://img296.imageshack.us/img296/9418/saveoe8.th.jpg (http://img296.imageshack.us/my.php?image=saveoe8.jpg)

Edit: Sry for talking with myself. :D I found the css-class - its ".tooltip". I placed it in my general css-file to overwrite it, and gave it a fixed width of 400px which is okay!

[Raspbuten]

Great tool!

Unfortunately for my guild, we're using GuildLaunch as our forums provider and thus, are subject to their activated BBCodes.

Is there anyway to make these standard so that third party forums may also use these tags?

EDIT:

I see that GuildLaunch does not allow the use of Custom BBCodes.

I've posted on their forums, along with the methods provided so that they might add this into their supported BBCodes.

Thanks for a great tool and resource.

[Astharothtx]

Done!

I tweak a bit the puitemstats for joomla with...

$data = itemstats_read_url('http://www.wardb.com/search.aspx?search_text=' . urlencode($item_name));
//String to search item.aspx?id= ";</script>
preg_match('#item.aspx\?id=(.+?)";</script>#s', $data, $ids);
$item_id = $ids[1];


$item_html = "<a class='wardb-item-text' href='http://www.wardb.com/item.aspx?id=" . $item_id . "'></a>";
// Finally, replace the bbcode with the html.
$message = str_replace($match[0], $item_html, $message);

And it works.. surely i can get working the item cache DB with this info too.

[Edit]
I forgot, this code is for item search by name, using a real query with the search.aspx page and looking into the results with one regular expression just to get the id.
Later, use the id with de jscript code around here to get the item tooltip.
PuItemStats have a cache in the db, surely we can store the "answer" (name>id) and maybe, tweaking a bit the jscript, the item data too.

It's not my intention do a new "puitemstats" for war, but if someone can get involved i can help.


Cheers from Spain!

[RadekSiN]

Very nice, cant wait for this go live officialy. until than I'll make a small hack of my own!

[Xanthian]

Any reason why spell linking doesnt work like the item one?

Can link it like [~url=http://www.wardb.com/spell.aspx?id=9471]Chillwind[/url~] Making - Chillwind (http://www.wardb.com/spell.aspx?id=9471)

But not using [~waritem=9471]Chillwind[/waritem~]

Am I missing something?

Using PHBB3 forums btw.

[Mo0rbid]

that might madden cthulu

[Xanthian]

that might madden cthulu

excuse me? :confused:

[gehmnal]

Done!

[snip]...

Cheers from Spain!

Thanks Astharothtx! I haven't had much time to work on any of this due to having a busy weekend and all, but I had a feeling it would be something simple like that. Anyone running phpbb3 with the WoW itemstats addon should have a pretty easy time if they just know where to look.

My issue is getting the phpbb3 addon to work completely with PHP Fusion, which may take some monkeying around, but I should be able to get it working alright. Just a matter of picking out the right spots to place includes and putting bbcodes directly in, instead of using a separate bbcode file.

[Shawnley]

iv updated This Site (http://tx-community.dk/waritems/waritems.php?) alittle..

got a short vBulletin tutorial, and basic html tutorial so far.

Gonna keep updating, depending on the requests :)

[GLStephen]

Unfortunately for my guild, we're using GuildLaunch as our forums provider and thus, are subject to their activated BBCodes.

Stephen from Guild Launch here.

We added this just the other day, so you're set. :)

For the WarDB staff, we use an ItemStats implementation as the core of our ItemStats, so something ItemStats compatible from you guys would let us get WarDB setup for use by our guilds really easily. We've got Warhammer items setup to come from MMODB as of now (available in the next release), but I'd prefer to use you all as the primary source.

-Stephen

[gehmnal]

For anyone interested in a PHP Fusion solution, here is what you do to get this working:

1. Add the following line to subheader.php:
<script type='text/javascript' src='http://www.wardb.com/js/extooltips.js'></script>2. Add the following to maincore.php in function parseubb($text) { } (best to do after the last line in the function that starts with $text = preg_replace(.....); ) :

// Custom tags for linking WAR items from WARDB.com
while (preg_match('#\[Item\](.+?)\[/Item\]#s', $text, $match)) {
$item_found = false;
$item_name = $match[1];
$data = item_read_url('http://www.wardb.com/search.aspx?search_text='.urlencode($item_name));
$item_found = preg_match('#item.aspx\?id=(.+?)";</script#s', $data, $id);
if ($item_found) {
$item_id = $id[1];
}
$item_html = "<a class='wardb-item-full-small' href='http://www.wardb.com/item.aspx?id=".$item_id."'>".$item_name."</a>";
$text = str_replace($match[0], $item_html, $text);
}3. Add the following function right underneath the end of the parseubb() function (this is the only code I actually took from itemstats):


function item_read_url($url) {
// Try cURL first. If that isn't available, check if we're allowed to
// use fopen on URLs. If that doesn't work, just die.
if (function_exists('curl_init'))
{
$ch = @curl_init($url);
@curl_setopt($ch, CURLOPT_TIMEOUT, 30);
@curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
@curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

$html_data = curl_exec($ch);
@curl_close($ch);
}
else if (ini_get('allow_url_fopen') == 1)
{
$html_data = @file_get_contents($url);
}
else
{
// Thanks to Aki Uusitalo
$url_array = parse_url($url);

$fp = fsockopen($url_array['host'], 80, $errno, $errstr, 5);

if (!fp)
{
die("cURL isn't installed, 'allow_url_fopen' isn't set and socket opening failed. Socket failed because: <br /><br /> $errstr ($errno)");

}
else
{
$out = "GET " . $url_array[path] . "?" . $url_array[query] ." HTTP/1.0\r\n";
$out .= "Host: " . $url_array[host] . " \r\n";
$out .= "Connection: Close\r\n\r\n";

fwrite($fp, $out);

// Get rid of the HTTP headers
while ($fp && !feof($fp))
{
$headerbuffer = fgets($fp, 1024);
if (urlencode($headerbuffer) == "%0D%0A")
{
// We've reached the end of the headers
break;
}
}

$html_data = '';
// Read the raw data from the socket in 1kb chunks
// Hopefully, it's just HTML.

while (!feof($fp))
{
$html_data .= fgets($fp, 1024);
}
fclose($fp);
}
}
return $html_data;
}
You should now be able to link items using [ Item ]item name[ /Item ] (no spaces) in forum posts and any other page that calls the parseubb function. By default, the news.php page doesn't call this function... if anyone wants to know how to get this working in the news feature of PHP Fusion as well, let me know and I'll explain (it's just a matter of adding $news_news = parseubb($news_news); to two locations in the file).

[edit] My apologies for the lack of caching to the WARDB/Warhammer Alliance staff. That's next on the agenda...

[Tymed]

Anyone know the code that would allow Itemstats for phpbb to pull the id from wardb.com by just typing the name?

[Shawnley]

For anyone interested in a PHP Fusion solution, here is what you do to get this working:


Great work there gehmnal..

This solution can, with alittle tweaking, also be used for any other forum/website.

.. Mind if i grab some stuff for it, and redo it other forums aswell?

[gehmnal]

Great work there gehmnal..

This solution can, with alittle tweaking, also be used for any other forum/website.

.. Mind if i grab some stuff for it, and redo it other forums aswell?

Please do, and thanks! The more CMS/forums this works with the better in my opinion. :) Personally I'd like to do a bit more work with this so the code can be located in a separate php file instead of having to extensively edit the core PHP Fusion files.

Anyone know the code that would allow Itemstats for phpbb to pull the id from wardb.com by just typing the name?

I think the easiest way is to make sure Itemstats is set to search on Thottbot (I know, just stay with me a second here), then edit the thottbot.php file in the includes directory of Itemstats according to Astharothtx's post above. It may be a bit more complicated than just that, as the thottbot.php file does more stuff as well, but if you don't mind wiping the contents you can use the second "quote" of code in my post above and it should work. Sorry I can't give exact instructions...

[Tymed]

This is the current code of the thottbot.php file for EQDKP portion of my website. I dont know how to edit it to sync up with warDB.

<?php

include_once(dirname(__FILE__) . '/urlreader.php');

// The main interface to the Thottbot.
class ParseThottbot
{
// Constructor
function ParseThottbot()
{

}

// Cleans up resources used by this object.
function close()
{

}

// Retrieves the data for the specified item from Thottbot.
function getItem($name)
{
// Ignore blank names.
$name = trim($name);

if (empty($name))
{
return null;
}

$item = array('name' => $name);

// Perform a search on Thottbot for the specified item name.
$data = itemstats_read_url('http://www.thottbot.com/?i=' . urlencode($name));

// First check if thottbot redirected us to the actual item page.
$item_found = preg_match('#\?i=(.*?);sort#', $data, $match);
if (!$item_found)
{
$item_found = preg_match("#input type='hidden' name='i' value=\"(.*?)\">#", $data, $match);
}

// If we were redirected, extract the item ID and move on.
if ($item_found)
{
$item_id = $match[1];
}
else // If a match was not found, we're probably on the search page.
{
// Look for search result that matches the item name.
if (preg_match_all("#\?i=(.*?)'><script>i(.*?)class=quality(.*?)>(.*?)</span>(.*?)&nbsp;(.*?)1.(.*?).(.*?)</font>#", $data, $matches))
{
foreach ($matches[0] as $key => $match)
{
if ((strcasecmp($item['name'], $matches[4][$key]) == 0))
{
// If we have a match, grab additional information about this item and break out of this loop.
$item_id = $matches[1][$key];

// Read the page specific to this item.
$data = itemstats_read_url('http://www.thottbot.com/?i=' . $item_id);

$item_found = true;
break;
}
}
}
}

// If the item was found, we got lots of work to do. Start molding the HTML to the way we want it.
if ($item_found)
{
// Grab the proper name of this item.
preg_match("#<span class=quality[0-9]>(.*?)</span>#", $data, $match);
$item['name'] = $match[1];

$item['id'] = $item_id;
$item['lang'] = 'en';

// Grab the icon for this item.
preg_match('#Icons/(.*?).jpg#', $data, $match);
$item['icon'] = $match[1];

// Create the link for this item.
$item['link'] = 'http://www.thottbot.com/?i=' . $item_id;

// Grab the display html of this item.
if (preg_match("/<table class\=ttb(.*?)" . $item['name'] . "(.*?)<\/table>/", $data, $match))
{
$item['html'] = $match[0];

// Extract the item color from the HTML.
preg_match('/quality[1-9]/', $item['html'], $match);
$item['color'] = $match[0];

// Look for a set id for this item.
if (preg_match("/href='\?set=(.*?)'/", $data, $match))
{
// Create a link to the set page.
$set_link = 'http://www.thottbot.com/?set=' . $match[1];

// Extract the name of the set for this item.
if (preg_match('/Set: (.*?) \((.*?)\)/', $item['html'], $match))
{
$set_name = $match[1];
}

// Extract the set bonuses.
if (preg_match('/worn:<br>(.*?)<center>/s', $data, $match))
{
$set_bonuses = str_replace("<a", "<a class='setbonus'", $match[1]);
}

// Build the set bonus html.
$set_html = "<tr><td colspan=2><a class='set' href='" . $set_link . "'>" . $set_name . "</a><span class='setbonus'><br />";
$set_html .= $set_bonuses;
$set_html .= '</span></td></tr>';

// Fix the "Set" part of the HTML.
$item['html'] = preg_replace('/Set: (.*?) \((.*?)\)/', '&nbsp;</td></tr>' . $set_html, $item['html']);
}

// Remove the "Sells for" part of the HTML.
$item['html'] = preg_replace('/<tr><td colspan=2>Sells for(.*?)<\/td><\/tr>/', '', $item['html']);

// Remove the "Item Level" part of the HTML.
$item['html'] = preg_replace('/<tr><td colspan=2>Item Level(.*?)<\/td><\/tr>/', '', $item['html']);

// Remove the "Durability" part of the HTML.
$item['html'] = preg_replace('/<tr><td colspan=2>Durability(.*?)<\/td><\/tr>/', '', $item['html']);

// Remove the "Source" part of the HTML.
$item['html'] = preg_replace('/<tr><td colspan=2><small><font color=(.*?)>Source(.*?)<\/table>/', '</table>', $item['html']);
$item['html'] = preg_replace('/<tr><td colspan=2><h6>(.*?)<\/h6><\/td><\/tr>/', '', $item['html']);

// Replace the 'ttd' table style with 'wowitemt'.
$item['html'] = str_replace('class=ttb', "class='wowitemt'", $item['html']);
$item['html'] = str_replace('<table', '<table cellspacing="0"', $item['html']);

// Replace the 'spell' style with 'itemeffectlink'.
$item['html'] = str_replace("class='spell'", "class='itemeffectlink'", $item['html']);

// Remove any underline tags
$item['html'] = preg_replace('/<[ \/]*u[ \/]*>/', '', $item['html']);

// Fix up some last bits of the HTML.
$item['html'] = str_replace('"', '\'', $item['html']);
$item['html'] = str_replace("href='?", "href='http://www.thottbot.com/?", $item['html']);
$item['html'] = str_replace("<a", "<a target='_new'", $item['html']);

// Build the final HTML by merging the template and the data we just prepared.
$template_html = trim(file_get_contents(dirname(__FILE__) . '/../templates/popup.tpl'));
$item['html'] = str_replace('{ITEM_HTML}', $item['html'], $template_html);
}
return $item;
}
unset($item['link']);
return $item;
}

// Retrieves the data for the specified item from Thottbot.
// Not disponible because not the same Id system of Blizzard
function getItemId($name)
{
$item = array('name' => $name);
return ($item);
}
}

?>

[Tymed]

bah i will just wait for a itemstats for eqdkp to come out for warhammer there is to much code to go through and change i think to get this working

[falcon56]

Hello,
i have put Item link on my invision board to do this :

Go to pcadmin-->look and feel -->Editing the Board Header and Footer Wrapper

after </head>
put <script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>

after go to management pannel --> Custom BBCode Manager

add bbcode :

Custom BBCode Title : waritem
Custom BBCode Tag : waritem
Custom BBCode Replacement : <a class='wardb-item-full-medium' href='http://www.wardb.com/item.aspx?id={content}'></a>

to put an item on your board item number

i have tried with spell but it doesn't work for me

ps : sorry for my english i'm french

[badrobot]

falcon, not working for me :(

I have vbulletin but your code made sense so I tried

[Shepx83]

Very nice work guys on coming up with the solutions for different boards.

Would there be a chance someone could work up one for SMF 1.1.5? That is a wee bit over my head. :)

[bluealien1]

Very nice work guys on coming up with the solutions for different boards.

Would there be a chance someone could work up one for SMF 1.1.5? That is a wee bit over my head. :)
I, too, could use one for SMF 1.1.5.

[DarkKaine]

I, too, could use one for SMF 1.1.5.

Yes, I've the same problem, I don't know how work it in SMF.

[Nalos]

I'm more or less a coding novice, and that's being generous, so most of what I'm seeing is a bit confusing. I understand what everyone is attempting to do with the way the code is written, I just have no idea where to put it.

I have a PHPBB3 board system, so if anyone has the time, could you put up an idiot's version of how to go about this? I don't mean to be a pain in the but my code guy is away for a while and I'm trying to get this up and running as he won't be able to for some time. Thanks for any help in advance.

[robb75067]

I'm more or less a coding novice, and that's being generous, so most of what I'm seeing is a bit confusing. I understand what everyone is attempting to do with the way the code is written, I just have no idea where to put it.

I have a PHPBB3 board system, so if anyone has the time, could you put up an idiot's version of how to go about this? I don't mean to be a pain in the but my code guy is away for a while and I'm trying to get this up and running as he won't be able to for some time. Thanks for any help in advance.

I'm in the same boat and also on PHPBB3.

Thanks,
BT

[Jizzy]

Great Work here guys we are going to try and implement this on PHP Fusion and will let you know how we get on.

[Micos]

I'm more or less a coding novice, and that's being generous, so most of what I'm seeing is a bit confusing. I understand what everyone is attempting to do with the way the code is written, I just have no idea where to put it.

This is for PHPBB3:
- login to your administration control panel and go to postings -> bbcode.
- create a new bbcode
- paste this in the first window (remove ~):

[~item]{TEXT}[/item]

- paste this in the second window:

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class="wardb-item-full-medium" href="{TEXT}"></a><br />

- set the option to show this bbcode while creating postings.

if you want to link spells/skills, you will have to create one more bbcode, exactly like the one above but with the following code:

bbcode (remove ~):

[~skill]{TEXT}[/skill]

html:

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class="wardb-spell-full-medium" href="{TEXT}"></a><br />


use [~skill]http://www.wardb.com/spell.aspx?id=9236[/skill] to link skills
or use [~item]http://www.wardb.com/item.aspx?id=434107[item] to link items.
i found this to be the most basic implementation, user dont have to look for ID-numbers. They just paste the whole link.
If you want to tighten your code, inject the first line of the html code into the header of your board.

[Shepx83]

I tried messing around with SMF, got the Javascript added into my header so it loads throughout my forum.

When i do the direct url bbc and manually put in the link and add my own name it will Show the text base version of it, with the popup.

I just cant figure out the way SMF 1.1.5 works, because you have to use Subs.php and Post.template.php as well as the Modifications.English file in languages as well. Just cant figure how to get the BBC right.

Here (http://custom.simplemachines.org/mods/index.php?action=parse) is an explantion on how to get a Youtube BBC to work in SMF, anyone able to tear it apart and put this into it? I know it would be alot more simple then doing a youtube BBC. Sorry for such a lengthy example, Just hoping to get us SMF people on par.

[Tymed]

i have been trying to the ItemStats for eqdkp to sync up with my dkp on my website but still no go. i have no idea how to do this, if anyone is good with code and can mod Itemstats it would be sweet. Thanks.

[falcon56]

falcon, not working for me :(

I have vbulletin but your code made sense so I tried

Sorry but i have just Invision Power Board not Vbulletin.

Anyone Tried Spell on Invision Board ?

[gehmnal]

Great Work here guys we are going to try and implement this on PHP Fusion and will let you know how we get on.

Check my post on page 3 of this thread (not sure if you read the whole thread or not) and you'll see step by step instructions. :)

Cheers!

[gehmnal]

Also, for anyone looking to get this working with EQDKP, the general idea of my long post on page 3 should be correct, but the file you're looking to edit is /includes/functions.php and the function you are looking for in there is news_parse() (not sure if there is one for forums, or if EQDKP even comes with forums...)

Note: I haven't tested this with EQDKP, nor do I intend to, but the way EQDKP handles bbcode parsing is close enough to PHP Fusion that it should work.

[Nalos]

This is for PHPBB3:
- login to your administration control panel and go to postings -> bbcode.
- create a new bbcode
- paste this in the first window (remove ~):

[~item]{TEXT}[/item]

- paste this in the second window:

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class="wardb-item-full-medium" href="{TEXT}"></a><br />

- set the option to show this bbcode while creating postings.

if you want to link spells/skills, you will have to create one more bbcode, exactly like the one above but with the following code:

bbcode (remove ~):

[~skill]{TEXT}[/skill]

html:

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class="wardb-spell-full-medium" href="{TEXT}"></a><br />


use [~skill]http://www.wardb.com/spell.aspx?id=9236[/skill] to link skills
or use [~item]http://www.wardb.com/item.aspx?id=434107[item] to link items.
i found this to be the most basic implementation, user dont have to look for ID-numbers. They just paste the whole link.
If you want to tighten your code, inject the first line of the html code into the header of your board.

You're awesome! It works great, thank you for the help.

EDIT: I took the liberty of changing the item and spell lines it a little bit to this;

<a class="wardb-item-text" href="{TEXT}"></a>
&
<a class="wardb-spell-text" href="{TEXT}"></a>

Thanks again for the help though.

[Zyxlei]

OK...

I am using an e107 site, and was able to get linking in no problemo with a little work:
Here's instructions for anyone else that may be on e107 or incase it might help anyone else figure some stuff out:

I edited line 37 of /e107_handlers/bbcode_handler.php to include 'warlink' (so I can use [~warlink]id[/warlink])

Then I created a file called warlink.bb in the /e107_files/bbcode directory. here is the full code:

if(strtolower($parm) == "item"){

$url = "http://www.wardb.com/".$parm.".aspx?id=".$code_text;

return "<a class='wardb-item-text' href='".$url."'>".$title_a[0]."</a>";}

if(strtolower($parm) == "spell"){

$url = "http://www.wardb.com/".$parm.".aspx?id=".$code_text;

return "<a class='wardb-spell-text' href='".$url."'>".$title_a[0]."</a>";}
All is awesome, I can get links to either items or spells with the tooltips by using [~warlink=item]id[/warlink] or id

This is evidenced by this link (http://www.templeofkhaine.com/e107_plugins/forum/forum_viewtopic.php?7.last)

P.S. I hope this helps someone

[DarkKaine]

Hello guys!

I have done it in my SMF 1.1.5 forum is very simple.

Before of nothing you must install this mod in your forum:

http://custom.simplemachines.org/mods/index.php?mod=621

Once you have installed it's important that your default language is the English in order that it works correctly.

Then you go to your administrator panel, and go to the section " Features and Options ". There you will find a tab with the name of the mod (Custom BBC).

You must push in " creating a new tag " and in " tag name " you put the tag that you want (if you want that it is {content} simply put "item" in this case.

The rest of options are optional, less that of the code certainly...

Where the code asks for HTML you to paste this for the items:

<tag> <script src ='http: // www.wardb.com/js/extooltips.js (http://www.wardb.com/js/extooltips.js) ' type ='text/javascript '> </script> <to class = "wardb-item-full-medium" href = " {content} "> </to> <br /> </tag>

And for the skills paste this in another new tag:

<tag> <script src ='http: // www.wardb.com/js/extooltips.js (http://www.wardb.com/js/extooltips.js) ' type ='text/javascript '> </script> <to class = "wardb-spell-full-medium" href = " {content} "> </to> <br /> </tag>

Now you have your BBCodes de Wardb in your forum SMF :)
To add a button follow the instructions of the readme of the mod.

I hope that your problem and you have understood me in spite of my terrible english.

Thanks for all commentaries and guides. They have been many usefull for me.

Greetings!

[johanlm]

tagging & subscribing this. ;)

[EDIT]
Anyone done a phpbb2 sollution for this yet?

[Kronyx]

I've tried your how to DarkKaine, i have the button when i create a new post, appear, i put the number in, i cleck on preview, i see there is something but nothing appear !
Can you help me with that ?

[DarkKaine]

I've tried your how to DarkKaine, i have the button when i create a new post, appear, i put the number in, i cleck on preview, i see there is something but nothing appear !
Can you help me with that ?

Have you enabled te BBCode like this ?

http://img501.imageshack.us/img501/2579/consolaoy7.jpg

I've got some problems with button image, but the BBC works correctly.

However, try to post it :) Sometimes I see nothing in the preview but if I post it, the item/spell apears.

Greetings!

[Zyxlei]

Need a small hand here. All of my Item links are coming across just fine, colors and everything.

My spell links, however, are only coming across in grey, which is the default color for links on my site, I would like them to come across orange or something else that stands out.

The only way I've been able to change their color is by changing the default link color, but that changes every link.

Is there any way I can change the color of just the spell links?

Thanks in advance!

[GalloInfligo]

Anyone have any luck with this in dragonfly using ForumsPro yet?

[Zyxlei]

Anyone have any luck with this in dragonfly using ForumsPro yet?

I do not use dragonfly, but knowing that it is a PHP built CMS, look into making a custom BBcode for dragonfly. If you can get that working,you shouldbe able to use the code that I provided for the actual BBcode PHP script.

[JinF]

When I try adding the BBCodes to my phpbb3 forums, I get a 403 error when trying to submit it. Seems to have something to do with the javascript part, since I can add HTML BBCodes without a problem. Anyone else had this issue?

[robb75067]

This is for PHPBB3:
- login to your administration control panel and go to postings -> bbcode.
- create a new bbcode
- paste this in the first window (remove ~):

[~item]{TEXT}[/item]

- paste this in the second window:

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class="wardb-item-full-medium" href="{TEXT}"></a><br />

- set the option to show this bbcode while creating postings.

if you want to link spells/skills, you will have to create one more bbcode, exactly like the one above but with the following code:

bbcode (remove ~):

[~skill]{TEXT}[/skill]

html:

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class="wardb-spell-full-medium" href="{TEXT}"></a><br />


use [~skill]http://www.wardb.com/spell.aspx?id=9236[/skill] to link skills
or use [~item]http://www.wardb.com/item.aspx?id=434107[item] to link items.
i found this to be the most basic implementation, user dont have to look for ID-numbers. They just paste the whole link.
If you want to tighten your code, inject the first line of the html code into the header of your board.


Thanks for the info!!

[Takauri]

This is for PHPBB3:
- login to your administration control panel and go to postings -> bbcode.
- create a new bbcode
- paste this in the first window (remove ~):

[~item]{TEXT}[/item]

- paste this in the second window:

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class="wardb-item-full-medium" href="{TEXT}"></a><br />

- set the option to show this bbcode while creating postings.

if you want to link spells/skills, you will have to create one more bbcode, exactly like the one above but with the following code:

bbcode (remove ~):

[~skill]{TEXT}[/skill]

html:

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class="wardb-spell-full-medium" href="{TEXT}"></a><br />


use [~skill]http://www.wardb.com/spell.aspx?id=9236[/skill] to link skills
or use [~item]http://www.wardb.com/item.aspx?id=434107[item] to link items.
i found this to be the most basic implementation, user dont have to look for ID-numbers. They just paste the whole link.
If you want to tighten your code, inject the first line of the html code into the header of your board.


Can I suggest a slight change so that the users only need to enter the id number rather than the whole URL?

Replace the above quoted HTML replacement strings with...

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class="wardb-item-full-medium" href="http://www.wardb.com/item.aspx?id={TEXT}"></a><br />

and

<script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>
<a class="wardb-spell-full-medium" href="http://www.wardb.com/spell.aspx?id={TEXT}"></a><br />

Then you could use use [~skill]9236[/skill] to link skills
or use [~item]434107[item] to link items.

[GalloInfligo]

I do not use dragonfly, but knowing that it is a PHP built CMS, look into making a custom BBcode for dragonfly. If you can get that working,you should be able to use the code that I provided for the actual BBcode PHP script.

Well after finally finding where the file was, and findig that there was two there and i was editing the wrong one ;) I got it working with modifying the codes given from the earlier post.

For anyone else using dragonfly and forums pro, you need to hand edit your
/includes/fpbbcode.php file and add the following 2 lines in


$text = preg_replace("#\[waritem\](.*?)\[/waritem\]#si", '<a class='wardb-item-full-medium' href='http://www.wardb.com/item.aspx?id=\\1'></a>', $text);
$text = preg_replace("#\[warspell\](.*?)\[/warspell\]#si", '<a class='wardb-spell-full' href='http://www.wardb.com/spell.aspx?id=\\1'></a>', $text);


I put these right after the line...


// and for italicizing text.
$text = preg_replace("#\[i\](.*?)\[/i\]#si", "[i:$uid]\\1[/i:$uid]", $text);


and it works just fine. also dont forget to put the javascript link in your themes header.html file

Now I could get the waritem and warspell working but I could not get the warlink to work, but i'm happy with what I got ;) thanks for all the information and the hard work you all have done. My tinkering on your code was the easy part ;)

[GalloInfligo]

One other thing that I have noticed now that I have it working, is that it works great....but every so often, a code from here that works, shows nothing on my site, no broken code, no image, just an empty space, any ideas on what would cause that? I was thinking some kind of lag or problem like that connecting to the database at the time I tried to pull that image up, but its weird that it happens for just the same ones all the time.

[Kronyx]

Have you enabled te BBCode like this ?

http://img501.imageshack.us/img501/2579/consolaoy7.jpg

I've got some problems with button image, but the BBC works correctly.

However, try to post it :) Sometimes I see nothing in the preview but if I post it, the item/spell apears.

Greetings!

Ok it's working now, i've copy the <tag> </tag> in the html LOL now it's working like a charm !

[Kronyx]

I also have this problem, it looks like it's a cache problem. The only problem i can see it's that there is no way to put 2 items on the same line. It always one by line.

[Micos]

Can I suggest a slight change so that the users only need to enter the id number rather than the whole URL?

dont be offended, but why would you want to do that?
Usually its easier to copy&paste the whole url, and dont bother with ID's. Most user who dont know how it works will try this first.

[Hawiz]

I got this working a while ago on my forums (IPB 2.3.5, here (http://www.dreadwing.org/index.php?showtopic=691&st=0&p=5712&#entry5712)), and only just noticed that the javascript file seems to be conflicting with other javascript files in the forum software. Dropdowns/popups don't seem to work in internet explorer, Safari, Opra etc, but they are fine in Firefox. Anyone know what might be causing this problem?

Thanks.

[SSSlippy]

This code should be compressed its currently 817 lines of code. Also anyway to get item links to have [] around them it makes them stick out especially if u are not using images.

[falcon56]

I got this working a while ago on my forums (IPB 2.3.5, here (http://www.dreadwing.org/index.php?showtopic=691&st=0&p=5712&#entry5712)), and only just noticed that the javascript file seems to be conflicting with other javascript files in the forum software. Dropdowns/popups don't seem to work in internet explorer, Safari, Opra etc, but they are fine in Firefox. Anyone know what might be causing this problem?

Thanks.

please help me to add BBcode warspell, it doesn't work for me on IPB 2.3.5.

I have add on my header <script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>

in my BBode <a class="wardb-spell-full-medium" href="{content}"></a><br/>

thanks for help

[Adamar]

It's awesome to see the community working together :) In an update this week, we'll be unveiling our syndication system which we hope will make implementing tooltips (and other features) on your sites as simple as possible.

[GalloInfligo]

Well the Java script has a bug in it that once I put it in the header for my site Version 6 of IE can no longer load my site. Just thought I would pass that on for you.... Damn IE ;)

[Hawiz]

please help me to add BBcode warspell, it doesn't work for me on IPB 2.3.5.

I have add on my header <script src='http://www.wardb.com/js/extooltips.js' type='text/javascript'></script>

in my BBode <a class="wardb-spell-full-medium" href="{content}"></a><br/>

thanks for help

The BBcode I used is shown in the attached images -

http://www.dreadwing.org/uploads/itembbcode.JPG
http://www.dreadwing.org/uploads/spellbbcode.JPG

Try copying the fields exactly, including the JS import in the header. Download the linked js file here (http://www.wardb.com/js/extooltips.js) (save page as...), and upload into the IPB /jscripts directory. If curse update their script, you'll have to update this file manually.

With all of that in place, putting an item ID in [item] tags will give you a single link. You can change the type of output by changing the "class" line in the BBcode.

You'll probably get the same problem as me though - it will conflict with some IPB JS files and some panels wont open up (such as options in the topic view) in certain browsers.

[vjeux]

There is quite a lot of issues with IPB forum and the javascript file.

First of all, the tooltip is completly messed up :
http://vjeux.fooo-team.com/curse/Tooltips/ipb%20tooltip.PNG

Then with IE only (tested with Firefox and Chrome) we can't open the Option dropdown.

[Phrost]

anyone got tactics to work when linking?

Added it to our site, but tactics dont work (items and spells works excellent :) )

[vjeux]

Unstoppable Juggernaut
Unstoppable Juggernaut

505
505
[ spell]Unstoppable Juggernaut[/spell]
[ SPELLLINK]Unstoppable Juggernaut[/SPELLLINK]

[ spell]505[/spell]
[ SPELLLINK]505[/SPELLLINK]

It's working well

[Phrost]

yes here on this forum, but re-read my post and youll see i had problems on -my- forum with linking tactics :)

items and spells work without any problems.

[vjeux]

Sorry :p

What's your forum application and how did you set it up? I'm working in making an installation documentation for the major forums out there and in none of them i have this problem.

[Phrost]

no worries reading back i wasnt as clear as i intended, so it was my bad aswell ;)

its phpbb3.0 using shawnleys link to set it up (http://tx-community.dk/waritems/waritems.php?)

Spells and items link without any problem, but tactics wont show up.

weird thing is tactics have the "http://www.wardb.com/spell.aspx?id=" just like "ordinary" spells have... so thats why im at a loss :(

edit: tried linking terrible embrace, and got the same problem :/

[vjeux]

Tactics are treated as regular spells by the database. You just have to use your spell tag (for example [ spell]) with the tactic name (or id) instead of the spell name (or id).

If you want to link the tactic Unstoppable Juggernaut, you have to write [ spell]Unstoppable Juggernaut[/spell]

You must NOT create another tag [tactic] or anything else tactic specific, you have to use what you use for the spells :)

Edit: Terrible Embrace (http://www.wardb.com/spell.aspx?id=8410)

[Phrost]

well yes on this forum it works flawlessly, but it doesnt on the other forum i was talking about ;)

doombolt works without any problem, terrible embrace and all the tactics linked in the post in the other forum doesnt work.

Items work flawlessly, but just cant get tactics to work (on that other forum ;))

the tags used is [ warspell]id# of spell[/warspell] and [ waritem]id# of item[/waritem]

again "real" spells like doombolt works, tactics dont.

sorry if im confusing or if this isnt the place to post ;)

[GalloInfligo]

Sorry :p

What's your forum application and how did you set it up? I'm working in making an installation documentation for the major forums out there and in none of them i have this problem.

Well since you are doing this, let me give you my information as well ;) I previously posted what I have done and gotten to work, here is everything I have so far.

CMS: Dragonfly version 9.2.1
ForumsPro Version 2.0.0.1

adding this to my /includes/fpbbcode.php file

$text = preg_replace("#\[waritem\](.*?)\[/waritem\]#si", '<a class='wardb-item-full-medium' href='http://www.wardb.com/item.aspx?id=\\1'></a>', $text);
$text = preg_replace("#\[warlink\](.*?)\[/warlink\]#si", '<a class='wardb-item-text' href='http://www.wardb.com/item.aspx?id=\\1'></a>', $text);
$text = preg_replace("#\[warspell\](.*?)\[/warspell\]#si", '<a class='wardb-spell-full' href='http://www.wardb.com/spell.aspx?id=\\1'></a>', $text);


I get waritem and warspell to work, war link however does not work. ALSO one thing I would like to point out, These only work if I use the item NUMBER if I enter the name like you do here in your posts, it makes the BBCode vanish from the post but then puts nothing in its place ALSO the spell 8177 does the same thing using warspell, i can get other spells and tactics to show up but not 8177, it just makes the bbcode vanish and shows nothing.

ALSO there is still the issue that all of my members using Internet Explorer version older than 7 can not even get my site to load unless I remove your Java Script from my header.

Now granted I am an amature to coding in this enviroment so I just hacked away until i got the damn thing to work, so if you see a better way to get the above code to work with what I use, feel free to share it with me ;)

[Grunk]

Has this been tested with SMF 1.1.5? And is the update this week going to include syndication for this?

[nighthawk999]

Ok I tried adding

$text = preg_replace("#\[\s*waritem\s*\](.+?)\[\/waritem\s*\]#is", "<a class='wardb-item-full-medium' href='http://www.wardb.com/item.aspx?id=\\1'></a>", $text);


To my functions_wysiwyg.php file (I use vBulletin)

I have the JS in the header of the forum.

Now I can do the standard

[url=etc.... linking stuff but I can't get the [~waritem....etc bbcode to work as per Shawnleys description. (following http://tx-community.dk/waritems/waritems.php?)

I tried replacing

$text = preg_replace($pregfind, $pregreplace, $text);

With his code

$text = preg_replace("#\[\s*waritem\s*\](.+?)\[\/waritem\s*\]#is", "<a class='wardb-item-full-medium' href='http://www.wardb.com/item.aspx?id=\\1'></a>", $text);

I tried leaving the original code in and adding it in underneath. Neither seem to work when I use [~waritem]

Should i just wait for the Curse guys to do their vBulletin plug in or is there anyone who has implemented this into their vBulletin boards already.

Cheers

[GalloInfligo]

I spoke with our developer about this. We'll have a page up shortly explaining in more detail how to use the various tooltip syndication, but for now if you want to get started, you can include the following: http://www.wardb.com/js/extooltips.js

The javascript should take care of the rest and will convert links to items, quests, and spells to mouse-over tooltip links. :)

OK we got the items and spells down, now how dow we link the quests?

[SonicBorg]

Having trouble getting images to show on smf.
Is there away to have buttons to add [ item] [/ item] code ? like the [ b] and [ i] is above the edit box ?


EDIT: Okay i noticed that the custom BBcode (http://custom.simplemachines.org/mods/index.php?mod=621)mod for SMF is limit upto version 1.1.2 and not the latest 1.1.5 stable (or even beta 2.x)
Does a clever person know another way, or have something simular/updated on that custom BBcode script please ?

[badrobot]

I think thats a query to run it (backup your db first) from cpanel or phpmy admin.
---

I installed everything from VBulletin instructions but there 2 errors

1)

Warning: mysql_query() [function.mysql-query]: Access denied for user 'xxx'@'localhost' (using password: NO) in [path]/includes/class_bbcode.php on line 2464

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in [path]/includes/class_bbcode.php on line 2464

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in [path]/includes/class_bbcode.php on line 2465

Items and spells still display ok but there is a long list with errors above so something is wrong ;) (npc and quests didnt)

2) this isnt important but the icons for bbcode dont work

3) Last thing
"Example:
id or name or id or name. Tip: You can use "text", "full-small", "full-medium" and "full-large""

Can you explain this more please? What we write there or we need to choose?

[Adamar]

Please go to http://www.wardb.com/syndication.aspx for any unanswered syndication questions.

[SonicBorg]

Please go to http://www.wardb.com/syndication.aspx for any unanswered syndication questions.

any chance on someone please looking into e107 to see where to put
<script type="text/javascript" src="http://www.wardb.com/js/extooltips.js"></script>
as I can not get this to work no matter where i shove this.

[badrobot]

Please go to http://www.wardb.com/syndication.aspx for any unanswered syndication questions.

i know, but did you read my message?
i got errors after i followed all your steps.

regards

[SonicBorg]

I was looking at Itemstats1.5 for WoW, and i was wondering if maybe someone might be able to edit this to support WAR on wardb ?

http://itemstats.free.fr/news.php (You can change the language to english on the right side of page)

This seems to have built in support for e107, SMF,phpnuke,Joomla,vbulletin,phpbb, and also has cache feature which i understand would be lightening the load on wardb servers?


EDIT : ps. just found away to make this work nicely and so easy in e107 CMS after trying many things.
If you have a "custom menu" just add the needed code in there. So for example i have the search tool on my site from Curse, which was added by custom menu, i also added the needed code for tooltips.
www.teknoid.org.uk/front/ for demo

[Vesk]

Can I force that script to wardb-item-small instead of wardb-item-text for every link?

[Tymed]

could you also add it for eqdkp as well?

[GLStephen]

This is working well for us, but it seems the Quests and NPC types aren't working. Is there some trick, some issue, or do only certain quests/npcs work? I notice that the URL is different on WarDB for public and party and normal quests.

-Stephen

[Adamar]

We've just added support for eqDKP. We've also fixed several of the reported bugs with vBulletin. You can read the new and update installation instructions here:

http://www.wardb.com/syndication.aspx

[badrobot]

Thx for update!
I managed to install the light version for vbulletin. But only items and spells are working.

For the normal version I got this error when running the SQL Querry:


An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE `wardb_itemcache` (
`id` int(32) NOT NULL,
`name_en` varch' at line 1


Images for bbcodes still not working but I will make my own.

CHEERS!

[Tymed]

Thanks! I had a diff, earlier version of eqDKP but i was able to use the code you provided to tweak it. WarDB is almost fully integrated into my site www.dread-guild.com now.

[vjeux]

Badrobot, the sql is working fine. How did you execute it?
I suggest you to login into phpMyAdmin or the tool to handle your database and find the place where to enter a sql command, copy paste the full code and it should work fine.

However if you execute it with php or any other programmation language your website is made of, you should try to execute the query in multiple times. Each ";" means the end of a query, so you should have at the end a script that looks like:

mysql_query("DROP TABLE IF EXISTS `wardb_itemcache`");
mysql_query("CREATE TABLE `wardb_itemcache` (`id` int(32) NOT NULL, `name_en` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1");
[continues with the 4 other tables to create].

I hope that fixes your problem.

As for the icon, we just forgot to drop in the folder, should be fixed really soon.

[badrobot]

Thanks for fast reply.
I was running the query in forum admincp, now I did it in phpmy admin.

Item stats and spell stats work now with ids and also names. Cheers

NPC/Quests sill dont work but they arent that important

[GLStephen]

For those of you working with an ItemStats implementation we've published the diff from our ItemStats that should allow you to setup ItemStats for Warhammer from WarDB.

http://www.guildlaunch.com/extras/wardb_itemstats.html

This code had to be massaged because we use a custom ItemStats implementation, but ours is compatible with the vanilla one available. Make sure you backup before making these edits.

Enjoy!
Stephen

[Adamar]

Images for bbcodes still not working but I will make my own.

This has been fixed.

[Gjeep]

We are using a phpBB port for PHP-Nuke. Any chance you will be adding support for PHP-Nuke, so we can get it working on our site?

[SSSlippy]

Do you have any recommendations for where to hook this into vbulletin instead of doing file edits.

[SSSlippy]

Getting this error.

Warning: file_get_contents(http://www.wardb.com/ajaxIDLookup.aspx?type=1&name=Capitol%20Set%201%20%20Epaulettes) [function.file-get-contents (http://immortal-guild.net/vbtest/function.file-get-contents)]: failed to open stream: HTTP request failed! in [path]/includes/class_bbcode.php on line 2493

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(*) AS count
FROM attachment
WHERE posthash = '92016412d2bb8279d1dba8158fd09235'
AND userid = 2262;

MySQL Error : MySQL server has gone away
Error Number : 2006


Im not sure what the code u have for vbulletin is but it rips a dedicated server apart.

[Adamar]

Getting this error.



Im not sure what the code u have for vbulletin is but it rips a dedicated server apart.

It's very simple code, which is used to power the tooltips on this site. Are you sure you installed it correctly?

[vjeux]

Warning: file_get_contents(http://www.wardb.com/ajaxIDLookup.as...0%20Epaulettes) [function.file-get-contents]: failed to open stream: HTTP request failed! in [path]/includes/class_bbcode.php on line 2493

This errors says that the server could not access the wardb server to get the requested file. There must be something that block the script like a firewall or a bad configuration.


Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(*) AS count
FROM attachment
WHERE posthash = '92016412d2bb8279d1dba8158fd09235'
AND userid = 2262;

MySQL Error : MySQL server has gone away
Error Number : 2006This error does not come from our script.
Do you have any recommendations for where to hook this into vbulletin instead of doing file edits.You can use the Light (http://www.wardb.com/syndication/vbb-3.7.3_light_install.html) version of the installation. The downside is that you won't be able to insert the name of the item to display it, you will have to find the id and type [/b]]123456 (instead of [/b]]Sword of the Wind)

[galahadkoa]

I installed the Warhammer DB itemstats code for phpbb version 3.0.2

When I try using any of the BBCode I get the following error:

phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 652: file_get_contents() [function.file-get-contents (http://www.allianceknights.net/forum/function.file-get-contents)]: URL file-access is disabled in the server configuration
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 652: file_get_contents(http://www.wardb.com/ajaxIDLookup.aspx?type=6&name=Unstoppable%20Juggernaut) [function.file-get-contents (http://www.allianceknights.net/forum/function.file-get-contents)]: failed to open stream: no suitable wrapper could be found


I looked up the function.file-get-contents error and it pretty much says the php.ini file for the server is set to not allow this type of content to be posted. I searched the server host website knowledge base and it pretty much says this has been disallowed intentionally because its a huge security risk, but we can create our own custom ini file or use something called cURL, but almost none of that stuff makes any sense. Is there any way to get past this to actually allow this to show on our forums or am I pretty much screwed?

Thanks!

Edit: I was able to get the Light version to work. The pictures, colors, and tooltips for all Items, Spells, and Abilities works fine. I dont know why the server blocks the other way because I would very much prefer to use that.

NPC's and Quests only show as a link that says NPC# 456 or Quest #5634.
Is that correct or should it be showing the quest name?

[chninkel]

Great work from the wardb.com ppl :)

I've added support on my forum, which is in .NET (yetanotherforum.net)

http://www.skarr.biz/forum/Default.aspx?g=posts&t=60


Still need to do some finetuning, but if anyone's interested I can put the code here.
Though you'll have to manually change source code, since it doesn't support the kind of automatic scripts from other forums.

[vjeux]

galahadkoa, your hosting does not allow the use of the function file_get_contents which is collecting some informations from the wardb servers. I doubt cUrl (that basically does the same thing as file_get_contents) would be allowed if the first one isn't.

What i suggest you is either keep the light version, either change your host with one that allows the function file_get_contents.

As for the Quest and NPC not being replaced, this is being investigated.

[badrobot]

Item/spell stats dont work on my vb forum (http://www.warhammeronline.ro/forum/showthread.php?t=106) anymore.

I didnt make any change and they did work after I installed them a couple of days ago.

Or maybe you guys update the javascript code as its loading slow anyways.

[Tophet]

In changing from the "Light" version to the "Full" version. I somehow managed to mess up something. It works fine, but I get this silly return for each new item linked:

"Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in" Is what I get.

Here is the area of contention:

function wardb_getIdFromName($database, $type, $name)
{
global $ipsclass;
$name = str_replace(''', "'", $name);
$name = str_replace(''', "'", $name);
$name = str_replace('!', "!", $name);
$result = mysqli_query($ipsclass->DB->connection_id, "SELECT `id` FROM `".$database."` WHERE `name_en` = '".str_replace("'", "\'", $name)."'");
if ($row = mysqli_fetch_array($result)) {
return $row[0];
} else {
$rname = urlencode($name);
$rname = str_replace('%26quot%3B','%22', $rname);
$rname = str_replace('+','%20', $rname);
$id = file_get_contents("http://www.wardb.com/ajaxIDLookup.aspx?type=".$type."&name=".$rname);
if ($id != "" and $id != "0") {
mysqli_query($ipsclass->DB->connection_id, "INSERT INTO `".$database."` SET `name_en` = '".str_replace("'", "\'", $name)."', id = '".$id."'");
return $id;
} else
return 0;
}
mysqli_free_result($result);
}
WTB [code] ='(


Oh, also: This is on IPB.

[Pedesvir]

Just a post to say a huge thanks to all involved in creating the code used for this. I have (and I am a novice coder), got it all working on both SMF and my Regiments blog.

Although, my blogs theme, really doesnt do it justice. Any tips to get it to display better - or should I bite the bullet and switch themes? (Link (http://handsofjustice.co.uk/hojblog/))

[Sanklovich]

the CSS on your site should be tweaked, it currently provides a background color for all <span> elements, which is causing the tooltips to appear strange

[Pedesvir]

the CSS on your site should be tweaked, it currently provides a background color for all <span> elements, which is causing the tooltips to appear strange

Excellent - thanks. I'll look that up and sort it out.

Cheers for the assistance.

[rendl42]

Thanks all who are contributing to this awesome tool.

I've just installed this on my vbulletin board but haven't got it working just yet. I have a feeling that the javascript isn't loading properly in the headinclude template.

When I try an in form link using "[spell] id [spell]" it simply comes back with Warhammer Online Spell. Also, I don't see the bbcode icons in the messagebox.

The javascript is place in headinclude template as follows:

<!-- CSS Stylesheet -->
$style[css]
<if condition="is_browser('opera') AND !is_browser('opera', '8.0.1')">
<style type="text/css" id="vbulletin_opera8fix_css">
ul, ol { padding-$stylevar[left]:20px; }
</style>
</if>
<if condition="$show['editor_css']">
$editor_css
</if>
<!-- / CSS Stylesheet -->

<script type="text/javascript" src="http://www.wardb.com/js/extooltips.js" ></script>

<script type="text/javascript" src="$stylevar[yuipath]/yahoo-dom-event/yahoo-dom-event.js?v=$vboptions[simpleversion]"></script>
<script type="text/javascript" src="$stylevar[yuipath]/connection/connection-min.js?v=$vboptions[simpleversion]"></script>
<script type="text/javascript">

And here is a link to my class_bbcode.

http://www.wpguild.com/downloads/class_bbcode.php.txt

I will run through the entire install process again to check, but if you see anything obviously wrong, please let me know.

Thanks Curse.com for this sweet script!

[Tymedx]

added in a latest drop item menu w/ warhammers links and member can also update their gear via their profiles and when you view their profile it will show their gear.

[Tymedx]

is there anyway i can still use the item link to show the mouse over but make it redirect to different url instead of the wardb of the item?

[rendl42]

is there anyway i can still use the item link to show the mouse over but make it redirect to different url instead of the wardb of the item?

I looked at the same thing. Though there may be around it, seems that those links are handled in the hosted .js.

[chninkel]

is there anyway i can still use the item link to show the mouse over but make it redirect to different url instead of the wardb of the item?

modify the functions wardb_item, wardb_spell, ...
The <a href /> is created there

so instead of
return '<a class="wardb-item-'.$modifier.'" href="http://www.wardb.com/item.aspx?id='.$id.'">'.$name.'</a>';


you put your own url in the href attribute

[Tymedx]

modify the functions wardb_item, wardb_spell, ...
The <a href /> is created there

so instead of


you put your own url in the href attribute

ummmmmm it wont provide the mouse over tool tip then

[chninkel]

ummmmmm it wont provide the mouse over tool tip then

I tested it and you're right :)

I did find a way around it, though it requires you to use a local copy of extooltips.js and modify it.

On top of the changes you did earlier:


replace
Curse.WHO.Syndication.prototype={baseURL:http://www.wardb.com/,
with
Curse.WHO.Syndication.prototype={baseURL:"http://www.wardb.com/",baseURL2:http://www.myownurl.com/,

replace
new RegExp("wardb\\.com\\/(item|spell|quest)\\.aspx\\?id=(\\d+)");
with
new RegExp("myownurl\\.com\\/(item|spell|quest)\\.aspx\\?id=(\\d+)");

Attention if your domain isn't .com, also replace .com with whatever

replace
a.href=this.baseURL+"spell.aspx?id="+spell.id;
with
a.href=this.baseURL2+"spell.aspx?id="+spell.id;

replace
a.href=this.baseURL+"item.aspx?id="+item.id
with
a.href=this.baseURL2+"item.aspx?id="+item.id


not sure if we're allowed to change the .js file though

[Kumnaa]

Is there a function that can be called that will 'refresh' the items on the page. My custom written forums use javascript to edit posts in page and when I add the <a> links they aren't getting transformed to the tooltip'd links. I am assuming that this is because the elements are being added after page load.

Thanks,

Kumnaa

[Tymedx]

I tested it and you're right :)

I did find a way around it, though it requires you to use a local copy of extooltips.js and modify it.

On top of the changes you did earlier:



not sure if we're allowed to change the .js file though

tired that , didn't work the item just disappears when i change the url to url2

[rendl42]

So with some more testing, I found that the following works perfectly on vbulletin 3.7.3:

Items: <a href="http://www.wardb.com/item.aspx?id=435134">Warlord Flamerobe</a> (Warlord Flamerobe)

But the bbcodes dont work. So the .js is obviously loading but seems the bbcode being picked up and parsed.

[Ashaltiriak]

First of all, thanks to Adamar and Curse.com for this cool feature. I really appreciate you guys sharing this for all of the community, especially taking the work and adapting the scripts for 5 different forums. Cheers!

Got it installed and working on IPB (after I discovered that my host is still using PHP4 and rewriting the php part a bit). It just looks a little awkward, since the text is centered and the left padding is a bit messed up:
http://www.fama-nefas.de/index.php?s=&showtopic=6119

I guess this is because of some styles overwriting the itemlink styles, but I can't figure out which one is causing trouble.

Any ideas?

[chninkel]

tired that , didn't work the item just disappears when i change the url to url2

What's the new url you're pointing too ?

probably a regex problem in .js file

[GalloInfligo]

$text = preg_replace("#\[waritem\](.*?)\[/waritem\]#si", '<a class='wardb-item-full-medium' href='http://www.wardb.com/item.aspx?id=\\1'></a>', $text);
$text = preg_replace("#\[warquest\](.*?)\[/warquest\]#si", '<a class='wardb-quest-full' href='http://www.wardb.com/quest.aspx?id=\\1'></a>', $text);
$text = preg_replace("#\[warnpc\](.*?)\[/warnpc\]#si", '<a class='wardb-npc-full' href='http://www.wardb.com/npc.aspx?id=\\1'></a>', $text);
$text = preg_replace("#\[warspell\](.*?)\[/warspell\]#si", '<a class='wardb-spell-full-medium' href='http://www.wardb.com/spell.aspx?id=\\1'></a>', $text);


I still can not get the quest or npc one to work, but the item and spell one works just fine....any ideas?

[Tymedx]

What's the new url you're pointing too ?

probably a regex problem in .js file


If you go to my website www.dread-guild.com (http://www.dread-guild.com) you will see a Latest drops link on the right side of the website.

I am trying to get thoes to be hover over icons but at the same time link to

http://www.dread-guild.coml/viewitem.php?sid=&item={itemit.ID}

itemit.ID pulls from the database the id of the item, im not even sure it will work in the .js file, but it works in the .html templates that are used to build teh website so i dont see why it wouldn't work in the .js file

even if i couldn't get it to link to that even linking to something like
http://www.dread-guild.com/listitems.php (http://www.dread-guild.coml/listitems.php) would be good

[GLStephen]

Has anyone tried using this script with Lightbox? We're finding that it nocks out our Lightbox script in IE.

-Stephen

[Perce]

Anybody get this working on PunBB yet? I havent had time to really give it a go, and im no programmer so I know if I try to do things, its going to take me a looooong time if I can do it at all :-/

[Kino]

Hi, I read this whole post, is there any plans for PHPnuke Integration, It uses PHPbb2.x...

If it could be possible for the news section aswell as the forums that would be awsome!

[Vegetta]

Items, quests and spells all work/link flawlessly in SMF forum in firefox. NPC only display a link (no icon no mouseover) the link does work however and will take you to the item on the wardbsite.


In IE icons are not displayed and the pop up for quests is double the width it should be (it repeats the background box)


UPDATE silly me IE6 doesnt display .png files - Works fine with ie7 and SMF Also in ie7 the quest pop up box is the proper size

[MasterEvilAce]

Hey, I'm using PHPBB 3.0.2, and I just set it up as per http://www.wardb.com/syndication/phpbb-3.0.2_install.html

However, custom bbcodes do not work anymore unless there is also a wardb tooltip included in a post somewhere on the page (or maybe it has to be the same post? not sure of this)

my custom bbcodes are just like [~center]centerthis[/center] tags

[Ataris]

Hello, I've looked through the thread and not found anyone with a similar problem.

I am using a full install on phpBB 3.0.2 and everything -seems- to work ok. Whenever I put up an item tag for an item name, all I get is a link to the item on WarDB. I simply get no tooltips showing up. I get no error messages at all.

Any suggestions are welcome, thank you for your time.

[itzmiko]

Hello, I've looked through the thread and not found anyone with a similar problem.

I am using a full install on phpBB 3.0.2 and everything -seems- to work ok. Whenever I put up an item tag for an item name, all I get is a link to the item on WarDB. I simply get no tooltips showing up. I get no error messages at all.

Any suggestions are welcome, thank you for your time.


First things first...Awesome, big ups to wardb.com

Second, im having the same exact problem, ran through the full setup for phpbb and i only get item names with a link, no images or mouseover details

item#

is the code im using, anyone know how to correct this?

[itzmiko]

First things first...Awesome, big ups to wardb.com

Second, im having the same exact problem, ran through the full setup for phpbb and i only get item names with a link, no images or mouseover details

item#

is the code im using, anyone know how to correct this?

Figured it out...stupid phpbb template cacheing.

ACP -> Styles -> Templates -> {Template Name} Cache -> Select All -> Delete

Tada!

Maybe we can get someone to post this on install page so other people dont run into this?

[MasterEvilAce]

Hey, I'm using PHPBB 3.0.2, and I just set it up as per http://www.wardb.com/syndication/phpbb-3.0.2_install.html

However, custom bbcodes do not work anymore unless there is also a wardb tooltip included in a post somewhere on the page (or maybe it has to be the same post? not sure of this)

my custom bbcodes are just like [~center]centerthis[/center] tags


Anyone have any ideas on this???? Apparently [url] doesn't even work anymore. Probably going to have to uninstall this if nobody knows

[swh]

galahadkoa, your hosting does not allow the use of the function file_get_contents which is collecting some informations from the wardb servers. I doubt cUrl (that basically does the same thing as file_get_contents) would be allowed if the first one isn't.

What i suggest you is either keep the light version, either change your host with one that allows the function file_get_contents.

As for the Quest and NPC not being replaced, this is being investigated.

Generally speaking most web hosts offer cURL because it is safer than get_file_contents/fopen and other functions.

If you would like to use the full integration and you only have access to cURL then replace the following functions (wardb_getNameFromId & wardb_getNameFromName) in bbcode.php.

http://www.aonxe.com/curl-syndicate.txt

This isn't the best way to do cURL but it works.

[Xoulz]

Not sure if something broken, but links (icon or not) isn't working on this message board.

Unless the tools above are not correct..?

test:

id=1902

[rendl42]

If you are using vBulletin with vbSEO linking will not work.

You must modify the config_vbseo.php. Find the following:

Redirect ALL External URLs Posted in Private Forums

And set it to no.

[Arasius]

I got this error trying to install on IPB 2.3.5

Fatal error: Call to undefined function mysqli_query() in /home/xxx/public_html/xxx.com/forum/sources/action_public/topics.php on line 2646

line 2646 is this one:

$result = mysqli_query($ipsclass->DB->connection_id, "SELECT `id` FROM `".$database."` WHERE `name_en` = '".str_replace("'", "\'", $name)."'");


i have checked my DB and all wqardb tables are empty....

Could someone help me?

Ty in advance

[Tipjip]

Figured it out...stupid phpbb template cacheing.

ACP -> Styles -> Templates -> {Template Name} Cache -> Select All -> Delete

Tada!

Maybe we can get someone to post this on install page so other people dont run into this?

After running into the same symptoms like you and not being able to solve it the same way as you I (finally) found another possible source for the problem: The Code apparently isn't compatible with every Style! While it works fine with the standard subsilver theme it doesn't work with "Dark Fantasy" which was my default at the time.

Regards,

Tipjip

[Kalamere]

I got this working a while ago on my forums (IPB 2.3.5, here (http://www.dreadwing.org/index.php?showtopic=691&st=0&p=5712&#entry5712)), and only just noticed that the javascript file seems to be conflicting with other javascript files in the forum software. Dropdowns/popups don't seem to work in internet explorer, Safari, Opra etc, but they are fine in Firefox. Anyone know what might be causing this problem?Sorry to be so late to the game here. The thread's been inactive awhile and that comment was ages ago. That said, I read through and didn't see a direct response to it and from my own experience this issue still exists.

If you have the same issue I do, the cause is the part of the script that adds the array prototype indexOf. Doing that (or, really, adding any prototyping to array) breaks the ability to do for(in) loops on an array. Correct me if I'm mistaken, but this is where the research has led me thus far.

In my case the issue should be resolvable by using an object instead of an array, which I should have been doing anyway. It's my own script though and something I can fix myself. Those of you experiencing this with forum software and such that you don't have control over have a more difficult battle to fight.

[Zyxlei]

[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 654: file_get_contents() [function.file-get-contents]: URL file-access is disabled in the server configuration
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 654: file_get_contents(http://www.wardb.com/ajaxIDLookup.aspx?type=4&name=Fragile%20Light) [function.file-get-contents]: failed to open stream: no suitable wrapper could be found
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3549: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2975)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3551: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2975)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3552: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2975)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3553: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2975)
Is appearing at the header of any page I link on. I have a page that I originally tested links on, and those work fine. You can see that here. (http://griftersguild.com/forums/viewtopic.php?f=5&t=2&start=0)

But Here is a page that I tried to put a link on today (http://griftersguild.com/forums/viewtopic.php?f=35&t=100&p=427#p427), and you can see there errors up top. (I left it all errored out so you could see it)

Anyone have a clue to fixing this?

TIA

[swh]

Is appearing at the header of any page I link on. I have a page that I originally tested links on, and those work fine. You can see that here. (http://griftersguild.com/forums/viewtopic.php?f=5&t=2&start=0)

But Here is a page that I tried to put a link on today (http://griftersguild.com/forums/viewtopic.php?f=35&t=100&p=427#p427), and you can see there errors up top. (I left it all errored out so you could see it)

Anyone have a clue to fixing this?

TIA

Your server doesn't seem to have fopen avaliable. Try cURL. (http://www.warhammeralliance.com/forums/showpost.php?p=1914165&postcount=149)

[Kardac]

OK...

I am using an e107 site, and was able to get linking in no problemo with a little work:
Here's instructions for anyone else that may be on e107 or incase it might help anyone else figure some stuff out:

I edited line 37 of /e107_handlers/bbcode_handler.php to include 'warlink' (so I can use [~warlink]id[/warlink])

Then I created a file called warlink.bb in the /e107_files/bbcode directory. here is the full code:


All is awesome, I can get links to either items or spells with the tooltips by using [~warlink=item]id[/warlink] or id

This is evidenced by this link (http://www.templeofkhaine.com/e107_plugins/forum/forum_viewtopic.php?7.last)

P.S. I hope this helps someone

Didnt get it to work. Did as you wrote in your post, but when i use 640228 it doesent even display the itemnumber.

Maybe im doing it wrong?

http://norroner.com/e107_plugins/forum/forum_viewtopic.php?12618