query("SELECT sid,sort1 AS sort,orderid FROM {$dbprefix}sort WHERE grade='1' ORDER BY orderid asc");
$i=0;
while($row=$dblink->fetch_array($query))
{
?>
query("SELECT sid,sort2 AS sort,orderid FROM {$dbprefix}sort WHERE grade=2 AND sid1='$sort_row[sid]' ORDER BY orderid asc");
$i=0;
while($row=$dblink->fetch_array($query))
{
?>
query("SELECT sid,sort3 AS sort,orderid FROM {$dbprefix}sort WHERE grade='3' AND sid2='$sort_row[sid]' ORDER BY orderid asc");
$i=0;
while($row=$dblink->fetch_array($query))
{
?>
query("SELECT count(*) FROM {$dbprefix}sort WHERE grade=1");
$count1=$dblink->result($query,0);
$query=$dblink->query("SELECT sid,sort1 FROM {$dbprefix}sort WHERE grade=1 ORDER BY orderid");
$class1='new Array("0","'.$lang['sort_sort1'].'"),';
$c=1;
while($row1=$dblink->fetch_array($query))
{
$class1.='new Array("'.$row1[sid].'","'.$row1[sort1].'")';
if($c==$count1) $class1.="\n"; else $class1.=",\n";
$c++;
}
$query=$dblink->query("SELECT count(*) FROM {$dbprefix}sort WHERE grade=2");
$count2=$dblink->result($query,0);
$query=$dblink->query("SELECT sid,sid1,sort2 FROM {$dbprefix}sort WHERE grade=2 ORDER BY orderid");
$class2='';
$c=1;
while($row2=$dblink->fetch_array($query))
{
$class2.='new Array("'.$row2[sid1].'","'.$row2[sid].'","'.$row2[sort2].'")';
if($c==$count2) $class2.="\n"; else $class2.=",\n";
$c++;
}
?>
query("select * from {$dbprefix}sort where sid='$_GET[ClassLevel2]'");
$sort_row=$dblink->fetch_array($query);
$query=$dblink->query("INSERT INTO {$dbprefix}sort SET sid1='$sort_row[sid1]',sid2='$_GET[ClassLevel2]',sort1='$sort_row[sort1]',sort2='$sort_row[sort2]',sort3='$_GET[sortname]',grade='3',orderid='$_GET[orderid]'");
$sid=$dblink->insert_id();
header("location:admin.php?admin_action=sort_list&grade=3&sid=$_GET[ClassLevel2]");
}
elseif($_GET['ClassLevel1'])
{
$query=$dblink->query("select * from {$dbprefix}sort where sid='$_GET[ClassLevel1]'");
$sort_row=$dblink->fetch_array($query);
$query=$dblink->query("INSERT INTO {$dbprefix}sort SET sid1='$_GET[ClassLevel1]',sort1='$sort_row[sort1]',sort2='$_GET[sortname]',grade='2',orderid='$_GET[orderid]'");
$sid=$dblink->insert_id();
header("location:admin.php?admin_action=sort_list&grade=2&sid=$_GET[ClassLevel1]");
}
else
{
$query=$dblink->query("INSERT INTO {$dbprefix}sort SET sort1='$_GET[sortname]',grade='1',orderid='$_GET[orderid]'");
$sid=$dblink->insert_id();
header("location:admin.php?admin_action=sort_list&grade=1");
}
}
elseif($_GET['admin_action']=='sort_edit')
{
if($grade==1)
{
$query=$dblink->query("SELECT sort1 AS sort,orderid FROM {$dbprefix}sort WHERE sid='$_GET[sid]'");
}
elseif($grade==2)
{
$query=$dblink->query("SELECT sort2 AS sort,orderid FROM {$dbprefix}sort WHERE sid='$_GET[sid]'");
}
elseif($grade==3)
{
$query=$dblink->query("SELECT sort3 AS sort,orderid FROM {$dbprefix}sort WHERE sid='$_GET[sid]'");
}
else
{
exit("error");
}
$sort_row=$dblink->fetch_array($query);
admin_header();
?>
query("UPDATE {$dbprefix}sort SET sort1='$_GET[sortname]',orderid='$_GET[orderid]' WHERE sid=$_GET[sid]");
$dblink->query("UPDATE {$dbprefix}sort SET sort1='$_GET[sortname]' WHERE sid1=$_GET[sid] AND grade=2");
$dblink->query("UPDATE {$dbprefix}sort SET sort1='$_GET[sortname]' WHERE sid2=$_GET[sid] AND grade=3");
header("location:admin.php?admin_action=sort_list");
}
elseif($_GET['grade']==2)
{
$dblink->query("UPDATE {$dbprefix}sort SET sort2='$_GET[sortname]',orderid='$_GET[orderid]' WHERE sid=$_GET[sid]");
$dblink->query("UPDATE {$dbprefix}sort SET sort2='$_GET[sortname]' WHERE sid2=$_GET[sid] AND grade=3");
$query=$dblink->query("SELECT sid1 FROM {$dbprefix}sort WHERE sid='$_GET[sid]'");
$sort_row=$dblink->fetch_array($query);
header("location:admin.php?admin_action=sort_list&grade=2&sid=$sort_row[sid1]");
}
elseif($_GET['grade']==3)
{
$dblink->query("UPDATE {$dbprefix}sort SET sort3='$_GET[sortname]',orderid='$_GET[orderid]' WHERE sid=$_GET[sid]");
$query=$dblink->query("SELECT sid2 FROM {$dbprefix}sort WHERE sid=$_GET[sid]");
$sort_row=$dblink->fetch_array($query);
header("location:admin.php?admin_action=sort_list&grade=3&sid=$sort_row[sid2]");
}
else
{
exit("error");
}
}
elseif($_GET['admin_action']=='sort_join')
{
if($grade==1)
{
$query=$dblink->query("SELECT sid,sort1 AS sort FROM {$dbprefix}sort WHERE grade='1' AND sid!='$_GET[sid]' ORDER BY orderid asc");
}
elseif($grade==2)
{
$query=$dblink->query("SELECT sid1 FROM {$dbprefix}sort WHERE sid='$_GET[sid]'");
$sid1=$dblink->result($query,0);
$query=$dblink->query("SELECT sid,sort2 AS sort FROM {$dbprefix}sort WHERE grade='2' AND sid1='$sid1' AND sid!='$_GET[sid]' ORDER BY orderid asc");
}
elseif($grade==3)
{
$query=$dblink->query("SELECT sid2 FROM {$dbprefix}sort WHERE sid='$_GET[sid]'");
$sid2=$dblink->result($query,0);
$query=$dblink->query("SELECT sid,sort3 AS sort FROM {$dbprefix}sort WHERE grade='3' AND sid2='$sid2' AND sid!='$_GET[sid]' ORDER BY orderid asc");
}
else
{
exit("error");
}
admin_header();
?>
query("SELECT * FROM {$dbprefix}sort WHERE sid='$_GET[jointosid]'");
$jointo=$dblink->fetch_array($query);
if($_GET['grade']==1)
{
$dblink->query("UPDATE {$dbprefix}ques SET sid1='$jointo[sid]' WHERE sid1='$_GET[sid]'");
$dblink->query("UPDATE {$dbprefix}sort SET sid1='$jointo[sid]',sort1='$jointo[sort1]' WHERE grade='2' AND sid1='$_GET[sid]'");
$dblink->query("UPDATE {$dbprefix}sort SET sid1='$jointo[sid]',sort1='$jointo[sort1]' WHERE grade='3' AND sid1='$_GET[sid]'");
$dblink->query("DELETE FROM {$dbprefix}sort WHERE grade='1' AND sid='$_GET[sid]'");
header("location:admin.php?admin_action=sort_list");
}
elseif($_GET['grade']==2)
{
$dblink->query("UPDATE {$dbprefix}ques SET sid2='$jointo[sid]' WHERE sid2='$_GET[sid]'");
$dblink->query("UPDATE {$dbprefix}sort SET sid2='$jointo[sid]',sort2='$jointo[sort2]' WHERE grade='3' AND sid2='$_GET[sid]'");
$dblink->query("DELETE FROM {$dbprefix}sort WHERE grade='2' AND sid='$_GET[sid]'");
header("location:admin.php?admin_action=sort_list&grade=2&sid=$jointo[sid1]");
}
elseif($_GET['grade']==3)
{
$dblink->query("UPDATE {$dbprefix}ques SET sid3='$jointo[sid]' WHERE sid3='$_GET[sid]'");
$dblink->query("DELETE FROM {$dbprefix}sort WHERE grade='3' AND sid='$_GET[sid]'");
header("location:admin.php?admin_action=sort_list&grade=3&sid=$jointo[sid2]");
}
else
{
exit("error");
}
}
elseif($_GET['admin_action']=='sort_del')
{
$sid=intval($_GET['sid']);
$supersid=intval($_GET['supersid']);
switch($grade)
{
case 1:
$dblink->query("DELETE FROM {$dbprefix}sort WHERE sid=$sid");
$dblink->query("DELETE FROM {$dbprefix}sort WHERE sid1=$sid");
$dblink->query("DELETE FROM {$dbprefix}ques WHERE sid1=$sid");
break;
case 2:
$dblink->query("DELETE FROM {$dbprefix}sort WHERE sid=$sid");
$dblink->query("DELETE FROM {$dbprefix}sort WHERE sid2=$sid");
$dblink->query("DELETE FROM {$dbprefix}ques WHERE sid2=$sid");
break;
case 3:
$dblink->query("DELETE FROM {$dbprefix}sort WHERE sid=$sid");
$dblink->query("DELETE FROM {$dbprefix}ques WHERE sid3=$sid");
break;
}
header("location:admin.php?admin_action=sort_list&grade=$grade&sid=$supersid");
}
else
{
echo 'action error';
}
?>