Файл: AdmPanel/link.php
Строк: 670
<?php
$title = 'Панель управления сайтом - Управление ссылками';
$str='link';
require_once('Sys/head.php');
reg();
level(2);
echo'<div id="st21">';
if($cache['cacheMenu'] > 0)
{
if(file_exists('../Cache/cacheMenu1.cache')) unlink('../Cache/cacheMenu1.cache');
if(file_exists('../Cache/cacheMenu2.cache')) unlink('../Cache/cacheMenu2.cache');
if(file_exists('../Cache/cacheMenu3.cache')) unlink('../Cache/cacheMenu3.cache');
if(file_exists('../Cache/cacheMenu4.cache')) unlink('../Cache/cacheMenu4.cache');
if(file_exists('../Cache/cacheMenu5.cache')) unlink('../Cache/cacheMenu5.cache');
if(file_exists('../Cache/cacheMenu6.cache')) unlink('../Cache/cacheMenu6.cache');
if(file_exists('../Cache/cacheMenu7.cache')) unlink('../Cache/cacheMenu7.cache');
if(file_exists('../Cache/cacheMenu8.cache')) unlink('../Cache/cacheMenu8.cache');
if(file_exists('../Cache/cacheMenu9.cache')) unlink('../Cache/cacheMenu9.cache');
}
switch($act)
{
default:
echo'
<div class="st2"> <h2 class="titlev">Управление ссылками</h2>
</div>';
$links = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '0' ORDER BY `position`");
if($links->num_rows > 0)
{
echo'<div class="st2">
<h2 class="title"></h2><div class="middle_back">';
echo '
<table class="class1">
<tr class="class2">
<th class="class3">Иконка</th>
<th class="class3">Ссылка</th>
<th class="class3">Место<br /> отображения</th>
<th class="class3">Позиция</th>
<th class="class3">Действие</th>
</tr>
';
$mesto='Не отображается';
$mesto1='Верх 1';
$mesto2='Верх 2';
$mesto3='Низ 1';
$mesto4='Низ 2';
$mesto5='Низ 3';
$mesto6='Виджет 1';
$mesto7='Виджет 2';
$mesto8='Виджет 3';
$mesto9='Виджет 4';
while($link = $links->fetch_array())
{
if($link['mest']==0){$mest=$mesto;} if($link['mest']==1){$mest=$mesto1;} if($link['mest']==2){$mest=$mesto2;} if($link['mest']==3){$mest=$mesto3;} if($link['mest']==4){$mest=$mesto4;}
if($link['mest']==5){$mest=$mesto5;} if($link['mest']==6){$mest=$mesto6;} if($link['mest']==7){$mest=$mesto7;} if($link['mest']==8){$mest=$mesto8;} if($link['mest']==9){$mest=$mesto9;}
echo ' <tr class="class2">
<td class="class4">';
if(!empty($link['img']))
{
echo'<img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/'.$link['img'].'"> ';
}
echo'</td>';
echo'
<td class="class4"><a href="'.$link['url'].'" title = "'.$link['about'].'"><b>'.bbCodes(nl2br($link['name'])).'</b></a></td>
<td class="class4">'.$mest.'</td>
<td class="class4"><b>'.$link['position'].'</b> ';
if($link['position']>0)
{
echo'<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/linkEdit/up/'.$link['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/up.png"></a>';
}
echo'<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/linkEdit/down/'.$link['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/down.png"></a>
</td>
<td class="class4">
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/edit/'.$link['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/edit.png"></a>
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/delete/'.$link['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/delete.png"></a>
</td></tr>';
$links1 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '".$link['id']."' ORDER BY `position`");
if($links1->num_rows > 0)
{
while($link1 = $links1->fetch_array())
{
if($link1['mest']==0){$mest1=$mesto;} if($link1['mest']==1){$mest1=$mesto1;} if($link1['mest']==2){$mest1=$mesto2;} if($link1['mest']==3){$mest1=$mesto3;} if($link1['mest']==4){$mest1=$mesto4;}
if($link1['mest']==5){$mest1=$mesto5;} if($link1['mest']==6){$mest1=$mesto6;} if($link1['mest']==7){$mest1=$mesto7;} if($link1['mest']==8){$mest1=$mesto8;} if($link1['mest']==9){$mest1=$mesto9;}
echo ' <tr class="class2">
<td class="class4">';
if(!empty($link1['img']))
{
echo'<img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/'.$link1['img'].'"> ';
}
echo'</td>';
echo'
<td class="class4"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/ms.png"> <a href="'.$link1['url'].'" title = "'.$link1['about'].'">'.bbCodes(nl2br($link1['name'])).'</a></td>
<td class="class4">'.$mest1.'</td>
<td class="class4"><b>'.$link1['position'].'</b> ';
if($link1['position']>0)
{
echo'<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/linkEdit/up/'.$link1['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/up.png"></a>';
}
echo'<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/linkEdit/down/'.$link1['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/down.png"></a>
</td>
<td class="class4">
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/edit/'.$link1['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/edit.png"></a>
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/delete/'.$link1['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/delete.png"></a>
</td></tr>';
$links2 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '".$link1['id']."' ORDER BY `position`");
if($links2->num_rows > 0)
{
while($link2 = $links2->fetch_array())
{
if($link2['mest']==0){$mest2=$mesto;} if($link2['mest']==1){$mest2=$mesto1;} if($link2['mest']==2){$mest2=$mesto2;} if($link2['mest']==3){$mest2=$mesto3;} if($link2['mest']==4){$mest2=$mesto4;}
if($link2['mest']==5){$mest2=$mesto5;} if($link2['mest']==6){$mest2=$mesto6;} if($link2['mest']==7){$mest2=$mesto7;} if($link2['mest']==8){$mest2=$mesto8;} if($link2['mest']==9){$mest2=$mesto9;}
echo ' <tr class="class2">
<td class="class4">';
if(!empty($link2['img']))
{
echo'<img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/'.$link2['img'].'"> ';
}
echo'</td>';
echo' <td class="class4"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/ms.png"> <img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/ms.png"> <a href="'.$link2['url'].'" title = "'.$link2['about'].'">'.bbCodes(nl2br($link2['name'])).'</a></td>
<td class="class4">'.$mest2.'</td>
<td class="class4"><b>'.$link2['position'].'</b> ';
if($link2['position']>0)
{
echo'<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/linkEdit/up/'.$link2['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/up.png"></a>';
}
echo'<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/linkEdit/down/'.$link2['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/down.png"></a>
</td>
<td class="class4">
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/edit/'.$link2['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/edit.png"></a>
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/delete/'.$link2['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/delete.png"></a>
</td></tr>';
$links3 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '".$link2['id']."' ORDER BY `position`");
if($links3->num_rows > 0)
{
while($link3 = $links3->fetch_array())
{
if($link3['mest']==0){$mest3=$mesto;} if($link3['mest']==1){$mest3=$mesto1;} if($link3['mest']==2){$mest3=$mesto2;} if($link3['mest']==3){$mest3=$mesto3;} if($link3['mest']==4){$mest3=$mesto4;}
if($link3['mest']==5){$mest3=$mesto5;} if($link3['mest']==6){$mest3=$mesto6;} if($link3['mest']==7){$mest3=$mesto7;} if($link3['mest']==8){$mest3=$mesto8;} if($link3['mest']==9){$mest3=$mesto9;}
echo ' <tr class="class2">
<td class="class4">';
if(!empty($link3['img']))
{
echo'<img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/'.$link3['img'].'"> ';
}
echo'</td>';
echo'
<td class="class4"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/ms.png"> <img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/ms.png"> <img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/ms.png"> <a href="'.$link3['url'].'" title = "'.$link3['about'].'">'.bbCodes(nl2br($link3['name'])).'</a></td>
<td class="class4">'.$mest3.'</td>
<td class="class4"><b>'.$link3['position'].'</b> ';
if($link3['position']>0)
{
echo'<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/linkEdit/up/'.$link3['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/up.png"></a>';
}
echo'<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/linkEdit/down/'.$link3['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/down.png"></a>
</td>
<td class="class4">
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/edit/'.$link3['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/edit.png"></a>
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/delete/'.$link3['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/delete.png"></a>
</td></tr>';
$links4 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '".$link3['id']."' ORDER BY `position`");
if($links4->num_rows > 0)
{
while($link4 = $links4->fetch_array())
{
if($link4['mest']==0){$mest4=$mesto;} if($link4['mest']==1){$mest4=$mesto1;} if($link4['mest']==2){$mest4=$mesto2;} if($link4['mest']==3){$mest4=$mesto3;} if($link4['mest']==4){$mest4=$mesto4;}
if($link4['mest']==5){$mest4=$mesto5;} if($link4['mest']==6){$mest4=$mesto6;} if($link4['mest']==7){$mest4=$mesto7;} if($link4['mest']==8){$mest4=$mesto8;} if($link4['mest']==9){$mest4=$mesto9;}
echo ' <tr class="class2">
<td class="class4">';
if(!empty($link4['img']))
{
echo'<img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/'.$link4['img'].'"> ';
}
echo'</td>';
echo'
<td class="class4"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/ms.png"> <img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/ms.png"> <img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/ms.png"> <img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/ms.png"> <a href="'.$link4['url'].'" title = "'.$link4['about'].'">'.bbCodes(nl2br($link4['name'])).'</a></td>
<td class="class4">'.$mest4.'</td>
<td class="class4"><b>'.$link4['position'].'</b> ';
if($link4['position']>0)
{
echo'<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/linkEdit/up/'.$link4['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/up.png"></a>';
}
echo'<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/linkEdit/down/'.$link4['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/down.png"></a>
</td>
<td class="class4">
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/edit/'.$link4['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/edit.png"></a>
<a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/delete/'.$link4['id'].'"><img src="http://'.$_SERVER['HTTP_HOST'].'/images/ico/delete.png"></a>
</td></tr>';
}
}
}
}
}
}
}
}
}
echo '</table></div></div>';
}
else
{
echo '<div class="st2">
<h2 class="title"></h2><div class="middle_back">';
echo 'Ссылок нет<br/>';
echo '</div></div>';
}
break;
case 'add':
if(!isset($_POST['ok']))
{ echo '
<div class="st2">
<h2 class="title">Добавить ссылку</h2>
<div class="middle_back">';
echo'
<form action="" name="post" method="post" onsubmit="return checkForm(this)">
';
echo '<div id="2" style="display:none;"> ';
//$razm = '1'; // если нужна большая панель ВВ то должно быть 1
$setid = '222'; // id ссылки раскрывающего меню выбора цвета
$inputNamebb = 'name'; // name формы ввода
require_once('../javascript/panelbb.php');
echo'</div>';
echo'Имя ссылки: ';
echo"<a href="javascript:ShowOrHide('2');">Показать BB коды</a><br />";
echo" <textarea class="form" name="name" cols="73" rows="1" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);"></textarea><br /><br />n"; //echo'<input type="text" class="form" name="name" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);"> ';
echo'Адрес ссылки(URL):<br/>
<textarea class="form" name="url" cols="73" rows="1"></textarea><br/><br />
Описание ссылки:<br />';
echo' <textarea class="form" name="about" cols="73" rows="2"></textarea><br/><br /> ';
echo '<div id="1" style="display:none;">';
$inputName = 'img'; // name формы ввода
require_once('../javascript/icon.php');
echo'<br /></div>';
echo'Иконка ссылки: ';
echo"<a href="javascript:ShowOrHide('1');">Показать иконки</a><br />";
echo"<textarea class="form" name="img" cols="73" rows="1" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);"></textarea><br/><br />";
$links = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '0' ORDER BY `position`");
if($links->num_rows > 0)
{ echo'Родитель:<br/>
<select name="uid">';
echo '<option value="0">Обычная ссылка</option>';
while($link = $links->fetch_array())
{
echo '<option value="'.$link['id'].'">'.bbCodes(nl2br($link['name'])).'</option>';
$links1 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '".$link['id']."' ORDER BY `position`");
if($links1->num_rows > 0)
{
while($link1 = $links1->fetch_array())
{
echo '<option value="'.$link1['id'].'"> - '.bbCodes(nl2br($link1['name'])).'</option>';
$links2 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '".$link1['id']."' ORDER BY `position`");
if($links2->num_rows > 0)
{
while($link2 = $links2->fetch_array())
{
echo '<option value="'.$link2['id'].'"> - - '.bbCodes(nl2br($link2['name'])).'</option>';
$links3 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '".$link2['id']."' ORDER BY `position`");
if($links3->num_rows > 0)
{
while($link3 = $links3->fetch_array())
{
echo '<option value="'.$link3['id'].'"> - - - '.bbCodes(nl2br($link3['name'])).'</option>';
}
}
}
}
}
}
}
echo '</select><br/><br/>';
}
echo 'Место отображения:<br/>';
echo '<select name="mest">';
echo '<option value="0">Не отображать</option>';
echo '<option value="1">Верх 1</option>';
echo '<option value="2">Верх 2</option>';
echo '<option value="3">Низ 1</option>';
echo '<option value="4">Низ 2</option>';
echo '<option value="5">Низ 3</option>';
echo '<option value="6">Виджет 1</option>';
echo '<option value="7">Виджет 2</option>';
echo '<option value="8">Виджет 3</option>';
echo '<option value="9">Виджет 4</option>';
echo'</select><br /><br />
Позиция (max.100):<br/>
<input type="text" class="form" name="position" maxlength="3" value=""/><br/><br />
<input name="ok" type="submit" class="button" value="Добавить" />
</form></div>
</div>
';
}
else
{
$name = filter($_POST['name']);
$url = filter($_POST['url']);
$about = filter($_POST['about']);
$img = filter($_POST['img']);
$uid = intval($_POST['uid']);
$mest = intval($_POST['mest']);
$position = intval($_POST['position']);
$error = '';
if(empty($name) OR empty($mest) OR empty($url))
{
$error .= 'Не заполнены поля.<br/>';
}
if(mb_strlen($name) > 1000)
{
$error .= 'Поле "Имя ссылки" больше 1000 символов.<br/>';
}
if(mb_strlen($about) > 50000)
{
$error .= 'Поле "Описание ссылки" больше 50000 символов.<br/>';
}
if(!empty($error))
{ echo'<div class="st2">
<h2 class="title"></h2>
<div class="middle_back">';
echo '<div class="error">';
echo 'В результате заполнения полей , выявились ошибки:<br/>';
echo $error;
echo '<br /><a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/add">Назад</a><br/>';
echo '</div>';
echo '</div></div>';
}
else
{
$mysqli->query("INSERT INTO `".$prefix."link` SET `name` = '".$name."', `url` = '".$url."', `uid` = '".$uid."', `about` = '".$about."', `img` = '".$img."', `mest` = '".$mest."', `position` = '".$position."'");
echo '<div class="st2">
<h2 class="title"></h2>
<div class="middle_back">';
echo 'Ссылка успешно добавлена! <br/>';
echo '</div></div>';
}
}
break;
case 'delete':
if($id)
{ $mysqli->query("DELETE FROM `".$prefix."link` WHERE `id` = '".$id."'");
echo '<div class="st2">
<h2 class="title"></h2>
<div class="middle_back">';
echo 'Ссылка успешно удалена.<br/>';
echo '</div></div>';
}
else
{
echo '<div class="st2">
<h2 class="title"></h2>
<div class="middle_back">';
echo 'Не выбрана запись.<br/>';
echo '</div></div>';
}
break;
case 'edit':
$isset = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `id` = '".$id."'");
if($isset->num_rows > 0)
{
$lin = $isset->fetch_assoc();
echo '<div class="st2">
<h2 class="title">Изменение ссылки</h2>
';
if(!isset($_POST['ok']))
{
echo '
<div class="middle_back">
<form action="" method="post" name="post"> ';
echo '<div id="2" style="display:none;"> ';
//$razm = '1'; // если нужна большая панель ВВ то должно быть 1
$setid = '222'; // id ссылки раскрывающего меню выбора цвета
$inputNamebb = 'name'; // name формы ввода
require_once('../javascript/panelbb.php');
echo'</div>';
echo'Имя ссылки: ';
echo"<a href="javascript:ShowOrHide('2');">Показать BB коды</a><br />";
echo" <textarea class="form" name="name" cols="73" rows="1" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);">".$lin['name']."</textarea><br /><br />n"; //echo'<input type="text" class="form" name="name" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);"> ';
echo'
Адрес ссылки(URL):<br/>
<input type="text" class="form" name="url" value="'.$lin['url'].'"><br /><br />
Описание ссылки:<br />
<textarea class="form" name="about" cols="73" rows="5">'.$lin['about'].'</textarea><br/><br /> ';
echo '<div id="1" style="display:none;">';
$inputName = 'img'; // name формы ввода
require_once('../javascript/icon.php');
echo'<br /></div>';
echo'Иконка ссылки: ';
echo"<a href="javascript:ShowOrHide('1');">Показать иконки</a><br />";
echo"<textarea class="form" name="img" cols="73" rows="1" onselect="storeCaret(this);" onclick="storeCaret(this);" onkeyup="storeCaret(this);">".$lin['img']."</textarea><br/><br />";
$links = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '0' ORDER BY `position`");
if($links->num_rows > 0)
{ echo'Родитель:<br/>
<select name="uid">';
echo '<option value="0">Обычная ссылка</option>';
while($link = $links->fetch_array())
{
$selected = ($link['id'] == $lin['uid']) ? ' selected="selected"' : '';
echo '<option value="'.$link['id'].'"'.$selected.'>'.bbCodes(nl2br($link['name'])).'</option>';
$links1 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '".$link['id']."' ORDER BY `position`");
if($links1->num_rows > 0)
{
while($link1 = $links1->fetch_array())
{ $selected = ($link1['id'] == $lin['uid']) ? ' selected="selected"' : '';
echo '<option value="'.$link1['id'].'"'.$selected.'> - '.bbCodes(nl2br($link1['name'])).'</option>';
$links2 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '".$link1['id']."' ORDER BY `position`");
if($links2->num_rows > 0)
{
while($link2 = $links2->fetch_array())
{ $selected = ($link2['id'] == $lin['uid']) ? ' selected="selected"' : '';
echo '<option value="'.$link2['id'].'"'.$selected.'> - - '.bbCodes(nl2br($link2['name'])).'</option>';
$links3 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `uid` = '".$link2['id']."' ORDER BY `position`");
if($links3->num_rows > 0)
{
while($link3 = $links3->fetch_array())
{ $selected = ($link3['id'] == $lin['uid']) ? ' selected="selected"' : '';
echo '<option value="'.$link3['id'].'"'.$selected.'> - - - '.bbCodes(nl2br($link3['name'])).'</option>';
}
}
}
}
}
}
}
echo '</select><br/><br/>';
}
echo 'Место отображения:<br/>';
echo '<select name="mest">';
if($lin['mest']==0){$select0 = 'selected="selected"';}
if($lin['mest']==1){$select1 = 'selected="selected"';}
if($lin['mest']==2){$select2 = 'selected="selected"';}
if($lin['mest']==3){$select3 = 'selected="selected"';}
if($lin['mest']==4){$select4 = 'selected="selected"';}
if($lin['mest']==5){$select5 = 'selected="selected"';}
if($lin['mest']==6){$select6 = 'selected="selected"';}
if($lin['mest']==7){$select7 = 'selected="selected"';}
if($lin['mest']==8){$select8 = 'selected="selected"';}
if($lin['mest']==9){$select9 = 'selected="selected"';}
echo '<option value="0"'.$select0.'>Не отображать</option><br/>';
echo '<option value="1"'.$select1.'>Верх 1</option><br/>';
echo '<option value="2"'.$select2.'>Верх 2</option><br/>';
echo '<option value="3"'.$select3.'>Низ 1</option><br/>';
echo '<option value="4"'.$select4.'>Низ 2</option><br/>';
echo '<option value="5"'.$select5.'>Низ 3</option><br/>';
echo '<option value="6"'.$select6.'>Виджет 1</option><br/>';
echo '<option value="7"'.$select7.'>Виджет 2</option><br/>';
echo '<option value="8"'.$select8.'>Виджет 3</option><br/>';
echo '<option value="9"'.$select9.'>Виджет 4</option><br/>';
echo'</select><br /><br />
Позиция (max.100):<br/>
<input type="text" class="form" name="position" maxlength="3" value="'.$lin['position'].'"/><br/><br />
<input name="ok" type="submit" class="button" value="Изменить" />
</form>
</form>';
echo'</div></div>';
}
else
{
$name = filter($_POST['name']);
$url = filter($_POST['url']);
$about = filter($_POST['about']);
$img = filter($_POST['img']);
$uid = intval($_POST['uid']);
$mest = intval($_POST['mest']);
$position = intval($_POST['position']);
$error = '';
if(empty($name) OR empty($url))
{
$error .= 'Не заполнены поля.<br/>';
}
if(!empty($error))
{ echo'
<div class="middle_back">';
echo '<div class="error">';
echo 'В результате заполнения полей , выявились ошибки:<br/>';
echo $error;
echo '<br /><a href="http://'.$_SERVER['HTTP_HOST'].'/controlPanel/link/add">Назад</a><br/>';
echo '</div>';
echo '</div></div>';
}
else
{
if($uid!= $id)
{
$l = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `id` = '".$uid."'");
if($l->num_rows > 0)
{ $li = $l->fetch_array();
if($li['uid'] == $id)
{
$mysqli->query("UPDATE `".$prefix."link` SET `uid` = '".$lin['uid']."' WHERE `uid` = '".$li['uid']."'");
}
else
{
$l1 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `id` = '".$li['uid']."'");
if($l1->num_rows > 0)
{ $li1 = $l1->fetch_array();
if($li1['uid'] == $id)
{
$mysqli->query("UPDATE `".$prefix."link` SET `uid` = '".$lin['uid']."' WHERE `uid` = '".$li1['uid']."'");
}
else{
$l2 = $mysqli->query("SELECT * FROM `".$prefix."link` WHERE `id` = '".$li1['uid']."'");
if($l2->num_rows > 0)
{ $li2 = $l2->fetch_array();
if($li2['uid'] == $id)
{
$mysqli->query("UPDATE `".$prefix."link` SET `uid` = '".$lin['uid']."' WHERE `uid` = '".$li2['uid']."'");
}
else{
}
}
}
}
}
}
$mysqli->query("UPDATE `".$prefix."link` SET `name` = '".$name."', `url` = '".$url."', `uid` = '".$uid."', `about` = '".$about."', `img` = '".$img."', `mest` = '".$mest."', `position` = '".$position."' WHERE `id` = '".$id."'");
}
echo '
<div class="middle_back">';
echo 'Ссылка успешно изменена! <br/>';
echo '</div></div>';
}
}
} else
{
echo '<div class="st2">
<h2 class="title"></h2>
<div class="middle_back"><div class="error">';
echo 'Не выбрана ссылка.<br/>';
echo '</div></div></div>';
}
break;
}
echo '<br /></div>';
?>