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:
Faucet In A Box Ultimate R106



Changelog:
- Fixed IP_Locks error that appears when you install with different prefix.

Download:
faucetinabox-ultimate-r106.zip

Upgrading:
If ...


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 R103



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


Faucet In A Box Ultimate R112

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


Faucet In A Box Ultimate R105



Changelog:
- Fixed self-refer prevention
- Added WalCrypt

Download:
faucetinabox-ultimate-r105.zip

Upgrading:
If ...