Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Setting the expiry date to "Never" via GT::SQL::add

Quote Reply
Setting the expiry date to "Never" via GT::SQL::add
Hi Guys. Is there a prefered way to set links expiry date to "Never" when importing?

<input type="radio" name="pe_radio" onclick="document.getElementById('ExpiryDate').value = 2147483646"> Never<br>

I'm trying to work out where the stuff like 2147483647 comes from.

Anyone got any ideas / suggestions ?? I'm just stumped as to how you can set a link to "never expiring", whilst just importing.

TIA

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Setting the expiry date to "Never" via GT::SQL::add In reply to
Hi Andy

Note sure if you already know but if you look in the Link table properties "2147483647" is the default for that field.

If you're importing from an old version or one that doesn't currently have payment set up then that field will be blank and will automatically default to "2147483647".

Unimpressed

Regan
Quote Reply
Re: [ryel01] Setting the expiry date to "Never" via GT::SQL::add In reply to
Ah.. didn't know that :) Thanks, thats got me going in the right direction then. Just need to set all links to that value :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Setting the expiry date to "Never" via GT::SQL::add In reply to
WinkAndy, did you ever figure out what numbers to put in the default field to set the ExpiryDate to>Never

Is this the correct numbers 2147483646

Last edited by:

rascal: Mar 6, 2005, 3:01 AM
Quote Reply
Re: [rascal] Setting the expiry date to "Never" via GT::SQL::add In reply to
Yup, 2147483646 is the correct date :)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Setting the expiry date to "Never" via GT::SQL::add In reply to
The 2147483646 number is unixtime, and means: 19-01-2038 04:14:06

To convert, just use the iScripts Unix Timestamp Converter.


See more info here about the "Tue Jan 19 03:14:07 2038" date here:
http://www.2038bug.com/


I don't know why is there 1 hour difference.

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Quote Reply
Re: [webmaster33] Setting the expiry date to "Never" via GT::SQL::add In reply to
Thanks, the converter works well.

I'd like to find a way of telling lotus to perform this conversion for me so I can build my database off-line. Something to do on a rainy day!
Quote Reply
Re: [Andy] Setting the expiry date to "Never" via GT::SQL::add In reply to
Look at the constants in Links.pm: UNPAID (awaiting payment), UNLIMITED (does not require payment or a lifetime payment), and FREE (free link).

Adrian