Frags não contam.

[ScythePhantom 4]

Dúvida sanada.

 

Editado Março 2, 2015 por ScythePhantom (veja o histórico de edições)

[Sammy 143]

Altere seu talkactions/scripts/frags.lua para este:

 

local config = {
useFragHandler = getBooleanFromString(getConfigValue('useFragHandler')),
advancedFragList = getBooleanFromString(getConfigValue('advancedFragList'))
}

function onSay(cid, words, param, channel)
if(not config.useFragHandler) then
return false
end

local time = os.time()
local times = {today = (time - 86400), week = (time - (7 * 86400))}

local contents, result = {day = {}, week = {}, month = {}}, db.getResult("SELECT `pd`.`date`, `pd`.`level`, `p`.`name` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `pk`.`player_id` = " .. getPlayerGUID(cid) .. " AND `k`.`unjustified` = 1 AND `pd`.`date` >= " .. (time - (30 * 86400)) .. " ORDER BY `pd`.`date` DESC")
if(result:getID() ~= -1) then
repeat
local content = {
name = result:getDataString("name"),
level = result:getDataInt("level"),
date = result:getDataInt("date")
}
if(content.date > times.today) then
table.insert(contents.day, content)
elseif(content.date > times.week) then
table.insert(contents.week, content)
else
table.insert(contents.month, content)
end
until not result:next()
result:free()
end

local size = {
day = table.maxn(contents.day),
week = table.maxn(contents.week),
month = table.maxn(contents.month)
}
if(config.advancedFragList) then
local result = "Frags gained today: " .. size.day .. "."
if(size.day > 0) then
for _, content in ipairs(contents.day) do
result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level
end

result = result .. "\n"
end

result = result .. "\nFrags gained this week: " .. (size.day + size.week) .. "."
if(size.week > 0) then
for _, content in ipairs(contents.week) do
result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level
end

result = result .. "\n"
end

result = result .. "\nFrags gained this month: " .. (size.day + size.week + size.month) .. "."
if(size.month > 0) then
for _, content in ipairs(contents.month) do
result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level
end

result = result .. "\n"
end

local skullEnd = getPlayerSkullEnd(cid)
if(skullEnd > 0) then
result = result .. "\nYour " .. (getCreatureSkullType(cid) == SKULL_RED and "red" or "black") .. " skull will expire at " .. os.date("%d %B %Y %X", skullEnd)
end

doPlayerPopupFYI(cid, result)
else
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You currently have " .. size.day .. " frags today, " .. (size.day + size.week) .. " this week and " .. (size.day + size.week + size.month) .. " this month.")
if(size.day > 0) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Last frag at " .. os.date("%d %B %Y %X", contents.day[1].date) .. " on level " .. contents.day[1].level .. " (" .. contents.day[1].name .. ").")
end

local skullEnd = getPlayerSkullEnd(cid)
if(skullEnd > 0) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Your " .. (getCreatureSkullType(cid) == SKULL_RED and "red" or "black") .. " skull will expire at " .. os.date("%d %B %Y %X", skullEnd))
end
end

return true
end

[Kagador 0]

Poxa entao.. Estou revivendo o topico pq estou com o mesmo problema e isto ae não resolve... Os players matam matam matam e nunca pegam red... !frags = 0 dia, 0 semana e 0 mes sempre...

Ja usei varios frags.lua e nenhum funciona...

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

[gabrieldiaszin 6]

posta seu config.lua e frags.lua(data/talkactions/scripts/frags.lua) em spoiler

[Kagador 0]

Config lua

-- The Forgotten Server Config

 

-- Account manager

accountManager = "yes"

namelockManager = "no"

newPlayerChooseVoc = "yes"

newPlayerSpawnPosX = 2000

newPlayerSpawnPosY = 2000

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 0

generateAccountNumber = "no"

 

-- Unjustified kills

redSkullLength = 2 * 24 * 60 * 60

blackSkullLength = 2 * 24 * 60 * 60

