diff options
| author | friendica <info@friendica.com> | 2013-12-05 20:40:27 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2013-12-05 20:40:27 -0800 |
| commit | 7ae371d2865c063144490fbd6e1097f90c75eaf3 (patch) | |
| tree | f4bee1422ba23c966a1bd61b0339297327f12613 /mod | |
| parent | 28ac593e67be5ad649a90752ebac533a972a227c (diff) | |
| download | volse-hubzilla-7ae371d2865c063144490fbd6e1097f90c75eaf3.tar.gz volse-hubzilla-7ae371d2865c063144490fbd6e1097f90c75eaf3.tar.bz2 volse-hubzilla-7ae371d2865c063144490fbd6e1097f90c75eaf3.zip | |
couple of errant SQL queries
Diffstat (limited to 'mod')
| -rw-r--r-- | mod/profile_photo.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mod/profile_photo.php b/mod/profile_photo.php index 7893cc302..e86e2a828 100644 --- a/mod/profile_photo.php +++ b/mod/profile_photo.php @@ -119,7 +119,7 @@ function profile_photo_post(&$a) { dbesc($base_image['resource_id']), intval(local_user()) ); - $r = q("UPDATE photo SET ( photo_flags ^ %d ) WHERE (photo_flags & %d ) + $r = q("UPDATE photo SET photo_flags = ( photo_flags ^ %d ) WHERE ( photo_flags & %d ) AND resource_id != '%s' AND `uid` = %d", intval(PHOTO_PROFILE), intval(PHOTO_PROFILE), @@ -236,7 +236,7 @@ function profile_photo_content(&$a) { // unset any existing profile photos $r = q("UPDATE photo SET profile = 0 WHERE profile = 1 AND uid = %d", intval(local_user())); - $r = q("UPDATE photo SET (photo_flags ^ %d ) WHERE (photo_flags & %d ) AND uid = %d", + $r = q("UPDATE photo SET photo_flags = (photo_flags ^ %d ) WHERE (photo_flags & %d ) AND uid = %d", intval(PHOTO_PROFILE), intval(PHOTO_PROFILE), intval(local_user())); |