Who Quoted Me

[renlok]

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.php?p=2156341&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]

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]

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 (https://vborg.vbsupport.ru/showthread.php?t=199975)

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

[Wonksta]

How hard would it be to implement this for only certain usergroups eg, paid members?

[FreshFroot]

Was waiting for this.. but seems like it has a lot of bugs right now.

[FreshFroot]

How hard would it be to implement this for only certain usergroups eg, paid members?
Not too hard, I might work on it myself. Set it so VIP groups can use it etc.. or X group(s)

[Wonksta]

Not too hard, I might work on it myself. Set it so VIP groups can use it etc.. or X group(s)
Mate if you would be kind enough to forward me the code you placed to restrict groups I would greatly appreciate it.

The Mod appears to be working very well, notifications work nicely. However very important people follow darthos posts about amending the code slightly.

[FreshFroot]

Well I haven't tried it out fully. But, I will play with it this weekend and see how it goes and let you know.

[Wonksta]

Hmm would

<if condition="is_member_of($bbuserinfo, array(5,6,7))">

Work efficiently if so where should that go in the XML?

[FreshFroot]

Well what I am thinking of doing is adding a section in acp, so you can select which usergroups can use this hack.

[Wonksta]

Well what I am thinking of doing is adding a section in acp, so you can select which usergroups can use this hack.
Ahhh if only I was that good with coding!

I'll wait for you then :)

[FreshFroot]

What kind of stress does this put on the server fetching quotes?
From what I can tell it will put just a little bit more stress on the server compared to posting a new reply. Just because it's going to check if the post is quoted and then create a notification.

[Wonksta]

From what I can tell it will put just a little bit more stress on the server compared to posting a new reply. Just because it's going to check if the post is quoted and then create a notification.
OK Should be OK then for only Premium Members I guess! Lookin forward to your usergroup mod now even more ;)

[FreshFroot]

OK Should be OK then for only Premium Members I guess! Lookin forward to your usergroup mod now even more ;)
working on it as we speak.. might be done in 30 mins.

I did find a bug, I guess the OP missed a vB4 tag and so when you click on a thread in the usercp.. it leads you to...

showthread.php?t=13#post{vb:raw whoquote.postid}

Going to fix this too ;)

So far I added in the 3 fixes till now.

[Wonksta]

working on it as we speak.. might be done in 30 mins.

I did find a bug, I guess the OP missed a vB4 tag and so when you click on a thread in the usercp.. it leads you to...

showthread.php?t=13#post{vb:raw whoquote.postid}

Going to fix this too ;)

So far I added in the 3 fixes till now.
You are a good man! :D

[FreshFroot]

almost done.. just going to do a few fast tests to see if it works and then i'll let u give it a test run for me too.

The one thing that I do hate is the fact that once you click on the notifications.

I kinda think it might be better if it worked the same way the PM system does? Where if you go into your PM box and if you have 2 PM's, but only read one of them.

the notification will STILL say you have 1 PM and will go away when you read all unread PM's.

So hopefully the same can be done for this mod. Where it highlights which quotes are NEW and the notification goes away when you view all quoted posts?

Anyways thought I'd throw it out there in case people like the idea or not.

[Wonksta]

almost done.. just going to do a few fast tests to see if it works and then i'll let u give it a test run for me too.

The one thing that I do hate is the fact that once you click on the notifications.

I kinda think it might be better if it worked the same way the PM system does? Where if you go into your PM box and if you have 2 PM's, but only read one of them.

the notification will STILL say you have 1 PM and will go away when you read all unread PM's.

So hopefully the same can be done for this mod. Where it highlights which quotes are NEW and the notification goes away when you view all quoted posts?

