magera

Funfou.. REP+

up

Estive com o mesmo problema a alguns dias, procurei uma solução e encontrei este tópico. Após conseguir solucionar meu problema resolvi postar aqui caso alguém tenha o mesmo problema.. Se o char não está salvando as skills é porque provavelmente não existem os registros em players_skills, então vamos adicionar. 1º) Vamos achar o ID do player: Em seu banco de dados vá até a tabela players e clique em pesquisar, localizado na parte superior da pagina (IMAGEM DE UMA LUPA). No bloco "name" digite o nome do player bugado e aperte enter pra executar. Agora basta pegar o ID que é oque precisamos.. 2º) Executando query: Clique em seu banco de dados novamente para voltar a todas as tabelas em seguida iremos em SQL localizado na parte superior da tela. Substitua onde tem ID pelo id do player que acabamos de buscar e execute a query. INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES (ID, 0, 10, 0), (ID, 1, 10, 0), (ID, 2, 13, 60), (ID, 3, 10, 0), (ID, 4, 10, 0), (ID, 5, 11, 25), (ID, 6, 10, 0); Omeu ficou desse jeito: INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES (18, 0, 10, 0), (18, 1, 10, 0), (18, 2, 13, 60), (18, 3, 10, 0), (18, 4, 10, 0), (18, 5, 11, 25), (18, 6, 10, 0);

Reviver o tópico porque estou com o mesmo problema, então é melhor do que criar outro.. ESTOU USANDO OTX, Edit.. Encontrei a solução.. Execute isso no seu banco de dados.. DROP TABLE IF EXISTS `bans`; CREATE TABLE `bans` ( `id` INT UNSIGNED NOT NULL auto_increment, `type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion', `value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number', `param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)', `active` TINYINT(1) NOT NULL DEFAULT TRUE, `expires` INT NOT NULL, `added` INT UNSIGNED NOT NULL, `admin_id` INT UNSIGNED NOT NULL DEFAULT 0, `comment` TEXT NOT NULL, `reason` INT UNSIGNED NOT NULL DEFAULT 0, `action` INT UNSIGNED NOT NULL DEFAULT 0, `statement` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `type` (`type`, `value`), KEY `active` (`active`) ) ENGINE = InnoDB;

Galera é o seguinte, configurei minha config.lua certinho para pegar red 20 frags por dia e o pushCreatureDelay diminuir o tempo, porém quando um jogador mata 3 player já pega red, e o push eu posso colocar 0 que nada acontece. Estou usando OTX Server. Alguém puder ajudar, REP+.

Solved Consegui resolver.. Usei uma source diferente (provavelmente a outra estava zuada) e fiz o atributo no piso (tile). <attribute key="walkStack" value="0" /> Valeu, REP +

Está correto "open" OTX 8.60

OTX 8.60

