Arrow Home arrow Forums
larger font smaller font default font Fixed screen resolution Auto adjust screen size

Joomlapolis Forums  


<< Start < Prev 1 2 Next > End >>
How to make a date ordered CB list with automatic record aging
Date: 2006/02/16 12:25 By: nant Status: Admin  
Karma: 463  
Admin

Posts: 6014
graph
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
Nick A.
CB Core Team Member
Support CB Development and Get Detailed Documentation
Developer of Nant's Gallery plugin
CB Gallery Extensions Listing, Rate CB Gallery on Extensions Site
Developer of CB AutoWelcome Plugin
CB AutoWelcome Extensions Listing,Rate CB AutoWelcome on Extensions Site
People ignoring your call for help? Read this!
FAQ you
Joomlapolis Extensions Directory (new)- check it out!
Click here to see the profile of this user The administrator has disabled public write access.

Re:How to make a date ordered CB list with automatic record aging
Date: 2006/02/16 22:22 By: nant Status: Admin  
Karma: 463  
Admin

Posts: 6014
graph
I just created 2 extra lists on Joomlapolis using this tip!

The 'Last 30d Newest Members' List:
Code:

 DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= `registerDate`



and

the 'Last 30d visits' list:

Code:

 DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= `lastvisitDate`



again excellent tip!
Nick A.
CB Core Team Member
Support CB Development and Get Detailed Documentation
Developer of Nant's Gallery plugin
CB Gallery Extensions Listing, Rate CB Gallery on Extensions Site
Developer of CB AutoWelcome Plugin
CB AutoWelcome Extensions Listing,Rate CB AutoWelcome on Extensions Site
People ignoring your call for help? Read this!
FAQ you
Joomlapolis Extensions Directory (new)- check it out!
Click here to see the profile of this user The administrator has disabled public write access.

Re:How to make a date ordered CB list with automat
Date: 2006/02/16 23:37 By: irgendwer Status: User  
Karma: 2  
Senior Joomlapolitan

Posts: 87
graphgraph
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
Click here to see the profile of this user The administrator has disabled public write access.

Re:How to make a date ordered CB list with automat
Date: 2006/02/18 04:13 By: hfhs Status: CB Doc subscriber  
Karma: 1  
Junior Joomlapolitan

Posts: 35
graphgraph
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?
Click here to see the profile of this user The administrator has disabled public write access.

Re:How to make a date ordered CB list with automat
Date: 2006/02/21 03:31 By: djsdjs Status: CB Doc subscriber  
Karma: 3  
Senior Joomlapolitan

Posts: 69
graphgraph
For birthdays in the future, I googled this one for you - but haven't tried it within CB:

Code:

 where datepart(dydateadd(d, -datepart(dyGetDate())+1, dateadd(yeardatediff(year, @BirthDategetDate()),  @BirthDate)))-1 between 0 and 30



It is from: http://r937.com/birthdays.html

Post edited by: djsdjs, at: 2006/02/20 21:32
Click here to see the profile of this user The administrator has disabled public write access.

Re:How to make a date ordered CB list with automat
Date: 2006/05/11 09:28 By: MadPax Status: User  
Karma: 3  
Junior Joomlapolitan

Posts: 33
graphgraph
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
Click here to see the profile of this user The administrator has disabled public write access.

<< Start < Prev 1 2 Next > End >>

Documentation

Documentation Subscription Service
(updated for CB 1.2 RC2)

What?

Why?

Where?

Just click here for answers!

Click here for a yearly subscription: subscribe now

Download Latest Release

The latest stable Community Builder Release is version 1.1 for Joomla 1.0 and Mambo.
You need to be a registered member of Joomlapolis to download.

The latest release candidate of Community Builder is version 1.2 RC3, native for Joomla 1.0, 1.5 and Mambo.
It is available as "thank you" to all CB documentation subscribers at this time.

CB Login