Anyways thought I'd throw it out there in case people like the idea or not.
That's pretty solid idea mate I also noticed that it doesn't actually take you to the post in which you were quoted in (unless it's just me???) can be difficult if the thread is 6,000 + posts (I have a few of these)

[FreshFroot]

That's pretty solid idea mate I also noticed that it doesn't actually take you to the post in which you were quoted in (unless it's just me???) can be difficult if the thread is 6,000 + posts (I have a few of these)
it doesn't take you to the quotes post, because as I decribed above. The coder when porting the mod from vB4 to vB3 left a vB4 code tag, which vB3 doesn't understand. I fixed that so it will lead to the post now.

I think I am done for the most part with the update.

I kinda want to find a way to get the idea I posted going.. or at least getting the unread quote notifications marked with something, so you know which ones you read and check and which ones you haven't.

[Wonksta]

it doesn't take you to the quotes post, because as I decribed above. The coder when porting the mod from vB4 to vB3 left a vB4 code tag, which vB3 doesn't understand. I fixed that so it will lead to the post now.

I think I am done for the most part with the update.

I kinda want to find a way to get the idea I posted going.. or at least getting the unread quote notifications marked with something, so you know which ones you read and check and which ones you haven't.
I fixed that so it will lead to the post now.

Sorry my bad! Good work!

I kinda want to find a way to get the idea I posted going.. or at least getting the unread quote notifications marked with something, so you know which ones you read and check and which ones you haven't.

Again, that idea is sweet!

Another idea i was thinking was under the Title of the thread an XX amount of character preview of the post that can be admin set in acp

just an idea :P

[Wonksta]

Also just thought of a little scenario where a member may get pissed off, if he she posts something really controversial then goes to bed wakes up and has 50 notifications there needs to be a way to mark the all 'viewed/red' in a single click. :D

[FreshFroot]

Also just thought of a little scenario where a member may get pissed off, if he she posts something really controversial then goes to bed wakes up and has 50 notifications there needs to be a way to mark the all 'viewed/red' in a single click. :D
good idea.. I didn't think about that... hmmm

okay well I will work with that part later sometime unless the OP does it.

For now I got it working with usergroups and also made a way to turn the system on and off.

[Wonksta]

good idea.. I didn't think about that... hmmm

okay well I will work with that part later sometime unless the OP does it.

For now I got it working with usergroups and also made a way to turn the system on and off.
Awesome! Great ideas are never rushed!

Let me know when ya ready for me to test it you can PM if you like

[FreshFroot]

Alright guys here is an updated version for those that don't want to wait.

Thanks to the OP for making a vB3 version.


Added a way to turn the quote notifications on or off globally
Able to add usergroup permissions as to who can use the quote notification system.
Fixed the usercp quotes thread tags, which now will point to the quoted post reply

Fixed the image tag to use default code for vB stylevars
Fixed the plugin issue loading quotes

Thanks to dartho for the above two fixes.


EDIT: forgot to add, just upload like you do usually and overwrite.

Also updated it to v1.2.1

If you have problems let me know.

In the mean time I am looking at the ideas I discussed earlier above in other posts.

[Wonksta]

Alright guys here is an updated version for those that don't want to wait.

Thanks to the OP for making a vB3 version.



EDIT: forgot to add, just upload like you do usually and overwrite.

Also updated it to v1.2.1

If you have problems let me know.

In the mean time I am looking at the ideas I discussed earlier above in other posts.
Thanks but doesn't appear to be notifying or showing anything in UserCP like the original op released...

[FreshFroot]

Also another update.

For those that want to have the quick reply button automatically quote without having to click the "quote message in reply" check box.


In The SHOWTHREAD template

FIND

<label for="qr_quickreply"><input type="checkbox" name="quickreply" value="1" id="qr_quickreply" accesskey="w" tabindex="4" />$vbphrase[quote_message_in_reply]</label>

REPLACE it with

<label for="qr_quickreply"><input type="checkbox" checked="checked" name="quickreply" value="1" id="qr_quickreply" accesskey="w" tabindex="4" />$vbphrase[quote_message_in_reply]</label>

[FreshFroot]

Thanks but doesn't appear to be notifying or showing anything in UserCP like the original op released...
hmm i tested it now on a live site and it seems to work fine.

Did you go into the settings and enable the mod? vBulletin -> Options -> Who Quoted Me

Make sure it says Yes to enabled.

[Wonksta]

Update: When I set 0 in Usergroup bit it works

So far I have included

Admin
and all my Premium Groups

[Wonksta]

Update 2:

It appears it doesn't work with more then one usergroup

If I set usergroup 6 it works nicely

if i have 6, 10, 11 or 6,10,11

It does not work

[Wonksta]

Update 3:

Issue with it going to the post quoted:

The post I quoted myself in is on page 3 but the URL rendered:

http://www.xxxxx.com/forum/showthread.php?t=11230#post195348

Which just loads the first page of the thread :( and does not go to the post

[FreshFroot]

I figured out the usergroup problem.. small mistake..

as for the 2nd part.. I will check that, I didn't recall having issues but ill check.

[Wonksta]

I figured out the usergroup problem.. small mistake..

as for the 2nd part.. I will check that, I didn't recall having issues but ill check.
You the MAN!!!!!!!!!!!!

[FreshFroot]

Okay try again here: https://vborg.vbsupport.ru/showpost.php?p=2156341&postcount=30

I fixed the usergroup problem.

As for the 2nd one I couldn't replicate it.

[Wonksta]

Mate Usergroups are fixed however the other problem still happens. I did figure out what works though:

Instead of:

/forum/showthread.php?t=11230#post195382

Like this:
/forum/showthread.php?p=195382#post195382

OR EVEN:
/forum/showthread.php?p=195382

But I don't have the knowledge I to fix it, the other mod that uses the above method of taking the user to the exact post is the Dragon Byte Advanced User Tagging system that uses the p= thing instead of t= and works nicely

[FreshFroot]

well what the "p" does it it brings you DIRECTLY to the post, where as the "t" brings you directly to the post BUT allows you to see the whole thread.

I'm not sure what problem you are having exactly. can you PM me ur url so I can take a look.

[Wonksta]

well what the "p" does it it brings you DIRECTLY to the post, where as the "t" brings you directly to the post BUT allows you to see the whole thread.

I'm not sure what problem you are having exactly. can you PM me ur url so I can take a look.
Thanks mate PM sent. Mines doing the opposite as per PM.

Thanks again

[FreshFroot]

If anyone else wants to use the method Wonksta did just do the following


Go into your templates and edit the display_who_quoted_me templated

Find

<a href="showthread.php?t=$threadinfo[threadid]#post$whoquote[postid]">$threadinfo[title]</a>

REPLACE

<a href="showthread.php?p=$whoquote[postid]#post$whoquote[postid]">$threadinfo[title]</a>



Cheers.

[Wonksta]

I was just thinking... I have reported posts auto create a thread on behalf of the reporter that gets posted in invisible and private Mod Room now the post contains a quote of the persons posts.

Will this Mod notify the user that they have been quoted in the Mod Room listing the title etc?

[Alfa1]

I was just thinking... I have reported posts auto create a thread on behalf of the reporter that gets posted in invisible and private Mod Room now the post contains a quote of the persons posts.

Will this Mod notify the user that they have been quoted in the Mod Room listing the title etc?
Very good point! I think most boards have post reports working as such.

[Alfa1]

I have installed the new version and it works!

bug: setting usergroups to 0 does not work. That turns it off.
sort of a bug: quoting yourself gives an alert.

The overview in usercp would look nicer if:
- the font would be smaller. (smallfont)
- display it like this: Member_X quoted your post in the thread_title on [date;time] Please make that all one line.

It would be nice if there were 2 different phrases for the notification:
1 member quoted you.
x members quoted you.

The latter being plural.

Below the 'Who Quoted Me' block, there should be some empty space. I have Paul M's modification installed to show a 'latest reputation given' block there and both blocks touch each other. There should be some distance. Adding a <br/> at the end of the usercp_who_quoted_me template resolves that.

I think that the link should really lead to the post where the quote is. The way to handle the target location that you have posted earlier in the thread should be in the xml.

Thank you!

[Alfa1]

I have reworked the usercp listing to the following:
display_who_quoted_me
<tr>
<td class="alt1Active" width="80%">
<a class="smallfont" href="member.php?$session[sessionurl]u=$whoquote[userid]">$whoquote[username]</a> <a class="smallfont"> quoted your post in the thread: </a> <a class="smallfont" href="showthread.php?p=$whoquote[postid]#post$whoquote[postid]"><b>$threadinfo[title]</b></a>
</td>
<td class="alt1Active">
<div class="userinfo">
<div class="smallfont">$whoquote[dateline] <span class="time">$whoquote[timeline]</span></div>
</td>
</tr>

Looks better now IMHO.

[Wonksta]

I have reworked the usercp listing to the following:
display_who_quoted_me
<tr>
<td class="alt1Active" width="80%">
<a class="smallfont" href="member.php?$session[sessionurl]u=$whoquote[userid]">$whoquote[username]</a> <a class="smallfont"> quoted your post in the thread: </a> <a class="smallfont" href="showthread.php?p=$whoquote[postid]#post$whoquote[postid]"><b>$threadinfo[title]</b></a>
</td>
<td class="alt1Active">
<div class="userinfo">
<div class="smallfont">$whoquote[dateline] <span class="time">$whoquote[timeline]</span></div>
</td>
</tr>

Looks better now IMHO.
Screenshot?

[Wonksta]

Doesn't seem to notify me if someone quotes my post that contains links, it's a bit of a hit and miss when a URL is pasted. Can anyone check?

[FreshFroot]

I'll work on some of the suggestions later on.

As for the url thing.. it could be due to checks for if a post was replied too or not. I'm just guessing right now.

when you mean url does www.name.com work fine or is it a problem when you add http://

[Wonksta]

I'll work on some of the suggestions later on.

As for the url thing.. it could be due to checks for if a post was replied too or not. I'm just guessing right now.

when you mean url does www.name.com work fine or is it a problem when you add http://
Hmmmmm!

Tried it with both http and www and got both notifications how, odd. I'll keep an eye on it though.

Mod is great, users love it btw.

[Alfa1]

Im not sure what the culprit is, but not all quotes cause a notification. We are testing in order to find out. Maybe it differs per subforum?

I am worried that reported posts will cause members to find out, who reported their post. That could spark some riots. So its definitely needed to exclude report forums and infraction forums from causing notifications. Or does this mod already do that?

Here's a screenshot of the usercp after the modifications I applied:

https://vborg.vbsupport.ru/external/2011/01/3.jpg

[Wonksta]

OK Just reported one of my own posts and it created a reported post in the Reports sub forum but the good news is it did not notify me that I reported my post. I tried twice. Take note you can notify yourself when you quote yourself anyway so hence I think it wont notify people but maybe FreshFoot could confirm by looking at the code for us?

Alfa that looks great!

EDIT: Alfa the template tweak is mint, thanks for sharing!

[Alfa1]

I would appreciate it if someone could check the code below to see if proper syntax has been used:

I have reworked the usercp listing to the following:
display_who_quoted_me
<tr>
<td class="alt1Active" width="80%">
<a class="smallfont" href="member.php?$session[sessionurl]u=$whoquote[userid]">$whoquote[username]</a> <a class="smallfont"> quoted your post in the thread: </a> <a class="smallfont" href="showthread.php?p=$whoquote[postid]#post$whoquote[postid]"><b>$threadinfo[title]</b></a>
</td>
<td class="alt1Active">
<div class="userinfo">
<div class="smallfont">$whoquote[dateline] <span class="time">$whoquote[timeline]</span></div>
</td>
</tr>

https://vborg.vbsupport.ru/attachment.php?attachmentid=126274&stc=1&d=1296476200

[FreshFroot]

I will check the reporting issue and will add in Alfa1's layout, as it looks pretty good.

As for all quote's not being notified. I will try to run a few tests with subforums to see if that could be a problem.

Will keep ya updated.

Thanks.

[Wonksta]

FreshFroot here is a post which did not notify me:

This is what it contained:
-----------
URL Test 2

http://www.arandomurlhere.com

Quote notification not working @Admin ??

------

Two things present in this post A URL DBTECH's Advanced User Tagging Mod which parsed @Admin.

Thoughts?

[FreshFroot]

FreshFroot here is a post which did not notify me:

This is what it contained:
-----------


Quote notification not working @Admin ??

------

Two things present in this post A URL DBTECH's Advanced User Tagging Mod which parsed @Admin.

Thoughts?
Sorry I don't get what you mean? Are you saying urls don't get a notification or when using @name (DBTech's mod) causes no notification?

[Wonksta]

After testing it sometimes it randomly doesn't notify of quotes.

Just to confirm if a member from a usergroup who isn't given permission to use the mod quotes a member from a usergroup which is given permission to use the mod, will it cause a notification?

[FreshFroot]

After testing it sometimes it randomly doesn't notify of quotes.

Just to confirm if a member from a usergroup who isn't given permission to use the mod quotes a member from a usergroup which is given permission to use the mod, will it cause a notification?
I'll re-check the usergroups. I know there was a bug with adding a 0.

But if the usergroup has no permission to use it, then it will not create a notification at all.

[Wonksta]

I'll re-check the usergroups. I know there was a bug with adding a 0.

But if the usergroup has no permission to use it, then it will not create a notification at all.
Ahhhhhhhhhhhhh bummer is there anyway to make it so that if you don't have permission to use it and you get quoted you simply don't get notified but when you quote someone who has permission and you don't have permission to use it, it notifies the person with the permission.

If that makes sense? That would be amazing.

[Da-Vinci]

Must be clasing with something I get.

Fatal error: Call to a member function query_read_slave() on a non-object in /home/clandigi/public_html/includes/class_bootstrap.php(1120) : eval()'d code on line 10

as soon as I install this mod.

[Konstantinos]

Invalid SQL:
SELECT hasseen FROM vbquotedatanew
WHERE quoted = '1' AND hasseen = 0;

MySQL Error : Unknown column 'hasseen' in 'field list'

[FreshFroot]

Ahhhhhhhhhhhhh bummer is there anyway to make it so that if you don't have permission to use it and you get quoted you simply don't get notified but when you quote someone who has permission and you don't have permission to use it, it notifies the person with the permission.

If that makes sense? That would be amazing.

hmmmm ya that could work, I will look into that this weekend.

Must be clasing with something I get.

Fatal error: Call to a member function query_read_slave() on a non-object in /home/clandigi/public_html/includes/class_bootstrap.php(1120) : eval()'d code on line 10

as soon as I install this mod.

hmmmm could be due to other mods too. I'm using quite a lot and so far haven't had clashes.

Invalid SQL:
SELECT hasseen FROM vbquotedatanew
WHERE quoted = '1' AND hasseen = 0;

MySQL Error : Unknown column 'hasseen' in 'field list'

Seems like you did not install the mod properly. Try installing again.

[FreshFroot]

FreshFroot here is a post which did not notify me:

This is what it contained:
-----------


Quote notification not working @Admin ??

------

Two things present in this post A URL DBTECH's Advanced User Tagging Mod which parsed @Admin.

Thoughts?
Looks like there IS a problem when using this mod and the DBTech user tag mod. It then will not allow quotes to show or work at all.

[Wonksta]

Ahhh bummer mate! So it's not a permission thing as per your previous post but DBTech only?

[Konstantinos]

can u make it that the who quoted me to be on a new page ? like misc.php and linked from the user.cp or a popup window ?? there are so many items showing in usercp like subscription reps etc

[Wonksta]

Fresh I am willing to chip in some $$ if you can fix the compatibility issue with Dbtech mate!

[Alfa1]

I dont have the DBtech user tagging addon and somehow the quote notifications work in some instances, while not in other instances. Its a complete mystery to me.

Could this be subforum related?

[Wonksta]

Yeah I was looking at that some of the Quotes do not include a DBTECH Parsed link in them and don't show :(

[FreshFroot]

can u make it that the who quoted me to be on a new page ? like misc.php and linked from the user.cp or a popup window ?? there are so many items showing in usercp like subscription reps etc

You can do that already.. Look at the vB4 version of this mod and it has a separate file that you can use.

Ahhh bummer mate! So it's not a permission thing as per your previous post but DBTech only?

Nope not a permission issue. It's an issue with the DBTECH mod I think breaking this mod.

Fresh I am willing to chip in some $$ if you can fix the compatibility issue with Dbtech mate!

I'll look into it... but I'll have to find out what the DBTECH mod is doing itself.

I dont have the DBtech user tagging addon and somehow the quote notifications work in some instances, while not in other instances. Its a complete mystery to me.

Could this be subforum related?

Could be.. although I don't think I've had a subforum problem yet....

[Wonksta]

Holy fark you're the man! If ya ever come to Australia let me know I owe you a beer Fresh!

[Konstantinos]

You can do that already.. Look at the vB4 version of this mod and it has a separate file that you can use.



..

but it doesnt work 0n 3.8 does it ?

[Konstantinos]

as others said it doesnt work on all quotes. weird. i also am using this https://vborg.vbsupport.ru/showthread.php?t=112498

maybe u can fix the bugs, add a new page with pagenation and include pm email options per user too

[FreshFroot]

Holy fark you're the man! If ya ever come to Australia let me know I owe you a beer Fresh!

hmm I'm not a huge beer fan sadly.. I like hard liquor :p

but it doesnt work 0n 3.8 does it ?

I haven't tested it.. so I can't say for sure. I assume it needs small tweaks.

as others said it doesnt work on all quotes. weird. i also am using this https://vborg.vbsupport.ru/showthread.php?t=112498

maybe u can fix the bugs, add a new page with pagenation and include pm email options per user too

I would have to look later. That mod might be coded differently, so I'd have to look at it.

[Alfa1]

Is there any way to get the quote notifications to disappear when the post is visited, instead of the usercp?

can u make it that the who quoted me to be on a new page ? like misc.php and linked from the user.cp or a popup window ?? there are so many items showing in usercp like subscription reps etc
I much agree with this. My users are complaining about this. I display in usercp: personal notepad, invitations, PMs, Friend requests, thread subscriptions, who quoted me, reputation given, reputation received. With 8 blocks thats quite a jungle of notifications to wade through.

I think the optimal solution would be to create an AJAX tabbed content block in usercp.php so that its easy to browse notifications.

[Wonksta]

Although I agree with the whole Misc.php I think we should be thankful of Fresh for his work so far and that we should prioritise the issue of some quotes not working properly (not notifying the user)

Once the core purpose of the Mod is solid then we should focus on extra goodies! :P

[FreshFroot]

Well I might get everyone to move to another similar mod. Apparently it WORKS, but it sends you a PM for each quote. So with that we could modify it to create a method in the usercp.

As for the blocks, we might be able to do that as well. I'm thinking if we make a usercp clone, but just for quotes. That way it LOOKS like the usercp and you can use the block, but it won't display everything at once besides the quotes.

[Wonksta]

I'm interested whats different about that code to this one we are using now regarding it being more accurate in notifying people?

[Alfa1]

I would not want my members to get a PM for every quote. If that can be replaced with a usercp type method then Im surely up for it.

[Wonksta]

I would not want my members to get a PM for every quote. If that can be replaced with a usercp type method then Im surely up for it.
x2

But I think that's what Fresh meant too

[Alfa1]

My users sometimes encounter this error:
Warning: require_once(./global.php) [function.require-once]: failed to open stream: No such file or directory in /public_html/usercp.php on line 74

Fatal error: require_once() [function.require]: Failed opening required './global.php' (include_path='.:/usr/local/lib/php') in /public_html/usercp.php on line 74
Mind that my installation if in public_html/forum/

[biftek]

i can't get this to show , i have installed it but it wont show in my usercp , i am using a mod icons for usercp would that be causing problems?

[Alfa1]

If a thread is deleted, the quote notification stays. This should not happen. It would be nice the mod would check if the thread is deleted or not.

[FreshFroot]

I'm interested whats different about that code to this one we are using now regarding it being more accurate in notifying people?
I haven't checked, but I think it's coded better or with less bugs.

[Wonksta]

I haven't checked, but I think it's coded better or with less bugs.
Sounds juicy! :D

[Saloom]

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?

:up:

is you

[Morrus]

I'm not sure where I'm supposed to be looking (I looked at the USerCP) but I'm not seeing anything there. And there's no entry in the notification dropdown that relates to quotes.

I've definitely switched it on and selected notifications, but it's like I've not installed anything at all.

[Morrus]

Ah, OK, if I have it set to "0" it switches off. If I list my usergroups it works.

[Morrus]

....and it's stopped working again for no reason. Not doing anything. Ah well! It was a cool idea! :)

[Morrus]

OK, so it seems to be, at best, intermittent. I can't figure out the pattern, but sometimes it works and sometimes it doesn't.

[Wonksta]

OK, so it seems to be, at best, intermittent. I can't figure out the pattern, but sometimes it works and sometimes it doesn't.
Yeah FreshFroot is working on it he mentioned about modifying another Mod to make it work the same as this as it had better code. It seems to always notify me when the usergroup who I added via ACP but rarely notifies me of quotes of users part of other non listed user groups...

[FreshFroot]

OK, so it seems to be, at best, intermittent. I can't figure out the pattern, but sometimes it works and sometimes it doesn't.
If your adding 0 it WON'T work.. I have to fix that. It SHOULD work if you enter each usergroup.

I will look at it tomorrow and post a new fix up.

[Morrus]

If your adding 0 it WON'T work.. I have to fix that. It SHOULD work if you enter each usergroup.

I will look at it tomorrow and post a new fix up.

I have no 0s in there at present, just a list of usergroups. Works sometimes, but intermittently.

[biftek]

If your adding 0 it WON'T work.. I have to fix that. It SHOULD work if you enter each usergroup.

I will look at it tomorrow and post a new fix up.
ah that fixed it , wish someone had of said that sooner

[FreshFroot]

ah that fixed it , wish someone had of said that sooner
It was said 2-3 times already... you need to read and not skim posts... :p

[Alfa1]

If a member is quoted in the staff forums then the member will get a quote notification. This just happened and I needed to uninstall this addon for that reason.

Also: indexing posts for quotes leads to a mass of duplicate notifications. (multiple notifications for the same post)

[Wonksta]

If a member is quoted in the staff forums then the member will get a quote notification. This just happened and I needed to uninstall this addon for that reason.

Also: indexing posts for quotes leads to a mass of duplicate notifications. (multiple notifications for the same post)
Bump :(

[ricardoNJ]

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.

I had database error, but this was a good solution. Thanks!

[Morrus]

Any update on fixing the intermittent behaviour of this? I'd love to use it.

[great kitten]

sorry en espa?ol

me sale error en la base de datos o si pongo este hack https://vborg.vbsupport.ru/showp...1&postcount=30

cuando me cito no me aparece la notificaci?n...me pueden ayudar a solucionarlo....gracias

[Alfa1]

Ese link no funciona.

[Wonksta]

Dragon released something:

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

Using it now the quotes are working all the time, everytime! w00t.

Sadly I paid $90 to modify this mod then the next day this gets released for free :( Haha

[Morrus]

Dragon released something:

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

Using it now the quotes are working all the time, everytime! w00t.

Yup, I'm using that too. Much better than this mod.

[EddyMaxx]

Yeah the DBTech quotes feature is awesome.

[JohorBahru]

Hi,

How do i place it at the homepage as well? Thank you!!

[Artes_Marciales]

BD Error to acces panel control
Database error in vBulletin 3.8.7:

Invalid SQL:
SELECT user.username, quote.*, post.threadid, thread.title
FROM quotedatanew As quote
LEFT JOIN post AS post ON(quote.postid = post.postid)
LEFT JOIN thread AS thread ON(post.threadid = thread.threadid)
LEFT JOIN user AS user ON(user.userid = quote.quoter)
WHERE quote.quoted = '2' 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 : Monday, September 5th 2011 @ 05:32:42 PM
Error Date : Monday, September 5th 2011 @ 05:32:42 PM

[Hellmaster]

Works on 3.8.4?

[Amenadiel]

Amazing and useful

[Magoware]

This hack didn't work on my vbulletin 3.8.2

[Donkey11]

hack didn't work 3.8.4

[MoMan]

There are some bugs in this, but after a few changes I've gotten everything working on my board. I will post the updated version as time allows...

[Concha]

There are some bugs in this, but after a few changes I've gotten everything working on my board. I will post the updated version as time allows...

Waiting them this plugin works fine.

[beekay]

sometimes it doesn't recognize someone being quoted and doesn't notify them.

other than that it seems to be working ok. also i wouldnt mind moving the who quoted me off the user cp and maybe into the profile like in dbtech's version. if anyone has tried that let me know how it worked

[itilm]

Waooo superb Thanks for sharing

[sa3eka.com]

I test in 3.8.7 pal2
It is not working
1.2.1

[ricardoNJ]

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/showp...1&postcount=30

...testing

[puddlove]

Can anyone help me turn this in to a vBadvanced module?

[JamesN]

Does anyone know if this works in 4.2.1?

[dutchbb]

Does anyone know how to tweak the top quoters query so that it only shows the top quoters of the last year instead of all time?

[dakotart.com]

Tested on 3.8.7 PL2

Changed settings in Admin CP. - Works

- Had to change user-groups to actual numbers instead of default "0" (aka everyone). I manually input each user-group on my board and now it's working fine.

Marking Installed.

Edit: I also added the <br> in user_cp_who_quoted_me template.

[yjeanrenaud]

does it work on 4.2.2.?

[Amenadiel]

It's working for me in 4.2.2

However, it doesn't seem to work when you mention people in vbshout.

[DCD.RB]

Does anyone know if:
- This is added to vB's notification block?
- If it alerts on posts quoted in restricted sections such as staff forum?

Thanks