$lab_job_grp_date_start = $sql_first_lab_job_grp['lab_job_grp_date_start']; $lab_job_grp_date_complete = $sql_first_lab_job_grp['lab_job_grp_date_complete']; $lab_job_grp_status = $sql_first_lab_job_grp['lab_job_grp_status']; // Update Job Group Status to Provisioning $sql_update_table = 'lab_job_grp'; $sql_update_values = array( 'lab_job_grp_date_start' => date('Y-m-d H:i:s'), "lab_job_grp_status" => '3' ); $sql_update_exec = sql_update($sql_update_table,$sql_update_values,$lab_job_grp); sdk_log('info','JOB GROUP STARTED','[User '.$sdk_act_usr.'] Job Group #'.$lab_job_grp.' has started. Status set to Provisioning (3).','lab_job_grp',$lab_job_grp); // Select Job Actions $sql_list_lab_job_uid = sql_list($model_lab_job_uid,array('lab_job_uid.lab_job_grp'=>$lab_job_grp,'lab_job_uid_status'=>'2')); foreach($sql_list_lab_job_uid as $job_action) { // Verify that job status is still pending (2) if($job_action['lab_job_uid_status']=='2') { // Define Variables from SQL Query $lab_job_uid = $job_action['lab_job_uid']; $lab_vpd_uid = $job_action['lab_vpd_uid']; $lab_job_uid_action = $job_action['lab_job_uid_action']; $lab_job_uid_object = $job_action['lab_job_uid_object']; $lab_job_uid_date_start = $job_action['lab_job_uid_date_start']; $lab_job_uid_date_complete = $job_action['lab_job_uid_date_complete']; $lab_job_uid_status = $job_action['lab_job_uid_status'];
$kidid[] = $temp['id']; $numkids++; } } } $tpl->assign("member", $member); $tpl->assign("signupallowed", $signupallowed); $tpl->assign("numkids", $numkids); $tpl->assign("kidlist", $kidlist); if ($_POST['Submit'] == "Update") { $attendies = $_POST['attend']; $options = $_POST['options']; $userattend = $_POST['userattend']; $useroptions = $_POST['useroptions']; $kidid[] = $member['id']; $kididlist = sql_list($kidid, "uid", "OR"); $data->delete_query("attendies", "({$kididlist}) AND eid={$itemid}"); foreach ($attendies as $uid => $attend) { if ($attend == 1) { $useroption = safesql(serialize($options[$uid]), "text"); if ($data->num_rows($data->select_query("attendies", "WHERE uid={$uid} AND eid = {$itemid}")) == 0) { $data->insert_query("attendies", "'', {$uid}, {$itemid}, {$useroption}"); } else { $data->update_query("attendies", "options = {$useroption}", "uid={$uid} AND eid={$itemid}"); } } } if ($userattend == 1) { $uid = $member['id']; $useroption = safesql(serialize($useroptions), "text"); if ($data->num_rows($data->select_query("attendies", "WHERE uid={$uid} AND eid = {$itemid}")) == 0) {
'trx_rsv_grp' => $sql_trx_rsv_grp, 'lab_vnd_uid' => $sql_lab_vnd_uid, 'lab_vpd_grp' => $sql_lab_vpd_grp ); $sql_insert_exec = sql_insert($sql_insert_table,$sql_insert_values); $sql_lab_job_grp = $sql_insert_exec; // sdk_log('info','SQL INSERT','[labstack-agent:/app/controllers/scrub.php] Job Group #'.$sql_update_index.' created for cleaning up Pod #'.$sql_lab_vpd_grp.' for Reservation #'.$sql_trx_rsv_grp.'.',$sql_insert_table,$sql_insert_exec); /** * * Find Instances for this Reservation * */ $sql_list_trx_rsv_uid = sql_list($model_trx_rsv_uid,array('trx_rsv_uid.trx_rsv_grp'=>$sql_trx_rsv_grp)); // Loop through Database Rows foreach($sql_list_trx_rsv_uid as $reservation_instance) { // Define Variables for Database Row $sql_trx_rsv_uid = $reservation_instance['trx_rsv_uid']; $sql_lab_vpd_uid = $reservation_instance['lab_vpd_uid']; $sql_lab_img_grp_ref = $reservation_instance['lab_img_grp_ref']; /** * * Update Reservation Instances Status to Closed * */
$forums = array(); while ($temp3 = $data->fetch_array($sqls)) { $temp2 = $data->select_fetch_one_row("forumauths", "WHERE forum_id={$temp3['id']}"); $view_forum = unserialize($temp2['view_forum']); $read_topics = unserialize($temp2['read_topics']); $viewauth = 0; $readauth = 0; for ($i = 0; $i < count($usergroups); $i++) { $viewauth = $viewauth || $view_forum[-1]; $readauth = $readauth || $read_topics[-1]; } if ($viewauth && $readauth) { $forums[] = $temp3['id']; } } $forumlist = sql_list($forums, "forum", "OR"); if ($forumlist != "") { $sql = $data->select_query("forumtopics", "WHERE {$forumlist} ORDER BY lastdate DESC LIMIT {$config['numsidebox']}"); if ($data->num_rows($sql)) { while ($temp = $data->fetch_array($sql)) { $temp2 = $data->select_fetch_one_row("forumposts", "WHERE topic={$temp['id']} AND dateposted = {$temp['lastdate']}", "posttext"); $description = truncate(html_decode(strip_tags($temp2['posttext'])), 100); $temp['subject'] = $temp['subject']; $temp2 = $data->select_fetch_one_row("forumposts", "WHERE topic={$temp['id']} AND dateposted = {$temp['lastdate']}", "posttext"); $temp2 = $data->select_fetch_one_row("forumposts", "WHERE topic={$temp['id']} AND dateposted = {$temp['lastdate']}", "posttext"); $lastdate = strftime($format, $temp['lastdate']); $guid = "forum." . $temp['id']; echo "\n\t\t\t\t\t<item>\n\t\t\t\t\t<title>{$temp['subject']} [Forum Post]</title> \n\t\t\t\t\t<guid isPermaLink=\"false\">{$guid}</guid>\n\t\t\t\t\t<link>{$config['siteaddress']}index.php?page=forums&action=topic&t={$temp['id']}&late=1</link> \n\t\t\t\t\t<description>{$description}</description> \n\t\t\t\t\t<pubDate>{$lastdate}</pubDate> \n\t\t\t\t\t</item>"; } } }