[REQUEST] online players script

PowerChaos · 10/03/2008, 19:16

hi all ,

i think that the titel says enouf of what i want to aks , but to be shure i goin write a little more ^^

i aim looking for a script whit a few things

server offline
server online
players online

if posseble it need to be in php :S

i searched the forum already for it and coulnd find it

Thank you for your help and
Greets From The Crasher

Rawsteeey · 10/03/2008, 19:22

its status.php

Kradel · 10/03/2008, 21:25

Way to go, netlog_stefan, way to go. :P

Those files are, most recently, included in

There are a handful of other useful things in there too, as our friend NecroN has kindly broken the non-release barrier.

I attached a copy of it, as well as the config.php file you'll need to edit to make it work.

I obtained the files from NecroN collection above, but I don't know for sure who wrote the original.

~~Spy520~~ · 10/03/2008, 21:47

Quote:

Originally Posted by Kradel

Way to go, netlog_stefan, way to go. :P

Those files are, most recently, included in There are a handful of other useful things in there too, as our friend NecroN has kindly broken the non-release barrier.

I attached a copy of it, as well as the config.php file you'll need to edit to make it work.

I obtained the files from NecroN collection above, but I don't know for sure who wrote the original.

I tried them alot but they say Online Players : 0 and dont increase

PowerChaos · 10/03/2008, 23:12

Thank you for helping me

but he is right , i got a few players online and it shows 0 players online

i got a few accounts and it shows 2 accounts

but for the rest it seems to be working

(i downloaded the other release , some bugs are there fixed )

i think i figured out where the problem is
from the moment i takes a look at the script then i saw that the table where he is looking is missing by me ( table "online" )

Thank you again

Greets From The Crasher

~~Spy520~~ · 10/03/2008, 23:29

Quote:

Originally Posted by The Crasher

Thank you for helping me

but he is right , i got a few players online and it shows 0 players online

i got a few accounts and it shows 2 accounts

but for the rest it seems to be working (i downloaded the other release , some bugs are there fixed )

i think i figured out where the problem is
from the moment i takes a look at the script then i saw that the table where he is looking is missing by me ( table "online" )

Thank you again

Greets From The Crasher

Hey dude online players dont need any table Forecer told me before that i have to run a program called netstat but idk how to fix it :S

~~Spy520~~ · 10/03/2008, 23:53

I got the way from forcer
1st open run ---> cmd ---> type in cmd
netstat -a -n |find "5816" |find "ESTABLISHED" /c
then see the status page it will count the online players if it failed so type in cmd
netstat -a -n |find "9988" |find "ESTABLISHED" /c
or
netstat -a -n |find "8899" |find "ESTABLISHED" /c
If you wana thank me so you must thank Forcer 1st

forcer · 10/04/2008, 00:23

Quote:

Originally Posted by Spy520

I got the way from forcer
1st open run ---> cmd ---> type in cmd
netstat -a -n |find "5816" |find "ESTABLISHED" /c
then see the status page it will count the online players if it failed so type in cmd
netstat -a -n |find "9988" |find "ESTABLISHED" /c
or
netstat -a -n |find "8899" |find "ESTABLISHED" /c
If you wana thank me so you must thank Forcer 1st

this will not update any pages. you will need to exec this code and read output like this:

PHP Code:


			
Online Players: <b><?php echo (exec('netstat -a -n |find "5816"  |find "ESTABLISHED" /c')-2); ?></b><br />

adding this to your index.php should show Online players.

and message for ACE guys: stop being a copy & paste morons and invent something. I'm sick of your constant copying of everything from acme

~~Spy520~~ · 10/04/2008, 00:55

Quote:

Originally Posted by forcer

this will not update any pages. you will need to exec this code and read output like this:

PHP Code:

Online Players: <b><?php echo (exec('netstat -a -n |find "5816" |find "ESTABLISHED" /c')-2); ?></b><br />

adding this to your index.php should show Online players.

and message for ACE guys: stop being a copy & paste morons and invent something. I'm sick of your constant copying of everything from acme

And if you failed this is small example

Code:

<? 
require("config.php");
?>
<STYLE type='text/css'>
body
{
	FONT: 13px Arial;
}
td
{
	FONT: 13px Arial;
}
.Label1 {
	TEXT-ALIGN: right
}
.Label {
	PADDING-LEFT: 5px
}
.Label1 {
	PADDING-LEFT: 5px
}
.Label {
	PADDING-BOTTOM: 16px; FONT: 13px Arial; VERTICAL-ALIGN: top! important; WIDTH: 100px; COLOR: #000; WHITE-SPACE: nowrap
}
.it {
	WIDTH: 160px
}
#ipassword {
	WIDTH: 160px
}
#ipassword2 {
	WIDTH: 160px
}
.it3 {
	VERTICAL-ALIGN: top; WIDTH: 160px
}
.it1 {	WIDTH: 160px
}
.Butt {
	BORDER-RIGHT: #2854a7 1px solid; BORDER-TOP: #7cbaff 1px solid; FONT: bold 12px Arial, Helvetica, sans-serif; BORDER-LEFT: #7cbaff 1px solid; COLOR: #ffffff; BORDER-BOTTOM: #2854a7 1px solid; BACKGROUND-COLOR: #3366cc
}
</STYLE>
<td align="left"><p><?php
			mysql_select_db();
			 = mysql_query("SELECT count(*) FROM account;");
			 = mysql_fetch_array();
			echo "Total Accounts: ".."<br />";
			
			mysql_select_db();
			 = mysql_query("SELECT count(*) FROM cq_user;");
			 = mysql_fetch_array();
			echo "Total Characters: ".."<br />";



			
			echo "Server Status: ";
			 = @fsockopen(, , , , 1);
			if (!) {
				echo "<font style='color: #FF3300'><B>Offline</B></font></br>";
			}
			else
			{
				echo "<font style='color: #009933'><B>Online</B></font></br>";
				fclose();
			}
			?>
Online Players: <b><?php echo (exec('netstat -a -n |find "5816"  |find "ESTABLISHED" /c')-2); ?></b><br />

Kradel · 10/04/2008, 01:17

Quote:

Originally Posted by forcer

and message for ACE guys: stop being a copy & paste morons and invent something. I'm sick of your constant copying of everything from acme

Are you talking about me? :\

PowerChaos · 10/04/2008, 03:06

Thank you forcer , it works now

Just_Me99999 · 10/04/2008, 04:39

Quote:

Originally Posted by Spy520

And if you failed this is small example

Code:

<? 
require("config.php");
?>
<STYLE type='text/css'>
body
{
	FONT: 13px Arial;
}
td
{
	FONT: 13px Arial;
}
.Label1 {
	TEXT-ALIGN: right
}
.Label {
	PADDING-LEFT: 5px
}
.Label1 {
	PADDING-LEFT: 5px
}
.Label {
	PADDING-BOTTOM: 16px; FONT: 13px Arial; VERTICAL-ALIGN: top! important; WIDTH: 100px; COLOR: #000; WHITE-SPACE: nowrap
}
.it {
	WIDTH: 160px
}
#ipassword {
	WIDTH: 160px
}
#ipassword2 {
	WIDTH: 160px
}
.it3 {
	VERTICAL-ALIGN: top; WIDTH: 160px
}
.it1 {	WIDTH: 160px
}
.Butt {
	BORDER-RIGHT: #2854a7 1px solid; BORDER-TOP: #7cbaff 1px solid; FONT: bold 12px Arial, Helvetica, sans-serif; BORDER-LEFT: #7cbaff 1px solid; COLOR: #ffffff; BORDER-BOTTOM: #2854a7 1px solid; BACKGROUND-COLOR: #3366cc
}
</STYLE>
<td align="left"><p><?php
			mysql_select_db();
			 = mysql_query("SELECT count(*) FROM account;");
			 = mysql_fetch_array();
			echo "Total Accounts: ".."<br />";
			
			mysql_select_db();
			 = mysql_query("SELECT count(*) FROM cq_user;");
			 = mysql_fetch_array();
			echo "Total Characters: ".."<br />";



			
			echo "Server Status: ";
			 = @fsockopen(, , , , 1);
			if (!) {
				echo "<font style='color: #FF3300'><B>Offline</B></font></br>";
			}
			else
			{
				echo "<font style='color: #009933'><B>Online</B></font></br>";
				fclose();
			}
			?>
Online Players: <b><?php echo (exec('netstat -a -n |find "5816"  |find "ESTABLISHED" /c')-2); ?></b><br />

Bad example.
People can flood with those useless queries.
And css part? Copy & paste?
Don't put all queries in same page.

No hard feelings, but try to separate them.

PowerChaos · 10/05/2008, 01:45

hehe
i just needed the basic of it to let the online players to showing
becosue i aim making my own kind of script (or let me say , i aim editing the script so its better to what i want ^^ )

to see a previeuw so far, then go to

Thank you all so far from helping me out

all credits goes to the providers of the scripts (and the persones who i got the codes from becouse most of them are from them

Greets From The Crasher

Just_Me99999 · 10/05/2008, 03:32

Quote:

Originally Posted by The Crasher

hehe
i just needed the basic of it to let the online players to showing
becosue i aim making my own kind of script (or let me say , i aim editing the script so its better to what i want ^^ )

to see a previeuw so far, then go to

Thank you all so far from helping me out
all credits goes to the providers of the scripts (and the persones who i got the codes from becouse most of them are from them

Greets From The Crasher

Nice!
Cut off list about max 50 (less stress to your server)
Remove PMs from list...its not fair to players to show how much PMs own Eps.

PowerChaos · 10/05/2008, 04:33

hmm , i aim now buzzy whit inplenting the legion members and so on , but if i can find a way to remove the pm out of it then i will do it

but i cant find a way at this moment to do it (dont know how to start whit it :S )

then a small update , the pm you see on top need to be deleted :P its just a test account ^^

Greets From The Crasher