Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Mail : Discussion :

Search in admin area (in 2.2.4)

Nov 15, 2004, 10:28 AM
areh
User (303 posts)
Nov 15, 2004, 10:28 AM
Post #1 of 4
Views: 2773
Shortcut
Quote Reply
Search in admin area (in 2.2.4)
Hi

I canīt seem to get correct results when doing a search on 'Not Paid' accounts (the radion button). I do get correct results if I search on a plan and the expire date is in the future.. How come?
Nov 16, 2004, 11:22 AM
brewt
Staff (4101 posts)
brewt's avatar
Nov 16, 2004, 11:22 AM
Post #2 of 4
Views: 2685
Shortcut
Quote Reply
Re: [areh] Search in admin area (in 2.2.4) In reply to
Here's a patch to admin/GMail/SQL/Admin.pm to fix that problem:
Code:
@@ -1014,7 +1014,7 @@
}
# length > 1, because expiry can be -1 (unpaid) or 0 (unlimited). date_to_time()
# would return undef for these, thus removing the term from the search.
- if (exists $cgi->{$p . 'users.users_payment_expiry' . $opt} and length($cgi->{$p . 'users.users_payment_expiry' . $opt}) > 1) {
+ if (exists $cgi->{$p . 'users.users_payment_expiry' . $opt} and $cgi->{$p . 'users.users_payment_expiry' . $opt} != 0 and $cgi->{$p . 'users.users_payment_expiry' . $opt} != -1) {
$cgi->{$p . 'users.users_payment_expiry' . $opt} = date_to_time($cgi->{$p . 'users.users_payment_expiry' . $opt});
}
}

Adrian
Nov 17, 2004, 8:27 AM
areh
User (303 posts)
Nov 17, 2004, 8:27 AM
Post #3 of 4
Views: 2662
Shortcut
Quote Reply
Re: [brewt] Search in admin area (in 2.2.4) In reply to
I changed it to the below, but didnīt seem to make it any better:

# length > 1, because expiry can be -1 (unpaid) or 0 (unlimited). date_to_time()
# would return undef for these, thus removing the term from the search.
if (exists $cgi->{$p . 'users.users_payment_expiry' . $opt} and $cgi->{$p . 'users.users_payment_expiry' . $opt} != 0 and $cgi->{$p .
'users.users_payment_expiry' . $opt} != -1)
{
$cgi->{$p . 'users.users_payment_expiry' . $opt} = date_to_time($cgi->{$p . 'users.users_payment_expiry' . $opt});
}
}
return $self->SUPER::format_search_cgi;
}
Nov 23, 2004, 1:20 PM
areh
User (303 posts)
Nov 23, 2004, 1:20 PM
Post #4 of 4
Views: 2652
Shortcut
Quote Reply
Re: [areh] Search in admin area (in 2.2.4) In reply to
After logging out, it suddenly seems to work.

So, thanks!