[BETA] Last Post by User in Profile 0.1.1

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Post Reply
alexi02
Registered User
Posts: 271
Joined: Fri Mar 05, 2004 2:15 am
Location: Australia
Contact:

[BETA] Last Post by User in Profile 0.1.1

Post by alexi02 »

MOD Title: Last Post by User in Profile
MOD Description: In the user's profile it shows the thread they last posted in and the time they posted
MOD Version: 0.1.1

MOD Download: Last Post by User in Profile 0.1.1 (5.22 KB)
Last Stable version: N/A

MOD Screenshot: Profile

MOD History:
2006-09-10 - Version 0.1.1
- Added LIMIT 0, 1 to Posts SQL query (thanks eviL<3)

2006-09-10 - Version 0.1.0
- Initial Release (for phpBB 2.0.21)

Author Notes:
A quick way to see the user's last post.


Please post any problems or ways to improve this mod here.
I'm not sure if this mod has been done before or not.

alexi02.
Last edited by alexi02 on Sun Sep 10, 2006 11:42 am, edited 3 times in total.
User avatar
Emufarmers
Registered User
Posts: 811
Joined: Tue Jul 18, 2006 11:12 am
Contact:

Re: [BETA] Last Post by User in Profile 0.1.0

Post by Emufarmers »

alexi02 wrote: MOD Title: Change Your Password Reminder

Always be careful when copying a template. :P

(The mod looks neat. :))
alexi02
Registered User
Posts: 271
Joined: Fri Mar 05, 2004 2:15 am
Location: Australia
Contact:

Post by alexi02 »

Hehe, fixed :P
User avatar
igorw
Former Team Member
Posts: 8024
Joined: Fri Dec 16, 2005 12:23 pm
Location: {postrow.POSTER_FROM}
Name: Igor Wiedler

Post by igorw »

Very nice, but i suggest you to do this:

Code: Select all

// Posts SQL
$sql = "SELECT post_id, topic_id, post_time
        FROM " . POSTS_TABLE . "
        WHERE poster_id = " . $profiledata['user_id'] . "
        ORDER BY post_time DESC
        LIMIT 0, 1";
The "LIMIT 0, 1" part will make the query faster ;)
Igor Wiedler | area51 | GitHub | trashbin | Formerly known as evil less than three
alexi02
Registered User
Posts: 271
Joined: Fri Mar 05, 2004 2:15 am
Location: Australia
Contact:

Post by alexi02 »

Cheers, added.

2006-09-10 - Version 0.1.1
- Added LIMIT 0, 1 to Posts SQL query (thanks eviL<3)
tunafish
Registered User
Posts: 152
Joined: Sat Jul 23, 2005 1:29 pm

Post by tunafish »

Cool mod, tho its not using the AUTH system like this mod: http://www.phpbb.com/phpBB/viewtopic.php?t=439886
phpBB Problems? PM ME :)
maico
Registered User
Posts: 16
Joined: Sun Jun 27, 2004 5:06 pm

Post by maico »

hey hello,

first i want say sorry for may bad englisch :oops:

I playing around with this mod as total layman :oops:
This mod is working verry nice, accept i would to see this function in my members list.
Is this possible?
I wanne create a extra field wit there in the last post, so i can see on one page who have make the last post.
Image
I wanna that this way because we are deleted members after 40 day non posting.

can sombody help me figure it out please, but remember I`m total layman but i can instal a mod :lol:
alexi02
Registered User
Posts: 271
Joined: Fri Mar 05, 2004 2:15 am
Location: Australia
Contact:

Post by alexi02 »

## MOD Title: Last Post by User in Memberlist
## MOD Author: alexi02 < N/A > (Alejandro Iannuzzi) http://www.uzzisoft.com
## MOD Description: In the memberlist it shows the last time each user posted
## MOD Version: 0.1.0

Download here - http://www.uzzisoft.com/projects/last_p ... v0.1.0.txt
maico
Registered User
Posts: 16
Joined: Sun Jun 27, 2004 5:06 pm

Post by maico »

hey alexi02

Great!!
Thanks it works good!! :wink:
Post Reply

Return to “[2.0.x] MODs in Development”