function tmp() { global $wpdb; $query = "SELECT * FROM wp_flmain"; $results = $wpdb->get_results($query, ARRAY_A); foreach ($results as $row) { $update = "UPDATE wp_flmain SET seconds=" . convert_time_seconds($row["duration"]) . " WHERE user_id=" . $row["user_id"] . " AND sbr_type='" . $row["sbr_type"] . "' AND plan_type='" . $row["plan_type"] . "' AND workout_date='" . $row["workout_date"] . "'"; $wpdb->query($update); } }
// for the element arrays defaults are as follows: // 0 = swim // 1 = bike // 2 = run // 3 = strength // // example: // $workout_date[0] = workoutdate for swim // $workout_date[1] = workoutdate for bike // $workout_date[2] = workoutdate for run // $workout_date[3] = workoutdate for strength // Get the data entered and validate it. $workout_date = array($_POST["s_workoutdate"], $_POST["b_workoutdate"], $_POST["r_workoutdate"], $_POST["s_workoutdate"]); $workout_time = array($_POST["s_workouttime"], $_POST["b_workouttime"], $_POST["r_workouttime"], $_POST["str_workouttime"]); $duration = array($_POST["s_duration"], $_POST["b_duration"], $_POST["r_duration"], $_POST["str_duration"]); $seconds = array(convert_time_seconds($duration[0]), convert_time_seconds($duration[1]), convert_time_seconds($duration[2]), convert_time_seconds($duration[3])); $distance = array($_POST["s_distance"], $_POST["b_distance"], $_POST["r_distance"], 0); $notes = array($_POST["s_notes"], $_POST["b_notes"], $_POST["r_notes"], $_POST["str_notes"]); $min_hr = array($_POST["s_min_hr"], $_POST["b_min_hr"], $_POST["r_min_hr"], 0); $avg_hr = array($_POST["s_avg_hr"], $_POST["b_avg_hr"], $_POST["r_avg_hr"], 0); $max_hr = array($_POST["s_max_hr"], $_POST["b_max_hr"], $_POST["r_max_hr"], 0); $avg_rpms = $_POST["avg_rpms"]; $calsburned = array($_POST["s_calsburned"], $_POST["b_calsburned"], $_POST["r_calsburned"], 0); $updatingswim = $_POST["updatingswim"]; $updatingbike = $_POST["updatingbike"]; $updatingrun = $_POST["updatingrun"]; $updatingblognotes = $_POST["updatingblognotes"]; $blog_notes = $_POST["blog_notes"]; for ($i = 0; $i < 3; $i++) { // Validate data. if (!validate_date($workout_date[$i])) {
<?php require 'fitlogfunc.php'; // Get time, distance and activity $strtime = strval($_GET['time']); $distance = floatval($_GET['distance']); $activity = strval($_GET['activity']); // convert the parsed time into seconds and put that into the $time variable $time = convert_time_seconds($strtime); switch ($activity) { case "swim": $pace = swimpace($time, $distance); break; case "bike": $pace = bikepace($time, $distance); break; case "run": $pace = runpace($time, $distance); break; default: $pace = 0; break; } echo $pace;
function saveday($userID, $connection, $xml_data) { $recordSaved = 0; $xmldoc = simplexml_load_string($xml_data); /* First we need the start time and duration of the workout and convert duration to seconds, and get the date of the workout. */ $startTime = $xmldoc->starttime; $duration = $xmldoc->duration; $seconds = convert_time_seconds($xmldoc->duration); $date = $xmldoc->date; $type = $xmldoc->type; $notes = $xmldoc->notes; $strId = $xmldoc->strid; /* Check to see if we are going to update a current record or creating a new one */ if (!strcmp($strId, "0")) { /* Now create the initial record in flstrength table */ $query = "INSERT INTO flstrength (exercises_id, plan_type, workout_date, time_of_day, duration, notes, seconds, user_id) VALUES ( NULL, '{$type}', '{$date}', '{$startTime}', '{$duration}', '{$notes}', {$seconds}, {$userID} )"; $result = @mysql_query($query, $connection); } else { /* Delete all the records in the flexercises table to be replaced with the current data set. */ $query = "DELETE FROM fl_exercises WHERE exercises_id={$strID} AND user_id={$userID}"; $result = @mysql_query($query, $connection); /* Update the current record then in the flstrength table */ $query = "UPDATE flstrength SET duration='" . $duration . "', seconds={$seconds}, notes='" . $notes . "' WHERE exercises_id={$strId} AND user_id={$userID}"; $result = @mysql_query($query, $connection); } if (!result) { $msg = "<saveDay>" . "<error>" . "Unable to create record in flstrength!" . "</error>" . "</saveDay>"; return $msg; } else { /* Get the id for the just created strength record. */ $query = "SELECT exercises_id FROM flstrength WHERE user_id={$userID} ORDER BY exercises_id DESC"; $result = @mysql_query($query, $connection); $row = mysql_fetch_array($result); $exercisesID = $row["exercises_id"]; foreach ($xmldoc->row as $row) { $catexercisePair = explode(":", $row->exercise_desc); $setNum = $row->set; if (strcmp($row->reps, "")) { $reps = $row->reps; } else { $reps = 0; } if (strcmp($row->weight, "")) { $weight = $row->weight; } else { $weight = 0; } // Fetch the exercise Id from the flexercise_type table. $query = "SELECT exercise_type_id FROM flexercise_type WHERE user_id={$userID} AND category='" . $catexercisePair[0] . "' AND exercise='" . $catexercisePair[1] . "'"; $result = @mysql_query($query, $connection); $rows = mysql_fetch_array($result); $exerciseID = $rows['exercise_type_id']; // Save the current row into the flexercises table $query = "INSERT INTO flexercises (exercises_id, exercise_type_id, set_number, reps, weight) VALUES ({$exercisesID}, {$exerciseID}, {$setNum}, {$reps}, {$weight})"; $result = @mysql_query($query, $connection); if (!result) { $error = true; } else { $error = false; $recordsSaved++; } } if (!$error) { $msg = "<saveTemplate>" . "<recordssaved>" . $recordsSaved . "</recordssaved>" . "</saveTemplate>"; } else { $msg = "<saveDay>" . "<error>" . "There was an error saving your workout" . "</error>" . "</saveDay>"; } } return $msg; }
function create_history($connection, $template) { $userid = getUserID($connection); $yearmoday = explode("-", $_SESSION["nav_month"]); // See if the users is trying to display a month other than the current month. if ($yearmoday != NULL) { $display_mo = new Date(); $display_mo->setDayMonthYear($yearmoday[2], $yearmoday[1], $yearmoday[0]); } else { $display_mo = new Date(); } $LastDay = $display_mo->getYear() . "-" . $display_mo->getMonth() . "-" . $display_mo->GetDaysInMonth(); $FirstDay = $display_mo->format("%Y") . "-" . $display_mo->format("%m") . "-" . "1"; $sbr_type = array("s", "b", "r"); $total_duration = array(0, 0, 0); $total_distance = array(0, 0, 0); $total_calories = array(0, 0, 0); $i = 0; while ($i < 3) { $query = "SELECT * FROM flmain WHERE user_id={$userid} AND workout_date>='" . $FirstDay . "' AND workout_date<='" . $LastDay . "' AND sbr_type='" . $sbr_type[$i] . "' ORDER BY workout_date ASC"; $result = @mysql_query($query, $connection); if (mysql_num_rows($result) > 0) { //set the correct template block selectActivityBlock($i, $template); //Get the first row of data and compare it to the day of the month to see if we have any //data to display on the current day. $row = mysql_fetch_array($result); //Out put each day of the displayed month. If we have data for that day //then put it into the grid also. $currentDay = new Date(); $nextMonth = new Date(); $currentDay->setDayMonthYear(1, $display_mo->getMonth(), $display_mo->getYear()); //Move the display_mo to the first day of the next month. $nextMonth->setDayMonthYear($display_mo->GetDaysInMonth(), $display_mo->getMonth(), $display_mo->getYear()); $nextMonth->addDays(1); while ($currentDay->before($nextMonth)) { // select the correct activity block. selectActivityBlock($i, $template); $template->setVariable("UPDATE", $currentDay->format("%Y-%m-%d")); $template->setVariable("DATE", $currentDay->format("%b %e, %Y")); //Check to see if the current day matches the current row, if so then output it. if (!strcmp($currentDay->format("%Y-%m-%d"), $row["workout_date"])) { outputCurrentDay($template, $row, $i); //Add up the duration, distance and calories $total_dur[$i] = $total_dur[$i] + convert_time_seconds($row["duration"]); $total_dist[$i] = $total_dist[$i] + $row["distance"]; $total_cal[$i] = $total_cal[$i] + $row["cals_burned"]; $row = mysql_fetch_array($result); } $template->parseCurrentBlock(); $currentDay->addDays(1); } outputTotals($template, $total_dur[$i], $total_dist[$i], $total_cal[$i], $i); } else { $currentDay = new Date(); $nextMonth = new Date(); $currentDay->setDayMonthYear(1, $display_mo->getMonth(), $display_mo->getYear()); //Move the display_mo to the first day of the next month. $nextMonth->setDayMonthYear($display_mo->GetDaysInMonth(), $display_mo->getMonth(), $display_mo->getYear()); $nextMonth->addDays(1); while ($currentDay->before($nextMonth)) { // set the correct activity block. selectActivityBlock($i, $template); $template->setVariable("UPDATE", $currentDay->format("%Y-%m-%d")); $template->setVariable("DATE", $currentDay->format("%b %e, %Y")); $template->parseCurrentBlock(); $currentDay->addDays(1); } } $i = $i + 1; } }