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);
