Suggestion: Dissable search in signature text!

Post by **Noel** » Sat Apr 25, 2009 10:22 pm

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!

--

Post by **Bwired** » Sat Apr 25, 2009 10:37 pm

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.

Post by **Digit** » Sat Apr 25, 2009 11:00 pm

Limit the search to the text before the last hr in the post?
Easier said then done i guess..

Post by **Noel** » Sat Apr 25, 2009 11:09 pm

Kill the sigtext

--

Post by **Hetwieg** » Sun Apr 26, 2009 12:04 am

And when you start in the database the signature with  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.

Post by **Bwired** » Sun Apr 26, 2009 12:17 am

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

Post by **Snelvuur** » Sun Apr 26, 2009 1:21 am

kuch kuch, or install phpbb or something similar

// Erik (binkey.nl)

Post by **Alexander** » Tue Jul 21, 2009 8:02 pm

damn, try to search for fritz...

Any progress on this Pieter?

Post by **Bwired** » Tue Jul 21, 2009 8:09 pm

I think I kill the signature, in the database its added to the topic

Post by **Alexander** » Tue Jul 21, 2009 8:13 pm

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).

Post by **Bwired** » Tue Jul 21, 2009 8:50 pm

Yep I know how to solve the problem, I can make a seperate table for signature but its a lot of work

Post by **Alexander** » Tue Jul 21, 2009 8:54 pm

Why extra table? the signatures are already in the user table i would guess?

Post by **Bwired** » Tue Jul 21, 2009 10:39 pm

you are right its added in the topic when posted

Post by **Alexander** » Tue Jul 21, 2009 10:51 pm

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.

Post by **Bwired** » Tue Jul 21, 2009 11:06 pm

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