Future New Underground Membership Criteria Post: 303028991

Sponsored Content

The Lounge What is on Your Mind? Future New Underground Membership Criteria Post 303028991 by Neo on Saturday 19th of January 2019 04:03:11 AM

01-19-2019

Administrator

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

View Public Profile for Neo

Visit Neo's homepage!

Find all posts by Neo

3 More Discussions You Might Find Interesting

1. Post Here to Contact Site Administrators and Moderators

Membership

what is the meaning of the types of membership and when am i a full member:confused: :confused: :confused:

2. Solaris

Group membership limit

On Solaris, a user is limited to being a member of a maximum of 16 groups. Could someone tell me where this limit comes from, i.e. is it NIS, or Solaris, or NFS that is imposing this limit? What is the work-around to remove this limitation?

3. Post Here to Contact Site Administrators and Moderators

monthly membership??

Hi, Do we have monthly membership (VIP) in our forum? if not, do we have any plans for it? Regards,

LEARN ABOUT OPENSOLARIS

mysql_fix_privilege_tables

mysql(1)							  MySQL database							  mysql(1)

NAME

       mysql_fix_privilege_tables - Fixes MySQL privilege tables.

SYNOPSIS

       mysql_fix_privilege_tables [mysql_root_password]

DESCRIPTION

       This scripts updates the mysql.user, mysql.db, mysql.host and the mysql.func tables to MySQL 3.22.14 and above.

       This is needed if you want to use the new GRANT functions, CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

       If you get 'Access denied' errors, run the script again and give the MySQL root user password as an argument.

SEE ALSO

       isamchk(1),  isamlog(1),  mysql(1),  mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysqlshow(1),
       mysql_zap(1), perror(1), replace(1)

       For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available  online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       This manpage was written by Christian Hammers <ch@debian.org>.

       MySQL is available at http://www.mysql.com/.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							   17 March 2003							  mysql(1)