Ok then shall we move on ? LOLFirst download all of these :- MYSQL 5.0.45- MySQL GUI Tools 5.0-r122.1 Install MySQL 5.0.27 -Click Next-Choose Typical and then click Next.-Click Install.-Choose to skip sign up and then click Next.-When the installation finished, Tick Configure the MySQL Server now and click Finish.-Now you can choose Detailed Configuration or Standard Configuration. This would be up to you to choose any of it. You can just choose standard configuration and click Next.-Next, Under Service Name Column, Choose MYSQL5 and then click Next.-Next, Just enter any password for this root user and click next. Do not change the username as this username and password would be used later as your database login.-Click Execute and after its done, click Finish. If any errors occurs, uninstall MYSQL5.0.27 and reinstall everything again.2.2 Install MySQL GUI Tools 5.0-r82.3 Open MySql Adminstrator and it will prompt out a window, Type in the Host Name, Username and password as shown below.Stored Connection: [Just leave this column empty] Server Host: localhost Username: root Password: (enter the password you have created before for the user root) Port: 3306-Click Ok and you should now be in MYSQL Adminstrator.-Go to your left column and look for User Adminstration and click on Add New User.-Enter this inside the columns:MySQL User: ragnarok Password: ragnarok Confirm Password: ragnarok Click Apply Changes when you are done. -When you are done, exit MYSQL Adminstrator.2.4 Open MYSQL Query Browser from your Desktop or Start Menu.-If you cant find it in your desktop, try finding it from the following directory C:\Program Files\MySQL\MySQL Tools for 5.02.5 After you open MySQL Query Browser, a window should prompt out, type this out in the following blanks:Stored Connection: [just leave it empty] Server Host: localhost Username: root Password: [enter the password we created before for root] Default Schema: ragnarok Port: 3306Click OK to create a new ragnarok schema.You should now be inside MySQL Query Browser.Click once on the Ragnarok Database on your right column and make sure it is bold.Go to menu, click File, Open Script and search for a folder named sql-files which should be in your eAthena Server Folder.When you are inside the sql-files folder with your MySQL Query Browser, click on Main.sql and click open.Once it is done loading, click on the Green Execute Button on your upper right hand corner and it should do some executing. Do the same with Mail.sql and some latest upgrade.sql .Once you are done, click on the Resultset 1 Tab to go back to the main page. Right click on any database, eg.Ragnarok and choose Create New Schema , type in log and click ok. Once it is done, click once on log database and make sure it is bold, Go to menu, File, Open Script and choose logs.sql and click on the Green Execute Button.Now, click on the Resultset 1 to go back to the main page. Click once on Ragnarok database, right click on Ragnarok database and click refresh. There should be some database files shown on your right column. Search for a database named login and click Quadruple (4) times on it.A window should prompt out .To edit the login table, click once on edit on the bottom, look at column 1 and change the username s1 , password p1 to the username and password you used eariler on in your char_athena and map_athena.To make a GM[Game Master] Account, Right click on any place between the white screen, click create new column. Change the newly created empty column number id to 2000000 and choose a username and password for your GM account. As for the level column , put 99 for adminstrator.After you have done, click Apply Changes.You are now done with your MySql Database. EXIT now.
Okay I'll continue with some WPE tutorial ^^Here's the method to refine fast..1. Open your ragnarok online and go to the refinement wherever you want ( if possible find the place where no people crowded so easier to record the packet ^^ )2. Open your WPE Pro Alpha or download HERE3. Choose target program then search your RO Client > Open3. Click the Play button like the picture below5. After that go back to your RO Client then do refine +1 only to head and click enter until the dialog finished then back to WPE Pro and click the Stop button like the picture below6. There will spawn some packet pop up.. Right click at the first packet and choose "add to send list" and right click again at the first packet and choose "Set Send list with this socket ID"Do the same to all packet ( about 8~10 ) in order from 1-107. Now close the pop up window then go to the Send tabThen check all the packet and now click the play button below the"Gauge" tab And Click the Play buttonThen it will spawn a pop up like thisThen Set it like thisTimes : Set the times by ( total packet you record times by 4 ( e.g : 10 packet x 4 = 40)Timer : 0 MilisecondsOpen Socketand Leave the Socket ID ( DON'T CHANGE IT )Then click the play button..And.... WALAAA CONGRATS THAT YOUR Headgear has been refined to +4 in a sec..you can refine other headgear you just need to change your headgear and just click the play button ( on the pop-up )want to refine the other equipment ? ( e.g : shoes , garment , etc )Just do the same thing ( record packet , send packet )LOL ^^NB : After you send the packet , but at the ragnarok side there is some dialogue left don't choose continue.. choose the close/stop instead.. if you choose the continue one you will be DC and you must do record packet again... that's suck.. hahaha LOL 2b1af7f3a8