plugin content file

<?php
/*
if($include_flag == 1)
{
*/
function showHome($project)
{
    $home_query = mysql_query("SELECT * FROM mod_verkoopstatus WHERE project = '$project'") or die(mysql_error());
    while($home_info = mysql_fetch_object($home_query))
    {
        if($home_info->status == 1)
        {
            $color = '#2E2EFE';
        }
        if($home_info->status == 2)
        {
            $color = '#3E8028';
        }
        if($home_info->status == 3)
        {
            $color = '#F26A20';
        }
        if($home_info->status == 4)
        {
            $color = '#F1F121';
        }
        echo '<a target="_self" href="http://localhost/abc/wp-admin/admin.php?page=Verkoopstatus'.$home_info->project.'&nr='.$home_info->nr.'">';
        echo '<div style="position: absolute; border: 1px solid black; margin-left: '.$home_info->left.'px; margin-top: '.$home_info->top.'px; height: '.$home_info->height.'px; width: '.$home_info->width.'px; background-color: '.$color.'"><p style="padding-top: 0px; margin-top: 0px;" align="center">'.$home_info->nr.'</p></div>';
        echo '</a>';
    }
}

if(isset($_GET['project']) && !empty($_GET['project']) && isset($_GET['nr']) && !empty($_GET['nr']))
{
    mysql_query("UPDATE mod_verkoopstatus SET status = status + 1 WHERE project = '".$_GET['project']."' AND nr = '".$_GET['nr']."'") or die(mysql_error());
    mysql_query("UPDATE mod_verkoopstatus SET status = status - 4 WHERE status > 4 ") or die(mysql_error()); //na 4 weer naar status 1
}

?>
<div class="wrap">
<table width="650" height="350" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" bgcolor="#ffffff">
    <tr>
        <td width="650" valign="top">
            <table width="600" border="0" align="center">
                <tr>
                    <td height="10" class="module-header">
                        &nbsp;<img src="images/arrow.gif"> Verkoopstatus
                    </td>
                </tr>
                <tr>
                    <td class="module-content">
                        <p><b>Verkoopstatus nieuwbouw project 1:</b></p>
                        <div style="height: 515; width: 600;">
                            <div style="margin: 0px; height: 515px; width: 600px;">
                                <p style="padding-top: 0px; margin-top: 0px;" align="center"><img alt="" src="verkoopstatus_project_1.jpg" /></p>
                            </div>
                            <div style="margin-top: -515px; position: absolute;">
                                <div style="position: absolute; border: 1px solid black; margin-left: 5px; margin-top: 5px; height: 30px; width: 80px; background-color: #2E2EFE"><p style="padding-top: 0px; margin-top: 0px; font-family:arial; font-size:12px;" align="center"><strong>Nog niet in verkoop</strong></p></div>
                                <div style="position: absolute; border: 1px solid black; margin-left: 5px; margin-top: 35px; height: 30px; width: 80px; background-color: #3E8028"><p style="padding-top: 0px; margin-top: 0px; font-family:arial; font-size:12px;" align="center"><strong>Nog vrij</strong></p></div>
                                <div style="position: absolute; border: 1px solid black; margin-left: 5px; margin-top: 65px; height: 30px; width: 80px; background-color: #F26A20"><p style="padding-top: 0px; margin-top: 0px; font-family:arial; font-size:12px;" align="center"><strong>Optie</strong></p></div>
                                <div style="position: absolute; border: 1px solid black; margin-left: 5px; margin-top: 95px; height: 30px; width: 80px; background-color: #F1F121"><p style="padding-top: 0px; margin-top: 0px; font-family:arial; font-size:12px;" align="center"><strong>Verkocht</strong></p></div>
                                <?php //showHome('1'); ?>
                            </div>
                        </div>
                        <p><b>Verkoopstatus nieuwbouw project 2:</b></p>
                        <div style="height: 280; width: 600;">
                            <div style="margin: 0px; height: 280px; width: 600px;">
                                <p style="padding-top: 0px; margin-top: 0px;" align="center"><img alt="" src="verkoopstatus_project_2.jpg" /></p>
                            </div>
                            <div style="margin-top: -280px; position: absolute;">
                                <div style="position: absolute; border: 1px solid black; margin-left: 5px; margin-top: 5px; height: 30px; width: 80px; background-color: #2E2EFE"><p style="padding-top: 0px; margin-top: 0px; font-family:arial; font-size:12px;" align="center"><strong>Nog niet in verkoop</strong></p></div>
                                <div style="position: absolute; border: 1px solid black; margin-left: 5px; margin-top: 35px; height: 30px; width: 80px; background-color: #3E8028"><p style="padding-top: 0px; margin-top: 0px; font-family:arial; font-size:12px;" align="center"><strong>Nog vrij</strong></p></div>
                                <div style="position: absolute; border: 1px solid black; margin-left: 5px; margin-top: 65px; height: 30px; width: 80px; background-color: #F26A20"><p style="padding-top: 0px; margin-top: 0px; font-family:arial; font-size:12px;" align="center"><strong>Optie</strong></p></div>
                                <div style="position: absolute; border: 1px solid black; margin-left: 5px; margin-top: 95px; height: 30px; width: 80px; background-color: #F1F121"><p style="padding-top: 0px; margin-top: 0px; font-family:arial; font-size:12px;" align="center"><strong>Verkocht</strong></p></div>
                                <?php //showHome('2'); ?>
                            </div>
                        </div>
                    </td>
                </tr>
            </table>
        </td>
    </tr>
</table>
</div><!-- end .wrap -->

<?php

//}
/*else
{
    echo "<script>top.location.href='../index.php';</script>";
}*/

?>