This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "FusionForge".
The branch, master has been updated
via 9b341ae4b5121ad3eeaa551104172d170799bde0 (commit)
from 41000ca86c9829f2597de637ec660f25ad259f55 (commit)
Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.
- Log -----------------------------------------------------------------
https://scm.fusionforge.org/anonscm/gitweb/?p=fusionforge/fusionforge.git;a=commitdiff;h=9b341ae4b5121ad3eeaa551104172d170799bde0
commit 9b341ae4b5121ad3eeaa551104172d170799bde0
Author: Marc-Etienne Vargenau <[email protected]>
Date: Mon Jul 11 11:53:07 2016 +0200
Use upper case for keywords in SQL
diff --git a/src/common/include/FusionForge.class.php
b/src/common/include/FusionForge.class.php
index 390e6c9..bcad0cd 100644
--- a/src/common/include/FusionForge.class.php
+++ b/src/common/include/FusionForge.class.php
@@ -62,7 +62,7 @@ class FusionForge extends FFError {
* @param string $extended_qpa string of SQL to be part of the
QPA query
*/
function getNumberOfProjects($params = array(), $extended_qpa = null) {
- $qpa = db_construct_qpa(false, 'SELECT count(*) as count FROM
groups');
+ $qpa = db_construct_qpa(false, 'SELECT count(*) AS count FROM
groups');
if (count($params) > 1) {
$qpa = db_construct_qpa($qpa, ' WHERE ');
$i = 0;
@@ -116,7 +116,7 @@ class FusionForge extends FFError {
}
function getNumberOfProjectsFilteredByGroupName($filter) {
- $res = db_query_params('SELECT count(*) as count FROM groups
WHERE lower(group_name) LIKE $1', array(strtolower("$filter%")));
+ $res = db_query_params('SELECT count(*) AS count FROM groups
WHERE lower(group_name) LIKE $1', array(strtolower("$filter%")));
if (!$res || db_numrows($res) < 1) {
$this->setError('Unable to get project count:
'.db_error());
return false;
@@ -125,7 +125,7 @@ class FusionForge extends FFError {
}
function getNumberOfUsersUsingAPlugin($plugin_name) {
- $res = db_query_params ('SELECT count(u.user_id) AS count FROM
plugins p, user_plugin up, users u WHERE p.plugin_name = $1 and up.user_id =
u.user_id and p.plugin_id = up.plugin_id and users.user_id != 100',
+ $res = db_query_params ('SELECT count(u.user_id) AS count FROM
plugins p, user_plugin up, users u WHERE p.plugin_name = $1 and up.user_id =
u.user_id AND p.plugin_id = up.plugin_id and users.user_id != 100',
array($plugin_name));
if (!$res || db_numrows($res) < 1) {
$this->setError('Unable to get user count:
'.db_error());
@@ -165,7 +165,7 @@ class FusionForge extends FFError {
}
function getNumberOfProjectsUsingTags($params = array(), $extended_qpa
= null) {
- $qpa = db_construct_qpa(false, 'SELECT count(*) as count FROM
groups, project_tags WHERE groups.group_id = project_tags.group_id ');
+ $qpa = db_construct_qpa(false, 'SELECT count(*) AS count FROM
groups, project_tags WHERE groups.group_id = project_tags.group_id ');
if (count($params) > 1) {
$qpa = db_construct_qpa($qpa, ' AND ');
$i = 0;
-----------------------------------------------------------------------
Summary of changes:
src/common/include/FusionForge.class.php | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
hooks/post-receive
--
FusionForge
_______________________________________________
Fusionforge-commits mailing list
[email protected]
http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-commits
