Gossamer Forum
Skip to Content
for Advanced Search
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 (953 posts)
Sep 8, 2009, 5:32 AM
Post #1 of 42
Views: 1430
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 (16033 posts)
Andy's avatar
Sep 8, 2009, 5:43 AM
Post #2 of 42
Views: 1426
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.com


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 (953 posts)
Sep 8, 2009, 6:17 AM
Post #3 of 42
Views: 1424
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 (16033 posts)
Andy's avatar
Sep 8, 2009, 6:45 AM
Post #4 of 42
Views: 1417
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.com


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 (953 posts)
Sep 8, 2009, 6:54 AM
Post #5 of 42
Views: 1416
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 (16033 posts)
Andy's avatar
Sep 8, 2009, 6:56 AM
Post #6 of 42
Views: 1415
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.com


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 (953 posts)
Sep 8, 2009, 7:04 AM
Post #7 of 42
Views: 1414
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 (16033 posts)
Andy's avatar
Sep 8, 2009, 7:07 AM
Post #8 of 42
Views: 1412
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.com


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 (953 posts)
Sep 8, 2009, 7:24 AM
Post #9 of 42
Views: 1411
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 (16033 posts)
Andy's avatar
Sep 8, 2009, 7:26 AM
Post #10 of 42
Views: 1410
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.com


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 (953 posts)
Sep 8, 2009, 7:33 AM
Post #11 of 42
Views: 1408
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 (16033 posts)
Andy's avatar
Sep 8, 2009, 7:42 AM
Post #12 of 42
Views: 1406
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.com


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 (953 posts)
Sep 8, 2009, 8:12 AM
Post #13 of 42
Views: 1400
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 (953 posts)
Sep 9, 2009, 9:09 AM
Post #14 of 42
Views: 1327
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 (16033 posts)
Andy's avatar
Sep 9, 2009, 9:13 AM
Post #15 of 42
Views: 1326
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.com


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 (953 posts)
Sep 9, 2009, 9:22 AM
Post #16 of 42
Views: 1323
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 (16033 posts)
Andy's avatar
Sep 9, 2009, 9:23 AM
Post #17 of 42
Views: 1321
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.com


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 (953 posts)
Sep 9, 2009, 9:24 AM
Post #18 of 42
Views: 1320
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 (953 posts)
Sep 9, 2009, 9:26 AM
Post #19 of 42
Views: 1317
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 (16033 posts)
Andy's avatar
Sep 9, 2009, 9:27 AM
Post #20 of 42
Views: 1316
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.com


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 (953 posts)
Sep 10, 2009, 4:36 AM
Post #21 of 42
Views: 1233
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 (16033 posts)
Andy's avatar
Sep 10, 2009, 4:38 AM
Post #22 of 42
Views: 1232
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.com


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 (953 posts)
Sep 10, 2009, 5:23 AM
Post #23 of 42
Views: 1227
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 (16033 posts)
Andy's avatar
Sep 10, 2009, 5:24 AM
Post #24 of 42
Views: 1226
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.com


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 (953 posts)
Sep 10, 2009, 8:21 AM
Post #25 of 42
Views: 1209
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