Example #1
0
$comment = $comment_result["comment"];
$reply = $comment_result["reply"];
$reply_to = $comment_result["reply_to"];
$ip_address = $comment_result["ip_address"];
$is_approved = $comment_result["is_approved"];
$approval_reasoning = $comment_result["approval_reasoning"];
$is_sent = $comment_result["is_sent"];
$sent_to = $comment_result["sent_to"];
$likes = $comment_result["likes"];
$dislikes = $comment_result["dislikes"];
$reports = $comment_result["reports"];
$is_sticky = $comment_result["is_sticky"];
$is_locked = $comment_result["is_locked"];
$is_verified = $comment_result["is_verified"];
$time = cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($comment_result["dated"])));
$date = cmtx_format_date(date(CMTX_DATE_FORMAT, strtotime($comment_result["dated"])));
$page_id = $comment_result["page_id"];
$page_id_san = cmtx_sanitize($page_id);
$page_reference_query = cmtx_db_query("SELECT `reference` FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `id` = '{$page_id_san}'");
$page_reference_result = cmtx_db_fetch_assoc($page_reference_query);
$page_reference = $page_reference_result["reference"];
?>

<p />

<?php 
if (file_exists('../includes/language/' . cmtx_setting('language_frontend') . '/custom/countries.php')) {
    require '../includes/language/' . cmtx_setting('language_frontend') . '/custom/countries.php';
}
require '../includes/language/' . cmtx_setting('language_frontend') . '/countries.php';
?>
Example #2
0
    }
    ?>
</div>
</div>

<div class="dashboard_block">
<div class="dashboard_title"><?php 
    echo CMTX_DASH_LAST_LOGIN;
    ?>
</div>
<div class="dashboard_content">
<?php 
    $last_login_query = cmtx_db_query("SELECT `dated` FROM `" . $cmtx_mysql_table_prefix . "logins` ORDER BY `dated` ASC LIMIT 1");
    $last_login_result = cmtx_db_fetch_assoc($last_login_query);
    $last_login = $last_login_result["dated"];
    printf(CMTX_DASH_LAST_LOGIN_DETAILS, cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($last_login))), cmtx_format_date(date(CMTX_DATE_FORMAT, strtotime($last_login))));
    ?>
</div>
</div>

<div class="dashboard_block">
<div class="dashboard_title"><?php 
    echo CMTX_DASH_STATISTICS;
    ?>
</div>
<div class="dashboard_content">
<?php 
    $approve_comments = cmtx_db_num_rows(cmtx_db_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '0'"));
    $flagged_comments = cmtx_db_num_rows(cmtx_db_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `reports` >= " . cmtx_setting('flag_min_per_comment')));
    $today = date("Y-m-d");
    $new_comments = cmtx_db_num_rows(cmtx_db_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `dated` LIKE '" . $today . "%'"));
Example #3
0
    echo "<a href='" . $page["url"] . "' target='_blank'>" . $page["url"] . "</a>";
    ?>
</td>
			<td><?php 
    if ($page["is_form_enabled"]) {
        echo CMTX_TABLE_YES;
    } else {
        echo CMTX_TABLE_NO;
    }
    ?>
</td>
            <td><span style="display:none;"><?php 
    echo date("YmdHis", strtotime($page["dated"]));
    ?>
</span><?php 
    echo cmtx_format_date(date(CMTX_DATE_FORMAT, strtotime($page['dated']))) . ' ' . cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($page['dated'])));
    ?>
</td>
			<td>
			<a href="<?php 
    echo "index.php?page=edit_page&id=" . $page["id"];
    ?>
"><img src="images/buttons/edit.png" class="button_edit" title="Edit" alt="Edit"></a>
			<a href="<?php 
    echo "index.php?page=manage_pages&action=delete&id=" . $page["id"] . "&key=" . $_SESSION['cmtx_csrf_key'];
    ?>
"><img src="images/buttons/delete.png" class="button_delete" onclick="return delete_confirmation()" title="Delete" alt="Delete"></a>
			</td>
        </tr>	
<?php 
}
        echo CMTX_TABLE_NO;
    }
    ?>
