hey, i sure like most of u guys here running a server, you make alot of changes to your DB from the default datapack, so when it comes to updating u must put all these changes back again to keep the "uniquness" of your server.
The problem im having is that im such a n00b at sql, and at the last update i compared the difference between the new and old DB's and got some genrall output, in a few mins i went thru the data and determines what i needed to add back to the DB after updating and what was just fuber , but i literally had to sit there for 2 hours adding all these changes back manually using phpmyadmin (lol)
so im wondering, how do you guys overcome this problem ? is there a better app/script for comparing the Db's and then applying all my previouse changes back to the new db on mass ?
maybe someone made a nice script specific to the l2 db structure, or maybe there is some existing script or app that could possible do what i need after some config , im hoping the open source nature of this project/forums will also apply to any possible script like that if it exists, in fact a friend of mine is arguing with me that NOONE will give such a thing to me if it exists, as he is being negative and thinks most ppl wouldnt give such a thing as it gives power, and ppl wanna keep that power (or something like that 0.o) but i have more faith , so is anyone gonna prove him wrong ? and at the same time u would be helping out a n00b admin here get his l2 server off the ground and we are still very new, and also you would in a round about kinda way be restoring a small part of my brazilian friends faith in humanity x'D lol
ty for any replies :']
does a script/app exist that can do this ?
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
- Posts: 117
- Joined: Tue Oct 11, 2005 1:41 pm
- Contact:
-
- Posts: 4
- Joined: Thu Aug 04, 2005 6:44 pm
You could easily write your own sql batch script to execute after you update your server.
Something like this for instance:
post-update.sql
I'd just run that in, for instance, SQLYog as a batch script and it would modify my database the way I want. Doesn't take too much of an understanding of MySQL to figure it out either, and I'm sure you can always ask questions here
Just to note, the script above does the following:
Something like this for instance:
post-update.sql
Code: Select all
--
-- Post Update Add-on Script 10/27/05
--
UPDATE merchant_buylists SET price=246400 WHERE item_id=437 AND shop_id=5803;
UPDATE merchant_buylists SET price=246400 WHERE item_id=437 AND shop_id=5805;
insert into armor values
(7683,'rabbit_ear','hair','false','none',15,'wood','none',0,90,0,0,0,100,0,'true'),
(9052,'Wedding_pants','legs','true','light',0,'cloth','s',0,0,0,0,0,0,0,'true'),
(9053,'Wedding_Boots','feet','true','light',0,'cloth','s',0,0,0,0,0,0,0,'true'),
(9054,'Wedding_Chest','chest','true','light',1,'cloth','s',0,0,0,0,0,0,0,'true'),
(9055,'Wedding_gloves','gloves','true','light',0,'cloth','s',0,0,0,0,0,0,0,'true');
Just to note, the script above does the following:
- Modifies the price of the Mithril Tunic sold in the Heine weapon shop to that of the price in Giran, in the 'merchant_buylist' table.
- Adds the C4 Wedding outfits and Rabbit ears to the 'armor' table.
-
- Posts: 117
- Joined: Tue Oct 11, 2005 1:41 pm
- Contact:
-
- Posts: 117
- Joined: Tue Oct 11, 2005 1:41 pm
- Contact: