vb.org Archive - Who Quoted Me?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Who Quoted Me? - Version 2.0 (https://vborg.vbsupport.ru/showthread.php?t=67938)

Gamingforce

08-02-2004 10:00 PM

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?

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

08-03-2004 06:20 AM

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

Gamingforce

08-03-2004 06:26 AM

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

08-03-2004 06:29 AM

Quote:

Originally Posted by Gamingforce

Hmm, sounds like a good design.

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

reteep

08-03-2004 07:16 AM

Sounds pretty nice, installing it now!

Natch

08-03-2004 10:57 AM

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

08-03-2004 01:05 PM

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

08-03-2004 01:43 PM

Good on you - thanks for this :)

Natch

08-03-2004 01:57 PM

And u forget two things in your install script:

Code:

==========================================================

[OPEN FILE includes/functions_user.php]

==========================================================

[FIND]-->

                'event_reminders',



[REPLACE WITH]-->

                'event_reminders',

                'whoquotedme',

==========================================================

and

Code:

==========================================================

[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

08-06-2004 03:48 PM

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

08-06-2004 06:19 PM

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

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

Gamingforce

08-07-2004 10:14 AM

I guess I could add these in an update. :)

Shock.r

08-18-2004 12:51 AM

NM, got it to work!

lordofgun

08-26-2004 04:52 PM

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

Thanks in advance for your help!

Sleep

08-27-2004 04:33 AM

Having an error....

My tables have the prefix Vb3_

So it should be deluzion_vb.Vb3_user

Quote:

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

08-30-2004 01:10 AM

/me clicks install!

lordofgun

08-30-2004 04:22 PM

Quote:

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

08-31-2004 07:49 PM

Another great hack from the master..

Thank you.! :)

buro9

09-26-2004 08:52 PM

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

09-26-2004 09:55 PM

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

09-27-2004 09:42 AM

Thanks for the quick fix.. :)

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

Jolten

09-27-2004 04:24 PM

Also.. this was missed.

Code:

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

10-10-2004 03:39 AM

in quotes.php , around line 195 you have:

Code:

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

is this missing the ' ?

shoud be:

Code:

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

Ber|Art

10-19-2004 04:03 PM

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

MikaK

01-05-2005 09:09 AM

*install*

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

TwinsX2Dad

01-05-2005 01:26 PM

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

01-08-2005 09:47 PM

/me installs!

Creative Suite

01-08-2005 11:32 PM

great work :)

lefthome

03-13-2005 10:15 PM

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

bigwest

03-30-2005 10:32 PM

Are all the corrections incorporated into this hack yet?

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

weaver

04-18-2005 08:54 PM

As far as I can tell they haven't.

reteep

10-04-2005 05:46 AM

Any port to vb 3.5?

lordofgun

10-15-2005 03:05 AM

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

lordofgun

10-18-2005 07:12 PM

Bump. Any way to get this for 3.5?

lordofgun

10-24-2005 11:29 PM

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

reteep

11-25-2005 05:49 AM

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

RolandvonGilead

12-26-2005 10:09 AM

Quote:

Originally Posted by lordofgun

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

All times are GMT. The time now is 04:43 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01194 seconds Memory Usage 1,811KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (37)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: