TalkAction /Namelock tfs 1.x

[Sir Islam]

have fun for all

Request:
[TFS 1.0] namelock/ban reason

talkactions.xml

<talkaction words="/namelock" separator=" " script="namelock.lua" />

namelock.lua

function onSay(player, words, param)
    if not player:getGroup():getAccess() then
        return true
    end

    local name = param
    local reason = ''

    local separatorPos = param:find(',')
    if separatorPos ~= nil then
        name = param:sub(0, separatorPos - 1)
        reason = string.trim(param:sub(separatorPos + 1))
    end

    local PlayerGUID = getPlayerGUIDByName(name)
    if PlayerGUID == 0 then
        return false
    end

    local timeNow = os.time()
    db.query("INSERT INTO `player_namelocks`(`player_id`, `reason`, `namelocked_at`, `namelocked_by`) VALUES (".. PlayerGUID.."," .. db.escapeString(reason) .. ","..timeNow.."," .. player:getGuid() .. ")")
    local target = Player(name)
    if target ~= nil then
        player:sendTextMessage(MESSAGE_EVENT_ADVANCE, target:getName() .. " has been Namelock.")
        target:remove()
    else
        player:sendTextMessage(MESSAGE_EVENT_ADVANCE, name .. " has been Namelock.")
    end
end

how to use

/namelock name,reason

<talkaction words="/unlock" separator=" " script="unlock.lua"/

unlock.lua

function onSay(player, words, param)
   if not player:getGroup():getAccess() then
     return true
   end

   local resultId = db.storeQuery("SELECT `id` FROM `players` WHERE `name` = " .. db.escapeString(param))
   if resultId == false then
     return false
   end

   db.asyncQuery("DELETE FROM `player_namelocks` WHERE `player_id` = " .. result.getDataInt(resultId, "id"))
   result.free(resultId)
   player:sendTextMessage(MESSAGE_EVENT_ADVANCE, param .. " has been unlock.")
   return false
end

/unlock name


if you use tfs 1.0

chnage

db.asyncQuery
db.query

to

db:query

 

[raf]

Awesome, thank's for contribution. Could you also add sql query to alter table?

 

[Sir Islam]

Awesome, thank's for contribution. Could you also add sql query to alter table?

    db.query("INSERT INTO `player_namelocks`(`player_id`, `reason`, `namelocked_at`, `namelocked_by`) VALUES (".. PlayerGUID.."," .. db.escapeString(reason) .. ","..timeNow.."," .. player:getGuid() .. ")")

 

[Untrax]

U can make /unlock?
Used for disable namelocked.

 

[WibbenZ]

Not 1.x, 1.1+.

And use player:getGuid (once you have checked if the player exists) insted of getPlayerGUIDByName.

 

[Sir Islam]

U can make /unlock?
Used for disable namelocked.

update : add unlock

 

[Untrax]

update : add unlock

Uool <3 u are best, thanks!

 

[Sir Islam]

Thanks a lot bro you are welcome

 

[raf]

Ugh, sorry to bother again. Is this, updated, version working on TFS 1.0 ? Cause the previous version, before update - it didnt.

 

[Sir Islam]

Ugh, sorry to bother again. Is this, updated, version working on TFS 1.0 ? Cause the previous version, before update - it didnt.

chnage

db.asyncQuery
db.query

to

db:query

 

[froie]

I'm trying but it isn't working its saying this

http://oi59.tinypic.com/9quv0p.jpg

 

[WibbenZ]

I'm trying but it isn't working its saying this

http://oi59.tinypic.com/9quv0p.jpg

As I stated above, this is not for 1.x.
You have to recompile the userdata values to make sure it will work with older versions.