XF 2.1 User Upgrade with MySQL Query

[Jerr0w]

Hello,

I would like to upgrade users through MySQL queries. Can somebody tell me which MySQL queries I have to execute to perform it correctly?

 

[Paul B]

We wouldn't recommend using queries - there is a lot of data to update.

Why can't you use the user group promotion system, or the manual promotion method in the ACP?

 

[Jerr0w]

I want to be able to activate users with a PHP script. Is there any other way than MySQL queries?

 

[Jerr0w]

bump

 

[Jerr0w]

Is there no help for this?

It seems like that it's possible to do that through the XenForo Framework

$startTime = microtime(true);
$fileDir = '/path/to/xenforo/root';

require($fileDir . '/library/XenForo/Autoloader.php');
XenForo_Autoloader::getInstance()->setupAutoloader($fileDir . '/library');

XenForo_Application::initialize($fileDir . '/library', $fileDir);
XenForo_Application::set('page_start_time', $startTime);

$dependencies = new XenForo_Dependencies_Public();
$dependencies->preLoadData();

$userUpgradeModel = XenForo_Model::create('XenForo_Model_UserUpgrade');
$userUpgradeModel->upgradeUser($userId, $userUpgradeRecord, true, $endDate);

Is it possible to downgrade subscriptions as well? @Brogan

 

[Jeremy P]

The code you posted is for XF1. There are services for upgrading and downgrading users in XF2 (\XF\Service\User\Upgrade and \XF\Service\User\Downgrade). You can reference \XF\Admin\Controller\UserUpgrade::actionManual() and \XF\Admin\Controller\UserUpgrade::actionDowngrade() to see how they are used.

 

[Jerr0w]

The code you posted is for XF1. There are services for upgrading and downgrading users in XF2 (\XF\Service\User\Upgrade and \XF\Service\User\Downgrade). You can reference \XF\Admin\Controller\UserUpgrade::actionManual() and \XF\Admin\Controller\UserUpgrade::actionDowngrade() to see how they are used.

Thanks. Can you maybe tell me how I can load the XF Framework? Doesn't work as in XF 1.

 

[Jeremy P]

Untested:

<?php

$phpVersion = phpversion();
if (version_compare($phpVersion, '5.6.0', '<'))
{
	die("PHP 5.6.0 or newer is required. $phpVersion does not meet this requirement. Please ask your host to upgrade PHP.");
}

$dir = __DIR__;
require($dir . '/src/XF.php');

\XF::start($dir);
\XF::setupApp('XF\Pub\App');

 

[Jerr0w]

Thank you! Will test it soon

Edit: Works perfectly!

One last question: Can you maybe give me the code for user upgrade/downgrade as well?

 

[Jeremy P]

I'm not familiar enough with the specifics off-hand, but hopefully you can get the gist of it from the admin controller and reading through some of the developer documentation.

 

[Jerr0w]

I've posted a solutiom here (not MySQL!):

XF 2.1 - XF Framework - User Upgrades/Downgrades

Hello, I'm currently coding an external page with PHP and I need to be able to upgrade/downgrade users through the XF framework. Unfortunarely I can't find any references for user upgrade/downgrades. Can someone share some code for User upgrades/downgrades through the XF framework? :) Currenty...

xenforo.com