guibino

Bom dia Xtibianos, GOstaria que alguem me informasse como faço pra alterar um valor de todas as contas que existem em meu bd. Por exemplo, todos os chars tem 30 dias de premium, e gostaria de aumentar este valor para 60, gostaria de saber um comando onde eu fizesse isso automaticamente, e não alterar 1 por 1, grato!

BUMP!!! também preciso saber isso, ja tentei de tudo!!!

Cara, obrigado pelo post Porém estou tendo problemas com Modern aac, nao sei mais o que faço meu config.lua esta como criptografia em "plain", porém nao sei onde ajusto isso no modern aac, já fucei em tudo e nao acho... ele manda a senha criada pelo site no banco de dados criptografada,e eu não consigo acessar a conta pelo jogo.... pode me ajudar? dou rep+ Grato

Já sei criar sites em mySQL, minha dúvida foi bem clara, como consigo criar um site em SQLite? Referente a conversão de SQLITE para mySQL, já foi resolvida... Então, retomando a pergunta... Existe algum website que pode ser utilizado SQLITE? GRATO

também estou procurando um site pra Pokemon OT ja testei o gesior, o modern account mas eles nao aceitam o config.lua do OT POKEMON... se alguem puder ajudar veja o erro que aparece STEP 1 Check server configuration Warning: syntax error, unexpected '(' in C:/Documents and Settings/Administrador/Desktop/Pokemon Flash 3.0/Pokemon Flash 3.0/Pokemon Flash/config.lua on line 17 in C:\xampp\htdocs\install.php on line 130 File config.lua loaded from C:/Documents and Settings/Administrador/Desktop/Pokemon Flash 3.0/Pokemon Flash 3.0/Pokemon Flash/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory. If it's your config.lua file from TFS contact with acc. maker author. Eu uso o OT FLASH TIBIA v3 Desculpe, esquecide postar meu config.lua -- The Forgotten Server Config -- Account manager accountManager = true namelockManager = true newPlayerChooseVoc = true newPlayerSpawnPosX = 1587 newPlayerSpawnPosY = 613 newPlayerSpawnPosZ = 7 newPlayerTownId = 11 newPlayerLevel = 1 newPlayerMagicLevel = 0 generateAccountNumber = false -- Unjustified kills -- NOTE: *Banishment and *BlackSkull variables are >summed up< -- (dailyFragsToRedSkull + dailyFragsToBanishment) with their -- *RedSkull equivalents. -- Auto banishing works only if useBlackSkull set to negative. -- advancedFragList is not advised if you use huge frags -- requirements. redSkullLength = 30 * 24 * 60 * 60 blackSkullLength = 45 * 24 * 60 * 60 dailyFragsToRedSkull = 3 weeklyFragsToRedSkull = 5 monthlyFragsToRedSkull = 10 dailyFragsToBlackSkull = dailyFragsToRedSkull weeklyFragsToBlackSkull = weeklyFragsToRedSkull monthlyFragsToBlackSkull = monthlyFragsToRedSkull dailyFragsToBanishment = dailyFragsToRedSkull weeklyFragsToBanishment = weeklyFragsToRedSkull monthlyFragsToBanishment = monthlyFragsToRedSkull blackSkulledDeathHealth = 40 blackSkulledDeathMana = 0 useBlackSkull = true useFragHandler = true advancedFragList = false -- Banishments -- violationNameReportActionType 1 = just a report, 2 = name lock, 3 = player banishment -- killsBanLength works only if useBlackSkull option is disabled. notationsToBan = 3 warningsToFinalBan = 4 warningsToDeletion = 5 banLength = 7 * 24 * 60 * 60 killsBanLength = 7 * 24 * 60 * 60 finalBanLength = 30 * 24 * 60 * 60 ipBanishmentLength = 1 * 24 * 60 * 60 broadcastBanishments = true maxViolationCommentSize = 200 violationNameReportActionType = 2 autoBanishUnknownBytes = false -- Battle -- NOTE: showHealingDamageForMonsters inheritates from showHealingDamage. -- loginProtectionPeriod is the famous Tibia anti-magebomb system. -- deathLostPercent set to nil enables manual mode. worldType = "no-pvp" protectionLevel = 1000000 pvpTileIgnoreLevelAndVocationProtection = true pzLocked = 10 * 1000 huntingDuration = 60 * 1000 criticalHitChance = 7 criticalHitMultiplier = 1 displayCriticalHitNotify = true removeWeaponAmmunition = true removeWeaponCharges = true removeRuneCharges = true whiteSkullTime = 15 * 60 * 1000 noDamageToSameLookfeet = true showHealingDamage = true showHealingDamageForMonsters = true fieldOwnershipDuration = 5 * 1000 stopAttackingAtExit = true oldConditionAccuracy = true loginProtectionPeriod = 10 * 1000 deathLostPercent = 10 stairhopDelay = 2 * 1000 pushCreatureDelay = 2 * 1000 deathContainerId = 1987 gainExperienceColor = 215 addManaSpentInPvPZone = true squareColor = 0 allowFightback = true -- Connection config worldId = 0 ip = "ultrapokemon.servegame.com" bindOnlyConfiguredIpAddress = false loginPort = 7171 gamePort = 7172 adminPort = 7171 statusPort = 7171 loginTries = 10 retryTimeout = 5 * 1000 loginTimeout = 60 * 1000 maxPlayers = 1000 motd = "Wellcome to Pokemon Flash!" displayOnOrOffAtCharlist = false onePlayerOnlinePerAccount = true allowClones = false serverName = "Pkm Flash" loginMessage = "Pkm Flash!" statusTimeout = 5 * 60 * 1000 replaceKickOnLogin = true forceSlowConnectionsToDisconnect = false loginOnlyWithLoginServer = false premiumPlayerSkipWaitList = false -- Database -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database. -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value. sqlType = "mysql" sqlHost = "localhost" sqlPort = 3306 sqlUser = "root" sqlPass = "dis2fe" sqlDatabase = "pkmflash" sqlFile = "pkmflash.s3db" sqlKeepAlive = 0 mysqlReadTimeout = 10 mysqlWriteTimeout = 10 encryptionType = "plain" -- Deathlist deathListEnabled = true deathListRequiredTime = 1 * 60 * 1000 deathAssistCount = 19 maxDeathRecords = 5 -- Guilds ingameGuildManagement = true levelToFormGuild = 8 premiumDaysToFormGuild = 0 guildNameMinLength = 4 guildNameMaxLength = 20 -- Highscores highscoreDisplayPlayers = 30 updateHighscoresAfterMinutes = 1 -- Houses buyableAndSellableHouses = true houseNeedPremium = true bedsRequirePremium = true levelToBuyHouse = 60 housesPerAccount = 0 houseRentAsPrice = false housePriceAsRent = false housePriceEachSquare = 1000 houseRentPeriod = "never" houseCleanOld = 0 guildHalls = false -- Item usage timeBetweenActions = 200 timeBetweenExActions = 1000 hotkeyAimbotEnabled = true -- Map -- NOTE: storeTrash costs more memory, but will perform alot faster cleaning. mapName = "flash" mapAuthor = "RoyalFlash" randomizeTiles = true storeTrash = true cleanProtectedZones = true mailboxDisabledTowns = "-1" -- Process -- NOTE: defaultPriority works only on Windows and niceLevel on *nix -- coresUsed are seperated by comma cores ids used by server process, -- default is -1, so it stays untouched (automaticaly assigned by OS). defaultPriority = "high" niceLevel = 5 coresUsed = "-1" -- Startup optimizeDatabaseAtStartup = true removePremiumOnInit = true confirmOutdatedVersion = false -- Spells formulaLevel = 5.0 formulaMagic = 1.0 bufferMutedOnSpellFailure = false spellNameInsteadOfWords = false emoteSpells = false -- Outfits allowChangeOutfit = true allowChangeColors = true allowChangeAddons = true disableOutfitsForPrivilegedPlayers = false addonsOnlyPremium = true -- Miscellaneous -- NOTE: promptExceptionTracerErrorBox works only with precompiled support feature, -- called "exception tracer" (__EXCEPTION_TRACER__ flag). dataDirectory = "data/" bankSystem = true displaySkillLevelOnAdvance = false promptExceptionTracerErrorBox = true separateViplistPerCharacter = false maximumDoorLevel = 500 maxMessageBuffer = 4 -- Saving-related -- useHouseDataStorage usage may be found at README. saveGlobalStorage = true useHouseDataStorage = false storePlayerDirection = false -- Loot -- monsterLootMessage 0 to disable, 1 - only party, 2 - only player, 3 - party or player (like Tibia's) checkCorpseOwner = true monsterLootMessage = 3 monsterLootMessageType = 25 -- Ghost mode ghostModeInvisibleEffect = true ghostModeSpellEffects = true -- Limits idleWarningTime = 14 * 60 * 1000 idleKickTime = 15 * 60 * 1000 expireReportsAfterReads = 1 playerQueryDeepness = 2 maxItemsPerPZTile = 0 maxItemsPerHouseTile = 0 -- Premium-related freePremium = true premiumForPromotion = true -- Blessings -- NOTE: blessingReduction* regards items/containers loss. -- eachBlessReduction is how much each bless reduces the experience/magic/skills loss. blessingOnlyPremium = true blessingReductionBase = 30 blessingReductionDecreament = 5 eachBlessReduction = 8 -- Rates -- NOTE: experienceStages configuration is located in data/XML/stages.xml. -- rateExperienceFromPlayers 0 to disable. experienceStages = true rateExperience = 2000000.0 rateExperienceFromPlayers = 0 rateSkill = 2.7 rateMagic = 16.0 rateLoot = 14.0 rateSpawn = 1 -- Monster rates rateMonsterHealth = 1.0 rateMonsterMana = 1.0 rateMonsterAttack = 1.0 rateMonsterDefense = 1.0 -- Experience from players -- NOTE: min~Threshold* set to 0 will disable the minimum threshold: -- player will gain experience from every lower leveled player. -- max~Threshold* set to 0 will disable the maximum threshold: -- player will gain experience from every higher leveled player. minLevelThresholdForKilledPlayer = 0.9 maxLevelThresholdForKilledPlayer = 1.1 -- Stamina -- NOTE: Stamina is stored in miliseconds, so seconds are multiplied by 1000. -- rateStaminaHits multiplies every hit done a creature, which are later -- multiplied by player attack speed. -- rateStaminaGain is divider of every logged out second, eg: -- 60000 / 3 = 20000 milliseconds, what gives 20 stamina seconds for 1 minute being logged off. -- rateStaminaThresholdGain is divider for the premium stamina. -- staminaRatingLimit* is in minutes. rateStaminaLoss = 1 rateStaminaGain = 3 rateStaminaThresholdGain = 12 staminaRatingLimitTop = 41 * 60 staminaRatingLimitBottom = 14 * 60 rateStaminaAboveNormal = 1.5 rateStaminaUnderNormal = 0.5 staminaThresholdOnlyPremium = true -- Party -- NOTE: experienceShareLevelDifference is float number. -- experienceShareLevelDifference is highestLevel * value experienceShareRadiusX = 30 experienceShareRadiusY = 30 experienceShareRadiusZ = 1 experienceShareLevelDifference = 2 / 3 extraPartyExperienceLimit = 20 extraPartyExperiencePercent = 5 experienceShareActivity = 2 * 60 * 1000 -- Global save -- NOTE: globalSaveHour means like 03:00, not that it will save every 3 hours, -- if you want such a system please check out data/globalevents/globalevents.xml. globalSaveEnabled = false globalSaveHour = 8 shutdownAtGlobalSave = true cleanMapAtGlobalSave = false -- Spawns deSpawnRange = 2 deSpawnRadius = 50 -- Summons maxPlayerSummons = 2 teleportAllSummons = true teleportPlayerSummons = true -- Status ownerName = "Delluge" ownerEmail = "@otland.net" url = "http://otland.net/" location = "Europe" displayGamemastersWithOnlineCommand = false -- Logs -- NOTE: This kind of logging does not work in GUI version. -- For such, please compile the software with __GUI_LOGS__ flag. adminLogsEnabled = false displayPlayersLogging = true prefixChannelLogs = "" runFile = "" outLogName = "" errorLogName = "" truncateLogsOnStartup = false

