Already added requests should be cleaned from the list.
(Sorry for my English)
ok, it makes sense. What about those, where subtitles exists ? Delete them after...1,2 weeks, month ?I don't think the request should be deleted when there are no subs....
it may take longer than a month before a sub for a not-so-well-known movie appear....
this works a bit different, I will describe it a bit, it is hidden feature as alwaysA bunch of ideas for requests :
if request is filled with subdownloader :
- send an email to requester(s)
- delete request
if request if filled thru website :
- send an email to requester
- ask requester to confirm subs match copy (with subdownloader eventually)
- delete request if confirmed, else hold until confirmation but signal existence of subs (and ask confirmation)
yes, now it is done so.while request not filled :
hold forever if necessary
this should be done, it is not so hard I think. But dont want to see SQL which is generating thatFor browsing request, add filter "last week, last month, last 3 months, last 6 months, last year, more than 1 year"
it is already done - look at right side of requests...when uploading subs either thru subdownloader or web site : check that if request exists and if yes, flag request as (maybe) filled
yes, I thought this should be nice too, but who is looking on requests anyway ?for all requests : add a search, sort by date, imdb id, requesters, etc, pretty much like the subs base.
nothing as contributors mailing list does not exist I don't want send mail at all, or minimize it...everything is on the site:) So when someone want fill some request, he just look in request area and fill it.for all requests : send a weekly email to contibutors that have subscribed to it : "This week theses subtitles were requested, can you help ?".
(note that one should be able to select the languages he wants to contribute and therefore not receive request for languages he will not be likely to have).
my 4 centsThat was my 2 cents for today
mmm depending on how you store your dates in the SQL database it's more or less easy...this should be done, it is not so hard I think. But dont want to see SQL which is generating thatFor browsing request, add filter "last week, last month, last 3 months, last 6 months, last year, more than 1 year"
Code: Select all
$today = time();
$last_week = date("Y-m-d", ($today - (86400 * 7)) ) ;
$last_month = date("Y-m-d", ($today - (86400 * 30)) ) ;
$last_6months = date("Y-m-d", ($today - (86400 * 182)) ) ;
$last_year = date("Y-m-d", ($today - (86400 * 365)) ) ;
$all = '0000-00-00' ;
switch ($_POST['since_when']) {
case 'week' :
$date_selected = $last_week;
case 'month' :
$date_selected = $last_month;
.../...
}
$sql = "select * from " . TABLE_WHERE_REQUEST_ARE_STORED . "where date_added > $date_selected" ;
Code: Select all
FROM_UNIXTIME(table.field_name)
which returns a date in format YYYY-MM-DD HH:MM:SS
for example :
$last_week = date("Y-m-d 00:00:00", ($today - (86400 * 7)) ) ;
sql = "SELECT .... FROM_UNIXTIME(table.field_name) as date_added ".
"WHERE FROM_UNIXTIME(table.field_name) >= $last_week".
"ORDER BY date_added DESC;
Code: Select all
SELECT SQL_CALC_FOUND_ROWS count(IDSubtitle) as cnts, AID, cnt, MovieName, MovieYear, MovieImdbRating, IDMovieImdb, IDMovie, LanguageName, ISO639, IDSubLanguage, added
FROM
(
SELECT AID, COUNT( a.ASubjectID ) AS cnt, b.MovieName, b.MovieYear, b.MovieImdbRating, b.IDMovieImdb, b.IDMovie, c.LanguageName, c.ISO639, c.IDSubLanguage, a.ADateTime AS added
FROM subs_abstract a
LEFT JOIN subs_movie b ON a.ASubjectID = b.IDMovie
LEFT JOIN subs_subtitle_language c ON a.ALanguageID = c.IDSubLanguage
WHERE $where and a.AType = 'sreq'
AND a.AEnabled = 1
GROUP BY ASubjectID, ALanguageID
) x
LEFT JOIN subs_subtitle y ON idsublanguage = SubLanguageID and IDMovie = MovieID
WHERE (SubEnabled = 1 or SubEnabled is null)
GROUP BY AID
ORDER BY cnt DESC , added DESC
Believe me, the request are careful watched, since they contain the newest movies available on the web, same as I use this search function not only for searching subs, since I watch the most in Englishyes, I thought this should be nice too, but who is looking on requests anyway ?
Users browsing this forum: No registered users and 72 guests