accountManager = false namelockManager = true newPlayerChooseVoc = true newPlayerSpawnPosX = 159 newPlayerSpawnPosY = 387 newPlayerSpawnPosZ = 6 newPlayerTownId = 2 newPlayerLevel = 8 newPlayerMagicLevel = 0 generateAccountNumber = false generateAccountSalt = false useRookSystem = false rookTownId = 1 rookLevelToGetRooked = 5 rookLevelToLeaveRook = 8 useFragHandler = true redSkullLength = 1 * 24 * 60 * 60 blackSkullLength = 3 * 24 * 60 * 60 dailyFragsToRedSkull = 15 weeklyFragsToRedSkull = 80 monthlyFragsToRedSkull = 120 dailyFragsToBlackSkull = dailyFragsToRedSkull weeklyFragsToBlackSkull = weeklyFragsToRedSkull monthlyFragsToBlackSkull = monthlyFragsToRedSkull dailyFragsToBanishment = dailyFragsToRedSkull weeklyFragsToBanishment = weeklyFragsToRedSkull monthlyFragsToBanishment = monthlyFragsToRedSkull blackSkulledDeathHealth = 40 blackSkulledDeathMana = 0 useBlackSkull = true advancedFragList = false enableCast = true notationsToBan = 3 warningsToFinalBan = 4 warningsToDeletion = 5 banLength = 1 * 24 * 60 * 60 killsBanLength = 1 * 24 * 60 * 60 finalBanLength = 1 * 24 * 60 * 60 ipBanLength = 1 * 24 * 60 * 60 allowedMaxSizePackets = 20 worldType = "open" protectionLevel = 80 pvpTileIgnoreLevelAndVocationProtection = true pzLocked = 10 * 1000 huntingDuration = 10 * 1000 criticalHitChance = 7 criticalHitMultiplier = 1 displayCriticalHitNotify = false removeWeaponAmmunition = false removeWeaponCharges = false removeRuneCharges = false whiteSkullTime = 5 * 60 * 1000 noDamageToSameLookfeet = false showHealthChange = false showManaChange = false showHealthChangeForMonsters = false showManaChangeForMonsters = false fieldOwnershipDuration = 5 * 1000 stopAttackingAtExit = true loginProtectionPeriod = 10 * 1000 deathLostPercent = 10 stairhopDelay = 2 * 1000 pushCreatureDelay = 1 * 800 deathContainerId = 1987 gainExperienceColor = 215 addManaSpentInPvPZone = true recoverManaAfterDeathInPvPZone = false squareColor = 0 allowFightback = true fistBaseAttack = 7 useFairfightReduction = true optionalWarAttackableAlly = false worldId = 0 ip = "192.168.219.128" bindOnlyGlobalAddress = false loginPort = 7171 gamePort = "7172" loginTries = 3 retryTimeout = 5 * 1000 loginTimeout = 60 * 1000 maxPlayers = 1000 motd = "Styller" displayOnOrOffAtCharlist = false onePlayerOnlinePerAccount = true allowClones = 0 serverName = "Styller" loginMessage = "Espero que sua jornada no servidor seja uma constante alegria.!" statusTimeout = 5 * 60 * 1000 replaceKickOnLogin = true forceSlowConnectionsToDisconnect = false loginOnlyWithLoginServer = false premiumPlayerSkipWaitList = false packetsPerSecond = 50 rsaPrime1 = "14299623962416399520070177382898895550795403345466153217470516082934737582776038882967213386204600674145392845853859217990626450972452084065728686565928113" rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101" rsaPublic = "65537" rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413" rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073" sqlType = "mysql" sqlHost = "localhost" sqlPort = 3306 sqlUser = "root" sqlPass = "123" sqlDatabase = "otserv" sqlFile = "" sqlKeepAlive = 0 mysqlReadTimeout = 10 mysqlWriteTimeout = 10 mysqlReconnectionAttempts = 3 encryptionType = "sha1" deathListEnabled = true deathListRequiredTime = 1 * 60 * 1000 deathAssistCount = 19 maxDeathRecords = 5 multipleNames = false externalGuildWarsManagement = false ingameGuildManagement = false levelToFormGuild = 8 premiumDaysToFormGuild = 0 guildNameMinLength = 4 guildNameMaxLength = 20 buyableAndSellableHouses = true houseNeedPremium = true bedsRequirePremium = true levelToBuyHouse = 150 housesPerAccount = 0 houseRentAsPrice = false housePriceAsRent = false housePriceEachSquare = 1000 houseSkipInitialRent = true houseRentPeriod = "never" houseCleanOld = 0 guildHalls = false houseProtection = true timeBetweenActions = 200 timeBetweenExActions = 1000 timeBetweenCustomActions = 500 hotkeyAimbotEnabled = true tibiaClassicSlots = true canOnlyRopePlayers = true mapName = "Styller.otbm" mapAuthor = "" randomizeTiles = true storeTrash = true cleanProtectedZones = true mailboxDisabledTowns = "" mailMaxAttempts = 20 mailBlockPeriod = 60 * 60 * 1000 mailAttemptsFadeTime = 10 * 60 * 1000 daemonize = false defaultPriority = "high" niceLevel = 5 serviceThreads = 1 coresUsed = "-1" startupDatabaseOptimization = true updatePremiumStateAtStartup = true confirmOutdatedVersion = false skipItemsVersionCheck = true formulaLevel = 5.0 formulaMagic = 1.0 bufferMutedOnSpellFailure = false spellNameInsteadOfWords = false emoteSpells = true unifiedSpells = true enableCooldowns = true allowChangeOutfit = true allowChangeColors = true allowChangeAddons = true disableOutfitsForPrivilegedPlayers = false addonsOnlyPremium = false dataDirectory = "data/" logsDirectory = "data/logs/" bankSystem = true promptExceptionTracerErrorBox = true maximumDoorLevel = 500 maxMessageBuffer = 4 logPlayersStatements = true tradeLimit = 100 useCapacity = true playerFollowExhaust = 0 defaultDepotSizePremium = 2000 defaultDepotSize = 1000 separateVipListPerCharacter = false vipListDefaultLimit = 20 vipListDefaultPremiumLimit = 100 houseDataStorage = "binary" saveGlobalStorage = true storePlayerDirection = false savePlayerData = true checkCorpseOwner = true monsterLootMessage = 3 monsterLootMessageType = 25 ghostModeInvisibleEffect = false ghostModeSpellEffects = true idleWarningTime = 14 * 60 * 1000 idleKickTime = 15 * 60 * 1000 reportsExpirationAfterReads = 1 playerQueryDeepness = -1 tileLimit = 0 protectionTileLimit = 0 houseTileLimit = 0 freePremium = true premiumForPromotion = false blessings = true blessingOnlyPremium = false blessingReductionBase = 30 blessingReductionDecrement = 5 eachBlessReduction = 8 pvpBlessingThreshold = 40 fairFightTimeRange = 60 experienceStages = true rateExperience = 200 rateExperienceFromPlayers = 0 rateSkill = 30 rateMagic = 15 rateLoot = 1.5 rateSpawnMin = 1 rateSpawnMax = 1 rateMonsterHealth = 1.0 rateMonsterMana = 1.0 rateMonsterAttack = 1.0 rateMonsterDefense = 1.0 minLevelThresholdForKilledPlayer = 0.9 maxLevelThresholdForKilledPlayer = 1.1 rateStaminaLoss = 1 rateStaminaGain = 3 rateStaminaThresholdGain = 12 staminaRatingLimitTop = 40 * 60 staminaRatingLimitBottom = 14 * 60 staminaLootLimit = 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 = 6 globalSaveMinute = 0 shutdownAtGlobalSave = false cleanMapAtGlobalSave = false closeInstanceOnShutdown = true deSpawnRange = 2 deSpawnRadius = 50 monsterSpawnWalkback = true allowBlockSpawn = true maxPlayerSummons = 2 teleportAllSummons = false teleportPlayerSummons = false statusPort = 7171 ownerName = "" ownerEmail = "" url = "" location = "Brazil" displayGamemastersWithOnlineCommand = false disableLuaErrors = false displayPlayersLogging = true prefixChannelLogs = "" runFile = "" outputLog = "" truncateLogOnStartup = false managerPort = 7171 managerLogs = true managerPassword = "" managerLocalhostOnly = true managerConnectionsLimit = 1 adminPort = 7171 adminLogs = true adminPassword = "" adminLocalhostOnly = true adminConnectionsLimit = 1 adminRequireLogin = true adminEncryption = "" adminEncryptionData = "" Unica coisa que achei foi isso e está do mesmo jeito que voce postou

Apos modificar as sources tenho que compilar novamente?

Galera, estou com um problema no meu servidor que o player consegue passar por cima do outro no DP e pegar o item (se tiver em cima do depot). # Já tentei colocar vários tiles desses que afundam, mas não deu certo. Gostaria de um script pra colocar no tile que só pudesse passar 1 por vez, ou seja, seguir a lei de Newton "Dois corpos não ocupam mesmo lugar no espaço" kkk Ou caso haja uma solução mais viável me informem por favor..

Este aqui data/talkactions/scripts/war.lua:75: attempt to call field 'query' (a nil value) basta vc ir na linha 75 e mudar db.query por db.executeQuery