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

Jump to content

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

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

#1 Guest_Psibeast_*

  • Group: Guests

Posted 17 March 2007 - 08:01 AM

Hi,

I installed Itemstats over eqdkp 1.3.2 according to the instructions, but all I get now is just question mark icons near the item names and no tooltip showing up.

example:

http://www.immortall...e....php?s=&r=4

What am I doing wrong?

Thanks.

#2 Guest_Psibeast_*

  • Group: Guests

Posted 17 March 2007 - 08:39 AM

Looking over the phpmyadmin I saw that item_cache table was not created. So I tried the SQL query that was in the FAQ to add the table.

I got the error message:

#1214 - The used table type doesn't support FULLTEXT indexes

using phpMyAdmin 2.6.0-pl3 on MySQL 4.1.18-nt

#3 Guest_Neriyah_*

  • Group: Guests

Posted 17 March 2007 - 10:39 AM

Did you modify your template ?

Quote

3-If you use a different theme from that delivered with the portal, you have to add the Javascript "overlib.js" and the CSS Styles "Itemstats.css".

For that, edit the file "/templates/YOUR_THEME/page_header.html", search the lines :


<title>{PAGE_TITLE}</title>



and add the following line :




<link REL=StyleSheet HREF="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/templates/itemstats.css" TYPE="text/css" MEDIA=screen />

<script type="text/javascript" src="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/overlib/overlib.js"><!-- overLIB © Erik Bosrup --></script>


in the end, it will give :


<title>{PAGE_TITLE}</title>

<link REL=StyleSheet HREF="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/templates/itemstats.css" TYPE="text/css" MEDIA=screen />

<script type="text/javascript" src="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/overlib/overlib.js"><!-- overLIB © Erik Bosrup --></script>


#4 Guest_Psibeast_*

  • Group: Guests

Posted 17 March 2007 - 03:01 PM

View PostNeriyah, on Mar 17 2007, 10:39 AM, said:

Did you modify your template ?


Yes, I did that. But it doesn't work even with the default template.
I believe the root of the problem is with the database as the item_cache table does not exist and I can't create it using the query that was offered in the FAQ.

#5 Guest_Thorgall_*

  • Group: Guests

Posted 18 March 2007 - 08:35 AM

Same here, it doesn't work:
http://hgfollowers.d.../...=&p=history

And I made sure to follow all the staps provided in this page (wich is pretty simple):
http://itemstats.fre....php?content.10

And I didn't modify any template or whatever. It seems to not even query allakhazam at all.

#6 User is offline   Dazza

  • EQdkp Moderator
  • PipPipPip
  • Group: EQdkp Administrators
  • Posts: 384
  • Joined: 13-February 06
  • Gender:Male
  • Location:Newcastle, Australia
  • Interests:Graphic Design, Web Development, Tennis, Guitar

Posted 18 March 2007 - 02:50 PM

View PostThorgall, on Mar 19 2007, 03:35 AM, said:

Same here, it doesn't work:
http://hgfollowers.d.../...=&p=history

And I made sure to follow all the staps provided in this page (wich is pretty simple):
http://itemstats.fre....php?content.10

And I didn't modify any template or whatever. It seems to not even query allakhazam at all.



View PostNeriyah, on Mar 18 2007, 05:39 AM, said:

Did you modify your template ?

Quote

3-If you use a different theme from that delivered with the portal, you have to add the Javascript "overlib.js" and the CSS Styles "Itemstats.css".

For that, edit the file "/templates/YOUR_THEME/page_header.html", search the lines :


<title>{PAGE_TITLE}</title>



and add the following line :




<link REL=StyleSheet HREF="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/templates/itemstats.css" TYPE="text/css" MEDIA=screen />

<script type="text/javascript" src="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/overlib/overlib.js"><!-- overLIB © Erik Bosrup --></script>


in the end, it will give :


<title>{PAGE_TITLE}</title>

<link REL=StyleSheet HREF="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/templates/itemstats.css" TYPE="text/css" MEDIA=screen />

<script type="text/javascript" src="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/overlib/overlib.js"><!-- overLIB © Erik Bosrup --></script>


Read that, then view the source code of your web site. Come back when you are willing to listen to the answers provided to you.

#7 Guest_Thorgall_*

  • Group: Guests

Posted 18 March 2007 - 03:50 PM

