forums.eqdkp.com: Help! Itemstats not working with EQDKP 1.3.2 - forums.eqdkp.com

Jump to content

  • (5 Pages) +
  • 1
  • 2
  • 3
  • 4
  • Last »
  • You cannot start a new topic
  • You cannot reply to this topic

Help! Itemstats not working with EQDKP 1.3.2 Rate Topic: -----

#16 Guest_Psibeast_*

  • Group: Guests

Posted 20 March 2007 - 01:38 PM

View PostDrizzit, on Mar 20 2007, 02:35 AM, said:

@psibeast

I had a look at the source from http://www.immortall...e....php?s=&i=9 and comparing it with the source from http://dkp.wow-redey...m.php?s=&i=3443 (an item on my DKP server), it seems that you are missing something akin to this.

<div class='wowitem wowitemlive'>
<span class='iname'><a target='_blank' class='itemlink' href='http://wow.allakhazam.com/db/item.html?witem=28745&locale=enUS'><span class='purplename'>Mithril Chain of Heroism</span></a></span><br />
Binds when picked up<br />
Neck<span class='wowrttxt'>Miscellaneous</span><br />
+25 Strength<br />

+20 Agility<br />
+19 Stamina<br />
Requires&nbsp;Level&nbsp;70<br />
</div>

I presume that the the reason you are missing this is because you are missing {ITEM_STATS} from your templates/<your template>/viewitem.html
See my post above for where to put it.
Oh... and clear your cached files.

Hi,

I made sure I have {ITEM_STATS} in my viewitem.html in all of the template directories, not just one of them.
Still doesn't work :(

Any more ideas?

#17 Guest_Corbism_*

  • Group: Guests

Posted 20 March 2007 - 01:43 PM

View PostDrizzit, on Mar 20 2007, 05:13 AM, said:

If your plugins are working, it means that the base eqdkp files has not been properly modified.

I've put together a package from eqdkp 1.3.2 with all itemstats modifications, this package is meant to replace itemstats1.5_eqdkp_1.3.1.rar ( I just hope I got all the changes for itemstats correct). It works ok on my DKP server.

I've only included changes for the default template, as the original release only contained these files, and I use the default template on my site, so I can't test and verify any other templates.

Drizzit! Thank you. The package you put together has fixed the problem. Itemstats is now working properly from what I can see so far.

Thanks again!

#18 Guest_Thorgall_*

  • Group: Guests

Posted 20 March 2007 - 03:05 PM

I really don't know what's wrong because I did everything that was suggested (hardcoded the path to itemstats.css, etc...) and it still doesn't want to work... >_<

I am lost...

http://www.hgfollowe...p...=&p=history

#19 User is offline   Ryushi32

  • Member
  • Pip
  • Group: Members
  • Posts: 7
  • Joined: 18-November 06
  • Gender:Male

Posted 20 March 2007 - 04:46 PM

with those new files in this post it somewhat works but it takes a long time to get items and some it will not get http://www.mrun.info...hp?s=&p=history

#20 Guest_Exciter_*

  • Group: Guests

Posted 20 March 2007 - 06:48 PM

Hi guys..

sorry for my broken english - but looks like I do have the same issues like my colleagues above.

After upgrading EQDKP 1.31 to 1.32 itemstats is not working any longer.

This is what I did in detail additionally...

- Downloaded the attachment in this thread and updated all files as requested.
- Loaded default template

This is how it looks...

http://www.undercons...istitems.php?s=

#21 Guest_Thorgall_*

  • Group: Guests

Posted 21 March 2007 - 03:43 AM

View PostDrizzit, on Mar 20 2007, 05:13 AM, said:

Attachment itemstat...kp_1.3.2.zip

Works with the attachment! Great, thanks guys.

I get the red "?" at first but when I click the link, I can get an icon.

#22 User is offline   Drizzit

  • Member
  • Pip
  • Group: Members
  • Posts: 36
  • Joined: 23-January 06
  • Location:Largs, Scotland

Posted 21 March 2007 - 05:26 AM

@Psibeast
Still trying to figure out what may have gone wrong on your site.

When I click the item links on your site, they seem to be refreshed and updated, though I'm unable to see the update item link.


@Ryushi32
The time it takes to load is most likely down to a high latencey between your host and allakhazam or thottbot, or if you've enabled automatic updates in the itemstats/config_itemstats.php file (which makes it update all items listed automatically).

The items that does not show, will not show if you use Allakhazam, as they no longer provide stats for any items that has the affix 'of the Eagle', 'of the Owl' etc.
Seems that thottbot no longer shows them either, though I did not check thoroughly.


@Exciter
Where is your itemstats core installed? I cannot see see that it's on your server.

Download the itemstats core 1.5.5 from itemstats.free.fr, and follow the installation instructions provided.

The package I provided only contains EQDKP modifications, not the itemstats core files.

#23 User is offline   Drizzit

  • Member
  • Pip
  • Group: Members
  • Posts: 36
  • Joined: 23-January 06
  • Location:Largs, Scotland

Posted 21 March 2007 - 05:59 AM

@Psibeast
Please check your itemstats directory for a templates directory, it should contain the following files:

itemstats/templates/
index.html
itemstats.css
popup-error.tpl
popup.tpl
viewitem.tpl

I can access http://www.immortall...s/itemstats.css directly, but not the .tpl files (I can directly access them on my DKP server and on my test servers).

#24 Guest_tramazing_*

  • Group: Guests

Posted 21 March 2007 - 11:25 AM

View PostThorgall, on Mar 21 2007, 03:43 AM, said:

Works with the attachment! Great, thanks guys.

