[WBB4 Connect] funktion.php

<?php
use wcf\system\session\SessionHandler;

$db_wbb4_host       = '';//wbb4 mysql ip
$db_wbb4_user       = '';//wbb4 mysql user
$db_wbb4_pass       = '';//wbb4 mysql pass
$db_wbb4_database   = '';//wbb4 mysql datenbank
$wbb4_link = mysql_connect($db_wbb4_host,$db_wbb4_user,$db_wbb4_pass,true) or die('Unable to establish a DB connection');
mysql_select_db($db_wbb4_database,$wbb4_link);

class SAMPWBB4
{
    public static function Create($name,$pw,$email)
    {
        require_once('../wbb4/global.php');
        require_once('../wbb4/wcf/lib/data/user/UserAction.class.php');
        $data=array("username"=>$name, "password"=>$pw, "email"=>$email);
        $action = new wcf\data\user\UserAction(array(), 'create', array('data' => $data));
        $returnValues = $action->executeAction();
        $user = $returnValues['returnValues'];
        echo $user;
    }
    public static function BanUser($userID,$name,$reason,$banname)
    {
        require_once('../wbb4/global.php');
        require_once('../wbb4/wcf/lib/data/user/UserAction.class.php');
        $userIDs = array($userID);
        $groupIDs = array(1,3,14,15);
        $action = new wcf\data\user\UserAction($userIDs, 'addToGroups', array('groups' => $groupIDs,'addDefaultGroups' => false, 'deleteOldGroups' => true));
        $action->executeAction();
        $sql = "UPDATE wcf1_user SET userOnlineGroupID = '15', rankID = '16', banned = '1', banReason= '".$name." - ".$reason." (Von ".$banname.")' WHERE userID= '".$userID."'";//Benutzer bannen
        $result = mysql_query($sql);
        SessionHandler::resetSessions($userIDs);
    }
    public static function UnBanUser($userID)
    {
        $sql = "UPDATE wcf1_user SET banned = '0' WHERE userID= '".$userID."'";//Benutzer entbannen
        $result = mysql_query($sql);
    }
    public static function Update($userID,$TeamLevel,$userName)
    {
        require_once('../wbb4/global.php');
        require_once('../wbb4/wcf/lib/data/user/UserAction.class.php');
        $userIDs = array($userID);
        //
        $groupIDs = array(1,3,14);
        $action = new wcf\data\user\UserAction($userIDs, 'addToGroups', array('groups' => $groupIDs,'addDefaultGroups' => false, 'deleteOldGroups' => true));
        $action->executeAction();
        $sql = "UPDATE wcf1_user SET userOnlineGroupID = '14',rankID = '14',username = '".$userName."' WHERE userID= '".$userID."'";
        $result = mysql_query($sql);
        if($TeamLevel == 1 || $TeamLevel == 2)
        {
            $groupIDs = array(8);
            $action = new wcf\data\user\UserAction($userIDs, 'addToGroups', array('groups' => $groupIDs,'addDefaultGroups' => false, 'deleteOldGroups' => false));
            $action->executeAction();
            $sql = "UPDATE wcf1_user SET userOnlineGroupID = '8',rankID = '11' WHERE userID= '".$userID."'";
            $result = mysql_query($sql);
        }
        elseif($TeamLevel == 3)
        {
            $groupIDs = array(9);
            $action = new wcf\data\user\UserAction($userIDs, 'addToGroups', array('groups' => $groupIDs,'addDefaultGroups' => false, 'deleteOldGroups' => false));
            $action->executeAction();
            $sql = "UPDATE wcf1_user SET userOnlineGroupID = '9',rankID = '12' WHERE userID= '".$userID."'";
            $result = mysql_query($sql);
        }
        elseif($TeamLevel == 4)
        {
            $groupIDs = array(10);
            $action = new wcf\data\user\UserAction($userIDs, 'addToGroups', array('groups' => $groupIDs,'addDefaultGroups' => false, 'deleteOldGroups' => false));
            $action->executeAction();
            $sql = "UPDATE wcf1_user SET userOnlineGroupID = '10',rankID = '13' WHERE userID= '".$userID."'";
            $result = mysql_query($sql);
        }
        elseif($TeamLevel == 5)
        {
            $groupIDs = array(7);
            $action = new wcf\data\user\UserAction($userIDs, 'addToGroups', array('groups' => $groupIDs,'addDefaultGroups' => false, 'deleteOldGroups' => false));
            $action->executeAction();
            $sql = "UPDATE wcf1_user SET userOnlineGroupID = '7',rankID = '10' WHERE userID= '".$userID."'";
            $result = mysql_query($sql);
        }
        SessionHandler::resetSessions($userIDs);
        self::Update($userID,$TeamLevel,$userName);
    }
}
?>