Online Players PHP Script + Face PCs

[DarkKnightCZ]

yamimarik: works on every project

 

you didnt set right password and username in config.php and in config.php you have some error on line 8

 

btw Leki edit this

 

Finaly Create and write <?php 
require("Config.php");...

 

to

 

Finaly Create and write

<?php 
require("config.php");...

 

(big c in config.php (for almost every server wont work if letters are different (c has another postition in ascii table than C) ) )

 

 

and one extension :)

 

 

if you wanna show only online users (not GMs), replace that mysql_query with

 

SELECT count(*) FROM characters WHERE online = 1 AND accesslevel = 0

 

 

 

anyway, good share

 

 

 

 

edit : Spiros: not effective, too much "sql queries" for "fully loaded database" while running l2 servers (with count(*) like Leki wrote its better)

edit no2: Spiros: you have bad syntax, it wont run ;-)

[Gam3Master]

Man write a simple php script.

 

<?php

 

$MySQL_Connection = mysql_connect("localhost", "root", root");

 

if($MySQL_Connection) {

    if(mysql_select_db("l2jdb", $MySQL_Connection)) {

              $MySQL_Action = "SELECT online FROM character WHERE online = 1";

              $MySQL_Query = mysql_query($MySQL_Action, $MySQL_Connection);

              $Number_of_rows = mysql_num_rows($MySQL_Query);

              echo("Online players: $Number_of_rows);

      }

      else {

            echo("Wrong");

      }

}

else {

      echo("Wrong");

}

 

?>

 

 

A very simple online player script!!!!

i think that method is more protected

[dendrinos]

Nice.. :not bad:

[Ilusioner]

thanks, i learn some tricks again  ;D

[dendrinos]

its too complicated for me :/

[baban]

nice job man

[Iqes]

ohh you mean like this ?