WebDKP Server

[Zevious]

I went ahead and created some new boards to support the host your own server. Should be useful for now until things are ready on opendkp.com

[tiburon]

Is there anyway to have a leaderboard at the top of our webdkp page like I see on other loot system servers..It breaks down each class and who is in the lead with dkp..that would be pretty damn hot to have...

[ermethic]

Any idea about how to adapt the remote.js script of the old webdkp.com site to embed the tables from the new server in a webpage ? I've been trying to do it, but i have very limited scripting knowledge, and i couldn't make it work. It would be an awesome addition to the server's functionality, and i'm sure it's quite easy to accomplish.

[Dense]

Anyone else having issues with the wowhead links not working anymore for new items?

I noticed it with a few items on our old site but didnt think much of it. Now that we have migrated to a new host I imported the backup and every link isnt updating.


Example.

http://www.utilityguild.com/forum/webdkp/Loot/1/date/desc

And the old one. Notice a few didnt update.

Edit: In doing a little research it might be that wowhead changed their xml feed syntax. I can find nothing about it on their site though.

http://old.utilityguild.com/forum/webdkp/Loot/1/date/desc

[Dense]

OK. I fixed it. It looks like they changed the syntax.

In wowstats.php change this line.

const itemUrl = "http://www.wowhead.com/item?={ITEM_NAME}&xml";

to

const itemUrl = "http://www.wowhead.com/item={ITEM_NAME}&xml";

[Zevious]

Nice job Dense

Wish I could be more of a help with the website stuff. I may try to get more involved sometime here in the future.
Thanks for your posts they definitely help others.

Zevious

[Hjalte]

Google code updated with wowstats.php changes (r69) and "experimental" fileutil.php changes (r70).

Released r69 as latest edition zip file.

[ftpfan]

Hi,

I have a big Problem, It wont run, I can do what I want but it wont run.
I just get a white sreen with no Output, No Errors, Nothing.
All plugins who are required run, rewritemod runs, curl runs too.
It is a Apache Win server, with PHP5, all other Sites working, all CMS runs but not WebDKP.
I hope Someone can Help me

The Link to my Site is: www.securum-gilde.info/webdkp/
Status Site: http://www.securum-gilde.info/status.php

Thank you for your Help

FTPFAN

[kyller974]

Maybe a problem with your .htaccess file.

[Merian]

Hello every one.
Im new to this forum, but I have read It entirely through and I didnt find answer on my problem.

I have WebDKP installed on my site (http://www.tolh.cz/webdkp/Dkp). I use it for long time, but I have recently noticed drastic decrease of loot table performance.
Usually it takes about 30+sec to load loot site entirely.

I dont think the problem is my hosting or something like that, but something must be wrong because eg. on this site: http://www.utilityguild.com/forum/webdkp/Loot  loot table loads pretty quick.

Have anyone of you same problems or some advice? Were there some changes in SQL structure in last half year or so?
Thanks
My WebDKp page: http://www.tolh.cz/webdkp/Dkp

[Zedd]

I have a feeling I know whats going on. The default tables created during install are not correctly indexed for the types of queries being made. In fact, I think the out-of-the-box install may not index at all beyond the primary key. I'd have to check the tables again to see how they should be indexed, but that should give ~ a 1000x performance boost.

I'm not sure of the best way to get those indexes in there. For future installs the install code of the site can be fixed. For existing installs, we'd have to update the code to detect if the tables are indexed correctly....

[Merian]

I have no problem with adding this indexes to all necessary tables manualy.
If you can just provide the list of necessary indexes it would by realy great.

[Merian]

Looks like I was able to solve this problem by my self, because the speed of Loot tab increase a lot when I change hosting company.
It was probably something wrong with their MySQL server.