Ive decided to make this thread cuz theres allot of good servers out there with pages looking like something frontpage would spit out.. besides it was time to give something back to the rz community =)
I could post all scripts from castle sieges to clan hall owners lol.. but i will just post this 3 for example.. and ofcourse learning purposes..
Server Status:
anyway status script is the easyest thing to do with php.. and i wont even try to explain it since its mostly obvious..
Code:
<?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:
I wasted allot of time to get to know what encryption l2 uses for passwords.. anyway i wanted to spare you some time..
First create acc.php file in same directory as index.. and add this script to it
Code:
<?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
Code:
<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..
Code:
<?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
?>
sometimes you will only get for example clan id.. not the name of it.. and in that case i suggest you use 2 whiles (one inside the other) to check other tables for names...
hope it was helpful.. enjoy
