Просмотр поста

case 'up' :
////////////////////////////////////////////////////////////
// Перемещение на одну позицию вверх //
////////////////////////////////////////////////////////////
if ($id) {
$req = mysql_query("SELECT * FROM `forum` WHERE `id` = '$id' LIMIT 1");
if (mysql_num_rows($req)) {
$res1 = mysql_fetch_assoc($req);
$sort = $res1['realid'];
$req = mysql_query("SELECT * FROM `forum` WHERE `type` = '" . ($res1['type'] == 'f' ? 'f' : 'r') . "' AND `realid` < '$sort' ORDER BY `realid` DESC LIMIT 1");
if (mysql_num_rows($req)) {
$res = mysql_fetch_assoc($req);
$id2 = $res['id'];
$sort2 = $res['realid'];
mysql_query("UPDATE `forum` SET `realid` = '$sort2' WHERE `id` = '$id'");
mysql_query("UPDATE `forum` SET `realid` = '$sort' WHERE `id` = '$id2'");
}
}
}
header('Location: index.php?act=mod_forum&mod=cat' . ($res1['type'] == 'r' ? '&id=' . $res1['refid'] : ''));
break;


case 'down' :
////////////////////////////////////////////////////////////
// Перемещение на одну позицию вниз //
////////////////////////////////////////////////////////////
if ($id) {
$req = mysql_query("SELECT * FROM `forum` WHERE `id` = '$id' LIMIT 1");
if (mysql_num_rows($req)) {
$res1 = mysql_fetch_assoc($req);
$sort = $res1['realid'];
$req = mysql_query("SELECT * FROM `forum` WHERE `type` = '" . ($res1['type'] == 'f' ? 'f' : 'r') . "' AND `realid` > '$sort' ORDER BY `realid` ASC LIMIT 1");
if (mysql_num_rows($req)) {
$res = mysql_fetch_assoc($req);
$id2 = $res['id'];
$sort2 = $res['realid'];
mysql_query("UPDATE `forum` SET `realid` = '$sort2' WHERE `id` = '$id'");
mysql_query("UPDATE `forum` SET `realid` = '$sort' WHERE `id` = '$id2'");
}
}
}
header('Location: index.php?act=mod_forum&mod=cat' . ($res1['type'] == 'r' ? '&id=' . $res1['refid'] : ''));
break;