Diconfrost VaNz

Download these files first:

MySQL Gui Tools

MySQL Essentials

Download Compiled SVN here(I suggest to use trunk)

When you're done downloading those files, follow these steps:

==========// SVN Files Setup //==========

1) Goto your downloaded svn and extract it.

2) Goto conf folder and look for char_athena.txt, inter_athena.txt, map_athena.txt and subnet_athena.txt

3) Open char_athena.txt, and map_athena.txt and look for this:


 
// Server Communication username and password.userid: s1passwd: p1   

and change that into


 
// Server Communication username and password.userid: ragnarokpasswd: ragnarok   

2) Open your char_athena.txt again and look for this:


 
// Login Server IP// The character server connects to the login server using this IP address.// NOTE: This is useful when you are running behind a firewall or are on// a machine with multiple interfaces.//login_ip: 127.0.0.1// The character server listens on the interface with this IP address.// NOTE: This allows you to run multiple servers on multiple interfaces// while using the same ports for each server.//bind_ip: 127.0.0.1// Login Server Portlogin_port: 6900// Character Server IP// The IP address which clients will use to connect.// Set this to what your server's public IP address is.//char_ip: 127.0.0.1remove the "//" in login_ip and char_ip. It will look like this:// Login Server IP// The character server connects to the login server using this IP address.// NOTE: This is useful when you are running behind a firewall or are on// a machine with multiple interfaces.login_ip: 127.0.0.1// The character server listens on the interface with this IP address.// NOTE: This allows you to run multiple servers on multiple interfaces// while using the same ports for each server.//bind_ip: 127.0.0.1// Login Server Portlogin_port: 6900// Character Server IP// The IP address which clients will use to connect.// Set this to what your server's public IP address is.char_ip: 127.0.0.1   

3) Open your inter_athena.txt and look for this:


 
// Global SQL settings// overriden by local settings when the hostname is defined there// (currently only the login-server reads/obeys these settings)sql.db_hostname: 127.0.0.1sql.db_port: 3306sql.db_username: ragnaroksql.db_password: ragnaroksql.db_database: ragnaroksql.codepage:// MySQL Character SQL serverchar_server_ip: 127.0.0.1char_server_port: 3306char_server_id: ragnarokchar_server_pw:ragnarokchar_server_db: ragnarok// MySQL Map SQL Servermap_server_ip: 127.0.0.1map_server_port: 3306map_server_id: ragnarokmap_server_pw: ragnarokmap_server_db: ragnarok// MySQL Log SQL Databaselog_db_ip: 127.0.0.1log_db_port: 3306log_db_id: ragnaroklog_db_pw: ragnaroklog_db_db: loglog_codepage:   

if you're using my guide that is a given and you don't need to edit them. But if you're planning to change any of here like the user password or what, you need to change this too.

4) Open your map_athena.txt and look for this:



 
// Character Server IP// The map server connects to the character server using this IP address.// NOTE: This is useful when you are running behind a firewall or are on// a machine with multiple interfaces.//char_ip: 127.0.0.1// The map server listens on the interface with this IP address.// NOTE: This allows you to run multiple servers on multiple interfaces// while using the same ports for each server.//bind_ip: 127.0.0.1// Character Server Portchar_port: 6121// Map Server IP// The IP address which clients will use to connect.// Set this to what your server's public IP address is.//map_ip: 127.0.0.1// Map Server Portmap_port: 5121remove "//" in char_ip, and map_ip, it will look like this:// Character Server IP// The map server connects to the character server using this IP address.// NOTE: This is useful when you are running behind a firewall or are on// a machine with multiple interfaces.char_ip: 127.0.0.1// The map server listens on the interface with this IP address.// NOTE: This allows you to run multiple servers on multiple interfaces// while using the same ports for each server.//bind_ip: 127.0.0.1// Character Server Portchar_port: 6121// Map Server IP// The IP address which clients will use to connect.// Set this to what your server's public IP address is.map_ip: 127.0.0.1// Map Server Portmap_port: 5121   

5) Open you subnet_athena.txt and you'll see this:


 
subnet: 255.0.0.0:127.0.0.1:127.0.0.1   

If you changed the ips in char_athena.txt, inter_athena.txt and map_athena.txt, you should consider to put them here too.

for example, the ip is 125.60.252.169

 
subnet: 255.0.0.0:125.60.252.169:125.60.252.169   

==========// MySQL Setup //==========

1) Install MySQL Gui Tools

2) Install MySQL Essentials. Choose MySQL 501. Enter "ragnarok" for the password for "root"(remember you can change this later on, this is just a basic one). Just click the Execute and when done, just click Finish. Go to Task Manager and check if mysqld-nt.exe is running in processes although it's not necessary if no error occured during installation.

