Newest Member Recognition Mod [by Kae]

[Kaeliah]

Newest Member Recognition Mod
By Kaeliah


Modification TOS
**Note that there is no viewable credit required for this mod**

I believe it was enddayne who suggested this Mod. It's just a small code snippet, so here it is.

$query = "SELECT * FROM ".$prefix."users ORDER BY membersince DESC LIMIT 1";
$result = mysql_query($query);
$num = mysql_numrows($result);
$i=0;
while ($i < $num) {
$username=@mysql_result($result, $i, "username");

$article_content = $article_content."<br>Please Welcome our newest user, <a href='profile.php?user=".$username."'>".$username."</a> ";
$i++;
}
// Newest Member Recognition Modification Snippet by Kaeliah of Mysidia Adoptables

Instructions: This code snippet is meant to be placed near the end of the stats.php page, just before the...

// **********************************************************************
// Begin Template Definition
// **********************************************************************

... however it can be placed elsewhere IF you know what your doing!!

That's pretty much it! Enjoy!

 

[Hall of Famer]

Love this script Kaeliah. It looks like a simple but helpful script, lots of members will enjoy it. ^^

 

[Tequila]

Nice work, I'll have to add it in.

 

[Kaeliah]

Thank you. It was enddayne's idea though. I just coded it. XD I'm no good with ideas of my own.

EDIT: ninja'd by enddayne. ^.^

Thanks, hope you like it, it was your suggestion. ^.^

 

[RoconzaArt]

Sorry for sounding dumb but what's "Newest Member Recognition"?

 

[ChibiMaestro]

It shows the username of the most recent account registered.

And Kae, so epical and will be useful.

 

[Kaeliah]

@Roconza, ^.^ don't worry about sounding dumb, nobody is going to penalize you for asking questions. And yes, as Chibi said. It shows the newest registered member, so they can be welcomed.

@Chibi, Thank you!

 

[Plague]

I know you said you just did the coding, but regardless great job Kaeliah. And it could be used for so many different things. For example I edited it to display creatures with the least amount of attention. That way creatures that may be more neglected are there front and center for other users to help out.

 

[Rozel]

This is very nice! It's simple, yet helpful and a nice addition to any site.

@Plague; that's very smart, I think x]

 

[Kaeliah]

Thank you Rozel & Plague. I'm glad you find it useful!

 

[Slix]

Thanks! I modified it to show the last 5 users.