Dawn of Light

Emergency patch for Sniperwolf Boros Release ONLY. Be sure to run this after you have ran the Sniperwolf DB.

This patch fixes many of the broken NPC's, Trainers, Merchants, etc. But was not included in the release.

This will DROP all mob and npctemplate tables and replace them with the updated tables.

*Make sure your DOL Sniperwolf Database is selected before executing.

This will be committed into the next version.

Installation is much easier if you use an SQL browser or a Database management software of some kind, any will do, though I prefer HeidiSQL.

Initially posted this on a different thread, but this seemed to be a more appropriate place. I think HeidiSQL should be more than just a recommendation. I spent 2 days trying to get this working only to figure out that the MySQL command line was ignoring the DROP TABLE statements in the patch files. Lord only knows what else it was doing wrong. Also, the MySQL "Workbench" just hangs when trying to open the bigger files. Once I finally installed HeidiSQL, everything worked perfectly!

Thanks for all the good work, Sniperwolf!

So if I want to pull existing accounts/characters and custom NPCs/Mobs over to this db, can't I just use an INSERT IGNORE from my old db into this one? I'm thinking the required tables to bring in would be:

account
dolcharacters
guild
guildalliance
guildrank
inventory
mob
npcequipment
npctemplate

Did I miss anything? Esp. character/guild stuff. I really don't want to lose my custom NPCs, Horse Routes, Teleporters, etc. But losing character/player info would be really bad...

Hmm, after experimenting a bit, it looks like it will be easier if I export stuff from your db into mine. Too many things break when I go the other way (my db into yours...) Awesome work though! Much, much appreciated!

Ok all, here it is as promised.

https://github.com/djsniperwolf/SWDB.git/

Any contributions will be of great help, things are looking up as the database approaches a more classic feel.

Ok i know this is a rather old thread, not sure if sniperwolf is still around but I have been using your DB's over the last week for a private server for my friends and I. I really love it! thanks so much! was just curious if this recent post you have here is more upto date than the files on the user files...as well is there a way to add these new files without overwriting characters or files people have made on my server? I'm very new to this. Thanks for all the insight.

hi chrono88,

unfortunately, this database is not working combined with the actual DOL SVN 1.9.7.3593 from GitHub.
If you found a way to get that thing running, give us a sign!

thanks,

Eyebalze!

just to give you an idea how to go around "non-compatible" database issue that will work most of the time:
1. identify tables that contain data that you want to be used on your server. do not just take whole db script and overwrite yours. it won't work this way as previous poster mentioned.
2. once you know the tables, create a DDL create table script. if you are using workbench just right click on table and pick ddl create script option.
3. use that ddl script by selecting columns by name to insert into your existing DB from sniperwolf table. this way records will be copied/inserted w/out looking at order of columns. some adjustments will have to made possibly. make sure you know the key in the table and do not insert duplicates or just delete insert based on a key.

it's not an easy task for non-sql developer but its very doable. good thing is most of the tables had not been changed so only the few that were need to be adapted. in terms of not loosing your characters, do the steps above. instead of using sniperwolf db, use your existing and adopt sniper to yours. good luck and let me know if you need specific scripts i might be able to help with.

I think the problem is the null default values about real.
For example null default value for int instead of 0.

For few fields I had to do ifnull (field,0), you are correct.