</td>
			<td><span style="display:none;"><?php 
    echo date("YmdHis", strtotime($administrator["last_login"]));
    ?>
</span><?php 
    echo cmtx_format_date(date(CMTX_DATE_FORMAT, strtotime($administrator['last_login']))) . ' ' . cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($administrator['last_login'])));
    ?>
</td>
			<td><span style="display:none;"><?php 
    echo date("YmdHis", strtotime($administrator["dated"]));
    ?>
</span><?php 
    echo cmtx_format_date(date(CMTX_DATE_FORMAT, strtotime($administrator['dated']))) . ' ' . cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($administrator['dated'])));
    ?>
</td>
			<td>
			<a href="<?php 
    echo "index.php?page=edit_administrator&id=" . $administrator["id"];
    ?>
"><img src="images/buttons/edit.png" class="button_edit" title="Edit" alt="Edit"></a>
			<a href="<?php 
    echo "index.php?page=manage_administrators&action=delete&id=" . $administrator["id"] . "&key=" . $_SESSION['cmtx_csrf_key'];
    ?>
"><img src="images/buttons/delete.png" class="button_delete" onclick="return delete_confirmation()" title="Delete" alt="Delete"></a>
			</td>
        </tr>	
<?php 
}
    }
}
?>

<?php 
$id = $_GET['id'];
$id_san = cmtx_sanitize($id);
$administrators = cmtx_db_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "admins` WHERE `id` = '{$id_san}'");
$administrator = cmtx_db_fetch_assoc($administrators);
$username = $administrator["username"];
$email = $administrator["email"];
$enabled = $administrator["is_enabled"];
$restrict_pages = $administrator["restrict_pages"];
$allowed_pages = $administrator["allowed_pages"];
$time = cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($administrator["dated"])));
$date = cmtx_format_date(date(CMTX_DATE_FORMAT, strtotime($administrator["dated"])));
?>

<p />

