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!

[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

[y2krazy]

/me clicks install!

[lordofgun]

Originally Posted by lordofgun

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

Thanks in advance for your help!

anyone? :ermm:

[Oblivion Knight]

Another great hack from the master..

Thank you.!

[buro9]

There is one major problem with this hack.

Permissions.

If you have two forums:
* An admin/mods forum
* Public chit chat forum

And you have an incident in the public forum... so you quote the incident in the private (registered users can't get there) forum... then this appears in that users Who Quoted Me? page.

This should not be the case.

Regardless of where the quote is made... whatever permissions apply to the forum that the thread the contains the quote is in, these should be applied to the Who Quoted Me? page.

So... If user A cannot see the admin forum, then when user A is quoted in the admin forum user A should not see the thread in the Who Quoted Me? page.

This was reported to me by a user who is on probation on our forum, and that should never have happened.

Please issue an update.

[buro9]

There was a second problem too... it didn't cache the templates that were being used.

And a third problem... the queries were inefficient... 3 seperate queries! 2 of those in a loop. So if you had the default 20 quotes set, then you would perform 41 queries in total. Really no need for that.

However, I shall give credit where it's due. The idea is brilliantly done and the database table is perfect No crude and no playing with vBulletin tables.

Anyhow... could the hack author take a look at the version of whoquotedme.php I've attached and consider merging the changes into the one in your zip file.

I've added the template caching.
I've added the forum permissions logic.
I've reduced the whole thing down to 1 database query.
So on your average site it will only be 11 queries to generate the page and not 52.

The file is attached, I'm sure others might also want to look and merge the differences.