Galera estou com um probleminha, estou criando um website para Pokemon ONLINE e não sei como faço para utilizar SQLITE ao inves de MYSQL para o meu website... alguem pode me ajudar? Se caso nao seja possível, gostaria que alguem me ajudasse a fazer a conversão de sqlite para mySQL do meu DATABASE obrigado

Kra, o firstitems que eu tenho no meu server é o que ta ai em cima, eu ja coloquei o seu e nao adiantou nada.. Eu percebi que quando se cria um CHAR novo, ele vem como se fosse o outfit do ACCOUNT MANAGER, mas passa 1 segundo e volta pro character todo branco, EU estou percebendo também que esta é a duvida de muitas pessoas aqui no forum, mas ninguem ta sabendo solucionar... :(:(

Cara, obrigado pela ajuda, porém ainda nao consegui editar os itens! O char nasce totalmente pelado. mudei as config q vc me falou, mas nada adiantou, e o comando q vc me passou se encontra no login.lua... kra to precisando de mt ajuda, só falta ajustar isso pro meu server fica on, e eu ja to pagando DEDICADO abraços

Eu fui lá e tem isso, mas o meu char NASCE PELADO, alguem pode me ajudar!!! EU ja consegui editar o level, exp, mana, life, e cap do CHAR la no DATABASE, mas os itens eu n consigo.. o ot q eu uso eh WE DO OTS local commonItems = { -- ITEMS ALL VOCS RECEIVE {itemid=2480, count=1}, -- legion helmet {itemid=2464, count=1}, -- chain armor {itemid=2468, count=1}, -- studded legs {itemid=2643, count=1}, -- leather boots {itemid=2120, count=1}, -- rope {itemid=5710, count=1} -- shovel } local firstItems = { { -- SORC ITEMS {itemid=2190, count=1}, -- wand of vortex {itemid=2175, count=1} -- spellbook }, { -- DRUID ITEMS {itemid=2182, count=1}, -- snakebite rod {itemid=2175, count=1} -- spellbook }, { -- PALADIN ITEMS {itemid=2456, count=1}, -- bow {itemid=2544, count=100} -- 100 arrows }, { -- KNIGHT ITEMS {itemid=2412, count=1}, -- katana {itemid=2530, count=1} -- copper shield } } for _, items in ipairs(firstItems) do for _, item in ipairs(commonItems) do table.insert(items, item) end end local storage = 35353 function onLogin(cid) if getPlayerGroupId(cid) < 3 then local receivedItems = getPlayerStorageValue(cid, storage) if receivedItems == -1 then --[[local backpack = ]]doPlayerAddItem(cid, 1988, 1) local giveItems = firstItems[getPlayerVocation(cid)] if giveItems ~= nil then for _, v in ipairs(giveItems) do --doAddContainerItem(backpack, v.itemid, v.count or 1) doPlayerAddItem(cid, v.itemid, v.count or 1) end doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_ORANGE, "You have recieved your first items!") end setPlayerStorageValue(cid, storage, 1) end return true end

aqui todo mundo respondeu a mesma coisa MAS EU PRECISO SABER O SEGUINTE Como edito os itens inicias do CHAR Já fui no DATABASE E lá só da pra mudar a mana, life, level, e o outfit, n achei lugar pra editar os itens!!! alguem ajudeee