Changeset 1714 in ExiteCMS for branches/PLi-Fusion/administration/modules.php

Timestamp:

08/28/08 18:20:38 (4 years ago)

Author:

hverton

Message:

Merged trunk revisions 1706:1713 into the PLi-Fusion branch

File:

• branches/PLi-Fusion/administration/modules.php (modified) (2 diffs)

branches/PLi-Fusion/administration/modules.php

@@ -211 +211 @@
                     $mod_search['title'] = isset($mod_search['title']) ? $mod_search['title'] : ("Search: ".$mod_search['name']);
                     $mod_search['version'] = isset($mod_search['version']) ? $mod_search['version'] : $mod_version;
+                    // get the max searchorder
+                    $result = dbquery("SELECT max(search_order) as max FROM ".$db_prefix."search");
+                    if ($result) {
+                        $data = dbarray($result);
+                        $max = $data['max'] + 1;
+                    } else {
+                        $max = 1;
+                    }
                     // add it to the search table
-                    $result = dbquery("INSERT INTO ".$db_prefix."search (search_mod_id, search_name, search_title, search_version, search_fulltext, search_visibility) 
-                        VALUES ('".$id."', '".$mod_search['name']."', '".$mod_search['title']."', '".$mod_search['version']."',  '".$mod_search['fulltext']."', '".$mod_search['visibility']."')");
+                    $result = dbquery("INSERT INTO ".$db_prefix."search (search_mod_id, search_name, search_title, search_version, search_fulltext, search_visibility, search_order) 
+                        VALUES ('".$id."', '".$mod_search['name']."', '".$mod_search['title']."', '".$mod_search['version']."',  '".$mod_search['fulltext']."', '".$mod_search['visibility']."', ".$max.")");
                 }
             }
@@ -543 +551 @@
                     $mod_search['title'] = isset($mod_search['title']) ? $mod_search['title'] : ("Search: ".$mod_search['name']);
                     $mod_search['version'] = isset($mod_search['version']) ? $mod_search['version'] : $mod_version;
+                    // get the max searchorder
+                    $result = dbquery("SELECT max(search_order) as max FROM ".$db_prefix."search");
+                    if ($result) {
+                        $data = dbarray($result);
+                        $max = $data['max'] + 1;
+                    } else {
+                        $max = 1;
+                    }
                     // add it to the search table
-                    $result = dbquery("INSERT INTO ".$db_prefix."search (search_mod_id, search_name, search_title, search_version, search_fulltext, search_visibility) 
-                        VALUES ('".$id."', '".$mod_search['name']."', '".$mod_search['title']."', '".$mod_search['version']."',  '".$mod_search['fulltext']."', '".$mod_search['visibility']."')");
+                    $result = dbquery("INSERT INTO ".$db_prefix."search (search_mod_id, search_name, search_title, search_version, search_fulltext, search_visibility, search_order) 
+                        VALUES ('".$id."', '".$mod_search['name']."', '".$mod_search['title']."', '".$mod_search['version']."',  '".$mod_search['fulltext']."', '".$mod_search['visibility']."', ".$max.")");
                 }
             }