Alexander Nicolaysen Sørnes : appData: Some cleanup in SQL code
Chris Morgan
cmorgan at winehq.org
Sun Dec 2 12:53:21 CST 2007
Module: appdb
Branch: master
Commit: 6d9aa68e0ee1a0ffc21a7ce2c1c4bb198e77615d
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=6d9aa68e0ee1a0ffc21a7ce2c1c4bb198e77615d
Author: Alexander Nicolaysen Sørnes <alex at thehandofagony.com>
Date: Sun Dec 2 19:38:17 2007 +0100
appData: Some cleanup in SQL code
---
include/appData.php | 13 ++-----------
1 files changed, 2 insertions(+), 11 deletions(-)
diff --git a/include/appData.php b/include/appData.php
index ac1f1f4..8265763 100644
--- a/include/appData.php
+++ b/include/appData.php
@@ -214,7 +214,6 @@ class appData
$sQueued = "false";
$sSelectType = "";
- $sLimit = "";
if(($sQueued == "true" || $sQueued == "all") &&
!$_SESSION['current']->hasPriv("admin"))
@@ -280,17 +279,13 @@ class appData
$sSelectType = " AND type = '?'";
$sQuery = "(SELECT COUNT(DISTINCT appData.id) as count FROM appData,
- appFamily, appVersion WHERE
- appFamily.appId = appVersion.appId
- AND
+ appFamily WHERE
(
appData.appId = appFamily.appId
AND
appData.versionId = '0'
)
AND
- appVersion.queued = 'false'
- AND
appFamily.queued = 'false'$sAppDataQueued$sSelectType) UNION
(
SELECT COUNT(DISTINCT appData.id) as count FROM appData,
@@ -407,17 +402,13 @@ class appData
$sQuery =
"(
SELECT DISTINCT appData.* FROM appData,
- appFamily, appVersion WHERE
- appFamily.appId = appVersion.appId
- AND
+ appFamily WHERE
(
appData.appId = appFamily.appId
AND
appData.versionId = '0'
)
AND
- appVersion.queued = 'false'
- AND
appFamily.queued = 'false'
AND
appData.queued = '?'
More information about the wine-cvs
mailing list