OnlinePlayers indicator ! how?

[Rulzan]

i need something for my web that will show the online players,i saw on a lot of webs.. i use 5065 tq binarys
something like

Login Server: Online
Game Server: Online
Registration Server: Online
Players Online: 35

Only the Players online stuff i need

[magnon]

E*Pvpers only can help u

[3mrz]

Then someone help him >.>

[Rulzan]

Originally Posted by magnon

E*Pvpers only can help u

your post supose to help me ?

[damianpesta]

Originally Posted by Rulzan

your post supose to help me ?

Hmm I think that source suppose to be saving the character count to an ini file , and everytime someone logs/logs out it updates the ini file with the count of the characters online , and your website reads the ini file with the charr count.I think thats the way , maybe not...?

[yuko]

DATABASE.CS

public static void ChangeOnlineStatus(string AccID, int online)
        {
            MySqlCommand Cmd = new MySqlCommand("UPDATE `accounts` SET `online` = \"" + online + "\" WHERE `AccountID` = \"" + AccID + "\"", DatabaseConnection.NewConnection());
            Cmd.ExecuteNonQuery();
            Cmd.Connection.Close();
            Cmd.Connection.Dispose();
            Cmd.Dispose();
        }

PACKETPROCESSOR.CS

Database.Database.ChangeOnlineStatus(CSocket.AccountName, 1);//online

CLIENTSOCKET.CS

Database.Database.ChangeOnlineStatus(AccountName, 0);//offline

database(mysql)

ALTER TABLE `accounts` ADD `online` BOOL NOT NULL ;

edit it the way you want.

[Kiyono]

Originally Posted by yuko

DATABASE.CS

public static void ChangeOnlineStatus(string AccID, int online)
        {
            MySqlCommand Cmd = new MySqlCommand("UPDATE `accounts` SET `online` = \"" + online + "\" WHERE `AccountID` = \"" + AccID + "\"", DatabaseConnection.NewConnection());
            Cmd.ExecuteNonQuery();
            Cmd.Connection.Close();
            Cmd.Connection.Dispose();
            Cmd.Dispose();
        }

PACKETPROCESSOR.CS

Database.Database.ChangeOnlineStatus(CSocket.AccountName, 1);//online

CLIENTSOCKET.CS

Database.Database.ChangeOnlineStatus(AccountName, 0);//offline

database(mysql)

ALTER TABLE `accounts` ADD `online` BOOL NOT NULL ;

edit it the way you want.

He uses the TQ Binaries.

[Rulzan]

**** im sad..i really wanna have that indicator

[hunterman01]

Originally Posted by Rulzan

**** im sad..i really wanna have that indicator

Then Dont use binarys lol

[Rulzan]

Originally Posted by hunterman01

Then Dont use binarys lol

lol,i hate those crappy-reply's
i thing you eat lotf every day..

[L1nk1n*P4rK]

Man what you need i a php indicator???
to show you how much ppls are online???

BTW Rulzan I just release Table Editor V2 go and test it :P

[blakesmi13]

well...you can do /player all and it shows all players online in top left and /player map shows how many players is on that map hope it helped

[Zeroxelli]

PHP Code:

$sql = mysql_query("SELECT COUNT(*) AS PlayersOnline FROM characters WHERE Online='true'");
if($row = mysql_fetch_array($sql))
    echo "{$row['PlayersOnline']} Players online." 


Or something ;O

[coles]

Originally Posted by Zeroxelli

#Request Delete Post

Wtf, if I lag it sends twice? ;'<

Meh, quickest way to get an online count for server is run a shell netstat command.
Ofcourse using this method would require you to have the correct OS permissions.

same goes for status, query an ip and port (can increase page load times if not written properly)

[Zeroxelli]

Originally Posted by coles

Meh, quickest way to get an online count for server is run a shell netstat command.
Ofcourse using this method would require you to have the correct OS permissions.

same goes for status, query an ip and port (can increase page load times if not written properly)

He's talking about getting the players online, on the game server. The only two ways of doing that are MySQL and Flatfiles. MySQL is obviously easier and in some cases faster. Plus, you don't need extra r+ perms for the folder of your host. Netstat isn't smart unless you're hosting on your own machine, or a nix shell.