ya as track said u must search but for the hurdle race time :
u got to check 2 things
1st : the real way to change then the practice ;)
1st:
UPDATE cq_action SET param = '2009-06-22 01:45 2009-06-22 02:00' where id = 6915085;
where "2009-06-22 01:45" is from when open and
"2009-06-22 02:00" till when its closed (so 2009-06-22 02:01 will be already impossible to enter anymore!)
2nd by Soul :
Quote:
Ok I will describe additionally here rules under action type "123" - which is responsible for time
As I noticed this was never explained totally and I was asked in time few times for details considering this usage .... So here we go
IN GENERAL:
Code:
ACTION_CHKTIME = 123, / /
data for the time to type
0 - check the details of the current server time "% d-% d-% d% d:% d% d-% d-% d% d:% d";
1 - check in One day time "% d-% d% d:% d% d-% d% d:% d",
2 - to check the time on one day "% d% d:% d% d% d:% d",
3 - check days "% d% d:% d% d% d:% d",
4 - to check on time "% d:% d% d:% d",
5 - check the hours "% d % d "(the first few minutes of each hour in the end a few minutes)
IN PRACTICE
ok we have type "123" and "data" and "param"
(DATA =0)
Param: 2010-01-15 00:00 2011-02-23 23:59
START checking time
End checking time
2010 = year start
01 = month (01 = January) start
15 = day start
2010 - year finish
02 - month (02 = February)
23 - day
(DATA =1)
type: 123
data: 1
param: 10-31 00:00 11-9 23:59
meaning
Start time:
month number = 10 (September)
day number
Hour (its 24 clock, meaning you if you wish to setup like 1 pm just put 13:00)
Finishing time - rules like under starting -> month, day, hour
Now NEXT (DATA =2):
type: 123
data: 1
param: 1 00:00 1 23:59
Day number (1 = Monday, 2=Tuesday..... 7= Sunday)
Time (start - finish) at 00:00 will start and will finish at 23:59
(DATA =3)
this one is under similar rules like DATA = 2 !!
Its like data 2 is checking all for one certain day but data 3 is doing this during all days ... (I didnt find usage of different for both yet but I am suspecting that data 2 is just working only for within 1 day like from 1 to 1 ... but data 3 will can be used for checking dats within range 1-7 even ...)
(DATA =4)
Param: 21:10 21:12
Start time
End time
(DATA =5)
Param: 43 44
this one is most tricky
It will check minutes of certain hour on server
so if you wish to something last must happen between 43 and 44 minute of every hour you must use it
EXAMPLES:
Code:
id id_next id_nextfail type data param
Code:
10000 10001 10002 0123 0 2010-01-15 00:00 2011-02-23 23:59
Code:
10000 10001 10002 0123 1 10-31 00:00 11-9 23:59
Code:
10000 10001 10002 0123 2 1 00:00 1 23:59
Code:
10000 10001 10002 0123 3 1 00:00 1 23:59
Code:
10000 10001 10002 0123 4 21:10 21:12
Code:
10000 10001 10002 0123 5 19 19
Remember: this is not automatic checking! meaning - you always must be aware of get this action to life by other action
Regards
|
BestRegards ;)