[Riotblade]

Anyone got a script that shows how many registered accounts there are and how many players are on currently? Thanks

[Mana Isozaki]

Its been posted before. Use search.

[Riotblade]

Ugh... I mean *.ASP scripts.

[Mana Isozaki]

Again, been posted. Use search.

[willy_sunny]

lol, poor riot <_<

PS: Why is this thread in this sub forum?

[azndragon]

From the top of my head, try these code samples. Not sure if the database structure is 100% correct, but it should be relatively easy to fix.

Number of registered accounts:

Quote

<?php
mssql_connect('localhost', 'login', 'tai');
mssql_select_db('nLogin');
$query = "SELECT * FROM login";
$result = mssql_query($query);
$accounts = mssql_num_rows($result);
echo "There are $accounts total accounts on the server.";
?>

Number of online players:

Quote

<?php
mssql_connect('localhost', 'login', 'tai');
mssql_select_db(user);
$query = "SELECT * FROM t_user WHERE tu_state = '1'";
$result = mssql_query($query);
$online = mssql_num_rows($result);
echo "There are $online players online.";
?>

[serra]

@Riotblade

Try this.

@azndragon

He requested ASP, not PHP scripts. ;) Also, concerning the sql you have.. could use just 'SELECT tu_state COUNT(1) FROM t_user' or 'SELECT * COUNT(*) FROM login'. Those I think would just throw back the number of rows where the count condition is true instead of having php need a large array to count the rows from. If mssql doesn't support count I would be somewhat surprised.

[azndragon]

Didn't read the PHP part, and shouldn't mssql_num_rows work in the same way as you suggestion? The execution time should be very close, not even worth the time it takes to understand the query, cause I never used complex SQL queries :D JOIN was as far as I needed to do what I do.

This post has been edited by azndragon: 22 April 2004 - 12:29 AM

[serra]

Dumb cs classes keep on drilling extreme models to make me code with more efficiency.. try counting the rows of the itemlog table or something, maybe that will sway you over to learning the wonderful joys of sql :D

[azndragon]

Meh, I'm still new to the PHP/MySQL scene :lol:

[TweaK]

MSSQl :blink:

[serra]

sql is sql is sql.. in general B)