After all,computers crash,people die,relationships fall apart. The best we can do is breathe and reboot.
-Sarah Jessica Parker
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 | <?php include (dirname(__FILE__)."/jpgraph/jpgraph.php"); include (dirname(__FILE__)."/jpgraph/jpgraph_line.php"); include (dirname(__FILE__)."/jpgraph/jpgraph_scatter.php"); // get our db settings without loading all of wordpress every save $html = implode('', file("../../../wp-config.php")); $html = str_replace ("require_once", "// ", $html); $html = str_replace ("<?php", "", $html); $html = str_replace ("?>", "", $html); eval($html); mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); mysql_select_db(DB_NAME); $weeks = $_GET["weeks"]; $start_date = $_GET["start_date"]; $end_date = $_GET["end_date"]; $goal = $_GET["goal"]; $user_id = $_GET["user"]; $maint_mode = $_GET["maint_mode"]; if ($weeks) { $query = "select date,weight,trend from ".$table_prefix."hackdiet_weightlog where wp_id = $user_id and date >\"".date("Y-m-d", strtotime("$weeks weeks ago"))."\" order by date asc"; } else if ($start_date and $end_date) { $query = "select date,weight,trend from ".$table_prefix."hackdiet_weightlog where wp_id = $user_id and date >=\"$start_date\" and date <= \"$end_date\" order by date asc"; } result = mysql_query($query); if (mysql_num_rows($result)) { if (mysql_num_rows($result) == 1) { // only one day,gotta finagle the display $row = mysql_fetch_assoc($result); // fake day before $weight_data[] = 0; if ($goal > 0) { $goal_data[] = $goal; } $x_data[] = date("n/j", strtotime("yesterday", strtotime($row["date"]))); // data $weight_data[] = $row["weight"]; if ($goal > 0) { $goal_data[] = $goal; } $x_data[] = date("n/j", strtotime($row["date"])); // fake day after $weight_data[] = 0; if ($goal > 0) { $goal_data[] = $goal; } $x_data[] = date("n/j", strtotime("tomorrow", strtotime($row["date"]))); } else { $num_rows = mysql_num_rows($result); if ($num_rows <= 7 * 2) { // 0-2 weeks $ticks = "daily"; } else if ($num_rows <= 31 * 4) { // 2 weeks - 4 months $ticks = "weekly"; } else { // 4 months + $ticks = "monthly"; } $count = 1; while ($row = mysql_fetch_assoc($result)) { $weight_data[] = $row["weight"]; $trend_data[] = $row["trend"]; if ($goal > 0) { $goal_data[] = $goal; } switch ($ticks) { case "weekly": if ($count == 1) { $x_data[] = date("n/j", strtotime($row["date"])); } else { $x_data[] = ""; if ($count == 7) { $count = 0; } } break; case "monthly": if (date("j", strtotime($row["date"])) == "1") { $x_data[] = date("n/j", strtotime($row["date"])); } else { $x_data[] = ""; } break; case "daily": default: $x_data[] = date("n/j", strtotime($row["date"])); break; } $count++; } } ... <snip> |
If you enjoyed this post,make sure you subscribe to my RSS feed!



[...] Reboot [...]