[DBTech] DragonByte Shop

[DBTech] DragonByte Shop [Paid] 7.1.0

No permission to buy (€12.45)
Overview Updates (74) Reviews (7) History Discussion
ALMUSA said:
1- How to limit currency earning to specific nodes only
Click to expand...
This is not possible with the built-in points system, sorry.

ALMUSA said:
2- How to disable the "Filter" option or disable certain items from appearing in the filter list "Item Type"
Click to expand...
This is not possible at this time, though you can edit out the filter menu via the templates. I can't give you specific instructions, as this kind of customisation goes beyond the scope of support, sorry.

ALMUSA said:
3- How to make purchase pending admin approval
Click to expand...
I don't believe there is such a feature at this time.

ALMUSA said:
4- How to change the shop link from dbtech-shop to a custom link.
Click to expand...
Under the Setup menu, choose "Route filters" and follow the on-screen instructions :)
 
DragonByte Tech said:
This is not possible at this time, though you can edit out the filter menu via the templates. I can't give you specific instructions, as this kind of customisation goes beyond the scope of support, sorry.
Click to expand...

Thanks Fillip but I do no think it is logical if you only have two or three items in the shop and the filter exposed all the items this addon offers.

I will just disable the entire filter function via the templates.

​

 
@DragonByte Tech is there any possibility of getting an option so that a product that has been purchased and is in the inventory can be visible and usable even if the category it was purchased from is set to not be viewed?

I am currently using categories to hold different price points for products right now with our custom product type (until I move to eCommerce) and I am using permission to disable those price points from being visible when we do not have that specific sale going. A lot of users buy products in bulk and bank them for the future, so I've had a few panic when they couldn't see their products.

Probably a very niche feature, but hopefully you can consider it.
 
Forsaken said:
@DragonByte Tech is there any possibility of getting an option so that a product that has been purchased and is in the inventory can be visible and usable even if the category it was purchased from is set to not be viewed?

I am currently using categories to hold different price points for products right now with our custom product type (until I move to eCommerce) and I am using permission to disable those price points from being visible when we do not have that specific sale going. A lot of users buy products in bulk and bank them for the future, so I've had a few panic when they couldn't see their products.

Probably a very niche feature, but hopefully you can consider it.
Click to expand...
Feature requests will need to be posted here: https://www.dragonbyte-tech.com/forums/dragonbyte-shop.480/ otherwise they will get lost :)
 
DragonByte Tech updated [DBTech] DragonByte Shop with a new update entry:

Security Notification: XSS in DragonByte Shop v6.1.0 - v6.4.6

Hey all,

An XSS security issue has been discovered affecting all versions of DragonByte Shop from v6.1.0 to v6.4.6. This issue is critical in nature and you should patch your site immediately. This affects XenForo 2.0, 2.1 and 2.2 versions.

All affected versions of DragonByte Shop have been patched, so even if your license has expired or you cannot update for whatever, you can still login and download a fixed version of the version you're currently running.

If you cannot login or...
Click to expand...

Read the rest of this update entry...
 
Forsaken said:
This update breaks the formatting for posts.

Apparently already hotfixed as I posted.
Click to expand...
Yeah, I noticed that myself and patched all versions - thankfully I still had the files open in my editor, otherwise it woulda taken a hot minute to edit a trillion old versions :p

