Already added requests should be cleaned from the list.
(Sorry for my English)
Forum rules
Under no circumstances is spamming or advertising of any kind allowed. Do not post any abusive, obscene, vulgar, slanderous, hateful, threatening, sexually-orientated or any other material that may violate others security. Profanity or any kind of insolent behavior to other members (regardless of rank) will not be tolerated. Remember, what you don’t find offensive can be offensive to other members. Please treat each other with the kind of reverence you’d expect from other members.
Failure to comply with any of the above will result in users being banned without notice. If any further details are needed, contact: “The team” using the link at the bottom of the forum page. Thank you.
Under no circumstances is spamming or advertising of any kind allowed. Do not post any abusive, obscene, vulgar, slanderous, hateful, threatening, sexually-orientated or any other material that may violate others security. Profanity or any kind of insolent behavior to other members (regardless of rank) will not be tolerated. Remember, what you don’t find offensive can be offensive to other members. Please treat each other with the kind of reverence you’d expect from other members.
Failure to comply with any of the above will result in users being banned without notice. If any further details are needed, contact: “The team” using the link at the bottom of the forum page. Thank you.
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....
I know sitation is not good nowadays, and fix this shouldnt be a big problem
A 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)
while request not filled :
hold forever if necessary
For browsing request, add filter "last week, last month, last 3 months, last 6 months, last year, more than 1 year"
when uploading subs either thru subdownloader or web site : check that if request exists and if yes, flag request as (maybe) filled
for all requests : add a search, sort by date, imdb id, requesters, etc, pretty much like the subs base.
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).
That was my 2 cents for today
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)
while request not filled :
hold forever if necessary
For browsing request, add filter "last week, last month, last 3 months, last 6 months, last year, more than 1 year"
when uploading subs either thru subdownloader or web site : check that if request exists and if yes, flag request as (maybe) filled
for all requests : add a search, sort by date, imdb id, requesters, etc, pretty much like the subs base.
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).
That was my 2 cents for today
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)
OK, every night runs a script, it sends "search results" based on search criteria - log in, search something, and at bottom you ahve MAIL RESULT. When user add request, program automatically add this to "search request", so when request is filled, it is sent to requester as you want to. I dont think it is good to ask user, if those subtitles match. Maybe we add someday requests through subdownloader (it is not possible now), or maybe we allow only these kinds of requests, so we will know, if requests are filled with right subtitles.
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 existfor 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).
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.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"
let's say your dates are store in mysql format :
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" ;
there are also some SQL requests such as :
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;
hehe, dates aren't problem, I will show you how current SQL looks like for request:
hope you understand I am using ABstract table for storing everything, and it is quite fun
Ofcourse I know how to add some condition for selecting just some records which are in date range...but...I am doing something different, I think, and I hope, tomorrow main page (first) will change a bit...
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
I am using ABstract table for storing everything, and it is quite fun Ofcourse I know how to add some condition for selecting just some records which are in date range...but...I am doing something different, I think, and I hope, tomorrow main page (first) will change a bit...
-
Jasperwillem
- Posts: 3
- Joined: Fri Dec 01, 2006 1:58 pm
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 ?
The request sections of some private trackers keep track of the number of requests you complete, and with this create a ranking or so, or other benefits, make something up for that.
Most communities live or die on the request section, since when no-one comments requests their would be no content users search for.
I totally forget to fill in this rule. How stupid of me.
Who is online
Users browsing this forum: No registered users and 14 guests