Page 1 of 1

Its time for a new db i think (please read)

PostPosted: Tue Jan 10, 2017 12:28 am
by PlanarChaosRvrtwo
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

Re: Its time for a new db i think (please read)

PostPosted: Tue Jan 10, 2017 12:30 am
by PlanarChaosRvrtwo
Before you say there are some old_items that is correct but its only fragmentaric

Re: Its time for a new db i think (please read)

PostPosted: Tue Jan 10, 2017 12:35 am
by PlanarChaosRvrtwo
And to make it more interessting to help everyone who helps me get the done / or nearly done db 2 weeks early then rest of dol cummunity. (but to be true i want share with everyone fast as possible its only an idea couse the xped long term dol members maybe need a small profit for their own)