Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

How to display days since add and last modified

(Page 1 of 2)
> >
Previous ThreadNext ThreadPrint ThreadView Threaded
Sep 8, 2009, 5:32 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 8, 2009, 5:32 AM
Post #1 of 42
Views: 2253
Shortcut
Quote Reply
How to display days since add and last modified
As subject says, I was wondering if there was a way to display:

1. Number of days since listing was added (current date - add date)
2. Number of days since listing was last modified (current date - modified date)

Is this possible via UltraGLobal or any other global?

Thanks.

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 8, 2009, 5:43 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 8, 2009, 5:43 AM
Post #2 of 42
Views: 2241
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Hi,

Not 100% sure - but you should be able to do with something like this:


Code:
<%GT::Date::date_diff($Add_Date,GT::Date::date_get)%>

..and:

Code:
<%GT::Date::date_diff($Mod_Date,GT::Date::date_get)%>

May not be as simple as that (cos the date formats for $Add_Date and $Mod_Date are converted when passed to the template - so may require a little cleverer solution).

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 8, 2009, 6:17 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 8, 2009, 6:17 AM
Post #3 of 42
Views: 2239
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
hum :( not working.. its giving 0 as out put for both.. Here is what I am using:

Add Date: <%GT::Date::date_diff($Add_Date,GT::Date::date_get)%> <br>
Mod Date: <%GT::Date::date_diff($Mod_Date,GT::Date::date_get)%>

and here is the output:

Add Date: 0
Mod Date: 0

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 8, 2009, 6:45 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 8, 2009, 6:45 AM
Post #4 of 42
Views: 2232
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Try this:

Code:
<%set today = GT::Date::date_get%>
Add Date: <%GT::Date::date_diff($Add_Date,$today)%> <br>
Mod Date: <%GT::Date::date_diff($Mod_Date,$today)%>

If not, what format do you have set in
Code:
Setup > Date Options > date_user_format
?

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 8, 2009, 6:54 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 8, 2009, 6:54 AM
Post #5 of 42
Views: 2231
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
Output for that code is -14495

date_user_format = %dd% %mmm% %yyyy%

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 8, 2009, 6:56 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 8, 2009, 6:56 AM
Post #6 of 42
Views: 2230
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Ok, stab in the dark - but try:

<%set _today = GT::Date::date_get%>
<%set today = GT::Date::date_transform ($_today, "%dd% %mmm% %yyyy% ", "%yyyy%-%mm-%dd%")%>
Add Date: <%GT::Date::date_diff($Add_Date,$today)%> <br>
Mod Date: <%GT::Date::date_diff($Mod_Date,$today)%>


Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 8, 2009, 7:04 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 8, 2009, 7:04 AM
Post #7 of 42
Views: 2229
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
hum... back to:

Add Date: 0
Mod Date: 0

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 8, 2009, 7:07 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 8, 2009, 7:07 AM
Post #8 of 42
Views: 2227
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Ok try some debugging:

Code:
<%set _today = GT::Date::date_get%>
<%set today = GT::Date::date_transform ($_today, "%yyyy%-%mm-%dd%", "%dd% %mmm% %yyyy%")%>
today = <%today%> <br />
Add Date: <%GT::Date::date_diff($Add_Date,$today)%> <br>
Mod Date: <%GT::Date::date_diff($Mod_Date,$today)%>

(I also fixed something, which may have been causing it not to work =))

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 8, 2009, 7:24 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 8, 2009, 7:24 AM
Post #9 of 42
Views: 2226
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
:( Still no success

today =
Add Date: 0
Mod Date: 0

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 8, 2009, 7:26 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 8, 2009, 7:26 AM
Post #10 of 42
Views: 2225
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Send over GLinks details, and I'll try to take a look later / tomorrow. Really busy atm.

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 8, 2009, 7:33 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 8, 2009, 7:33 AM
Post #11 of 42
Views: 2223
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
Check your pm.. its there And I am adding above code in link.html at the end.

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 8, 2009, 7:42 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 8, 2009, 7:42 AM
Post #12 of 42
Views: 2221
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Hi,

You gave the wrong date format ;)

This now works:

Code:
<%GT::Date::date_set_format("%ddd% %mmm% %dd% %yyyy%")%>
<%set _today = GT::Date::date_get%>
Add Date: <%GT::Date::date_diff($_today,$Add_Date)%> <br>
Mod Date: <%GT::Date::date_diff($_today,$Mod_Date)%>


