What is on Your Mind?

View Public Profile for RavinderSingh13

01-19-2019

Moderator

3,105, 1,603

Join Date: May 2013

Last Activity: 31 August 2020, 1:46 AM EDT

Location: Chennai

Posts: 3,105

Thanks Given: 1,269

Thanked 1,603 Times in 1,369 Posts

Quote:

Originally Posted by Neo

Recently I did what I was hesitant to do for years, I purged all forum Underground (UG) members who had not been active within a certain period.
We need to change the UG membership criteria (from mod voting) and create a new criteria for UG membership which is not based on "voting" because mods are often busy and not inclined to vote on every member unless asked to vote. This is not really fair to member or moderators. So, I have a new TODO to make entry into the forum Underground based automatic based on a combination of various metrics, TBD.
I have not created the metrics yet, but it will be a combination of things like:

Number of Posts
Number of Thanks from Other Users
Number of Thanks Given to Other Users
Time a Member
Recent Activity
Infractions
Bug Hunter Team Badge

Basically, when a member has a certain number of posts, thanks and time as a member, no active mod infractions, and have reported a verified bug in the forums at least once, they will be automatically promoted to UG member with extra permissions, edit privileges, and other benefits, TBD.
When a UG member is inactive for a certain number of months, they will be automatically demoted back to the "Registered Users" group.
If anyone (including Ravinder, hint hint) would like to suggest the criteria for this automatic promotion to the UG, please reply with your suggested criteria.
Status: TODO

Hello Neo,

Would like to add 2 more criteria here.

1- Number of ideas given by member(Or any useful ideas which are having nice impact for forums).
2- Making F.As volunteer basis also, if we could nominate people for F.A.

Thanks,
R. Singh

This User Gave Thanks to RavinderSingh13 For This Post:

RavinderSingh13

Find all posts by RavinderSingh13

01-19-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

Good idea Ravinder:

Number of Posts
Number of Thanks from Other Users
Number of Thanks Given to Other Users
Time a Member
Recent Activity
Infractions
Bug Hunter Team Badge
Formulator Badge [Recognized for Providing Idea(s) - This badge exists as you know.]

Yes, anyone can nominate anyone else for a "human given" badge, including Forum Advisor (UG) ; but that does not mean it will necessarily be issued immediately.

People have already nominated members for a number of badges, including the coveted "Order of the Wizard's Hat Badge", and we have issued a few "Wizard's Hat Badge" since the badging system was created; but there is currently backlog of "Wizard" badges to issue. Thanks for your patience, Wizards!

PS: Ravinder was the first person to receive the special "Formulator's Badge" based on his many forward-thinking ideas here; including the idea that I should develop a badging system. Well Deserved, Mr. Formulator!

Cheers and Thanks for the Good Idea.

This User Gave Thanks to Neo For This Post:

Neo

01-19-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

Until we refine this UG criteria, I just ran this MySQL query:

Code:

mysql>  select username  from user where posts > 100 AND lastactivity > (UNIX_TIMESTAMP() - (3600*24*60)) and usergroupid = '2' and post_thanks_thanked_times > 25;
+----------------+
| username       |
+----------------+
| derekludwig    |
| drysdalk       |
| stomp          |
| gandolf989     |
| migurus        |
| apmcd47        |
| krishmaths     |
| disedorgue     |
| amitranjansahu |
| figaro         |
| hergp          |
| Skrynesaver    |
| Just Ice       |
| CarloM         |
| rdrtx1         |
| wisecracker    |
| Aia            |
| Akshay Hegde   |
| balajesuri     |
| ctsgnb         |
| Franklin52     |
+----------------+
21 rows in set (0.00 sec)

mysql> update  user set usergroupid =13, usertitle='Forum Advisor', customtitle=1  where posts > 100 AND lastactivity > (UNIX_TIMESTAMP() - (3600*24*60)) and usergroupid = '2' and post_thanks_thanked_times > 25;
Rows matched: 21  Changed: 21  Warnings: 0

We can refine this over time.... It's a good start I think.

My main goal is to insure Forum Advisors (FAs) in the Underground (UG) are at least active within 60 days; have at least 100 posts, at least 25 thanks (to them) and are currently in the "Registered User" group before we promote them. I will run this for VIP members as well.

Maybe we will create another group badge for those who also have the "Formulate" + "Bug Hunter" badges, or something along those lines.

If anyone has any "badge logic" to suggest for the UG or other potential user groups, please reply!

Cheers.

Neo

01-19-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

OK... until we get some better ideas, the system will run this cron once a day:

Code:

<?php
$promote_ug = "update  user set usergroupid =13, usertitle='Forum Advisor', customtitle=1  where posts > 100 AND lastactivity > (UNIX_TIMESTAMP() - (3600*24*60)) and usergroupid = 2 and post_thanks_thanked_times > 25";

$status_up = $vbulletin->db->query_write($promote_ug); 

$demote_ug = "update user set usergroupid = 2, usertitle='Registered User', customtitle=1 WHERE lastactivity <  (UNIX_TIMESTAMP() - (3600*24*60)) and usergroupid = 13"; 

$status_down = $vbulletin->db->query_write($demote_ug);

Looking forward to some great ideas on changing this criteria or adding new badges / user groups.

Neo

View Public Profile for Don Cragun

01-19-2019

Registered User

12,315, 4,560

Join Date: Jul 2012

Last Activity: 22 November 2019, 4:29 PM EST

Location: San Jose, CA, USA

Posts: 12,315

Thanks Given: 952

Thanked 4,560 Times in 3,818 Posts

Quote:

Originally Posted by Neo

OK... until we get some better ideas, the system will run this cron once a day:

Code:

<?php
$promote_ug = "update  user set usergroupid =13, usertitle='Forum Advisor', customtitle=1  where posts > 100 AND lastactivity > (UNIX_TIMESTAMP() - (3600*24*60)) and usergroupid = 2 and post_thanks_thanked_times > 25";

$status_up = $vbulletin->db->query_write($promote_ug); 

$demote_ug = "update user set usergroupid = 2, usertitle='Registered User', customtitle=1 WHERE lastactivity <  (UNIX_TIMESTAMP() - (3600*24*60)) and usergroupid = 13"; 

$status_down = $vbulletin->db->query_write($demote_ug);

Looking forward to some great ideas on changing this criteria or adding new badges / user groups.

Am I reading the above code correctly to believe that if someone has paid 400000 bits to get a custom title, this code will automatically discard that custom title if that user is promoted to or demoted to the underground? Shouldn't custom titles that have been paid for remain with that user (getting only color changes in the title to indicate changes in level) unless that user asked to have the custom title removed?

One of the (private) notes that is about to be or recently was deleted said that a user wasn't going to be asked to become a moderator because it could put him in an awkward position at his job (due to a possible conflict of interest). If that was a valid concern then, should there ever be a promotion without asking the user if (s)he wants that honor first?

Don Cragun

Find all posts by Don Cragun

01-19-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

Don,

No one is going to be embarrassed to be promoted automatically.

We never asked anyone before when we promoted members to the UG by voting and in the long history of the site no UG member has ever asked to not be promoted to the UG.

In additon to my knowledge no member has ever used Bits to get a custom title!

Also "customtitle=1" means "admin sets title" this is for SQL purposes.

There is nothing in this simple, esay UG logic than is a problem based on my understanding and if some rare exception ever happens I will add a line of logic to deal with the exception!

Thanks!

PS: The great majority of peole here do not even use their real names or profile in the forum. If members want to be "secretive" they just use some forum name like "superduper" and "go for it".

Every one has a choice when they register what username to pick. The VAST majority do not use their actual names.

Neo