WoW Itemstats

[RobbieB]

Okay, great that fixed it. Looks like you've figured out the problems. Will we be seeing an updated download soon with the 3 files and the itemcache fix?

[ricoboy]

I made my first Joomla website, and now I need to know how to install WoW Itemstats to my site.

http://mods.simplemachines.org/index.php?mod=247

Is the link to the add-on, and I would love to know how to install it to the latest version of Joomla.

[RobbieB]

Well, the add on has nothing to do with joomla. Its strictly a simple machines forum add on. But if you use joomla that's fine too, it just doens't matter.

Go ahead and downlaod that file, then read back a few posts to when I started posting and that will help you fix the problems that you will get after installing it.

[ricoboy]

Well, the things is... I dont know HOW to install it. I never saw any tutorial.

[RobbieB]

Read the FAQ
http://www.simplemachines.org/support/faq/?action=display&faq=34

[Daemonist]

Well, I need some advanced help-- I've posted on the author's site too, just in case-- but here is the issue:

I've managed to install version 1.23 along with a few of the updated code bits, which corrected error messages and the like.  I'm running on SMF 1.1 RC2 with TinyPortal 0.8.6 and MySQL 4.x

Basically, I can create a line that looks like:

Code Select Expand

[wowitem]Silk Cloth[/wowitem]

When I view the message, i see [Silk Cloth], however, it is grey.  When I mouse over the link, there is no popup with the details or icon.   I can, however, click on the link and get pushed to allakhazam for details on the Silk Cloth.

UPDATE:  Originally, I could not get information to save in the mysql tables, however, now I AM getting an entry for Silk Cloth that includes the fact that it is a WHITE item (not grey).   I still, however, get no popup.

I did notice that there were similar issues posted both here and on the author's site...  However, they always ended up going PM or IM, so no answers were ever posted. 