View PostDazza, on Mar 18 2007, 05:50 PM, said:

Read that, then view the source code of your web site. Come back when you are willing to listen to the answers provided to you.

I am 100% willing to listen to the answer provided but as I already said, I use the defaut template and it doesn't work. The other guy also said he tried the default template and it still doesn't work for him either.

Code in: dkp/itemstats/templates/default/page_header.html
<title>{PAGE_TITLE}</title>
<link REL=StyleSheet HREF="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/templates/itemstats.css" TYPE="text/css" MEDIA=screen />
<script type="text/javascript" src="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/overlib/overlib.js"><!-- overLIB © Erik Bosrup --></script>


#8 User is offline   Ryushi32

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

Posted 18 March 2007 - 04:39 PM

I am using the default template also with 1.3.2 and it will not query the items they all just show up as question marks

#9 User is offline   Dazza

  • EQdkp Moderator
  • PipPipPip
  • Group: EQdkp Administrators
  • Posts: 384
  • Joined: 13-February 06
  • Gender:Male
  • Location:Newcastle, Australia
  • Interests:Graphic Design, Web Development, Tennis, Guitar

Posted 18 March 2007 - 06:40 PM

@Thorgall
Following your itemstats links from the source code of your page (in firefox: open page, right click > view source), it would appear that your itemstats installation is not where your link thinks it is. I will assume that this means that the template variable {ITEMSTATS_PATH} does not actually exist. Instead, you should hard-code the directory for itemstats in its place.

@Psibeast, Ryushi32
The source code on your page shows that while the overlib and stylesheet for itemstats is correctly linked on the pages, the items don't have any tags with javascript code in them to do the rollovers for the items. This suggests to me that you're most likely using itemstats 1.5, and you installed the core for itemstats, but not the files for eqdkp. Possibly.
I haven't used itemstats 1.5 on a site before, so this is speculation on my part.

#10 Guest_Psibeast_*

  • Group: Guests

Posted 19 March 2007 - 03:55 AM

View PostDazza, on Mar 18 2007, 06:40 PM, said:

@Thorgall
Following your itemstats links from the source code of your page (in firefox: open page, right click > view source), it would appear that your itemstats installation is not where your link thinks it is. I will assume that this means that the template variable {ITEMSTATS_PATH} does not actually exist. Instead, you should hard-code the directory for itemstats in its place.

@Psibeast, Ryushi32
The source code on your page shows that while the overlib and stylesheet for itemstats is correctly linked on the pages, the items don't have any tags with javascript code in them to do the rollovers for the items. This suggests to me that you're most likely using itemstats 1.5, and you installed the core for itemstats, but not the files for eqdkp. Possibly.
I haven't used itemstats 1.5 on a site before, so this is speculation on my part.

Dazza,

First thanks for answering.

Here are the exact steps I took in installing Itemstats:

1. I downloaded both the core files and the eqdkp files to my computer and extracted them each to their own directories
2. I uploaded itemstats as a subdirectory under the eqdkp directory to my server
3. I copied over the eqdkp files to the directory of the eqdkp installation on my server overwriting my old files
4. I edited the template header adding the lines mentioned
5. I edited the configuration file with the details to my server.

What I do see is that the item_cache table is not created on my database and the sql query that is supposed to create it doesn't work (it says #1214 - The used table type doesn't support FULLTEXT indexes).

One thing to note is that I am using your version of eqdkp Dazza (1.3.2) while Itemstats 1.5 says it supports 1.3.1. I am not sure if this should create a problem or not, you might have a better idea.

Once again, thanks for helping.

#11 Guest_Neriyah_*

  • Group: Guests

Posted 19 March 2007 - 10:35 AM

Psibeast You default database engine is most likely InnoDB, create the database engine as MyISAM and it will work.

edit:
Something like this
CREATE TABLE `item_cache` (
`item_name` varchar(100) NOT NULL default '',
`item_id` varchar(100) default '0',
`item_lang` varchar(2) default '',
`item_link` varchar(100) default NULL,
`item_color` varchar(20) NOT NULL default '',
`item_icon` varchar(50) NOT NULL default '',
`item_html` text NOT NULL,
UNIQUE KEY `item_name` (`item_name`),
FULLTEXT KEY `item_html` (`item_html`)
) ENGINE=MyISAM;

#12 Guest_Psibeast_*

  • Group: Guests

Posted 19 March 2007 - 01:30 PM

Thank you very much Neriyah. Your query did in fact succeed in creating the missing table.
The bad news is that it didn't change anything :( It is still not working for me.

I took Dazza's speculation as a hint and copied over again all the files for the eqdkp and made sure they are the ones on the site. It didn't help anything either. If anyone has any idea why my items don't have the code for the roll-over I'd be very grateful.

Thanks.

#13 Guest_Corbism_*

  • Group: Guests

Posted 19 March 2007 - 09:04 PM

View PostThorgall, on Mar 18 2007, 11:35 AM, said:

Same here, it doesn't work:
http://hgfollowers.d.../...=&p=history

And I made sure to follow all the staps provided in this page (wich is pretty simple):
http://itemstats.fre....php?content.10

And I didn't modify any template or whatever. It seems to not even query allakhazam at all.


I am having the same problem Thorgall.

I just updated to 1.3.2 (which works perfectly btw), and itemstats immediately stopped working on any of the eqdkp pages.

I previously had this itemstats code in my template page_header file:

<title>{PAGE_TITLE}</title>
<link REL=StyleSheet HREF="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/templates/itemstats.css" TYPE="text/css" MEDIA=screen />
<script type="text/javascript" src="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}/overlib/overlib.js"><!-- overLIB © Erik Bosrup --></script>


Since that doesn't work after the eqdkp upgrade, I ended up trying to hard-code the path to itemstats (as Dazza recommended earlier in this thread) as follows:

<link REL=StyleSheet HREF="../../../eq/itemstats/templates/itemstats.css" TYPE="text/css" MEDIA=screen />
&lt;script type="text/javascript" src="../../../eq/itemstats/overlib/overlib.js"><!-- overLIB © Erik Bosrup --></script>


Itemstats is still not working. BUT. BUT, a couple of eq plugins ARE WORKING with itemstats as hard-coded above. FancyStats and Set Progress. Now, what is odd is that these have a re-direct to my altered template file. So, basically, if I look at the source code in either fancystats or setprogress, I see:

<link REL=StyleSheet HREF="../../../eq/itemstats/templates/itemstats.css" TYPE="text/css" MEDIA=screen />
&lt;script type="text/javascript" src="../../../eq/itemstats/overlib/overlib.js"><!-- overLIB © Erik Bosrup --></script>


Now, when I look at the source code of say a standard Raid Summary, I see the same code above. BUT, itemstats is not functioning (No icons or rollovers). Just what you are experiencing. So, I have no clue what is wrong and why the plugins are working with itemstats, but not the eqdkp pages themselves.

#14 User is offline   Drizzit

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

Posted 20 March 2007 - 02:13 AM

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.

If you're using a template other than the default, you have 2 options:

1) Change (temporarily) to a style using the default template to verify the itemstats functionality before implementing the changes in point 2.

2) Change your template files. There are 2 files that needs to be changed in the templates/<your template> directory, these are page_header.html and viewitem.html.

Changes in page_header.html

Find:
<title>{PAGE_TITLE}</title>


Add After:
<!-- MODIFICATION, ItemStat http://itemstats.free.fr === by Yahourt / Thorkal == EU Elune / Horde ========== -->
<link REL=StyleSheet HREF="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}{ITEMSTATS_CSS_PATH}" TYPE="text/css" MEDIA=screen />
&lt;script type="text/javascript" src="{EQDKP_ROOT_PATH}{ITEMSTATS_PATH}{ITEMSTATS_JS_PATH}"><!-- overLIB (c) Erik Bosrup --></script>


Changes in viewitem.html

<!-- INCLUDE page_header.html -->
<table width="100%" border="0" cellspacing="1" cellpadding="2">
  {ITEM_STATS}   <!-- ItemStats modification -->
  <tr class="rowhead">
	<th align="center" colspan="4">{L_PURCHASE_HISTORY_FOR}</th>



Make sure that you delete everything in the templates/cache/<your template> directory so that you are not loading pages from the cache, as they may not have been updated with the changes that was made.

Attached File  itemstats_eqdkp_1.3.2.zip (34.63K)
Number of downloads: 787

#15 User is offline   Drizzit

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

Posted 20 March 2007 - 02:35 AM

@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.

  • (5 Pages) +
  • 1
  • 2
  • 3
  • 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