Latest Export

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

Re: Latest Export

Postby Coco » Fri Mar 01, 2013 6:03 pm

We're not going to be including the ratings table in any of the future dumps as it contains user information.
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 » Sat Mar 02, 2013 4:46 am

OK, I understand that.
In my opinion ratings have a big potential for recommending TV Shows.For instance if an user (A) likes shows 1, 8 and 30 , we could search for another user(B) who also likes those shows and recommend to user A another shows that user B likes. We really don't need to know user ids (the only user information available in that table). Perhaps (I know that needs your effort) that userid can be hidden or changed in same way (md5). I didn't find any way to get this information using API.

Thank you.

aur0n
Posts: 4
Joined: Fri Mar 16, 2012 1:20 pm
Location: Italia

Re: Latest Export

Postby aur0n » Fri Apr 19, 2013 1:07 pm

Sorry for the dumb question but... where I can find the database schema?

For example, in the dump file, one of the first queries is "INSERT INTO aka_seriesname...", but how do I create that table first?

EDIT: Nevermind, got it!

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

Re: Latest Export

Postby Coco » Mon Jun 17, 2013 2:47 pm

New dump posted. Check first post in thread for links.
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.

hotbrit
Posts: 14
Joined: Tue Jul 17, 2012 10:51 am

Re: Latest Export

Postby hotbrit » Sun Jun 30, 2013 4:36 pm

Thanks for making the dumps available !

Game
Posts: 2
Joined: Sun Jul 14, 2013 1:21 pm

Re: Latest Export

Postby Game » Sun Jul 14, 2013 1:24 pm

Hi dudes,

I'm sorry, can the dump be uploaded somewhere else? hero6.com doesn't exist anymore, as the notice apoints:

NOTICE: This domain name expired on 07/12/2013 and is pending renewal or deletion.

Please...

thanks

furby
Site Moderator
Posts: 4063
Joined: Mon Aug 24, 2009 8:30 am

Re: Latest Export

Postby furby » Mon Jul 15, 2013 7:55 am

Works fine for me, guess it was renewed.
Please link to the series/episode page and your sources. Wikipedia is NOT a valid source.

Game
Posts: 2
Joined: Sun Jul 14, 2013 1:21 pm

Re: Latest Export

Postby Game » Mon Jul 15, 2013 11:27 am

I'm gonna try when i get home, thanks

RoliSoft
Posts: 2
Joined: Wed May 19, 2010 8:22 am

Re: Latest Export

Postby RoliSoft » Sun Jan 26, 2014 10:21 am

Would it be possible to request a newer dump?

Thank you very much!

Tweekster
Posts: 3
Joined: Wed Dec 19, 2012 7:10 am

Re: Latest Export

Postby Tweekster » Mon Jan 27, 2014 9:56 am

Yes, after half a year it would be good to get a new dump.

Pretty pleeeeeease.