• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[7.6] - Tibia old full - release

how to correct this error? please help.
here the log.
Code:
:: ==============================================
:: OTserv 7.60
:: Compilation date: Nov 14 2011 14:24:00
:: Modified by Jeffry(Exploit) & Johan(Boman)
:: ==============================================

:: Initializing the random numbers... [done]
:: Loading lua script config.lua... [done]
:: Checking Database Connection... [done]
:: Loading data/vocations.xml... [done]
:: Loading data/commands.xml... [done]
:: Loading data/items/items.otb... [done]
:: Loading data/items/items.xml... [done]
:: Loading Script Systems
:: Loading Weapons ...[done]
:: Loading Spells ...[done]
:: Loading Actions ...[done]
:: Loading Talkactions ...[done]
:: Loading MoveEvents ...[done]
:: Loading CreatureEvents ...[done]
:: Loading data/monsters/monsters.xml... [done]
:: Loading stages.xml... [done]
:: Worldtype: PVP
:: Skull System [ENABLED]
:: Use plain passwords
:: Loading map from: data/world/world.otbm OTBM
:: Map size: 65000x65000
:: OTBM loader took: 55.455 seconds
:: Map load took: 0.121 s
::
:: Running on host Servidor-PC
:: Local IP: 190.200.183.189
:: Local port: 7171
:: Global IP: 127.0.0.1
::
:: Starting OTserv Server [done]
:: OTserv Server Running
mysql_real_query(): SELECT * FROM player_blessings WHERE player_id='1': MYSQL ER
ROR: Table 'realbest.player_blessings' doesn't exist
mysql_store_result(): SELECT * FROM player_blessings WHERE player_id='1': MYSQL
ERROR: Table 'realbest.player_blessings' doesn't exist
mysql_real_query(): UPDATE `players` SET `online` = 1 WHERE `id` = 1: MYSQL ERRO
R: Unknown column 'online' in 'field list'
 
how to correct this error? please help.
here the log.
Code:
:: ==============================================
:: OTserv 7.60
:: Compilation date: Nov 14 2011 14:24:00
:: Modified by Jeffry(Exploit) & Johan(Boman)
:: ==============================================

:: Initializing the random numbers... [done]
:: Loading lua script config.lua... [done]
:: Checking Database Connection... [done]
:: Loading data/vocations.xml... [done]
:: Loading data/commands.xml... [done]
:: Loading data/items/items.otb... [done]
:: Loading data/items/items.xml... [done]
:: Loading Script Systems
:: Loading Weapons ...[done]
:: Loading Spells ...[done]
:: Loading Actions ...[done]
:: Loading Talkactions ...[done]
:: Loading MoveEvents ...[done]
:: Loading CreatureEvents ...[done]
:: Loading data/monsters/monsters.xml... [done]
:: Loading stages.xml... [done]
:: Worldtype: PVP
:: Skull System [ENABLED]
:: Use plain passwords
:: Loading map from: data/world/world.otbm OTBM
:: Map size: 65000x65000
:: OTBM loader took: 55.455 seconds
:: Map load took: 0.121 s
::
:: Running on host Servidor-PC
:: Local IP: 190.200.183.189
:: Local port: 7171
:: Global IP: 127.0.0.1
::
:: Starting OTserv Server [done]
:: OTserv Server Running
mysql_real_query(): SELECT * FROM player_blessings WHERE player_id='1': MYSQL ER
ROR: Table 'realbest.player_blessings' doesn't exist
mysql_store_result(): SELECT * FROM player_blessings WHERE player_id='1': MYSQL
ERROR: Table 'realbest.player_blessings' doesn't exist
mysql_real_query(): UPDATE `players` SET `online` = 1 WHERE `id` = 1: MYSQL ERRO
R: Unknown column 'online' in 'field list'
execute that on phpmyadmin (mysql)

CREATE TABLE `player_blessings` (
`player_id` int(11) NOT NULL,
`blessing` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
 
execute that on phpmyadmin (mysql)

CREATE TABLE `player_blessings` (
`player_id` int(11) NOT NULL,
`blessing` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

thanks friend, now when I connect I get this message.
Code:
:: ==============================================
:: OTserv 7.60
:: Compilation date: Nov 14 2011 14:24:00
:: Modified by Jeffry(Exploit) & Johan(Boman)
:: ==============================================

:: Initializing the random numbers... [done]
:: Loading lua script config.lua... [done]
:: Checking Database Connection... [done]
:: Loading data/vocations.xml... [done]
:: Loading data/commands.xml... [done]
:: Loading data/items/items.otb... [done]
:: Loading data/items/items.xml... [done]
:: Loading Script Systems
:: Loading Weapons ...[done]
:: Loading Spells ...[done]
:: Loading Actions ...[done]
:: Loading Talkactions ...[done]
:: Loading MoveEvents ...[done]
:: Loading CreatureEvents ...[done]
:: Loading data/monsters/monsters.xml... [done]
:: Loading stages.xml... [done]
:: Worldtype: PVP
:: Skull System [ENABLED]
:: Use plain passwords
:: Loading map from: data/world/world.otbm OTBM
:: Map size: 65000x65000
:: OTBM loader took: 62.512 seconds
:: Map load took: 0.009 s
::
:: Running on host Servidor-PC
:: Local IP: 190.200.183.189
:: Local port: 7171
:: Global IP: 127.0.0.1
::
:: Starting OTserv Server [done]
:: OTserv Server Running
mysql_real_query(): UPDATE `players` SET `online` = 1 WHERE `id` = 1: MYSQL ERRO
R: Unknown column 'online' in 'field list'
 
Code:
ALTER TABLE `players` ADD `online` TINYINT(1) NOT NULL DEFAULT 0;
 
You can set the attribute to unsigned as well because you probably won't have less than zero players : p
 
There are a lot of bugs and missing things on this release, will you ask for fixes on everything?
 
you have the source of that?, if u can post the configmanager.cpp for see the function, or search someone about money/cash/etc on your configmanager,cpp,h

cant edit sorry double post, search on your luascript.cpp
 
I have no experience in c + + can you tell me that I should edit?
and how can I recompile this work?

on your sources you have the file luascripts.cpp/.h?, just post or send me with private, or if u wanna i can help you with teamviewer right now i have some time
 
i do not recommend to use this distro...have alot of bugs...
 
Back
Top