Ejemplo n.º 1
0
            $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'];
Ejemplo n.º 2
0
             $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) {
Ejemplo n.º 3
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
                     *
                     */
Ejemplo n.º 4
0
 $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&amp;action=topic&amp;t={$temp['id']}&amp;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>";
         }
     }
 }