Page 1 of 2

Suggestion: Dissable search in signature text!

Posted: Sat Apr 25, 2009 10:22 pm
by Noel
Is it possible to dissable searching text that is in the users signature text?

Example. When I search in the "Homeseer HStouch" forum only for "PlugWise" RdP's signature text will cause a positive hit as he has got the word PlugWise in his signature text.

This makes searching really hard!

--
Image

Suggestion: Dissable search in signature text!

Posted: Sat Apr 25, 2009 10:37 pm
by Bwired
I did some analyses but the signature is placed in the topic and then stored in de database.
And everybody is placing there signature on every answer or topic, yours is an image, so much better.
mmhhh.

Suggestion: Dissable search in signature text!

Posted: Sat Apr 25, 2009 11:00 pm
by Digit
Limit the search to the text before the last hr in the post?
Easier said then done i guess.. :-(

Suggestion: Dissable search in signature text!

Posted: Sat Apr 25, 2009 11:09 pm
by Noel
Kill the sigtext :-)

--
Image

Suggestion: Dissable search in signature text!

Posted: Sun Apr 26, 2009 12:04 am
by Hetwieg
And when you start in the database the signature with <!--SIGNATURE--> then you could sachre ma by at the front of this text.

Edit:
Or you place the SINATURE in a other field in the table and place it on the same location when you show a post.

Suggestion: Dissable search in signature text!

Posted: Sun Apr 26, 2009 12:17 am
by Bwired
kill the sigtext, make an image or a link where everybody can put there stuff would be the best option.
separate field would slow the stuff down and limit the search is not easy to do I guess :-(

Suggestion: Dissable search in signature text!

Posted: Sun Apr 26, 2009 1:21 am
by Snelvuur
kuch kuch, or install phpbb or something similar ;)

// Erik (binkey.nl)

Suggestion: Dissable search in signature text!

Posted: Tue Jul 21, 2009 8:02 pm
by Alexander
damn, try to search for fritz... :(
Any progress on this Pieter?

Suggestion: Dissable search in signature text!

Posted: Tue Jul 21, 2009 8:09 pm
by Bwired
I think I kill the signature, in the database its added to the topic :-(

Suggestion: Dissable search in signature text!

Posted: Tue Jul 21, 2009 8:13 pm
by Alexander
you could add the signature dynamically when selecting the attributes from the tables to generate the requested page/topic. Current data will not help ofcourse and you will have two signatures with the current data with above idea (deleting that signature data within the current database is simple ofcourse).

Suggestion: Dissable search in signature text!

Posted: Tue Jul 21, 2009 8:50 pm
by Bwired
Yep I know how to solve the problem, I can make a seperate table for signature but its a lot of work :-(

Suggestion: Dissable search in signature text!

Posted: Tue Jul 21, 2009 8:54 pm
by Alexander
Why extra table? the signatures are already in the user table i would guess?

Suggestion: Dissable search in signature text!

Posted: Tue Jul 21, 2009 10:39 pm
by Bwired
you are right its added in the topic when posted

Suggestion: Dissable search in signature text!

Posted: Tue Jul 21, 2009 10:51 pm
by Alexander
than you C&P the "select query against the usertable to retrieve the signature" from the post_info.asp (if it's in there and not included) to the topic.asp (or included file to make the topic post). The only difference is that the select query where clausule isn't checked against the current user id but the userid from the reply.

Normally you want to prevent duplicated info in a database. Now all the topic entries contain the signatures of all the users contributed to the topic (5 times your signature for this topic). Eventhough its only characters, it's not a nice solution.

I've spare time to help you in this. <b>I know you have the knowledge</b>, but like you'd said, you don't have the spare time. If you send me the ASP files needed to be changed, i will e-mail you back which lines can be deleted and which one to be added. Than that is the only time you will be spending.

Suggestion: Dissable search in signature text!

Posted: Tue Jul 21, 2009 11:06 pm
by Bwired
Mine and your signature are not the problem, but the whole bunch of equipment mentioned in others is :-)
Thanks for the offer, Let me check first, get back to you