Latest Export

Announcements about the database, website, and plugins.
Coco
Site Admin
Posts: 2472
Joined: Tue Mar 13, 2007 10:16 pm
Location: Canada

Re: Latest Export

Postby Coco » Sun Oct 07, 2012 10:42 am

Your question doesn't have anything to do with this DB dump. You just posted a list of other databases on your computer. I might answer the odd question about the database but we don't officially support it so if you want to use it you'll have to at least know the basics of how mySQL works.
Please don't PM me. Post in the forums instead unless there is a very good reason for a PM or I won't respond.

Piero87
Posts: 151
Joined: Fri May 13, 2011 6:34 am

Re: Latest Export

Postby Piero87 » Mon Oct 08, 2012 3:21 am

you have right i'm sorry, i have open the tvdb.sql in mysql and i have this tablelist:

aka_seriesname
banners
genres
imgstatus
languages
networks
ratings
seriesactors
translation_episodename
translation_episodeoverview
translation_seriesname
translation_seriesoverview
tvepisodes
tvseasons
tvseries

what is the call to have a list of all tv series? thank you very much...

Piero87
Posts: 151
Joined: Fri May 13, 2011 6:34 am

Re: Latest Export

Postby Piero87 » Mon Oct 08, 2012 2:34 pm

Ok with SELECT tvseries.SeriesName
FROM tvseries

i can find a list of all TV Series, in english language, can you tell me please how i can find a list of all series in the italian language? what is the query? thank you very much...

ManiacB
Site Moderator
Posts: 1992
Joined: Tue Apr 26, 2011 5:56 am

Re: Latest Export

Postby ManiacB » Mon Oct 08, 2012 3:44 pm

Not trying to be rude here, but this is pretty basic stuff and you'd be better off googling for some simple MySQL tutorials by the sounds of it.
We're happy to provide a DB dump but we're not really here to teach you how to use it.

Piero87
Posts: 151
Joined: Fri May 13, 2011 6:34 am

Re: Latest Export

Postby Piero87 » Mon Oct 08, 2012 3:47 pm

Ok thank you for the DB dump ;)

szsori
Site Admin
Posts: 2014
Joined: Fri Nov 03, 2006 5:23 pm

Re: Latest Export

Postby szsori » Mon Oct 08, 2012 9:06 pm

And just for reference to try saving you a bit of time, you want to do a join on the tvseries and translation_seriesname tables and set your where clause to limit based on the language id. Likewise, doing an outer join with the same filter will also show untranslated series. We'd love for you to fill those in if you ever have some time. ;)

theraster
Posts: 241
Joined: Thu Nov 25, 2010 11:29 pm

Re: Latest Export

Postby theraster » Thu Jan 03, 2013 8:40 pm

any chance of getting a new db dump to round out 2012?

theraster
Posts: 241
Joined: Thu Nov 25, 2010 11:29 pm

Re: Latest Export

Postby theraster » Sun Feb 03, 2013 9:44 am

coco?

Coco
Site Admin
Posts: 2472
Joined: Tue Mar 13, 2007 10:16 pm
Location: Canada

Re: Latest Export

Postby Coco » Mon Feb 04, 2013 1:32 pm

Please don't PM me. Post in the forums instead unless there is a very good reason for a PM or I won't respond.

plek
Posts: 7
Joined: Fri Mar 01, 2013 1:26 pm

Re: Latest Export

Postby plek » Fri Mar 01, 2013 1:30 pm

Hi coco.

Thank your for making this available.

I developed an iOS app and i would like to include a TV Shows recommender. I was playing with ratings table for that purpose. In your last dump that table is not included. Was that a mistake or you won't export this table anymore ?

Thank you.