Who Quoted Me? - Version 2.0

[ Feature Description ]
This is a very popular feature on my community since it allows people to easily track who's been quoting them. This is very useful because it allows you to easily check up on who's been replying to you! This hack is a HUGE upgrade from the version I made for vBulletin 2.0 because it's precise, fast, supports multiple users, direct post linking and more! This is even more useful than the vb2 version because vB3 doesn't search for your username within quote tags!

How does it work?

1. John quotes Paris in a reply and also quotes Nicole.
2. The hack recognizes that John's quoting Paris and Nicole and adds 2 entries to the quotedata table.
3. Paris and Nicole can see in their "Who Quoted Me?" page that John has quoted their post.
4. Paris wants to see the post with her quoted on and she clicks the link. She is brought to the post!
5. Everyone is happy and John enjoys a Chalupa from Taco Bell.*

For such a useful feature, it's incredibly easy to install! Just modify one line in a file, add two templates, modify one template and run a query!

You can easily modify the number of results to display for the user! Just change the $zig in the whoquotedme.php file!

[ Screenshots ]


The link to Who Quoted Me? in the User CP.


A screenshot of the Who Quoted Me? page. I quoted myself 3 times because I just reset the quotedata table and nobody really wants to quote me.

Enjoy!

[integra99]

seems like it would be a quite a server intensive process, no?

[Gamingforce]

Nope not at all! The quote data is saved once into a small database row that uses only numbers as the post is made and is only pulled when someone a user views the Who Quoted Me? page.

Even with over 250 concurrent users on my board, this hack hasn't slowed anything down one bit!

[integra99]

Originally Posted by Gamingforce

Nope not at all! The quote data is saved once into a small database row that uses only numbers as the post is made and is only pulled when someone a user views the Who Quoted Me? page.

Even with over 250 concurrent users on my board, this hack hasn't slowed anything down one bit!

Hmm, sounds like a good design.

[high]* integra99 is going to try it out.[/high]

[reteep]

Sounds pretty nice, installing it now!

[Natch]

Nice job ! Excellent work...

Question: is there any way you can add a new Maintenance task to rebuild the WhoQuoted table based on an analysis of all post?

[Gamingforce]

A script that builds quotadata by going through all posts prior to installation of this hack is in the works. It's not going to change the current script or data at all so feel free to install it now.

[Natch]

Good on you - thanks for this

[Natch]

And u forget two things in your install script:

==========================================================
[OPEN FILE includes/functions_user.php]
==========================================================
[FIND]-->
		'event_reminders',

[REPLACE WITH]-->
		'event_reminders',
		'whoquotedme',
==========================================================

and

==========================================================
[FIND]-->
==========================================================
<tr>
	<td class="alt2" nowrap="nowrap"><a class="smallfont" href="whoquotedme.php?$session[sessionurl]">Who Quoted Me?</a></td>
</tr>
==========================================================
REPLACE WITH -->
==========================================================
<tr>
	<td class="$navclass[whoquotedme]" nowrap="nowrap"><a class="smallfont" href="whoquotedme.php?$session[sessionurl]">Who Quoted Me?</a></td>
</tr>

[YabbaDabba]

First off, Bravo!!

I've been looking for something like this for vB 3.x for awhile now.
Members want to easily see who is trying to converse with them.
So I will definitely be trying this out!!

I do have a request/suggestion.
Rather than bury the link in the CP, wouldn't it make sense to put a link in the main menu bar? A popular feature suggests a need for ease of access. I would suggest adding a "My Conversations"(?) link to the "Quick Links" pop-up menu near "New Posts." This would make it very easy to access and increase its popularity further.

Again, many thanks for your work!

[Jolten]

YAY!! Great! Finally!!! Thank you!!!!

Now.... can I make it email the user when they are quoted in a post?

[Gamingforce]

I guess I could add these in an update.

[Shock.r]

NM, got it to work!

[lordofgun]

Would it be possible to exclude certain usergroups from using this? How?

Thanks in advance for your help!

[Sleep]

Having an error....

My tables have the prefix Vb3_

So it should be deluzion_vb.Vb3_user

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT userid FROM user WHERE username = 'sleep'
mysql error: Table 'deluzion_vb.user' doesn't exist

mysql error number: 1146

Date: Friday 27th of August 2004 01:25:04 AM
Script: http://deluzions.net/forum/newreply.php
Referer: http://deluzions.net/forum/newreply.php
Username: Sleep