Add Wowhead tooltips to your forums or CMS.

Post by Lockslap

@loodinek: It won't "look" like anything. MySQL can be a bitch if you don't have any background experience in using it. I personally use phpMyAdmin, which makes everything easy. This script will only create the necessary tables that it needs to function, it cannot create the database and username/password for you. That you will need to do in your control panel, or speak with your host.

@criodor: I am unfamiliar with what does. I'm assuming it has something to do with the icon? If so, then you're speaking about ItemStats (or something like that), which created its own popups when you moused over a link. I have no intention of doing this, as why would I reinvent the wheel when Wowhead's tooltips are pretty and extremely functional. If I am wrong about what you're referring to then let me know, and I'd be happy to look into it.

I have gone over the code on this script at least 1,000 times trying to figure out why it won't show threads/posts for people when using the item cache. I have been unable to find any reasons as to why this would be happening. So on that note, if anyone is still having any problems and wouldn't mind giving me FTP/website access to see what's going on, then perhaps I can fix it so that it doesn't happen anymore. You can contact me on this page, or via X-Fire, which my name is cr4ckp0t. Any other contact methods are available on my website @ http://www.crackpot.us. I completely understand about giving some stranger access to your website, but without being able to duplicate this problem (which I have tried, many times) I cannot produce a fix for it. I really don't like the fact that this script isn't working for some people, but I can only guess at what the problem would be without actually being able to see it (from a code stand-point).

On a good note I have been creating a few plugins for phpBB3 Portal to display raid information and such, and have finally figured out how phpBB3 handles its MySQL connections. Due to this fact I will be rewriting the SQL portion of the script to allow it to use phpBB3's connection to avoid having to setup a separate database for the item cache. This way the items will sit nicely in a table inside of phpBB's database, and not create any problems with them being in the same database. It will create problems with how the manage_cache.php functions, but overall it should be a great change/fix. I will post it as soon as I code and test it.

EDIT
I have released the new version that uses phpBB's connection, and it is working as intended. I have tested it as much as I could, so if you encounter any problems please let me know. Installation of this version will render your old cache useless, so it will have to cache the item's again. I also redid create_table.php to automatically create the table inside of phpBB's database, so make sure everything is setup properly. These changes have rendered manage_cache.php useless, hence why it is not included in the newest ZIP file, so do not attempt to use it after installing this version of the script.

As always, if you have any problems please let me know.

Post by 148966

This post was from a user who has deleted their account.

Post by 148118

This post was from a user who has deleted their account.

Post by Lockslap

With wowhead's current setup, its not possible. The only way to do it is to capture a search page with the spell, which would take a lot of time, especially if you have a lot of spells on one post. I am working on a way to use more efficient methods. I am learning a new method of querying other websites using cURL, we'll see how it works.

Post by 149926

This post was from a user who has deleted their account.

Post by aesyl

I had the same issue, only I changed it to:

$dummy = $db->sql_query("INSERT INTO phpbb_wowhead_cache (itemid, name, search_name, link, quality) VALUES ('$itemid', '" . addslashes($f_name) . "', '" . addslashes($name) . "', '" . addslashes($link) . "', '$quality')");

Caching wasn't working at all for me before this update, now except for this quick fix it's working beautifully.

Post by 150396

This post was from a user who has deleted their account.

Post by Inchhigh

I was having the same problems here, i was running a localhost version of my board for upgrade purposes, using the same setup my hosting has.

After a few hours of scratching my head, i finally fixed my issue on the the localhost, i reistalled and did a convert from my old phpbb2.x and changed the SQL option to MySQL, previously i had MySQL & MySQLi enabled, and that was the only change i made on the reinstall and that fixed.

I dont know if that helps any, but as i said it was the only change i made to the local board, i set the same option on Hosted version and that was also running fine...

Post by 68116

This post was from a user who has deleted their account.

Post by 151984

This post was from a user who has deleted their account.

Post by 150396

This post was from a user who has deleted their account.

Post by 68116

This post was from a user who has deleted their account.

Post by stolenaggro

ok i upgrated my forum to the 3.1 version
reinstaled a new theme
and of course followed all instrucions again here.

the phpbb3 files was new ones, but the database was old
but the create_table.php said was susseful on creating the table, but now every post that have the tag , just crash and i got this error

SQL ERROR

Incorrect integer value: '' for column 'id' at row 1

SQL

INSERT INTO phpbb_wowhead_cache VALUES ('', '33492', 'Trollbane', 'Trollbane', 'http://www.wowhead.com/?item=33492', 'Epic')

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: wowhead/parse.php
LINE: 65
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_content.php
LINE: 694
CALL: whp_parse()

FILE: viewtopic.php
LINE: 1269
CALL: bbcode_nl2br()

its possible it said susseful, but still using old tablle?

Post by CthulhuDragon

I've installed this on my board and it works fine for the most part. I am having trouble using an external css however. I wanted to change the colors of the common items to show up better on a light background, but when I change $external_css= true, all the common items show up as an orange color, but no other changes are present. It doesn't matter what colors I set in the css file, the ones on the board don't change even after I clear the cache.

And idea what the problem could be? I've double checked that I've changed everything as instructed. I'm stumped.

Edit: It appears to work ok when I set the $external_css to false and set the quality array to "common". Doesn't work if I just have external_css to true.

Post by JCinDE

Maybe I'm just blind but I can't find the phpBB2 instructions everyone refers to. Can you help me out here?

Post by Lockslap

Maybe I'm just blind but I can't find the phpBB2 instructions everyone refers to. Can you help me out here?
It is located in a previous post located in this topic.

I've installed this on my board and it works fine for the most part. I am having trouble using an external css however. I wanted to change the colors of the common items to show up better on a light background, but when I change $external_css= true, all the common items show up as an orange color, but no other changes are present. It doesn't matter what colors I set in the css file, the ones on the board don't change even after I clear the cache.

And idea what the problem could be? I've double checked that I've changed everything as instructed. I'm stumped.

Edit: It appears to work ok when I set the $external_css to false and set the quality array to "common". Doesn't work if I just have external_css to true.
Set external_css back to true, and then make sure the quality array is empty. Then view a post that has items linked int it. Next view the source and post here the code that shows up for the post's body. It should start with <div class="content">
This will tell me exactly what the script is doing, because I have been unable to duplicate such a problem.

On a good note (hopefully), I have updated the script to function properly with MySQLi or MySQL. To do this it will use your 'config.php' file that phpBB uses and check what database it is using (either 'mysql' or 'mysqli') and then it will use whichever function is required.

Also included in this update/fix is a MySQL query fix for those getting the errors with the INSERT query sent to MySQL after finding the item. The one saying invalid integer. Again this is due to MySQLi being picky about their queries (and partly due to me being lazy), but it is fixed as well.

You can download the newest version by going to http://downloads.exhume-guild.com/?dl=wowhead.zip

As always, thank you very much for the positive feedback and bug reports that you guys have given me. Hopefully, this will fix most of the errors/bugs with the code so that it works on all phpBB installations that use MySQL/MySQLi as their database. If not, please be sure to let me know by posting in here.

Thanks,
craCkpot

Post by Lockslap

I am hard at work once again adding functionality to link quests and spells. The only problem is that for the time being I can only use the quest's/spell's corresponding id in order to link it. Unfortunately, there's no way around this at this point in time, but some functionality is better than none.

The quest portion is completed. I am still working on the spell part.

Stay tuned!

EDIT I have written the portion for the spells and now it is available for use (and testing). It works much the same way that works except that it only allows the item's ID between the tags. This is not because I'm lazy, but rather the way that Wowhead handles spells and quests is different from their items, so I had to adapt to make it work. Be happy, I have yet to see any other scripts with this functionality (=D). See below for examples.

Spells: 27229 would make
Quests: 11877 would make

And so on! To get the spell/quest's ID simply goto its page on wowhead and look for the portion after the = in the URL.

As always you can download the latest version from http://downloads.exhume-guild.com/?dl=wowhead.zip

And also, if you have any problems or questions/comments feel free to post.

Thanks,
craCkpot

Post by Mikey7047

Hey Crackpot I'm wondering if you can help me, I get a

Parse error: parse error, unexpected T_IF in /home/content/m/v/a/mvarrieur/html/forum/includes/functions_content.php on line 1

After making your modifications whenever visiting my forums. I have added you on xfire and AIM hopefully see you on at some point today. I will try to stay logged in all day if you could just shoot me a message when you get on. I'm making a secondary FTP account so that you can just login and make whatever changes you want, if you want.

EDIT: Actually if you see this could you email me and I'll send over the FTP info? (Mikey7047 at gmail dot com)

Post by Lockslap

It seems that you have modified part of the code that doesn't need to be modified. By the error you posted, you have modified

if (!defined('IN_PHPBB'))
{
exit;
}

That should be at the top of your functions_content.php. The include_once() line should be added on the next line after the "}".

Post by Lockslap

A little teaser for you guys. I have devised an efficient way of searching Wowhead for spells and/or quests. I have a working example at http://www.exhume-guild.com/viewtopic.php?f=16&t=147. There still are a couple of minor bugs that I have to work out before I can publicly release it. So stay tuned, I hope to have it released really soon (within the next day or so).

EDIT Okay, the issues with certain search results have been resolved so I will be posting the newest version when I wake up. This is some extensive code, so I'm sure there will be bugs. I'm counting on you guys to find them for me.

As for now, I'm going to sleep, g'night.

Add Wowhead tooltips to your forums or CMS.

Post Reply