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

[Gesior AAC] 0.3.4 (beta4) fixed v5

STEP 5
Set Admin Account

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\Users\Bobbo\Desktop\ot\xampplite\htdocs\pot\OTS_Account.php:229 Stack trace: #0 C:\Users\Bobbo\Desktop\ot\xampplite\htdocs\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\Users\Bobbo\Desktop\ot\xampplite\htdocs\install.php(468): OTS_Account->load(1) #2 {main} thrown in C:\Users\Bobbo\Desktop\ot\xampplite\htdocs\pot\OTS_Account.php on line 229

Can someone please help fix this problem, I cant get past it....

Thanks
 
change in config.lua:

PHP:
-- Status
	ownerName = ""
	ownerEmail = "@otland.net"
	url = "http://otland.net/"
 
@spanky:
Propably you dont use TFS 0.3.4, maybe TFS 0.2.2 or sth different. But this Version works only with TFS 0.3.4 +
 
Updated to version 2. Check first post for more information.

if it works afc i like it but speadshare is glitchy.

Code:
Forbidden

You don't have permission to access /data/674585151/17043549/61902324/gesior 0.3.4(beta4) fixed v2.rar on this server.
 
Hello, i got TFS 0.3.4 Crying Damson

and its giving me this error when i select the Path, o nthe installation.



Warning: Error parsing C:/Akuma/config.lua on line 142 in C:\xampp\htdocs\install.php on line 150
File config.lua loaded from C:/Akuma/config.lua and looks like fine server config file. Now you can check database(mysql) connection: STEP 2 - check database connection



halp?
 
a guy in this thread said i should deleted line 142, i did it..and now it says this...



Warning: Error parsing C:/Akuma/config.lua on line 156 in C:\xampp\htdocs\install.php on line 150
File config.lua loaded from C:/Akuma/config.lua and looks like fine server config file. Now you can check database(mysql) connection: STEP 2 - check database connection
 
Use this config.php... :

