function updateTable($inTableNode) { $myAttrList = $inTableNode->attributes(); $myTableName = $myAttrList["name"]; $myCmd = $myAttrList["command"]; echo "\n {$myCmd} table {$myTableName}"; $myRows = $inTableNode->xpath('Rows/Row'); $myRowCount = count($myRows); if ($myRowCount > 0) { foreach ($myRows as $myRow) { if ($myCmd == "Delete") { deleteRow($myTableName, $inTableNode, $myRow); } else { if (isRowFound($myTableName, $inTableNode, $myRow)) { updateRow($myTableName, $inTableNode, $myRow); } else { insertRow($myTableName, $inTableNode, $myRow); } } } } echo "\n------------------------------\n"; }
if (isset($_REQUEST['oper'])) { try { switch ($_REQUEST['oper']) { case 'del': _log(__FILE__ . " - line " . __LINE__ . ": Request for deletion: " . print_r($_REQUEST, TRUE)); // explode, then implode adding quotes $deleteUUID = explode(",", utf8_decode($_REQUEST['id'])); $deleteParameters = '"' . implode('","', $deleteUUID) . '"'; if ($db->query("DELETE FROM Obstacles WHERE UUID IN (" . $deleteParameters . ")")) { _log(__FILE__ . " - line " . __LINE__ . ": Obstacle(s) deleted: " . $deleteParameters); } else { _log(__FILE__ . " - line " . __LINE__ . ": Error deleting position(s) \"" . $deleteParameters . "\"! " . $db->lastErrorMsg()); exit(0); } break; case 'edit': updateRow(); break; case 'add': addRow(); // unsupported break; } } catch (PDOException $e) { _log(__FILE__ . " - line " . __LINE__ . ": Some query failed: " . PDO_PREFIX . SQLITE_DB_FILENAME . ": " . $e->getMessage()); exit(0); // flag jQueryGrid that this failed } } else { updateRow(); }
{ $sql = "UPDATE `patients` SET currentState='" . $cur_state . "', stateID = " . $cur_stateID . " WHERE entryID = " . $entryID; $stmt = $db->prepare($sql); if (!$stmt->execute()) { echo ' ' . $entryID . '----' . $cur_state . ' ERROR<br>'; exit; } echo $sql . '<br>'; } $total_state_transitions = 0; $cur_state = ""; $cur_stateID = ""; for ($entryID = 1; $entryID <= 26486; $entryID++) { $sql = "SELECT * FROM `patients` where entryID = " . $entryID; $stmt = $db->prepare($sql); if ($stmt->execute()) { $obj = $stmt->fetch(PDO::FETCH_OBJ); if ($obj->STATE != "") { echo 'state change at entryID = ' . $entryID . '<br>'; $cur_state = $obj->STATE; $cur_stateID = $obj->stateID; updateRow($db, $entryID, $cur_state, $cur_stateID); $total_state_transitions++; } else { if ($obj->STATE == "") { updateRow($db, $entryID, $cur_state, $cur_stateID); } } } } echo '<br><br>Updates done. Total State Transitions were <br>' . $total_state_transitions;
?> - DB Maintenance</title> <link rel="icon" type="image/png" href="favicon-32x32.png" sizes="32x32" /> <link rel="icon" type="image/png" href="favicon-16x16.png" sizes="16x16" /> </head> <body bgcolor="666666"> <!-- Handle POST action / Display result or error --> <?php if ($_SERVER['REQUEST_METHOD'] == 'POST') { echo "<table cellpadding=2 width='100%' bgcolor='FFFFFF'><tr><td>\n"; echo "<font face='arial' color='red'>\n"; if ($_POST["insert"] == 'Submit') { echo insertRow(addslashes($_POST["FortuneText"])); } elseif ($_POST["update"] == 'Submit') { echo updateRow($_POST["id"], addslashes($_POST["FortuneText"])); } elseif ($_POST["delete"] == 'Delete') { echo deleteRow($_POST["id"]); } echo "</font>\n</td></tr></table>"; } ?> <font face="arial" color="FFFFFF"> <h1>Devops Fortune Cookie - Database Maintenance </h1> </font> <font face="arial" color="FFFFFF"> <h2>Current Fortune List</h2> </font>
$address_group_id = filter_input(INPUT_POST, 'address_group_id'); $fullname = filter_input(INPUT_POST, 'fullname'); $email = filter_input(INPUT_POST, 'email'); $address = filter_input(INPUT_POST, 'address'); $website = filter_input(INPUT_POST, 'website'); $birthday = filter_input(INPUT_POST, 'birthday'); $phone = filter_input(INPUT_POST, 'phone'); if ($birthday === "") { $birthday = $results['birthday']; } try { $image = uploadImage('upfile'); } catch (RuntimeException $ex) { $image = filter_input(INPUT_POST, 'oldimage'); } $isUpdated = updateRow($id, $address_group_id, $fullname, $email, $address, $phone, $website, $birthday, $image); if ($isUpdated) { header("Refresh:0; url=update.html.php?id=" . $id); } else { echo "Address Not Updated"; } } ?> <form method="post" action="#" enctype="multipart/form-data"> <table class="table table-striped"> <tr> <td> Group: <select name="address_group_id"> <option value="1" <?php if ($results['address_group_id'] === 1) {
$cover = getArtName($path); // New art copied, upload to web server if ($cover && copyArt($cover)) { uploadArt(basename($cover)); } else { echo "No album art found in {$path}.\n"; } } elseif (isset($row['art'])) { $cover = $row['art']; } // Add db columns $parameters['art'] = basename($cover); $parameters['listeners'] = $listenerString; // DB record exists, overwrite if ($row) { updateRow($parameters); } else { insertRow($parameters); } // Save nowplaying info $row = $parameters; } else { if ($firstPass) { echo "Song unchanged from previous run. Updating playback only.\n"; } updatePlayback($parameters['playback_time'], $parameters['paused'], $listenerString); } } else { // Song was playing on last update if (isset($row['title']) && strlen($row['title']) || isset($row[0])) { deleteRow();
$largestCriticalStrike = 0; // int $totalDamageTaken = 7357; // int $physicalDamageTaken = 7357; // int $magicDamageTaken = 7357; // int $totalTimeSpentDead = 0; // int } } $total_games = $num_old_games + $gamesSuccessfullyParsed; debug('total_games: ' . $total_games); debug('oldest game: ' . $oldest_game); echo json_encode(array('total_games' => $total_games, 'parsed_games' => $gamesSuccessfullyParsed, 'oldest_game' => $oldest_game, 'name' => $summoner_array['name'])); } } $mysqli->close(); } $summoner_name_arr = array('summonerName' => $_POST['summonerName']); $summoner_data = getEloData($r_base_url, $r_region, $r_key, 'getSummonerByName', $summoner_name_arr, TRUE); // Make sure this summoner actually has data that returned $summoner_arr = json_decode($summoner_data, true); $keys = array_keys($summoner_arr); if (!$keys) { echo 'null'; return; } updateRow($r_region, $r_key, $r_base_url, $host, $username, $password, $database, $summoner_arr);