Example #1
0
<?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>
Example #2
0
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 = "&nbsp;&nbsp;" 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>';
}