Register Members List Search Today's Posts Mark Forums Read

Showing results 1 to 9 of 9
Search took 0.02 seconds.
Search: Posts Made By: PSS
Forum: Modification Requests/Questions (Unpaid) 23 Oct 2008, 17:33
Replies: 2
Views: 718
Posted By PSS
Of course that is better to do with varchar(255),...

Of course that is better to do with varchar(255), a comma-delimited string of allowed forums. That requires one more SELECT when reading a forum index, but keeps it in one column.

I could code...
Forum: Modification Requests/Questions (Unpaid) 22 Oct 2008, 16:39
Replies: 2
Views: 718
Posted By PSS
Submit agreement form before can view a specific forum

Searched but could not find a mod:

- user enters forum or subforum
- cookie X checked
- If cookie X found: show posts.
- if cookie X not found: show user an agreement form.
- only when user...
Forum: Forum and Server Management 03 May 2008, 21:40
Replies: 833
Views: 211,232
Posted By PSS
Just wanted to say I really appreciate your...

Just wanted to say I really appreciate your contribution, scanlover. I'll try that code with my big board in couple of weeks, I have to set up a test system first for 3.7.

--------------- Added...
Forum: Big Board Discussions 19 Jan 2008, 17:40
Replies: 59
Views: 17,879
Posted By PSS
http://photography-on-the.net/forum ...

http://photography-on-the.net/forum

Big-boards rank ca. 250 and going up.
Alexa rank ca. 12,500
2000-3000 users online 24/7
4,7 million posts
135,000 members

One server:
RHEL 5 64-bit
Forum: Forum and Server Management 16 Jan 2008, 00:07
Replies: 833
Views: 211,232
Posted By PSS
Thanks it would be great if you'd share the 3.7 +...

Thanks it would be great if you'd share the 3.7 + Sphinx info! I'm not going to use Vb inbuilt search ever again.
Forum: Forum and Server Management 26 Jul 2007, 13:57
Replies: 833
Views: 211,232
Posted By PSS
TRUNCATE TABLE `PREFIX_word`; ALTER TABLE...

TRUNCATE TABLE `PREFIX_word`;

ALTER TABLE `PREFIX_post` DROP INDEX `title`;

KRon's improvements are worth doing, too:

ALTER TABLE `PREFIX_post` ADD INDEX `th_search` ( `threadid` ,...
Forum: Forum and Server Management 25 Jul 2007, 00:02
Replies: 833
Views: 211,232
Posted By PSS
I still would like to know: when you have Sphinx...

I still would like to know: when you have Sphinx search in place, do you need to have FULLTEXT index(es) in Vbulletin at all?

Maybe it is a stupid question and FAQ and RTFM etc, but please take a...
Forum: Forum and Server Management 09 Jul 2007, 16:37
Replies: 833
Views: 211,232
Posted By PSS
Another question: is there a way to check if...

Another question: is there a way to check if searchd is running and if not, put text "search is offline" to the search page?
Forum: Forum and Server Management 07 Jul 2007, 20:18
Replies: 833
Views: 211,232
Posted By PSS
Couple of small things: 1. you did ...

Couple of small things:

1. you did

CREATE TABLE sph_counter

but used sphinx_counter in sphinx.conf.

2. Then it would be great to have PREFIX_ where you would place your personal Vb table...
Showing results 1 to 9 of 9

 
Forum Jump

New To Site? Need Help?

All times are GMT. The time now is 11:23.

Layout Options | Width: Wide Color: