Sphinx and soft deletes

[LauraS]

I'm having an issue with sphinx search when finding posts by a user. I have a thread that was marked as a soft delete (thread.visible = 2) but the posts inside that thread were not soft deleted (post.visible = 1). The problem I'm seeing is that if I then run a find post by user search those soft deleted posts don't show up in the output even though in the DB I can see that that postid is set to visible = 1. So I'm not really seeing ALL the posts for that user. Anybody experienced something like this?

Danny

[LauraS]

I think i found the solution to my problem. Seemed like for super mod, mod and admin account types soft deletes would still display using vbsearch when doing find post/thread by users but since sphinx does not index soft deletes they'd never show up on the output when converted to sphinx search. To remedy that I modified search_sphinx.php with the following:

near the top after

// admin only mode
#if ($vbulletin->userinfo['userid'] != 1) die('Search not available at the moment.');

// finduser
if ($_REQUEST['do'] == 'finduser')
{

I included

        // My code *******************************************************
	// Don't do sphinx search for admins, mods and super mods
	if ($vbulletin->userinfo['usergroupid'] == 5 || $vbulletin->userinfo['usergroupid'] == 6 || $vbulletin->userinfo['usergroupid'] == 7) {
		return true;
	}

	// Checking to see if user is member of admin, mod, super mods
	$ccGroupList = explode(",", $vbulletin->userinfo['membergroupids']);
	foreach($ccGroupList as $ccGroupID) {
		if ($ccGroupID == 5 || $ccGroupID == 6 || $ccGroupID == 7) {
			return true;
		}		
	}
        // End of my code ***************************************************

	// search timer
	$searchstart = microtime();

Basically when either the usergroupid or membergroupids is or part of admin, mod, super mod accounts it exits out and uses normal vbsearch which for us is not a huge deal and seems to work.

Danny