diff options
| author | Yorhel <git@yorhel.nl> | 2010-12-23 12:51:35 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2010-12-23 12:54:44 +0100 |
| commit | 6ff1efe0d07e24e9fb2db199c308c6cbed51e578 (patch) | |
| tree | 510ad533838b4236ac9d3a17b9ac4c07d1790f04 /lib/VNDB/DB/ULists.pm | |
| parent | 951568c87b1a1ad6fcb73928608f76b3470fd817 (diff) | |
Converted the show_list pref. to users_prefs and inverted the value
In the users_prefs table, the default value should evaluate to 'false'
in Perl, so show_list had to be inverted to hide_list.
Diffstat (limited to 'lib/VNDB/DB/ULists.pm')
| -rw-r--r-- | lib/VNDB/DB/ULists.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/VNDB/DB/ULists.pm b/lib/VNDB/DB/ULists.pm index a1f02786..e6b6419a 100644 --- a/lib/VNDB/DB/ULists.pm +++ b/lib/VNDB/DB/ULists.pm @@ -188,7 +188,7 @@ sub dbVoteGet { my %where = ( $o{uid} ? ( 'n.uid = ?' => $o{uid} ) : (), $o{vid} ? ( 'n.vid = ?' => $o{vid} ) : (), - $o{hide} ? ( 'u.show_list = TRUE' => 1 ) : (), + $o{hide} ? ( 'NOT EXISTS(SELECT 1 FROM users_prefs WHERE uid = n.uid AND key = \'hide_list\')' => 1 ) : (), $o{hide_ign} ? ( '(NOT u.ign_votes OR u.id = ?)' => $self->authInfo->{id}||0 ) : (), $o{vn_char} ? ( 'LOWER(SUBSTR(vr.title, 1, 1)) = ?' => $o{vn_char} ) : (), defined $o{vn_char} && !$o{vn_char} ? ( |