Please Log in or Create an account to join the conversation.
An advanced filter against the registration date will work fine for that. Advanced filters are just SQL so feel free to test the SQL in phpmyadmin until you have the results you need.I've tried the module CB content first, but the tags (just tested with [name] to start) renders the name only while the user is connected...
I also tried with CB lists, witch seems easier, but tried to order by register date "less than" "30" , tried also 30 days, failed.
Tried this query : u.'registerDate' < NOW() - INTERVAL 30 DAY
as a free filter, but failed
I assume you mean the search criteria? You can completely customize that under Parameters > Search.Other problem with this list are the other filtering fields that I don't want. I could use a CSS to hide some fields, that would be okay, but I also need to put this list into a module (I could use regularlab to load component also)
I assume you already have the donation amount stored in profile in which case a Code field provided by CB Code Field would need to be used to perform your math using PHP. If not you can query for their donations from the CBSubs database tables using a Query field provided by CB Query Field and also perform your math in the query.Final issue, I'd like this amount donated to be mutiplied by x (and it will be different for each plan) and then this variable will be stored also on the user profile, it will be some an equivalent of points.
Let's say 1€ = 1000 points.
Please Log in or Create an account to join the conversation.