how to show the onlineplayer in website...

[pengsaizhen]

who have the db and website....plz give me the link/

[MentaL]

[Canic]

Its sql ~
Something like

SELECT nCount FROM StatisticsData..tSameTimeChar WHERE nWorld = 0 ORDER BY nIndex DESC

[Krum]

Its sql ~
Something like

SELECT nCount FROM StatisticsData..tSameTimeChar WHERE nWorld = 0 ORDER BY nIndex DESC

^ Not that sql.

SELECT nCharNo FROM w00_Character..LoggedInChars WHERE nAdminLevel = 0 ORDER BY nExp DESC

[pengsaizhen]

^ Not that sql.

SELECT nCharNo FROM w00_Character..LoggedInChars WHERE nAdminLevel = 0 ORDER BY nExp DESC

have the LoggedInChars sql and store process?xd

[Canic]

But my SQL is this one from the optool and works with the word exe. The logged in char table isn't originally added from os

Send from my Nexus 4 with Tapatalk.

[Krum]

have the LoggedInChars sql and store process?xd

English please.

But my SQL is this one from the optool and works with the word exe. The logged in char table isn't originally added from os

Send from my Nexus 4 with Tapatalk.

Well if u say urs work then it should, i never tried it tho. But the one from LoggedInChars works but it's on server restart, if u restarted the server while the player is still in the game and he dced, the row will stay in the table. But if he logged out, the row will disappear, it's dumb.

[Canic]

English please.




Well if u say urs work then it should, i never tried it tho. But the one from LoggedInChars works but it's on server restart, if u restarted the server while the player is still in the game and he dced, the row will stay in the table. But if he logged out, the row will disappear, it's dumb.

This problem don't happen at mine

Send from my Nexus 4 with Tapatalk.

[Krum]

This problem don't happen at mine

Send from my Nexus 4 with Tapatalk.

Ok then i think ur sql is better than mine.