dailyFragsToRedSkull = 50

weeklyFragsToRedSkull = 80

monthlyFragsToRedSkull = 100

dailyFragsToBlackSkull = dailyFragsToRedSkull

weeklyFragsToBlackSkull = weeklyFragsToRedSkull

monthlyFragsToBlackSkull = monthlyFragsToRedSkull

dailyFragsToBanishment = dailyFragsToRedSkull

weeklyFragsToBanishment = weeklyFragsToRedSkull

monthlyFragsToBanishment = monthlyFragsToRedSkull

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = true

useFragHandler = true

advancedFragList = false

 

-- Banishments

notationsToBan = 3

warningsToFinalBan = 4

warningsToDeletion = 5

banLength = 7 * 24 * 60 * 60

killsBanLength = 8 * 24 * 60 * 60

finalBanLength = 30 * 24 * 60 * 60

ipBanishmentLength = 100 * 24 * 60 * 60

broadcastBanishments = true

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

 

-- Battle

worldType = "pvp"

protectionLevel = 1

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 1 * 30 * 1000

huntingDuration = 1 * 10 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = "no"

whiteSkullTime = 1 * 10 * 100

noDamageToSameLookfeet = false

showHealingDamage = true

showHealingDamageForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = true

oldConditionAccuracy = false

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

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 893

motd = "Bem VindO ao Baiak Yurots Edição 2014!"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = false

allowClones = false

serverName = "Baiak 8.60"

loginMessage = ".:: Bem Vindo ao Baiak Yurots Edição 2014!"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

 

-- Database

sqlType = "sqlite"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = ""

sqlDatabase = "theforgottenserver"

sqlFile = "forgottenserver.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "sha1"

 

-- Deathlist

deathListEnabled = false

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

 

-- Guilds

ingameGuildManagement = true

levelToFormGuild = 8

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 40

 

-- Highscores

highscoreDisplayPlayers = 10

updateHighscoresAfterMinutes = 3

 

-- Houses

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 500

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 10000

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

 

-- Item usage

timeBetweenActions = 200

timeBetweenExActions = 1000

checkCorpseOwner = true

hotkeyAimbotEnabled = true

maximumDoorLevel = 500

 

-- Map

mapName = "Baiak Yurots"

mapAuthor = "Luiz Baiak #Facebook."

randomizeTiles = true

useHouseDataStorage = false

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

 

-- Startup

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

removePremiumOnInit = true

confirmOutdatedVersion = false

 

-- Muted buffer

maxMessageBuffer = 4

bufferMutedOnSpellFailure = false

 

-- Miscellaneous

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

bankSystem = true

saveGlobalStorage = true

displaySkillLevelOnAdvance = false

spellNameInsteadOfWords = false

emoteSpells = true

promptExceptionTracerErrorBox = true

storePlayerDirection = false

monsterLootMessage = 3

monsterLootMessageType = 25

separateViplistPerCharacter = false

 

-- Ghost mode

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

 

-- Limits

idleWarningTime = 14 * 60 * 1000

idleKickTime = 240 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

 

-- Premium-related

freePremium = true

premiumForPromotion = true

 

-- Blessings

blessingOnlyPremium = true

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

 

-- Rates

experienceStages = "yes"

rateExperience = 10

rateExperienceFromPlayers = 5

rateSkill = 700

rateMagic = 100

rateLoot = 25

rateSpawn = 500

 

-- Monster rates

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

 

-- Experience from players

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

 

-- Stamina

rateStaminaLoss = 1

rateStaminaGain = 3

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 41 * 60

staminaRatingLimitBottom = 14 * 60

rateStaminaAboveNormal = 1.5

rateStaminaUnderNormal = 0.5

staminaThresholdOnlyPremium = true

 

-- Party

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 5

experienceShareActivity = 2 * 60 * 1000

 

-- Global save

globalSaveEnabled = false

globalSaveHour = 8

shutdownAtGlobalSave = false

