TESTED on TFS 0.2pl23 with mysql database
it's modified deathlist.lua script
Add new talkaction and in script paste:
It show list like (player id - name):
it's modified deathlist.lua script
Add new talkaction and in script paste:
PHP:
dofile("./config.lua")
function onSay(cid, words, param)
if sqlType == "mysql" then
env = assert(luasql.mysql())
con = assert(env:connect(mysqlDatabase, mysqlUser, mysqlPass, mysqlHost, mysqlPort))
else -- sqlite
env = assert(luasql.sqlite3())
con = assert(env:connect(sqliteDatabase))
end
local players = 0
for id, name, lastip in rows(con, "SELECT `id`,`name`,`lastip` FROM `players` WHERE `lastip`=(SELECT `lastip` FROM `players` WHERE `name`='" .. escapeString(param) .. "') AND `lastip` > 0;") do
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, id .. " - " .. name)
players = players + 1
end
if players == 0 then
doPlayerSendCancel(cid, "A player with that name does not exist or never logged in.")
end
con:close()
env:close()
end
18:52 2 - GM Jony
18:52 28 - Speedy
18:52 29 - Maniek
18:52 3184 - Tinki Winki
18:52 3775 - Lala
18:52 4792 - Sir Black
Last edited: