Jump to content

Recommended Posts

Posted

{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

Posted

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 ;]

  • 1 month later...

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • From Salvation onwards I think you need a patched nwindow.dll that allows such modifications, try to see if you get what you need here: https://drive.google.com/drive/u/1/folders/1LLbQFGf8KlR-O0Iv5umfF-pwZgrDh9bd
    • hello everyone! I am wanting to save the files (Ini. - Data - ) of the EP5 Client: Salvation... But they generate the error "corrupt files"... I tried several versions of L2FileEditor without good results. I need help! Thank you!
    • Opening December 6th at 19:00 (GMT +3)! Open Beta Test from November 30th!   https://l2soe.com/   🌟 Introducing L2 Saga of Eternia: A Revolution in Lineage 2 High Five! 🌟   Dear Lineage 2 enthusiasts, Prepare to witness the future of private servers! L2 Saga of Eternia is not just another High Five project—it’s a game-changing experience designed to compete with the giants of the Lineage 2 private server scene. Built for the community, by the community, we’re here to raise the bar in quality, innovation, and longevity. What Sets Us Apart? 💎 No Wipes, Ever Say goodbye to the fear of losing your progress. Our server is built to last and will never close. Stability and consistency are our promises to you. ⚔️ Weekly New Content Our dedicated development team ensures fresh challenges, events, and updates every week. From custom quests to exclusive features, there will always be something exciting to explore. 💰 No Pay-to-Win Skill and strategy matter most here. Enjoy a balanced gameplay environment where your achievements come from effort, not your wallet. 🌍 A Massive Community With 2000+ players expected, join a vibrant and active community of like-minded adventurers ready to conquer the world of Aden. 🏆 Fair and Competitive Gameplay Our systems are designed to promote healthy competition while avoiding abusive mechanics and exploits. 🔧 Professional Development From advanced bug fixes to carefully curated content, we pride ourselves on smooth performance, no lag, and unparalleled server quality. Key Features Chronicle: High Five with unique interface Rate: Dynamic x10 rates Class Balance: Carefully fine-tuned for a fair experience PvP Focused: PvP Ranking & aura display effect for 3 Top PvPers every week Custom Events: Seasonal and permanent events to keep you engaged Additional Features:   Custom Endgame Content: Introduce unique dungeons, raids, or zones unavailable in other servers. Player-Driven Economy: Implement a strong market system and avoid overinflated drops or rewards. Epic Siege Battles: Announce special large-scale sieges and PvP events. Incentives for Streamers and Clans: Attract influencers and big clans to boost server publicity. Roadmap Transparency: Share a public roadmap of planned updates to build trust and excitemen   Here you can read all the features: https://l2soe.com/features   Video preview: Join the Revolution! This is your chance to be part of something legendary. L2 Saga of Eternia is not just a server; it’s a movement to redefine what Lineage 2 can be. Whether you’re a seasoned veteran or a newcomer to the world of Aden, we invite you to experience Lineage 2 at its finest.   Official Launch Date: December 6th 2024 Website: https://l2soe.com/ Facebook: https://www.facebook.com/l2soe Discord: https://discord.com/invite/l2eternia   Let’s build the ultimate Lineage 2 experience together. See you in-game! 🎮
    • That's like a tutorial on how to run l2 on MacOS Xd but good job for the investigation. 
    • small update: dc robe set sold   wts adena 1kk = 1.5$ 
  • Topics

×
×
  • Create New...