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_zap

zap(1)								  MySQL database							    zap(1)

NAME

       zap - a perl script used to kill processes

USAGE

       /usr/bin/mysql_zap [-signal] [-?Ift] pattern

SYNOPSIS

       zap [-I|-?]  [-f] [-t]

DESCRIPTION

       zap    supports by executing

       -I|-?  info

       -f     force

       -t     test

NOTE

       If  -f isn't given, ask user for confirmation for each process to kill. If signal isn't given, try first with signal 15 and after that with
       signal 9. If -t is given the processes is only shown on stdout.

SEE ALSO

       isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
       lege_tables(1), mysqlshow(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

       Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no war-
       ranty.  Manual  page  by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurme-
       dia.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							 19 December 2000							    zap(1)