The bit in bold needs to match up to whatever you have in your "Date Options" section - otherwise it won't work.

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 8, 2009, 8:12 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 8, 2009, 8:12 AM
Post #13 of 42
Views: 2215
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
Hey you got it..... wow.. this is just insane.. I mean it open up like a zillion new ideas on how to format or display info..

Cool.

Thanks again.

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 9, 2009, 9:09 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 9, 2009, 9:09 AM
Post #14 of 42
Views: 2142
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
Hi Andy,

Was wondering on how to display age for Listing & User:

Example : I just used the dates for easy example:
So for Link it can be like :::: (Based on the Add Date)
Listed Since: April 22, 2007 (2 years 4 months 18 days)

Last Updated :::: (Based on the Mod Date)
Last Updated: April 22, 2008 (1 years 4 months 18 days)


For Users it can be like :::: (Based on the User Registration Date)
Member Since April 22, 2006 (3 years 4 months 18 days)

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 9, 2009, 9:13 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 9, 2009, 9:13 AM
Post #15 of 42
Views: 2141
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Depends on how you are using - are you using GComm?

I'm not sure without looking, to see how the "signup date" is stored for users (bit busy to start looking I'm afraid)

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 9, 2009, 9:22 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 9, 2009, 9:22 AM
Post #16 of 42
Views: 2138
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
Nope.. not using GCom.. just GLinks.

I noticed that there is no Date field in User Tables, so simply created one (with the name Signup_Date & Column Type as "Date"). Or in other words, its set same as Link Add Date but under user tables.

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 9, 2009, 9:23 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 9, 2009, 9:23 AM
Post #17 of 42
Views: 2136
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Ok, and what format (when you look in mysqlman), does it show for that field?

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 9, 2009, 9:24 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 9, 2009, 9:24 AM
Post #18 of 42
Views: 2135
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
I just checked in the GLinks help section it shows "DATE: This stores a date defaulting to yyyy-mm-dd format"

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 9, 2009, 9:26 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 9, 2009, 9:26 AM
Post #19 of 42
Views: 2132
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
It is on the same development site that I send you last login info.

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 9, 2009, 9:27 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 9, 2009, 9:27 AM
Post #20 of 42
Views: 2131
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Ok, well try this then:

Code:
<%GT::Date::date_set_format("%yyyy%-%dd%-%mm%")%>
<%set _today = GT::Date::date_get%>
Since Signup: <%GT::Date::date_diff($_today,user.DateField)%>

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 10, 2009, 4:36 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 10, 2009, 4:36 AM
Post #21 of 42
Views: 2048
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
No Success, here is what I am doing:

In footer for user_profile.html page (User Edit Profile Plugin)
am having this code
Code:
<%GT::Date::date_set_format("%yyyy%-%dd%-%mm%")%>
<%set _today = GT::Date::date_get%>
Since Signup: <%GT::Date::date_diff($_today,user.Signup_Date)%>

Output
Code:
0 Since Signup: 14497

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 10, 2009, 4:38 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 10, 2009, 4:38 AM
Post #22 of 42
Views: 2048
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Mmm, sometimes it can be due to the user, stuff

Try doing:
Code:
<%GT::Date::date_set_format("%yyyy%-%dd%-%mm%")%>
<%set _today = GT::Date::date_get%>
<%set tmp = user.Signup_Date%>
Since Signup: <%GT::Date::date_diff($_today,$tmp)%>

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 10, 2009, 5:23 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 10, 2009, 5:23 AM
Post #23 of 42
Views: 2042
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
Still the same output.

0 Since Signup: 14497

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Sep 10, 2009, 5:24 AM
Andy
Veteran / Moderator (17296 posts)
Andy's avatar
Sep 10, 2009, 5:24 AM
Post #24 of 42
Views: 2041
Shortcut
Quote Reply
Re: [SWDevil.Com] How to display days since add and last modified In reply to
Ok not sure - will try and have a look later - mega busy atm.

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Sep 10, 2009, 8:21 AM
SWDevil.Com
Enthusiast (974 posts)
Sep 10, 2009, 8:21 AM
Post #25 of 42
Views: 2024
Shortcut
Quote Reply
Re: [Andy] How to display days since add and last modified In reply to
Thanks for the help, will be waiting for your reply.

Vishal

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
> >
Previous ThreadNext ThreadPrint ThreadView Threaded