Forum Subject: New users

Posted on: 12/30/04 01:53pm
By: Anonymous (Luke)

Can someone please tell me how can I make a simple PHP script that displays the users that registered today.

Is there anything like this already available?

Thanks.

New users

Posted on: 12/30/04 01:57pm
By: Dirk

This[*1] is a start ...

bye, Dirk

New users

Posted on: 12/30/04 03:08pm
By: Anonymous (Luke)

Thanks for that.

I still have no clue how to do it.

I was trying this code:

$result = mysql_query
("SELECT COUNT(*) FROM gl_users WHERE regdate='".date("M d, Y")."'");

How can I compare the current date with the date (and time) Geeklog uses when users register?

Thanks.

New users

Posted on: 12/30/04 09:07pm
By: Anonymous (Alfred)

This looks great. I would like to use it. Anyone has done this yet?

New users

Posted on: 12/31/04 11:55am
By: Anonymous (Luke)

Anyone please?

I still didn't manage to get it to work?

New users

Posted on: 12/31/04 05:45pm
By: machinari

this works for me... a variation of phpblock_whos_new for your lib-custom.php

/*
// NOTE: just a slight variation of  ***function phpblock_whos_new()***
// this returns users (up to limit) that have registered today.
*/

function phpblock_whos_new_today(){
    global $_CONF, $_TABLES;

    $today = date("Y-m-d") . ' 00:00:00';
    $numToShow = 5;

    $result = DB_query("SELECT uid,username,photo FROM {$_TABLES['users']} WHERE regdate > '$today' ORDER BY regdate DESC limit $numToShow");

    $nrows = DB_numRows($result);
    for ($i = 1; $i <= $nrows; $i++) {
        $A = DB_fetchArray($result);
        $retval .= '<a href="' . $_CONF['site_url'] . '/users.php?mode=profile&uid=';
        $retval .= $A['uid'] . '">' . $A['username'] . '</a>';
        if (!empty($A['photo']) AND $_CONF['allow_user_photo'] == 1) {
            $retval .= ' <a href="' . $_CONF['site_url'];
            $retval .= '/users.php?mode=profile&uid=' . $A['uid'] . '"><img src="';
            $retval .= $_CONF['layout_url'] . '/images/smallcamera.gif" border="0"></a>';
        }
        $retval .= '';
    }
    return $retval;
}