AdBlock Tracker & Usergroup Swap

AdBlock Tracker & Usergroup Swap [Paid] v2.4.0

No permission to buy ($45.00)
Overview FAQ Updates (47) Reviews (4) History Discussion
Wutime said:
So before I wade in much further I just wanted to ensure you hadn't possibly created new paid membership roles and forgotten to add those to the "ignore roles" in the AdBlock Tracker plugin.
Click to expand...
Sorry, late to the party today. (But fashionably late) - Yes, I'm setup properly. I will let you know how it goes moving forward.
 
In 2.3.11 you have a template modification which adds the clickable link in the avatar to view the members' adblock history.
It uses
HTML: 
<i aria-hidden="true" class="fas fa-hand-paper"></i>
This won't work with fontawesome on Xenforo 2.3+, right?
And we don't get any fontawesome icon displayed inside the red hexagon.
 
When trying to buy (clicking in the button here) it shows:

Error establishing a database connection​


This also happens with other addons as well (not all, for example "Content Blur Pro" works well, but "Limited Guest Viewing Pro" doesn't)
 
I received a user upgrade and the usergroup switch and removal (from the adblocker group) worked as expected.

However, I have an error message in my log. It appears everything worked - so what does this mean?



XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '71093-4' for key 'user_id_upgrade_id' src/XF/Db/AbstractStatement.php:230

Generated by: Unknown account Mar 25, 2025 at 11:21 PM

Stack trace

INSERT INTO xf_user_upgrade_active (user_upgrade_id, user_id, start_date, extra, end_date, purchase_request_key, user_upgrade_record_id, is_cancelled) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1572): XF\Db\AbstractAdapter->insert('xf_user_upgrade...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1300): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Service/User/UpgradeService.php(179): XF\Mvc\Entity\Entity->save(true, false)
#7 src/addons/Wutime/AdBlockTracker/XF/Service/User/Upgrade.php(12): XF\Service\User\UpgradeService->upgrade()
#8 src/XF/Purchasable/UserUpgrade.php(184): Wutime\AdBlockTracker\XF\Service\User\Upgrade->upgrade()
#9 src/XF/Payment/AbstractProvider.php(212): XF\Purchasable\UserUpgrade->completePurchase(Object(XF\Payment\CallbackState))
#10 payment_callback.php(67): XF\Payment\AbstractProvider->completeTransaction(Object(XF\Payment\CallbackState))
#11 {main}

Request state

array(4) {
["url"] => string(54) "/forum/payment_callback.php?_xfProvider=stripe"
["referrer"] => bool(false)
["_GET"] => array(1) {
["_xfProvider"] => string(6) "stripe"
}
["_POST"] => array(0) {
}
}
 
That's odd. Was it a one off, or the one and only time you've had an upgrade?

The duplicate key means the database tried to create the upgrade twice, which violates the primary key because it must be unique.

Should be just fine, but I'll look into it to see it it's due to my addon.
 
Wutime said:
That's odd. Was it a one off, or the one and only time you've had an upgrade?

The duplicate key means the database tried to create the upgrade twice, which violates the primary key because it must be unique.

Should be just fine, but I'll look into it to see it it's due to my addon.
Click to expand...
I’ve only had this single upgrade. My forums lost a lot of traffic to Reddit and Quora after the most recent Google search engine update.
 
Sal Collaziano said:
I’ve only had this single upgrade. My forums lost a lot of traffic to Reddit and Quora after the most recent Google search engine update.
Click to expand...
Similar, but fortunately I'm pretty niche.

Remember the days of "do no evil"? Google seems to have done a hard left from that years ago and it's starting to show.
 
Wutime said:
Remember the days of "do no evil"? Google seems to have done a hard left from that years ago and it's starting to show.
Click to expand...
Yes, I'm glad I got started many years ago when it was all a level playing field and a well built website with good information could rank as high as a multi billion dollar corporation. I used to rank #1 for "cadillac", "low carb diet", "thinning hair", and many others. Now it's all sponsored ads and/or simply large corporation on top.
 
Sal Collaziano said:
I received a user upgrade and the usergroup switch and removal (from the adblocker group) worked as expected.

However, I have an error message in my log. It appears everything worked - so what does this mean?
Click to expand...
I looked into this and couldn't find any issues on testing upgrades.

Before I look further I was going to see if any of my websites have this issue. Given everything completed properly on your end, I like the 'wait and see' approach.

Please let me know if this recurs next time someone does an upgrade that affects their AdBlock/UserGroup status change upon upgrade.
 
Wutime updated AdBlock Tracker & Usergroup Swap with a new update entry:

v2.4.0

  • UPDATE: Refactored primary detection method to remove attack vector
  • UPDATE: Improved detection under Firefox with AdGuard, uBlock, AdBlock Plus
  • UPDATE: Update detection to include newly added variables to obfuscation array
  • UPDATE: Obfuscate reject and resolve promise methods
  • UPDATE: Obfuscate XHR and script requests
  • UPDATE: Precompile order of obfuscation array elements to be most performant prior to execution
  • UPDATE: Tracking detection code base upgraded v3.0 =>...
Click to expand...

Read the rest of this update entry...
 
You must log in or register to reply here.
Back
Top Bottom