<?
/*---------------------------*/
//either include in the filename or include setup.php, ensure established connection to database
$submit = $_GET['submit'];
$update = $_GET['update'];
$confirm = $_GET['confirm'];
$display_ = $_POST['display'];
if(isset($display_)) {
$display_ = 1;
} else {
$display_ = 0;
}
$bg_ = $_POST['bg'];
$width_ = $_POST['width'];
$height_ = $_POST['height'];
$left_ = $_POST['left'];
$padding_ = $_POST['padding'];
$border_width_ = $_POST['border_width'];
$border_bottom_ = $_POST['border_bottom'];
////
//features//
$contentarea_ = $_POST['contentarea'];
$navarea_ = $_POST['navarea'];
//Spacing///
$spacing1_ = $_POST['spacing1'];
$spacing2_ = $_POST['spacing2'];
$spacing3_ = $_POST['spacing3'];
$spacing4_ = $_POST['spacing4'];
$bgbody_ = $_POST['bgbody'];
$bg1_ = $_POST['bg1'];
$bg2_ = $_POST['bg2'];
$bg3_ = $_POST['bg3'];
$bg4_ = $_POST['bg4'];
$bg5_ = $_POST['bg5'];
$bg6_ = $_POST['bg6'];
$bg7_ = $_POST['bg7'];
$backupfilename_ = $_POST['backupfilename'];
$resetname_ = $_POST['resetname'];
////
$edit = mysql_query("SELECT * FROM section WHERE section='container'");
while($row=mysql_fetch_array($edit)) {
$bg = $row["bgcolor"];
$width = $row['width'];
$height = $row['height'];
$left = $row['left'];
$padding = $row['top'];
$border_width = $row['border_width'];
$border_bottom = $row['border_bottom'];
}
$editlayout_1 = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="editlayout_1" method="post" action="?page=secure&a=sitelayout&submit=2&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Container Setup</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td width="22%">Background</td>
<td width="78%"><input name="bg" type="text" id="bg" value="$bg"></td>
</tr>
<tr>
<td width="22%">width</td>
<td width="78%"><input name="width" type="text" id="width" value="$width"></td>
</tr>
<tr>
<td width="22%">height</td>
<td width="78%"><input name="height" type="text" id="height" value="$height"></td>
</tr>
<tr>
<td width="22%">Align</td>
<td width="78%">
<select name="exportformat" size="1">
<option value='1' selected>Center</option>
<option value='2'>Left</option>
<option value='3' >Right</option>
</td>
</tr>
<tr>
<td width="22%">Padding</td>
<td width="78%"><input name="padding" type="text" id="padding" value="$padding"></td>
</tr>
<tr>
<td width="22%">Border Width</td>
<td width="78%"><input name="border_width" type="text" id="border_width" value="$border_width"></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$edit = mysql_query("SELECT * FROM section WHERE section='header'");
while($row=mysql_fetch_array($edit)) {
$display = $row['display'];
if($display == 1) {
$value = "value="1" CHECKED";
} else {
$value = "value="0" UNCHECKED";
}
$bg = $row["bgcolor"];
$width = $row['width'];
$height = $row['height'];
$padding = $row['top'];
$border_width = $row['border_width'];
$border_bottom = $row['border_bottom'];
}
$editlayout_2 = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="editlayout_2" method="post" action="?page=secure&a=sitelayout&submit=3&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Header Setup</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td>Display Header</td><td><input type="checkbox" name="display" $value></td>
</tr>
<tr>
<td width="22%">Background</td>
<td width="78%"><input name="bg" type="text" id="bg" value="$bg"></td>
</tr>
<tr>
<td width="22%">width</td>
<td width="78%"><input name="width" type="text" id="width" value="$width"></td>
</tr>
<tr>
<td width="22%">height</td>
<td width="78%"><input name="height" type="text" id="height" value="$height"></td>
</tr>
<tr>
<td width="22%">Padding</td>
<td width="78%"><input name="padding" type="text" id="padding" value="$padding"></td>
</tr>
<tr>
<td width="22%">Border Width</td>
<td width="78%"><input name="border_width" type="text" id="border_width" value="$border_width"></td>
</tr>
<tr>
<td width="22%">Bottom Border Width</td>
<td width="78%"><input name="border_bottom" type="text" id="border_bottom" value="$border_bottom"></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$edit = mysql_query("SELECT * FROM section WHERE section='nav top'");
while($row=mysql_fetch_array($edit)) {
$display = $row['display'];
if($display == 1) {
$value = "value="1" CHECKED";
} else {
$value = "value="0" UNCHECKED";
}
$bg = $row["bgcolor"];
$width = $row['width'];
$height = $row['height'];
$padding = $row['top'];
$border_width = $row['border_width'];
$border_bottom = $row['border_bottom'];
}
$editlayout_3 = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="editlayout_3" method="post" action="?page=secure&a=sitelayout&submit=4&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Top Setup</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td>Display Top</td><td><input type="checkbox" name="display" $value></td>
<tr>
<td width="22%">Background</td>
<td width="78%"><input name="bg" type="text" id="bg" value="$bg"></td>
</tr>
<tr>
<td width="22%">width</td>
<td width="78%"><input name="width" type="text" id="width" value="$width"></td>
</tr>
<tr>
<td width="22%">height</td>
<td width="78%"><input name="height" type="text" id="height" value="$height"></td>
</tr>
<tr>
<td width="22%">Padding</td>
<td width="78%"><input name="padding" type="text" id="padding" value="$padding"></td>
</tr>
<tr>
<td width="22%">Border Width</td>
<td width="78%"><input name="border_width" type="text" id="border_width" value="$border_width"></td>
</tr>
<tr>
<td width="22%">Bottom Border Width</td>
<td width="78%"><input name="border_bottom" type="text" id="border_bottom" value="$border_bottom"></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$edit = mysql_query("SELECT * FROM section WHERE section='left'");
while($row=mysql_fetch_array($edit)) {
$display = $row['display'];
if($display == 1) {
$value = "value="1" CHECKED";
} else {
$value = "value="0" UNCHECKED";
}
$bg = $row["bgcolor"];
$width = $row['width'];
$height = $row['height'];
$left = $row['left'];
$padding = $row['top'];
$border_width = $row['border_width'];
$border_bottom = $row['border_bottom'];
}
$editlayout_4 = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="editlayout_4" method="post" action="?page=secure&a=sitelayout&submit=5&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Left Setup</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td>Display Left</td><td><input type="checkbox" name="display" $value></td>
<tr>
<td width="22%">Background</td>
<td width="78%"><input name="bg" type="text" id="bg" value="$bg"></td>
</tr>
<tr>
<td width="22%">width</td>
<td width="78%"><input name="width" type="text" id="width" value="$width"></td>
</tr>
<tr>
<td width="22%">height</td>
<td width="78%"><input name="height" type="text" id="height" value="$height"></td>
</tr>
<tr>
<td width="22%">Top Padding</td>
<td width="78%"><input name="padding" type="text" id="padding" value="$padding"></td>
</tr>
<tr>
<td width="22%">Border Width</td>
<td width="78%"><input name="border_width" type="text" id="border_width" value="$border_width"></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$edit = mysql_query("SELECT * FROM section WHERE section='middle'");
while($row=mysql_fetch_array($edit)) {
$display = $row['display'];
if($display == 1) {
$value = "value="1" CHECKED";
} else {
$value = "value="0" UNCHECKED";
}
$bg = $row["bgcolor"];
$width = $row['width'];
$height = $row['height'];
$padding = $row['top'];
$border_width = $row['border_width'];
$border_bottom = $row['border_bottom'];
}
$editlayout_5 = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="editlayout_5" method="post" action="?page=secure&a=sitelayout&submit=6&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Middle Setup</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td>Display Middle</td><td><input type="checkbox" name="display" $value></td>
<tr>
<td width="22%">Background</td>
<td width="78%"><input name="bg" type="text" id="bg" value="$bg"></td>
</tr>
<tr>
<td width="22%">width</td>
<td width="78%"><input name="width" type="text" id="width" value="$width"></td>
</tr>
<tr>
<td width="22%">height</td>
<td width="78%"><input name="height" type="text" id="height" value="$height"></td>
</tr>
<tr>
<td width="22%">Left padding</td>
<td width="78%"><input name="padding" type="text" id="padding" value="$padding"></td>
</tr>
<tr>
<td width="22%">Border Width</td>
<td width="78%"><input name="border_width" type="text" id="border_width" value="$border_width"></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$edit = mysql_query("SELECT * FROM section WHERE section='right'");
while($row=mysql_fetch_array($edit)) {
$display = $row['display'];
if($display == 1) {
$value = "value="1" CHECKED";
} else {
$value = "value="0" UNCHECKED";
}
$bg = $row["bgcolor"];
$width = $row['width'];
$height = $row['height'];
$padding = $row['top'];
$border_width = $row['border_width'];
$border_bottom = $row['border_bottom'];
}
$editlayout_6 = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="editlayout_6" method="post" action="?page=secure&a=sitelayout&submit=7&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Right Setup</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td>Display Right</td><td><input type="checkbox" name="display" $value></td>
<tr>
<td width="22%">Background</td>
<td width="78%"><input name="bg" type="text" id="bg" value="$bg"></td>
</tr>
<tr>
<td width="22%">width</td>
<td width="78%"><input name="width" type="text" id="width" value="$width"></td>
</tr>
<tr>
<td width="22%">height</td>
<td width="78%"><input name="height" type="text" id="height" value="$height"></td>
</tr>
<tr>
<td width="22%">Left Padding</td>
<td width="78%"><input name="padding" type="text" id="padding" value="$padding"></td>
</tr>
<tr>
<td width="22%">Border Width</td>
<td width="78%"><input name="border_width" type="text" id="border_width" value="$border_width"></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$edit = mysql_query("SELECT * FROM section WHERE section='footer'");
while($row=mysql_fetch_array($edit)) {
$display = $row['display'];
if($display == 1) {
$value = "value="1" CHECKED";
} else {
$value = "value="0" UNCHECKED";
}
$bg = $row["bgcolor"];
$width = $row['width'];
$height = $row['height'];
$padding = $row['top'];
$border_width = $row['border_width'];
$border_bottom = $row['border_bottom'];
}
$editlayout_7 = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="editlayout_7" method="post" action="?page=secure&a=sitelayout&submit=8&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Footer Setup</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td>Display footer</td><td><input type="checkbox" name="display" $value></td>
<tr>
<td width="22%">Background</td>
<td width="78%"><input name="bg" type="text" id="bg" value="$bg"></td>
</tr>
<tr>
<td width="22%">width</td>
<td width="78%"><input name="width" type="text" id="width" value="$width"></td>
</tr>
<tr>
<td width="22%">height</td>
<td width="78%"><input name="height" type="text" id="height" value="$height"></td>
</tr>
<tr>
<td width="22%">Padding</td>
<td width="78%"><input name="padding" type="text" id="padding" value="$padding"></td>
</tr>
<tr>
<td width="22%">Border Width</td>
<td width="78%"><input name="border_width" type="text" id="border_width" value="$border_width"></td>
</tr>
<tr>
<td width="22%">Bottom Border Width</td>
<td width="78%"><input name="border_bottom" type="text" id="border_bottom" value="$border_bottom"></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$editfeature = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="editfeature" method="post" action="?page=secure&a=sitelayout&submit=9&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Feature Setup</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td width="22%">Content Area</td>
</td>
<td>
<select name="contentarea" size="1">
<option value='1' selected >Middle Column</option>
<option value='2'>Left Column</option>
<option value='3' >Right Column</option>
</td>
<tr>
<tr>
<td width="22%">Navigation Area</td>
</td>
<td>
<select name="navarea" size="1">
<option value='1' selected >Top Nav bar</option>
<option value='2'>Left Nav bar</option>
<option value='3' >Right Nav bar</option>
</td>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$edit = mysql_query("SELECT top FROM section WHERE section='container'");
while($row=mysql_fetch_array($edit)) {
$spacing1 = $row['top'];
}
$edit = mysql_query("SELECT top FROM section WHERE section='nav top'");
while($row=mysql_fetch_array($edit)) {
$spacing2 = $row['top'];
}
$edit = mysql_query("SELECT top FROM section WHERE section='left'");
while($row=mysql_fetch_array($edit)) {
$spacing3 = $row['top'];
}
$edit = mysql_query("SELECT top FROM section WHERE section='footer'");
while($row=mysql_fetch_array($edit)) {
$spacing4 = $row['top'];
}
$editspacing = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="spacing1" method="post" action="?page=secure&a=sitelayout&submit=spacing&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Verticle Spacings</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td width="22%">Screen spacing</td>
<td width="78%"><input name="spacing1" type="text" id="bg" value="$spacing1"></td>
</tr>
<tr>
<td width="22%">Top bar to header</td>
<td width="78%"><input name="spacing2" type="text" id="width" value="$spacing2"></td>
</tr>
<tr>
<td width="22%">Middle to above table</td>
<td width="78%"><input name="spacing3" type="text" id="height" value="$spacing3"></td>
</tr>
<tr>
<td width="22%">footer to middle</td>
<td width="78%"><input name="spacing4" type="text" id="top" value="$spacing4"></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$edit = mysql_query("SELECT bgcolor FROM section WHERE section='body'");
while($row=mysql_fetch_array($edit)) {
$bgbody = $row['bgcolor'];
}
$edit = mysql_query("SELECT bgcolor FROM section WHERE section='container'");
while($row=mysql_fetch_array($edit)) {
$bg1 = $row['bgcolor'];
}
$edit = mysql_query("SELECT bgcolor FROM section WHERE section='header'");
while($row=mysql_fetch_array($edit)) {
$bg2 = $row['bgcolor'];
}
$edit = mysql_query("SELECT bgcolor FROM section WHERE section='nav top'");
while($row=mysql_fetch_array($edit)) {
$bg3 = $row['bgcolor'];
}
$edit = mysql_query("SELECT bgcolor FROM section WHERE section='left'");
while($row=mysql_fetch_array($edit)) {
$bg4 = $row['bgcolor'];
}
$edit = mysql_query("SELECT bgcolor FROM section WHERE section='middle'");
while($row=mysql_fetch_array($edit)) {
$bg5 = $row['bgcolor'];
}
$edit = mysql_query("SELECT bgcolor FROM section WHERE section='right'");
while($row=mysql_fetch_array($edit)) {
$bg6 = $row['bgcolor'];
}
$edit = mysql_query("SELECT bgcolor FROM section WHERE section='footer'");
while($row=mysql_fetch_array($edit)) {
$bg7 = $row['bgcolor'];
}
$editcolour = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="colour" method="post" action="?page=secure&a=sitelayout&submit=colour&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Adjust Colour Scheme</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td width="22%">Body</td>
<td width="78%"><input name="bgbody" type="text" id="bgbody" value="$bgbody"></td>
</tr>
<tr>
<td width="22%">Container</td>
<td width="78%"><input name="bg1" type="text" id="bg1" value="$bg1"></td>
</tr>
<tr>
<td width="22%">Header</td>
<td width="78%"><input name="bg2" type="text" id="bg2" value="$bg2"></td>
</tr>
<tr>
<td width="22%">Top Nav</td>
<td width="78%"><input name="bg3" type="text" id="bg3" value="$bg3"></td>
</tr>
<tr>
<td width="22%">Left</td>
<td width="78%"><input name="bg4" type="text" id="bg4" value="$bg4"></td>
</tr>
<tr>
<td width="22%">Middle</td>
<td width="78%"><input name="bg5" type="text" id="bg5" value="$bg5"></td>
</tr>
<tr>
<td width="22%">Right</td>
<td width="78%"><input name="bg6" type="text" id="bg6" value="$bg6"></td>
</tr>
<tr>
<td width="22%">Footer</td>
<td width="78%"><input name="bg7" type="text" id="bg7" value="$bg7"></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$backupform = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="backupform" method="post" action="?page=secure&a=sitelayout&submit=backup&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Backup Current Settings</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td width="22%">Filename</td>
<td width="78%"><input name="backupfilename" type="text" id="backupfilename" value="$backupfilename"></td>
</tr>
<tr>
<td width="22%">Export</td>
<td width="78%">
<select name="exportformat" size="1">
<option value='1' selected >To Browser</option>
<option value='2'>To HDD DIR</option>
<option value='3' >To FTP</option>
</td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
$resetform = <<<HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<form name="resetform" method="post" action="?page=secure&a=sitelayout&submit=reset&update=1">
<table width="100%" border="0" cellpadding="4" cellspacing="0">
<tr>
<td width="22%">Reset Settings</td>
<td width="78%"><!----></td>
</tr>
<tr>
<td width="22%">Filename</td>
<td width="78%"><input name="backupname" type="text" id="bg" value="$resetname"></td>
</tr>
<tr>
<td width="22%">Date</td>
<td width="78%"><input name="resetdate" type="text" id="width" value="$resetdate"></td>
</tr>
<tr>
<td width="22%">Import</td>
<td width="78%">
<select name="importformat" size="1">
<option value='1' selected >From Browser</option>
<option value='2'>From HDD DIR</option>
<option value='3' >From FTP</option>
</td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Save Changes!"></td>
</tr>
</table>
</form>
<br>
HTML;
?><br><hr><?
//////////
if(isset($submit)) {
///
if($submit == 1) {
print $editlayout_1;
}
if($submit == 2) {
If(isset($update)) {
mysql_query("UPDATE section SET display='{$display_}',bgcolor='{$bg_}',width='{$width_}',height='{$height_}',top='{$padding_}',border_width='{$border_width_}' WHERE section='container'");
print 'Container Successfully Edited<br>';
}
print $editlayout_2;
}
if($submit == 3) {
If(isset($update)) {
mysql_query("UPDATE section SET display='{$display_}',bgcolor='{$bg_}',width='{$width_}',height='{$height_}',top='{$padding_}',border_width='{$border_width_}',border_bottom='{$border_bottom_}' WHERE section='header'");
print 'Header Successfully Edited<br>';
}
print $editlayout_3;
}
if($submit == 4) {
If(isset($update)) {
mysql_query("UPDATE section SET display='{$display_}',bgcolor='{$bg_}',width='{$width_}',height='{$height_}',top='{$padding_}',border_width='{$border_width_}',border_bottom='{$border_bottom_}' WHERE section='nav top'");
print 'Nav Top Successfully Edited<br>';
}
print $editlayout_4;
}
if($submit == 5) {
If(isset($update)) {
mysql_query("UPDATE section SET display='{$display_}',bgcolor='{$bg_}',height='{$height_}',width='{$width_}',top='{$padding_}',border_width='{$border_width_}' WHERE section='left'");
print 'left Successfully Edited<br>';
}
print $editlayout_5;
}
if($submit == 6) {
If(isset($update)) {
mysql_query("UPDATE section SET display='{$display_}',bgcolor='{$bg_}',width='{$width_}',height='{$height_}',top='{$padding_}',border_width='{$border_width_}' WHERE section='middle'");
print 'Middle Successfully Edited<br>';
}
print $editlayout_6;
}
if($submit == 7) {
If(isset($update)) {
mysql_query("UPDATE section SET display='{$display_}',bgcolor='{$bg_}',width='{$width_}',height='{$height_}',top='{$padding_}',border_width='{$border_width_}' WHERE section='right'");
print 'Right Successfully Edited<br>';
}
print $editlayout_7;
}
if($submit == 8) {
If(isset($update)) {
mysql_query("UPDATE section SET display='{$display_}',bgcolor='{$bg_}',width='{$width_}',height='{$height_}',top='{$padding_}',border_width='{$border_width_}',border_bottom='{$border_bottom_}' WHERE section='footer'");
print 'Footer Successfully Edited<br>';
}
print $editfeature;
}
if($submit == 9) {
If(isset($update)) {
///
if($contentarea_ == 1) {
mysql_query("UPDATE section SET show_content='1' WHERE section='middle'");
mysql_query("UPDATE section SET show_content='0' WHERE section='left'");
mysql_query("UPDATE section SET show_content='0' WHERE section='right'");
print 'Content section assigned: Middle <br>';
mysql_query("UPDATE section SET display='1' WHERE section='middle'");
}
if($contentarea_ == 2) {
mysql_query("UPDATE section SET show_content='0' WHERE section='middle'");
mysql_query("UPDATE section SET show_content='1' WHERE section='left'");
mysql_query("UPDATE section SET show_content='0' WHERE section='right'");
print 'Content section assigned: Left <br>';
mysql_query("UPDATE section SET display='1' WHERE section='left'");
}
if($contentarea_ == 3) {
mysql_query("UPDATE section SET show_content='0' WHERE section='middle'");
mysql_query("UPDATE section SET show_content='0' WHERE section='left'");
mysql_query("UPDATE section SET show_content='1' WHERE section='right'");
print 'Content section assigned: Right <br>';
mysql_query("UPDATE section SET display='1' WHERE section='right'");
}
if($navarea_ == 1) {
mysql_query("UPDATE section SET show_nav='1' WHERE section='nav top'");
mysql_query("UPDATE section SET show_nav='0' WHERE section='left'");
mysql_query("UPDATE section SET show_nav='0' WHERE section='right'");
print 'Nav section assigned: Top <br>';
}
if($navarea_ == 2) {
mysql_query("UPDATE section SET show_nav='0' WHERE section='nav top'");
mysql_query("UPDATE section SET show_nav='1' WHERE section='left'");
mysql_query("UPDATE section SET show_nav='0' WHERE section='right'");
print 'Nav section assigned: Left <br>';
}
if($navarea_ == 3) {
mysql_query("UPDATE section SET show_nav='0' WHERE section='nav top'");
mysql_query("UPDATE section SET show_nav='0' WHERE section='left'");
mysql_query("UPDATE section SET show_nav='1' WHERE section='right'");
print 'Nav section assigned: Right <br>';
}
////
}
}
if($submit == colour) {
If(isset($update)) {
mysql_query("UPDATE section SET bgcolor='{$bgbody_}' WHERE section='body'");
mysql_query("UPDATE section SET bgcolor='{$bg1_}' WHERE section='container'");
mysql_query("UPDATE section SET bgcolor='{$bg2_}' WHERE section='header'");
mysql_query("UPDATE section SET bgcolor='{$bg3_}' WHERE section='nav top'");
mysql_query("UPDATE section SET bgcolor='{$bg4_}' WHERE section='left'");
mysql_query("UPDATE section SET bgcolor='{$bg5_}' WHERE section='middle'");
mysql_query("UPDATE section SET bgcolor='{$bg6_}' WHERE section='right'");
mysql_query("UPDATE section SET bgcolor='{$bg7_}' WHERE section='footer'");
print 'Updated Colour Scheme<br>';
} else {
print $editcolour;
}
}
if($submit == border) {
print "updating borders...";
}
if($submit == spacing) {
If(isset($update)) {
mysql_query("UPDATE section SET top='{$spacing1_}' WHERE section='container'");
mysql_query("UPDATE section SET top='{$spacing2_}' WHERE section='nav top'");
mysql_query("UPDATE section SET top='{$spacing3_}' WHERE section='left'");
mysql_query("UPDATE section SET top='{$spacing4_}' WHERE section='footer'");
print 'Verticle Spacings Successfully Edited<br>';
} else {
print $editspacing;
}
}
if($submit == 13) {
///
If(isset($update)) {
print 'saved data to...<br>';
}
}
if($submit == upload) {
if ($_POST["action"]=="upload"){
$file=$HTTP_POST_FILES["file"];
$tmp_name=$file["tmp_name"];
$new_name=$_SERVER["DOCUMENT_ROOT"].'/upload/'.$file["name"];
move_uploaded_file($tmp_name, $new_name);
}
?>
<form enctype="multipart/form-data" action="?page=secure&a=sitelayout&submit=upload" method="post">
Choose a file:
<input type="file" name="file" />
<input type="hidden" name="MAX_FILE_SIZE" value="1048576" /><br />
<input type="hidden" name="action" value="upload" />
<input type="submit" name="submit" value="Upload!" />
</form>
<?
}
if($submit == reset) {
if($confirm == 1) {
print $resetform;
} else {
?>
Really reset?
<a href="?page=secure&a=sitelayout&submit=reset&confirm=1">Yes</a> || <a href="?">No</a><br><br>
<a href="?page=secure&a=sitelayout&submit=backup">backup first?</a><br>
<?
}
If(isset($update)) {
print "Failed backup";
print 'Reset data from $resetname_<br>';
}
}
if($submit == backup) {
print $backupform;
If(isset($update)) {
////////
define("AUTO_QUOTE",get_magic_quotes_gpc());
# configuration
$db_name = "$dbname";
$file = $backupfilename_; # blank to output to the screen
$create_tables = true; # add "CREATE TABLE" syntax at the begining of the script
$database = "$dbname";
function _dump_table($table_name){
$sql = mysql_query("select * from ". $table_name);
$dump = "";
while($row = mysql_fetch_assoc($sql)){
$keys = array_keys($row);
$val = array_values($row);
$len = count($keys);
$dump .= "INSERT INTO ".$table_name." (";
for($i=0;$i < $len;$i++){
$comma = ($i+1 != $len)?",":"";
$keys[$i] = (AUTO_QUOTE == 1)?addslashes($keys[$i]):$keys[$i];
$dump .= $keys[$i]. $comma;
}
$dump .= ") VALUES(";
for($i=0;$i < $len;$i++){
$comma = ($i+1 != $len)?"',":"'";
$val[$i] = (AUTO_QUOTE == 1)?addslashes($val[$i]):$val[$i];
$dump .= "'".$val[$i]. $comma;
}
$dump .= ");n";
}
return $dump;
}
function _create_table($table_name){
$sql = mysql_query("SHOW FIELDS FROM " . $table_name);
$dump = "CREATE TABLE " .$table_name ."(";
$i = 0;
while($row = mysql_fetch_assoc($sql)){
$attrib = array_values($row);
$keys = array_keys($row);
$len = count($attrib);
for($n=0;$n < $len;$n++){
$attrib[$n] = ($attrib[$n] == "PRI")?"PRIMARY KEY":$attrib[$n];
$attrib[$n] = ($attrib[$n] == "YES")?$keys[$n]:$attrib[$n];
$dump .= $attrib[$n] . " ";
}
$dump .= ($i+1 != $len)?",":"";
$i++;
}
$dump .= ");n";
return $dump;
}
function _get_tables($db){
$sql = mysql_query("SHOW TABLES FROM ".$db);
$i=0;
while($row = mysql_fetch_assoc($sql)){
list($tables[$i++]) = array_values($row);
}
return $tables;
}
function _comments(){
$c = "nn";
return $c;
}
#header("Content-type: text/plainrn");
$tables = _get_tables($database);
$add_table = "";
if($create_tables == true){
foreach($tables as $tab){
$addtable .= _create_table($tab);
}
$add_table .= "nn";
}
if(!empty($file)){
$fp = fopen($file,"w");
fwrite($fp,$addtable);
foreach($tables as $tab){
fwrite($fp,_dump_table($tab));
}
fwrite($fp,_comments());
fclose($fp);
echo "MySQL database saved into file ".$file;
}else{
echo $addtable;
foreach($tables as $tab){
echo _dump_table($tab);
}
echo _comments();
}
////
}
}
?>
<hr>
<a href="?page=secure&a=sitelayout">Edit Layout Menu</a><br>
<?
////
} else {
///////////
?>
Sections:<br>
<a href="?page=secure&a=sitelayout&submit=1">Edit Container</a> <br>
<a href="?page=secure&a=sitelayout&submit=2">Edit Header</a><br>
<a href="?page=secure&a=sitelayout&submit=3">Edit Top</a> <br>
<a href="?page=secure&a=sitelayout&submit=4">Edit Left</a> <br>
<a href="?page=secure&a=sitelayout&submit=5">Edit Middle</a> <br>
<a href="?page=secure&a=sitelayout&submit=6">Edit right</a> <br>
<a href="?page=secure&a=sitelayout&submit=7">Edit footer</a> <br>
<hr>
Settings:<br>
<a href="?page=secure&a=sitelayout&submit=8">Assign Sections</a> <br>
<a href="?page=secure&a=sitelayout&submit=colour">Edit Colours</a> <br>
<a href="?page=secure&a=sitelayout&submit=spacing">Edit Spacing</a> <br>
<br><br>
<a href="?page=secure&a=sitelayout&submit=upload">Upload file</a><br>
<a href="?page=secure&a=sit
Reply