Someone asked me for code to show war frags on guild chat. I made it for him, but he said I can release it.
In file data/creaturescripts/scripts/playerdeath.lua replace:
With:
Tested on TFS 1.3 downgraded to 8.6 ( nekiro/forgottenserver (https://github.com/nekiro/forgottenserver/tree/8.6-downgrade) ).
In file data/creaturescripts/scripts/playerdeath.lua replace:
Code:
if warId ~= false then
db.asyncQuery("INSERT INTO `guildwar_kills` (`killer`, `target`, `killerguild`, `targetguild`, `time`, `warid`) VALUES (" .. db.escapeString(killerName) .. ", " .. db.escapeString(player:getName()) .. ", " .. killerGuild .. ", " .. targetGuild .. ", " .. os.time() .. ", " .. warId .. ")")
end
Code:
if warId ~= false then
local killerFrags = 0
local targetFrags = 0
resultId = db.storeQuery("SELECT COUNT(1) AS frags FROM `guildwar_kills` WHERE `warid` = " .. warId .. " AND `killerguild` = " .. killerGuild)
if resultId ~= false then
killerFrags = result.getNumber(resultId, "frags")
result.free(resultId)
end
killerFrags = killerFrags + 1
resultId = db.storeQuery("SELECT COUNT(1) AS frags FROM `guildwar_kills` WHERE `warid` = " .. warId .. " AND `killerguild` = " .. targetGuild)
if resultId ~= false then
targetFrags = result.getNumber(resultId, "frags")
result.free(resultId)
end
local currentScoreKiller = "Current score: " .. killer:getGuild():getName() .. " - " .. killerFrags .. " : " .. targetFrags .. " - " .. player:getGuild():getName()
sendGuildChannelMessage(killerGuild, TALKTYPE_CHANNEL_R1, killer:getName() .. " killed enemy " .. player:getName() .. " at level " .. player:getLevel() .. ". " .. currentScoreKiller)
local currentScoreTarget = "Current score: " .. player:getGuild():getName() .. " - " .. targetFrags .. " : " .. killerFrags .. " - " .. killer:getGuild():getName()
sendGuildChannelMessage(targetGuild, TALKTYPE_CHANNEL_R1, player:getName() .. " died at level " .. player:getLevel() .. " by enemy " .. killer:getName() .. ". " .. currentScoreTarget)
db.asyncQuery("INSERT INTO `guildwar_kills` (`killer`, `target`, `killerguild`, `targetguild`, `time`, `warid`) VALUES (" .. db.escapeString(killerName) .. ", " .. db.escapeString(player:getName()) .. ", " .. killerGuild .. ", " .. targetGuild .. ", " .. os.time() .. ", " .. warId .. ")")
end
Tested on TFS 1.3 downgraded to 8.6 ( nekiro/forgottenserver (https://github.com/nekiro/forgottenserver/tree/8.6-downgrade) ).
Last edited: