- Forums
- Archive
- Important Content
- Community Builder Article Discussions
- How to make a date ordered CB list with automatic record aging
How to make a date ordered CB list with automatic record aging
nant
Team Member- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
18 years 2 months ago #6447
by nant
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
How to make a date ordered CB list with automatic record aging was created by nant
This thread discusses the Content article:
How to make a date ordered CB list with automatic record aging
Excellent article!
Thank you very much for taking the time to share this with the rest of the Joomlapolitans!
I hope this will inspire others to follow!
Post edited by: nant, at: 2006/05/10 23:00
Excellent article!
Thank you very much for taking the time to share this with the rest of the Joomlapolitans!
I hope this will inspire others to follow!
Post edited by: nant, at: 2006/05/10 23:00
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
- nant
- Team Member
- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
18 years 2 months ago #6468
by nant
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Replied by nant on topic Re:How to make a date ordered CB list with automatic record aging
I just created 2 extra lists on Joomlapolis using this tip!
The 'Last 30d Newest Members' List:
[code:1]DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= `registerDate`[/code:1]
and
the 'Last 30d visits' list:
[code:1]DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= `lastvisitDate`[/code:1]
again excellent tip!
The 'Last 30d Newest Members' List:
[code:1]DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= `registerDate`[/code:1]
and
the 'Last 30d visits' list:
[code:1]DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= `lastvisitDate`[/code:1]
again excellent tip!
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
- irgendwer
- OFFLINE
-
Premium Member
- Posts: 85
- Thanks: 0
- Karma: 2
18 years 2 months ago #6473
by irgendwer
South Korea's got Seoul
Replied by irgendwer on topic Re:How to make a date ordered CB list with automat
Is it also possible to create a list which shows the next birthdays which dates users have put in their profile?
South Korea's got Seoul
Please Log in to join the conversation.
- hfhs
- OFFLINE
-
Senior Member
- Posts: 45
- Thanks: 0
- Karma: 1
18 years 2 months ago #6588
by hfhs
Replied by hfhs on topic Re:How to make a date ordered CB list with automat
I really liked the idea of creating Announcements and then only showing the ones that have content. Is it possible to show those announcements in a module or in content on the frontpage? Or for that matter any of the cb fields on the frontpage, kind of like the Latest Forum Posts module?
Please Log in to join the conversation.
- djsdjs
- OFFLINE
-
Premium Member
- Posts: 80
- Thanks: 0
- Karma: 4
18 years 2 months ago #6754
by djsdjs
Replied by djsdjs on topic Re:How to make a date ordered CB list with automat
For birthdays in the future, I googled this one for you - but haven't tried it within CB:
[code:1]where datepart(dy, dateadd(d, -datepart(dy, GetDate())+1,
dateadd(year, datediff(year, @BirthDate, getDate()),
@BirthDate)))-1 between 0 and 30[/code:1]
It is from: r937.com/birthdays.html
Post edited by: djsdjs, at: 2006/02/20 21:32
[code:1]where datepart(dy, dateadd(d, -datepart(dy, GetDate())+1,
dateadd(year, datediff(year, @BirthDate, getDate()),
@BirthDate)))-1 between 0 and 30[/code:1]
It is from: r937.com/birthdays.html
Post edited by: djsdjs, at: 2006/02/20 21:32
Please Log in to join the conversation.
- MadPax
- OFFLINE
-
Senior Member
- Posts: 41
- Thanks: 1
- Karma: 3
17 years 11 months ago #12314
by MadPax
Replied by MadPax on topic Re:How to make a date ordered CB list with automat
Great Article, Thnks Nick for the suggestion.
One question though. Where's this DATE_SUB subroutine come from? Are there any such subroutines elsewhere for us to use in the advanced filter?
Hey Nick you deserve Karma for... errrrr... let me put it this way, a hell of a lot of things besides the fast response on my question.
tkare
Pax
One question though. Where's this DATE_SUB subroutine come from? Are there any such subroutines elsewhere for us to use in the advanced filter?
Hey Nick you deserve Karma for... errrrr... let me put it this way, a hell of a lot of things besides the fast response on my question.
tkare
Pax
Please Log in to join the conversation.
Moderators: beat, nant, krileon
- Forums
- Archive
- Important Content
- Community Builder Article Discussions
- How to make a date ordered CB list with automatic record aging
Time to create page: 0.316 seconds
-
You are here:
- Home
- Forums
- Archive
- Important Content
- Community Builder Article Discussions
- How to make a date ordered CB list with automatic record aging