on line player

[fp547]

I'm looking for a web page which I would say the player online on the basis of the table CT clan db

exemple

To view the content, you need to sign in or register

thanks

 

[Mojo-Be]

Here you go. Couldn't test it, don' have pt anymore.

    <?php
    // ---Written by Mojo---
    // ---PTNW--------------
     
    error_reporting(E_ALL | E_STRICT);
    
    $dbhost = "127.0.0.1";
    $dbusername = "sa";
    $dbpassword = "dbpashere";
    $dbname = "ClanDb";
    $db=mysql_connect($dbhost, $dbusername, $dbpassword) or die (mysql_error());
    mysql_select_db($dbname, $db) or die (mysql_error());
    
    
    $query = "SELECT * FROM ClanTicket";
    $query1 = mssql_query($query);
    $numberonline = mssql_num_rows($query1);
    ?>
        <h1>There are <?php echo $numberonline; ?> players online.</h1>
        <table width="100%" border="0">
    <?php
        if(mysql_num_rows($query1) > 0)
        {
            while ($row = mysql_fetch_array($query1))
        {
    ?>
        <tr>
            <td>
                <?php 
                    echo $row['ChName'];
                ?>
            </td>
            <td>
                <?php 
                    echo $row['ClanName'];
                ?>
            </td>
        </tr>
        <p><br />
     <?php
        }
        }else{
            echo "There is no1 online.";
        }
     ?>

Peace, Mojo

 

[fp547]

I not use Mysql. I just use sql and odbc

 

[Mojo-Be]

I will edit it to work.

 

[fp547]

thanks

 

[juniorsk8]

<?php
// Script by Mojo-BE
// Edited by JuNiOrSk8


$dbhost = 'DRIVER={SQL Server};SERVER=YOURCOMPUTER\SQLEXPRESS;DATABASE=ClanDB';
$dbuser = "sa";
$dbpass = "YOURPASSWORD";

$connection = odbc_connect($dbhost, $dbuser, $dbpass);
$query = "SELECT * FROM ClanTicket";
$odbcquery = odbc_exec($connection, $query);
$odbcdo = odbc_do($connection, $query);

while(odbc_fetch_row($odbcdo)) $i++;

if($i>0)
{
?>

 <h1>There are <?php echo $i; ?> players online.</h1>
 <table width="100%" border="0">

<?php
 
 while($row = odbc_fetch_array($odbcquery))
 {
?>

<tr>
 <td>
  <?php echo $row['ChName'];
  ?>
 </td>
 <td>
  <?php echo $row['ClanName'];
  ?>
 </td>
</tr>
<p><br />
<?php
 }
}
else
{
 echo "There is no1 online.";
}
?>

Yeah, working with ODBC ;]

 

[fp547]

very good work

big thanks

 

[juniorsk8]

No problem ;]