Blane Posted January 10, 2008 Share Posted January 10, 2008 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 Quote Link to comment Share on other sites More sharing options...
DrenepiaWorld Posted January 10, 2008 Share Posted January 10, 2008 1st wrong section..it should be --->Lineage II Develop [L2J] 2nd i think Anni already share them ... Quote Link to comment Share on other sites More sharing options...
Blane Posted January 10, 2008 Author Share Posted January 10, 2008 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? Quote Link to comment Share on other sites More sharing options...
Unstopable Posted January 10, 2008 Share Posted January 10, 2008 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. Quote Link to comment Share on other sites More sharing options...
Blane Posted January 11, 2008 Author Share Posted January 11, 2008 anyway move it like you want... Quote Link to comment Share on other sites More sharing options...
Blane Posted January 11, 2008 Author Share Posted January 11, 2008 could anyone make my karma 0 .. :) Quote Link to comment Share on other sites More sharing options...
TheVortex Posted January 11, 2008 Share Posted January 11, 2008 Already posted a same like this one here! http://www.maxcheaters.com/forum/index.php?topic=16023.0 Search before post. Quote Link to comment Share on other sites More sharing options...
Blane Posted January 11, 2008 Author Share Posted January 11, 2008 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... Quote Link to comment Share on other sites More sharing options...
l2dvc Posted September 25, 2009 Share Posted September 25, 2009 php error :(( Quote Link to comment Share on other sites More sharing options...
GangsteяBoy™ Posted November 17, 2009 Share Posted November 17, 2009 Nc Topic Man..Good Job Quote Link to comment Share on other sites More sharing options...
yankiller Posted October 8, 2010 Share Posted October 8, 2010 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! Quote Link to comment Share on other sites More sharing options...
piotress Posted October 8, 2010 Share Posted October 8, 2010 blane explain there up if you read :) Quote Link to comment Share on other sites More sharing options...
yankiller Posted October 10, 2010 Share Posted October 10, 2010 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.. Quote Link to comment Share on other sites More sharing options...
piotress Posted October 10, 2010 Share Posted October 10, 2010 u must integrate them in <?php ?> Quote Link to comment Share on other sites More sharing options...
yankiller Posted October 11, 2010 Share Posted October 11, 2010 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.