An overview of user statistics

[dlx]

In Wordpress home page I've insert a button that log in /forum/login.php

I wanted to ask if possible also include an overview of user statistics such as:

recent messages
last visit

etc.

This is the code:

<?php 
    global $vbulletin;
    if ($vbulletin->userinfo['userid']!=0) 
    {
    $username= $vbulletin->userinfo['username'];
    echo "Welcomeback, <b>";
    echo $username;
    echo "!</b>";    }

    else { 
    echo"<form action=\"/forum/login.php\" method=post onsubmit=md5hash(vb_login_password,vb_login_md5password,vb_login_md5password_utf)>
    <script type=text/javascript src=\"".$forumpath."/clientscript/vbulletin_md5.js\"></script>
   User:<input name=vb_login_username type=text id=navbar_username onfocus=\"if (this.value == '$vbphrase[username]') this.value = '';\" size=10 />
    Password:<input id=navbar_username name=vb_login_password type=password size=10 />
    <label for=cb_cookieuser_navbar><input name=cookieuser type=checkbox id=cb_cookieuser_navbar value=1 checked=checked />Ricordami</label>
    <input type=submit title=$vbphrase[enter_username_to_login_or_register] value=\"Log In\" />
    <input type=hidden name=s value=$session[sessionhash] />
    <input type=hidden name=do value=login />        
    <input type=hidden name=vb_login_md5password />
    <input type=hidden name=vb_login_md5password_utf />
    </form>";
    }
?>

And I need to put something like that

// Display last visit time and date
echo "Last visit: $pmbox[lastvisitdate] alle $pmbox[lastvisittime]";

// Display PM Details and generate link to PM box
echo "<a href=\"".$forumpath."private.php?$session[sessionurl] \">Private message:</a> $vbphrase[unread_x_nav_compiled] $vbphrase[total_x_nav_compiled]";

Thanks

[Jeff]

I am not sure what the question is here?

[dlx]

Originally Posted by Jeff

I am not sure what the question is here?

I forgot the question ...eheh

I would like that this code show me the last visit and PM, but it isn't work.

Can you hel me?

// Display last visit time and date
echo "Last visit: $pmbox[lastvisitdate] alle $pmbox[lastvisittime]";

// Display PM Details and generate link to PM box
echo "<a href=\"".$forumpath."private.php?$session[sessionurl] \">Private message:</a> $vbphrase[unread_x_nav_compiled] $vbphrase[total_x_nav_compiled]";

[Jeff]

Hmm did you try this?

global $vb;

echo "Last visit: " . $vb->userinfo[lastvisitdate] . " alle " . $vb->userinfo[lastvisittime];

[dlx]

Thanks work!

Can you help me also to show unread private messages and New Posts?

[Jeff]

I do not know how you would do new posts, but I believe pmunread is the field for pms:

echo $vb->userinfo['pmunread'];

[dlx]

New post:

[dlx]

Hi Jeff did you know vbulletin code to show New Post?

[Jeff]

Originally Posted by dlx

Hi Jeff did you know vbulletin code to show New Post?

I guess something along the line of:

echo "<a href=\"" . $vb->options['bburl'] . "/search.php?do=getnew\">New Posts</a>";

[dlx]

I wanted say something like:

// finds number of new posts
$newposts = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post AS post " . iif($vbulletin->options['threadmarking'], 'LEFT JOIN ' . TABLE_PREFIX . 'threadread AS threadread ON (threadread.threadid = post.threadid AND threadread.userid = ' . $vbulletin->userinfo['userid'] . ')') . " WHERE dateline >= " . $vbulletin->userinfo['lastvisit'] . iif($vbulletin->options['threadmarking'], ' AND dateline > IF(threadread.readtime IS NULL, ' . (TIMENOW - ($vbulletin->options['markinglimit'] * 86400)) . ', threadread.readtime)'));
$newposts = vb_number_format($newposts['count']);

echo"<a href=\"".$forumpath."search.php?$session[sessionurl]do=getnew\">$vbphrase[new_posts]</a>: $newposts<br />";
//  end of number of new posts stuff

[Jeff]

Originally Posted by dlx

I wanted say something like:

// finds number of new posts
$newposts = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "post AS post " . iif($vbulletin->options['threadmarking'], 'LEFT JOIN ' . TABLE_PREFIX . 'threadread AS threadread ON (threadread.threadid = post.threadid AND threadread.userid = ' . $vbulletin->userinfo['userid'] . ')') . " WHERE dateline >= " . $vbulletin->userinfo['lastvisit'] . iif($vbulletin->options['threadmarking'], ' AND dateline > IF(threadread.readtime IS NULL, ' . (TIMENOW - ($vbulletin->options['markinglimit'] * 86400)) . ', threadread.readtime)'));
$newposts = vb_number_format($newposts['count']);

echo"<a href=\"".$forumpath."search.php?$session[sessionurl]do=getnew\">$vbphrase[new_posts]</a>: $newposts<br />";
//  end of number of new posts stuff

That really falls outside the scope of this project. I am pretty pressed for time as it is..... I am just trying to find a nice and polite way of saying: you are going to have to that on your own.

[dlx]

Thanks anyway