Newest REGISTERED member in forumhome.

[MacMorag]

n the board "statistics" is it possible to change "Welcome to our newest member" so that it shows the latest registered member, instead of the default which shows unregistered members too.

The reason: I only allow registered users. Once they have registered they are allowed to upload an image, which is integral to the layout of their profile (as shown by member.php). However, the username appears in the "board statistics" before they have replied to the "verify email" - and if someone clicks on the link, it shows an incomplete profile.

Is there somewhere that I can set the display of the newest user in the "registered" group?

I initially thought that this would be a simple template edit, but it may be more difficult - and require hacking index.php.

Any ideas?

Thanks.

[Chris M]

Edit /includes/functions_databuild.php
Find:

PHP Code:

    // get newest member
    $newuser = $vbulletin->db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members[maxid]"); 


Replace with:

PHP Code:

    // get newest member
    $newuser = $vbulletin->db->query_first("SELECT userid, username, usergroupid FROM " . TABLE_PREFIX . "user WHERE userid = $members[maxid] AND usergroupid NOT IN (3,4,8)"); 


THIS IS UNTESTED

If it doesn't work, this is at least the right area to be looking in

Chris

[MacMorag]

Thanks Chris - I'll try later, and update this thread with outcome.

Cheers.

Iain

[Chris M]

If that doesn't work, try this:

Replace:

PHP Code:

    // get total members
    $members = $vbulletin->db->query_first("
        SELECT
        $sumsql
        COUNT(*) AS users,
        MAX(userid) AS maxid
        FROM " . TABLE_PREFIX . "user
    ");

    // get newest member
    $newuser = $vbulletin->db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members[maxid]"); 


with:

PHP Code:

    // get total members
    $members = $vbulletin->db->query_first("
        SELECT
        $sumsql
        COUNT(*) AS users
        FROM " . TABLE_PREFIX . "user
    ");

    // get newest member
    $newuser = $vbulletin->db->query_first("SELECT userid, username, usergroupid FROM " . TABLE_PREFIX . "user WHERE usergroupid NOT IN (3,4,8) DESC LIMIT 1"); 


Chris

[MacMorag]

Nearly there -

The first solution doesn't work. It just leaves a blank space where the newuser name should appear in the "board stats".

The second solution does work. Well almost. There was an error in the select statement you gave - specifically "(3,4,8) DESC LIMIT 1". So I filled in the blanks, but obviously not correctly.

I used "(3,4,8) ORDER BY userid DESC LIMIT 1, 1" - and results are a bit out, but going in the right direction.

What happens:

UserA is the existing member name displayed in the board stats.

I create UserB. Before I verify the email, UserA is still displayed as the newest member. Great.

I follow the link in the "verify email" - but UserA is still listed as the newest member. Not so good - it should say UserB.

I create another user, UserC. Before I verify, UserA is still listed as newest member. This is good (apart from the fact that it is UserA displayed and not UserB). There has been no change. As wanted.

Once I follow the link in the email, what should happen is that UserC is now displayed as the newest member. But no.

UserB(!) is displayed.

Repeat the process, and UserC is displayed.

So it is working. It's just displaying the newest member(-1).

As I said, this is probably due to me completing the SELECT statement wrongly. But it looks OK - I'm retrieving just one row, which contains the highest userid.

Any ideas what's wrong here?

Thanks again