vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - World of Warcraft Wowhead Item tooltips for vBulletin (https://vborg.vbsupport.ru/showthread.php?t=183035)

sweede 06-19-2008 10:00 PM

World of Warcraft Wowhead Item tooltips for vBulletin
 
** Discontinued thread !
See https://vborg.vbsupport.ru/showthread.php?t=239911 for current thread in 3.8 modification areas.

sweede 06-20-2008 08:39 AM

0.5.4 has been uploaded.

I noticed today on my test site that if you have existing posts with [item] tags then switch the language setting in the options and you run some of the Update Counter utilities, it clobbers the existing item tags.

That's been fixed as it tries now to do several things before giving up.

KURTZ 06-20-2008 08:53 AM

--cut--

nevermind i'm idiot :D

however just a question Sweede, i read the installation file, it says that we only need to import the product, so what about the upload folder? also what about the template edits that you put into hack's description?

thx

Kinneas 06-20-2008 08:53 AM

Great work sweede :) - I'll install shortly.

Kinneas 06-20-2008 08:59 AM

When trying to overwrite the old version or install the new version from scratch I receive the following:

Quote:

Database error in vBulletin 3.7.1:

Invalid SQL:
DROP TABLE wowitemstats;

MySQL Error : Unknown table 'wowitemstats'

KURTZ 06-20-2008 08:59 AM

Quote:

Originally Posted by Kinneas (Post 1554323)
When trying to overwrite the old version or install the new version from scratch I receive the following:

try to uninstall the previous version then install the new ... :)

Kinneas 06-20-2008 09:01 AM

Quote:

Originally Posted by KURTZ (Post 1554324)
try to uninstall the previous version then install the new ... :)

I did. Same error.

KURTZ 06-20-2008 09:03 AM

Quote:

Originally Posted by Kinneas (Post 1554325)
I did. Same error.

just tried onto a test board this is the result:

Code:

Database error in vBulletin 3.7.1:

Invalid SQL:
DROP TABLE wowitemstats;

MySQL Error  : Unknown table 'wowitemstats'
Error Number  : 1051
Request Date  : Friday, June 20th 2008 @ 12:02:58 PM
Error Date    : Friday, June 20th 2008 @ 12:02:59 PM
Script        : http://www.fniv.it/xxxx/admincp/plugin.php?do=productimport
Referrer      : http://www.fniv.it/xxxx/admincp/plugin.php?do=productadd
IP Address    : xxx.xxxx.xxxx
Username      : admin
Classname    : vB_Database
MySQL Version : 5.0.51a


Kinneas 06-20-2008 09:07 AM

I created that table just to see if that would satisfy the install script, but it still gives the same error (Even though it does drop the table).

Kinneas 06-20-2008 09:10 AM

I bypassed the problematic part of the Install script by removing the DROP TABLE line from the install code, but it still doesn't seem to work. The following plugin for bbcode_create seems to be incomplete:
Quote:

<plugin active="1" executionorder="5">
<title></title>
<hookname>bbcode_create</hookname>
<phpcode />
</plugin>

KURTZ 06-20-2008 09:17 AM

Steve, we need a fix by Sweede :)

Kinneas 06-20-2008 10:21 AM

Well I had a few attempts at fixing it but haven't been able to fully. Guess we'll have to wait for Mr. Sweede :P

Kinneas 06-20-2008 11:23 AM

For the time being I've had to go back to the older version.

Some problems I found with this current version:

The Install Script seems broken. The DB error I mentioned earlier in the thread seems to stem from these lines:
Code:

                <code version="0.5.0">
                        <installcode><![CDATA[$db->hide_errors();
$db->query_write("DROP TABLE ". TABLE_PREFIX . "wowitemstats");
$db->show_errors();]]></installcode>                        <uninstallcode />
                </code>


I'm guessing that just shouldn't be there full stop, as directly below it there's another, longer 0.5.0 install code which also contains the DROP TABLE line.

The bbcode plugin is incomplete, which resulted in no parsing whatsoever. In the product XML it looks like this:
Code:

                <plugin active="1" executionorder="5">
                        <title></title>
                        <hookname>bbcode_create</hookname>
                        <phpcode />
                </plugin>


I think I was able to get past these two problems (Firstly by removing the naughty install code and secondly by using the code from the 0.4.5 plugin in the above), but unfortunately I was still having issues.

Although the items bolded and hyperlinked to the wowhead site, no mouseover popup showed and they didn't change color based on item quality, they were just all bold black.

Also, after installing, the links default to Spanish Wowhead (es.wowhead), which I suppose could have been by design, but then if you go to the Product Settings in ACP the language defaulted is english. Simply clicking save (without changing anything) will then set it to English.

I'm not sure how long these problems would take to fix but it might be worth re-uploading the old version in the meantime Sweede.

sweede 06-20-2008 06:43 PM

:o !

uploaded the previous version, will have a new version up soon.

Caerydd 06-20-2008 09:35 PM

Please don't worry about the crafting database :) If you're busy you're busy, and we're in no hurry. Thank you for continuing the work on this fabulous addon ^^

AndyBaines 06-20-2008 11:43 PM

Installed and seems to be working fine, thankyou. :)

mikeylikesitz 06-21-2008 02:50 AM

doesnt seem to be pulling the rollovers, it shows the item color though

edit: i want to mention that the links made before the update are still working, just not the new links

sweede 06-21-2008 03:17 AM

1) Make sure that Options -> Wowhead Item Stats -> Local power.js is set to No
2) View source of any of your forums web pages, make sure that the line
HTML Code:

<script src="http://www.wowhead.com/widgets/power.js" type="text/javascript" defer="defer"></script>
is in the first few lines (within 10 lines)

If that isn't there, go to Plugins & Products -> Plugin Manager and find the plugin named 'WoWhead template Cache' and make sure that cache_templates is correct (if it isnt, hit edit and select it from the list).

mikeylikesitz 06-21-2008 03:29 AM

sorry, it must be a permission thing, i tried it in my admin forum and got nothing, tried it in the wow forum and it worked fine so all is well

thanks for the update

sweede 06-21-2008 03:32 AM

thats odd.. it shouldnt make a difference. In fact the tooltips should work on any vbulletin page...

mikeylikesitz 06-21-2008 03:36 AM

not sure, it is still that way if you would like to take a look, if not no biggie

KURTZ 06-21-2008 08:22 AM

Sweede, just uploaded and installed your add-on ... unfortunately it doesn't works ... :( it shows only the BBCode button and the tags [item], but nothing, no colors, nothing ...

if you need t to check-out somethings i can give you an admin account onto my test board ... ;)

edit. instead, the 0.5.1 version runs properly .... also the 0.5.1 runs with the 0.5.2 files so i think there is an issue in the .xml

sweede 06-21-2008 02:05 PM

Quote:

Originally Posted by KURTZ (Post 1555238)
Sweede, just uploaded and installed your add-on ... unfortunately it doesn't works ... :( it shows only the BBCode button and the tags [item], but nothing, no colors, nothing ...

if you need t to check-out somethings i can give you an admin account onto my test board ... ;)

edit. instead, the 0.5.1 version runs properly .... also the 0.5.1 runs with the 0.5.2 files so i think there is an issue in the .xml


Ok, fixed with 0.5.3

I use another product that allows me to store plugins on my local drive and edit them with a normal PHP Editor as php files. When i "Export" a product, it reads these php files and creates the XML file accordingly.

If there are any additional space after the closing ?> tag (or it is missing), it doesnt include that plugin, which has happened several times so far :)

KURTZ 06-21-2008 02:13 PM

OK it seems to be correct now ... edit: nvm it runs :P

KURTZ 06-21-2008 02:28 PM

upgraded to 5.4, just found a small issue :) i've settled into ACP 'disable underline' but the old tooltips are still underlined ... :)

Luxus 06-21-2008 06:18 PM

nice new version...
do you plan to support more then 1 language?
to post in german
use [item]http://de.wowhead.com/?item=29434[/item]
for default lang [item]29434[/item]

sweede 06-21-2008 06:36 PM

Quote:

Originally Posted by Luxus (Post 1555568)
nice new version...
do you plan to support more then 1 language?
to post in german
use [item]http://de.wowhead.com/?item=29434[/item]
for default lang [item]29434[/item]

