[Suggestion] Expose Resource Version in `getResourceUpdate` Response about xenfororesourcemanagerapi HOT 3 CLOSED

Thanks for looking into this for me. Sorry for my absence. I'll be trying to work on this soon.

from xenfororesourcemanagerapi.

I ended up looking into this despite knowing very little about Xenforo and SQL. I managed to figure out the following.

1. The version of a Resource Update is stored as the column version_string in the table xf_resource_version.

2. The API uses this internally to fetch the latest version of a Resource, filtering by the (already known) id of the latest update.

   XenforoResourceManagerAPI/src/support/Database.php

   Lines 211 to 212 in e7db7b9

   	INNER JOIN xf_resource_version rv
   	ON r.current_version_id = rv.resource_version_id

So—in theory—we would be able to adapt that code into the internal function _resource_update(), using the id of the Resource Update from the request. Unfortunately, this is where I got stuck by my limited knowledge. Could we do something like this perhaps?

private function _resource_update($suffix) {
    return sprintf(
-      "SELECT r.resource_update_id, r.resource_id, r.title, r.message
+      "SELECT r.resource_update_id, r.resource_id, r.title, r.message, rv.version_string
        FROM xf_resource_update r
+          INNER JOIN xf_resource_version rv 
+              ON r.resource_id = rv.resource_id         
        WHERE r.message_state = 'visible' %s",
        $suffix
    );
}

from xenfororesourcemanagerapi.

Sorry again for the wait. Life can be crazy. When #66 is merged, this will be available.

from xenfororesourcemanagerapi.