any help would be...   greatly appreciated (I'm tired of fighting the installation of this mod, but desperately want it to work). 



EDIT:   I've since managed to get everything working, so I'm a happy camper.  I would still love to see support for the "of the ..." items, as many of the items we link are ones like that.

Best Regards...

Daemonist

[ltdeta]

SMF 1.0.7 German

1. does anybody know what must be changed to get it work not from default theme-dir

because we are using another theme and i hate code-mixes with two themedirs 


2. found a small problem with german Umlauts

Code Select Expand

[wowitem=0,id]21684[wowitem]
  => [Mantle of the Desert's Fury]

Code Select Expand

[wowitem=1,id]21684[wowitem] 
  => [Mantel des Wüstenzorns]

thansk for reply

[DarkCloud14]

hi ltdeta can you pm me your website and maybe your AIM, ICQ, MSN or whatever else contact ??
Normaly it should work with other themes too but maybe I missed something...

Thanks

-- EDIT --
I've tried the item you've posted above and for me
it shows the german name correct: Mantel des Wüstenzorns
as you can see here:
http://www.darkcloud14.de/forum/index.php?topic=3.msg83#msg83

Hmm I think I know whats wrong, maybe your DB can't hold the german
chars like ü,ä,ö .. I don't replace those chars with the correct html code at the moment
maybe that's the problem but it's just a maybe...

[DarkCloud14]

If someone has problems with SMF WoW Itemstats 1.24 and
Joomla/Mambo please take a look at the following Topic:
http://www.darkcloud14.de/forum/index.php?topic=38.0

[jepelton]

Someone hacked through Wow ItemStats, location of the Hack was

http://www.wickedjoker.com/forum/Sources/itemstats/includes/redirect/session/update/sas/e-online-banking/signon.do&update=2/index.htm [nofollow]


It seems that this E-Online-Banking hacked into ItemStats and it collects data from users and sends them forward

Sadly, there is security hole in ItemStats.


Just wanted to inform

[DarkCloud14]

do you have any informations about how it happened ??
any logs or something like that which you could pm me?

I'll try some things I know about hacking php scripts but my knowledge
with hacking php scripts is really poor... If someone knows more about that
issue please tell me so I can fix it. I think some logs would help me too

[Daemonist]

Okay...   Since I read this post, I started to test to see what damage I could do to my forums.  The details provided in the post about the "Hack" were too vague, and the link doesn't actually work.

As I am unable to get the [wowitem][/wowitem] to do anything bad, I'm going to place this issue into my "hoax" folder...

If more details come up, then I will research more and assist Darkcloud14 with his troubleshooting process.

If you did get hacked...  I suggest that you take a look at the security settings in your website, and your folder/file structure.  Make sure you have not left a vulnerability somewhere else that might be giving hackers a way to "change" the official files.

cheers.

[jepelton]

Well, i didnt discover this myself, my host discovered this and made a shutdown to my site. The link used to be the location of the Hack but naturally, host deleted the info and just gave that link to me so i could identify where the Hack was.

I think the Hack problem was that ItemStats folder had Write permissions set on what naturally was my own fault *grins*

[Daemonist]

I think the Hack problem was that ItemStats folder had Write permissions set on what naturally was my own fault *grins*

  That is common, especially since most "how-to" instructions for setting up websites insist on having permissions set to full...   At the end of the installation, they never usually tell you to reduce the permissions, so your site remains vulnerable.

Glad you caught it and corrected it before they did any major damage.   Hurrah for backups and hosting companies that look out for us. 

[ShawnX]

I'm getting an error when I install on 1.1RC2.  I installed on another board using 1.1RC1 without problem.





www.sinandwar.com

[DarkCloud14]

Do you have any other Mods installed ?? Maybe another package has changed something the package
manager is looking for.. One thing you can try now is to uninstall every mod you've installed and try to
install itemstats again. If this works properly you can try to install the other mods again but I think another mod will file on Subs.php now... If you don't have any other mod install, you might try to replace the current Subs.php with the one of the smf-rc2 installation package.

If you want you can do the changes for Subs.php manually:

1. Just install the mod.

2. now unzip the Mod package.

3. open <yourboarddir>/Sources/Subs.php

4. open the wowitemstats-install_1_1_rc.xml file with any text editor and search for <file name="$sourcedir/Subs.php">.....</file>
Only do the changes inside the <file name="$sourcedir/Subs.php">.....</file> tags !!!

5. If you have located the tag, you will find one of the following tags below.
It will contain a block of code that must be located in the specified file:

<search position="after"><![CDATA[...]]></search> search for some code to add stuff before...
<search position="before"><![CDATA[...]]></search> search for some code to add stuff after...
<search position="replace"><![CDATA[...]]></search> Search for some code to replace...


6. After the <search position> tag, you will find one of these:
<add><![CDATA[...]]></add> this is the code to add/replace ...

7. Remember if you uninstall itemstats again you've to undo these things manually..

[ShawnX]

Thanks for the response....However, I'm not sure I follow.

I found the code you mentioned in the wowitemstats-install_1_1_rc.xml file, but I'm not sure what you want me to do with it.

Are you saying that I need to paste the code into Subs.php?  If so...where in the file do I paste the code?

You say <add><![CDATA[...]]></add> is the code to add/replace ..., but you don't say where to add or replace it.


*Edit

Nevermind...I figured out a workaround.  It was because the change I had to make to my Subs.php file to get it to show in MKPortal.  I just undid the change....ran the installer through the package manager, then re-applied the change to make the forum show in MKPortal...and it works fine!

[copkiller]

hi
nice mod ,since im running eqdkp for my gild i was looking for itemsstats at the forum.
well i testet at xampp smf rc2 and no errors.
after installing at web forum and user wrote alot of [wowitem]xxx[/wowitem]
i found a little problem with the german
item names .
in german the "umlaute" ä ö ü ß arent saved right in sql dataabase .
corgan , german eqdkp support wrote in his blasc.php a little fix for that.

well i have nox skill in php and sql .here is some example i found .

Code Select Expand

if (!$item_xml_found)
{
#Corgan
//$name = str_replace("'", "", $name);
if (strpos($name, "Formel:") !== false)
{
preg_match('#Formel:(.+?)-\s*([[:alpha:]üäöß]*)#i', $name, $formelmatch);
$name = $formelmatch[2];
}
$name = str_replace("%2B", "+", urlencode($name));
$data = itemstats_read_url('http://blasc.planet-multiplayer.de/?f='.$name);
preg_match_all("#(i=[a-z0-9]*)(.*?)</span>#", $data, $matches);
if (count($matches[0]) > 1)
{
for ($i=0;$i<count($matches[0]);$i++) {
if (strpos($matches[0][$i], ">".urldecode(urldecode($name))."<") !== false){
break;
}

could u look at ur code and maybe test the smf itemstats // hxxp:blasc.de [nonactive] items with german "umlaute"
special item :  Striker's Mark
in german :Schläger-Mal

the search hxxp:blasc.de [nonactive] for the item is working but storing in database doesnt work right.
well i just importet alot of items in my database and dont get anymore errors. but if new items with Ä Ö Ü ß
getting into the game by blizz it will mess up my forum.
allrighty that my probblem and sry for my bad english.

ps some links can be found here:
hxxp:forums.eqdkp.com/index.php?showtopic=5039 [nonactive]

bye

[DarkCloud14]

uhm copkiller could it be that you've installed php 5 on your server ?
Someone else had a similiar problem with the german umlauts (ä, ü, ö)

You can try the following but before make a backup of the file!!!
Only try this if you've php 5 installed on your server !

Open <smfdir>/Sources/itemstats/includes/xmlhelper.php

find the following Code:

Code Select Expand


xml_parser_free($this->parser);

return $this->element_data;


and replace it with the following:

Code Select Expand

xml_parser_free($this->parser);

return utf8_decode($this->element_data);

as you can see I've just changed the return...

It's just a quick fix if you've php 5 installed !!! After these changes delete the items
with the wrong converted umlauts. Now it should work.

Remember to create a backup of the file !!

[RobbieB]

I have the latest version installed on smf and it was working fine. However, a reply post that I made errored. I forgot to get the exact error but it was something about a duplicate item in the cache... I wiped the entire cache table in hopes to clear the problem but now the thread is unreadable. When you try to read the post it just tries to load but it doesn't.

Although now that I remember the item in the error didn't have a closing itemtag... gonna try to restore the backup I made of the cache table.

Okay, that was it.. forgot to close the item tag on 3 items in a row.