In import/inter-server.conf
inter_configuration: {
// Log configuration
log: {
// [LOGIN, MAP] Log database SQL connection
sql_connection: {
db_hostname: "127.0.0.1" // Change this to your hostname
db_port: 3306
db_username: "root" // Change this to your mysql username
db_password: "your_password" // Change this to your mysql password
db_database: "db_logs" // Change this to your log db name
}
}
}
In that way your main and log db is separate.
Hello and hi!) I show you the next half-ready project) Now I tried to update
the appearance of the locations around the Prontera, as it were in episode 16.
Bad or not - you decide. This project is the subpart of a larger update of
locations, of which I will report later .
.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.
All models of trees, bushes, and bridges are replaced by new ones from new
episodes. A custom texture is created that differs from the new standard
with a higher brightness and which is more in tune with the old texture.
And everywhere were planted hundreds of all kinds of flowers, which only
could find in the models. Now I can not imagine the field without this small update ¬3¬
Old - standart texture
Test - the texture received in the process of improvement
New - the best result that could be identified among dozens variants of brightness and intencity changing by 1% ^O^
At the moment, half of the Prontera maps are ready, and the combined textures of the locations of Morroc and Prontera are made.
Probably my most ambitious and personal project. I often met on my way
interesting places in the world of RO, to which it was impossible to get.
Then I began to find such places with the help of the BrowEdit program
and make them available for visiting. As the project expanded,
I decided to allow shooting and use skills from the hills on the maps,
where this feature was disabled (or Gravity was too lazy busy),
add plants and trees, create comfortable climbs and so on.
I suggest you watch a promo video that clearly explains my idea.
.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.•°'°•.
At the moment, almost ready the locations of the Schwartzwald and Arunafeltz for the release,
there is a reserve for many other locations. Since the appearance of the video, there have been
some changes, so the final result may be different. Below I attach screenshots from BrowEdit
"before" and "after" and gif files with changes of territories on the finished mini-maps.
Some screenshots of my work:
From the important places are opened: the airport in Veins, the left exit from Einbroch, the northern Einbroch railway station on Ein_Field04, the industrial zone on Ein_Field02, the border post between Ein_Field04 and Ein_Field05, the fortress on the map of Yuno_Field12, the entrance to the tower of Thanatos on Hu_Field01, the arch with a fountain on Ein_Fild09, the bridge in Lhz_Field02, the road from Ra_Fild06 to Ein_Field03 and more.
Mini-maps changes (if any map is missing, it means everything is fine with it):
As usual, I only write advance guides
This guide is a compilation of SQL commands that I have used, or Questions answered on the forum
every single subject here are related to Hercules/Ragnarok Online in some ways, so you won't feel bored reading them XD
Table of Content
1. When to use *escape_sql script command
2. How to build a case-sensitive table
3. Choose a table type, MyISAM or InnoDB ?
3a. How to index a table properly
3b. Why you shouldn't use `char_reg_num_db` table
4. AUTO_INCREMENT
5. How to do IF-ELSE in SQL query ?
5a. How to update multiple rows on different conditions in a single query
6. How to show the current rank of the player
7. INSERT INTO ... SELECT ...
8. Table JOIN vs AS
9. What is the maximum string limit for *query_sql
9a. UNION
This topic is now open to Suggestions, Ideas, Improvements, and Questions ~
I'm sure many of you have some questions since the creation of this topic
You may also post up your tricks if you want to share with us