At last, my store is up and running. There is still lots to do on the site, not to mention I’m actively developing an update for LinkLocker Pro for EE 1x, a NEW (3.0) version for EE 1.x, and LinkLocker Pro for EE2. At least now you no longer have to send a PM to purchase. Furthermore, the orders are being fulfilled with the upcoming LinkLocker 3.0, though the only thing you’ll notice from an end user perspective is that the generated links are MUCH shorter. If you would like to buy LinkLocker Pro or download LinkLocker Free, please visit my website at http://www.brad-street.com Thank.s!

Immediate suggestion: Link to this thread, and any other relevant threads in these forums, from the Linklocker Pro page on your site - and also from the Support page, which isn’t up yet. I had to hunt around to find this thread so I could review the SQL you provided to help eliminate bad/empty generated links. I think we’re still having that problem, as the exp_linklocker_gen table is up to 170,000 rows now. It’s one thing to be able to remove these links with some SQL, but I can’t figure out why it is generating so many links in the first place.

I’m also not seeing any results in the first 5 pages (of 13) when clicking on Link Statistics in the Module control panel. I don’t know if that is a result of the table being so large.

The links are being created as soon as you pull up a page with downloads on it. Not sure why that happens though. I just saw this myself and so emptied the whole table. I noted before deleting the links that loads and loads of them had the same link_id meaning a different download link was being created for the same link so that’s what is happening here.

That being said I can’t quite tell why so many are created on page load. I have a page with 11 links on it which automatically creates 48 links in the database table. I can’t quite put 2 + 2 together here and see why this is though.

Best wishes,

Mark

Actually I lie. I’ve just done this again and the first 11 links in the exp_linklocker_link table are for actual files. The 12th is totally empty for the link_url, however obviously if you times 12 * 4 you get the 48.

Would be nice to find out why this happens though.

Best wishes,

Mark

@Ryan:
  I’d be happy to look at your installation if you’d like.

With the current version of the module, if you are showing encrypted links to non-members or non-logged in members, a new link is created for each linklocker tag in the template on every page load. This means that in the links table, there should be 1 entry per template tag (url/path, group, and label are unique to each entry), but the gen table will have the details for each “generated” link for that particular entry in the links table. This should explain why that table has so many entries compared to the links table. The module does have auto pruning, whereby it automatically removes links that were generated for non-members/non-logged-in members that are more than 14 days expired. Of course, if you are setting long expiration times, these entries may be around for quite some time.

The upcoming version of LinkLocker Pro addresses these and other performance related issues in a quite elegant manner.

Thanks for the update, Brad. I am setting long expiration times - as in, links practically never expiring. Wondering if I should make two different tags - if one isn’t logged in, set a very short expiration time, but if one is logged in, set a long expiration time.

At any rate, I’m looking forward to upgrading the Module in the near future. I may have you take a look at it as well if you have any time to spare.

Hey Brad,

Sent an email earlier,  as I was having trouble with Linklocker Pro 2.5.1 on an MSM install.  Got that working by adjusting the .htaccess file.

But now I’m having another issue…  The links are generated properly,  and everything works fine when logged in.  When I add:

... it works,  and sends the user to the default linklocker error message page.  However,  when I then add:

and try to download when logged out,  I get to a blank page,  with the URL being the linklocker generated URL.  I am not redirected to the custom template.

In addition,  your docs are not quite right to begin with.  You have a syntax error in the restricted_url sample code.  You are missing the closing curly bracket for the linklocker tag, and the closing quote for the href tag…

Anyhoo,  does this feature work properly?  Any ideas?

Ira