Based on Filter Keywords

Post Reply
happydg
Posts: 412
Joined: Mon Jul 08, 2013 2:22 pm

Based on Filter Keywords

Post by happydg »

Hello,

I made some test and noticed when importing galleries based on filter keywords, it only searches filter keywords in tags, not in the description.

For example i have a group "Camel toes" with Filter keywords "Camel Toe"

A gallery which contains Camel toe in the description ( and not in tags ) won't be added, but if it contains Camel Toe in the tags it will be added.

It should be added if it contains it in the description or somewhere in custom var.

Thank you.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Based on Filter Keywords

Post by admin »

Are you sure ?
Can you please add a screenshot how you import and import line plz
Don't forget to run script update
happydg
Posts: 412
Joined: Mon Jul 08, 2013 2:22 pm

Re: Based on Filter Keywords

Post by happydg »

http://imgur.com/tsaGFaI

This doesn't go to Camel Toe goup

My build: Build 201603221213
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Based on Filter Keywords

Post by admin »

Just checked it
works fine
if you are sure it doesn't add to that group - PM admin are and text line plz
Don't forget to run script update
happydg
Posts: 412
Joined: Mon Jul 08, 2013 2:22 pm

Re: Based on Filter Keywords

Post by happydg »

Sorry it works it wasn't the problem.

The problem is i mass readded groups with filter keywords ( to mass edit them ), but filter keywords is limited to 255 characters.

Some groups have filter keywords with more than 255 characters so here is what i tried to mass add:

Big Tits,"Big Tits"|"Big Boobs"|"Busty"|"Huge tits"|"Massive tits"|"Monster tits"|"Large Breast"|-gay|-twink|-gays|-twinks|-shemale|-"She male"|-"She-male"|-shemales|-transsexual|-tgirl|-tgirls|-tranny|-"Trans sexual"|-transexual|-transsexuals|-ladyboy|-ladyboys|-"lady boy"|-"lady boys"|-transvestite|-transvestites

And here is the result after adding it:

"Big Tits"|"Big Boobs"|"Busty"|"Huge tits"|"Massive tits"|"Monster tits"|"Large Breast"|-gay|-twink|-gays|-twinks|-shemale|-"She male"|-"She-male"|-shemales|-transsexual|-tgirl|-tgirls|-tranny|-"Trans sexual"|-transexual|-transsexuals|-ladyboy|-ladyboys|-

It is limited to 255 characters, that is the problem.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Based on Filter Keywords

Post by admin »

You can make the field bigger

ALTER TABLE `rot_groups` CHANGE `ts_keywords` `ts_keywords` VARCHAR( 1024 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
Don't forget to run script update
happydg
Posts: 412
Joined: Mon Jul 08, 2013 2:22 pm

Re: Based on Filter Keywords

Post by happydg »

It works, thank you.

Could you please add more characters to the next version so i don't need to add this command after each upgrade?
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Based on Filter Keywords

Post by admin »

You have to do it once only, no need to do it every time

you can also optimize your query (it also saves server resources a bit)

like

-shemale|-shemales "-shemale" includes "-shemales"
-ladyboy|-ladyboys
Don't forget to run script update
happydg
Posts: 412
Joined: Mon Jul 08, 2013 2:22 pm

Re: Based on Filter Keywords

Post by happydg »

I want to reduce the number of synonyms so it proccesses galleries faster. For example i would like to add galleries with bus or sexy van or van sexy to this group. So i added in filter keywords:

bus|sexy van|

In test string sexy van and van sexy is working but not bus, could you please explain me the reason? Do i need to add "" if it has at least two words?

bus|"sexy van"|"van sexy"|

Thank you.
admin
Site Admin
Posts: 38004
Joined: Wed Sep 10, 2008 11:43 am

Re: Based on Filter Keywords

Post by admin »

Yes

otherwise ' ' (space) is treated as AND

so you get

bus OR sexy AND van
Don't forget to run script update
Post Reply