Yes, but not until i can figure out how to get a non-english name via URL

for example.

http://www.wowhead.com/?item=Netherwind+Pants&xml works as you would expect.

In french though,
http://fr.wowhead.com/?item=16915
it is
Pantalon de vent du N?ant

which if you put that in the URL, doesnt work
http://fr.wowhead.com/?item=Pantalon...t+du+N?ant&xml

if you change the ? to e
http://fr.wowhead.com/?item=Pantalon...t+du+Neant&xml

it works as expected

Now the problem is translating the ? to e and the other hundreds of characters automatically. While i can build a translation map, that doesnt appear to be the most robust solution right now.

Also, there are some characters in languages that i can't figure out the correct character to use (for example, there is this funky B looking character in German).

I don't want to rely on users knowing the item ID every time, and I haven't added a way to specify locale to the item ID (i.e. [item=ES-12345]Spanish Item[/item] so you can change the displayed language in the tooltip itself.

This though, is easy and i'll get that implemented further in the week (Along with pasting wowhead URLs supporting the same mechanic).

For example, if your board is set to use French by default and someone puts something like..

[item=ES]Abrazo de Alanna[/item] (item is in spanish)
[item=US-13314]Alanna's Embrace[/item] (Item would be in english)
or pasting
http://de.wowhead.com/?item=13314 (item would be in german) ,

all 3 of those would be in their appropriate language

Danoxth 06-22-2008 08:39 PM

Installed and runs perfectly :)

May I make a suggestion? Is it possible to get the following format to be accepted: [item=35497]

Reason I ask is that I use the RSS feed of a popular Warcraft site and they use that sort of formating so I'm currently having to go in manually edit each item code etc.

If it's possible it'd be great, if not, no worries, just more work for me :P

sweede 06-22-2008 08:50 PM

i don't know if you can do that in bbcode..

but, i'll look and see what i can do.

Whats the RSS feed so i can review and test ?

Danoxth 06-22-2008 09:06 PM

It's MMO Champions feed, which you can find here

Cheers for the quick response :)

Deepdog009 06-23-2008 05:11 AM

Super Beauts... :cool:

pewp 06-23-2008 04:19 PM

nevermind, reinstalled, works great. Thanks!

tuaguild 06-23-2008 05:30 PM

i still like mine lol but yours is pretty awesome there man

Kinneas 06-24-2008 06:48 AM

No problems seen so far on this version :) Thanks sweede!

crombiecrunch 06-27-2008 02:34 AM

any chance to get this to work with http://aoc.mmodb.com/ for age of conan?

sweede 06-27-2008 02:46 AM

Quote:

Originally Posted by Danoxth (Post 1556333)
It's MMO Champions feed, which you can find here

Cheers for the quick response :)


Yay for mmo-champ !

Create a new plugin
Product WoW Head ItemStats
Hook Location [b]rssposter_parse_rss[b]

Title Rss Test

Plugin PHP Code

Quote:

$pattern = '/\[item=(\d+)\]/i';
$replacement = '[item]\\1[/item]';
$item['description'] = preg_replace($pattern, $replacement, $item['description']);
You might have to wait a while for mmo champ to post news with that tag in it.

it will change [item=12345] to [item]12345[/item] , which should work out correctly

sweede 06-27-2008 02:57 AM

Quote:

Originally Posted by crombiecrunch (Post 1560072)
any chance to get this to work with http://aoc.mmodb.com/ for age of conan?

hmmmmmmmmmmmm

maybe, but not in this product

KURTZ 06-27-2008 07:51 AM

Quote:

Originally Posted by sweede (Post 1560090)
hmmmmmmmmmmmm

maybe, but not in this product

i need that! :p

Dsru123 07-01-2008 01:58 AM

worked great, but WoWhead JS script you have to add to headinclude in all styles you use was causing login error. After login you would get a blank screen untill you opened up same page in browser again. Been looking for a fix, but after some checking its the js script thats causing the login blank screen.

tuaguild 07-01-2008 02:04 AM

yeah try mine it is gitemstats with wowhead support


All times are GMT. The time now is 07:13 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01531 seconds
  • Memory Usage 1,829KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)bbcode_html_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete