Users Online

Results 1 to 2 of 2
  1. #1
    Enthusiast Fairytale is offline
    MemberRank
    Nov 2010 Join Date
    25Posts

    Users Online

    How do I make my site show how many people are online in-game?
    I used the search button, but I never could find what I'm looking for.
    Even a link to someones thread regarding how to do this would be nice.


  2. #2
    Enthusiast DopeFlyff is offline
    MemberRank
    Nov 2010 Join Date
    40Posts

    Re: Users Online

    You can use this code.. its for server stats:
    - Total Accounts: ----
    - Total Chars: ----
    - Total Players Online: ----
    - Server Peak : ----

    Code:
    <?php  
                
    
            $link = @mssql_connect("NAMESQLEXPRESS", "sa", "MSSQL PW") or die ("Server is down!");  
            $db = @mssql_select_db('ACCOUNT_DBF') or die ("Keine Accs Vorhanden");  
            $query = mssql_query('SELECT * FROM [ACCOUNT_TBL]');  
            echo 'Accounts: ' . mssql_num_rows($query);  
    echo "<br />";  
    
            $link = @mssql_connect("NAMESQLEXPRESS", "sa", "SQL PW") or die ("Server is down!");  
            $db = @mssql_select_db('CHARACTER_01_DBF') or die ("Keine Chars Vorhanden");        
            $query = mssql_query('SELECT * FROM [CHARACTER_TBL]');  
            echo 'Characters: ' . mssql_num_rows($query);   
    echo "<br />";  
    
            $link = @mssql_connect("NAMESQLEXPRESS", "sa", "SQL PW") or die ("Error!");  
            $db = @mssql_select_db('ACCOUNT_DBF') or die ("Keine Accs Vorhanden");  
                    $query = mssql_query("SELECT * FROM [ACCOUNT_TBL_DETAIL] WHERE isuse = 'J' ");  
                    $usersOnline =  mssql_num_rows($query);  
            echo 'Users Online: ' . $usersOnline;  
    echo "<br />";  
            $link = @mssql_connect("NAMESQLEXPRESS", "sa", "SQL PW") or die ("Error!");  
            $db = @mssql_select_db('LOGGING_01_DBF') or die ("Kein Peak Vorhanden");  
            $query = mssql_query("SELECT TOP 1 number FROM [LOG_USER_CNT_TBL] ORDER BY [number] DESC");  
            $peak =  mssql_fetch_row($query);  
            echo 'Server Peak: ' . $peak;  
    ?>
    Thanks button ?

    Ciao,
    Me



Advertisement