Terranet & Silvermoon DB Rev 6

Hello everybody,
Long expected TerraNet - ProjectSilvermoon DataBase Revision 6 is finally out.We bring you a great deal of new fixes, spawns, new added items, and overall blizzlike content.Thanx to all the supportive comunities.Thanx to TerraNet for hosting, also ProjectSilvermoon for hosting and supporting the DB.Thanx to all PPL who posted fixes here.Thanx to all PPL who use the DB and enjoying thier servers without serious flaws in DB.Enjoy in this new revision as you did with all of them.

This Revision is brought to you by the Development Team which consists of:

• Lemon - Project Leader
• Utsjitimmie - Project Leader
• Onemore - Project Sub-Leader
• Teto18 - Trainers Master
• Channel_49 - Items Master
• Devincean - Items and everything else
• Evilgb - Spawning
• Volition - Whining and Taking Care of everything
• Vertazzar - Creature Stats

Also we want to thanx to: CasaCorpus Team, skidac, felenna, Volvo132, sorcermerlin

IMPORTANT: This DataBase will be published only by TerraNet and Project Silvermoon, and no one else has no right to publish its modified version.It can only be published in repacks without any changes made, which means in the state that it has been published, without any updates or fixes included, since TerraNet and Project Silvermoon hold the right on this DB and only those comunities can release revisions of the same.
Resinate blow us

COMPATIBLE WITH ANTRIX REV 575

IMPORT ONLY WITH SQyog OR PS BACKUPER-IMPORTER

Please pay attention to README, you also have it in your downloaded folder.

README:
This database edition, just like the rev5 doesn`t contain character related tables, nor you need to backup them and reimport.All you have to do is just import this DataBase on your existing one.

It has been dumped so it has "Drop SQL query" in front of every insert or create query, so it will just replace the data you had in rev4 with this new data in rev6 without any modifications to your character or account related tables.

Srry for not releasing it in Changesets, but there is a lot of things we fix ingame, so its impossible to get all of that in SQL.

IMPORTANT: Instruct your players to delete their Cashe folder before entering the game, to avoid possible tickets http://projectsilvermoon.net/style_e...lt/biggrin.gif

Just in case someone is using this DB for the first time, I included character related tables too.

WARNING: DataBase structure is compatible with the latest revision of Antrix Core


LINKS

RapidShare: 1-Click Webhosting
CHANGELOG

• Fixed half of the trainers, few more left to go - thanx Teto
• Spawned more vines in the world - thanx Volvo132
• Fixing some wrong spawns, and creature IDs
• Spawned Old Hyjal - Thanx to Tim
• Spawned Gruuls Lair - some bosses needed, but missing due to being scripted
• Fixed profession trainers - thanx Onemore, possible unclickable trainers, please report if you find
• Fixed great deal of displayIDs - few more left
• Well I think the loot problem has been eliminated now, no more double loots and still working on improving the percentchances to fit the blizzlike standards.(blizzlike loots in Black Temple, Karazhan, The Eye, Serpent (only bosses) - thanx for the tool to skidac
• Added Complete Merciless Gladiator PVP Sets - thanx Devincean
• Added Missing Merciless Gladiator Weapons - Channel
• Added Other Missing Weapons from Hyjal - Channel
• Added a ton of missing items - thanx Channel
• Fixed all auction houses, and linked them together.All Ally AHs are linked and all Horde also, Gadzetzan is linked with bootybay
• Added proffesion recepies - thanx sorcermerlin
• Removed all those unclickable creatures, that I managed to find, report if you find some new please
• Fixed a lot of quest Reputation Rewards - thanx CasaCorpus Team and felenna
• Spawned Magtheridon`s Lair - not fully blizzlike*
• Started adding spells to bosses in various instances - only first steps
• Fixed all reported errors with trainers - PLEASE NOTE "REPORTED" which means there could be some more flaws with trainers-PLEASE REPORT THEM AND I WILL FIX
• Black Temple spawned(not fully) - Spawning Tim, Loots Lemon, Stats Vertazzar
• Slave Pens spawned - Thanx Evilgb

I take no credit for this, all made by Terranet Project Team and Project Silvermoon

Greetz

DarkWolve

so i need just to drop my antrix databse and put this one on its place right?

no, do this db as a new one and then copy it into the old one

Why when I allways try a new database i allways have -1stats on my items -.-*

Everything seems to be fine, but so far with Antrix 575 and the new database i have found that Blood elves paladins can't have auras and power activated at the same time.

is this in the database or is it in antrix?

if lemons wants to, he can pm me here on a super fix. me and a buddy in AP forums have discovered how to make dbs run on the littlest memory and fastest with very low bandwidth with our dbs. it greatly reduces the lag and even makes servers stay up longer. if he wants this small fix have him pm me. idc if u hate me. but i know everyone out here wants it.

i noticed when lookign at this.
400 spells were removed.
only 30 new items
creature table looks the same as rev 4 and 5.
this is the real rev 6 right. i know lemon does better releases.

Hey Guys. Iam getting this error after i restored the Rev 6 onto my rev5. Does it have anything to do with my core version..? it just keeps going like that until i kill it. if i open up my Antrix.conf it says Last updated at revision 236 and if it is the wrong core, which one should i use and can i restore on that after all the mess i got..? or is it someting else wrong here.? My server was running fine before with rev 5:scratch:

