Not Show New Member Name Right Away

[Diva]

How do I take out moderated users? Forgive me, I am not php saavy... at all.

[Erwin]

Okay, I've changed my code to reflect that. Try to change index.php and online.php using the above code.

Also, instead of using the original index.php code for newest member, use this:

PHP Code:

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username,usergroupid FROM user WHERE userid<=$numbersmembers[max] AND usergroupid<>4 ORDER BY userid DESC");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid']; 


This way you don't exclude valid members who are just waiting for email verification.

[Erwin]

Use the code from the previous posts - I have modified it to work for usergroupid 4. And also the above post.

[Diva]

Umm... I don't any names of members waiting for email notification or moderation showing up. If they do, then his insulting username shows. See, first it goes to email validation. Then It goes into moderation. How can I get it back so that only registered members who I have sent an email to okay show?

That means usergroup 3 and 4 doesnt show... How do I do that?

[Erwin]

Do this:

In index.php, find:

PHP Code:

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid']; 


Replace with:

PHP Code:

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username,usergroupid FROM user WHERE userid<=$numbersmembers[max] AND usergroupid<>3 AND usergroupid <>4 ORDER BY userid DESC");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid']; 


Then, find:

PHP Code:

$loggedins=$DB_site->query("SELECT DISTINCT session.userid,username,invisible,usergroupid
                              FROM session
                              LEFT JOIN user ON (user.userid=session.userid)
                              WHERE session.userid>0 AND session.lastactivity>$datecut
                              ORDER BY invisible ASC, username ASC"); 


Replace with:

PHP Code:

$loggedins=$DB_site->query("SELECT DISTINCT session.userid,username,invisible,usergroupid
                              FROM session
                              LEFT JOIN user ON (user.userid=session.userid)
                              WHERE session.userid>0 AND session.lastactivity>$datecut AND user.usergroupid<>3 AND user.usergroupid<>4
                              ORDER BY invisible ASC, username ASC"); 


In online.php (I'm going to try a different approach),

Find:

PHP Code:

  $allusers= $DB_site->query("SELECT user.username, session.location, session.lastactivity, user.userid, user.usergroupid, user.invisible, session.host, user.showemail, user.receivepm
                              FROM session
                              ". iif($WOLguests, " LEFT JOIN user USING (userid) ", ",user") ."
                              WHERE session.lastactivity > $datecut
                              ". iif(!$WOLguests, " AND session.userid = user.userid", "") ."
                              ORDER BY user.username
                              "); 


Replace with:

PHP Code:

  $allusers= $DB_site->query("SELECT user.username, session.location, session.lastactivity, user.userid, user.usergroupid, user.invisible, session.host, user.showemail, user.receivepm
                              FROM session
                              ". iif($WOLguests, " LEFT JOIN user USING (userid) ", ",user") ."
                              WHERE session.lastactivity > $datecut AND user.usergroupid <>3 AND user.usergroupid <>4 
                              ". iif(!$WOLguests, " AND session.userid = user.userid", "") ."
                              ORDER BY user.username
                              "); 


See if that works.

I am leaving for home now, and won't check this thread until tomorrow, so I hope it works!

[Diva]

Hi. The index part works great. Unfortunately the online part also wipes out the guests.

I took the online part of one of the hacks and it worked. Yay! Thank you sooo much.

[Xenon]

Erwin, that's new to me here...

normally you can use fields in where clause without include them into the select clause...
How old's your MySQL Diva?

[Erwin]

Xenon, you can't unless you include a SELECT * as well - but I'm no expert.

[Xenon]

im sure you can erwin, here's a part of an original vb code (index.php)

PHP Code:

    $birthdays = $DB_site->query_first("SELECT template FROM template WHERE title='birthdays' and templatesetid = -2"); 


you can see templatesetid and title are not included in the select, but they are in where :P

[Erwin]

Mmm... maybe templates are different as they are made global... I know when I write my own hacks, I have to SELECT the variable for it to be used as a conditional.