The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 4 posts ] 
Author Message
PostPosted: Mon Feb 19, 2007 10:32 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Feb 19, 2007 8:56 pm
Posts: 1
I'm creating a module that's a simple announcement banner.  I'd like the display to include a timestamp of when the module was last updated through the administrator interface.

I'd like the final product to look something like this:

---------------------------------------------------------------
|  This is an announcement.                        |
|  Last Updated: February 19, 2007 5:31 PM  |
---------------------------------------------------------------

How can I accomplish this?

Thanks much

-- t


Top
 Profile  
 
PostPosted: Mon Feb 19, 2007 10:59 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 8:55 pm
Posts: 19942
Location: Nijmegen, The Netherlands
taupecat wrote:
I'm creating a module that's a simple announcement banner.  I'd like the display to include a timestamp of when the module was last updated through the administrator interface.

I'd like the final product to look something like this:

---------------------------------------------------------------
|  This is an announcement.                        |
|  Last Updated: February 19, 2007 5:31 PM  |
---------------------------------------------------------------

How can I accomplish this?


I created the module "Site Last Modified" ( http://extensions.joomla.org/component/ ... Itemid,35/ ) with the creation and modification date that is stored in the jos_content table.

Unfortunatelly the jos_modules does not contain any date info that is in use (the only datetime field "checked_out_time" seems not to be in use as it's "0000-00-00 00:00:00" for all modules).

The file date of each module file (mod_modulename.php) does not change when you copy / edit the module in the Modules > Site Modules menu.
Therefore the php file date functions (see: http://php.net/manual/en/function.filemtime.php ) cannot be used...

_________________
Kind Regards,
Peter Martin, Global Moderator - Community Leadership Team
http://www.db8.nl - Joomla specialist, Nijmegen, Nederland
Joomla 2.5 multilanguage in 10 steps: http://www.db8.nl/en/joomla-presentatio ... ge-website


Top
 Profile  
 
PostPosted: Thu Mar 08, 2007 2:57 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Jul 18, 2006 11:23 am
Posts: 5
Maybe this doesn't apply directly to your problem, but I think it's a good timestamp solution.

I might not be a good solution (processing power needed etc), but it works.

I wanted a timestamp on my frontpage with the last time something was published in any of the sections.

I used the Display News module (mod_dn) where you can customize pretty much everything as far as information about what you show.

I configured it to show the newest item of all the sections on my site, and then made it show just the date/time of the update.

That way, you get a timestamp that you can use anywhere on your site, with the last time something was published ;)

The advantage of this method is that you can select only certain sections to report, instead of *anything* being updated, plus you can configure the whole string of text (static text like "Updated" or "Actualizado" or whatever you wanna use).

If you need some extra info, don't hesitate to ask, I'll let you know how my setup works.


Last edited by nublaii on Thu Mar 08, 2007 3:02 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: Displaying a
PostPosted: Wed Jun 13, 2012 4:12 am 
Joomla! Intern
Joomla! Intern

Joined: Mon Mar 14, 2011 2:19 am
Posts: 84
I also have question about TIMESTAMP

In database table: jos_vm_product
which is the table for virtueMart

In the tables, I'd like to know more fields: cdate, mdate

What I want to do is: do some SQL statements based on the values of these 2 fields, cdate, mdate

how to interpert the value in these fields?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 



Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group