TalkAction [TFS 0.2]Show list of players with same IP (offline and online)

[Gesior.pl]

TESTED on TFS 0.2pl23 with mysql database
it's modified deathlist.lua script
Add new talkaction and in script paste:

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

It show list like (player id - name):

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

 

[Master-m]

I think it would be better to show the ip+name insteed of the id:O.

 

[kacpersky]

i get this: a player with that name doesnt exist ...

 

[richux]

I think it would be better to show the ip+name insteed of the id:O.

Yes, Gesior please do so!

PS. Ur awesome!

 

[GangsteR]

Nice script thanks but i dont understand why
dofile("./config.lua") on the script ?

 

[Zonet]

@up
It checks the config.lua if the server is SQLITE OR MYSQL if mysql then it works.

    if sqlType == "mysql" then

 

[GangsteR]

Yup, got it ^^
Thanks Zonet

 

[Mazen]

Change:

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, id .. " - " .. name)

to:

doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, lastip .. " - " .. name)

I guess that will make it view the ip address instead of the player id.