Sorry about that :(
 
DragonByte Tech said:
Yeah, I noticed that myself and patched all versions - thankfully I still had the files open in my editor, otherwise it woulda taken a hot minute to edit a trillion old versions :p

Sorry about that :(
Click to expand...
Np, my website is use to random things happen whether they want them to or not.
 
Getting this error when members try to use the trade system.

Code: 
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xf_dbtech_shop_trade_offer.trade_id' in 'where clause' src/XF/Db/AbstractStatement.php:228

Code: 
            SELECT [ICODE]xf_dbtech_shop_trade_offer[/ICODE].[I], [ICODE]xf_dbtech_shop_trade_Trade_1[/ICODE].[/I], [ICODE]xf_user_User_2[/ICODE].*
            FROM [ICODE]xf_dbtech_shop_trade_offer[/ICODE]
            LEFT JOIN [ICODE]xf_dbtech_shop_trade[/ICODE] AS [ICODE]xf_dbtech_shop_trade_Trade_1[/ICODE] ON ([ICODE]xf_dbtech_shop_trade_Trade_1[/ICODE].[ICODE]trade_id[/ICODE] = [ICODE]xf_dbtech_shop_trade_offer[/ICODE].[ICODE]trade_id[/ICODE])
LEFT JOIN [ICODE]xf_user[/ICODE] AS [ICODE]xf_user_User_2[/ICODE] ON ([ICODE]xf_user_User_2[/ICODE].[ICODE]user_id[/ICODE] = [ICODE]xf_dbtech_shop_trade_offer[/ICODE].[ICODE]user_id[/ICODE])
            WHERE ([ICODE]xf_dbtech_shop_trade_offer[/ICODE].[ICODE]trade_id[/ICODE] = 2)
          
      
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Mvc/Entity/Finder.php(1379): XF\Db\AbstractAdapter->query('
            SELECT `xf_...')
#5 src/XF/Mvc/Entity/Manager.php(378): XF\Mvc\Entity\Finder->fetch()
#6 src/XF/Mvc/Entity/Entity.php(394): XF\Mvc\Entity\Manager->getRelation(Array, Object(DBTech\Shop\Entity\Trade))
#7 src/XF/Mvc/Entity/Entity.php(186): XF\Mvc\Entity\Entity->getRelation('Offers')
#8 src/XF/Mvc/Entity/Entity.php(110): XF\Mvc\Entity\Entity->get('Offers')
#9 src/addons/DBTech/Shop/Pub/Controller/Trade.php(208): XF\Mvc\Entity\Entity->__get('Offers')
#10 src/XF/Mvc/Dispatcher.php(350): DBTech\Shop\Pub\Controller\Trade->actionView(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('DBTech\\Shop\\Pub...', 'View', Object(XF\Mvc\RouteMatch), Object(DBTech\Shop\Pub\Controller\Trade), Object(XF\Mvc\Reply\Reroute))
#12 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(DBTech\Shop\Pub\Controller\Trade), Object(XF\Mvc\Reply\Reroute))
#13 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#15 src/XF.php(488): XF\App->run()
#16 index.php(20): XF::runApp('XF\\Pub\\App')
#17 {main}/code]

And this one when I attempt to merge:

Code: 
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'user_id' in 'where clause' src/XF/Db/AbstractStatement.php:228

Code: 
UPDATE  `xf_dbtech_shop_trade_offer` SET `user_id` = ? WHERE user_id = ?
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(322): XF\Db\AbstractAdapter->query('UPDATE  `xf_dbt...', Array)
#5 src/addons/DBTech/Shop/XF/Service/User/Merge.php(86): XF\Db\AbstractAdapter->update('xf_dbtech_shop_...', Array, 'user_id = ?', Array)
#6 src/addons/SV/SignupAbuseBlocking/XF/Service/User/Merge.php(10): DBTech\Shop\XF\Service\User\Merge->postMergeCleanUp()
#7 src/XF/Service/User/Merge.php(273): SV\SignupAbuseBlocking\XF\Service\User\Merge->postMergeCleanUp()
#8 src/XF/MultiPartRunnerTrait.php(48): XF\Service\User\Merge->stepFinalizeMerge(NULL, 7.87827)
#9 src/XF/Service/User/Merge.php(90): XF\Service\User\Merge->runLoop(8)
#10 src/XF/Job/UserMerge.php(39): XF\Service\User\Merge->merge(8)
#11 src/XF/Job/Manager.php(258): XF\Job\UserMerge->run(8)
#12 src/addons/Hampel/JobRunner/XF/Job/Manager.php(87): XF\Job\Manager->runJobInternal(Array, 8)
#13 src/XF/Job/Manager.php(200): Hampel\JobRunner\XF\Job\Manager->runJobInternal(Array, 8)
#14 src/addons/Hampel/JobRunner/XF/Job/Manager.php(80): XF\Job\Manager->runJobEntry(Array, 8)
#15 src/XF/Job/Manager.php(116): Hampel\JobRunner\XF\Job\Manager->runJobEntry(Array, 8)
#16 src/XF/Admin/Controller/Tools.php(120): XF\Job\Manager->runByIds(Array, 8)
#17 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#18 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(NF\Discord\XF\Admin\Controller\Tools), NULL)
#19 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(NF\Discord\XF\Admin\Controller\Tools), NULL)
#20 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#21 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#22 src/XF.php(488): XF\App->run()
#23 admin.php(13): XF::runApp('XF\\Admin\\App')
#24 {main}
 
DragonByte Tech updated [DBTech] DragonByte Shop with a new update entry:

6.4.8

Update highlights

This version resolves a regression from v6.4.6 as well as improving the checkout experience by making it possible to gift the same item during checkout to multiple users simultaneously.


Complete Change Log

Feature: It is now possible to gift the same item during checkout to multiple users simultaneously
Fix: Fix regression from 6.4.6 that caused issues when purchasing items
Click to expand...

Read the rest of this update entry...
 
Getting this error with the latest update:

Code: 
XF\Db\DuplicateKeyException: Batch install error: xf_dbtech_shop_trade_offer: MySQL query error [1062]: Duplicate entry '0-0-dbtech_shop_purchase-0' for key 'PRIMARY'src/XF/Db/AbstractStatement.php:228

ALTER TABLE `xf_dbtech_shop_trade_offer`
MODIFY COLUMN `quantity` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `trade_id` INT UNSIGNED NOT NULL,
ADD `user_id` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `content_type` VARCHAR(25) NOT NULL DEFAULT 'dbtech_shop_purchase',
ADD `content_id` INT UNSIGNED NOT NULL,
ADD `finalized` TINYINT UNSIGNED NOT NULL DEFAULT '0',
DROP PRIMARY KEY,
ADD PRIMARY KEY (`trade_id`, `user_id`, `content_type`, `content_id`)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/Schema/AbstractDdl.php(151): XF\Db\AbstractAdapter->query('ALTER TABLE `xf...')
#4 src/XF/Db/SchemaManager.php(149): XF\Db\Schema\AbstractDdl->apply()
#5 src/addons/DBTech/Shop/Setup.php(313): XF\Db\SchemaManager->alterTable('xf_dbtech_shop_...', Object(Closure))
#6 src/addons/DBTech/Shop/Install/Upgrade906049970Trait.php(20): DBTech\Shop\Setup->applyTables()
#7 src/XF/AddOn/StepRunnerUpgradeTrait.php(122): DBTech\Shop\Setup->upgrade906040870Step1(Array)
#8 src/XF/AddOn/StepRunnerUpgradeTrait.php(71): DBTech\Shop\Setup->upgradeStepRunner(906040870, 1, Array, NULL)
#9 src/XF/Job/AddOnInstallBatch.php(297): DBTech\Shop\Setup->upgrade(Array)
#10 src/XF/Job/AddOnInstallBatch.php(89): XF\Job\AddOnInstallBatch->stepAction(Object(XF\Timer))
#11 src/XF/Job/Manager.php(258): XF\Job\AddOnInstallBatch->run(8)
#12 src/addons/Hampel/JobRunner/XF/Job/Manager.php(87): XF\Job\Manager->runJobInternal(Array, 8)
#13 src/XF/Job/Manager.php(200): Hampel\JobRunner\XF\Job\Manager->runJobInternal(Array, 8)
#14 src/addons/Hampel/JobRunner/XF/Job/Manager.php(80): XF\Job\Manager->runJobEntry(Array, 8)
#15 src/XF/Job/Manager.php(116): Hampel\JobRunner\XF\Job\Manager->runJobEntry(Array, 8)
#16 src/XF/Admin/Controller/Tools.php(120): XF\Job\Manager->runByIds(Array, 8)
#17 src/XF/Mvc/Dispatcher.php(350): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#18 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(NF\Discord\XF\Admin\Controller\Tools), NULL)
#19 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(NF\Discord\XF\Admin\Controller\Tools), NULL)
#20 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#21 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#22 src/XF.php(488): XF\App->run()
#23 admin.php(13): XF::runApp('XF\\Admin\\App')
#24 {main}
 
Howdy!

I'm having an odd issue with this addon, namely that inventories when viewed from member profiles don't paginate right. Instead, all the pagination links just point you to your own inventory, like https://www.ninpocho.com/shinobi-shop/inventory/?page=2 instead of being in the tab on the member profile.
Weirdly enough, if I head over to https://www.ninpocho.com/shinobi-shop/inventory/?user_id=685&page=2 manually, it works just fine. But the pagination links seem to forget the user_id part of the url.
It worked just fine prior to updating to XenForo 2.2 (and the 6.4.7 of this addon), even with our route redirect in place from dbtech-shop to shinobi-shop.
 
You must log in or register to reply here.

Similar threads

DragonByte Tech
[DBTech] DragonByte Bluesky Poster
2
Replies
30
Views
441
DragonByte Tech
DragonByte Tech
VisEntities
DBTech DragonByte eCommerce vs XFA RM Marketplace?
Replies
0
Views
95
VisEntities
VisEntities
DragonByte Tech
[DBTech] DragonByte Stripe Checkout
2
Replies
33
Views
902
DragonByte Tech
DragonByte Tech
DragonByte Tech
[DBTech] DragonByte WebP
2
Replies
21
Views
1K
Yenxji
Yenxji
DragonByte Tech
[DBTech] DragonByte Social Groups [Paid]
8 9 10
Replies
180
Views
7K
DragonByte Tech
DragonByte Tech
Back
Top Bottom