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
293107
This post was from a user who has deleted their account.
Post by
Takehiko
I'm doing everything it says and then when i try to browse creat_table.php i get this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `{ARMORY_TABLE}` ( `name` varchar(255) NOT NULL, ' at line 2
Can anyone help? because my hosts say its a problem with the coding in this.
Post by
Lockslap
I'm doing everything it says and then when i try to browse creat_table.php i get this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `{ARMORY_TABLE}` ( `name` varchar(255) NOT NULL, ' at line 2
Can anyone help? because my hosts say its a problem with the coding in this.
Add a semicolon ";" to the end of the previous line in table_scheme.sql and then reupload and rerun create_table.php.
@beelz, the universal parser will work for SMF, just have to modify the installation instructions to account for the armory module's JavaScript file. The only changes required will be to the Joomla and Wordpress plugins I wrote.
Post by
Caldar
Finally got it workign now that the armory likes my site again.
Icons don't seem to show with the toggle in config set to true.
Caching doesnt seem to be working correctly. Looking at my database I see doezens of entries for the same character, bascially every view makes a new entry.
And now the armory doesn't like me again so my tooltips are just huge and filled with errors once again. Also, now that the armory is no longer working for my site, even the so called cached names are broken.
Using version 3.4.1.
The original mod yours is based off of worked correctly in these cases and even though the tooltips might say the armory was down, the links were correctly colored and icon'd.
Post by
Lockslap
Finally got it workign now that the armory likes my site again.
Icons don't seem to show with the toggle in config set to true.
Caching doesnt seem to be working correctly. Looking at my database I see doezens of entries for the same character, bascially every view makes a new entry.
And now the armory doesn't like me again so my tooltips are just huge and filled with errors once again. Also, now that the armory is no longer working for my site, even the so called cached names are broken.
Using version 3.4.1.
The original mod yours is based off of worked correctly in these cases and even though the tooltips might say the armory was down, the links were correctly colored and icon'd.
Telling me there's a problem is one thing, but SHOWING me the problem is much easier. Basically, what I'm saying is give me a link, please.
Post by
Lockslap
Okay the official download links for the script has changed. Now if you wish to download any new version please get them from
http://www.crackpot.ws/downloads/
. I'm not sure I like the download plugin I'm currently using for my site, but we'll see.
I am still in the process of moving the script's site into my main page. It will eventually be located at
http://www.crackpot.ws/wowhead-tooltips/
.
Nevermind, it would totally interrupt and mess up how the site is setup now. Everything will remain the same. But I still love my new layout, lol
I will continue to announce new releases on the main site, but everything will still happen at
http://wowhead.crackpot.ws
Post by
Caldar
Giving you a link right now would be useless as I have disabled the armory part for the time being since it is buggy as hell and every time the armory decides it doesn't like my site for a while it just generates error laden tooltips.
Make a page, fill it with a couple dozen armory links, and see what happens for you. But that is only part of the issue as I have said.
It doesn't show icons, even though my config is set to true.
It ignores cached names, pulls from the armory on every mouse over and stores a new entry in the database every time you mouse over a name. My armory table has a dozen entries for each name,
Post by
Lockslap
Giving you a link right now would be useless as I have disabled the armory part for the time being since it is buggy as hell and every time the armory decides it doesn't like my site for a while it just generates error laden tooltips.
Make a page, fill it with a couple dozen armory links, and see what happens for you. But that is only part of the issue as I have said.
It doesn't show icons, even though my config is set to true.
It ignores cached names, pulls from the armory on every mouse over and stores a new entry in the database every time you mouse over a name. My armory table has a dozen entries for each name,
In my defense, I did say that the armory module was going to be buggy as hell. Hence why its beta, lol. =D I'll get the kinks worked out and it will be whipped into shape.
Post by
Lockslap
Okay I think I have fixed both of those issues, but I'm going to hold off on releasing until I can do further testing. You can download the files that were changed
here
. Simply unzip the contents then upload to your site keeping the directory structure in tact. When it asks to overwrite, do so.
The icons still are iffy at times, but it is not because of my script. It properly outputs the icon every time, so my suspicion is that its because of the JS tooltips. Given that I am not terribly proficient at JavaScript, there's really not a lot I can do about it.
Let me know your findings. I have been unable to reproduce any of the issues posted above.
If you find a bug please don't hesitate to post it on the scripts bug tracker @
http://wowhead.crackpot.ws/bugs/
.
Post by
sasexw
off-topic:
crackpot man i dont think you have seen your sig, try fix it ^^(human drood?i want one xD)
Post by
Caldar
Okay I think I have fixed both of those issues, but I'm going to hold off on releasing until I can do further testing. You can download the files that were changed
here
. Simply unzip the contents then upload to your site keeping the directory structure in tact. When it asks to overwrite, do so.
The icons still are iffy at times, but it is not because of my script. It properly outputs the icon every time, so my suspicion is that its because of the JS tooltips. Given that I am not terribly proficient at JavaScript, there's really not a lot I can do about it.
Let me know your findings. I have been unable to reproduce any of the issues posted above.
If you find a bug please don't hesitate to post it on the scripts bug tracker @
http://wowhead.crackpot.ws/bugs/
.
New version is slightly better than the last. When armory dies the tooltip says its down now, and is only partially filled with errors :p
It still refuses to use the cached names in the database and still puts multiple entries for each name. If the armory is unreachable then basically nothing works. No icons, no class colored links, no functional tooltips.
How can I help you work out the kinks? I disabled it again since its only mostly functional when the armory is up and with a non-functioning cache in the database it blocks me all too quick.
Post by
Lockslap
The armory will block you if you attempt to make too many queries in a given amount of time, conventional wisdom is about 45 queries in a minute. It won't technically block you but it will throw a 503 error (server unavailable), if you continue to query after the 503 errors, then it will block you for about 1 day.
I dunno why the cache isn't working properly, it was working last night. I'll take a look.
Update
The cache is working properly for me. You may need to clear your cache. If the tooltip is throwing any errors then you need to copy/paste, take a screenshot, or link me them so I can see what's going on. There's not really any way to reproduce them if I can't see what its saying.
Post by
Caldar
Cache seems to be working once I cleared it now, though apparently it only caches a name once you have actually moused over it to generate a tooltip and not on initial query to find class/race?
Other than that it seems to be working. I emailed you a screenshot of my tooltip error.
Still looking for individual race / class icon toggles.
And there was something else but it escapes me at the moment.
Post by
Lockslap
Cache seems to be working once I cleared it now, though apparently it only caches a name once you have actually moused over it to generate a tooltip and not on initial query to find class/race?
Other than that it seems to be working. I emailed you a screenshot of my tooltip error.
Still looking for individual race / class icon toggles.
And there was something else but it escapes me at the moment.
The script is unable to get the tooltip when it gets the icons because of how I had to set it up. I am thinking about removing icons all together due to their buggy nature, it seems more trouble than its worth given that the tooltip gives the information anyhow.
Edit
I am going to remove the icons, they are more trouble than they're worth.
Post by
Caldar
Edit
I am going to remove the icons, they are more trouble than they're worth.
I actually like having the class icon if you can figure a way to keep them.
Post by
Lockslap
Edit
I am going to remove the icons, they are more trouble than they're worth.
I actually like having the class icon if you can figure a way to keep them.
I'll look into getting the icons a different way. I know it has something to do with the tooltip script (the JavaScript, that is).
Post by
Lockslap
So here's what I'm thinking about how I'm going to handle icons.
Basically when you do {char name} the parser (parse.php) will take that and work its magic like it always does. It will query the armory server for the basic character information (all we need is a properly formmated name, gender id, race id, and class id) and then it will print out the formatted link with the icons (if you want them).
It will then save the basic info to the cache.
Then when the user hovers over the link then the armory.php script will take over and generate the actual tooltip. This should remove the issues with using AJAX (AHAH, actually) to get the icon info.
I'll try to get a working example up tonight for you guys to test.
Oh, by the way, you can find me on
Twitter
for those up to the minute updates on what I'm doing to the script. Follow me!
Post by
Lockslap
Okay so, I was blocked by the armory all day yesterday so I wasn't able to work on the armory. Now that I am not blocked I was able to rewrite the wowhead_armory.php and armory.php files to handle parsing the armory. Here's how it goes:
Before:
(this is also the way the most popular Armory tooltip script works)
<User Loads the Page>
parse.php
passes
{char}
to
wowhead_armory.php
wowhead_armory.php
takes the info and generates a link to the armory and custom <a> parameters
armory.js.php
is called on page load to get the character's class and associated icons. (not cached)
<User Hovers Over the Link>
armory.php
is called, via AHAH inside of clueTip's code, to actually query the armory and cache the information into MySQL.
armory.php
then prints the resulting information, and is shown in the tooltip.
Now:
(this method seems more logical/faster and less queries to the armory, which with excessive queries will get you blocked)
<User Loads the Page>
parse.php
passes
{char}
to
wowhead_armory.php
wowhead_armory.php
checks if the info is already cached in MySQL.
If it is:
Generates HTML output for the link based on arguments from
armory
tags and
config.php
If not:
Queries armory for information. If not found or an error, returns said error.
Generates HTML output for the link based on arguments from
armory
tags and
config.php
Saves all the information (including the tooltip HTML) to MySQL.
<User Hovers Over the Link>
armory.php
is called, via AHAH inside of clueTip's code, to get the information from the cache
HTML tooltip is outputted, if it is found. If not, it reports an error.
Also included is the cache time which is used to automatically refresh the cache every # hours depending how you setup the
config.php
variable.
What this ends up doing is reducing the queries to the armory by 66% (1 query as opposed to 3, depending on the setup), which will lessen the chances of your site being temporarily blocked by the armory. This also speeds up the tooltip loading time, because when you hover over the link everything is grabbed directly from MySQL, which is much faster than querying the info from armory, and then parsing it, and then caching it. Hopefully, in the end the script will be more stable, and return less errors.
Also in this modified version i have added 4 optional parameters to the
armory
tags.
loc - syntax: loc="{region},{realm}" - specifies a different region/realm
noicons - syntax: noicons - disables all icons from the outputted HTML
noclass - syntax: noclass - disables the class icon
norace - syntax: norace - disables the race icon
As always, you can specify the defaults in
config.php
. The armory module seems stable for release, but I am going to rewrite the guild module to work the same way, just to keep things the same.
So look for version 3.4 sometime later today, possibly tomorrow. Once I officially release version 3.4 I will modify the installation instructions for the changes made, as well as update the Joomla and WordPress plugins.
Hopefully this makes sense to everyone, seems like ramble. My apologies if I am rambling, but I am quite proud with how the armory module turned out, and many thanks to the author of
WAT
, the backbone code for the armory module, for releasing the code under the GPL.
Later everyone,
craCkpot
Post by
Talonos
seems to be comming along very nicely m8, cant wait for next version to come out so i can hammer it for you :)
Post by
Lockslap
Apparently, the cache portion of the code wasn't working properly, so I have fixed it using some special SQL queries. Good stuff!
Post Reply
This topic is locked. You cannot post a reply.