vb.org Archive - Forum Home Enhancements

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Forum Home Enhancements - User Of The Month (https://vborg.vbsupport.ru/showthread.php?t=222579)

Here is another - maybe useful - change... If you have vbexperience installed!!!!! (else there will be some nice error drops *g*) you can do some changes and the best-ranked user will be viewed... I don't know, if the xperience-points are actual everytime, so this is a fast and dirty change, don't set to much hope in it. You should backup your product xml before the changes, maybe something failes...

// After this changes, the mod is an "User of the Moment"-Mod i think, cause the experience points are dynamic and recalculated more often?

Open the product xml and search for:

Code:

$sql = $vbulletin->db->query_read("Select userid, username, avatarrevision From ".TABLE_PREFIX."user

 Where userid = $uid");

The line can change a bit, cause there are linebreaks inside... if you doesn't find this line, search for:

Code:

$sql = $vbulletin->db->query_read("Select userid, username, avatarrevision From

Should be the same line, whatever i haven't tested it.

Replace the line/s with the following code. If you are unsure, you mustn't replace the line, you can write the code below the line you found.

Code:

$sql = $vbulletin->db->query_read("SELECT userid, usergroupid, username, avatarrevision, xperience From ".TABLE_PREFIX."user WHERE (usergroupid <> 6 AND usergroupid <> 8) order by xperience DESC LIMIT 1");

This SQL statement filters the usergroups with the id 6 (Admins) and 8 (Banned) from the experience top list. So these usergroups won't be shown. You can add or remove the usergroups in this statement... to add a ignored usergroup, you hafe to wirte "AND usergroupid <> X" after the "8". X is the placeholder for the usergroup. It's pretty simple.

If you are unsure, do not change anything and only copy the code.

Next search for:

Code:

//////////END SQL

If you found it, add below:

Code:

$uid = $yaz['userid'];

So. That's all the magic. Go to Admin CP and reimport the manipulated product xml... don't forget to change to "override product" else it won't work.

Maybe you could give some feedback, i think it should work but i'm not that sure.

If you get SQL Errors, you can easily reimport the original product xml.

The templates won't change via reimport.

I hope, the next release will have this stuff all inside and maybe some nice xperience-bridged-options...

Version 1.4.0 Added

for some reason avatar still don't work :confused:

What version of vB are you using?

Quote:

Originally Posted by gigaenvy (Post 1881964)

I'm not sure what you were trying to accomplish. In other words, what problem or limitation were you trying to solve by creating this mod?

User of the month should be determined by some criteria or many selectable types of criteria. For example, I would love this mod if it could give me a list of sortable users that had top posts, top activity, most thanks, etc. Then give me the option to clear the monthly results or export them. You can get crazy and have it automatically determine who was the user of the month by the pre-configured admincp settings each month. It would be best if users were emailed telling them how they're doing - "You need two more quality posts to be in the lead"....

This has potential, but so does VBExperience if they took this recommendation.

I totally agree with you giga... good MOD, but useless to me without these things...

Quote:

Originally Posted by gigaenvy (Post 1881964)

User of the month should be determined by some criteria or many selectable types of criteria. For example, I would love this mod if it could give me a list of sortable users that had top posts, top activity, most thanks, etc. Then give me the option to clear the monthly results or export them. You can get crazy and have it automatically determine who was the user of the month by the pre-configured admincp settings each month. It would be best if users were emailed telling them how they're doing - "You need two more quality posts to be in the lead"....

This has potential, but so does VBExperience if they took this recommendation.

I agree 100%,
I have just installed this mod and found it to be completely pointless as it is, I have to decide for myself who is to be the member of the month by typing in a userID. That is not user of the month, that is most favoured by admin user of the month. I've posted a mod request to at least get some kind of choice that is not biased on the admins behalf, if anyone wants to support the request by seconding the request that would be great, it's here:
https://vborg.vbsupport.ru/showthread.php?t=222849

Quote:

Originally Posted by EidolonAH (Post 1882462)

Do it like vbulletin.org..
Make a nomination thread and a poll, and let your users decide.

Is there anyway of putting it above the shoutbox?

works fine for me!!! thank u

install newr version but I still have problem with avtar still there is no avtat or pic

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01307 seconds Memory Usage 1,747KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: