Jump to content

Destramic

Members
  • Posts

    960
  • Joined

  • Last visited

About Destramic

  • Birthday 10/06/1986

Profile Information

  • Gender
    Male
  • Location
    United Kingdom

Contact Methods

  • Skype
    destramic

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Destramic's Achievements

Advanced Member

Advanced Member (4/5)

0

Reputation

3

Community Answers

  1. after my last post, i tried text type and got the same issue....varchar it is thank you for your time barand
  2. one lastthing, i want to make user_agent_checksum a unique index, but cant as its a blob, is there away around this...or will i have to make it a text type.
  3. now that is smart way of doing it :), i wouldt even need to create a cookie garbage collector thank you for helping me, again, barand
  4. i suppose these fields, would overall determine if a cookie exists: SELECT DISTINCT(name) , value FROM cookies WHERE user_agent_checksum = '...' AND domain = 'http://mysite.uk' AND path = '/' AND expiry > NOW() ORDER BY created DESC
  5. thank you for your reply barand, but.... cookie id is the only key in the table which isnt present during the insert causing there never to be a duplicate key and just inserts and not update. INSERT INTO cookies (name, value, path, domain, expiry, user_agent, user_agent_checksum, ip_address, ip_address_checksum) VALUES ('test', 1, '/', 'test', DATE_ADD(NOW(), INTERVAL 22 SECOND), 1, 1 , 1, 1) ON DUPLICATE KEY UPDATE value = 1 , expiry = DATE_ADD(NOW(), INTERVAL 22 SECOND) i could just insert a new cookie/row regardless if it cookie exists...and the cookies like so? SELECT DISTINCT(name) , value FROM cookies WHERE expiry > NOW() ORDER BY created DESC unless you have a better way
  6. Destramic

    Cookie DB

    hey guys im trying to create a cookie storage database...i want to update a cookie/row, but if the cookie doesnt exist i want to insert it a row, like so: UPDATE cookies SET value = 1 , expiry = DATE_ADD(NOW(), INTERVAL 22 SECOND) WHERE user_agent_checksum = 'fffff' AND name = 'test' AND domain = 'test' AND path = '/' AND expiry > NOW() AND NOT EXISTS( INSERT INTO cookies (name, value, path, domain, expiry, user_agent, user_agent_checksum, ip_addess, ip_address_checksum) VALUES ('test', 1, '/', 'test', DATE_ADD(NOW(), INTERVAL 22 SECOND), 1, 1 , 1, 1) ) but i get a error: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO cookies (name, value, path, domain, expiry, user_agent, user_agent_c' at line 8 so my question is how do i update a cookie/row, but if it doesnt exist then to create a new one please? here is the table structure: CREATE TABLE `cookies` ( `cookie_id` int(11) NOT NULL AUTO_INCREMENT, `name` blob NOT NULL, `value` blob NOT NULL, `path` varchar(45) NOT NULL, `domain` varchar(45) NOT NULL, `ip_address` blob NOT NULL `ip_address_checksum` blob NOT NULL, `user_agent` blob NOT NULL, `user_agent_checksum` blob NOT NULL, `expiry` timestamp NOT NULL, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`cookie_id`) ) thank you
  7. I've had numerous amounts of help from this forum for something that I have alot of passion for. Infact it was the first job I wanted to do when I grew up, but now I'm 34 haha! I played with Geocities when I was 13 then grasped how to write raw. But now I'm confident in many languages and feel I can put things together (not as well as you gurus). Anyhow, I want a career change and want to follow my kiddish dreams and work as a programmer. Start as a junior for a company, gain necessary qualifications if required and do what it is I love. Can you guys please give some advise for a rookie? Thank you 👍
  8. baramd this is beyond help, wow, thank you indeed. such a shame theres no exit statergy with the query, well its late now, so when im back on tomorrow i'll run you code and have a good tinker and get back to you. once again thank you, you didnt need to go to such efforts, but its greatly appreciated 😊
  9. Barand, can i please get some further advise, i've managed to get the end timestamp when the task is more than 2 days. But i got 2 problems, other than cleaning up the query. as seen in the picture, https://ibb.co/cbYN6BC 1. the date 24/06/2020 is the first date to subtract the remaining minutes and i don't know why, the first date subtracting minutes should be on the 23/06/2020 (total task time 1800 mins - 540 mins = 1260) 2. how do i end the query once i have a task end date? so it doesnt go through all the dates in the dates table? if i can figure these two problems out then i think im on my way...i'll need to add the annual leave to the task time also, which isnt a issue. set @days_work = NULL; set @minutes_remaining = NULL; SELECT t.task_id , times.day_working_hours , times.username , times.task_type , times.date , times.duration_hours , times.task_start_timestamp , times.task_end_timestamp , times.day_name , times.remaining_minutes , times.days_work , times.holiday_start_timestamp , times.holiday_end_timestamp , (times.duration_hours * 60) FROM tasks t LEFT JOIN ( SELECT date , t.task_id , u.username , tt.task_type , tt.duration_hours , ot.start_timestamp as task_start_timestamp , @day_working_hours := (timestampdiff(MINUTE, och.start_time, och.finish_time) - (timestampdiff(MINUTE, och.start_time, och.finish_time) DIV 270 ) * 30) / 60 as day_working_hours , DAYNAME(date) as day_name , oal.start_timestamp as holiday_start_timestamp , oal.end_timestamp as holiday_end_timestamp , @minutes_remaining := CASE WHEN @minutes_remaining IS NULL THEN TRUNCATE((tt.duration_hours * 60) - (@day_working_hours * 60), 0) ELSE TRUNCATE(@minutes_remaining - (@day_working_hours * 60), 0) END as remaining_minutes , @days_work := CASE WHEN @days_work IS NULL AND (@day_working_hours * 60) < @minutes_remaining THEN 1 WHEN @days_work IS NOT NULL AND (@day_working_hours * 60) < @minutes_remaining OR @days_work IS NOT NULL AND @minutes_remaining > 0 THEN @days_work + 1 END as days_work , CASE WHEN (@day_working_hours * 60) > @minutes_remaining AND @minutes_remaining > 0 THEN CONCAT(DATE_ADD(date(ot.start_timestamp), INTERVAL @days_work DAY), ' ', DATE_ADD(och.start_time, INTERVAL @minutes_remaining MINUTE)) ELSE NULL END as task_end_timestamp FROM dates d LEFT JOIN operative_contracted_hours och ON weekday(date) = och.week_day JOIN operatives_tasks ot USING (user_id) JOIN tasks t USING (task_id) JOIN task_types tt USING (task_type_id) JOIN users u USING (user_id) LEFT JOIN operatives_annual_leave oal ON oal.start_timestamp < CONCAT(date, ' ', och.finish_time) AND oal.end_timestamp > CONCAT(date, ' ', och.start_time) AND och.user_id = oal.user_id ORDER BY date ) as times ON times.task_id = t.task_id hope you can help further, thank you so far
  10. i like that idea, i looked at the old code you helped me with which had the same principle 😁 $db->exec("CREATE TEMPORARY TABLE date_range ( date DATE PRIMARY KEY )"); $stmt = $db->prepare("INSERT INTO date_range VALUES (?)"); foreach ($dp as $date) { $d = $date->format('Y-m-d'); $stmt->execute([$d]); } regarding the query i added a dates table and inserted a number of dates ands ran the query, thank you, i increased the task duration and increased the contracted working hours on a few days while testing and saw the query would only work a maximum of two days, so i had a little play around, and came up with this set @days_work = NULL; set @minutes_remaining = NULL; SELECT t.task_id , times.day_working_hours , times.username , times.task_type , times.date , times.duration_hours , times.task_start_timestamp , times.task_end_timestamp , times.day_name , times.remaining_minutes , times.days_work , times.holiday_start_timestamp , times.holiday_end_timestamp FROM tasks t LEFT JOIN ( SELECT date , t.task_id , u.username , tt.task_type , tt.duration_hours , ot.start_timestamp as task_start_timestamp , @day_working_hours := (timestampdiff(MINUTE, och.start_time, och.finish_time) - (timestampdiff(MINUTE, och.start_time, och.finish_time) DIV 270 ) * 30) / 60 as day_working_hours , DAYOFWEEK(date) as day_name , oal.start_timestamp as holiday_start_timestamp , oal.end_timestamp as holiday_end_timestamp , @days_work := IF (@day_working_hours > @minutes_remaining, IF (@days_work IS NULL, 1, @days_work + 1), NULL) as days_work , @minutes_remaining := IF (@minutes_remaining IS NULL, ((tt.duration_hours * 60) - (@day_working_hours * 60)), @minutes_remaining - (@day_working_hours * 60)) as remaining_minutes , CONCAT(IF ((@day_working_hours * 60)> @minutes_remaining , DATE_ADD(date, INTERVAL @days_work DAY), ''), ' ', IF ((@day_working_hours * 60) > @minutes_remaining, DATE_ADD(och.start_time, INTERVAL @remaining_minutes MINUTE), '')) as task_end_timestamp FROM dates d LEFT JOIN operative_contracted_hours och ON weekday(date) = och.week_day JOIN operatives_tasks ot USING (user_id) JOIN tasks t USING (task_id) JOIN task_types tt USING (task_type_id) JOIN users u USING (user_id) LEFT JOIN operatives_annual_leave oal ON oal.start_timestamp < CONCAT(date, ' ', och.finish_time) AND oal.end_timestamp > CONCAT(date, ' ', och.start_time) AND och.user_id = oal.user_id ) as times ON times.task_id = t.task_id ORDER BY task_id, date; the results are here: https://i.ibb.co/Zzn3C9z/Untitled4.png what im trying to do is caluclate the number of days work it is for the task and the minutes remaining and add them to task start date, but the problem lies with days_work and hours_remaining not corresponding with the correct date and is all muddled up. i feel if i can get the @days_work and @remaining_minutes in the right dates i can get a task end timestamp working for all different task durations thank you for your help once again barand
  11. hi Barand, i've digested what it is you've done, but realised that the query would work of only that scenario, so ive had a little play for the last hour and this is what i've came up with SELECT ot.task_id , tt.duration_hours , ot.start_timestamp , @start_weekday := weekday(ot.start_timestamp) , @days_work := IF (@start_weekday = 0 AND monday.shift_hours > tt.duration_hours, 0, IF (@start_weekday = 1 AND monday.shift_hours + tuesday.shift_hours > tt.duration_hours, 1, IF (@start_weekday = 2 AND monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours > tt.duration_hours, 2, IF (@start_weekday = 3 AND monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours > tt.duration_hours, 3, IF (@start_weekday = 4 AND monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours + friday.shift_hours > tt.duration_hours, 4, IF (@start_weekday = 5 AND monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours + friday.shift_hours + saturday.shift_hours > tt.duration_hours, 5, IF (@start_weekday = 6 AND monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours + friday.shift_hours + saturday.shift_hours + sunday.shift_hours > tt.duration_hours, 6, 'who knows'))))))) as `days_work` , @hours_remaining := IF (@start_weekday = 0 AND monday.shift_hours > tt.duration_hours, tt.duration_hours, IF (@start_weekday = 1 AND monday.shift_hours + tuesday.shift_hours > tt.duration_hours, tt.duration_hours - monday.shift_hours, IF (@start_weekday = 2 AND monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours > tt.duration_hours, tt.duration_hours - (monday.shift_hours + tuesday.shift_hours), IF (@start_weekday = 3 AND monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours > tt.duration_hours, tt.duration_hours - (monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours), IF (@start_weekday = 4 AND monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours + friday.shift_hours > tt.duration_hours, tt.duration_hours - (monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours), IF (@start_weekday = 5 AND monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours + friday.shift_hours + saturday.shift_hours > tt.duration_hours, tt.duration_hours - (monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours + friday.shift_hours), IF (@start_weekday = 6 AND monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours + friday.shift_hours + saturday.shift_hours + sunday.shift_hours > tt.duration_hours, tt.duration_hours - (monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours + friday.shift_hours + saturday.shift_hours), tt.duration_hours - (monday.shift_hours + tuesday.shift_hours + wednesday.shift_hours + thursday.shift_hours + friday.shift_hours + saturday.shift_hours + sunday.shift_hours)))))))) as `hours_remaining` , ot.start_timestamp + INTERVAL (@days_work) DAY + INTERVAL (60 * @hours_remaining) MINUTE as `end_timestamp` FROM tasks t INNER JOIN operatives_tasks ot ON ot.task_id = t.task_id INNER JOIN task_types tt ON tt.task_type_id = t.task_type_id INNER JOIN users u on u.user_id = ot.user_id LEFT JOIN (SELECT user_id , @contacted_hours_monday := TIMEDIFF(finish_time, start_time) AS `contracted_hours` , @hours := CONCAT('2020-01-01 ', @contacted_hours) , @break_duration := FLOOR(CAST(TIME_TO_SEC(@hours) / (60 * 60) AS DECIMAL(10, 1)) / 4.5) * 30 , CAST(TIME_TO_SEC(SUBSTRING( DATE_SUB(@hours, INTERVAL @break_duration MINUTE), 12, 19)) / (60 * 60) AS DECIMAL(10, 1)) AS `shift_hours` FROM operative_contracted_hours WHERE week_day = 0 ) monday ON monday.user_id = u.user_id LEFT JOIN (SELECT user_id , @contacted_hours_monday := TIMEDIFF(finish_time, start_time) AS `contracted_hours` , @hours := CONCAT('2020-01-01 ', @contacted_hours) , @break_duration := FLOOR(CAST(TIME_TO_SEC(@hours) / (60 * 60) AS DECIMAL(10, 1)) / 4.5) * 30 , CAST(TIME_TO_SEC(SUBSTRING( DATE_SUB(@hours, INTERVAL @break_duration MINUTE), 12, 19)) / (60 * 60) AS DECIMAL(10, 1)) AS `shift_hours` FROM operative_contracted_hours WHERE week_day = 1 ) tuesday ON tuesday.user_id = u.user_id LEFT JOIN (SELECT user_id , @contacted_hours_monday := TIMEDIFF(finish_time, start_time) AS `contracted_hours` , @hours := CONCAT('2020-01-01 ', @contacted_hours) , @break_duration := FLOOR(CAST(TIME_TO_SEC(@hours) / (60 * 60) AS DECIMAL(10, 1)) / 4.5) * 30 , CAST(TIME_TO_SEC(SUBSTRING( DATE_SUB(@hours, INTERVAL @break_duration MINUTE), 12, 19)) / (60 * 60) AS DECIMAL(10, 1)) AS `shift_hours` FROM operative_contracted_hours WHERE week_day = 2 ) wednesday ON wednesday.user_id = u.user_id LEFT JOIN (SELECT user_id , @contacted_hours_monday := TIMEDIFF(finish_time, start_time) AS `contracted_hours` , @hours := CONCAT('2020-01-01 ', @contacted_hours) , @break_duration := FLOOR(CAST(TIME_TO_SEC(@hours) / (60 * 60) AS DECIMAL(10, 1)) / 4.5) * 30 , CAST(TIME_TO_SEC(SUBSTRING( DATE_SUB(@hours, INTERVAL @break_duration MINUTE), 12, 19)) / (60 * 60) AS DECIMAL(10, 1)) AS `shift_hours` FROM operative_contracted_hours WHERE week_day = 3 ) thursday ON thursday.user_id = u.user_id LEFT JOIN (SELECT user_id , @contacted_hours_monday := TIMEDIFF(finish_time, start_time) AS `contracted_hours` , @hours := CONCAT('2020-01-01 ', @contacted_hours) , @break_duration := FLOOR(CAST(TIME_TO_SEC(@hours) / (60 * 60) AS DECIMAL(10, 1)) / 4.5) * 30 , CAST(TIME_TO_SEC(SUBSTRING( DATE_SUB(@hours, INTERVAL @break_duration MINUTE), 12, 19)) / (60 * 60) AS DECIMAL(10, 1)) AS `shift_hours` FROM operative_contracted_hours WHERE week_day = 4 ) friday ON friday.user_id = u.user_id LEFT JOIN (SELECT user_id , @contacted_hours_monday := TIMEDIFF(finish_time, start_time) AS `contracted_hours` , @hours := CONCAT('2020-01-01 ', @contacted_hours) , @break_duration := FLOOR(CAST(TIME_TO_SEC(@hours) / (60 * 60) AS DECIMAL(10, 1)) / 4.5) * 30 , CAST(TIME_TO_SEC(SUBSTRING( DATE_SUB(@hours, INTERVAL @break_duration MINUTE), 12, 19)) / (60 * 60) AS DECIMAL(10, 1)) AS `shift_hours` FROM operative_contracted_hours WHERE week_day = 5 ) saturday ON saturday.user_id = u.user_id LEFT JOIN (SELECT user_id , @contacted_hours_monday := TIMEDIFF(finish_time, start_time) AS `contracted_hours` , @hours := CONCAT('2020-01-01 ', @contacted_hours) , @break_duration := FLOOR(CAST(TIME_TO_SEC(@hours) / (60 * 60) AS DECIMAL(10, 1)) / 4.5) * 30 , CAST(TIME_TO_SEC(SUBSTRING( DATE_SUB(@hours, INTERVAL @break_duration MINUTE), 12, 19)) / (60 * 60) AS DECIMAL(10, 1)) AS `shift_hours` FROM operative_contracted_hours WHERE week_day = 6 ) sunday ON sunday.user_id = u.user_id INNER JOIN operatives_annual_leave oal ON oal.user_id = u.user_id WHERE u.user_id = 1 https://i.ibb.co/GJYG2Vq/Untitled3.png so i've worked out how many days work and hours remaining and added it all to the start timestamp, but the big problem is, what if the task takes more than 7 days, i could go forever with these if statements. if its not possible with mysql then i could work it all out via php what are your thoughts please? thank you
  12. ooook so your a mysql geneious 😄 jeeez, to be honest im gonna have to look at the manual with what your written here, but i just ran the query and the result is beautiful i'll get onto implimenting annual holidays and bank holidays tomorrow, i'll let you know what it looks like, when its done. thank you very much barand 😁😁😁
  13. no, a user can have different work patterns, for instance a user could work monday, wednesday, friday from 8-1 each day. day 1 is correct in your scenario, but day 2 is a new day therefor if the user/operative is working from 8-4 again he/she will only be entitled to a break for 30 mins at 12.30, but break times can change depending on the users contacted hours. ie (8-12 no break) but 30 mins every 4.5 hrs is rule of thumb (daily) if working from, 08:00- 19:00, 9 hrs work the user would be entitled to 2 breaks, break at 12.00 - 12:30 then break at 16:30 - 17:00 and home for 19:00 it probably make more sense to have a break on the 4th hour if entitled to breaks. would it be best for me to create a lof of if statements in the query? how is the best way for me to get the end results (task esistmated completion timestamp)? thank you again barand
  14. @contacted_hours := TIMEDIFF(och.finish_time, och.start_time) AS `contracted_hours`, @hours := CONCAT('2020-01-01 ', @contacted_hours), @breaks := FLOOR(CAST(TIME_TO_SEC(@hours) / (60 * 60) AS DECIMAL(10, 1)) / 4.5) AS `breaks`, @break_duration := @breaks * 30 AS `break_duration`, CAST(TIME_TO_SEC(SUBSTRING( DATE_SUB(@hours, INTERVAL @break_duration MINUTE), 12, 19)) / (60 * 60) AS DECIMAL(10, 1)) AS `shift_hours`, IF (@breaks = 1, CONCAT("{[", DATE_ADD(och.start_time, INTERVAL 270 MINUTE), ":", DATE_ADD(och.start_time, INTERVAL 300 MINUTE),"]}"), IF (@breakss = 2, CONCAT("{[", DATE_ADD(och.start_time, INTERVAL 270 MINUTE), ":", DATE_ADD(och.start_time, INTERVAL 300 MINUTE), "] , [", DATE_ADD(och.start_time, INTERVAL 540 MINUTE), ":", DATE_ADD(och.start_time, INTERVAL 570 MINUTE), "]}"), NULL)) AS `break_times`, i've also added break times which will display as {[12:30:00:13:00:00]}
  15. nice to hear from you again barand , the caluclations are based on 4 variables firsly though ive noticed that i missed @contacted_hours := TIMEDIFF(och.finish_time, och.start_time) AS `contracted_hours`, from my sql SELECT u.username, tt.task_type, tt.duration_hours `task_duration_hours`, ot.start_timestamp AS `task_start_timestamp`, @task_week_day_start := WEEKDAY(ot.start_timestamp) AS `task_week_day_start`, och.shift_hours, och.week_day, och.start_time AS `operatives_start_time`, och.finish_time AS `operatives_finish_time`, annual_leave_start_timestamp, annual_leave_end_timestamp FROM tasks t LEFT JOIN operatives_tasks ot ON ot.task_id = t.task_id LEFT JOIN task_types tt ON tt.task_type_id = t.task_type_id LEFT JOIN users u on u.user_id = ot.user_id LEFT JOIN ( SELECT och.user_id, och.week_day, och.start_time, och.finish_time, @contacted_hours := TIMEDIFF(och.finish_time, och.start_time) AS `contracted_hours`, @hours := CONCAT('2020-01-01 ', @contacted_hours), @break_duration := FLOOR(CAST(TIME_TO_SEC(@hours) / (60 * 60) AS DECIMAL(10, 1)) / 4.5) * 30 AS `break_duration`, CAST(TIME_TO_SEC(SUBSTRING( DATE_SUB(@hours, INTERVAL @break_duration MINUTE), 12, 19)) / (60 * 60) AS DECIMAL(10, 1)) AS `shift_hours`, oal.start_timestamp AS `annual_leave_start_timestamp`, oal.end_timestamp AS `annual_leave_end_timestamp` FROM operative_contracted_hours och INNER JOIN operatives_annual_leave oal ON oal.user_id = och.user_id ) AS och ON och.user_id = u.user_id WHERE u.user_id = 1 the 4 variables are: @contacted_hours := TIMEDIFF(och.finish_time, och.start_time) AS `contracted_hours`, @hours := CONCAT('2020-01-01 ', @contacted_hours), @break_duration := FLOOR(CAST(TIME_TO_SEC(@hours) / (60 * 60) AS DECIMAL(10, 1)) / 4.5) * 30 AS `break_duration`, CAST(TIME_TO_SEC(SUBSTRING( DATE_SUB(@hours, INTERVAL @break_duration MINUTE), 12, 19)) / (60 * 60) AS DECIMAL(10, 1)) AS `shift_hours`, @contracted_hours for that weekday @hours is just a created timestamp so i can workout the breaks @break_duration is putting the timestamp into seconds and converting into a decimal (ie. 08:00 - 16:00 would be 8.0) then dividing by 4.5 hrs, as a employee is entitled to 30 mins break for every 4.5 hours work. shift_hours then just taking away the 30 min break in this case returning 7.5 (hours) in this particual query the task is 9 hours long, but i added a 2 hour annual leave for the next day, in operatives_annual_leave table. so the operative works 7.5 each day in this case, and the task duration is 9 hours (1.5 hrs remaining), meaning the task would have to extend over 2 days, including the 2 hour annual leave next day, the operative should be finished 2020-06-24 11:30:00 i think im on the right track, but struggling to put it all together thanks you for your reply barand
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.