I've just installed Links SQL (a fantastic piece of work!) and a few of its great plug-ins, including this one.
Since the links in my database are all imported, and most of them added to the original database by the admin, there are very few registered users yet. Many, but not all of the records in the database do have an email address.
I would like to be able to send out "email-claim-invite.txt" to all unregistered records in the database which have a known email address, inviting them to register and claim ownership of the link. So basically, an email to all records in the links table where contact_email is not null, and link_claimable is set to "yes".
Since I'm relatively new to perl and mySQL, I'm assuming that some global will need to be written, and called up somehow in a mail template in admin>email >custom lists.
Any ideas on how or if this can be accomplished?
Thanks!
Since the links in my database are all imported, and most of them added to the original database by the admin, there are very few registered users yet. Many, but not all of the records in the database do have an email address.
I would like to be able to send out "email-claim-invite.txt" to all unregistered records in the database which have a known email address, inviting them to register and claim ownership of the link. So basically, an email to all records in the links table where contact_email is not null, and link_claimable is set to "yes".
Since I'm relatively new to perl and mySQL, I'm assuming that some global will need to be written, and called up somehow in a mail template in admin>email >custom lists.
Any ideas on how or if this can be accomplished?
Thanks!