Revision: 1126
http://mrbs.svn.sourceforge.net/mrbs/?rev=1126&view=rev
Author: cimorrison
Date: 2009-06-23 11:35:30 +0000 (Tue, 23 Jun 2009)
Log Message:
-----------
Fixed report SQL following change of PostgreSQL type for private from boolean
to smallint.
Modified Paths:
--------------
mrbs/trunk/web/report.php
Modified: mrbs/trunk/web/report.php
===================================================================
--- mrbs/trunk/web/report.php 2009-06-23 10:48:26 UTC (rev 1125)
+++ mrbs/trunk/web/report.php 2009-06-23 11:35:30 UTC (rev 1126)
@@ -661,14 +661,14 @@
}
else
{
- $sql .= " AND (e.create_by = '".addslashes($user)."' OR NOT
e.private)";
+ $sql .= " AND (e.create_by = '".addslashes($user)."' OR e.private=0)";
}
}
else
{
# un-authenticated users can only report on
# items which are not marked private
- $sql .= " AND NOT e.private";
+ $sql .= " AND e.private=0";
}
}
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
------------------------------------------------------------------------------
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
