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:
It is July 2018 and R90 now have support for ZEC and XMR



I'm sorry I had no time lately to push all the requested changes. But FaucetHub added 2 new coins ...


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 R101



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


Easy way to send USD payments to FaucetHub

Recently many shortlink operators became in need to be able to easily convert USD to BTC and send payments ...


Faucet In A Box Ultimate R103



Changelog:
- Fixed IPv6 bug that appeared in fresh r102
- Added ksWallet.net
- Added FaucetPay.io
- ...