[Blahzdns-cvs] blahzdns editzone.php,1.21,1.22
Status: Alpha
Brought to you by:
msroest
Menu
▾
▴
[Blahzdns-cvs] blahzdns editzone.php,1.21,1.22
|
From: Mike R. <ms...@us...> - 2004-05-01 03:19:56
|
Update of /cvsroot/blahzdns/blahzdns In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6853 Modified Files: editzone.php Log Message: Update primary zone editor to allow ascending and descending ordering of columns Index: editzone.php =================================================================== RCS file: /cvsroot/blahzdns/blahzdns/editzone.php,v retrieving revision 1.21 retrieving revision 1.22 diff -C2 -d -r1.21 -r1.22 *** editzone.php 8 Apr 2004 01:38:57 -0000 1.21 --- editzone.php 1 May 2004 03:19:44 -0000 1.22 *************** *** 390,402 **** if($zonetype == "Primary") { //Setup Output Table $output = "<H1>$myrow[0]</H1>\n<TABLE BORDER=\"1\">\n"; $output .= "<FORM NAME=\"EDITZONE\" ACTION=\"editzone.php\" METHOD=\"POST\">\n"; ! $output .= "<TR><TD>Record</TD><TD>TTL</TD><TD>Type</TD>\n"; ! $output .= "<TD>MX Priority</TD><TD>Value</TD><TD> </TD></TR>\n"; //Perform query $query = "SELECT R.RECORDID, R.ZONEID, R.RECORDTYPEID,R.RECORD,R.TTL,R.MXPRIORITY,R.VALUE,Z.NAME ZNAME,RT.NAME RTNAME\n"; ! $query .= " FROM RECORDS R,ZONES Z, RECORDTYPE RT WHERE R.ZONEID=$zoneid AND Z.ZONEID=R.ZONEID AND R.RECORDTYPEID=RT.RECORDTYPEID ORDER BY RT.SORTORDER,R.RECORD,R.MXPRIORITY\n"; $result = mysql_query($query,$db); if(userAuthToView($user,$zoneid,$zonetype)) { --- 390,421 ---- if($zonetype == "Primary") { + $sortColumn = $_GET['SORTCOLUMN']; + if(is_null($sortColumn)) { + $sortColumn=$_POST['SORTCOLUMN']; + } + $order=$_GET['ORDER']; + if(is_null($order)) { + $order=$_POST['ORDER']; + } + //Setup Output Table $output = "<H1>$myrow[0]</H1>\n<TABLE BORDER=\"1\">\n"; $output .= "<FORM NAME=\"EDITZONE\" ACTION=\"editzone.php\" METHOD=\"POST\">\n"; ! $output .="<INPUT TYPE=\"HIDDEN\" NAME=\"SORTCOLUMN\" VALUE=\"$sortColumn\">\n"; ! $output .= "<TR><TD>Record <a href=\"editzone.php?ZONEID=$zoneid&SORTCOLUMN=4&ORDER=ASC\"><IMG SRC=\"images/up.gif\" BORDER=\"0\"></a><a href=\"editzone.php?ZONEID=$zoneid&SORTCOLUMN=4&ORDER=DESC\"><IMG SRC=\"images/down.gif\" BORDER=\"0\"></a></TD>\n"; ! $output .= "<TD>TTL <a href=\"editzone.php?ZONEID=$zoneid&SORTCOLUMN=5&ORDER=ASC\"><IMG SRC=\"images/up.gif\" BORDER=\"0\"></a><a href=\"editzone.php?ZONEID=$zoneid&SORTCOLUMN=5&ORDER=DESC\"><IMG SRC=\"images/down.gif\" BORDER=\"0\"></a></TD>\n"; ! $output .= "<TD>Type <a href=\"editzone.php?ZONEID=$zoneid&SORTCOLUMN=3&ORDER=ASC\"><IMG SRC=\"images/up.gif\" BORDER=\"0\"></a><a href=\"editzone.php?ZONEID=$zoneid&SORTCOLUMN=3&ORDER=DESC\"><IMG SRC=\"images/down.gif\" BORDER=\"0\"></a></TD>\n"; ! $output .= "<TD>MX Priority <a href=\"editzone.php?ZONEID=$zoneid&SORTCOLUMN=6&ORDER=ASC\"><IMG SRC=\"images/up.gif\" BORDER=\"0\"></a><a href=\"editzone.php?ZONEID=$zoneid&SORTCOLUMN=6&ORDER=DESC\"><IMG SRC=\"images/down.gif\" BORDER=\"0\"></a></TD>\n"; ! $output .= "<TD>Value <a href=\"editzone.php?ZONEID=$zoneid&SORTCOLUMN=7&ORDER=ASC\"><IMG SRC=\"images/up.gif\" BORDER=\"0\"></a><a href=\"editzone.php?ZONEID=$zoneid&SORTCOLUMN=7&ORDER=DESC\"><IMG SRC=\"images/down.gif\" BORDER=\"0\"></a></TD><TD> </TD></TR>\n"; //Perform query $query = "SELECT R.RECORDID, R.ZONEID, R.RECORDTYPEID,R.RECORD,R.TTL,R.MXPRIORITY,R.VALUE,Z.NAME ZNAME,RT.NAME RTNAME\n"; ! $query .= " FROM RECORDS R,ZONES Z, RECORDTYPE RT WHERE R.ZONEID=$zoneid AND Z.ZONEID=R.ZONEID AND R.RECORDTYPEID=RT.RECORDTYPEID\n"; ! if(is_null($sortColumn) || $sortColumn =="" || $sortColumn=="3") { ! $query .= "ORDER BY RT.SORTORDER $order ,R.RECORD,R.MXPRIORITY \n"; ! } ! else { ! $query .= "ORDER BY $sortColumn $order,4,5 \n"; ! } $result = mysql_query($query,$db); if(userAuthToView($user,$zoneid,$zonetype)) { *************** *** 457,460 **** --- 476,480 ---- "<INPUT TYPE=\"HIDDEN\" NAME=\"ZONE\" VALUE=\"$zone\">\n". "<INPUT TYPE=\"HIDDEN\" NAME=\"ACTION\" VALUE=\"UPDATESEC\">\n". + "<INPUT TYPE=\"HIDDEN\" NAME=\"ZONETYPE\" VALUE=\"$zonetype\">\n". "</TD></TR></FORM></TABLE>\n"; echo $output; |
