xMrPwN Posted March 2, 2010 Share Posted March 2, 2010 {translation from my same guide in greek section} Ok, I don't know if this guide has been posted before but I'll make it very detailed Let's Start Supposing that we go to our web's files and we make a folder "/config" and inside we create a file "stats.php" inside it we put the following: <?php $db_user = "USER"; $db_pass = "PSW"; $db_name = "DATABASE"; $db_serv = "HOST(ip)"; $res = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]"); $resdb = mysql_select_db ( "$db_name",$res ); return $res; ?> we fill them according to our database the infos of how to connect to the database will be in this file(all infos are secure with this form) -------------------------------------------------------------------------------------------- afterwards, the page we want to show the infos must have on it's top: <?php include "config/stats.php" ?> and these: <?php mysql_connect($db_serv,$db_user,$db_pass) or die(mysql_error()); mysql_select_db($db_name) or die(mysql_error()); afterwards we write what we want from the file, to load from the database here are some examples for: //Total Accounts $query = ("SELECT * FROM accounts WHERE accesslevel>=0"); $result = mysql_query($query) or die(mysql_error()); $acc2=mysql_numrows($result); //GMs Online $query = ("SELECT * FROM characters WHERE accesslevel=200 and online=1"); $result = mysql_query($query) or die(mysql_error()); $GM=mysql_numrows($result); //Online Players $query = ("SELECT * FROM characters WHERE accesslevel<=0 and online=1"); $result = mysql_query($query) or die(mysql_error()); $online=mysql_numrows($result); //Total Characters $query = ("SELECT * FROM characters WHERE accesslevel>=0"); $result = mysql_query($query) or die(mysql_error()); $char2=mysql_numrows($result); //Total clans $get_config_data="SELECT clan_id FROM clan_data"; $query = ("SELECT clan_id FROM clan_data WHERE clan_id>0"); $result = mysql_query($query) or die(mysql_error()); $clan2=mysql_numrows($result); last lines of each code, for example: "$clan2=mysql_numrows($result);" clan2 will the name in wich everything will be written on the file, we can modify it if we want to then we conclude connect code with: mysql_close(); mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error()); mysql_select_db($db_name) or die(mysql_error()); ?> and after everything is written, to show the info, about total characters for example, on the site we write: Total Characters: <?php print ("$char2"); ?> (//Total characters(the script) must be in the same page in wich Total Characters: will be shown, if it's not, we simply add this on that page: <?php include "ToFilePouTaExeis.php" ?> I hope i've been helpful :) PS: whoever can please take my karma back to 0 ;p Quote Link to comment Share on other sites More sharing options...
TheiPodKid Posted March 3, 2010 Share Posted March 3, 2010 omg... Everyone who downloads a Lineage2 website there is a Online/Offline status already... Quote Link to comment Share on other sites More sharing options...
paulik Posted March 3, 2010 Share Posted March 3, 2010 tnx for share it again :) but use search before u post smt this think is shared 123123 times Quote Link to comment Share on other sites More sharing options...
xMrPwN Posted March 3, 2010 Author Share Posted March 3, 2010 omg... Everyone who downloads a Lineage2 website there is a Online/Offline status already... im refering to ppl who don't use that ready stuff but have the experience to create sth themselves and need a short guide to help them ;] Quote Link to comment Share on other sites More sharing options...
l2death Posted April 7, 2010 Share Posted April 7, 2010 i have a problem plz help me.:S add me mjpzzz024@hotmail.com tnx Quote Link to comment Share on other sites More sharing options...
`Rοmeο Posted April 7, 2010 Share Posted April 7, 2010 haha that are the scripts from mine website : http://www.maxcheaters.com/forum/index.php?topic=115992.0 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.
Note: Your post will require moderator approval before it will be visible.