<?php include("../header_test.php") ?>
<?php include("../menu_test.php") ?>
		<div id="content_main">
			<div id="sectionhead">
                OCEAN PICTURE OF THE DAY (OPOD)
			</div>
<?php include("../action/menu.php") ?>
	    <div id="right_col">
                <div id="content">
			  <table bgcolor="white" border="0" cellpadding="10" cellspacing="0" width="780">
                <tr>
                  <td align="center" valign="middle">
                    <center><h1>OPOD Monitoring<br />
                    <? print(Date("l, F d, Y")); ?></h1></center></td>
                </tr>
                <tr>
                    <td align="center">
                    	<?php
                    		$user = $_POST['username'];
                    		$pass = $_POST['pass'];
							
                    		if(($user=="theoceanproject")&&($pass=="password")) {
                    	?>
                            <form action="Monitor2.php" enctype="multipart/form-data" method="post">
                            <table border="0" bordercolor="#000060" bgcolor="#000060" id="Maintable" table width="720" align="center" cellpadding="16" cellspacing="0">                         
                            <tr id="ROW1title">
                                   <td width="400"><span style="color: #000000"></span>
                                        <table border="0" bordercolor="#CCCCCC" bgcolor="#CCCCCC" id="TITLE table">
                                     <tr>
                                               <td bordercolor="#999999" bgcolor="#FFFFFF"><div align="center" style="font-weight: bold; font-size: 16px">Review OPOD Submission</div></td>
                                            </tr>
                                        </table>
                                   </td>
                                </tr>
                                <tr id="ROW2Subdate">
                                   <td>
                                        <table width="100%" border="0" bordercolor="#999999" bgcolor="#CCCCCC" id="SUB DATE table" table >
                                            <tr>
                                                   <td bgcolor="#FFFFFF"><span class="instruction" style="font-size: 14px">  OPOD's Submission<span class="instruction" style="font-size: 14px"> Date:</span></span></td>
                                            </tr>
                                            <tr>
                                                   <td>
                                                   <?php
                                                // LINKUP 
                                                //Connect To Database
                                        	$hostname='mysql27.secureserver.net';
                                        	$username='oceanweb';
                                        	$password='password';
                                        	$dbname='oceanweb';
                                        
                                                //connect to database
                                               mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
                                               //select - use this database 
                                                mysql_select_db($dbname);
                                                
                              //Post oldest item where record hasn't been reviewed by monitor. 
                                                
                                                //$maxdate= "SELECT Min(date) FROM  pic";
                                                
                            $query0 = "SELECT date FROM user, pic, submits WHERE user.id = submits.user_id AND pic.id = submits.picture_id AND submits.status = 0 ORDER BY date LIMIT 1";
                                                
                                                //echo 'Running Query: '.$query;						
                                                $result = mysql_query($query0);
                                                if($result) {
                                                    while($row = mysql_fetch_array($result)){
                                                        echo $row['date'];
                                                        //$count = $count + 1;
                                                    }
                                                } else {
                                                    echo 'No results from query';
                                                
                                                }
                                                ?>                    </td>
                                            </tr>
                                        </table>
                                   </td>
                                </tr>
                                <tr id="ROW3userInfo">
                                   <td>
                                        <table width="100%" border="0" bordercolor="#999999" bgcolor="#CCCCCC" id="userInfo">
                                            <tr>
                                               <td colspan="2" bgcolor="#FFFFFF" class="instruction" style="font-size: 14px">User Info:</td>
                                            </tr>
                                            <tr>
                                               <td width="50" class="instruction">Name:</td>
                                              <td width="370">
                                                <?php
                                                //Connect To Database
                                        	$hostname='mysql27.secureserver.net';
                                        	$username='oceanweb';
                                        	$password='password';
                                        	$dbname='oceanweb';
                                                //connect to database
                                               mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
                                                //select - use this database 
                                                mysql_select_db($dbname);
                                                
                                                //Post Submitters name to the Page. //
                                                
                            $query1 = "SELECT user.first, user.last FROM user, pic, submits WHERE user.id = submits.user_id AND pic.id = submits.picture_id AND submits.status = 0 ORDER BY date LIMIT 1";
                                                
                                                //echo 'Running Query: '.$query;						
                                                $result = mysql_query($query1);
                                                if($result) {
                                                    while($row = mysql_fetch_array($result)){
                                                        echo $row['last'];
                                                        echo ', ';
                                                        echo $row['first'];
                                                        $count = $count + 1;
                                                    }
                                                } else {
                                                    echo 'No results from query';
                                                
                                                }
                                                ?></td>
                                            </tr>
                                            <tr>
                                               <td class="instruction">City:</td>
                                              <td width="370">
                                               <?php
                                                    //Connect To Database
                                        	$hostname='mysql27.secureserver.net';
                                        	$username='oceanweb';
                                        	$password='password';
                                        	$dbname='oceanweb';
                                                    
                                                    //connect to database
                                                    mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
                                                    
                                                    //select - use this database 
                                                    mysql_select_db($dbname);
                            
                            //City///////////////////////////////////////////////////////////////////////////////////////////////////////////
                                                    //$query2 = "SELECT town from pic WHERE town='blackstone'";
                                                    
                                                    $query2 = "SELECT town FROM user, pic, submits WHERE user.id = submits.user_id AND pic.id = submits.picture_id AND submits.status = 0 ORDER BY date LIMIT 1";
                                                    
                                                    //echo 'Running Query: '.$query;						
                                                    $result = mysql_query($query2);
                                                    if($result) {
                                                        while($row = mysql_fetch_array($result)){
                                                            echo $row['town'];
                                                            $count = $count + 1;
                                                        }
                                                    } else {
                                                        echo 'No results from query';
                                                    
                                                    }
                                                    ?>
                                              </td>
                                            </tr>
                                      <tr>
                                        <td class="instruction">State: </td>
                              <td>
                                                        <?php                           
                                            //Connect To Database
                                        	$hostname='mysql27.secureserver.net';
                                        	$username='oceanweb';
                                        	$password='password';
                                        	$dbname='oceanweb';
                                            
                                            //connect to database
                                            mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
                                            
                                            //select - use this database 
                                            mysql_select_db($dbname);
                                            
                                            // Post the State to the Page /////////////////////////////////////////////////////////////////////////////////////////////////
                                            
                                            $query3 = "SELECT state FROM user, pic, submits WHERE user.id = submits.user_id AND pic.id = submits.picture_id AND submits.status = 0 ORDER BY date LIMIT 1";
                                            
                                            //echo 'Running Query: '.$query;						
                                            $result = mysql_query($query3);
                                            if($result) {
                                                while($row = mysql_fetch_array($result)){
                                                    echo $row['state'];
                                                    $count = $count + 1;
                                                }
                                            } else {
                                                echo 'No results from query';
                                            }
                                            ?>
                                            </td>
                                            </tr>
                                            <tr>
                                               <td class="instruction">Email:</td>
                                              <td width="370">
                                                <?php
                                                //Connect To Database
                                        	$hostname='mysql27.secureserver.net';
                                        	$username='oceanweb';
                                        	$password='password';
                                        	$dbname='oceanweb';
                                                
                                                //connect to database
                                               mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
                                                
                                                //select - use this database 
                                                mysql_select_db($dbname);
                                                
                                                //Post the Submitters Email Address///////////////////////////////////////////////////////////////////////////////////////////////
                                                
                                                $query4 = "SELECT email FROM user, pic, submits WHERE user.id = submits.user_id AND pic.id = submits.picture_id AND submits.status = 0 ORDER BY date LIMIT 1";
                                                
                                                //echo 'Running Query: '.$query;						
                                                $result = mysql_query($query4);
                                                if($result) {
                                                    while($row = mysql_fetch_array($result)){
                                                        echo $row['email'];
                                                        $count = $count + 1;
                                                    }
                                                } else {
                                                    echo 'No results from query';
                            
                                                }
                                                ?>
                                              </td>
                                            </tr>
                                        </table>
                                    </td>
                                </tr>
                                <tr id="ROW4FileInfo">
                                   <td>
                                    <table width="100%" border="0" bordercolor="#999999" bgcolor="#CCCCCC" id="FILEinfo">
                                           <tr>
                                              <td colspan="2" bgcolor="#FFFFFF" class="instruction" style="font-size: 14px">File Info:</td>     
                                           </tr>
                                           <tr>
                                                <td width="91" class="instruction">File:</td>
                                                <td width="641">
                                                <?php 
                                                //Connect To Database
                                        	$hostname='mysql27.secureserver.net';
                                        	$username='oceanweb';
                                        	$password='password';
                                        	$dbname='oceanweb';
                                                
                                                //connect to database
                                            mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
                                                
                                                
                                                //select - use this database 
                                                mysql_select_db($dbname);
                                                
                                //File Name: ///////////////////////////////////////////////////////////////////////////////////////////////////////////
                                                
                                                $query5 = "SELECT name FROM user, pic, submits WHERE WHERE user.id = submits.user_id AND pic.id = submits.picture_id AND submits.status = 0 ORDER BY date LIMIT 1";
                                                
                                                //echo 'Running Query: '.$query;						
                                                $result = mysql_query($query5);
                                                if($result) {
                                                    while($row = mysql_fetch_array($result)){
                                                        echo $row['name'];
                                                        $count = $count + 1;
                                                    }
                                                } else {
                                                    echo 'No results';
                                                }
                                                ?>
                                                </td>
                                           </tr>
                                           <tr>
                                               <td width="91" class="instruction">Size:</td>
                                               <td width="641">
                                                <?php
                                                // LINKUP /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// 
                                                //Connect To Database
                                        	$hostname='mysql27.secureserver.net';
                                        	$username='oceanweb';
                                        	$password='password';
                                        	$dbname='oceanweb';
                                                
                                                //connect to database
                                     mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
                                                
                                                //select - use this database 
                                                mysql_select_db($dbname);
                                                
                              //Post the File Size to the Page //////////////////////////////////////////////////////////////////////////////////////
                                                
                                                $query6 = "SELECT size FROM user, pic, submits WHERE user.id = submits.user_id AND pic.id = submits.picture_id AND submits.status = 0 ORDER BY date LIMIT 1";
                                                
                                                //echo 'Running Query: '.$query;						
                                                $result = mysql_query($query6);
                                                if($result) {
                                                    while($row = mysql_fetch_array($result)){
                                                        echo $row['size'];
                                                        echo 'kb';
                                                        $count = $count + 1;
                                                    }
                                                } else {
                                                    echo 'No results';
                                                }
                                                ?>
                                               </td>
                                            </tr>
                                        </table>
                                   </td>
                                </tr>
                            <tr id="ROW5Image">
                               <td>
                                           <table width="100%" border="0" bordercolor="#CCCCCC" bgcolor="#CCCCCC" id ="Image">
                                        <tr>
                                           <td bordercolor="#999999" bgcolor="#FFFFFF" class="instruction" style="font-size: 14px">Image:</td>
                                        </tr>
                                        <tr>
                                           <td bordercolor="#000060" bgcolor="#000060">
                                                 <div align="center">
                                                    <?php
                                                    //Connect To Database
                                        	$hostname='mysql27.secureserver.net';
                                        	$username='oceanweb';
                                        	$password='password';
                                        	$dbname='oceanweb';
                                                    
                                                    //connect to database
                                        mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
                                                    
                                                    //select - use this database 
                                                    mysql_select_db($dbname);
                                                    
                                                    //IMAGE//////////////////////////////////////////////////////////////////////////////////////////////////////////
                                                    
                            $query8 = "SELECT name FROM user, pic, submits WHERE user.id = submits.user_id AND pic.id = submits.picture_id AND submits.status = 0 ORDER BY date LIMIT 1";
                                                    
                                                    //echo 'Running Query: '.$query;						
                                                    $result = mysql_query($query8);
                                                    if($result) {
                                                        while($row = mysql_fetch_array($result)){
                                                            echo "\n";
                                                            echo '<center><img src="http://www.theoceanproject.org/opod/upload/';
                                                            echo $row['name'];
                                                            echo '" width="500"></center>';
                                                            echo '							</tr>';
                                                            $count = $count + 1;
                                                        }
                                                    } else {
                                                        echo 'No results from query';
                                                    }
                                                    ?>
                                                    </div>
                                              </td>
                                        </tr>
                                        </table>
                               </td>
                            </tr>
                            <tr id="ROW6Caption">
                               <td>
                                           <table width="100%" border="0" bordercolor="#999999" bgcolor="#CCCCCC" id="caption">
                                        <tr>
                                           <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="instruction" style="font-size: 14px">Image Caption:</span></td>
                                        </tr>
                                        <tr>
                                           <td bordercolor="#999999" bgcolor="#CCCCCC">
                                 <div align="center">
                                                            <?php                           
                                                            //Connect To Database
                                        	$hostname='mysql27.secureserver.net';
                                        	$username='oceanweb';
                                        	$password='password';
                                        	$dbname='oceanweb';
                                                            
                                                            //connect to database
                                                            mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
                                                            
                                                            //select - use this database 
                                                            mysql_select_db($dbname);
                                                            
                                                            //caption///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
                            $query9 = "SELECT caption FROM user, pic, submits WHERE user.id = submits.user_id AND pic.id = submits.picture_id AND submits.status = 0 ORDER BY date LIMIT 1";
                                                            
                                                            //echo 'Running Query: '.$query;						
                                                            $result = mysql_query($query9);
                                                            if($result) {
                                                                while($row = mysql_fetch_array($result)){
																    echo '<textarea name="caption" cols=60 rows=8>';
                                                                    echo $row['caption'];
																    echo '</textarea>';
                                                                    $count = $count + 1;
                                                                }
                                                            } else {
                                                                echo 'No results from query';
                                                            }
                                                            ?>
                                                </div>
                                              </td>
                                        </tr>
                                        </table>
                            
                            </td>
                            </tr>
                            <tr id="ROW7UseDate"><td>
                            <table width="100%" border="0" bordercolor="#999999" bgcolor="#CCCCCC" id="UseDate">
                                        <tr>
                                        <td bgcolor="#FFFFFF"><span class="instruction" style="font-size: 16px">Update OPOD Data:</span></td>
                                        </tr>
                                        <tr>
                                        <td bgcolor="#CCCCCC" class="instruction" style="font-size: 12px">Record Posting Date :</td>
                                        </tr>
                                        <tr>
                                           <td bgcolor="#CCCCCC"><div align="left">
                                             <p align="center"><span class="instruction" style="color: #000000; font-size: 10px"> 
                                               <span style="font-size: 11px">Last Date Used as OPOD</span>: </span></p>
                                             <p align="center"><span class="instruction" style="color: #000000">
                                               <?php
												//Connect To Database
                                        	$hostname='mysql27.secureserver.net';
                                        	$username='oceanweb';
                                        	$password='password';
                                        	$dbname='oceanweb';
												
												//connect to database
												mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
												
												//select - use this database 
												mysql_select_db($dbname);
												
												// *** Last DATE USED - Last Known Date that a Submission was assigned to ** //
												$query11 = "SELECT use_date FROM user, pic, submits WHERE user.id = submits.user_id AND pic.id = submits.picture_id AND submits.status = 0 ORDER BY date LIMIT 1";
												
												//echo 'Running Query: '.$query;						
												$result = mysql_query($query11);
												if($result) {
													while($row = mysql_fetch_array($result)){
														echo $row['use_date'];
														$count = $count + 1;
													}
												} else {
													echo 'No results';
												}
                                            ?>
                                             </span> </p>
                                           </div></td>
                                              </tr>
                                           <tr>
                                           <td bgcolor="#CCCCCC">
                                                <div align="center">
                                                  <p align="center"><span class="instruction" style="font-size: 10px">Desired  Date to Post OPOD Record to Website:</span>                          </p>
                                                  <p align="center">
                                                    <input name="dsubmitDate" type="text" id="dsubmitDate" value="yyyy-mm-day" size="40" maxlength="15" />
                                                  </p>
                                                </div></td>
                                        </tr>
                                      <tr>         </tr>
                                     <tr>
                                               <td bgcolor="#CCCCCC"><p class="instruction" style="font-size: 12">Record Status:</p></td>
                                  </tr>
                                  <tr>
                                     <td bgcolor="#CCCCCC">
                                        <div align="center">
                                          <input type="checkbox" name="status" value="1" />
                                          <span style="font-weight: bold; font-size: 10px">Approve OPOD Record</span> </div></td>
                                  </tr>
                                  <tr>
                                     <td bgcolor="#CCCCCC"><div align="center" style="font-size: 10">
                                       <input type="checkbox" name="status" value="2" />
                                       <span style="font-weight: bold">Decline OPOD Record</span></div></td>
                                  </tr>
                                    <tr>
                                      <td bgcolor="#CCCCCC">
                                        <div align="center">
                                          <input type="submit" name=" submit" value="OK" />
                                          </div></td>
                                    </tr>
                            </table>
                            </form>
                        <?php							
                        	} else {
                        ?>
                        <style type="text/css">
							<!--
							.style1 {color: #000000}
							-->
                        </style>
                        <div style="background-image:url(crab.jpg);width:450px;height:262px" align="left">
                            <p> </p>
                            <p> </p>
                            <p> </p>
                            <p> </p>
                            <p> </p>
                            <h1>   Monitor Login</h1>
                            <form action="MonitorLogin.php" method="post">
                            <table>
                                <tr>
                                  <td><label for="username">     Username: </label></td><td><input type="text" name="username" maxlength="25" /></td>
                                </tr>
                                <tr>
                                  <td><label for="password">     Password: </label></td><td><input type="password" name="pass" maxlength="25" /></td>
                                </tr>
                                <tr>
                                  <td colspan="2" align="center"><input type="submit" name="submit" value="Login" /></td>
                                </tr>
                            </table>
                            </form> 
                        </div>
                        <?php							
                        	}
                        ?>
                    </td>
                </tr>
                <tr>
                    <td><p style="font-size:12px" align="center"><a href="upload_form.php">Submit an Ocean Picture Of the Day</a></p>
    					<p style="font-size:12px" align="center"><a href="index.php" style="font-size: 12px">OPOD Home Page</a></p>
    				</td>
                </tr>
                <tr>
                    <td><p style="font-size:12px" align="center">
                    		<a href="http://antwrp.gsfc.nasa.gov/apod/astropix.html" target="_blank">Astronomy Picture of the Day</a>
                    		| <a href="http://epod.usra.edu/" target="_blank">Earth Science Picture of the Day</a></p>                    
                    </td>
                </tr>
          </table>
          </td></tr></table>
          </div></div>
        <div id="footer" style="left:464px;top:712px">
        <table>
            <tr>
                <td style="background:transparent">
<?php include("../footer_div.php") ?>
</div>
</body>
</html>