Code:
-- The Forgotten Server Config

  -- Account manager
  accountManager = "yes"
  namelockManager = "yes"
  newPlayerChooseVoc = "no"
  newPlayerSpawnPosX = 95
  newPlayerSpawnPosY = 117
  newPlayerSpawnPosZ = 7
  newPlayerTownId = 1
  newPlayerLevel = 1
  newPlayerMagicLevel = 0
  generateAccountNumber = "no"

  -- Banishments
  notationsToBan = 3
  warningsToFinalBan = 4
  warningsToDeletion = 5
  banLength = 7 * 24 * 60 * 60
  finalBanLength = 30 * 24 * 60 * 60
  ipBanishmentLength = 1 * 24 * 60 * 60
  broadcastBanishments = "yes"
  killsToBan = 5
  maxViolationCommentSize = 200
  autoBanishUnknownBytes = "no"

  -- Battle
  -- NOTE: loginProtectionPeriod is the famous Tibia anti-magebomb system.
  -- deathLostPercent set to nil enables manual mode.
  -- showHealingDamageForMonsters inheritates from showHealingDamage.
  worldType = "pvp"
  protectionLevel = 1
  pvpTileIgnoreLevelAndVocationProtection = "yes"
  killsToRedSkull = 3
  pzLocked = 60 * 1000
  criticalHitChance = 7
  criticalHitMultiplier = 1
  displayCriticalHitNotify = "no"
  removeWeaponAmmunition = "yes"
  removeWeaponCharges = "yes"
  removeRuneCharges = "yes"
  timeToDecreaseFrags = 24 * 60 * 60 * 1000
  whiteSkullTime = 15 * 60 * 1000
  noDamageToSameLookfeet = "no"
  experienceByKillingPlayers = "no"
  showHealingDamage = "no"
  showHealingDamageForMonsters = "no"
  fieldOwnershipDuration = 5 * 1000
  stopAttackingAtExit = "no"
  oldConditionAccuracy = "no"
  loginProtectionPeriod = 10 * 1000
  deathLostPercent = 10
  stairhopDelay = 2 * 1000
  pushCreatureDelay = 2 * 1000
  deathContainerId = 1987
  gainExperienceColor = 215

  -- Connection config
  worldId = 0
  ip = "127.0.0.1"
  loginPort = 7171
  gamePort = 7172
  adminPort = 7171
  statusPort = 7171
  loginTries = 10
  retryTimeout = 5 * 1000
  loginTimeout = 60 * 1000
  maxPlayers = 1000
  motd = "Welcome to the Forgotten Server!"
  displayOnOrOffAtCharlist = "no"
  onePlayerOnlinePerAccount = "yes"
  allowClones = 0
  serverName = "Forgotten"
  loginMessage = "Welcome to the Forgotten Server!"
  statusTimeout = 5 * 60 * 1000
  replaceKickOnLogin = "yes"
  forceSlowConnectionsToDisconnect = "no"
  loginOnlyWithLoginServer = "no"
  premiumPlayerSkipWaitList = "no"

  -- Database
  -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
  -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
  sqlType = "sqlite"
  sqlHost = "localhost"
  sqlPort = 3306
  sqlUser = "root"
  sqlPass = ""
  sqlDatabase = "theforgottenserver"
  sqlFile = "forgottenserver.s3db"
  sqlKeepAlive = 0
  mysqlReadTimeout = 10
  mysqlWriteTImeout = 10
  passwordType = "plain"

  -- Deathlist
  deathListEnabled = "yes"
  maxDeathRecords = 5

  -- Guilds
  ingameGuildManagement = "yes"
  levelToFormGuild = 8
  premiumDaysToFormGuild = 0
  guildNameMinLength = 4
  guildNameMaxLength = 20

  -- Highscores
  highscoreDisplayPlayers = 15
  updateHighscoresAfterMinutes = 60

  -- Houses
  buyableAndSellableHouses = "yes"
  houseNeedPremium = "yes"
  bedsRequirePremium = "yes"
  levelToBuyHouse = 1
  housesPerAccount = 0
  houseRentAsPrice = "no"
  housePriceAsRent = "no"
  housePriceEachSquare = 1000
  houseRentPeriod = "never"

  -- Item usage
  timeBetweenActions = 200
  timeBetweenExActions = 1000
  checkCorpseOwner = "yes"
  hotkeyAimbotEnabled = "yes"
  maximumDoorLevel = 500

  -- Map
  -- NOTE: storeTrash costs more memory, but will perform alot faster cleaning.
  -- useHouseDataStorage usage may be found at README.
  mapName = "forgotten"
  mapAuthor = "Komic"
  randomizeTiles = "yes"
  useHouseDataStorage = "no"
  storeTrash = "yes"
  cleanProtectedZones = "yes"

  -- Startup
  defaultPriority = "high"
  niceLevel = 5
  coresUsed = "-1"
  optimizeDatabaseAtStartup = "yes"
  removePremiumOnInit = "yes"
  confirmOutdatedVersion = "yes"

  -- Muted buffer
  maxMessageBuffer = 4
  bufferMutedOnSpellFailure = "no"

  -- Miscellaneous
  dataDirectory = "data/"
  kickIdlePlayerAfterMinutes = 15
  allowChangeOutfit = "yes"
  allowChangeColors = "yes"
  allowChangeAddons = "yes"
  disableOutfitsForPrivilegedPlayers = "no"
  bankSystem = "yes"
  saveGlobalStorage = "yes"
  ghostModeInvisibleEffect = "no"
  displaySkillLevelOnAdvance = "no"
  spellNameInsteadOfWords = "no"
  emoteSpells = "no"
  expireReportsAfterReads = 1
  promptExceptionTracerErrorBox = "yes"
  storePlayerDirection = "no"
  playerQueryDeepness = 2

  -- Premium-related
  freePremium = "no"
  premiumForPromotion = "yes"

  -- Blessings
  -- NOTE: blessingReduction* regards items/containers loss.
  -- eachBlessReduction is how much each bless reduces the experience/magic/skills loss.
  blessingsOnlyPremium = "yes"
  blessingReductionBase = 30
  blessingReductionDecreament = 5
  eachBlessReduction = 8

  -- Rates
  -- NOTE: experienceStages configuration is located in data/XML/stages.xml.
  experienceStages = "no"
  rateExperience = 5.0
  rateSkill = 3.0
  rateMagic = 3.0
  rateLoot = 2.0
  rateSpawn = 1

  -- Stamina
  rateStaminaLoss = 1
  rateStaminaGain = 1000 / 3
  rateStaminaThresholdGain = 4
  staminaRatingLimitTop = 41 * 60
  staminaRatingLimitBottom = 14 * 60
  rateStaminaAboveNormal = 1.5
  rateStaminaUnderNormal = 0.5
  staminaThresholdOnlyPremium = "yes"

  -- Party
  -- NOTE: experienceShareLevelDifference is float number.
  -- experienceShareLevelDifference is highestLevel * value
  experienceShareRadiusX = 30
  experienceShareRadiusY = 30
  experienceShareRadiusZ = 1
  experienceShareLevelDifference = 2 / 3
  extraPartyExperienceLimit = 20
  extraPartyExperiencePercent = 5

  -- 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 = "no"
  globalSaveHour = 8
  shutdownAtGlobalSave = "yes"
  cleanMapAtGlobalSave = "no"

  -- Spawns
  deSpawnRange = 2
  deSpawnRadius = 50

  -- Summons
  maxPlayerSummons = 2
  teleportAllSummons = "no"
  teleportPlayerSummons = "no"

  -- Status
  ownerName = ""
  ownerEmail = "@otland.net"
  url = "http://otland.net/"
  location = "Europe"
  displayGamemastersWithOnlineCommand = "no"

  -- Logs
  -- NOTE: This kind of logging does not work in GUI version.
  adminLogsEnabled = "no"
  displayPlayersLogging = "yes"
  prefixChannelLogs = ""
  runeFile = ""
  outLogName = ""
  errorLogName = ""
  truncateLogsOnStartup = "no"
 