I get the red "?" at first but when I click the link, I can get an icon.



Well guys, I am in the same boat as this poster, the exact same thing has happened to me.

http://www.theancien...istitems.php?s=

can anyone tell me where i have gone wrong?

I installed and edited everything, both in the install docs, readmes, and in this thread. Can't seem to get the questionmarks to show items.

I am using mysql 5, eqdkp 1.3.2, and item stats 1.5.5. Suggestions?

#25 User is offline   Drizzit

  • Member
  • Pip
  • Group: Members
  • Posts: 36
  • Joined: 23-January 06
  • Location:Largs, Scotland

Posted 21 March 2007 - 12:31 PM

Getting a red ? mark on some of the icons is not that unusual.

This is usually down to that either Allakhazam or Thottbot (or any other item stat site) is too busy to process the request, or the link between your hosting and Alla/Thott has a high latencey.

There is not much you can do about this other than clicking the link to refresh the data.

If an item persists in not showing any stats, you should check that the name is correct, one mistake... and the item will not show.

Always look up an item on Alla/Thott to verify that you've got the name correct if you have a problem with some items.

#26 User is offline   Ryushi32

  • Member
  • Pip
  • Group: Members
  • Posts: 7
  • Joined: 18-November 06
  • Gender:Male

Posted 21 March 2007 - 02:08 PM

Those item names were inputed by ct_raid tracker also it gives sql query timeouts

#27 Guest_tramazing_*

  • Group: Guests

Posted 21 March 2007 - 02:19 PM

View PostRyushi32, on Mar 21 2007, 02:08 PM, said:

Those item names were inputed by ct_raid tracker also it gives sql query timeouts


Wow thats the first I've heard of this. What is so special about an item input from CTRT that would cause more latency?

#28 User is offline   Ryushi32

  • Member
  • Pip
  • Group: Members
  • Posts: 7
  • Joined: 18-November 06
  • Gender:Male

Posted 21 March 2007 - 04:31 PM

View Posttramazing, on Mar 21 2007, 12:19 PM, said:

Wow thats the first I've heard of this. What is so special about an item input from CTRT that would cause more latency?

What i was saying was in response to him suggesting that the item names were mispelled

#29 User is offline   Drizzit

  • Member
  • Pip
  • Group: Members
  • Posts: 36
  • Joined: 23-January 06
  • Location:Largs, Scotland

Posted 22 March 2007 - 02:07 AM

SQL errors/timeouts are not the same as latency between Thott/Alla, this usually means that the MYSQL is to busy to process the request, and this is something that happens more often if you host your DKP server with a hosting company instead of hosting it on your own server where you have full control.

Hosting companies does not (unless you pay a lot for the hosting) give you exclusive rights to a server. Everything is shared with other users, and depending on the hosting company, they may run their servers on the limit of what they're capable of, both with regards to databases and network traffic.
This is usually what accounts for SQL query timeouts and connection timeouts.

When parsing with CTRT you would not normally get connection timeouts, you are more likely to get SQL query timeouts if the database server is very busy. This has nothing to do with itemstats though.

As I explained earlier, when you try to update the items and some items come up with a red ? mark there are several possible explanations for this:

1. Connection timeouts between your host and Thott/Alla. You are more likely to see this if it takes a long time to update any items. The only thing you can do about this is to click the item link and refresh the data. You should also try at a time that is less busy. Usually early in the morning.

2. A misspelt item. Usually only happens if you added the item manually, but it is possible that it was incorrectly parsed. Check Thott/Alla to see that the name is correct.

3. Items with affixes (of the owl, of the eagle, etc) will not show, especially if you use Allakhazam as they do not store the data for these items, only the main item is shown on Alla. It seems that it's the same for Thottbot as well these days.

4. If the listitems page(s) take a long time to show, you most likely have enabled automatic updates for items. I would not recommend having this option on at all times, as it may cause a lot of network traffic, and on already strained systems you are likely to see that some items are not updated due to connection timeouts.

5. Your hosting company does not provide the fopen or CURL. If this is the case, all items with come up with a '?' mark, and I'd seriously consider checking with the hosting company if they have these functions.

So, that was some explanations of why some items may not show.

How can you actually determine what the problem may be?

- When you've added some items and the itemlinks stays gray after you've clicked it, you have a problem with itemstats, usually this would mean that it's not properly installed.
- When you've added some items and some items show as ? while others come up correctly. You should check point 1, 2 and 3 above.
- When you've added some items and all come up with a ? mark, you will have to look at point 1, 2, 3 and 5
- When you've added some items and some items show while the rest of the links stay gray. Check point 4.

These are explanations for the most common problems, but I'm sure there are more I've not thought of.

#30 User is offline   Drizzit

  • Member
  • Pip
  • Group: Members
  • Posts: 36
  • Joined: 23-January 06
  • Location:Largs, Scotland

Posted 22 March 2007 - 02:19 AM

@Ryusha

I suggest that you look up the items you that does not show.

These items does not show on your site:

Shadow Council Chain of the Sorcerer
Shattered Hand Belt of Fire Protection
Archmage Belt of the Owl
Conqueror's Epaulets of Spirit
Bloodfist Helmet of Stamina
Shadow Council Chain of the Sorcerer
Shadow Council Boot of the Invoker
Conqueror's Legplates of the Falcon
Conqueror's Helmet of the Eagle

Why?

As I've said earlier, if you look on Thottbot or Allakhazam, they're not there! If they don't have the data, you don't get the stats for them on the DKP server. This is not a problem with itemstats.
  • (5 Pages) +
  • 1
  • 2
  • 3
  • 4
  • Last »
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users