XF2 [8WR] Discord Integration

XF2 [8WR] Discord Integration [Paid] 2.0.2.1

No permission to buy ($30.00)

Jaxel

Well-known member
#1
Jaxel submitted a new resource:

XF2 [8WR] Discord Integration - Bridges roles and messages from XenForo to Discord

BRANDING REMOVAL can be purchased HERE:

This addon integrates your Discord server with your XenForo forums. It allows you to assign roles on your Discord server based on usergroups in XenForo, as well as post messages directly from XenForo to your Discord server.

Demo:


Basic Features:
  • Allows registration/login...
Read more about this resource...
 
#4
it shows this error:-
An exception occurred: [TypeError] Argument 1 passed to EWR\Discord\Setup::EWR\Discord\{closure}() must be an instance of XF\Db\Schema\Create, instance of XF\Db\Schema\Alter given, called in /var/www/html/src/XF/Db/SchemaManager.php on line 142 in src/addons/EWR/Discord/Setup.php on line 21
  1. EWR\Discord\Setup->EWR\Discord\{closure}() in src/XF/Db/SchemaManager.php at line 142
  2. XF\Db\SchemaManager->alterTable() in src/addons/EWR/Discord/Setup.php at line 24
  3. EWR\Discord\Setup->installStep1() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
  4. EWR\Discord\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
  5. EWR\Discord\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 378
  6. XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 249
  7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
  8. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
  9. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1880
  10. XF\App->run() in src/XF.php at line 328
  11. XF::runApp() in admin.php at line 13
 

kalle

New member
#9
Do you know what to do? Just installed it and followed your youtube guide. Bot is visible on my server but the following error occurs and the discord detail page is not loading the value for "cache.server" from the template and the discord join link doesn't work:

Code:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xf_user_connected_account.sync_date' in 'where clause'
 
src/XF/Db/AbstractStatement.php:212
Generated by: Unknown account
 
Jan 10, 2018 at 8:47 PM
Stack trace
SELECT `xf_user_connected_account`.*, `xf_user_User_1`.*
FROM `xf_user_connected_account`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_connected_account`.`user_id`)
WHERE (`xf_user_connected_account`.`provider` = 'discord') AND (`xf_user_connected_account`.`sync_date` < 1515527278)
ORDER BY `xf_user_connected_account`.`sync_date` ASC

LIMIT 1
------------

#0 src/XF/Db/Mysqli/Statement.php(174): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(35): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(46): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(74): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Mvc/Entity/Finder.php(1101): XF\Db\AbstractAdapter->query('\r\n\t\t\tSELECT `xf...')
#5 src/addons/EWR/Discord/Repository/Discord.php(180): XF\Mvc\Entity\Finder->fetchOne()
#6 src/addons/EWR/Discord/Cron/Sync.php(9): EWR\Discord\Repository\Discord->syncDiscord()
#7 [internal function]: EWR\Discord\Cron\Sync::syncDiscord(Object(XF\Entity\CronEntry))
#8 src/XF/Job/Cron.php(35): call_user_func(Array, Object(XF\Entity\CronEntry))
#9 src/XF/Job/Manager.php(241): XF\Job\Cron->run(7.9999990463257)
#10 src/XF/Job/Manager.php(187): XF\Job\Manager->runJobInternal(Array, 7.9999990463257)
#11 src/XF/Job/Manager.php(76): XF\Job\Manager->runJobEntry(Array, 7.9999990463257)
#12 job.php(15): XF\Job\Manager->runQueue(false, 8)
#13 {main}
Request state
array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(56) "https://*********/admin.php?add-ons/EWR-Discord/options"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
 

Jaxel

Well-known member
#10
Okay... I really screwed up with this install file... uninstall the current version, and re-install with 2.0.0.3 which I will send out in a minute.
 

kalle

New member
#12
Seems to work now. Unfortunately there is one more logged error that appeared on xenforo:

