Query by Season/Episode - Crazy results

For developers and developing site - suggestions, coding problems, API questions, new applications...
Forum rules
Under no circumstances is spamming or advertising of any kind allowed. Do not post any abusive, obscene, vulgar, slanderous, hateful, threatening, sexually-orientated or any other material that may violate others security. Profanity or any kind of insolent behavior to other members (regardless of rank) will not be tolerated. Remember, what you don’t find offensive can be offensive to other members. Please treat each other with the kind of reverence you’d expect from other members.
Failure to comply with any of the above will result in users being banned without notice. If any further details are needed, contact: “The team” using the link at the bottom of the forum page. Thank you.

Query by Season/Episode - Crazy results

Postby eduo » Wed Jun 27, 2012 12:51 am

So, I was testing some stuff today. I drop "True Blood 3x08 - Night on the Sun.avi" onto SolEol to check something and let it rip.

Doesn't find any subs in english (weird, but OK) so it tries to find subs by name. I have it set to search by "query", season and episode, if present. Query XML looks like this:

http://snipt.org/vajib8

Then the results come back, and my jaw drops. 93 results.

http://cl.ly/Hfna
http://snipt.org/vajic1

Checking the results each one seems to have taken the parameters right (fulltext, season 3, episode 8) but from the first result it's returning whatever season and episode it wishes and not the ones I searched for.

I get this now for all searches, but this wasn't happening like this before.
User avatar
eduo
Moderator
 
Posts: 667
Joined: Sat Feb 10, 2007 1:40 am
Location: Information Technology

Re: Query by Season/Episode - Crazy results

Postby oss » Wed Jun 27, 2012 6:55 am

http://pastebin.com/WcCCdbe2

http://pastebin.com/tKngCiAR

there was error in code, thanks for good find (episode and season filters was not applied), it should be fixed now.

Also, there is applied parsing of query, you can read about it more here: viewtopic.php?f=26&t=12823 (if you dont have access, I will put it public, I think it is time:)

Btw, nice new GUI in SolEol and welcome back on forum.

Edit; you may wonder, why sanctuary is in the results...it is because of AKA. You get idea (be logged in) here http://www.opensubtitles.org/en/subtitl ... nctuary-en

Edit2: it is possible you don't see anything suspect there, I code some routine to check movieaka for somethings, which don't belong to movie akas, so it is ignored, deleted, not indexed...lets see how it will work - database is reindexing 1 time per day, so maybe tomorrow you will not get the sancturay in results...
User avatar
oss
Site Admin
 
Posts: 2205
Joined: Sat Feb 25, 2006 11:26 pm

Re: Query by Season/Episode - Crazy results

Postby eduo » Wed Jun 27, 2012 12:44 pm

oss wrote:http://pastebin.com/WcCCdbe2

http://pastebin.com/tKngCiAR

there was error in code, thanks for good find (episode and season filters was not applied), it should be fixed now.

Also, there is applied parsing of query, you can read about it more here: viewtopic.php?f=26&t=12823 (if you dont have access, I will put it public, I think it is time:)

Btw, nice new GUI in SolEol and welcome back on forum.

Edit; you may wonder, why sanctuary is in the results...it is because of AKA. You get idea (be logged in) here http://www.opensubtitles.org/en/subtitl ... nctuary-en

Edit2: it is possible you don't see anything suspect there, I code some routine to check movieaka for somethings, which don't belong to movie akas, so it is ignored, deleted, not indexed...lets see how it will work - database is reindexing 1 time per day, so maybe tomorrow you will not get the sancturay in results...


Hadn't seen changes to query. Cool.

I did wonder about Sanctuary, but when searching by name I expect all sorts of things to appear there :) SolEol has some logic as well to ignore things too obviously different to what's being searched.
User avatar
eduo
Moderator
 
Posts: 667
Joined: Sat Feb 10, 2007 1:40 am
Location: Information Technology

Re: Query by Season/Episode - Crazy results

Postby oss » Wed Jun 27, 2012 12:56 pm

good, I also implemented some magic :) Anyway, I would like to see new SolEol, so when you release the one with new GUI, please let us know.
User avatar
oss
Site Admin
 
Posts: 2205
Joined: Sat Feb 25, 2006 11:26 pm

Re: Query by Season/Episode - Crazy results

Postby eduo » Wed Jun 27, 2012 1:35 pm

oss wrote:good, I also implemented some magic :) Anyway, I would like to see new SolEol, so when you release the one with new GUI, please let us know.


As soon as this other project leaves me with enough time to get it done:

http://www.flickr.com/photos/eduo/sets/ ... 564863051/

:D
User avatar
eduo
Moderator
 
Posts: 667
Joined: Sat Feb 10, 2007 1:40 am
Location: Information Technology

Re: Query by Season/Episode - Crazy results

Postby oss » Wed Jun 27, 2012 2:05 pm

good luck with that, this one long-time run and not so easy as SolEol :)
User avatar
oss
Site Admin
 
Posts: 2205
Joined: Sat Feb 25, 2006 11:26 pm


Return to Developing

Who is online

Users browsing this forum: No registered users and 1 guest