Page 1 of 1

Sniperwolf Database (Boros 10222015)

PostPosted: Thu Oct 22, 2015 8:11 am
by djsniperwolf
Further DB Updates are available here
https://github.com/djsniperwolf/SWDB.git/


Table of Contents
---
I. Information
II. Updates.
III. Basic Install information.


I. Information
---
Hey everyone, here is a a quick-release/snapshot of my current DB that will be released publicly. I know it has taken me
a while to get this out, but it is finally ready... Well, ready enough to be playable. I ask only of two things from you!

a. Report bugs! Please do this on the link provided below... I can't make improvements without user input.

b. If you like my DB, and use it in any way, shape, or form. Please give credit where credit is due.. This is alot
of work and I do it without financial gain. Thanks.

Much has changed since the original Sniperwolf Repack release. Below will highlight some of these major changes
and what is to come. Please note that this DB is a complete re-write and will not be compatible with your DB in it's current
form and may require major changes. This DB is compiled on SQL version 5.6.17 running on SVN version 3561 and is
the most up to date as of 10/22/2015.



II. Updates.
---
--Boros--
1. Mobs casting spells in certain dungeons
2. Mithra Tomb is now 100% functional.
3. Battleground is currently WIP, this will be fixed ASAP.
4. Item errors have been fixed
5. Quests are finally being implemented.
6. Djinn code modified and improved.
7. Artifacts DB complete, Linking has begun and will be tested.
8. Many, Many Spawn additions.
9.. Huge housing improvements, check them out!
10. Pathing has been modified, and many paths have been added.
11. Sauvage taxi point is having some issues, I will have this fixed by next roll out.

--Athena--
1. Cotswold Stable master is working 100%.
2. Pathing has been added throughout Camelot, Mithra, Avalon, Atlantis, Darkness Falls.
3. All keeps are in correct locations, waiting on further bug report feedback.
4. Consigment merchant now places correctly.
5. Market Explorer is working 100%
6. All housing objects placed on walls show up at proper size.
7. Merchants placed inside of houses will now display inventory.
8. Mob brains updated
9. Heal chants reconfigured with proper text.
10. Major DB cleanups.
11. Mobs for Atlantis have been spawned for all 3 realms!! (14k Mobs for albion) (10k Mobs for Hib and Mid)
12. Atlantean spawns for all 3 realms.
13. Djinn spawned in all 3 realms and works 100%.
14. Teleporter will now send you to Oceanus.



III. Basic install information
---
1. You will need a functioning version of Dawn of Light, as well as an SQL Server software of your choice. Information on this can be found on the net regarding the installation and configuration of a SQL server.

2. 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. It's free, and is downright fantastic to manage your database with.

3. Be sure to extract the SQL file into a clean and new DB on your server, things tend to get messy when things are copied in this manner.

4. Copy the scripts folder to your DOL Folder, or copy the sniperwolf folder into your scripts folder located in your DOL server Folder.

5. Configure your server using the Dawn of Light Configuration Service.

6. Start your server.

7. Play!

8. Any bug reports or requests can be directed here --> http://www.dolserver.net/viewtopic.php?f=70&t=19318 be sure to include the Version and revision information which can be found in the Dawn of Light Configuration Service.

9. Remember, this DB is a work in progress and will be updated continually!!

10. Please note that this DB is not currently compatible with any other DB's. Any attempt to merge, combine, or move data will result in errors or most likely data loss to your DB.

Thanks!

Sniperwolf

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Thu Oct 22, 2015 9:14 am
by HunabKu
Nice, thanks a lot man :wink:

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Thu Oct 22, 2015 6:26 pm
by djsniperwolf
Anytime. I am enjoying your Linux write-up at the moment, very tempting to try it out.

I saw the issues people were having with some of my less than perfect work. So, here is a long needed release to take care of some of the big issues people were having. I hope everyone enjoys it, more to come!

Oh, be sure to download the file at viewtopic.php?f=63&t=22725 to fix some things I forgot to include in the Boros Release, don't miss that one!

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Sun Nov 15, 2015 5:00 pm
by shanegru
athena will load up in hedisql.. cant get boros to load.. says no database selected.... i use heidisql 9.3 and autodetect mode..
any advice? im stuck on athena atm

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Mon Nov 16, 2015 6:43 am
by HunabKu
You need to create a database, for example named ATHENA, select it with a left clic, CTRL+O for open file.

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Fri Nov 20, 2015 3:50 am
by djsniperwolf
Updates!

1. Update to the DB coming soon, major fixes.

2. DB Repo is almost done, in hopes that I will crowd the forum less :)
a. files will be seperate, making it easier to update your DB withough having to do a clean install with every update.

3. Opening 10-15 slots for anyone willing to play on my server/db and help report with bugs.

Thanks.

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Fri Nov 20, 2015 5:15 am
by HunabKu
Good news Wolf ;)

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Fri Nov 20, 2015 8:51 am
by shanegru63624
hi guys...

hey sniper just wanted to say good db..
ill be testing this out..
was wondering if you could add the old keep system.. or maybe make a sql to add them for the classic users
im trying to get them working.. but i cant find the old frontiers keep id's
if i get them working.. ill post them here.... the main problem i got is
making the keeps showup on /rw
they are set for new frontiers...
my goal is to make boros database setup for classic.. and offer them to dolserver..
thanks again for your work..

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Wed Nov 25, 2015 4:47 am
by djsniperwolf
Thank you, I am glad you are enjoying the DB.

I will be implementing both old/new keeps in a future release, this was placed on hold as there were more important matters to be fixed.

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Wed Dec 02, 2015 1:39 am
by shanegru63624
hey sniper just been testing and heres what i got..
1...menty cant charm.. the fix is spellid's 4212-4216 set amnesiachance to 0 and they can charm
2 for assasin's perf artery and backstab works but man damage very low..like max 80 damage.. i did set in serverproperty.cs i set the cs effectiveness to 10.. and not changing...same exact damage..plz make this one a priority
3 no tireless in the regular trainer RA's
4 for song classes.. everything works but.. not bard heal song.... also all 3 classes icons are set wrong...except skald is correct. they are functioning.. except for bard heal song . its not in your skills to cast it
5 for trainer RA's they are correct.. but when you click on them.. to read what they do.. it shows like the one above the one you clicked on.. but if you slide the skill over.. its correct.. you get what you pick.. thats good
6 crafting works.. have tested most of them but alchemy does not work.. not sure if its the genesis patch im using stopping it from working.. does your alchemy have barrels? if so that might be why it dont work my server. ok a player can make alchemy stuff..definately a patch problem... hmm how to remove genesis patch erm

btw sniper.. if you got a update ill pretest it on my server for you
im working on /rw got the keeps to showup on it.. they set for NF keeps...i got some to remove and cleanup.way too many same keeps listed :).if you want my keep.cs after im finished let me know.. well after i fix it fully
if you get bored come check out hellstemple server

if you find out what the CS damage fix is plz let me know.. this is a big deal
cant wait for your update :) hope this info helps you..

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Thu Jul 07, 2016 8:01 pm
by djsniperwolf
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.

Re: Sniperwolf Database (Boros 10222015)

PostPosted: Thu Jul 14, 2016 2:49 pm
by Graveen
/worship you guys ! There are OW related stuff on theses forums, perhaps interesting to include :)