Hi,

I'd like to run an SQL query to find all links with Expiry Never and change them to No Payment Required ... but here's the thing ... I can't find how the field is set.

When I look into the Links table, all the expiry dates are the same.

I've compared a link with Never against one with No Payment Required and can't find a field that differentiates them. Am I missing something, or is the info stored elsewhere?

I suspect it's simple and I'm just not seeing it. Anyone?

Cheers,
Shaun

Hi,

I believe this will get links that are not set to expire:


..and;


..to find listings that have an expiry date.

Hope that helps.

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!

Andy,

Thanks for the info, this was driving me nuts

I finally found out (thanks to your prompting) that links with Never have an expiry date of '2147483646'.

All changed now ... thanks very much.

Cheers,
Shaun

Hi,

Glad I could help

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!