Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Wiki Edits in Postbits and Profiles Details »»
Wiki Edits in Postbits and Profiles
Version: 5, by AngelBlue AngelBlue is offline
Developer Last Online: May 2018 Show Printable Version Email this Page

Category: Integration with vBulletin - Version: 3.6.10 Rating:
Released: 02-13-2008 Last Update: 11-21-2008 Installs: 6
DB Changes Uses Plugins Template Edits
Re-useable Code Translations  
No support by the author.

This addon has been withdrawn.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 11-22-2008, 09:52 PM
AngelBlue AngelBlue is offline
 
Join Date: Jun 2007
Posts: 125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Current local version works fine for me (including with vB 3.7).
I've replaced the old XML with it. Try this one instead?
Reply With Quote
  #13  
Old 12-13-2008, 02:01 AM
Varsh's Avatar
Varsh Varsh is offline
 
Join Date: Aug 2006
Location: UK
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Superb simple hack, it'll come in handy for my website thanks. I had to modify the plugin to work with the vB SSO a little to get it to work but otherwise it works without a hitch. I have this now working on vB 3.8 b1 and MediaWiki 1.13.2.

To get this to work with the vB SSO all you need to do is change the query (appears twice in the XML) from:
Code:
SELECT user_editcount
FROM mw_user
WHERE user.username = user_real_name
to
Code:
SELECT user_editcount
FROM wiki_user
WHERE user.username = user_name
For me wiki_ is my prefix, it may be different for everyone else, the vB SSO however requires you to use user_name rather than user_real_name.

Here's the modified file if you want to add it to the front page AngelBlue, rename the file as you see fit.
Reply With Quote
  #14  
Old 01-22-2009, 05:19 PM
bagh1 bagh1 is offline
 
Join Date: Jul 2006
Posts: 38
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi,
I have two different databases. One for the main forums and the other for WIKI. The forums database isn't able to see mw_user and I start getting errors like this:

'forums.mw_user' doesn't exist

Any ideas on how to fix this?
TIA!
Reply With Quote
  #15  
Old 01-22-2009, 07:53 PM
Varsh's Avatar
Varsh Varsh is offline
 
Join Date: Aug 2006
Location: UK
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Please read my post above yours, it explains it all in there, in fact mine works.
Reply With Quote
  #16  
Old 01-23-2009, 12:43 AM
AngelBlue AngelBlue is offline
 
Join Date: Jun 2007
Posts: 125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This mod is no longer supported.
It has always worked fine for me on 3.7 and 3.8, but I lack the time to support it.
Reply With Quote
  #17  
Old 01-23-2009, 08:14 AM
Varsh's Avatar
Varsh Varsh is offline
 
Join Date: Aug 2006
Location: UK
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is it alright with you if I modify the code, add extras to it, then release for 3.8?
Reply With Quote
  #18  
Old 01-24-2009, 04:36 AM
AngelBlue AngelBlue is offline
 
Join Date: Jun 2007
Posts: 125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Varsh View Post
Is it alright with you if I modify the code, add extras to it, then release for 3.8?
Yes.
Reply With Quote
  #19  
Old 01-24-2009, 04:30 PM
ndahiya ndahiya is offline
 
Join Date: Aug 2004
Posts: 210
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by bagh1 View Post
Hi,
I have two different databases. One for the main forums and the other for WIKI. The forums database isn't able to see mw_user and I start getting errors like this:

'forums.mw_user' doesn't exist

Any ideas on how to fix this?
TIA!
mysql can access multiple databases in one query.. so name the database wikidatabasename.mw_user ... also make sure that forums-database-user has access to wikidatabasename .

this works fine then.


ndahiya
Reply With Quote
  #20  
Old 01-24-2009, 04:38 PM
ndahiya ndahiya is offline
 
Join Date: Aug 2004
Posts: 210
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Varsh View Post
Is it alright with you if I modify the code, add extras to it, then release for 3.8?
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).

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.

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:
Code:
<phrase 1="$prepared[username]">$vbphrase[find_all_threads_started_by_x]</phrase></a></li>
insert right after:
Code:
<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...
Reply With Quote
  #21  
Old 01-24-2009, 10:30 PM
Varsh's Avatar
Varsh Varsh is offline
 
Join Date: Aug 2006
Location: UK
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm not the greatest at PHP/MySQL and this would be my first take on something so please don't expect anything for a while (I am an extremely busy person). However I'll be doing plenty of tests on my site first between now and whenever I get to release it. If someone else manages to do it before me then props to them.

I'll try and get a plugin working but please remember, no promises. I will have a bash at it though.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:46 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07226 seconds
  • Memory Usage 2,307KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (4)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete