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.


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

Change log:
15-12-2010: v1.0.0 initial release
16-12-2010: v1.1.0 Added admin settings and notifications about new quotes
27-01-2011: v1.2.0 Added a button in maintenance -> update counters which finds all quotes and adds them to the who quoted me list (So users know who quoted them in all posts not just those made after installing this)

If you use this i would really appreciate any small donation


If you want The who quoted me list to have its own page download wqm_Page.zip upload the wqm.php file, install the plugin and in the plugin manager open up the Add to notifications list plugin find

PHP Code:

usercp.php 


and replace with

PHP Code:

wqm.php 


[Swedie]

Yeah, same problem here. It doesn't update... WTF: Must fix!

[Swedie]

The problem lies in the preg_match function. It's incorrect and fails finding quotes when there are line breaks (what I guess) in the post that is being quoted.

I wish I knew regex code well enough, but I don't, so I can only fix this by making an ugly piece of hack without regex that finds the quotes and puts then in an array. I might post it here, but beware it's fugly code.

[Swedie]

I figured it out pretty decently what caused it. It was the first preg_match but also for me I needed /is for case incensitive version.

Replace all the code in the plugin for this mod: Find Quotes

if(preg_match("/\[quote=(.*)\](.*)\[\/quote\]/is", $post['message'])) 
{
   preg_match_all("/\[quote=(.*?)\](.*?)\[\/quote\]/is", $post['message'], $quotematch);
	$quotecount = count($quotematch[0]);
	$tempcount = 0;
	$quotearray = array();

	while ($tempcount < $quotecount) 
	{
		$username = explode(';', $quotematch[1][$tempcount]);
		$quoteduserid = $vbulletin->db->query_first(
			"SELECT userid FROM " . TABLE_PREFIX . "user
			WHERE username = '" . $vbulletin->db->escape_string(htmlspecialchars_uni($username[0])) . "'"
		);

		if (!in_array($quoteduserid['userid'], $quotearray)) 
		{
			if ($quoteduserid['userid'] > 0)
			{
				$vbulletin->db->query_write("
					INSERT INTO " . TABLE_PREFIX . "quotedatanew (quoted,quoter,postid,dateline)
					VALUES ('" . $quoteduserid['userid'] . "','" . $vbulletin->userinfo['userid'] . "','" . $post['postid'] . "','" . time() . "')"
				);
				$quotearray[] = $quoteduserid['userid'];
			}
		}
		$tempcount++;
	}
}

This means this mod works up to version 4.x.x.

[henriof9]

[QUOTE=Swedie;2273791]I figured it out pretty decently what caused it. It was the first preg_match but also for me I needed /is for case incensitive version.

Replace all the code in the plugin for this mod: Find Quotes

if(preg_match("/\[quote=(.*)\](.*)\[\/quote\]/is", $post['message'])) 
{
   preg_match_all("/\

	
	

			
				

					Originally Posted by (.*?)\
					
				
				
(.*?)\[\/quote\]/is", $post['message'], $quotematch);
	$quotecount = count($quotematch[0]);
	$tempcount = 0;
	$quotearray = array();

	while ($tempcount < $quotecount) 
	{
		$username = explode(';', $quotematch[1][$tempcount]);
		$quoteduserid = $vbulletin->db->query_first(
			"SELECT userid FROM " . TABLE_PREFIX . "user
			WHERE username = '" . $vbulletin->db->escape_string(htmlspecialchars_uni($username[0])) . "'"
		);

		if (!in_array($quoteduserid['userid'], $quotearray)) 
		{
			if ($quoteduserid['userid'] > 0)
			{
				$vbulletin->db->query_write("
					INSERT INTO " . TABLE_PREFIX . "quotedatanew (quoted,quoter,postid,dateline)
					VALUES ('" . $quoteduserid['userid'] . "','" . $vbulletin->userinfo['userid'] . "','" . $post['postid'] . "','" . time() . "')"
				);
				$quotearray[] = $quoteduserid['userid'];
			}
		}
		$tempcount++;
	}
}
			
		

Originally Posted by (.*?)\

This means this mod works up to version 4.x.x.

Thanks, I have taken the hint from @inpicos post #65 and it works perfectly now.

[Breakpoint]

Let me know when updates, would love to try with out fixing code

[thenamesgould]

I like it, thanks! The only thing is the quotes in the off-limits areas, but we can be careful not to do any for now. Cheers.

[vauge]

Is there a way to easily turn this off per user?

[scott_237]

I think this works MOST of the time, but I'm admin on my forums and I only get notified for a small percentage of the quotes, no all of them. Why is this?

[EliasAlucard]

Originally Posted by scott_237

I think this works MOST of the time, but I'm admin on my forums and I only get notified for a small percentage of the quotes, no all of them. Why is this?

Yeah, I noticed now that it hasn't been working the past 3-4 days. I'm using vB 4.2.0 and it seems like this plugin could need an update.

[farazfaraz]

dont show

why?