[mute]

Originally Posted by orban

I think I'll do it every 3 days but I don't know yet, we're not very busy right now so the delta indices are quite small.

--------------------------------------------------------------------------------------------------------

I fail to see why this works and I still think there's missing data in these results....

Updated sphinx.conf

Added "IF(firstpostid=0,99999999,firstpostid) as firstpostid" to fields list and "sql_group3_column = firstpostid"

you only need to rebuilt the thread indices.

http://dragy.de/public/sphinx.conf

Updated includes/sphinx.php

http://dragy.de/public/sphinx.php.txt

Update search_forums template

Readded the show as threads, show as posts options...

Rolled back navbar and FORUMDISPLAY templates....back to "show as thread" "show as posts"....

http://dragy.de/public/sphinx_search...s.template.txt

Updated search.php

Remove

else
		{
			// bug fix because we don't have "show as posts/threads" anymore
			if ($vbulletin->GPC['starteronly'])
			{
				$vbulletin->GPC['showposts'] = 0;
			}
			else
			{
				$vbulletin->GPC['showposts'] = 1;
			}
			// end bug fix
		}

I also added a "$vbulletin->GPC['nocache'] = true;" to the search_process_start hook, I had some queries that stuck and I think that's because vB cached some queries and did some very bad re-sorting on those....try it out.

Can someone summarize what's going on here? I got sorta lost. Are you guys trying to figure out how to do the "view as posts, view as threads" options using sphinx, or making it so those options fall back on the vb search?