cleanMapAtGlobalSave = false

 

-- Spawns

deSpawnRange = 2

deSpawnRadius = 50

 

-- Summons

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

 

-- Status

ownerName = "Baiiak Lula"

ownerEmail = "[email protected]"

url = ""

location = "American"

displayGamemastersWithOnlineCommand = false

 

-- Logs

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

 

 

Frags

local config = {

useFragHandler = getBooleanFromString(getConfigValue('useFragHandler')),

advancedFragList = getBooleanFromString(getConfigValue('advancedFragList'))

}

 

function onSay(cid, words, param, channel)

if(not config.useFragHandler) then

return false

end

 

local time = os.time()

local times = {today = (time - 86400), week = (time - (7 * 86400))}

 

local contents, result = {day = {}, week = {}, month = {}}, db.getResult("SELECT `pd`.`date`, `pd`.`level`, `p`.`name` FROM `player_killers` pk LEFT JOIN `killers` k ON `pk`.`kill_id` = `k`.`id` LEFT JOIN `player_deaths` pd ON `k`.`death_id` = `pd`.`id` LEFT JOIN `players` p ON `pd`.`player_id` = `p`.`id` WHERE `pk`.`player_id` = " .. getPlayerGUID(cid) .. " AND `k`.`unjustified` = 1 AND `pd`.`date` >= " .. (time - (30 * 86400)) .. " ORDER BY `pd`.`date` DESC")

if(result:getID() ~= -1) then

repeat

local content = {

name = result:getDataString("name"),

level = result:getDataInt("level"),

date = result:getDataInt("date")

}

if(content.date > times.today) then

table.insert(contents.day, content)

elseif(content.date > times.week) then

table.insert(contents.week, content)

else

table.insert(contents.month, content)

end

until not result:next()

result:free()

end

 

local size = {

day = table.maxn(contents.day),

week = table.maxn(contents.week),

month = table.maxn(contents.month)

}

if(config.advancedFragList) then

local result = "Frags gained today: " .. size.day .. "."

if(size.day > 0) then

for _, content in ipairs(contents.day) do

result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level

end

 

result = result .. "\n"

end

 

result = result .. "\nFrags gained this week: " .. (size.day + size.week) .. "."

if(size.week > 0) then

for _, content in ipairs(contents.week) do

result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level

end

 

result = result .. "\n"

end

 

result = result .. "\nFrags gained this month: " .. (size.day + size.week + size.month) .. "."

if(size.month > 0) then

for _, content in ipairs(contents.month) do

result = result .. "\n* " .. os.date("%d %B %Y %X at ", content.date) .. content.name .. " on level " .. content.level

end

 

result = result .. "\n"

end

 

local skullEnd = getPlayerSkullEnd(cid)

if(skullEnd > 0) then

result = result .. "\nYour " .. (getCreatureSkullType(cid) == SKULL_RED and "red" or "black") .. " skull will expire at " .. os.date("%d %B %Y %X", skullEnd)

end

 

doPlayerPopupFYI(cid, result)

else

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You currently have " .. size.day .. " frags today, " .. (size.day + size.week) .. " this week and " .. (size.day + size.week + size.month) .. " this month.")

if(size.day > 0) then

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Last frag at " .. os.date("%d %B %Y %X", contents.day[1].date) .. " on level " .. contents.day[1].level .. " (" .. contents.day[1].name .. ").")

end

 

local skullEnd = getPlayerSkullEnd(cid)

if(skullEnd > 0) then

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Your " .. (getCreatureSkullType(cid) == SKULL_RED and "red" or "black") .. " skull will expire at " .. os.date("%d %B %Y %X", skullEnd))

end

end

 

return true

end

 

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

[Jpeedro 15]

O erro não é no script, é em alguma database do sql

[Kagador 0]

como arrumar?

[binhosantoos 0]

Estou com esse mesmo problema! Descobri que é um problema na Database SQL, so que não sei como conssertar!