TFS 1.X+ Old System Kills old school tfs 1.5 7.72

[bpm91]

hello guys, I have an old system, where there is no blacskull. the player has redskull and ban like old times.
however I have a table in my database that counts the kills.
however there is a problem, let's say I remove the player's skull and the ban. then the "player_murders" continues without updating, so when the player loses redskull/ban he kills 1 person he is banned again. can anybody help me?

the table in mysql

CREATE TABLE `player_murders` (
  `id` bigint(20) NOT NULL,
  `player_id` int(11) NOT NULL,
  `date` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

my config data

-- Red Skull
killsDayRedSkull = 3
killsWeekRedSkull = 5
killsMonthRedSkull = 10
-- Ban
killsDayBanishment = 5
killsWeekBanishment = 10
killsMonthBanishment = 20
redSkullTime = 30 * 24 * 60 * 60

if i remove skull in player in the table and the ban in account_ban
and the player kills 1 person he is banned again.

 

[Fresh]

Not tested

function Player.truncateFrags(self)
  return db.query(("DELETE FROM `player_murders` WHERE `player_id` = %d"):format(self:getId()))
end

Usage where you remove frags:

player:truncateFrags()

Enjoy errors since not tested and I don't have an working TFS 1.X+ environment set up

 

[bpm91]

Excuse my ignorance, but where do I apply?

iologindata.cpp

    std::ostringstream query;

    query << "SELECT `date` FROM `player_murders` WHERE `player_id` = " << player->getGUID() << " ORDER BY `date` ASC";
    if ((result = db.storeQuery(query.str()))) {
        do {
            player->murderTimeStamps.push_back(result->getNumber<time_t>("date"));
        } while (result->next());
    }

    query.str(std::string());

 

[Shadow_]

nope

function Player.truncateFrags(self)
  return db.query(("DELETE FROM `player_murders` WHERE `player_id` = %d"):format(self:getId()))
end

add this in data/lib/core/player.lua after the last line

and you can use player:truncateFrags() in the code that bans players when they reach X kills so before ban you need to add the function player:truncateFrags()

 

[bpm91]

work ty <3

 

[Felipe93]

nope

function Player.truncateFrags(self)
  return db.query(("DELETE FROM `player_murders` WHERE `player_id` = %d"):format(self:getId()))
end

add this in data/lib/core/player.lua after the last line

and you can use player:truncateFrags() in the code that bans players when they reach X kills so before ban you need to add the function player:truncateFrags()

" in the code that bans players when they reach X kills so before ban you need to add the function player:truncateFrags()"
where is that code? in source or in the datapack itself?