Buy World Merger Script

U

ubrxks2xp5pvp

Vagabond
Customer
I'm creating a seasonal system on my server, but I need a script to handle the merging between the new world and the old world, which will always remain online.
 
I need a script that will merge the new server into the old server, always keeping the old server’s data as the priority.
 
Deazer

Thread 'Instructions for merging game and login databases'

Database Merge Software: HeidiSQL or DataGrip

Script location: gameserver\sql\maintenance\server_merge.sql

Preparation process:
You must first make a backup of your databases - let's say Serverx2019 and Server2020. For example, we transfer data from the Serverx2019 database (src_db) to the Server2020 database (dst_db)
Create 2 databases - src_db (upload data from Serverx2019) and dst_db (upload data from Server2020)
1. src_db - base from which the data will be transferred to the one you need (Serverx2019)
2. dst_db - base to which you will transfer data (Server2020)...
 
zerohero said:
Deazer

Thread 'Instructions for merging game and login databases'

Database Merge Software: HeidiSQL or DataGrip

Script location: gameserver\sql\maintenance\server_merge.sql

Preparation process:
You must first make a backup of your databases - let's say Serverx2019 and Server2020. For example, we transfer data from the Serverx2019 database (src_db) to the Server2020 database (dst_db)
Create 2 databases - src_db (upload data from Serverx2019) and dst_db (upload data from Server2020)
1. src_db - base from which the data will be transferred to the one you need (Serverx2019)
2. dst_db - base to which you will transfer data (Server2020)...
Click to expand...
I will check and see if I can find a way to adapt it to work the way I need. Thank you for the help
 
fa1thDEV said:
he sai two servers in one

old + new, without lost the old server data (players, items, etc etc)

the problem is the players is, I think need rename the old players like "player_OLD"
Click to expand...
the script as it is, according to my knowledge, is completely wrong, many problems for players and admins
 
fa1thDEV said:
he sai two servers in one

old + new, without lost the old server data (players, items, etc etc)

the problem is the players is, I think need rename the old players like "player_OLD"
Click to expand...
Exactly — it will be two servers, both using the same login. When a new season opens, after some time the new server will be merged into the old server, always giving priority for names to be kept to the old server.
zerohero said:
the script as it is, according to my knowledge, is completely wrong, many problems for players and admins
Click to expand...
I can’t really tell you if the original script that comes in the package is working perfectly, but it should be, since Deazer wouldn’t include something that isn’t functional. I made some modifications to it and I'm testing, but I'm still not sure if it will work the way I did it.
 
it works like a script without any problem but for me the way it does the merge is wrong and creates problems after the merge with account and characters and this is because they are made into different accounts
 
zerohero said:
it works like a script without any problem but for me the way it does the merge is wrong and creates problems after the merge with account and characters and this is because they are made into different accounts
Click to expand...
I tried to solve this, but I'm currently running some tests. Apparently, I managed to do it, but I need to test it on a larger database.
 
zerohero said:
have you managed to have the script be from the main one or are you characters in the same account?
Click to expand...
The character will migrate to the account, and if it has the same name, it will be renamed, and an item will be added to the inventory for the name change. Since both the old and new servers use the same login and password, it's impossible to migrate the character to another owner's account :)
 
ubrxks2xp5pvp said:
The character will migrate to the account, and if it has the same name, it will be renamed, and an item will be added to the inventory for the name change. Since both the old and new servers use the same login and password, it's impossible to migrate the character to another owner's account :)
Click to expand...
yes, that's exactly what I'm saying, my friend, this is the most correct merge
 
You must log in or register to reply here.
Back
Top