<form name="administrator" id="administrator" action="index.php?page=edit_administrator&id=<?php 
echo $id;
?>
" method="post" onsubmit="return check_passwords()">
<label class='edit_administrator'><?php 
echo CMTX_FIELD_LABEL_USERNAME;
?>
</label> <input type="text" required name="username" size="12" maxlength="250" value="<?php 
echo $username;
?>
"/>
Example #6
0
function cmtx_generate_comment($is_preview, $alternate, $id, $name, $email, $website, $town, $country, $rating, $reply_to, $comment, $reply, $is_admin, $likes, $dislikes, $is_sticky, $is_locked, $dated)
{
    //generate comment
    $cmtx_box = '';
    //initialise box
    for ($i = 1; $i <= cmtx_get_reply_depth($id); $i++) {
        if (cmtx_setting('reply_arrow') && $i == cmtx_get_reply_depth($id)) {
            $cmtx_box .= '<div class="cmtx_reply_arrow">';
            //add the reply arrow
        }
        $cmtx_box .= '<div class="cmtx_reply_indent">';
        //indent the reply
    }
    $perm = '';
    if (isset($_GET['cmtx_perm']) && ctype_digit($_GET['cmtx_perm'])) {
        $cmtx_perm = (int) $_GET['cmtx_perm'];
        if ($cmtx_perm == $id) {
            $perm = ' cmtx_permalink_box';
        }
    }
    if ($alternate == 1) {
        //if it's the first box
        if (!$reply_to && !$is_admin) {
            $cmtx_box .= '<div class="cmtx_comment_box_1' . $perm . '" id="cmtx_perm_' . $id . '">';
            //comment and not admin
        } else {
            if ($reply_to && !$is_admin) {
                $cmtx_box .= '<div class="cmtx_reply_box_1' . $perm . '" id="cmtx_perm_' . $id . '">';
                //reply and not admin
            } else {
                if (!$reply_to && $is_admin) {
                    $cmtx_box .= '<div class="cmtx_admin_comment_box_1' . $perm . '" id="cmtx_perm_' . $id . '">';
                    //comment and is admin
                } else {
                    if ($reply_to && $is_admin) {
                        $cmtx_box .= '<div class="cmtx_admin_reply_box_1' . $perm . '" id="cmtx_perm_' . $id . '">';
                        //reply and is admin
                    }
                }
            }
        }
    } else {
        //if it's the second box
        if (!$reply_to && !$is_admin) {
            $cmtx_box .= '<div class="cmtx_comment_box_2' . $perm . '" id="cmtx_perm_' . $id . '">';
            //comment and not admin
        } else {
            if ($reply_to && !$is_admin) {
                $cmtx_box .= '<div class="cmtx_reply_box_2' . $perm . '" id="cmtx_perm_' . $id . '">';
                //reply and not admin
            } else {
                if (!$reply_to && $is_admin) {
                    $cmtx_box .= '<div class="cmtx_admin_comment_box_2' . $perm . '" id="cmtx_perm_' . $id . '">';
                    //comment and is admin
                } else {
                    if ($reply_to && $is_admin) {
                        $cmtx_box .= '<div class="cmtx_admin_reply_box_2' . $perm . '" id="cmtx_perm_' . $id . '">';
                        //reply and is admin
                    }
                }
            }
        }
    }
    //Sticky (1/2)
    if ($is_sticky) {
        $cmtx_box .= '<div class="cmtx_sticky_image">';
    }
    //Gravatar (1/2)
    if (cmtx_setting('show_gravatar')) {
        $cmtx_box .= '<div class="cmtx_gravatar_block">';
        $gravatar_parameter = '&amp;r=' . cmtx_setting('gravatar_rating');
        if (cmtx_setting('gravatar_default') != 'default') {
            if (cmtx_setting('gravatar_default') == 'custom') {
                $gravatar_parameter .= '&amp;d=' . cmtx_url_encode(cmtx_setting('gravatar_custom'));
            } else {
                $gravatar_parameter .= '&amp;d=' . cmtx_setting('gravatar_default');
            }
        }
        $cmtx_box .= '<img src="http://www.gravatar.com/avatar/' . md5(strtolower(trim($email))) . '.png?s=' . cmtx_setting('gravatar_size') . $gravatar_parameter . '" alt="Gravatar" title="Gravatar"/>';
        $cmtx_box .= '</div>';
        $cmtx_box .= '<div style="clear: right;"></div>';
        $cmtx_box .= '<div style="margin-left:' . (cmtx_setting('gravatar_size') + 5) . 'px;">';
    }
    //Rating
    if (cmtx_setting('show_rating') && $rating != 0) {
        $cmtx_box .= '<div class="cmtx_rating_block">';
        if ($rating == 1) {
            $cmtx_box .= cmtx_star_full(1, CMTX_RATING_ONE);
            $cmtx_box .= cmtx_star_empty(4, CMTX_RATING_ONE);
        } else {
            if ($rating == 2) {
                $cmtx_box .= cmtx_star_full(2, CMTX_RATING_TWO);
                $cmtx_box .= cmtx_star_empty(3, CMTX_RATING_TWO);
            } else {
                if ($rating == 3) {
                    $cmtx_box .= cmtx_star_full(3, CMTX_RATING_THREE);
                    $cmtx_box .= cmtx_star_empty(2, CMTX_RATING_THREE);
                } else {
                    if ($rating == 4) {
                        $cmtx_box .= cmtx_star_full(4, CMTX_RATING_FOUR);
                        $cmtx_box .= cmtx_star_empty(1, CMTX_RATING_FOUR);
                    } else {
                        if ($rating == 5) {
                            $cmtx_box .= cmtx_star_full(5, CMTX_RATING_FIVE);
                        }
                    }
                }
            }
        }
        $cmtx_box .= '</div>';
    }
    //Name and Website
    if (cmtx_setting('show_website') && !empty($website) && $website != 'http://') {
        $cmtx_website_attribute = '';
        //initialize variable
        if (cmtx_setting('website_new_window')) {
            $cmtx_website_attribute = ' target="_blank"';
        }
        //if website should open in new window
        if (cmtx_setting('website_nofollow')) {
            $cmtx_website_attribute .= ' rel="nofollow"';
        }
        //if website should contain nofollow tag
        if ($is_admin) {
            $cmtx_box .= '<a class="cmtx_admin_name_with_website_text" href="' . $website . '"' . $cmtx_website_attribute . '>' . $name . '</a>';
        } else {
            $cmtx_box .= '<a class="cmtx_name_with_website_text" href="' . $website . '"' . $cmtx_website_attribute . '>' . $name . '</a>';
        }
    } else {
        if ($is_admin) {
            $cmtx_box .= '<span class="cmtx_admin_name_without_website_text">';
            $cmtx_box .= $name;
            $cmtx_box .= '</span>';
        } else {
            $cmtx_box .= '<span class="cmtx_name_without_website_text">';
            $cmtx_box .= $name;
            $cmtx_box .= '</span>';
        }
    }
    //Town and Country
    if (cmtx_setting('show_town') && !empty($town) && cmtx_setting('show_country') && !empty($country)) {
        $cmtx_box .= '<span class="cmtx_town_country_text">';
        $cmtx_box .= ' (' . $town . ', ' . $country . ')';
        $cmtx_box .= '</span>';
    } else {
        if (cmtx_setting('show_town') && !empty($town)) {
            $cmtx_box .= '<span class="cmtx_town_country_text">';
            $cmtx_box .= ' (' . $town . ')';
            $cmtx_box .= '</span>';
        } else {
            if (cmtx_setting('show_country') && !empty($country)) {
                $cmtx_box .= '<span class="cmtx_town_country_text">';
                $cmtx_box .= ' (' . $country . ')';
                $cmtx_box .= '</span>';
            }
        }
    }
    //Says...
    if (cmtx_setting('show_says')) {
        $cmtx_box .= '<span class="cmtx_says_text">';
        $cmtx_box .= ' ' . CMTX_SAYS;
        $cmtx_box .= '</span>';
    }
    $cmtx_box .= '<div class="cmtx_height_above_comment_text"></div>';
    //Comment
    $cmtx_box .= '<div class="cmtx_comment_text">';
    if (cmtx_setting('show_read_more') && !$is_preview && cmtx_strlen(strip_tags($comment)) > cmtx_setting('read_more_limit')) {
        $comment_less = str_ireplace('<br />', ' ', $comment);
        $comment_less = str_ireplace('<br/>', ' ', $comment_less);
        $comment_less = str_ireplace('<br>', ' ', $comment_less);
        $comment_less = str_ireplace('<p></p>', ' ', $comment_less);
        $comment_less = str_ireplace('<p />', ' ', $comment_less);
        $comment_less = str_ireplace('<p/>', ' ', $comment_less);
        $comment_less = strip_tags($comment_less);
        $comment_cut = substr($comment_less, 0, cmtx_setting('read_more_limit'));
        $comment_less = substr($comment_cut, 0, strrpos($comment_cut, ' '));
        $cmtx_box .= '<div id="cmtx_comment_less_' . $id . '">';
        $cmtx_box .= $comment_less;
        $cmtx_box .= ' <a href="' . cmtx_url_encode(cmtx_current_page()) . '" class="cmtx_read_more_link" title="' . CMTX_TITLE_READ_MORE . '" rel="nofollow" onclick="cmtx_read_more(' . $id . ');return false;">' . CMTX_READ_MORE . '</a>';
        $cmtx_box .= '</div>';
        $cmtx_box .= '<div id="cmtx_comment_more_' . $id . '" style="display:none;">';
        $cmtx_box .= $comment;
        $cmtx_box .= '</div>';
    } else {
        $cmtx_box .= $comment;
    }
    $cmtx_box .= '</div>';
    //Admin Reply
    if (!empty($reply)) {
        $cmtx_box .= '<div class="cmtx_height_above_reply_text"></div>';
        $cmtx_box .= '<div class="cmtx_reply_area">';
        $cmtx_box .= '<div class="cmtx_reply_intro">';
        $cmtx_box .= CMTX_REPLY_INTRO;
        $cmtx_box .= '</div>';
        $cmtx_box .= ' ';
        $cmtx_box .= '<div class="cmtx_reply_text">';
        $cmtx_box .= $reply;
        $cmtx_box .= '</div>';
        $cmtx_box .= '</div>';
    }
    $cmtx_box .= '<div class="cmtx_height_below_comment_text"></div>';
    //Preview Message
    if ($is_preview) {
        $cmtx_box .= '<div class="cmtx_preview_text">';
        $cmtx_box .= CMTX_PREVIEW_TEXT;
        $cmtx_box .= '</div>';
    }
    $cmtx_box .= '<div class="cmtx_buttons_block">';
    //Reply
    if (cmtx_setting('show_reply') && !$is_preview) {
        $cmtx_box .= '<div class="cmtx_reply_block">';
        $cmtx_box .= '<div class="cmtx_buttons">';
        if (cmtx_get_reply_depth($id) < cmtx_setting('reply_depth') && !$is_locked) {
            $cmtx_box .= '<a href="' . cmtx_url_encode(cmtx_current_page() . CMTX_ANCHOR_FORM) . '" id="cmtx_reply_' . $id . '" class="cmtx_reply_enabled" title="' . CMTX_TITLE_REPLY . '" rel="nofollow" onclick="';
            if (cmtx_setting('hide_form')) {
                $cmtx_box .= 'cmtx_open_form();';
            }
            $cmtx_box .= 'document.getElementById(\'cmtx_hide_reply\').style.display=\'block\';';
            $cmtx_box .= 'document.getElementById(\'cmtx_reply_id\').value=\'' . $id . '\';';
            $cmtx_box .= 'document.getElementById(\'cmtx_reply_message\').innerHTML=\'' . CMTX_REPLY_MESSAGE . ' ' . $name . '. ' . '\';';
            $cmtx_box .= 'document.getElementById(\'cmtx_reset_reply\').style.display=\'inline\'">';
            $cmtx_box .= '<img src="' . cmtx_commentics_url() . 'images/buttons/reply.png" alt="Reply" title="' . CMTX_TITLE_REPLY . '"/>' . CMTX_REPLY . '</a>';
        } else {
            $cmtx_box .= '<a href="' . cmtx_url_encode(cmtx_current_page()) . '" id="cmtx_reply_' . $id . '" class="cmtx_reply_disabled" title="" rel="nofollow" onclick="return false;">';
            $cmtx_box .= '<img src="' . cmtx_commentics_url() . 'images/buttons/reply.png" alt="Reply" title=""/>' . CMTX_REPLY . '</a>';
        }
        $cmtx_box .= '</div>';
        $cmtx_box .= '</div>';
    }
    //Permalink
    if (cmtx_setting('show_permalink') && !$is_preview) {
        $cmtx_box .= '<div class="cmtx_permalink_block">';
        $cmtx_box .= '<div class="cmtx_buttons">';
        $cmtx_box .= '<a class="cmtx_permalink" href="' . cmtx_get_permalink($id, cmtx_get_page_url()) . '" id="cmtx_permalink_' . $id . '" title="' . CMTX_TITLE_PERMALINK . '" rel="nofollow"><img src="' . cmtx_commentics_url() . 'images/buttons/permalink.png" alt="Permalink" title="' . CMTX_TITLE_PERMALINK . '"/>' . CMTX_PERMALINK . '</a>';
        $cmtx_box .= '</div>';
        $cmtx_box .= '</div>';
    }
    //Flag
    if (cmtx_setting('show_flag') && !$is_preview) {
        $cmtx_box .= '<div class="cmtx_flag_block">';
        $cmtx_box .= '<div class="cmtx_buttons">';
        $cmtx_box .= '<a class="cmtx_flag" href="' . cmtx_url_encode(cmtx_current_page()) . '" id="cmtx_flag_' . $id . '" title="' . CMTX_TITLE_FLAG . '" rel="nofollow"><img src="' . cmtx_commentics_url() . 'images/buttons/flag.png" alt="Flag" title="' . CMTX_TITLE_FLAG . '"/>' . CMTX_FLAG . '</a>';
        $cmtx_box .= '</div>';
        $cmtx_box .= '</div>';
    }
    //Like/Dislike
    if ((cmtx_setting('show_like') || cmtx_setting('show_dislike')) && !$is_preview) {
        $cmtx_box .= '<div class="cmtx_like_block">';
        $cmtx_box .= '<div class="cmtx_buttons">';
        if (cmtx_setting('show_like')) {
            $cmtx_box .= '<a class="cmtx_vote cmtx_like" href="' . cmtx_url_encode(cmtx_current_page()) . '" id="cmtx_like_' . $id . '" title="' . CMTX_TITLE_LIKE . '" rel="nofollow"><img src="' . cmtx_commentics_url() . 'images/buttons/like.png" alt="Like" title="' . CMTX_TITLE_LIKE . '"/>' . $likes . '</a>';
        }
        if (cmtx_setting('show_dislike')) {
            $cmtx_box .= '<a class="cmtx_vote cmtx_dislike" href="' . cmtx_url_encode(cmtx_current_page()) . '" id="cmtx_dislike_' . $id . '" title="' . CMTX_TITLE_DISLIKE . '" rel="nofollow"><img src="' . cmtx_commentics_url() . 'images/buttons/dislike.png" alt="Dislike" title="' . CMTX_TITLE_DISLIKE . '"/>' . $dislikes . '</a>';
        }
        $cmtx_box .= '</div>';
        $cmtx_box .= '</div>';
    }
    $cmtx_box .= '</div>';
    //Date
    if (cmtx_setting('show_date')) {
        $cmtx_box .= '<div class="cmtx_date_text">';
        if (date('Y-m-d', strtotime($dated)) == date('Y-m-d')) {
            //if comment's date is today
            $cmtx_box .= CMTX_TODAY . ' ' . cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($dated)));
        } else {
            if (date('Y-m-d', strtotime($dated)) == date('Y-m-d', mktime(date('H'), date('i'), date('s'), date('m'), date('d') - 1, date('Y')))) {
                //if comment's date is yesterday
                $cmtx_box .= CMTX_YESTERDAY . ' ' . cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($dated)));
            } else {
                $cmtx_box .= cmtx_format_date(date(CMTX_DATE_FORMAT, strtotime($dated))) . ' ' . cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($dated)));
            }
        }
        $cmtx_box .= '</div>';
    }
    //Sticky (2/2)
    if ($is_sticky) {
        $cmtx_box .= '</div>';
    }
    //Gravatar (2/2)
    if (cmtx_setting('show_gravatar')) {
        $cmtx_box .= '</div>';
    }
    $cmtx_box .= '</div>';
    //end div
    for ($i = 1; $i <= cmtx_get_reply_depth($id); $i++) {
        if (cmtx_setting('reply_arrow') && $i == cmtx_get_reply_depth($id)) {
            $cmtx_box .= '</div>';
        }
        $cmtx_box .= '</div>';
    }
    if ($is_preview) {
        $cmtx_box .= '<div class="cmtx_height_below_preview_box"></div>';
    }
    return $cmtx_box;
}
    echo $page_reference_result["reference"];
    ?>
