Sniperwolf Database (Boros)PATCH10222015

Share files with other Dawn of Light users

Moderator: Support Team

Sniperwolf Database (Boros)PATCH10222015

Postby djsniperwolf » Thu Oct 22, 2015 6:20 pm

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.
Attachments
Sniperwolf(BOROS)PATCH10222015.zip
(6.9 MiB) Downloaded 370 times
Thanks,

-Wolf
User avatar
djsniperwolf
Contributor
 
Posts: 64
Joined: Thu Jun 09, 2011 8:14 pm

Re: Sniperwolf Database (Boros)PATCH10222015

Postby saltyteabag » Tue Dec 01, 2015 11:37 am

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!
saltyteabag
DOL Visitor
 
Posts: 6
Joined: Sun Nov 29, 2015 12:50 pm

Re: Sniperwolf Database (Boros)PATCH10222015

Postby Marko » Sat Jan 02, 2016 7:39 pm

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...
User avatar
Marko
DOL Novice
 
Posts: 79
Joined: Mon Jun 09, 2014 8:17 pm
Location: Rural Central Utah (Near Bryce Canyon)

Re: Sniperwolf Database (Boros)PATCH10222015

Postby Marko » Sat Jan 02, 2016 9:11 pm

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!
User avatar
Marko
DOL Novice
 
Posts: 79
Joined: Mon Jun 09, 2014 8:17 pm
Location: Rural Central Utah (Near Bryce Canyon)

Re: Sniperwolf Database (Boros)PATCH10222015

Postby djsniperwolf » Thu Jul 07, 2016 7:59 pm

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.
Thanks,

-Wolf
User avatar
djsniperwolf
Contributor
 
Posts: 64
Joined: Thu Jun 09, 2011 8:14 pm

Re: Sniperwolf Database (Boros)PATCH10222015

Postby chrono888 » Thu Sep 29, 2016 3:55 pm

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.
chrono888
DOL Guest
 
Posts: 2
Joined: Sat Sep 17, 2016 4:18 pm

Re: Sniperwolf Database (Boros)PATCH10222015

Postby Eyebalze » Fri Sep 30, 2016 6:43 am

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!
This is your last chance. After this, there is no turning back.
You take the blue pill—the story ends, you wake up in your bed and believe whatever you want to believe.
You take the red pill—you stay in Wonderland, and I show you how deep the rabbit hole goes.
User avatar
Eyebalze
DOL Apprentice
 
Posts: 46
Joined: Sat Dec 16, 2006 12:40 pm

Re: Sniperwolf Database (Boros)PATCH10222015

Postby LugusSkye » Fri Sep 30, 2016 4:04 pm

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.
User avatar
LugusSkye
DOL Initiate
 
Posts: 20
Joined: Fri Sep 09, 2016 4:05 am

Re: Sniperwolf Database (Boros)PATCH10222015

Postby HunabKu » Sat Oct 01, 2016 7:29 am

I think the problem is the null default values about real.
For example null default value for int instead of 0.
"C'est l'ignorance qui apporte le chaos, pas la connaissance."
Scarlett Johansson dans "Lucy" de Luc Besson
-------------------------------------------------------------------------------
"Ignorance brings chaos, not knowledge."
Scarlett Johansson on "Lucy" by Luc Besson
User avatar
HunabKu
Developer
 
Posts: 1848
Joined: Sat Jun 18, 2011 4:48 am

Re: Sniperwolf Database (Boros)PATCH10222015

Postby LugusSkye » Sat Oct 01, 2016 12:42 pm

For few fields I had to do ifnull (field,0), you are correct.
User avatar
LugusSkye
DOL Initiate
 
Posts: 20
Joined: Fri Sep 09, 2016 4:05 am


Return to User Files

Who is online

Users browsing this forum: No registered users and 1 guest

cron