<?php echo '<div style="border: 1px solid ' . $profile_colors['border'] . '; background: ' . $profile_colors['background'] . '; padding: 3px;">' . "\n"; require PATHS_INCLUDE . 'future-functions.php'; $query = 'SELECT * FROM traffa_future WHERE userid = ' . $userid . ' ORDER BY future_date'; $result = mysql_query($query) or die(report_sql_error($query)); while ($data = mysql_fetch_assoc($result)) { $img = $data['status'] == 'X' ? IMAGE_URL . 'images/icons/checkbox1_checked.png' : IMAGE_URL . 'images/icons/checkbox1_unchecked.png'; echo '<img src="' . $img . '" width="12" height="12" />' . "\n"; echo $data['future_name']; echo '<span style="line-height: 20px;">' . profile_future_draw_text($data['date_text'], $data['future_date'], $data['future_enddate']) . '</span>'; echo '<br />'; } ?> </div>
function profile_future_change_form() { if (isset($_GET['action']) && $_GET['action'] == 'remove') { $query = 'DELETE FROM traffa_future WHERE id = ' . $_GET['futureid']; mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__)); } if (isset($_POST['change_submit'])) { $query = 'UPDATE traffa_future SET status = " " WHERE userid = ' . $_SESSION['userid']; mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__)); foreach ($_POST as $id => $status) { $id = substr($id, 2); if (is_numeric($id)) { if ($status = 'yes') { $status = 'X'; } $query = 'UPDATE traffa_future SET status = "' . $status . '" WHERE id = ' . $id; mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__)); } } } $query = 'SELECT * FROM traffa_future WHERE userid = ' . $_SESSION['userid'] . ' ORDER BY future_date'; $result = mysql_query($query) or die(report_sql_error($query)); echo '<h2>Din framtid</h2>'; echo '<form action="' . $_SERVER['PHP_SELF'] . '?id=' . $_GET['id'] . '" method="post">'; while ($data = mysql_fetch_assoc($result)) { $checked = ''; if ($data['status'] == 'X') { $checked = 'checked'; } echo '<input type="checkbox" value="yes" name="id' . $data['id'] . '" ' . $checked . '/> '; echo $data['future_name']; echo profile_future_draw_text($data['date_text'], $data['future_date'], $data['future_enddate']) . ' '; echo ' <a href="' . $_SERVER['PHP_SELF'] . '?id=' . $_GET['id'] . '&action=remove&futureid=' . $data['id'] . '">[Ta bort]</a><br />'; } if (mysql_num_rows($result) > 0) { echo '<br /><input type="submit" name="change_submit" value="Spara de nya valen" class="button" />'; } echo '</form>'; }