Added sorting for later easier inserting of more array elements

diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php
index 4fb25ee3af6ce3dea3f9482a39729071b003644c..13411f758e13f916ba1e7d8cb4db5ed077347ecb 100644 (file)
--- a/inc/extensions/ext-network.php
+++ b/inc/extensions/ext-network.php
@@ -153,7 +153,9 @@ PRIMARY KEY (`network_translation_id`)
 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `network_api_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
+`sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_api_index`),
+INDEX (`sort`),
 PRIMARY KEY (`network_api_id`)
 ) TYPE={?_TABLE_TYPE?} COMMENT='Translation of API responses, generic data, DO NOT ALTER!'");
 

diff --git a/inc/libs/network_functions.php b/inc/libs/network_functions.php
index 23ccf54b9027755f868a59006849b6a479b22b08..b9554d66640b86977a6fd5c4bfad273389e72980 100644 (file)
--- a/inc/libs/network_functions.php
+++ b/inc/libs/network_functions.php
@@ -651,7 +651,7 @@ INNER JOIN
 ON
        `network_api_index`=`network_translation_id`
 ORDER BY
-       `network_api_id` ASC', __FUNCTION__, __LINE__);
+       `sort` ASC', __FUNCTION__, __LINE__);
 
                // Do we have entries?
                if (SQL_NUMROWS($result) > 0) {
@@ -1205,6 +1205,16 @@ function doAdminNetworkProcessAddNetworkApiTranslation () {
        // Add id
        setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
 
+       // Add sorting
+       setPostRequestParameter('sort', countSumTotalData(
+               postRequestParameter('network_id'),
+               'network_api_translation',
+               'network_api_id',
+               'network_id',
+               true,
+               sprintf(" AND `network_type_id`=%s", bigintval(postRequestParameter('network_type_id')))
+       ));
+
        // Add the whole request to database
        SQL_QUERY('INSERT INTO
        `{?_MYSQL_PREFIX?}_network_api_translation`