Jump to content

Recommended Posts

Posted

If it's double post please delete.

 

This Guide experts in Creating your servers databases,databases users,configuring Daedalus L2J Account Manager,in a way that your server is fully protected.

This Guide is addressed for account managers,installed in a different server than the server your gameserver is running on,with your account manager configured properly,to be able to connect to your gameserver's loginserver database securely.

 

 

This is a very important part about your server's security.

 

First of all i suggest you to have seperate databases for loginserver and gameserver.

A good choice is to make a database called loginserver for your loginserver(Login server database includes,your server's accounts basically)

As for the  gameserver i suggest you to make a database called gameserver.

I assume you already know how to install your l2j server database in 2 seperate databases.(one database for login server,one database for gameserver)

Now,that you have your databases installed,make sure you make the step 1 from database part.(This step is to later in this Guide)

 

Okay,you must now set up the proper permissions user/database permissions in  order to proceed to the Account Manager Tutorial.

 

In this tutorial you will create 1 extra user for your account manager in your website to have access in your database.

 

1)Open your Navicat. (www.navicat.com)

2)open your connection to the localhost

3)Click the "Manage Users" icon.

4)Now you see there is already a user in your mysql server.The (root@localhost) user,click create new user.In the hostname field write the server ip that you have your website.

(Note**The ip i am telling about isn't the ip you see in your Cpanel,or the ip you got from your hosting account information.It is the true server ip that your website is hosted in this server,This is because the ip of your website has blocked inbound traffic,and your script won't work.So you must ask your hosting provider what is the server's basic ip address)

Then the ip address they told you,you must put it in the hostname field.

For username we are gonna use "web_acm" without the quotes for this tutorial.

As for the password you can use whatever you like,but make sure you write them down on a paper,because you can forget this information.

Okay,now you have succesfully created the user that has access to your loginserver database, from your website.

5)You must now,give proper permissions to that user.Now left click,on your web_acm user,you will now see your 2 databases.(loginserver,gameserver),left click again to loginserver.(now you can see some tables)left click to accounts table(you can now see some fields.The only permissions you must give are "Select, Insert, Update".

Now do the same thing for the account_data table,but now you must give these permissions."select, insert, delete"

6)Done,your permissions are set correctly.

 

                    ACCOUNT MANAGER TUTORIAL

 

 

Download it's latest version by clicking this link.

New Version  :Account Manager  http://trac2.assembla.com/l2j_manager/changeset/latest/account_manager/?old_path=/&format=zip

SVN Version : SVN http://svn2.assembla.com/svn/l2j_manager/

Timeline : Account Manager http://trac2.assembla.com/l2j_manager/timeline

Old Version : Account Manager http://heliosdaedalus.free.fr/account_manager.tar.gz

Follow the steps bellow.

 

 

1)Upload this .zip folder in your webspace,in plublic_html(if you have Cpanel as your  control panel) and if you don't have Cpanel this is probably your web folder (www) that you need to upload your .zip file.

2)Extract it.You will see now a folder called account_manager.

3)Rename account_manager folder to acm.

4)We need to set permissions for some files in order to install and make the account manager work.

5)In the root directory of acm (/acm/) set permissions of all files to 644.

6)Inside of (/acm/libs/) set permissions to all files to 644.

7)Inside of (/acm/libs/plugins/) set permissions to all files to 644.

8)Inside of (/acm/libs/internals/) set permissions to all files to 644.

9)Inside of (/acm/language/) set permissions to all files to 644.

10)Go in (/acm/classes) and change permissions of all files to 644.

11)Inside  (/acm/templates/) you can see the templates you have.For each template you want to use,go inside it's folder and give 644 permissions to all the files,and then go to its /image folder and give 755 permissions to all images too.

Warning!

Don't try to give 644 privilenges to the files of a folder,by giving 644 to the folder,this will not change the privilenges of the files inside.

 

Configuration part

 

Configure in the (/acm/) the config.php to match your loginserver's database settings.(in the hostname put your dedicated server's ip,for database use your loginserver database,and for user use the user you created for your website to access your loginserver "web_acm is the user used in this tutorial",in the password put your user's password)

 

Database part

 

Execute the db.sql to the login server database.

 

Test

 

Run the install.php to see if all things go right.

If you see all things as ok then all went right.

 

 

Finished!

Your Account Manager is now perferctly configured and your database is secured.

Have fun.

 

 

Tutorial not mine, original source http://www.hopzones.net/forum/topic/116/

Guest
This topic is now closed to further replies.


  • Posts

    • Only 3 days left and we'll start with some events, you can check our Discord for more info!
    • Tired of frantically switching between windows trying to find that specific Warlock who should be casting saves? Forgot which server you left your Warsmith on? This mod solves these problems! What it does: Turns the boring window title into an information panel: Server Name - Character Name [Class] Real-life examples: - ServerName - HardcoreFarm [Spoilerr] (who's been spoiling for 3 months already) - ServerName - ClericHelper [Buffer] (eternal buffer on standby) - ServerName - MainChar [Gladiator] (main character who's always AFK) Why you need this: For multiboxers - to avoid confusing where the DD is and where the healer is For the forgetful - if your memory is like a goldfish For streamers - viewers immediately see who's on screen For adults - when playing at work and need to quickly hide the window DLL only - no Interface files needed Installation (more complicated than making tea): 1. Download the DLL 2. Drop it into the System folder 3. Launch the client 4. Be amazed how you lived without this before! Purchase Conditions: Price: 100$ Payment Method: USDT. How to Buy: Contact me on Telegram: @kiselevwv for a quick response. I will answer all your questions and provide additional information if needed. I guarantee functionality at the moment of sale and prompt assistance with setup after purchase.
    • I agree, l2damage crap to compare to l2java which was the father of pvp servers and till this days people playing there for good time.
    • 📝 Registration — Account Registration Creating a new player account. Usually includes: login password password confirmation email Result: a new record is created in the accounts table (loginserver). 🔑 Change Password — Password Change The player changes the password knowing the current one. Required: current password new password new password confirmation Result: the password field is updated in the accounts table. ♻️ Password Recovery — Password Reset If the player forgot the password. Implementation only via email: the player enters their login, email the system sends an email with a link or code the player opens the link / enters the code sets a new password Result: the password is updated in the accounts table.   All fields are validated (required, format, length, uniqueness, security checks).   Price: 80$   and i can rewrite script for PTS server.   Contacts:   Telegram Discord
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..