Olá Pessoal. 

Venho aqui pedir ajuda a vocês, meu ot é 8.6 (forgotten server 0.4).

Quando faço uma conta teste, eu upo alguns leveis e quando deslogo e logo novamente, tudo se perde.
Volto para o level 8 e perco todos os itens que peguei.

 

Agradeço desde já

 

config.lua

	accountManager = "yes"
	namelockManager = "no"
	newPlayerChooseVoc = "yes"
	newPlayerSpawnPosX = 143
	newPlayerSpawnPosY = 61
	newPlayerSpawnPosZ = 8
	newPlayerTownId = 1
	newPlayerLevel = 8
	newPlayerMagicLevel = 0
	generateAccountNumber = "no"

	redSkullLength = 24 * 60 * 60
	blackSkullLength = 48 * 60 * 60
	dailyFragsToRedSkull = 7
	weeklyFragsToRedSkull = 30
	monthlyFragsToRedSkull = 70
	dailyFragsToBlackSkull = dailyFragsToRedSkull
	weeklyFragsToBlackSkull = weeklyFragsToRedSkull
	monthlyFragsToBlackSkull = monthlyFragsToRedSkull
	dailyFragsToBanishment = dailyFragsToRedSkull
	weeklyFragsToBanishment = weeklyFragsToRedSkull
	monthlyFragsToBanishment = monthlyFragsToRedSkull
	blackSkulledDeathHealth = 40
	blackSkulledDeathMana = 0
	useBlackSkull = true
	useFragHandler = true
	advancedFragList = false

	notationsToBan = 3
	warningsToFinalBan = 4
	warningsToDeletion = 5
	banLength = 1 * 24 * 60 * 60
	killsBanLength = 1 * 24 * 60 * 60
	finalBanLength = 1 * 24 * 60 * 60
	ipBanishmentLength = 1 * 24 * 60 * 60
	broadcastBanishments = true
	maxViolationCommentSize = 200
	violationNameReportActionType = 2
	autoBanishUnknownBytes = false

	worldType = "open"
	protectionLevel = 100
	pvpTileIgnoreLevelAndVocationProtection = true
	pzLocked = 2 * 60 * 1000
	huntingDuration = 1 * 60 * 1000
	criticalHitChance = 7
	criticalHitMultiplier = 1
	displayCriticalHitNotify = true
	removeWeaponAmmunition = false
	removeWeaponCharges = true
	removeRuneCharges = false
	whiteSkullTime = 3 * 60 * 1000
	noDamageToSameLookfeet = false
	showHealingDamage = true
	showHealingDamageForMonsters = false
	fieldOwnershipDuration = 5 * 1000
	stopAttackingAtExit = false
	oldConditionAccuracy = false
	loginProtectionPeriod = 10 * 1000
	deathLostPercent = 10
	stairhopDelay = 2 * 1000
	pushCreatureDelay = 2 * 1000
	deathContainerId = 1987
	gainExperienceColor = 215
	addManaSpentInPvPZone = true
	squareColor = 0
	allowFightback = true

	worldId = 0
	ip = "taltaltal.servegame.com"
	bindOnlyConfiguredIpAddress = false
	loginPort = 7171
	gamePort = 7172
	adminPort = 7171
	statusPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = 109
	motd = "Bem Vindo ao Baiak criado por Absolute"
	displayOnOrOffAtCharlist = false
	onePlayerOnlinePerAccount = true
	allowClones = false
	serverName = "Baiak Absolute"
	loginMessage = "Bem Vindo ao Baiak criado por Absolute"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = true
	forceSlowConnectionsToDisconnect = false
	loginOnlyWithLoginServer = false
	premiumPlayerSkipWaitList = false

	sqlType = "sqlite"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = ""
	sqlDatabase = "otserv"
	sqlFile = "Baiak.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

	deathListEnabled = true
	deathListRequiredTime = 1 * 60 * 1000
	deathAssistCount = 19
	maxDeathRecords = 5

	ingameGuildManagement = true
	levelToFormGuild = 150
	premiumDaysToFormGuild = 0
	guildNameMinLength = 4
	guildNameMaxLength = 20

	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 2

	buyableAndSellableHouses = true
	houseNeedPremium = true
	bedsRequirePremium = true
	levelToBuyHouse = 150
	housesPerAccount = 0
	houseRentAsPrice = false
	housePriceAsRent = false
	housePriceEachSquare = 1000
	houseRentPeriod = "never"
	houseCleanOld = 0
	guildHalls = false

	timeBetweenActions = 200
	timeBetweenExActions = 1000
	checkCorpseOwner = true
	hotkeyAimbotEnabled = true
	maximumDoorLevel = 500

	mapName = "Baiak Barao.otbm"
	mapAuthor = "Absolute"
	randomizeTiles = true
	useHouseDataStorage = false
	storeTrash = true
	cleanProtectedZones = true
	mailboxDisabledTowns = "-1"

	defaultPriority = "high"
	niceLevel = 5
	coresUsed = "-1"
	optimizeDatabaseAtStartup = true
	removePremiumOnInit = true
	confirmOutdatedVersion = false

	maxMessageBuffer = 4
	bufferMutedOnSpellFailure = false

	dataDirectory = "data/"
	allowChangeOutfit = true
	allowChangeColors = true
	allowChangeAddons = true
	disableOutfitsForPrivilegedPlayers = false
	bankSystem = true
	saveGlobalStorage = true
	displaySkillLevelOnAdvance = false
	spellNameInsteadOfWords = false
	emoteSpells = true
	promptExceptionTracerErrorBox = true
	storePlayerDirection = false
	monsterLootMessage = 3
	monsterLootMessageType = 25
	separateViplistPerCharacter = false

	ghostModeInvisibleEffect = false
	ghostModeSpellEffects = true

	idleWarningTime = 14 * 60 * 1000
	idleKickTime = 15 * 60 * 1000
	expireReportsAfterReads = 1
	playerQueryDeepness = 2
	maxItemsPerPZTile = 0
	maxItemsPerHouseTile = 0

	freePremium = true
	premiumForPromotion = true

	blessingOnlyPremium = true
	blessingReductionBase = 30
	blessingReductionDecreament = 5
	eachBlessReduction = 8

	experienceStages = "yes"
	rateExperience = 900
	rateExperienceFromPlayers = 0
	rateSkill = 200
	rateMagic = 80
	rateLoot = 10
	rateSpawn = 2

	rateMonsterHealth = 1.0
	rateMonsterMana = 1.0
	rateMonsterAttack = 1.0
	rateMonsterDefense = 1.0

	-- Experience from players
	minLevelThresholdForKilledPlayer = 0.9
	maxLevelThresholdForKilledPlayer = 1.1

	rateStaminaLoss = 1
	rateStaminaGain = 3
	rateStaminaThresholdGain = 12
	staminaRatingLimitTop = 41 * 60
	staminaRatingLimitBottom = 14 * 60
	rateStaminaAboveNormal = 1.5
	rateStaminaUnderNormal = 0.5
	staminaThresholdOnlyPremium = true

	experienceShareRadiusX = 30
	experienceShareRadiusY = 30
	experienceShareRadiusZ = 1
	experienceShareLevelDifference = 2 / 3
	extraPartyExperienceLimit = 20
	extraPartyExperiencePercent = 5
	experienceShareActivity = 2 * 60 * 1000

	globalSaveEnabled = false
	globalSaveHour = 1
	shutdownAtGlobalSave = false
	cleanMapAtGlobalSave = false

	deSpawnRange = 2
	deSpawnRadius = 50

	maxPlayerSummons = 2
	teleportAllSummons = false
	teleportPlayerSummons = false

	ownerName = "Absolute on Tibiaking"
	ownerEmail = "absolute@tibiaking.com"
	url = "www.tibiaking.com"
	location = "Brazil"
	displayGamemastersWithOnlineCommand = false

	adminLogsEnabled = false
	displayPlayersLogging = true
	prefixChannelLogs = ""
	runFile = ""
	outLogName = ""
	errorLogName = ""
	truncateLogsOnStartup = false

