2.0.5 Erro em Sqlite Studio

[ScripterCrazy 0]

Olá galera, estou com uma dúvida, por que meu SQLITE STUDIO V 2.0.5 Não aparece as coisas de outros players, para poder editar nome e algo a mais, não aparece nada dos outros no SQL, me ajudem !

[PriisioneR 136]

ja verificou se não é sua database ?

[ScripterCrazy 0]

ja verificou se não é sua database ?

Já Verifiquei, não é a DETABASE '-'  

 

Eu já fiz tudo correto: Abri o SQL, Fui em "Anadir Base de Datos" ( O MEU ESTÁ EM ESPAÑOL ) e depois cliquei na Pasta do Lado > E depois cliquei no arquivo LUA " Forgottenserver " depois cliquei em Accounts \ Players e não vai , só tem a conta do GOD \ ACC MANAGER e os players só tem a conta do GOD \ ACC MANAGER

[PriisioneR 136]

Hum, mais sera que o seu servidor esta configurado para essa database ? 

poderia me passar seu config.lua em SPOILER ?

[lucasmacaca 67]

BAIXE O SQLITE STUDIO 2.1.5

[ScripterCrazy 0]

não sei passar em spoiler1!

Editado Julho 3, 2014 por ScripterCrazy (veja o histórico de edições)

[PriisioneR 136]

me passa normal entao.

[ScripterCrazy 0]

 

-- Rookwar 8.60 Server Config

 

-- Account manager

accountManager = yes

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 1000

newPlayerSpawnPosY = 1000

newPlayerSpawnPosZ = 10

newPlayerTownId = 1

newPlayerLevel = 50

newPlayerMagicLevel = 19

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 = 24 * 60 * 60

blackSkullLength = 24 * 60 * 60

dailyFragsToRedSkull = 1000000

weeklyFragsToRedSkull = 100000

monthlyFragsToRedSkull = 1500000

dailyFragsToBlackSkull = dailyFragsToRedSkull

weeklyFragsToBlackSkull = weeklyFragsToRedSkull

monthlyFragsToBlackSkull = monthlyFragsToRedSkull

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 100

blackSkulledDeathMana = 100

useBlackSkull = false

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 = 999

warningsToFinalBan = 999

warningsToDeletion = 999

banLength = 7 * 24 * 60 * 60

killsBanLength = 24 * 60 * 60

finalBanLength = 30 * 24 * 60 * 60

ipBanishmentLength = 1 * 24 * 60 * 60

broadcastBanishments = true

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

 

-- Battle

worldType = "Pvp"

protectionLevel = 1

pvpTileIgnoreLevelAndVocationProtection = yes

pzLocked = 40 * 1000

huntingDuration = 60 * 1000

criticalHitChance = 80

criticalHitMultiplier = 1

displayCriticalHitNotify = yes

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = false

whiteSkullTime = 20

noDamageToSameLookfeet = false

showHealingDamage = true

showHealingDamageForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

oldConditionAccuracy = false

loginProtectionPeriod = 1

deathLostPercent = 20

stairhopDelay = 1

pushCreatureDelay = 1

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = yes

 

-- Connection config

worldId = 0

ip = "wprookwar.ddns.net"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 5

retryTimeout = 2 * 1000

loginTimeout = 30 * 1000

maxPlayers = 100

motd = "Bem-vindo ao WPROOKWAR"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = false

allowClones = false

serverName = "WPROOKWAR!"

loginMessage = "Bem-vindo ao Wprookwar Editado por [ADM] Is Back"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = yes

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 = "sqlite"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = ""

sqlDatabase = "theforgottenserver"

sqlFile = "forgottenserver.s3db"

sqlKeepAlive = 1

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

 

-- Deathlist

deathListEnabled = yes

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

 

-- Guilds

ingameGuildManagement = true

levelToFormGuild = 8

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

 

-- Highscores

highscoreDisplayPlayers = 15

updateHighscoresAfterMinutes = 1

 

-- Houses

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 1

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 1000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

 

-- Item usage

timeBetweenActions = 100

timeBetweenExActions = 1000

hotkeyAimbotEnabled = true

 

-- Map

-- NOTE: storeTrash costs more memory, but will perform alot faster cleaning.

mapName = "rookwar"

mapAuthor = "Morrison"

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

 

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

 

-- Startup

optimizeDatabaseAtStartup = true

removePremiumOnInit = false

confirmOutdatedVersion = false

 

-- Spells

formulaLevel = 5.0

formulaMagic = 1.0

bufferMutedOnSpellFailure = false

spellNameInsteadOfWords = True

emoteSpells = true

 

-- Outfits

allowChangeOutfit = yes

allowChangeColors = yes

allowChangeAddons = yes

disableOutfitsForPrivilegedPlayers = false

addonsOnlyPremium = yes

 

-- 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 = 60

maxMessageBuffer = 6

 

-- Saving-related

-- useHouseDataStorage usage may be found at README.

saveGlobalStorage = yes

useHouseDataStorage = true

storePlayerDirection = true

 

-- Loot

-- monsterLootMessage 0 to disable, 1 - only party, 2 - only player, 3 - party or player (like Tibia's)

checkCorpseOwner = true

monsterLootMessage = 0

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 = 0

 

-- Rates

-- NOTE: experienceStages configuration is located in data/XML/stages.xml.

-- rateExperienceFromPlayers 0 to disable.

experienceStages = false

rateExperience = 40

rateExperienceFromPlayers = 45

rateSkill = 95.0

rateMagic = 50.0

rateLoot = 4.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

maxLevelThresholdForKilledPlayer = 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 = 15

experienceShareRadiusY = 15

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 = true

globalSaveHour = 1

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = true

 

-- Spawns

deSpawnRange = 2

deSpawnRadius = 30

 

-- Summons

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

 

-- Status

ownerName = "TECH WAR"

ownerEmail = "[email protected]"

url = "http://tibiaking.com/"

location = "Brazil"

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

[PriisioneR 136]

Tente baixar a versão mais nova do sqlite então pois sua config ta normal

[join 112]

Config.lua não tem nada ha ver com o sqlstudio.

Eu uso o "SQLite Expert" ,acho bem legalzinho, tente para ver se resolve seu problema

[PriisioneR 136]

Join talves o servidor dele tive-se 2 database eu pedi o config.lua para ver se ele estava usando a correta.

[join 112]

Hum, entendi

Tomara que ele resolva esse problema.

[ScripterCrazy 0]

Config.lua não tem nada ha ver com o sqlstudio.

Eu uso o "SQLite Expert" ,acho bem legalzinho, tente para ver se resolve seu problema

Baixei, deu na mesma coisa, eu acho que eu to vendo aqui no Forgottenserver uma parte que fala assim:

 

"CREATETABLEACCOUNTS e outra CREATEPLAYERS ACCOUNTS" olhem VVV

 

                                                                      $''‚tableserver_configserver_configCREATE TABLE "server_config" (

"config" VARCHAR(35) NOT NULL DEFAULT '',

"value" INTEGER NOT NULL,

UNIQUE ("config")

)9M' indexsqlite_autoindex_server_config_1server_configC##‚Mtableserver_motdserver_motdCREATE TABLE "server_motd" (

"id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"text" TEXT NOT NULL DEFAULT '',

UNIQUE ("id", "world_id")

)5I# indexsqlite_autoindex_server_motd_1server_motd[''‚utableserver_recordserver_recordCREATE TABLE "server_record" (

"record" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL,

UNIQUE ("record", "world_id", "timestamp")

)9M' indexsqlite_autoindex_server_record_1server_record

    W  W÷Ï                                                                         ƒ))…utableserver_reportsserver_reportsCREATE TABLE "server_reports" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL DEFAULT 0,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL DEFAULT 0,

"report" TEXT NOT NULL DEFAULT '',

"reads" INTEGER NOT NULL DEFAULT 0

)ƒU†}tableaccountsaccountsCREATE TABLE "accounts" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"password" VARCHAR(255) NOT NULL,

"premdays" INTEGER NOT NULL DEFAULT 0,

"lastday" INTEGER NOT NULL DEFAULT 0,

"email" VARCHAR(255) NOT NULL DEFAULT '',

"key" VARCHAR(20) NOT NULL DEFAULT '0',

"blocked" BOOLEAN NOT NULL DEFAULT 0,

"warnings" INTEGER NOT NULL DEFAULT 0,

"group_id" INTEGER NOT NULL DEFAULT 1,

 

Não sei como CRIA ! se é esse o problema.

[PriisioneR 136]

tente trocar a database do seu servido por uma nova limpa sem erros

use a da chaito que tem na net

[ScripterCrazy 0]

Já tentei usar essa "Chaito" não deu.

[join 112]

Ok, deixa eu entender melhor, vc está tentando abrir a sua base de dados do seu ot para ver os itens os player é isso ?