Ir para conteúdo

Featured Replies

  • Respostas 288
  • Visualizações 49.5k
  • Created
  • Última resposta

Top Posters In This Topic

Most Popular Posts

  • @quebra me passa o ip que vc quer e eu altero. @cleo mudar o treino offline é nas sources no arquivo player.h e recompilar com o tempo de acordo como vc quiser. ATT, Jaurez @luan

  • @GCManeiro Amigo eu uso um gesior que baixei de um tópico aqui mesmo do TK, existem vários, faça o download e teste, assim como eu fiz, logo vc acha um ideal para oq precisa. Estou utilizando ess

  • @Mall Basta baixar o novo remeres, instale, abra e clique em "IMPORT MAP",  busque por remeres 3.3, instale e teste (sugiro que baixe pelo github), qqr problema ou se funcionou comente aqui.

Posted Images

Postado
Em 26/08/2017 em 18:00, Jaurez disse:

@AugustoEdge já tem como comprar COINS dentro do jogo, só falar com o npc Benjamin (dp thais), ele vende scroll por $1.000.000 que dá 100 coins , o valor e quantidade pode ser editado.

@AugustoEdge sobre a versão do xampp, eu uso uma mais antiga que eu, hehehehe e funciona perfeitamente.

o login.php não precisa ser editado, é só colocar dentro do htdocs do xampp e logar com o client 11

@galokoao sobre a database tens razão, precisa usar a que está no download do server. Sobre add coins na account esse exemplo que sugeriu seria muito complicado fazer um a um, eu já fiz isso e sei que dá trabalho, já add um recurso para comprar os coins no game.

 

Entendi, perdoe, interpretei errado!! 

Postado

Olá,

 

Não estou conseguindo importar as tabelas do arquivo "otserv.cpp" (seria esse o schema.sql, correto?), se não, qual seria o correto a importar?

 

Pelo console recebo inúmeras msg's de erro de syntax (anexo1) e pelo phpmyAdmin 3 erros (anexo2) - também coloquei abaixo como spoiler.

 

Spoiler

MariaDB [oganza]> \s
--------------
C:\xampp\mysql\bin\mysql  Ver 15.1 Distrib 10.1.26-MariaDB, for Win32 (AMD64)

Connection id:          24
Current database:       oganza
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server:                 MariaDB
Server version:         10.1.26-MariaDB mariadb.org binary distribution
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 1 hour 44 min 36 sec

Threads: 1  Questions: 2775  Slow queries: 0  Opens: 26  Flush tables: 1  Open tables: 20  Queries per second avg: 0.442
--------------

MariaDB [oganza]> \. otserv.cpp
ERROR 1064 (42000) at line 38 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// TODO:

