Website Online Players Live php Script

[Aurel Andrei]

Hi,

im created php script for showing only Active Players on game and this script it's Live!

<?
$con = mssql_connect("localhost", "sa", "your_password") or die();
mssql_select_db("MuOnline", $con) or die();



$onlinedata = mssql_query("Select memb___id, ConnectStat, ConnectTM from MEMB_STAT where ConnectStat = 1 order by ConnectTM desc");
$i=1;
while($row = mssql_fetch_array($onlinedata)) {
    $onlinename = mssql_query("Select GameIDC from AccountCharacter where id='".$row['memb___id']."'");
    $onlinemap = mssql_query("Select MapNumber,CtlCode,cLevel from Character where Name='".$row['memb___id']."'");

$guma = mssql_fetch_array($onlinename);
    echo $i." - ".$guma['GameIDC']." [".$row['memb___id']."]<br />===================================<br />";

$i++;
}

if you need other php scripts for MuOnline website, tell me and i help you!

[MentaL]

[RevolGaming]

odbc is much secure. and add costum solution, so wazzap if the man have got Me_MuOnline, MuOnline etc?

make a php file like online.php and a config.php file where the people can setup the config... so you can add me_muonline, etc..

[Aurel Andrei]

this script im created only for me to see online players on server if me im not home... :) and its easy to change data base name
you see:

mssql_select_db("MuOnline", $con) or die(); 

you can change "MuOnline" in your DB name :)

[RevolGaming]

yeah, but if i have multi db... so i have Me_MuOnline (included accounts) MuOnline(inclouded characters1) MuOnline2 (included characters2)
your code not will run...

[Aurel Andrei]

you can try this..

<?
$con = mssql_connect("localhost", "sa", "your_password") or die();
mssql_select_db("Me_MuOnline", $con) or die();
mssql_select_db("MuOnline", $con) or die();
mssql_select_db("MuOnline2", $con) or die();



$onlinedata = mssql_query("Select memb___id, ConnectStat, ConnectTM from MuOnline.MEMB_STAT AND MuOnline2.MEMB_STAT where ConnectStat = 1 order by ConnectTM desc");
$i=1;
while($row = mssql_fetch_array($onlinedata)) {
    $onlinename = mssql_query("Select GameIDC from Me_MuOnline.AccountCharacter  where id='".$row['memb___id']."'");
    $onlinemap = mssql_query("Select MapNumber,CtlCode,cLevel from MuOnline.Character AND MuOnline2.Character where Name='".$row['memb___id']."'");

$guma = mssql_fetch_array($onlinename);
    echo $i." - ".$guma['GameIDC']." [".$row['memb___id']."]<br />===================================<br />";

$i++;
}

you have exemple from multiple conections up

[strdekliko]

LINK DOWNLOAD :

http://rapidu.net/7369941869/online.rar
http://freakshare.com/files/oru3g2hi/online.rar.html

[Ralpyy]

Does anybody have got "Active In 24H" code?