isPlayerOnline(name)

[Shawak]

This function check, if the player is online .

Version:
TFS 0.3.5.

data/lib/functions.lua at the end, add:

function isPlayerOnline(name)
	local result = db.getResult("SELECT `online` FROM `players` WHERE `name` = '"..name.."';")
	return result:getDataInt("online") == 1 and TRUE or FALSE
end

Example:

function onSay(cid, words, param, channel)
	if isPlayerOnline(param) == TRUE then
		doPlayerSendTextMessage(cid, 18, ""..param.." is online.")
	else
		doPlayerSendTextMessage(cid, 18, ""..param.." is offline.")
	end
	return TRUE
end

I hope you like it .

Regards,
Shawak

 

[Andrespro]

Nice function, It will help to create a TalkAction to add Premium Points for Shop System using:

if isPlayerOnline(param) == FALSE then

=)

 

[JDB]

Simple but usefull!
Should be implemented into 0.3.5!

 

[Shawak]

Nice function, It will help to create a TalkAction to add Premium Points for Shop System using:

if isPlayerOnline(param) == FALSE then

=)

Simple but usefull!
Should be implemented into 0.3.5!

@Andrespro: There you go :thumbup:.

@JDB: Thanks .

 

[chojrak]

if (getPlayerByName(param) == true) then
do something
end

Why?

Cause `online` = 1 in sometimes is while player is offline. Crash etc.

 

[Shawak]

if (getPlayerByName(param) == true) then
do something
end

Why?

Cause `online` = 1 in sometimes is while player is offline. Crash etc.

, don't know that, i change script now.

EDIT:

1. Why crashes?

 

[chojrak]

I mean when server crash then player's `online` column is still 1, but player is offline.

 

[Shawak]

I mean when server crash then player's `online` column is still 1, but player is offline.

Not realy, look in TFS 0.3.5 globalevents:

function onStartup()
	db.executeQuery("UPDATE `players` SET `online` = 0 WHERE `world_id` = " .. getConfigValue('worldId') .. ";")
	return TRUE
end

 

[chojrak]

Sry, i'm not using 0.3.5

 

[Shawak]

No Problem .

 

[Jano]

instead using a query you could do

players = getonlineplayers
ret = false

for _, player in ipairs(players) do
if string.lower(getcreaturename(player)) == string.lower(param?) then
ret = true
break
end
end


however nice way

 

[Shawak]

but i'm showing you other way to do the same using less memory.

..not decided people.

@Nahruto: If you have 500+ players online, it laaaag?

 

[Jano]

nope is as fast as do for i = 1, 500 do print(i) end

 

[Shawak]

nope is as fast as do for i = 1, 500 do print(i) end

Then it is the same, and my is shorter .

 

[chojrak]

Then it is the same, and my is shorter .

Lol, idiot. Why you talking about in other thread?

 

[Shawak]

Lol, idiot. Why you talking about in other thread?

Don't understand what you mean .

 

[chojrak]

Cause i not mean getPlayerByName is faster than your query, but doCombatHealth is faster than yours loop + getThingFromPos.

 

[Sync]

nice =D

 

[Shawak]

Cause i not mean getPlayerByName is faster than your query, but doCombatHealth is faster than yours loop + getThingFromPos.

I know and i mean:

for _, player in ipairs(players) do
if string.lower(getcreaturename(player)) == string.lower(param?) then
ret = true
break
end
end

I thing 1 query is faster .

@chris77: Thanks + Nice Spammer :thumbup:.

 

[Sync]

Nice spammer because i beleive this was a nice script which i could use on my server for some unique things? lmao