Miscellaneous Hacks - Who Quoted Me

In the user control panel, users can now see a list of the last few people who have quoted them.
This is a great way to encourage users to interact with each other as they can easily keep track of conversations within threads.


If you use this i would really appreciate any small donation

EDIT:
Looks like there a few bugs in this I dont have a computer at the moment but Freshfoot has made an updated release with some new features: https://vborg.vbsupport.ru/showpost....1&postcount=30

[dartho]

Found a small bug. You need to edit the "Load Quotes" plugin on the usercp_start hook and change $vbulletin->options['wqmmax'] to $vbulletin->options['wqm_max'] otherwise you get MySQL errors when trying to enter usercp.

Good work :up:

[Edit]You should probably also use the $stylevar[imgdir_button] when loading the collapse button rather than a hard coded path - I think there is more to it than just that, but that's what I needed to change to use my custom buttons.

[sulasno]

tagged and thanks

@dartho; please explain $stylevar[imgdir_button] ; thanks

[Wonksta]

Originally Posted by dartho

Found a small bug. You need to edit the "Load Quotes" plugin on the usercp_start hook and change $vbulletin->options['wqmmax'] to $vbulletin->options['wqm_max'] otherwise you get MySQL errors when trying to enter usercp.

Good work :up:

[Edit]You should probably also use the $stylevar[imgdir_button] when loading the collapse button rather than a hard coded path - I think there is more to it than just that, but that's what I needed to change to use my custom buttons.

Will download and Install once this coders recommendations are implemented. Can't wait!

[Alfa1]

Please add quote notifications to the notification drop down:

4 of your posts have been quoted

[dartho]

Originally Posted by sulasno

tagged and thanks

@dartho; please explain $stylevar[imgdir_button] ; thanks

This would only be an issue if you have custom styles (buttons in particular) in a custom path. If so, edit the template usercp_who_quoted_me and change src="images/buttons/collapse_tcat.gif" to src="$stylevar[imgdir_button]/collapse_tcat.gif"

Alpha - that is already implemented, although it current only has "Quotes n" - you'd have to edit the wqm_quotes phrase and change to something like "Number of posts quoted" if you wished to be more verbose ...

[Wonksta]

What kind of stress does this put on the server fetching quotes?

[Alfa1]

Im getting a DB error:

Database error in vBulletin 3.8.6:

Invalid SQL:
SELECT user.username, quote.*, post.threadid, thread.title
    FROM vb6_quotedatanew As quote
    LEFT JOIN vb6_post AS post ON(quote.postid = post.postid)
    LEFT JOIN vb6_thread AS thread ON(post.threadid = thread.threadid)
    LEFT JOIN vb6_user AS user ON(user.userid = quote.quoter)
    WHERE quote.quoted = '1' ORDER BY quote.dateline DESC LIMIT;

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 6
Error Number  : 1064
Request Date  : Sunday, January 30th 2011 @ 02:36:38 AM
Error Date    : Sunday, January 30th 2011 @ 02:36:38 AM
Script        : http://www.my-forum.com/forum/usercp.php
Referrer      : https://www.my-forum.com/forum/index.php
Username      : Alfa1
Classname     : vB_Database
MySQL Version : 5.0.90-log

Are table prefixes considered in this modification?

[dartho]

Check my post above:

Found a small bug. You need to edit the "Load Quotes" plugin on the usercp_start hook and change $vbulletin->options['wqmmax'] to $vbulletin->options['wqm_max'] otherwise you get MySQL errors

[Alfa1]

Duh. Sorry bout that. That solves the DB error.

Im not getting any notifications of new quotes. Nor is anything listed under 'Who Quoted Me' in usercp

Please mind I have this installed: Display Reputation Comments Given

My site is rather busy, so I imagine that loading the quote data might be extensive for 85.000 members. 7.500 active members.