Help! Itemstats not working with EQDKP 1.3.2
#1 Guest_Psibeast_*
Posted 17 March 2007 - 08:01 AM
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_*
Posted 17 March 2007 - 08:39 AM
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_*
Posted 17 March 2007 - 10:39 AM
Quote
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_*
Posted 17 March 2007 - 03:01 PM
Neriyah, on Mar 17 2007, 10:39 AM, said:
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_*
Posted 18 March 2007 - 08:35 AM
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
Posted 18 March 2007 - 02:50 PM
Thorgall, on Mar 19 2007, 03:35 AM, said:
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.
Neriyah, on Mar 18 2007, 05:39 AM, said:
Quote
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_*
Posted 18 March 2007 - 03:50 PM
Dazza, on Mar 18 2007, 05:50 PM, said:
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
Posted 18 March 2007 - 04:39 PM
#9
Posted 18 March 2007 - 06:40 PM
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_*
Posted 19 March 2007 - 03:55 AM
Dazza, on Mar 18 2007, 06:40 PM, said:
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_*
Posted 19 March 2007 - 10:35 AM
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_*
Posted 19 March 2007 - 01:30 PM
The bad news is that it didn't change anything
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_*
Posted 19 March 2007 - 09:04 PM
Thorgall, on Mar 18 2007, 11:35 AM, said:
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 /> <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 /> <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
Posted 20 March 2007 - 02:13 AM
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 />
<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.
itemstats_eqdkp_1.3.2.zip (34.63K)
Number of downloads: 787
#15
Posted 20 March 2007 - 02:35 AM
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 Level 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.


Sign In
Register
Help

Back to top
MultiQuote