diff options
| author | Aleksey Lim <alsroot@sugarlabs.org> | 2012-01-18 16:10:47 (GMT) |
|---|---|---|
| committer | Aleksey Lim <alsroot@sugarlabs.org> | 2012-01-18 16:10:47 (GMT) |
| commit | e377c0b191a04745a0f094bbc77d9a41f41da93b (patch) | |
| tree | 62c237229900aa9dc9c7e5f2c872aea8aebbb3d4 | |
| parent | 50c5c8d15b0c373c043b148c017d3a15a53428b0 (diff) | |
Compare versions by release number, not by id
| -rw-r--r-- | site/app/models/version.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/site/app/models/version.php b/site/app/models/version.php index c3acbfe..9f8044c 100644 --- a/site/app/models/version.php +++ b/site/app/models/version.php @@ -156,7 +156,7 @@ class Version extends AppModel WHERE Version.addon_id = {$id} ORDER BY - Version.id + IF({$app_ver} >= CAST(B.version AS DECIMAL(3,3)) AND {$app_ver} <= CAST(C.version AS DECIMAL(3,3)), 1000000, 0) DESC + Version.version + IF({$app_ver} >= CAST(B.version AS DECIMAL(3,3)) AND {$app_ver} <= CAST(C.version AS DECIMAL(3,3)), 1000000, 0) DESC LIMIT 1 "; @@ -194,7 +194,7 @@ class Version extends AppModel WHERE Version.addon_id = {$id} AND ({$version} = 0 OR Version.version = {$version}) ORDER BY - Version.id + IF({$app_ver} >= CAST(B.version AS DECIMAL(3,3)) AND {$app_ver} <= CAST(C.version AS DECIMAL(3,3)), 1000000, 0) DESC + Version.version + IF({$app_ver} >= CAST(B.version AS DECIMAL(3,3)) AND {$app_ver} <= CAST(C.version AS DECIMAL(3,3)), 1000000, 0) DESC LIMIT 1 "; |