</td>
			<td><?php 
    if ($subscriber["is_confirmed"]) {
        echo CMTX_TABLE_YES;
    } else {
        echo CMTX_TABLE_NO;
    }
    ?>
</td>
            <td><span style="display:none;"><?php 
    echo date("YmdHis", strtotime($subscriber["dated"]));
    ?>
</span><?php 
    echo cmtx_format_date(date(CMTX_DATE_FORMAT, strtotime($subscriber['dated']))) . ' ' . cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($subscriber['dated'])));
    ?>
</td>
			<td>
			<a href="<?php 
    echo "index.php?page=edit_subscriber&id=" . $subscriber["id"];
    ?>
"><img src="images/buttons/edit.png" class="button_edit" title="Edit" alt="Edit"></a>
			<a href="<?php 
    echo "index.php?page=manage_subscribers&action=delete&id=" . $subscriber["id"] . "&key=" . $_SESSION['cmtx_csrf_key'];
    ?>
"><img src="images/buttons/delete.png" class="button_delete" onclick="return delete_confirmation()" title="Delete" alt="Delete"></a>
			</td>
        </tr>	
<?php 
}
<div style="clear: left;"></div>
<?php 
    }
}
?>

<?php 
$id = $_GET['id'];
$id_san = cmtx_sanitize($id);
$subscriber_query = cmtx_db_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "subscribers` WHERE `id` = '{$id_san}'");
$subscriber_result = cmtx_db_fetch_assoc($subscriber_query);
$name = $subscriber_result["name"];
$email = $subscriber_result["email"];
$confirmed = $subscriber_result["is_confirmed"];
$time = cmtx_format_date(date(CMTX_TIME_FORMAT, strtotime($subscriber_result["dated"])));
$date = cmtx_format_date(date(CMTX_DATE_FORMAT, strtotime($subscriber_result["dated"])));
$page_id = $subscriber_result["page_id"];
$page_reference_query = cmtx_db_query("SELECT `reference` FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `id` = '{$page_id}'");
$page_reference_result = cmtx_db_fetch_assoc($page_reference_query);
$page_reference = $page_reference_result["reference"];
?>

