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...
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...
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
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
Do it like vbulletin.org..
Make a nomination thread and a poll, and let your users decide.
User Of The Month Details »»
About Developer
Uses Plugins 
No support by the author.
09-09-2009, 01:30 PM
