Who Quoted Me? - Version 2.0

[Gamingforce]

[ 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?

John quotes Paris in a reply and also quotes Nicole.
The hack recognizes that John's quoting Paris and Nicole and adds 2 entries to the quotedata table.
Paris and Nicole can see in their "Who Quoted Me?" page that John has quoted their post.
Paris wants to see the post with her quoted on and she clicks the link. She is brought to the post!
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 ]

http://www.gamingforcex.com/chocobo/whoquotedmeex.gif
The link to Who Quoted Me? in the User CP.

http://www.gamingforcex.com/chocobo/whoquotedmess.gif
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]

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.

* integra99 is going to try it out.

[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

[y2krazy]

/me clicks install!

[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.

[Oblivion Knight]

Thanks for the quick fix.. :)

Using this file until Gamingforce comes up with an "official" fixed release.

[Jolten]

Also.. this was missed.


In includes/functions_online.php


Find --------------------------------------
case 'bugs':
$userinfo['action'] = construct_phrase($vbphrase['viewing_x'], 'Bugs'); // Don't report 'bugs' as needing to be translated please :p
break;

Add after --------------------------------

case 'whoquote':
$userinfo['action'] = 'User Control Panel';
$userinfo['where'] = "<a href=\"$userinfo[location]\">Who Quoted $userinfo[username]</a>";
break;



Find---------------------------------

case 'threadrate.php':
$userinfo['activity'] = 'threadrate';
break;

Add after ----------------------------------

case 'whoquotedme.php':
$userinfo['activity'] = 'whoquote';
break;

[robert_2004]

in quotes.php , around line 195 you have:

eval('print_output("' . fetch_template(quote_listquote) . '");');

is this missing the ' ?

shoud be:
eval('print_output("' . fetch_template('quote_listquote') . '");');

[Ber|Art]

Wow, very nice and usefull hack, easy to install and it works with MultiQuote :)

[MikaK]

*install*

Some TABLE_PREFIXES are needed for bbs using one. Oterwise a clean install.
Probably, very handy!

[TwinsX2Dad]

I've been holding off installing this pending the next update (with fixes). Any idea as to the timeline?

It seems to have laid dormant for awhile now.

[auveeb]

/me installs!

[Creative Suite]

great work :)

[lefthome]

Will this script work in 3.07? if yes, do I need to change anything since this was designed fro 3.03?

[bigwest]

Are all the corrections incorporated into this hack yet?

And if so... are they all contained in the initial zip file?

[weaver]

As far as I can tell they haven't.

[reteep]

Any port to vb 3.5?

[lordofgun]

My users love this feature. Would love a 3.5 Gold port.

[lordofgun]

Bump. Any way to get this for 3.5?

[lordofgun]

Gamingforce hasn't been online since July. Can anyone port this to 3.5? Thanks!

[reteep]

Guys, this hack should have been the hack of the year :/

[RolandvonGilead]

Gamingforce hasn't been online since July. Can anyone port this to 3.5? Thanks!


Here I ported it:

https://vborg.vbsupport.ru/showthread.php?t=103768

Greetz
Roland