\nRecordId\n<\/p>\n
\nAuto Increment
\nint (unisigned)
\nPrimary Key\n<\/p>\n
\nSettingName\n<\/p>\n
\nvarchar\n<\/p>\n
\nSettingValue\n<\/p>\n
\ntext\n<\/p>\n
\r\n\r\n\t\/\/----- CHECK IF UPLOADS ARE ENABLED CURRENTLY -----\r\n\t$QueryString = @mysql_query("SELECT SettingValue FROM tblApiSettings WHERE SettingName = 'ArchiveDataUploadsEnabled'");\r\n\t$result = @mysql_fetch_array($QueryString);\r\n\t$UploadsEnabled = $result['SettingValue'];\r\n\t$UploadsEnabled = filter_var($UploadsEnabled, FILTER_VALIDATE_BOOLEAN);\r\n\tif (!$UploadsEnabled)\r\n\t\tdie("Quitting - Uploads import is currently disabled");\r\n<\/code><\/pre>\n\nIs A Background Task Already Being Done (With timeout check)
\n<\/h4>\n\r\n\r\n\t\/\/----- CHECK IF THIS TASK IS ALREADY RUNNING CURRENTLY -----\r\n\t\/\/(Started from an earlier CRON call)\r\n\t$QueryString = @mysql_query("SELECT SettingValue FROM tblApiSettings WHERE SettingName = 'ArchiveDataUploadsImportActive'");\r\n\t$result = @mysql_fetch_array($QueryString);\r\n\t$ArchiveDataUploadsImportActive = $result['SettingValue'];\r\n\t\r\n\tif ($ArchiveDataUploadsImportActive != "0")\r\n\t{\r\n\t\t$end = strtotime(date("Y-m-d H:i:s"));\t\t\/\/Now\r\n\t\t$start = strtotime($ArchiveDataUploadsImportActive);\r\n\t\tif ($start <= $end)\r\n\t\t{\r\n\t\t\t$no_of_minutes = ceil(abs($end - $start) \/ 60); \/\/ceil rounds the amount of days up to the next full day. Use floor if you want to get the amount of full days between the two dates.\r\n\t\t\tif ($no_of_minutes < 120)\t\t\t\/\/<<<Timeout, if longer than this many minutes has passed ignore the setting as old task must have died for some reason without clearing this\r\n\t\t\t{\r\n\t\t\t\t\/\/----- UPLOADS IMPORT IS ALREADY ACTIVE -----\r\n\t\t\t\tdie("Quitting - Uploads import is already active (started: " .$ArchiveDataUploadsImportActive . ")");\r\n\t\t\t}\r\n\t\t}\r\n\t}\r\n<\/code><\/pre>\n\r\n\r\n\t\/\/----- FLAG THAT WE ARE ACTIVE CARRYING OUT IMPORT -----\r\n\t\/\/(Stop other cron calls also doing this until we quit. We use a timestamp to allow them to detect if something has gone wrong and too much time has passed)\r\n\t$TimeNow = date("Y-m-d H:i:s");\r\n\t$result = @mysql_query("UPDATE tblApiSettings SET\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tSettingValue = '$TimeNow'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE SettingName = 'ArchiveDataUploadsImportActive'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t");\r\n\r\n<\/code><\/pre>\n\r\n\r\n\t\/\/----- FLAG THAT IMPORT IS COMPLETE -----\r\n\t\/\/(Remove block on other cron calls doing this task)\r\n\t$TimeNow = date("Y-m-d H:i:s");\r\n\t$result = @mysql_query("UPDATE tblApiSettings SET\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tSettingValue = '0'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE SettingName = 'ArchiveDataUploadsImportActive'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t");\r\n\r\n<\/code><\/pre>\n\n \n<\/p>\n
\n <\/p>\n","protected":false},"excerpt":{"rendered":"
Table Design RecordId Auto Increment int (unisigned) Primary Key SettingName varchar SettingValue text Is A Setting Enabled? \/\/—– CHECK IF UPLOADS ARE ENABLED CURRENTLY —– $QueryString = @mysql_query("SELECT SettingValue FROM tblApiSettings WHERE SettingName = 'ArchiveDataUploadsEnabled'"); $result = @mysql_fetch_array($QueryString); $UploadsEnabled = $result[‘SettingValue’]; $UploadsEnabled = filter_var($UploadsEnabled, FILTER_VALIDATE_BOOLEAN); if (!$UploadsEnabled) die("Quitting – Uploads import is currently disabled"); Is […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[148],"tags":[],"class_list":["post-1767","post","type-post","status-publish","format-standard","hentry","category-examples-mysql"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/comments?post=1767"}],"version-history":[{"count":2,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1767\/revisions"}],"predecessor-version":[{"id":1769,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1767\/revisions\/1769"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/media?parent=1767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/categories?post=1767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/tags?post=1767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}