This site makes extensive use of JavaScript.
Please enable JavaScript in your browser.
Live
PTR
10.2.7
PTR
10.2.6
Beta
Add Wowhead tooltips to your forums or CMS.
Return to board index
Post by
Lockslap
Just a quick update about the progress with the
WOTLK
site integration. I have finished adding the necessary code to the Wowhead class to be able to handle the new quests/items/spells, and currently I am working on adding it to parse.php to actually be able to handle the new stuff.
Please note, there is no multiple language support for the WOTLK portion of the script. Currently, only English is supported (same as on Wowhead's website).
I am still working out how to handle the new quality type (for BoA items), and a few other kinks, I hope to have a working version uploaded later today.
Post by
Lockslap
Another update!
Wowhead has released a
Russian
version of their site, so I am going to hold off releasing 2.4 until I can get it added and tested. Also, I am going to have to figure out how achievements are handled and make it possible to search for them as well, so it may be a couple of days or so until I get things figured out/added.
On the good side of things, WOTLK is now officially supported by the script. Items, quests, and spells are now supported!
Post by
Lockslap
Version 2.4 Released
Well I was really anxious to get the
WOTLK
portion of the script released, so I decided to release it even though the Russian language is not currently supported by the regular portion of the script.
Here's how to use it:
Items:
{item name or id}
Quests:
{quest name or id}
Spells (w/o rank):
{spell name or id}
Spells (w/ rank):
{spell name}
AND introducing Achievements:
{achievement name or id}
In order to use this version you must replace
wowhead.php
,
parse.php
, and
wowhead.css
and then run
create_table.php
(if you're using item cache). I had to change the MySQL table yet again in order to tell the script which site to use (specific language, or WOTLK site), I also adjusted it to a different character set in anticipation of the
Russian
language being supported (not in this release though, version 2.5).
As for Russian support, it seems the script is unable to return results because of the encoding the script uses to get the items/quests/spells, so I am trying to find a workaround, or I may have to add a special method just for Russian support. Unfortunately, when it comes to character sets and languages I am generally bad at dealing with and fixing, so just bare with me.
Other than that, I am really proud of this release! If you have any questions, comments, flames, fixes, bugs, e-hugs, gold, etc. please feel free to post in this thread.
Enjoy!
craCkpot
P.S. I am aware that the Changelog portion of the script's website is screwed, I am working on fixing it. Damn Unix timestamps....
Post by
Skosiris
Good job craCkpot :D
Post by
Lockslap
Good job craCkpot :D
Thank you, sir. I must say that I am quite proud of what this script has become, when I originally created it for my own personal use. Good to see the positive feedback and comments I have gotten since the initial release back in February.
Post by
205789
This post was from a user who has deleted their account.
Post by
Lockslap
Hello, craCkpot!
As for Russian support, it seems the script is unable to return results because of the encoding the script uses to get the items/quests/spells, so I am trying to find a workaround, or I may have to add a special method just for Russian support. Unfortunately, when it comes to character sets and languages I am generally bad at dealing with and fixing, so just bare with me.
If you need any help with encodings: cp1251 (Windows-1251), utf8, koi8-r, etc... - I'm ready to help you out. I'm holding phpBB forums, and I use your mod, so I'm intrested ;)
I'm still looking into what's going on, but I have a suspicion as to what's going on. Tomorrow I intend on digging into it (after raiding, of course) and either fixing or finding a workaround. I may just have to code a special part of the class to be able to support the Russian language.
Post by
aesyl
Version 2.4 gives a MySQL error when trying to use or SQL ERROR
Field 'lang' doesn't have a default value
SQL
INSERT into `phpbb_wowhead_cache` ( `id`, `itemid`, `name`, `search_name`, `quality`, `rank`, `type`, `wotlk` ) VALUES ( NULL, 40384, 'Betrayer of Humanity', '40384', 4, NULL, 'item', 1 )
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()
FILE: wowhead/parse.php
LINE: 118
CALL: dbal_mysql->sql_query()
FILE: wowhead/parse.php
LINE: 323
CALL: whp_wotlk_parse()
FILE: includes/functions_content.php
LINE: 695
CALL: whp_parse()
FILE: includes/message_parser.php
LINE: 1193
CALL: bbcode_nl2br()
FILE: posting.php
LINE: 1032
CALL: parse_message->format_display()
When using and it returns a blank page.
Post by
Lockslap
Version 2.4 gives a MySQL error when trying to use or SQL ERROR
Field 'lang' doesn't have a default value
SQL
INSERT into `phpbb_wowhead_cache` ( `id`, `itemid`, `name`, `search_name`, `quality`, `rank`, `type`, `wotlk` ) VALUES ( NULL, 40384, 'Betrayer of Humanity', '40384', 4, NULL, 'item', 1 )
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()
FILE: wowhead/parse.php
LINE: 118
CALL: dbal_mysql->sql_query()
FILE: wowhead/parse.php
LINE: 323
CALL: whp_wotlk_parse()
FILE: includes/functions_content.php
LINE: 695
CALL: whp_parse()
FILE: includes/message_parser.php
LINE: 1193
CALL: bbcode_nl2br()
FILE: posting.php
LINE: 1032
CALL: parse_message->format_display()
When using and it returns a blank page.
Thank you for bringing this to my attention. MySQL didn't like that I had the table setup so that 'lang' could not be
NULL
(no value), which wasn't a problem when not using WOTLK queries, but now that WOTLK only supports English, and I have omitted it from the SQL query, it becomes a problem. On a good note, this issue has been fixed and it also brought to my attention another problem with spell ranks, so I killed 2 birds with one stone.
You can get the latest version
here
, as always you must run 'create_table.php' in order to update your MySQL table (this will also clear your table).
I am working on fixing the script's site, and then I will tackle the Russian language support.
EDIT
Okay the changelog on the script's site is now fixed. Apparently MySQL and PHP handle dates differently...who knew? LOL. Now I will see what's going on with Russian language support.
EDIT #2
It appears as though my script is unable to get the information from Wowhead when using the Russian language. I'm not sure if this is a bug in the Wowhead site (confirmation?), or this is intended, or it is a problem on my end (highly possible). If I could get some feedback on the Wowhead side of things that would be most helpful.
Allow me to clarify what's going on: I am trying to do:
http://ru.wowhead.com/?item=
{insert item name here}&xml (like I am able to do with any of the other languages supported) and regardless of what I do in terms of encoding, etc. it always returns a not found response. As I have said in a previous post, I am not used to using other languages in my scripts, so I am kind of feeling my way through. Unfortunately, I have hit a wall and am unable to find a workaround. Oh mighty Skosiris I beseech thee to bless thy wisdom upon me. Hehe, that's sounds cool!
Post by
205789
This post was from a user who has deleted their account.
Post by
Lockslap
Omg...
http://ru.wowhead.com/?item=
{insert item name here}&xml will result in url-encoding, like
Нога (Leg -- rus.) is %D0%9D%D0%BE%D0%B3%D0%B0 ...
Am I diggin' in a right way? :D
You're correct sir.
Post by
Lockslap
I have decided that I wish to branch the script out to support other forum/CMS software, so I would like to get your input as to what software it should be ported over to next. If I get enough requests I will install the given software on my personal website and then begin working on writing parse.php for it. So if you're using something other than phpBB3 and would like to use this script, then post what you use here and I will get a working version for ya!
If you would like to discuss other options please feel free to contact me at admin@crackpot.us, or via X-Fire (username: cr4ckp0t) and we'll see what we can work out.
EDIT
I am going to go ahead and install vBulletin, Invision Power Board (I think that's what its called), and Joomla on my personal website and begin working on getting this script adapted to work.
Post by
aesyl
Items and achievements are working now. is not working at all, when using a name it says the quest is not found, when you use an ID# it returns a blank page.
Post by
Lockslap
Items and achievements are working now. is not working at all, when using a name it says the quest is not found, when you use an ID# it returns a blank page.
Are you using any third-party mods?
I'm afraid I can't help much if the script and/or phpBB aren't throwing up any errors/warnings.
As you can see on my
test forum
the script is working as it should. I'm assuming you're running the same exact version as I am (2.4.1).
Perhaps a link to the forum in question would allow me to better see what's going on.
Post by
aesyl
phpbb 3.0.1 no mods.
http://aristocracy.dyndns.org/forums/
If you go to the Random Stuff forum and click on the thread titled 'Testing' you can see what happens when I do 11718. A Bot in Mammoth's Clothing just says the quest isn't found. It's the same quest you use on your test forum.
Post by
Lockslap
I'm not sure what's going on, I have installed the same theme you use on your forums on the testing forum and the script is still working as intended.
Does the normal part of the script work as intended? And are you using an item cache? One thing you could try is using the default phpBB theme (prosilver) and see if that has any effect.
Post by
aesyl
Does the normal part of the script work as intended?
Yes
And are you using an item cache?
Yes
Using prosilver had no effect.
Post by
219816
This post was from a user who has deleted their account.
Post by
Lockslap
Does the normal part of the script work as intended?
Yes
And are you using an item cache?
Yes
Using prosilver had no effect.
I really wish I could help, but without actually being able to look at the code on your site I'm afraid I can't offer much help. I have tried many things to be able to duplicate the problems you're having on the testing forum, without any luck. You could try to clear your cache...I doubt it would have any effect but it couldn't hurt.
EDIT
On second thought, try disabling your cache. Perhaps it has something to do with MySQL.
Oh by the way, concerning you're forum, I would highly recommend that you force the people who register at your site to activate their account before actually being able to login. Otherwise you will (eventually) get a lot of spamming accounts created. It got so bad on my forums that we had to enable admin activation.
Hello, help to understand... On a forum phpbb3 has established the given script, menus well, but colour in the name of subjects dark blue open how to make what it automatically changed according to quality of a subject? It is possible to look here
http://klan-teney.ru/forum/viewtopic.php?f=5&t=35
You're not actually using my script. You're basically providing the URL to Wowhead's JavaScript and it is providing the tooltip. It does not color the links automatically, that is done with other HTML tags.
Post by
aesyl
Disabling the cache didn't do anything.
Post Reply
This topic is locked. You cannot post a reply.