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
Old 01-19-2019
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.
 

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: (1 Reply)
Discussion started by: nigel
1 Replies

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? (4 Replies)
Discussion started by: son_t
4 Replies

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, (1 Reply)
Discussion started by: clx
1 Replies
ALCC(1) 							  aMule utilities							   ALCC(1)

NAME
alcc - text based eD2k links calculator for aMule SYNOPSIS
alcc [-p] [-v] <inputfiles_list> alcc [-h] DESCRIPTION
Compute the eD2k links of all the input files given in the <inputfiles_list> (There can be one or more files). [ -p, --parthashes ] Compute and add part hashes to the computed eD2k links. [ -h, --help ] Prints a short usage description. [ -v, --verbose ] Be verbose - show also calculation steps. REPORTING BUGS
Please report bugs either on our forum (http://forum.amule.org/), or in our bugtracker (http://bugs.amule.org/). Please do not report bugs in e-mail, neither to our mailing list nor directly to any team member. COPYRIGHT
aMule and all of its related utilities are distributed under the GNU General Public License. SEE ALSO
alc(1), amuled(1), amulecmd(1), amuleweb(1), cas(1), ed2k(1), wxcas(1), xas(1) AUTHOR
This manpage was written by Vollstrecker <amule@vollstreckernet.de> aMule eD2k links calculator November 2011 ALCC(1)
All times are GMT -4. The time now is 04:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy