How to make a date ordered CB list with automatic record aging

Home

Forums

Welcome, Guest

Joomlapolis Forum

Important Content

Community Builder Article Discussions

How to make a date ordered CB list with automatic record aging

(1 viewing) (1) Guest

Reply Topic

Page:
1
2

TOPIC: How to make a date ordered CB list with automatic record aging

How to make a date ordered CB list with automatic record aging 6 years, 3 months ago #6447

nant OFFLINE Administrator Posts: 17305 Karma: 717	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 (nant)* Community Builder Team Member Before posting on forums: Read FAQ thoroughly CB links: Subscribe to CB documentation - Our templates - Paid Subscriptions - Get Hosting - Our Forge - Incubator Visit my CB Profile - Send me a Private Message (PM) -- My personal site(s)/link(s): under construction - Tutorials Reply Quote

Re:How to make a date ordered CB list with automatic record aging 6 years, 3 months ago #6468

nant OFFLINE Administrator Posts: 17305 Karma: 717	I just created 2 extra lists on Joomlapolis using this tip! The 'Last 30d Newest Members' List: DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= `registerDate` and the 'Last 30d visits' list: DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= `lastvisitDate` again excellent tip!
	*Nick (nant)* Community Builder Team Member Before posting on forums: Read FAQ thoroughly CB links: Subscribe to CB documentation - Our templates - Paid Subscriptions - Get Hosting - Our Forge - Incubator Visit my CB Profile - Send me a Private Message (PM) -- My personal site(s)/link(s): under construction - Tutorials Reply Quote

Re:How to make a date ordered CB list with automat 6 years, 3 months ago #6473

irgendwer OFFLINE Expert Boarder Posts: 85 Karma: 2	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 Reply Quote

Re:How to make a date ordered CB list with automat 6 years, 3 months ago #6588

hfhs OFFLINE Senior Boarder Posts: 45 Karma: 1	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?
	Reply Quote

Re:How to make a date ordered CB list with automat 6 years, 3 months ago #6754

djsdjs OFFLINE Expert Boarder Posts: 80 Karma: 4	For birthdays in the future, I googled this one for you - but haven't tried it within CB: where datepart(dy, dateadd(d, -datepart(dy, GetDate())+1, dateadd(year, datediff(year, @BirthDate, getDate()), @BirthDate)))-1 between 0 and 30 It is from: http://r937.com/birthdays.html Post edited by: djsdjs, at: 2006/02/20 21:32
	Reply Quote

Re:How to make a date ordered CB list with automat 6 years ago #12314

MadPax OFFLINE Junior Boarder Posts: 30 Karma: 3	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
	Reply Quote

Reply Topic

Page:
1
2

Joomlapolis Forum

Important Content

Community Builder Article Discussions

Powered by Kunena

Time to create page: 0.98 seconds

Site-Map