english 
Thread Options  Search this Thread  
Post: #1
29-11-2009 19:04 PM (This post was last modified: 29-11-2009 19:17 PM by mrozik)
mrozik


Joined: 20-12-2008
Posts: 7
Country: Poland
Male mrozik is Offline now
some H&R cronjob ideas
Hi

First i want You to look at this screen:

 

As You know this is a part of settings panel. I changed it. I think ideas that i present on this screen should be understand when You will see some examples.

Few things of explaination:
Red numbers on the screen match numbers that i will write
DM - doesn't matter
(...) - fixed part of query

example1:
1. No
2.-6. DM (because cronjob is disabled)
Cronjob: disable
Finish query: none

exaple2:
1. Yes
2. Yes
3. 48 (48h=48*60*60=172800s)
4. No
5. DM (seedtime obligation is disable)
6. DM (because only one obligation is enable)
Cronjob: enable
Finish query:
CODE:
(...) AND UNIX_TIMESTAMP(s.completedat) > 1230806554 AND s.uploaded / s.downloaded < 0.5 AND time()-UNIX_TIMESTAMP(s.completedat)>172800


example3:
1. Yes
2. Yes
3. 48 (48h=48*60*60=172800s)
4. Yes
5. 48 (48h=48*60*60=172800s)
6. BOTH
Cronjob: enable
Finish query:
CODE:
(...) AND UNIX_TIMESTAMP(s.completedat) > 1230806554 AND ((s.uploaded / s.downloaded < 0.5 AND time()-UNIX_TIMESTAMP(s.completedat)>172800) OR (s.seedtime < 86400 AND time()-UNIX_TIMESTAMP(s.completedat)>172800))


example4:
1. Yes
2. Yes
3. 48 (48h=48*60*60=172800s)
4. Yes
5. 48 (48h=48*60*60=172800s)
6. ONE OF THEM
Cronjob: enable
Finish query:
CODE:
(...) AND UNIX_TIMESTAMP(s.completedat) > 1230806554 AND (s.uploaded / s.downloaded < 0.5 AND time()-UNIX_TIMESTAMP(s.completedat)>172800) AND (s.seedtime < 86400 AND time()-UNIX_TIMESTAMP(s.completedat)>172800)


example5:
1. Yes
2. no
3. DM (ratio obligation is disable)
4. Yes
5. 48 (48h=48*60*60=172800s)
6. DM (because only one obligation is enable)
Cronjob: enable
Finish query:
CODE:
(...) AND UNIX_TIMESTAMP(s.completedat) > 1230806554 AND s.seedtime < 86400 AND time()-UNIX_TIMESTAMP(s.completedat)>172800


When number 3. or 5. will be set to 0 the SQL query will be the same that with number bigger than 0 but it will means disable the time limit.

I hope all of this is clear. If no, please post here.

Post: #2
29-11-2009 21:55 PM
mhmd1983


Joined: 17-01-2008
Posts: 713
Country: Egypt
Male mhmd1983 is Offline now
some H&R cronjob ideas
OOh , great one
But for me i suggest xam give away the source code of hit and run cron job so we can edit it to match our own needs , also this screen can be edited and moved to stuff panel to have the ability to edit both of cronjob , and stuff panel front end as a plugin or add-on

Quick Reply
Decrease Size
Increase Size
Insert bold text Insert italic text Insert underlined text Align text to the left Align text to the centerr Align text to the right Justify text Insert quoted text Code Insert formatted PHP code Insert formatted SQL code
Colors
Insert hyperlink Insert image Insert email address
Smilies
Insert hidden text



Forum Jump: