Adicionado CASTLE WAR.

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!! 

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

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.

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!