[Release] Get users online (logged in mapserver)

[Rafael Carvalho]

SELECT * FROM [DNMembership].[dbo].[DNAuth] where CertifyingStep = 2

[MentaL]

[SePhII2oth]

CertifyingStep = 1 means that the user is in character select screen.
CertifyingStep = 2 means the user is in Gameserver (playing)
CertifyingStep = 0 menas the user is offline.

[lecet988]

what from php?

[ikanbakar4]

<?php
$query = sqlsrv_query("SELECT * FROM DNMembership.[dbo].DNAuth a JOIN DNWorld.[dbo] Characters b ON a.CharacterID = b.CharacterID where a.CertifyingStep = 2");

while($row = sqlsrv_fetch_array($query)){
echo $row['CharacterName']. '<br/>';
}
?>

[lecet988]

<?php
$query = sqlsrv_query("SELECT * FROM DNMembership.[dbo].DNAuth a JOIN DNWorld.[dbo] Characters b ON a.CharacterID = b.CharacterID where a.CertifyingStep = 2");

while($row = sqlsrv_fetch_array($query)){
echo $row['CharacterName']. '<br/>';
}
?>

thanks sir, then what for asp file :) thanks

[aphexman]

<?php
$query = sqlsrv_query("SELECT * FROM DNMembership.[dbo].DNAuth a JOIN DNWorld.[dbo] Characters b ON a.CharacterID = b.CharacterID where a.CertifyingStep = 2");

while($row = sqlsrv_fetch_array($query)){
echo $row['CharacterName']. '<br/>';
}
?>

Dont work, can u share full php?

[lecet988]

i make asp, sorry i forget :(

[ikanbakar4]

Dont work, can u share full php?

didn't work ? please share your error message when running that script.
you must install sqlsrv module if you using xampp / IIS
for tutorial search on google
and you must make connection script on your php script

i make asp, sorry i forget :(

sorry i never develop using asp :)