User Notes Icon/Link in Postbit, if user has notes

Description:
This modification adds an icon and link to a member's usernotes in the postbit template. The icon will only appear to the people with proper permissions for viewing notes. The icon will only appear IF the member actually has usernotes posted about them. Icon links directly to that member's notes. Rolling over the icon reveals the number of notes a member has posted about them.

Time to install: 5 minutes or less.

Files to Modify: 1 php file, 1 template.

Graphic included.

- - - - -

------ FILE CHANGE -------

OPEN showthread.php

FIND:

PHP Code:

        // get first and last post ids for this page (for big reply buttons) 


ADD right ABOVE it:

PHP Code:

   // ###### MOD display user notes in postbit if user has notes MOD ######
    $usernote = $DB_site->query_first("
        SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
        FROM " . TABLE_PREFIX . "usernote AS usernote
        WHERE userid = $post[userid]
    ");
    $show['hasusernote'] = iif($usernote['total'], true, false);
    $show['usernotetotal'] = $usernote['total']; 


Save showthread.php
Close and upload.


----- TEMPLATE CHANGE -----

OPEN postbit

FIND:

PHP Code:

            $post[iplogged] 


ADD right BELOW it:

PHP Code:

            <if condition="(($post['userid'] == $bbuserinfo['userid'] AND $permissions['genericpermissions'] & CANVIEWOWNUSERNOTES) OR ($post[userid] != $bbuserinfo['userid'] AND $permissions['genericpermissions'] & CANVIEWOTHERSUSERNOTES)) AND $show[hasusernote]">&nbsp;<a href="usernote.php?$session[sessionurl]u=$post[userid]"><img src="images/buttons/notes.gif" border=0 alt="$show[usernotetotal]"></a></if> 


Save changes.


----- ADDITIONAL IMAGE UPLOAD -----

Use provided notes.gif image, or make your own.

UPLOAD into directory images/buttons (or other appropriate image directory of your choosing).

If you upload into a different directory, be sure to change the IMG SRC code in postbit to refer to the correct place.


That's it, you're done.

[Bison]

Good job SFishy!

[alkatraz]

Great idea! Makes the user notes feature a lot more useful and convenient

Excellant Hack, simple but useful.

[SFishy]

Originally Posted by pseudo class

Excellant Hack, simple but useful.

Glad you guys like it --
One thing I just added to the mod .txt file...

PHP Code:

----- OPTIONAL TEMPLATE CHANGE -----

If you want "Post Usernote About MemberX" to appear in the postbit user dropdown.  Will ONLY appear for people who have permission to add/view notes.

OPEN postbit (or postbit_legacy)

FIND:

         $vbphrase[add_x_to_buddy_list]</phrase></a></td></tr>
    </if>
    
ADD right BELOW it:

    <if condition="(($post['userid'] == $bbuserinfo['userid'] AND $permissions['genericpermissions'] & CANVIEWOWNUSERNOTES) OR ($post[userid] != $bbuserinfo['userid'] AND $permissions['genericpermissions'] & CANVIEWOTHERSUSERNOTES))"><tr><td class="vbmenu_option"><a href="usernote.php?$session[sessionurl]do=newnote&amp;u=$post[userid]">Post Usernote About $post[username]</a></td></tr>
    </if>
    
Save changes. 


Just makes it's easier to immediately select to post usernotes about a member.

[Alien]

Awesome enhancement, thanks so much!

[SnowBot]

I had this for vb2 nice addition.

[jmacieira]

Nice i instalade

but i correct the center gif

<if condition="(($post['userid'] == $bbuserinfo['userid'] AND $permissions['genericpermissions'] & CANVIEWOWNUSERNOTES) OR ($post[userid] != $bbuserinfo['userid'] AND $permissions['genericpermissions'] & CANVIEWOTHERSUSERNOTES)) AND $show[hasusernote]">&nbsp;<a href="usernote.php?$session[sessionurl]u=$post[userid]"><img class="inlineimg" src="$stylevar[imgdir_button]/notes.gif" alt="$show[usernotetotal]" border="0" /></a> &nbsp;</if>

[ttlgDaveh]

Nice hack, although I would suggest adding

PHP Code:

if($post[userid] !='') 


around the query as you get nice DB errors if you have any posts without userids, as happened to me in a botched upgrade from one forum software to another several years ago.

[trackpads]

I got this whenever someone tried to open a post made by a guest user:

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT MAX(dateline) AS lastpost, COUNT(*) AS total
FROM usernote AS usernote
WHERE userid =

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

mysql error number: 1064

Date: Tuesday 25th of January 2005 08:19:27 AM
Script: http://www.trackpads.com/forum/showthread.php?t=83928
Referer: http://www.trackpads.com/mail/read.e...69710&show=msg
Username: Hannibal
IP Address: 68.18.124.54

I have USENET import on my site and the posts from the usenet posters are guests.

Thanks,

-Jason