3) Start MySQL Query nd it will prompt up a window. Fill in


 
Stored Connection: (leave it blank)Server Host: localhost  Port: 3306Username: rootPassword: (remember the password you made when you're installing MySQL Essentials?put it here)Default Schema: ragnarok(you can change this afterwards, this is just a basic name)   
and leave other field as it is but to make sure everything is correct. Then press enter.

4) *When you are in MySQL Query Browser, click once on ragnarok database that is below Schemata.
*Go to menu, click File and choose Open Script...
*We need to execute main.sql, mail.sql and log.sql (execute upgrade_svn* .sql files, too, if require) so, look for the main.sql, which should be in sql-files folder in eAthena Server and other .sql files.
*Pick main.sql and click Open.
*Click the Green Execute Icon to the upper right to execute. Do the same with mail.sql now and execute it.
*When you are done, we need to create log database by right-click somewhere within the table where the databases are and choose Create New Schema and type in log and click OK.
*Double-click on log database, go to menu, click File, choose Open Script..., open logs.sql and Execute.
*Double click ragnarok database to expand to see all tables.
*Look for login table and double click and double click again.
*Click once on Edit so, we can edit the cells. This icon should be in bottom.
*For userid: and user_pass:, type in the name that you used in char_athena.conf and map_athena.conf.
*When you are done editing, just click the Apply Changes that is next to the Edit icon.

5) Goto MySQL Administrator. Login there.


 
Stored Connection: (leave it blank)Server Host: localhost  Port: 3306Username: rootPassword: (remember the password you made when you're installing MySQL Essentials?put it here)    
Then Enter.

6) And you're inside the MySQL Administrator now. Go to User Administration and Click New User and enter this:


 
MySQL User: ragnarokPassword: ragnarokConfirm Password: ragnarok   
then click "Apply Changes".

After that, Click the ragnarok user and goto schema priviledges(right-side of user information). Click ragnarok and log database and click "<<", then click "Apply Changes"

And we're done  

Flux Control Panel for Hercules
 
Flux CP is now officialy available for Hercules!
 
It is fully working with both pre-Renewal and Renewal Hercules servers. We will continue developing it, so it is always up-to-date and compatible with latest Hercules.
 
New theme
Hercules' Flux CP comes with a brand new theme. It's a grey-ish modern and clean HTML5 theme, called Emphaino.
It has a nice dropdown menu located on top of the screen, and a customizable footer area, where you can put some stuff that should be visible all the time (like links to social media, forums etc.).
 
A picture is worth a thousand words:



 
It's a HTML5 theme, so it requires a decent browser, or IE9+ (if you insist on using that).
 
Theme selection
Having two themes is great, but until now it was impossible to make use of them both. That's why theme selector has been added to both themes, so your users can pick whichever theme they like more.
 
Again, preview:

 
Extra credits
Authors of original FluxCP & FluxCP-rA. Authors of Emphaino theme (originally for Wordpress).

 
Download
Hercules' FluxCP Github repository: https://github.com/HerculesWS/FluxCP
 
Issues
Bug reports, questions and suggestions are all welcome directly on GitHub: https://github.com/HerculesWS/FluxCP/issues
 
Enjoy~

This should work(in theory)
 
getpartymember getcharid(1),0; getpartymember getcharid(1),1; getpartymember getcharid(1),2; set .@count, $@partymembercount; copyarray .@name$[0], $@partymembername$[0], $@partymembercount; // list the party member names for (set .@i,0; .@i < .@count; set .@i, .@i+1) { if ((readparam(Class,.@name$[.@i]) == 4075 || readparam(Class,.@name$[.@i]) == 4076) && isloggedin( $@partymemberaid[.@i], $@partymembercid[.@i]) //THE PARTY HAS A WANDERER/MINSTREL! //THE PARTY HAS A WANDERER/MINSTREL! //THE PARTY HAS A WANDERER/MINSTREL! } close;  
 
Uses readparam script command.
 
The actual readparam usage is
 
 
 
readparam(<type>{,"<character name>"}); type can be
 
StatusPoint, BaseLevel, SkillPoint, Class, Upper, Zeny, Sex, Weight, MaxWeight,
JobLevel, BaseExp, JobExp, NextBaseExp, NextJobExp, Hp, MaxHp, Sp, MaxSp,
BaseJob, Karma, Manner, bVit, bDex, bAgi, bStr, bInt, bLuk

@Yuki, i will try to do your suggestions

It looks like a very decent and nice design so far, though I cannot give better comments if I cannot see the whole layout with more words and buttons, etc.   Nevertheless, I think what you did to the background image overall was neat, and having background pictures within each box is pretty nice as well (but I need to see how they are with words on top, just to see if it will look cluttered).   I have a few suggestions (do not necessarily have to follow them, just my opinion =D):   1. For the boxes with the swirl image in the background, I think it's better to shift the white-looking parts to the edge of the boxes so that they do not look cut off. Furthermore, I just find the silver parts coming out of the box a bit distracting (doesn't blend well for me personally).   2. The black line in the middle of one of the middle boxes looks pixelated - is it completely straight?   3. For the boxes with RO characters sticking out, I prefer it if the extra parts are cut off. Or, at least move the swordsman down to cover the bottom edge of the outer box, just like the assassin character.   4. The black Facebook and Twitter buttons don't really match the design in my opinion, probably because of the dark colour. Maybe make it brighter to match the brownish colour theme you have going.   5. Really need to see where you will put the logo as well as its design to match the website layout   Keep up the amazing work! Can't wait to see the full version of this design ^^ and good luck!