DatabaseTasks g_databaseTasks' at line 1
ERROR 1064 (42000) at line 41 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Dispatcher g_dispatcher' at line 1
ERROR 1064 (42000) at line 42 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Scheduler g_scheduler' at line 1
ERROR 1064 (42000) at line 44 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Game g_game' at line 1
ERROR 1064 (42000) at line 45 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ConfigManager g_config' at line 1
ERROR 1064 (42000) at line 46 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Monsters g_monsters' at line 1
ERROR 1064 (42000) at line 47 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Vocations g_vocations' at line 1
ERROR 1064 (42000) at line 48 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RSA g_RSA' at line 1
ERROR 1064 (42000) at line 50 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::mutex g_loaderLock' at line 1
ERROR 1064 (42000) at line 51 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::condition_variable g_loaderSignal' at line 1
ERROR 1064 (42000) at line 52 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::unique_lock<std::mutex> g_loaderUniqueLock(g_loaderLock)' at line 1
ERROR 1064 (42000) at line 54 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'void startupErrorMessage(const std::string& errorStr)
{
        std::cout << "> ERROR: ' at line 1
ERROR 1064 (42000) at line 57 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_loaderSignal.notify_all()' at line 1
ERROR 1064 (42000) at line 58 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

void mainLoader(int argc, char* argv[], ServiceManager* servicer)' at line 1
ERROR 1064 (42000) at line 62 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'void badAllocationHandler()
{
        // Use functions that only use stack allocation
        ' at line 1
ERROR 1064 (42000) at line 66 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'getchar()' at line 1
ERROR 1064 (42000) at line 67 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'exit(-1)' at line 1
ERROR 1064 (42000) at line 68 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

int main(int argc, char* argv[])
{
        // Setup bad allocation handler
        std::set' at line 1
ERROR 1064 (42000) at line 75 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ServiceManager serviceManager' at line 1
ERROR 1064 (42000) at line 77 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_dispatcher.start()' at line 1
ERROR 1064 (42000) at line 78 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_scheduler.start()' at line 1
ERROR 1064 (42000) at line 80 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_dispatcher.addTask(createTask(std::bind(mainLoader, argc, argv, &serviceManage' at line 1
ERROR 1064 (42000) at line 82 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_loaderSignal.wait(g_loaderUniqueLock)' at line 1
ERROR 1064 (42000) at line 84 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
                std::cout << ">> " << g_config.getString(ConfigManager::SERVER_NAME) << " On' at line 1
ERROR 1064 (42000) at line 86 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'serviceManager.run()' at line 1
ERROR 1064 (42000) at line 87 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else {
                std::cout << ">> Nenhum servi├ºo rodando. O servidor N├âO est├í onlin' at line 1
ERROR 1064 (42000) at line 89 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_scheduler.shutdown()' at line 1
ERROR 1064 (42000) at line 90 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_databaseTasks.shutdown()' at line 1
ERROR 1064 (42000) at line 91 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_dispatcher.shutdown()' at line 1
ERROR 1064 (42000) at line 92 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        g_scheduler.join()' at line 1
ERROR 1064 (42000) at line 95 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_databaseTasks.join()' at line 1
ERROR 1064 (42000) at line 96 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_dispatcher.join()' at line 1
ERROR 1064 (42000) at line 97 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return 0' at line 1
ERROR 1064 (42000) at line 98 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

void mainLoader(int argc, char* argv[], ServiceManager* services)
{
        //dispat' at line 1
ERROR 1064 (42000) at line 105 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'srand(static_cast<unsigned int>(OTSYS_TIME()))' at line 1
ERROR 1064 (42000) at line 107 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SetConsoleTitle(STATUS_SERVER_NAME)' at line 1
ERROR 1064 (42000) at line 109 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "The " << STATUS_SERVER_NAME << " Version: (" << STATUS_SERVER_VERS' at line 1
ERROR 1064 (42000) at line 110 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "Compiled on " << __DATE__ << ' ' << __TIME__ << " for platform "' at line 1
ERROR 1064 (42000) at line 113 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "x64" << std::endl' at line 1
ERROR 1064 (42000) at line 115 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "x86" << std::endl' at line 1
ERROR 1064 (42000) at line 117 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "ARM" << std::endl' at line 1
ERROR 1064 (42000) at line 119 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "unknown" << std::endl' at line 1
ERROR 1064 (42000) at line 121 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << std::endl' at line 1
ERROR 1064 (42000) at line 123 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "Servidor compilado por " << STATUS_SERVER_COMPILERS << "." << std:' at line 1
ERROR 1064 (42000) at line 124 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "Visite meu forum: " << GIT_REPO <<"." << std::endl' at line 1
ERROR 1064 (42000) at line 125 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << std::endl' at line 1
ERROR 1064 (42000) at line 127 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// TODO: dirty for now' at line 1
ERROR 1049 (42000) at line 127 in file: 'otserv.cpp': Unknown database 'stdarg'
ERROR 1064 (42000) at line 128 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
                std::string param = { argv[1] }' at line 1
ERROR 1064 (42000) at line 130 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= "-c") {
                        g_config.setConfigFileLua(argv[2])' at line 1
ERROR 1064 (42000) at line 132 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}
        }

        // read global config
        std::cout << ">> Loading config: " << g_config.get' at line 1
ERROR 1064 (42000) at line 137 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
                startupErrorMessage("Unable to load Config File!")' at line 1
ERROR 1064 (42000) at line 139 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 140 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}


        const std::string& defaultPriority = g_config.getString(ConfigManager::DEFA' at line 1
ERROR 1064 (42000) at line 144 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 0) {
                SetPriorityClass(GetCurrentProcess(), HIGH_PRIORITY_CLASS)' at line 1
ERROR 1064 (42000) at line 146 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (strcasecmp(defaultPriority.c_str(), "above-normal") == 0) {
                SetPrio' at line 1
ERROR 1064 (42000) at line 148 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}


        //set RSA key
        const char* p("142996239624163995200701773828988955507954033' at line 1
ERROR 1064 (42000) at line 153 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'const char* q("76309791959704047218912018477920021255354012927791239372074475745' at line 1
ERROR 1064 (42000) at line 154 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_RSA.setKey(p, q)' at line 1
ERROR 1064 (42000) at line 156 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << ">> Establishing database connection..." << std::flush' at line 1
ERROR 1064 (42000) at line 158 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::getInstance().connect()) {
                startupErrorMessage("Failed to connect to databas' at line 1
ERROR 1064 (42000) at line 160 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 161 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << " MySQL " << Database::getClientVersion() << std::endl' at line 1
ERROR 1064 (42000) at line 165 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// run database manager
        std::cout << ">> Running database manager" << std::endl' at line 1
ERROR 1064 (42000) at line 168 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::isDatabaseSetup()) {
                startupErrorMessage("The database you have specified in' at line 1
ERROR 1064 (42000) at line 170 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 171 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}
        g_databaseTasks.start()' at line 1
ERROR 1064 (42000) at line 174 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DatabaseManager::updateDatabase()' at line 1
ERROR 1064 (42000) at line 176 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::OPTIMIZE_DATABASE) && !DatabaseManager::optimizeTables()) {
                std::cout << "> ' at line 1
ERROR 1064 (42000) at line 178 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        //load vocations
        std::cout << ">> Loading vocations" << std::endl' at line 1
ERROR 1064 (42000) at line 182 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
                startupErrorMessage("Unable to load vocations!")' at line 1
ERROR 1064 (42000) at line 184 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 185 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        // load item data
        std::cout << ">> Loading items" << std::endl' at line 1
ERROR 1064 (42000) at line 189 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::items.loadFromOtb("data/items/items.otb") != ERROR_NONE) {
                startupErrorMessa' at line 1
ERROR 1064 (42000) at line 191 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 192 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        if (!Item::items.loadFromXml()) {
                startupErrorMessage("Unable to load item' at line 1
ERROR 1064 (42000) at line 196 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 197 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << ">> Loading script systems" << std::endl' at line 1
ERROR 1064 (42000) at line 200 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::getInstance().loadScriptSystems()) {
                startupErrorMessage("Failed to load scr' at line 1
ERROR 1064 (42000) at line 202 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 203 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << ">> Loading monsters" << std::endl' at line 1
ERROR 1064 (42000) at line 206 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
                startupErrorMessage("Unable to load monsters!")' at line 1
ERROR 1064 (42000) at line 208 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 209 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << ">> Loading outfits" << std::endl' at line 1
ERROR 1064 (42000) at line 212 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::getInstance().loadFromXml()) {
                startupErrorMessage("Unable to load outfits!"' at line 1
ERROR 1064 (42000) at line 214 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 215 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << ">> Checking world type... " << std::flush' at line 1
ERROR 1064 (42000) at line 218 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::string worldType = asLowerCaseString(g_config.getString(ConfigManager::WORL' at line 1
ERROR 1064 (42000) at line 219 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= "pvp") {
                g_game.setWorldType(WORLD_TYPE_PVP)' at line 1
ERROR 1064 (42000) at line 221 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (worldType == "no-pvp") {
                g_game.setWorldType(WORLD_TYPE_NO_PVP)' at line 1
ERROR 1064 (42000) at line 223 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (worldType == "pvp-enforced") {
                g_game.setWorldType(WORLD_TYPE_PVP_E' at line 1
ERROR 1064 (42000) at line 225 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else {
                std::cout << std::endl' at line 1
ERROR 1064 (42000) at line 228 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::ostringstream ss' at line 1
ERROR 1064 (42000) at line 229 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ss << "> ERROR: Unknown world type: " << g_config.getString(ConfigManager::WORLD' at line 1
ERROR 1064 (42000) at line 230 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'startupErrorMessage(ss.str())' at line 1
ERROR 1064 (42000) at line 231 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 232 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}
        std::cout << asUpperCaseString(worldType) << std::endl' at line 1
ERROR 1064 (42000) at line 235 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << ">> Loading map" << std::endl' at line 1
ERROR 1064 (42000) at line 236 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::MAP_NAME))) {
                startupErrorMessage("Failed to load map")' at line 1
ERROR 1064 (42000) at line 238 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 239 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << ">> Initializing gamestate" << std::endl' at line 1
ERROR 1064 (42000) at line 242 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_game.setGameState(GAME_STATE_INIT)' at line 1
ERROR 1064 (42000) at line 244 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// Game client protocols
        services->add<ProtocolGame>(g_config.getNumber(ConfigM' at line 1
ERROR 1064 (42000) at line 246 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::ENABLE_LIVE_CASTING)) {
                ProtocolGame::clearLiveCastInfo()' at line 1
ERROR 1064 (42000) at line 248 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'services->add<ProtocolSpectator>(g_config.getNumber(ConfigManager::LIVE_CAST_POR' at line 1
ERROR 1064 (42000) at line 249 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}
        services->add<ProtocolLogin>(g_config.getNumber(ConfigManager::LOGIN_PORT))' at line 1
ERROR 1064 (42000) at line 252 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// OT protocols
        services->add<ProtocolStatus>(g_config.getNumber(ConfigManager:' at line 1
ERROR 1064 (42000) at line 255 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// Legacy login protocol
        services->add<ProtocolOld>(g_config.getNumber(ConfigMa' at line 1
ERROR 1064 (42000) at line 258 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RentPeriod_t rentPeriod' at line 1
ERROR 1064 (42000) at line 259 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::string strRentPeriod = asLowerCaseString(g_config.getString(ConfigManager::' at line 1
ERROR 1064 (42000) at line 261 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= "yearly") {
                rentPeriod = RENTPERIOD_YEARLY' at line 1
ERROR 1064 (42000) at line 263 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (strRentPeriod == "weekly") {
                rentPeriod = RENTPERIOD_WEEKLY' at line 1
ERROR 1064 (42000) at line 265 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (strRentPeriod == "monthly") {
                rentPeriod = RENTPERIOD_MONTHLY' at line 1
ERROR 1064 (42000) at line 267 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (strRentPeriod == "daily") {
                rentPeriod = RENTPERIOD_DAILY' at line 1
ERROR 1064 (42000) at line 269 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else {
                rentPeriod = RENTPERIOD_NEVER' at line 1
ERROR 1064 (42000) at line 271 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        g_game.map.houses.payHouses(rentPeriod)' at line 1
ERROR 1064 (42000) at line 275 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IOMarket::checkExpiredOffers()' at line 1
ERROR 1064 (42000) at line 276 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IOMarket::getInstance().updateStatistics()' at line 1
ERROR 1064 (42000) at line 278 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << ">> Tudo carregado com sucesso, iniciando o servidor..." << std::en' at line 1
ERROR 1064 (42000) at line 281 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 0 || geteuid() == 0) {
                std::cout << "> Warning: " << STATUS_SERVER_NAME << "' at line 1
ERROR 1064 (42000) at line 283 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}


        g_game.start(services)' at line 1
ERROR 1064 (42000) at line 287 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_game.setGameState(GAME_STATE_NORMAL)' at line 1
ERROR 1064 (42000) at line 288 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_loaderSignal.notify_all()' at line 1
ERROR 1064 (42000) at line 289 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}' at line 1
MariaDB [oganza]>
MariaDB [oganza]>
MariaDB [oganza]>

 

Spoiler

Erro
Static analysis:

3 errors were found during analysis.

Unexpected beginning of statement. (near "TODO:" at position 3)
Unexpected beginning of statement. (near "DatabaseTasks" at position 10)
Unexpected beginning of statement. (near "g_databaseTasks" at position 24)
Comando SQL:

// TODO: DatabaseTasks g_databaseTasks

Mensagens do MySQL : Documentação

#1064 - Você tem um erro de sintaxe no seu SQL próximo a '// TODO: 
DatabaseTasks g_databaseTasks' na linha 1

 

Peguei o "otserv.cpp" na pasta \Oganza-Server-master\src do download que fiz no github do inicio do post.

 

Alguém consegue me ajudar? - estou rodando o mysql e o apache pelo XAMPP v3.2.2

ANEXO1 - erro console mysql.txt

ANEXO2 - erro phpmyAdmin.txt

Postado
  • Autor
34 minutos atrás, douglost disse:

Olá,

 

Não estou conseguindo importar as tabelas do arquivo "otserv.cpp" (seria esse o schema.sql, correto?), se não, qual seria o correto a importar?

 

Pelo console recebo inúmeras msg's de erro de syntax (anexo1) e pelo phpmyAdmin 3 erros (anexo2) - também coloquei abaixo como spoiler.

 

  Mostrar conteúdo oculto

MariaDB [oganza]> \s
--------------
C:\xampp\mysql\bin\mysql  Ver 15.1 Distrib 10.1.26-MariaDB, for Win32 (AMD64)

Connection id:          24
Current database:       oganza
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server:                 MariaDB
Server version:         10.1.26-MariaDB mariadb.org binary distribution
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 1 hour 44 min 36 sec

Threads: 1  Questions: 2775  Slow queries: 0  Opens: 26  Flush tables: 1  Open tables: 20  Queries per second avg: 0.442
--------------

MariaDB [oganza]> \. otserv.cpp
ERROR 1064 (42000) at line 38 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// TODO:

DatabaseTasks g_databaseTasks' at line 1
ERROR 1064 (42000) at line 41 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Dispatcher g_dispatcher' at line 1
ERROR 1064 (42000) at line 42 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Scheduler g_scheduler' at line 1
ERROR 1064 (42000) at line 44 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Game g_game' at line 1
ERROR 1064 (42000) at line 45 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ConfigManager g_config' at line 1
ERROR 1064 (42000) at line 46 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Monsters g_monsters' at line 1
ERROR 1064 (42000) at line 47 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Vocations g_vocations' at line 1
ERROR 1064 (42000) at line 48 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RSA g_RSA' at line 1
ERROR 1064 (42000) at line 50 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::mutex g_loaderLock' at line 1
ERROR 1064 (42000) at line 51 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::condition_variable g_loaderSignal' at line 1
ERROR 1064 (42000) at line 52 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::unique_lock<std::mutex> g_loaderUniqueLock(g_loaderLock)' at line 1
ERROR 1064 (42000) at line 54 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'void startupErrorMessage(const std::string& errorStr)
{
        std::cout << "> ERROR: ' at line 1
ERROR 1064 (42000) at line 57 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_loaderSignal.notify_all()' at line 1
ERROR 1064 (42000) at line 58 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

void mainLoader(int argc, char* argv[], ServiceManager* servicer)' at line 1
ERROR 1064 (42000) at line 62 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'void badAllocationHandler()
{
        // Use functions that only use stack allocation
        ' at line 1
ERROR 1064 (42000) at line 66 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'getchar()' at line 1
ERROR 1064 (42000) at line 67 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'exit(-1)' at line 1
ERROR 1064 (42000) at line 68 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

int main(int argc, char* argv[])
{
        // Setup bad allocation handler
        std::set' at line 1
ERROR 1064 (42000) at line 75 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ServiceManager serviceManager' at line 1
ERROR 1064 (42000) at line 77 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_dispatcher.start()' at line 1
ERROR 1064 (42000) at line 78 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_scheduler.start()' at line 1
ERROR 1064 (42000) at line 80 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_dispatcher.addTask(createTask(std::bind(mainLoader, argc, argv, &serviceManage' at line 1
ERROR 1064 (42000) at line 82 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_loaderSignal.wait(g_loaderUniqueLock)' at line 1
ERROR 1064 (42000) at line 84 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
                std::cout << ">> " << g_config.getString(ConfigManager::SERVER_NAME) << " On' at line 1
ERROR 1064 (42000) at line 86 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'serviceManager.run()' at line 1
ERROR 1064 (42000) at line 87 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else {
                std::cout << ">> Nenhum servi├ºo rodando. O servidor N├âO est├í onlin' at line 1
ERROR 1064 (42000) at line 89 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_scheduler.shutdown()' at line 1
ERROR 1064 (42000) at line 90 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_databaseTasks.shutdown()' at line 1
ERROR 1064 (42000) at line 91 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_dispatcher.shutdown()' at line 1
ERROR 1064 (42000) at line 92 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        g_scheduler.join()' at line 1
ERROR 1064 (42000) at line 95 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_databaseTasks.join()' at line 1
ERROR 1064 (42000) at line 96 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_dispatcher.join()' at line 1
ERROR 1064 (42000) at line 97 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return 0' at line 1
ERROR 1064 (42000) at line 98 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

void mainLoader(int argc, char* argv[], ServiceManager* services)
{
        //dispat' at line 1
ERROR 1064 (42000) at line 105 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'srand(static_cast<unsigned int>(OTSYS_TIME()))' at line 1
ERROR 1064 (42000) at line 107 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SetConsoleTitle(STATUS_SERVER_NAME)' at line 1
ERROR 1064 (42000) at line 109 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "The " << STATUS_SERVER_NAME << " Version: (" << STATUS_SERVER_VERS' at line 1
ERROR 1064 (42000) at line 110 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "Compiled on " << __DATE__ << ' ' << __TIME__ << " for platform "' at line 1
ERROR 1064 (42000) at line 113 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "x64" << std::endl' at line 1
ERROR 1064 (42000) at line 115 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "x86" << std::endl' at line 1
ERROR 1064 (42000) at line 117 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "ARM" << std::endl' at line 1
ERROR 1064 (42000) at line 119 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "unknown" << std::endl' at line 1
ERROR 1064 (42000) at line 121 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << std::endl' at line 1
ERROR 1064 (42000) at line 123 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "Servidor compilado por " << STATUS_SERVER_COMPILERS << "." << std:' at line 1
ERROR 1064 (42000) at line 124 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << "Visite meu forum: " << GIT_REPO <<"." << std::endl' at line 1
ERROR 1064 (42000) at line 125 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << std::endl' at line 1
ERROR 1064 (42000) at line 127 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// TODO: dirty for now' at line 1
ERROR 1049 (42000) at line 127 in file: 'otserv.cpp': Unknown database 'stdarg'
ERROR 1064 (42000) at line 128 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
                std::string param = { argv[1] }' at line 1
ERROR 1064 (42000) at line 130 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= "-c") {
                        g_config.setConfigFileLua(argv[2])' at line 1
ERROR 1064 (42000) at line 132 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}
        }

        // read global config
        std::cout << ">> Loading config: " << g_config.get' at line 1
ERROR 1064 (42000) at line 137 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
                startupErrorMessage("Unable to load Config File!")' at line 1
ERROR 1064 (42000) at line 139 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 140 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}


        const std::string& defaultPriority = g_config.getString(ConfigManager::DEFA' at line 1
ERROR 1064 (42000) at line 144 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 0) {
                SetPriorityClass(GetCurrentProcess(), HIGH_PRIORITY_CLASS)' at line 1
ERROR 1064 (42000) at line 146 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (strcasecmp(defaultPriority.c_str(), "above-normal") == 0) {
                SetPrio' at line 1
ERROR 1064 (42000) at line 148 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}


        //set RSA key
        const char* p("142996239624163995200701773828988955507954033' at line 1
ERROR 1064 (42000) at line 153 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'const char* q("76309791959704047218912018477920021255354012927791239372074475745' at line 1
ERROR 1064 (42000) at line 154 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_RSA.setKey(p, q)' at line 1
ERROR 1064 (42000) at line 156 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << ">> Establishing database connection..." << std::flush' at line 1
ERROR 1064 (42000) at line 158 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::getInstance().connect()) {
                startupErrorMessage("Failed to connect to databas' at line 1
ERROR 1064 (42000) at line 160 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 161 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << " MySQL " << Database::getClientVersion() << std::endl' at line 1
ERROR 1064 (42000) at line 165 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// run database manager
        std::cout << ">> Running database manager" << std::endl' at line 1
ERROR 1064 (42000) at line 168 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::isDatabaseSetup()) {
                startupErrorMessage("The database you have specified in' at line 1
ERROR 1064 (42000) at line 170 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 171 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}
        g_databaseTasks.start()' at line 1
ERROR 1064 (42000) at line 174 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DatabaseManager::updateDatabase()' at line 1
ERROR 1064 (42000) at line 176 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::OPTIMIZE_DATABASE) && !DatabaseManager::optimizeTables()) {
                std::cout << "> ' at line 1
ERROR 1064 (42000) at line 178 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        //load vocations
        std::cout << ">> Loading vocations" << std::endl' at line 1
ERROR 1064 (42000) at line 182 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
                startupErrorMessage("Unable to load vocations!")' at line 1
ERROR 1064 (42000) at line 184 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 185 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        // load item data
        std::cout << ">> Loading items" << std::endl' at line 1
ERROR 1064 (42000) at line 189 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::items.loadFromOtb("data/items/items.otb") != ERROR_NONE) {
                startupErrorMessa' at line 1
ERROR 1064 (42000) at line 191 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 192 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        if (!Item::items.loadFromXml()) {
                startupErrorMessage("Unable to load item' at line 1
ERROR 1064 (42000) at line 196 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 197 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << ">> Loading script systems" << std::endl' at line 1
ERROR 1064 (42000) at line 200 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::getInstance().loadScriptSystems()) {
                startupErrorMessage("Failed to load scr' at line 1
ERROR 1064 (42000) at line 202 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 203 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << ">> Loading monsters" << std::endl' at line 1
ERROR 1064 (42000) at line 206 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '{
                startupErrorMessage("Unable to load monsters!")' at line 1
ERROR 1064 (42000) at line 208 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 209 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << ">> Loading outfits" << std::endl' at line 1
ERROR 1064 (42000) at line 212 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::getInstance().loadFromXml()) {
                startupErrorMessage("Unable to load outfits!"' at line 1
ERROR 1064 (42000) at line 214 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 215 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << ">> Checking world type... " << std::flush' at line 1
ERROR 1064 (42000) at line 218 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::string worldType = asLowerCaseString(g_config.getString(ConfigManager::WORL' at line 1
ERROR 1064 (42000) at line 219 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= "pvp") {
                g_game.setWorldType(WORLD_TYPE_PVP)' at line 1
ERROR 1064 (42000) at line 221 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (worldType == "no-pvp") {
                g_game.setWorldType(WORLD_TYPE_NO_PVP)' at line 1
ERROR 1064 (42000) at line 223 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (worldType == "pvp-enforced") {
                g_game.setWorldType(WORLD_TYPE_PVP_E' at line 1
ERROR 1064 (42000) at line 225 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else {
                std::cout << std::endl' at line 1
ERROR 1064 (42000) at line 228 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::ostringstream ss' at line 1
ERROR 1064 (42000) at line 229 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ss << "> ERROR: Unknown world type: " << g_config.getString(ConfigManager::WORLD' at line 1
ERROR 1064 (42000) at line 230 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'startupErrorMessage(ss.str())' at line 1
ERROR 1064 (42000) at line 231 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 232 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}
        std::cout << asUpperCaseString(worldType) << std::endl' at line 1
ERROR 1064 (42000) at line 235 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << ">> Loading map" << std::endl' at line 1
ERROR 1064 (42000) at line 236 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::MAP_NAME))) {
                startupErrorMessage("Failed to load map")' at line 1
ERROR 1064 (42000) at line 238 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'return' at line 1
ERROR 1064 (42000) at line 239 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        std::cout << ">> Initializing gamestate" << std::endl' at line 1
ERROR 1064 (42000) at line 242 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_game.setGameState(GAME_STATE_INIT)' at line 1
ERROR 1064 (42000) at line 244 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// Game client protocols
        services->add<ProtocolGame>(g_config.getNumber(ConfigM' at line 1
ERROR 1064 (42000) at line 246 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::ENABLE_LIVE_CASTING)) {
                ProtocolGame::clearLiveCastInfo()' at line 1
ERROR 1064 (42000) at line 248 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'services->add<ProtocolSpectator>(g_config.getNumber(ConfigManager::LIVE_CAST_POR' at line 1
ERROR 1064 (42000) at line 249 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}
        services->add<ProtocolLogin>(g_config.getNumber(ConfigManager::LOGIN_PORT))' at line 1
ERROR 1064 (42000) at line 252 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// OT protocols
        services->add<ProtocolStatus>(g_config.getNumber(ConfigManager:' at line 1
ERROR 1064 (42000) at line 255 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '// Legacy login protocol
        services->add<ProtocolOld>(g_config.getNumber(ConfigMa' at line 1
ERROR 1064 (42000) at line 258 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RentPeriod_t rentPeriod' at line 1
ERROR 1064 (42000) at line 259 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::string strRentPeriod = asLowerCaseString(g_config.getString(ConfigManager::' at line 1
ERROR 1064 (42000) at line 261 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= "yearly") {
                rentPeriod = RENTPERIOD_YEARLY' at line 1
ERROR 1064 (42000) at line 263 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (strRentPeriod == "weekly") {
                rentPeriod = RENTPERIOD_WEEKLY' at line 1
ERROR 1064 (42000) at line 265 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (strRentPeriod == "monthly") {
                rentPeriod = RENTPERIOD_MONTHLY' at line 1
ERROR 1064 (42000) at line 267 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else if (strRentPeriod == "daily") {
                rentPeriod = RENTPERIOD_DAILY' at line 1
ERROR 1064 (42000) at line 269 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '} else {
                rentPeriod = RENTPERIOD_NEVER' at line 1
ERROR 1064 (42000) at line 271 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}

        g_game.map.houses.payHouses(rentPeriod)' at line 1
ERROR 1064 (42000) at line 275 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IOMarket::checkExpiredOffers()' at line 1
ERROR 1064 (42000) at line 276 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IOMarket::getInstance().updateStatistics()' at line 1
ERROR 1064 (42000) at line 278 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'std::cout << ">> Tudo carregado com sucesso, iniciando o servidor..." << std::en' at line 1
ERROR 1064 (42000) at line 281 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= 0 || geteuid() == 0) {
                std::cout << "> Warning: " << STATUS_SERVER_NAME << "' at line 1
ERROR 1064 (42000) at line 283 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}


        g_game.start(services)' at line 1
ERROR 1064 (42000) at line 287 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_game.setGameState(GAME_STATE_NORMAL)' at line 1
ERROR 1064 (42000) at line 288 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'g_loaderSignal.notify_all()' at line 1
ERROR 1064 (42000) at line 289 in file: 'otserv.cpp': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '}' at line 1
MariaDB [oganza]>
MariaDB [oganza]>
MariaDB [oganza]>

 

  Mostrar conteúdo oculto

Erro
Static analysis:

3 errors were found during analysis.

Unexpected beginning of statement. (near "TODO:" at position 3)
Unexpected beginning of statement. (near "DatabaseTasks" at position 10)
Unexpected beginning of statement. (near "g_databaseTasks" at position 24)
Comando SQL:

// TODO: DatabaseTasks g_databaseTasks

Mensagens do MySQL : Documentação

#1064 - Você tem um erro de sintaxe no seu SQL próximo a '// TODO: 
DatabaseTasks g_databaseTasks' na linha 1

 

Peguei o "otserv.cpp" na pasta \Oganza-Server-master\src do download que fiz no github do inicio do post.

 

Alguém consegue me ajudar? - estou rodando o mysql e o apache pelo XAMPP v3.2.2

ANEXO1 - erro console mysql.txt

ANEXO2 - erro phpmyAdmin.txt

@douglost Olá, estou atualizando o servidor, vc fez o download agora? Se sim aguarde uns minutos, estou corrigindo os erros e vou repostar os arquivos certos.

Obrigado.

Postado
24 minutos atrás, Jaurez disse:

@douglost Olá, estou atualizando o servidor, vc fez o download agora? Se sim aguarde uns minutos, estou corrigindo os erros e vou repostar os arquivos certos.

Obrigado.

Olá,

 

Fiz o download a mais ou menos umas 3 horas atras, fiquei "fuçando" nesse meio tempo.

 

Ok, vou aguardar. Obrigado!

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

Visitante
Responder

Quem Está Navegando 0

  • Nenhum usuário registrado visualizando esta página.

Estatísticas dos Fóruns

  • Tópicos 96k
  • Posts 512.6k

Informação Importante

Confirmação de Termo