[Share]PHP Status/Acc creation/Online players Scripts For your Site!!!

[Blane]

I found this useful guide in RZ.I decided to repost it here to help newbies making their site and adding these scripts:

 

Server Status:

 

<?php
    print'<table width="150">';
    $server  = "127.0.0.1";
    $portg   = "7777";
    $portl   = "9014";
    $timeout = "5";

    if ($server and $port and $timeout) {
        $game =  @fsockopen("$server", $portg, $errno, $errstr, $timeout);
        $login =  @fsockopen("$server", $portl, $errno, $errstr, $timeout);
    }
    print'<tr><td align="center"><strong>Server Status</strong></td></tr>';
    if($login) { print'<tr><td>Login:</td><td><font color="#00FF00"><strong> Online</strong></font><br><br></td></tr>'; }
    else { print'<tr><td>Login:</td><td><font color="#FF0000"><strong> Offline</strong></font><br><br></td></tr>'; }
    if($game) { print'<tr><td>Game:</td><td><font color="#00FF00"><strong> Online</strong></font></td></tr>'; }
    else { print'<tr><td>Game:</td><td"><font color="#FF0000"><strong> Offline</strong></td></tr>'; } 
    print'</table>';
?>

 

Acc Creation:

 

First create acc.php file in same directory as index.. and add this script to it:

 

<?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();
?>

 

after that add this to index

 

<form action="acc.php" method=post>
                        UserID:<input type="text" name="name" size 20><br><br>
                        Password:<input type="password" name="pass" size 20><br><br>
                         <input type=submit name="submit" value="Login">
            </form>

 

Online Players:

 

This script connects to the database(that means you need to have php connected to sql.. if you need any help with it try searching with google for apache php mysql install guides and i bet first link will work). Ive explained some of the code.. so learning from it should be easy..

 

<?php
//first you need to define db info
  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

//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
?>

 

Ok that's all!

REMEMBER: It's just a reshare for a user in RZ.I think it's suitable for the forum.

 

Regards

nS-Blane

[DrenepiaWorld]

1st wrong section..it should be --->Lineage II Develop [L2J]

2nd i think Anni already share them ...

[Blane]

1st wrong section..it should be --->Lineage II Develop [L2J]

2nd i think Anni already share them ...

 

1st: It's not says about l2JDeveloping...but website develop and its theme is L2...so it's in right section.

2nd: Surly no..I searched....wth?

[Unstopable]

well if you wanna get technical about it, the only people who would need this are people who are running a private server website > running a private server > should be in the L2j Dev section.

[Blane]

anyway move it like you want...

 

[Blane]

could anyone make my karma 0 .. :)

[TheVortex]

Already posted a same like this one here!

http://www.maxcheaters.com/forum/index.php?topic=16023.0

Search before post.

[Blane]

Already posted a same like this one here!

http://www.maxcheaters.com/forum/index.php?topic=16023.0

Search before post.

 

I searched...damn hell :P

I am really sorry you can delete my post if you want...It was just a repost...

[l2dvc]

php error :((

[GangsteяBoy™]

Nc Topic Man..Good Job

[yankiller]

Guys i know that i might piss you off but how the hell do i use these?Where put them?Give me any help in general if you can,someone answer me or post a link to a guide,thx in advance!

[piotress]

blane explain there up if you read :)

[yankiller]

how do i add these scripts to my site?change the ips data user and pass?then what,just copy paste on website,it doesnt work this way..

[piotress]

u must integrate them in <?php

?>

[yankiller]

first of all thx man for tring to help,but i still get nothing,i pute them in website and i just see them as simple letters,....nothing works.