Changeset 44 for trunk/admin

Timestamp:

01/10/06 21:23:00 (3 years ago)

Author:

michiel

Message:

added suggestion for order in new link form
Fixes #32

Files:

• trunk/admin/index.php (modified) (2 diffs)

trunk/admin/index.php

@@ -855 +855 @@
 function show_menuitems() {
         global $db;
-        /* get settings from db */
-        $settings = array();
-        $sql = "SELECT * FROM menulinks ORDER BY sortorder";
+        /* get max pos from db and add 1 for the default pos in new item */
+        $sql = "SELECT MAX(sortorder) FROM menulinks";
+        $res =& $db->query($sql);
+        $res->fetchInto($row);
+        $nextsort = (int)$row[0]+1;
+        $sql = "SELECT * FROM menulinks ORDER BY sortorder,linktitle";
         $res =& $db->query($sql);
         ?>
@@ -906 +909 @@
                                         <td>pos</td>
                                         <td>
-                                                <input style="width: 30px;" type="text" name="link[0][sortorder]" value="" />
+                                <input style="width: 30px;" type="text" name="link[0][sortorder]" value="<?=$nextsort?>" />
                                         </td>
                                 </tr></table>