<? 
require "header.php"; 

if($_POST['niche']) {
	foreach($_POST['niche'] as $i) {
		mysql_query("DELETE FROM static WHERE record_num = '$i'");
	}
}

if($_POST[title]) {
	$_POST = mysql_real_escape_array($_POST); 
	mysql_query("INSERT INTO static (filename, title, body, metakw, metadesc, headertitle) VALUES ('$_POST[filename]', '$_POST[title]', '$_POST[body]', '$_POST[metakw]', '$_POST[metadesc]', '$_POST[headertitle]')");
	$insertid = mysql_insert_id();
}
?>
     <div id="right_column">
        <!-- RIGHT -->
        <div id="right_top">
        	<div id="right_home"></div>
            <div id="right_right">  
            <a href="index.php">Admin Home</a>          
            <span><a href="static.php">Static Pages</a></span>  
            </div>
        </div>
        
        
        
        <div id="right_bg">
        
      		<h2>Edit<strong>Static Pages</strong></h2>
            
            <div id="index_left" style='width: 100%;'>            
           
        
<? if($error) { ?><p><? echo $error; ?></p><? } ?>
<form id="form1" name="form1" method="post" action="" enctype='multipart/form-data'>
  <table border="0" align="center" cellpadding="3" cellspacing="0" class='pagetable'> 
  <thead>
  <tr>
  <th colspan=2 align='left'>Add Static Page</th>
  </tr>
  </thead>
      <tr>
      <td width="99" height="25" class="style4">Filename</td>
      <td width="446" height="25" align="left" class="style4"><input name="filename" type="text" class="style4" id="name" size="35" maxlength="255" /></td>
    </tr>
    <tr>
      <td width="99" height="25" class="style4">Title</td>
      <td width="446" height="25" align="left" class="style4"><input name="title" type="text" class="style4" id="name" size="35" maxlength="255" /></td>
    </tr>
     <tr>
      <td width="99" height="25" class="style4">Header Title</td>
      <td width="446" height="25" align="left" class="style4"><input name="headertitle" type="text" class="style4" id="name" size="35" maxlength="255" /></td>
    </tr>
     <tr>
      <td width="99" height="25" class="style4">Meta KW</td>
      <td width="446" height="25" align="left" class="style4"><input name="metakw" type="text" class="style4" id="name" size="35" maxlength="255" /></td>
    </tr>
     <tr>
      <td width="99" height="25" class="style4">Meta Desc</td>
      <td width="446" height="25" align="left" class="style4"><input name="metadesc" type="text" class="style4" id="name" size="35" maxlength="255" /></td>
    </tr>
    <tr>
      <td height="25" class="style4">Body</td>
      <td height="25" align="left" class="style4"><textarea name="body" cols="35" rows="15" class="style4" id="name4"></textarea></td>
    </tr>  
  
    <tr>
      <td height="25" colspan="2" align="center" class="style4"><input type="submit" name="Submit2" value="Save" /></td>
    </tr>
  </table>
<br />
  <br />
  <table border="0" align="center" cellpadding="3" cellspacing="0" class='pagetable'>
  	<thead>
    <tr>
      <th width="131" align='left'>Filename</th>
      <th width="446" align='left'>Title</th>
      <th width="47" align="center">Edit</th>
      <th width="52" align="center">Delete</th>
    </tr>
    </thead>
    
<?
$bgcolor = '#ffffff';
$result = mysql_query("SELECT * FROM static ORDER BY filename ASC");
while($row = mysql_fetch_array($result)) { 
?>
    <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td valign="top" class="style4"><a href='<? echo $basehttp; ?>/static/<? echo $row[filename]; ?>'><? echo $row[filename]; ?></a></td>
      <td valign="top" class="style4"><? echo $row[title]; ?></td>
      <td align="center" valign="top"><a href="edit_static.php?id=<? echo $row[record_num]; ?>">Edit</a></td>
      <td align="center" valign="top"><input name="niche[]" type="checkbox" class="style4" value="<? echo $row[record_num]; ?>" /></td>
    </tr>
<? 
if($bgcolor == '#ffffff') { $bgcolor = "#EBEBEB"; } else { $bgcolor = '#ffffff'; }
}
?>
    <tr bgcolor = '<? echo $bgcolor; ?>'>
      <td colspan="5" class="style4"><center><br />
           <input name="Submit" type="submit" value="Delete Selected" />
      </center></td>
    </tr>
</table>
           
           
            </div>
            
          
        
        </div>
        
        <div id="right_bottom"></div>
       
        <!-- RIGHT -->
        
        
        
        <!-- STATYSTYKI -->
      
        
      
        </div>
       <!-- STATYSTYKI -->       
        
    
    
    </div>
  



</div>


      
        





<? require "footer.php"; ?>