Code:
ErrorException: [E_NOTICE] Array to string conversion src/XF/Db/Mysqli/Statement.php:63
Generated by: kalle Jan 11, 2018 at 6:14 AM
Stack trace
#0 [internal function]: XF::handlePhpError(8, '[E_NOTICE] Arra...', '/*/***/***...', 63, Array)
#1 src/XF/Db/Mysqli/Statement.php(63): mysqli_stmt->execute()
#2 src/XF/Db/AbstractAdapter.php(74): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(150): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/EWR/Discord/Setup.php(35): XF\Db\AbstractAdapter->insert('xf_connected_ac...', Array)
#5 src/XF/AddOn/StepRunnerInstallTrait.php(60): EWR\Discord\Setup->installStep2(Array)
#6 src/XF/AddOn/StepRunnerInstallTrait.php(27): EWR\Discord\Setup->installStepRunner(2, Array)
#7 src/XF/Admin/Controller/AddOn.php(378): EWR\Discord\Setup->install(Array)
#8 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\AddOn->actionInstall(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Install', 'html', Object(XF\Mvc\ParameterBag), 'listAddOns', Object(XF\Admin\Controller\AddOn), NULL)
#10 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(1880): XF\Mvc\Dispatcher->run()
#12 src/XF.php(328): XF\App->run()
#13 admin.php(13): XF::runApp('XF\\Admin\\App')
#14 {main}
Request state
array(4) {
  ["url"] => string(38) "/admin.php?add-ons/EWR-Discord/install"
  ["referrer"] => string(56) "https://****/admin.php?add-ons/EWR-Discord/install"
  ["_GET"] => array(1) {
    ["add-ons/EWR-Discord/install"] => string(0) ""
  }
  ["_POST"] => array(7) {
    ["_xfProcessing"] => string(1) "1"
    ["continue"] => string(1) "1"
    ["confirm"] => string(1) "1"
    ["params"] => string(10) "{"step":2}"
    ["count"] => string(1) "2"
    ["finished"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
  }
}
Also I have some kind of ideas for new features:
  • possibility (or code example) to use your add-on in external code (that is integrated in the xenforo core)
    • I currently have some additional tool and integrated the xenforo permission system into it (loading the xenforo core into this external application) to be able to authenticate users on this application. It would be neat if I could send messages to a specific channel via this script
  • I have own the official Addons for media and resources. It would be great if there is a possibility to embed new media directly into a discord channel and link directly to new resources (even though there will be a new topic created for every resource, but you'll have to click twice to see the resource at all)
Regards,
Kalle
 

3rd AnGle

Well-known member
#13
Dayummm....!! This is good.

@Jaxel could you make a similar one for Slack?

Most of the forum users are now moving to platform like Slack.... although it cannot substitute the in depth discussion of "forum". We need something like this for slack.

Slack is BIG now for team chat. If such a plugin exists for XF it'd be amazing.
 
#14
Downloaded latest version:
Code:
XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry 'discord' for key 'PRIMARY' in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 70
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 74
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 151
XF\Db\AbstractAdapter->insert() in src/addons/EWR/Discord/Setup.php at line 39
EWR\Discord\Setup->installStep2() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
EWR\Discord\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
EWR\Discord\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 378
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1880
XF\App->run() in src/XF.php at line 328
XF::runApp() in admin.php at line 13
I cannot install
 
Last edited:
#16
Hey Jaxel,

Purchased this regardless, awesome add-on. Have a few questions about functionality.

1) From the looks, this add-on is designed for a single discord only. Possibility to add multi-discord support? (Tab at the top not used).

2) If not, are there work arounds to sync multiple discords? (disconnect one server, connect the other, sync. Repeat as needed).

3) Depends on the two answers above, but how does the bot work if set to public?
 

Jaxel

Well-known member
#17
@Jaxel

Do we delete the xF1 version before upgrading to xF2 or do we leave in place and just upgrade it once our board has moved to xF2.
I honestly have no idea how the upgrade process between XF1 versions and XF2 versions work.

Downloaded latest version:
Code:
XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry 'discord' for key 'PRIMARY' in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 70
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 74
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 151
XF\Db\AbstractAdapter->insert() in src/addons/EWR/Discord/Setup.php at line 39
EWR\Discord\Setup->installStep2() in src/XF/AddOn/StepRunnerInstallTrait.php at line 60
EWR\Discord\Setup->installStepRunner() in src/XF/AddOn/StepRunnerInstallTrait.php at line 27
EWR\Discord\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 378
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1880
XF\App->run() in src/XF.php at line 328
XF::runApp() in admin.php at line 13
I cannot install
Do you have other addons installed that add Discord integration? You can only have one.
 
#18
Hey @Jaxel i sent you a mail. What I had before was a widget but I deleted the template and the widget. But still says duplicate 😵 I sent all the error details to mail maybe you could help me out.
 
Top