beginTransaction(); $sth = $dbh->prepare($statement240); if ($sth->execute(array($_SESSION['MemberID']))) { $stb = $dbh->prepare($statement242); while ($row = $sth->fetch(PDO::FETCH_ASSOC)) { foreach ($_POST as $post => $value) { //print("post $post and value $value are ${row['id']}"); if ((int) $post === (int) $row['id'] && (int) $value === (int) $row['id']) { //print ("activating..."); $stb->execute(array($_SESSION['MemberID'], $row['id'])); } } } } $dbh->commit(); } catch (Exception $e) { print ("Failed to activate tools " . $e->getMessage()); $dbh->rollBack(); } } else if (isset($_POST['Deactivate'])) { try { $dbh = returnDatabaseHandel(); $dbh->beginTransaction(); $sth = $dbh->prepare($statement241); if ($sth->execute(array($_SESSION['MemberID']))) { $stb = $dbh->prepare($statement243); while ($row = $sth->fetch(PDO::FETCH_ASSOC)) { foreach ($_POST as $post => $value) { if ((int) $post === (int) $row['id'] && (int) $value === (int) $row['id']) { $stb->execute(array($row['id'])); } } } } $dbh->commit(); } catch (Exception $e) { print ("Failed to deactivate tools " . $e->getMessage()); $dbh->rollBack(); } } else if (isset($_POST['DeactivateAll'])) { try { $dbh = returnDatabaseHandel(); $dbh->beginTransaction(); $sth = $dbh->prepare($statement244); if ($sth->execute(array($_SESSION['MemberID']))) { } $dbh->commit(); } catch (Exception $e) { print ("Failed to deactivate all authorized tools " . $e->getMessage()); $dbh->rollBack(); } } } $root = $doc->appendChild($root); $root->appendChild(generateHead($doc)); $body = $doc->createElement('body'); $root->appendChild($body); $body->appendChild(generateMastHead($doc, $baseDir)); //$body->appendChild($doc->createElement('hr')); $_SESSION['subNav'] = NULL; $body->appendChild(generateSelectedMenuBar($doc)); $h3 = $doc->createElement('h3'); $h3->appendChild($doc->createTextNode("Tool Activation")); $body->appendChild($h3); $formDiv = createDiv($doc); $form = createForm($doc, "toolActivation.php"); $form->appendChild(populateToolActivationTable($doc, $_SESSION['MemberID'])); $input = createSubmitInput($doc, 'Activate', $text0015); /* $input = $doc->createElement('input'); $input->setAttribute('type', 'submit'); $input->setAttribute('name', 'Activate'); $input->setAttribute('value', 'Activate');*/ $form->appendChild($input); $input = createSubmitInput($doc, 'Deactivate', $text0016); /* $input = $doc->createElement('input'); $input->setAttribute('type', 'submit'); $input->setAttribute('name', 'Deactivate'); $input->setAttribute('value', 'Deactivate'); */ $form->appendChild($input); $input = createSubmitInput($doc, 'DeactiavateAll', $text0017); /* $input = $doc->createElement('input'); $input->setAttribute('type', 'submit'); $input->setAttribute('name', 'DeactivateAll'); $input->setAttribute('value', 'Deactivate All'); */ $form->appendChild($input); $formDiv->appendChild($form); $body->appendChild($formDiv); /* * Insert content here. */ $body->appendChild(generateFooter($doc)); if ($prettyPretty) $doc->formatOutput = true; outputDoc($doc); } else generateIndexRedirect(); ?>