germo

\Documents and Settings\Syntyche\Desktop\mangos\antix\Antrix\src\game\QuestMgr.c
pp:1063 ASSERTION FAILED:
i == pResult->GetFieldCount()
Map 369: 22 creatures / 45 gameobjects loaded.
Map 449: 10 creatures / 20 gameobjects loaded.
Map 450: 13 creatures / 0 gameobjects loaded.
Map 1: 25518 creatures / 10637 gameobjects loaded.
Map 0: 22628 creatures / 12626 gameobjects loaded.
Map 530: 28000 creatures / 8563 gameobjects loaded.
antrix.exe!Singleton<DataStore<ItemExtendedCostEntry> >::Singleton<DataStore<
ItemExtendedCostEntry> > Line 0
antrix.exe!QuestMgr::LoadSQLQuests Line 0
antrix.exe!Singleton<ChannelMgr>::getSingletonPtr Line 0
antrix.exe!World::GetStats Line 0
antrix.exe!World::DeleteObject Line 0
MSVCR71.dll!endthreadex Line 0
kernel32.dll!GetModuleFileNameA Line 0

its the db from his project.

look under Project Silvermoon Official Community Forums (Powered by Invision Power Board)

its there official realest of their db.

So can i just import it into a new DB then copy my accounts and stuff to it?

just copy this db over your installed and used db.

Could anyone read my post further up and please tell me what is wrong with my update from rev 5 to rev 6 i imported like i did on rev 4 to 5 and that worked but htis time big crash

Germo

does this db have flying mounts?

Ok thanx :D

Hey guys. After searching around trying some stuff, iam ending up with this error
I started with DB rev 4 updated with rev 5 all was fine, then i updated with this rev 6 today, and ended up with logonserver was starting fine then when i clicked Antrix.exe i got a bunc of errors, then i was trying deffrent things and now i only got this error, but still no server running here it is >>> could some see what is wrong..!! is it my DB that needs a newer version or what..? please fill me in here. :scratch:

==============================================================================
Antrix/Win32-2.1.2-575 :: World Server Emupedia.com - Term of use
Copyright (c) 2007 Antrix Team. This software is under the QPL license, for
more information look under the COPYING file in this distribution.
==============================================================================
The key combination <Ctrl-C> will safely shut down the server at any time.
Initializing File Loggers...
Initializing Random Number Generators...
Starting Thread Manager...
Loading Config Files...
>> antrix.conf :: ok!
>> realms.conf :: ok!
sql: One or more parameters were missing from Database directive.
Startup failed for some reason. Please review the error messages above and hit a
ny key to exit.
vbmenu_register("postmenu_2382228", true);

Hmm I cant seem to find Merciless Gladiator stuff. Tho the black temple spawns are nice :D.

Germo, get the terranet db 5 complete ready from atilla

Why was Peep the Phoenix removed? :(

The DB wont accept any accounts other than the ones that were on befor i put Terranet DB 6 on. So when i try to use an account that i added after Terranet DB 6 it just says invalid password.

EDIT: Nvm I fixed it. I just changed to antrix rev 558 and everything is running perfectly :D.

Quote:

---

Originally Posted by resinate

if lemons wants to, he can pm me here on a super fix. me and a buddy in AP forums have discovered how to make dbs run on the littlest memory and fastest with very low bandwidth with our dbs. it greatly reduces the lag and even makes servers stay up longer. if he wants this small fix have him pm me. idc if u hate me. but i know everyone out here wants it.

i noticed when lookign at this.
400 spells were removed.
only 30 new items
creature table looks the same as rev 4 and 5.
this is the real rev 6 right. i know lemon does better releases.

---

Bleh you didn't discover jack, I did all the work :P
What he is talking about is merely converting your DB to another storage engine, not really a `super fix` ;)
We tried it to the antrixprojectdatabase and it increased things in some ways, but being as antrix doesn't really take that much load on database different storage engines arn't really needed.

BUt if terranet really wants a fix here's a good SQL query to run
DROP DATABASE stolenpieceofshit;

I upgraded from terra 5 to terra 6 and used antrix rev584. Antrix and logon works fine but problem is player can't buy items from npc (cant find sell templete or something). Can someone help me if this is client, core, or db problem?

It's not stolen DB. (Why? take a look here. 1 proof).
It's best DB you can find atm.
- Most corrected one.
- Most "Fast Updated" one.
- And cleanest one.

Have a good day,
oh and if you something better, put it in your ass.

that doesn't prove anything lol, that's just terranets mangos looking site TBH I highly doubt we'd all ban Lemon from every community site (cept this one and PS) because he didn't steal data from M4F DB and others and refuse to give credit but then he wants people to give him credit when they rip shit from his DB LOL!

But I wouldn't expect you to actually check shit out before you opened your mouth on whats what <3

y the size of file sooooooo small anyways if i use it without already having terrav4 or terrav5 will it work good ???

i dont think so. i updatet the db since terranet db 3 and it works fine withe me. i would do the same i i where u.

And tiers? how can i make it?
before i used another db, their id's were 3200X
Now i get terranet 6 and there isn't tiers at id 3200X.
Are they in the db? where can i find them?
thx