<p />

<form name="edit_subscriber" id="edit_subscriber" action="index.php?page=edit_subscriber&id=<?php 
echo $id;
?>
" method="post">
<label class='edit_subscriber'><?php 
echo CMTX_FIELD_LABEL_NAME;
?>
Example #9
0
        ?>
    	<tr>
			<td><input type="checkbox" name="bulk[]" value="<?php 
        echo str_ireplace(".sql", "", basename($backup));
        ?>
" onclick="bulk_check();"/></td>
        	<td><?php 
        echo "<a href='" . $backup . "'>" . basename($backup) . "</a>";
        ?>
</td>
            <td><?php 
        echo round(filesize($backup) / 1024, 2) . " KB";
        ?>
</td>
            <td><?php 
        echo cmtx_format_date(date(CMTX_DATE_FORMAT, filemtime($backup))) . ' ' . cmtx_format_date(date(CMTX_TIME_FORMAT, filemtime($backup)));
        ?>
</td>
			<td><a href="<?php 
        echo "index.php?page=tool_db_backup&action=delete&id=" . str_ireplace(".sql", "", basename($backup)) . "&key=" . $_SESSION['cmtx_csrf_key'];
        ?>
"><img src="images/buttons/delete.png" class="button_delete" onclick="return delete_confirmation()" title="Delete" alt="Delete"></a></td>
        </tr>	
<?php 
        $count++;
    }
    ?>

    </tbody>
</table>