Panelių bazė
Sveiki, jūs panelių bazėje.
Neaktyvuotų panelių: 0
Viso panelių: 377
Ieškoti panelės
Neaktyvuotų panelių: 0
Viso panelių: 377
Ieškoti panelės
Panelės peržiūra
| Pavadinimas | L2 Online Users |
| Įdėjo | R0ny - Pateikta: 2008-08-27 - Peržiūrėta: 6627 |
| Aprašymas | Sipanele skirta l2 statusui Ji parodo kiek serveryje zmoniu tereikia irasyti reikiamus laukeliu PAZYMEJAU ! |
| Panelė | Code <?php
//first you need to define db info
define('mySQL_hostname', 'Tavo IP'); //database IP
define('mySQL_database', 'Database'); //database name
define('mySQL_username', 'User'); //database user
define('mySQL_password', 'Pass'); //database password
//connects to mysql
$db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )
or die( 'Error connecting to mysql<br><br>'.mysql_error() );
//connects to Database
$db_select = mysql_select_db( mySQL_database, $db_link )
or die( 'Error connecting to Database<br><br>'.mysql_error() );
//selects desired table
$chars=mysql_query("SELECT * FROM characters");
//tells how much rows are there (will come helpfull with while loops)
$rows =mysql_numrows($characters);
$i=0;
$x=0;
//while $i is smaller than number of rows repeat the code
while ($i < $rows) {
$online=mysql_result($chars,$i,"online"); //looks into characters table, under column online(if player is online its "0" else "1"), at row $i
if ($online == 1) { $x++; } // if column online at row $i is "1", increase $x
$i++; //increase $i
}
print 'Online players:<em>'.$x.'<em>'; //prints out the $x number of players online
?> |
Rašyti komentarą
Turite prisijungti, norėdami parašyti komentarą.
Man bi?ki itartina pasidar kam tos database? :|
kad galetu prisijungt ir naudot duomenis kas online
kaip ja ikelti?
Pakelk ir nune?k
Susikurkit php fail ir j ra?ykit.. :|
neveikia
Viskas veikia reik tik txt failiuka susikurt ;)
tj susikuri txt failiuka ir ka su juo daryt?
tj susikuri txt failiuka ir ka su juo daryt?
Nefloodink !!! :@
Nu ir irasai sita :
//first you need to define db info
define('mySQL_hostname', 'Tavo IP'); //database IP
define('mySQL_database', 'Database'); //database name
define('mySQL_username', 'User'); //database user
define('mySQL_password', 'Pass'); //database password
//connects to mysql
$db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )
or die( 'Error connecting to mysql
'.mysql_error() );
//connects to Database
$db_select = mysql_select_db( mySQL_database, $db_link )
or die( 'Error connecting to Database
'.mysql_error() );
//selects desired table
$chars=mysql_query("SELECT * FROM characters");
//tells how much rows are there (will come helpfull with while loops)
$rows =mysql_numrows($characters);
$i=0;
$x=0;
//while $i is smaller than number of rows repeat the code
while ($i < $rows) {
$online=mysql_result($chars,$i,"online"); //looks into characters table, under column online(if player is online its "0" else "1"), at row $i
if ($online == 1) { $x++; } // if column online at row $i is "1", increase $x
$i++; //increase $i
}
print 'Online players:'.$x.''; //prints out the $x number of players online
?>