Revision: 1642
http://mrbs.svn.sourceforge.net/mrbs/?rev=1642&view=rev
Author: cimorrison
Date: 2010-11-25 04:17:21 +0000 (Thu, 25 Nov 2010)
Log Message:
-----------
Fixed bug causing approval of entries not to work when using PostgreSQL
Modified Paths:
--------------
mrbs/trunk/web/mrbs_sql.inc
Modified: mrbs/trunk/web/mrbs_sql.inc
===================================================================
--- mrbs/trunk/web/mrbs_sql.inc 2010-11-24 19:07:03 UTC (rev 1641)
+++ mrbs/trunk/web/mrbs_sql.inc 2010-11-25 04:17:21 UTC (rev 1642)
@@ -698,13 +698,13 @@
{
// First update the repeat table
$sql = "UPDATE $tbl_repeat
- SET status=status&". ~STATUS_AWAITING_APPROVAL . "
+ SET status=status&(". ~STATUS_AWAITING_APPROVAL . ")
WHERE id=$id";
if (sql_command($sql) > 0) // We expect there to be one row affected
{
// Then update the entry table
$sql = "UPDATE $tbl_entry
- SET status=status&". ~STATUS_AWAITING_APPROVAL . "
+ SET status=status&(". ~STATUS_AWAITING_APPROVAL . ")
WHERE repeat_id=$id";
// It's possible that there will be no rows affected if all the
// entries have previously been individually approved
@@ -718,7 +718,7 @@
else
{
$sql = "UPDATE $tbl_entry
- SET status=status&". ~STATUS_AWAITING_APPROVAL . "
+ SET status=status&(". ~STATUS_AWAITING_APPROVAL . ")
WHERE id=$id";
return (sql_command($sql) > 0); // We expect there to be one row affected
}
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
