avesta status problem

[Ganjita]

Someone can help me?, im using rev 94 avesta, the problem is on my webpage(znote converted 7.x) when server is online the webpage show always 0 online players, im searching about how to solve but nothing.
img1.-

img2.-
but when on database i switch my status to 1(on table players > status from 0 to 1)

img3
--> the players online found good

someone can help me?, i think i need add an UPDATE(status '1') etc.. but i dont know, thanks in advance!, greetings

 

[Ganjita]

someone can help me?, im trying add some same :

mysqlQuery("UPDATE `players` SET `status` = 1 " " WHERE `name` = .. getPlayerName(cid) .. ", "UPDATE")

i dont know the sintaxis

 

[Znote]

Shouldn't it automatically update online status?

Worst case scenario, make a globalevent that runs like every 5 minute updating player status.

mysqlQuery("UPDATE `players` SET `status` = '0';", "UPDATE")
membersList = getPlayersOnlineList()
for i, _cid in pairs(membersList) do
    mysqlQuery("UPDATE `players` SET `players`.`status`=1 WHERE `players`.`name` = \"" .. getPlayerName(_cid) .. "\"", 'UPDATE')
end

or make it as creaturescript

login.lua

mysqlQuery("UPDATE `players` SET `players`.`status`=1 WHERE `players`.`name` = \"" .. getPlayerName(cid) .. "\"", 'UPDATE')

logout.lua

mysqlQuery("UPDATE `players` SET `players`.`status`=0 WHERE `players`.`name` = \"" .. getPlayerName(cid) .. "\"", 'UPDATE')

 

[53701688]

Ganjita I can code this for you in the sources I use it for warloria aswell.

 

[Ganjita]

Shouldn't it automatically update online status?

Worst case scenario, make a globalevent that runs like every 5 minute updating player status.

mysqlQuery("UPDATE `players` SET `status` = '0';", "UPDATE")
membersList = getPlayersOnlineList()
for i, _cid in pairs(membersList) do
    mysqlQuery("UPDATE `players` SET `players`.`status`=1 WHERE `players`.`name` = \"" .. getPlayerName(_cid) .. "\"", 'UPDATE')
end

or make it as creaturescript

login.lua

mysqlQuery("UPDATE `players` SET `players`.`status`=1 WHERE `players`.`name` = \"" .. getPlayerName(cid) .. "\"", 'UPDATE')

logout.lua

mysqlQuery("UPDATE `players` SET `players`.`status`=0 WHERE `players`.`name` = \"" .. getPlayerName(cid) .. "\"", 'UPDATE')

I try when i reach my hluse, thanks znote! You always save me

Ganjita I can code this for you in the sources I use it for warloria aswell.

What files i need edit?, i think i can try code that by myself but i never know where start

 

[Ganjita]

Shouldn't it automatically update online status?

Worst case scenario, make a globalevent that runs like every 5 minute updating player status.

mysqlQuery("UPDATE `players` SET `status` = '0';", "UPDATE")
membersList = getPlayersOnlineList()
for i, _cid in pairs(membersList) do
    mysqlQuery("UPDATE `players` SET `players`.`status`=1 WHERE `players`.`name` = \"" .. getPlayerName(_cid) .. "\"", 'UPDATE')
end

or make it as creaturescript

login.lua

mysqlQuery("UPDATE `players` SET `players`.`status`=1 WHERE `players`.`name` = \"" .. getPlayerName(cid) .. "\"", 'UPDATE')

logout.lua

mysqlQuery("UPDATE `players` SET `players`.`status`=0 WHERE `players`.`name` = \"" .. getPlayerName(cid) .. "\"", 'UPDATE')

found good!, thanks brou

 

[thokk]

I'm having EXACTLY this problem (https://otland.net/threads/problems-with-website.236084/#post-2279463) someone can explain to me what i have to do? I read but i don't understand. What i have to change in my server/website?

I have to copy this login.lua and make a creaturescript with this content?