Fix AdLinkFly performance issues?

Recently many shortlink providers started getting performance issues.

I've spent some time analyzing the AdLinkFly shortner script and found that it is not perfectly working with the disposable links that FBU creates.

After little bit of lurking here are the steps that will most likely improve the situation.

1. Make database backup (just in case).

2. Create new campaigns every week or two and delete the older ones (including the stats).

3. I've prepared special script to remove the unneeded links. You can download it here adlinkfly-cleaner-100.zip

4. Upload it to your host.

5. Password-protect the adlinkfly-cleaner folder.

6. Open config.php and enter your database details.

7. Run index.php

8. The default options are good-enough (be careful, if you change something you may delete way more than you want).

9. Press Delete Links and wait for the result.

10. Press Delete Statistics and wait for the result.


Use at your own risk.

If you like my work you may say "thank you" via my BTC address 1MakeJarmmzLs5gzkQubNJxxx9kQMZpKPr




Other topics:
How the priority and Limit works in R87

Since the release of FaucetInABox R87 I've got many questions about how the new "shortlink" feature works. ...


Faucet In A Box Ultimate R96 is here



I'll try to be short this time.

Changelog:
- Added 7 days IP check local cache - should allow ...


Faucet In A Box Ultimate R112



Changelog:
- fixed XTZ and ETC bug (expresscrypto)
- added TRX (faucetpay)
- admin - made tiny ...


Jar Pay 4.00 ready for download

Changelog:
- Removed Faucethub
- Added FaucetPay
- Added MicroWallet
- Added WalCrypt
- Added ksWallet

Download:
Jar ...


Faucet In A Box Ultimate R101



Changelog:
- Better shortlink management.
- Removed ExpressCrypto v1 compatibility. Improved v2 ...