Use this config.php... :

Code:
-- The Forgotten Server Config

  -- Account manager
  accountManager = "yes"
  namelockManager = "yes"
  newPlayerChooseVoc = "no"
  newPlayerSpawnPosX = 95
  newPlayerSpawnPosY = 117
  newPlayerSpawnPosZ = 7
  newPlayerTownId = 1
  newPlayerLevel = 1
  newPlayerMagicLevel = 0
  generateAccountNumber = "no"

  -- Banishments
  notationsToBan = 3
  warningsToFinalBan = 4
  warningsToDeletion = 5
  banLength = 7 * 24 * 60 * 60
  finalBanLength = 30 * 24 * 60 * 60
  ipBanishmentLength = 1 * 24 * 60 * 60
  broadcastBanishments = "yes"
  killsToBan = 5
  maxViolationCommentSize = 200
  autoBanishUnknownBytes = "no"

  -- Battle
  -- NOTE: loginProtectionPeriod is the famous Tibia anti-magebomb system.
  -- deathLostPercent set to nil enables manual mode.
  -- showHealingDamageForMonsters inheritates from showHealingDamage.
  worldType = "pvp"
  protectionLevel = 1
  pvpTileIgnoreLevelAndVocationProtection = "yes"
  killsToRedSkull = 3
  pzLocked = 60 * 1000
  criticalHitChance = 7
  criticalHitMultiplier = 1
  displayCriticalHitNotify = "no"
  removeWeaponAmmunition = "yes"
  removeWeaponCharges = "yes"
  removeRuneCharges = "yes"
  timeToDecreaseFrags = 24 * 60 * 60 * 1000
  whiteSkullTime = 15 * 60 * 1000
  noDamageToSameLookfeet = "no"
  experienceByKillingPlayers = "no"
  showHealingDamage = "no"
  showHealingDamageForMonsters = "no"
  fieldOwnershipDuration = 5 * 1000
  stopAttackingAtExit = "no"
  oldConditionAccuracy = "no"
  loginProtectionPeriod = 10 * 1000
  deathLostPercent = 10
  stairhopDelay = 2 * 1000
  pushCreatureDelay = 2 * 1000
  deathContainerId = 1987
  gainExperienceColor = 215

  -- Connection config
  worldId = 0
  ip = "127.0.0.1"
  loginPort = 7171
  gamePort = 7172
  adminPort = 7171
  statusPort = 7171
  loginTries = 10
  retryTimeout = 5 * 1000
  loginTimeout = 60 * 1000
  maxPlayers = 1000
  motd = "Welcome to the Forgotten Server!"
  displayOnOrOffAtCharlist = "no"
  onePlayerOnlinePerAccount = "yes"
  allowClones = 0
  serverName = "Forgotten"
  loginMessage = "Welcome to the Forgotten Server!"
  statusTimeout = 5 * 60 * 1000
  replaceKickOnLogin = "yes"
  forceSlowConnectionsToDisconnect = "no"
  loginOnlyWithLoginServer = "no"
  premiumPlayerSkipWaitList = "no"

  -- Database
  -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
  -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
  sqlType = "sqlite"
  sqlHost = "localhost"
  sqlPort = 3306
  sqlUser = "root"
  sqlPass = ""
  sqlDatabase = "theforgottenserver"
  sqlFile = "forgottenserver.s3db"
  sqlKeepAlive = 0
  mysqlReadTimeout = 10
  mysqlWriteTImeout = 10
  passwordType = "plain"

  -- Deathlist
  deathListEnabled = "yes"
  maxDeathRecords = 5

  -- Guilds
  ingameGuildManagement = "yes"
  levelToFormGuild = 8
  premiumDaysToFormGuild = 0
  guildNameMinLength = 4
  guildNameMaxLength = 20

  -- Highscores
  highscoreDisplayPlayers = 15
  updateHighscoresAfterMinutes = 60

  -- Houses
  buyableAndSellableHouses = "yes"
  houseNeedPremium = "yes"
  bedsRequirePremium = "yes"
  levelToBuyHouse = 1
  housesPerAccount = 0
  houseRentAsPrice = "no"
  housePriceAsRent = "no"
  housePriceEachSquare = 1000
  houseRentPeriod = "never"

  -- Item usage
  timeBetweenActions = 200
  timeBetweenExActions = 1000
  checkCorpseOwner = "yes"
  hotkeyAimbotEnabled = "yes"
  maximumDoorLevel = 500

  -- Map
  -- NOTE: storeTrash costs more memory, but will perform alot faster cleaning.
  -- useHouseDataStorage usage may be found at README.
  mapName = "forgotten"
  mapAuthor = "Komic"
  randomizeTiles = "yes"
  useHouseDataStorage = "no"
  storeTrash = "yes"
  cleanProtectedZones = "yes"

  -- Startup
  defaultPriority = "high"
  niceLevel = 5
  coresUsed = "-1"
  optimizeDatabaseAtStartup = "yes"
  removePremiumOnInit = "yes"
  confirmOutdatedVersion = "yes"

  -- Muted buffer
  maxMessageBuffer = 4
  bufferMutedOnSpellFailure = "no"

  -- Miscellaneous
  dataDirectory = "data/"
  kickIdlePlayerAfterMinutes = 15
  allowChangeOutfit = "yes"
  allowChangeColors = "yes"
  allowChangeAddons = "yes"
  disableOutfitsForPrivilegedPlayers = "no"
  bankSystem = "yes"
  saveGlobalStorage = "yes"
  ghostModeInvisibleEffect = "no"
  displaySkillLevelOnAdvance = "no"
  spellNameInsteadOfWords = "no"
  emoteSpells = "no"
  expireReportsAfterReads = 1
  promptExceptionTracerErrorBox = "yes"
  storePlayerDirection = "no"
  playerQueryDeepness = 2

  -- Premium-related
  freePremium = "no"
  premiumForPromotion = "yes"

  -- Blessings
  -- NOTE: blessingReduction* regards items/containers loss.
  -- eachBlessReduction is how much each bless reduces the experience/magic/skills loss.
  blessingsOnlyPremium = "yes"
  blessingReductionBase = 30
  blessingReductionDecreament = 5
  eachBlessReduction = 8

  -- Rates
  -- NOTE: experienceStages configuration is located in data/XML/stages.xml.
  experienceStages = "no"
  rateExperience = 5.0
  rateSkill = 3.0
  rateMagic = 3.0
  rateLoot = 2.0
  rateSpawn = 1

  -- Stamina
  rateStaminaLoss = 1
  rateStaminaGain = 1000 / 3
  rateStaminaThresholdGain = 4
  staminaRatingLimitTop = 41 * 60
  staminaRatingLimitBottom = 14 * 60
  rateStaminaAboveNormal = 1.5
  rateStaminaUnderNormal = 0.5
  staminaThresholdOnlyPremium = "yes"

  -- Party
  -- NOTE: experienceShareLevelDifference is float number.
  -- experienceShareLevelDifference is highestLevel * value
  experienceShareRadiusX = 30
  experienceShareRadiusY = 30
  experienceShareRadiusZ = 1
  experienceShareLevelDifference = 2 / 3
  extraPartyExperienceLimit = 20
  extraPartyExperiencePercent = 5

  -- 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 = "no"
  globalSaveHour = 8
  shutdownAtGlobalSave = "yes"
  cleanMapAtGlobalSave = "no"

  -- Spawns
  deSpawnRange = 2
  deSpawnRadius = 50

  -- Summons
  maxPlayerSummons = 2
  teleportAllSummons = "no"
  teleportPlayerSummons = "no"

  -- Status
  ownerName = ""
  ownerEmail = "@otland.net"
  url = "http://otland.net/"
  location = "Europe"
  displayGamemastersWithOnlineCommand = "no"

  -- Logs
  -- NOTE: This kind of logging does not work in GUI version.
  adminLogsEnabled = "no"
  displayPlayersLogging = "yes"
  prefixChannelLogs = ""
  runeFile = ""
  outLogName = ""
  errorLogName = ""
  truncateLogsOnStartup = "no"



thansk you, it works :) can u tell me where do i edit the newsticker?
 
You have to login as admin and then go to admin page. There you can add news tickers/news. If you wanna delete them go to newspage. When you are logged in as admin a delete button will be in news tickers for every ticker. You can edit it only on phpmyadmin i think (but dunno xD). Normal news you can edit on the page i think..
 
How do i fix the logging section? it takes me to otland , i need it to be able to create accs and also to log in on acc on website
 
Back
Top