Erros:

 

Editado Outubro 21, 2016 8 anos por KingsotServ (veja o histórico de edições)

@KingsotServ Executa essa query no sqlite.

 

DROP TABLE IF EXISTS players;
CREATE TABLE players (
    id                    INTEGER           PRIMARY KEY
                                            NOT NULL,
    name                  VARCHAR( 255 )    NOT NULL,
    world_id              INTEGER           NOT NULL
                                            DEFAULT '0',
    group_id              INTEGER           NOT NULL
                                            DEFAULT '1',
    account_id            INTEGER           NOT NULL,
    level                 INTEGER           NOT NULL
                                            DEFAULT '1',
    vocation              INTEGER           NOT NULL
                                            DEFAULT '0',
    health                INTEGER           NOT NULL
                                            DEFAULT '100',
    healthmax             INTEGER           NOT NULL
                                            DEFAULT '100',
    experience            INTEGER           NOT NULL
                                            DEFAULT '0',
    lookbody              INTEGER           NOT NULL
                                            DEFAULT '10',
    lookfeet              INTEGER           NOT NULL
                                            DEFAULT '10',
    lookhead              INTEGER           NOT NULL
                                            DEFAULT '10',
    looklegs              INTEGER           NOT NULL
                                            DEFAULT '10',
    looktype              INTEGER           NOT NULL
                                            DEFAULT '136',
    lookaddons            INTEGER           NOT NULL
                                            DEFAULT '0',
    lookmount             INTEGER           NOT NULL
                                            DEFAULT '0',
    maglevel              INTEGER           NOT NULL
                                            DEFAULT '0',
    mana                  INTEGER           NOT NULL
                                            DEFAULT '100',
    manamax               INTEGER           NOT NULL
                                            DEFAULT '100',
    manaspent             INTEGER           NOT NULL
                                            DEFAULT '0',
    soul                  INTEGER           NOT NULL
                                            DEFAULT '0',
    town_id               INTEGER           NOT NULL,
    posx                  INTEGER           NOT NULL
                                            DEFAULT '32369',
    posy                  INTEGER           NOT NULL
                                            DEFAULT '32241',
    posz                  INTEGER           NOT NULL
                                            DEFAULT '7',
    conditions            BLOB              NOT NULL,
    cap                   INTEGER           NOT NULL
                                            DEFAULT '0',
    sex                   INTEGER           NOT NULL
                                            DEFAULT '0',
    lastlogin             INTEGER           NOT NULL
                                            DEFAULT '0',
    lastip                INTEGER           NOT NULL
                                            DEFAULT '0',
    save                  BOOLEAN           NOT NULL
                                            DEFAULT 'TRUE',
    skull                 INTEGER           NOT NULL
                                            DEFAULT '0',
    skulltime             INTEGER           NOT NULL
                                            DEFAULT '0',
    rank_id               INTEGER           NOT NULL,
    guildnick             VARCHAR( 255 )    NOT NULL
                                            DEFAULT '''',
    lastlogout            INTEGER           NOT NULL
                                            DEFAULT '0',
    blessings             INTEGER           NOT NULL
                                            DEFAULT '0',
    pvp_blessing          BOOLEAN           NOT NULL
                                            DEFAULT 'FALSE',
    balance               INTEGER           NOT NULL
                                            DEFAULT '0',
    stamina               INTEGER           NOT NULL
                                            DEFAULT '151200000',
    direction             INTEGER           NOT NULL
                                            DEFAULT '2',
    loss_experience       INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_mana             INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_skills           INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_containers       INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_items            INTEGER           NOT NULL
                                            DEFAULT '100',
    premend               INTEGER           NOT NULL
                                            DEFAULT '0',
    online                INTEGER           NOT NULL
                                            DEFAULT '0',
    marriage              INTEGER           NOT NULL
                                            DEFAULT '0',
    promotion             INTEGER           NOT NULL
                                            DEFAULT '0',
    deleted               INTEGER           NOT NULL
                                            DEFAULT '0',
    description           VARCHAR( 255 )    NOT NULL
                                            DEFAULT '''',
    comment               TEXT            NOT NULL,
    create_ip             INT( 11 )       NOT NULL
                                          DEFAULT '0',
    create_date           INT( 11 )       NOT NULL
                                          DEFAULT '0',
    hide_char             INT( 11 )       NOT NULL
                                          DEFAULT '0',
    signature             TEXT            NOT NULL,
    offlinetraining_time  SMALLINT UNSIGNED NOT NULL
                                            DEFAULT '43200',
    offlinetraining_skill INT               NOT NULL
                                            DEFAULT '-1',
    cast                  TINYINT( 4 )    NOT NULL
                                          DEFAULT '0',
    castViewers           INT( 11 )       NOT NULL
                                          DEFAULT '0',
    castDescription       VARCHAR( 255 )  NOT NULL,
    created               INT( 11 )       NOT NULL
                                          DEFAULT '0',
    nick_verify           INT( 11 )       NOT NULL
                                          DEFAULT '0',
    old_name              VARCHAR( 255 )  NOT NULL
                                          DEFAULT '',
    worldtransfer         INT( 11 )       NOT NULL
                                          DEFAULT '0',
    show_outfit           TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_eq               TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_bars             TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_skills           TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_quests           TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    stars                 INT( 10 )       NOT NULL
                                          DEFAULT '0',
    ip                    VARCHAR( 17 )     NOT NULL
                                            DEFAULT '0',
    UNIQUE ( name, deleted ),
    FOREIGN KEY ( account_id ) REFERENCES accounts ( id )
);
INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0);

 

Editado Novembro 2, 2016 8 anos por chbuss (veja o histórico de edições)

esta dando esse erro quando executo o query  Error while executing query: foreign key constraint failed

Ta dando erro pq sua database não tem a tabela cast. (a coluna cast na tabela player*)

ALTER TABLE players ADD COLUMN cast TINYINT( 4 ) NOT NULL;

 

Editado Julho 7, 2018 6 anos por riicksouzaa
erro (veja o histórico de edições)