[KoTiX]

I'm making a movieplayer.it scaper for tv series, when in a show or in an episode there is a very big list of actors the display order is wrong, sometimes it seems kind of casual.
This is my GetEpisodeDetails

Code:

GetEpisodeDetails returned
<details>
<title>Our Father</title>
<plot>La vita di Dexter sembra tornata sui giusti binari. Individuato un nuovo criminale da far fuori, si ritrova però ad uccidere per caso l'uomo sbagliato, il fratello del pubblico ministero Miguel Prado. Intanto, gli Affari Interni fanno pressione su Debra affinché sorvegli il suo nuovo collega, il detective Quinn.</plot>
<aired>28.09.2008</aired>
<rating>8.3</rating>
<actor><name>Michael C. Hall</name><role>Dexter Morgan</role><thumb>http://images.movieplayer.it/2008/05/30/michael-c-hall-77744.jpg</thumb></actor>
<actor><name>Julie Benz</name><role>Rita Bennett</role><thumb>http://images.movieplayer.it/2007/07/12/julie-benz-44518.jpg</thumb></actor><actor><name>Jennifer Carpenter</name><role>Debra Morgan</role><thumb>http://images.movieplayer.it/2003/07/26/jennifer-carpenter-21059.jpg</thumb></actor><actor><name>C.S. Lee</name><role>Vince Masuka</role><thumb>http://images.movieplayer.it/2009/08/24/c-s-lee-e-vince-masuka-nella-stagione-4-di-dexter-128192.jpg</thumb></actor><actor><name>Lauren Vélez</name><role>Tenente Maria Laguerta</role><thumb>http://images.movieplayer.it/2009/06/09/lauren-velez-interpreta-la-tenente-maria-laguerta-nella-seconda-stagione-di-dexter-120121.jpg</thumb></actor>
<actor><name>David Zayas</name><role>Angel Batista</role><thumb>http://images.movieplayer.it/2009/08/24/david-zayas-e-angel-batista-nella-stagione-4-di-dexter-128194.jpg</thumb></actor><actor><name>Preston Bailey</name><role>Cody</role><thumb>http://images.movieplayer.it/2008/09/16/una-foto-di-preston-bailey-88532.jpg</thumb></actor><actor><name>Mike Erwin</name><role>Freebo</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor>
<actor><name>Desmond Harrington</name><role>Joey Quinn</role><thumb>http://images.movieplayer.it/2003/01/15/desmond-harrington-1516.jpg</thumb></actor><actor><name>Nick Hermz</name><role>Oscar Prado</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor><actor><name>Jelly Howie</name><role>Teegan</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor><actor><name>Marc John Jefferies</name><role>Wendell Owens</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor>
<actor><name>Mary Alyce Kania</name><role>Karen</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor><actor><name>Liza Lapira</name><role>Yuki Amado</role><thumb>http://images.movieplayer.it/2008/08/31/foto-dell-attrice-liza-lapira-86904.jpg</thumb></actor><actor><name>Paul Lieber</name><role>Barista</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor><actor><name>Jason Manuel Olazabal</name><role>Ramon Prado</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor>
[b]<actor><name>Anthony Tyler Quinn</name><role>Dentista</role>[/b]<thumb>http://images.movieplayer.it/fake.jpg</thumb></actor><actor><name>David Ramsey</name><role>Anton Briggs</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor><actor><name>Bryce Robinson</name><role>Ragazzo #1</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor>
<actor><name>Christina Robinson</name><role>Astor</role><thumb>http://images.movieplayer.it/2009/03/24/un-primo-piano-di-christina-robinson-109466.jpg</thumb></actor>
<actor><name>Jimmy Smits</name><role>Miguel Prado</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor><actor><name>Yolanda Snowball</name><role>Insegnante</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor>
<actor><name>Joel Weiss</name><role>Cal Rooney</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor><actor><name>Mario Z.</name><role>Uomo anziano</role><thumb>http://images.movieplayer.it/fake.jpg</thumb></actor>
<director>Keith Gordon</director>
<credits>Clyde Phillips</credits>
</details>

Then XBMC display:

Antony Tyler as Dentista
Michael C. Hall as Dexter
Julie Benz as ...
Jennifer Carpenter as...
C.S. Lee as ...

It should start with Michael C. Hall but it starts with Antony Tyler that is in the middle of the list, and it's worse if the list is longer (in the show details for example)

Here is my scraper if somebody need it for debugging:
http://pastebin.com/m715cf583

[KoTiX]

Bump!
Anybody know why is this happening?
Is there a limit to the actors number? If so how can i limit the results of the regexp?
Tnx in advance

[jmarshall]

Nothing obvious would cause that as far as I can tell. Check in the db itself to see what's in the link table for actors + tvshows.

[KoTiX]

Uhm, i exported the db and it's exactly in the way I see it in xbmc, with the wrong order, let me show you a bigger example:

This is my scraper if you need to test it, just turn on everything in the settings:
http://www.2shared.com/file/8701907/2c0b...it-TV.html

with that, looking for Dexter, i have this log:
http://pastebin.com/m198c15cb
where you can see the first actor is:
<actor>
<name>Michael C. Hall</name>
<role>Dexter Morgan 40 episodi (2006 - 2009)</role>
<thumb>http://images.movieplayer.it/2008/05/30/michael-c-hall-77744.jpg</thumb>
</actor>

But the result in xbmc and in its db is:
http://pastebin.com/d6966794e

I know it's not a big problem, but the first names are the ones with the thumb and they are the most knowed people.

Tnx again if you can take a look at it

[jmarshall]

I meant to check in the link table directly in the db. If it's in the wrong order there, then it'll be in the wrong order when returned.

Open your db in sqlitespy or similar.

[KoTiX]

Looking with sqllite the order in my db is ok, btw il try deleting my db if that can be the problem

[KoTiX]

Nevermind, my database was not right, those actors in the wrong positions had somehow a lower id (28, 200, 211 etc) than the first scraped (4585, 4586, 4587, etc).
I'm sorry, it was my fault, I should clean my db before starting playing with scrapers

[jmarshall]

No problem - we rely on the order in the db for this (which strictly speaking is incorrect) so if you have earlier entries in those tables things will go wrong, yes.

[UsagiYojimbo]

I have the same problem: the actors got in mixed up order.
Is it possible, to retain the scraper returned order? E.g. by adding an order field to the table that links the actors to the movie/episode?