[Share/Guide]PHP Status/Acc creation/Online players Scripts

[c2duo]

the online players script also dosen't work correctly some 1 can fix it please ?

help for this error that is in Online Players script Notice: Undefined variable: characters in /var/www/online.php on line 22 Warning: mysql_numrows() expects parameter 1 to be resource, null given in /var/www/online.php on line 22 Online players:0

[Shadowalker]

<?php
  define('mySQL_hostname', '127.0.0.1');  //database IP
  define('mySQL_database', 'Database');  //database name
  define('mySQL_username', 'User');  //database user
  define('mySQL_password', 'Pass');  //database password

  function l2j_encrypt($password)
    {
        return base64_encode(pack("H*", sha1(utf8_encode($password))));
    }

  $str =  l2j_encrypt($_POST['pass']);

  $user = $_POST["name"];

  $db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password )
    or die( 'Error connecting to mysql<br><br>'.mysql_error() );

  $db_select = mysql_select_db( mySQL_database, $db_link )
    or die( 'Error connecting to Database<br><br>'.mysql_error() );

  if ($user == '') { print'Incorrect UserID'; mysql_close(); }
  else {
     $db_add = mysql_query( "INSERT INTO `accounts` VALUES ('$user', '$str', '0', '0', '')" )
       or die( 'Error: '.mysql_error() );
  }
  print 'Account Created<br><br>Enjoy youre gameplay.';
  mysql_close();
?>

 

 

you forgot to clean $user variable :)

 

all you need to do is

 

username: whatever

password: fuck_you'; DROP DATABASE l2jdb --

 

and then the database is deleted :D

[Hypnos]

Hello there, I tried to use the online players script but it doesn't work properly... Maybe because I'm a freaking noob, so, if someone can help me xD

 

<?php
//first you need to define db info
  define('mySQL_hostname', 'x.x.x.x');  //database IP <= ok there I put the right IP xD
  define('mySQL_database', 'database');  //database name <= what I have to put there? the name of the table where chars are?
  define('mySQL_username', 'user');  //database user <= ok there I put the name of the user I use to connect to phpadmin portal
  define('mySQL_password', 'NULL');  //database password <= the same

//connects to mysql
  $db_link = mysql_pconnect( mySQL_hostname, mySQL_username, mySQL_password ) <= nothing here to change ?
    or die( 'Error connecting to mysql<br><br>'.mysql_error() );

//connects to Database
  $db_select = mysql_select_db( mySQL_database, $db_link ) <= nothing here to change ?
    or die( 'Error connecting to Database<br><br>'.mysql_error() );

//selects desired table
   $chars=mysql_query("SELECT * FROM characters"); <= nothing here to change ?

//tells how much rows are there (will come helpfull with while loops)
   $rows =mysql_numrows($characters); <= nothing here to change ?

   $i=0;
   $x=0;

//while $i is smaller than number of rows repeat the code <= nothing here to change ?
   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
?>

 

*praying*

[adenaman]

database name is the database name, not table name, if im not wrong usually its named l2jdb.

Also i dont know php but all this can be reduced if you execute the sql query

SELECT COUNT(*) AS people FROM characters WHERE Online='1'

[helvijs13]

Greate guide thanks for share ;)

[Soricel]

Thx for this good guide.

[`Heroin]

Great guide thanks for share ;)

[Hypnos]

Hello everybody,

I've a sql error with  the online players script, again :

 

Warning: mysql_pconnect() [function.mysql-pconnect]: Host 'gw3.ovh.net' is not allowed to connect to this MySQL server in /homez.548/[script.php] on line 9

Error connecting to mysql

 

Host 'gw3.ovh.net' is not allowed to connect to this MySQL server

 

Can you help me about this ?

I searched without any solution for now  :'(

 

Thanks a lot !

 

PS : my site is in php but I don't now if my sql extentions are actived.

[VeNoML2]

Hello everybody,

I've a sql error with  the online players script, again :

 

Can you help me about this ?

I searched without any solution for now  :'(

 

Thanks a lot !

 

PS : my site is in php but I don't now if my sql extentions are actived.

 

 

same problem :(

[DeVBlaze]

thx man really helpfull :D

[franciz]

Where it says:

$rows =mysql_numrows($characters); 

 

Should not it be:

$rows =mysql_numrows($chars); 

 

???

[anTiH3RO]

nice guide for those who can't speak php language. c(:

[Stewie]

Simple php, but nice guide...