TFS 1.X+ Error Transferring

[adrenyslopez]

Hello, good evening, does anyone have any idea about this error?



This is the error in the error.log of /var/log/apache2/

PHP Fatal error:  Uncaught Error: Call to a member function rowCount() on bool in /var/www/html/pages/ws_login.php:139\nStack trace:\n#0 /var/www/html/system/load.page.php(7): include()\n#1 /var/www/html/index.php(37): include_once('/var/www/html/s...')\n#2 /var/www/html/login.php(4): include('/var/www/html/i...')\n#3 {main}\n  thrown in /var/www/html/pages/ws_login.php on line 139

This is my login.php located at /var/www/html/

<?php
$_GET['subtopic'] = 'ws_login';
$_REQUEST['subtopic'] = 'ws_login';
include('index.php');

This is my ws login.php located at /var/www/html/pages/

<?php
header('Content-Type: application/json');

if(!defined('INITIALIZED'))
    exit;

# error function
function sendError($msg){
    $ret = [];
    $ret["errorCode"] = 3;
    $ret["errorMessage"] = $msg;
    die(json_encode($ret));
}
# event schedule function
function parseEvent($table1, $date, $table2, $bool){
if ($table1) {
    if ($date) {
        if ($table2) {
            $date = $table1->getAttribute('startdate');
            return date_create("{$date}")->format('U');
        } else {
            $date = $table1->getAttribute('enddate');
            return date_create("{$date}")->format('U');
        }
    } else {
        foreach($table1 as $attr) {
            if ($attr) {
                if ($bool) {
                    if (intval($attr->getAttribute($table2)) > 0) {
                        return true;
                    }
                        return false;
                }
                return $attr->getAttribute($table2);
            }
        }
    }
}
    return;
}

$request = file_get_contents('php://input');
$result = json_decode($request);
$action = isset($result->type) ? $result->type : '';

