Latest Export

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

Sun Oct 07, 2012 8: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 4:34 am

Mon Oct 08, 2012 1: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 4:34 am

Mon Oct 08, 2012 12: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...
User avatar
ManiacB
Site Moderator
Posts: 2004
Joined: Tue Apr 26, 2011 3:56 am

Mon Oct 08, 2012 1: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 4:34 am

Mon Oct 08, 2012 1:47 pm

Ok thank you for the DB dump ;)
User avatar
szsori
Site Admin
Posts: 2294
Joined: Fri Nov 03, 2006 2:23 pm

Mon Oct 08, 2012 7: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: 256
Joined: Thu Nov 25, 2010 8:29 pm

Thu Jan 03, 2013 5:40 pm

any chance of getting a new db dump to round out 2012?
theraster
Posts: 256
Joined: Thu Nov 25, 2010 8:29 pm

Sun Feb 03, 2013 6:44 am

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

Mon Feb 04, 2013 10:32 am

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 10:26 am

Fri Mar 01, 2013 10:30 am

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.
Post Reply