The Arcive of vBulletin Modifications Site.

Newest Member's First Post! (v1.1) · **Released**: 08-30-2002

Ok, here is my 3rd Hack, the first with all of the code actually being mine

Updated with Velocd's fix! :banana:

So, what does this hack do, you ask? It adds a link next to the newest member taking you to their first post. If the user doesn not have a post, no link is shown.

So, here we go!

To Do:
2 File Mods (root/index.php)
1 Template Edit (forumhome)

---------------------------------------
New Member's First Post hack by squall14716
Inspired by ezboard.
---------------------------------------

---------------------------------------
open index.php
---------------------------------------
find:
---------------------------------------

Code:

$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");

---------------------------------------
replace with:
---------------------------------------

Code:

$getnewestusers=$DB_site->query_first("SELECT userid,username,lastpost FROM user WHERE 
userid=$numbersmembers[max]");

---------------------------------------
find:
---------------------------------------

Code:

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

---------------------------------------
add under:
---------------------------------------

Code:

if ($getnewestusers['lastpost'] != 0) {
$getnewusersposts=$DB_site->query_first("SELECT * FROM post WHERE userid=$newuserid LIMIT 1"); 
 $userfirstpost=$getnewusersposts['postid']; 
 
 if (!$getnewusersposts) {
 $firstpost="";
 } else {
 $firstpost=" | <a href='showthread.php?postid=$userfirstpost#post$userfirstpost'>First Post!</a>";
 }
}

---------------------------------------
Save and Close
---------------------------------------
Open up forumhome template
---------------------------------------
find:
---------------------------------------

Code:

      Welcome to our newest member, <a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$newuserid">$newusername</a>

---------------------------------------
Add DIRECTLY AFTER (on the same line)
---------------------------------------

Code:

$firstpost

---------------------------------------

Post any bugs/questions/suggestions here.

:banana:

N9ne · #2 08-30-2002, 10:37 PM

screen?

Link14716 · #3 08-30-2002, 10:39 PM

Hold your horses! I just posted it and am on a crappy comp

Edit: Screen :banana:

lordofgun · #4 08-30-2002, 10:45 PM

nice!

Vile · #5 08-30-2002, 11:08 PM

Nice hack, works great

N9ne · #6 08-30-2002, 11:28 PM

Looks good.

FFMania · #7 08-31-2002, 12:05 AM

[high]* FFMania clicks "installed" button

[/high]

Link14716 · #8 08-31-2002, 12:16 AM

Glad to here no one has had any problems with this hack.

Quick, easy, bug-free that I know of. Thanks everyone

Velocd · #9 08-31-2002, 04:47 AM

Nifty idea, I might consider it

Only for my members though, since I just use Afterlabs top 10 posts whenever viewing a new members posts, to review more than just one.

Velocd · #10 08-31-2002, 04:57 AM

A small tip that might save you a query. By looking at your code, it would seem if the new member has not made a post, then an extra query is being called anyway just to check. This can be avoided though.

In index.php replace:

PHP Code:


			$getnewestusers=$DB_site->query_first("SELECT userid,username,posts FROM user WHERE userid=$numbersmembers[max]");

With:

PHP Code:


			$getnewestusers=$DB_site->query_first("SELECT userid,username,posts,lastpost FROM user WHERE userid=$numbersmembers[max]");

Now in Link14716 hack, replace:

PHP Code:


			$getnewusersposts=$DB_site->query_first("SELECT * FROM post WHERE userid=$newuserid LIMIT 1"); 
 $userfirstpost=$getnewusersposts['postid']; 
 
 if (!$getnewusersposts) {
 $firstpost="";
 } else {
 $firstpost=" | <a href='showthread.php?postid=$userfirstpost#post$userfirstpost'>First Post!</a>";
 }

With:

PHP Code:


			if(getnewestusers['lastpost'] != 0){
$getnewusersposts=$DB_site->query_first("SELECT * FROM post WHERE userid=$newuserid LIMIT 1"); 
 $userfirstpost=$getnewusersposts['postid']; 
 
 if (!$getnewusersposts) {
 $firstpost="";
 } else {
 $firstpost=" | <a href='showthread.php?postid=$userfirstpost#post$userfirstpost'>First Post!</a>";
 }
}

This is untested, but should work