darkjav
Senior Developer
gratz thx :*
[Gesior AAC] 0.3.4 (beta4) fixed v5
- Thread starter Norix
- Start date
Well here you have new problem 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:\xampp\htdocs\pot\OTS_Account.php:229 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(581): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 229
Set Admin Account
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:229 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(581): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 229
Update v5
Updated to v5. Check first post for more information.
Also if you wanna use a AAC for TFS 0.2+ check this: http://otland.net/f118/gesior-aac-0-3-1-fixed-v1-forgotten-server-0-2-a-39963/
Updated to v5. Check first post for more information.
Also if you wanna use a AAC for TFS 0.2+ check this: http://otland.net/f118/gesior-aac-0-3-1-fixed-v1-forgotten-server-0-2-a-39963/
Renusek
beton beton beton punk!
Great, works fine with 0.3.4pl2, not work with 0.3.5 ;p. But when I have edited this, it works on 0.3.5 too ;D.
Crew
New Member
I Help plx error in set acc admin
I'm having problems on step 2:
My config.lua
Code:
Warning: Error parsing C:/OT/config.lua on line 142 in C:\OT\xampplite\htdocs\install.php on line 177
Database error. Unknown database type in C:/OT/config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""My config.lua
Code:
-- The Forgotten Server Config
-- Account Manager
accountManager = "no"
namelockManager = "yes"
newPlayerChooseVoc = "no"
newPlayerSpawnPosX = 95
newPlayerSpawnPosY = 117
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 1
newPlayerMagicLevel = 0
generateAccountNumber = "yes"
-- Banishments
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 3 * 24 * 60 * 60
finalBanLength = 10 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = "yes"
killsToBan = 8
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 = 25
pvpTileIgnoreLevelAndVocationProtection = "yes"
killsToRedSkull = 6
pzLocked = 60 * 1000
criticalHitChance = 25
criticalHitMultiplier = 1.05
displayCriticalHitNotify = "yes"
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 = 1 * 1000
pushCreatureDelay = 2 * 1000
deathContainerId = 1987
gainExperienceColor = 215
-- Connection config
worldId = 0
ip = "201.132.20.46"
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 500
retryTimeout = 30 * 1000
loginTimeout = 60 * 1000
maxPlayers = 250
motd = "Bienvenidos a DeathSouls 8.4\n Recuerda leer las reglas!\n\nY vota por nosotros en otvote.otfans.net"
displayOnOrOffAtCharlist = "no"
onePlayerOnlinePerAccount = "yes"
allowClones = 0
serverName = "DeathSouls"
loginMessage = "Bienvenidos a DeathSouls 8.4\nWeb: http://deathsouls.no-ip.org:7002/\nForo: http://deathsouls.foros.ws"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = "no"
forceSlowConnectionsToDisconnect = "no"
loginOnlyWithLoginServer = "no"
premiumPlayerSkipWaitList = "no"
-- Database
-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
-- To disable sqlKeepAlive use 0 value.
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "*****"
sqlPass = "*****"
sqlDatabase = "*****"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTImeout = 10
passwordType = "md5"
-- Deathlist
deathListEnabled = "yes"
maxDeathRecords = 999
-- Guilds
ingameGuildManagement = "no"
levelToFormGuild = 8
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
-- Highscores
highscoreDisplayPlayers = 20
updateHighscoresAfterMinutes = 30
-- Houses
buyableAndSellableHouses = "yes"
houseNeedPremium = "yes"
bedsRequirePremium = "yes"
levelToBuyHouse = 15
housesPerAccount = 1
houseRentAsPrice = "no"
housePriceAsRent = "no"
housePriceEachSquare = 200
houseRentPeriod = "weekly"
-- 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 = "DeathSouls"
mapAuthor = "God Lord and God Knight"
randomizeTiles = "yes"
useHouseDataStorage = "no"
storeTrash = "yes"
cleanProtectedZones = "yes"
-- Startup
-- 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"
optimizeDatabaseAtStartup = "no"
removePremiumOnInit = "yes"
confirmOutdatedVersion = "yes"
-- Muted buffer
maxMessageBuffer = 4
bufferMutedOnSpellFailure = "no"
-- Miscellaneous
-- NOTE: promptExceptionTracerErrorBox works only with precompiled support feature,
-- called "exception tracer" (__EXCEPTION_TRACER__ flag).
dataDirectory = "data/"
kickIdlePlayerAfterMinutes = 15
allowChangeOutfit = "yes"
allowChangeColors = "yes"
allowChangeAddons = "yes"
disableOutfitsForPrivilegedPlayers = "no"
bankSystem = "yes"
saveGlobalStorage = "yes"
ghostModeInvisibleEffect = "yes"
displaySkillLevelOnAdvance = "no"
spellNameInsteadOfWords = "no"
emoteSpells = "no"
expireReportsAfterReads = 1
promptExceptionTracerErrorBox = "yes"
storePlayerDirection = "no"
playerQueryDeepness = 2
-- Premium-related
freePremium = "yes"
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 = "yes"
rateExperience = 5.0
rateSkill = 5.0
rateLoot = 3.0
rateMagic = 5.0
rateSpawn = 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 multiplying every second of logged out time, eg:
-- 60 * 1000 / 3 = 20 seconds, what gives 1 stamina minute for 3 being logged off.
-- rateStaminaThresholdGain is dividing in case the normal gain (that is
-- multiplied by rateStaminaGain, btw.) passed above threshold, eg:
-- 60 * 1000 / 3 = 20 / 4 = 5 seconds (3 * 4 = 12 minutes for 1 stamina minute).
-- staminaRatingLimit* is in minutes.
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 = 40
experienceShareRadiusY = 40
experienceShareRadiusZ = 1
experienceShareLevelDifference = 2 / 3
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 20
-- 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 directory.
globalSaveEnabled = "no"
globalSaveHour = 0
shutdownAtGlobalSave = "no"
cleanMapAtGlobalSave = "yes"
-- Spawns
deSpawnRange = 2
deSpawnRadius = 50
-- Summons
maxPlayerSummons = 2
teleportAllSummons = "yes"
teleportPlayerSummons = "yes"
-- Status
ownerName = "God Lord"
ownerEmail = "[email protected]"
url = "http://deathsouls.no-ip.org:7002"
location = "Mexico"
displayGamemastersWithOnlineCommand = "no"
-- Logs
-- NOTE: This kind of logging does not work in GUI version.
-- For such, please compile the software with __GUI_LOGS__ flag.
adminLogsEnabled = "yes"
displayPlayersLogging = "yes"
prefixChannelLogs = ""
runeFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = "no"
Renusek
beton beton beton punk!
redbull915
I learn...
Nice update mayby you can add next version add a system o flag in whoisonline
the flags is really easy... i will post it ;D
jerryb1988
Member
- Joined
- Mar 10, 2008
- Messages
- 79
- Reaction score
- 5
Good job here with this package. You're welcome to use my modified shopsystem.php in your next release. Just put me in the credits ;P
jerryb1988
Member
- Joined
- Mar 10, 2008
- Messages
- 79
- Reaction score
- 5
I'm not sure if its your mistake or gesior's, but if you have "show_vip_status" off, it also doesn't show that characters comment. Heres how to fix it:
characters.php - Line 97
put a } on the end of this line. The one on line 98 is closing the begging { on line 87.
then - Line 109
delete this entire line, which is only a }
Save and go check out your char page. Comment works now
characters.php - Line 97
PHP:
$main_content .= '<TD><span class="green"><B>VIP</B></TD></TR>';then - Line 109
PHP:
}Save and go check out your char page. Comment works now
