[Release]Project Silvermoon FunDB rev4 [compatible with patch 2.3.0!!]

[latruwski]

The release of our Project Silvermoon Fundb for Ascent, this release is compatible with patch 2.3.0!!! :lol:
Have fun! :lol:
This release is compatible with ascent rev 2364, if you want to use it with a higher rev, check whether there are any sql updates above 2364 and apply them to your database after you've batched this file.
REMEMBER TO CLEAR YOUR CACHE/WDB FOLDER,
TELL OTHERS WHO PLAY ON YOUR SERVER TO DO THE SAME!!
Tables you need to backup to save your characters:

account_data

account_overrides
accounts
arenateams
auctions
banned_names
banned_phrases
characters
charters
corpses
gm_tickets
groups
guild_ranks
guilds
instances
ipbans
mailbox
playercooldownitems
playercooldownsecurity
playeritems
playeritems_external
playerpets
playerpetspells
playersummonspells
questlog
server_settings
social
tutorials

File Name: PS_partyDB_full.rar | File Size: 12.02 MB
Filebeam - Free Fast File Hosting

Features:
- Dance Club (starting area in the Caverns of Time) *Imperium, Laila and Utsjitimmie*
- Skypad (in Zangarmarsh, a place to relax) *Imperium and Laila*
- Turtle Racetrack (around the Dance Club) *Imperium and Laila*
- Dance Floor (in The Stormspire in Netherstorm) *Utsjitimmie*
- PVP Area (at the Arena of Nagrand, spawned vendors, xp-bombs, trainers etc.) *Utsjitimmie*
- Maarten's Magical Obstacle Course (in Tirisfal Glades) *Kunamo*
- Obstacle Course 2: The Cauldron Run (in Wetlands) *Kunamo*
- Snowball Fight Area (at Ironforge Airport) *Utsjitimmie*
- Obstacle Course 3: The Tower *Utsjitimmie and Kunamo*
- The Frozen Throne (at the end of OC3) *Utsjitimmie*
- The Stair of Eternity *Utsjitimmie*
- *Fixed* The Emerald Dream Maze (you can now use .recall port maze to go there) *Utsjitimmie*
- 3 custom vendors who sell party items (party clothes, fireworks, drinks and more) *Imperium*
- 2 special new items, [Project Silvermoon Snowball!] and [Project Silvermoon's Backpack of Endless Space] *Utsjitimmie*
- A lottery *Utsjitimmie*
- A lot of new and old vendors who sell armor and weapons at the PVP Area *Utsjitimmie*
(you'll remember the Tier family that I (Utsjitimmie) originally created on Mangos and spawned on GM-Island)
- I created the item [Frostmourne] *Utsjitimmie*
- Players will now begin at the normal starting areas, there are portals to the dance club at the begin areas *Utsjitimmie*
- I created more custom items as rewards for the obstacle courses *Utsjitimmie*
- Added the flying broom mounts to the <Mount Vendor> at the PVP Area in Nagrand *Utsjitimmie*
Attention! It is not a bug that the normal mage portals and portals in Shattrath do not port you to the main cities,
it's because there is no way to make custom portals without using the official spells.



Sharing this, have fun with it !!!


grtz

[latruwski]

already having a database? just wnt update? here ya go:


The release of our Project Silvermoon Fundatabase that you can apply to your existing database as 1 batch file! :lol:
This release works only with a database compatible with ascent rev 2364 and probably higher, it works only with patch 2.3.0!!!
For instance, you have the NCDB Milestone 0.2.2 database on your server and you have already edited some stuff, you don't want to import an entire new database, cause you'll loose your stuff. That's exactly why I made this sql update file, it contains all of the custom stuff of the Project Silvermoon Fundatabase, just apply it to your existing database and restart your server and you have all of the custom things on your server
Have fun!
This release is compatible with a database that has been updated to the format that fully supports ascent rev 2364. It probably works with other formats too, but if only one of the table structures (excluding the char tables) has changed it probably won't work.
REMEMBER TO CLEAR YOUR CACHE/WDB FOLDER,
TELL OTHERS WHO PLAY ON YOUR SERVER TO DO THE SAME!!

File Name: PS_partydb_update_2.3.0.rar | File Size: 0.28 MB
Filebeam - Free Fast File Hosting

Features:
- Dance Club (starting area in the Caverns of Time) *Imperium, Laila and Utsjitimmie*
- Skypad (in Zangarmarsh, a place to relax) *Imperium and Laila*
- Turtle Racetrack (around the Dance Club) *Imperium and Laila*
- Dance Floor (in The Stormspire in Netherstorm) *Utsjitimmie*
- PVP Area (at the Arena of Nagrand, spawned vendors, xp-bombs, trainers etc.) *Utsjitimmie*
- Maarten's Magical Obstacle Course (in Tirisfal Glades) *Kunamo*
- Obstacle Course 2: The Cauldron Run (in Wetlands) *Kunamo*
- Snowball Fight Area (at Ironforge Airport) *Utsjitimmie*
- Obstacle Course 3: The Tower *Utsjitimmie and Kunamo*
- The Frozen Throne (at the end of OC3) *Utsjitimmie*
- The Stair of Eternity *Utsjitimmie*
- *Fixed* The Emerald Dream Maze (you can now use .recall port maze to go there) *Utsjitimmie*
- 3 custom vendors who sell party items (party clothes, fireworks, drinks and more) *Imperium*
- 2 special new items, [Project Silvermoon Snowball!] and [Project Silvermoon's Backpack of Endless Space] *Utsjitimmie*
- A lottery *Utsjitimmie*
- A lot of new and old vendors who sell armor and weapons at the PVP Area *Utsjitimmie*
(you'll remember the Tier family that I (Utsjitimmie) originally created on Mangos and spawned on GM-Island)
- I created the item [Frostmourne] *Utsjitimmie*
- Players will now begin at the normal starting areas, there are portals to the dance club at the begin areas *Utsjitimmie*
- I created more custom items as rewards for the obstacle courses *Utsjitimmie*
- Added the flying broom mounts to the <Mount Vendor> at the PVP Area in Nagrand *Utsjitimmie*
Attention! It is not a bug that the normal mage portals and portals in Shattrath do not port you to the main cities,
it's because there is no way to make custom portals without using the official spells.



grtz

[Illidan1]

Double post?, lol, very nice though, keep posting stuff

[knaur]

illidan: no it isnt double post.

The first is a full db release
the second is upgrade for existing db,s

[Illidan1]

Ahh, lol sorry, Damn school mac Computers have super Mouse scroll ...

[Ebon]

Very nice, +Rep!

[bluuinator]

k so if i want to use your project and im use HeidiSQL how can i upload it to my other db. just post in ehre and ill read tommorow

[bluuinator]

i get SQL Error Unknown coloum name in field list

[latruwski]

i get SQL Error Unknown coloum name in field list

are u using ncdb 0.2.2 ?

[gravestalker]

very nice +rep. also could you give me the download to the newest rev?

gota spread rep around first hold on

[jonnd]

Ok doesn't work it loads but You Can't login the game you can make a Charater but as soon as u press enter it stop and doesn't do anything....

[HumanAlien]

thanks +rep if i could :/

EDIT:
could any1 please help me? I just got my server up and running a few days ago (after many months of struggle..)..what i want to know is..where in the db do I find the danceclub, the arenas, the lotery etc..so I can copy it into my own server :O ?

[Sajjad12]

I get: Error occured at:2007-11-25 16:21:20
Line no.:10419
Error Code: 1054 - Unknown column 'mapid' in 'field list'

Do I need to update to latest NCDB?

[Wheeze]

Awesome, I'll keep it in mind

[seg_168]

You are so good ... # 1 ... i can't say more ... my happyess can't be sayd in words ... thank you