switch ($action) {
    case 'cacheinfo':
        $playersonline = $SQL->query("select count(*) from `players_online`")->fetchAll();
        die(json_encode([
            'playersonline' => (intval($playersonline[0][0])),
            'twitchstreams' => 0,
            'twitchviewer' => 0,
            'gamingyoutubestreams' => 0,
            'gamingyoutubeviewer' => 0
        ]));
    break;
    case 'eventschedule':
    $eventlist = array();
    $lastupdatetimestamp = time();
    $file_path = Website::getWebsiteConfig()->getValue('serverPath') . 'data/XML/events.xml';
    if (!Website::fileExists($file_path)) {
        die(json_encode([]));
        break;
    }
    $xml = new DOMDocument;
    $xml->load($file_path);
    $tableevent = $xml->getElementsByTagName('event');
    foreach ($tableevent as $event) {
        if ($event) {
        $tmplist = array();
        $tmplist['colorlight'] = parseEvent($event->getElementsByTagName('colors'), false, 'colorlight', false);
        $tmplist['colordark'] = parseEvent($event->getElementsByTagName('colors'), false, 'colordark', false);
        $tmplist['description'] = parseEvent($event->getElementsByTagName('description'), false, 'description', false);
        $tmplist['displaypriority'] = (intval(parseEvent($event->getElementsByTagName('details'), false, 'displaypriority', false)));
        $tmplist['enddate'] = (intval(parseEvent($event, true, false, false)));
        $tmplist['isseasonal'] = parseEvent($event->getElementsByTagName('details'), false, 'isseasonal', true);
        $tmplist['name'] = $event->getAttribute('name');
        $tmplist['startdate'] = (intval(parseEvent($event, true, true, false)));
        $tmplist['specialevent'] = (intval(parseEvent($event->getElementsByTagName('details'), false, 'specialevent', false)));
        $eventlist[] = $tmplist;
        }
    }
    die(json_encode(compact('eventlist', 'lastupdatetimestamp')));
    break;
    case 'boostedcreature':
        $boostDB = $SQL->query("select * from " . $SQL->tableName('boosted_creature'))->fetchAll();
        foreach ($boostDB as $Tableboost) {
        die(json_encode([
            'boostedcreature' => true,
            'raceid' => intval($Tableboost['raceid'])
        ]));
        }
    break;
    case 'login':
    
        $port = Website::getServerConfig()->getValue('gameProtocolPort');
    
        // default world info
        $world = [
            'id' => 0,
            'name' => Website::getServerConfig()->getValue('serverName'),
            'externaladdress' => Website::getServerConfig()->getValue('ip'),
            'externalport' => $port,
            'externaladdressprotected' => Website::getServerConfig()->getValue('ip'),
            'externalportprotected' => $port,
            'externaladdressunprotected' => Website::getServerConfig()->getValue('ip'),
            'externalportunprotected' => $port,
            'previewstate' => 0,
            'location' => 'BRA', // BRA, EUR, USA
            'anticheatprotection' => false,
            'pvptype' => array_search(Website::getServerConfig()->getValue('worldType'), ['pvp', 'no-pvp', 'pvp-enforced']),
            'istournamentworld' => false,
            'restrictedstore' => false,
            'currenttournamentphase' => 2
        ];
        $characters = [];
        $account = null;
        
        // common columns
        $columns = 'name, level, sex, vocation, looktype, lookhead, lookbody, looklegs, lookfeet, lookaddons, lastlogin, isreward, istutorial';
        
        $account = new Account();
        $account->loadByEmail($result->email);
        $current_password = Website::encryptPassword($result->password);
        if (!$account->isLoaded() || !$account->isValidPassword($result->password)) {
            sendError('Email or password is not correct.');
        }
        $players = $SQL->query("select {$columns} from players where account_id = " . $account->getId() . " AND deleted = 0 order by name asc");
        if($players && $players->rowCount() > 0) {
            $players = $players->fetchAll();
            foreach ($players as $player) {
                $characters[] = create_char($player);
            }
        }

        $save = false;
        $timeNow = time();
        $query = $SQL->query("select `premdays`, `lastday` from `accounts` where `id` = " . $account->getId());
            if($query->rowCount() > 0) {
                $query = $query->fetch();
                $premDays = (int)$query['premdays'];
                $lastDay = (int)$query['lastday'];
                $lastLogin = $lastDay;
            }
            else {
                sendError("Error while fetching your account data. Please contact admin.");
        }
        if($premDays != 0 && $premDays != PHP_INT_MAX ) {
            if($lastDay == 0) {
                $lastDay = $timeNow;
                $save = true;
            } else {
                $days = (int)(($timeNow - $lastDay) / 86400);
                if($days > 0) {
                    if($days >= $premDays) {
                        $premDays = 0;
                        $lastDay = 0;
                    } else {
                        $premDays -= $days;
                        $reminder = (int)(($timeNow - $lastDay) % 86400);
                        $lastDay = $timeNow - $reminder;
                    }

                    $save = true;
                }
            }
        } else if ($lastDay != 0) {
            $lastDay = 0;
            $save = true;
        }
        if($save) {
            $SQL->query("update `accounts` set `premdays` = " . $premDays . ", `lastday` = " . $lastDay . " where `id` = " . $account->getId());
        }
        $premiumAccount = $premDays > 0;
        $timePremium = time() + ($premDays * 86400);

        $worlds = [$world];
        $playdata = compact('worlds', 'characters');
        $session = [
            'sessionkey' => "$result->email\n$result->password",
            'lastlogintime' => (!$account) ? 0 : $account->getLastLogin(),
            'ispremium' => Website::getServerConfig()->getValue('freePremium') ? true : $account->isPremium(),
            'premiumuntil' => ($account->getPremDays()) > 0 ? (time() + ($account->getPremDays() * 86400)) : 0,
            'status' => 'active', // active, frozen or suspended
            'returnernotification' => false,
            'showrewardnews' => true,
            'isreturner' => true,
            'fpstracking' => false,
            'optiontracking' => false,
            'tournamentticketpurchasestate' => 0,
            'emailcoderequest' => false
        ];
        die(json_encode(compact('session', 'playdata')));
    break;
    
    default:
        sendError("Unrecognized event {$action}.");
    break;
}
function create_char($player) {
    return [
        'worldid' => 0,
        'name' => $player['name'],
        'ismale' => intval($player['sex']) === 1,
        'tutorial' => (bool)$player['istutorial'],
        'level' => intval($player['level']),
        'vocation' => Website::getVocationName($player['vocation']),
        'outfitid' => intval($player['looktype']),
        'headcolor' => intval($player['lookhead']),
        'torsocolor' => intval($player['lookbody']),
        'legscolor' => intval($player['looklegs']),
        'detailcolor' => intval($player['lookfeet']),
        'addonsflags' => intval($player['lookaddons']),
        'ishidden' => 0,
        'istournamentparticipant' => false,
        'ismaincharacter' => true,
        'dailyrewardstate' => intval($player['isreward']),
        'remainingdailytournamentplaytime' => 0
    ];
}

I am using this gesior :

GitHub - gesior/Gesior2012: Gesior 2012 - Account Maker [website] for OTSes, account maker you can find in BRANCHES. Select 'branch'.

Gesior 2012 - Account Maker [website] for OTSes, account maker you can find in BRANCHES. Select 'branch'. - gesior/Gesior2012

github.com

I use this tfs:

GitHub - otland/forgottenserver: A free and open-source MMORPG server emulator written in C++

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com