Its time for a new db i think (please read)
PostPosted: Tue Jan 10, 2017 12:28 am
Im on my way doing an own server but by that i had to combine 7 databases so i want offer an idea:
If you have any working systems like realm specific housing.
A script that allows merchants to sell items for an diffrent price then item price so you can do dragonscale merchant without more then one itemtemplateid
and such things share it with me i combine all the great dbs many dol members did over time and repack it to an new db that everyone can use from now to push dol further.
(changes that fit my server targets are done to db after i released it)
(The following idea is more for the far future (like at end of the current year or such)
And by that im planning to do a mix db that sound bad on first but hear first the idea:
After the livelike db is on good state i wanna clone the items and set the stats to classic and save both into same DB and share an SQL script that cant create issues and work on base of following things:
old_name_of_item
name_of_item
Now you ether run a script to remove/rename templateid old or without old
If you have any working systems like realm specific housing.
A script that allows merchants to sell items for an diffrent price then item price so you can do dragonscale merchant without more then one itemtemplateid
and such things share it with me i combine all the great dbs many dol members did over time and repack it to an new db that everyone can use from now to push dol further.
(changes that fit my server targets are done to db after i released it)
(The following idea is more for the far future (like at end of the current year or such)
And by that im planning to do a mix db that sound bad on first but hear first the idea:
After the livelike db is on good state i wanna clone the items and set the stats to classic and save both into same DB and share an SQL script that cant create issues and work on base of following things:
old_name_of_item
name_of_item
Now you ether run a script to remove/rename templateid old or without old