PDA

View Full Version : Newest Member Recognition Mod [by Kae]


Kaeliah
01-20-2011, 12:23 PM
Newest Member Recognition Mod
By Kaeliah


Modification TOS (http://www.mysidiaadoptables.com/forum/blog.php?cp=3)
**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 AdoptablesInstructions: 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
01-20-2011, 12:38 PM
Love this script Kaeliah. It looks like a simple but helpful script, lots of members will enjoy it. ^^

Tequila
01-20-2011, 12:42 PM
Nice work, I'll have to add it in.

Kaeliah
01-20-2011, 12:43 PM
Thank you. :smile: 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
01-20-2011, 02:00 PM
Sorry for sounding dumb but what's "Newest Member Recognition"?

ChibiMaestro
01-20-2011, 02:03 PM
It shows the username of the most recent account registered.

And Kae, so epical and will be useful. :)

Kaeliah
01-20-2011, 02:11 PM
@Roconza, ^.^ don't worry about sounding dumb, nobody is going to penalize you for asking questions. :smile: And yes, as Chibi said. It shows the newest registered member, so they can be welcomed.

@Chibi, Thank you! :D

Plague
03-28-2011, 09:01 PM
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
03-28-2011, 09:04 PM
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
04-02-2011, 02:19 AM
Thank you Rozel & Plague. :) I'm glad you find it useful!

Slix
04-02-2011, 12:44 PM
Thanks! I modified it to show the last 5 users. :D