[AngelBlue]

Originally Posted by ndahiya

Good that you're taking the lead on this..

some point re 3.8 -


1. Performance improves greatly if there is a(ny) index on real_user_name in the mw_user table. With about 10K users, the database started overrunning max connections and failing the first time hourly cleanup cron job ran (that is what updates the wiki stats).

Good idea. I wrote this a long time ago, before I became aware of the potential DB issues of running a large forum.

Originally Posted by ndahiya

2. This plugin fails if there are multiple entries for real_user_name (which would happen if you had legacy entries... but it might be better not to make the index unique - might break the linkage. if you fix all the dupes initially, hopefully will not happen again). A way around is to use "SELECT sum(user_editcount) ..... " instead of "SELECT user_editcount ...." in the cron query.

Wouldn't that mean that if you had two users A and B with identical real_user_name entries, they'd each be credited with the sum of A+B wiki edits?

3. the template to be edited for memberinfo is "memberinfo_block_statistics"
wikieditsperday is not showing for some reason (hook location?). the edit i made was:

Find:

<phrase 1="$prepared[username]">$vbphrase[find_all_threads_started_by_x]</phrase></a></li>

insert right after:

<li><br>$vbphrase[total_wikiedits]: $userinfo[wikiedits]</li>

<if condition="$userinfo[wikiedits] > 0">
<li><a href="/wikihome/Special:Contributions/$userinfo[username]" rel="nofollow">Click here to see Wiki edits</a></li>
</if>

Hope this helps...

Here's how I do it:

Originally Posted by in template 'memberinfo_block_statistics', after

<li><a href="search.php?$session[sessionurl]do=finduser&amp;u=$userinfo[userid]&amp;starteronly=1" rel="nofollow"><phrase 1="$prepared[username]">$vbphrase[find_all_threads_started_by_x]</phrase></a></li>

Originally Posted by insert

<if condition="$userinfo[wikiedits] > 0">
<li><a href="http://www.myweb.site/wiki/index.php/Special:Contributions/$userinfo[username]" rel="nofollow">$vbphrase[find_all_wikiedits_by_x] $userinfo[username]</a></li>
</if>